Petty Cash Format in Excel (Free Template + How to Use It)
Keeping office petty cash in a notebook or a hastily-made sheet is exactly where small amounts quietly go missing - ₹200 here, ₹500 there, and by month-end the cash box and the record never match. A clean petty cash format in Excel fixes most of that, as long as it has the right columns and a running balance. Here's a free one you can download and start using today (use the download button above).
What's in the template
The template gives you a proper petty cash book, not just a blank grid:
- Date - when the spend happened
- Description - what it was for
- Category - Pantry, Travel, Stationery, and so on (a suggested list is on the second tab)
- Money Out - the amount spent
- Money In - top-ups added to the cash box
- Balance - calculated automatically, so you always know what should be in the box
There's also an Opening float cell at the top - set it once and the running balance flows from there.
How to use it
- Set your opening float - the fixed amount you keep in the cash box (say ₹2,000).
- Log every spend the moment it happens - date, description, category, and the amount in Money Out. Don't wait for the end of the week.
- Record top-ups in Money In whenever you refill the box.
- Let the Balance column do the maths - it updates itself on every row.
- Keep a slip for each spend so you can reconcile without guessing.
Common mistakes to avoid
- Logging weekly instead of daily - you'll forget the small ones, and those are the leaks.
- Skipping the category - without it, month-end sorting is painful.
- Sharing one file among many people - this is where Excel starts to hurt.
Where Excel starts to hurt
Excel is perfect for one person. The moment your team shares it, the cracks show: the file lives on one laptop, two people can't edit at the same time, a stray click overwrites a formula, and nobody's sure which copy is the latest. If only you touch the petty cash, the template above is all you need. If several people spend, read on.
A simpler option when you outgrow Excel
If more than one person handles petty cash, our simple online expense tracker keeps a single shared copy that totals itself, works on any phone, and never breaks a formula - it handles petty cash and more. It's the same idea as this template, just always current and shared. Prefer to learn the system first? Read How to manage petty cash.