Free Petty Cash Template Download: Excel, Word, PDF, Google Sheets & Docs

What is The Petty Cash Template?

A Petty Cash Template is a tool used to record and monitor minor, day-to-day cash expenditures within a business. Petty cash refers to a small reserve of physical cash held on-site, typically secured in a locked drawer or box, and used for immediate, low-cost purchases, such as office supplies, staff refreshments, or travel costs, without going through the formal procurement process.

This petty cash Excel template plays a crucial role in maintaining financial accuracy, ensuring accountability, and minimizing fraud by creating a clear audit trail. While digital bookkeeping handles most large transactions, petty cash remains a manual and localized process, usually overseen by a designated petty cash custodian, making this template essential for reconciling funds, managing replenishments, and maintaining transparency.

The proper use of a petty cash log template ensures that even the smallest expenditures are tracked, approved, and categorized, contributing to sound financial oversight and regulatory compliance.

What Does a Petty Cash Log Template Contain?

1- Business Information Header

At the top, fill in core identifiers:

• Business Name & Address: Ensures the log is company-specific, critical if you're managing multiple branches or departments.
• Reporting Period: Clarifies the start and end dates of the cash log. Ideal for monthly, biweekly, or project-based tracking.
• Beginning Balance: Marks the initial cash amount on hand at the start of the reporting period, forming the base for all calculations.

2- Transaction Log Table

This is the operational heart of the petty cash template Excel:

• Date: The transaction date, not the logging date. This maintains chronological accuracy and improves reconciliation.
• Receipt Number: A unique identifier for each transaction, matched with physical or digital receipts.
• Paid To / Received From: Identifies who received or returned funds, essential for follow-ups or dispute resolution.
• Purpose: Describes what the cash was used for (e.g., "Uber to client meeting," "Printer ink"). The more specific, the better.
• Approved By: Indicates managerial sign-off, deterring unauthorized spending and reinforcing accountability.
• Cash Out / Cash In: Log disbursements and reimbursements, respectively. Every transaction must flow through one of these two columns.
• Running Balance: Automatically calculates the remaining petty cash after each transaction. This column ensures real-time cash tracking.

3- Reconciliation Section

• Prepared By / Verified By / Approved By: Role-based fields for final oversight. These confirm that the recorded transactions match the physical cash on hand.
• Cash on Hand: Physically count your remaining cash and record it here.
• Difference: Highlights discrepancies between the recorded balance and the physical cash. A positive or negative number here triggers review and correction.
• Petty Cash Reimbursement: If the fund is low, use this field to indicate how much needs replenishment.
• Balance Forward: If rolling over to the next period, record the new beginning balance.

What Enerpize Petty Cash Template Includes

Most free petty cash templates online give you a log and nothing else. Ours doesn't stop there. After reviewing how petty cash is actually used, and where the gaps show up when a business tries to reconcile a fund at month-end, we built in three things most templates leave out entirely.

A dedicated petty cash voucher, not just a log. Most templates describe the difference between a voucher and a log in a paragraph of text and then only give you the log. Ours includes both, an actual one-transaction voucher slip alongside the master log, so every disbursement has a paper trail from the moment cash leaves the box, not just a line item added later.

A custodian and threshold field built into the header, not just mentioned in a tip. Every petty cash guide tells you to name a custodian and set a reimbursement threshold. Almost none of them give you a field to actually record it. Ours does, right in the Business Details block, so the policy lives in the document, not in a separate memo someone has to remember exists.

Reimbursement math that actually ties back to the float. Most templates just show a running balance and a manual reconciliation line. Ours calculates Reimbursement as Beginning Balance minus Cash on Hand, so it tells you exactly how much to top the fund back up to, and Balance Forward automatically reflects that restored amount, instead of leaving you to do that arithmetic by hand every period.

Available in Excel, Word, PDF, and Google Sheets.

How to Use the Petty Cash Template

1- Set Up Your Petty Cash Fund

Before logging anything, ensure you have:

• A designated petty cash custodian
• A defined maximum fund limit
• Approval protocols are in place

Start by entering your business details at the top: name, address, reporting period, and initial balance. These become the reference points for every entry.

2- Log Transactions in Real Time

Don’t delay recording. As transactions occur:

• Fill in the date of the transaction
• Assign a receipt number (sequential or based on receipt file names)
• Identify the recipient (e.g., the employee or vendor)
• Clearly state the purpose ("Snacks for client meeting" > "Food")
• Note who approved the spend
• Record the cash out amount for purchases, or cash in for returns
• Update the balance after each entry to maintain accuracy

Expert Tip: Use a petty cash voucher form for each transaction and staple it to the corresponding receipt. This makes reconciling effortless.

3- Monitor the Balance

Always know how much petty cash is available. The running balance column auto-adjusts with every entry.

