For multi-entity companies

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.

What was consolidated revenue and operating income? Get rates from OFX.com.

Here are consolidated results for September, but one intercompany pair doesn’t match, see note below.

Entity (USD)RevenueIncome
Northwind US$1,200,000$182,000
Northwind UK$415,400$54,940
Northwind Canada$399,600$45,880
Consolidated$2,015,000$282,820
US shows intercompany revenue of $48,000; but the matching invoice appears in the UK as £48,000. Should I correct the UK entry?
Group finance

Four jobs that span companies.

Multi-company access removes the exports and switching. Ledger detail supports the mappings, corrections and explanations.

Reporting

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.

Try asking“Refresh the group P&L for September and explain the three largest consolidated movements.”
Intercompany

Reconciliation with paired corrections

Match receivables to payables across companies, explain each difference, and draft the correction in each company.

Try asking“Match every intercompany balance across our four entities and draft the corrections.”
Allocations

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.

Try asking“Allocate September’s shared IT costs across our three entities by headcount and draft the recharges.”
Cash

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.

Try asking“Which entities may fall below $250,000 in cash in the next 30 days?”
What you supply

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
Per-entity permissions

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.

UserNorthwind USNorthwind UKNorthwind Canada
Group controllerFull accessFull accessFull access
UK finance teamNo accessBookkeeperNo access
Canada finance teamNo accessNo accessBookkeeper
AuditorRead onlyRead onlyRead only
Sample questions

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.