Property sale payment plans and accounting

How a property sale is invoiced, paid and recorded from reservation fee to handover, with its ledger accounts, balanced worked examples and cancellation refunds.

Property Sales → Deals → a deal → Money, and Payments Available

A property sale uses the same invoices, receipts and general ledger as the rest of Nyumba Zetu. Each deal has one sale contract from the moment it is reserved. Every bill and every receipt for the sale belongs to that contract, so the sale's account is always one place.

The payment plan

The plan is set when the offer is made. See Reservations, offers and the deal lifecycle.

LineKindTypically
Reservation feeFeePaid at reservation.
DepositDepositDue soon after the offer. Fee plus deposit is often 10% of the price.
InstalmentsInstalmentDated payments while the home is built.
BalanceBalanceThe last payment, often from a lender.
  • Fee plus instalments equals the agreed price, to the cent.
  • Buyer or lender. Each line names who pays. A lender line is billed to the lender, on the same contract.
  • Versions. A plan is never edited. Change plan writes a new version; lines already invoiced carry over as they were.
Design board for journey 4: a reminder arrives, the buyer opens the buyer portal, chooses how to pay, gets a receipt applied at once, and finance sees the payment applied on the deal. Under each screen it says who acts, what they do and what the system does.
A buyer pays an instalment, as designed: from the reminder to finance seeing it applied. Open it full size to read each step.

When bills are raised

BillRaisedDue
Reservation feeAt once, when the unit is reservedThe same day
Each instalmentBy the daily invoicing job, on its due date, or the agreed number of days before itIts due date
ForfeitWhen a sale is cancelledThe day of cancellation

Sale bills are raised only by Property Sales. They cannot be made by hand from an invoice screen, and no instalment is invoiced twice. Bills are numbered INV- like any other invoice. The daily job does not send the buyer a message when it raises an instalment.

How a buyer pays

Every sale has its own payment reference: P followed by the contract number, for example P900002150. Give it to the buyer, and to any lender, to use as the account number.

RouteHow it reaches the saleStatus
Record payment on the dealStaff record a receipt on the sale contract and apply it to the bills. Needs permission to create payments.Available
M-Pesa paybill or bank feedThe buyer pays with the P reference as the account. With automatic reconciliation on for the branch, the payment is matched to the sale and applied.Available
Buyer portal PayThe buyer asks for an M-Pesa prompt on their phone for a bill.Available

Receipts are numbered RCPT-. However the money arrives, it is recorded the same way:

  1. The receipt puts the cash in the bank and holds it as unapplied.
  2. Applying it pays the sale's bills, oldest first.

Overpayment. If a buyer pays more than is due, the excess stays on the receipt as credit in Unapplied receipts (2240). It is not counted as paid until it is applied to a bill. Finance can also refund it from Payments.

What money moves on a deal

Payments drive the deal forward. Nobody ticks these by hand:

FactTrue whenWhat it unlocks
Payment receivedAny money is applied to the saleThe deal can no longer lapse or be released. Ending it needs Cancel sale.
Deposit paidThe fee and every deposit line are invoiced and paid in fullWith a signed agreement, the deal becomes Sold. Commission parts tied to it are earned.
Paid in fullPaid reaches the agreed priceHand over keys becomes possible.

If a receipt is reversed or a bill voided, the facts are worked out again, and one that no longer holds is cleared. The deal's history records it.

The accounts

AccountNameIn a sale
BankYour branch bank or paybill accountCash in from buyers and lenders; cash out for refunds and agent payouts.
1200Accounts receivableWhat the buyer or lender owes, bill by bill.
2240Unapplied receiptsCash received but not yet applied. Overpayments, and money held after a cancellation, sit here.
2250Deferred revenueThe sale price invoiced so far, held until handover.
4600Property sales revenueThe sale, recognised at handover.
4330Other incomeA forfeit kept when a sale is cancelled.
5265Sales commission expenseAgent commission, when approved.
2110Accounts payableCommission owed to agents until it is paid out.
BankM-Pesa or bank account2240Unapplied receipts1200Accounts receivable2250Deferred revenue4600Property sales revenue1. Invoice: Dr 1200 / Cr 22502. Receipt: Dr Bank / Cr 22403. Applied: Dr 2240 / Cr 12004. Handover: Dr 2250 / Cr 4600Steps 1–3 repeat for the fee, the deposit and every instalment; step 4 happens once.
Where the money sits. Each arrow runs from the account credited to the account debited.

Journals by event

