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
How do I set up direct deposit for my employees?
Start by choosing a payroll provider that supports ACH direct deposits, then collect authorization forms from each employee with their bank details. Connect your business bank account to the payroll system and allow time for account verification before running your first payroll.
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 answerHow do I handle sales tax on food and beverage sales?
Most states tax prepared food while exempting or reducing rates on grocery items. You need to know your local rates, configure your POS system correctly, and file on time to avoid penalties.
Read answerHow far back should I fix my bookkeeping records?
Three years is the practical minimum because it matches the standard IRS audit window. Going further back depends on your specific needs like selling the business, getting a loan, or investor due diligence.
Read answerWhat are the common bookkeeping mistakes dental offices make?
Dental offices commonly fail to reconcile insurance payments to EOBs, let patient AR age without follow-up, and mix personal expenses with practice accounts. These mistakes hide revenue leaks and distort profitability.
Read answerHow much does a bookkeeper cost for a small business?
Small business bookkeeping typically costs $200 to $600 monthly for basic services. The actual price depends on transaction volume, industry complexity, and which services are included beyond basic monthly books.
Read answer

