Tax and GST

A petty cash book template with columns that work

A petty cash book layout with voucher number, payee, purpose, amount, balance and approver columns, plus a filled fortnight for a small clinic front desk.

Editorial illustration for A petty cash book template with columns that work

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?

ColumnWhat to writeWhy it matters
Voucher no.A running number, V01, V02 and so onLinks the line to a bill or slip
DateDay the cash was paidKeeps lines in order
Paid toShop, person or serviceShows who got the money
PurposeA few words: courier, tea, repairLets you total by type later
Amount (₹)Cash actually paidSubtracted from the balance
Balance (₹)Previous balance minus this amountShows what is left
Approved byInitials of the person who OKed itStops 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.

VoucherDatePaid toPurposeAmount (₹)Balance (₹)
Start3 NovFloat givenOpening float-5,000
V013 NovWater supplierDrinking water cans1204,880
V024 NovCourierLab sample parcel1804,700
V035 NovStationerRegisters2604,440
V047 NovTea stallTea and snacks3404,100
V0510 NovAuto driverFare for reports1503,950
V0612 NovGeneral storeCleaning items4203,530
V0714 NovPrint shopCartridge refill6502,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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports