Skip to content
The title slide and first slides of the Hair Stylist Expense Tracker template

Hair Stylist Expense Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Stylists who rent a chair or a booth use this hair stylist expense tracker to see the real result of each week. The Weekly tab records service income, retail sales, card tips, cash tips and rent, then shows the total taken in and what is left after rent. The Supplies tab sorts color, tools, classes, insurance and cleaning costs and flags each receipt. The Dashboard splits income by source and totals each cost type.

Fill in one row every Monday for the week before. Keep a small notebook behind the station for cash tips, since that is the figure people most often estimate. Save receipts from the distributor in a folder and mark them Saved. At tax time, give your preparer the Dashboard totals and ask which costs apply to a chair renter.

Useful for

  • See each week after chair rent is paid
  • Track cash tips and card tips apart
  • Total color, tools and class costs for the year

What's included

  • 4 tabs: Dashboard, Weekly, Supplies, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Weekly: a table
  • Supplies: a table
  • 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 Weekly 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 should a hair stylist track tips?

Record card tips from your payment report and cash tips from a daily note, week by week. Keeping them in separate columns makes it easier to check totals against your own records.

What expenses can a booth renter keep records for?

Keep records of chair or booth rent, color and products, tools, classes, license fees, insurance, cleaning and marketing. Ask a preparer which of them count for you.

How do I know what I really earn each week?

The After rent column subtracts chair rent from everything taken in. The Dashboard also subtracts supplies, to set against the income you plan to report.

  • #tax-tracker
  • #hair-stylist-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…