PayoutExplainedSample data
Upload Your Own File
This is a sample settlement analysis using demo data.Explore the full breakdown below, then upload your own file for a real analysis.
Reconciled: calculated net matches the settlement total reported in the file (USD 2590.23).
Net Amount From This Settlement
USD2590.23
Sales and credits minus fees, refunds, holds, and other adjustments from this uploaded settlement file. Includes 1 unmapped row(s).
Settlement Period
Jan 1, 2025 – Jan 14, 2025
Effective Commission Rate
15%
Commissions ÷ Gross Sales
Total Fee Rate
36.25%
(Commissions + fulfillment + storage + account fees) ÷ Gross Sales
Total Rows Processed
96
12 categories
Gross Sales
USD 4218.47
Total Fees
USD 1529.11
Net Reserve Change
USD -75.00
Reimbursements
USD 42.50

Money In

Gross Sales+USD 4218.47
Shipping Income+USD 287.40
Reimbursements+USD 42.50
Reserve Released+USD 175.00
Total In+USD 4723.37

Money Out

Amazon Commissions-USD 632.77
Fulfillment & Storage-USD 896.34
Refunds-USD 189.97
Reserve Held-USD 250.00
Taxes-USD 143.86
Total Out-USD 2112.94

Other

Other Adjustments-USD 12.80
Unknown / Unmapped-USD 7.40

Top Fee Categories

FBA fulfillment fee (per unit)FBAPerUnitFulfillmentFee
-USD 712.1846.6% of fees
Referral fee (commission)Commission
-USD 632.7741.4% of fees
FBA fulfillment fee (weight-based)FBAWeightBasedFee
-USD 128.408.4% of fees
FBA storage feeStorage Fee
-USD 55.763.6% of fees
Total Fees-USD 1529.11

Reimbursement Credits

DateOrderDescriptionAmount
2025-01-09114-3892047-6618201Refund Reimbursal+USD 42.50
Total Reimbursements+USD 42.50

Rows by Category

CategoryRowsTotal
32USD +4218.47
32USD -632.77
14USD -840.58
5USD +287.40
4USD -143.86
3USD -189.97
1USD +175.00
1USD -55.76
1USD +42.50
1USD -12.80
1USD -7.40
1USD -250.00
Total96USD +2590.23

Transactions

Every row included in the totals above, with Amazon’s original identifiers and why it was categorized the way it was.

