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
| Field | What to enter | Example |
|---|---|---|
| Fund name / location | Which 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 |
| Custodian | The one person who holds the key and pays out cash. | Maria Lopez, office manager |
| Period | First and last date covered by this sheet. | Nov 1 – Nov 30, 2026 |
| Per-payment limit | Maximum single payment from petty cash; anything above goes through accounts payable. | $75.00 |
| Opening balance | Cash in the box at the start of the period (normally equal to the float). | $300.00 |
Payment lines (one per voucher)
| Field | What to enter | Example |
|---|---|---|
| Date | Date 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 / description | Who received the money and for what. | USPS, certified mail to landlord |
| Account category | Expense account in your chart of accounts. | Postage |
| Amount out | Cash paid, matching the receipt. | 18.40 |
| Running balance | Previous balance minus this payment (calculated in Excel). | 281.60 |
Count and replenishment
| Field | What to enter | Example |
|---|---|---|
| Count date and counter | When the cash was counted and by whom (not only the custodian). | 2026-11-30, J. Kim (controller) |
| Cash counted | Notes and coins actually in the box. | $169.15 |
| Book balance | Float minus total paid out according to the log. | $169.15 |
| Difference and explanation | Any shortage or overage, with the reason; zero is the goal. | $0.00 |
| Replenishment requested | Total paid out this period, which restores the float. | $130.85 |
| Approved by | Someone 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.
| Fund | Front office cash box, NYC |
|---|---|
| Float | $300.00 |
| Custodian | Maria Lopez |
| Period | Nov 1 – Nov 30, 2026 |
| Count | Nov 30, by J. Kim (controller) |
Payments from the fund
| Date | Description | Category | Amount |
|---|---|---|---|
| 2026-11-04 | USPS certified mail (PC-118) | Postage | $18.40 |
| 2026-11-09 | Printer paper and toner (PC-119) | Office supplies | $42.75 |
| 2026-11-12 | Parking for client visit (PC-120) | Travel | $12.00 |
| 2026-11-18 | Coffee and pastries, client meeting (PC-121) | Meals | $26.50 |
| 2026-11-24 | Same-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
- 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).
- 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.
- Log the payment immediately. Enter the date, voucher number, description, category and amount in the log; the sheet updates the running balance.
- 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.
- Explain any difference. Record shortages or overages with the reason. Never cover a gap from your own pocket without writing it down.
- 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
- IRS: Recordkeeping (checked November 19, 2026)
- IRS: How long should I keep records? (checked November 19, 2026)
- GOV.UK: Company and accounting records (checked November 19, 2026)
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.