A petty cash book needs seven columns: voucher number, date, paid to, purpose, amount, balance and approved by. Fill one line per voucher, subtract each amount from the running balance, and when the balance falls low, top up by exactly what the vouchers added to.
What does each column do?
| Column | What to write | Why it matters |
|---|---|---|
| Voucher no. | A running number, V01, V02 and so on | Links the line to a bill or slip |
| Date | Day the cash was paid | Keeps lines in order |
| Paid to | Shop, person or service | Shows who got the money |
| Purpose | A few words: courier, tea, repair | Lets you total by type later |
| Amount (₹) | Cash actually paid | Subtracted from the balance |
| Balance (₹) | Previous balance minus this amount | Shows what is left |
| Approved by | Initials of the person who OKed it | Stops unchecked spending |
A filled fortnight for a clinic front desk
Say the front desk of a small clinic holds a petty cash float of ₹5,000. Over two weeks it pays for small day-to-day needs.
| Voucher | Date | Paid to | Purpose | Amount (₹) | Balance (₹) |
|---|---|---|---|---|---|
| Start | 3 Nov | Float given | Opening float | - | 5,000 |
| V01 | 3 Nov | Water supplier | Drinking water cans | 120 | 4,880 |
| V02 | 4 Nov | Courier | Lab sample parcel | 180 | 4,700 |
| V03 | 5 Nov | Stationer | Registers | 260 | 4,440 |
| V04 | 7 Nov | Tea stall | Tea and snacks | 340 | 4,100 |
| V05 | 10 Nov | Auto driver | Fare for reports | 150 | 3,950 |
| V06 | 12 Nov | General store | Cleaning items | 420 | 3,530 |
| V07 | 14 Nov | Print shop | Cartridge refill | 650 | 2,880 |
Total spent is ₹120 + ₹180 + ₹260 + ₹340 + ₹150 + ₹420 + ₹650 = ₹2,120. Float ₹5,000 minus ₹2,120 equals ₹2,880, which matches the last balance. Cash in the box plus the vouchers must always come to ₹5,000.
How do you keep the vouchers?
Number each bill or slip with the voucher number in pencil or pen, and file them in order behind a cover sheet. If there is no bill, write a small slip by hand with the date, payee, purpose and amount, and ask the person who paid to sign it.
Who should approve a line?
Pick someone other than the person holding the cash. In a small clinic, that may be the doctor or the manager. They initial the line in the last column, ideally at the time of payment, or at least when the vouchers are totalled for the top-up. If the same person pays, writes and approves, the column adds nothing.
What counts as petty cash, and what does not?
Petty cash is for small, frequent, low-value payments where writing a cheque or making a transfer would be silly: tea, couriers, stationery, local fares, minor repairs. Rent, salaries, supplier bills and anything you would want a proper invoice for should go through the bank so the statement records them. Write your own list of allowed items on the inside cover of the book, so the person at the desk does not have to ask each time. Review the list every few months, because what is small for a clinic with ten patients a day is not small for a workshop with two workers.
Can you keep this in Excel or Google Sheets?
Yes. Put the headings in row 1 and the opening float in the Balance column of row 2. In row 3, for the first voucher, enter the amount in column E and a balance formula in column F such as =F2-E3, and copy it down. Keep one sheet per float, so you never need to guess which box a line belongs to. When a sheet stops being enough, SpendixAI lets you add expenses by hand and attach the bill image to each.
Starting checklist
- Print or draw the seven columns.
- Write the float amount and the date on the first line.
- Number every voucher in order.
- Count the box weekly and compare with the last balance.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


