Units
OF Osere Flats
* Denotes Required Field
Unit No :
 *
Unit Code :
 *
Property :
 *
Landlord :
Rent :
Service Charge :
Size :
Rooms :
Floor :
Elec A/C No :
Water A/C No :
Security Rent Deposit :
 (Ksh)
Water Deposit :
 (Ksh)
Electricity Deposit :
 (Ksh)
Gas Deposit :
 (Ksh)
Service Fee Deposit :
 (Ksh)
VATable :
Unit Status :
 *
Rental Status :
 *
Remarks :
 
 
Occupier:
Tenant :
 
Date Occupied : * Lease Starts :
Vacated/Shifted On : House :
Generate Agreement    
PAID DEPOSITS
# Deposit Name Amount Date Paid Remarks With Landlord/Office
UNIT UTILITIES
# Utility Exempt Amount
1 Water
2 Water
3 Water
4 Electricity
UNIT SECURITY DEPOSITS
# Utility Exempt Amount
UNIT OTHER FEES
# Utility Exempt Amount
# Tenant Rental Type Date Occupied Vacated On Lease Starts Renew Every (Months) Lease Ends Increase Type Increase By Increase Every (Months) Rent Due Date (Every Month/quarter)    
1 Allan Lerina N/a 01 Mar 2024 10 Apr 2024 01 Mar 2024 0 0 0 0 Refund  
2 Allan Lerina N/a Monthly 01 Mar 2024 01 Mar 2024 0 0 0 0  
* Denotes Required Field
End Date :
New Rent Amount :
* Denotes Required Field
Tenant :
Breakage :
Cost :
Remarks :
1 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-05-11 Del
2 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-05-11 Del
3 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-06-20 Del
4 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-08-22 Del
5 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-09 Del
6 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-12 Del
7 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-17 Del
8 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-19 Del
9 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-05-01 Del
10 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-08-31 Del
11 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-09-16 Del
12 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-11-07 Del
13 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-11-10 Del
14 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-05 Del
15 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-18 Del
16 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-19 Del
17 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-21 Del
18 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-25 Del
19 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2026-01-10 Del
20 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-05-11 Del
21 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-05-11 Del
22 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-06-20 Del
23 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2024-08-22 Del
24 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-09 Del
25 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-12 Del
26 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-17 Del
27 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-04-19 Del
28 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-05-01 Del
29 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-08-31 Del
30 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-09-16 Del
31 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-11-07 Del
32 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-11-10 Del
33 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-05 Del
34 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-18 Del
35 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-19 Del
36 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-21 Del
37 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2025-12-25 Del
38 _AB203_AA0334.docx Initial agreement for House allocation Agreement Initial Agreement2026-01-10 Del
Type : Periodic Final
Inspected On :
Inspected By :
Remarks :
#  
1 Floor Finishes
2 Walls & Ceilings
3 Doors
4 Electrical Fittings
5 Plumbing Fittings
6 Sanitary Fittings
7 Cupboards/shelves
8 Windows
9 Keys Issued
10 Closet
# Type Inspected On Inspected By Remarks
1 03 Apr 2017 The following issues were observed : loose lockers quotation shs. 1000
2 Final 03 Apr 2017 ok .a tenant has been assigned
3 Final 03 Apr 2017 ok .a tenant has been assigned
4 Final 03 Apr 2017 the following observations were seen :it is in good condition .
5 Final 01 Apr 2017 The following observations were seen at sirikwa in room 3 painting , and floor filling .
6 Final 01 Apr 2017 The following observations were seen at sirikwa in room 3 painting , and floor filling and window replacement.
# UNIT METER CODE UTILITY Remarks
1 AB203 R/OFAB203 R/OFAB203 Rent R/OFAB203
2 AB203 W/OFAB203 W/OFAB203 Water W/OFAB203
# Unit Month Year Water Water Water Electricity
1 AB203 March 2024 0.00 0.00 0.00 0.00
2 AB203 April 2024 0.00 0.00 0.00 0.00
3 AB203 May 2024 0.00 0.00 0.00 0.00
4 AB203 June 2024 0.00 0.00 0.00 0.00
5 AB203 July 2024 0.00 0.00 0.00 0.00
6 AB203 August 2024 0.00 0.00 0.00 0.00
7 AB203 September 2024 0.00 0.00 0.00 0.00
8 AB203 October 2024 0.00 0.00 0.00 0.00
9 AB203 November 2024 0.00 0.00 0.00 0.00
10 AB203 December 2024 0.00 0.00 0.00 0.00
11 AB203 January 2025 0.00 0.00 0.00 0.00
12 AB203 February 2025 0.00 0.00 0.00 0.00
13 AB203 March 2025 0.00 0.00 0.00 0.00
14 AB203 April 2025 0.00 0.00 0.00 0.00
15 AB203 May 2025 0.00 0.00 0.00 0.00
16 AB203 June 2025 0.00 0.00 0.00 0.00
17 AB203 July 2025 0.00 0.00 0.00 0.00
18 AB203 August 2025 0.00 0.00 0.00 0.00
19 AB203 September 2025 0.00 0.00 0.00 0.00
20 AB203 October 2025 0.00 0.00 0.00 0.00
21 AB203 November 2025 0.00 0.00 0.00 0.00
22 AB203 December 2025 0.00 0.00 0.00 0.00
23 AB203 January 2026 0.00 0.00 0.00 0.00
STATEMENT -
From: To:
create view st_view as select concat('INV','',em_payables.documentno) documentno, em_payables.invoicedon as transactdate, concat(em_paymentterms.name,' - ',monthname(STR_TO_DATE(month, '%m'))) name, em_payables.quantity, concat(em_paymentterms.name,' - ',monthname(STR_TO_DATE(month, '%m'))) remarks, '' memo, em_payables.total as debit, 0 as credit, '' as transactionno, 'payables' as type from em_payables left join em_paymentterms on em_paymentterms.id=em_payables.paymenttermid where houseid='179' and em_payables.status=0 union select em_tenantpayments.documentno, em_tenantpayments.paidon as transactdate, em_paymentterms.name, '' quantity, em_tenantpayments.remarks,em_tenantpayments.memo, 0 as debit, em_tenantpayments.amount as credit, concat(em_tenantpayments.transactionno,' ',em_tenantpayments.chequeno) as transactionno, 'tenantpayment' as type from em_tenantpayments left join em_paymentterms on em_tenantpayments.paymenttermid=em_paymentterms.id where houseid='179' union select em_returns.documentno, em_returns.invoicedon as transactdate, em_paymentterms.name, '' quantity, em_returns.remarks,'' memo, 0 as debit, em_returns.amount as credit, '' as transactionno, 'creditnote' as type from em_returns left join em_paymentterms on em_returns.paymenttermid=em_paymentterms.id where houseid='179' and em_returns.type='credit' union select em_returns.documentno, em_returns.invoicedon as transactdate, em_paymentterms.name, '' quantity, em_returns.remarks, '' memo,em_returns.amount as debit, 0 as credit, '' as transactionno,'debitnote' as type from em_returns left join em_paymentterms on em_returns.paymenttermid=em_paymentterms.id where houseid='179' and em_returns.type='debit'
# Date Doc No. Reference Details Transaction Consumption Billing Payment Balance