Free petty cash template and guide

Managing small, day-to-day expenses shouldn't eat up hours of your time. Petty cash is essential for covering quick, low-cost transactions such as reimbursing employees for office supplies or buying coffee for a team meeting. But without an organized system, keeping track of these expenses can get messy.

A petty cash template helps you log transactions efficiently and keep your finances in order. Below, you'll find how to download free templates, step-by-step setup instructions, and best practices to keep your petty cash fund running smoothly.

What is a petty cash template

A petty cash template is a pre-formatted document used to track small, everyday business expenses paid in cash. It serves as your petty cash log, a central record of every withdrawal, receipt, and remaining balance in your fund.

Think of it as a simple ledger designed specifically for minor purchases. Instead of routing a $12 office supply run through your full accounts payable process, you pull from petty cash and record it in the template. The template keeps a running tally so you always know how much is left and where the money went.

Most petty cash templates come in spreadsheet or PDF format and include fields for dates, amounts, descriptions, and receipt references. Whether you manage the fund yourself or hand it off to a custodian, the template creates a clear paper trail that makes reconciliation and auditing straightforward.

What to include in a petty cash log

A useful petty cash log captures enough detail to track every dollar without overcomplicating the process. Here are the core components your log should include:

Business information header

• Company name and department: Identifies which team or location the fund belongs to
• Fund custodian name: The person responsible for managing and disbursing cash
• Reporting period dates: The start and end dates the log covers (e.g., weekly or monthly)
• Starting balance amount: The total cash in the fund at the beginning of the period

Transaction log table

This is the core of your petty cash log. Each row represents a single transaction with columns for:

• Date: When the expense occurred
• Description/purpose: A brief note explaining what the cash was used for
• Expense category: The general ledger category (e.g., office supplies, postage, meals)
• Amount disbursed: How much cash was paid out
• Receipt number: A reference number linking the entry to a physical or digital receipt
• Recipient name: Who received the cash

Running balance column

A running balance column automatically calculates remaining funds after each transaction. This is the quickest way to know how much cash is left in the fund at any point without counting what's in the box. In Excel or Google Sheets, a simple formula handles this for you.

Reconciliation section

At the bottom of your log, include fields for:

• Total disbursements: The sum of all cash paid out during the period
• Cash on hand: The physical cash remaining in the fund
• Receipts collected: The total value of all receipts gathered
• Discrepancies: Any difference between the expected balance and the actual cash on hand

This section is what ties everything together at the end of each reporting period and flags problems before they snowball.

Types of petty cash forms and logs

Different petty cash forms serve different tracking needs. The right choice depends on your transaction volume, how detailed your reporting needs to be, and whether you need forms for requesting or reconciling funds.

Simple petty cash log

A simple log covers the basics: date, description, and amount. If your team only dips into petty cash a few times a month, this format keeps things clean without unnecessary complexity.

Analytical petty cash log

An analytical log adds expense category columns so you can see where money is going at a glance. This is helpful if you want to spot trends, such as whether office supply costs are creeping up quarter over quarter.

Columnar petty cash log

A columnar log separates expenses into multiple dedicated columns (e.g., supplies, postage, meals, travel). It's best for teams with high transaction volumes who need quick visual tracking of spending patterns across categories.

Imprest petty cash log

An imprest system starts with a fixed fund amount—say $500—and replenishes it back to that exact level after each reconciliation. The log tracks every disbursement against that fixed amount, making it easy to verify that receipts plus remaining cash always equal the original balance.

Petty cash reconciliation form

This form is used at the end of a reporting period to verify that everything adds up. You'll compare total disbursements and receipts collected against the cash remaining in the fund. Any variance gets flagged and investigated.

Petty cash request form

A request form adds a layer of pre-approval to your process. Employees fill it out before receiving cash, documenting the purpose, amount requested, and approval signature. It's a simple way to prevent unauthorized spending.

Petty cash log template

