One report for a group of companies
If you keep the books for several companies, Blink pulls a trial balance, profit and loss or balance sheet for all of them at once, with one column per company. Refresh All then updates every report tab in the workbook.
Setting up a group
- In Blink, open Xero or QuickBooks, then Orgs. Connect each company first.
- In the Groups card, tick two or more companies and click Create group.
- Give the group a name and click Save.
- Click Select on the group. Reports now run for the group until you click Use one entity.
A group is saved for everyone on your Blink account. It holds Xero companies or QuickBooks Online companies, not a mix of the two.
Pulling a group report
With the group selected, go to Reports and pull the trial balance, profit and loss or balance sheet as usual. The tab is named for the group, for example “Northwind Group TB”.
The report has the account name and code, one column per company, and a Total column. The first row shows each company’s currency.
An account lines up across companies when its code, name and section all match. Where they differ, the account gets a row of its own, so a common chart of accounts gives the cleanest report.
What it does not do
- It is not a consolidation. There are no intercompany eliminations. The Total column is a straight sum of the companies.
- It does not translate currencies. If the companies report in different currencies, the Total is labelled “Mixed — not translated”.
- Only these three reports run for a group. Aging and transaction lists are pulled one company at a time.
Do eliminations and translation in your own columns on a separate tab, reading from the group tab.
If one company in the group cannot be pulled, the whole report stops and Blink names the company. Reconnect it on the Orgs tab and pull again.
Refresh All
Every tab Blink pulls keeps its own company or group and its own dates. Refresh All on the Reports tab pulls them all again, one at a time, and finishes with a count for each company of what refreshed and what failed. You can stop it part way.
So a month-end workbook with a group trial balance, a profit and loss for each company and the aging for each is brought up to date with one click, not one export per report per company.
For the next month, use Roll forward on each tab to move its dates on one period. A workbook with both Xero and QuickBooks Online tabs needs Refresh All run once under each.
Questions
Do I need a group to keep several companies in one workbook?
No. Each tab remembers the company it was pulled for, so you can pull one company after another into the same workbook and Refresh All covers them all. A group is for putting companies side by side in one report.
Is there a limit on companies in a group?
A group needs at least two. We have not set an upper limit.
Why are Journal and Reconcile greyed out?
They work on one company at a time. Click Use one entity on the Orgs tab and they come back.
Get started with Blink
Add Blink to Excel yourself, or send us the workbook and we’ll set it up with you.
