How to Track Your Music Income and Expenses in a Spreadsheet

Tax season is the moment most musicians realize their financial records are inadequate. They have months of income they cannot fully account for, expenses they cannot prove, and a general anxiety about numbers that makes the whole process worse than it needs to be.

The solution is not complicated software or a bookkeeper. For most independent musicians earning under $100,000 per year from music, a well-structured spreadsheet is all you need. One that you update weekly takes about fifteen minutes per week and produces records clean enough to file taxes without stress, apply for grants confidently, and understand your actual music business economics.

This guide explains exactly how to set up that spreadsheet.

What You Will Learn

• The categories your spreadsheet needs to track
• How to structure your income and expense records
• What counts as a deductible music business expense
• How to prepare quarterly tax estimates from your records
• How to use the data to make better business decisions

Why Track Everything: The Business Case

Musicians who track their income and expenses consistently discover patterns they did not see before. They find out which income streams are actually profitable after expenses, which clients pay on time and which do not, what their effective hourly rate is for different types of work, and whether their music business is growing or stagnating.

Without records, all of this is intuition. With records, it is data you can act on.

The tax argument is equally compelling. The IRS allows self-employed musicians to deduct ordinary and necessary business expenses from their taxable income. Every dollar you cannot prove is a dollar you pay tax on unnecessarily. Good records can reduce your tax bill by hundreds to thousands of dollars per year.

The Spreadsheet Structure

Build your music finance spreadsheet with two main sheets: Income and Expenses. A third sheet for a Summary Dashboard pulls totals from both and gives you the at-a-glance view you need for decision-making and quarterly tax calculations.

The Income Sheet

Your income sheet should have one row per transaction with these columns:

| Date | Source/Client | Category | Description | Amount | Invoice # | Payment Method | Status |

|---|---|---|---|---|---|---|---|

Date: The date payment was received (not the date invoiced).

Source/Client: Who paid you. For streaming royalties, the distributor name. For a gig, the venue or client name.

Category: The type of income. Use consistent categories so you can subtotal by type at year end. Suggested categories:

• Live Performance
• Session Work (Remote)
• Session Work (In-Person)
• Streaming Royalties
• Sync Licensing
• Teaching / Lessons
• Merchandise
• Publishing Royalties
• YouTube / Content
• Grants / Awards
• Other

Description: A brief note about the specific payment. "Wedding reception, April 12, Smith & Jones" or "March streaming royalties, DistroKid."

Amount: The amount received, not including any transaction fees.

Invoice #: The invoice number from your invoicing system, if applicable. Links your income records to your invoices.

Payment Method: Check, bank transfer, PayPal, Venmo, cash, etc. Useful for reconciling records.

Status: Paid, Outstanding, or Overdue. Track outstanding invoices here so you can follow up.

The Expense Sheet

The expense sheet mirrors the income sheet structure:

| Date | Vendor | Category | Description | Amount | Payment Method | Receipt |

|---|---|---|---|---|---|---|

Category: Use consistent expense categories that map to IRS Schedule C deductions. Suggested categories:

• Recording / Production Costs
• Equipment (instruments, gear)
• Software and Plugins
• Studio / Rehearsal Space Rental
• Home Studio (portion of home used exclusively for music business)
• Marketing and Advertising
• Website and Hosting
• Distribution Fees
• Professional Fees (attorney, accountant)
• Education and Training
• Travel and Transportation
• Meals (business related, 50% deductible)
• Uniforms and Stage Clothing
• Instrument Maintenance and Repair
• Membership Fees (AFM, PRO publisher fees, etc.)
• Miscellaneous

Receipt: Note where the receipt is stored. "Google Drive / Receipts / 2026 / April" or "Box labeled 2026 Receipts." You need to be able to produce receipts if audited.

The Summary Dashboard

Create a third sheet with formulas that pull from the Income and Expense sheets:

Monthly totals for each income category: SUMIFS formulas that total income in each category by month. Gives you a month-by-month view of where income is coming from.

Running year-to-date totals: SUMIF formulas for total income and total expenses by category.

Net income (profit/loss): Total income minus total expenses. The key number for both tax purposes and business analysis.

Quarterly tax estimate: Multiply your net income by your estimated tax rate (25 to 30% is a safe estimate for most self-employed musicians in the US) and compare it to quarterly estimated tax payments made.

