A free Google Sheet: import one Settlement report and it explains every line, checks that the payout adds up, and flags fees that are higher than usual for the same SKU.
Runs in your own Google account. No Seller Central login, no add-on to install, no % of anything.
| Check | Result |
|---|---|
| Payout reported vs sum of all lines | Adds up |
| ORD-0007 · COASTER-SET4 FBA fee higher than usual for this SKU | +$0.37 |
| ORD-0023 · TUMBLER-20OZ Referral rate differs from usual | +$0.51 |
| ORD-0003 refund Admin fee higher than the $5 / 20% rule | +$4.10 |
| Estimated extra charged | $5.35 |
Open the sheet and choose File > Make a copy. It lives in your Google Drive; nobody else sees it.
Seller Central: Reports > Payments > All Statements > download the Flat File V2. In the Settlement tab: File > Import, "Replace data at selected cell".
Every flagged order line, what looks off, and the estimated amount, ready to take to Seller Support.
A flag is a question to ask Seller Support, not proof of an error. Thresholds are editable in the sheet.
Free, no sign-up. Supports settlements up to 10,000 lines. US-style amounts; for EU files set the sheet's locale to your country before importing.
Opens Google's "Make a copy" page. Nothing is shared with us.
We're building a version that pulls each settlement automatically and alerts you when a line looks off, for $29/month. After you try the sheet, tell us what it found below; that decides whether we build it.
Two minutes. The numbers come straight from the Findings tab. Email is optional unless you want the automatic version.
If you'd rather not set it up yourself, leave your email. We reply within one business day with a private way to send one Settlement Flat File V2 (no buyer names or addresses), run the same sheet on it by hand and send you the result. The file is deleted within 30 days.
An independent developer building tools for sellers who work in spreadsheets. Not affiliated with, endorsed or sponsored by Amazon.