Hair Stylist Income Spreadsheet for Salons & Self-Employed Hair Stylists
In the previous article, we included a salon expense spreadsheet. In this article, we have covered two excel sheets 1) hair stylist income spreadsheet for services sold and 2) Income from goods sold in a salon. So, without further delay, let’s begin!
Hair Stylist Income Spreadsheet with a Customizable Template
It is crucial for hair stylists and salon owners to keep track of their income and expenses with profound accuracy. The below self-employed hair stylist income spreadsheet can be used by beauty salons, nail salons, and hair salons, as well.
Access and customize the below sheet: Hair Stylist Income Sheet
This is a sample income spreadsheet for salons with random numbers.
| Services | Number of Services | Per service rate | Total | |
| Men’s services | ||||
| Men’s basic haircut | 39 | $20 | $780 | |
| Kids’ haircut | 21 | $15 | $315 | |
| Short Hair + Cropped Fringe | 21 | $45 | $945 | |
| Skin Fade + Blunt Cut Fringe | 33 | $60 | $1,980 | |
| Buzzcut + Shape Up + Disconnected Beard | 12 | $15 | $180 | |
| Short Textured Haircut For Men | 56 | $35 | $1,960 | |
| High Fade + Loose Pompadour | 24 | $25 | $600 | |
| High Fade + Textured Quiff Haircut | 23 | $30 | $690 | |
| Men’s advanced hairstyle/cut -1 | 12 | $15 | $180 | |
| Men’s advanced hairstyle/cut -2 | 21 | $45 | $945 | |
| Men’s advanced hairstyle- 3… | 33 | $60 | $1,980 | |
| Blow dry | 12 | $15 | $180 | |
| Beard grooming/styling | 56 | $35 | $1,960 | |
| Shaving | 24 | $25 | $600 | |
| Head massage | 34 | $50 | $1,700 | |
| Shoulder massage | 12 | $50 | $600 | |
| Hair Color | 22 | $60 | $1,320 | |
| Beard color | 10 | $25 | $250 | |
| Mustache color | 16 | $15 | $240 | |
| Face and neck detan | 35 | $75 | $2,625 | |
| Root touchup | 10 | $25 | $250 | |
| Shampoo and conditioner | 16 | $15 | $240 | |
| Hair and scalp treatment | 35 | $75 | $2,625 | |
| Hair spa | 16 | $75 | $1,200 | |
| other service-1 | 0 | $60 | $0 | |
| other service-2 | 0 | $25 | $0 | |
| other service-3 | 0 | $15 | $0 | |
| Women’s services | ||||
| Women’s basic haircut | 39 | $20 | $780 | |
| Butterfly Haircut | 23 | $30 | $690 | |
| Air Bangs | 21 | $45 | $945 | |
| Long Pixie | 33 | $60 | $1,980 | |
| Layers | 12 | $15 | $180 | |
| U Cut | 56 | $35 | $1,960 | |
| V cut | 24 | $25 | $600 | |
| Waterfall Cut | 34 | $50 | $1,700 | |
| Women’s haircut-1 | 12 | $50 | $600 | |
| Women’s haircut -2 | 22 | $60 | $1,320 | |
| Women’s haircut -3… | 10 | $25 | $250 | |
| Blow-dry | 16 | $15 | $240 | |
| Women’s basic hairstyle | 35 | $75 | $2,625 | |
| Classic Low Chignon | 39 | $20 | $780 | |
| Vintage Curls | 23 | $30 | $690 | |
| Updo | 3 | $45 | $135 | |
| Long, Smooth Curls | 26 | $60 | $1,560 | |
| Ponytail | 12 | $15 | $180 | |
| Braiding | 21 | $35 | $735 | |
| Women’s hair style-1 | 24 | $25 | $600 | |
| Women’s hair style-2 | 15 | $50 | $750 | |
| Women’s hair style-3… | 12 | $50 | $600 | |
| Basic perm | 11 | $60 | $660 | |
| Spiral perm | 1 | $25 | $25 | |
| Body wave perm | 3 | $15 | $45 | |
| Beach wave perm | 35 | $75 | $2,625 | |
| Pin curl perm | 5 | $20 | $100 | |
| Partial perm | 23 | $30 | $690 | |
| Root perm | 21 | $45 | $945 | |
| Other perms | 33 | $60 | $1,980 | |
| Hair color- short hair | 12 | $15 | $180 | |
| Hair color- medium hair | 56 | $35 | $1,960 | |
| Hair color- long hair | 24 | $25 | $600 | |
| Ironing/straightening | 34 | $50 | $1,700 | |
| Roller Setting | 1 | $50 | $50 | |
| Shampoo & Conditioning | 22 | $60 | $1,320 | |
| Rebonding | 10 | $25 | $250 | |
| Keratin | 16 | $15 | $240 | |
| Scalp Treatment- type 1 | 35 | $75 | $2,625 | |
| Scalp Treatment- type 2 | 23 | $20 | $460 | |
| Hair spa | 25 | $30 | $750 | |
| Oiling with Head and neck massage | 21 | $45 | $945 | |
| Root Touch Up | 33 | $60 | $1,980 | |
| Other service-1 | 0 | $15 | $0 | |
| Other service-2 | 3 | $35 | $105 | |
| Other service-3… | 16 | $25 | $400 | |
| Revenue from services(A) | $64,880 | |||
| Paid by gift cards redemption (B) | $2,500 | |||
| Gross revenue from services sold C (A-B) | $62,380 |
Freebie Alert: Yottled is a free all-in-one software for salons. 30+ brilliant features including appointment booking, CRM to store client data, gift cards, payment integration, email marketing, and employee scheduling.
We have included all the major types of services that a hair salon or a self-employed hair stylist provides in this printable hair stylist income spreadsheet. To use the data effectively,
- Access the spreadsheet and copy-paste everything to your excel sheet. Alternatively, download it by clicking on File and Download from the upper left-side menu.
- Remove the services you don’t offer.
- Add additional services like waxing, threading, beauty treatment, facials, manicure, pedicures, etc., if you’re offering them.
- To add more services: right-click on the spreadsheet, hit Insert, and click on Add new raw above/below.
- Change the rates and number of services with real data.
We have already provided all the equations and formulas for profit calculation in the spreadsheet.
Why gift card redemption is deducted?
We have already included income from all the gift cards sold in the salon income spreadsheet. Now, irrespective of whether a gift card is being redeemed or not, you have already received an income from it.
For example, you have sold gift cards worth $5,000. But in that month, customers redeemed gift cards worth $3,000 to pay for the services.
You have provided services worth $3,000, and not $5000. But you have already received $5,000 this month. So, if you show your income from gift cards as $5,000 and services worth $3,000, it will either show $8,000 as income from gift cards, or $2000 in discrepancy which results in an accounting error. That’s why deduct the payment made through gift cards in the income statement and enter the entire amount of gift cards sold in the income spreadsheet.
Income From Goods Sold For Salons
It is the most common thing for salons to sell physical products on their premises. This practice
- provides an additional income,
- strengthens the relations with the salon products suppliers, and
- helps salons to get their daily usage products at a further discounted cost.
Here is a simple income spreadsheet template for hair stylists and salons to calculate profit from the goods sold. Because it involves a complicated calculation and this spreadsheet is made for self-employed hair stylists or small salons, we haven’t included inventory, opening stock, and closing stock here.
To customize the income spreadsheet: Access the template
| Product name | Units sold | Purchase price | Selling price | Profit |
| Shampoo bottles Brand-1 | 63 | $20 | $25 | $315 |
| Brand-2 | 22 | $5 | $15 | $220 |
| Brand-3 | 5 | $35 | $75 | $200 |
| Conditioner Brand-1 | 23 | $10 | $30 | $460 |
| Brand-2 | 34 | $25 | $45 | $680 |
| Brand-3 | 12 | $30 | $60 | $360 |
| Hair oil Brand-1 | 33 | $15 | $35 | $660 |
| Brand-2 | 2 | $20 | $25 | $10 |
| Brand-3 | 8 | $35 | $50 | $120 |
| Hair dye/color Brand-1 | 22 | $50 | $60 | $220 |
| Brand-2 | 10 | $20 | $25 | $50 |
| Brand-3 | 16 | $11 | $15 | $64 |
| Hair cream | 5 | $53 | $75 | $110 |
| Massage cream | 39 | $12 | $20 | $312 |
| Anti-dandruff therapy kit | 8 | $14 | $30 | $128 |
| Hair falls defense kit | 21 | $40 | $45 | $105 |
| Sculp treatment kit | 10 | $21 | $25 | $40 |
| Hair styling products Product-1 | 43 | $10 | $15 | $215 |
| Product-2 | 5 | $23 | $75 | $260 |
| Product-3 | 8 | $9 | $20 | $88 |
| Other products-1 | 54 | $18 | $45 | $1,458 |
| Other products-2 | 2 | $25 | $60 | $70 |
| Other products-3… | 12 | $13 | $15 | $24 |
| Revenue from goods sold | $6,169 | |||
This is just a simple salon income template example with the common products sold in a hair salon. Just copy-paste and customize it with the real data. If you sell beauty products or nail art products, add them, too.
Final Words on Hair Stylist Income Spreadsheet
We hope our templates helped you to get a direction on how to calculate income and expenses for your salon. You can automate a lot of these calculations by using a 100% free all-in-one software like Yottled that keeps track of all your income from services and goods sold. Also, don’t forget to access our salon income and expense spreadsheet to calculate accurate profits.
If you’re looking for ways to cut costs, check out our other article on 3 tricks to reduce salon costs.
