Petty Cash Template Excel [extra Quality] Free Download Jun 2026

Several reputable sources offer free, pre-formatted templates to help you log these transactions:

: For educational or institutional use, UPEI and MSOfficeGeek provide summary sheets and "imprest" style books that include automated reconciliation formulas. How to Use a Petty Cash Excel Sheet 23 Free Small Business Bookkeeping Templates - Smartsheet

The beauty of using Excel over a paper log is the . As you enter expenses, the sheet should subtract them from your total, giving you a real-time view of your funds. 4. Reconciliation and Replenishment petty cash template excel free download

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.

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. My assistant, who is terrified of Excel formulas,

Only one person (the Petty Cash Custodian) should have the key to the cash box.

: Vertex42 offers a straightforward printable and customizable Excel template perfect for basic tracking. "Cleaning supplies"). This is Excel-only.

A brief note on what was purchased (e.g., "Cleaning supplies").

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.