Business

All your business loans on one sheet: lender, balance, due date

A single sheet listing your bank loan, supplier credit, family money and chit with amount, instalment, due date and balance, read against your sales calendar.

Editorial illustration for All your business loans on one sheet: lender, balance, due date

Put every business debt on one sheet, whether it is a bank loan, supplier credit, money from family or a chit. For each, note the amount taken, the instalment, the due date, the balance left and what the money was for. Add up the monthly instalments and compare the total with the weeks your sales cash actually arrives.

What columns does the sheet need?

  • Lender or source: bank, supplier name, family member, chit group.
  • Purpose: stock, equipment, shop repair, wages gap.
  • Amount taken and date taken.
  • Instalment amount and how often it falls.
  • Due date each month.
  • Balance left.
  • Last instalment month.
  • Notes: interest rate, charges, who to call.

What does a filled-in sheet look like?

Here is a made-up shop with four debts. The figures are invented.

SourcePurposeAmount takenMonthly instalmentDue dateBalance left
Bank term loanFreezer and racks₹4,00,000₹9,8005th₹2,94,000
Supplier creditFestival stock₹60,000₹30,000 for 2 months20th₹60,000
Family moneyShop deposit₹1,00,000₹5,0001st₹70,000
Monthly chitWorking cash₹1,20,000 over 12 months₹10,00010th₹70,000 (7 left)

The monthly total of instalments is 9,800 + 30,000 + 5,000 + 10,000 = ₹54,800. The supplier debt clears in two months, so the total drops after that, and the sheet should show it.

How do you read the total against your sales?

Add a second small table: your usual cash in by week. Suppose the shop collects roughly ₹30,000, ₹60,000, ₹45,000 and ₹35,000 in weeks one to four. Place the due dates by week.

  • Week 1 (1st to 7th): family ₹5,000 and bank ₹9,800 = ₹14,800 against ₹30,000 collected.
  • Week 2 (8th to 14th): chit ₹10,000 against ₹60,000 collected.
  • Week 3 (15th to 21st): supplier ₹30,000 against ₹45,000 collected.
  • Week 4 (22nd to 31st): nothing due against ₹35,000 collected.

The heavy week is week three, when about two thirds of that week's cash goes to one supplier payment. If a supplier payment and the bank EMI ever land in the same week, you would want to know it a month in advance, not on the day.

What should you update, and when?

After each payment, reduce the balance and tick the due date. Once a month, check the sheet against your bank statement. A balance on your sheet that does not match what the lender shows is a signal to ask for a statement of account.

Can an app help?

A sheet is usually enough for a handful of debts. If you want repayments to sit alongside everything else you spend, SpendixAI lets you import bank and card statements and categorise the rows, so loan debits show up in reports. It does not replace the lender's own balance, which you should keep checking.

Two extra columns earn their place. The first is a one-line reason for each debt, because a loan taken for a freezer should be judged differently from a loan taken to cover wages. The second is a note on who to contact and how, so that on a hard week you can pick up the phone to the right person instead of searching through old messages.

Sort the sheet by due date once a month. When the list reads in calendar order, you can see which weeks carry two or three payments, and plan to move cash or ask for a different date before you are stuck.

What do you do once the sheet exists?

  1. Mark every due date on a wall or phone calendar.
  2. Flag any week where instalments exceed half of normal cash.
  3. Decide which debt to clear first by looking at cost and the pressure it puts on you.
  4. Review the sheet on the first of every month.
SPENDIXAI JOURNAL

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

Explore your reports