Debt Tracker Template

List every loan and card balance, log payments against them, and watch remaining balances and payoff progress shrink.

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

Trackers

Tables

Debts, Payments

Fields

23

Views

grid, dashboard, calendar, form

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.

Debts

14 fields · 4 sample rows

  • All debts (Grid)
  • Payoff (Dashboard)
DebtTextLenderTextTypeSingle selectOriginal amountCurrencyInterest ratePercentMonthly paymentCurrencyDue dayNumberStart dateDatePaymentsLink to another tableTotal paidRollupBalanceFormulaPaid offFormulaMonths to goFormulaStatusSingle select
HDFC credit cardHDFC BankCredit card₹85,00042.0%₹15,000520 Sep 2026HDFC – Oct, HDFC – Nov₹29,700₹55,30035%4Active
Car loan – SwiftSBICar loan₹6,00,0009.0%₹12,5001015 Oct 2025Swift EMI – Oct, Swift EMI – Nov₹17,870₹5,82,1303%47Active
Education loanAxis BankEducation loan₹4,50,00010.5%₹9,0001519 Dec 2024Edu loan – Nov₹5,900₹4,44,1001%50Active
Loan from Uncle RameshRamesh MamaFamily / friend₹50,0000.0%₹10,00021 Aug 2026Uncle Ramesh – final₹50,000₹0100%0Paid off
Field details
Debt · Text
Lender · Text
Type · Single select
Credit card, Personal loan, Car loan, Home loan, Education loan, Family / friend
Original amount · Currency
INR
Interest rate · Percent
Monthly payment · Currency
INR
Due day · Number
Start date · Date
Payments · Link to another table
Links to Payments
Total paid · Rollup
sum of Principal via Payments
Balance · Formula
MAX(0, {Original amount} - {Total paid})
Paid off · Formula
IF({Original amount} > 0, MIN(1, {Total paid} / {Original amount}), BLANK())
Months to go · Formula
IF({Monthly payment} > 0, ROUNDUP({Balance} / {Monthly payment}, 0), BLANK())
Status · Single select
Active, Paid off, Overdue

Payments

9 fields · 6 sample rows

  • Payment log (Grid)
  • Calendar (Calendar)
  • Record a payment (Form)
PaymentTextDebtLink to another tableDateDateAmountCurrencyInterest portionCurrencyPrincipalFormulaMethodSingle selectExtra paymentCheckboxNotesText
HDFC – OctHDFC credit card10 Oct 2026₹15,000₹2,900₹12,100Net banking
HDFC – NovHDFC credit card9 Nov 2026₹20,000₹2,400₹17,600Net bankingYesUsed Diwali bonus.
Swift EMI – OctCar loan – Swift14 Oct 2026₹12,500₹3,600₹8,900Auto-debit
Swift EMI – NovCar loan – Swift14 Nov 2026₹12,500₹3,530₹8,970Auto-debit
Edu loan – NovEducation loan18 Nov 2026₹9,000₹3,100₹5,900Auto-debit
Uncle Ramesh – finalLoan from Uncle Ramesh30 Oct 2026₹50,000₹0₹50,000UPIRepaid in full.
Field details
Payment · Text
Debt · Link to another table
Links to Debts
Date · Date
Amount · Currency
INR
Interest portion · Currency
INR
Principal · Formula
{Amount} - {Interest portion}
Method · Single select
Auto-debit, UPI, Net banking, Cash
Extra payment · Checkbox
Notes · Text

Form view “Record a payment” asks for: Payment, Debt, Date, Amount, Interest portion, Method, Extra payment, Notes.

Debt Tracker 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