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 records do I need to keep for my small business?
Keep financial records, tax documents, employment files, business formation papers, contracts, and insurance policies. Most tax-related records should be kept for seven years, while formation documents and insurance policies should be kept permanently.
Read answerShould I migrate from QuickBooks Desktop to QuickBooks Online?
It depends on how you work and what features you rely on. QuickBooks Online offers cloud access and easier collaboration, while Desktop provides more robust tools for inventory and job costing.
Read answerWhat are the signs that my business needs professional bookkeeping help?
Common signs include not knowing your actual profitability, falling months behind on reconciliations, dreading tax season, and spending hours on books instead of running your business. If your CPA is charging extra to clean up your records, that's a clear signal.
Read answerHow did the Wayfair decision change sales tax requirements?
Before 2018, you only collected sales tax in states where you had physical presence. The Wayfair decision let states require collection based on economic activity alone, typically once you exceed $100,000 in sales or 200 transactions.
Read answerHow do I choose between QuickBooks Online and QuickBooks Desktop?
For most small businesses today, QuickBooks Online is the better choice. It offers cloud access, better integrations, and automatic updates. Desktop still makes sense for specific situations like complex manufacturing or construction with heavy job costing needs.
Read answerWhat tax deductions are available for healthcare practices?
Healthcare practices can deduct most operating expenses including medical equipment, clinical supplies, staff wages, rent, insurance, and professional services. The key is tracking everything properly and knowing which industry-specific deductions apply to your practice type.
Read answer

