February 10, 2026
How to reconcile invoices with bank statements (step by step)
Invoice reconciliation is the process of matching the invoices you sent to the payments that actually showed up in your bank account. It sounds straightforward — until you sit down and try to do it for 40 invoices across three payment processors.
Here's the step-by-step process most small business owners follow, along with where it starts to fall apart.
Step 1: Export your data
Start by downloading two CSV files: one from your invoicing tool (FreshBooks, QuickBooks, Wave, or even a spreadsheet) and one from your bank. Most banks let you export transactions for a date range. Make sure the date ranges overlap with your outstanding invoices — go back at least 60 days to catch late payments.
Step 2: Sort and scan
Sort both lists by amount. This is the fastest way to spot matches — if you invoiced $3,500 and there's a $3,500 deposit, you've likely found a match. Work through the exact matches first, marking each invoice as paid and noting the corresponding bank transaction date.
For small businesses with fewer than 20 invoices per month, this might be all you need. You can finish in 30 minutes.
Step 3: Hunt for the close matches
Now comes the hard part. The remaining deposits won't match any invoice exactly. A $2,000 invoice might show up as $1,942.00 after Stripe's 2.9% + $0.30 fee. A $500 PayPal invoice arrives as $485.20. You need to calculate the expected fee for each payment processor and check if the deposit amount falls within range.
This is where most people start making mistakes. One wrong mental math calculation and you've matched the wrong invoice, which cascades into more mismatches downstream.
Step 4: Investigate the outliers
After matching what you can, you'll have leftover deposits and unpaid invoices. Some deposits are combined payments — a client paid three invoices in one transaction. Some are partial payments. Some are from clients who paid a different amount than invoiced. And some are deposits that have nothing to do with invoices at all (refunds, interest, transfers).
Each outlier requires detective work: checking email confirmations, logging into payment processors, or contacting the client directly.
Step 5: Record and follow up
Mark each matched invoice as paid with the payment date. For unmatched invoices, decide: is the payment late, or did you miss the deposit? For unmatched deposits, figure out what they are before your next bank reconciliation turns into an even bigger puzzle.
Where this process breaks down
This manual process works at low volumes. But once you're sending 50+ invoices per month across multiple payment processors, the math gets overwhelming. Processing fees vary by processor and payment method. Clients combine invoices. Payments arrive weeks apart from when you expect them. Bank descriptions are cryptic.
That's the problem InvoiceTally is built to solve. Upload your invoices and bank statement, and it matches them automatically — accounting for processor fees, combined payments, and timing differences. No spreadsheet gymnastics required.