• If your balance is running low, use the Reimbursement field to signal replenishment.
• Avoid letting the balance hit zero; this causes process breakdowns.

Expert Tip: Assign a minimum threshold (e.g., “Reimburse when below $50”) to automate your refill process.

4- Conduct Periodic Reconciliation

At the end of each reporting period—or when replenishment is needed—perform a formal reconciliation.

Steps:

1. Count the actual cash in the petty cash box
2. Compare it with the final balance on the sheet
3. Record the amount in Cash on Hand
4. If there's a discrepancy, log it in the Difference field
5. Have the custodian, a verifier, and an approver sign off on the reconciliation

If the balance is accurate, this confirms proper usage. If not, review receipts and approval fields to identify errors or potential misuse.

5- Close and Archive the Log

Once reconciled, finalize the log:

• Record any reimbursement made
• Note the balance forward for the next cycle
• Save a digital and printed copy
• Store physical receipts with the log for full audit readiness

Expert Tip: Use cloud storage with version control (e.g., Google Drive, Dropbox) to retain and organize historical logs for fast retrieval.

6- Integrate With Your Accounting System

While petty cash isn’t usually part of daily accounting software inputs, it does impact monthly reporting.

• Aggregate petty cash expenses and categorize them against your chart of accounts (e.g., “Office Supplies”, “Travel”)
• Include these summaries in your expense reports or manual journal entries
• For added control, consider uploading the template or summary data into your accounting software if it allows custom imports

Petty Cash Voucher Template

A petty cash log tracks the whole fund over a period. A petty cash voucher tracks one transaction, the moment cash actually leaves the box. If your business has more than a handful of petty cash transactions a month, relying on the log alone means there's no record at the point of disbursement, only after someone gets around to entering it.

The voucher fixes that. It captures the date, who received the cash, what it was for, the category, and the amount, with a signature line for whoever approved it and whoever received it. Fill one out every time cash leaves the fund, attach the receipt to it, and file both together. When it's time to reconcile, the vouchers and receipts should match the log entry for entry, if they don't, that's exactly where a discrepancy started.

This template includes a printable voucher slip alongside the log, in Excel, Word, PDF, and Google Sheets, so you're not stitching one together from a separate download.

Types of Petty Cash Logs

Not every business needs the same level of detail. Here's how the four common formats differ.

Simple Log

Covers the basics: date, description, amount. If petty cash only gets touched a few times a month, this is enough, anything more just adds friction.

Analytical Log

Adds expense category columns, so spending patterns show up at a glance instead of requiring a separate export to spot them.

Columnar Log

Separates expenses into dedicated columns per category, office supplies, postage, travel, and so on. This is the right choice once transaction volume is high enough that scanning a single amount column stops being useful.

Imprest Log

Starts with a fixed fund amount and replenishes back to that exact level every period. This is the standard most businesses actually use, and it's the model this template follows, the reimbursement calculation is built specifically to restore the fund to its original float, not just to whatever feels close.

Enerpize's template is built as an imprest log with category tracking, giving you the columnar and imprest benefits together without having to choose one or maintain two separate files.

Importance of Petty Cash Template

Convenience for Minor Transactions

The petty cash template allows employees to cover small, necessary expenses quickly. This prevents operational bottlenecks by eliminating the need for formal approval chains for trivial purchases such as postage, coffee, or parking fees. It keeps the wheels of daily business turning smoothly. For businesses that also handle larger cash volumes, pairing this with a daily cash report template gives you complete visibility from petty disbursements to total daily cash flow.

Flexibility for Unplanned Expenses 

With cash readily available, staff can respond promptly to unexpected needs, such as buying printer ink that has just run out or tipping a delivery person. The petty cash template helps track these impromptu outlays in real time, ensuring they don’t slip through the cracks.

Quick Fund Access Without Bureaucracy

Instead of waiting for finance to approve a reimbursement or issue a check, employees can draw from petty cash immediately. The template ensures those transactions are recorded systematically, preserving clarity and accountability.

Improves Expense Control and Fraud Prevention

Each transaction logged in the template is subject to review, giving oversight authorities a clear view of spending patterns. By enforcing routine reconciliations and approvals, the system discourages misuse and flags anomalies early, many of the most common accounting errors in small businesses originate from unrecorded or misclassified petty cash transactions.

Supports Accurate Budgeting and Forecasting

When consistently maintained, the petty cash template becomes a valuable source of data. It highlights frequent expenses, seasonal trends, and overspending risks, which are critical for setting realistic budgets and managing petty cash allocations efficiently.

Who Uses the Petty Cash Template?

Small Business Owners

Entrepreneurs and small business owners often juggle multiple roles. A petty cash template provides them with an easy way to track incidental expenses without needing accounting software, while maintaining clean records for tax purposes.

Department Heads and Team Managers

