Bookkeeping and accounting services for Santa Fe and Northern New Mexico small businesses.

Call or Text: (505) 629-0818

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

What expenses should owner-operators track?

Owner-operators should track fuel, maintenance, insurance, truck payments, permits, tolls, meals, equipment, and professional services. Missing expense categories means overpaying on taxes and not knowing your true cost per mile.

Read answer

What is the best way to track crew labor hours by project?

Track labor daily using time tracking apps or paper timesheets with one person responsible for each crew. Capture hours by job and task type, and review entries weekly before closing them out.

Read answer

What is bank reconciliation and why does it matter?

Bank reconciliation is comparing your internal records to your bank statement to make sure they match. It catches errors, detects fraud, and ensures your books reflect your actual cash position.

Read answer

Do I need separate bookkeeping for each short-term rental?

It depends on your legal structure. If each property is in a separate LLC, yes. If they're all under one entity, you can use one set of books with class tracking to see each property's performance individually.

Read answer

How do I file New Mexico gross receipts tax?

File through the Taxpayer Access Point (TAP) portal after registering for a CRS number. You'll report gross receipts by location code and pay by the 25th of the following month.

Read answer

Do I need to charge GRT to out-of-state customers?

Generally, no. Sales of goods shipped outside New Mexico and services delivered to out-of-state customers are usually not subject to Gross Receipts Tax. The determining factor is where the product is delivered or where the service benefit is received.

Read answer

Focus Point Accounting provides bookkeeping and accounting services for small businesses across Santa Fe and Northern New Mexico. Led by Stephen Vigil, a Certified Internal Auditor with 20+ years of experience. We bring an auditor's precision to your financial records.

Client Reviews

5-Star Rated Firm
  • Certified Internal Auditor badge
  • Intuit Bookkeeping Certification badge
  • QuickBooks Online Certification Level 1 badge
  • Gusto Payroll Certification badge
  • Santa Fe Chamber of Commerce logo
  • Better Business Bureau badge

© 2026 Focus Point Accounting LLC