Income by category breakdown: A simple summary showing what percentage of your income comes from each stream. This is often the most revealing number when musicians review it for the first time.

What Counts as a Deductible Music Business Expense

The IRS allows deductions for "ordinary and necessary" business expenses. For musicians, these commonly include:

Equipment: Instruments, amplifiers, microphones, audio interfaces, studio monitors, cables, and other equipment purchased for your music business. Items over $2,500 may need to be depreciated over several years rather than deducted in full in the year of purchase (consult a tax professional).

Software and plugins: DAW software licenses, plugin subscriptions, sample libraries, notation software, streaming analytics tools.

Recording and production costs: Studio time, session musician fees, producer fees, mixing and mastering costs, music video production.

Home studio deduction: If you have a dedicated space in your home used exclusively for music business (a home recording studio, not a room you also use for other purposes), you can deduct a portion of your rent or mortgage, utilities, and internet proportional to the square footage of that dedicated space.

Marketing: Advertising spend (Facebook ads, TikTok ads, Spotify Marquee), press kit creation, promotional CDs and merchandise, photography and graphic design.

Professional fees: Music attorney fees, accountant fees, business filing fees.

Education: Music lessons, workshops, courses, or books that maintain or improve skills directly related to your music business.

Travel: Miles driven to performances, studio sessions, meetings, and music business events. Keep a mileage log. For 2026, the IRS standard mileage rate is 70 cents per mile (check for updates at irs.gov). Flights, hotels, and per diem for music business travel are also deductible.

Instrument maintenance: Strings, reeds, drum heads, tuning, setup, and repair costs.

Note: Personal expenses are not deductible even if you occasionally use personal items for music business. Keep business and personal expenses completely separate, ideally through a dedicated business bank account. See our business bank account guide for the practical setup.

Quarterly Tax Estimation

If you expect to owe more than $1,000 in taxes for the year, the IRS requires you to make quarterly estimated tax payments. The due dates are:

• Q1 (Jan to Mar income): April 15
• Q2 (Apr to Jun income): June 16
• Q3 (Jul to Sep income): September 15
• Q4 (Oct to Dec income): January 15

From your summary dashboard, take your year-to-date net income at each quarterly deadline, multiply by your estimated effective tax rate, subtract any withholding (W-2 income taxes already withheld), and pay the difference. Pay online at irs.gov/payments.

Underpaying quarterly estimates by more than $1,000 triggers a penalty. Paying quarterly keeps you compliant and prevents the large one-time tax bill at April filing.

Using Your Records to Make Better Decisions

Your tracking spreadsheet is not just a tax tool. Review it monthly and ask:

• Which income streams grew or shrank this month?
• What is my net income per gig or per client after expenses?
• Am I earning more this quarter than the same quarter last year?
• Which expenses are not generating a return?
• Am I on track to hit my income goal for the year?

This regular review is what separates musicians who drift through their careers financially from those who build intentionally toward their goals. For the strategic framework that makes these numbers meaningful, see our music business plan guide.

Frequently Asked Questions

Q: Should I use a spreadsheet or accounting software like QuickBooks?

A: A spreadsheet is sufficient for most independent musicians. QuickBooks and Xero are better investments once you have employees, complex inventory, or income above $100,000 per year. The learning curve and monthly cost ($30+) are not justified for most freelance musician situations.

Q: How often should I update my records?

A: Weekly is the practical minimum. It takes 10 to 15 minutes to enter a week's transactions. Monthly updates lead to forgotten transactions and the need to reconstruct records. Quarterly updates produce the kind of incomplete, stressful records most musicians start with.

Q: What happens if I get audited without good records?

A: The IRS can disallow any deduction you cannot document. If you cannot prove a business expense happened, you lose the deduction and may owe back taxes plus interest and penalties. Good records mean an audit is a nuisance rather than a financial catastrophe.

Q: Do I need to save physical receipts?

A: Digital receipts (email confirmations, PDF invoices) are accepted by the IRS. Photograph paper receipts immediately and save them in a cloud folder organized by year and month. You do not need the physical paper copy as long as the digital record is complete and legible.

What to Do Next

With your tracking system in place, the next step is making sure your invoicing process feeds cleanly into your income records. Our invoicing guide covers the complete invoicing workflow from sending your first invoice to following up on late payments. For artists who want to understand all the income streams that should be flowing into their tracking system, see our complete guide to making money as a musician.