Elena Kritopulos
A bad QuickBooks setup does not announce itself. It just produces inaccurate reports, month after month, until a decision gets made on numbers that were never right. Here is what to look for.
It does not feel broken. It still runs. Reports still generate. Numbers still appear. Nothing throws an error message.
It just quietly produces inaccurate information every single month until someone catches it. And most people never do, not until their CPA spends three hours at tax time trying to reconcile reports that do not add up, or until they make a major business decision based on a profit margin that was never real.
I have seen this more times than I can count. A business running on a QuickBooks file that was set up fast, set up by someone who did not know the business, or set up years ago and never reviewed. Everything looks fine on the surface. Underneath, the categories are wrong, the opening balances are off, and the reports are telling a story that has nothing to do with what actually happened.
Here are the seven signs I look for when I do a file review. If any of these sound familiar, it is worth getting a second set of eyes on your books.
These are QuickBooks defaults that are supposed to be temporary. They are placeholders for transactions that need to be reviewed and assigned to the right category. If your chart of accounts still has significant balances sitting in these buckets, transactions have been stacking up unreviewed. Your expenses and income are being reported incorrectly, and your P&L is not accurate.
This is the most fundamental check in bookkeeping, and it is one of the most commonly missed. If your bank statement says one number and QuickBooks says another, the reconciliation has not been done properly, or at all. Every month that gap exists, the inaccuracy compounds. This is also one of the most common signs that a bookkeeper has been sending you reports without actually reconciling the accounts behind them.
A critical note: some bookkeeping services use batch imports and estimates to process your transactions faster. This means your books look reconciled without actually being reconciled. The only way to know is to check the reconciliation reports inside QuickBooks and confirm every account matches its statement.
A bloated chart of accounts is almost always a sign of a hasty or default setup. QuickBooks comes with a generic list of accounts that does not reflect how most small service businesses actually operate. If nobody customized it to your business, you have dozens of categories that do not apply to you, and your transactions are probably being dumped into whatever seemed closest at the time.
A clean chart of accounts for a service business might have 30 to 50 well-defined categories. If yours has 200, something went wrong early and was never fixed.
Opening balances are the starting point for your books, the amounts in each account on the day you started using QuickBooks. If these were entered incorrectly, or if they were never entered at all, every report generated from that point forward is built on a false foundation. This is one of the hardest problems to fix retroactively because it requires going back to the original source documents and reconstructing the starting point from scratch.
Moving from spreadsheets, Wave, FreshBooks, or another accounting system to QuickBooks without a proper migration creates gaps. Transactions from before the switch are not in QuickBooks. The beginning of the year does not match the actual beginning of the year. Comparative reports, this year vs. last year, are meaningless because the data only goes back to whenever the migration happened.
Some difference between profit and cash is normal. Timing of payments, owner distributions, and loan repayments all affect it. But if your P&L says you made $80,000 last year and your bank account barely moved, something in the setup is producing incorrect numbers. Common culprits include transactions being coded as transfers instead of expenses, owner draws being counted as business costs, or income being double-counted due to how your payment processor is connected.
This one is so normalized that most business owners have stopped questioning it. But it should not be a normal part of year-end. If your CPA is spending time every year reorganizing your books before they can work on your taxes, it means the underlying setup or the ongoing maintenance is producing something that does not meet the standard needed for tax preparation. That cleanup time is billed to you at CPA rates, typically $150 to $300 per hour, for work that should have been done by your bookkeeper throughout the year.
"Professional accountants report spending 20 to 40% of their time fixing bookkeeping errors during tax preparation. Those correction hours come at $150 to $300 per hour." Industry estimate, multiple sources
Start with a file review. A QBO-certified bookkeeper can go through your file, identify where the issues are, and give you a clear picture of what needs to be fixed and in what order. Most reviews take a few hours and give you a prioritized list of what is actually wrong versus what is just a cosmetic issue.
If the issues are significant, incorrect opening balances, years of uncategorized transactions, reconciliations that were never done, that is a cleanup project. The work is not glamorous but the outcome is real: reports you can trust, a CPA who does not need to fix things before they can file, and financial numbers you can actually use to run your business.
The goal is not perfect books for the sake of perfect books. The goal is reports that reflect what actually happened in your business, so that the decisions you make from them are based on something real.
Most of the founders I talk to who have a setup problem did not create it on purpose. They started QuickBooks themselves when they were starting the business, or they hired someone cheap to set it up and never had it reviewed. By the time they realize something is off, months or years of transactions have been categorized incorrectly.
The good news is it is fixable. It always is. The question is just how long you want to keep making decisions on numbers that are not telling you the truth.
Book a free discovery call with Elena to see how KeepBookers can support your business.