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 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. petty cash template excel free download
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. Good templates include a column for "Voucher #
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. You cannot easily log an expense from your
