FREE 14+ Petty Cash Log Templates Excel

A petty cash log records small cash payments and the remaining cash held by a custodian. Each entry should be supported by a receipt or approved voucher.

Choose a log with date, voucher number, purpose, money in, money out, balance, and authorization. Keep personal spending outside the fund.

Template previews and downloads

How to use the petty cash log template

Step 1. Record the verified opening float. Categorize approved costs in expense trackers.

Step 2. Enter each authorized payment and attach its supporting reference. Post the summarized expenses into bookkeeping templates.

Step 3. Count physical cash and reconcile it with the log before replenishing the fund.

Give vouchers or receipts a consistent reference and record the custodian responsible for the float. A running balance is useful only when payments are entered promptly and the physical money can be counted against it. Keep advances outstanding until they are properly settled.

When replenishing the fund, reconcile the cash remaining plus supported expenditure to the authorized float. Investigate shortages or overages openly. Do not change a receipt amount merely to force the total to match the money in the box.

Example and checks

A float of 200 less supported payments of 35 and 20 leaves expected cash of 145. Investigate any difference from the physical count.

Replenishing the fund is not a second expense for the same receipts. Preserve a clear record of what each replenishment covers. Use expense reports to present a period summary.