Reconcile a Bank Statement in a Spreadsheet
Reconciling means proving that your own records and the bank agree for a period. With the statement as rows instead of a PDF, the matching can be done with sorting and a couple of formulas.
Your file is never uploaded. RowSmith reads text-based PDF statements in your browser. Scanned PDFs aren't supported yet. Always review the rows before you use them.
Open the free statement converter
Steps
- Convert the month's statement PDF to an Excel file.
- Paste your ledger entries for the same month into a second sheet.
- Sort both sheets by amount, then match pairs and mark them.
- List whatever is left on either side and explain each item.
Good to know
Matching by amount
Dates can differ by a day or two between your ledger and the bank, but amounts rarely do. A lookup on the amount column, followed by a quick look at the dates, finds most pairs fast. Repeated amounts, such as a weekly payment, need a second glance.
Typical leftovers
Unmatched lines are usually bank fees, interest, checks that haven't cleared, or deposits recorded in the wrong month. Each one either needs an entry in your books or is a timing difference that will clear next month.
Closing the loop
When opening balance plus all statement rows equals the closing balance, and every row is matched or explained, the month is reconciled.
Questions
Do I need accounting software for this?
No. A spreadsheet works well for a few accounts and a modest number of transactions.
How often should I reconcile?
Monthly is common, right after each statement is issued, so the gaps stay small and easy to trace.
This guide was written with AI assistance and reviewed against the converter's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.