Petty Cash Spreadsheet: Reconcile the Float to the Cent

Every workplace I have ever known had a tin.

Hey folks, it's Ren here. At my first proper job the tin lived in the drawer under the register: an old biscuit tin with fifty dollars in it, a fistful of receipts, and a sticky note on the lid that just said DO NOT.

Do not what, nobody ever explained.

Someone would grab a twenty for stamps. Someone else would buy milk for the staff fridge. Once a month the boss would tip the whole thing onto the counter, count it twice, sigh, and put it all back.

The tin was never right. Not once.

It took me years of running my own business to learn that the fix was never a better tin. It was a petty cash spreadsheet sitting next to it.

"Take care of the pence, and the pounds will take care of themselves." — William Lowndes

What is a petty cash spreadsheet?

A petty cash spreadsheet is a simple ledger that tracks a small cash float from the day you set it, through every cash payment that comes out of it, to the day you top it back up. It replaces the sticky notes and the mental arithmetic with five columns and a running balance.

Petty cash exists for the little stuff that is silly to invoice or awkward to put on the business card: stamps, milk, a courier bag, a parking meter, a birthday cake for the staff room.

Individually those amounts are tiny.

Together, across a year, they are a real expense line that plenty of small businesses cannot actually prove at tax time, because the evidence went through the wash in someone's back pocket.

The spreadsheet is what makes them provable.

💸 Why the tin never matches the tally in your head

Petty cash goes wrong because it is the only money in a business that anyone can touch without leaving an electronic trail. A card payment writes its own record and a bank transfer writes its own record, but a ten dollar note leaving a tin writes nothing at all unless a human writes it down in the same minute.

Please do not be hard on yourself if your tin has never once matched your mental tally. The system leaks by design, not because you are careless.

Here is where it leaks:

• The spend is tiny, so writing it down feels sillier than the purchase itself.
• The receipt goes into a pocket instead of the tin, and the pocket goes through the wash.
• Two people take cash out on the same day and each assumes the other one logged it.
• Change from a twenty goes back in as coins, and coins are where counts go to die.
• Nobody counts the tin until the float runs dry, weeks after the mistakes were made.

🧾 What goes in each column of the ledger?

A petty cash spreadsheet needs only five working columns: date, description, receipt reference, cash out, and running balance. The very first row is not a spend at all, it is the opening float.

Column	What goes in it
Date	The day the cash left the tin, logged the same day it happens.
Description	What the money bought, in five words or fewer.
Receipt ref	A number written on the slip and stored in the tin, or the word none in honest ink.
Cash out	The exact amount taken, to the cent.
Running balance	What the tin should hold after that line: the previous balance minus the cash out.

The running balance column is the quiet hero. At any moment, on any day, it names the exact figure the tin should hold, and that single number is what turns a vague looks-about-right into a real check.

How does the imprest float method work?

The imprest method sets the float at one fixed figure, and every top up restores the tin to exactly that figure rather than adding a round number. If your float is $200 and you count $51.35 in the tin, the top up is $148.65, not another two hundred.

That one rule sounds fussy. It is actually the entire engine.

Because the tin always returns to the same level, the top up amount IS your petty cash spend for the period. Nobody has to add up the slips to work out the expense figure for the books; the top up did the maths already.

And here is the part I rarely see said out loud: petty cash is the only account in your whole business that you reconcile against something you can physically hold. A bank reconciliation is your records arguing with the bank's records, one ledger against another. A petty cash count is your ledger against actual folding money on an actual desk. It has a ground truth you can touch, which is exactly why it can, and should, balance to the cent.

The cycle runs: set the float, spend with a slip each time, count and reconcile at month end, top up by exactly what went out. Around and around, and the float figure itself never changes on paper.

🔍 One real month, reconciled to the cent

A worked month shows how the reconciliation catches what memory cannot. I ran a $200 float through a typical small-office month of sixteen cash outs and reconciled it line by line.

The ledger recorded $147.40 going out, which left a book balance of $52.60. The actual count of the tin came to $51.35.

