1
Ask Ari for the group report
Build a P&L Page by entity, with a group total for each month.The group total adds up the entities. For a balance sheet and cash flow statement too, see Get your P&L, balance sheet, and cash flow statement.
2
Check that the entities share Dimensions
Every row of a QuickBooks Online or Xero company’s statements carries Entity, the company’s name, and Currency. When another company from the same accounting system loads for the first time, its Entity and Currency columns join the Dimensions the first company created. One Entity Dimension then lists every company. Rillet’s statements carry one set of rows for each subsidiary, with Entity naming the subsidiary. NetSuite’s statements have no Entity or Currency column: the NetSuite Income Statement names each row’s subsidiary in Subsidiary and its currency in Currency Name.Companies in different accounting systems, such as one in QuickBooks Online and one in Xero, get separate Dimensions. So do two companies with the same name. To combine two compatible Dimensions, ask Ari:
Combine the Entity Dimensions from QuickBooks Online and Xero into one.For how Dimensions are shared and combined, see Dimension mappings and shared Dimensions.
3
Check that every entity's accounts map into one structure
Each company has its own chart of accounts, so each company’s accounts must map into the same reporting lines. If they do not, ask Ari:
Map both companies’ accounts into one set of P&L lines: Revenue, COGS, Payroll, Software, Rent, and Other. Where the same account number means different things in the two companies, map by company and account together.See Map one Dimension’s items to another.
4
Convert currencies, if your entities use more than one
cfo.ai does not convert currencies on its own. Amounts load in the currency the source reports them in, so a total across companies that report in different currencies adds unlike numbers. Ask Ari to convert to your reporting currency at a rate you choose:
Convert the UK company’s results from GBP to USD at 1.27, and show the group total in USD.Ari keeps the rate as an assumption you can change.
5
Remove intercompany transactions
Adding entities up does not remove the transactions between them. When the US company charges the UK company a management fee, the fee is revenue in one and expense in the other, and both stay in a simple sum. cfo.ai does not eliminate them on its own. Rillet removes them only in its own consolidated reports, so adding Rillet’s subsidiaries up does not match Rillet’s consolidated numbers.Ask Ari to add the eliminations as their own lines:
Add an eliminations line that removes the management fee between the US and UK companies from the group total.