Keep missing transfers separate from amount mismatches.

In this synthetic ecommerce workbook, 25 source rows contain 24 unique orders. The checks isolate:

one exact duplicate;

two missing reported transfers;

a $12.50 shortfall across the matched orders.

Separating those exceptions makes it easier to see what needs checking. The original rows stay available, formulas are editable, and unresolved values remain flagged.

This is a demonstration with invented transactions, not a client case study: https://docs.google.com/spreadsheets/d/1tLA0h1dCYXhK-Xf-uCh3gN9EMYgdHu4E/edit

I offer a $75 CSV/Excel cleanup for one table of up to 1,000 rows: agreed duplicate/date/number checks, a cleaned copy, and an exceptions/change log. One correction round is included, with delivery within two business days after we agree the inputs, scope and payment terms.

Message me here on Contra with the file type, row count and what looks wrong. Please keep personal/customer data out of public comments.