Skip to content
Tutorials Center
My learning

Topics

Lesson 33 of 36 ยท Accounting Practices

Fixing Mistakes and the Audit Log

Correct QuickBooks mistakes safely: edit, void or delete, credit memos, reclassifying, undoing a reconciliation, and using the audit log and user roles to keep books trustworthy.

Everyone makes bookkeeping mistakes: a wrong category, a duplicate bill, a payment applied to the wrong invoice. What matters is fixing them in a way that leaves a clear trail and does not break other records. QuickBooks gives you several tools, and choosing the right one depends on whether the transaction affects a closed period, a reconciled account or a customer's statement.

QuickBooks cannot run on this site. The TryIts are JavaScript stand-ins that model the decisions and a simple audit log, not QuickBooks code.

Choose the least destructive fix

Work from the mildest correction to the strongest:

  1. Edit: change the category, date, amount, memo or customer on the transaction itself. Best for current-period typos. QuickBooks recalculates everything and records the edit in the audit log.
  2. Reclassify: move many transactions from one account to another at once (QuickBooks Online Accountant, Gear icon > Reclassify transactions). Good for a bulk category change.
  3. Void: the transaction stays in the books with an amount of zero. It preserves the document number and a visible record. Use it for checks and invoices that were never delivered or were issued by mistake.
  4. Delete: removes the transaction. Use it for duplicates and entries that should never have existed. It is allowed only if no payments or links depend on it, and not for reconciled items without consequences.
  5. Credit memo, refund or journal entry: the right answer when the original transaction was real and a customer or vendor already has it. Never delete an invoice you sent; issue a credit memo (or refund) so there is a paper trail on both sides.

Void for a record that happened but should not count. Delete for a record that never should have been created. When unsure, void: you can always delete later, but you cannot undelete (though the audit log still shows it).

flowchart TD
    A["Mistake found"] --> B{"Was it sent to a customer or vendor, or already paid?"}
    B -- Yes --> C["Credit memo, refund or bill credit"]
    B -- No --> D{"Wrong details only?"}
    D -- Yes --> E["Edit"]
    D -- No --> F{"Should it exist at all?"}
    F -- "Kept as a record" --> G["Void"]
    F -- "Duplicate" --> H["Delete"]

A quick guide to choosing a correction.

Common fixes

  • Wrong category on an accepted bank-feed line: open the transaction in Banking > Categorized, Undo, then re-categorize; or edit the category on the expense.
  • Duplicate bill or expense: delete one (after confirming nothing is paid against it). If one of them was matched to a bank line, undo that match first.
  • Payment applied to the wrong invoice: open the payment, unselect the wrong invoice, tick the right one, and save.
  • Customer overpaid: record a credit or a refund, or apply it to the next invoice.
  • Deposit categorized as income when it was a transfer: delete or fix the transaction and record a transfer instead, so income is not overstated.
  • Reconciled transaction needs changing: first consider whether it is necessary. If so, edit carefully, then re-run Reconciliation discrepancy report and fix the account. If an entire reconciliation is wrong, use Undo in Reconcile > History by account.
  • Closed period: QuickBooks warns you. Do not change a closed period without asking your accountant; the correct fix may be an adjusting entry in the current period.

The audit log

The Audit log (Gear icon > Audit log) records who did what and when: created, edited, deleted or voided a transaction, changed a setting, logged in or invited a user. For each event it shows the user, date and time, the type of event and, for edits, the before and after values.

Use it to answer questions such as who deleted that invoice?, when did this amount change? and did my accountant adjust this entry? You can filter by user, date range, event type or transaction type. There is also the report Reports > Audit log and Transaction list with splits in some editions.

Pair the audit log with user roles: give each person their own login with the least access they need (for example, a clerk who can enter bills but not change bank accounts or see payroll), never share one login, and review the list of users periodically. Only the master admin should manage billing and add admins. Turn on multi-factor authentication for all users.

JS A tiny audit log

Press Run (or Ctrl + Enter) to see the console output here.

No output.

JS Which correction fits?

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Prevent mistakes

Use bank rules sparingly at first, reconcile monthly, restrict who can edit old periods, and keep a note when you fix something unusual. A short memo such as "Reclassified from Supplies per Jan review" saves hours later.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. You emailed an invoice to the right customer with the wrong amount. What is the cleanest fix?

    Once a document reached the customer, the correction should leave a visible trail, through a credit memo or a clearly communicated edit.
  2. 2. What does voiding a check do?

    A voided transaction stays on file for the sequence and audit trail but no longer affects balances.
  3. 3. What does the audit log record?

    The audit log tracks user activity and, for edits, before and after values.
  4. 4. Why should each person have their own QuickBooks login?

    Separate logins make the audit log meaningful and let you apply least-privilege roles.

Summary

  • Prefer the mildest fix: edit, then void, then delete; use credit memos for documents others have seen.
  • Be careful with reconciled and closed periods.
  • The audit log shows who changed what and when; pair it with roles and separate logins.
  • Add memos to unusual corrections.

Next: Project: Books for a Small Service Business