How do you identify and fix duplicate transactions causing discrepancies in reports?

• A. Delete all duplicates.
• B. Do nothing and leave the duplicates as-is.
• C. Search for duplicates, delete or modify duplicates, then re-run reports and reconcile to confirm.
• D. Re-enter all data to replace duplicates.

Answer: (C)

Duplicates pull reports out of alignment, so the right approach is to locate them, remove or adjust the duplicates, then re-run the reports and reconcile to confirm the figures now align with the source data. Start by identifying where duplicates are showing up—look for transactions that have the same date, amount, vendor or customer, and description. QuickBooks’ reports and audit trail tools help spot these common duplicates, and filtering by date or amount can reveal patterns.

Once you’ve found the duplicates, delete or modify them as appropriate. The goal is to remove the extra entries that double-count amounts while preserving valid transactions. After cleaning up, re-run the relevant financial reports (like the profit and loss and balance sheet) and perform a reconciliation to ensure the totals now reflect reality and agree with source documents. This final check helps confirm that the discrepancy is resolved.

Deleting all duplicates without review isn’t safe because some may be legitimate repeats (for example, legitimate multiple invoices or payments). Doing nothing leaves the discrepancy in place, and re-entering all data is unnecessary and risks introducing new errors. The careful identification, correction, and rechecking process ensures accuracy and a clean audit trail.