Amazon Settlement Decoder

Amazon's take rate — referral plus FBA fulfilment fees as a share of principal sales this month, from the settlement flat file — with everything else Amazon charged beside it.

$17one-time · VAT included · no subscription

Free files

BLIKPrzelewy24VisaMastercardApple PayGoogle PayPayPal

✓Download page opens right after payment + links by e-mail. No account.

✓Excel 2016+ / Microsoft 365 · Google Sheets (upload to Drive)

✓Light + Dark · USD GBP EUR AUD CAD INR · PLN pricing — every edition in one download

✓Free updates forever · 14-day refund

Part of the Complete Collection — 119 workbooks, every edition, future releases, $99.

The ritual page

What the file tells you

The settlement flat file has forty columns and the truth. Paste it and the sheet classifies every line — principal, referral, FBA, shipping chargebacks, promotions, refunds and the fees Amazon keeps on them, storage, advertising, subscription — into one take rate and one net per unit for your pricing.

01 · verdictFees — referral + FBA vs what you priced for; everything Amazon charged

02 · verdictRefunds — refund rate, the 20% referral fee Amazon keeps, the FBA fee never returned

03 · verdictAds & storage — advertising and storage deducted from the settlement, subscription and inbound

Sheets in the workbook

✓Report · take rate, net per unit, three verdicts, six months, three tasks

✓Paste · the settlement flat file V2 in its column order; every line classified and flagged

✓Months · twelve months of sales, referral + FBA, take rate, refunds, ads, storage, net paid out, units

✓Settings · the take rate you priced for and the limits you tolerate

How it works

1Set what you expect — take rate, refund, ads and storage limits — once

2Paste the settlement — Payments → All Statements → Flat File V2 → paste the rows

3Open Report — take rate, net per unit, three verdicts, three tasks — ten minutes per settlement

Who it is for

FBA sellers who know their revenue and have never seen their net per unit.

Dark edition included

Amazon Settlement Decoder — dark edition

Do I need Excel?

Excel 2016+ or Microsoft 365. Or upload the .xlsx to Google Drive — it opens in Sheets with formulas and charts intact.

Can I pay with BLIK?

Yes — BLIK, Przelewy24, any card, Apple Pay, Google Pay and PayPal. Prices in PLN, EUR, USD or GBP; the currency switch is at the top.

Invoice for my company?

Tick “I’m purchasing as a business” at checkout and enter your NIP / VAT ID. The invoice arrives with the download e-mail.

What if it isn’t for me?

14-day refund, no questions. One e-mail to [email protected].

Pairs well with

More Sellers files →