See the profit on every item you resell

What is in the workbook

Six sheets. You type in the input columns; the formula columns calculate themselves. Each data sheet has formulas ready for 500 rows.

• Start Here

  Short notes on every sheet, how to enter fees, and the disclosures.

• Settings

  Columns: Setting, Value, Note. Default referral fee %, default FBA fee per unit, prep cost per unit, inbound shipping per lb, sales tax % paid at source, and the report year. The values shipped there are examples; you replace them with your own.

• Inventory

  One row per product you buy.

  You enter: Date bought, Source store, Product name, ASIN/SKU, Qty, Unit cost, Inbound ship, Planned sell price, Status (Bought/Shipped/Live/Sold).

  Calculated: Tax paid, Prep, Referral fee, FBA fee, Net profit per unit, Total profit, ROI %, Margin %.

• Sales

  One row per sale.

  You enter: Date sold, ASIN/SKU, Qty, Sale price (per unit), Fees paid (total).

  Calculated: Unit cost (from Inventory), Profit, Month, Revenue, COGS.

• Expenses

  Other business costs such as software, supplies and subscriptions.

  Columns: Date, Category, Amount, Month (calculated).

• Monthly Summary

  Twelve months for the report year you set, plus a totals row.

  Columns: Month, Revenue, COGS, Fees, Expenses, Net profit, ROI %.

A short QUICK-START.txt guide is included with the download.

Who it is for

• FBA sellers who want fees, prep and inbound shipping counted in each unit's profit.
• Online arbitrage (OA) sellers who buy from web stores and need cost, tax and sale price in one place.
• Retail arbitrage (RA) sellers who buy in physical stores and want to see ROI and margin per product.

How it works

1. Open Settings and replace the example numbers with your own current fees.
2. Log what you buy on Inventory.
3. Log each sale on Sales using the same ASIN/SKU text; the unit cost is looked up for you.
4. Read profit, ROI and margin per product, and the month-by-month totals on Monthly Summary.