Travel and vehicles

Selling a vehicle on instalments: track the money coming in

Selling a bike or car in parts? Use this simple receivable sheet to track the agreed price, each date, money received and balance, plus delay notes.

Editorial illustration for Selling a vehicle on instalments: track the money coming in

If a buyer is paying you for a vehicle in parts, keep a small receivable sheet: the agreed price, every promised date and amount, what actually arrived and when, and the balance still due. Update it the day money lands, and write a one-line note whenever a date slips. That single page settles most arguments later about who owed what.

What should the vehicle sale record contain?

Start with a header block, then a row per instalment. The header holds facts that never change; the rows hold facts that move.

  • Vehicle details: make, model, registration number, and the date you agreed the sale.
  • Buyer details: name, phone number, and how you will recognise their payments (UPI name, account name on the NEFT credit).
  • Agreed price: one figure, in rupees, that both of you have confirmed in writing, even if only a message exchange.
  • Advance received, with date and mode (cash, UPI, NEFT or cheque).
  • Handover status: whether the vehicle and its documents have changed hands yet, and on what date.

Keep the written confirmation of the price and schedule with the sheet. A screenshot of the chat where the buyer agrees to the dates is better than memory.

How does the receivable tracker look in a sheet?

Here is a hypothetical set-up. Say you sell a scooter for ₹62,000, with ₹20,000 as advance and three monthly instalments of ₹14,000 from the buyer.

InstalmentDue dateAmount dueDate receivedAmount receivedBalance after
Advance5 Jan₹20,0005 Jan₹20,000₹42,000
15 Feb₹14,0005 Feb₹14,000₹28,000
25 Mar₹14,00012 Mar₹10,000₹18,000
35 Apr₹14,000pending₹0₹18,000

Check the arithmetic: 20,000 plus 14,000 plus 14,000 plus 14,000 is 62,000, which matches the agreed price. After the first three receipts of 20,000, 14,000 and 10,000 the buyer has paid 44,000, so the balance is 62,000 minus 44,000, which is 18,000.

In Excel or Google Sheets, with the agreed price in B1, amounts received in column E from row 4 down, and the running balance in column F, the formula for F4 is =$B$1-SUM($E$4:E4). Copy it down and it recalculates after each receipt. A cell such as =IF(AND(D4="",C4<TODAY()),"OVERDUE","") placed in column G will flag a row whose due date has passed with nothing received.

What do I write down when an instalment is delayed?

Delays are normal, but unrecorded delays turn into disputes. Add a notes column and log, in plain words, each contact: the date you asked, what the buyer said, and the new date promised. Part-payments get their own line rather than being merged, as in the 12 March row above, so the sheet shows that ₹4,000 of that instalment is still open.

  • Date you reminded the buyer and how (call, message).
  • The reason given, in the buyer's words, kept short.
  • The new promised date, and whether the buyer agreed in writing.
  • Any amount received that does not match the schedule, with its mode and date.

Can I hand over the papers before the last instalment?

That is your decision and the sheet cannot make it for you. It can, however, show you the facts: how much is outstanding, how often dates have slipped, and what the buyer has said. Transfer of ownership and the related forms are governed by transport-office rules that change, so confirm the current process with the regional transport office or a lawyer before you hand over anything that cannot be taken back. Note the date on which each document or key changes hands in the header block.

Where does SpendixAI fit?

The receivable sheet is about money you are owed, so a spreadsheet is the right tool for it. SpendixAI helps on the other side of the sale: the transfer fee, the cost of a pre-sale service, or the newspaper listing you paid for. You can enter those by hand and attach the receipts to the transactions, so the net result of the sale is easy to work out afterwards.

Closing checklist

  1. Get the price and instalment dates confirmed in writing.
  2. Record the advance with date and mode.
  3. Update the sheet on the day each payment lands.
  4. Log every delay with the new promised date.
  5. Note when documents and keys are handed over.
  6. Keep the sheet and the chat screenshots until the balance reads zero and the transfer is complete.
SPENDIXAI JOURNAL

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

Explore your reports