EventDebitCreditDated
A sale bill is raised (fee, deposit, instalment, lender line)1200 Accounts receivable2250 Deferred revenueThe bill's date
A receipt comes inBank2240 Unapplied receiptsThe payment date
The receipt is applied to a bill2240 Unapplied receipts1200 Accounts receivableWhen applied
Handover: revenue is recognised2250 Deferred revenue4600 Property sales revenueThe completion day
A commission part is approved5265 Sales commission expense2110 Accounts payableWhen approved
The agent is paid in a payout run2110 Accounts payableBankWhen paid
A commission is reversed or clawed back2110 Accounts payable5265 Sales commission expenseWhen the deal closes
A forfeit is invoiced on cancellation1200 Accounts receivable4330 Other incomeThe cancellation day
A refund is paid2240 Unapplied receiptsBankThe refund date

Revenue is recognised at handover, and handover needs the sale to be paid in full. Deferred revenue holds what has been invoiced, not cash, so releasing it any earlier would count money still owed as revenue. At handover the whole invoiced amount moves to 4600 in one journal, once. If the completion day's period is closed, the journal is dated today. If the release fails at that moment, an hourly check posts it.

Worked example: a sale from reservation to handover

A unit at Kilele Heights sells for KES 10,000,000:

  • reservation fee 100,000 and deposit 900,000, together 10%;
  • three buyer instalments of 1,000,000;
  • a lender line of 6,000,000 for the balance;
  • agent commission of 2% (200,000), on the default scheme: half when signed and the deposit is paid, half when 50% of the price is paid.

The table shows the running balance of each account after each step. Debits are positive, credits negative, and every row balances.

#EventJournalBank120022402250460052652110
1Reserve; fee invoicedDr 1200 / Cr 2250 100,0000100,0000−100,000000
2Buyer pays the fee to the P referenceDr Bank / Cr 2240 100,000, then Dr 2240 / Cr 1200 100,000100,00000−100,000000
3Deposit invoiced by the daily jobDr 1200 / Cr 2250 900,000100,000900,0000−1,000,000000
4Buyer pays the depositDr Bank / Cr 2240, then Dr 2240 / Cr 1200, 900,0001,000,00000−1,000,000000
5Agreement signed → Sold; commission part 1 approvedDr 5265 / Cr 2110 100,0001,000,00000−1,000,0000100,000−100,000
6Three instalments invoiced and paidDr 1200 / Cr 2250, Dr Bank / Cr 2240, Dr 2240 / Cr 1200, each 3,000,0004,000,00000−4,000,0000100,000−100,000
7Lender line invoiced to the lenderDr 1200 / Cr 2250 6,000,0004,000,0006,000,0000−10,000,0000100,000−100,000
8Lender pays → paid in fullDr Bank / Cr 2240, then Dr 2240 / Cr 1200, 6,000,00010,000,00000−10,000,0000100,000−100,000
9Commission part 2 approvedDr 5265 / Cr 2110 100,00010,000,00000−10,000,0000200,000−200,000
10Agent paid in a payout runDr 2110 / Cr Bank 200,0009,800,00000−10,000,0000200,0000
11Hand over keys: revenue recognisedDr 2250 / Cr 4600 10,000,0009,800,000000−10,000,000200,0000

After step 11 the debits are Bank 9,800,000 and commission 200,000, together 10,000,000; the credit is revenue of 10,000,000. The developer has KES 9.8 million in the bank and a recognised sale of KES 10 million, less 200,000 of commission.

Cancellation: forfeit and refund

A sales manager cancels a sale that has been paid on or signed with Cancel sale and a reason. See when a deal ends early.

The forfeit is what the developer keeps:

forfeit = the smaller of (what the buyer has paid) and (the larger of the forfeit percentage of the price, and the minimum forfeit)

The price is the agreed price, or the list price before an offer. The forfeit percentage and minimum are set per development with Nyumba Zetu during onboarding. With no forfeit rule, the forfeit is zero and everything paid is refunded.

The refund is what the buyer has paid, less the forfeit. Forfeit plus refund always equals what was paid, to the cent.

What happens, in order:

  1. Money is taken back off the bills. Every receipt applied to the sale is un-applied and held.
  2. The bills are voided, paid or not.
  3. A forfeit bill is raised and paid at once from the held receipts. It is income on the day: it does not go through deferred revenue.
  4. The refund stays as credit on the buyer's receipts, in Unapplied receipts (2240).
  5. Finance refunds it from Payments, receipt by receipt. Nothing is refunded automatically.
  6. Commission closes. A commission part approved but not yet paid is reversed. One already paid is clawed back from the agent's next payout run.
