computer spreadsheets for monthly expenses

#Computer spreadsheets for monthly expenses how to#

Beauty salon: You will get a detailed list of all the expenses in this beauty salon expense sheet.Include all the items related to shaving such as shaving cream, aftershave location, razors, trimmers, etc. Most of the hair salons offer shaving facilities as well.

To access the complete list, please go to the hair stylist expense sheet template. Hair salons: If you’re making an expense sheet for a hair stylist or hair salon, add expenses like scissors, blow dryers, trimmers, chemicals, hair spray, combs/brushes, straighteners, curing lamps, etc.While some items are specific to the type of services you provide, here are the 3 prominent examples we have included in our salon expenses spreadsheet. in your salon, you need to maintain a separate spreadsheet for profit from goods sold.įor example, items like uniforms, aprons, towels, doormats, gloves, wiping and cleaning papers/cloths, chairs, and other furniture are needed in all types of salons. If you’re selling retail products like shampoos, lotions, hair oils, etc. Note: Add items that you’re using in salon operations and not for selling purposes. Some of them are industry specific, while some a common for all types of salons. The salon needs a large number of inventories to run the business. Include admin and front desk employees’ salaries, too. If you have per-hour salon staff, calculate hours worked and per-hour rate. SalariesĪdd monthly salaries, commissions, and tips. Here’s a detailed article on 3 cost-cutting secrets for salons. We have included the most common expenses for every salon, irrespective of their nature, i.e., hair, beauty, or nail salon. Other income (if any): If you have any other income such as selling video tutorials, subleases, interest, etc.But irrespective of the service provided, you have still made an income just by selling them. Because these gift cards may or may not be redeemed yet. Revenue from gift cards sold: Keep all the gift cards sold amount here, under a separate head instead of having them added to the services sold.It works if you have a low number of transactions. This is a complicated calculation, but to simplify it, we have included net profit from the product sold. Profit on products sold (purchase price – sales price): If you’re selling hair and beauty products in your salon, use this profit from goods sold template.Here’s a template for the salon income spreadsheet. It includes cash, payment through credit cards/debit cards, bank transfer, digital wallets, and checks. Revenue from salon services: This will include the total of all the services you sold and the rate for each service.We have included 4 types of common income sources for beauty, hair, and nail salons.

#Computer spreadsheets for monthly expenses how to#

Here are the expenses we have included and an overview of how to calculate them. The above beauty salon expense sheet is simple and self-explanatory. To access the above income spreadsheet, use this template.

Salon expenses template (below is the explanation).

Cost of goods sold spreadsheet (If you’re generating extra income by selling retail products in your salon like shampoos, nail polishes, hair oils, etc.).

You need 3 main spreadsheets to keep track of salon revenue, expenses, and profits. You can add the additional items and remove the ones not applicable to your business. We have included the most common hair and beauty salon monthly expenses. Salon Expenses Sheet for Hair Stylists and Beauty Salons It is also ideal for self-employed stylists, makeup artists, nail artists, and beauticians. Here is a customizable salon expenses spreadsheet template for keeping track of all monthly expenses.