Browse a few screenshots from the Excel workbook built for salons, barbers, nails and tanning. You’ll see the Daily Takings (cash/card/tips), stylist chair/commission tracker, services & price list, retail/colour stock with reorder list, invoices/receipts, and the monthly P&L with VAT summary (if registered). Click any image to enlarge. Figures are sample data only; layouts may vary slightly.
Requires Excel 2016 or Microsoft 365 (Windows/Mac). For full details and setup steps, see the User Guide.
LEDGER (Pivot Table) — Accounts Slicer: filter Accounts • multi-select (Ctrl+click) • Date/Month • In / Out / Net • Running Bank Balance • drill-down (double-click) • Refresh(right-click → Refresh) • exclude (blank) • works for VAT-registered and non-VAT-registered businesses • cash-basis • UK VAT. GENERALENTRIES — Journal (cash-basis): date dd/mm/yyyy • description • account • debit | credit • VAT on Purchases / VAT on Sales • bank • sales • expenses • supplier invoice • customer receipt • A/R • A/P • inventory • tips • petty cash • UK VAT • auto updates Ledger / P&L / VAT return.APPOINTMENTS — Daily Schedule (Printable): two versions — Today (auto date) and Custom Date (enter any past/future date) • day view for bookings/staff • ready-to-print A4 Portrait, centered, Fit to 1 page • change via Page Layout → Orientation/Margins/Print Area • ideal for salon/barber/nails/tanning front desk.PROFIT & LOSS — Automatic (Printable): pulls totals from GENERALENTRIES / LEDGER • period selector (month/quarter/year) • cash-basis Revenue / COGS / Gross Profit / Expenses / Operating Profit / Other Income / Finance Costs / Profit before/after tax • works for VAT & non-VAT businesses • zero-suppression on empty lines • A4 Portrait, centered, Fit to 1 page (change via Page Layout) • Export → PDF • refresh if pivot-based.BALANCE SHEET — Automatic (Printable): “as at” date selector • pulls from TRIAL BALANCE (fed by GENERALENTRIES/LEDGER) • groups Current/Non-current Assets, Current/Non-current Liabilities, Equity • VAT balance auto-splits (Recoverable vs Liability) • Retained Earnings linked to P&L net profit • works for VAT & non-VAT businesses • zero-suppression on empty rows • A4 Portrait, centered, Fit to 1 page (change via Page Layout) • Export → PDF • refresh if pivot-based.
Hairdresser Excel Bookkeeping Spreadsheet
Full Setup
£119.00
Designed for salons, barbers and mobile stylists.
Service menu & stylist chair tracking (chair rent/commission).
Tips & cash takings log with daily till reconciliation.
Colour stock tracker (tubes/bowls) and retail product margins.
Built-in invoice/receipt templates for retail and services.
Full Setup: We load your stylists, services, prices and opening balances.