In larger organizations, department-specific petty cash funds are common. Managers can use the template to delegate spending authority while maintaining visibility and control over minor departmental expenses.

Administrative Staff and Office Managers

These are the frontline custodians of petty cash. Using the template, they can document each transaction with precision, ensuring every coin spent is accounted for and reducing the risk of discrepancies during audits.

Finance and Accounting Teams

While they may not handle petty cash directly, accountants rely on well-maintained petty cash templates for accurate bookkeeping, expense categorization, and financial reporting. It ensures petty expenditures are reflected correctly in the general ledger.

Nonprofits and Community Organizations

These organizations often deal with limited budgets and cash-based expenditures. A petty cash template ensures transparency in spending, which is crucial for donor reporting and regulatory compliance.

Petty Cash Best Practices Every Business Should Follow

The template does the tracking. These rules make sure the tracking actually means something.

Set a per-transaction spending limit

Petty cash exists for small, immediate expenses — not for bypassing the procurement process on larger purchases. Define a ceiling (typically $25–$50 per transaction depending on your business size) and enforce it. Anything above the limit goes through a formal purchase order or expense claim.

Require receipts for every disbursement — no exceptions

A verbal description of what was spent is not a financial record. Every withdrawal from the petty cash fund needs a physical or digital receipt attached to the log entry. No receipt means the expense cannot be verified, approved, or reimbursed. Build this into your policy from day one.

Reconcile weekly, not monthly

Monthly reconciliation means a month's worth of discrepancies to investigate if something is off. Weekly reconciliation keeps errors small, flags unauthorized withdrawals early, and builds a discipline of financial accuracy. If your petty cash volume is high, reconcile daily.

Keep petty cash completely separate from operational cash

The petty cash fund is a fixed, replenished reserve — it is not a secondary till, a float for change, or an emergency drawing account. Mixing it with operational cash makes reconciliation meaningless and creates liability in audits.

Assign a single, named custodian

Shared responsibility is no responsibility. One person should be accountable for the fund at any given time. When custody changes, conduct a formal handover reconciliation — count the cash, verify the log, and get both parties to sign off.

How Enerpize Handles Petty Cash

A template solves the recording problem. It doesn't solve the reconciling-by-hand problem, and that's usually where petty cash management actually breaks down as a business grows past one or two people touching the fund.

Automatic Reconciliation

Enerpize tracks every petty cash transaction directly, so the running balance, the category breakdown, and the reconciliation math are calculated automatically rather than rebuilt in a spreadsheet each period. When the fund needs replenishing, the reimbursement amount is already sitting there, no manual subtraction required.

Scan the Receipt, Skip the Typing

Most petty cash breakdowns happen at the receipt stage, someone pays cash for something small, the receipt gets stuffed in a pocket, and by the time anyone logs it, half the details are a guess. Enerpize's expense management software scans or attaches a receipt from any mobile device, online or offline, and its built-in OCR extracts the amount, date, vendor, and tax details automatically, no manual entry required. For petty cash specifically, that means the disbursement is logged the moment it happens, not reconstructed from memory at month-end.

Treasuries and Spend Limits, Not One Shared Fund

Once a business has more than one branch or department drawing on petty cash, a single shared log stops being enough. Enerpize lets you set up separate treasuries and petty cash accounts per branch or department, each with its own spend limits, so no single fund, and no single custodian, ends up carrying more exposure than it should. Every expense still rolls up into custom categories and gets distributed across the right journal accounts and cost centers, so branch-level control doesn't come at the cost of consolidated reporting.

Connected to Your Books, and Your Payroll

Petty cash expenses need to show up in your accounting eventually anyway. Enerpize routes them straight into the right accounts in your chart of accounts automatically, closing the gap between "logged in the petty cash sheet" and "reflected in the actual ledger," a step most businesses currently handle as a separate manual journal entry at month-end. It goes a step further than most accounting tools here too: petty cash, treasury, and company card settlements can consolidate directly into payroll alongside travel and expense reimbursements, so a custodian's petty cash advance and an employee's reimbursement claim aren't tracked in two disconnected systems that both eventually need to hit the same payslip.

An Audit Trail That's Already Built

Because every transaction is scanned, categorized, and reconciled as it happens, running an audit trail report or checking for anomalies isn't a separate project, the record already exists in the shape an auditor or an internal reviewer would want to see it.

If your team is already juggling expense reports and reimbursement requests alongside petty cash, that's usually the sign this is worth consolidating rather than managing as three separate processes.

Petty Cash Template vs. Petty Cash Voucher: What's the Difference?

They work together — they're not the same thing.

A petty cash template (also called a petty cash log or petty cash book) is the master record for the entire fund. It tracks every transaction chronologically, maintains a running balance, and gives you the reconciliation totals at the end of the period. It's the document the fund custodian manages and the accountant reviews.

