Bank reconciliation
Bank reconciliation in Excel, done for you
The usual way is two columns in a spreadsheet, sorted by amount, ticked off one by one. Here the ticking is done for you: same amounts within a few days, check numbers, and deposits that combine several payments. You review what is left and download the finished workbook.
Step 1
Bank statement
PDF from online banking, a scan, or the bank's CSV or Excel export.
Step 2
Books
The bank account's register or ledger from QuickBooks, Xero or a spreadsheet, as CSV or Excel.
Any spreadsheet works as the ledger
The ledger can be any spreadsheet with a date column and either an amount column or separate money-in and money-out columns. Column names are recognised automatically; you can change the assignment if a column is named differently.
The reconciliation statement
Balance per bank statement, plus deposits in transit, less outstanding checks and payments, equals the adjusted bank balance. Balance per books, plus or minus items on the statement that are not in the books, equals the adjusted book balance. The difference should be zero; if it is not, the lists show where to look.
Pricing
- ✓PDF, scanned, CSV and Excel statements
- ✓QuickBooks, Xero and spreadsheet ledgers
- ✓Check numbers, groups and near misses
- ✓Reconciliation report in Excel
- ✓Files never stored
Prices in USD are approximate. Checkout charges the exact amount in USD at Stripe’s exchange rate (a 2–4% conversion fee is included), or in euros if you prefer. No VAT or sales tax is added. Monthly, cancel any month. A statement is one uploaded statement file; matching it again or against a corrected ledger is not counted again.
Questions
- Can I match lines by hand?
- Yes. Tick lines on both sides; when the totals agree, they can be matched together. Wrong matches can be undone.