Petty cash log spreadsheet template
A working Excel petty cash log. Record each payment out against its receipt and each top-up in; the sheet keeps a running balance of what should be in the tin, totals spending by category for any period, and has a count section that compares the expected cash with what you actually count. Free, no sign-up and no email address.
What is in it
| Sheet | One row per | What it does for you |
|---|---|---|
| Petty cash | Payment or top-up | Date, details, receipt or voucher number, category, money in, money out, the VAT included in a payment, and who it was paid to. The balance column works out what should be in the tin after every line. |
| Summary and count | Category | Spending by category and the VAT within it for the dates you choose, then the cash count: what should be in the tin, what you counted, the difference, and the top-up needed to bring it back to the float. |
How a petty cash float works
Decide a float, say £100, and put that amount in the tin. Every time cash goes out, a receipt goes in and a line goes in the log. At any moment the cash plus the receipts should add up to the float. When the cash runs low, top the tin back up to the float; the amount you add equals what was spent, which is the figure that goes into your accounts by category. This is usually called the imprest system.
Why the count matters
A log on its own only tells you what was written down. The count tells you whether that is the whole story. Count the tin, type the amount into the count section, and the difference shows at once. A shortfall means cash is missing or a payment went unrecorded, and it is far easier to explain on the day than at the year end.
Receipts and VAT
Give each receipt a number and write the same number on the line, so any payment can be traced to its paper. If you are VAT registered, enter the VAT shown on the receipt in its own column; whether it can be reclaimed depends on having a valid VAT receipt and on what was bought, which is a question for HMRC's guidance or your accountant.
The bigger pile
Petty cash is the small paperwork. Supplier invoices are the large pile, and they arrive as PDFs, scans and photos. Invoices to Spreadsheets turns a folder of those into one checked table you can export to Excel. Try one invoice free, without an account.
Is the petty cash template free?
Yes. Download it, use it, change it. No account, no email address, no card.
How do I record a top-up?
Enter the date, a note such as "Top-up", and the amount in the Money in column. The balance goes up by that amount. On the imprest system the top-up equals what has been spent since the last one.
What if the cash in the tin does not match the balance?
Type the counted amount into the count section. The difference line shows how much is over or short. Check for receipts not yet entered, then for a payment with no receipt, before treating it as a loss.
Can I change the categories?
Yes. The categories are a dropdown on the Category column and a list on the summary sheet. Change the name in both places so the totals still match.
Does it work in Google Sheets or Numbers?
Yes. It is a standard .xlsx file using SUM and SUMIFS, with an ordinary dropdown. Set your locale to United Kingdom before importing so dates are read day first.
7 days · 50 documents · No card needed
All free tools and templates · Self-employed income and expenses template · Business mileage log template