Report this item to Etsy

Annual Budget Spreadsheet with Monthly Tabs, Expense Tracker for Excel and Google Sheets

Price:87,19 kr.

Loading
VAT Included
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by InkAndIndexShop
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

Enter each income and expense once and the twelve monthly tabs and the annual dashboard add everything up for you. A budget spreadsheet for Excel and Google Sheets built around a single transaction log.

WHAT YOU GET (3 files)
- Budget-Tracker_Blank.xlsx: your own copy, with common category names and no amounts
- Budget-Tracker_Example-Filled.xlsx: the same workbook filled with invented 2027 example data, so you can see how it works
- T1-Read-Me-First.pdf: a 4-page guide for Excel and Google Sheets

INSIDE THE WORKBOOK
- Start Here: plain steps, a color key and the limits
- Setup: the year, up to 10 income sources and up to 30 expense categories with a planned amount for each
- Transactions: one log with room for 5,000 rows. Date, description, category from a dropdown, amount. A Check column flags a category that is not on Setup or a date in another year
- Jan to Dec: twelve monthly tabs. Planned against actual for income and for every category, what is left, percent used and a status (OK, Near limit, On plan, Over), plus a line that should read 0 if every transaction was matched
- Dashboard: all twelve months side by side, a running left-over total, two charts, and every category by month

HOW IT WORKS
You type in the cells with blue text on yellow. Every other number is a formula. The monthly tabs count only transactions dated in that month of the year you type on Setup. Change the year to reuse the workbook for another year.

EXCEL AND GOOGLE SHEETS
It uses ordinary formulas (SUMIFS, IF, SUM) and no macros. In Google Sheets, use the link in the PDF guide to make your own copy, or upload the .xlsx to Google Drive, open it, then choose File, Save as Google Sheets. Formulas, dropdowns and colors usually carry across. Chart styling can change a little, so check one monthly tab and the Dashboard after you import. Amounts are shown without a currency symbol, so it works in any currency.

LIMITS
5,000 transaction rows, 10 income sources and 30 expense categories.

WHAT IS NOT INCLUDED
No bank connection, no automatic import, no bill reminders, no macros, no debt payoff or net worth tabs. The workbook does not move money or give advice.

NOT ADVICE
This is a record-keeping tool. It is not financial, tax or accounting advice.

FILES AND LICENSE
Digital files only. Personal use. Please do not resell, share or upload the files.

Designed by a seller. AI tools were used to help write the wording and the code that builds the workbook, the guide, the pictures and the video. The formulas were checked by comparing the workbook's results with an independent calculation of the example data.

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 18, 2026