Then the receipts. The slips in the tin added up to $144.15 against $147.40 of logged spending, so $3.25 of cash outs had no paper behind them, and a further $1.25 had left the tin with no line in the ledger at all.

Reconciliation line	Amount
Opening float	$200.00
Cash outs logged (16)	$147.40
Book balance	$52.60
Cash counted in the tin	$51.35
Unexplained shortage	$1.25
Receipts in the tin	$144.15
Spends with no receipt	$3.25
Top up to restore the float	$148.65

The top up came to $148.65, and it splits perfectly: $144.15 of provable expenses, $3.25 of unreceipted spends, and $1.25 of pure shortage.

Here are those numbers as a yearly story. A $1.25 shortage plus $3.25 of missing receipts is $4.50 a month, or about $54 a year that you either cannot deduct or cannot explain. Small, but it is exactly the leak a five-column ledger closes for free.

✅ Your 15-minute setup, step by step

1. Pick the float and get it in cash. Somewhere between $100 and $300 suits most small businesses; choose a round figure you will restore at every top up.
2. Build the five columns. Date, description, receipt reference, cash out and running balance, with the opening float as row one.
3. Put a slip rule on the tin. Every cash out gets a numbered slip or receipt into the tin the moment the money leaves, with no exceptions for tiny amounts.
4. Count and reconcile monthly. Count the cash, compare it to the running balance, and total the receipts against the logged spends.
5. Top up to the float, never by a round number. Record the top up as the final line of the month, and note any shortage on its own line rather than hiding it.

🚧 Mistakes that break the float

• Topping up by a round number. Fix it: always top up to the float figure, so the top up equals the spend and the books write themselves.
• Using the tin as a change drawer. Fix it: petty cash pays for things; it never makes change for customers or swaps notes for coins.
• Allowing IOUs. Fix it: a borrowed twenty is a cash out like any other, logged with a name on the slip, or it is a shortage waiting to be discovered.
• Logging the week from memory. Fix it: the row gets written the same day the cash moves, because a week later the purchase never happened.
• Skipping the count because card sales dominate. Fix it: a smaller float counted monthly beats a forgotten tin audited never.

One boundary worth drawing early: the tin covers cash spent from the float, but the money you front from your own pocket on the business's behalf is a different animal. The expense reimbursement tracker spreadsheet is built for chasing that kind of money back.

🎯 Your action steps this week

• Count whatever cash tin or drawer you have right now and write the figure down; that is your starting truth.
• Set a float you will actually maintain and get it in mixed notes and coins.
• Build the five-column petty cash spreadsheet, or open the petty cash tab in your budget template, and enter the float as row one.
• Tape the slip rule to the lid of the tin where everyone can see it.
• Feed the receipted totals into your tax deduction spreadsheet so the little purchases still count at tax time.
• Diarise a ten-minute count for the last Friday of the month.

💬 Common situations

If the count is short and you cannot explain it

Log the difference as a cash shortage line rather than hiding it inside the top up. A $200 float that is $1.25 short is normal life with coins and change; the same float short $20 two months running is a process problem, and the ledger is what lets you tell which one you have. Record it, restore the float, and tighten the slip rule before you suspect anybody.

If more than one person takes cash from the tin

Add an initials column to the petty cash spreadsheet and make the slip rule non-negotiable. Keep one keyholder if you can; if you cannot, the ledger plus initials means a mismatch narrows to a short list instead of a whole staff room. In my experience most shortages turn out to be an unlogged spend, not a sticky hand.

If you barely use cash any more

Shrink the float rather than abandoning the ledger. A $50 float that reconciles beats a forgotten $200 tin, and the odd market stall, tradie or council car park still wants notes. If a whole quarter passes with no cash outs, retire the tin, bank the float, and let the card statement do the tracking instead.

The tin at that first job never balanced because nobody ever gave it a ledger, and a tin without a ledger is just a box of maybes.

Yours can be right. Not roughly right. Right to the cent.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.