Yearly Budget Template

An annual plan for income and expenses with quarterly actuals, year-to-date totals and the share of each budget already used.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Budget Sheets

Tables

Annual budget

Fields

12

Views

grid, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Annual budget

12 fields · 7 sample rows

  • Plan vs actual (Grid)
  • Year at a glance (Dashboard)
Line itemTextTypeSingle selectAnnual budgetCurrencyQ1 actualCurrencyQ2 actualCurrencyQ3 actualCurrencyQ4 actualCurrencyYTD actualFormulaRemainingFormula% usedFormulaMonthly budgetFormulaNotesText
Salary (net)Income₹18,00,000₹4,50,000₹4,50,000₹3,00,000₹12,00,000₹6,00,00067%₹1,50,000
Rental incomeIncome₹2,16,000₹54,000₹54,000₹36,000₹1,44,000₹72,00067%₹18,000
Home loan EMIFixed expense₹4,62,000₹1,15,500₹1,15,500₹77,000₹3,08,000₹1,54,00067%₹38,500
Insurance premiumsFixed expense₹85,000₹62,000₹0₹23,000₹85,000₹0100%₹7,083
Groceries & householdVariable expense₹2,40,000₹64,000₹61,000₹44,000₹1,69,000₹71,00070%₹20,000
Travel & holidaysVariable expense₹1,50,000₹92,000₹18,000₹52,000₹1,62,000₹-12,000108%₹12,500Diwali trip overspent
PPF + mutual fundsSavings₹3,60,000₹90,000₹90,000₹60,000₹2,40,000₹1,20,00067%₹30,000
Field details
Line item · Text
Type · Single select
Income, Fixed expense, Variable expense, Savings
Annual budget · Currency
INR
Q1 actual · Currency
INR
Q2 actual · Currency
INR
Q3 actual · Currency
INR
Q4 actual · Currency
INR
YTD actual · Formula
{Q1 actual} + {Q2 actual} + {Q3 actual} + {Q4 actual}
Remaining · Formula
{Annual budget} - {YTD actual}
% used · Formula
IF({Annual budget}, {YTD actual} / {Annual budget}, BLANK())
Monthly budget · Formula
{Annual budget} / 12
Notes · Text

Yearly Budget Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates