Consolidate and reconcile without the spreadsheet.
Each entity keeps its own QuickBooks company. Your assistant reads them side by side, matches intercompany balances and drafts the entries on both sides, with each entity’s team limited to its own books.
Here are consolidated results for September, but one intercompany pair doesn’t match, see note below.
Four jobs that span companies.
Multi-company access removes the exports and switching. Ledger detail supports the mappings, corrections and explanations.
Consolidated monthly package
Refresh the group P&L and balance sheet, map each company to your reporting accounts, apply your eliminations and explain the largest movements.
Reconciliation with paired corrections
Match receivables to payables across companies, explain each difference, and draft the correction in each company.
Shared-cost allocations and recharges
Allocate shared software, insurance and finance costs by your drivers, prepare the entries in each company and tie back to the original costs.
Group cash and funding review
See which entity may fall below its minimum cash in the next 30 days, with the collections, bills and assumptions behind each funding need.
You set the rules. Your assistant does the legwork.
Adding up company totals isn’t consolidation. Ototo works from the rules you give it.
You provide
- Ownership and reporting currency
- FX rates and your FX policy
- Account mapping and elimination rules
- Allocation drivers, such as headcount or usage
Your assistant does
- Pulls each company’s reports and ledger detail
- Applies your mapping and rates
- Traces movements to the originating company and transactions
- Drafts entries in each company, posted only after approval
Each entity’s team sees its own books.
The UK finance team works in the UK company only. The group controller sees every entity. Each company’s policy can turn writes or deletes off for everyone.
| User | Northwind US | Northwind UK | Northwind Canada |
|---|---|---|---|
| Group controller | Full access | Full access | Full access |
| UK finance team | No access | Bookkeeper | No access |
| Canada finance team | No access | No access | Bookkeeper |
| Auditor | Read only | Read only | Read only |
Questions group finance asks first.
“Combined balance sheet for all four entities at September 30, at the rates I give you.”
“Which intercompany balances don’t net to zero, and by how much?”
“Allocate Q3 insurance across entities by revenue and show the entries.”
“Which entity drove the change in consolidated gross margin this quarter?”
“Roll forward intercompany loans and flag balances that haven’t moved in 90 days.”
“What does each entity owe the US parent at month end?”
Start with last month’s variances.
Connect QuickBooks, add Ototo to your assistant and ask it to explain last month’s biggest variances. It’s read-only, so nothing in your books changes. 7-day free trial, no card needed.