{"product_id":"hair-braiding-bookkeeping-spreadsheet","title":"Hair Braiding Bookkeeping Spreadsheet","description":"\u003cp\u003eThis hair braiding bookkeeping spreadsheet is for braiders and extension stylists who buy hair, use it on clients and want to know what they really earn. It keeps the hair you buy and the hair you charge for on separate lines, so your markup is visible instead of hidden inside the appointment price.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eSet up for a braider business\u003c\/h2\u003e\u003cp\u003eInstead of the shop accounts most ledgers start with, the categories match a hair extensions business.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome lines:\u003c\/strong\u003e Braiding, Extensions and weaves, Maintenance and takedown, and Hair resold\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExpense lines:\u003c\/strong\u003e Hair and bundles, Products and consumables, Chair or room rent, and Tools and equipment, and more\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMileage reasons:\u003c\/strong\u003e mobile appointment, wholesaler, training and salon, picked from a drop-down\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eBundles bought at one price and charged at double that are a markup. If both sit inside one appointment fee, the markup never shows. Here, hair resold is its own income line and hair and bundles is its own cost.\u003c\/p\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Clients, Income, Expenses, Mileage, Monthly, Quarterly, Profit and Loss, Balances and Dashboard.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e500 income rows and 500 expense rows\u003c\/li\u003e\n\u003cli\u003eMileage with your own reasons, useful if you work as a mobile hairdresser, and the year totaled\u003c\/li\u003e\n\u003cli\u003eMonthly and quarterly totals, which is how tax gets filed\u003c\/li\u003e\n\u003cli\u003eA profit and loss taken from the same two lists\u003c\/li\u003e\n\u003cli\u003e10 client records showing what each has been worth\u003c\/li\u003e\n\u003cli\u003eAccount balances, so the file knows what the business holds\u003c\/li\u003e\n\u003cli\u003eA dashboard that reads it all\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA filled year to learn from\u003c\/h2\u003e\u003cp\u003eThe example copy holds 450 income entries and 378 expense entries for one stylist's year, ending at a 32.8% margin. The blank copy is ready for your clients, and the Start Here tab gets you set up in a few minutes. Chair rent, products and travel all land in the same ledger, so nothing needs copying across.\u003c\/p\u003e\u003cp\u003eThis is a bookkeeping spreadsheet, not an accountant. Tax rates and what you can claim are yours to set and yours to check.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel workbooks: the filled example and a blank one\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour download is ready the moment payment clears. The files are for personal and business use on your own devices; please do not share or resell them. Questions? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Google Sheets as well as Excel?\u003c\/h3\u003e\u003cp\u003eYes. The Excel workbooks run on Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I see what I make on the hair I resell?\u003c\/h3\u003e\u003cp\u003eYes. Hair resold is its own income line and Hair and bundles is its own expense line, so the markup shows in your totals.\u003c\/p\u003e\u003ch3\u003eI rent a chair. Where does that go?\u003c\/h3\u003e\u003cp\u003eChair or room rent is one of the expense lines, so it sits in the monthly, quarterly and profit and loss totals.\u003c\/p\u003e\u003ch3\u003eDoes it track travel to clients?\u003c\/h3\u003e\u003cp\u003eYes. The Mileage tab has reasons such as mobile appointment, wholesaler, training and salon, and totals the year.\u003c\/p\u003e\u003ch3\u003eWill it calculate my tax?\u003c\/h3\u003e\u003cp\u003eNo. It gives monthly and quarterly totals and a profit and loss, but tax rates and what you can claim are yours to set and check.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597869219934,"sku":"OPX-155","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/hair-braiding-bookkeeping-spreadsheet-01.jpg?v=1790832811","url":"https:\/\/opxviashop.com\/products\/hair-braiding-bookkeeping-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}