Free Amazon FBA Profit Calculator & P&L Spreadsheet (2026)

Most Amazon FBA profit calculators stop at fees. You type in a price and a box size, they subtract the referral fee and the fulfillment fee, and they hand you a margin that looks great. Then you launch, pay for ads, eat some refunds, store inventory through a peak season, and the real margin turns out to be half of what the calculator said. Most of the free ones are also lead magnets for a software trial.

This one is a plain spreadsheet. It counts the costs that actually decide whether a product makes money: ads, refunds, storage, promotions, and your real landed cost. It comes from a private-label store with more than $3M in lifetime Amazon sales, and it mirrors how we look at our own numbers. When you outgrow it, Sellerise is the profit tool we pay for, and sellerboard is the alternative we recommend. The spreadsheet is free, with no email and no signup.

Download the free spreadsheet (.xlsx)

It works in Excel and in Google Sheets: in Sheets, use File > Import > Upload and choose the file. It is formulas only, with no macros.

Rather not download anything? The online profit calculator runs the same per-unit math in your browser.

The short answer

• Three tabs: Unit Profit (one row per SKU), Monthly P&L (one column per month), and a Read me that shows where each number lives in Seller Central.
• Blue cells are inputs. Everything else calculates.
• It answers four questions per SKU: profit per unit, net margin, ROI, and break-even ACoS, plus the most you can pay per click and still break even.
• Amazon’s own Revenue Calculator is fine for fees and blind to ads and refunds, which together cost us about 20% of sales.
• Once you have more than a handful of SKUs, a profit tool that reads your settlement data daily beats copying numbers into a sheet.

What is in the spreadsheet

Unit Profit. One row per product. You enter ten numbers (plus an optional ad conversion rate) and get Amazon fees, total cost, profit, margin, ROI, break-even ACoS, and a max CPC hint. Three example rows are filled in with made-up numbers so you can see it working; overwrite them with your own.

Monthly P&L. Twelve month columns and a total. You enter top-line figures from your payments reports: sales, units, COGS, referral fees, FBA fees, storage, other Amazon fees, ads, refunds, promotions, reimbursements, and software. It returns total Amazon fees as a share of sales, profit before ads, TACoS, net profit, net margin, and profit per unit.

Read me. How to use it, where to find each input in Seller Central, and definitions.

A worked example, input by input

The numbers below are made up, and they are Example B in the sheet. They are not one of our products. They are just round enough to follow.

A few of these deserve a sentence each.

Landed COGS is the one people get wrong most often. It is not the factory price. It is the factory price plus everything it costs to get the unit to your warehouse or prep center: freight, duty, customs brokerage. Since Amazon stopped offering prep and labeling for US FBA shipments on 1 January 2026, any labeling your supplier or prep center does belongs here or under other costs.

Referral fee is 15% in most categories, with a $0.30 minimum per item. A few categories are tiered by price, so check our fee guide or Amazon’s schedule.

FBA fulfillment fee depends on size, weight, and now price. Since 17 April 2026 Amazon adds a 3.5% fuel and logistics surcharge to it, and from 15 October 2026 to 14 January 2027 holiday peak fees average $0.32 more per unit. Use the figure your Fee Preview shows, and if it excludes the surcharge, multiply by 1.035.

Storage per unit is easiest to get backwards. Take a month’s storage bill and divide it by units sold that month, not units stored. A slow seller with a big footprint will show a high number here, which is the point.

Refund rate is treated as lost revenue: the sheet multiplies it by the sale price. That is conservative, because some returns go back on sale. If most of yours do, lower the rate you enter.

What comes out

Subtract only COGS, inbound shipping, and Amazon fees and this product shows about a 40% margin. Add ads, refunds, and promotions and it is under 17%. That is normal, not a disaster. For comparison, our own store ran at about 21% net margin over the last 12 months, with Amazon fees taking about 30% of sales and ads another 13-14%.

Break-even ACoS and TACoS, explained

These two get mixed up constantly, and they answer different questions.

ACoS is ad spend divided by the sales those ads produced. It tells you what an ad-driven sale costs.

