Report this item to Etsy

Tax Write Offs for Hair Stylists – Salon Bookkeeping Spreadsheet 2026 | Booth Renter Income Expense Tracker, Tips, Sales Tax | Excel Sheets

NowPrice:$4.99

Original Price: $9.98

50% off

•

Sale ends on November 20

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by MFASZ
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

Hair stylist bookkeeping spreadsheet 2026: booth rent, services, tips, retail and sales tax, Schedule C expenses, mileage, 1099-K check, quarterly set-aside.

WHAT YOU GET (instant digital download)
- Income (1,000 rows): date, client or batch, category (hair, nails/skin/lashes, retail, salon commission as contractor, classes, chair sublet), source, gross, tips, card or app fees withheld, sales tax collected, net and a row check
- Expenses and Categories: 31 salon categories mapped to the 2025 Schedule C (booth or suite rent line 20b, retail products for resale line 4, color and products used on clients line 22, tools, license 23, card fees 10, meals at 50%), default business-use % and override
- Retail & Sales Tax: cost of goods sold (beginning inventory + purchases - ending), a 40-line year-end count, sales tax collected vs. remitted by quarter, and service income, retail, tips and booth rent by month
- Mileage (600 trips): 2026 IRS rate by trip date (72.5¢ Jan. 1-Jun. 30, 76¢ Jul. 1-Dec. 31), parking and tolls
- 1099 Check: each processor, app or salon vs. the 1099-K (over $20,000 and 200 transactions) or 1099-NEC ($2,000 for 2026 payments) you receive
- Monthly P&L, Schedule C and Quarterly: profit by month with a chart; lines 1-31 and Part IV; SE tax estimate and set-aside; the four 2026 Form 1040-ES periods and due dates
- Salon Tips tab and PDF guide: booth renter vs. commission vs. W-2, tips, inventory, sales tax and tools

HOW IT WORKS
1. Download the files from your Etsy purchase page right after checkout.
2. Open the .xlsx in Excel, or upload it to Google Drive and open with Google Sheets. No macros, nothing to install.
3. Start on the "Start here" tab, then type in the yellow cells. Grey cells are formulas and recalculate for you. Each workbook comes in two copies: one with sample rows marked "Sample — delete" so you can see how it works, and one blank.

DETAILS
Tips are income and stay inside gross receipts (tracked separately for your preparer; the Schedule 1-A tips deduction is not calculated). Sales tax: a Settings switch follows the Schedule C rule (imposed on the buyer: not income; imposed on you as seller: in gross receipts and deducted on line 23). Two copies: Example (a sample booth renter marked "Sample — delete") and blank.

Important: the workbook does not file sales tax returns, calculate depreciation or the qualified tips deduction, or prepare a return. The set-aside is a rough estimate. If you are on a salon’s W-2 payroll, that pay does not belong in this workbook. Schedule C line numbers follow the 2025 form.

Last reviewed Oct. 23, 2026. Uses 2026 IRS figures (mileage rates, SE tax, Form 1099 thresholds, Form 1040-ES due dates) with sources listed in the workbook.

General information, not tax, legal or accounting advice. MFA is not affiliated with the IRS or any salon, booking app or payment company.

Want your books cleaned up or your return prepared? MFA works with stylists and beauty pros. Visit mfa-advisory.com or call (347) 205-4468.

This is a digital product: no physical item will be shipped. Because files are delivered instantly, all sales are final. If a file won't open, message us and we'll fix it.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

View shop registration details

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Makeup Artist Pricing Calculator

Hair Stylist Income Tracker

Business Opportunity

Listed on Oct 23, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates