✓ Скачивание сразу·PDF · Excel · Google Sheets·Гарантия возврата 14 дней·PayPal и любые карты
RU
Excel и Google Sheets · Excel 2016+ · Google Sheets

Большая годовая таблица бюджета

12 месяцев бюджета почти без вашего участия — панель, 60 категорий, счета, долги, накопления и капитал в одном файле Excel / Google Sheets.

$14.99 $29.99 Скидка 50%

Скачивание сразу · лицензия для личного использования · обновления навсегда
Оплата через PayPal или любой картой

PayPalVISAMastercardAMEX
  • 18 листов · 7025 формул
  • Форматы: .xlsx (Excel 2016+, Google Sheets) + PDF guide
  • ZIP: 194 KB
Есть и в наборе «Полный набор таблиц бюджета» 9 товаров за $39 — экономия $57.91 по сравнению с покупкой по отдельности. Открыть набор →
♡ Гарантия возврата 14 дней

Настройте, попробуйте хотя бы неделю — и если вам это действительно не подошло, напишите нам в течение 14 дней и приложите скриншот вашей настройки: вернём всю сумму.

Подробное описание товара пока на английском.

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.

Что вы получите

  • 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

Посмотреть все страницы

Нажмите на страницу, чтобы увеличить.

All pages of Большая годовая таблица бюджета

Что внутри

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.

Вопросы

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.

Отзывы

Отзывов пока нет — товар новый. Все отзывы здесь оставляют только подтверждённые покупатели.

Лицензия для личного использования в одной семье. Перепродажа и распространение запрещены. Доставляется как ZIP-файл сразу после оплаты. Физический товар не отправляется.