Skip to content
The title slide and first slides of the Musician Gig Income Tracker template

Musician Gig Income Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Working musicians, session players and music teachers use this tracker to keep a year of uneven income in order. The Gigs tab records each show with the venue, gig type, pay, tips, miles and whether the money has arrived. The Lessons tab turns lesson counts and rates into monthly income. The Costs tab lists strings, repairs, rehearsal rooms and other spending, and the Dashboard brings the year together with a chart of income by gig type.

Fill the Gigs tab the night of the show, when the pay and tips are fresh. Mark late payers Owed so they show in red and in the unpaid total. Record only the work share of anything you also use at home. When tax season comes, hand the totals and your mileage to a tax professional instead of rebuilding the year from bank statements.

Useful for

  • See which kinds of gigs actually pay best
  • Chase unpaid invoices from venues and clients
  • Gather gig, lesson and gear totals before a tax appointment

What's included

  • 5 tabs: Dashboard, Gigs, Lessons, Costs, How to use
  • Dashboard: a dashboard with 6 summary figures
  • Gigs: a table
  • Lessons: a table
  • Costs: 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 Gigs 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 records should a gigging musician keep?

Keep a date, the venue or client, what you were paid and any tips for each job. Add receipts for gear and travel, and a note of the miles driven. This sheet holds those details in one row per gig, so your year is organized for filing time.

How do I track tips and cash payments?

Give each tip its own amount in the tips column, even when it came as cash. Cash is still income to report, so write it down on the day. Check IRS guidance for how tips and self-employment income are reported.

Can I use one sheet for gigs and teaching?

Yes. Gigs and lessons sit on separate tabs so each keeps its own columns, and the Dashboard adds them together. Keep gear used for both jobs in the Costs tab and note the share you use for each.

  • #tax-tracker
  • #musician-gig-income-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…