— For the multi-unit controller, analyst, or CTO
What completeness checks catch a missing store, duplicated file, or omitted payout before the dollar reconciliation begins?
How to find duplicate or missing marketplace settlements
A total can look reasonable even when one store is missing and another file was loaded twice. Build a completeness manifest listing platform, legal entity, store ID, statement or payout ID, covered dates, file name, row count, and a file hash when available. Reject duplicate IDs or hashes and flag gaps in expected weekly or monthly coverage.
Compare the active-store master with the stores present in each close. Then reconcile dollars. Completeness is a separate control because no amount of accurate arithmetic can recover a file that was never included.
— Field checks
- 01Create the source-file manifest.
- 02Test unique payout IDs and file hashes.
- 03Compare expected stores and periods with received coverage.
— Evidence to keep
- • Active store-platform master
- • Raw file manifest
- • Expected settlement calendar
Sources checked August 21, 2026. Independent operational guidance—not marketplace-endorsed legal, tax, or accounting advice. Read the evidence and corrections standard.
— More answers