Why Most Sellers Skip the FBA Worksheet (And Lose Money)
I spent three years trying to run my FBA business from memory and Google Docs tabs. That worked fine until I had 40 SKUs and my cash flow went sideways because I miscalculated landed costs on a container from China. Now I use a proper spreadsheet and I won't go back. A well-built FBA worksheet tracks everything that matters: product cost, shipping per unit, Amazon fees, storage costs, advertising spend, and your actual profit margin. Not revenue. Profit. There's a big difference and most sellers conflate them until they're looking at a bank account that doesn't match their expectations. The typical structure has columns for SKU, product cost per unit, freight cost per unit, customs/duty per unit, Amazon referral fee, FBA fulfillment fee, monthly storage fee estimate, PPC cost per unit, and net profit per unit. Add a sheet for revenue projection based on units sold, and you've got something that actually tells you whether a product is worth pursuing before you commit to inventory.
I use a secondary tab for break-even analysis. This is where the tool becomes useful rather than just a record-keeping exercise. You set your target margin, plug in your fixed costs, and the formula tells you how many units you need to sell per month. When I was evaluating a $12 kitchen gadget sourced at $3.50, the break-even came out to 280 units per month at my target margin. I scoped the competition and realized that number was realistic but required aggressive PPC spend. That one calculation saved me from ordering 500 units into a saturated niche. Here's something most beginner guides don't mention: the FBA fee varies by size tier and weight bracket, and those brackets are not intuitive. A product that looks like it fits in the standard size category can cross into oversized if you choose the wrong box dimensions during shipping. I learned this the hard way with a batch of water bottles. The product itself was within limits, but my supplier used boxes that were two inches too tall. Amazon resized them, charged me the next size tier, and ate into my margin by about 18 percent on that SKU. The workaround was to send a sample first, measure the packaged dimensions yourself, and verify the size tier before placing the bulk order. Your worksheet should have a column for estimated size tier so you can see this hit before it arrives at the warehouse. Storage fees changed structure in 2024 and they're more punishing now for long-term inventory. If you're holding stock past 180 days, the per-cubic-foot rate jumps significantly. Your worksheet needs a column for estimated days in storage based on your sell-through rate. Monthly units sold divided into your average inventory level gives you a rough turnover estimate. If that number tells you you'll hold inventory for four months, the storage cost column will probably make you reconsider the order quantity or the pricing strategy.
One edge case that caught me off guard: returns. Amazon deducts the referral fee on returned items but you still eat the fulfillment cost. I had a product line where returns ran about 12 percent. My initial model didn't account for this properly and my profit numbers were overstated by roughly 6 to 8 percent. The fix was adding a returns reserve column. I calculate it as gross profit times estimated return rate, then subtract that from net profit. It sounds obvious in retrospect but most people skip it because they're excited about the top-line revenue number. Another nuance people miss is the prep and labeling cost if you're not using Amazon's prep service. You might think it's negligible but when you're moving thousands of units through a third-party prep center, the per-unit fee adds up fast. I started tracking this separately and it ran about $0.40 to $0.65 per unit depending on the service. That's not huge on a single SKU but it matters when you're evaluating multiple products or scaling up. For the actual template, keep it simple. Too many columns and you'll abandon it within a month. The core sheets should be: product sourcing with landed cost breakdown, fee estimation using Amazon's current calculator values, PPC estimate based on your category's average CPC, and a monthly summary sheet that rolls everything into net profit and ROI per SKU. Link them with formulas so updating one number cascades correctly. I use Excel but Google Sheets works just as well and lets you share with an accountant or partner without file version issues.
Get the Full Details
If you want to download a ready-made version, search for "Amazon FBA profit calculator spreadsheet" and pick one that gets updated regularly. The fee schedules change often enough that a static template from 2022 will give you inaccurate numbers. Alternatively, you can build your own over an afternoon if you know your way around basic spreadsheet functions. The value isn't in the template itself, it's in the discipline of filling it out consistently and actually reading the output instead of ignoring it once a quarter. The biggest limitation of any FBA worksheet is that it's only as good as your input data. If you guess on shipping costs, assume a fee tier without verification, or underestimate ad spend because you've never run ads before, the profit number is useless. I've seen sellers treat the spreadsheet like a crystal ball. It isn't. It's a decision support tool. You still need real market research, supplier quotes, and actual campaign data to make it accurate. But once you have those inputs, the worksheet cuts the analysis time from hours to minutes and gives you a clear comparison between different products or pricing strategies. Another honest caveat: if you're doing private label on Amazon, this worksheet works well for evaluation and tracking. If you're doing wholesale or arbitrage, the model still applies but the variables shift. Your margins are thinner, your volume is higher, and the storage calculation matters less because you're turning inventory faster. Adjust the template accordingly or you'll overcomplicate something that's already straightforward.
I'd recommend starting with one product in your worksheet and running it through to completion before building it out for your whole catalog. That way you catch the formula errors, understand which fields matter most, and develop the habit of updating it weekly instead of letting it become a graveyard of stale projections. The difference between a spreadsheet that sits there and one that actually influences your purchasing decisions is consistency. Two minutes a day keeps the numbers honest.
