If Your QuickBooks Numbers Feel Off, It's Usually One of These 10 Things
- Aug 25
- 5 min read
Updated: 6 days ago
You open QuickBooks to check one number, and forty minutes later you are still in there — chasing a balance that doesn't look right, wondering when the last reconciliation actually happened, and quietly deciding to deal with it later.
I see the same handful of problems every single month. Not because business owners are careless, but because QuickBooks lets you keep working while things quietly go sideways. Here are the ten we clean up most often, and what you can do about each one.
1. Duplicate vendors
What happens: You end up with "ABC Supply," "ABC Supply Inc," and "A.B.C. Supply" — so your spending on that vendor is split three ways and never looks as big as it is.
The fix: Run the Vendor Contact List, sort alphabetically, and look for near-matches. Merge the duplicates into the spelling you want to keep, then set a rule that only one person adds new vendors.
2. Misclassified expenses
What happens: Equipment purchases land in Supplies. Meals land in Office Expense. Your P&L looks fine and your tax return is wrong.
The fix: Pull a Profit & Loss Detail for the year and scan the accounts you use most. Anything that makes you say "that's not right" gets reclassified now, not in March.
3. Undeposited Funds piling up
What happens: Payments get received but never grouped into an actual bank deposit, so Undeposited Funds swells into a number that means nothing and your income gets counted twice.
The fix: Open the Undeposited Funds register and match each item to a real deposit on your bank statement. Going forward, always record deposits the same way you make them at the bank.
4. Payroll liabilities that never clear
What happens: The balance sheet shows payroll taxes owed from two years ago, usually because the tax payment was entered as a check or an expense instead of a liability payment.
The fix: Compare the liability balances to your filed 941s and state returns. This is one to handle carefully — a wrong entry here can look like unfiled or unpaid payroll taxes, and that gets the IRS's attention.
5. Bank feeds that don't match the register
What happens: Downloaded transactions get "added" instead of "matched," so every transaction exists twice — once from your entry and once from the bank.
The fix: Always look for a match before you add. If you already have duplicates, filter the register by amount and date to find the pairs and delete the extras.
6. Old uncleared transactions
What happens: Checks from 2022 still sitting uncleared, deposits in transit that never came in. Your book balance and your real cash never agree.
The fix: Review anything uncleared over 90 days. Void what was never cashed (with the correct date, so you don't change a closed year), and correct the entries that were simply wrong.
7. A chart of accounts that doesn't fit the business
What happens: Either 300 accounts nobody uses, or six accounts that tell you nothing. Both make your reports useless for decisions.
The fix: Trim the accounts you would actually look at to run the business, and use classes or items — not new accounts — when you want detail by job, location, or service line.
8. Sales tax collected but not tracked as a liability
What happens: Sales tax gets booked into income, so revenue looks inflated and the money you owe the state isn't sitting anywhere on the balance sheet.
The fix: Turn on the sales tax feature, set the right rates and agencies, and reconcile the sales tax payable balance to your filed returns each quarter.
9. Personal expenses and owner draws mixed in
What happens: The truck payment, the phone bill, the occasional Amazon order — all coded to business expense accounts. It inflates deductions and it is exactly what an auditor looks for.
The fix: Separate the accounts entirely if you haven't. For anything already in there, reclassify it to Owner's Draw or Distributions and let your accountant decide what is legitimately deductible.
10. Stale invoices and unpaid bills
What happens: Accounts Receivable shows customers who paid you months ago, and Accounts Payable shows bills you already wrote a check for.
The fix: Run the A/R and A/P Aging Detail reports. Apply the payments that were never applied, and write off what you know you'll never collect.
What this actually changes
Clean books are not about having a tidy file. They're about what a tidy file gives you:
Numbers you trust. You can quote a job, hire someone, or buy equipment without guessing.
A shorter, cheaper tax season. No scrambling in March to explain a balance from last May.
Fewer letters from the IRS and the state. Most notices we resolve started as a bookkeeping error, not fraud.
Your evenings back. You stop doing data entry at 9:00 p.m. and stop thinking about it on Sunday.
Where to start
If you're already a client of ours, you are further along on this list than you think. We reconcile your bank accounts and send you the uncleared items every month — those old checks and deposits sitting out there. All that's left on your end is a quick look: tell us which ones were never cashed, which ones need to be voided, and which are still legitimately outstanding. Send it back and we clear them out of the file.
Your A/R and A/P aging reports come to you monthly for the same reason. Mark the invoices customers have already paid, the bills you've settled, and anything you know you'll never collect or that should be voided, then send it back to us. We'll make the corrections on our end. Ten or fifteen minutes of your review is usually all it takes to keep both sides current — and it's far easier than untangling three years of it later.
If you're not working with us yet, pick one thing and look at it. Reconcile last month's bank account, or run your A/R Aging, or open Undeposited Funds. You'll know within ten minutes whether this is a small tidy-up or something bigger. And if it looks worse than you expected — that's a normal place to land, and it's the point where most of our clients call. We do one-time cleanups to get the file right, and monthly bookkeeping so it stays that way. Some owners hand it all off; others just want us on call when QuickBooks does something they can't explain. Either is fine.
Who we are
Business Advisory Services, LLC has worked with small business owners in Wisconsin and the surrounding states for more than twenty years — bookkeeping, payroll, taxes, and tax resolution when things have gone further than a cleanup. We work in QuickBooks every day, which is how we know these ten so well.
Let's take a look at it
If you want a second set of eyes on your file, call 608-831-4900 ext. 801 or reach us through quickbooks-anywhere.com. We'll look at where things stand and tell you honestly whether you need a full cleanup, a few corrections, or nothing at all. No pressure either way.
Comments