You're closing the month, you run the bank reconciliation in QuickBooks Online, and the numbers don't match. The difference might be $14.50 or it might be $14,000 — either way, bank reconciliation discrepancies mean something in your books doesn't reflect reality. For professional services firms managing retainers, progress billing, and multiple bank accounts, reconciliation discrepancies are more than an inconvenience — they're a signal that financial data you're using for decisions may be wrong.
This guide walks through the most common causes of bank reconciliation discrepancies, a systematic process to resolve them, and the prevention strategies that keep your books clean month after month.
A reconciliation discrepancy is the difference between your bank statement ending balance and the cleared balance in your accounting software (QBO, Xero, etc.) for the same period. When these two numbers don't match, it means transactions recorded in one system aren't reflected — or are reflected differently — in the other.
The goal of bank reconciliation is simple: prove that every dollar moving through your bank account is accurately captured in your books. A discrepancy of even $1 means that proof is broken.
Note: A discrepancy is not always an error. Timing differences — like outstanding checks or deposits in transit — are expected. The problem is when you can't explain the difference.
After reconciling thousands of accounts for professional services firms, we've identified the causes that show up most frequently. Here they are, ranked by how often we encounter them.
| # | Cause | Frequency | Typical Dollar Impact |
|---|---|---|---|
| 1 | Missing transactions (not recorded in QBO) | Very common | $50 – $10,000+ |
| 2 | Duplicate entries | Very common | Exact 2x of original amount |
| 3 | Timing differences (outstanding checks) | Common | Varies — resolves next period |
| 4 | Bank fees and service charges | Common | $10 – $200/month |
| 5 | Incorrect transaction amounts | Moderate | Transposition errors ($540 vs. $450) |
| 6 | Deposits in transit | Moderate | Varies — resolves next period |
| 7 | Voided or deleted checks not adjusted | Moderate | Full check amount |
| 8 | Interest income not recorded | Occasional | $5 – $500/month |
| 9 | Wrong bank account (recorded in wrong register) | Occasional | Full transaction amount |
| 10 | Prior period adjustments or edits | Occasional | Any amount |
The most frequent cause. A wire transfer, ACH payment, or automatic debit hits your bank but was never entered in QBO. This is especially common with payroll tax payments, loan auto-debits, and merchant processing fees that don't flow through the bank feed.
This happens when you manually enter a transaction AND it also imports through the bank feed. The bank feed shows a match suggestion, but someone clicks "Add" instead of "Match." Result: the same expense or deposit appears twice. The discrepancy equals the exact amount of the duplicated transaction.
Outstanding checks are checks you've written and recorded in QBO, but the recipient hasn't cashed them yet. They appear in your books but not on the bank statement. This is a normal reconciling item — not an error — but you need to track them.
Monthly maintenance fees, wire transfer fees, overdraft charges, and check printing costs appear on the bank statement but are easily missed in QBO. For firms with multiple accounts, these can add up to $200-500/month in unrecorded expenses.
Transposition errors (typing $5,400 instead of $4,500) and decimal errors ($150 instead of $1,500) create discrepancies that are maddening to find because the transaction exists in both places — just at different amounts.
Deposits in transit work like outstanding checks in reverse. Voided checks that aren't properly reversed in QBO leave phantom balances. Interest income is typically small but adds up over time. Wrong account recording happens when firms have 3+ bank accounts and someone posts a transaction to the operating account instead of the trust account. And prior period edits — someone changing a transaction date after reconciliation — can unreconcile months that were previously balanced.
When you hit a discrepancy, resist the urge to make a "reconciliation adjustment" — that just buries the problem. Instead, follow this systematic process.
Open the reconciliation window in QBO and confirm that the beginning balance matches the prior month's ending bank statement balance. If the beginning balance is off, someone edited or deleted a previously reconciled transaction. You'll need to fix that month first.
Print (or export) the bank statement. Go through each line item and verify it exists in QBO with the correct date, amount, and payee. Mark each one as you go. Any unmarked items on either side are your discrepancy sources.
In QBO, sort the register by amount and look for identical entries on nearby dates. You can also run the Transaction Detail by Account report for the bank account, sorted by amount, to spot duplicates quickly.
Pull up last month's reconciliation summary. Any outstanding checks or deposits should have cleared this month. If they still haven't cleared, investigate — a check outstanding for 90+ days may need to be voided.
If your discrepancy is divisible by 9, you likely have a transposition error (e.g., $54 - $45 = $9). This is a classic bookkeeping trick: divide the discrepancy by 9 — if you get a whole number, search for two digits that are swapped.
If you can't find the discrepancy in the target account, check whether a transaction was posted to the wrong bank register. This is particularly common at law firms with separate operating and trust (IOLTA) accounts.
Pro Tip: If the discrepancy equals a round number ($100, $500, $1,000), check for bank fees, tax payments, or loan auto-debits that were deducted from the bank but never recorded in QBO.
The best reconciliation is a boring one — where everything matches on the first pass. Here's how to get there.
Reconcile every bank and credit card account within 5 business days of the statement closing date. The longer you wait, the harder discrepancies are to trace. We've seen firms go 6-12 months without reconciling, turning a $50 fix into a $5,000 cleanup project.
Bank feeds in QBO are a massive time-saver, but they create duplicates when you're not careful. Establish a clear workflow: either enter transactions manually and match to the feed, or let the feed create transactions and review before confirming. Never do both simultaneously.
In QBO, set a closing date after each reconciliation to prevent anyone from editing transactions in reconciled months. Go to Settings > Advanced > Accounting > Close the books and set a password.
The person entering transactions shouldn't be the same person reconciling. At smaller firms, this isn't always practical — which is one reason outsourcing the reconciliation function adds both accuracy and a layer of oversight.
Keep a running log of outstanding checks and deposits in transit. At month-end, update the log and investigate anything that's been outstanding for more than 60 days.
Most reconciliation discrepancies are honest mistakes — a missed entry, a duplicate, a timing issue. But persistent or unexplained discrepancies can indicate more serious problems:
Critical: If you find transactions on your bank statement that no one in your organization authorized, contact your bank immediately and engage a forensic accountant. Time is critical for recovering funds.
A clean reconciliation is the foundation of trustworthy financials. When your bank balance and your books agree every month, you can confidently use your P&L and Balance Sheet for pricing decisions, hiring plans, and partner distributions.
When they don't agree, nothing else in your financial reporting can be trusted.
If your firm has fallen behind on reconciliations or you're dealing with discrepancies that span multiple months, the most cost-effective solution is often to bring in a professional bookkeeping team that specializes in your industry.
Need help getting your books reconciled? Steph's Books provides monthly bank reconciliation services for professional services firms — including cleanup of historical discrepancies. Schedule a free consultation to get started.
Get a free quote and see how Steph's Books can save you 40-60% vs hiring in-house.
