

We have included 4 types of common income sources for beauty, hair, and nail salons. 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. With those facts, you will uncover far more trends - knowledge that will help you to greatly improve your business efficiency.Here is a customizable salon expenses spreadsheet template for keeping track of all monthly expenses. Anecdotally, you may notice that drinking mugs sell well in the autumn while bathing suits sell poorly, but nothing beats hard facts available at a glance. This will help you to identify periodic trends in your expense patterns.Ĭreate a comparable sales sheet, and integrate the two so that you can see how your various expenses pay off. Note official holidays and other important commercial days, such as Black Friday after Thanksgiving. Organize this list in an electronic spreadsheet or other accounting instrument so that you can view purchases by day of week, day of month, month, quarter and year. For instance, you may find that the grocery department of your shop is noticeably more expensive to run, or that a particular seller delivers high-quality merchandise at reliably low prices. By doing this you can sort the same information many different ways and coax out important clues about the context of your expenses. Use a spreadsheet or other accounting instrument to manage your list, so that you can manipulate the data quickly with minimal errors.Īppend to each entry in the master list any additional statistics relevant to that purchase, such as the shipping cost, quantity of items bought, date bought, date delivered, supplier’s name, price paid per unit, condition of merchandise, type of merchandise, and new or used status. Process new inventory as soon as it comes in. It enables you to document and track your expenses. Make an electronic master list of all your merchandise procurement costs, going as far back in time as you reasonably can.
