Petty Cash Template
Track petty cash fund with this simple log and reconciliation template.
What's Included:
- Running balance log tracking every withdrawal and replenishment
- Reconciliation section comparing physical count to log balance
- Category breakdown showing where petty cash is being spent
- Replenishment alert that triggers when the fund falls below a set threshold
Available Formats:
Download Free Template
Enter your email to download this template instantly. We'll also send you tips on financial management.
Petty cash funds are small but require diligent tracking to prevent losses and ensure accountability. This template creates a paper trail for every dollar that leaves the fund, with receipt references and category coding for each transaction.
Weekly reconciliation is the key to a well-managed petty cash fund. Count the physical cash, enter the amount, and compare it to the log. If there is a discrepancy, the template flags it in red so you can investigate immediately. The replenishment alert notifies you when the fund drops below your set threshold so you never run out of petty cash when someone needs it.
How to Use This Template
Set Your Fund Amount
Enter the starting petty cash fund amount (e.g., $200) and the minimum threshold at which you want a replenishment reminder.
Record Every Transaction
Log each petty cash withdrawal with the date, recipient, amount, purpose, and category. Attach or reference the receipt for every expenditure.
Reconcile Weekly
Count the physical cash remaining, enter the count, and compare it to the log balance. Investigate and document any discrepancies immediately.
Frequently Asked Questions
How much should a petty cash fund be?
Most small businesses start with $100-$500, depending on how frequently small cash purchases are needed. Set the amount high enough to cover two to four weeks of typical small purchases without constant replenishment. This template lets you set any starting amount.
How often should petty cash be reconciled?
Reconcile at least weekly—more often if multiple people have access to the fund. The template compares the physical cash count to the running balance and flags any discrepancies that need investigation.
Related Financial Resources
Tired of manual spreadsheets?
FiscalInsights automates everything this template does—plus cash flow forecasting, expense categorization, and real-time insights.
Try FiscalInsights Free