Petty Cash Reconciliation Log: Track the Float, Count the Cash, Replenish Clean

The problem this kills

The petty-cash box is the smallest account you have and the most annoying to close. Someone takes a twenty for stamps, someone else grabs cash for donuts, a receipt goes missing, and by replenishment time the math never quite ties. You sit there with a shoebox of curling receipts, a calculator, and a sticky note, trying to reconstruct who spent what — and the box is three dollars short with no idea why. Then you still have to turn it into a clean journal entry so the GL gets the spend by category, not just one lump "petty cash" line.

It's a tiny amount of money guarded by a surprising amount of effort. The information you need is simple — date, payee, amount, category, a receipt — but it lives on paper scraps instead of anywhere you can total it. You don't need to be a developer to fix that. You need a small tool that captures each slip the moment it happens, keeps a live running balance, and turns the periodic cash count into a reconciliation a supervisor can approve in two minutes.

What you'll build

A simple internal web tool for whoever maintains the petty-cash box. Each time cash leaves the box, you key a disbursement slip — date, payee, amount, category, and a photo of the receipt — and the running balance updates instantly against your float ceiling. When it's time to replenish, you enter the physical cash count from the box and the tool computes the math: receipts plus cash on hand versus the float, and the over/short if they don't agree. Anything off has to carry an explanation. Then the custodian's supervisor reviews the reconciliation and approves the replenishment — and only then does the tool export the replenishment journal entry (top the float back up to its ceiling) and a category spend summary ready to post to the general ledger.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how your box works today, your float amount and ceiling, your real spend categories and GL codes, how often you replenish, who the custodian and approving supervisor are, and the messy bits like IOUs, missing receipts, and the odd cash advance. It reads a short spec back to you for a thumbs-up, then builds the tool around your box instead of a generic template. From there it walks the agent through the data model, the slip-entry form with receipt upload, the running-balance and float-ceiling logic, the cash-count reconciliation with over/short, the supervisor approval gate, and the journal-entry and category-summary exports. Every step ends with a ready-to-copy prompt.

The governance it includes (this is the point)

This isn't a toy. The plan builds in the controls a real finance function needs: login so only your team can use it, row-level security so people only see their own organization's box, a complete audit trail of every slip, edit, count, and approval (who, what, when, and why), a hard human-approval gate so no replenishment posts until a supervisor signs off on the reconciliation, and duplicate guards so the same slip can't be entered twice. A receipt photo is required on every slip, the float ceiling is enforced, and any over/short must be explained before it can be approved. The AI does the arithmetic; a person owns the decision.

Who it's for

Office managers, bookkeepers, and finance admins who babysit a petty-cash box and dread reconciliation day. If you can describe how cash leaves your box and how you top it back up, you can build this.

You've got this — open the plan, paste the first prompt, and you'll be logging your first real slips and watching the balance tick down this afternoon.