Petty Cash Log with Cash Count Sheet - Excel Template
Track petty cash movements, compare physical cash on hand, and carry balances forward across 12 months in one practical Excel workbook.
S$2.90
The Petty Cash Log with Cash Count Sheet — Excel Template is a practical workbook designed for accountants, bookkeepers, and business owners who want a simple and organized way to manage petty cash.
Instead of creating a petty cash schedule from scratch, this workbook helps you record petty cash transactions, monitor the running balance, count physical cash on hand, and identify any difference between the physical cash count and the petty cash log balance.
The workbook includes 12 monthly tabs, with formulas linking each month so the opening balance carries forward correctly from the previous month. This helps reduce manual errors and makes petty cash tracking more consistent across the financial year.
Use the Petty Cash Log section to record cash in, cash out, reference numbers, descriptions, and categories. Use the Cash Count Sheet section to count physical cash by denomination and compare it against the book balance.
This workbook includes:
Petty cash log
Cash count sheet
Running balance calculation
Monthly carry-forward opening balances
12 month tabs for full-year use
Setup and configuration tab
Dashboard summary
Color guide and how-to-use instructions
It is suitable for day-to-day petty cash management, month-end checks, internal review, and small business record keeping.
Best for:
Accountants
Bookkeepers
Junior accounting staff
Small business owners
Anyone maintaining petty cash records
This template is also included in the BookJobs Accounting Records Starter Pack bundle.
