Scribd Logo
Upload

Welcome to Scribd!

  • 710 views

    Apartment Maintenance Accounts Excel Template

    Uploaded by

    Techto solve
    The document contains monthly apartment maintenance expense records for Rang Raj Apartments - A from January to December. It lists expenses such as janitor/sweeper costs, lift man salary, electricity and water bills, electrician fees, and maintenance costs for drainage and water pumps. The total yearly expense amount for maintaining the apartment is ₹35,700.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Apartment Maintenance Accounts Excel Template

    Uploaded by

    Techto solve
    710 views27 pages
    The document contains monthly apartment maintenance expense records for Rang Raj Apartments - A from January to December. It lists expenses such as janitor/sweeper costs, lift man salary, electricity and water bills, electrician fees, and maintenance costs for drainage and water pumps. The total yearly expense amount for maintaining the apartment is ₹35,700.

    Original Title

    Apartment-Maintenance-Accounts-Excel-Template.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains monthly apartment maintenance expense records for Rang Raj Apartments - A from January to December. It lists expenses such as janitor/sweeper costs, lift man salary, electricity and water bills, electrician fees, and maintenance costs for drainage and water pumps. The total yearly expense amount for maintaining the apartment is ₹35,700.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    710 views27 pages

    Apartment Maintenance Accounts Excel Template

    Uploaded by

    Techto solve
    The document contains monthly apartment maintenance expense records for Rang Raj Apartments - A from January to December. It lists expenses such as janitor/sweeper costs, lift man salary, electricity and water bills, electrician fees, and maintenance costs for drainage and water pumps. The total yearly expense amount for maintaining the apartment is ₹35,700.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 27

    Apartment Maintenance Accounts

    Month Jan
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man Salary
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair
    Month Feb
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair

    Month Mar
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair

    Month Apr
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair

    Month May
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair
    Month Jun
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair
    Month Jul
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair
    Month Aug
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair
    Month Sep
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair
    Month Oct
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair

    Month Nov
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair

    Month Dec
    Name of the Building Rang Raj Apartments - A
    Date Day Expense Description
    1/1/2019 Tuesday Janitor/Sweeper
    1/1/2019 Tuesday Lift Man
    1/1/2019 Tuesday Electricity Bill
    1/1/2019 Tuesday Water Supply
    1/1/2019 Tuesday Electrician
    1/1/2019 Tuesday Electricals(2nd Floor)
    1/2/2019 Wednesday Drainage Maintenence
    1/8/2019 Tuesday Water Pump Repair
    ce Accounts

    Rang Raj Apartments - A Yearly Expense Summary


    xpense Description Amount Month
    Janitor/Sweeper ₹ 1,000.00 Jan
    Lift Man Salary ₹ 3,000.00 Feb
    Electricity Bill ₹ 15,000.00 Mar
    Water Supply ₹ 8,000.00 Apr
    Electrician ₹ 500.00 May
    Electricals(2nd Floor) ₹ 200.00 Jun
    Drainage Maintenence ₹ 2,000.00 Jul
    Water Pump Repair ₹ 6,000.00 Aug
    Sep
    Oct
    Nov
    Dec
    Total

    Total ₹ 35,700
    Rang Raj Apartments - A
    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00

    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00

    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00

    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00
    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00
    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00
    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00
    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00
    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00

    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00

    Total ₹ 35,700

    Rang Raj Apartments - A


    xpense Description Amount
    Janitor/Sweeper ₹ 1,000.00
    Lift Man ₹ 3,000.00
    Electricity Bill ₹ 15,000.00
    Water Supply ₹ 8,000.00
    Electrician ₹ 500.00
    Electricals(2nd Floor) ₹ 200.00
    Drainage Maintenence ₹ 2,000.00
    Water Pump Repair ₹ 6,000.00

    Total ₹ 35,700
    rly Expense Summary
    Amount
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 35,700
    ₹ 428,400
    Flat-wise Maintenance Collec
    Maintenance Amount Per Month 1000 Maintenance Amount Annual
    Amount Received
    Flat No Flat Holder Name Jan Feb Mar Apr May Jun Jul
    A-101 Amit 3000 - - 3000 - - 2000
    A-102 Raj 3000 - - 3000 - - 3000
    A-103 Sharan 3000 - - 3000 - - 3000
    A-104 Gautam 3000 - - 3000 - - 3000
    A-201 Rajesh 3000 - - 3000 - - 3000
    A-202 Pratham 3000 - - 3000 - - 3000
    A-203 Lucky 3000 - - 3000 - - 3000
    A-204 Vishesh 3000 - - 3000 - - 3000
    A-301 Amrita 3000 - - 3000 - - 3000
    A-302 Gopal 3000 - - 3000 - - 3000
    A-303 Siham 3000 - - 3000 - - 3000
    A-304 Ritu 3000 - - 3000 - - 3000
    A-401 Divyesh 3000 - - 3000 - - 3000
    A-402 Raju 3000 - - 3000 - - 3000
    A-403 Jitendra 3000 - - 3000 - - 3000
    A-404 Bhupendra 3000 - - 3000 - - 3000
    A-501 Vignesh 1000 1000 1000 1000 1000 1000 1000
    A-502 Priya 1000 1000 1000 1000 1000 1000 1000
    A-503 Krishna 1000 1000 1000 1000 1000 1000 1000
    A-504 Shreya 1000 1000 1000 1000 1000 1000 1000
    A-601 Amit 1000 1000 1000 1000 1000 1000 1000
    A-602 Raj 1000 1000 1000 1000 1000 1000 1000
    A-603 Sharan 1000 1000 1000 1000 1000 1000 1000
    A-604 Gautam 1000 1000 1000 1000 1000 1000 1000
    A-701 Rajesh 1000 1000 1000 1000 1000 1000 1000
    A-702 Pratham 1000 1000 1000 1000 1000 1000 1000
    A-703 Lucky 1000 1000 1000 1000 1000 1000 1000
    A-704 Vishesh 1000 1000 1000 1000 1000 1000 1000
    A-801 Amrita 1000 1000 1000 1000 1000 1000 1000
    A-802 Gopal 1000 1000 1000 1000 1000 1000 1000
    A-803 Siham 1000 1000 1000 1000 1000 1000 1000
    A-804 Ritu 1000 1000 1000 1000 1000 1000 1000
    A-901 Divyesh 1000 1000 1000 1000 1000 1000 1000
    A-902 Raju 1000 1000 1000 1000 1000 1000 1000
    A-903 Jitendra 1000 1000 1000 1000 1000 1000 1000
    A-904 Bhupendra 1000 1000 1000 1000 1000 1000 1000
    A-1001 Vignesh 1000 1000 1000 1000 1000 1000 1000
    A-1002 Priya 1000 1000 1000 1000 1000 1000 1000
    A-1003 Krishna 1000 1000 1000 1000 1000 1000 1000
    A-1004 Shreya 1000 1000 1000 1000 1000 1000 1000
    Totals 72000 24000 24000 72000 24000 24000 71000
    nce Collection
    mount Annual 12000
    nt Received
    Aug Sep Oct Nov Dec Total Outstanding
    - - 3000 - - 11000 1000
    - - 1000 - - 10000 2000
    - - 3000 - - 12000 0
    - - 2500 - - 11500 500
    - - 3000 - - 12000 0
    - - 2200 - - 11200 800
    - - 3000 - - 12000 0
    - - 3000 - - 12000 0
    - - 800 - - 9800 2200
    - - 3000 - - 12000 0
    - - 800 - - 9800 2200
    - - 3000 - - 12000 0
    - - 3000 - - 12000 0
    - - 3000 - - 12000 0
    - - 3000 - - 12000 0
    - - 3000 - - 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 1000 1000 1000 1000 12000 0
    1000 - - - - 8000 4000
    1000 - - - - 8000 4000
    1000 - - - - 8000 4000
    1000 - - - - 8000 4000
    1000 - - - - 8000 4000
    1000 - - - - 8000 4000
    1000 - - - - 8000 4000
    24000 17000 57300 17000 17000 443300 36700

    You might also like