Turn an Amazon Payments transaction or settlement CSV into a readable payout summary, fee breakdown, effective Amazon take rate, and SKU-level reconciliation.
Your files stay private: all analysis runs locally in your browser.
Amazon settlement and payment transaction reports can combine orders, refunds, selling fees, fulfillment fees, advertising charges, reserves, reimbursements, and account-level adjustments. The bank deposit alone does not tell you which activities produced the payout.
This analyzer groups recognized columns into operational categories and preserves an account-level bucket for items that cannot be assigned to a SKU.
Start with product charges, subtract refunds and Amazon fees, then account for advertising, reserves, prior balances, reimbursements, and other adjustments. Compare the calculated net with the statement's transfer amount and investigate material differences rather than forcing the totals to match.
Report formats and timing differ. Orders can occur in one period and settle in another, while reserves can move between statements.
A large payout can hide weak unit economics. Sort SKUs by sales, fees, and refunds to find products with disproportionate deductions. Combine the export with your landed cost and off-Amazon expenses before treating the result as accounting profit.
This tool is for operational review and is not tax or accounting software. Preserve Amazon's original reports and consult a qualified accountant for books and filings.
The type/description column in a Payments report uses Amazon's internal vocabulary. These are the entries sellers most often ask about:
| Transaction type | What it is | Watch for |
|---|---|---|
| Order | A customer purchase: product charge, shipping/gift-wrap credits, and the selling and FBA fees deducted against it. | Fee columns on the same row are negative — the row nets to what you keep before COGS. |
| Refund | A customer return or refund reversal of an earlier order. | Amazon keeps a portion of the referral fee on many refunds (a refund administration fee) — you rarely get 100% of fees back. |
| Adjustment | Account-level corrections: reimbursements for lost or damaged inventory, fee corrections, chargeback resolutions. | Positive adjustments you didn't expect are often FBA reimbursements — worth auditing systematically, since they follow from inventory Amazon lost. |
| Service Fee | Subscription, advertising, storage, disposal, labeling, and other program charges. | Monthly storage and long-term storage fees land here and are easy to miss at SKU level because they're account-scoped. |
| Transfer | The actual disbursement to your bank account. | A settlement's transfers should roughly equal its net activity after reserves — this is the row your bank statement matches. |
| Chargeback / A-to-z Claim | Funds withheld or reversed for payment disputes and buyer claims. | A pattern of these on one SKU usually signals a listing accuracy or fulfillment problem, not random buyer behavior. |
| Current Reserve / Unavailable Balance | Funds Amazon holds back — commonly to cover potential returns (delivery-date-based reserves) or account-level risk. | Reserves roll forward: last statement's reserve releases into this one. They shift cash timing, not total cash. |
Here is a realistic month for a private-label FBA seller doing $10,000 in ordered product sales, so you can sanity-check your own effective take rate:
| Line | Amount | % of gross sales |
|---|---|---|
| Product sales | +$10,000 | 100% |
| Customer refunds (8% of sales) | −$800 | 8% |
| Referral fees (15% category rate) | −$1,500 | 15% |
| FBA fulfillment fees ($3.50 avg × ~630 units) | −$2,200 | 22% |
| Monthly + long-term storage fees | −$150 | 1.5% |
| Sponsored Products spend (deducted from payout) | −$1,200 | 12% |
| FBA inventory reimbursements | +$90 | — |
| Net transferred | ≈ $4,240 | ≈ 42% |
Roughly 58% of gross never reaches the bank — before a single dollar of product cost. That is not a scandal; it is the normal FBA cost structure. The number to monitor is the trend: if your effective deduction rate creeps from 55% to 62% with no strategy change, something specific (fee tier bump, return-rate rise, ad efficiency decay) is eating margin, and this report is where it shows up first.
Note that advertising only appears in the payout if you pay for ads from your sales proceeds — many sellers charge ads to a credit card, in which case ad spend never touches the settlement and must be added back separately when judging profitability.
A Payments transaction, date-range transaction, or settlement CSV works best. Column availability varies by report version.
Reserves, prior balances, timing, unavailable columns, currency conversion, and account-level adjustments can create differences.
It calculates recognized Amazon cash activity. Add COGS, freight, software, payroll, and other expenses for true profit.
For a typical private-label FBA product, referral fees (usually 8–15%), FBA fulfillment fees, storage, and refunds together commonly consume 40–55% of gross sales before advertising. Add ads and 50–60%+ total deductions are normal — which is why unit economics must be modeled before launch, not discovered in the settlement.
Money Amazon temporarily withholds from a disbursement — most commonly a delivery-date-based reserve covering potential returns on recently delivered orders, sometimes a risk-based hold. Reserves release into the following settlement, shifting cash timing rather than total cash.
Compare your inventory ledger's lost, damaged, and destroyed events against the Adjustment lines in your settlements. Amazon auto-reimburses many cases, but not all; unreimbursed discrepancies can be claimed within the eligibility window through Seller Support.
Last updated:
Powered by HumanCalculations — free online calculators