School supply closet reimbursements
An elementary school office manages a $300 petty cash drawer for teacher supply reimbursements and needs a log with running balance and monthly close.
Petty Cash Log
Tier 2 · Accounting & Finance · $100 · 4-5 hrs · 10 day turnaround
Listed price is the project base price. A 3% payment processing fee is added at checkout. The full total is charged upfront when you place your order.
Design and populate a petty cash tracking log with running balance, categories, and a monthly summary tab.
A ready-to-use petty cash tracking spreadsheet that automatically calculates running balances, sorts expenses by category, and generates a monthly summary page—designed for small teams, offices, or event budgets that need a simple audit trail without complex accounting software.
Deliverables
- Petty cash log spreadsheet
- Running balance formulas
- Monthly summary tab
What's included
- Daily entry sheet
- Category dropdowns
- Sample seed data
Not included
- Bank reconciliation
- Receipt imaging
- Multi-location consolidation
What you'll get
A list of expense categories you track (e.g. 'Office Supplies', 'Meals', 'Mileage', 'Repairs'), your starting float amount, and any sample transactions you want included to test the formulas (optional).
Builds a multi-tab spreadsheet with a daily entry sheet (date, amount, category, description, running balance columns), category dropdowns to prevent data-entry typos, formulas that auto-calculate remaining cash after each transaction, and a separate tab that totals spending by category for the month.
One Excel or Google Sheets file with three working tabs: Daily Log, Category Dropdowns (hidden reference sheet), and Monthly Summary. All formulas are unlocked for you to edit, and sample seed data is included to show how entries flow into the monthly totals.
Your $100 payment stays in escrow until you confirm the running balance calculations are accurate and the category summary tab matches your test data.
Common use cases
Coffee-shop till float
A coffee shop's manager needs a daily petty cash log for the $200 register float covering small vendor cash payouts and tip-jar deposits.
Film production daily petty cash
A small production company needs a per-shoot-day petty cash log with categories (craft service, props, locations) so producers can reconcile after wrap.
Medical clinic front desk cash drawer
A busy clinic collects copayments and parking fees in a locked drawer but needs to track variance at shift end. The student creates a log where the receptionist enters each payment by source, and the monthly summary shows total copay vs. parking revenue—revealing if the $200 starting float should be adjusted.
Nonprofit donation processing center
A small nonprofit's volunteers handle donated items and occasional cash gifts on-site. Staff need to log each cash transaction (donor name, amount, purpose) and confirm the month's total matches their bank deposit. The spreadsheet includes a reconciliation row to flag missing cash.
Retail kiosk operator reimbursement
A mall kiosk owner fronts small expenses (credit card fees, change orders, supplies) and tracks them for monthly reimbursement from headquarters. The log sorts expenses by vendor and shows total out-of-pocket, making reimbursement requests faster and dispute-proof.
Frequently asked questions
Can I use this in Google Sheets, or do I need Excel?
The student will deliver a file compatible with both—built in Google Sheets by default, but exportable as .xlsx for Excel. Formulas like SUM and VLOOKUP work identically in both, and category dropdowns use data validation that transfers cleanly.
What happens if I add or remove a category after the sheet is live?
You can add new categories to the reference sheet anytime; the dropdown will auto-update. If you remove a category, past entries with that label remain visible (no data loss), but new entries won't offer that choice in the dropdown—ideal for seasonal or one-time expense types.
Does the running balance reset at month end, or does it carry forward?
The daily log carries the running balance forward continuously—if you end January with $145 remaining, February 1st starts at $145. The monthly summary tab shows only February transactions separately, so you can see both the cumulative balance and the month's delta.
How many rows should I expect in the daily log sheet?
The student will pre-format the sheet for 250 daily entries (roughly 8–10 months of typical petty cash activity); you can insert additional rows below if needed, and the running balance formula will auto-extend.
What if I need to adjust or delete an entry by mistake—will the running balance break?
No. Because the running balance uses a SUM formula tied to each date, deleting or editing a single entry will recalculate automatically. The student will document the formula structure so you can confidently edit without breaking downstream calculations.
Ready to get your project started?
Select a scope and let your Shamrck PM handle the rest. Pay the full total upfront at checkout, then review and approve the completed deliverable. Approval does not trigger a new charge.
Already have an account? Log in