Loading...
HomeMy WebLinkAbout2021PLJan - Dec 21 Ordinary Income/Expense Income MedPremiumCR 374.55 WageCreditCR 5,350.52 43300 · Contributions 43320 · United Way Designations 16,698.13 43325 · Individuals 299,940.55 43345 · Community & Corporate 85,100.46 44540 · Faith Groups 37,638.73 44550 · Parking Lot Contributions 12,464.00 Total 43300 · Contributions 451,841.87 43350 · Fundraising Income 651,534.75 44400 · Grants 44410 · FEMA-EFSP 16,993.50 44430 · HUD-COC-RRH 542,706.00 44449 · IFA-ESG-CV 899,334.00 44455 · IFA-ESG-Rapid Rehousing 77,454.00 44465 · HTFJC-501-Construction (501 Construction Grant.)400,000.00 44466 · HUD-NHTF-501-Construction (IFA Pass Through.)1,199,236.00 44480 · Private & Corporate 98,500.00 44493 · IFA-SAF-Emergency Shelter 102,299.00 44495 · HUD-COC-PSH-CPP (Permanent Supportive Housing ...236,845.00 44497 · HUD-COC-PSH-SS (COC Scattered Site PSH)198,067.81 46420BH · VA Per Diem BH 72,269.68 Total 44400 · Grants 3,843,704.99 44500 · Local Funding Grants 44510 · Johnson Co 44510-1 · COVID Hoteling Grant (Johnson County COVID Ho...46,619.29 44510-3 · Shower Grant 14,250.00 44510-4 · DHHS-ICA-COVID 1,642.50 44510-5 · Eviction Diversion 12,000.00 44510 · Johnson Co - Other 123,600.00 Total 44510 · Johnson Co 198,111.79 44515 · Iowa City 44565-1 · City of Iowa City-CDBG-CV 377,358.76 44565-2 · City of Iowa City -Housing Auth (Iowa City Housin...48,262.74 44565 · City of Iowa City-CDBG 27,662.00 44567 · Eviction Prevention Program 28,969.16 44568 · Eviction Diversion 41,000.00 44515 · Iowa City - Other 66,611.00 1:38 PM Shelter House 06/09/22 Profit & Loss Accrual Basis January through December 2021 Page 1 Jan - Dec 21 Total 44515 · Iowa City 589,863.66 44520 · Coralville 10,371.00 44525 · North Liberty 8,500.00 44530 · United Way Allocations 121,248.00 Total 44500 · Local Funding Grants 928,094.45 46400 · Contract Services 446420 · PHA Case Management 112,088.00 46430 · Per Diem UIHC 24,000.00 47000 · Fresh Starts 149,155.11 47210 · Contract Meals 26,719.29 47240 · Lodge Rent 41,378.71 47245 · CPP Rent 218,360.00 Total 46400 · Contract Services 571,701.11 48000 · In Kind Donations 207,340.00 50100 · Clinic Rent CPP (CPP Clinic Income from UI School of N...3,000.00 Total Income 6,662,942.24 Gross Profit 6,662,942.24 Expense 60300 · Employee Expenses 60310 · Salaries & Wages 60315 · VISTA Expense 6,169.77 60310 · Salaries & Wages - Other 1,972,302.51 Total 60310 · Salaries & Wages 1,978,472.28 60320 · FICA Expense 144,721.82 60330 · Unemployment Expense 32,780.74 60340 · Workers Compensation Insurance 31,146.62 60345 · FSA Contribution (Employer Contribution FSA + DC F...3,220.09 60350 · Health Insurance (Health, Dental and Vision Insurance)145,065.17 60360 · Simple IRA Plan Contribution 20,578.77 60365 · Employee Referral Bonus 2,000.00 Total 60300 · Employee Expenses 2,357,985.49 62600 · Automobile - Kitchen Van (Kitchen Auto Expenses) 62610 · Fuel (Kitchen Auto Gas)112.69 62630 · Repairs & Maintenance (Kitchen Auto Repairs)166.14 Total 62600 · Automobile - Kitchen Van (Kitchen Auto Expenses)278.83 1:38 PM Shelter House 06/09/22 Profit & Loss Accrual Basis January through December 2021 Page 2 Jan - Dec 21 62700 · Insurance Expense 62710 · Property 25,320.34 62720 · Liability 24,256.53 62730 · Auto 12,584.71 Total 62700 · Insurance Expense 62,161.58 62800 · Utilities & Facility 62820 · Gas & Electric 62821 · Gas 7,415.41 62822 · Electric 46,447.57 Total 62820 · Gas & Electric 53,862.98 62830 · Water & Sewer 20,081.87 62835 · Waste/Recycle 4,337.85 62840 · Building Repairs & Maintenance 73,062.42 62845 · Equipment Repair & Maintenance 22,504.45 62870 · Program Supplies 62871 · COVID Response 4,668.46 62870 · Program Supplies - Other 29,975.80 Total 62870 · Program Supplies 34,644.26 62875 · Programs - Equipment 15,677.49 62880 · Property Taxes (Taxes on real estate and personal pro...7,636.32 62890 · Advertising/Website 13,835.53 62895 · Telecommunications & Network 149,508.07 Total 62800 · Utilities & Facility 395,151.24 63000 · Direct Client-Resident Services 63001 · Client Hoteling - COVID 37,207.80 63010 · Resident Meals 36,294.45 63020 · Client Outreach Expense 125.66 63025 · Life Skills 340.27 63040 · Outpatient Health Services 64.55 63056 · Other Assistance (Other Assistance - Late Fee)14,838.87 63060 · Client Transportation 63061 · Fuel 63061-1 · Red Mini-Van 1,494.91 63061-2 · Mailbu 319.97 63061-3 · Focus - Ford 252.07 63061-4 · White Van 477.67 63061-5 · Green Van 673.99 63061-7 · Maroon Van 2,120.17 63061-8 · Silver Van (2006 Honda Odyssey)1,113.87 63061-9 · Sienna (2005 Sienna)1,407.60 63061-A · GMC Moving Truck (Moving Truck)1,204.81 1:38 PM Shelter House 06/09/22 Profit & Loss Accrual Basis January through December 2021 Page 3 Jan - Dec 21 63061-B · 2011 Sienna Truck 693.98 63061-C · Highlander Truck 966.30 Total 63061 · Fuel 10,725.34 63062 · Repairs & Maintenance 63062-1 · Red Mini-Van 487.22 63062-2 · Malibu 584.60 63062-3 · Focus - Ford 214.67 63062-4 · White Van 51.00 63062-5 · Green Van 708.20 63062-7 · Maroon Van 2,864.67 63062-8 · Silver Van (2006 Honda Odyssey)2,361.24 63062-9 · Sienna (2005 Sienna)3,424.76 63062-A · GMC Moving Truck (Moving Truck)927.50 63062-B · 2011 Sienna Truck -49.00 63062-C · Highlander Truck 205.49 63062 · Repairs & Maintenance - Other 450.50 Total 63062 · Repairs & Maintenance 12,230.85 63060 · Client Transportation - Other 3,615.37 Total 63060 · Client Transportation 26,571.56 63065 · Clothing 739.84 63070 · Client Security Deposits 202,631.00 63071 · Client Rent Assistance 1,022,677.48 63072 · Client Utilities 48,523.48 63073 · Household Items 2,261.29 63075 · Client Application Fees/Moving 8,896.66 63076 · Credit Repair 796.00 Total 63000 · Direct Client-Resident Services 1,401,968.91 65000 · HR, Fundraising, Office & Admin 65005 · Audit Fees 22,140.00 65010 · Bank & Credit Cards Fees 9,792.86 65015 · Professional Fees 25,476.25 65025 · Dues, Fees & Subscriptions 24,607.25 65030 · Events & Fundraising Expenses 7,633.10 65035 · Office Supplies 2,149.99 65040 · Postage/Shipping 3,614.55 65045 · Print & Publicity 10,476.87 65070 · Staff Development 21,935.78 65075 · Conferences 3,101.93 65080 · Travel/Fuel/Parking 279.20 65090 · D&O Insurance 3,095.00 1:38 PM Shelter House 06/09/22 Profit & Loss Accrual Basis January through December 2021 Page 4 Jan - Dec 21 65000 · HR, Fundraising, Office & Admin - Other 54.00 Total 65000 · HR, Fundraising, Office & Admin 134,356.78 65100 · Other Expenses 65105 · Misc Expense 341.39 65115 · Storage 1,400.96 65130 · Interest Expense (Interest on loans and leases, other t...23,145.01 65140 · Parking Lot Rent (Parking Lot Rent)2,624.00 65145 · Rental Payment 12,600.00 65190 · Late Fee 0.00 65199 · Sales Tax Adjustment 114.72 Total 65100 · Other Expenses 40,226.08 66900 · Reconciliation Discrepancies (Discrepancies between ba...-2.49 Total Expense 4,392,126.42 Net Ordinary Income 2,270,815.82 Other Income/Expense Other Income 70605 · Change in Beneficial Interest 219,419.79 70606 · Misc Income 2,650.93 70610 · Interest Income 760.05 80120 · Gain/Loss 103,391.51 Total Other Income 326,222.28 Net Other Income 326,222.28 Net Income 2,597,038.10 1:38 PM Shelter House 06/09/22 Profit & Loss Accrual Basis January through December 2021 Page 5