Free Amazon Referral Fee Calculator Spreadsheet: Category Rates, Minimum Fee, Handmade & FBA

Use the free CSV template above if you want an Amazon referral fee calculator spreadsheet that opens in Excel, Google Sheets, Numbers, or most spreadsheet tools. It is designed for seller product research before pricing or ordering inventory.

The template includes category referral fee rate, minimum referral fee, referral fee used, product cost, fulfillment cost, ad cost, return allowance, estimated profit, and net margin. It also includes examples for common 15% planning rates, low-fee categories, higher-fee stress tests, Handmade 15% or $0.30 minimum, and very low-priced items.

A spreadsheet is useful when you want to compare many products or category assumptions offline. The online Amazon Referral Fee Calculator is better for quick single-scenario checks and shareable results.

The core formula is referral fee = max(fee base x category referral fee rate, minimum referral fee). The spreadsheet keeps category rate and minimum fee visible so you can see whether the percentage fee or the minimum fee is driving cost.

The spreadsheet also includes a simple order-level profit model: estimated profit = item price + shipping charged - referral fee - product cost - fulfillment cost - ad cost - return allowance. Net margin = estimated profit / revenue.

Use it for early product screening, not final settlement. Amazon category rules, fee bases, FBA rates, account settings, taxes, incentives, and marketplace rules can change, so replace sample values with current data before making inventory decisions.

Use Excel or Google Sheets when you are comparing many SKUs, many category assumptions, or multiple supplier quotes. A spreadsheet lets you duplicate rows, add notes, save category assumptions, and keep a record of why a product passed or failed.

Use the online Amazon Referral Fee Calculator when you need one fast answer. It is better during live product research, supplier calls, or when you want to check a low-price minimum fee without opening a workbook.

The strongest workflow is to use both. Start in the online calculator, then move promising products into the spreadsheet for side-by-side comparison. Once a SKU looks viable, move it into the Amazon FBA Profit Calculator for complete margin planning.

The template includes a Handmade row that uses 15% and a $0.30 minimum referral fee. This helps artisan sellers test the fee quickly before adding labor, materials, packaging, shipping, ads, returns, and remake allowance.

It also includes a low-price minimum fee row. If a $1.50 item has a 15% percentage fee, the percentage fee is only $0.225. A $0.30 minimum would be used instead, creating an effective referral-fee rate of 20% before any other cost.

For low-ticket Amazon products, this minimum-fee check can be more important than the headline category rate. A product can look cheap to source but become fragile after the minimum fee, fulfillment, packaging, and ads.

First, replace every sample value with your current marketplace and category assumptions. Do not reuse 15% blindly if your category uses a different rate, tier, or minimum fee.

Second, open the Amazon Referral Fee Calculator for quick checks while you research: /amazon-referral-fee-calculator. Use the calculator to test low-price products, Handmade scenarios, and category-rate changes without editing the spreadsheet.

Third, use the Amazon FBA Profit Calculator when the product needs a complete unit model: /amazon-fba-profit-calculator. Referral fee is only one line; FBA fulfillment, inbound shipping, storage, ads, returns, coupons, and break-even price decide whether the SKU is safe.