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中文
Envelope Budget Ultimate ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Envelope Budget Spreadsheet Template for Google Sheets & Excel

Income goes in once at the top and every envelope is funded from it, each carrying a remaining balance and a status reading on track or over. The Essentials Envelope Budget spreadsheet template holds 18 envelopes on its tracker and reports six figures on a dashboard: income, allocated, spent, remaining, envelopes on track, and the unallocated income the month has not accounted for. Google Sheets and Excel, one file. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Envelope Budget Spreadsheet Template
$29
Essentials Envelope Budget spreadsheet template - Google Sheets and Excel preview

What's Included

  • Income entered once, with every envelope funded from it
  • A remaining balance on every envelope, updating as spending is recorded
  • A status on each envelope marking it on track or over
  • Dashboard carrying six figures: income, allocated, spent, remaining, envelopes on track, and unallocated income
  • Unallocated income reported plainly - the part of the month the envelopes have not accounted for
  • Two charts: each envelope's allocation against what it spent, and where the spending landed
  • A currency dropdown on the Dashboard that relabels money columns across both sheets at once
  • Step-by-step "How to Use" guide on a tab of its own
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Income entered once, with every envelope funded from it
  • A remaining balance on every envelope, updating as spending is recorded
  • A status on each envelope marking it on track or over
  • Dashboard carrying six figures: income, allocated, spent, remaining, envelopes on track, and unallocated income
Ultimate - $29
  • Envelope Setup defining every envelope once, each with an allocation, a priority and a note
  • Priority marking every envelope essential, important or optional
  • Unallocated income reported as a buffer rather than left implicit
  • A Spending Log carrying date, description, envelope, amount, payment method and notes
  • Monthly Envelopes pulling spending from the log automatically, so there is no second tally to keep
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Envelope Budget Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook that turns a month's income into funded envelopes and tracks what is left in each, with a How to Use guide on a third tab. It works as an Essentials Envelope Budget Excel template and an Essentials Envelope Budget Google Sheets template from the same download. Where the Free build sets allocated against spent, this Essentials Envelope Budget spreadsheet template carries a running balance on every envelope, marks each one on track or over, and reports the month across two charts. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Envelope Budget spreadsheet template

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

  1. 01 of 02

    Dashboard

    The month in six figures: what came in, what has been allocated across the envelopes, what has been spent from them, what is left, how many envelopes are still on track, and how much of the income has not been assigned to anything. That last one is the useful one - it is the money the method has not yet accounted for. Two charts sit alongside, one setting each envelope's allocation against what it actually spent, the other showing where the spending landed.

    FinancialAha Envelope Budget spreadsheet template - Dashboard sheet

  2. 02 of 02

    Envelope Tracker

    The sheet you type into. Income goes in at the top, then each envelope takes a name and an allocation, and you update what has been spent as the month goes. The remaining balance and the status beside it settle themselves, so an envelope running short shows up as you record rather than at the end. Envelopes named however suits you.

    FinancialAha Envelope Budget Google Sheets template - Envelope Tracker sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, how to choose envelope amounts, what the colour coding means, and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Envelope Budget Spreadsheet template for Google Sheets

Upload the Essentials Envelope Budget Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Envelope Budget Google Sheets template needs no conversion step and both charts survive the trip intact - the balances keep working exactly as they do in Excel. The currency dropdown on the Dashboard relabels every money column across both sheets at once.

Essentials Envelope Budget Google Sheets template setup

A shared copy of the Essentials Envelope Budget Google Sheets template suits a household drawing on the same envelopes, which is where the method needs the most visibility. Because the reporting sits on its own tab, one person can update the Envelope Tracker while the other reads the Essentials Envelope Budget spreadsheet dashboard.

Sharing the Essentials Envelope Budget Google Sheet

Day to day the Essentials Envelope Budget Google Sheet is a short job: open the Envelope Tracker, add what went out to the right envelope, and the remaining balance and status settle. The Dashboard is the weekly read rather than the daily one, and version history covers a figure entered against the wrong envelope.

Also available as:

Essentials Envelope Budget Spreadsheet template for Excel

The Essentials Envelope Budget spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Envelope Budget Excel template directly, with no import step and no compatibility prompt, and both charts are native Excel charts that redraw as the numbers change. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials Envelope Budget Excel template setup

The same Essentials Envelope Budget 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 Envelope Budget spreadsheet download to choose between.

Essentials Envelope Budget spreadsheet Excel notes

The Essentials Envelope Budget spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials Envelope Budget spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.

Opening the Essentials Envelope Budget spreadsheet Excel file

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

Also available as:

Spreadsheet template highlights

What the Essentials Envelope Budget spreadsheet template tracks

You name the envelopes, set what goes into each, and record what comes out. The Essentials Envelope Budget Spreadsheet Template derives the rest:

Envelope
the name of the envelope, free text
Allocated
what you are putting into it this month
Spent
what has come out of it so far
Remaining auto
derived, what is still in the envelope
Status auto
derived, marking the envelope on track or over

Compare builds

