Free Petty Cash Template for Excel & Google Sheets

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.

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

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.

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.