Title card reading Reseller Profit Tracker beside a laptop showing the Dashboard tab with four summary cards and a profit by month table.
  • Title card reading Reseller Profit Tracker beside a laptop showing the Dashboard tab with four summary cards and a profit by month table.
  • The Dashboard tab of the Example file: summary cards, a profit by month table with a bar chart, a platform table and unsold stock tables.
  • The Items tab with yellow input columns for item, source, dates, cost and platform, and gray columns for fee, profit, margin, days held and status.
  • A table named By platform with sold, money in, fees, shipping paid, profit, margin, average days held and profit per item for three platforms.
  • Two tables: unsold stock value grouped by age bands, and the 10 oldest unsold items ranked with days held and value.
  • The Setup tab with shop name, dates and a platforms table of percentage fee, fixed fee and a Yes or No for fee on shipping.
  • A card listing the Example and Blank .xlsx files and the tabs Start Here, Setup, Items and Dashboard, with the 500 item row limit.
  • A card describing how the file was tested: six sets of test data recalculated in LibreOffice and compared with Python, with no differences found.

Reseller Spreadsheet

Every item you flip gets its own row here, from purchase through to sale. Each item is a row on the Items tab. Enter what you paid, then the platform and listing date, then the sale price and shipping once it sells. Fee, money in, profit, margin and days held appear on their own. Setup is where each platform gets a name, a percentage fee and a fixed fee, for up to 8 platforms. No fees come built in, so copy them from each platform's fee page. The Dashboard tab gives profit by month, a table per platform, unsold stock value by age and your 10 oldest unsold items. A Check column names what is wrong with a row. The Example file holds 72 made-up items. The Blank file is empty.

$5.99 on Etsy

From our listing records. Etsy shows the current price and your local currency at checkout.

Buy on Etsy

An .xlsx file with ordinary formulas and no macros. A script recalculated it in Excel for Mac and LibreOffice. Excel for Windows and Google Sheets have not been tried.

Instant download from Etsy · nothing shipped

What's included

  • Reseller-Profit-Tracker-Example.xlsx, filled in with made-up items
  • Reseller-Profit-Tracker-Blank.xlsx, for your own items
A card listing the Example and Blank .xlsx files and the tabs Start Here, Setup, Items and Dashboard, with the 500 item row limit.

How it works

  1. The Dashboard tab of the Example file: summary cards, a profit by month table with a bar chart, a platform table and unsold stock tables.
    Read the Dashboard Items sold, money in, fees paid and profit sit in cards at the top. Profit by month is a table with a bar chart. The numbers are made up.
  2. The Items tab with yellow input columns for item, source, dates, cost and platform, and gray columns for fee, profit, margin, days held and status.
    Log each item One row per item. The yellow columns are yours. The gray columns work out fee, profit, margin, days held and days listed.
  3. A table named By platform with sold, money in, fees, shipping paid, profit, margin, average days held and profit per item for three platforms.
    Compare platforms A table of sold, money in, fees, shipping paid, profit, margin and average days held for each platform you add on Setup.
  4. Two tables: unsold stock value grouped by age bands, and the 10 oldest unsold items ranked with days held and value.
    Spot old stock Unsold value is grouped by age. A second table lists the 10 oldest unsold items with days held and cost.
  5. The Setup tab with shop name, dates and a platforms table of percentage fee, fixed fee and a Yes or No for fee on shipping.
    Type your fees The Setup tab holds each platform's percentage fee, fixed fee and whether it charges on shipping. Nothing is filled in for you.

Compatibility and file formats

An .xlsx workbook with ordinary formulas. No macros and no add-ins. A script recalculated it in LibreOffice 26.8 and compared the results with a separate Python calculation. Another script confirmed it uses no LAMBDA, LET, XLOOKUP or spill formulas. A script also opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation: every cell matched the values stored in the file, with no error cells. That test did not type new data into Excel or look at the screen. Excel for Windows and Google Sheets have not been tried.

Instant download from Etsy · nothing shipped.

Video

Questions

Which platforms does it know?

None. You type the name and fee of each one on the Setup tab, up to 8. The Example uses made-up names and fees.

What happens when an item is returned?

Returns are not handled. Delete the sold date and sale price on that row, and the item goes back to unsold stock.

Does profit include my rent or mileage?

No. Profit is the money in on that row less shipping paid, the fee, the cost and the prep cost.

How do I see only unsold items?

Use the filter arrow on the Status column of the Items tab.

This file adds up what you type. Fees in the Example are made up. It gives no tax or financial advice. License: for your personal use only. No resale or sharing of this file. AI helped write the listing text, the how-to text and the code that builds this file. Scripts tested: the fee, profit, margin, days held and every Dashboard table, on 6 sets of test data including a sale at a loss, a typed fee of 0, a platform missing from Setup, the age limits at 30, 60, 90 and 180 days and a full 500 rows. No person is claimed to have checked it unless stated here.