Personal Budget Template

Log income, spending and savings as signed transactions and track progress toward personal savings goals.

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

Transactions, Goals

Fields

17

Views

grid, calendar, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Transactions

10 fields · 8 sample rows

  • Ledger (Grid)
  • Calendar (Calendar)
  • Insights (Dashboard)
DescriptionTextDateDateTypeSingle selectCategorySingle selectAmountCurrencySigned amountFormulaAccountSingle selectMonthFormulaRecurringCheckboxGoalLink to another table
Salary — Infosys5 Nov 2026IncomeSalary₹92,000₹92,000Bank transfer2026-11Yes
Freelance logo project13 Nov 2026IncomeSide income₹15,000₹15,000UPI2026-11
PG rent6 Nov 2026ExpenseRent₹18,000₹-18,000UPI2026-11Yes
Groceries & snacks14 Nov 2026ExpenseFood₹4,200₹-4,200Debit card2026-11
Concert tickets16 Nov 2026ExpenseFun₹3,500₹-3,500Credit card2026-11
Udemy course17 Nov 2026ExpenseEducation₹499₹-499Credit card2026-11
Trip fund transfer7 Nov 2026SavingInvestments₹8,000₹-8,000Bank transfer2026-11YesJapan trip
Laptop fund transfer7 Nov 2026SavingInvestments₹5,000₹-5,000Bank transfer2026-11New MacBook
Field details
Description · Text
Date · Date
Type · Single select
Income, Expense, Saving
Category · Single select
Salary, Side income, Rent, Food, Transport, Health, Shopping, Fun and 2 more
Amount · Currency
INR
Signed amount · Formula
IF({Type} = 'Income', {Amount}, -{Amount})
Account · Single select
UPI, Credit card, Debit card, Bank transfer, Cash, Cheque
Month · Formula
IF({Date}, DATETIME_FORMAT({Date}, 'YYYY-MM'), '')
Recurring · Checkbox
Goal · Link to another table
Links to Goals

Goals

7 fields · 3 sample rows

  • Goals (Grid)
GoalTextTargetCurrencyTarget dateDateContributionsLink to another tableSavedRollupProgressFormulaNeeded per monthFormula
Japan trip₹2,50,00015 Sep 2027Trip fund transfer₹8,0003%₹26,889
New MacBook₹1,50,00018 Apr 2027Laptop fund transfer₹5,0003%₹36,250
Emergency fund (6 months)₹4,00,00012 May 2028₹00%₹23,529
Field details
Goal · Text
Target · Currency
INR
Target date · Date
Contributions · Link to another table
Links to Transactions
Saved · Rollup
sum of Amount via Contributions
Progress · Formula
IF({Target}, MIN({Saved} / {Target}, 1), BLANK())
Needed per month · Formula
IF(AND({Target date}, DATETIME_DIFF({Target date}, TODAY(), 'months') > 0), ROUND(({Target} - {Saved}) / DATETIME_DIFF({Target date}, TODAY(), 'months'), 0), {Target} - {Saved})

Personal 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