Petty Cash Log Essentials 模板
Track small cash transactions with date, description, and amount. Maintain a running balance and reconcile the petty cash fund.
包含内容
- 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
预览
查看此模板的内容
如何使用这个Petty Cash Log模板
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.
由 Claude AI 构建，经我们精心打磨。
我们使用 Claude AI 在深入研究后起草每个模板。然后由团队接手，优化布局、全面测试每个公式、修复边界情况，并打磨设计，直到达到我们自己愿意使用的标准。AI 完成了 80% 的工作，最后 20% 靠的是人工判断。
常见问题
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.
如何在 Google Sheets 中打开？
将 .xlsx 文件上传到 Google Drive，然后使用 Google Sheets 打开。所有公式和格式都会保留。