Use this table to record every withdrawal from your petty cash fund. Each row represents a single transaction. The running balance column shows how much money remains after each expense.

You can copy these tables into Excel or Google Sheets and customize the categories or columns to match your business expense tracking needs.

How to use this template

1. Enter your starting fund balance in the first row.
2. Record each petty cash transaction as it occurs.
3. Include a receipt number and recipient name to create a clear audit trail.
4. Update the running balance after each entry so you always know how much cash remains in the fund.

If you're using Excel or Google Sheets, you can automate the running balance using a simple formula:

Previous balance – Amount disbursed

For example:

=G2-D3

This subtracts the current transaction amount from the previous balance.

Petty cash reconciliation template

At the end of each reporting period, reconcile your petty cash fund to confirm that all transactions were recorded correctly.

Use this reconciliation template to compare your receipts and remaining cash against the original fund balance.

When to use this template

A petty cash template works best for businesses that regularly pay for small, immediate expenses that would be inefficient to process through accounts payable.

Common examples include:

• Office supplies
• Postage and shipping
• Employee meals
• Small travel expenses
• Minor equipment purchases

Using a structured template ensures every dollar is documented and makes reconciliation much easier during monthly reviews or internal audits.

How to complete a petty cash reconciliation form

Reconciliation is how you confirm that every dollar in your petty cash fund is accounted for. It's a straightforward process, but skipping it is where most petty cash problems start.

Here's what to verify during each reconciliation:

• Starting balance: Confirm the amount your fund began with at the start of the period
• Total disbursements: Add up every cash payout recorded in your log
• Receipts collected: Total the value of all receipts on file; these should match your disbursements
• Cash remaining: Count the physical cash left in the fund
• Variance: Identify any difference between what you expect and what you actually have

Reconciliation formula

To calculate the expected balance, use this formula:

Starting balance − Total disbursements = Expected cash on hand

If the expected cash doesn't match the actual cash counted, review your receipts and log entries to identify missing documentation or recording errors.

Sample reconciliation calculation

Let's say you started the month with a $500 fund:

In this example, you're $4.50 short. That means a receipt is missing or a transaction wasn't logged. Investigate the gap, document the resolution, and then submit a replenishment request for $352.00 ($347.50 in disbursements plus the $4.50 shortage) to bring the fund back to $500.

If expected cash on hand doesn't equal actual cash on hand, you have a variance to resolve.

Best practices for petty cash management

Even with a well-designed template, a solid petty cash management system requires clear processes and accountability. Here's how to keep it running smoothly.

1. Establish a clear petty cash policy

Document your spending limits, approved expense categories, and required documentation in writing. Share the policy with everyone who might use the fund so there's no ambiguity about what qualifies and what doesn't.

2. Assign a dedicated petty cash custodian

Designate one trusted employee to oversee the fund. Having a single point of responsibility reduces errors, prevents confusion, and makes it clear who to go to with questions.

3. Set transaction and spending limits

Define maximum amounts for single transactions and total monthly disbursements. This prevents the fund from being used for purchases that should go through your standard procurement process.

4. Require receipts for every expense

No exceptions—every withdrawal needs a corresponding receipt. Make it mandatory to log all expenses, no matter how small, and attach receipts for verification. This is the foundation of proper petty cash tracking.

5. Reconcile weekly or monthly

Regular reconciliation catches discrepancies early before they become larger problems. Whether you reconcile weekly or monthly depends on your transaction volume, but don't let it slide longer than a month.

Replace your petty cash fund with Ramp

Ditch the hassle of managing a petty cash fund and switch to Ramp's corporate cards for everything from recurring expenses to smaller day-to-day purchases.

Ramp offers real-time expense tracking and customizable spending limits, giving you the control and transparency of a petty cash system without the risks of theft, fraud, or human error. Plus, there's no need to assign a custodian to oversee every transaction.

Explore Ramp's interactive demo to see how businesses save an average of 5% annually across all expenses with smarter financial management tools.