Why is QuickBooks showing a different number than my bank account?
The most common reason is timing. QuickBooks might include transactions that haven’t cleared your bank yet, like checks you’ve written but recipients haven’t cashed or deposits that are still pending. Your bank statement only shows what has actually posted. So both numbers can be technically correct while looking completely different.
Bank feed issues are another frequent culprit. If you have bank feeds enabled, QuickBooks automatically downloads transactions from your bank. Sometimes transactions download twice, especially if you also enter them manually before they clear. Other times transactions fail to download or land in the wrong account. Any of these situations creates a mismatch that grows over time if you don’t catch it.
Check for unreconciled transactions. When you reconcile in QuickBooks, you’re matching your records to the bank statement and confirming they agree. If you haven’t reconciled recently, discrepancies pile up without any way to spot them. Regular reconciliation is how you find problems while they’re still easy to trace back to the source.
Opening balance problems show up more often than you’d expect. If your QuickBooks setup started with an incorrect opening balance, every report since then has been off by that amount. This happens frequently when someone connects a bank account without entering the correct starting figure or imports historical data that doesn’t match reality.
To find the discrepancy, run a reconciliation in QuickBooks and look at the uncleared transactions. These are items recorded in QuickBooks that haven’t been matched to the bank statement. Compare your actual bank statement line by line against what QuickBooks shows. The mismatch is usually hiding in plain sight once you look transaction by transaction.
If the difference is small and appeared recently, it’s often a timing issue that resolves itself in a day or two when pending transactions clear. If it’s a round number like $500 or $1,000, look for a missing or duplicate transaction in that amount. If it’s an odd number that’s been sitting there for months, you likely have an opening balance problem or a past reconciliation that was forced to balance without actually finding the issue.
A Richmond bookkeeper can help you track down stubborn discrepancies and set up your reconciliation process so these problems get caught early. The longer a mismatch sits unresolved, the harder it becomes to trace back to the original cause.
Greater Richmond's Small Business Bookkeeper
The Next Step:
A Short Conversation
Fifteen minutes to tell us what you're dealing with. We'll let you know how we can help and give you a clear price quote.
More Questions
Can you help me migrate from QuickBooks Desktop to QuickBooks Online?
Yes, we regularly help businesses migrate from Desktop to Online. The process involves transferring your data, cleaning up historical entries, and getting you comfortable with the new system.
Read answerHow much does it cost to clean up messy books?
Cleaning up messy books typically costs $500 to $3,000 for most small businesses. The actual price depends on how far behind you are, transaction volume, and whether documentation still exists.
Read answerI'm months behind on my bookkeeping. Where do I start?
Start by gathering all your bank and credit card statements for the missing months. Check for urgent deadlines like quarterly taxes or pending loan applications, then work through reconciliation one month at a time starting with the oldest.
Read answerHow do I set up job costing in QuickBooks Online?
Enable the Projects feature in QBO Plus or Advanced, then configure your chart of accounts to track costs by category. The software setup is straightforward but the structure you choose determines whether your job reports are actually useful.
Read answerWhat's the best way to track costs for each project?
The best approach is capturing every cost as it happens and assigning it to the right project in your accounting system. This means tracking labor hours, materials, subcontractor bills, and direct expenses separately for each job so you know your actual profit margin on every project.
Read answerHow do I handle progress billing in QuickBooks?
Enable progress invoicing in QuickBooks settings, then create invoices from estimates for partial amounts. The feature is straightforward but only works well if your estimates are accurate and you track costs alongside billings.
Read answer
