Petty Cash Log with Cash Count Sheet - Excel Template

Who is this for?

Business owners, office managers and accountants who handle physical cash and need a proper system to track, reconcile and report petty cash — every single month.

What makes this different?

Most petty cash templates are a single page. This is a complete 12-month management system — one tab per month, auto carry forward, and a physical cash count sheet built in.

What's inside:

📒 12 Monthly Tabs — each with its own petty cash log (50 rows) and cash count sheet. Change one date in Setup and everything recalculates for your financial year.

🪙 Cash Count Sheet — count physical cash by denomination. Total auto-calculates and compares against book balance. Difference highlighted red — with an explanation field.

📊 Dashboard — full year summary. Monthly closing balances, total cash in, total cash out and transaction count at a glance.

⚙️ Setup — enter company name, custodian, financial year end month and opening balance once. Everything flows from there.

Key features:

— 12 monthly tabs ordered by YOUR financial year — just set your year end month

— Opening balance auto-carries from previous month — no manual entry

— Cash count sheet with 15 denomination rows

— Difference alert — red highlight when physical cash doesn't match book balance

— 10 customisable expense categories

— Yellow cells = your input. Green cells = auto-calculated.

Instant download. One-time payment. No subscription.

Questions? templates@getbookjobs.com