What's the first step in reconstructing a year of transactions from bank statements?

Build a complete account inventory first: every checking, savings, and credit card account used during the year, all twelve months of statements for each, and the opening and closing balance for each account. Missing an entire account is far more damaging than a miscategorized transaction, so confirm the inventory before touching any data entry.

How do you avoid double-counting transfers between accounts?

Match withdrawals on one account to deposits on another by amount and date, then tag them as internal transfers rather than income or expense. Do this before categorizing anything else, and gather all accounts up front so you can actually see both sides of each transfer.

How do you know the reconstruction is complete and accurate?

Reconcile every account, month by month: opening balance plus deposits minus withdrawals must equal the closing balance printed on the actual statement. If it doesn't match, something is missing or double-counted. Checking monthly instead of just at year-end makes it far easier to find exactly where the error is.

How to Reconstruct a Year of Transactions From Bank Statements

When a client shows up with no books and a stack of statements, the bank and card statements are the only source of truth you have. Here's how to turn twelve months of PDFs into a complete, reconciled year of transactions.

When you need a full rebuild

Sometimes there are no books to catch up — there's nothing. A new client hands you a shoebox and says "I didn't do any bookkeeping this year." A business owner needs a prior-year P&L for a loan application and their accounting software was never set up. An estate needs a full picture of an account with no ledger behind it. In all of these cases you're not reconciling existing records, you're building the entire year from source documents.

The source documents are the bank and credit card statements. That's the one thing that can't lie: every deposit and withdrawal that actually happened is on there, whether or not anyone ever entered it into QuickBooks. The job is turning twelve months of statement PDFs into a complete, reconciled transaction ledger.

Step 1: Gather every account, every month

Before you touch a single transaction, build the account inventory. Missing an account entirely is far more damaging than a few miscategorized transactions, because it means an entire slice of activity is invisible to the reconstruction.

List every checking, savings, and credit card account the business or individual used during the year — ask directly, don't assume it's just the "main" account.
Confirm you have all twelve months for each account. Statements go missing most often around account openings, closings, or bank mergers.
Note the opening balance on the first statement and the closing balance on the last one for each account. These two numbers are your reconciliation anchors for the entire year.
Watch for accounts that opened or closed mid-year — the reconstruction only needs to cover the months the account was actually active.

If a client can't produce a statement, most banks will let you or the client request historical statements going back several years through online banking or a written request. It's worth the wait rather than reconstructing a year with a hole in it.

Step 2: Convert PDFs to structured data

Bank statements come as PDFs, and PDFs are not spreadsheets. Retyping a year of transactions by hand across multiple accounts is slow and it's where most reconstruction errors creep in — a transposed digit or a skipped line on page 4 of a statement nobody double-checks.

Run each statement through a converter instead. A tool like bankstatement.dev extracts every transaction line from the PDF and outputs a clean spreadsheet, matching the statement's own balance so you know the extraction is complete before you move on. For a full year of records headed straight into your accounting software, the bank statement to QuickBooks converter skips a manual import step entirely; otherwise a plain CSV works fine for building the ledger yourself.

Do this for every account before you start categorizing anything. You want all twelve months of every account sitting in spreadsheet form, side by side, before you try to make sense of the whole year.

Step 3: Dedupe transfers between accounts

This is the step people skip and regret. If a business moves money from checking to savings, that transfer shows up on both statements — once as a withdrawal, once as a deposit. Count it as income or expense on either side and you've overstated the year's activity.

Match transfers by amount and date across the accounts you gathered in step 1. A $5,000 withdrawal from checking on the 14th and a $5,000 deposit to savings on the 14th or 15th is almost always the same movement of cash.
Tag matched transfers as internal movements, not revenue or expense, so they don't inflate either side of the P&L.
Watch for credit card payments too — a payment leaving the checking account and landing on the credit card statement is the same transfer viewed from two sides. Only the underlying purchases on the card are real expenses.

This step is exactly why you gather every account before categorizing anything. You can't spot a transfer's other half if you're working one account at a time.

Step 4: Categorize with a consistent chart of accounts

Once transfers are stripped out, what's left is real income and real expense. Categorize it against a chart of accounts you've decided on up front, not one you're inventing transaction by transaction.

Use vendor names and recurring patterns to batch-categorize — the same payroll processor, the same rent payment, the same supplier will appear repeatedly across the year.
Flag anything ambiguous for the client rather than guessing. A reconstruction built on guesses about categorization is fragile the moment it's questioned.
Keep personal and business activity clearly separated if you're working a sole proprietor's mixed-use account — see separating business and personal expenses for how to draw that line without losing legitimate deductions.

For guidance on building the category structure itself from statement data, categorizing business expenses from a bank statement covers the mechanics in more depth.

Step 5: Reconcile to the statement balances

This is the step that proves the reconstruction is complete, and it's non-negotiable. For every account, every month:

Opening balance + deposits − withdrawals = closing balance, and that closing balance must match the number printed on the actual statement.

If it doesn't match, you're missing a transaction, you've double-counted a transfer, or a fee or interest line got dropped somewhere. Track this down before moving to the next month — errors compound, and finding a missing transaction from March is much easier in March than after you've built ten more months on top of it.

Do this monthly, not just at year-end. A single year-end reconciliation only tells you the whole year is off; it doesn't tell you where. Twelve monthly checkpoints tell you exactly which month to dig into. For the underlying discipline here, see why bank reconciliation takes so long — most of what makes it slow is exactly the transfer and duplicate issues covered above, and it goes faster once you know what you're looking for.

Once every account ties out month by month, you have a defensible, complete year of transactions built entirely from source documents — no assumptions, no gaps, and a paper trail back to every number on it.