Finance / Operations · Live in production · Operated by Altaurux
One Automated Briefing Across a $28.7M Trust and Two Operating Companies
Three QuickBooks entities, consolidated and analysed automatically every Saturday morning.
The challenge
A founder was running three businesses at once: a real estate trust holding $28.7M in assets, and two operating companies generating $3-4M in combined annual revenue. Each entity kept its own books in QuickBooks. None of them talked to each other.
Every week, the same ritual. Log into three separate QuickBooks accounts. Export three sets of numbers. Drop them into a spreadsheet. Reconcile the formats, normalise the chart of accounts, and manually scan for anything that looked wrong: a vendor cost that had quietly doubled, a receivable that hadn’t cleared, a payroll line that didn’t match the headcount.
It worked. That’s the trap. Manual multi-entity reporting works, right up until it doesn’t, and the failure mode is invisible. The deeper problem wasn’t time, it was latency. A cash-flow risk that surfaces three weeks after it starts is no longer a warning: it’s a fire.
What we built
An automated financial intelligence layer that sits on top of all three QuickBooks entities and produces a boardroom-ready briefing every Saturday morning without a human touching it.
Live multi-entity data ingestion
Connects directly to the QuickBooks API for each entity and pulls current ledger data on a scheduled sync. Account structures map to a unified chart of accounts, so figures roll up correctly. No exports, no CSVs, no copy-paste.
AI-generated P&L analysis
Runs an AI analysis pass over the consolidated P&L and produces written commentary in plain English: what moved, by how much, and the most likely explanation. It reads like a CFO briefing, not a database query.
Automated variance detection
Any line item moving more than 50% week-over-week is automatically flagged and surfaced at the top. The anomaly announces itself instead of waiting to be found.
Cash-flow risk surfacing
Models cash position across entities and flags emerging pressure: ageing receivables, upcoming obligations against projected inflows, entity-level shortfalls invisible in isolation. Risks surface while still adjustable.
Scheduled boardroom-ready delivery
Every Saturday morning the finished briefing arrives automatically. The founder’s weekly review starts with reading, not assembling.
How it works
Sync: authenticate to all three QuickBooks entities and pull the current period’s ledger data.
Normalise: map accounts into a unified structure so cross-entity figures are genuinely comparable.
Consolidate: generate a combined P&L and cash position across all three entities.
Flag: compare every line against the prior week; surface anything exceeding the 50% threshold.
Analyse: an AI layer generates written commentary on performance, movements and risks.
Deliver: the formatted briefing is dispatched Saturday morning.
Results
A $28.7M trust and two operating companies consolidated into a single weekly view
Hours of manual data assembly per week eliminated entirely
Anomalies surfaced automatically instead of discovered by chance
Cash-flow risks identified while there’s still time to act on them
Running in production, operated by Altaurux on an ongoing basis
See it in action
A full walkthrough of the system: QuickBooks sync across all three entities, live variance flagging, and the automated Saturday briefing as the founder receives it.
Technology
FAQ
Can this work with more than three entities?⌄
Yes. The consolidation layer is entity-agnostic: additional QuickBooks accounts are added as new sources and mapped into the same unified chart of accounts. The reporting logic doesn’t change.
How is the 50% variance threshold set?⌄
It’s configurable. 50% was the right sensitivity for this client’s cost structure, enough to catch real movement without noise. It can be set per account.
Is the AI analysis reliable enough for financial decisions?⌄
The AI generates commentary on figures pulled directly from the source ledgers, it doesn’t calculate the numbers, it explains them. Every figure is traceable back to QuickBooks.
What happens if a sync fails or data is incomplete?⌄
The briefing is generated from live ledger data on a scheduled cycle, so reporting reflects the current state of the books rather than a stale manual snapshot.
Managing multiple entities by hand?
If your weekly financial review starts with three exports and a spreadsheet, there’s a system that removes that entirely.