An Excel (XLSX) tracker for online marketplace resellers who want purchase lots, sales, estimated fees, profit and remaining stock in one file. Entry is manual, with one currency and editable fee rates. One-time digital download with a blank and a fictional demo workbook plus a PDF guide in each of five languages: English, Italian, Spanish, French and German.

The problem it solves

Purchase costs, sale prices, fees and shipping end up in different notes and statements, so it is hard to tell what each sale really earned and what is still unsold.

Who it is for

Online marketplace resellers and second-hand sellers who buy items, resell them and want to know what they actually kept after costs, fees and shipping.

What you get

• Record up to 200 purchase lots, each with a unique SKU, quantity and unit cost
• Record up to 500 sale rows against those SKUs, with shipping charged, shipping cost, other costs and refunds
• Estimated fees from four editable platform names, each with a percentage and a fixed amount
• Profit and margin per sale, plus remaining quantity and stock value at purchase cost per SKU
• A Dashboard and a Monthly summary for the selected year, with a chart of amount, fees and profit
• Workbook and PDF guide in English, Italian, Spanish, French and German, each with a fictional DEMO to learn from

How you use it

1. Download and extract the ZIP, choose your language and read the PDF guide.
2. Open the DEMO workbook to see the fictional examples, then keep BLANK unchanged and save a working copy.
3. In Settings, enter the reporting year, a currency label and the fee percentage and fixed amount for each platform name. Zero values are placeholders: check your own statements.
4. Add each purchase lot with a unique SKU, quantity and unit cost. A different purchase cost needs a different SKU.
5. Record each sale against its SKU, then review profit, stock, the Dashboard and the Monthly summary. Save dated backup copies.

Questions