Petty Cash Log Template
Small cash purchases are the easiest transactions to lose track of — no bank record, no automatic paper trail. This log tracks every dollar in and out of your petty cash box, with a running balance that should always match what’s physically in the drawer.
Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt
Who this is for
- Businesses that keep a small cash fund for minor purchases
- Retail or restaurant owners managing a cash drawer
- Office managers responsible for reimbursing small out-of-pocket purchases
- Anyone who has ever had a petty cash box that didn’t match its log
What's included
- Disbursement log with date, purpose, and amount
- Cash replenishment tracking when the fund is topped up
- Automatic running balance that should match your physical cash count
- Built-in AI prompt to flag unusual spending patterns
Why use a template instead of starting from scratch?
Small cash transactions have no bank statement to fall back on if something doesn’t add up — the log itself is the only record. Keeping it current and reconciling it against the actual cash on hand regularly is the only way to catch a discrepancy before it becomes a bigger, unexplainable gap.
How to Use This Template
Download and open in Excel or Google Sheets
Requires a Tools Club membership — log in first to access the file.
Set your starting cash balance
This should match what’s actually in the petty cash box on day one.
Log every disbursement immediately
Date, purpose, amount, and ideally who took the cash — the more specific, the easier to reconcile later.
Log replenishments when you top up the fund
Record exactly how much cash was added and when.
Count the physical cash and compare to the running balance regularly
Any mismatch needs to be investigated right away, while it’s still traceable.
Built-in AI prompt
Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether your disbursement pattern looks reasonable, and any transactions worth double-checking given the amounts and frequency, no accounting background required.
Common Mistakes to Avoid
Not requiring a receipt for every disbursement
Even small cash purchases should have a receipt attached or referenced — this is what makes the log defensible if questioned later.
Letting entries pile up instead of logging in real time
The longer you wait to log a disbursement, the more likely details get forgotten or the physical cash count drifts from the recorded balance.
Skipping regular physical cash counts
The log is only useful if you’re actually verifying it against the real cash on hand — do this on a set schedule, not just when something feels off.
Using petty cash for larger, recurring expenses
Petty cash is meant for small, occasional purchases — a recurring expense should go through your normal accounts payable process instead.
Frequently Asked Questions
Related Templates
Related Resources
Want the Full Template Library?
70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.
Join the Tools Club