Get the worksheets.
The sales file is a blank worksheet, not an automated accounting system. Use one row per service or a consistent service-allocation method. Enter payments once so a customer paying for two services does not accidentally double your receipts.
What belongs on a sales row?
| Field | Why it matters |
|---|---|
| Date, time and service reference | Lets you find the transaction again |
| Service and staff member | Connects the work to the person who did it |
| Amount charged | Records the actual sale after an agreed discount |
| Payment method | Separates cash, M-Pesa and card |
| Amount received and reference | Helps reconcile the payment |
| Outstanding amount or adjustment note | Explains why the payment differs from the charge |
Customer names are not necessary for every cash-up task. Collect personal details only where you need them for the service or customer relationship, and control who can see the record.
When you use a barbershop POS, these service and payment records are the starting point for the day’s report. A spreadsheet works best when staff use the same names and definitions each time.
Keep sales separate from cash movements.
Write the opening float before trading begins. At closing, add cash received and subtract documented expenses, withdrawals and other cash paid out. Compare the expected amount with the cash actually counted.
| Service / barber | Charge | Payment | Reference |
|---|---|---|---|
| Haircut / Barber A | KES 500 | Cash KES 500 | Example sale 001 |
| Haircut and beard / Barber B | KES 700 | M-Pesa KES 700 | Example receipt 002 |
| Beard trim / Barber A | KES 300 | Cash KES 300 | Example sale 003 |
| Total services | KES 1,500 | Cash KES 800; M-Pesa KES 700 | No unpaid balances |
KES 1,000 opening float + KES 800 cash received − KES 200 approved cash expense = KES 1,600 expected in the drawer. If the count is KES 1,550, record a KES 50 shortage to investigate. Match the separate KES 700 M-Pesa receipt to sale 002; do not add it to the physical cash count.
The KES 1,500 sales total remains unchanged by the opening float or expense. This example assumes no refunds, advances, bank deposits or other cash movements.
A difference goes on the checklist with a reason to investigate and a person responsible for following it up. Do not change the opening float after the count just to make the numbers agree.
Check M-Pesa separately against the relevant receipts, reversals and timing. The M-Pesa reconciliation guide explains why a closing balance is not the same as gross receipts.
Review staff earnings from the same set of services.
Use the staff assignment on the sale to build the pay-period totals. Keep refunds, discounts and advances visible, then apply the agreed rule. The commission calculator provides a quick check for a percentage arrangement.
If you pay commission out of the cash drawer, record the cash movement as well as the pay settlement. Otherwise, a correct payment to a barber can look like a shortage when you count the till.
Give the owner something useful to review.
Keep one file or book per agreed period and make the closing records easy to find. Review unexplained differences first, then look for recurring issues: late sales entry, missing expense receipts or services assigned to the wrong person.
The worksheet supports an operating routine. It is not a tax invoice and does not establish eTIMS compliance. Use KRA’s official guidance to confirm invoicing requirements for your business.
Use the management checklist to agree when these records are completed. If you are ready to replace a growing collection of sheets, KinyoziHQ connects the diary, till and staff records in one system.
Bring your closing sheet to a demo.
We’ll show how the service list, payments and staff earnings connect, using the checks you already want the team to do.
See the daily records