Paid by the buyerKES 2,000,000receipts held in 2240Bills voidedreceipts unapplied: Dr 1200 / Cr 2240invoices reversed: Dr 2250 / Cr 1200Forfeit kept: KES 1,000,000invoice Dr 1200 / Cr 4330 Other incomepaid from held receipts: Dr 2240 / Cr 1200Refund due: KES 1,000,000waits in 2240 Unapplied receiptsfinance refunds: Dr 2240 / Cr BankForfeit = min(paid, max(forfeit % × price, forfeit minimum)). No rule set means no forfeit.
Cancelling a sale paid KES 2,000,000 on a KES 10,000,000 price, with a 10% forfeit rule.

Worked example: cancelling the sale above

The buyer signed and paid the fee, the deposit and the first instalment, 2,000,000 in all. The second instalment of 1,000,000 has been invoiced but not paid. Commission part 1 (100,000) is approved but not yet paid. The development's forfeit rule is 10% of the price, no minimum.

  • Forfeit = the smaller of 2,000,000 and 10% × 10,000,000 = 1,000,000.
  • Refund = 2,000,000 − 1,000,000 = 1,000,000.
#EventJournalBank120022402250433052652110
0Before cancelling—2,000,0001,000,0000−3,000,0000100,000−100,000
1Receipts un-applied from the three paid billsDr 1200 / Cr 2240 2,000,0002,000,0003,000,000−2,000,000−3,000,0000100,000−100,000
2All four bills voidedDr 2250 / Cr 1200 3,000,0002,000,0000−2,000,00000100,000−100,000
3Forfeit invoicedDr 1200 / Cr 4330 1,000,0002,000,0001,000,000−2,000,0000−1,000,000100,000−100,000
4Forfeit paid from the held receiptsDr 2240 / Cr 1200 1,000,0002,000,0000−1,000,0000−1,000,000100,000−100,000
5Unpaid commission reversedDr 2110 / Cr 5265 100,0002,000,0000−1,000,0000−1,000,00000
6Finance refunds the buyerDr 2240 / Cr Bank 1,000,0001,000,000000−1,000,00000

The developer keeps 1,000,000 in the bank, recorded as other income, and the buyer has their 1,000,000 back.

A deal that ends without money on it (released, lapsed or moved) only has its unpaid bills voided: Dr 2250 / Cr 1200 for each.

Statements

A statement shows the buyer's sale contract: every bill, every receipt and the balance.

  • Preview statement on the deal shows the exact PDF the buyer would receive, with Download PDF. It works on ended sales too.
  • Send statement sends it by email, with the PDF attached, or by SMS. The dialog names where it will go. Needs Sell, on your own deal, or Manage. Ended sales have no Send.
  • At most one per sale per day. If today's has already gone, by staff or on the monthly schedule, the dialog says when and the next can go tomorrow.
  • Monthly statements. Tick Send every buyer their statement on the 1st of each month on the development to send every sale still going its statement on the 1st. Ended sales are skipped. A buyer whom staff already sent one that day gets it the next day.
  • In the buyer portal the buyer sees their statement and schedule, and can Download PDF.

Where finance reads a sale

  • The deal's Money section: the plan, every bill with what is paid and owed, the receipts and the facts above.
  • Payments: receipts, allocation and refunds, as for any receipt.
  • Accounting reports: the general ledger and trial balance show 1200, 2240, 2250 and 4600 like any other account.

Sale money is kept apart from owner money: it does not appear on owner statements or in owner payout runs, and agent commission is paid in payout runs of its own. See Agents and commissions.

Frequently asked questions

Which accounts does a property sale post to?
Sale invoices post to Accounts receivable (1200) and Deferred revenue (2250). Receipts post to the bank and Unapplied receipts (2240), and are then applied to the bills. At handover the whole sale moves from 2250 to Property sales revenue (4600). A forfeit goes to Other income (4330), and agent commission to Sales commission expense (5265) and Accounts payable (2110).
Why is the sale not revenue when the buyer pays?
A sale is not complete until the home is handed over. Until then the price invoiced is held in Deferred revenue. Handover needs the sale to be paid in full, and moves the whole amount to Property sales revenue in one journal.
What does "paid" mean on a deal?
Money applied to the sale's bills. A receipt that has come in but has not yet been applied, such as an overpayment held as credit, is not counted as paid.
How does a buyer pay?
To your M-Pesa paybill or bank account with the sale's payment reference, which starts with P, or through a receipt that staff record on the deal. With automatic reconciliation on for the branch, a payment with the reference is matched to the sale's bills, oldest first.
Does Nyumba Zetu refund a cancelled buyer automatically?
No. Cancelling works out what the buyer forfeits and leaves the rest as credit on their receipts. Finance then refunds it from Payments, receipt by receipt.