Apartment Maintenance Accounts 2022

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 32

Dream Homes

Apartment Maintenance Accounts

Month January
Name of the Building Dream Homes
Date Day Expense Description
Janitor/Sweeper
Security Salary
Electricity Bill
Month February
Name of the Building Dream Homes
Date Day Expense Description
Janitor/Sweeper
Security Salary
Electricity Bill

Month March
Name of the Building Dream Homes
Date Day Expense Description
Janitor/Sweeper
Security Salary
Electricity Bill
Month April
Name of the Building Dream Homes
Date Day Expense Description
Janitor/Sweeper
Security Salary
Electricity Bill
Month May
Name of the Building Dream Homes
Date Day Expense Description
Janitor/Sweeper
Security Salary
Electricity Bill
Month June
Name of the Building Dream Homes
Date Day Expense Description
Janitor/Sweeper
Security Salary
Electricity Bill
Month July
Name of the Building Dream Homes
Date Day Expense Description
5/7/2022 Tuesday Janitor/Sweeper
5/7/2022 Tuesday Security Salary
19/7/2022 Monday Electricity Bill
3/7/2022 Sunday Motor Cage Raw Material
5/7/2022 Tuesday Motor Cage Raw Material
9/7/2022 Saturday Motor Cage Raw Material
9/7/2022 Saturday Motor Cage Raw Material
16/7/2022 Saturday Bleching Powder
16/7/2022 Saturday Wiper
17/7/2022 Sunday Waste Water Motor Fitting Equipment
17/7/2022 Sunday Mop, Broom
17/7/2022 Sunday Sewage Motor and Waste Water Motor Installation
20/7/2022 Monday Mop and Detergent
29/7/2022 Friday Motor Electircal Fitment
Month August
Name of the Building Dream Homes
Date Day Expense Description
5/8/2022 Friday Janitor/Sweeper
5/8/2022 Friday Security Salary
Electricity Bill
1/8/2022 Monday Broom
5/8/2022 Friday Security Whistle
7/8/2022 Sunday Fineal Floor Cleaner
14/8/2022 Sunday Indian Flag

Month September
Name of the Building Dream Homes
Date Day Expense Description
4/9/2022 Sunday Janitor/Sweeper
4/9/2022 Sunday Security Salary
10/9/2022 Sunday Electricity Bill
18/9/2022 Sunday Detergent
18/9/2022 Sunday Softner Salt
18/9/2022 Sunday Broom
18/9/2022 Sunday Security & Family Lunch for Cleaning Basesment
24/9/2022 Saturday Electrician for CCTV Instalation
24/9/2022 Saturday Detergent
24/9/2022 Saturday Salt for Softner
24/9/2022 Saturday Wifi Instalation for CCTV
24/9/2022 Saturday Plumber
24/9/2022 Saturday CCTV Instalation

Month October
Name of the Building Dream Homes
Date Day Expense Description
1/10/2022 Saturday Janitor/Sweeper
1/10/2022 Saturday Security Salary
Electricity Bill
1/10/2022 Saturday Dushera Festival to Janitor
15/10/2022 Saturday Broom
15/10/2022 Saturday Diwali Light Fitment
20/10/2022 Thursday Diwali Light Fitment and connecters
20/10/2022 Thursday Diwali Lights
23/10/2022 Sunday Diwali Sweets for Guard
23/10/2022 Sunday Wiper + 1 kg Nirma
23/10/2022 Sunday Connecter for Basement Lighting
23/10/2022 Sunday Diwali Bonus for Security Gurard
23/10/2022 Sunday Diwali Bonus for Sweeper
30/10/2022 Sunday Softner Recharge

Month November
Name of the Building Dream Homes
Date Day Expense Description
1/11/2022 Thursday Janitor/Sweeper
1/11/2022 Thursday Security Salary
22/11/2022 Monday Electricity Bill
1/11/2022 Thursday Broom 2 piece
1/11/2022 Thursday Tap and Mseal
1/11/2022 Thursday Water Softner Recharge
1/11/2022 Thursday Chand Plumber
6/11/2022 Sunday Autocut Machine
7/11/2022 Monday Electrician Costing for Installation of Autocut and Stairs bulb
9/11/2022 Wednesday Electrican Autocut Machine Extra Wire fitment
9/11/2022 Wednesday Diwali Light Deinstalation
18/11/2022 Friday Autocut Repair
18/11/2022 Friday Water Tank Cap
18/11/2022 Friday Softer Salt
27/11/2022 Sunday Security Table
27/11/2022 Sunday Tasla
Month December
Name of the Building Dream Homes
Date Day Expense Description
1/12/2022 Thursday Janitor/Sweeper
1/12/2022 Thursday Security Salary
Electricity Bill
4/12/2022 Sunday Register and Pen
4/12/2022 Sunday Finial
4/12/2022 Sunday Tree Sheding and Garbage Removol
4/12/2022 Sunday Softner Reacharge
4/12/2022 Sunday Roof Pipe Instalation Material
4/12/2022 Sunday Roof Pipe Instalation Labour
4/12/2022 Sunday M-Seal
13/12/2022 Monday Softner Reacharge
13/12/2022 Monday Broom
13/12/2022 Monday Shaft Clean
17/12/2022 Saturday Finial
24/12/2022 Saturday 2 Times Softner Reacharge
31/12/2022 Saturday Submersible Repair
mes
ce Accounts

