Free Petty Cash Log Spreadsheet Template
Track small cash transactions with date, description, and amount. Maintain a running balance and reconcile the petty cash fund.
What's Included
- Dashboard with petty cash fund summary showing starting balance, total disbursed, and remaining fund amount
- Cash log with date, payee, description, and amount columns plus an automatic running balance after each entry
- Category tracking for each disbursement so petty cash spending can be grouped by office supplies, travel, meals
- Fund reconciliation support with replenishment entries to reset the cash balance to the original fund amount
- Color-coded input cells (yellow) and auto-calculated running balance (blue) for accurate cash tracking
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Preview
See what's inside this template
How to Use This Petty Cash Log Template
Set the fund amount
Enter the starting petty cash fund balance at the top. This is the amount initially placed in the cash box.
Log each disbursement
Record every cash payment with date, payee, description, amount, and category in the cash log.
Monitor the balance
The running balance updates after each entry. Check it against the actual cash in the box to verify accuracy.
Replenish the fund
When the balance gets low, add a replenishment entry to bring the fund back to the original amount.
Built by Claude AI. Perfected by us.
We use Claude AI to draft each free template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.
Frequently Asked Questions
How do I reconcile the fund?
Count the physical cash, add up outstanding receipts, and compare to the expected balance in the log. Any difference is a variance to investigate.
What categories should I use?
Common categories include office supplies, postage, meals, parking, and miscellaneous. Use whatever matches your typical small cash expenses.
How often should I replenish?
Replenish when the fund balance gets low - typically when 50% to 75% has been disbursed. The log entry restores the balance to the original amount.
Can I track multiple petty cash funds?
This template covers one fund. Duplicate the file if you maintain separate petty cash funds at different locations or departments.
How do I open this in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
What license is this template under?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
More Free Business Finance Templates
Looking for premium spreadsheet templates?
Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.