Clean-up
Bookkeeping cleanup before tax season: how to fix a messy QuickBooks
The file never tells you it is wrong. It just shows a profit nobody can explain.
If your QuickBooks balance does not match the bank statement, the file needs a cleanup before the year closes, and the time for that is now, not February. October gives you two things February cannot: room to fix one month at a time without rushing, and a number you trust when the December decisions come up, like equipment purchases, bonuses and distributions. In February the same correction becomes an emergency, and emergency work inside tax season is the most expensive hour of the year.
This is for the owner who opens QuickBooks every month and no longer trusts what it shows. If your case is different, entire months with nothing posted, start with the article on books that are months behind. To see the work itself, look at bookkeeping cleanup and QuickBooks cleanup.
How the file tells you something is wrong
None of these signs shows up as an error message. QuickBooks closes the month the same way whether the number is right or wrong. What changes is what the report starts telling you. Before opening transaction by transaction, check the seven signs below, because each points at a different cause and asks for a different fix.
| Symptom | What is usually behind it |
|---|---|
| The QuickBooks balance does not match the statement | A reconciliation closed with a difference, or a transaction posted after the month was already reconciled. The gap does not clear itself, it gets pushed into the next month. |
| Undeposited Funds with a growing balance | The customer payment landed there and the bank deposit was booked as fresh income. The same sale counts twice on the P&L, the profit and loss report. |
| Opening Balance Equity with any balance at all | Someone typed an opening balance when the file was set up, or forced an adjustment to make a month close. After setup this account should sit at zero. |
| Uncategorized Income and Uncategorized Expense | Bank feed transactions accepted without picking a category. The money is recorded, but the P&L does not say what it was, and the deduction disappears along the way. |
| The same expense shows up twice | The bank feed, the automatic bank connection, imported the expense and someone also entered it by hand. The cost doubles and profit shrinks for no real reason. |
| An open invoice for a customer who already paid | The deposit came in as loose income, never applied to the invoice. Accounts receivable shows money nobody owes, and the reminder goes to the wrong customer. |
| Personal spending mixed into the company | The company card paying for groceries, the personal card paying a supplier. Each case becomes an owner draw or a reimbursement, and the wrong category changes the year result. |
These signs almost never travel alone. A file with inflated Undeposited Funds usually also has open invoices for customers who already paid, because both come from the same habit: booking the bank deposit as new income instead of applying it to the payment already on record.
Why October costs less than February
CPA time is not bookkeeper time
When the file reaches the accountant broken in February, they fix it, or their team does, in the middle of the busiest season of the year. And they bill accountant hours to do bookkeeper work. Same task, priced at the higher rate. Arriving clean, the accountant does only what only they can do: compute and file.
The December decision depends on today's number
December concentrates decisions: buy equipment this year or wait, pay bonuses, take a distribution, pull an expense forward. All of them depend on knowing the real result so far. With a broken file, the owner decides by the bank balance, and a bank balance is not profit. It can be customer money paid in advance or an invoice still waiting. Whoever finds out the result in March finds out after the window closed.
January arrives with a queue already formed
January is not an empty month. The 1099-NEC, the form that reports payments to contractors, is due January 31. In Florida, the LLC annual report on Sunbiz opens January 1 and closes May 1, with a 400 dollar penalty for missing it. Federal deadlines follow right behind: March 15 for S corporations and partnerships, April 15 for individuals and calendar year C corporations. Fixing twelve months of file in the middle of that stacks work on top of deadlines.
The order of the work, most recent month backwards
In a cleanup, order is not a detail of method. Fixing one account moves the balance of another, and touching them in the wrong order forces a redo. The sequence below exists so you do not do the work twice.
- Export today's picture. Year to date P&L and Balance Sheet, before a single adjustment. It is your before and after, and it is what the accountant will want to see.
- Count what exists. How many bank accounts, cards and payment platforms are connected to the file, including the ones closed mid year.
- Reconcile the last closed month. If the balance matches on the last day of the month, everything in between is right. If it does not, the difference points exactly where to look.
- Work back month by month. Each reconciled month pushes the error backwards, and the previous month gets easier, because the remaining gap is already smaller.
- Only then touch the problem accounts. Undeposited Funds, Opening Balance Equity and uncategorized get resolved after reconciliation, never before, because fixing one changes the balance of the others.
- Fix the bank rules. One wrong automatic rule recreates the same error by itself next month. Cleaning without reviewing the rules means cleaning twice.
- Close the year and install the routine. With the year reconciled, it is the monthly close that holds the file. Without a routine, you redo this whole list next year.
If the correction touches a number from a year already filed, stop before adjusting and talk to your accountant. They decide whether the return needs correcting. GS Brasil organizes the books and hands over verified material, it does not compute or file taxes.
What changes once the file is clean
The cleanup is not an end in itself. It exists to give back five things the broken file had taken from you.
- The P&L becomes a decision tool. With revenue and expense in the right category, you can see which service, job or client pays for itself.
- The accountant bills less rework. The package arrives closed, with each reconciliation report and a list of what was adjusted. Fewer questions, fewer hours.
- Deductions stop disappearing. An uncategorized expense is one the accountant cannot classify, and what cannot be classified tends to be left out.
- The bank talks to you again. A credit request or a line of working capital starts with a consistent P&L and Balance Sheet. Without them the conversation does not even open.
- The next year starts right. A correct opening balance on January 1 is what keeps the mess from starting over.
Frequently asked
Questions on this topic
Is there still time to do the cleanup before year end?
It depends on three numbers: how many months are wrong, how many accounts and cards exist, and the transaction volume per month. Those define the size of the job. Gathering them takes one conversation, and that is what separates a real timeline from a guess.
Is it better to clean the file or start a new QuickBooks?
Starting fresh looks faster and almost never is. A new file needs correct opening balances, which are exactly what is wrong, and you lose the history you compare against. That decision comes out of the diagnosis, aligned with your accountant.
Do I need to tell my accountant before correcting anything?
If the correction touches a year already filed, yes. Your accountant or CPA decides whether the return needs an amendment. GS Brasil does not compute or file taxes, it organizes the books and hands over material ready for them to work with.
My bookkeeper reconciled everything. Can it still be wrong?
It can. A reconciliation closed with a difference shows as reconciled in the system and stays wrong in the balance. That is why a cleanup starts by checking each reconciliation report, not the status QuickBooks shows on screen.
Are cleanup and catch-up bookkeeping the same thing?
No. In a cleanup the months are posted but wrong. In catch-up entire months were never posted at all. Many companies have some of both, and the diagnosis shows which one weighs more.
Keep reading
Related
Bookkeeping cleanup
What a books cleanup is and what it delivers at the end.
QuickBooks cleanup
Fixing the file that is in use and does not match the bank.
Books behind: what to do
The path when entire months of closing are missing.