Petty Cash Excel Template
Track petty cash transactions with running balance, categories, and auto totals.
Template Preview
| Date | Description | Category | Amount | Receipt # | Approved By | Balance |
|---|---|---|---|---|---|---|
| 2026-01-01 | Opening Balance | — | 500.00 | — | — | 500.00 |
| 2026-01-03 | Office supplies | Office Supplies | -45.00 | R001 | J. Smith | 455.00 |
| 2026-01-05 | Taxi fare | Transportation | -25.00 | R002 | J. Smith | 430.00 |
| 2026-01-10 | Replenishment | — | +200.00 | — | — | 630.00 |
Enter your email to download
We'll send you occasional tips and updates. No spam, unsubscribe anytime.
Download Ready!
Sent to:
How to Use This Template
- 1Download the CSV file and open it in Excel or Google Sheets.
- 2Enter your opening balance in the first row.
- 3Add each transaction with date, description, category, and amount.
- 4The Balance column auto-calculates the running balance.
FAQ
What format is the template?
The template downloads as a CSV file that opens directly in Excel, Google Sheets, or any spreadsheet application.
Is the template free?
Yes, completely free. Just enter your email to unlock the download.
Does it calculate the running balance?
The template includes a Balance column with a formula that auto-calculates the running balance after each transaction.
Automate Your Petty Cash
PettyCash tracks every transaction automatically — no spreadsheets needed.
Try PettyCash Free