If you are looking for a simple bookkeeping for salon business, then you can use this salon bookkeeping spreadsheet template. It is created with non accountant approach. It allows people who doesn’t have accounting knowledge can use it.
To run successful salon, you need to understand flows of your cash. Also to calculate your profit and loss correctly. You only need Microsoft Excel to run this spreadsheet. No need to install proprietary application.
There are inventory modules inside this spreadsheet. You can use these modules to manage your salon inventory. Either you use them as part of your service packages or as selling products.
Here, you can find similar platform with different salon business models.
How to Use
Since all of those businesses are sharing similar platform, here is instruction on how to use it.
Set starting date of one year fiscal period to any date. Type your salon business name. It will be used as a title to all of your financial statements.
There are default revenue and expenses categories. You can modify them to suit your own categories.
There is a sales worksheet to input your routine transaction. You don’t have to fill it per one customer. You can fill it with daily or particular period summary. Other worksheets are purchase, cash book, internal bank/account transfer and depreciation.
If you need to print receipts, you can select particular receipt number to pull particular transaction to print.
Track Payable and Receivable
You can track your supplier payable as well as your customer receivable.
Analyze and Print Financial Statement
There are ten worksheets you can use to analyze your financial transactions. It should help you seeing your salon business condition. Those reports are :
- Profit & loss report or income statement
- Balance Sheet statement
- Cash Flow statement
- Statement of owner’s equity
- Channel report
- Monthly profit & loss report
- Gross profit & loss report
- Asset report
- Monthly cash account summary
- Dashboard (you can see one year of financial summary in visual view)
Hair Salon Bookkeeping Spreadsheet
A hair salon usually provides professional hair styling services for men and women. It is including professional hair styling and hair texturing. Most of them also offer hair coloring, highlights, head and scalp treatments and formal styling.
Pricing is based on selected treatment package where it included all used hair products.
In this spreadsheet you can see how to organize those services and product categories. This spreadsheet is filled with dummy data transaction. You can learn how to input your financial transaction in respective tables.
Barbershop Bookkeeping Spreadsheet
The most common customer at a barbershop is a man who wants a quick haircut and possibly a beard trim or shave as well. Even though barber shop doesn’t differentiate gender of their visitors, most customers are men.
Also, their services are a little bit different from hair salon.
Manicure and Pedicure Bookkeeping Spreadsheet
A manicure is a cosmetic beauty treatment for the fingernails and hands and a pedicure is a cosmetic treatment of the feet and toenails. It is analogous to a manicure.
Beauty Salon Bookkeeping Spreadsheet
Beauty salon has broader coverage than hair salon. It handles cosmetic treatments to all bodies from hair to toe of both men and women. Spa or massage therapy can fall into this business salon category.
Skin Care Bookkeeping Spreadsheet
Skin care is the range of practices to enhance skin appearance and relieve skin conditions. It could include the use of cosmetics, botulinum, exfoliation, fillers, laser resurfacing, peels and ultrasonic skin treatment. Women are main target of this business.
In this bookkeeping spreadsheet you can see how those services are categorized. Also, you can learn how to input transactions to generate financial statements.