The answer
How to reconstruct books from bank statements
You can rebuild a full year of books from nothing but monthly bank and card statements. The statement is the primary record: it carries every dollar in and out, with a date, a description and a running balance the bank itself printed.
Below is the method in eight steps, the check that proves a month is actually finished, and the mistakes that waste the most time. Doing it by hand takes roughly 25 to 50 hours for a year at normal volume.
The whole method in one line
Transcribe every line, categorize it, then prove the month by matching your closing balance to the one your bank printed. That match is the difference between a spreadsheet and books.
Or drop one statement and watch it happen: Titan closes your first month free, tied out, with every figure traceable to its source line.
Close one month free01 / What you need
Five inputs, and one you can skip.
Every monthly statement, every account
Business checking, savings, and every credit card the business used. A missing account is the single most common reason a reconstruction never ties out, because money leaves one account and appears in another.
The statements as PDFs from the bank
Download them from online banking rather than scanning paper. A bank PDF carries the printed opening and closing balances, which is the evidence the whole method rests on.
A continuous run of months, with no gaps
January and March without February will not reconcile: February's closing balance is March's opening balance, and without it the chain breaks.
Loan and payment-processor statements, if any
A term loan, an SBA loan, a Stripe or Square account, or a PayPal balance each move money that your bank shows only as a net transfer. Without them, the transfers look like income or expense and both are wrong.
Nothing else, strictly speaking
Receipts, invoices and contracts make the categorizing sharper and are worth having for a review. But they are not required to produce reconciled books, and waiting until you have them is how a reconstruction stalls for another year.
02 / The method
Eight steps, in order.
01
Fix the period and the basis
Decide the first and last month you are rebuilding, and whether the books are cash basis or accrual. For a reconstruction from statements, cash basis is the honest default: a statement records money moving, which is exactly what cash basis measures. Accrual requires invoice and bill dates that a statement does not contain.
02
Build a chart of accounts for your trade
Twenty to forty accounts, not two hundred. A general contractor needs subcontractors, materials, equipment rental, permits and fuel; a Shopify seller needs cost of goods, merchant fees, ads and shipping. Getting this list right before you categorize anything is what makes the P&L readable at the end.
03
Transcribe every line, exactly as printed
Date, description as the bank printed it, and amount, one row per transaction, per account. Do not clean up the descriptions — the raw string is what lets you find the line again later, and what proves the row is not invented.
04
Check the arithmetic before you interpret anything
Opening balance plus deposits minus withdrawals must equal the printed closing balance, for each month and each account. If it does not, you have missed a line or a page. Fix that before categorizing — categorizing a month with a hole in it wastes the work twice.
05
Categorize, and mark every guess as a guess
Most lines are obvious from the description once you have seen the vendor twice. Some are genuinely ambiguous: a hardware-store charge could be materials, equipment, or the owner's deck. Guessing silently is the failure mode that makes books indefensible. Flag the uncertain ones and keep the list short enough to actually resolve.
06
Separate transfers, owner draws and loans from income and expense
The three most common errors in a self-built reconstruction, in order: a transfer between your own accounts counted as revenue; an owner draw counted as an expense; a loan deposit counted as income. Each one distorts the P&L badly and none of them is obvious from the statement line alone.
07
Reconcile and tie out each month
A month is finished when your ledger's closing balance equals the balance printed on the statement, to the cent, for every account. That equality is the tie-out. Until it holds, you have a categorized list of transactions — not books. Once it holds for twelve consecutive months, the year is defensible.
08
Produce the statements, then the audit trail
From a tied-out ledger, the profit and loss, balance sheet and cash flow statement are arithmetic. The part that matters for a review is the trail: every figure on every report should trace back to a specific line on a specific statement page. A number that cannot be traced is a number nobody should rely on.
Step 07 is the one people skip, and it is the only one that produces proof. A month that has been categorized but never reconciled looks finished on screen and falls apart the first time someone checks it against the bank.
03 / Where it goes wrong
The five errors that cost the most time.
- Starting with an opening balance you cannot explain
- Month one has to start somewhere. If the opening balance came out of thin air, the balance sheet is wrong for the whole period. Either go back to the prior year's last statement or state plainly that the opening figure is unexplained.
- Rebuilding on top of a half-finished accounting file
- Duplicate imports and a plugged balance from an abandoned attempt are more expensive to unwind than starting again from statements. Undo before you rebuild.
- Categorizing by amount instead of by description
- Two $450 charges in the same month are rarely the same thing. The description and the vendor are the signal; the amount almost never is.
- Treating credit-card payments as expenses
- The expense happened when the card was charged. Paying the card is a transfer. Counting both doubles your costs, which feels conservative and is simply inaccurate.
- Stopping at a P&L
- A profit and loss with no balance sheet and no reconciliation is the version a lender or a reviewer sends back. The tie-out is the part that makes it evidence.
04 / Or have it done
The same eight steps, in hours, at a public price.
Titan runs this method on your statements: every line read, a chart of accounts for your trade, each month reconciled to the printed closing balance, every uncertain categorization flagged rather than guessed silently, and every figure in every report clickable back to its source line.
The first month is free and tied out. Drop one statement — pick a month you already know something about, so you can check our arithmetic against your own memory of it.
05 / Questions
The rest of what people ask.
- Can you really reconstruct books from bank statements alone?
- Yes, on a cash basis. A bank statement records every dollar in and out with a date, a description and a running balance, which is enough to build a general ledger, reconcile each month to the printed closing balance, and produce a P&L, balance sheet and cash flow statement. Receipts improve the categorizing and are useful in a review, but they are not required for the books to reconcile.
- How long does it take to do it yourself?
- For a business with 50 to 300 transactions a month, budget two to five hours per month rebuilt once you have a system — so roughly 25 to 50 hours for a year, spread over whatever evenings you have. The transcribing is fast; the categorizing and the tie-out are where the hours go.
- What does 'tied out' mean?
- That your ledger's closing balance for a month equals the closing balance printed on the bank's own statement, exactly, for every account. It is the one check that proves nothing was missed or double-counted. Books that do not tie out are an estimate.
- Cash basis or accrual for a reconstruction?
- Cash basis, unless a lender or your CPA specifically requires accrual. Statements tell you when money moved, not when an invoice was issued, so an accrual reconstruction from statements alone involves assumptions you cannot support. Many small businesses file on cash basis anyway.
- Will my CPA accept books built this way?
- A preparer's objection is almost never the method — it is unreconciled balances and untraceable figures. Hand over a ledger where every month ties to the statement and every figure traces to a source line, and you have given them something to review rather than redo. They should still sign the return; we do not file returns and do not give tax advice.
- How far back can I get statements?
- Most US banks keep about seven years available in online banking, and will produce older ones on request, sometimes for a fee. Two years of monthly PDFs is twenty-four downloads and is the whole input.
- What does Titan do differently from doing this by hand?
- The same eight steps, run in minutes instead of weeks: it reads every line from the PDF, applies a chart of accounts for your trade, reconciles the month to the printed balance, shows a confidence on each categorization, and lets you click any figure in the P&L to see the exact source line on your own statement. The first month is free, so you can check the method against a month you already know.
Try it on one month before deciding.
One statement in, one closed month out — reconciled to the balance your bank printed, with every figure traceable to the line it came from. No account, no card, no call.