How do I clean up my books?
Excite Tax's order is statements, then balances, then categories. Collect every statement, make each account's books agree with its statement month by month, and only then recategorize. The full order is below.
How do I clean up messy books?
Excite Tax's answer for Utah owners: IRS Publication 583 counts account statements as expense records, so reconcile every account to its statements first, then fix the categories.
Short answers
Why does my bookkeeping show negative balances?
Usually because something was entered twice, entered on one side only, or never given a starting balance. When the books show a bank account below zero and the bank says it never was, the books are wrong, not the bank. The common causes and fixes are in the table below.
My accounting system is a mess: where do I start?
Start with the bank account the business uses most, and its oldest month that does not match the statement. Leave the chart of accounts, the reports and the software settings alone until that account reconciles. The triage is here.
Should I clean up my books before starting Profit First?
Yes. Profit First allocates real revenue into separate bank accounts, so it needs a revenue number and bank balances that are true. Reconcile first; otherwise the allocations start from a figure that was never real. More below.
Should I fix the old file or start a new one?
Fix it if returns were filed from it, because the filed numbers have to tie to something. A fresh file works only from a clean starting point, such as the first day of a year whose opening balances already agree with the bank statements and the last return filed.
The cleanup order
Messy books have two kinds of problem: transactions that are wrong (missing, doubled, in the wrong month) and transactions that are right but labelled wrong. Fixing labels first is wasted work, because a later reconciliation deletes or moves half of what was relabelled. Do it in this order.
- List every account the business used: bank accounts, credit cards, loans, merchant processors and payment apps.
- Download every statement for each of them since the month the books were last right. Publication 583 lists account statements among the documents that support expenses.
- Set each account's opening balance in the books to the balance on the first statement. Most negative balances start here.
- Reconcile each account, oldest month first, until the statement and the books agree. Do not start the next month until this one ties.
- Delete duplicates, enter what is missing, and record transfers between the business's own accounts as transfers, not income or expense.
- Only now fix categories. Personal spending becomes an owner draw, not an expense, and a loan payment is split into principal and interest.
- Move sales tax collected out of income and into a liability account (see In Utah).
- Match the larger expenses to a receipt or invoice, because proof of payment alone does not establish a deduction.
- Close and lock each finished period so nobody edits it later by accident.
Why the statements come first
When you receive your bank statement, make sure the statement, your checkbook, and your books agree.
A bank statement is the one record in a messy file that someone else kept. It says what actually cleared, in what amount and on what date. When the books agree with it, every total built on them is at least complete; when they do not, no amount of recategorizing makes the profit figure right. That is why the IRS says to reconcile each month and why a cleanup starts with the oldest month that does not.
Some differences are timing, not errors. A statement can differ from the books because of bank charges not yet entered, deposits made after the statement date, and checks that have not cleared. Those are listed on the reconciliation and left alone. Everything else is a mistake to fix.
Negative balances: what they mean and how to fix them
A negative balance is the books telling you the entries do not add up. In double-entry books total debits must equal total credits, and if they do not, there is an error to find and correct. A negative on an account that cannot be negative, such as cash in a bank that never went overdrawn, points to the same kind of error.
Common negative balances in small-business books
| Account showing negative | Usual cause | Fix |
|---|---|---|
| Checking account | The same payment entered twice, from the bank feed and by hand, or no opening balance | Reconcile to the statement; delete the duplicate; enter the opening balance |
| Credit card | Payments to the card recorded, charges never imported | Import the card's statements and reconcile the card like a bank account |
| Accounts receivable | Customer payments recorded against invoices that were never entered | Enter the invoices, or record the deposits as sales if the business does not invoice |
| Accounts payable | Bills paid by check or transfer without being matched to the bill | Match each payment to its bill instead of posting it straight to expense |
| Sales tax payable | Tax paid to the state, tax collected recorded as income | Record tax collected to the liability so the payment clears it |
| Loan | The whole payment posted against the loan, interest included | Split each payment into principal and interest using the lender's statement |
| Inventory | Items sold that were never recorded as bought | Enter the purchases, then count what is on hand |
Worked example: a doubled rent payment
Publication 583's own journal example is a $780 October rent payment, debited to rent expense and credited to cash. Suppose the bank feed imports that $780 payment and someone also types it in by hand. Rent expense is now overstated by the same $780, cash in the books is understated by it, and if the account held less than that on the day, the books show a negative balance the bank never did. The reconciliation finds it: the books show two payments where the statement shows one. Delete the manual entry, and the expense, the cash and the profit are all right again.
Where to start when the accounting system is a mess
A messy system usually means one of three things: the bank feed is connected twice or its rules post everything to the wrong place, the chart of accounts has grown to dozens of near-duplicate categories, or nobody has reconciled for so long that the opening balances are fiction. Tackle them in that order.
- Turn off automatic rules and check that each bank and card is connected once. A doubled feed makes every other fix pointless.
- Pick the most-used bank account and reconcile its oldest bad month. Then the next account.
- Merge near-duplicate categories into one list short enough to read on a single screen. A chart of accounts guide shows a sensible starting set.
- Leave the reports alone until the accounts reconcile. A profit and loss statement from unreconciled books is a guess with a layout.
The law does not demand a particular system. The IRS accepts any recordkeeping system that clearly shows income and expenses, so the goal of a cleanup is books that do that, not books that use every feature of the software.
Cleaning up before Profit First
Profit First is a cash-management method: revenue lands in one account and is swept into separate accounts for profit, owner pay, tax and expenses. It runs on real revenue and real bank balances. Starting it on messy books means the percentages are applied to income that includes transfers, loan proceeds or sales tax, and the tax account ends up funded from a figure that was never profit. Clean up first, at least through the last completed month, and start the method from a reconciled balance.
The paperwork that backs a cleanup
Publication 583 names sales slips, paid bills, invoices, receipts, deposit slips and canceled checks as the supporting documents behind the entries in the books. Missing a canceled check is not fatal: an account statement showing the amount, the payee and the posting date can prove payment. It proves payment, not purpose, so a receipt or invoice still matters for anything large or unusual.
Owner spending needs its own treatment. The IRS says to write checks to yourself only when withdrawing from the business for personal use, which is why personal spending found in a cleanup is recorded as a draw rather than an expense. If personal and business spending share an account, the cleanup is slower, and keeping the business account separate is the fix going forward (more on that).
In Utah
(d) A seller is not required to maintain a separate account for the tax collected... (e) Taxes collected by a seller pursuant to this chapter shall be held in trust for the benefit of the state
Utah treats sales tax a seller collects as held in trust for the state, and the same statute says a seller need not keep a separate account for it. So the cleanup has to separate it in the books: tax collected goes to a sales-tax liability, not to sales, and each return's payment clears that liability. Returns are due the last day of the month after the filing period, so a cleanup that finds tax booked as income also shows how much of the balance was never the business's money.
Keeping the books clean afterwards
Reconcile every account each month, close the month, and lock it. A month-end close checklist covers the rest. If the mess is years deep rather than months, the catch-up guide covers which year to rebuild first.
When to hand this to a preparer
Hand the books over when keeping them costs more hours than the business can spare, or when they stop agreeing with the bank.
Excite Tax keeps these books; the return they feed is reviewed and signed by a licensed CPA at TBD CPA LLC.
Sources
- IRS Publication 583 (12/2024), Starting a Business and Keeping Records · retrieved September 2026
- Utah Code § 59-12-107(3)(d)-(e) (effective 7/1/2025), Collection, remittance, and payment of tax by sellers · retrieved September 2026
- Utah State Tax Commission, Sales and Use Tax · retrieved September 2026
Ranked and explained on the sources page.