How do I find and fix transactions that were recorded to the wrong account or category in my books?

What makes a transaction wrong rather than just unusual?

Every entry should rest on a document or a reason. IRS Publication 583 names paid bills, invoices, receipts and deposit slips among supporting documents, and says they support the entries in your books and on your tax return. A transaction is misclassified when its document or reason shows it is a different kind of item from what its account exists to hold, such as an internet bill in Meals or rent in Advertising. It is merely unconventional when another bookkeeper might have chosen a different account but yours holds that kind of item consistently. Leave those alone unless you are redesigning your categories on purpose, which is a separate question.

Never move an item because a report would read better. An entry moved without a document-based reason becomes the error, and it no longer agrees with the record that supports it.

Where should I look, and in what order?

Work through these places in order; the first surface whole runs of errors, the later ones single slips.

In QuickBooks Online, the account register is where you read an account line by line; Intuit's register help says it gives you the history of an account. The Transaction List by Vendor report with the Split column added shows which accounts each vendor's transactions went to, as Intuit's 1099 troubleshooting help describes.

A swing between periods is a lead, not a verdict. The PCAOB's auditing standard on analytical procedures, AS 2305, names among the conditions that can cause such variations "specific unusual transactions or events, accounting changes, business changes, random fluctuations, or misstatements." Only the document tells you which.

What changes when automation did the coding?

Automated coding produces patterns rather than one-off slips. Intuit's help on AI suggestions in QuickBooks Online says suggestions are based on the full bank description and your transaction history, and that QuickBooks suggests the categories you usually use for that vendor or customer. One wrong choice therefore tends to repeat. When you find one, search that payee back to its first transaction in your books, not only the period you are reviewing. Correct the occurrences in open periods, and list any dated on or before your lock date or in a period already reported for the closed-period decision.

How do I confirm an item really is in the wrong account?

Open each candidate's document: the receipt, bill, invoice or deposit slip. The document, not the report, decides where the item belongs. Then act on what it shows:

Log each confirmed item before changing anything: date, payee, amount, current account, correct account, the document and the reason. Save a copy of the profit and loss and balance sheet for the affected periods as well. The log becomes your checklist for a batch, your total for verification, and the explanation an accountant or reviewer needs when a large movement between accounts shows up later.

What must stay the same when I move an item?

Only the account changes, plus class or location if those are also wrong. The date, amount, payee and bank or card account stay exactly as they are. Intuit's reconcile-workflow help says you need to make sure the amounts match your real-life bank and credit card statements; the amount, date and bank account are what that match rests on. The date also fixes which period the item falls in, and the payee ties it to the supplier's records and to reports by payee.

That is why deleting a transaction and re-entering it in the right account is the wrong fix. Intuit's help on beginning-balance issues lists a reconciled transaction that "was edited, deleted, voided, moved, or unreconciled", and a categorized bank-feed transaction that was undone and sent back to pending, among the causes of a reconciliation that no longer starts where the last one ended. A re-entered copy is also a new record with no tie to the bank line or document behind the original.

This example shows one transaction before and after, with only the account moved:

Meals falls by 89.00 and Internet and phone rises by 89.00. Profit and the checking balance do not change.

How do I fix a single transaction?

In QuickBooks Online, Intuit's register help says to find and select the transaction in the account register to expand it, make changes to the available fields, and select Edit for anything grayed out, which opens the full transaction form. Change only the category on the line that is wrong; on a split transaction, leave the other lines alone. In other software, use that vendor's own help for editing a transaction's account; the same one-field rule applies.

How do I fix many transactions at once without sweeping up the wrong ones?

Intuit's help page on reclassifying multiple transactions says its tool moves several transactions to a different account, class or location at once, in QuickBooks Online Advanced and, through QuickBooks Online Accountant, for clients on any subscription. You choose Profit and Loss (income and expense accounts) or Balance Sheet (asset, liability and equity accounts), narrow the list with a date range and other details, select each transaction, and apply the new account, class or location. If you are on another plan and no accountant or bookkeeper works in your books through QuickBooks Online Accountant, correct items one at a time.

The same page lists what the tool will not change:

• Expenses. The account can move, but the bank or credit card account cannot.
• Invoices, sales receipts, checks and bills with products or services. Only the class can change, not the account.
• Billable expenses. The expense account can change, but not the account on the related income transaction.
• Inventory adjustments. Neither the account nor the class can change, because both are linked to inventory shrinkage and asset accounts.
• Payroll transactions. They cannot be changed in the tool and are managed in the payroll app.
• Moves into Accounts Receivable or Accounts Payable. You must assign a customer or vendor.

A batch tool applies the same change to everything selected, so the selection is the control:

1. Filter to one source account and, where you can, one payee, with a date range that starts after your lock date and after any period already reported.
2. Compare the selected items with your log and deselect anything you have not confirmed.
3. Note the count and total of the selection.
4. Apply the change, then run the checks below.

