QuickBooks Online · 6 minute read
I have cleaned up a lot of QuickBooks files over twenty years, and the same five problems turn up in almost every one. None of them look like emergencies. That's exactly why they're expensive — each one quietly distorts the numbers you're using to price work, chase payment, and decide whether you can afford to hire.
Here they are, what each one actually costs a service business, and how to fix it yourself.
What I see. A card that started out as the business card but now buys groceries on Saturdays. Or the reverse: materials bought on a personal card during a busy week and never recorded at all.
What it costs. Your profit margin is wrong, in both directions. Personal spending inflates expenses and understates profit, so you look less profitable than you are — which matters the day a lender or bonding company asks for statements. Business spending on a personal card means real deductions you never claimed. And at year end, your CPA charges you to untangle it, usually at a higher rate than a bookkeeper would.
The fix. Disconnect personal cards from the bank feed entirely. If a personal purchase does slip through, don't delete it — record it as an Owner's Draw so the money is accounted for and the books still reconcile. Going the other way, reimburse yourself properly rather than letting the expense vanish.
What I see. The bank feed looks tidy, everything's been categorized, so reconciliation feels like paperwork for its own sake. It gets skipped for a month, then a quarter.
What it costs. Reconciliation is the only step that proves your books match reality. Without it, duplicate entries, missing deposits, and bank errors sit undetected. I have found the same invoice entered twice, months apart, in books that looked perfectly organized. If you're in construction, this is also how a deposit on a job gets counted as revenue twice.
The fix. Reconcile every account — checking, savings, every credit card, and any loan — against the actual statement, every month. If QuickBooks shows a difference that isn't zero, don't force it. Find it. A forced reconciliation hides the problem rather than solving it, and it compounds.
What I see. Software subscriptions, merchant processing fees, equipment, and subcontractor payments all defaulting into "Office Expenses" or sitting in "Uncategorized Expense" because a bank rule was set up once and never checked.
What it costs. Your Profit & Loss becomes decorative. You can't see your true cost of goods sold, which means you can't see your real gross margin, which means you're bidding and pricing on a guess. For a contractor this is the difference between knowing a job made money and assuming it did. For a professional services firm it hides how much of your revenue is being eaten by software and processing fees.
The fix. Build bank rules deliberately, one vendor at a time, and review them quarterly as vendors change. Treat "Uncategorized" as a to-do list, not a resting place. And make sure subcontractor payments are coded to a cost of goods account, not a general expense — that single change often reveals a margin nobody knew they had.
What I see. Invoices go out, and then nobody looks at them again until cash gets tight.
What it costs. Unpaid invoices are an interest-free loan you didn't agree to make. Service businesses are especially exposed here, because you've already paid for the labor and materials before the client pays you. I have watched profitable companies come close to missing payroll while sixty thousand dollars sat in receivables nobody had chased.
The fix. Open the A/R Aging Summary weekly. It takes two minutes and it tells you exactly who owes what and for how long. Turn on automatic reminders in QuickBooks Online for past-due invoices so the first nudge isn't a phone call you're dreading. And if you bill progressively, make sure retainage is tracked as its own receivable rather than quietly written off.
What I see. The bank feed suggests a match, the suggestion looks close enough, and a month of transactions gets accepted in one sitting.
What it costs. Auto-add is confident and frequently wrong. It creates duplicates when a payment was already recorded manually, and it assigns income to whatever account it saw last time. Because these entries look legitimate, they're hard to spot later — usually surfacing during a cleanup, sometimes after a tax return has already been filed on the wrong numbers.
The fix. Review before you accept, particularly on anything where money came in. Then build a short monthly close routine: reconcile every account, read the P&L against last month, and investigate anything that moved more than you'd expect. Fifteen minutes a month prevents most of what I get paid to clean up.
None of these are accounting errors exactly. They're what happens when bookkeeping is something you get to after the real work is done. The fix in every case is a routine rather than an expertise — the same handful of checks, on the same day each month.
If you read this and recognized three of the five, that's normal, and it's fixable. If you recognized all five, your books are probably telling you something that isn't true, and it's worth finding out what.
I'll take a look and tell you straight. Fifteen minutes, no cost, no obligation — you'll get an honest read on where your books stand whether or not we work together.
Regina · RMD Premium Bookkeeping · QuickBooks Online Level 2 Certified · QuickBooks Online Payroll Certified