SheetComparePetty Cash Reconciliation Template
Track every petty-cash transaction with a running-balance formula so the sheet total always matches the cash in the box.
What's in it
- Cash In — Top-ups added to the petty cash float.
- Cash Out — Amounts paid out, backed by a receipt.
- Running Balance — Auto-calculated balance after each transaction (previous balance plus in, minus out).
- Receipt — The receipt reference for each payment out.
Petty cash goes wrong quietly: a payment made without a receipt, a top-up that wasn't logged, and suddenly the box doesn't match the book. This template logs each transaction with a running-balance formula, so the sheet always shows what should be in the box, and reconciling is just comparing that figure to the physical count.
Each row carries a receipt reference so every payment is backed up. Add a row per transaction and the running balance updates down the column automatically.
How to use it
- 1
Log every transaction
One row per top-up or payment, with the date, description, receipt reference, and the amount in or out.
- 2
Watch the running balance
The Running Balance column calculates after each row, so the last value is what should physically be in the box.
- 3
Reconcile to the count
Count the actual cash and compare it to the final running balance. A gap means a missing receipt or an unlogged transaction.
Frequently asked questions
How does the running balance work?▾
Each row adds Cash In and subtracts Cash Out from the previous row's balance, using a live formula. Insert rows in order and it keeps calculating.
What if the box doesn't match the sheet?▾
Look for a payment made without a receipt, a top-up that wasn't logged, or a transposed amount. The running balance pinpoints where the two diverge.
Can I reconcile two periods?▾
Yes, keep a workbook per period and diff them in SheetCompare to see every transaction added or changed.
Related templates
Bank Reconciliation Template
Match your ledger against the bank statement, with a live difference column and totals that flag anything out of balance.
General Ledger Reconciliation Template
Reconcile each GL account against its subledger, with an automatic difference column, a reconciled flag, and a reviewer column for sign-off.
Credit Card Reconciliation Template
Match each statement charge against what you recorded, with a variance column that flags mismatches and category tracking.