Your copy. Your pace.
Duplicate transaction triage
Use a suspected duplicate in an import or ledger read to create a reviewer decision linked to the candidate records. The design keeps source references, uncertain matches, and approval decisions visible to the responsible accountant. It coordinates an administrative handoff with version checks and an exception queue. A suspected duplicate must never be deleted or reversed automatically.
1. Define the starting point
Start with a suspected duplicate in an import or ledger read. A successful handoff produces a reviewer decision linked to the candidate records. Define the accountable owner before connecting systems. A suspected duplicate must never be deleted or reversed automatically. A source event is a request to evaluate the current state; it is not permission to make an irreversible change.
2. Walk through the process
1. Read the candidate set
Scope the company, account, period, and import source using read-only access.
2. Calculate similarity
Compare stable external IDs, amount, date, and source checksum. Separate exact repeated imports from lookalikes.
3. Assemble evidence
Show source references, destination IDs, and any existing reconciliation or approval.
4. Request accountant decision
A reviewer distinguishes legitimate recurring transactions, duplicates, and unresolved cases.
5. Record the outcome
Create a correction task where needed; ledger edits require their own authorized process.
3. Check the information
Use invented references in this worksheet. Keep real documents and personal records in an appropriate private system.
| Reference field | Working record | Check |
|---|---|---|
| company_id | company_id | Resolve the stable source reference in the correct client, entity, and engagement. |
| transaction_ids | transaction_ids | Resolve the stable source reference in the correct client, entity, and engagement. |
| source_import_key | source_import_key | Resolve the stable source reference in the correct client, entity, and engagement. |
| review_outcome | review_outcome | Use the authorized owner or reviewed decision; unknown values stop the handoff. |
4. Verify the process
Use synthetic examples. Mark a check only after recording what actually happened.
5. Decide the next step
Retain qualified professional review for legal, accounting, tax, medical, financial, or other consequential decisions. This workbook does not certify compliance or guarantee results.