Consolidated Reports

Merge and compare financial data from every company in your local Kantivo installation.

Overview

Consolidated Reports pull numbers from multiple companies stored in your local PostgreSQL database and present them together in unified financial statements. Because everything runs on your own hardware, even large multi-entity reports generate quickly with no dependency on an internet connection. Common scenarios include:

• Entrepreneurs who operate several businesses and want a combined performance picture
• Parent companies that need to roll up subsidiary figures into a single view
• Accounting professionals comparing key indicators across their client roster
• Franchise operators benchmarking individual locations against one another

Accessing Consolidated Reports

1. Open Reports from the main navigation
2. Press the Consolidated button (purple gradient styling)
3. Tick at least two companies in the checkbox list
4. Optionally narrow the data by setting a Start Date and End Date
5. Choose the specific report you want to produce

Consolidated Income Statement

Brings together revenue, costs, and net income from every selected entity into a single statement so you can evaluate collective profitability.

What's Included:

• Revenue broken out by company
• Expenses broken out by company
• Net Income for each entity individually
• Grand totals across all selected companies
• Highlight cards summarizing the most important figures

Use Cases:

• Preparing board-level presentations on organization-wide results
• Producing investor updates that reflect combined earnings
• Running year-over-year trend analyses across multiple entities

Consolidated Balance Sheet

Combines the asset, liability, and equity positions of every chosen company into one unified balance sheet.

What's Included:

• Total Assets per company
• Total Liabilities per company
• Total Equity per company
• Summed consolidated figures
• A balance verification indicator to confirm debits equal credits

Combined Trial Balance

Lists every account from each selected entity in a single spreadsheet-style table, making it straightforward to compare balances side by side.

What's Included:

• Account name and classification type
• A separate balance column for each company
• Summed debit totals per company
• Summed credit totals per company

Use Cases:

• Accountants performing a simultaneous review of several sets of books
• Comparing how different entities structure their chart of accounts
• Spotting anomalies or outlier balances that warrant investigation

Comparative P&L

Generates an individual profit and loss card for each selected company, complete with profitability ratios, so you can quickly see which entities are thriving and which need attention.

What's Included:

• Total Revenue
• Cost of Goods Sold
• Gross Profit
• Operating Expenses
• Net Income
• Gross Margin percentage
• Net Margin percentage

Use Cases:

• Ranking business units by profitability in a single glance
• Pinpointing entities where margins are declining
• Setting performance benchmarks across divisions or franchise locations

Client Summary Dashboard

A bird's-eye-view of every selected company, pairing key financial metrics with health indicators so you can quickly triage where your attention is needed most.

What's Included:

Use Cases:

• Managing an accounting practice and keeping tabs on every client at once
• Running a fast health check across a portfolio of entities
• Flagging companies that have gone quiet or are trending toward a loss

Intercompany Eliminations: What & Why

Plain roll-up reports add the books of every selected company together — which silently double-counts every transaction your entities did with one another. If Company A invoices Company B for $100,000 of services, the unconsolidated roll-up shows $100K of revenue on A's books AND $100K of expense on B's books, plus a phantom $100K of receivable matching a phantom $100K of payable. The combined entity didn't actually sell anything to an outsider; the activity was internal.

Kantivo's elimination engine fixes that. It identifies every intercompany transaction inside the period, pairs A's invoice with B's bill, and writes balanced journal entries that cancel both sides at the consolidation layer. The source books on each entity stay untouched — eliminations live in a separate "consolidation run" — so you keep clean per-entity statements while presenting a clean group-level view.

Step 1 — Tag Intercompany Partners on Customers and Vendors

The system needs to know which contacts represent your other companies. Open any customer or vendor record; if your account owns more than one company you'll see a 🔗 Intercompany Partner section. Pick the related company from the dropdown, save, and you're done. The section auto-hides for accounts that own only one company.

From that moment forward, any invoice, bill, payment, register entry, or journal entry posted against that contact gets stamped with the counterparty company id so the matcher can find it later.

Step 2 — Create a Consolidation Group

A consolidation group is the parent + subsidiaries you want to roll up together. Navigate to Reports → Consolidation Groups:

