Free Excel template
Compare your bank statement with your ledger.
Paste two transaction lists for one account. See which dates and amounts appear on both sides, which appear on one side, and which repeat.
The comparison runs in Excel on your computer. The workbook includes a fictional example you can try.
Use it with your register export
- Choose one account, currency and date range in both files. Paste the bank date, description and signed amount into the Bank tab.
- Paste the equivalent columns from QuickBooks or another register into Ledger. For a checking account with separate deposits and payments, use deposits minus payments.
- Open Review. A unique date and amount points to the other sheet’s row. Check the descriptions before clearing it. Review splits, fees and different posting dates manually.
Each copy checks 1,000 rows per side. For longer histories, split both lists at the same whole-date boundaries.
Starting with PDF statements?
Convert up to 12 monthly PDFs into an Excel workbook. Its first three transaction columns paste directly into this template, and the source filename and page are available for review.
Turn statement PDFs into Excel rows2 PDF pages free per day. One-time packs start at $6 for 50 pages. View conversion prices.