How to track salon income without a spreadsheet
A simple method for beauty pros to record income per client and per service: what to write for each visit, a weekly check, and three month-end totals.
To track your income as an independent beauty pro, record every visit on the day it happens, with the same six things each time: the date, the client, the service, the price, what you actually received and how you were paid. Keep one line per visit rather than one total per day, use the same names for services and clients every time, and check the record against your card payments and cash once a week. At the end of the month, three totals tell you most of what you need: income by service, by client and by payment method.
Why is a bank statement not enough to track income?
#Because it records money moving, not the work behind it. Cash never reaches it. A single card payout can bundle a whole day of visits, after fees, under the processor's name. A transfer from a client shows up next to a transfer between your own accounts. The statement can tell you what arrived; it cannot tell you who paid, for which service, or whether a quiet month was fewer clients or cheaper services.
That is why the record has to start at the visit, not at the bank. The statement is still useful, as the thing you check your record against.
What should you record for each visit?
#The same six things, every time. A notebook, a printed sheet, a spreadsheet or an app can all hold them; what matters is that nothing is skipped.
| What to record | Why it matters |
|---|---|
| Date | Puts the income in the right week and month |
| Client | Shows who your regulars are and when someone stops coming |
| Service, and any products sold | Shows which services carry the month |
| Price of the service | What the visit should have brought in |
| Amount actually received | What it did bring in, including any tip |
| How it was paid: cash, card or transfer | Lets you match the record to your card payments and your cash |
If a client pays part in cash and part by card, write both amounts. If she buys a product on top of the service, give it its own line, so product sales do not quietly inflate what a service seems to earn.
Here is what a few lines look like. The numbers are illustrative.
| Date | Client | Service | Price | Received | Paid by |
|---|---|---|---|---|---|
| March 3 | Ana P. | Lash fill | $65 | $70 | Card |
| March 3 | Maria L. | Brow lamination | $55 | $55 | Cash |
| March 4 | Ioana D. | Full lash set | $140 | $140 | Transfer |
| March 4 | Elena S. | Lash fill | $65 | $65 | $40 cash, $25 card |
Ana's visit was priced at $65 and she paid $70, so $5 of it is a tip. Keeping the price and the amount received side by side is what makes tips visible without a separate column to remember.
Why do the names have to be the same every time?
#Because every total you will want later is a sum of lines that share a name. If one fill is written "lash fill", the next "fill" and the next "LF 3 wk", they are three different services when you add them up, and the month's most important number is split across all three.
- Keep a short, fixed list of your services, with their prices, and copy from it rather than writing a new description each time. Your price list is a good start.
- Write each client's name the same way every visit. A full name or a first name and initial, but always the same one.
- Decide once what counts as a separate service. A full set and a fill are different services; a fill at two weeks and a fill at three can be the same service at different prices.
This is the part people find tedious, and it is the part that turns a list of visits into something you can read.
How do you check your record each week?
#Once a week, compare three things with what the record says:
- Card payments. Open your card processor's report of payments and check that every card line in your record is there with the same amount, and that nothing is there that your record is missing. Then check that each payout reached your bank. A payout often arrives a day or more after the payments in it, so Friday's cards may land the following week, and it is lower than the payments by the processor's fees. Those fees are a cost of the business, so write them down as one.
- Cash. Count the cash taken that week and compare it with the cash lines in your record. If you pay cash into the bank, a deposit rarely lines up with a week exactly, and some cash may have gone on supplies before it got there, so check against the count and write down anything paid out of the takings as a cost.
- Transfers. Check that every transfer in your record arrived, and that every client transfer that arrived is in your record.
A difference usually means a visit was not written down, a payment was split and only one half recorded, or a payout or transfer is still on its way. Finding it within the week is easy. Finding it three months later, at tax time, usually is not.
What should you look at at the end of the month?
#Three totals, each a sum of the lines you already have. These are illustrative, for a lash artist's month.
By service:
| Service | Visits | Income from the service |
|---|---|---|
| Lash fill | 38 | $2,470 |
| Brow lamination | 24 | $1,320 |
| Full lash set | 9 | $1,260 |
| Lash removal | 6 | $150 |
| Total | 77 | $5,200 |
By payment method, using everything received, so including the $310 of tips paid on top of those prices:
| Paid by | Received |
|---|---|
| Card | $3,240 |
| Cash | $1,470 |
| Transfer | $800 |
| Total | $5,510 |
By client: this month, 52 clients came in. The 43 returning clients brought in $4,330 and the 9 new ones $870. The average visit was $5,200 ÷ 77, about $68 before tips, and the average client spent $5,200 ÷ 52, or $100.
Each total answers a different question:
- By service shows which services the month rests on. Here, fills bring in nearly half the income, which makes the regulars who come back for them the most important thing in the book.
- By payment method is the one you check against your card processor's reports, your bank and your cash. If it does not match, go back to the weekly checks.
- By client shows how much of the month came from people who already knew you: here, about five-sixths of it. New clients are welcome, but a book where most of the income is returning clients is a steady one. If returning clients start to fall, how to spot lapsed clients shows how to find who has drifted away.
Income is only half of the month, of course. To know what you kept, take away what the month cost, including the bills that do not arrive every month. The recurring costs beauty pros forget covers those, and how much to set aside for taxes covers the share that is not yours to spend.
Do you need a spreadsheet to do this?
#No. A spreadsheet is a good tool, and plenty of beauty pros keep excellent books in one, or in a notebook. Neither is a mistake: most independent pros start their business with nobody to set up a back office for them, and writing every visit down by hand is a sound way to start.
What the method needs is the habit, not the tool: one line per visit, the same six things, the same names, a weekly check. On paper, the month-end totals take an evening with a calculator. In a spreadsheet they take some formulas, which have to be set up once and kept from breaking. The record underneath is the same.
If you would rather not build or maintain either, an app can keep the same record for you. iBeauty records each visit against a client, with the services and products sold, the payment split across cash, card and transfer, and anything paid above the price counted as a tip. The totals by service, by client and new versus returning are worked out as you go, and every record can be exported as a CSV.
Key takeaways
#- A bank statement is something to check your income against, not a record of it.
- Record every visit the day it happens: date, client, service, price, amount received, how it was paid.
- Use the same service and client names every time, or the totals split apart.
- Check card payments, cash and transfers against the record once a week.
- At the end of the month, total your income by service, by client and by payment method.
Frequently asked questions
#How do I track income as a self-employed nail tech or lash artist?
#Record every visit on the day it happens, with the date, the client, the service, its price, the amount you received and how you were paid. Use the same names for services and clients each time, check the record against your card payments and cash weekly, and total it by service, client and payment method at the end of the month.
What should I record for each client visit?
#The date, the client's name, the service and any products sold, the price of the service, the amount actually received and how it was paid: cash, card, transfer or a mix. Those six things are enough to answer most questions about your income later.
Should tips be recorded as income?
#Yes. Record what the client actually paid alongside the price of the service, so the difference shows as the tip. Tips are part of what you received, and how they are taxed depends on where you live, so ask your accountant how to report them.
How do I see how much each service makes?
#Use one fixed name for each service on every visit, then add up the visits and the income for each name at the end of the month. If the same service is written several different ways, its income is split across them and the total is wrong.
Is a bank statement enough to track salon income?
#No. It misses cash, bundles several card payments into one payout after fees, and does not say who paid or for which service. Keep a record of every visit, and use the bank statement to check that record each week.
iBeauty is an app for independent beauty professionals that records every visit, client, service and cost, keeps recurring bills and reserves in view, and shows the profit left at the end of the month. The first month is free.