Report this item to Etsy

Budget Spreadsheet Template for Excel, Budget vs Actual Dashboard, 50 30 20 Budget Planner, Simple Household Budget with Charts

Price:$8.99

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 ZIP

See exactly where your money goes. Type what you planned and what you actually spent in each category, and this budget spreadsheet shows the difference, what is left, and how your spending compares with the 50/30/20 rule - on a clean dashboard with four charts.

WHY YOU WILL LIKE IT
- Know in seconds whether you are over or under budget in every category.
- Spot your biggest overspends automatically - no manual sorting.
- Check your plan against the 50/30/20 guideline with your own targets.
- Works in any currency: set your symbol or code once and every heading updates.
- Beginner-friendly: yellow cells are for typing, everything else calculates for you.

FEATURES
- Dashboard with 6 key numbers: actual income, actual expenses, remaining balance, left to budget, savings & debt share and categories over budget
- 4 automatic charts: budgeted vs actual by group, where the money went, 50/30/20 target vs actual, income vs expenses
- Budget sheet for up to 8 income lines and 50 expense categories with Budgeted, Actual, Remaining and % used
- Automatic status for every category: Over budget, Unplanned spend, At budget, Near limit, On track
- 10 editable spending groups, each mapped to Needs, Wants or Savings & debt
- 50/30/20 check with editable target percentages
- Review sheet: top 5 overspent categories plus reflection prompts for next period
- Currency label setting (e.g. $, EUR, GBP) shown in every amount heading
- Built-in checks: invalid amounts and unknown groups are flagged and kept out of totals
- Blank template plus a filled-in sample version, and a printable layout

EXAMPLE (fictional sample data)
In the sample (October 2026): actual income 5,765.75, actual expenses 5,267.80, so 497.95 is left; 5 categories are over budget and the biggest overspend, Home maintenance, is 65.20 over plan.

WHAT'S INCLUDED
- Budget-Spreadsheet.xlsx - blank template with starter categories (no amounts)
- Budget-Spreadsheet-SAMPLE.xlsx - the same workbook filled with fictional example data
- User-Guide.pdf - getting started, how the numbers work, Google Sheets steps and limitations
- Budget-Categories-Starter.csv - starter category list you can import or copy
- README.txt - quick start

HOW TO USE
1. Download the ZIP after purchase and unzip it.
2. Open Budget-Spreadsheet.xlsx in Excel (or upload it to Google Drive and save as Google Sheets).
3. Follow the Start Here sheet: set your currency, enter your income and budgeted amounts, then actuals.

COMPATIBILITY
- Microsoft Excel (desktop): tested in Microsoft 365 for Windows. Uses features available since Excel 2013.
- Google Sheets: built only with formulas that Google Sheets also supports; upload the .xlsx to Google Drive and choose File > Save as Google Sheets. Live Google Sheets testing is pending - see the note in the guide.
- Not tested in Apple Numbers, LibreOffice or Excel for Mac.

PLEASE NOTE
This is a digital download - no physical product will be shipped. Due to the nature of digital files, please read the description and compatibility notes before purchasing. This template is for personal budgeting and does not provide financial, tax or legal advice. Sample data is fictional.

FAQ
Do I need to enter every purchase?
No. This spreadsheet uses one Actual amount per category - add up receipts or check your bank app and type the total. (If you prefer logging every transaction, a transaction-based tracker is a different product.)

Can I change the categories?
Yes. Rename any category, add up to 50, and rename the 10 groups on the Settings sheet.

Does it work with my currency?
Yes. Type your symbol or code (e.g. EUR) on Settings; amounts are plain numbers in one currency.

How do I use it every month?
Save a copy of the file for each month, clear the Actual column and update the period label.

Is this financial advice?
No. It is a personal budgeting tool. The 50/30/20 check is a general guideline you can adjust.

Will I receive a physical item?
No. This is an instant digital download.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 25, 2026