Why won't my QuickBooks balance sheet reconcile?
A balance sheet that won’t balance usually traces back to a handful of common problems. The fix depends on identifying which one you’re dealing with.
Opening Balance Equity is the first place to look. When QuickBooks creates certain accounts or when bank connections are set up, it posts offsetting entries to Opening Balance Equity. This account should eventually be zeroed out by journaling those amounts to the correct equity accounts. If your Opening Balance Equity shows a balance other than zero, that’s often the culprit. Check when those entries were created and what accounts they relate to.
Deleted or modified reconciled transactions are another frequent cause. If someone deletes a transaction that was already reconciled, or changes the amount after reconciliation, QuickBooks doesn’t automatically flag the problem. Your reconciliation history might show everything as cleared, but the underlying numbers no longer match. Run an Audit Log report filtered by deleted transactions to see if this happened.
Duplicate entries from bank feeds create discrepancies that can be hard to spot. This happens when someone manually enters a transaction and then the bank feed imports the same transaction again. Both hit the books, so your bank account balance looks right when you reconcile, but other accounts are doubled up. Look for transactions on the same date for the same amount hitting the same vendor or customer.
Journal entries with errors cause balance sheet problems when they don’t truly balance or when they hit the wrong account types. A journal entry might look balanced in the entry screen but if an account was misclassified as an expense when it should be a liability, the balance sheet suffers. Review your journal entries, especially any made by people unfamiliar with QuickBooks setup conventions.
Undeposited Funds is worth checking if you record customer payments. Payments go to Undeposited Funds first, then get grouped into bank deposits. If payments are recorded but never deposited, you’ll have an inflated balance in Undeposited Funds that doesn’t match reality. Open that account and look for old payments sitting there.
To investigate, run a Balance Sheet Detail report for the period in question. Look at each account balance and drill down into the transactions. The account that’s off will usually become obvious when you see the individual transactions that make up the balance.
If you can’t find the problem or the discrepancy goes back multiple periods, it might be faster to have a QuickBooks bookkeeper in Santa Fe review your file. Untangling months or years of accumulated errors takes time, and fixing things incorrectly can make it worse. Sometimes a fresh set of eyes catches what you’ve been staring past.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
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 handle payroll taxes in New Mexico?
Register with the IRS for an EIN and with New Mexico agencies for withholding and unemployment. You'll withhold federal and state income taxes plus FICA, then file and deposit on schedule.
Read answerWhat bookkeeping software is best for real estate investors?
QuickBooks Online works well for most real estate investors because it handles multiple properties, tracks income and expenses at the property level, and produces the reports your accountant needs at tax time. Purpose-built options like Stessa or REI Hub are simpler if your portfolio is strictly rentals.
Read answerHow do I set up a chart of accounts in QuickBooks?
QuickBooks generates a default chart of accounts when you create a company file. Start with the defaults, then customize by adding accounts specific to your business and making unused accounts inactive.
Read answerHow do I track subcontractor costs in QuickBooks?
Set up subcontractors as vendors, use projects or classes to assign every bill to a specific job, and enter bills when you receive invoices rather than when you pay. This gives you accurate job costing and simplifies 1099 prep at year end.
Read answerHow do I find a bookkeeper familiar with New Mexico taxes?
Look for someone who regularly files GRT returns for New Mexico clients. Ask about their experience with location codes, combined reporting, and the state's unique tax structure. Local referrals from CPAs or other business owners are your best starting point.
Read answerHow do I prepare my rental property books for my CPA?
Your CPA needs income and expense totals by property, categorized correctly for Schedule E. Separate each property in your records, distinguish repairs from improvements, and have mortgage statements and receipts ready.
Read answer
