Office guide

How to Use Petty Cash Log Builder

A petty cash log records every addition and expense so the calculated balance can be reconciled with the physical cash. References and descriptions make discrepancies easier to investigate.

Open the Petty Cash Log Builder

What to prepare

A few reliable inputs make the first result easier to review.

  • The verified opening cash and currency
  • Receipts or vouchers for each transaction
  • The current physical cash count for reconciliation

How to Use Petty Cash Log Builder

  1. Enter the opening cash, currency, and physical count
  2. Add each transaction with date, description, type, amount, and reference
  3. Build the ledger and compare calculated closing cash with the physical count
  4. Investigate any variance, then export the reconciled record

Worked example

Start with $200, record a $24.50 office-supply expense and a $50 replenishment, and expect $225.50. If the cash count is $220.50, investigate the $5 variance before closing the period.

Review the result

Check arithmetic, duplicate entries, missing vouchers, and transactions recorded with the wrong type. Reconciliation should be performed by the responsible person under the organization’s controls.

Practical tips

  • Number receipts in sequence
  • Record replenishments separately from refunds
  • Close and archive the log on a regular schedule

Common mistakes to avoid

  • Changing the opening balance to hide a variance
  • Recording a cash withdrawal with no purpose
  • Mixing more than one currency in a single ledger

Build it in your browser

The free Petty Cash Log Builder processes entries locally in your browser. Review the generated draft against source information and any policy that applies before sharing it.

Use the Petty Cash Log Builder