Why are my QuickBooks accounts not reconciling?
The most common cause is duplicate transactions. If you manually entered something and it also came through the bank feed, both are sitting in your register. QuickBooks doesn’t automatically combine them unless you match them. The same expense shows twice, throwing off your ending balance by exactly that amount.
Check your bank feed for unmatched transactions. QuickBooks will often suggest a match if a manual entry already exists. If you’ve already added the bank feed transaction as new instead of matching it, you’ll need to find and delete the duplicate.
A wrong starting balance creates ongoing problems. When you first connected your bank account or started reconciling, QuickBooks needed a correct starting point. If that number was off, every reconciliation afterward will be off by the same amount. Compare your first reconciliation’s starting balance to an actual bank statement from that period.
Transactions dated in the wrong period cause issues too. An expense dated December 31 but actually processed January 2 will show up in the wrong month’s reconciliation. Check transactions near the end of the statement period to make sure dates match when the bank actually cleared them.
Deleted or modified transactions after you’ve already reconciled can reopen old differences. QuickBooks marks reconciled transactions with a small R. If someone changes or removes a reconciled transaction, the previously balanced period becomes unbalanced. Run the Reconciliation Discrepancy report to see if any reconciled transactions were modified.
Small charges like bank fees, monthly service charges, or interest often get overlooked. These hit your bank account but might not come through automatically depending on your bank feed setup. Check your statement for anything under $20 that might not have been recorded.
Outstanding checks and deposits create timing differences. You wrote a check on January 28, but it didn’t clear until February 5. During January reconciliation, that check should remain outstanding. Only mark transactions that actually cleared during the statement period you’re reconciling.
The fix depends on how far back the problem goes. If reconciliations have been off for months, cleanup takes longer. Sometimes adjusting for the difference and starting fresh with correct processes is faster than hunting down every historical error.
Regular reconciliation prevents most of these issues. Monthly is the minimum, weekly is better. Working with a small business bookkeeping service that handles monthly reconciliation catches errors before they compound into bigger problems.
If reconciliation constantly frustrates you, the issue might be how your QuickBooks was configured originally. A proper chart of accounts and correctly connected bank feeds make the process straightforward. QuickBooks setup and training done right from the start saves hours of frustration every month going forward.
The Merrimack Valley's Trusted Accounting Partner
The Next Step:
A 15-Minute Call
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
What is the cost of outsourcing payroll for a small business?
Most small businesses pay $50 to $200 per month for outsourced payroll, depending on employee count and pay frequency. Pricing typically includes a base fee plus a per-employee charge, with extras like multi-state filings adding cost.
Read answerHow do I handle IFTA reporting for multi-state trucking?
Track miles driven and fuel purchased by state throughout each quarter, then file one consolidated return with your base jurisdiction. The key is having systems that capture jurisdiction-level data automatically rather than reconstructing it at filing time.
Read answerCan a bookkeeper help me if I'm behind on quarterly estimated taxes?
A bookkeeper helps by getting your books current so you know your actual income and can calculate what you owe. They provide the foundation your tax professional needs to determine estimated tax amounts and catch-up payments.
Read answerHow do I create a budget for my small business?
Start with your historical financial data or realistic projections, separate fixed and variable expenses, then build in revenue targets and review monthly. A budget only works if you actually compare it to what happened.
Read answerWhat are the business tax requirements in Massachusetts?
Massachusetts businesses face several tax obligations including entity-level taxes, sales tax collection, payroll withholding, and annual reporting. The specific requirements depend on your business structure and activities.
Read answerWhat is the difference between bookkeeping and accounting?
Bookkeeping is recording and organizing financial transactions. Accounting is analyzing that data, preparing tax returns, and providing strategic guidance. Most small businesses need both, just at different levels.
Read answer

