Off-plan instalment payment tracking means keeping, for every buyer, a schedule of what they agreed to pay and when, a record of what they have paid, and a list of what is late. For each instalment you need a due date, an amount, a state and a person chasing it.
Key takeaways
- Track instalments per purchase, not per month. A buyer's schedule is the record; the month's collection is only the total.
- Every instalment needs four things: a due date, an amount, a state (scheduled, due, overdue, paid) and the person chasing it.
- Let the state follow the dates and the receipts. If somebody types "paid", your sheet and your bank will disagree.
- Record how each payment arrived and keep the reference. Cash has legal limits in Nigeria, and records must be kept.
- Chase on a routine, with a log. "I called him" is not a record; "he promised ₦1,400,000 by Friday" is.
What does an off-plan payment plan look like in naira?
Picture Funmi, who runs client accounts for a developer in Ibadan. A buyer, Mr Adeniyi, takes a 3-bed unit priced at ₦24,000,000 on this plan: 30% deposit, then twelve equal monthly payments.
| Item | Amount | Due |
|---|---|---|
| Price | ₦24,000,000 | |
| Deposit (30%) | ₦7,200,000 | On signing, 3 March |
| Balance | ₦16,800,000 | |
| Instalment 1 of 12 | ₦1,400,000 | 3 April |
| Instalments 2 to 12 | ₦1,400,000 each | The 3rd of each month |
| Furnishing fee (optional) | Agreed separately | Before furnishing starts |
The figures are invented. What matters is that the plan adds up: ₦7,200,000 plus twelve payments of ₦1,400,000 is ₦24,000,000. A schedule that does not add up to the price is the first thing to check when an old purchase will not reconcile.
Some developers add milestone payments, where a payment is due when the building reaches a stage rather than on a date. Those need a different treatment, because they have no date until the stage is done.
How do you set up a ledger that works?
A sheet will do for a small number of buyers. Use one row per instalment, not one row per buyer, so you can filter by date. This workbook has the columns below, and a schedule that fills itself in from the price, the deposit and the number of instalments.
Download the off-plan instalment ledger (Excel)
| Column | What goes in it |
|---|---|
| Buyer and unit | Mr Adeniyi, Block B, flat 3 |
| Purchase reference | A reference that never changes |
| Instalment | Deposit, 1 of 12, 2 of 12 and so on |
| Due date | The date in the agreement |
| Amount due | In naira |
| Amount paid | What has actually arrived |
| Date paid | The date the money was received |
| Method | Transfer, cash, POS, cheque |
| Bank reference | The transfer reference or teller number |
| State | Scheduled, due, overdue, part paid, paid |
| Days late | Today minus due date, if unpaid |
| Chasing | Who, and what they last said |
Three habits keep it honest:
- One person enters receipts, against the bank statement, at least weekly. Everyone else reads.
- Never overwrite. If a payment was recorded against the wrong buyer, reverse it and record it again, with a reason.
- Reconcile the total. Sum of "amount paid" should equal the credits on the bank statement for the period. If it does not, find the difference now.
What should you record about each payment?
Record more than the amount. A year from now, you may need to show who paid what, when and how.
The Money Laundering (Prevention and Prohibition) Act 2022 is the main source here. Under section 2, nobody may make or accept a cash payment above ₦5,000,000 (an individual) or ₦10,000,000 (a body corporate) except through a financial institution. The Act's list of designated non-financial businesses includes estate developers, and section 8 requires such businesses to keep transaction records for at least five years after the transaction. Section 11 requires a report to the Special Control Unit against Money Laundering (SCUML) of a single transaction above the same thresholds, within seven days. This is general information, not legal advice. Check your own obligations with your lawyer or SCUML.
For your ledger, that means: record the method, the reference and the date for every payment; ask buyers to pay by bank transfer to a named account; and keep the receipts. A buyer who pays ₦9,000,000 in cash across three weeks is a conversation to have with your lawyer, not a ledger entry to tidy up.
How do you chase late instalments?
Late payment is rarely dramatic. It is a buyer who forgot, or had a delay at work, or is quietly in trouble. Chase on a routine so that nobody is surprised.
| Days late | Who | What |
|---|---|---|
| Due date | Client accounts | Send a friendly reminder with the amount and account details |
| 1 to 7 | The officer who sold it | Call, ask for a date, log the promise |
| 8 to 30 | Head of sales | Call and visit if needed, agree a revised date in writing |
| 31 to 60 | Managing director | Meeting, with the agreement in hand |
| Over 60 | Lawyer | Review the agreement and the notice period |
The day counts are an example. Set yours from your own contract. For wording, see our payment reminder message to a client and what to do when customers are not paying. A reminder you can copy:
Good morning Mr Adeniyi. Your instalment of ₦1,400,000 on Block B, flat 3, was due on 3 April. Please confirm when you will make the transfer. The account details are on your payment schedule. Thank you.
Log every call. Write the promise down with a date and an amount. Next week, you can see whether it was kept.



