Amazon FBA Seller Profit Tracker Excel for Amazon sellers — product pricing after landed cost, FBA fulfillment, and referral fees, a sales log by channel, FBA inventory, and a monthly P and L dashboard with PPC. Know…
About this template
Amazon FBA Seller Profit Tracker Excel for Amazon sellers — product pricing after landed cost, FBA fulfillment, and referral fees, a sales log by channel, FBA inventory, and a monthly P and L dashboard with PPC. Know what every unit actually earns — and whether advertising left any profit.
$49
Excel & Google Sheets template — instant download on Etsy
Products and Pricing — unit landed cost, FBA fulfillment plus referral fees per unit, total cost per unit, sale price, and margin in dollars and percent for every product. Change a cost and every order profit updates by formula.
Sales Log — date, customer placeholder, channel (FBA or FBM), product, quantity in units, price per unit, revenue, cost per unit pulled from the pricing sheet, profit per order, and margin. Log orders and batches in one place.
FBA Inventory — product, unit, units on hand at Amazon, reorder point, unit landed cost, and stock value. Anything at or below its reorder point is flagged LOW STOCK so you ship more before it stocks out.
Monthly P and L — revenue, product cost, Amazon storage fees, advertising (PPC), and other expenses by month, Jan-Dec, with net profit and margin. Revenue and product cost are formulas from the Sales sheet.
Dashboard — total revenue, orders, units sold, average order value, gross and net profit and margin, best product by margin per unit and by margin percent, best-selling product, best order and best channel, costs by category, and low stock count.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Amazon FBA Seller Profit and Inventory Tracker track?
The Amazon FBA Seller Profit and Inventory Tracker tracks Products and Pricing; Sales Log; FBA Inventory; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 4,602.00 from 20 orders and 236 units sold; average order value 230.10.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.