The short answer: Fix miscategorized transactions by editing the category in open periods and posting a dated journal entry for closed periods. Never touch the amount, date, or bank account on a reconciled item. A reclass between two expense accounts leaves the reconciliation intact. A $270 change to a cleared amount opens a $270 difference on the next statement.
- Reconciliation ties the bank side of an entry to the statement. The offsetting account is not part of that tie, so recategorizing is safe.
- In the worked example, moving $46,800 of software subscriptions out of cost of revenue lifts gross margin from 61.2% to 62.7% on $3.1M of revenue.
- Set the closing date to the last reconciled and reported month-end, and require a password for any change behind it.
- The IRS says to keep records 3 years in the common case and 6 years when unreported income exceeds 25% of gross income. A fix must leave an audit trail, not erase one.
Last updated September 2026.
Old and miscategorized transactions distort margins long after the month they landed in. In the worked example below, 187 of 2,340 transactions sit in the wrong account, and most fall in months that were reconciled and reported long ago. The temptation is to open each one and fix it in place. Do that to a reconciled amount and the next reconciliation inherits the difference.
The method below corrects the reports without disturbing the reconciliations underneath them, and it keeps the trail the IRS expects businesses to retain for 3 to 7 years.
Can you edit a transaction that has already been reconciled?
Yes, and that is the risk. The ledger lets you change a reconciled transaction, but the reconciliation only holds while the bank side stays as it cleared. Reconciliation matches the amount, date, and bank or card account of each entry to the statement. The category on the other side of the entry is not part of that match.
So the rule splits in two. Changing the category of a reconciled $1,250 payment from cost of revenue to software expense leaves the reconciliation intact, because $1,250 still cleared the bank on the same day. Changing the amount to $1,520 breaks it. The next reconciliation opens with a $270 difference, the exact size of the edit.
Moving the date across a statement boundary does the same damage. Deleting the item removes a cleared entry and opens a difference for the full $1,250. Our bank reconciliation worked example shows how one of these differences surfaces and how long it takes to trace.
Which miscategorized transactions should you fix by editing, and which by journal entry?
Edit when the period is open and the bank side stays put. Post a journal entry when the period is closed, or when the fix would change a cleared amount or date. A period counts as closed once its statements have gone to a lender or a board, or a tax return has been filed on them. The table below is the decision rule applied on every cleanup file.
| Situation | Method | Why |
|---|---|---|
| Wrong expense account, open period, bank side unchanged | Edit the category on the transaction | Reconciliation untouched; the report is right at the source |
| Wrong expense account, closed period | One journal entry dated the first day of the open period, memo naming the months it corrects | Issued statements stay as issued; the cumulative balance is right |
| Wrong amount or date on a reconciled item | Leave the item; book an adjusting entry for the difference and fix the source document | Editing opens a reconciliation difference equal to the change |
| Duplicate reconciled transaction | Reverse it with an offsetting entry; do not delete | Deleting removes a cleared item and opens a difference for its full amount |
| Bank feed rule misfiring | Fix the rule first, then batch-reclass the open-period items it touched | Otherwise the same error posts again next month |
| Owner spending booked as expense | Reclass to a draw or distribution account (journal entry if closed) | Restores true operating expense and equity |
Why do bank feed rules and owner spending cause most miscategorized transactions?
Because both repeat every month without anyone looking. Two of the rows above carry most of the volume. Bank feed rules misfire quietly. A rule sending every card-processor payout to the wrong income account for 9 months, at 12 payouts a month, produces 108 miscategorized transactions from one setting. Fix the rule before the transactions or the error recurs. Owner spending is the other, and it belongs in equity, not on the income statement.
How do you clean up old transactions in QuickBooks without redoing the books?
Work from the reports down to the transactions, not the other way round. Run a profit and loss by month for the full span and read across each row for a month that breaks the pattern. Suppose a software line runs about $3,900 a month, then shows $0 for four months while cost of revenue rises by the same amount. That is a categorization error with a date range attached.
Then triage by period. Anything in an open period gets fixed at the transaction, in batches by vendor, so the report is right at the source. Anything in a closed period gets one reclassifying journal entry dated the first day of the current open period, with a memo that names the months it corrects.
Finish by re-running the profit and loss and every prior reconciliation report. Each one should still show a difference of $0.00. This is the transaction-level pass inside the wider step-by-step QuickBooks cleanup. Account-level problems, such as negative balances and stale receivables, are covered separately in our guide to balance sheet cleanup.
What does a worked reclassification look like?
Take a $3.1M revenue services company with 14 months of books: 12 months closed and reported to a lender, 2 months open. Of 2,340 transactions, 187 sit in the wrong account, or 8.0%. The largest group is a software subscription of $3,900 a month posted to cost of revenue for all 14 months, $54,600 in total. The figures are illustrative; the arithmetic transfers to any file.
Reported cost of revenue for the 12 closed months is $1,202,800, a 61.2% gross margin on $3.1M. The closed months hold 12 × $3,900 = $46,800 of the misposted subscription. Moving it out brings cost of revenue to $1,156,000, and gross margin to ($3,100,000 − $1,156,000) ÷ $3,100,000 = 62.7%. That is a 1.5-point change from one reclass.
The fix takes two motions. One journal entry dated the first day of the open period debits software expense and credits cost of revenue for $46,800, with a memo naming the 12 months. The remaining 2 × $3,900 = $7,800 in the open months is edited at the transaction, since nothing on the bank side changes. Every one of the 14 reconciliations still shows a $0.00 difference.
When should you use a journal entry instead of editing history?
Use a journal entry whenever the period is closed, and whenever a fix would change a reconciled amount or date. Editing history rewrites statements that other people already hold. A journal entry dated in the open period corrects the cumulative balance, leaves the issued statements as issued, and carries a memo that explains what it fixes.
The accounting standard points the same way. Under ASC 250, an error material to previously issued financial statements is corrected by restating those statements, a controlled disclosure rather than a quiet edit. An immaterial error may be corrected in the period it is found.
Tax follows its own test. A reclass between two deductible expense accounts changes no line of taxable income. Moving an owner’s personal spending out of deductions does, and the tax preparer should evaluate an amended return.
Recordkeeping argues against deletion for the same reason. The IRS instruction is direct: “Keep records for 6 years if you do not report income that you should report, and it is more than 25% of the gross income shown on your return.” Bad debt and worthless-securities claims extend that to 7 years. A journal entry with a memo keeps the trail. A deleted transaction erases it.
How do you protect closed periods with a closing date and password?
Set the ledger’s closing date to the last month-end that is both reconciled and reported, and require a password for any entry dated on or before it. Whether the ledger calls it a closing date, a lock date, or a period close, the discipline is the same. Move the date forward once a month, on the day the close packet ships, and never move it backward.
Then read the exceptions report at each close. Any entry that crossed the closing date under the password is either a deliberate prior-period correction, which should carry a memo, or a mistake, which should be reversed. Aaron Ressel signs off the closing-date change on every Debit & Co. cleanup before the file returns to a monthly rhythm.
That rhythm is the Continuous Close Method™: reconcile as transactions land, close inside 5–7 business days, and lock the period behind you. Miscategorized transactions stop accumulating when every month is reviewed within the month. The routine that keeps a cleaned file clean sits in our guide to the monthly bookkeeping routine after a cleanup.
Frequently asked questions
How do I clean up old transactions in QuickBooks?
Start from a profit and loss by month for the full span and look for a month that breaks the pattern in any line. Triage each error by period. Fix open-period items at the transaction, in batches by vendor, and correct closed-period items with one journal entry dated the first day of the open period. Re-run every prior reconciliation report afterward; each should still show a $0.00 difference.
Can you edit a transaction that’s already been reconciled?
You can change the category safely, because reconciliation matches only the bank side of the entry: amount, date, and bank or card account. Changing any of those three, or deleting the item, opens a difference on the next reconciliation equal to the change. A reconciled $1,250 payment edited to $1,520 creates a $270 difference.
How do you fix wrongly categorized transactions from closed periods?
Post one reclassifying journal entry dated the first day of the current open period. Debit the correct account and credit the wrong one for the closed-period total, with a memo naming the months it corrects. In the worked example that is $46,800 across 12 months, moved from cost of revenue to software expense, lifting gross margin from 61.2% to 62.7%.
When should you use a journal entry instead of editing history?
Whenever the period is closed, meaning statements have gone to a lender or board or a tax return has been filed on them. Also whenever a fix would change a reconciled amount or date. Under ASC 250, a material error in issued statements is corrected by a restatement; an immaterial one may be corrected in the period found. A dated journal entry with a memo does that without rewriting history.
How do you protect closed periods with a closing date and password?
Set the closing date to the last month-end that is both reconciled and reported, and require a password for any entry dated on or before it. Move the date forward once a month when the close packet ships. Review the exceptions report at each close so that any entry that crossed the date is either a documented correction or gets reversed.
