Jerry Augustine

NOTE LUX 2, APARTMENTS JAHI Try not to alter cells that contain a formula. JUNE Accounts,2025 Starting balance: ₦187,600.00 START BALANCE END BALANCE ₦0.00 ₦187,600.00 Expenses Income Planned ₦400,000.00 Planned ₦2,500,000.00 Actual ₦342,400.00 Actual ₦530,000.00 Income Expenses Planned Actual ₦400,000.00 ₦342,400.00 Water Board Bill ₦0.00 ₦0.00 ₦0.00 Agent Booking ₦530,000.00 ₦0.00 Security Salary ₦0.00 ₦0.00 ₦0.00 Agent Booking ₦0.00 ₦0.00 Totals House Keepers Salary Facility Mgr. Salary Toiletries Diff. ₦57,600.00 Totals ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 Agent Booking ₦0.00 ₦0.00 ₦20,000.00 ₦56,500.00 ₦-36,500.00 Agent Booking ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦20,000.00 ₦0.00 ₦10,000.00 Electrical Maintenance ₦20,000.00 ₦95,900.00 ₦-75,900.00 Agent Booking Internet Data & Airtime ₦0.00 ₦0.00 ₦0.00 ₦25,000.00 ₦25,000.00 ₦0.00 ₦0.00 ₦0.00 ₦0.00 ₦20,000.00 ₦0.00 ₦-36,000.00 ₦100,000.00 ₦7,500.00 ₦92,500.00 ₦20,000.00 ₦137,500.00 ₦-117,500.00 ₦0.00 ₦0.00 ₦0.00 ₦100,000.00 ₦20,000.00 ₦80,000.00 Transpotation ₦0.00 ₦0.00 ₦0.00 Agent's Commission 10% ₦0.00 ₦0.00 ₦0.00 Generator Maintenance FUEL Purchase (100L) Miscellaneous Expenses General Mainten. /Repairs AEDC LUX 1, House TOTAL BUDGET Diff. ₦1,970,000.00 ₦50,000.00 Plumbing Maintenance Wares & Furniture Replmt. Actual ₦530,000.00 Agent Booking Agent Booking DSTV Subscription Planned ₦2,500,000.00 ₦400,000.00 ₦342,400.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 24/05/2025 ₦15,000.00 Elect cable 15 yrds 10mm Category Date Amount Description Category Electrical Maintenance 22/06/2025 ₦200,000.00 Booking 26/05/2025 ₦9,000.00 Elect. workmanship Electrical Maintenance 25/06/2025 ₦30,000.00 Booking 29/05/2025 ₦5,500.00 Meter reconnection Electrical Maintenance 27/06/2025 ₦100,000.00 Booking 16/06/2025 ₦22,000.00 Electri. materials Electrical Maintenance 28/06/2025 ₦100,000.00 Booking 17/06/2025 ₦36,000.00 DSTV Installation Electrical Maintenance 29/06/2025 ₦100,000.00 Booking 17/06/2025 ₦25,000.00 DSTV Recharge DSTV Subs ₦28,000.00 AC Installation materials Electrical Maintenance 17/06/2025 17/06/2025 ₦2,500.00 17/06/2025 ₦23,900.00 Elect. workmanship Electrical Maintenance ₦7,000.00 Electrical Maintenance 16/06/2025 Elect. Cable HDMI 10mm Electrical Maintenance AEDC Recharge 18/06/2025 ₦19,000.00 20/06/2025 ₦35,000.00 AC Installation workmanship Electrical Maintenance 21/06/2025 ₦12,500.00 Air fresher & Insect. Toiletries 22/06/2025 ₦10,000.00 Cleaning Agents AEDC Lux 2 23/06/2025 ₦7,500.00 23/06/2025 ₦10,000.00 Internet Subs Gas head AEDC Recharge Toiletries AEDC Recharge AEDC Recharge ₦7,500.00 ₦14,000.00 Cooking Gas refil Miscellaneous ₦25,000.00 Toiletries supply Toiletries 27/06/2025 ₦10,000.00 AEDC Lux 2 AEDC Recharge R&M AEDC Recharge AEDC Recharge NOTE! Miscellaneous 30/06/2025 Is made up of: DSTV installation, Ac installation, internet, cooking gas, Gas head, & HDMI Cable ₦0.00 Agents Commission AEDC Recharge Miscellaneous 24/06/2025 24/06/2025 AEDC Recharge Miscellaneous 23/06/2025 Gas head Electrical Maintenance Agent's Commission AEDC Recharge AEDC Recharge