Dream Homes Yearly Expense Summary


xpense Description Amount Month
Janitor/Sweeper ₹ 0.00 January
Security Salary February
Electricity Bill March
April
May
June
July
August
September
October
November
December
Total

Balance Remaning

Total ₹0
Dream Homes
xpense Description Amount
Janitor/Sweeper
Security Salary
Electricity Bill

Total ₹0

Dream Homes
xpense Description Amount
Janitor/Sweeper
Security Salary
Electricity Bill
Total ₹0

Dream Homes
xpense Description Amount
Janitor/Sweeper
Security Salary
Electricity Bill
Total ₹0

Dream Homes
xpense Description Amount
Janitor/Sweeper
Security Salary
Electricity Bill
Total ₹0

Dream Homes
xpense Description Amount
Janitor/Sweeper
Security Salary
Electricity Bill
Total ₹0

Dream Homes
xpense Description Amount
Janitor/Sweeper ₹ 1,400.00
Security Salary ₹ 11,500.00
Electricity Bill ₹ 5,307.00
otor Cage Raw Material ₹ 2,500.00
otor Cage Raw Material ₹ 1,000.00
otor Cage Raw Material ₹ 1,000.00
otor Cage Raw Material ₹ 1,100.00
Bleching Powder ₹ 165.00
Wiper ₹ 220.00
Water Motor Fitting Equipment ₹ 343.00
Mop, Broom ₹ 325.00
r and Waste Water Motor Installation ₹ 1,300.00
Mop and Detergent ₹ 105.00
Motor Electircal Fitment ₹ 1,260.00

Total ₹ 27,525
Dream Homes
xpense Description Amount
Janitor/Sweeper ₹ 1,400.00
Security Salary ₹ 11,500.00
Electricity Bill ₹ 8,425.00
Broom ₹ 240.00
Security Whistle ₹ 20.00
Fineal Floor Cleaner ₹ 155.00
Indian Flag ₹ 470.00

Total ₹ 22,210

Dream Homes
xpense Description Amount
Janitor/Sweeper ₹ 1,400.00
Security Salary ₹ 11,500.00
Electricity Bill ₹ 2,662.00
Detergent ₹ 140.00
Softner Salt ₹ 520.00
Broom ₹ 65.00
mily Lunch for Cleaning Basesment ₹ 150.00
rician for CCTV Instalation ₹ 780.00
Detergent ₹ 70.00
Salt for Softner ₹ 1,450.00
Wifi Instalation for CCTV ₹ 2,825.00
Plumber ₹ 100.00
CCTV Instalation ₹ 27,000.00

Total ₹ 48,662

Dream Homes
xpense Description Amount
Janitor/Sweeper ₹ 1,400.00
Security Salary ₹ 11,500.00
Electricity Bill ₹ 6,547.00
shera Festival to Janitor ₹ 400.00
Broom ₹ 500.00
Diwali Light Fitment ₹ 1,950.00
Light Fitment and connecters ₹ 2,100.00
Diwali Lights ₹ 5,250.00
iwali Sweets for Guard ₹ 130.00
Wiper + 1 kg Nirma ₹ 370.00
ecter for Basement Lighting ₹ 95.00
i Bonus for Security Gurard ₹ 1,100.00
wali Bonus for Sweeper ₹ 500.00
Softner Recharge ₹ 150.00

Total ₹ 31,992

Dream Homes
xpense Description Amount
Janitor/Sweeper ₹ 1,400.00
Security Salary ₹ 11,500.00
Electricity Bill ₹ 7,612.00
Broom 2 piece ₹ 240.00
Tap and Mseal ₹ 280.00
Water Softner Recharge ₹ 150.00
Chand Plumber ₹ 200.00
Autocut Machine ₹ 2,500.00
or Installation of Autocut and Stairs bulb ₹ 1,290.00
utocut Machine Extra Wire fitment ₹ 300.00
wali Light Deinstalation ₹ 400.00
Autocut Repair ₹ 200.00
Water Tank Cap ₹ 360.00
Softer Salt ₹ 1,300.00
Security Table ₹ 1,500.00
Tasla ₹ 250.00
Total ₹ 29,482

