Excel template · Finance

Petty Cash Book Format in Excel (Imprest System)

Record each top-up and small payment with its expense head and voucher number. The book keeps a running balance, flags payments without a bill, and gives a head-wise month-by-month summary ready to post to the ledger.

For: Office managers, cashiers and accountants who handle day-to-day cash.

Free download · no sign-up · no macros · Excel 2010+, Google Sheets, LibreOffice

Preview of the Petty Cash Book & Expense Claim Excel template with sample data
Main sheet with sample data

At a glance

What it is
Petty Cash Book & Expense Claim — an Excel workbook for Indian businesses and accountants
Free edition
4 sheets (Guide, Heads, Petty Cash Book, Monthly Summary) — free download, no sign-up
Pro edition
7 sheets, adds Expense Claim and Travel Claim and Replenishment Voucher — ₹19 one-time (regular ₹99)
Works in
Microsoft Excel 2010 or later, Google Sheets, LibreOffice Calc — no macros
Checked
Recalculated with zero formula errors; sample data and a Guide sheet included
Made by
Prakash Bagchi, finance professional, PB Lab (Raipur, India)

Free vs Pro: what you get

SheetFreePro
Guide
What it does, how to use it, assumptions and a live status check
Heads
Expense heads with ledger codes — add your own
Petty Cash Book
Imprest, top-ups and payments with running balance and bill flag
Monthly Summary
Head-wise totals by month with balance checks
Expense Claim
Employee claim form with advance adjustment and approvals
—
Travel Claim
Local conveyance by km for car and two-wheeler
—
Replenishment Voucher
Amount to top up the imprest plus a denomination-wise cash count
—

Pro edition

Get Petty Cash Book & Expense Claim – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • Expense Claim — Employee claim form with advance adjustment and approvals
  • Travel Claim — Local conveyance by km for car and two-wheeler
  • Replenishment Voucher — Amount to top up the imprest plus a denomination-wise cash count
  • One-time payment, instant .xlsx download, free updates
+91

Secure payment by Razorpay · UPI, cards, netbanking & wallets

We use your details only to deliver the file and support your purchase. See our privacy policy and terms.

Need more than one? The Finance & Accounts Kit has all 14 finance Pro templates, including this one, for ₹208.

How to use it

  1. 1Download the free file and read the Guide sheet.
  2. 2Review the expense heads on Heads and add any you need.
  3. 3On Petty Cash Book, enter the imprest amount and opening balance.
  4. 4Record every top-up and payment in date order with voucher number, head and whether a bill is attached.
  5. 5At month-end, check the Monthly Summary and post the head-wise totals to your ledger.

The imprest system

Under the imprest system, the petty cashier starts each period with a fixed float — say ₹25,000. Small payments are made from it against vouchers. At the end of the period, the cashier presents the vouchers and is reimbursed exactly the amount spent, bringing the cash back to the imprest amount. The beauty of the system is the built-in check: at any moment, cash in hand plus vouchers paid should equal the imprest.

What to record

Each entry needs a date, a voucher number, who was paid, what for, the expense head and the amount. Mark whether a bill or receipt is attached. Payments without a bill are highlighted, so they can be approved or supported by a self-declaration within your policy limit. Keeping entries in date order gives you a reliable running balance to compare with the cash in the box.

Monthly summary for posting

Instead of posting every small payment to the ledger, most businesses post one journal per month per expense head from the petty cash book. The Monthly Summary gives you exactly that — head-wise totals by month — along with checks for payments without a head, a negative balance or a mismatch between the book and the summary.

Cash limits to keep in mind

Petty cash is for small expenses. Income-tax law disallows a business expense paid in cash above ₹10,000 to one person in a day (section 40A(3) under the 1961 Act, with a similar rule in the 2025 Act; ₹35,000 for payments to transporters). Larger payments should go through the bank. Your own policy will usually set a much lower per-payment limit for petty cash.

GST on petty cash bills

Small purchases often come with a GST invoice — stationery, courier, repairs. If your business is registered and the supplier's invoice shows your GSTIN, the input tax credit can be claimed like any other purchase. The petty cash book records the amount paid; pass those few invoices to whoever books purchases so the GST is split out and the credit isn't lost. Bills without your GSTIN, or from unregistered suppliers, are simply expensed at full value. Food and beverages, and some other items, are blocked credits under section 17(5) of the CGST Act whatever the invoice says.

Controls that prevent problems

Count the cash regularly — ideally by someone other than the cashier — and record the count by denomination. Keep the float small enough that it needs topping up every few weeks. Number vouchers in sequence and never pay against a photocopy. The Pro edition adds a replenishment voucher with a denomination-wise cash count, plus employee expense and travel claim forms that feed the petty cash book.

Written by Prakash Bagchi, finance professional and founder of PB Lab. Last reviewed .

Frequently asked questions

What is the imprest system of petty cash?

A fixed float is given to the cashier. At the end of each period, the amount spent is reimbursed so the cash returns to the fixed amount.

How much should the petty cash float be?

Enough to cover a few weeks of small expenses. Too large a float increases the risk of loss; too small means constant top-ups.

Is there a limit on cash payments?

Income-tax law disallows business expenses paid in cash above ₹10,000 to one person in a day (₹35,000 for transporters). Pay larger amounts through the bank.

What if a payment has no bill?

The template highlights it. Get it approved, or ask for a self-declaration within your policy limit.

Does it include an expense claim form?

The Pro edition includes an employee expense claim, a local travel (per-km) claim and an imprest replenishment voucher.

Can I add my own expense heads?

Yes. Add them on the Heads sheet and they appear in the drop-down on the Petty Cash Book.

How much does the Pro edition cost and how do I get it?

The Pro edition is ₹19 (regular price ₹99), a one-time payment through Razorpay by UPI, card, netbanking or wallet. You download the .xlsx file right after paying, and the download page works again later if you bookmark it. Pro adds: Expense Claim, Travel Claim, Replenishment Voucher.

Related free calculators

More Excel templates

See all templates →

Disclaimer: This template is a working aid, not legal, tax or accounting advice. Sample data is fictional. Laws, rates and thresholds change — verify them against the current Act, rules and notifications, or with a qualified professional, before relying on the results. PB Lab is not responsible for decisions made using this file.