Free Petty Cash Tracker & Excel Export

Petty cash is a small amount of money kept on hand for everyday business costs that are too minor for a purchase order or a supplier bill. Tea for a meeting, a courier to the bank, auto fare to the GST office, a pack of A4 paper — each is small, but together they empty a drawer if nobody writes them down.

The float is usually a fixed sum, such as ₹5,000 or ₹10,000, held by one person. When the drawer runs low, it is topped up from the bank or from a reimbursement, not from whoever was nearest the till. The point of the float is speed: you should not wait a week to buy envelopes.

Petty cash is still business money. It is not a personal wallet and it is not “miscellaneous” in the sense of untraceable. A date, a category, an amount and a short description are enough to keep the float honest.

Businesses need petty cash tracking because small spends are the ones that vanish. A ₹40 tea slip is easy to forget by Friday. Twenty such slips in a month are ₹800 that never reached the books. Over a year that is not a rounding error.

Tracking also protects the person who holds the cash. If the drawer is short, a dated list shows whether the money was spent or simply not recorded. That is fairer than a vague accusation, and it is the only way an auditor or an owner can see what the float actually bought.

GST, reimbursement and month-end close all work better when petty cash is listed, not remembered. You cannot claim a courier, or explain a fuel top-up, from a pile of unmarked notes in a tin.

Typical petty cash expenses include:

• Tea, coffee, water and biscuits for staff or visitors
• Local travel: auto, bus, metro or parking for an office errand
• Fuel for a short trip when a vehicle is used for business
• Food for a late meeting or a small staff refreshment
• Stationery: pens, files, tape, printer paper
• Courier and postage
• Minor maintenance: a fuse, a lock, a plumber's call-out fee
• Utilities paid in cash at a counter, such as a small recharge

A laptop, a month of rent, a bulk stock purchase or a contractor invoice is not petty cash. Those belong on a bill, a purchase order or the main expense ledger. If you have to wait for approval, it is probably not petty.

A simple petty cash cycle looks like this:

1. The business sets a float — the maximum cash to keep in the drawer.
2. One person is responsible for the cash, the slips and the list of spends.
3. Each payment is recorded on the day: date, what it was, category, amount and how it was paid.
4. A voucher, UPI reference or bill number is kept if there is one.
5. When the cash is low, the list is checked against the remaining notes. The difference is reimbursed to restore the float.

Payment is not always physical cash. Many “petty” spends now go out by UPI or a staff card and are reimbursed later. The float idea still holds: small, frequent, same-day costs, recorded as they happen. On this page you enter those rows once. The dashboard totals them. Excel or CSV export is the file you hand to accounts.

A paper register works until the book is left at home, a page is skipped, or the handwriting cannot be read at month end. A digital list is the same information — date, category, amount — in a form you can search, total and export without retyping.

Totals update as you add or edit a row. You can see today's spend, this month's spend, the highest line and the average, plus a total for tea versus courier. That is hard to do from a column of numbers in a notebook unless someone adds them twice.

Digital also means the report can leave the drawer. Print it, copy it, or download Excel or CSV for the accountant. The slips can stay in an envelope; the summary does not have to be rebuilt from those slips every 30 days.

All petty cash items are business expenses. Not all business expenses are petty cash. The difference is size, speed and how they are approved and paid.

Mixing the two is how a “petty” tin starts funding a printer or a festival advance. Put large or recurring costs on the main books. Keep petty cash for the small, same-day items the float was meant to cover.

• Fix a float and a per-item limit so the drawer cannot quietly fund a large purchase.
• Name one custodian. Shared tins become nobody's list.
• Record the spend on the same day, not from memory on Friday.
• Use categories (tea, travel, courier) so month-end is not one pile called miscellaneous.
• Keep a reference: UPI number, bill no. or voucher, even if the amount is small.
• Reconcile remaining cash against the list before you top up the float.
• Export or print a report at a set interval — weekly in a busy shop, monthly in a quiet office.

Best practice is boring on purpose. The aim is a list that matches the cash, not a perfect taxonomy. If a spend does not fit a category, use Other and write a clear description. Do not skip the row.

To manage petty cash without a second job:

1. Set the float and the categories before the first spend, not after a messy month.
2. Enter each item when it happens: date, category, description, amount, cash, UPI or card.
3. Review today and this month on the dashboard instead of adding a column by hand.
4. Search or filter when someone asks “what did we spend on courier?” rather than scanning pages.
5. Export Excel or CSV, or print the report, when accounts or the owner wants a file.

Efficiency is fewer steps between the spend and the record. If staff must fill a form that nobody files, they will stop filling it. A short digital entry, saved on the device, is closer to how UPI already works: the payment is instant, the note should be too.

• No named custodian, so gaps in the cash have no owner.
• Recording at month end from memory and a handful of crumpled slips.
• Calling everything miscellaneous, which hides tea, travel and courier in one number.
• Paying a large bill from the petty tin because it was “easier than raising a PO”.
• Mixing personal spends with office spends in the same drawer.
• Topping up the float without reconciling, so shortages are rolled forward.
• Keeping the only copy in a notebook that cannot be exported or searched.

A further mistake is to treat UPI as “already recorded” because the bank app shows it. The bank app is a payment log. It is not your category, your project, or your petty cash report. Copy the reference into the tracker so the two can be matched.

A digital petty cash tracker gives you a live list and a live total. You add a row; today's expenses, this month's expenses, entry count, highest line, average and category totals update without a separate spreadsheet formula.

You can search, filter by category or date, and switch between a flat table, a weekly view and a monthly view. Edit and delete keep the list accurate. Export Excel or CSV, print, or copy the report when someone outside the drawer needs the same numbers.

This page runs in the browser and saves on this device. There is no account to create. That is enough for a single office or a founder who wants a clean file. It is not a multi-user ledger. When several people spend and one set of books must hold every bill, you need the expense record to live with accounting, not only in one browser.

This tracker stores a local petty cash list. ZemERP is cloud ERP for billing, inventory, accounting, GST, CRM, HRMS and payroll in one login. Expenses sit next to the vendor bills, the GST return and the bank, instead of in a file that accounts has to re-key.

A courier recorded in ZemERP can carry the same date and amount as a line you might first capture here. The difference is what happens next: it can be approved, posted, and reported with the rest of the books. Petty items stop being a side notebook that is always a month behind.

Use the free tracker to get the habit of a dated list and an Excel export. Use ZemERP when petty cash, bills and reimbursements need to live in the same organisation as sales and stock, so month-end is not a hunt for slips.