✓ Téléchargement immédiat·PDF · Excel · Google Sheets·Garantie satisfaction 14 jours·PayPal et toutes les cartes
FR
Excel et Google Sheets · Excel 2016+ · Google Sheets

Le Grand Tableur Budget Annuel

12 mois de budget en pilote automatique — tableau de bord, 60 catégories, factures, dettes, épargne et patrimoine dans un seul fichier Excel / Google Sheets.

$14.99 $29.99 Économisez 50 %

Téléchargement immédiat · licence usage personnel · mises à jour à vie
Payez avec PayPal ou une carte

PayPalVISAMastercardAMEX
  • 18 feuilles · 7025 formules
  • Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
  • ZIP: 194 KB
Aussi dans le Pack Complet Tableurs Budget 9 produits pour $39 — vous économisez $57.91 par rapport à l'achat séparé. Voir le pack →
♡ Garantie satisfaction 14 jours

Installez le produit, utilisez-le au moins une semaine et, s'il ne vous convient vraiment pas, écrivez-nous dans les 14 jours avec une capture d'écran de votre installation : nous vous remboursons intégralement.

Le détail du produit est pour l'instant en anglais.

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.

Ce que vous recevez

  • 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

Voir toutes les pages

Cliquez sur une page pour l'agrandir.

All pages of Le Grand Tableur Budget Annuel

Ce qu'il y a dedans

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.

Questions

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.

Avis

Pas encore d'avis — ce produit est nouveau. Chaque avis publié ici provient d'un achat vérifié.

Licence d'usage personnel pour un foyer. Ni revente ni redistribution. Livré sous forme de fichier ZIP à télécharger immédiatement après le paiement. Aucun article physique n'est expédié.