If you take a loan against property for the business, keep three things apart from day one: the money the lender pays out, the business spending it funds, and the EMI that follows. Give each its own account or ledger, and keep the household budget out of all three. The loan is secured on a property your family may live in, so mixing the money makes it hard to see what the business is really costing the home.
Why the loan money needs its own trail
Once a lakh or two of loan money sits in a savings account next to the grocery and school-fee spending, it gets spent on both without anyone deciding to. Six months later you cannot say how much went into the shop and how much into the household, and you cannot say whether the business is paying its own EMI. A separate trail answers those questions in minutes.
The setup: three buckets
- Bucket 1, loan proceeds: the amount disbursed, less any charges the lender deducts. Move it into a separate business account on the day it arrives.
- Bucket 2, business spending: every payment that expands or runs the business, paid from that business account only.
- Bucket 3, the EMI: paid from the business account if the business earns enough, otherwise show clearly how much the household tops up each month.
The household budget stays a fourth, separate set of numbers. Nothing in it should be funded from the loan money, and anything the business owes the family should be written down as a transfer, not hidden in a grocery line.
A worked example with invented numbers
Say a kirana owner takes a loan against property of ₹15,00,000 to expand her shop. The lender deducts ₹30,000 as processing and other charges, so ₹14,70,000 reaches the account. Every figure below is hypothetical.
| Item | Amount (₹) | Balance of loan money (₹) |
|---|---|---|
| Received after charges | 14,70,000 | 14,70,000 |
| Shop fit-out and shutters | 4,80,000 | 9,90,000 |
| Racks and refrigeration | 1,90,000 | 8,00,000 |
| Opening inventory for the bigger range | 5,50,000 | 2,50,000 |
| Kept as working-capital cushion | 2,50,000 | 0 |
Check: 4,80,000 + 1,90,000 + 5,50,000 = 12,20,000, and 14,70,000 minus 12,20,000 leaves 2,50,000. The cushion is not spent, so keep it in the business account, and drawing on it later should be a logged decision.
Now the EMI. Say it is ₹19,800 a month. Pay it from the business account and log it under loan repayment for the business. If the shop's takings after costs in a month are ₹26,000, the EMI is covered with ₹6,200 left; if they are ₹15,000, the shortfall of ₹4,800 is a household top-up that you should record by name rather than let it vanish into the month's spending.
How do I split the EMI into interest and principal?
Your lender's repayment schedule or loan statement shows what part of each instalment is interest and what part reduces the loan. Do not guess it. Record the full EMI as one business payment, and if you want the split, copy it from the schedule into a second column. Rules on how loan interest is treated for tax are not something to infer from a tracker, so ask your CA how to report it.
What if the business account is also used for personal spending?
Then pick a clean-up rule and stick to it. A simple one: any personal payment from the business account is logged as a drawing, with the date and reason, and any business payment made from a personal account is logged as money the business owes you. At month end the two lists should net to a single number you can settle with a transfer.
Doing this in a tracker
In a spreadsheet, add a column called Bucket with the values Loan, Business or Household, and filter on it. In SpendixAI you can upload each bank account's statement separately, pick the right account before importing so every row keeps it, and set up custom categories such as Shop fit-out and Loan EMI. Keep receipts with the transactions that carry them.
A monthly routine
- Match the business account statement to your ledger and mark anything unexplained.
- Check that the loan-money balance in your ledger equals what is actually left unspent.
- Write down the household top-up for the EMI, if any.
- Note the instalments paid and the outstanding balance shown on the lender's latest statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
