Petty Cash Template Excel Free Download //top\\ Review

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.

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

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

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. At the bottom, it tells you exactly how

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.