Dream Homes
xpense Description Amount
Janitor/Sweeper ₹ 1,400.00
Security Salary ₹ 12,500.00
Electricity Bill ₹ 5,062.00
Register and Pen ₹ 50.00
Finial ₹ 170.00
eding and Garbage Removol ₹ 500.00
Softner Reacharge ₹ 150.00
f Pipe Instalation Material ₹ 3,460.00
of Pipe Instalation Labour ₹ 4,360.00
M-Seal ₹ 150.00
Softner Reacharge ₹ 150.00
Broom ₹ 310.00
Shaft Clean ₹ 200.00
Finial ₹ 170.00
Times Softner Reacharge ₹ 300.00
Submersible Repair ₹ 650.00
Total ₹ 29,582
pense Summary
Amount
₹0
₹0
₹0
₹0
₹0
₹0
₹ 27,525
₹ 22,210
₹ 48,662
₹ 31,992
₹ 29,482
₹ 29,582
₹ 189,453

₹ 45,366
Flat-wise Maintenance Collection
Maintenance Amount Per Month 1500 Maintenance Amount Annual
Amount Received
Flat No Flat Holder Name Jan Feb Mar Apr May Jun Jul Aug
GF-1 (GROUND FLOOR) DR. KL CHETIWAL 1500 1500
GF-2 (GROUND FLOOR) MR. UDAIVIR SINGH TOMAR 1500 1500
GF-3 (GROUND FLOOR) MR. NITIN KHANNA 1500 1500
FF-1 (FIRST FLOOR) MR SURENDER SINGH 1500 1500
FF-2 (FIRST FLOOR) MR. ASHISH JAITLEY 1500 1500
FF-3 (FIRST FLOOR) MR. PRADEEP SHARMA 1500 1500
FF-4 (FIRST FLOOR) MS. MEENAKSHI GUPTA 1500 1500
FF-5 (FIRST FLOOR) MR. ASHISH JAITLEY 1500 1500
SF-1 (SECOND FLOOR) MR RK. BAJPAI 1500 1500
SF-2 (SECOND FLOOR) MR AMAN PRATAP 1500 1500
SF-3 (SECOND FLOOR) MR.VIPIN CHAUHAN 1500 1500
SF-4 (SECOND FLOOR) MR RAHUL TYAGI 1500 1500
SF-5 (SECOND FLOOR) MR VIPIN SAINI 1500 1500
TF-1 (THIRD FLOOR) MR. PRAHLAD NISHAD 1500 1500
TF-2 (THIRD FLOOR) MR. LAKSHYA CHABRA 1500 1500
TF-3 (THIRD FLOOR) MS. TAPSYA 1500 1500
TF-4 (THIRD FLOOR) MR.UTTAM KUMAR KARMAKAR 1500 1500
TF-5 (THIRD FLOOR) MR. SACHIN 1500 1500
TF-1 (FOURTH FLOOR) MR.SAURABH 1500 1500
TF-2 (FOURTH FLOOR) MR. YOGESH GOYAL 1500 1500
TF-3 (FOURTH FLOOR) MR. RK CHAUHAN 1500 1500
TF-4 (FOURTH FLOOR) MR NITESH 1500 1500
TF-5 (FOURTH FLOOR) MR ISHPAL SINGH 1500 1500
Totals 0 0 0 0 0 0 34500 34500
Shop-wise Maintenance
Maintenance Amount Per Month 500
Collection
Maintenance Amount Annual
Amount Received
Shop Name Shop Holder Name Jan Feb Mar Apr May Jun Jul Aug
GREY CELL MR. ARJUN 500 500
IME MR SAHIL 500 500
IME MR SAHIL 500 500
CHOUDHARY STAINORY MR. SURENDER SIGNH 500 500
DOCTOR DR. SMRITI SINGH 500 500
PHARMACY 500 500
BUILDER SENCAR PAL
Totals 0 0 0 0 0 0 3000 3000

Total Collection 37500 37500


lection
18000
ved
Sep Oct Nov Dec Total Outstanding
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 7500 10500
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
1500 1500 1500 1500 9000 9000
34500 34500 34500 33000 205500 208500
llection
6000
ved
Sep Oct Nov Dec Total Outstanding
500 500 500 500 3000 3000
500 500 500 500 3000 3000
500 500 500 500 3000 3000
500 500 500 500 3000 3000
500 500 500 500 3000 3000
1000 5000
500 500 500 500 1000 5000
3000 3000 3000 3000 17000 33000

37500 37500 37500 36000


Flat-wise Servo Collection
Amount 2500

Flat No Flat Holder Name Amount Received Total


