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 Quenter Akoth O Monthly 01 Jan 2026 01 Jan 2026 0 0 0 0  
* Denotes Required Field
End Date :
New Rent Amount :
* Denotes Required Field
Tenant :
Breakage :
Cost :
Remarks :
1 _BSHOP3_KP244.docx Initial agreement for House allocation Agreement Initial Agreement2024-05-11 Del
2 _BSHOP3_KP244.docx Initial agreement for House allocation Agreement Initial Agreement2024-05-11 Del
3 _BSHOP3_AA0568.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 BSHOP3 R/OFBSHOP3 R/OFBSHOP3 Rent R/OFBSHOP3
2 BSHOP3 W/OFBSHOP3 W/OFBSHOP3 Water W/OFBSHOP3
# Unit Month Year Water Water Water Electricity
1 BSHOP3 February 2024 0.00 0.00 16.00 0.00
2 BSHOP3 March 2024 0.00 0.00 17.21 0.00
3 BSHOP3 April 2024 0.00 0.00 0.00 0.00
4 BSHOP3 May 2024 0.00 0.00 0.00 0.00
5 BSHOP3 June 2024 0.00 0.00 0.00 0.00
6 BSHOP3 January 2024 0.00 0.00 0.00 0.00
7 BSHOP3 July 2024 0.00 0.00 0.00 0.00
8 BSHOP3 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='301' 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='301' 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='301' 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='301' and em_returns.type='debit'
# Date Doc No. Reference Details Transaction Consumption Billing Payment Balance