Why Most Amazon FBA Spreadsheets Are Junk
The spreadsheet I use for product research isn't pretty, but it works because it forces you to confront the numbers before you get excited about a product idea. Most people skip that step. They fall in love with a gadget on Amazon and then try to reverse-engineer the math. That never ends well. I built my system after burning through about $18,000 in inventory across three failed launches in 2021. The problem wasn't the products. It was that I was guessing at margins instead of calculating them upfront. Here's how the actual Aesthetic Amazon Fba Worksheet works when you're sitting down to evaluate a potential product. The first tab is the research sheet where you log the raw data from Amazon. Product name, current price, number of reviews, estimated monthly revenue from Jungle Scout or Helium 10 data, BSR, and image count. You pull this from the product page and maybe one or two competitor listings. Don't over-research here. Five to ten minutes per product max at this stage. The second tab is the cost calculator. This is where people mess up. You need Amazon's FBA fee calculator built in, but you also have to account for shipping per unit from your supplier, product cost from Alibaba quotes, import duties, customs broker fees, and the 15% referral fee that Amazon charges. Most beginners forget the duty part. If your product is coming from China and it's over $800 in value, you're legally required to file entry paperwork. That's another $100 to $250 per shipment sitting right there. I learned this the hard way on a $4,200 shipment of silicone kitchen tools in early 2022. Customs held the goods for eleven days and I ate the broker fee plus demurrage charges.
The third tab flips the numbers into actual profit. Net profit per unit after all fees, profit margin percentage, and break-even sell price if you need to compete on price. The formula columns should be visible so you can see exactly what's happening. No hidden cells. If someone tells you to trust a spreadsheet where you can't see the math, don't use it. There's a fourth tab I added later for tracking actual performance after launch. Real sell-through rate, actual FBA fees from your seller central reports versus what the calculator predicted, and advertising spend as a percentage of revenue. This tab becomes the truth check that tells you whether your research was accurate or optimistic. The real edge case that broke my early spreadsheets was private label products with multiple variations. Say you're launching a product in three colors and two sizes. The FBA fee calculator uses dimensional weight for shipping, and that changes based on packaging. My original sheet assumed one standard box size for everything. It was off by 30% on fulfillment fees for the larger variant. I ended up pricing it too aggressively and eating the difference. The fix was adding a variation matrix where each SKU gets its own packaging dimensions and weight entry. Takes ten extra minutes to set up but saves you from ugly surprises later.
How to Build or Use This Without Wasting Time
Start by deciding whether you're building from scratch or downloading a template. A blank sheet gives you control but costs you two days of setup. A pre-built template saves time but usually has flaws baked into the formulas. The most common flaw is the net profit formula not accounting for inventory storage fees beyond the first 30 days. If your product sits in a fulfillment center for four months before selling through, those long-term storage charges wipe out your margin. Make sure your spreadsheet has a column for estimated days of inventory on hand and multiplies that by the applicable storage rate. Another thing nobody mentions in these guides is the return rate adjustment. Amazon's return rate varies wildly by category. Clothing and accessories can hit 20 to 30%. Home and kitchen usually sits around 5 to 8%. If your spreadsheet assumes zero returns, your profit estimate is fiction. Add a realistic return rate per category and factor it into your revenue calculation. Lost revenue from returns includes the product cost, the FBA fee you paid, and the inbound shipping cost you never recover. When you're actually using the worksheet, there's a decision gate you should follow. If the net margin comes in below 20%, move on. Below 15%, absolutely move on. The 20% threshold accounts for the fact that your advertising costs will eat 8 to 12% of revenue in the first six months. Anything less than 20% margin leaves you with thin air to breathe when PPC bids go up, which they always do. I've seen sellers run profitable on paper for months and then watch their net go negative when the holiday season hit and competition drove ad costs through the roof.
Get the Full Details
There's also a workflow issue worth noting. Most people open a fresh spreadsheet for every product they research. That's inefficient. Set up one master worksheet with a dropdown for product category and date fields. All your research goes into a single file organized by date. When you come back three months later to review your pipeline, you can sort by margin or by date and see what you were thinking at the time. This became critical for me when I had to explain to my partner why we passed on five products that later sold well. Looking back at the spreadsheet data showed I'd misread the review count on two of them. The products had more reviews than I recorded, meaning higher competition than I'd accounted for.
What This Approach Can't Do For You
The spreadsheet will not save you from a bad product. If the market is saturated, if Amazon is private labeling the same item, if the product has inherent quality issues, no amount of good math fixes that. The worksheet only tells you whether a product could be profitable under the assumptions you enter. Garbage inputs still produce garbage outputs. I've seen people feed optimistic revenue estimates into an otherwise solid sheet and come out thinking they found a goldmine. The numbers looked perfect on paper. The product launched to 12 units sold in the first month and the seller gave up two weeks later. The second limitation is timing. Amazon's fee structure changed in late 2023 and early 2024. If you're using an old template, the FBA fulfillment fee columns are probably wrong for medium and large standard-size items. Check the current rates on Amazon's website before trusting any calculation. The referral fee percentage also varies by category and can shift. A spreadsheet that worked in 2022 might overstate your profit by 2 to 4% now without you realizing it. If you want something simpler than building your own system, you could use a tool like Helium 10's Profit Calculator or Jungle Scout's FBA Calculator instead. They're less customizable but at least they're kept current with Amazon's fee changes. The tradeoff is that you lose the ability to layer in your actual supplier costs and shipping estimates the way you can with a custom worksheet. I ended up using both. The calculator tools for quick screening and the spreadsheet for anything past the initial filter stage.
Download the template I described above would involve building it yourself from the structure I outlined. It's one sheet with the four tabs, the variation matrix, the return rate column, and the storage fee projection. I set mine up in Google Sheets so it syncs across devices and I can share it with my virtual assistant without version control headaches. The whole setup took about six hours including the variation matrix fix I mentioned. Worth it given that I now evaluate products in 20 minutes flat instead of spending an hour and a half second-guessing myself.
