Excel + Google Sheets
Annual Budget
Annual budget spreadsheet for Google Sheets and Excel: a yearly budget planner with one tab per month fed by a single transaction log, a bill calendar, debt snowball or avalanche, savings and net worth.
A full year of your money, planned forward instead of explained backwards. Twelve monthly budget tabs, a bill payment calendar, savings and debt trackers, and a year dashboard that rolls it all up, so December-you can thank January-you.
Coming to Etsy this week
Instant download on Etsy: Excel files plus a link to your own Google Sheets copy.
What’s inside · 25 tabs
- Start: Read Me guide and Start tab. Currency, year and your own category lists
- Dashboard: The visual panel. Big KPI cards, donut and bar charts, with a month filter
- Log & Pay: Transaction Log, Payment tracker, bill Calendar, Account overview
- 12 Months: One budget tab per month (M01-M12), each fed by your log
- Year: The annual dashboard. The whole year at a glance
- Wealth: Savings tracker, Debt tracker (Snowball or Avalanche), Net Worth, plus a free-form Worksheet
- Plus a lists tab that holds the dropdown options you define.
Features
- Visual Dashboard tab: big KPI cards (income, spent, left over, savings rate, net worth), donut and bar charts that update from your entries; pick a month or the full year to filter
- Log once, see it everywhere: the month tabs and the year dashboard read the same log
- Five currencies: USD / CAD / AUD / EUR / GBP
- Pay-frequency aware: weekly, biweekly, twice-monthly or monthly
- Debt payoff your way: Snowball or Avalanche, switchable
- Importance ratings on expenses (Very Important to Unnecessary) to spot the easy cuts
- Filled EXAMPLE workbook + clean BLANK workbook included
- Excel AND Google Sheets versions, both in this listing
- Every formula tested before publishing
You’ll need
- Microsoft Excel 2016 or newer (desktop; Microsoft 365 not required) or a free Google account for the Google Sheets version.
- Best on desktop or laptop.
More in Budget