Transactions matching the current filters. Amounts are signed: + is money in, − is money out.
LineDateDescriptionOrder / SKUCategoryAmount
32025-01-01
Item price
Order · ItemPrice · Principal
114-3533926-1316353
WH-GRIP-BLK-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 274.89
42025-01-01
Tax withheld by Amazon
Order · ItemWithheld · Tax
114-3533926-1316353
WH-GRIP-BLK-01
Taxes
Matches the rule for Order / ItemWithheld / Tax → Taxes.
-USD 30.48
52025-01-01
Referral fee (commission)
Order · ItemFees · Commission
114-3533926-1316353
WH-GRIP-BLK-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 41.23
62025-01-01
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
114-3533926-1316353
WH-GRIP-BLK-01
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 72.49
72025-01-01
Item price
Order · ItemPrice · Principal
112-2648905-7619272
WH-GRIP-BLU-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 199.92
82025-01-01
Referral fee (commission)
Order · ItemFees · Commission
112-2648905-7619272
WH-GRIP-BLU-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 29.99
92025-01-01
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
112-2648905-7619272
WH-GRIP-BLU-01
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 52.72
102025-01-01
Item price
Order · ItemPrice · Principal
114-5582675-8421115
RB-SET-5PC
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 329.89
112025-01-01
Tax withheld by Amazon
Order · ItemWithheld · Tax
114-5582675-8421115
RB-SET-5PC
Taxes
Matches the rule for Order / ItemWithheld / Tax → Taxes.
-USD 37.18
122025-01-01
Referral fee (commission)
Order · ItemFees · Commission
114-5582675-8421115
RB-SET-5PC
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 49.48
132025-01-01
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
114-5582675-8421115
RB-SET-5PC
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 77.66
142025-01-01
Previous reserve released
Other-Transaction · Other-Transaction · Previous Reserve Amount Balance
—
Reserve Released
Matches the rule for Other-Transaction / Other-Transaction / Previous Reserve Amount Balance → Reserve Released.
+USD 175.00
152025-01-02
Item price
Order · ItemPrice · Principal
114-9429936-1998403
JR-SPEED-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 179.88
162025-01-02
Referral fee (commission)
Order · ItemFees · Commission
114-9429936-1998403
JR-SPEED-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 26.98
172025-01-02
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
114-9429936-1998403
JR-SPEED-01
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 66.60
182025-01-02
Item price
Order · ItemPrice · Principal
113-8994896-5956816
YM-MAT-6MM
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 319.92
192025-01-02
Tax withheld by Amazon
Order · ItemWithheld · Tax
113-8994896-5956816
YM-MAT-6MM
Taxes
Matches the rule for Order / ItemWithheld / Tax → Taxes.
-USD 34.95
202025-01-02
Referral fee (commission)
Order · ItemFees · Commission
113-8994896-5956816
YM-MAT-6MM
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 47.99
212025-01-02
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
113-8994896-5956816
YM-MAT-6MM
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 70.96
222025-01-03
Item price
Order · ItemPrice · Principal
113-4827814-2669194
FR-ROLL-18
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 263.92
232025-01-03
Referral fee (commission)
Order · ItemFees · Commission
113-4827814-2669194
FR-ROLL-18
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 39.59
242025-01-03
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
113-4827814-2669194
FR-ROLL-18
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 65.28
252025-01-03
Item price
Order · ItemPrice · Principal
112-6436494-8926044
AB-WHEEL-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 179.91
262025-01-03
Referral fee (commission)
Order · ItemFees · Commission
112-6436494-8926044
AB-WHEEL-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 26.99
272025-01-03
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
112-6436494-8926044
AB-WHEEL-01
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 55.17
282025-01-03
Item price
Order · ItemPrice · Principal
114-7903615-9070286
WH-GRIP-BLK-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 199.92
292025-01-03
Referral fee (commission)
Order · ItemFees · Commission
114-7903615-9070286
WH-GRIP-BLK-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 29.99
302025-01-03
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
114-7903615-9070286
WH-GRIP-BLK-01
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 52.72
312025-01-04
Item price
Order · ItemPrice · Principal
112-7523980-6665806
WH-GRIP-BLU-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 199.92
322025-01-04
Referral fee (commission)
Order · ItemFees · Commission
112-7523980-6665806
WH-GRIP-BLU-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 29.99
332025-01-04
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
112-7523980-6665806
WH-GRIP-BLU-01
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 52.72
342025-01-04
Item price
Order · ItemPrice · Principal
114-6111904-7814422
RB-SET-5PC
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 359.88
352025-01-04
Tax withheld by Amazon
Order · ItemWithheld · Tax
114-6111904-7814422
RB-SET-5PC
Taxes
Matches the rule for Order / ItemWithheld / Tax → Taxes.
-USD 41.25
362025-01-04
Referral fee (commission)
Order · ItemFees · Commission
114-6111904-7814422
RB-SET-5PC
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 53.95
372025-01-04
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
114-6111904-7814422
RB-SET-5PC
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 84.72
382025-01-05
Item price
Order · ItemPrice · Principal
114-4219346-9136650
JR-SPEED-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 164.89
392025-01-05
Referral fee (commission)
Order · ItemFees · Commission
114-4219346-9136650
JR-SPEED-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 24.73
402025-01-05
FBA fulfillment fee (per unit)
Order · ItemFees · FBAPerUnitFulfillmentFee
114-4219346-9136650
JR-SPEED-01
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAPerUnitFulfillmentFee → Fulfillment Fees.
-USD 61.14
412025-01-05
Item price
Order · ItemPrice · Principal
114-8525179-4809695
KB-ADJ-20
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 89.99
422025-01-05
Referral fee (commission)
Order · ItemFees · Commission
114-8525179-4809695
KB-ADJ-20
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 13.50
432025-01-05
FBA fulfillment fee (weight-based)
Order · ItemFees · FBAWeightBasedFee
114-8525179-4809695
KB-ADJ-20
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAWeightBasedFee → Fulfillment Fees.
-USD 44.12
442025-01-05
Item price
Order · ItemPrice · Principal
113-4017188-4184977
DB-HEX-15
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 129.98
452025-01-05
Referral fee (commission)
Order · ItemFees · Commission
113-4017188-4184977
DB-HEX-15
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 19.50
462025-01-05
FBA fulfillment fee (weight-based)
Order · ItemFees · FBAWeightBasedFee
113-4017188-4184977
DB-HEX-15
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAWeightBasedFee → Fulfillment Fees.
-USD 38.96
472025-01-06
Item price
Order · ItemPrice · Principal
113-7741305-5852072
KB-ADJ-20
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 89.99
482025-01-06
Referral fee (commission)
Order · ItemFees · Commission
113-7741305-5852072
KB-ADJ-20
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 13.50
492025-01-06
FBA fulfillment fee (weight-based)
Order · ItemFees · FBAWeightBasedFee
113-7741305-5852072
KB-ADJ-20
Fulfillment Fees
Matches the rule for Order / ItemFees / FBAWeightBasedFee → Fulfillment Fees.
-USD 45.32
502025-01-06
Item price
Order · ItemPrice · Principal
112-3259352-9603060
PB-DOOR-01
Sales
Matches the rule for Order / ItemPrice / Principal → Sales.
+USD 34.99
512025-01-06
Shipping charged to buyer
Order · ItemPrice · Shipping
112-3259352-9603060
PB-DOOR-01
Shipping Income
Matches the rule for Order / ItemPrice / Shipping → Shipping Income.
+USD 64.95
522025-01-06
Referral fee (commission)
Order · ItemFees · Commission
112-3259352-9603060
PB-DOOR-01
Commissions
Matches the rule for Order / ItemFees / Commission → Commissions.
-USD 5.25

Top Orders by Gross Sales

Settlement revenue only — does not reflect profit or cost of goods.

Order IDGross SalesAmazon FeesRows
114-6111904-7814422USD 359.88USD -138.674
114-5582675-8421115USD 329.89USD -127.144
113-8994896-5956816USD 319.92USD -118.954
114-3533926-1316353USD 274.89USD -113.724
113-4827814-2669194USD 263.92USD -104.873
113-9304426-3001528USD 240.74USD -36.112
112-2648905-7619272USD 199.92USD -82.713
114-7903615-9070286USD 199.92USD -82.713
112-7523980-6665806USD 199.92USD -82.713
112-6436494-8926044USD 179.91USD -82.163

1 row(s) totalling USD -7.40 could not be automatically categorized.

Ready to analyze your own settlement?

Upload your Settlement Report Flat File V2 and get the same breakdown for your real data.

Upload Settlement File

Want automated settlement reports when they’re ready?

Get updates when account-connected imports, recurring email summaries, and accountant-friendly workflows are available.

No spam. Just product updates when there’s something real to share.

PayoutExplained v1.0 — Categorization is rule-based. Unknown rows are shown explicitly.
This is not a substitute for full accounting reconciliation.