● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Small Business Petty Cash Tracker
Small Business Petty Cash Tracker hero preview with cash log and headline features
BOOKKEEPING & BUSINESS FINANCE

Small Business Petty Cash Tracker

Petty cash has a habit of living in a drawer, a notebook and a pile of loose receipts. This petty cash tracker replaces all that with a single workbook and a running balance, plus a weekly count that tells you exactly what should be in the box.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Small cash, properly accounted for

You begin by setting your opening float once, along with your business name, custodian and currency. From then on, every cash payment goes into the Petty Cash Log with its receipt number, date, what it was for, who received it, its category and the amounts in and out. The log holds room for 40 entries and keeps a running balance, so the expected contents of the box are never a guess.

Top-ups stop being something people just remember. Each replenishment is recorded with its number, amount, approver and method, which keeps the float honest and auditable. Once a week, count the physical cash on the Cash Float tab, where you enter notes and coins by denomination, the tab adds the count up and highlights any gap between what you found and what the log expects, ready for a count note and a quick check.

At month end, the summaries do the reviewing for you. The Monthly Summary totals money in and out for every month from the log dates, along with a net figure and a count of entries, starting with six months. Expense Categories track spending against a monthly budget for areas like stationery, postage, travel and refreshments, while Receipt Notes keeps any missing receipt visible with a follow-up note until it is resolved.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the tracker into your own account
  • BLANK Excel workbook, clean and ready for your own cash box
  • EXAMPLE Excel workbook filled with realistic small business demo data and a float top-up
  • Quick Start Guide PDF covering setup, a daily routine, tips and troubleshooting
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel and in Google Sheets, with nothing to install
  • Built for everyday business spending, not personal budgeting
  • A record keeping tool, not accounting or tax advice for your business
  • Categories and budgets can be edited on the Expense Categories and Settings tabs
  • Questions are answered through Etsy messages if anything is unclear

Questions about this template

The things buyers ask us most.

How do I know if the cash in the box is right?

Use the Cash Float tab for a weekly count. You enter the cash by denomination, the tab totals it and compares it with the balance your log expects, showing any difference clearly. If there is a gap, note it on the tab, recheck the latest entries and receipts, and recount before topping up.

Can I change the expense categories or budgets?

Yes. Monthly budgets are set on the Expense Categories tab, and you can add your own categories on the Settings and Lists tab. Just keep the spelling in the log exactly the same as the list, so totals add up correctly. The starting categories cover common costs like stationery, postage, travel, printing and refreshments.

What happens when a receipt goes missing?

Flag it on the Receipt Notes tab and add a short follow-up note, such as chasing a duplicate copy from the supplier. The missing count on that tab keeps the gap visible until it is sorted, instead of it being forgotten. Every receipt gets one line, so chasing paperwork becomes a short list rather than a drawer search.

How long can I keep using one copy of the tracker?

One copy starts with six months on the summary and space for 40 log entries in each period. That suits many small cash boxes comfortably. When a period fills up, begin again with a clean copy or open a new period, carrying the closing float forward as the new opening float on Start Here.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Small Business Cash Flow Spreadsheet

A 13 week cash flow forecast that flags tight weeks before they arrive.

$7.50 $3.00
View on Etsy
Cash Flow Spreadsheet Template

A 13-week and 12-month forecast that flags tight weeks before they can hurt.

$7.50 $3.00
View on Etsy
Business Emergency Fund Tracker

Turn essential business costs into a clear fund target and build months of cover step by step.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00