FinancialAha Envelope Budget spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 6
Envelope capacity 15 18 15, plus a 100-row spending log
Planned vs actual Yes Yes Yes
Income entered Yes Yes Yes
On track / over status – Per envelope Per envelope, plus % used
Charts – 2 2
Transaction log – – 100 rows, with payment method
Rollover between months – – Yes, entered per envelope
Transfers between envelopes – By editing allocations Logged, 30 rows
Envelope priority – – Essential / Important / Optional
12-month history – – Yes, with annual stats

The FinancialAha Essentials Envelope Budget Spreadsheet Template covers two working sheets. Against the Free Envelope Budget Spreadsheet Template, which sets allocated against spent with no income figure and no running balance, this build funds the envelopes from an income total, carries a remaining balance and a status on each, and reports the month on a dashboard with two charts - including how much income has not been allocated at all. What it does not have is a transaction log: spending is entered as a running total per envelope, and moving money between envelopes means editing both allocations. The Ultimate Envelope Budget Spreadsheet Template adds a spending log that feeds the envelopes automatically, logged transfers, month-to-month rollover, priorities, and a twelve-month history.

Compare the other builds: Free Envelope Budget spreadsheet template or the Ultimate Envelope Budget spreadsheet template .

Good to know

Notes on working in the Essentials Envelope Budget spreadsheet template

  • Unallocated income is the figure worth watching on the Dashboard - it is the part of the month the envelopes have not yet accounted for.
  • Spending is recorded as a running total per envelope rather than transaction by transaction. The Ultimate build is the one with a log.
  • Moving money between envelopes means editing both allocations, so the two changes need making together.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Envelope Budget spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials Envelope Budget Spreadsheet Template

1

Enter your income

Put your monthly income at the top of the Envelope Tracker. Everything the Dashboard reports is measured against it.

2

Fund your envelopes

Name each envelope and set what goes into it this month in the Allocated column.

3

Record spending

Update the Spent column as the month goes. The remaining balance and the status settle themselves.

4

Check the dashboard

Read the six figures and the two charts - including how much income is still unallocated.

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.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Envelope Budget Spreadsheet Template a Google Sheets template?

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

Is the FinancialAha Essentials Envelope Budget Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Envelope Budget 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 Envelope Budget spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Envelope Budget 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 Envelope Budget spreadsheet log individual transactions?

No. Spending is entered as a running total per envelope rather than transaction by transaction. The Ultimate build adds a spending log that feeds the envelope balances on its own.

How many envelopes can I create in the Essentials Envelope Budget spreadsheet?

Eighteen, each named however suits you. The allocation, the spending, the remaining balance and the status all sit on one row per envelope.

Can I move money between envelopes in the Essentials Envelope Budget spreadsheet?

Yes, by editing both allocations - taking the amount off one and adding it to the other. The Ultimate build logs transfers on a sheet of their own instead.

What happens when an envelope runs out in the Essentials Envelope Budget spreadsheet?

The remaining balance goes negative and the status marks that envelope as over. Nothing is blocked; the sheet reports the position rather than enforcing it.

What is unallocated income in the Essentials Envelope Budget spreadsheet template?

The part of your income that has not been assigned to any envelope. The Dashboard reports it so money that has not been given a job is visible rather than assumed spent.

How do I open the Essentials Envelope Budget 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 Personal Budgeting Templates

Monthly Budget

Categories grouped into sections - income, housing, transport, food, utilities, insurance and more - each subtotalling itself, so areas of spending compare directly. The Essentials Monthly Budget spreadsheet template puts budget, actual and the difference on every line, adds a share-of-income column that stays comparable between a good month and a lean one, and reports a savings rate on the Dashboard. Google Sheets and Excel, one file. No macros, no VBA.

$19

50/30/20 Budget

Enter your income once and the three targets follow from the total. The Essentials 50/30/20 Budget spreadsheet template gives needs, wants and savings a section each, ten lines to fill, and a status on every one calling it on track or over - then reads the month back in six figures on a dashboard: income, the three targets, the savings rate you actually achieved, and whether you finished over or under. Two charts, three working sheets. Google Sheets and Excel. No macros, no VBA.

$19

Zero-Based Budget

Income goes in at the top and every allocation is measured against it, with a remaining-to-assign figure whose goal is zero - the number the method turns on. The Essentials Zero-Based Budget spreadsheet template groups categories into sections rather than one long list, puts planned against actual on every line, and reports income, total allocated and what is still unassigned on a Dashboard. Three tabs, Google Sheets or Excel. No macros, no VBA.

$19

Household Budget

Each partner gets an income section of their own and the two combine automatically, with personal spending kept apart from the grouped shared costs. The Essentials Household Budget spreadsheet template runs planned against actual on every line, derives the difference, adds a share-of-income column per category, and closes on a dashboard with combined income, total expenses, net savings and the savings rate. Google Sheets and Excel, one file. No macros, no VBA.

$19
Essentials
Preview
See Ultimate Financial Spreadsheet Templates - Full Access Pack 58 templates included • Save $1383

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 →