What if the item is reconciled, locked or already reported?

The state of the period decides what you may do:

For reconciled items, Intuit's beginning-balance help counts any edited reconciled transaction among the causes of a discrepancy, without setting apart an account-only edit, and says the beginning balance should match the ending balance of your last reconciliation. Check that after the change rather than assuming it. Before a batch that includes reconciled items, change one, save, and check that it still shows as reconciled in the account register's reconcile status column and that the next reconciliation's beginning balance is unchanged; batch the rest only if both hold.

For locked periods, Intuit's help on locking your books says you set a lock date, and anyone who tries to change or delete a transaction on or before it gets a warning or a password prompt, depending on your settings. Do not click through that prompt to make a correction. Whether a correction to a closed or reported period goes in that period or the current one, and what to do about statements already given out, is a separate question; settle it before moving anything dated there.

Which transactions carry links that moving the account leaves behind?

Moving the account alone can leave linked data pointing at the old treatment. Payroll transactions and inventory adjustments fall under the tool limits above. In QuickBooks Online, three more cases need care:

• Transactions with products or services. The reclassify page limits them to a class change. An item carries its own income account, and Intuit's help on changing an item's account covers only that income account, so do not change it to fix a check or bill line.

  That help says the option to update historical transactions updates all transactions that use the item, and that for inventory items the change also affects prior transactions. It does not say whether your lock date stops either, so assume both reach locked and reported periods, and settle the closed-period question before using them. To leave history alone, it says to create a new item with the correct income account and use it to replace the old one.

• Billable expenses tied to a customer. As the reclassify page says, the related income transaction keeps its account when the expense moves, so check it separately.
• Tax settings. The reclassify page lists only an account, class or location as what the tool applies, so a tax code or sales tax setting on the transaction stays as it was; check it separately. Settings keyed to the account work the other way: Intuit's 1099 troubleshooting help says QuickBooks uses the expense accounts you mapped to report 1099 transactions, so moving a contractor payment into or out of a mapped account changes what its 1099 reports pick up.

What changes when the move crosses the balance sheet and profit and loss?

Moving an item between two expense accounts changes what profit is made of, not profit itself. Moving it between an income or expense account and an asset, liability or equity account changes profit for that period by the full amount, and the balance sheet with it. Suppose a document shows that 1,200.00 your chart of accounts records as an asset was posted to an expense account. Editing the original transaction has this net effect; it is not a separate entry to post:

Profit for that period rises by 1,200.00, and total assets rise by the same amount. Re-run the profit and loss and balance sheet for every affected period, and list anything built on the old figures, such as statements given to a lender or partner or figures sent to your tax preparer. If the asset is one your accountant depreciates or writes off over time, tell them, because their schedule will not yet include it. If any of those periods were already reported, what to re-issue belongs to the closed-period question above. If you reconcile the balance-sheet account a move touched, confirm its next reconciliation still starts where the last one ended.

How do I check the result?

Run these checks in order once the corrections are in:

1. Re-run the detail for every account you moved items out of or into, over the dates you worked on. The count and total moved should match your log, and nothing should have moved that is not on it.
2. Re-run the profit and loss for each affected period, and the balance sheet where a move crossed statements. The differences from your saved copies should equal the moves you logged.
3. In QuickBooks Online, open the audit log, which Intuit's audit-log help says shows the date of each change, the user who made it and the original transaction details, and review every change made at the time of your batch.
4. Start the next reconciliation of every account you reconcile that a move touched (the item's bank or card account, and any balance-sheet account a move took an amount into or out of) and confirm its beginning balance still matches the last ending balance. If it does not, Intuit's beginning-balance help says the Reconcile Discrepancy Report lists what changed, how it affected your balance, and what you can do to fix each item.
5. Check the outputs tied to linked records: billable income, item-based reports and 1099 reports.

How do I stop the same mistake coming back?

A one-off slip needs only the fix. A pattern, where every occurrence of the same payee or description is wrong, needs the history corrected, in a batch if you have the tool, and then the thing that produces it changed; correcting the history, one at a time or in a batch, without changing what produced it means the pattern returns next period. Fix the source, which is usually one of these:

• A bank rule. Change or retire it; rule design is covered in the related question on bank rules.
• Learned suggestions. Intuit's AI suggestions help says you can always change the category and QuickBooks will learn for next time. It asks you to confirm or review a suggestion before posting when it shows a blue or orange signal; for a green checkmark, which means similar transactions have consistently gone to that category, its next step is to review any other required fields and post, and a repeated miscoding can earn that checkmark. For a payee you have just corrected, check the suggested category on each new transaction before posting, whatever the signal.
• An item's income account. Change it with the historical-update caution above, or replace the item.
• A recurring transaction. Correct its template, or it repeats the old account each time it runs.
• A person's habit. Give whoever codes the books a short list of regular payees and the account each belongs in, taken from your log.

Keep the log with the documents.