Debt

Tracking where each rupee of a loan against property goes

Use a running ledger to track where each rupee of a loan against property goes, with a worked ₹20 lakh example and the unspent balance shown line by line.

Editorial illustration for Tracking where each rupee of a loan against property goes

To track where each rupee of a loan against property goes, keep a running ledger: the amount disbursed at the top, every spend underneath with the date, purpose and amount, and a balance column showing what is still unspent. The ledger closes when the balance is zero or when you have decided what the leftover will do. It works with a spreadsheet, a notebook or an expense tracker.

Why does a running balance matter?

A list of expenses tells you what was spent. A running balance tells you what is left, which is the number people lose track of. If the sanction was for a specific purpose, a ledger also shows at a glance that every rupee went where you said it would.

The ledger layout

  • Date
  • Purpose, in a word or two, such as Contractor or Machinery advance
  • Paid to
  • Mode, for example NEFT, UPI or cheque, with reference number
  • Amount
  • Balance of loan money left
  • Bill or receipt kept? Yes or no

Rule one: the balance is always the previous balance minus the new amount. Rule two: only money coming from the loan account counts. If you top up a job from your own pocket, log it separately so the ledger stays honest.

Example with a hypothetical ₹20 lakh disbursement

Suppose ₹20,00,000 is disbursed in full for a workshop upgrade. All the numbers below are invented.

DatePurposeAmount (₹)Balance (₹)
1 AprDisbursed20,00,00020,00,000
3 AprLoan charges paid out of proceeds40,00019,60,000
10 AprContractor, first instalment6,00,00013,60,000
22 AprBuilding materials3,50,00010,10,000
5 MayMachinery advance4,00,0006,10,000
18 MayWorking-capital reserve moved to savings2,00,0004,10,000

Check each line: 20,00,000 − 40,000 = 19,60,000; minus 6,00,000 = 13,60,000; minus 3,50,000 = 10,10,000; minus 4,00,000 = 6,10,000; minus 2,00,000 = 4,10,000. So ₹4,10,000 is unspent, and the next job to be paid from it should be written in a Planned column so it is not forgotten.

What do I do with the unspent balance?

Decide on purpose rather than by drift. The options are to hold it for the next planned payment, to keep it as a reserve with a written reason, or to use it to reduce the loan if the lender allows part-payment. Whichever you pick, write a one-line note with the date. Be aware that interest runs on the whole outstanding loan, not just the part you have spent, so unspent money is not free; ask the lender how part-payment works and what it costs.

How do I handle spends that are partly business, partly personal?

Split them into two lines at the time of payment. For example, if one bill covers a machine for the workshop and a deposit for something at home, log the workshop part against the loan and the home part against your household budget. Splitting later from memory is where errors creep in.

Where to keep it

In a spreadsheet, put the disbursed amount in F2 and each spend in column E from row 3; then the balance in F3 is =F2-E3, copied down so every row subtracts its own spend from the row above. In SpendixAI, add the loan account as its own account, upload its statement, review the rows before saving, and use a custom category per purpose. Reports can then group spending by category so the ledger totals are quick to check against the statement.

A month-end check

  • Do the ledger spends match the bank statement line for line?
  • Does the balance in the ledger equal what the statement implies?
  • Are there any amounts with no bill?
  • Is any payment waiting for approval or a milestone that you should note for next month?
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports