Petty Cash Template Excel Free Download [extra Quality] 【2026 Edition】

This is Excel-only. You cannot easily log an expense from your phone while buying donuts. You’ll need to save receipts and type them in later.

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. petty cash template excel free download

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. This is Excel-only

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. This is the killer feature

Overall Rating: ⭐⭐⭐⭐ (4.5/5)

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.

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").