Complete Collection — every workbook for $99|Pay with BLIK · Przelewy24 · card · Apple Pay · Google Pay
tintedcells
PL Cart · 0
Home › Catalog › Sellers › Amazon Settlement Decoder
Paste · 10 min Decoder

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
In your download: 8 files
  • Excel workbook · Light · USD
  • START HERE guide (PDF)
  • Excel workbook · Dark Mode
  • Excel workbook · UK · GBP
  • Excel workbook · EUR
  • Excel workbook · AUD
  • Excel workbook · CAD
  • Excel workbook · INR
BLIKPrzelewy24VisaMastercardApple PayGoogle Pay
✓Download page opens right after payment + links by e-mail. No account.
Works inExcelGoogle Sheets
✓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 and Google Pay. Prices in PLN, EUR or USD; 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 →
Etsy Payments Decoder
Paste · 10 min$14Shopify Payouts Decoder
Paste · 10 min$14Marketplace Fee Comparator
Fee review · 10 min$24Complete Collection
All 119 workbooks$99