Trial balance in, financial statements out
The mapping exercise every accountant repeats — account classification, subtotals, statements — done from one prompt, with the logic visible.
A client sends a trial balance. You know exactly what happens next: classify every account into revenue, COGS, opex, assets, liabilities, equity; build the subtotals; tie the statements. It's the same hour of Excel every time, and the mapping lives in a spreadsheet only you understand.
Drop the trial balance on the canvas instead. The AI proposes the classification and writes the SQL that builds the statements; you see every rule it applied and can correct any account with a sentence. The computation itself is done by a query engine on your machine — the totals tie because they're computed, not composed.
The prompt
“Here's a trial balance export. Classify the accounts into a P&L and balance sheet, and show me gross margin and net income.”
The classification is visible and correctable — "move Merchant Fees into operating expenses" is a follow-up, not a redo.
How it works
Connect QuickBooks live, or drop an export — Excel, CSV, JSON, Parquet. From QuickBooks or any other system.
The AI plans the steps and writes the SQL for each one — visible on the canvas, readable, auditable.
A real query engine in your browser runs the SQL on your actual data. Numbers are computed, never generated.
What you get
- A classified P&L with revenue, COGS, gross profit, opex, and net income
- A balance sheet that ties, built from the same trial balance
- The classification logic spelled out — every account, every bucket
- A reusable workflow for the next client, or next month
Common questions
What format does the trial balance need to be in?
Excel or CSV with account names and debit/credit (or signed balance) columns — the standard export from QuickBooks, Xero, NetSuite, or any GL. The AI reads your actual column names; there's no template to fill.
What if the AI classifies an account wrong?
You'll see it — the classification is shown, not hidden. Correct it in plain English ("treat Freight In as COGS, not opex") and the statements recompute. The point is that the logic is visible, so errors are catchable.
Can the AI hallucinate my numbers?
No — the AI never generates numbers. It plans the analysis and writes SQL; a real query engine in your browser computes the result from your actual data. Every step is visible as SQL you can read and audit, so a wrong number is a wrong query you can see, not an invented figure you can't.
Do I need to sign up to try it?
No. Open the canvas, drop a file, and ask — you get free AI messages with no account. A free account unlocks a monthly allowance of AI questions and saved workflows you can re-run every month.
More QuickBooks guides
Try it on your books
No sign-up to start. Drop a file or connect QuickBooks — your file contents never leave your machine.
Open the canvas →