Skip to content
The title slide and first slides of the Yard Sale Tracker template

Yard Sale Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

A garage sale moves fast, and the cash box is easy to get wrong. This yard sale tracker starts the night before with the Items tab: a tag number, item, category and the price on the sticker. On sale day, the Sales tab takes only a tag number, a time and the amount paid; the item name, category and tag price are looked up for you, and the discount is worked out. The Totals tab shows takings, items sold, items unsold, the tag value left on the table and the average discount, and two charts, one per category and one per payment type.

The sample sale lists sixteen items and eleven sales, with most buyers haggling a few dollars off. The Items tab turns green as things sell, which makes the leftover pile obvious when you are deciding what to donate. Count the cash box against the Cash line in the payment breakdown at closing time. Rows for more items and sales are ready below the sample data.

Useful for

  • Plan price tags before the neighborhood sale
  • Count the cash box against the sheet at closing time
  • See which categories sold and which should be donated

What's included

  • 4 tabs: Items, Sales, Totals, How to use
  • Items: a table
  • Sales: a table
  • Totals: 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

What is a simple way to record yard sale purchases?

Number each price sticker, list the numbers with item names beforehand, then write down the number and amount for every sale. Add the amounts at the end to get the total takings.

How should I price items at a yard sale?

Many sellers start at about a third of the retail price for items in good condition and expect buyers to negotiate. This sheet shows the average discount, so you can price higher or lower next time.

Which unsold items are worth keeping for the next sale?

Check the unsold list on the Items tab, then donate, list the best pieces online or save them for the next sale. The unsold tag value shows how much you left behind.

  • #sales-tracker
  • #yard-sale-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…