Duplicate row finder
Identify matching source rows without deleting or merging any record.
Match groups
1- Rows in groups
- 2
- Additional matching rows
- 1
Illustrative calculation · AUD where amounts are shown.
| Match group | Source row | Reference | Date | Staff | Item | Category | Amount | Tax | Reported commission |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2 | S-101 | 2026-09-21 | Mia Chen | Cut and finish | Service | 220.00 | 20.00 | 80.00 |
| 1 | 5 | S-101 | 2026-09-21 | Mia Chen | Cut and finish | Service | 220.00 | 20.00 | 80.00 |
See how the number is made.
Matching rows are candidates for review, not proof of a duplicate sale. An invoice can legitimately contain two identical items. Compare the source line identifier and original report before excluding a row. Quoted cell content is parsed before comparison.
The working
Group rows whose chosen field values match; show every source row in each group.
The sample repeats S-101. Both rows appear in the same match group, and the tool reports one additional matching row.
- Compared columns: Reference, Date, Staff, Item, Amount. Matching ignores letter case and repeated whitespace.
- These are candidates, not confirmed duplicate sales. No source row has been removed.
Use the calculation basis and rules you have agreed. A tool result is a working record; it does not establish an entitlement or send a payment.