A petty cash voucher is a transaction-level document — one per disbursement. It captures the date, amount, recipient, purpose, and authorization signature for a single withdrawal. Think of it as the receipt's companion. Every time cash leaves the fund, a voucher should be filled out and filed with the receipt.

The relationship between the two is straightforward: vouchers are created at the point of every transaction, then summarized and reconciled against the master log at the end of the period. If your log shows a $15 withdrawal on Tuesday and you can't find a voucher — and receipt — to match it, that's a discrepancy that requires resolution before the period closes.

A third document sometimes enters the picture: a petty cash reconciliation sheet, used specifically at period-end to formally compare recorded balances against physical cash on hand. Enerpize's cash reconciliation template handles this step.

In short: the voucher documents the transaction, the log tracks the fund, and the reconciliation sheet verifies them both.

FAQs

What is included in a petty cash template?

A complete petty cash template includes fields for the reporting period and opening balance; individual transaction rows capturing the date, receipt number, expense description, category, cash in, and cash out; a running balance column that auto-updates after each entry; and a reconciliation section at the bottom to compare the recorded closing balance against the physical cash on hand. The Enerpize template covers all of these in both Excel and Google Sheets format.

How do I reconcile a petty cash fund using Excel?

At the end of your reporting period, count the physical cash remaining in the fund. Open the template and locate the closing balance — this is what the log says should be there based on recorded transactions. Enter your physical count in the "Cash on Hand" field. The "Difference" field will automatically calculate the variance. A zero means your records are accurate. A positive or negative figure means a transaction was either missed, incorrectly recorded, or the cash was mishandled — each case requires investigation and a written explanation before you close the period.

What is the difference between petty cash and a cash advance?

Petty cash is a fixed fund held on-site and replenished periodically — it's company money managed by a designated custodian for immediate, minor expenses. A cash advance is money given to a specific employee before a trip or project to cover anticipated expenses, with the expectation that they will return unused funds and submit receipts afterward. Petty cash is ongoing and revolving; a cash advance is event-specific and settled individually.

How much should a petty cash fund be?

There's no universal answer, but a practical starting point is two to four weeks' worth of your typical minor cash expenses. For most small businesses, this falls somewhere between $100 and $500. If you're replenishing the fund more than once a week, the fund is too small. If most of the fund sits untouched at period-end, it's too large — unnecessary cash on hand is an internal control risk.

Can I use this template for multiple departments?

Yes — and you should. The best practice is to maintain a separate petty cash log for each department or branch that holds its own fund. This keeps reconciliation independent, makes it easy to identify which cost center each expense belongs to, and ensures that a discrepancy in one department doesn't cloud the records of another. Download one copy of the template per fund, label it clearly with the department name and reporting period, and archive completed logs together for consolidated review.

How often should petty cash be reconciled?

At minimum, monthly — but weekly is strongly recommended for most businesses, and daily for high-volume operations like retail or food service. The shorter the reconciliation cycle, the smaller and more traceable any discrepancies will be. If your business is growing and weekly reconciliation is becoming a manual burden, that's a signal it's time to consider automating your expense management rather than continuing to rely on spreadsheets.

What is a petty cash voucher?

A petty cash voucher is a one-transaction document filled out every time cash leaves the fund. It records the date, who received the cash, the purpose, the category, and the amount, with a signature from whoever approved it and whoever received it. It's different from the petty cash log, which tracks the entire fund over a full period, the voucher documents a single disbursement, the log is the running master record those vouchers feed into.

What's the difference between an imprest petty cash system and a simple log?

A simple log just records date, description, and amount, enough for a business that only touches petty cash a few times a month. An imprest system starts with a fixed fund amount and replenishes back to that exact level every period, it's the standard most businesses actually use, and it's the model this template follows. The reimbursement calculation is built specifically to restore the fund to its original float, not just to whatever amount feels close.

How long should I keep petty cash records?

It depends on where you operate. In the US, the IRS's general guidance is at least three years. In South Africa, SARS expects five years. In Malaysia, it's seven years under the Income Tax Act. In India, books of account and supporting documents need to be kept for six years from the end of the relevant assessment year. In Indonesia, it's ten years under the General Provisions and Tax Procedures Law. Match your filing practice to the country you operate in, and when in doubt, keep the longer period.

Can Enerpize automate petty cash tracking?

Yes. Enerpize tracks every petty cash transaction directly, so the running balance, category breakdown, and reimbursement calculation happen automatically instead of being rebuilt in a spreadsheet each period. Receipts can be scanned from any mobile device, with built-in OCR extracting the amount, date, and vendor automatically. Petty cash expenses route directly into the right accounts in your chart of accounts, and larger organizations can set up separate treasuries with their own spend limits per branch or department instead of relying on one shared fund.

About the Author

Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.