A consolidated board pack from QuickBooks Online
Updated
A board pack for a group of companies is the combined profit and loss, balance sheet and cash flow for the period, with the money between your own companies taken out, and a summary page in front. QuickBooks Online reports one company at a time, so the combining is the work. Here is what the pack needs and how to make it in a few minutes instead of a spreadsheet afternoon.
What the board needs to see
- A summary first. Revenue, net profit, cash at the end of the period and total assets for the group, after eliminations. Most board members read this page and the notes and little else.
- The three statements, by company. Profit and loss, balance sheet and cash flow with a column per company, an Eliminations column and the consolidated total, so anyone can see which company drove a number.
- The trend, for longer periods. For a quarter or year to date, profit and loss month by month shows whether things are improving.
- Things to know about the numbers. A pair that didn't cancel out, a month cut short, cash that doesn't tie to the bank. Saying so up front is better than being asked.
The steps
Connect every company
Each QuickBooks Online company in the group, so the pack covers all of them. A board pack missing one company is worse than none.
Take out the intercompany amounts
Pair the accounts that record money moving between your own companies, such as fees, rent, loans and investments, so both sides drop out of the totals.
Run the month-end checks
Pairs that cancel out, a balance sheet that balances, and closing cash that agrees with the bank. Fix what they find before the board sees it.
Pick the period
Usually the last complete month, or the quarter or year to date. A month still in progress shows half a month.
Make the pack and add your notes
One PDF: a cover, a summary page, then the profit and loss, balance sheet and cash flow by company. Write a few lines on what changed; that's the part the board reads first.
The intercompany eliminations guide covers which accounts to pair, and the consolidated cash flow guide covers the bank check.
In SigmaClose
The Report pack page makes the whole pack as one PDF: a cover with your logo and the companies included, a summary page, then the three statements by company, for a month, quarter, year to date, full year or the last 12 months. It defaults to the last complete month. Excel, CSV and PDF of each statement are on the Reports page if the board wants the figures to work with.
Your AI assistant can do it too. With SigmaClose connected to Claude or ChatGPT, ask "give me October's report pack for the board" and it hands over a download link to the same PDF, with a short summary beside it. The QuickBooks MCP guide explains connecting it. You can see a sample pack for a made-up group in the demo, with no account.
It's $20 a month or $200 a year per group for any number of companies, and free to try, with 5 refreshes per QuickBooks company and no card. Other tools that make consolidated reports are compared, with prices, in consolidation tools compared.
Questions
What goes in a board pack for a group of companies?
The consolidated profit and loss, balance sheet and cash flow for the period, with a column per company and the money between your own companies taken out. A short summary page goes in front: revenue, net profit, cash at the end and total assets, plus anything the board should know about the numbers. Commentary on what changed is the part only you can write.
Can QuickBooks Online make a consolidated board pack?
Not on its own. QuickBooks Online's reports cover one company at a time, so a group either builds the combined statements in a spreadsheet each month, moves to Intuit Enterprise Suite, or uses a consolidation tool that reads every company and combines them.
How do I stop intercompany amounts inflating the board's numbers?
Pair the accounts that record the same money from opposite sides, such as a management fee charged by one company and paid by another, and remove both sides in full. If the two sides don't agree in a month, show the difference on its own line rather than hide it. The intercompany eliminations guide covers the common pairs.
Can my AI assistant send me the board pack?
Yes, with SigmaClose connected to Claude or ChatGPT. Ask for the report pack for a month, and the assistant hands over a download link to the PDF SigmaClose makes, with a one-line summary. The link works for 10 minutes.
Does the board pack carry our own branding?
Yes. SigmaClose reads your logo and main color from your website, and the pack's cover and headings use them. Without them, it uses a plain black and yellow look.