Reseller Spreadsheet Excel, Profit per Item, Platform Fees, Days Listed

A log for people who buy things and sell them on. Each item gets one row, from the day you bought it to the day it sold.

Items tab: type the ID, item, source, date bought, cost and any prep cost. When you list it, add the platform and date. When it sells, add the date, sale price, shipping charged and shipping paid. The sheet works out the fee, money in, profit, margin, days held and days listed. It holds 500 items.

Setup tab: you type each platform's name, percentage fee and fixed fee, and choose whether it charges on shipping. No fees are built in, so check them against each platform's own fee page. If a payout shows a different fee, type it in Actual fee on that row and it replaces the calculated one.

Dashboard tab: items sold, money in, fees paid, profit, profit per item and average days to sell. Below that: profit by month, a table comparing up to 8 platforms, unsold stock value by age, and the 10 oldest unsold items.

The Check column on Items names what is wrong with a row, such as Sold before bought or Unknown platform.

The Example file has 72 made-up items. Start your own in the Blank file.

WHAT'S INCLUDED
- Reseller-Profit-Tracker-Example.xlsx, filled in with made-up items
- Reseller-Profit-Tracker-Blank.xlsx, for your own items

Tabs in each: Start Here, Setup, Items, Dashboard. Digital download. Nothing is shipped.

COMPATIBILITY
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, and the menu steps below have not been tried in Excel or Google Sheets.

QUESTIONS AND HOW-TO
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.

Using this file in Excel

Open the .xlsx file. If a yellow bar says Protected View, click Enable Editing.

Type only in the colored input cells. The other cells hold formulas and are locked so they don't get overwritten by accident.

The Example file has made-up entries so you can see how it fills in. Start your own work in the Blank file.

Before you type anything, use File > Save As and give the Blank file a new name. That keeps a clean copy for next time.

To change a locked cell, go to Review > Unprotect Sheet. There is no password. If you edit a formula, the totals may stop being right.

Copying this file to Google Sheets

Open Google Sheets in a browser and start a blank spreadsheet.

Go to File > Import, choose the Upload tab and select the .xlsx file.

Under Import location choose Replace spreadsheet, then click Import data.

Your copy now lives in your own Google Drive. Name it with File > Rename.

Sheets may not keep the locks from the Excel file, so type only in the colored input cells.

HOW AI WAS USED
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.

PLEASE NOTE
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.