Skip to content
PN Scripts

Business spreadsheets

Booth Renter Profit & Tax Planner (Excel / Google Sheets)

A spreadsheet for US stylists, barbers, nail and lash pros who rent a booth or suite: see what you really take home, which services pay best per hour, and how much to set aside for each quarterly tax payment. Excel, LibreOffice and Google Sheets.

  • Microsoft Excel (.xlsx)
  • LibreOffice Calc (.ods)
  • Google Sheets
  • PDF
  • Paid
  • External marketplace: Gumroad
Buy on Gumroad (opens in a new tab)

Sold on Gumroad. PN Scripts does not take payment for it here.

Business spreadsheets
The Dashboard sheet of the example workbook with take-home before tax, earnings per hour, tax set-aside, tips, rent paid and the next estimated payment, a chart by month and the best services per hour

What it solves

The gap

Booth renters are their own business: rent, product and self-employment tax come out of every service, and the IRS expects estimated payments every quarter, while most salon apps only show what was booked.

What it is

One workbook that turns a five-minute weekly log into take-home pay, profit per service and per hour, a booth rent versus commission comparison and a quarterly tax set-aside with the IRS due dates.

How you use it

Fill in Settings and your service menu once, then log each week and check Quarterly Taxes before each 1040-ES due date.

Built for booth and suite renters: take-home, service profit per hour and quarterly taxes in a plain workbook without macros or a subscription.

Who it is for

Use it when

  • Deciding between booth rent and a commission chair.
  • Pricing services by profit per hour.
  • Setting money aside for the quarterly estimated tax payments.

Built for

  • Hair stylists, barbers, nail techs and lash artists in the United States who rent a booth or suite.
  • Salon suite renters who file Schedule C.

What is inside

Booth rent or commission

Enter your split, the product charge, your rent and supplies. The sheet shows weekly and yearly take-home both ways, including self-employment tax against employee payroll tax, and the weekly revenue where both pay the same.

Service menu check

Price, chair minutes, product cost and how often each service is booked give the profit per service and per hour after a fair share of your rent, ranked from best to worst.

Quarterly estimated taxes

Profit by IRS estimated-tax period, self-employment tax with the 2026 wage base, an income tax set-aside and the suggested payment for each 2026 Form 1040-ES due date, with what you already paid.

Weekly log and dashboard

One row per week from your booking app or POS totals. The dashboard shows take-home before tax, earnings per hour, tips, rent paid, the tax set-aside and the next estimated payment.

Specs

Vendor
PN Scripts
Type
Template
Pricing
One-time purchase · USD 15.00 Price on Gumroad.
License
Commercial license
Deployment
Download (ZIP: .xlsx, .ods and PDF guide)
Maturity
v1.0

Compatibility

Platform or runtime Supported versions Tested up to
Microsoft Excel 2019 or newer Not stated
LibreOffice Calc 7 or newer 24.2

Stack

  • Microsoft Excel (.xlsx)
  • LibreOffice Calc (.ods)
  • Google Sheets
  • PDF

Get the Booth Renter Profit & Tax Planner

Buy it on Gumroad for $15: blank and example workbooks for Excel and LibreOffice, a PDF guide and Google Sheets instructions in one ZIP.

Buy on Gumroad (opens in a new tab)

Sold on Gumroad. PN Scripts does not take payment for it here.

Questions

Only if you answer Yes in Settings. It is capped at $25,000 and at your net profit, and the income phase-out is not modelled. Check your eligibility with a tax professional.

Yes. Choose monthly in Settings and the rent is converted to a weekly amount.

No, it is a planning tool. It estimates what to set aside; safe-harbor rules, state taxes, the QBI deduction and other credits are not included. Confirm with a tax professional.

Excel 2019, 2021, 2024 or Microsoft 365, LibreOffice, or Google Sheets. It does not work in Excel 2016 or older or in Apple Numbers. There are no macros.

Use them for your own business and make as many copies as you need for yourself. Do not resell, share or publish the template.

The workbook is generated from code, and its tests recalculate the example workbook in LibreOffice and check the results against the same arithmetic done in Python. Created with AI assistance; every formula is checked by PN Scripts with automated recalculation tests.

On Gumroad, which takes the payment and delivers the download. PN Scripts does not take payment on this site.