Consolidated Reports

Generate financial reports across multiple companies.

Enterprise Feature: Consolidated Reports require True Enterprise or Accountant Enterprise subscription. Available in the free trial.

Overview

Consolidated Reports allow you to aggregate and compare financial data across multiple companies in your BizBooks Pro installation. Perfect for:

Multi-business owners viewing total performance
Holding companies consolidating subsidiaries
Accountants comparing client metrics
Franchise owners analyzing locations

Accessing Consolidated Reports

Navigate to Reports in the main menu
Click the Consolidated button (purple gradient)
Select at least 2 companies from the checkbox list
Optionally set date range (Start Date and End Date)
Click the report you want to generate

Tip: You must have access to at least 2 companies to use consolidated reports. Create additional companies or request access from company admins.

Consolidated Income Statement

Shows combined revenue, expenses, and net income across all selected companies.

What's Included:

Revenue by company
Expenses by company
Net Income by company
Consolidated totals
Summary cards with key metrics

Use Cases:

Board reporting on total organization performance
Investor updates showing combined profitability
Year-over-year comparisons across entities

Consolidated Balance Sheet

Aggregates assets, liabilities, and equity across all selected companies.

What's Included:

Total Assets by company
Total Liabilities by company
Total Equity by company
Consolidated totals
Balance check indicator

Combined Trial Balance

Displays every account from every selected company side by side in a single table.

What's Included:

Account name and type
Balance for each company in separate columns
Total debits per company
Total credits per company

Use Cases:

Accountants reviewing multiple clients' books
Comparing chart of accounts across entities
Identifying discrepancies or unusual balances

Comparative P&L

Shows individual profit & loss cards for each selected company with profitability metrics.

What's Included:

Revenue total
Cost of Goods Sold
Gross Profit
Operating Expenses
Net Income
Gross Margin %
Net Margin %

Use Cases:

Comparing profitability across business units
Identifying which companies need attention
Benchmarking margin performance

Client Summary Dashboard

High-level overview of all selected companies with health indicators and key metrics.

What's Included:

Metric	Description
Revenue	Total income
Net Income	Profit after expenses
Cash Balance	Current bank account totals
A/R Outstanding	Accounts receivable balance
Transaction Count	Total transactions recorded
Customer Count	Number of customers
Vendor Count	Number of vendors
Health Status	Profitable or Loss indicator
Last Activity	Most recent transaction date

Use Cases:

Practice management for accounting firms
Quick health check across all entities
Identifying clients who need attention

Tip: All consolidated reports can be printed directly from the report view using the Print button.

Intercompany Eliminations: Why Eliminate?

Adding the books of two related companies straight together produces a number that's too big — every dollar your entities exchanged with each other gets counted twice. If your manufacturing company invoices your retail company $250,000 for goods, an unconsolidated total reports a quarter million in revenue on one set of books AND a quarter million in expense on the other, plus matching $250K balances on receivables and payables that net to zero internally. The combined enterprise didn't actually sell anything to a third party.

BizBooks Pro's elimination engine corrects this. It identifies your intercompany activity, matches the two halves of every transaction, and writes journal entries that wipe out both sides at the consolidation level. Your underlying per-entity books stay intact — eliminations live in a separate "consolidation run" — so the standalone statements remain accurate while the rolled-up numbers finally reflect reality.

v1 covers: Wholly-owned subsidiaries, single-currency operations, invoice↔bill pairing. Foreign-currency translation with cumulative translation adjustment, partial ownership / non-controlling interest, and parent-investment-vs-sub-equity elimination are scheduled for v2.

Step 1 — Flag Related Parties on Customer and Vendor Records

The software can't pair intercompany transactions until you tell it which contacts are related entities. Open any customer or vendor; if your account spans more than one company you'll see a 🔗 Intercompany Partner block. Choose the company that this contact represents, save, and you're set. Single-company accounts won't see this block at all.

After tagging, every invoice, bill, payment, register entry, and journal entry referencing that contact automatically inherits the counterparty company id — so the matcher has clean data without you having to remember anything at entry time.

Step 2 — Build a Consolidation Group

A group bundles the parent and its subsidiaries for reporting purposes. Go to Reports → Consolidation Groups:

Hit + New Group.
Give it a meaningful name like "Smith Enterprises Roll-up".
Select the parent — it joins as a 100% member automatically.
Set the reporting currency.
Tune the matching tolerances if your numbers tend to disagree by more than a dollar or arrive more than a week apart. The default $1.00 / 7 days fits most situations.
Add subsidiary members and ownership percentages.
Save.

Step 3 — Scan a Period for Intercompany Activity

From the group's runs page, click + New Run:

Set period start and end (most users do month, quarter, or fiscal year).
Optionally jot notes for audit-trail purposes.
Click Create & Scan. The run is created in draft state and immediately scanned.

The matcher pulls every IC-tagged invoice and bill in the period, indexes the bills by from→to direction, and pairs reciprocals using your tolerances. Five summary cards report what it found — Matched, Discrepancies, Unmatched A-side, Unmatched B-side, and an auto-match rate. Discrepancies indicate pairs that landed within tolerance but aren't perfectly identical (typically rounding or posting-date differences); unmatched items are transactions one side recorded that the other didn't.

Step 4 — Generate the Elimination Journal Entries

When the matches look right, press ⚡ Generate Eliminations. For each paired transaction you'll get two balanced JEs:

P&L Elimination (📉): Reverses the revenue Cr from the seller and the expense Dr from the buyer. The income statement no longer counts the intercompany sale as outside revenue.
B/S Elimination (⚖️): Reverses the AR on the seller and the AP on the buyer. The balance sheet no longer carries phantom internal balances.

Every entry surfaces a complete debit/credit ledger view, totals, and a balance check. Re-running Regenerate Auto wipes only the auto-generated rows — manual entries you've added survive.

Step 5 — Add Manual Entries and Approve Everything

Some intercompany activity won't surface from invoice↔bill pairing — cost-allocation chargebacks, expense reimbursements, unrealized profit on intercompany inventory still on hand, etc. Click ✏️ Add Manual, build a balanced multi-line entry across any companies in the group, and save. A live balance bar enforces debit = credit before letting you proceed.

Auto and manual entries alike must be approved before the run can be posted. Click ✓ Approve on each card; the entry stamps with your username and timestamp. ↩ Unapprove rolls it back if you spot something later.

Step 6 — Post the Run (and Lock the Period)

Once everything's approved, the green 🔒 Post Run button activates. Posting:

Records who posted and when.
Freezes the run — no more re-scans, regenerations, manual edits, or deletes.
Marks the run as the official audit-trail record for the period.

If you discover an error after posting, hit 🔓 Unpost to drop back to scanned status and reopen edits.

Step 7 — Pull the Three-Column Consolidated Reports

Head to Reports → All Reports → 🏢 Consolidated Financial Reports. The new 🔗 Apply Eliminations from Posted Run dropdown lists posted runs from every group you own. Pick the run you just posted, and:

Member-company checkboxes get auto-restricted and pre-ticked.
Income Statement, Balance Sheet, and Trial Balance all switch to a Rolled-up | Eliminations | Consolidated three-column layout.
Eliminations on each row show in parentheses so reviewers can trace exactly what was removed.
The Balance Sheet's L+E balance check honors eliminations on both sides and still ties to the cent.

Switching the dropdown back to "None (roll-up only)" returns the reports to plain aggregate mode — handy for showing pre- vs post-elimination side by side.

Bonus — Cash Transfers Between Your Entities

Treasury sweeps, intercompany loans, and any other direct cash movement between your companies don't run through customer or vendor channels — they require simultaneous entries on both sets of books. From the group's runs page click 📤 IC Transfer:

Date, amount, description, optional reference number.
Source company → cash account (where money leaves) → offset account (e.g. "Due From Subsidiary").
Destination company → cash account (where money arrives) → offset account (e.g. "Due To Parent").
Hit Record Transfer.

BizBooks Pro creates the matched dual-entry journal entries on both companies' books in one step, both stamped intercompany. The next consolidation scan pairs the offsets so they can be eliminated.