1. Click + New Group.
2. Name it (e.g. "Acme Holdings Consolidated").
3. Pick the Parent Company — it's automatically added as a member at 100% ownership.
4. Pick the reporting currency (defaults to USD).
5. Adjust the matching tolerances if needed: the defaults are $1.00 amount tolerance and 7-day date window — tighter values reject more imperfect matches; looser values catch more pairs but risk false matches.
6. Add additional member companies with their ownership %.
7. Save.

Step 3 — Run the Matching Engine

From the group card, click 📊 Runs → + New Run:

1. Pick a period start and end (typically a month, quarter, or fiscal year).
2. Add notes if helpful for the audit trail.
3. Hit Create & Scan — Kantivo creates the run in draft status and immediately auto-scans.

The scanner pulls every IC-tagged invoice and bill in the period across all member companies, buckets them by from→to direction, and pairs reciprocals using your tolerance settings. The result page shows summary cards: ✅ Matched | ⚠️ Discrepancies | 🔍 Unmatched A | 🔍 Unmatched B | 📈 Auto-match Rate. Discrepancies are pairs that match within tolerance but aren't exact (typically off-by-cents from rounding or a few days from posting lag); unmatched items are transactions that have no counterpart on the other side at all.

Step 4 — Generate Eliminations

Once you're satisfied the matching captured what you expected, hit ⚡ Generate Eliminations. For each matched/discrepancy pair Kantivo creates two balanced journal entries:

• P&L Elimination (📉): Dr A's revenue accounts $X / Cr B's expense accounts $X. Kills the inflated income statement.
• B/S Elimination (⚖️): Dr B's Accounts Payable $X / Cr A's Accounts Receivable $X. Kills the phantom intercompany balances.

Each entry shows the full debit/credit ledger view, totals, and a ✓ balanced check. Regenerate Auto wipes auto-generated entries and rebuilds them from scratch — manual entries you've added are preserved.

Step 5 — Manual Entries + Approval

For intercompany activity the matcher couldn't auto-detect (typically anything that isn't a paired invoice↔bill — like cost allocations, expense reimbursements, or unrealized profit on inventory still on hand) click ✏️ Add Manual. The modal lets you build a balanced multi-line journal entry across any companies in your group; a live balance bar shows whether the entry is balanced and disables Save until it is.

Every entry — auto or manual — must be approved before the run can be posted. Click ✓ Approve on each card; the entry stamps with your username and timestamp. Use ↩ Unapprove if you need to revisit it.

Step 6 — Post & Lock the Run

When every elimination is approved, the 🔒 Post Run button enables. Posting:

• Stamps the run with posted_at and posted_by.
• Disables further re-scans, regenerations, manual edits, and deletes on this run.
• Establishes the run as the audit-trail anchor for the period.

Need to make corrections? Click 🔓 Unpost to reverse to scanned status. The run is fully editable again.

Step 7 — View Three-Column Consolidated Reports

Open Reports → All Reports → 🏢 Consolidated Financial Reports. The new 🔗 Apply Eliminations from Posted Run dropdown lists every posted run from every group you own. Pick one, and:

• The company multiselect auto-restricts to that run's group members and pre-ticks them.
• Income Statement, Balance Sheet, and Trial Balance all gain a Rolled-up | Eliminations | Consolidated column layout.
• Eliminations show in parentheses next to each affected account — reviewers see exactly what the matcher removed and what's left.
• The Balance Sheet's L+E balance check accounts for eliminations on both sides and still ties to the penny.

If you pick "None (roll-up only)", the reports revert to the original aggregate view — useful for comparing pre- and post-elimination numbers side by side.

Bonus — Recording Intercompany Cash Transfers

Treasury sweeps, intercompany loans, and direct cash movements between your entities don't go through customer/vendor channels — they need to hit both companies' bank accounts simultaneously. From the group runs page, click 📤 IC Transfer:

1. Enter date, amount, description, optional reference.
2. Pick the source company, the cash account funds leave from, and the offset account (e.g. "Due From Sub").
3. Pick the destination company, the cash account funds arrive in, and the offset account (e.g. "Due To Parent").
4. Hit Record Transfer.

Kantivo creates two matched, balanced journal entries — one on each entity's books — both auto-tagged intercompany. The cash movement is fully recorded and the next consolidation scan will pair the offsets so they can be eliminated.