Break-even ACoS is your profit before advertising, divided by the sale price. In Example B, every cost except ads adds up to $21.20, which leaves $8.79 of a $29.99 sale, or 29.3%. Any campaign running above 29.3% ACoS loses money on each ad sale. Below it, ads make money even before you count the organic rank they help build. Our own ACoS sat around 26%.

Max CPC at break-even turns that into a bid. If 12% of clicks become orders, each click is worth 12% of the $8.79 you can afford to spend per sale, so about $1.05. Bid above that and you are paying for clicks that cannot pay back.

TACoS is total ad spend divided by total sales, ads and organic together. It tells you what advertising costs the whole business, and it is the right number to put in a per-unit profit model, because it spreads ad cost across every unit you sell. Ours was about 12.5%, with roughly half of our units coming through ads. A falling TACoS while sales grow usually means organic rank is doing more of the work.

Rule of thumb: manage campaigns against break-even ACoS, and judge the business by TACoS.

The Monthly P&L tab

The unit tab tells you whether a product should make money. The P&L tab tells you whether it did. Each month, copy the lines from your Seller Central payments reports into one column. The Read me tab lists where each lives.

Three lines are easy to forget:

• Other Amazon fees. Inbound placement, low-inventory-level, aged inventory, disposal, and coupon fees. They are small one by one: our placement, coupon, and disposal fees together came to under 1% of sales. They become large when inventory gets out of balance.
• Reimbursements. Money Amazon pays back for lost, damaged, or unreturned units. It goes in as income. If yours is zero, read our reimbursements guide; we recovered a little over $3,000 in 12 months.
• Software. Your tools are a cost of selling. Put them in.

The bottom rows give you Amazon fees as a percentage of sales, TACoS, net profit, and net margin per month. Watch the fee percentage after every Amazon fee change. In 2026 there were three: a base FBA increase on 15 January, the surcharge on 17 April, and peak fees from 15 October.

Why Amazon’s Revenue Calculator is not enough

Amazon’s free Revenue Calculator is good at one thing: telling you the referral fee, the fulfillment fee, and an estimated monthly storage cost for a product. Use it to fill in the fee inputs here. But it is a fee calculator, not a profit calculator.

• It does not model advertising. Ads cost us about 13-14% of sales, more than fulfillment fees. A margin without ads is not a margin.
• It does not model refunds. Ours were about 7% of sales.
• It leaves out several FBA costs. Amazon’s own guide to the tool says long-term storage, removal order, and return processing costs “aren’t built into the calculator”, and suggests adding them as a miscellaneous cost.
• Storage is a monthly average, not storage over time. It takes how many units you plan to store and sell in a month. It does not show what happens when stock sits through October to December at peak rates, or crosses 181 days and picks up the aged inventory surcharge.
• COGS is one number. Freight, duty, inbound shipping, and prep are on you to add correctly.

Run Amazon’s calculator for the fees, then put them into this sheet for everything else.

When to graduate to a profit tool

A spreadsheet is the right tool when you are deciding whether to launch something, or when you have a few SKUs and an hour a month. It becomes the wrong tool when:

• You have more than a handful of SKUs, and copying fees and ad spend per product takes longer than reading the answer.
• You want profit daily, not after the month closes, so you can catch a fee change or a runaway campaign within days.
• Your fees change mid-month: peak season, surcharges, a product remeasured into a new size tier.
• You want reimbursements found for you instead of matched by hand.

That is when a profit tool earns its subscription. It reads your settlement data directly and nets fees, refunds, ads, and COGS per product per day.

Sellerise is what we use. The fee split in our FBA fees guide came straight out of it. It is the better pick if you want detail and reimbursement tools without paying a recovery service a percentage. Try Sellerise: 10% off monthly plans for your first year through our link.

sellerboard is the gentler dashboard, and the one we suggest to sellers who find Sellerise too dense. Our view comes from its published plans and a side-by-side comparison with Sellerise. Try sellerboard: a two-month free trial through our link, versus one month on their site.

Either way, keep the spreadsheet for pre-launch math. A profit tool only knows products you already sell.

Bottom line

Download the spreadsheet, overwrite the three example rows with your own products, and look hard at break-even ACoS and net margin after ads and refunds. If a product only works on a fees-only calculator, it does not work. Use Amazon’s Revenue Calculator to get the fees right, this sheet to get the profit right, and a profit tool once there are too many SKUs to do it by hand.