✓ Sofort-Download·PDF · Excel · Google Sheets·14 Tage Zufriedenheitsgarantie·PayPal & alle gängigen Karten
DE
Excel & Google Sheets · Excel 2016+ · Google Sheets

Große Jahresbudget-Tabelle

12 Monate Budget wie von selbst — Dashboard, 60 Kategorien, Rechnungen, Schulden, Sparen und Vermögen in einer einzigen Excel-/Google-Sheets-Datei.

$14.99 $29.99 50 % sparen

Sofort-Download · Lizenz für private Nutzung · lebenslange Updates
Mit PayPal oder Karte bezahlen

PayPalVISAMastercardAMEX
  • 18 Blätter · 7025 Formeln
  • Formate: .xlsx (Excel 2016+, Google Sheets) + PDF guide
  • ZIP: 194 KB
Auch im Komplettpaket Budget-Tabellen 9 Produkte für $39 — du sparst $57.91 gegenüber dem Einzelkauf. Bundle ansehen →
♡ 14 Tage Zufriedenheitsgarantie

Richte es ein, nutze es mindestens eine Woche — und wenn es wirklich nicht zu dir passt, schreib uns innerhalb von 14 Tagen mit einem Screenshot deiner Einrichtung, und du bekommst den vollen Betrag zurück.

Die Produktdetails sind derzeit auf Englisch.

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.

Das bekommst du

  • 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

Jede Seite ansehen

Klick auf eine Seite, um sie zu vergrößern.

All pages of Große Jahresbudget-Tabelle

Was drin ist

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.

Fragen

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.

Bewertungen

Noch keine Bewertungen — dieses Produkt ist neu. Jede Bewertung hier stammt aus einem bestätigten Kauf.

Lizenz für die private Nutzung in einem Haushalt. Kein Weiterverkauf, keine Weitergabe. Lieferung als ZIP-Download sofort nach der Zahlung. Es wird nichts Physisches verschickt.