GF-1 (GROUND FLOOR) DR. KL CHETIWAL 2500 2500
GF-2 (GROUND FLOOR) MR. UDAIVIR SINGH TOMAR 2500 2500
GF-3 (GROUND FLOOR) MR. NITIN KHANNA 2500 2500
FF-1 (FIRST FLOOR) MR SURENDER SINGH 2500 2500
FF-2 (FIRST FLOOR) MR. ASHISH JAITLEY 2500 2500
FF-3 (FIRST FLOOR) MR. PRADEEP SHARMA 2500 2500
FF-4 (FIRST FLOOR) MS. MEENAKSHI GUPTA 2500 2500
FF-5 (FIRST FLOOR) MR. ASHISH JAITLEY 2500 2500
SF-1 (SECOND FLOOR) MR RK. BAJPAI 2500 2500
SF-2 (SECOND FLOOR) MR AMAN PRATAP 2500 2500
SF-3 (SECOND FLOOR) MR.VIPIN CHAUHAN 2500 2500
SF-4 (SECOND FLOOR) MR RAHUL TYAGI 2500 2500
SF-5 (SECOND FLOOR) MR VIPIN SAINI 2500 2500
TF-1 (THIRD FLOOR) MR PRALAD NISHAD 2500 2500
TF-2 (THIRD FLOOR) MR. LAKSHYA CHABRA 2500 2500
TF-3 (THIRD FLOOR) MS. TAPSYA 2500 2500
TF-4 (THIRD FLOOR) MR.UTTAM KUMAR KARMAKAR 2500 2500
TF-5 (THIRD FLOOR) MR. SACHIN 2500 2500
TF-1 (FOURTH FLOOR) MR.SAURABH 2500 2500
TF-2 (FOURTH FLOOR) MR. YOGESH GOYAL 2500 2500
TF-3 (FOURTH FLOOR) MR. RK CHAUHAN 2500 2500
TF-4 (FOURTH FLOOR) MR NITESH 2500 2500
TF-5 (FOURTH FLOOR) MR ISHPAL SINGH 2500 2500
Totals 57500 57500
Servo Cost 41,000
Electrical Wiring for Servo and MCB fitting 13,000
Outstanding 54,000
0
0 Balance Remain from Servo Collection Rs 3500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Flat-wise Water Softner Collectio
Amount

Flat No Flat Holder Name Amount Received


GF-1 (GROUND FLOOR) DR. KL CHETIWAL 7000
GF-2 (GROUND FLOOR) MR. UDAIVIR SINGH TOMAR 7000
GF-3 (GROUND FLOOR) MR. NITIN KHANNA 5000
FF-1 (FIRST FLOOR) MR SURENDER SINGH 7000
FF-2 (FIRST FLOOR) MR. ASHISH JAITLEY 7000
FF-3 (FIRST FLOOR) MR. PRADEEP SHARMA 7000
FF-4 (FIRST FLOOR) MS. MEENAKSHI GUPTA 5000
FF-5 (FIRST FLOOR) MR. ASHISH JAITLEY 7000
SF-1 (SECOND FLOOR) MR RK. BAJPAI 7000
SF-2 (SECOND FLOOR) MR AMAN PRATAP 7000
SF-3 (SECOND FLOOR) MR.VIPIN CHAUHAN 7000
SF-4 (SECOND FLOOR) MR RAHUL TYAGI 7000
SF-5 (SECOND FLOOR) MR VIPIN SAINI 7000
TF-1 (THIRD FLOOR) MR PRALAD NISHAD 7000
TF-2 (THIRD FLOOR) MR. LAKSHYA CHABRA 7000
TF-3 (THIRD FLOOR) MS. TAPSYA 5000
TF-4 (THIRD FLOOR) MR.UTTAM KUMAR KARMAKAR 5000
TF-5 (THIRD FLOOR) MR. SACHIN 7000
TF-1 (FOURTH FLOOR) MR.SAURABH 7000
TF-2 (FOURTH FLOOR) MR. YOGESH GOYAL 7000
TF-3 (FOURTH FLOOR) MR. RK CHAUHAN 7000
TF-4 (FOURTH FLOOR) MR NITESH 7000
TF-5 (FOURTH FLOOR) MR ISHPAL SINGH 7000
Totals 0
er Collection
7000

Total Outstanding
7000 0
7000 0
5000 2000
7000 0
7000 0
7000 0
5000 2000
7000 0
7000 0
7000 0
7000 0
7000 0
7000 0
7000 0
7000 0
5000 2000
5000 2000
7000 0
7000 0
7000 0
7000 0
7000 0
7000 0
153000 8000
Total Amount for Softner Rs.1,40,000
Advance Paid Rs.50,000
After Instalation Amount Paid Rs.65,000
Remaning Amount Paid Rs.25,000

Softner Total Amount Collection Rs.1,61,000

Remaning Balance is added to society fund Rs.21,000

You might also like