Moving a salon's revenue, expenses and payroll out of Excel so the owner can plan ahead.
The problem
01 / 04
Every pay period, payroll was rebuilt in Excel. Hours, commissions and deductions all had to be checked by hand before anyone could be paid.
02 / 04
Revenue and expenses lived in different files. Getting the full picture meant opening several sheets and piecing the totals together.
03 / 04
Because the numbers were scattered, net profit was never obvious. The owner had to calculate it manually whenever she needed an answer.
March totals
Three separate files have to agree first.
Net profit, March
₱ ?
Manual calculation04 / 04
Planning the next month relied on incomplete totals. Sales goals and expense budgets involved more guesswork than reliable data.
April plan
Set next month's targets
One dashboard where revenue and expenses are logged as they happen and payroll totals compute from what's entered. The owner still runs payroll, but no longer rebuilds it in a spreadsheet, and with everything in one place they can set budgets and goals from real numbers.
Revenue is logged by service, technician and payment type, and expenses by category, so nothing lives in a side spreadsheet.
With revenue and expenses tracked properly, the owner sets a monthly sales goal and expense budget and sees progress against both as the month goes.
Payroll is still run by the owner, but hours, commission, deductions and net pay compute from what's entered, and every period stays on record.
Tech stack used
Built with 
Next.js, 
TypeScript, 
Tailwind CSS, and 
Supabase.