Loading...
HomeMy WebLinkAboutTrial_Balance_escaya_Accrual1/26/2022 6:10 PMForward EndingBalance Debit Credit Balance1100-0010 Operating Cash #1 1,015,472.97 0.00 385,352.61 630,120.361100-0210 Petty Cash 2,000.00 0.00 0.00 2,000.001300-0010 Tenant Receivables 94,679.81 0.00 5,526.69 89,153.121300-0030 A/R - Retail -11,841.57 6,423.05 0.00 -5,418.521300-0380 AR - Other 4th 4,660.73 0.00 0.00 4,660.731400-0010 Prepaid Expenses 1,718.04 0.00 0.00 1,718.041400-0070 Prepaid Insurance Property 15,070.51 170,583.58 0.00 185,654.091400-0075 Umbrella Insurance 2,399.70 32,028.23 0.00 34,427.931400-0090 Prepaid Liability Insurance 1,498.11 15,573.29 0.00 17,071.402100-0010 Accounts Payable -9,214.62 3,573.05 0.00 -5,641.572100-0350 Prepaid Rent -71,652.66 16,616.66 0.00 -55,036.002100-0370 Prepaid Other Income -13,784.40 0.00 0.00 -13,784.402200-0010 Security Deposits - Current -226,603.80 7,638.00 0.00 -218,965.802200-0030 Pet Deposits -3,500.00 500.00 0.00 -3,000.002200-0080 Retail Deposits -44,919.12 0.00 0.00 -44,919.122200-0150 Security Deposits-Move Out -4,639.50 0.00 0.00 -4,639.502400-0010 Accrued Expenses -85,524.39 0.00 260,903.06 -346,427.452400-0050 Accrued Property Taxes -247,713.42 247,713.42 0.00 0.002400-0120 Accrued payroll expenses -16,154.00 0.00 3,725.00 -19,879.002400-0230 Accrued Property Management -15,771.51 0.00 706.03 -16,477.543000-0010 Contributions 1 -248,412.18 0.00 0.00 -248,412.183000-0470 Distributions 1 5,688,801.79 0.00 300,000.00 5,388,801.793000-1670 Retained Earnings -1,110,062.23 0.00 0.00 -1,110,062.234100-0020 Rent -6,758,440.03 0.00 634,243.42 -7,392,683.454100-0090 Models 47,025.00 4,275.00 0.00 51,300.004100-0100 Employee Units 68,468.58 7,291.53 0.00 75,760.114100-0150 Rental Concessions 18,303.93 100.00 0.00 18,403.934100-0320 Bad Debt Expense 17,736.93 0.00 0.00 17,736.934100-0350 Base Rent - Commercial -40,782.10 0.00 10,331.75 -51,113.854200-0060 Application Fees -13,815.00 0.00 1,938.00 -15,753.004200-0100 Carport Income -49,896.72 0.00 4,203.05 -54,099.774200-0180 Damage Fees -34,933.05 0.00 3,487.59 -38,420.64The Residences at Escaya + Retail (escaya)Trial BalancePeriod = Nov 2021Book = Accrual Page 1 of 6 1/26/2022 6:10 PMForward EndingBalance Debit Credit BalanceThe Residences at Escaya + Retail (escaya)Trial BalancePeriod = Nov 2021Book = Accrual4200-0230 Termination Fees -6,357.79 0.00 861.77 -7,219.564200-0340 Pet Rent -30,667.99 0.00 1,990.75 -32,658.744200-0360 NSF -1,155.00 0.00 105.00 -1,260.004200-0610 Renter's Insurance 20.08 203.49 0.00 223.574300-0010 Miscellaneous Income -30.00 0.00 199.85 -229.854300-0130 Collection Income -11,443.53 0.00 1,687.36 -13,130.894300-0630 Accelerated Rent -5,324.50 0.00 0.00 -5,324.504400-0040 Rent Concession - Retail 57,987.65 6,974.00 0.00 64,961.654400-0080 Retail Income CAM -11,343.96 0.00 2,628.39 -13,972.354700-0010 Reimbursed Electricity -100.00 0.00 200.00 -300.005100-1030 Manager 69,801.73 5,207.38 0.00 75,009.115100-1040 Assistant Manager 47,423.09 4,909.22 0.00 52,332.315100-2010 Leasing Manager 18,058.50 0.00 0.00 18,058.505100-2020 Leasing Consultant 41,712.18 3,013.34 0.00 44,725.525100-3010 Director of Facilities 5,711.08 564.00 0.00 6,275.085100-3030 Maintenance Manager 47,624.74 4,803.00 0.00 52,427.745100-3050 Maintenance Person 68,050.00 5,299.22 0.00 73,349.225200-0010 Overtime - Administrative 3,135.71 242.77 0.00 3,378.485200-0020 Overtime - Leasing 591.46 119.57 0.00 711.035200-0030 Overtime - Maintenance 4,848.70 130.41 0.00 4,979.115250-0010 Bonus - Administrative - Monthly 60.00 0.00 0.00 60.005250-0050 Bonus - Leasing - Monthly 3,262.08 0.00 53.08 3,209.005250-0330 Bonuses & Other Bonuses 68,274.65 9,850.48 0.00 78,125.135400-0010 Ck Processing - Administrative 120.00 0.00 0.00 120.005450-0250 Other Payroll Taxes 34,716.99 3,247.79 0.00 37,964.785500-0090 Other Insurance Benefits 31,499.68 2,540.00 0.00 34,039.685550-0100 401K Administration Costs 4,790.88 719.02 0.00 5,509.905600-0010 Workers Comp - Administrative 32,328.79 3,641.97 0.00 35,970.765650-0040 New Hire Expense - Admin 957.53 0.00 0.00 957.535650-0050 New Hire Expense - Maint 27.55 0.00 0.00 27.555650-0090 Employee Gifts 40.00 0.00 0.00 40.006000-0010 Landscape Contract 50,953.00 5,576.65 0.00 56,529.65 Page 2 of 6 1/26/2022 6:10 PMForward EndingBalance Debit Credit BalanceThe Residences at Escaya + Retail (escaya)Trial BalancePeriod = Nov 2021Book = Accrual6000-0020 Flowers 2,212.68 179.22 0.00 2,391.906000-0030 Mulch 5,518.20 0.80 0.00 5,519.006000-0040 Landscape Supplies 286.65 301.84 0.00 588.496000-0130 Irrigation/Sprinkler Repairs 4,450.41 312.62 0.00 4,763.036100-0010 Electricity 55,927.71 8,197.90 0.00 64,125.616100-0030 Electricity - Model -630.18 116.29 0.00 -513.896100-0040 Electricity - Vacant 8,940.62 0.00 2,054.94 6,885.686100-0080 Gas 14,938.88 4,142.06 0.00 19,080.946100-0100 Gas - Model 0.00 0.00 0.00 0.006100-0110 Gas - Vacant 0.00 0.00 0.00 0.006100-0150 Water 110,473.79 7,151.08 0.00 117,624.876100-0220 Sewer 0.00 0.00 0.00 0.006100-0280 Trash Removal 103,486.26 13,648.00 0.00 117,134.266100-0310 Cable Expense 1,500.50 165.67 0.00 1,666.176100-0370 Reimbursed Utilities -13,329.56 0.00 528.93 -13,858.496100-0375 Reimbursed Water -49,316.45 0.00 4,565.50 -53,881.956100-0380 Reimbursed Sewer -35,811.21 0.00 3,268.55 -39,079.766100-0390 Reimbursed Trash Removal -77,006.30 0.00 7,933.69 -84,939.996100-0430 Contract Utility Admin 9,481.84 127.27 0.00 9,609.116300-0050 Marketing - Internet 25,216.60 2,707.00 0.00 27,923.606300-0210 Advertising Other 179.29 355.00 0.00 534.296300-0220 Dues, Memberships & Sub. 2,409.00 200.00 0.00 2,609.006300-0230 Resident Functions -901.26 0.00 0.00 -901.266300-0280 Marketing Supplies 30.00 0.00 0.00 30.006300-0300 Temporary Signage 534.67 0.00 0.00 534.676300-0342 Alliance Resident Works 566.50 0.00 0.00 566.506300-0346 PPC 18,393.68 1,467.03 0.00 19,860.716300-0420 Resident Retention 797.46 176.50 0.00 973.966300-0460 Model Maintenance 2,360.03 399.40 0.00 2,759.436300-0540 Other Mktg. - Non Adv. 1,515.50 0.00 0.00 1,515.506300-0542 SEO Program 6,600.00 0.00 0.00 6,600.006300-0544 Reputation Management 1,224.75 0.00 0.00 1,224.75 Page 3 of 6 1/26/2022 6:10 PMForward EndingBalance Debit Credit BalanceThe Residences at Escaya + Retail (escaya)Trial BalancePeriod = Nov 2021Book = Accrual6300-0550 Shopper Reports 0.00 30.00 0.00 30.006300-0570 Fitness program 0.00 0.00 0.00 0.006300-0580 Fitness program - Property 2,766.00 249.00 0.00 3,015.006400-0010 Telephone 2,066.05 57.90 0.00 2,123.956400-0020 Cell Phone 273.94 31.79 0.00 305.736400-0050 Internet Service 5,279.41 460.89 0.00 5,740.306400-0060 Common Area TV 155.77 0.00 0.00 155.776400-0070 Office Supplies 3,218.82 150.26 0.00 3,369.086400-0075 Misc Office Expense 176.33 0.00 0.00 176.336400-0120 Postage -90.21 0.00 0.00 -90.216400-0170 Printing 0.00 3.89 0.00 3.896400-0200 Licenses 2,417.00 175.00 0.00 2,592.006400-0230 Training & Education 2,941.69 291.67 0.00 3,233.366400-0250 Eviction/Legal Fees 2,074.98 0.00 0.00 2,074.986400-0270 Credit Check 3,731.91 412.65 0.00 4,144.566400-0310 Bank Charges/Credit Card Fees 3,573.31 327.73 0.00 3,901.046400-0320 Employee Recognition 881.06 0.00 0.00 881.066400-0330 Employee Meetings 36.16 35.80 0.00 71.966400-0440 Administrative Other 2,106.21 301.16 0.00 2,407.376400-0480 Computer Software 7,220.80 1,783.00 0.00 9,003.806400-0484 Yardi PAYscan 309.70 0.00 0.00 309.706400-0510 Computer Leasing 0.00 0.00 0.00 0.006400-0560 Gov Licenses Fees/Permits 3,403.97 0.00 0.00 3,403.976400-0660 Renter's Insurance 0.00 0.00 0.00 0.006400-0805 Uniforms - Leasing 288.94 0.00 0.00 288.946500-0010 Building & Structure 28.74 0.00 0.00 28.746500-0020 Building & Maintenance 212.81 183.58 0.00 396.396500-0030 Building & Maintenance Supplies 1,160.23 315.80 0.00 1,476.036500-0060 Lighting 0.73 0.00 0.00 0.736500-0110 Amenities R&M 1,109.75 284.46 0.00 1,394.216500-0360 Electrical 2,437.09 217.93 0.00 2,655.026500-0380 Electrical Supplies -429.46 0.00 0.00 -429.46 Page 4 of 6 1/26/2022 6:10 PMForward EndingBalance Debit Credit BalanceThe Residences at Escaya + Retail (escaya)Trial BalancePeriod = Nov 2021Book = Accrual6500-0400 Plumbing 3,231.08 762.78 0.00 3,993.866500-0410 Plumbing Supplies 0.00 0.00 0.00 0.006500-0430 HVAC 2,411.54 1,010.04 0.00 3,421.586500-0440 HVAC Supplies -223.75 0.00 0.00 -223.756500-0600 Misc. Supplies 1.87 0.00 0.00 1.876500-0610 Housekeeping 42,668.02 4,733.94 0.00 47,401.966500-0620 Cleaning Supplies 624.33 0.00 0.00 624.336500-0690 Pest Control 4,380.00 370.00 0.00 4,750.006500-0710 Swimming Pool 11,882.54 0.00 1,341.17 10,541.376500-0840 Courtesy Patrol 15,675.00 3,150.00 0.00 18,825.006500-1040 Keys 925.33 0.00 0.00 925.336500-1050 Locks -73.81 0.00 0.00 -73.816500-1060 Fire Extinguisher, 1st Aid 15,484.32 651.24 0.00 16,135.566500-1110 Alarm Expense 3,896.25 1,252.50 0.00 5,148.756500-1360 Appliances 2,337.42 0.00 0.00 2,337.426500-1460 Safety Tool Equip/Rep/Sup 902.62 33.20 0.00 935.826500-1480 Appliance Repair 5,120.28 1,534.99 0.00 6,655.276500-1500 Carpet Replacement -1,402.68 0.00 0.00 -1,402.686500-1550 Uniforms - Maintenance 1,425.24 0.00 0.00 1,425.246600-0010 Redec-General Cleaning 14,742.62 4,643.17 0.00 19,385.796600-0020 Redec-Cleaning Supplies -152.52 0.00 0.00 -152.526600-0040 Redec-Painting Supplies 564.86 189.90 0.00 754.766600-0050 Redec-Painting Contract 33,325.00 3,330.00 0.00 36,655.006600-0080 Redec-Drapes/Blinds 1,039.50 0.00 0.00 1,039.506600-0130 Redec-Carpet Cleaning 4,300.00 1,805.00 0.00 6,105.006600-0140 Redec-Carpet Replacement 28,694.34 7,528.15 0.00 36,222.496600-0150 Redec-Vinyl Repair 460.00 0.00 0.00 460.006600-0170 Redec-Bathroom 199.00 0.00 0.00 199.006600-0180 Redec-Appliance Repair 467.64 182.81 0.00 650.456600-0200 Redec-Plumbing 674.00 37.40 0.00 711.406600-0230 Redec-Doors/Cabinets 374.16 78.95 0.00 453.117000-0010 Management Fees - #1 171,611.76 16,477.54 0.00 188,089.30 Page 5 of 6 1/26/2022 6:10 PMForward EndingBalance Debit Credit BalanceThe Residences at Escaya + Retail (escaya)Trial BalancePeriod = Nov 2021Book = Accrual7100-0010 Property Insurance 163,032.35 31,948.15 0.00 194,980.507100-0020 General Liability Insurance 16,478.88 3,050.05 0.00 19,528.937100-0035 Umbrella Insurance 21,767.11 5,529.51 0.00 27,296.627200-0010 Real Estate Taxes 434,779.31 922,611.55 0.00 1,357,390.867200-0100 Taxes Other 175,882.00 12,488.00 0.00 188,370.007300-0050 Eviction Legal Fees 3.25 0.00 0.00 3.258200-0040 Legal 17.89 0.00 0.00 17.898400-0670 Miscellaneous 46,818.21 119.00 0.00 46,937.218500-0010 Appliances 405.19 0.00 0.00 405.198500-0060 Carpeting 0.00 0.00 0.00 0.008800-0200 Leasing Commissions 35,383.06 0.00 0.00 35,383.068800-0440 Disaster Relief - COVID-19 68.95 0.00 0.00 68.958800-0480 Insurance Reimbursement -3,353.05 0.00 0.00 -3,353.05Total 0.00 1,637,836.18 1,637,836.18 0.00 Page 6 of 6