Payment Reconciliation: Finding and Fixing Discrepancies
Common reasons reconciliation gets messy, how to track down missing transactions, and a practical approach to monthly closing.
Why Reconciliation Matters More Than You Think
Most finance teams dread reconciliation day. You’ve got bank statements, accounting records, and spreadsheets that don’t match. It’s frustrating, time-consuming, and it feels like you’re hunting for a missing transaction that could be anywhere.
But here’s the thing — when you skip proper reconciliation or rush through it, small discrepancies turn into big problems. They compound month after month. You don’t know if there’s a real error, a timing issue, or fraud. And when auditors show up, you’re scrambling to explain inconsistencies that should’ve been caught weeks ago.
The good news? Reconciliation isn’t actually that complicated once you’ve got a system. It’s about being methodical, knowing where problems typically hide, and having a process that catches issues fast.
The Usual Suspects: Where Discrepancies Hide
You’re not imagining it — reconciliation problems happen because of predictable, recurring issues. Most organizations see the same problems month after month until they actually address the root cause.
Timing Differences
A payment you recorded on February 28 doesn’t hit the bank until March 1. You think there’s a discrepancy, but it’s just the float period. Most companies have 2–4 days of timing gaps between when they record something and when the bank processes it.
Duplicate Entries
Someone records a transaction manually, then the system auto-imports it. Now it’s there twice. You’ve got $5,000 in your books but only $5,000 at the bank. Difference is $5,000 because of one accidental duplicate.
Bank Fees and Charges
The bank deducts monthly fees, wire charges, or overdraft fees that nobody recorded in accounting. These often show up on the statement without warning, and they’re easy to miss.
Data Entry Errors
Someone typed $15,000 instead of $1,500. Or they entered the account number wrong. These are human mistakes, and they happen. A single keystroke error creates a mismatch that can take hours to find.
NSF Checks and Reversals
A check you received bounced. A deposit got reversed. You recorded the money coming in, but it went back out. The bank’s record and your books disagree until you spot the reversal.
Missing or Unmatched Transactions
Sometimes a transaction just doesn’t show up. A wire transfer you sent appears in the bank records but not in your accounting system. Or the opposite — you’ve got it in the books but the bank doesn’t.
The Practical Reconciliation Process
A step-by-step approach that actually works, even if you’re behind on reconciliation.
Pull Your Bank Statement and Your Books
Get the official bank statement for the month you’re reconciling. Download your accounting records for the same period. Make sure you’re looking at the exact same date range — this is critical. Some statements run calendar month, some run differently. Don’t assume. Verify the dates match before you do anything else.
Start With the Ending Balances
Write down your book balance (what your accounting system says) and your bank balance (what the bank says). If they match, you’re done — celebrate. If they don’t, calculate the difference. That number is what you’re hunting for. If the difference is $2,500, somewhere there’s a $2,500 transaction that doesn’t match up.
Check Outstanding Items
Go through your books and find transactions that haven’t cleared the bank yet. These are outstanding checks, pending transfers, or deposits in transit. Write them all down. These are legitimate and expected. Subtract outstanding checks from the bank balance and add deposits in transit. After this adjustment, does the bank balance match your books? If yes, you’re reconciled.
Match Line by Line
If you’re still off after accounting for outstanding items, you need to match individual transactions. Go through the bank statement and your books simultaneously. Check off every transaction as you find it in both places. When you find something on the bank statement that’s not in your books, mark it. When you find something in your books that’s not on the bank statement, flag it. These unmatched items are your discrepancies.
Investigate Each Discrepancy
For every unmatched transaction, dig into it. Is it a timing issue? Look at the dates — if it’s within 2–3 days, it’s probably just float. Is it a duplicate? Search your system for multiple entries of the same amount and date. Is it a fee or charge you forgot to record? Check if the bank added any fees that month. Is it a data entry error? Compare the numbers character by character. Talk to whoever made the entry if you need to.
Make Journal Entries to Fix It
Once you’ve identified the problem, fix it in your books. If the bank charged a fee you didn’t record, create a journal entry to record it. If you find a duplicate, reverse one entry. If it’s a data entry error, correct it. Each fix gets documented so you’ve got an audit trail. This is important — you need to be able to explain every adjustment later.
Verify Everything Matches
After you’ve made all your adjustments, recalculate. Does your adjusted book balance now equal the adjusted bank balance? If yes, reconciliation is complete. If no, you’ve missed something. Go back to step 4 and match again. This time, be even more careful. Sometimes the problem is hiding in a transaction amount that’s slightly different or a date that’s off by one day.
Preventing Discrepancies Before They Start
Once you’ve reconciled once, you don’t want to do it again — not the way you just did. Prevention is way better than hunting for problems.
The first thing: reconcile more often. Monthly reconciliation is standard, but if you’re having trouble, try weekly. It’s easier to find discrepancies when there’s less data to sort through. You’re looking at maybe 50 transactions instead of 500. The problem stands out faster.
Second, use bank feeds if your system supports them. Modern accounting software can pull transactions directly from your bank. You’re not typing them in manually, so you eliminate data entry errors. The transactions match automatically most of the time. You just need to review and approve them.
Third, document your process. Write down what you do each month. Create a checklist of where problems usually hide for your specific organization. Train your team on how to record transactions properly. When everyone knows the rules, fewer mistakes happen.
Fourth, set up alerts. Most banks let you configure notifications for large transactions, unusual activity, or when balances drop below a threshold. These alerts catch problems early instead of waiting until month-end.
Finally, review your internal processes. How are people requesting payments? How are they being approved? Is there a clear audit trail? When the process is clean and documented, discrepancies become obvious because they stand out from normal activity.
Tools That Make Reconciliation Easier
You don’t need fancy software, but the right tools save hours every month.
Spreadsheet Reconciliation Template
A well-built Excel or Google Sheets template with formulas does most of the matching for you. You import transactions from both sources and use VLOOKUP or INDEX/MATCH to find pairs. It’s not fancy, but it works and you control it completely.
Bank Feeds & Auto-Import
If your accounting software supports it (QuickBooks, Xero, Wave), set up direct bank feeds. Transactions pull in automatically, eliminating manual data entry and reducing errors. You’re just verifying and categorizing instead of entering everything yourself.
Accounting Software with Reconciliation Features
Dedicated reconciliation tools built into your accounting software make it visual and straightforward. You see matched pairs highlighted, unmatched items flagged, and the status of your reconciliation in real-time. It’s worth the investment if you’re doing this regularly.
Reconciliation Checklist & Documentation
Create a simple checklist in a document or shared drive. Step-by-step instructions, common problem areas, and who to contact if something’s wrong. This isn’t fancy, but it standardizes your process and makes training new team members much faster.
The Bottom Line
Payment reconciliation isn’t exciting, but it’s essential. You’ve got to know that your books match reality. When they don’t, you need a system for finding and fixing the problem fast.
Most discrepancies fall into predictable categories: timing issues, duplicates, fees, data entry errors, reversals, and missing transactions. Once you know where to look, you’ll spot them quicker each month.
Follow the seven-step process, invest in the right tools, and prevent problems before they happen. That’s how you go from dreading reconciliation day to handling it confidently. And when the auditors show up, you’ve got clean records and documentation to back everything up.
Start with monthly reconciliation. If you’re behind, catch up this month. Then commit to doing it every month going forward. It gets faster once you’ve got the rhythm down.
Disclaimer
This article is for informational purposes only and should not be considered financial, accounting, or legal advice. Payment reconciliation practices vary by organization, jurisdiction, and industry. Specific circumstances, regulatory requirements, and your company’s unique situation may require different approaches. Always consult with a qualified accountant, auditor, or financial professional before implementing new reconciliation processes or making significant changes to your financial procedures. The techniques and examples described here are general guidance based on common practices and are not guaranteed to solve all reconciliation issues.