How To Use Amazon Fba Worksheet

Working with Amazon FBA fees is a headache until you actually get a grasp on how costs add up.

I spent about three years doing this wrong, watching margins disappear because I never bothered calculating referral fees, storage charges, and inbound shipping separately. My first product cost $4.20 to source, sold for $19.99, and I walked away with roughly $2.10 profit after Amazon took their cut. That wake-up call is why I started building detailed spreadsheets before committing inventory to their warehouses. The basic worksheet isn't some fancy software subscription. It is a Google Sheet or Excel file where you plug in your product cost, dimensions, weight, and target selling price. The formula does the heavy lifting. You set up columns for FBA fees, storage costs, shipping to Amazon, advertising spend, and return rate adjustments. Then the sheet spits out a real number instead of a guess. I use a sheet that separates variable costs from fixed costs. Variable includes the referral fee, which Amazon calculates as a percentage of the sale price, and FBA fulfillment fees, which depend on size tier. Fixed costs are things like monthly storage fees if inventory sits too long, or advertising budgets you commit to regardless of sales velocity. Mixing these two categories is where most sellers blow their margins without noticing.

Here is the practical part. Create a new row for each product variation you plan to list. Column A is ASIN or SKU. Column B is unit cost from your supplier. Column C is package weight in pounds. Column D is length, width, and height in inches. Column E is your planned selling price. Columns F through K calculate Amazon fees using their published rate tables. Column L subtracts everything from your revenue to show net profit per unit. Column M multiplies that by projected monthly units to give you a rough profitability estimate. The referral fee calculation trips people up. Amazon charges different percentages by category. Electronics run 15 percent, clothing can be 17 percent, and some categories like watches hit 20 percent. Make sure your worksheet pulls the right rate for each product. I learned this the hard way listing fitness bands under health and beauty because I forgot to check the actual category tree in Seller Central. Fulfillment fees have their own quirks. Standard size items under two pounds cost around $3.22 to pick, pack, and ship. Anything over that moves into large standard or oversize tiers with steeper rates. Your spreadsheet should reference Amazon's current fee schedule because they adjust these numbers annually. I keep a tab with the latest rate table and use VLOOKUP to pull the correct fulfillment cost based on weight and size dimensions you enter.

Storage fees are another silent margin killer. Amazon charges per cubic foot per month, and the rates spike dramatically during Q4. In my experience, products that do not sell within 180 days start accumulating long-term storage fees that can eat your entire profit. Build a column into your worksheet that flags slow-moving inventory and estimates what those storage charges will look like if a product stalls. Shipping to Amazon themselves is often overlooked. You pay freight to send inventory to their fulfillment centers, and that cost varies by carrier, route, and shipment size. A typical LTL shipment from China might run $800 to $1500 depending on volume and weight. Break that cost per unit across your initial shipment quantity and include it in your per-unit profitability calculation. I used to ignore this and wonder why my cash flow looked fine on paper but my bank account told a different story. Advertising spend needs its own line item. If you plan to run PPC campaigns, estimate your daily budget and divide by expected monthly sales to get a cost-per-sale figure. Amazon's default recommendation is often aggressive, so build in a variable percentage you can adjust. A realistic starting point for new products is around 10 to 15 percent of revenue going back into ads, but this drops as organic rank improves.

One edge case that caught me off guard involves returns. Amazon keeps the referral fee even when a customer returns the item, and they charge a return processing fee on top of that. If your product has a higher-than-average return rate, your spreadsheet should factor in that loss. I list a return rate assumption in column N and let the sheet deduct the lost referral fee and processing charge for each returned unit. Products with return rates above 8 percent usually need a different strategy, whether that means better packaging, clearer listings, or finding a supplier with improved quality control. Here is a workaround I developed after my first rough quarter. I added a sensitivity analysis section at the bottom of the sheet that shows how profit changes if your selling price drops by 10 percent, or if your unit cost increases by 15 percent, or if your monthly sales volume falls to half the forecast. This tells you immediately which variables you can control and which ones will destroy you if they shift even slightly. Most sellers never build this, and they get blindsided when supplier prices jump right before restocking. Use actual Amazon rate data, not old numbers from a YouTube video. Fee schedules change frequently, and relying on outdated figures gives you false confidence. I keep a master sheet with the current rates and reference it for every new product. The time investment is about ten minutes per product iteration, but it saves hours of guessing later.

Another thing worth noting is that the worksheet only tells you what you expect to earn, not what you actually will earn. Sales velocity, review quality, and competitive pressure all influence real-world results. I treat the spreadsheet as a decision-making tool rather than a guarantee. If the numbers do not look solid before you order, you probably should not proceed. A negative per-unit profit estimate is your first warning sign, but even positive estimates need a buffer for unexpected costs. For anyone just starting, there are several free templates available online. I recommend modifying them rather than using them blindly because the default assumptions rarely match your actual situation. Adjust the referral fee percentages, update the fulfillment fee table, and add your own shipping and advertising estimates. The goal is a worksheet that reflects your specific product category and business model, not a generic calculator that looks good but misses the details. Run the numbers for at least three to five products before committing capital. I found that building a small portfolio of calculated products reduced my risk significantly. Even if one item underperforms, the others can carry the operation. Spreading orders across multiple SKUs also helps with storage fee management since you avoid tying up all your capital in a single product that might stall in the warehouse.

Keep the sheet updated monthly once you start selling. Compare projected versus actual results and adjust your assumptions. The gap between your forecast and reality is where you learn what matters. After six months of tracking, I stopped worrying about perfect accuracy and focused on consistency. The worksheet became a living document that improved with each iteration rather than a one-time calculation you fill out and forget. Download a clean template to get started, then customize it for your needs. The structure I described is simple enough to build from scratch in fifteen minutes, and having control over the formulas means you understand exactly how each cost component affects your bottom line. That understanding pays off when you negotiate with suppliers, set competitive prices, or decide whether to keep or drop a product line.