Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Petty Cash Log Spreadsheet Template for Google Sheets & Excel

Fifty cash movements, each with an amount in or an amount out, a running balance and a reference column pointing at the voucher or receipt behind it. The Essentials Petty Cash Log spreadsheet template holds the starting balance as a labelled setting rather than a row in the log, and reports the current balance - what should physically be on hand - and the net change on a Dashboard. Two working sheets and two charts. Google Sheets and Excel. No macros, no VBA.

Instant digital delivery · Terms & Conditions apply

Essentials Petty Cash Log spreadsheet template - Google Sheets and Excel preview

What's Included

  • A running balance on every cash movement
  • A starting balance held as a labelled setting rather than a row in the log
  • A reference column for the voucher or receipt each entry points at
  • Amount in and amount out kept in separate columns
  • Current balance - what should physically be on hand
  • Total in, total out and the net change across the period
  • A count of entries logged
  • Two charts on the dashboard
  • A currency dropdown on the Dashboard that relabels money columns on both sheets
  • Works in Microsoft Excel and Google Sheets with no setup required

The FinancialAha Essentials Petty Cash Log Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook, a row per cash movement, with a How to Use guide on a third tab. It works as an Essentials Petty Cash Log Excel template and an Essentials Petty Cash Log Google Sheets template from the same download. This Essentials Petty Cash Log spreadsheet template reports what should be in the float, what has moved in each direction, and the net change over the period. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Petty Cash Log spreadsheet template

The FinancialAha Essentials Petty Cash Log Spreadsheet Template runs on two working sheets - one you fill in, one that reports back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Petty Cash Log spreadsheet holds.

  1. 01 of 02

    Cash Log

    A starting balance in a labelled cell of its own, then a row per movement in and out. Each carries a date, a reference, a description, and the amount in whichever direction it went, with a running balance beside it that takes the row above and adjusts it. Keeping the opening figure as a setting rather than a line inside the log is a small change that matters at period end, when the float is being closed off and reopened - the opening balance is a fact about the period rather than a transaction in it. The reference column is where a voucher or receipt number goes. Cash is the one thing with no independent record behind it, so a log that points at a physical slip for every line is the difference between a record and an assertion. Worth being straight about a trade: this build carries that reference column in place of the free build's category column, so grouping spending by type is not something it does.

    FinancialAha Petty Cash Log spreadsheet template - Cash Log sheet

  2. 02 of 02

    Dashboard

    The float in six figures: what should be on hand now, what has been paid in, what has gone out, the net change across the period, how many entries have been logged, and the balance it opened with. The net change is the one to read alongside the current balance - a float can end a month roughly where it started and still have had far more moving through it than anyone expected. Two charts sit alongside.

    FinancialAha Petty Cash Log Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering the starting balance setting, what each column expects, and how the running balance and dashboard figures are built. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Petty Cash Log Spreadsheet template for Google Sheets

Upload the Essentials Petty Cash Log Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Petty Cash Log Google Sheets template needs no conversion step and both charts survive the trip intact - the running balance recalculates exactly as it does in Excel. The currency dropdown on the Dashboard relabels the money columns on both sheets at once.

Essentials Petty Cash Log Google Sheets template setup

A shared copy of the Essentials Petty Cash Log Google Sheets template suits a float several people draw on, since whoever takes the cash can log it with the voucher number in the moment. Sheets version history covers an entry typed over, which matters on a record that has to reconcile against physical cash.

Sharing the Essentials Petty Cash Log Google Sheet

The Essentials Petty Cash Log Google Sheet is meant to be filled in as money moves - a cash float is the one record that cannot be rebuilt from a statement later. Because the dashboard reads the log directly, the figure to count the tin against is always current.

Essentials Petty Cash Log Spreadsheet template for Excel

The Essentials Petty Cash Log spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Petty Cash Log Excel template directly, with no import step and no compatibility prompt, and both charts are native Excel charts that redraw as entries are added. There are no macros and no VBA in the file.

Essentials Petty Cash Log Excel template setup

The same Essentials Petty Cash Log Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Petty Cash Log spreadsheet download to choose between.

Essentials Petty Cash Log spreadsheet Excel notes

The Essentials Petty Cash Log spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt - which matters when a cash record is handed to a bookkeeper or an auditor.

Opening the Essentials Petty Cash Log spreadsheet Excel file

Nothing in the Essentials Petty Cash Log Excel template is version-specific, so this Essentials Petty Cash Log spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Spreadsheet template highlights

What the Essentials Petty Cash Log spreadsheet template tracks

A row per movement. This is what the Essentials Petty Cash Log Spreadsheet Template holds against each one:

Date
when the cash moved
Reference
the voucher or receipt number the entry points at
Description
what it was for
Amount In
money put into the float, including replenishments
Amount Out
money taken out of it
Balance auto
derived, a running figure carried down from the starting balance

