KENYA · GUIDE 0584 · EDITION 4.7
Rental record system setup in Kenya: Pricing, Costing and Cash Flow Example
Editorial update: 28 October 2026 · Business planning reference · Review scope
Use one accepted sale unit throughout
Work through a fictional KSh 7,500.00 invoice against KSh 4,950.00 of selected cost lines; distinguish the invoice from collected cash.
This is a planning reference for rental record system setup. The order below is an invented teaching case. It is not a completed customer job, an operating approval or a prediction of demand or earnings.
The example offer and its boundary
Fictional rental-record setup RENT-84 creates a spreadsheet for six units with client-supplied opening balances, monthly charges and payment allocations. Example fixture: unitU03 has two approved 10,000 charges and 15,000 allocated payments, leaving an operational balance 5,000 before any adjustments. This arithmetic is fictional and is not a legal finding that a tenant owes a debt. Output is unit register, charge/payment tables, balance view and owner test sheet. Lease drafting, lawful-rent determination, penalties, tax filing, collections and tenant screening are excluded.
Charging basis to confirm: system setup. The rates and quantities below are teaching assumptions. Even a previously recorded listing is not adopted here as a current quotation or an earnings forecast.
Itemised arithmetic
| Selected input/activity | Quantity | Assumed unit rate | Selected cost |
|---|---|---|---|
| Process/data mapping hours | 2 | KSh 500.00 | KSh 1,000.00 |
| Tables/formulas hours | 5 | KSh 500.00 | KSh 2,500.00 |
| Six-fixture checks hours | 2 | KSh 500.00 | KSh 1,000.00 |
| Owner training hours | 1 | KSh 450.00 | KSh 450.00 |
| Calculation | Teaching result |
|---|---|
| Selected cost total | KSh 4,950.00 |
| Priced/accepted output | 1 example units |
| Assumed selling price | KSh 7,500.00 |
| Assumed invoice | KSh 7,500.00 |
| Difference before excluded costs and tax | KSh 2,550.00 |
Illustrative cost is 1,000+2,500+1,000+450=4,950. An assumed 7,500 setup fee yields 2,550 pre-tax planning surplus. Accounting reconciliation, tenant communications, legal review, data entry beyond agreed sample, subscriptions and tax are excluded. The 10,000/15,000 fixture amounts are model tests, not real rent recommendations. Opening balances and legal treatment need authorised client/adviser approval before operational use.
Check cash timing and a weaker outcome
TRAINING-0584: a fictional order for the scoped offer in section 01, using 1 priced units at KSh 7,500.00 each. Buyer group: Small landlords and property managers. No buyer was contacted and no order was completed.
Teaching invoice = 1 x KSh 7,500.00 = KSh 7,500.00. The selected input lines in section 06 total KSh 4,950.00; their difference from this assumed invoice is KSh 2,550.00 before excluded costs and tax.
For cash-timing practice only, suppose a buyer pays a 30% advance of KSh 2,250.00. The invoice balance is KSh 5,250.00. If the selected input bill is paid before the balance arrives, additional cash of KSh 2,700.00 is needed after applying the advance. The advance is counted once, not again at final collection.
On full collection, total receipts are KSh 7,500.00. Cash against the selected example bill is KSh 2,550.00 before other payments. If a hypothetical 10% increase in the largest selected line (Tables/formulas hours) adds KSh 250.00, the unchanged invoice leaves KSh 2,300.00 against that revised bill.
If the customer instead leaves 10% of the invoice unpaid, KSh 750.00 is a receivable. Cash collected is KSh 6,750.00 and collected cash less the selected bill is KSh 1,800.00. This differs from invoice margin; do not spend the unpaid amount as though it is already cash.
The scenario is complete only as a teaching record of the stated lines. Add actual excluded startup and operating costs using file 12, and replace every assumed rate before relying on a quote. Use measured accepted output for the actual invoice; unaccepted output is not automatically chargeable.
For an actual quote, add all relevant excluded costs, use measured accepted output, and compare amounts from the same period. An unpaid invoice balance is not available cash. A deposit held for an uncompleted obligation is not automatically earned income.
References and their limits
Import data from data sources (Power Query)
Import preview and data-source workflow; version-specific menus may differ. Reference check recorded 2026-10-26.
Keeping leading zeros and large numbers — Microsoft
Import identifier columns as text to preserve zeros and precision. Reference check recorded 2026-10-26.
Rights Of A Data Subject
Kenyan privacy principles and data minimisation; not a complete compliance assessment. Reference check recorded 2026-10-26.
Recorded references support only the scope stated beside them. They do not prove current supplier stock, a local quotation, actual buyer demand, operator competence or the feasibility of this particular business. Later editorial changes do not refresh earlier source-check dates.
Prepared by Business Starter Guides using AI-assisted drafting and desk editorial checks. Independent operator trials and specialist certification are not claimed. See the editorial method for the review scope.
Editorial method and evidence limits