Can I use it for a barbershop or a tattoo studio?

Yes. The income shape, daily sales, chair or booth rent, retail, is the same. Only the category names change.

Should I include the owner's draw?

Yes, as a weekly cost. Cash you take out is cash the business does not have, and leaving it out is the most common way a forecast flatters itself.

Does this work in Excel and Google Sheets?

Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.

How do I enter something that happens once?

Put the same week number in the From and To columns.

I'm not confident with spreadsheets. Will I manage?

Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

Home → Tools → Salon & Studio Cash Flow Forecaster

Cash Flow Forecaster for Salons & Studios

The chairs stay booked and the account stays thin, and nobody can say why.

Thirteen weeks of salon cash including chair rent and quarterly tax, so a quiet two weeks does not become a missed payroll.

$29 USD · one-time

Buy on Etsy · $29Gumroad coming soon

Instant download · Excel & Google Sheets · works on Mac and Windows · on Etsy today, Gumroad soon

Salon & Studio Cash Flow Forecaster dashboard

Who it's for

Made for the way you actually work.

Salon owners carrying rent and wages through quiet months
Studio owners whose bookings swing with the seasons
Lash, nail and brow techs going out on their own
Owners weighing a second chair against a bigger space

What's included

Everything in one file.

Dashboard: Lowest balance, runway and the cash curve. Read-only.
Start Here: Five steps from opening the file to a real number on screen.
Cash Flow: Where the forecast is built. The main working sheet.
Settings: Forecast horizon and display.
Instructions: What each sheet does, and what to do if a number looks off.
About: Version, license and support.
PDF Quick-Start Guide: two pages, first result in five minutes

How it works

Three steps to a number you trust.

Open Cash Flow. Enter the cash you can actually draw on today, not invoiced, not committed, available.
Set your alert threshold: the balance below which you cannot operate.
Under Money in, enter each source with the amount and the weeks it runs for. A one-off uses the same number twice.

A look inside

The screens you'll be working in.

List of the seven sheets in the salon cash flow forecaster

Cash Flow sheet with money in, money out and the balance by week

Start Here sheet with five steps to a readable forecast

Settings sheet covering thirteen weeks of one salon

Three steps: money in, money out, read the low point

Compatibility: works in Google Sheets and Microsoft Excel 365

Questions

Good to know.

Can I use it for a barbershop or a tattoo studio?: Yes. The income shape, daily sales, chair or booth rent, retail, is the same. Only the category names change.
Should I include the owner's draw?: Yes, as a weekly cost. Cash you take out is cash the business does not have, and leaving it out is the most common way a forecast flatters itself.
Does this work in Excel and Google Sheets?: Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.
How do I enter something that happens once?: Put the same week number in the From and To columns.
I'm not confident with spreadsheets. Will I manage?: Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

One mispriced job costs more than this.

$29 once, and it's yours to keep. It pays for itself the first time it stops you underpricing a job or leaving margin on the table. No subscription, no login, just a file that does the maths.

Buy on Etsy · $29Gumroad coming soon

Related tools