Compare builds

FinancialAha Petty Cash Log spreadsheet template: Free and Essentials compared

Feature Free View Spreadsheet Template Essentials This page
Working sheets 1 2
Transaction rows 16 50
Running balance Yes Yes
Opening balance A row in the log A labelled setting
Category on each entry Yes –
Reference code – Yes
Current balance reported Yes, on the log strip Yes, on a dashboard
Total in and out Yes, on the log strip Yes, on a dashboard
Net change – Yes
Charts – 2

The FinancialAha Essentials Petty Cash Log Spreadsheet Template covers two working sheets. Against the Free Petty Cash Log Spreadsheet Template, which already reports a running balance, a total in and a total out, this build adds the net change and the entry count, across two charts it does not have. It also holds the opening balance as a labelled setting rather than a row in the log, and adds a reference column for voucher numbers - carried in place of the free build's category column rather than alongside it.

Compare the other builds: Free Petty Cash Log spreadsheet template .

Good to know

Notes on working in the Essentials Petty Cash Log spreadsheet template

  • The starting balance is a setting rather than a row, which is what makes closing off a period and reopening it clean.
  • The reference column is the point of a cash record - cash has no independent trail behind it, so a line that points at a physical slip is worth more than one that does not.
  • Net change read beside the current balance is what shows a float that ended where it started after a busy month.
  • This build has no category column. Grouping spending by type is on the free build, which keeps its own balance, total in and total out alongside it.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Petty Cash Log spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials Petty Cash Log Spreadsheet Template

1

Set the starting balance

It sits in its own labelled cell above the log.

2

Log each movement

Date, reference, description, and the amount in or out.

3

Record the voucher

The reference column points each line at a physical slip.

4

Read the dashboard

What should be on hand, what moved each way, and the net change.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Petty Cash Log Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Petty Cash Log Google Sheets template needs no conversion step and both charts survive the trip intact.

Is the FinancialAha Essentials Petty Cash Log Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Petty Cash Log Excel template opens directly in Excel with no import step. Both charts are native Excel charts, and there are no macros or VBA.

Will the FinancialAha Essentials Petty Cash Log spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Petty Cash Log spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Does the Essentials Petty Cash Log spreadsheet have a category column?

No, and it is worth knowing before you buy. It carries a reference column for voucher numbers in place of one. The free build keeps the category column alongside a balance, a total in and a total out of its own; this build trades the category for the reference and adds the net change, an entry count and two charts.

Why is the starting balance a setting rather than a row in the Essentials Petty Cash Log spreadsheet?

Because an opening balance is a fact about the period rather than a transaction in it. Keeping it separate makes closing a period off and reopening the next one clean.

What is the reference column for in the Essentials Petty Cash Log spreadsheet?

The voucher or receipt number behind each entry. Cash is the one thing with no independent record behind it, so a line that points at a physical slip is the difference between a record and an assertion.

What does net change tell me in the Essentials Petty Cash Log spreadsheet?

How the float moved across the period, read beside the current balance. A float can end a month roughly where it started and still have had far more passing through it than anyone expected.

How many entries does the Essentials Petty Cash Log spreadsheet hold?

Fifty, each with a running balance. The Free build holds sixteen.

How do I open the Essentials Petty Cash Log spreadsheet template in Google Sheets?

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

More Essentials Business Finance Templates

Cash Flow Statement

Twelve months across the page, with operating, investing and financing activities grouped into sections of their own and an annual total closing the grid. The Essentials Cash Flow Statement spreadsheet template carries the cash position month to month - you enter January's opening balance and the rest link forward - and follows the usual accounting convention on the working-capital lines. Three working sheets. Google Sheets and Excel. No macros, no VBA.

$19

Profit & Loss Projection

Year one is what you enter; years two and three are worked out from six assumptions you set - revenue, cost of goods sold and operating expense growth, plus a tax rate. The Essentials Profit & Loss Projection spreadsheet template runs thirteen lines from revenue through gross profit and margin, operating income, EBITDA, interest and income before tax, down to net income, with a dashboard over the top. Google Sheets and Excel. No macros, no VBA.

$19

Sales Forecast

Ten product lines forecast across twelve months, then the same ten again recording what actually happened, with the variance worked out per month in money and as a percentage. The Essentials Sales Forecast spreadsheet template gives every line an annual total and a share-of-total figure, and reports the year total and the implied growth on a dashboard. Two working sheets, Google Sheets and Excel. No macros, no VBA.

$19

Startup Costs

Fourteen one-time costs and twelve monthly operating ones stay on lists of their own, each line carrying an estimate, an actual, the variance and a per-cent-spent figure. The Essentials Startup Costs spreadsheet template builds a first-year total from both, one-time plus twelve months of operating, and sets up to six funding sources against it. A notes column records what each figure assumes. Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →