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.
: Vertex42 offers a straightforward printable and customizable Excel template perfect for basic tracking.
The following sources offer free, safe, and customizable Excel templates. petty cash template excel free download
Weekly or monthly, a manager (not the custodian) should:
No trial periods, no email sign-up walls (if you know where to look—try Template.net or Vertex42). You download the .xlsx file and own it forever. This is Excel-only
| | A | B | C | D | E | F | G | |:---|:---|:---|:---|:---|:---|:---|:---| | | Date | Description | Category | Receipt # | Debit (Expense) | Credit (Deposit) | Balance | | 2 | 01/01/24 | Opening Float | N/A | N/A | $0.00 | $300.00 | $300.00 | | 3 | 01/02/24 | Stamps | Postage | 101 | $15.00 | $0.00 | $285.00 | | 4 | 01/03/24 | Coffee Supplies | Kitchen | 102 | $22.50 | $0.00 | $262.50 | | 5 | 01/05/24 | Taxi Fare | Travel | 103 | $18.00 | $0.00 | $244.50 | | 6 | TOTALS | | | | $55.50 | $300.00 | |
A is the simplest, most effective way to maintain accountability without the need for expensive accounting software. In this guide, we’ll explore why you need a petty cash log and provide a link for a free download to get you started today. What is Petty Cash and Why Does It Matter? You download the
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.
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.