Skip to content
The title slide and first slides of the Resale Profit Tracker template

Resale Profit Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Reselling feels profitable until fees and shipping are counted. This resale profit tracker keeps two lists. Items records what you bought, where and for how much, and marks each item In stock or Sold. Sales records the price, fees and shipping, looks up the cost by item name and works out profit and margin. The Summary tab adds up sales, profit, margin, items sold and the cost of stock you still hold, and splits results by sales channel and by where you bought the goods.

Fourteen sample items show a thrift-and-estate-sale routine with ten sold and four waiting. The sources chart tells you which places give the best return, and the channel chart shows whether fees on one platform eat the gain. Item names must be unique and typed the same on both tabs. Negative-profit sales turn red, so a bad buy is easy to spot.

Useful for

  • Find which thrift stores and sales give the best profit
  • Compare online marketplaces, auctions and local pickup
  • See what unsold stock has cost you so far

What's included

  • 4 tabs: Items, Sales, Summary, How to use
  • Items: a table
  • Sales: a table
  • Summary: a dashboard with 5 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Items tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I calculate profit on a resale item?

Subtract what you paid for the item, any selling fees and the shipping you covered from the sale price. A $48 sale with $6.10 fees, $11.20 shipping and a $12 cost leaves $18.70 profit.

What is a good profit margin for reselling?

Margin is profit divided by the sale price. Many resellers look for 30 percent or more after fees, but it depends on your time and the item type. This sheet shows the margin for each sale.

Do I need to track every item I buy to resell?

Yes, if you want true profit. Unsold stock ties up money, and costs recorded at purchase let the sheet work out profit when the item sells.

  • #sales-tracker
  • #resale-profit-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More sales tracker templates

See all 10

Also in Sales

All sales templates
Get this template

Preparing your template…