This is the killer feature. You enter the starting fund amount (e.g., $200). As you log expenses, the template subtracts them automatically. At the bottom, it tells you exactly how much cash should be in the box. If it’s wrong, you know someone made a math error or forgot a receipt.
Good templates include a column for "Voucher #." This forces you to use a petty cash slip system, which auditors love. Without this, you’re just guessing. petty cash template excel free download
Most free templates come with generic categories. You will have to manually edit the dropdown list to match your Chart of Accounts (e.g., change "Office Supplies" to "Cleaning Supplies"). This is the killer feature
Unlike paid apps (Expensify, Zoho), you can’t attach a photo of the receipt inside the spreadsheet. You still need a physical envelope or a separate folder for scanned PDFs. Who This Is For (And Who Should Skip It) | ✅ Perfect for... | ❌ Avoid if... | |----------------|----------------| | Offices with 1-10 employees | You have more than 3 cash boxes | | Monthly fund size under $500 | You process over 50 transactions/month | | You are comfortable with basic Excel | You need mobile receipt scanning | | You want a free audit trail | Your accountant requires cloud backups | Final Verdict Download this template. It’s a massive upgrade from tracking cash on a sticky note or in a notebook. For the price of $0, the automated reconciliation alone saves me at least 2 hours of frustration every month. At the bottom, it tells you exactly how
My assistant, who is terrified of Excel formulas, figured this out in 10 minutes. You only type into white cells; grey cells (totals, balances) are protected formulas. The Cons (Read Before Downloading) 1. No Multi-Currency or Petty Cash Accounts If you have two separate cash boxes (e.g., Front Desk + Warehouse), you’ll need two separate files. The template assumes one fund.