Amazon Wholesale Sourcing Spreadsheet Template
A free Excel template for checking a supplier price list: paste the list, add the Amazon numbers, and every row shows landed cost, profit, ROI, the most you can pay and a BUY, REVIEW or AVOID decision.
Free, no sign-up. Made for Microsoft Excel.
What is in the spreadsheet
- How to use: the steps and tips on one sheet.
- Settings: your target ROI, minimum profit per unit, minimum sales per month, and prep, labels and shipping per unit. Change them once; every formula reads them.
- Products: room for 500 products, with three example rows to delete. Orange columns are yours to fill in, blue columns calculate themselves.
The columns
| Column | What goes in it | Filled by |
|---|---|---|
| A–D | UPC or EAN (kept as text, so leading zeros survive), title, case pack, cost per unit | The supplier’s list |
| E–J | ASIN, Buy Box price, referral fee, FBA fee, sales per month, number of sellers | You, from Amazon |
| K–N | Landed cost, profit, ROI and margin | Formulas |
| O | Max buy cost: the highest supplier price that still meets your ROI and minimum profit | Formula |
| P | BUY, REVIEW or AVOID, coloured green, amber or red | Formula |
Rows with a single seller (usually the brand itself) or more than 20 sellers (a crowded listing) are highlighted. Every formula is explained in how to build an Amazon wholesale sourcing spreadsheet.
Where a spreadsheet stops
The template does the arithmetic. The slow part is columns E to J: looking up the listing, the fees, the rank and the sellers for every product takes a minute or two each, and the numbers change daily. A spreadsheet also cannot see a falling price, a rising number of sellers, Amazon on the listing, your selling eligibility or the brand’s IP complaint history. Before you order, run through the due diligence checklist, and check pack sizes with the multipack calculator.
To fill every column automatically, upload the same supplier list to Wholesale Analyzer. It matches each product to Amazon with live prices and fees, adds the checks a spreadsheet cannot do, and returns an Excel workbook with the decision for every row. The first 50 products are free every month. See the supplier price list analyzer.
Stop guessing. Start buying with confidence.
Upload your next supplier list and see which products are worth your money, how many to order and the most you should pay. Your first scan every month is free.