Jerry Augustine

NOTE UTAKO APARTMENTS JABI Try not to alter cells that contain a formula. JUNE Accounts,2025 Starting balance: ₦2,284,000.00 START BALANCE END BALANCE ₦0.00 ₦2,284,000.00 Expenses Income Planned ₦950,000.00 Planned ₦4,500,000.00 Actual ₦716,000.00 Actual ₦3,000,000.00 Income Expenses Totals Water Board Bill Planned Actual ₦950,000.00 ₦716,000.00 ₦0.00 ₦0.00 Diff. ₦234,000.00 Totals Planned Actual Diff. ₦4,500,000.00 ₦3,000,000.00 ₦1,500,000.00 ₦0.00 Agent Booking ₦3,000,000.00 ₦0.00 Security Salary ₦40,000.00 ₦40,000.00 ₦0.00 Agent Booking ₦0.00 ₦0.00 House Keepers Salary ₦60,000.00 ₦60,000.00 ₦0.00 Agent Booking ₦0.00 ₦0.00 Facility Mgr. Salary ₦80,000.00 ₦0.00 ₦0.00 Agent Booking ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 Toiletries ₦80,000.00 ₦50,000.00 ₦20,000.00 Agent Booking Plumbing Maintenance ₦40,000.00 ₦6,000.00 ₦34,000.00 Agent Booking Electrical Maintenance ₦50,000.00 ₦0.00 ₦50,000.00 Agent Booking Internet Data & Airtime ₦0.00 ₦0.00 ₦0.00 ₦25,000.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦75,000.00 ₦8,000.00 ₦67,000.00 ₦360,000.00 ₦147,000.00 ₦213,000.00 ₦30,000.00 ₦20,000.00 ₦10,000.00 ₦0.00 ₦0.00 ₦0.00 ₦100,000.00 ₦70,000.00 ₦30,000.00 ₦50,000.00 ₦15,000.00 ₦35,000.00 ₦0.00 ₦300,000.00 ₦0.00 DSTV Subscription Wares & Furniture Replmt. Generator Maintenance Diesel Purchase (300L) Miscellaneous Expenses General Mainten. /Repairs AEDC Main House AEDC Pumbing Machine Agent's Commission 10% TOTAL BUDGET ₦950,000.00 ₦716,000.00 ₦0.00 ₦0.00 Change or add categories by updating the Expenses and Income tables in the Summary sheet. Expenses Income Date Amount Description Category Date 01/06/2025 Amount Description Category ₦5,000.00 AEDC Pumping machine AEDC Recharge 15/06/2025 ₦500,000.00 Booking 01/06/2025 ₦10,000.00 AEDC Main Building AEDC Recharge 23/06/2025 ₦2,350,000.0 0 Booking 23/06/2025 ₦50,000.00 Toiletries Stationeries 23/06/2025 Booking 25/06/2025 ₦8,000.00 Generator servicing Electrical Maintenance 07/06/2025 ₦56,000.00 Diesel 50Ltrs Electrical expenses 17/06/2025 ₦35,000.00 Diesel 25ltrs Electrical expenses ₦20,000.00 Buckets and big rubber Miscellaneous 23/06/2025 24/06/2025 ₦20,000.00 26/06/2025 ₦56,000.00 Diesel 50Ltrs Electrical Maintenance ₦10,000.00 AEDC Pumping machine AEDC Recharge 24/06/2025 AEDC Main Building AEDC Recharge AEDC Main Building AEDC Recharge 00/06/2025 ₦10,000.00 AEDC Main Building AEDC Recharge AEDC Main Building AEDC Recharge 00/06/2025 ₦10,000.00 AEDC Main Building AEDC Recharge AEDC Main Building AEDC Recharge 00/04/2025 ₦10,000.00 AEDC Main Building AEDC Recharge AEDC Main Building AEDC Recharge 00/06/2025 ₦10,000.00 AEDC Main Building AEDC Recharge AEDC Main Building AEDC Recharge 30/06/2025 ₦40,000.00 Security salary House Security Salary 30/06/2025 ₦60,000.00 House keeper salary House keeper Salary 30/06/2025 ₦300,000.00 Agents Commission Agent's Commission ₦150,000.00