Free Download - Excel & Google Sheets

Free Petty Cash Log Spreadsheet Template

Dated log of petty-cash disbursements with running balance.

Essentials $12 Free See Comparison & Free Download

petty-cash-log.xlsx

Free and Essentials - what's the difference?

Free Petty Cash Log

Spreadsheet Template

Works in Excel and Google Sheets · CC BY 4.0

What's Included

"Petty Cash" sheet with deposit, withdrawal, and running-balance columns
Running balance updates automatically after each entry
Simple date/description/category layout - easy to reconcile
Step-by-step "How to Use" guide included in a second sheet
Works in Microsoft Excel, Google Sheets, and LibreOffice Calc - no setup or sign-up

Essentials Petty Cash Log

Spreadsheet Template

Everything in Free
Dashboard with petty cash fund summary showing starting balance, total disbursed, and remaining fund amount
Cash log with date, payee, description, and amount columns plus an automatic running balance after each entry
Category tracking for each disbursement so petty cash spending can be grouped by office supplies, travel, meals
Fund reconciliation support with replenishment entries to reset the cash balance to the original fund amount

View Essentials $12›

How the Petty Cash Log template works

Dated log of petty-cash disbursements with running balance. Open the spreadsheet, enter your own numbers, and let the formulas do the math.

When this template helps

You want a running balance on a single account without connecting to the bank.

You are reconciling statements and want one line per transaction.

You need a simple record for a petty cash box, personal account, or small fund.

You prefer pen-and-paper style entry in a digital file.

Tips to get the most out of it

Keep the column labels simple - the formulas work best when categories are consistent month to month.
Replenish when low regularly - once a week is a good rhythm for most people.

Common mistakes to avoid

Entering transactions out of date order. The running balance column assumes chronological entries.
Missing a beginning balance. Without an opening row, the running balance starts from zero.
Reconciling once a year. Do it monthly - catching errors earlier saves time.

How to Use This Petty Cash Log Template

Review the sample data so

Review the sample data so you understand the layout.

Replace the sample values

Replace the sample values in the highlighted input cells with your own petty-cash transactions.

Totals and KPI strip

The totals and KPI strip at the top update automatically from your data.

When you hit

When you hit the row limit, upgrade to Essentials (or Ultimate) for more capacity.

Essentials

Petty Cash Log

Essentials (12) adds a dashboard, charts, and expanded categories.

View Essentials · $12

Built by Claude AI. Perfected by us.

We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.

Excel

Sheets

LibreOffice

No signup

Download instantly, no email required

Formula-driven

All calculations update automatically

Dual compatible

Works in Excel and Google Sheets

Sample data included

See the template in action right away

Frequently Asked Questions

What is the difference between Free, Essentials, and Ultimate?

Free is a single-sheet starter template (sample data + How to Use guide). Essentials ($12) adds a dashboard, charts, expanded categories, and pre-filled subcategories. Ultimate (when available) adds multi-entity tracking, scenario analysis, and power-user reporting across 6-7 interconnected sheets.

Should I upgrade to Essentials?

Upgrade to Essentials if you want a dashboard with charts, more categories, larger capacity, and a more polished spreadsheet for ongoing use. The Free version is a good fit for one-off planning or trying out the layout.

Is Essentials worth $12?

Essentials is a one-time $12 purchase with no subscription. It typically adds a full dashboard, 30-50% more categories or rows than the Free version, and richer formulas. Most buyers upgrade after using the Free version for a few weeks and hitting its limits.

What is included in the free version?

The free Petty Cash Log is a single-sheet template with sample data and a "How to Use" guide. It covers the essentials. The Essentials version ($12) adds a dashboard, larger capacity, and extended categories; Ultimate (when available) adds multi-entity tracking and ultimate-grade reporting.

Does the running balance update automatically?

Yes. Each new entry recalculates the running balance column based on the prior row plus deposits minus withdrawals.

Can I use this for reconciliation?

Yes. Enter transactions in date order and compare the ending balance to your statement. Flag discrepancies in the description column.

Is the file safe to download?

Yes. No macros, no sign-up, no tracking. The file is a plain .xlsx that opens directly in Excel, Google Sheets, or LibreOffice Calc.

How do I open this in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

What license is this template under?

All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.

Petty Cash Log

Free · $12

View Essentials

Free Petty Cash Log Spreadsheet Template

Free and Essentials - what's the difference?

Free Petty Cash Log

Essentials Petty Cash Log

How to Use This Petty Cash Log Template

Built by Claude AI. Perfected by us.

Frequently Asked Questions

More Free Business Finance Templates

Cash Flow Statement

Profit & Loss Projection

Sales Forecast

Startup Costs