Petty cash book for clinics
Every small cash payment in one place, with who paid, who approved and whether the receipt is there. The balance runs per branch against its float, and the month shows which kind of spending grew.
Download
FreeNo sign-upDownloads directlyExcel and Google Sheets
What is inside
| Settings | Clinic name, currency, branches with each one’s float, staff, and the expense types. |
|---|---|
| Petty cash book | One row per payment: date, branch, type, description, amount, paid by, approved by and receipt attached. The balance runs per branch; top-ups from the main cash office add to it. |
| Monthly summary | Expense types against months for one branch or all, with totals, top-ups and spending without a receipt. A type that doubled on the month before is coloured red. |
| Top-up request | Pick a branch and a period: spending by type, entries without a receipt, the balance and the amount to bring the float back. One page with signature lines. |
How to use it
Set the floats
Each branch with the cash it holds, the staff and your expense types.
Record each payment
Who paid, who approved, and whether the receipt is attached.
Read the month
Look for red cells: a type that doubled needs a question.
Request the top-up
Print the request for the period, attach the receipts and sign.
Who it is for
Clinic managers and accountants who hand a small float to reception or a branch and want it accounted for every month. The sample covers August and September 2026 at two branches; in September urgent consumables double, which usually means stock is running out before the order arrives.
Questions
Does it work in Google Sheets?
Yes. Upload it to Google Drive and open it with Google Sheets. It uses SUMIFS, COUNTIFS, INDEX and MATCH, which both handle.
Can I change the currency?
Yes. Pick it on the Settings sheet. The amounts are numbers, so the sums do not change.
Is my data stored anywhere?
No. The file is yours, on your computer or your own Drive. Nothing you type reaches Medicolize.
Can each branch keep a different float?
Yes. Each branch has its own float on Settings, and its balance only counts its own payments and top-ups.
Petty cash inside the treasury
In Medicolize the petty cash drawer is an account in the treasury with its own balance per branch, and each expense is posted against the account that paid it. Thirty minutes on your own clinic.