✓ Direct downloaden·PDF · Excel · Google Sheets·14 dagen niet-goed-geld-terug·PayPal en alle bekende kaarten
NL
Excel en Google Sheets · Excel 2016+ · Google Sheets

Complete Jaarbudget-spreadsheet

12 maanden budget op de automatische piloot — dashboard, 60 categorieën, rekeningen, schulden, sparen en vermogen in één Excel-/Google Sheets-bestand.

$14.99 $29.99 50% korting

Direct downloaden · licentie voor persoonlijk gebruik · levenslang updates
Betaal met PayPal of een willekeurige kaart

PayPalVISAMastercardAMEX
  • 18 tabbladen · 7025 formules
  • Formaten: .xlsx (Excel 2016+, Google Sheets) + PDF guide
  • ZIP: 194 KB
Zit ook in de Complete Budgetspreadsheet-bundel 9 producten voor $39 — je bespaart $57.91 ten opzichte van los kopen. Bekijk de bundel →
♡ 14 dagen niet-goed-geld-terug

Stel het in, gebruik het minstens een week en als het echt niets voor je is, stuur ons dan binnen 14 dagen een bericht met een schermafbeelding van je opzet — dan krijg je het volledige bedrag terug.

De productdetails zijn voorlopig in het Engels.

One workbook for the whole year. Set it up once on the Settings tab (currency, start month, your categories and income), then just log what you spend. The Dashboard, monthly summaries, 50/30/20 check, category analysis and net worth chart all update themselves.

Inside are 18 linked sheets and 7,025 formulas: a 1,000-row Expense Log with category and payment dropdowns, a 300-row Income Log, an Annual Budget grid for every category and month, a Bills Tracker with 12 paid check-marks and a Cash Flow Calendar that shows which bills land on which day. Debt payoff uses the same NPER maths as a loan calculator; savings goals and sinking funds tell you exactly how much to put aside each month.

It ships with three months of realistic sample data for a fictional household so every chart is alive the moment you open it — clear the yellow cells in a minute and make it yours. Built only with functions Google Sheets supports (no macros, no XLOOKUP), so it works the same in Excel 2016+, Excel 365 and Google Sheets, on desktop and phone.

Wat je krijgt

  • 18 sheets, 7,025 formulas — no macros, nothing locked
  • Dashboard with 8 KPIs, 4 charts, month-by-month table and your top 5 categories
  • 60 ready-made categories in 16 groups, each tagged Need / Want / Saving, plus 10 blank rows for your own
  • 1,000-row Expense Log and 300-row Income Log with dropdowns and automatic month / group / type columns
  • Annual Budget grid (category × month), Monthly Summary and Category Analysis with over-budget flags
  • Bills Tracker (40 bills, autopay, 12 paid marks) and a Cash Flow Calendar by due day
  • Debt Tracker with NPER payoff months, interest estimate, debt-free date, snowball vs avalanche focus
  • Savings Goals, Sinking Funds, Subscriptions audit, Net Worth by month, Monthly Review, 50/30/20 check
  • Any currency symbol, any start month (fiscal years welcome), Google Sheets instructions PDF included

Bekijk elke pagina

Klik op een pagina om die te vergroten.

All pages of Complete Jaarbudget-spreadsheet

Wat erin zit

Start HereSetup steps, colour legend, what every sheet does.
SettingsCurrency, budget year, start month, pay frequency, 50/30/20 targets, 60 categories with default budgets, income sources, dropdown lists.
Dashboard8 KPIs, income vs spending, spending by group, needs/wants/savings vs target, planned vs actual, month table, top 5 categories, snapshot.
Annual BudgetPlanned amount for every category in every month, pre-filled from your defaults, with annual totals and left-to-assign.
Monthly SummaryIncome, planned, actual, needs, wants, savings, savings rate and status per month; actual-by-category matrix.
Expense Log1,000 rows: date, description, category dropdown, amount, payment method, notes.
Income Log300 rows with a source dropdown.
Bills Tracker40 bills: amount, frequency, due day, autopay, monthly equivalent, annual cost, 12 paid marks.
Savings Goals12 goals with remaining, % complete, months to go and estimated completion date.
Debt Tracker12 debts: NPER months to payoff, total interest, payoff date, weighted APR, avalanche and snowball focus.
Net Worth10 assets and 10 liabilities by month, net worth and change, bar chart.
Monthly Review12 blocks with auto-filled numbers plus wins, challenges, next-month focus and a rating.
Category AnalysisPlanned vs actual per category and per group with data bars, % of total and over-budget flags.
50-30-20 RuleNeeds / wants / savings vs your targets, annually and by month, with a stacked chart.
Sinking Funds12 funds with deadline, months left and the amount to save per month.
Subscriptions30 subscriptions with monthly equivalent, annual cost, renewal date and keep/cancel savings.
Cash Flow CalendarPick a month: bills by day on a calendar grid plus a date-ordered list with paid status.
NotesFree space for reminders and money-date notes.

Vragen

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive, open it and choose File → Save as Google Sheets. Every formula uses functions Sheets supports (SUMIFS, INDEX/MATCH, NPER, EDATE and friends); there are no macros, no XLOOKUP and no dynamic arrays. The included PDF walks you through it.

Can I change the currency?

Yes. Type any symbol on the Settings tab ($, €, £, ¥, CHF, kr…). It appears in the Dashboard labels, and the numbers use your computer's regional format for thousands and decimals.

Can I add or rename categories?

Yes. The Settings tab has 60 categories in 16 groups plus 10 blank rows. Rename, regroup, re-type (Need / Want / Saving) or add your own — every other sheet picks the change up automatically.

Which Excel versions are supported?

Excel 2016 or newer on Windows and Mac, Excel 365 and Excel Online. It also opens in Apple Numbers and LibreOffice, though charts and colour rules can look slightly different there.

Is it really sample data I can delete?

Yes. Three months (January–March) for a fictional household are pre-filled in the yellow input cells only. The PDF lists the exact ranges; select the yellow cells and press Delete. Formulas, dropdowns and charts stay intact.

Beoordelingen

Nog geen beoordelingen — dit product is nieuw. Elke beoordeling hier komt van een geverifieerde aankoop.

Licentie voor persoonlijk gebruik binnen één huishouden. Doorverkoop of verspreiding is niet toegestaan. Wordt direct na betaling geleverd als ZIP-download. Er wordt niets fysieks verstuurd.