Petty Cash Reconciliation Excel Template | Cash Count & Receipt Tracking Spreadsheet | Small Business Accounting Template

Keep your petty cash records organized with this Petty Cash Reconciliation Excel Spreadsheet Template, designed to make routine cash reconciliation simple, structured, and easy to document. 

This reusable Excel template helps you count physical cash by denomination, record receipts, account for advances and submitted replenishments, and compare your reconciled petty cash against the approved fund amount.

Built-in formulas automatically calculate key totals, helping you quickly identify any difference between the amount accounted for and the approved petty cash fund.

What’s Included

✓ Petty Cash Reconciliation Worksheet
✓ Currency Denomination Tracking
✓ Automatic Cash Balance Calculations
✓ Receipts on Hand Tracking
✓ Automatic Total Receipts
✓ Advances Tracking
✓ Replenishments Currently Submitted
✓ Automatic Reconciled Petty Cash Total
✓ Approved Petty Cash Comparison
✓ Automatic Difference Calculation
✓ Custodian & Department Information
✓ Signature Sections
✓ Disclaimer / Reference Tab

How It Works

1. Add Fund Details
Enter the date, custodian information, department, fund number, and total approved petty cash.

2. Count Your Cash
Enter the quantity of each currency denomination. The spreadsheet calculates the corresponding cash balances and total cash on hand.

3. Record Supporting Amounts
Enter receipts on hand, advances, and replenishments currently submitted.

4. Review Your Reconciliation
The spreadsheet calculates the total reconciled petty cash and compares it with the approved petty cash amount so you can review the resulting difference.

Perfect For

• Small Business Owners
• Bookkeepers
• Office Administrators
• Finance Teams
• Department Managers
• Petty Cash Custodians
• Entrepreneurs
• Administrative Professionals

Why You’ll Love It

✓ Simple and organized layout
✓ Built-in Excel calculations
✓ Reusable for ongoing reconciliations
✓ Tracks multiple components of petty cash
✓ Helps document cash counts and receipts
✓ Quickly highlights reconciliation differences
✓ Professional business-friendly format

Digital Product

This is a digital Excel spreadsheet template. No physical product will be shipped.

Download the file, open it in Microsoft Excel, enter your information, and reuse the template whenever you need to perform a petty cash reconciliation.

Important: This template is provided as a general organizational and record-keeping resource. Please review the included disclaimer and determine whether the template is appropriate for your individual business, accounting, or record-keeping requirements.