PayoutSheet Get the free sheet
For Amazon sellers who run their numbers in Google Sheets

Know exactly why your Amazon payout is what it is.

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.

Findings tab · example settlement
CheckResult
Payout reported vs sum of all linesAdds 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

How it works

1

Make your copy

Open the sheet and choose File > Make a copy. It lives in your Google Drive; nobody else sees it.

2

Import one Settlement report

Seller Central: Reports > Payments > All Statements > download the Flat File V2. In the Settlement tab: File > Import, "Replace data at selected cell".

3

Read Findings

Every flagged order line, what looks off, and the estimated amount, ready to take to Seller Support.

What the sheet checks

  • That the payout Amazon reports equals the sum of every line in the report
  • Where the money went: every transaction type and charge, totalled
  • FBA fulfilment fee per unit above the usual fee for the same SKU in that settlement
  • Referral fee rate that differs from the usual rate for the same SKU
  • Refund administration fees above the lesser of $5 or 20% of the referral fee
  • Profit per SKU, once you enter your unit costs

A flag is a question to ask Seller Support, not proof of an error. Thresholds are editable in the sheet.

What it doesn't do (yet)

  • Connect to your Seller Central account (you import the report yourself)
  • Know each SKU's official size tier; it compares against what you were charged for that SKU
  • Track returns that never came back, or file claims for you
  • Replace your accountant or bookkeeping software

Get the free 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.

Want it to run by itself?

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.

Tell us what the sheet found

Two minutes. The numbers come straight from the Findings tab. Email is optional unless you want the automatic version.

Rather have us check it?

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.

Who is behind this?

An independent developer building tools for sellers who work in spreadsheets. Not affiliated with, endorsed or sponsored by Amazon.