Finance & approvals

Petty cash log template: track, count and top up your cash box

A petty cash log is the running record of a small cash fund kept in the office for minor purchases such as postage, parking, courier fees and coffee for a client meeting. Every payment out of the box is written down with a voucher number, so at any moment the cash in the box plus the receipts equals the fixed float.

Below you get a free petty cash log template in Excel with an automatic running balance, an explanation of every field, a filled-in example with a month-end count, and the controls auditors expect: one custodian, receipts for every line, surprise counts and a replenishment request signed by someone other than the custodian.

What is a petty cash log?

Most companies run petty cash on the imprest system. Finance gives a custodian a fixed amount, the float, for example $300. When someone needs to pay a small business cost in cash, the custodian pays from the box, collects the receipt and records the payment in the log. When the box runs low, or at month end, the custodian totals the log, counts the cash and asks finance to replenish exactly the amount spent, which brings the box back to $300.

The log is different from a cash advance, where money is handed to one employee before a trip and settled afterwards, and from an expense report, where an employee who paid with their own money asks to be paid back. Petty cash is the company's own money in a box, so the log is effectively a mini cash book that feeds the general ledger each time the fund is replenished.

When to use it

  • Your office regularly pays small amounts in cash: stamps, parking, taxi fares, courier fees, light refreshments or urgent supplies.
  • You are setting up a new petty cash fund and need a standard record before handing over the float.
  • Month-end or quarter-end close, when the fund must be counted, reconciled and replenished so the expenses reach the books in the right period.
  • An auditor or new finance manager asks how cash outside the bank is controlled.
  • Several branches or sites each hold a small float and head office needs the same format from all of them.

Petty cash log template: every field explained

The Excel file has three blocks: the fund header, one line per payment with a running balance, and the count and replenishment block at the bottom.

Fund header

FieldWhat to enterExample
Fund name / locationWhich box or site this log belongs to.Front office cash box, NYC
Float (imprest amount)The fixed amount the fund is restored to after each replenishment.$300.00
CustodianThe one person who holds the key and pays out cash.Maria Lopez, office manager
PeriodFirst and last date covered by this sheet.Nov 1 – Nov 30, 2026
Per-payment limitMaximum single payment from petty cash; anything above goes through accounts payable.$75.00
Opening balanceCash in the box at the start of the period (normally equal to the float).$300.00

Payment lines (one per voucher)

FieldWhat to enterExample
DateDate the cash left the box.2026-11-04
Voucher no.Sequential number written on the petty cash voucher and on the receipt.PC-118
Paid to / descriptionWho received the money and for what.USPS, certified mail to landlord
Account categoryExpense account in your chart of accounts.Postage
Amount outCash paid, matching the receipt.18.40
Running balancePrevious balance minus this payment (calculated in Excel).281.60

Count and replenishment

FieldWhat to enterExample
Count date and counterWhen the cash was counted and by whom (not only the custodian).2026-11-30, J. Kim (controller)
Cash countedNotes and coins actually in the box.$169.15
Book balanceFloat minus total paid out according to the log.$169.15
Difference and explanationAny shortage or overage, with the reason; zero is the goal.$0.00
Replenishment requestedTotal paid out this period, which restores the float.$130.85
Approved bySomeone other than the custodian signs off the replenishment.J. Kim, 2026-11-30

Petty cash log example (filled in)

A $300 office fund for November. Each line has a voucher number and a receipt; at month end the controller counts the box and approves the top-up.

FundFront office cash box, NYC
Float$300.00
CustodianMaria Lopez
PeriodNov 1 – Nov 30, 2026
CountNov 30, by J. Kim (controller)

Payments from the fund

DateDescriptionCategoryAmount
2026-11-04USPS certified mail (PC-118)Postage$18.40
2026-11-09Printer paper and toner (PC-119)Office supplies$42.75
2026-11-12Parking for client visit (PC-120)Travel$12.00
2026-11-18Coffee and pastries, client meeting (PC-121)Meals$26.50
2026-11-24Same-day courier, signed contract (PC-122)Courier$31.20
Total paid out$130.85

Float $300.00 − total paid out $130.85 = $169.15 cash on hand, which matched the count exactly. Replenishment request: $130.85, which brings the box back to $300.00.

Free download

Free, no sign-up. Opens in Excel, Google Sheets, Numbers, Word, Google Docs and LibreOffice.

Open the downloaded file in Nobami, our web office, to edit it right away.

How to run a petty cash log

  1. Set the float and the rules. Pick a float that covers two to four weeks of small spending, name one custodian, and write down the per-payment limit and what petty cash may not be used for (salaries, loans, personal items).
  2. Pay only against a voucher. For every payment, fill in a numbered voucher with date, amount, purpose and the recipient's signature, and staple the original receipt to it.
  3. Log the payment immediately. Enter the date, voucher number, description, category and amount in the log; the sheet updates the running balance.
  4. Count the cash regularly. At least monthly, and occasionally without warning, count the box with a second person and compare it with the book balance.
  5. Explain any difference. Record shortages or overages with the reason. Never cover a gap from your own pocket without writing it down.
  6. Request replenishment. Total the period, attach the vouchers and receipts, and send the replenishment request for approval; finance posts the expenses by category and restores the float.

Record-keeping notes (US, UK and elsewhere)

United States: petty cash payments are deductible business expenses only if you can show what they were for. The IRS asks businesses to keep supporting documents such as receipts, cash register tapes and invoices, and to keep records for as long as they may be needed to support the return, which is generally three years from filing.

United Kingdom: limited companies must keep accounting records, including receipts and petty cash records, for six years from the end of the financial year they relate to, or longer in some cases.

Rules on receipts, cash limits and retention differ by country. See the local versions of this page for Korea, Japan, Taiwan, Spain, Germany and others.

Sources

General information, not accounting or tax advice. Limits and retention periods change; confirm with your accountant or the official source.

Common petty cash mistakes

  • Paying out without a receipt or voucher, so the expense cannot be booked or defended in an audit.
  • Putting employee IOUs or personal loans in the box; they are receivables, not expenses, and hide shortages.
  • Letting the custodian approve their own replenishment, which removes the only independent check.
  • Setting the float too large, so a lot of cash sits unprotected and differences are noticed late.
  • Never doing a surprise count; regular counts announced in advance are easy to prepare for.
  • Using petty cash for purchases that should go through purchasing or payroll.

Petty cash log FAQ

What is the imprest system?

A fixed float is kept in the fund. Each replenishment equals exactly what was spent, so cash in the box plus receipts always equals the float, which makes shortages easy to spot.

How big should the petty cash float be?

Big enough for two to four weeks of small payments and no larger. Many small offices use a few hundred dollars and replenish monthly or when the balance falls below a set level.

How is a petty cash log different from a cash advance or an expense report?

A cash advance is money given to one employee before a trip and settled afterwards. An expense report repays an employee who used their own money. Petty cash is a company fund paid out directly to suppliers or for small costs and topped up on the imprest basis.

What if the count does not match the log?

Recount with a second person, look for an unrecorded voucher or a calculation error, then record the difference as cash over and short with an explanation. Repeated differences mean the controls need tightening.

Who should approve the replenishment?

Someone other than the custodian, usually the finance manager or controller, after checking that each line has a voucher and a receipt.

Submit this form for approval in Workbami

Stop emailing spreadsheets around. Fill in, approve and file it in Workbami, where approvals, reports and team chat live together. Free during the beta.

Start free

Related templates

← All templates