Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2013-10-22 HRA Agenda
HOUSING & REDEVELOPMENT AUTHORITY AGENDA 7:00 P.M. Tuesday October 22, 2013 PARKVIEW VILLA, COMMUNITY ROOM B, 965 40'x' AVE., COLUMBIA HEIGHTS, MN 1. Call to Order 2. Roll Call Tammera Diehm, Chair Bobby Williams, Vice Chair Rheta Nelson 3. Pledge of Allegiance CONSENT AGENDA 4. Approve minutes of July 23, 2013 meeting minutes Bruce Nawroeki Donna Schmitt, Secretary /Treasurer Gary Peterson 5. Approve Financial Report and payment of bills for July, August, and September 2013 on Resolution 2013 -08 Motion: Move to approve consent items as listed BUSINESS ITEMS 6. Report of Management Company 7. Resident Council Minutes 8. Citizen Forum* 9. Approval of Parkview Villa North 2014 Budget — Resolution 2013 -09 Motion: Move to waive the reading of Resolution 2013 -09 there being ample copies available to the public. Motion: Move to adopt Resolution 2013 — 09 approving the Housing and Redevelopment Authority in and for the City of Columbia Heights, adopting the 2014 Parkview Villa North Budget of $598,251 and recommending this to the City Council for approval. 10. Approval of Parkview Villa South 2014 Budget — Resolution 2013 -10 Motion: Move to waive the reading of Resolution 2013 -10 there being ample copies available to the public Motion: Move to adopt Resolution 2013 -01 approving the Housing and Redevelopment Authority in and for the City of Columbia Heights, adopting the 2014 Parkview Villa South Budget of $274,850 and recommending this to the City Council for approval 11. PUBLIC HEARING 1. Approval of PHA Plan Amendment— Resolution 2013 -11 and Resolution 2013 -12 Motion: Move to waive the reading of Resolution 2013 -11 there being ample copies available to the public. Motion: Move to adopt resolution 2013 -11 Approving a PHA Amendment for FY 2011,FY2012 and Approving FY2013 Physical Needs Statement. Motion: Move to waive the reading of Resolution 2013 -12 there being ample copies available to the public. Motion: Move to adopt Resolution 2013 -12 confirming approval of the Public Housing Agency Certifications of Compliance with the FY2011, FY2012 and FY 2013 PHA Plan Amendment and related regulations, and Authorizing it's submission to HUD. Business Items 1. Administrative Updates *At this time, citizens have an opportunity to discuss with the HRA items not on the regular agenda. The citizen is requested to limit their comments to five minutes. Please note the public may address the [-IRA regarding specific agenda items at the time the item is being discussed. HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE MEETING OF JULY 23, 2013 1. Call to order — The meeting was called to order by Chair Diehm at 7:00 pm. 2. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Donna Schmitt, Bobby Williams, Rheta Nelson, and Tammera Diebm. Staff Present: Executive Director -Walt Fehst, Community Development Director -Scott Clark, and Secretary- Shelley Hanson. CommonBond Staff- Laura Frost and Heidi Mindestrom 3. Pledge of Allegiance — Recited CONSENT AGENDA 4. Approve Minutes of April 23, 2013. 5. Approve Financial Reports and Payment of Bills for April, May, and June 2013 on Resolution 2013 -07. Questions from members: Schmitt questioned the Miscellaneous Administration Expenses in May as noted on the reports. Laura Frost stated there was an accounting error that was later corrected and noted on the June reports. Motion by Peterson, seconded by Williams, to approve items on the Consent Agenda as presented. All ayes. MOTION PASSED. HRA RESOLUTION 2013 -07 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR APRIL, MAY AND JUNE 2013 AND PAYMENT OF BILLS FOR THE MONTHS OF APRIL, MAY, AND JUNE 2013. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (I -IRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the HRA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and WHEREAS, the financial statement for the months of April, May, and June 2013 and the list of bills for the months of April, May, and June 2013 are attached hereto and made a part of this resolution; and HRA Minutes Page 2 July 23, 2013 WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that it has examined the attached financial statements and list of bills, which are attached hereto and made a part hereof, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the list of bills as presented in writing are approved for payment out of proper funds; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 23'1 day of July 2013. MOTION BY: Peterson SECONDED BY: Williams AYES: All ayes BUSINESS ITEM 6. Report of Management Company Nawrocki noted the occupancy for the south building has fluctuated over the last few months, and is back down to 82 %. He wondered why. Frost explained there are 5 units currently vacant but 2 of them will be occupied August 1" and the other 3 are being processed for move - ins. She said there is also a waiting list for the south building, which they haven't had for quite a while. Laura Frost introduced Heidi Mindestrom, the new site manager. Frost then went on to inform the members about the power outage they experienced after the Friday, June 21st storm. She told members that Tom, the maintenance person, and Heidi both came in and helped over the weekend to get the back -up generator running so there was some power in the building until it was restored 3 days later. She said this effort kept the elevator operating. They also assisted residents as power to outlets varied from apartment to apartment. Frost then reported that elevator #2 has been out of service for about a month. The parts for this elevator are obsolete and a new software upgrade had to be ordered. They just got word today that it came in and they have scheduled the work for the first week of August. The elevator company is hiring a specialist to install the upgrade. HRA Minutes Page 3 July 23, 2013 Shirley, a south side resident, said residents aren't informed about these types of things. She also stated that no one checked on the residents while the power was out. She said some people had no power at all, and some had partial power. Diehrn asked if there is a community bulletin board. Residents said there is, but nothing was posted to let residents know the estimated time frame until this week. Diehm asked that management use the bulletin board to inform residents on various issues as they arise. Rheta Nelsen told members that residents didn't know that some of the outlets worked. It was discovered that each apartment should have a couple outlets that work during the use of the back -up generator, but that each apartment is different. She suggested that the outlets be marked for future outages if the same outlets would be the ones to have power. Clark will locate the plans for the building and look into whether a determination can be made to identify outlets designated to work during an emergency. Leann - #424 -told members that some residents didn't notify management that they had no power, and therefore, it is hard for management to help them. She wanted to go on record that Tom was on site all weekend and worked very hard to keep things ruining and assist residents wherever he could. She thought he did a tremendous job. Len Larson- #216- currently lives on the south side but is moving to the north side. He said the apartments lack amenities and that could be affecting the occupancy rates. 7. Resident Council Minutes The minutes were included in the agenda packets. Rheta reported that the current President Pro - tem is on vacation and that elections will be held August 7`" to fill the vacancies. 8. Citizens Forum Barb Camp said she wrote a thank you note to the Columbia Heights Fire Dept. for all their help. Kathy asked if the smoking shelter could be moved out further. It was noted that it is anchored to a concrete pad and to move it would be a project. Even if it were moved a couple of feet, it won't resolve all the issues totally. It cannot be located in a spot that will make everyone happy. Lyn Miner said people stay out there too late and the noise disturbs others. Laura Frost stated they will put something in the newsletter that will remind residents that they need to be respectful of others and not light up until they are in the shelter and to keep voices down. Adam- #611 - people who complain about people smoking outside the shelter don't realize that sometimes it's too hot in the shelter, or it leaks in the rain, and that some of the people don't get along, so that is why they are smoking in numerous places on the grounds. HR Minutes Page 4 July 23, 2013 9. AEON Update Clark reported that the Voluntary Conversion process has been awful and HUD doesn't seem to have an established policy for handling, reviewing, and approving the requests. The application was submitted in May and they are still reviewing it. He told members he hopes another conference call will take place this week to answer any concerns they have. He is still hoping for a closing by year end. He said that AEON has a lot invested in this, so they also want the closing to take place soon. Clark stated that AEON will roll out a Re -hab plan in the next week or so complete with specs and prices. They will then hold one or two community meetings with the residents at Parkview to explain the plans. They will then break out a piece of the plan to do with the Modernization Funds. Clark told members the 1 s` floor modernization may be delayed as 5 units on the north side will need to be made ADA compliant in the near future, and this would mean remodeling them twice. Clark said the details of their plan will be brought to the Board at a special meeting in September. 10. Other Business There was no other business. Dielnn stated the next regular meeting is scheduled for Tuesday, October 22, 2013, at Parkview Villa. The meeting was adjourned at 7:40 pm. Respectfully submitted, AN (A-"ct-� Shelley Hanson Secretary COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) Meeting of: October 22, 2013 AGENDA SECTION: Consent Agenda ORIGINATING EXECUTIVE NO: 5 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Financial Report and Payment of Bills BY: Scott Clark BY: — Resolution 2013 -8 DATE: October 22, 2013 BACKGROUND: A copy of the Financial Reports for the months of July, August, and September 2013 are attached. RECOMMENDATION: Management staff will be available to answer specific questions. If the report is satisfactorily complete, we recommend the Board take affirmative action to receive the Financial Report and approve the payment of bills. RECOMMENDED MOTION: MOTION: Move to waive the reading of Resolution 2013 -08, there being ample copies available to the public. Motion: Move to approve Resolution 2013 -08 Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of July, August and September 2013. zu'i s -uu ana rinanciai HRA ACTION: HRA RESOLUTION 2013 -8 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JULY, AUGUST AND SEPTEMBER 2013 AND PAYMENT OF BILLS FOR THE MONTHS OF JULY, AUGUST AND SEPTEMBER, 2013. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the HRA to examine the statement and treasurer's vouchers or bills and if correct, to approve them by resolution and enter the resolution in its records; and WHEREAS, the financial statement for the months of July, August, and September 2013 and the list of bills for the months of July, August and September 2013 are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that it has examined the attached financial statements and list of bills, which are attached hereto and made a part hereof, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the list of bills as presented in writing are approved for payment out of proper funds; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 22nd day of October. 2013 MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary JULY Km 213.46340 Parkvlew Villa South City of Columbia Heights I IRA Expenditures for Fiscal Year 2013- Parkvlew Villa North & South 27,524 3,932 47,186 as of July, 2013 Supplies 3,759 367 Account Object Code Classification Actual YTD Actual MTD Budget Balance 203.46330 Parkvlew Villa North 110,834 Capital O tl y 0 0 Personnel Services 61,264 8,752 105,028 43,764 Supplies 6,371 749 21,550 15,179 Other Services & Charges 166,042 27,547 376,547 210,505 C pllal Outlays 1.840 - 92,200 90.360 Totals 203.46330 235,517 37,048 596,326 359,808 213.46340 Parkvlew Villa South Personnel Services 27,524 3,932 47,186 19,662 Supplies 3,759 367 10,675 6,916 Other Services & Charges 75,406 13,697 186,240 110,834 Capital O tl y 0 0 35.000 35000 Totals 213.46340 106,689 17,996 279,101 172,412 Parlcview Villa South Financial Statement Overview July 2013 Revenue: Occupancy for the moutli of July was 89 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects lower occupancy Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) Legal Expenses were under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were slightly over budget (unfavorable); however, this reflects some quarterly billing Electric was over budget (favorable) and reflects June billing Gas was under budget (favorable) and reflects a quarterly billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was over budget (unfavorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor Supplies was slightly over budget (unfavorable) Exterminating Contract was under budget (favorable) p� Q�j Q�j� qN Np� q q N NNN�NN NN��1b1 N fQ11 W c a i O q � � O N ^ n. a q w v 3 ~ �yq1 1rv�rv1 T Q D N_ C N d O N N �^ Cw a ` O .�i T c 3 N a N j S 111 N g 10 n d 'v 3 'm °'. '° '^' a X1`1 q p1- C %' = m �c�wR m o 6�'a �°.� " Q _nran3 m� g K C N H x m H A � a1q J f q W O � N W N P O O W N O m ONi O J N�N (gi(nn W NpWp11J �AOAgN WO1N�o p CoPONJ�L�b APO ^q1V pYW�� �OmmWIwJ J�OJNO 11I� gA00 GPOW +NOq OWOAO L� NwW0 p N N +Z'Np NIjZ tOTNWOON °m ° °o °o °o $mp Dwp °oDJ a °nD NwNp��u woo q po N � T IpJ ON (yn N WW A N W W J O J A m O W> Nn N w A 0 N< O J W N ( I yp N+ }wjN 7mJO aq PIJ bNNOWJ O+ W �b A pw ONIAO W+1Ow0 A. 2- W+0+ VJi tOOwO N 1J P W N+p� N J A r J J N w fJ N U1�� W W N NJNNNw� NNO(ONNpN Aw0�0 A AWOi OVO I� J J O W W O N O w d + D O 4W W + q W p q O O N A N O N O O T+ N p 0 O O N O O O O O O O O O O W c a i O q � � O N ^ n. a q w v y y m m mNm �m �i m N m NNN.N . N mN ....N Um c$ p Q ep mop o m q OmmN bAm m NNJQNiNNOtO JNW OIWN z � o -nI NNN � O O AAp J AN Ll yy N ONO m J � +vpmNOOmImW H 000 O AO N mW yW O J O N J J A N N N O J W� O J J N W O O 0 0 a d 0 �JJD 1 a O (n ON O W O W om a o $� O °�`° ;n�OSoAi�Om RmmO4�rn�3�d`p1' 2iwN o Y u � aaa�Aan oann,Zoo��y �' mCNI � O cq, 'ar O m2 ng ' Rm'a�ONg Ring 9 � w R w 0000 0o m oo`� °o ,°.�oi°m oo oNNI of o00mi OZ N Omi'NOJOmO WJ �IW� O N OOJ OD W JN OOm10NOOW NJ �I GI -�NNw O W NmJ J O �p i W O lJ0 INIi J W W �y J fAJN22 0AA�000fAJ N (WJ A W �O NN ON popi� m NNN O O AAp J AN Ll yy N ONO m J � +vpmNOOmImW H 000 O AO N mW yW O J O N J J A N N N O J W� O J J N W O O 0 0 0 �JJD OW N � O AImOOO�O n1,JJ O�w ,dp�0 Jm � � 000 JO OI JWON(WJN�JWJ Ow0 oNNI of o00mi OZ N Omi'NOJOmO WJ �IW� O N OOJ OD W JN OOm10NOOW NJ �I GI -�NNw O W NmJ J O �p i W O lJ0 INIi J W W �y J fAJN22 0AA�000fAJ N (WJ A W �O NN ON p v WJ N Oy) NN WWW OT �W WHICH: �4� y (p NJNA ON A 11 N A m N N ...... M W W N N O O O O W Q O N J N w O O O O (Wig O N N O O 'O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 O 0 9 U g a < N ♦/ 0 N a m N J y yy N N W N . .� m N iD N J Nm � N m W W W WO O O AO N O O i 0 0 0 'mOJI � OJ N N m m ' �p T TN J J N NNJN�p�N ?OWtWO ( (O , ,�J�W WHICH: �4� y (p NJNA ON A 11 N A m N N ...... M W W N N O O O O W Q O N J N w O O O O (Wig O N N O O 'O O O O O O O O O O O O 0 0 0 0 0 0 0 0 0 0 O 0 9 U g a < N ♦/ 0 N a m N 0 9 U g a < N ♦/ 0 N a m N N ZZZ ?ZZ � D D D D D D �oOO �p app NWW pp qOW OW W041 p N � b �p W � ONION JOON -` O o10 W ^I L'$ D N viiT6HoN 0- Fn� r 111 A�AAA$' NO ur N N N N N O O IVO O pN� O fll Z D 'n a Q 0 N N O � O N Z Z ZZZ ?ZZ D D D D D D D D i p� OON NNW �I °o moo o °Oo AON U1NW tJ IJ O W r O ZZ2 7 DZz DDD DD °1000 000 1 A O i O OI O O w 9 cu "V `a D�(pF ° O N y w 3 0 � � 3 c� y m A m W E ®2/ ,2 \\ (20 \ ; }f \ ^ , ! � (� § ( � \) 2 !,, ° r: A ) q[S A;; § � � \ \ \ %� \ § \ \\ !\;!§ ;; Parkvlew Villa South (166) Balance July 2013 Books = Accrual Jul -13 Assets 20200 Accounts Payable 6,685.17 95,841.27 6,190.99 10100 Cash Balance 8,477.42 - 279.00 10200 Petty Cash 7,200.83 22200 Accrued PILOT 729,970.36 552.00 10400 Investments 29,106.41 Total Liabilities 5,772.11 11300 Rent Receivable 802,886.96 25300 Fund Balance 11500 Accounts Receivable 130.63 802,686.96 Total Fund Balance 831,993.37 Total Liabilities and Fund Balance Total Assets Liabilities 20200 Accounts Payable 6,685.17 6,190.99 20210 Accrued Other Expenses 8,477.42 22000 Deposits 7,200.83 22200 Accrued PILOT 22210 Revenue Collected in Advance 552.00 29,106.41 Total Liabilities Fund Balance 802,886.96 25300 Fund Balance 802,686.96 Total Fund Balance Total Liabilities and Fund Balance 831,993.37 Parkview Villa -South (166) Income Statement For The Period Ending July 2013 Books = Accrual Month to Date % Year to Date Revenue 77.54 0.30% 318.59 0.19% 36220 -46340 Gen. Government Rents 25,240.97 96.29% 164,312.50 96.75% 36225 -46340 Nondwelling Rents 489.68 1.87% 3,274.68 1.93% 36290 -96340 Other Miscellaneous Revenue 482.41 1.84% 2,243.11 1.32% 39120 -46340 Recovery Damage City - 0.00% - 0.00% Total Revenue 26,213.06 100.000/0 169,830.29 100.00% Expenses Personal Services 1000 -46340 Accrued Salaries 3,932.00 15.00% 27,524.00 16.21% Total Personal Services 3,932.00 15.00% 27,524.00 16.21% Supplies 2000 -46340 Office Supplies 77.54 0.30% 318.59 0.19% 0.00 0.00% 1,433.32 0.84% 2010 -46340 Minor Equipment 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 289.54 1.10% 2,007.37 1.18% 367.08 1.40% 3,759.28 2.210/. Total Supplies Other Services & Charges 0.00 0.00% 52.50 0.03% 3040 -46340 Legal Fees 3050 -46340 Expert & Professional Services 0.00 0.00% 0.00 0.00% 3060 -46340 Management Services 2,126.00 8.11% 14,882.00 8.76% 3100 -46340 Protective Services 149.42 0.57% 979.34 0.58% 3210 -46340 Telephone & Telegraph 163.14 0.62% 1,096.03 0.65% 3430 -46390 Advertising Other 0.00 0.00% 160.28 0.09% 3600 -46340 Insurance & Bonds 841.25 3.21% 5,929.64 3.49% 3810 -46340 Electric 2,736.64 10.44% 13,848.37 8.15% 1,026.68 3.92% 1,196.70 0.70% 3820 -46340 Water 326.60 1.25% 9,173.13 5.40% 3830 -46340 Gas 0.00 0.00% 66.04 0.04% 3840 -96340 Refuse 508.08 1.94% 952.71 0.56% 3850 -46340 Sewer 4000 -46340 Repair & Maint. Services 4,691.20 17.90% 18,241.67 10.74% 80.00 0.31% 545.00 0.32% 4100 -46340 Rents & Leases 4300 -46340 Miscellaneous Charges 0.00 0.00% 181.59 0.11% 4315 -46340 PILOT 1,028.69 3.92% 7,200.83 4.24% 0.00 0.00% 558.62 0.33% 4390 -46340 Taxes & Licenses 4500 -46340 Administrative Expenses 12.63 0.05% 297,27 0.18% 4850 -46340 Interest on Deposits 6.89 0.03% 44.54 0.03% Total Other services & Charges 13,697.22 52.250% 75,406.26 44.40% Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00 % 0.00 0.000/0 0.00 0.000/0 17,996.30 68.65% 106,689.54 62.82% 8,216.76 31.35% 63,140.75 37.18% Paikvfew Villa South (166) Cash Flow Statement Period * Ady 2013 Month to Date Revenue 36220 Gen. Government Rents 25,240.97 36225 Nondwelling Rents 489.68 36290 Other Miscellaneous Revenue 482.41 39120 Recovery Damage City Property 0.00 Total Revenue 26,213.06 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 3,932.00 Supplies 2000 Office Supplies 77.54 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 289.54 2175 Food Supplies 0.00 Total Supplies 367.08 Other Services & Charges 3040 Legal Fees 0.00 3060 Management Services 2,126.00 3100 Protective Services 149.42 3210 Telephone & Telegraph 163.14 3430 Advertising Other 0100 3600 Insurance & Bonds 841.25 3810 Electric 2,736.64 3820 Water 1,026.68 3830 Gas 326.60 3840 Refuse 0.00 3850 Sewer 508.08 4000 Repair & Maint. Services 4,691.20 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 80.00 4300 Miscellaneous Charges 0.00 4315 PILOT 1,028.69 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 12.63 4850 Interest on Deposits 6.89 Total Other Services & Charges 13,697.22 Total Expenses 17,996.30 Parkvlew villa south (166) Cash Flow Statement Period = July 2078 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 8,216.76 0.00 0.00 (1,861.00) (70.00) 0.00 (716.65) 841.25 104.29 1,028.69 109.00 (564.42) 7,652.34 End Cash Difference 88,188.93 95,841.27 7,652.34 279.00 279.00 - 729,970.36 729,970.36 - 818,438.29 826,090.63 7,652.34 Page 6 of 7 8/14/2013 3:04 PM Parkvlew villa South (166) General Ledger period = July 2013 Cook = Accrual; Tree = ysi_tb Pruperf<y Rate d*ersn n /BescfiptlBn ' '(yantrol Reference:: bebil "� ,Credo: "'BBIaBne 1iQmarks 1000-46340 Accrued Salaries 23,592.00 = Beginning Balance = 166 7/31/2013 :PostRecurring Recurring 3- 168178 RC 3,932.00 0.00 27,524.00 R/C CHC PR Mgmt Fee Net Change= 3,932.00 27,524.00 = Ending Balance = 2000-46340 Office Supplies 241.05 = Beginning Balance = 166 6/20/2013 Office Depot (off18804) P- 339768 6.6239E 1-11 22.36 0.00 263.41 copy paper /fan 166 7/23/2013 CommonBond Housing (chc) P- 342262 06128/13 -07/23 23.74 0.00 287.15 164120 9empler first aid /sp 166 7/30/2013 Commoneond Housing (chc) P- 343132 07/24/13 -07/30 3144 0.00 318.59 179677 first imprssn bus ca Net Change =77.54 318.59 = Ending Balance = 2010 -46340 Minor Equipment 1,433.32 = Beginning Balance = Net Change =0.00 1,433.32 = Ending Balance = 2171 -46340 General Supplies 1,717.83 = Beginning Balance = 166 6/19/2013 HD Supply Facilities Maintenance, P- 339097 9123033180 40.37 0.00 1,758.20 malnt supplies 166 6/24/2013 Home Depot Credit Se rvlces (how P- 342079 fc11005000076 6.20 0.00 1,764.40 late fee 06/24/13 166 6/26/2013 HD Supply Facilities Maintenance, P- 339628 9123184450 40.23 0.00 1,804.63 magic eraser /tb cleaner /tra 166 6/28/2013 Buckeye Cleaning Centers (bucke P- 340672 750403 60.97 0.00 1,865.60 grn seal ecosoft /crt foam hr 166 6/28/2013 HD Supply Facilities Maintenance, P- 339624 9123242299 54.19 0.00 1,919.79 fan /bulbs /vacuum pts /grab 166 713/2013 IID Supply Facilities Maintenance, P- 341050 9123342831 11.90 0.00 1,931.69 toilet seatcovers 166 7110/2013 HD Supply Facilities Maintenance, P- 341606 9123450976 42.76 0.00 1,974A5 sunk alrms /ovn Ihrnmr /mist 166 7/23/2013 HD Supply Facilities Maintenance, P- 342959 9123735777 32.92 0.00 2,007.37 bk elmnt;shwr hs;plstc corn Net Change= 289.54 2,007.37 = Ending Balance = 3040 -46340 Legal Fees 52.50 = Beginning Balance = Net Change =0.00 52,50 = Ending Balance = 3060 -46340 Management Services 12,756.00 = Beginning Balance = 166 7130/2013 Common Bond Housing (chc) P- 343132 07/24/13 -07/30 6,058.00 0.00 18,814.00 180027 mgmt fees 7/13 166 7/31/2013 :PostRecurring Recurring 3- 168178 RC 0.00 3,932.00 14,882.00 R/C CHC PR Mgmt Fee Net Change= 21126.00 14,882.00 = Ending Balance = 3100 -46340 Security Contract 829.92 = Beginning Balance = 166 7/12/2013 Simplex Grinnell (simp) P- 340675 69085619 149.42 0.00 979.34 fire system rpr 6/25/13 Net Change= 149.42 979.34 = Ending Balance = 3210 -46340 Telephone & Telegraph 932.89 = Beginning Balance = 166 6/30/2013 Popp.com (Popp) P- 341543 992117384 100.57 0.00 1,033.46 phone 07/13 166 7/1/2013 Level One (level P- 339527 0338239IN 34.38 0.00 1,067.84 rate plan 7/13 166 7/2/2013 Comcast(comc3422) P- 341457 877210505019E 28.19 0.00 1,096.03 Internet 07 /11- 08/10/13 Net Change= 163.14 1,096.03 = Ending Balance = 3430 -46340 Advertising Other 160.28 = Beginning Balance = Net Change =0.00 160.28 = Ending Balance = 3600 -46340 Insurance & Bonds 5,088.39 = Beginning Balance = 166 7131/2013 :PostRecurring Recurring 3- 168178 RC 841.25 0.00 5,929.64 C of Columbia Heights Ins P Net Change= 841.25 5,929.64 = Ending Balance = 3810 -46340 Electric 11,111.73 = Beginning Balance = 166 7/11/2013 Xcel Energy (xcel) P- 342183 5150441553 07 2,736.64 0.00 13,848.37 electric 6 /5- 7/6/13 Net Change = 2,736.64 13,848.37 = Ending Balance = 3820 -46340 Water 170.02 = Beginning Balance = 166 7/8/2013 City of Columbia Heights (colu) P- 341389 31802650001 0 999.83 0.00 1,169.85 w 03/28- 06/27/13 166 7/8/2013 City of Columbia Heights (colu) P- 341397 3182700001 07. 26.85 0.00 1,196.70 w 03/20- 06/20/13 Net Change= 1,026.68 1,196.70 = Ending Balance = 3830 -46340 Gas 8,846.53 = Beginning Balance = 166 6/22/2013 Lubrication Technologles, Inc. (lot P- 339415 625668 74.00 0.00 8,920.53 fuel 166 6/24/2013 Lubrication Tethering Ins Inc (I nor P- 339417 624814 53.10 0.00 8,973.63 fuel oil 166 7110/2013 CenterPolnt Energy (cent) P-341419 55271324 07/11 199.50 0.00 9,173.13 9 06/05- 07/08/13 Net Change= 326.60 9,173.13 = Ending Balance = Page 6 of 7 Parkview Villa South Bank Reconciliation Report 07/31/2013 5016464 Balance Per Bank Statement as of 0713112013 Outstanding Checks Check dale Check number 06/18/2013 1782 06/18/2013 1786 07/16/2013 1811 07/16/2013 1812 07123/2013 1814 07/30/2013 1822- 07/30/2013 1823 07/30/2013 1824 07130/2013 1825 07/3012013 1826 Less: Outstanding Checks Payee kocl - K.O. Cleaning and Restoration LLC 10011071 - Johnson lubr - Lubrication Technologies Inc Iubr900 - Lubrication Technologies, Inc. allm2138 - All Metro Lawn & Snow, LLC Cho - CommonBond Housing home7 - HD Supply Facilities Maintenance, Ltd home0055 - Home Depot Credit Services multi - Multihousing Credit Control xcel -Xcel Energy Reconciled Bank Balance Balance per GL as of 07131/2013 Reconciled Balance Per GIL Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items : Cleared Checks Dole Tran # 06/26/2013 1787 06/26/2013 1788 06/2512013 1769 06/25/2013 1790 06/25/2013 1791 00/2512013 1792 06/25/2013 1793 07/02/2013 1794 07/0212013 1795 07/02/2013 1796 07/0212013 1797 08/02/2013 99,227.75 Amount 50.00 232,96 53.10 74.00 117.94 23.74 11.90 6.20 80.00 2,736.64 3,386.48 95,841.27 95,841.27 95,841.27 0.00 Notes Amount Date Cleared adam - Adam's Peat Control, Inc. 46.64 07/31/2013 case701 -Case 91.00 07/31/2013 comc3474- Comcast 25.56 07/31/2013 Prat - Frattalone's/Melro Ace 15.58 07131/2013 Ibpm - LBP Mechanical, Inc 2,450.50. 07131/2013 Popp - Popp.com 100.42 07/31/2013 xcel - Xcel Energy 1,850.84. 07/31/2013 cbc - CommonBond Communities 40.89 07/31/2013 cent - CenhuPoint Energy - 279.42 07/31/2013 Cho - CommonBond Housing 6,058.00 07/31/2013 home7 - HD Supply Facilities Maintenance, Ltd. 131.18 07/31/2013 Parkview Villa South 08/02/2013 Bank Reconciliation Report 07/31/2013 5016464 Cleared Checks Date Tran # - Notes Amount Date Cleared 07/02/2013 1798 kocl - K.O. Cleaning and Restoration LLC 250.00 07/31/2013 07/0212013 1700 we114 - Wellington Security Systems 58.51 07/31/2013 07109/2013 1800 gardl086 - Gardner Plumbing, LLC 424.00 07/31/2013 07/09/2013 1801 homo7 - HD Supply Facilities Maintenance, Ltd. 807.39 01/31/2013 07/09/2013 1802 oM8804- Office Depot 26.43 07/31/2013 07/16/2013 1803 arbo- Arbor Barber, Inc. 700.00 07/31/2013 07/16/2013 1804 buck8411 - Buckeye Cleaning Centers 60.97 - 07/31/2013 07116/2013 1805 cumm1600- Cummins NPower LLC 1,019.00 - 07/31/2013 07/16/2013 1806 dire - Direct Home Appliance Services 89.00 07131/2013 07/16/2013 1807 gardl086- Gardner Plumbing, LLC 1,390.60 07/31/2013 0711612013 1808 homey - HD Supply Facilities Maintenance, Ltd. 40.37 0713112013 07/1612013 1809 Ibpm - LBP Mechanical, Inc 277.26 07/31/2013 07/1612013 1810 lave - Level One 34.38 07/312013 07/16/2013 1813 *imp - SImplex Grinnell 149.42 07/31/2013 07/23/2013 1815 colu - City of Columbia Heights 1,534.76 07/31/2013 07/23/2013 1816 comc3422 - Comcast 28.19 07/31/2013 07/23/2013 1817 dire - Direct Home Appliance Services 109.00 07131/2013 07/2312013 1818 home? - HD Supply Facilities Maintenance, I.W. 94.42 07/31/2013 07/23/2013 1819 kone - Kona Inc. 314.50 07/31/2013 07/23/2013 1820 _ offi8804. Office Depot 22.36 07/31/2013 07/23/2013 1821 popp - Popp.com 100.57 07/31/2013 Total Cleared Checks 18,621.06 Cleared Deposits Dale Tran # Notes Amount Dale Cleared 07/05/2013 364 24,412.00 07/31/2013 07/1112013 385 653.00 07/31/2013 07/1112013 387 100.00 07131/2013 07/12/2013 386 284.38 07/31/2013 Total Cleared Deposits 25,449:38 Cleared Other Items Date Tran # Notes Amount Date Cleared 07/05/2013 RC 966770 Returned Item 10006610 - 653.00 07/31/2013 Total Cleared Other Items - 653.00 Date 7/31/13 Page I Primary Account QXXXXX@6464 Enclosures 35 BRA OF COLUMBIA HEIGHTS PARKVIP,W VILLA SOUTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - •••••• C H E C K I N G A C C O U N T S - - -- CHANGE NOTICE EFFECTIVE SEPTEMBER 1, 2013: *CANADIAN CHECK ITEM PROCESSING FEE - $1,000 OR LESS = $5.00, $1,001 OR GREATER = $10.00. *REDEPOSITED RETURN ITEM PER _ $4.00 *AN INTEREST CHARGE F'OR NEGATIVE AVERAGE COLLECTED BALANCE EQUAL TO AN INTEREST RATE OF PRIME PLUS 4t WILL BE APPLIED TO BUSINESS CHECKING ACCOUNTS ON ANALYSIS EACH STMT CYCLE. NORTHEAST PUBLIC FUNDS ACCT Account Number ®XXXXXOo6464 .Previous Balance 93,052.43 3 Deposits/Credits 25,449.38 33 Checks /Debits 19,274.06 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 99,227.75 Number of Images 35 Statement Dates 7/01/13 thru 7/31/13 Days in the Statement Period 31 Average Ledger 102,489 Average Collected 100,537 Deposits and Credits Date Description Amount 7/05 DDA REGULAR DEPOSIT 24,412.00 7/11 DDA REGULAR DEPOSIT 753.00 7112 DDA REGULAR DEPOSIT 284.38 ********' x*** wwww: t* w* w* w * *wwwwwwwww * * * *wwwwwwwwxwww * * ** *wwwwww *ww * ** *www *wwwwww Charges and Debits Date Description Amount 7/10 RETURN ITEM DEBIT 653.00 Checks in serial order Date Checkgf Amount Date Checki{ Amount 7/02 1787 46.64 7/02 1793 1,850.84 7/02 1788 91.00 7/05 1794 40.89 7/08 1789 25.56 7/17 1795 279.42 7/02 1790 15.58 7/05 1796 6,058.00 7/02 1791 2,450,50 7/11 1797 131.18 7/02 1792 100.42 7/17 1798 250.00 * indicates skip in check numbers Date 7/31/13 Page 2 Primary Account @XXXXX @6464 Enclosures 35 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Date Checks in serial order 93,052.43 7/12 106,979.69 7/24 Date Check# Amount Date Check# Amount 7/08 11199 58.51 7/23 1809 277.26 7/15 1800 424.00 7/22 1810 34.38 7/15 1801 807.39 7/24 1813* 149.42 7/16 1802. 26.43 7/29 1815* 1,534.76 7/25 1803 700,00 7/30 1816 28.19 7/22 3.804 60.97 7/29 1617 109.00 7/23 1605 1,019.00 1/29 1818 94.42 7/29 1806 89.00 7/29 1819 314.50 7/23 1.807 1,390.50 7/30 1820 22.36 7/23 1808 40.37 7/30 3.821 100.57 * indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 7/01 93,052.43 7/12 106,979.69 7/24 102,220.55 7/02 88,497.45 7/15 105,748.30 7/25 101,520.55 7/05 106,810.56 '1/16 105,721.87 7/29 99,378,87 7/08 106,71.6.49 - 7/17 105,192.45 7/30 99,227.75 7/10 106,073.49 7/22 105,097.10 7/11 106,695.31 7/23 102,369.97 * * * E N D O F S T A T E M E N T Payment Summary Bank= 166opr AND mm /yy= 07/2013 - 07/2013 AND All checks =Yes AND Include Volds -All Checks Check Post Total Dank Check# Vendor Date Month Amount 166opr - Parkvlew Villa South 1794 cbc - Commo78ond Communities 07/02%2013 07/2013 40.89 166opr - Parkvlew Villa South 1795 cent • CenterPolnt Energy 07/02/2013 07/2013 279.42 166opr - Parkvlew Villa South 1796 cite - Common8ond Housing 07/02/2013 07/2013 6,058.00 166opr - Parkvlew Villa South 1797 home? - HD Supply Facilities Maintenance, Ltd. 07/02/2013 07/2013 131.18 166opr - Parkvlew Villa South 1790 kocl - K.O. Cleaning and Restoration LLC 07102/2013 07/2013 2S0 166opr - Parkvlew Villa South 1799 we114 - Wellington Security Systems 07/0212013 07/2013 58.51 166opr - Parkvlew Villa South 1800 gardl086 - Gardner Plumbing, LLC 07/09/2013 07/2013 424 166opr - Parkvlew Villa South 1801 home? - HD Supply Facilities t4aintenance, Ltd. 07/0912013 07/2013 807.39 166opr - Parkview Villa South 1002 off18804 - Office Depot 07/09/2013 07/2013 26.43 166opr- Parkvlew Villa South 1803 arbo - Arbor Barber, Inc. 07/16/2013 07/2013 700 166opr - Parkvlew Villa South 1804 buck8411 - Buckeye Cleaning Centers 07/16/2013 07/2013 60.97 166opr - Parkvlew Villa South 1805 cumm1600 - Cummins NPower LLC 07/16/2013 07/2013 1,019.00 166opr - Parkvlew Villa South 1806 dire - Direct home Appliance Services 07/16/2013 07/2013 89 166opr - Parkvlew Villa South 1807 garc11086 - Gardner Plumbing, LLC 07/16/2013 07/2013 1,390.50 166opr - Parkvlew Villa South 1808 home? - HD Supply Facilities Maintenance, Ltd. 07/16/2013 07/2013 40.37 166opr - Parkvlew Villa South 1809 Ibpm - LBP Mechanical, Inc 07/16/2013 07/2013 277.26 166opr - Parkvlew Villa South 1810 leve - Level One 07/16/2013 07/2013 34.38 166opr - Parkvew Villa South 1811 lubr - Lubrication Technologies Inc 07/16/2013 07/2013 53.1 166opr- Parkview Villa South 1812 Iubr900 - Lubrication Technologies, Inc. 07/16/2013 07/2013 74 166opr - Parkvlew Villa South 1813 simp - Simplex Grinnell 07/16/2013 07/2013 149.42 166opr - Parkvlew Villa South 1814 allm2138 - All Metro Lawn & Snow, LLC 07/23/2013 07/2013 117.94 166opr • Parkvlew Villa South IBIS colu - City of Columbia Heights 07/23/2013 07/2013 1,534.76 166opr - Parkvlew Villa South 1816 comc3422 - Comcast 07/23/2013 07/2013 28.19 166opr - Parkview Villa South 1817 dire - Direct Home Appliance Services 07/23/2013 07/2013 109 166opr - Parkvlew Villa South 1818 home7 - HD Supply Facilities Maintenance, Ltd. 07/23/2013 07/2013 94.42 166opr - Parkvlew Villa South 1819 kone - Kone Inc. 07/23/2013 07/2013 314.5 166opr - Parkvlew Villa South 1820 of08804 - Office Depot 07/23/2013 07/2013 22.36 166opr - Parkvlew Villa South 1821 Popp - Popp.com 07/23/2013 07/2013 100.57 1666pr - ParkvleW Villa South 1822 cbc - Common8ond Housing 07/30/2013 07/2013 23.74 166opr - Parkvlew Villa South 1823 homo7 - HD Supply Facilities Maintenance, Ltd. 07/30/2013 07/2013 11.9 166opr - Parkvlew Villa South 1824 home9055 - Home Depot Credit Services 07/30/2013 07/2013 6.2 166opr - Parkview Villa South 1825 multi - Multihousing Credit Control 07/30/2013 07/2013 80 166opr - Parkview Villa South 1826 xcel - Xcel Energy 07/30/2013 0712013 2,736.64 17,144.04 8/1412013 3:04 PM Parkview Villa Sent) (166) General Ledger Period = July 2013 Book = Accrual, Tree ysl tb Property "Cote person(Descrlptlon control'; � Reference °'., Reblt_ Cradlt l' Balance Rsmatks ; 3640 -46340 Refuse 66.04 = Beginning Balance = Net Change =0.00 66.04 = Ending Balance = 3850 -46340 Sewer 444.63 = Beginning Balance = 166 7/8/2013 City of Columbia Heights (colu) P- 341389 31802650001 0 508.08 0.00 952.71 s 03/28 - 06/27/13 Net Change = 508.08 952.71 = Ending Balance = 4000 -46340 Repair & Maint. Services 13,550.47 = Beginning Balance = 166 6/26/2013 Arbor Barber, Inc.(arbo) P- 339875 12973 700.00 0.00 14,250.47 tree removal 166 6/30/2013 All Metro Lawn & Snow, LLC (allm P- 341423 2581 117.94 0.00 14,368.41 mow,trim,blow 06/01 -06/2E 166 3117/2013 Gardner Plumbing, LLC (gard108f P- 339376 2625 224.00 0.00 14,592.41 Drain repair Unit 424 03/15 166 5/22/2013 Gardner Plumbing, LLC (gard108f P- 339381 2652 200.00 0.00 14,792.41 repair leak -apt 115 - 5/22/1° 166 6/20/2013 Gardner Plumbing, LLC (gard108f P- 339375 2676 1,390.50 0.00 16,182.91 replace water meters -6/19/ 166 6/25/2013 Direct Home Appliance Services 0 P- 339374 62513166 89.00 0.00 16,271.91 repair coin box on 4th It 166 7/10/2013 Cummins NPower LLC (cumm1601P- 339972 10069560 1,019.00 0.00 17,290.91 annual pm map 05/30-05/3 166 7/12/2013 Direct Home Appliance Services (, P-341956 71213166 109.00 0.00 17,399.91 fix washer 166 7/17/2013 Kone Inc.(kone) P- 341417 221219873 314.50 0.00 17,714.41 elev realm 07 /31/13 166 6/30/2013 LIMP Mechanical, Inc (Ibpm) P- 340731 w18931 277.26 0.00 17,991.67 replace thrmcp106 /24 -07/0 166 6/24/2013 K.O. Cleaning and Restoration LL(P- 338870 1462 250.00 0.00 18,241.67 paint walls unit 217 Net Change= 4,691.20 18,241.67 = Ending Balance = 4100 -46340 Rents & Leases 465.00 = Beginning Balance = 166 6/30/2013 Multlhousing Credit Control (mult:P- 341287 13060396 80.00 0.00 545.00 Residential Screening 06/1: Net Change =80.00 545.00 = Ending Balance = 4300 -46340 Misellaneous Charges 181.59 = Beginning Balance = Net Change =0.00 181.59 = Ending Balance = 4315 -46340 PILOT 6,172.14 = Beginning Balance = 166 7/31/2013 :PostRecurring Recurring 1- 168178 RC 1,028.69 0.00 7,200.83 Anoka Cty Property Tax Acc Net Change= 1,028.69 7,200.63 = Ending Balance = 4390 -46340 Taxes & Licenses 558.62 = Beginning Balance = Net Change =0.00 556.62 = Ending Balance = 4300 -46340 Administrative Expenses 284.64 = Beginning Balance = 166 7/30/2013 Commoneond Housing (chc) P- 343132 07/24/13 -07/30 12.63 0.00 297.27 179832 If crd Lo r 6/14 -7/1 Net Change =12.63 297.27 = Ending Balance = 4650 -46340 Interest on Deposits 37.65 = Beginning Balance = 166 7/31/2013 Sec Dep Interest accrual 3- 168976 G31 6.89 0.00 44.54 Sec Dep interest accrual Net Change =6.89 44.54 = Ending Balance = 21,928.30 3,932.00 Page 7 of 7 Parkview Villa North 0810212013 Bank Reconciliation Report 07/31/2093 5016456 Cleared Checks Date Tran # Notes Amount Date Cleared 07/09/2013 2141 offi8804. Office Depot 58.84 07131/2013 07/16/2013 2142 buck8411 - Buckeye Cleaning Centers 135.72 07131/2013 07/16/2013 2143 cumm1600 - Cummins NPower LLC. 1,063.50 07/31/2013 07/16/2013 2144 home7 - HD Supply Facilities. Maintenance, Ltd 89.86 07/3112013 07/16/2013 2146 kone - Kone Inc. 786.38 07/31/2013 07/16/2013 2147 Ibpm- LSP Mechanical, Inc 1,612.06 07/31/2013 07/16/2013 2148 leve - Level One 76.52 0713112013 07/1612013 2151 sher4110 - Shervrin•Wllllams Co. 298.45 07/31/2013 07/1612013 2152 slmp - Simplax Grinnell 332.58 07131/2013 07/23/2013 2164 clty4054 - City Wide Locksmlthing, Inc. 21.00 07/31/2013 07/23/2013 2155 cote - City of Columbia Heights 6,415,48 07/3112013 07/23/2013 2156 comc3422 - Comcasl 62.74 07131/2013 0712312013 2157 home7 - HD Supply Facilities Maintenance, Ltd.' 210.15 07/31/2013 07/23/2013 2158 kone - Kone Inc. 700.01 07/31/2013 07/23/2013 2159 o#i8804 - Office Depot 49.76 07/31/2013 07123/2.013 2160 Popp - Popp.com 223.84 07/31/2013 07/23/2013 2161 stan0371 - Stanley Access Tecchnologles LLC 190.71 07/31/2013 Total Cleared Checks 32,180.78 Cleared Deposits Date Tran # Notes Amount Dale Cleared 07/05/2013 497 25,475.00 07131/2013 07/11/2013 498 4,132.00 07/31/2013 07/12/2013 499 284.37 07/31/2013 Total Cleared Deposits 29,891.37 Cleared Other Items Date Pan # Notes Amount Date Cleared 07/08/2013 JE 108477 ELoccs Operating Fund receipt 19,836.00 07131/2013 Total Cleared Other Items 19,836.00 Parlcview Villa North Financial Statement Overview July 2013 Revenue: Occupancy for the month of July 2013 was 99% occupied; Rent Revenue was over budget (favorable) for July Total Revenue for July over budget (favorable) Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Computer Equipment, Supplies and Maintenance was over budget (unfavorable) and reflects the cost of computer support Legal Services was under budget (favorable) Misc. Admin Expenses was under budget (favorable) Utilities: Utilities Expenses were under budget (favorable) Fuel Oil was over budget (unfavorable) and reflects one invoice from June Electric was over budget (unfavorable) and reflects June billing Gas was under budget (favorable) and reflects June billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was under budget (favorable) and also reflects quarterly billing Operatinll and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was Linder budget (favorable) Garbage and Trash was over budget (unfavorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is over budget (unfavorable) and reflects cost for restart of elevator #2 after power failure Heating, Cooling Maintenance and Repairs is over budget (unfavorable) and reflects the cost of replacing exhaust fan motor on Boiler Decorating Contract was under budget (favorable) N0A� N 41 N N N W J W W A O W W W O O o 00 O O b N b W Ny � W N N i i� N O pN t app JOJ0000 A +ON N +OJ (O O]O VW JOO m JOON � o j 6f m y o m < m '§'' 3 m N a g� v o w my m a m m m u,�.,G • N �+ JAT pO OWi 0884NWW `686 - iTO W O1 �O A W N884023 O J (WJ W O W 0 0 0 0 N J W � k� N+ N o0 OAO N a '`J J �o 10 w q'J p� N y N kYN ^I N A N N W W W tP �33 ' i OOO kS OAOOOO �J JOJOO N N m�ij PNPOOOOO q ii k N i01� fJ N A O m Wp Wp A N OWN � Wbb00 O�AJON �10'O �0 p00 N p OINO 00 ob O' O A W Np W Nb W OIwNW W(OII+ I'N 41 (J�NA 1IpPAA (WN + N N o O OP+ON OW) NoW W N iJpO yWj W y O A N W O O V W W O J O O O � O NW O +ANJO • N �+ JAT pO OWi 0884NWW `686 - iTO W O1 �O A W N884023 O J (WJ W O W 0 0 0 0 N J W � k� N+ N O OAO �� iTOW10N 'p� '`J W�V COAbZJ00 O�W 10 10 10 �'W+ q'J W ' �33 ' i v kS O N N q o �0 A n N i01� fJ N A O m Wp Wp A N OWN � Wbb00 O�AJON �10'O �0 p00 >VWN NObWWO(T1�0 OINO 00 O' O Np W Nb W OIwNW W(OII+ I'N 41 (J�NA 1IpPAA (WN + N N o iN OP+ON OW) NoW W N iJpO NO O O A N � O NW O +ANJO OJm�O� IXWW fJ (J WO W+WOONOO N(N11i0010 W+� ?W i� N 41 +PITON O +W W+ 000000 } }nl k1 I i! ?N + A + p pyN N ObOJJW S� >N �"'qN iAV W+ pr PJWiOU 0� LLl p, �tN00 �jpObbONOm JWb ANNWWNtOP TAO(N000 'N� a g m O L "W3 O v IT' J W � k� N.i� (. W N N N � pW+ WWNZOO�O+ AWOQ,O+ O�W 10 10 10 �'W+ W ' ' kS O � Np W Nb W OIwNW W(OII+ I'N 41 (J�NA 1IpPAA OW NWT O (ON OON000 iN OP+ON OW) NoW W N iJpO NO O O A O °p o0opo ?W o00 a g m O L "W3 O v IT' QQ.� � mom�m mmmmmmm �'$�c N � O N O J pO� O N N N m N J fmJ (11 f� v JN J O A N W IWIi !1 � v J IIN 4 m b i d v s � 3 1 O � -I NGa A Np Oi A JJ QQ T- 'mA���G1��yv3 � o °�AC qq yG3,A.�mt � O NY03A0001v V'(]ry '-Wadi O (ON V a J IJ N �p O °A1➢ N W W O W A OA O X00, 3ao N � O N O J pO� O N N N m N J fmJ (11 f� v JN J O A N W IWIi !1 � v J IIN 4 m b 4 NAM A � �(WJ °iaA� +IOlimo (Jib W o o W O AWOO W � A!OJ N1,00 !OmNO�� OWON NO tW° NNOObOPNJY pp w o W OZ p o d O W O D � W O O J V 0 O W O O ��pp a m O N J W yy�� OO11 �mm0 ON pop O��OAOn O W N O O N W N� A O J O A JW O b NN NN N oOwo AW(n NfJ� OiOA NO b �Da00(m°d10Ab0 (n a N O N W N J W QmW +N WN W bJfO1JJWOr V1WmW O W(PA NN 10 OmON�mm m b q� W O A A WW W O T O +AO> 00� -' OU�mON�O�ON v W A IT W N m W J N o N o W A NA N m W W W O m w v W v F � a ° O z u. J J v N -I NGa A Np Oi A JJ A � m N O O (ON V a J IJ N �p O °A1➢ N W W O W A OA O 4 NAM A � �(WJ °iaA� +IOlimo (Jib W o o W O AWOO W � A!OJ N1,00 !OmNO�� OWON NO tW° NNOObOPNJY pp w o W OZ p o d O W O D � W O O J V 0 O W O O ��pp a m O N J W yy�� OO11 �mm0 ON pop O��OAOn O W N O O N W N� A O J O A JW O b NN NN N oOwo AW(n NfJ� OiOA NO b �Da00(m°d10Ab0 (n a N O N W N J W QmW +N WN W bJfO1JJWOr V1WmW O W(PA NN 10 OmON�mm m b q� W O A A WW W O T O +AO> 00� -' OU�mON�O�ON v W A IT W N m W J N o N o W A NA N m W W W O m w v W v F � a ° O z u. J J v N A m m� m D O R 0 v W o ml I wl� loo °� wlm° °1 tA0 of °o 0000 °ol °oo �GI Ao Din ,iyiimo (p O O N Ll W O Z ZZZZ �ZZ D DDaD DDD Fy�i NN N + W W N ON1 N ONi om O 1n 0 J OJNON JOON °o p 0 q 0 �'�'Dn Er 7 9 V z --a nn Nov s y JS Fl 2 �m v o°1 mo FOj o. 3 � T 1D 3 tt NmTbmd a N¢ � a go hH � g g a A m m� m D O R 0 v W o ml I wl� loo °� wlm° °1 tA0 of °o 0000 °ol °oo �GI Ao Din ,iyiimo (p O O N Ll W O Z ZZZZ �ZZ D DDaD DDD Fy�i NN N + W o (.1 ON1 N ONi om �4 A 0 0000 m10 °o I m NJ m w o V A J 0000 fnNO ZDzz >�JZ o °o A N N O 1Jmnlm a wv U3 v a II (Q R - ° O z `J 3 v m w C! ;;_ 7 ;zzz ;; )■(§ .. ) 4554) >)§ § ] )§ ! :; ®§!aE b \ } \ ( � m ` r !(!2N ! \\\\\ ^ �) ®( �[ L4 \ > �z ;; S g ; ; ; 7 „ ; , [� [ ! )� / ; ;n ; , ! C! UU {Zo : E ; ) ^k} ;;_ 7 ;zzz ;; )■(§ .. (z 4554) >)§ UU {Zo : E ; ) ^k} )§ ®§!aE b \ } \ )))/ §; �[ L4 \ > �z ;; S g ; ; ; 7 „ ; , [� [ ! )� / ; ;n ; Parkview Villa -North (165) Balance Sheet July 2013 Books = Accrual May -13 Assets 37,318.69 10100 Cash Balance 871.00 10200 Petty Cash 891,214.11 10400 Investments 2,898.68 11300 Rent Receivable 208.12 11500 Accounts Receivable 0.00 13200 Due From Other Government Units 932,510.60 Total Assets Liabilities 14,338.13 20200 Accounts Payable 12,192.25 20210 Accrued Other Expenses 551.74 20220 Due to Resident Council 17,960.45 22000 Deposits 14,190.05 22200 Accrued PILOT 666.60 22210 Revenue Collected in Advance 59,899.22 Total Liabilities Fund Balance 872,611.38 25300 Fund Balance 872,611.38 Total Fund Balance 932,510.60 Total Liabilities and Fund Balance Paikuew Villa -North (165) Income Statement For The Periatl Ending July 2013 Books = Accrual 8/14/2013 3:02 PM Expenses Personal services 100046330 Actru al Salaries 8,252.00 Month to Date % Year to Data 92a Revenue 12.19% 61,264.00 24.53 9/o Supplies 3316046330 Federal Grant 19,836.00 38.96% 31,286.91 12.53% 36220 -46330 Gen. Government Rents 29,295.00 58.52% 210,769.00 84.40% 3622546330 Nordwelling Rents 363.00 0,71% 2,904.00 I.IG% 3629046330 Other Miscellaneous Revenue 096.37 1.76% 4,646.86 1.86% 3912046330 Recovery Damage City Property 25.00 0.05% 130.00 0.05% Total Revenue 50,915.37 100.00-A, 249,236.)] 100.00% Expenses Personal services 100046330 Actru al Salaries 8,252.00 17.19% 61,264.00 24.53% Total Personal Services 8,252.00 12.19% 61,264.00 24.53 9/o Supplies 200046330 Office Supplies 104.94 0.21% 1,052.11 0.42% 2010 -46330 Minor Equipment 0.00 0.00% 615.13 0.2501ig 216046330 Maint. &ConstruR Materials 392.23 0.77% 3,641.04 1.46% 212146330 General5upplles 251.24 0.49% 11062.84 0.43% Tota15upplies 249.41 1.420/0 6,321.12 2.55% Other Services & Charges 304046330 Legal Fees 0.00 0.00% 3,240.95 1.500. 305046330 Expert and Professional Services 0.00 0100% 0.00 0.00% 306046330 Management Services 4,272.00 9.32% 33,404.00 13.36% 310046330 Protective Services 332.58 0.65% 2,428.42 0.99% 321046330 Telephone & Telegraph 363.10 0J1% 2,449.28 0.98% 3430 -46330 Mlvettising Other 0.00 0.00% 65.00 0.03% 360046330 lesuance &Heads 1,241.25 3.42% 12,262.64 4.91% 38/046330 Electric 5,642.49 11.0% 23,328.28 9.36% 382046330 Water 1,645.96 3.23% 3,886.24 1.569% 3830 -46330 Gas 852.54 1.68% 23,416.14 9.36% 384046330 Refuse 3,253.82 7,37% 2,419.20 2.97% 385046330 Sewer 1,042.55 2.05020 2,112.59 0.85% 400046330 assign &Maim. Services 5,315.16 10.44% 33,582.51 13,45% 410046330 Rents &Leases age 0.00% 552.31 0.22% 430046330 Miscellaneous Charges 21.00 0.04% 21.00 0.01% 431546330 PILOT 2,022.15 3.98% 14,735.21 5.90% 4390 -46330 Taxes & licenses 0.00 0.00% 1,243.38 0150% 450046330 Atlministrative Expenses 12.62 0.02% 1,180.18 0.47% 485046330 Interest on Deposits 13.98 0.03% 98.29 0.04% Tote l Other Services &Charges 22,546.25 54.10% 166,042.12 66.49% Page 2 of 9 8/1412013 3:02 PM Capital Outlay 512046330 BuIUM &Improvements 0.00 0.00 °0 1,039.76 0.74% Total Capital Outlay 0.00 0.00% 1,839.76 0.74 %0 Total Expense 37,048.16 72,76% 235,517.05 94.31% Excess (Deficit) Revenue over Expense 13,867.21 2734% 14,219.72 5.69% Page 3 of 9 PFMxreinrAM -NOtgl 065) Cash Flow Statement Peeod Revenue 33160 Federal Grant 36220 Gen. Government Rents 36225 handwriting Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Expenses Personnel Services 1000 Accrued Salirles Total Personnel Servkes supplles 2000 Office Supplies 2010 Minor Equipment 2160 plains. &Construct Materials 2121 General Supplies 2280 Vehicle Parts Total Supplies Other Servkes & Charges 3040 Legal Fees 3050 &pert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 AOvertising Other 3600 Insurance & Bonds 31110 Electric 3020 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Malnt. Services 4050 Garage, Labor Boo. 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Adminlslrative Expenses 4850 Interest on Deposits 5120 Buliding & Imp rovemrim Total Other Services & Charges Total Expenses Excess(DeRCit) Revenue over Expenses Month to Date 19,836.00 29,795.00 363.00 896.37 25.00 50,915.3) 8,)52.00 8,752.00 104.94 0.00 0.00 644.47 0.00 )49.41 0.00 0.00 4,272.00 332.58 363.10 0.00 1,)41.75 5,60.49 1,615.96 857.54 3,753.87 1,042.55 5,315.16 0.00 0.00 21.00 2,027.15 0.00 12.62 13.98 0.00 2),546.75 37,048.16 13,86).21 Pago 4 019 8/14/2013 3:02 PM W,0rier 1d la Nn" 1' (165) Cash Flow Statement Peoea = �:dy 2u 13 hex = m:r�,ml Adjustments 10200 Petty Cash 104001nyestments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due Fran Other Government Units 15510 Prepaid insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 0.00 0.00 39.69 4.00 0.00 0.00 - 1,125.66 1,291.75 - 490.33 2,022.15 52.80 1,419.22 15,286.43 Beg Cash End Cash Difference 22,032.26 32,318.69 15,286.43 821.00 821.00 891,214.11 691,214.11 914,112.32 929,403.60 15,286.43 Page 5 of 9 8/14/2013 3:02 PM Parkview Villa North (165) General Ledger Period = Jul 2013 Book = Accrual; Tree = ysi_tb Propert Date Person/ Description Control Reference Debit Credit Balance Remarks 1000 -46330 Accrued Salaries _ 52,512.00 = Beginning Balance = 165 7/31/2013 Accrued Salaries 3- 168177 RC 8,752.00 0.00 61,264.00 R/C CHC PR Mgmt Fee Net Change = 8,752.00 61,264.00 = Ending Balance = 2000 -46330 Office Supplies 947.17 = Beginning Balance = 165 6/20/2013 Office Depot (off18804) P- 339768 6.6239E +11 49.76 0.00 996.93 copy paper /(an 165 7/23/2013 Commom3ond Housing (chc) P- 342261 06/28/13 -07/23 23.74 0.00 1,020.67 164119 gempler first aid, 165 7/30/2013 CommonBond Housing (chc) P- 343123 07/24/13 -07/30 31.44 0.00 1,052.11 179676 first imprssn bus Net Change= 104.94 1,052.11 = Ending Balance = 2160 -46330 Maintenance Supplies 31248.31 = Beginning Balance = 165 6/19/2013 HD Supply Facilities Maintenance, LU P- 339097 9123033180 89.86 0.00 3,338.17 maint supplies 165 6/24/2013 Home Depot Credit Services (home9l P- 342079 fch005000076 13.80 0.00 3,351.97 late fee 06/24/13 165 6/28/2013 HD Supply Facilities Maintenance, Lot P- 339624 9123242299 120.62 0.00 3,472.59 fan /bulbs /vacuum pts /9r 165 7/10/2013 HD Supply Facilities Mal ntenance, Ltr P- 341606 9123450976 95.18 0.00 3,567.77 sank alrms /ovn thrmtr /m 165 7/23/2013 IID Supply Facilities Maintenance, U( P-342959 9123735777 73.27 0.00 3,641.04 bk elmnp shwr hs; plstc n Net Change= 392.73 3,641.04 = Ending Balance = 2171 -46330 General Supplies 811.10 = Beginning Balance = 165 6/26/2013 HD Supply Facilities Maintenance, LU P- 339628 9123184450 89.53 0.00 900.63 magic eraser /tb cleaner /' 165 6/28/2013 Buckeye Cleaning Centers (buck8411 P- 340672 750403 135.72 0.00 1,036.35 gin seal ecosoft /crt foam 165 7/3/2013 HD Supply Facilities Maintenance, LU P- 341050 9123342831 26.49 0.00 1,062.84 toilet seatcovers Net Change = 251.74 1,062.84 = Ending Balance = 3040-46330 Legal Fees 3,740.95 = Beginning Balance = Net Change =0.00 3,740.95 = Ending Balance = 3060 -46330 Management Services 28,632.00 = Beginning Balance = 165 7/30/2013 CommonBand Housing (chc) P- 343123 07/24/13 -07/30 13,524.00 0.00 42,156.00 180026 mgmt fees 7/13 165 7/31/2013 :PostRecurring Monthly recurring ent 1- 168177 RC 0.00 8,752.00 33,404.00 R/C CHIC PR Mgmt Fee Net Change= 4,772.00 33,404.00 = Ending Balance = 3100 -46330 Protective Services 2,145.89 = Beginning Balance = 165 7/12/2013 Simplex Grinnell (simp) P- 340675 69085619 332.58 0.00 2,478.47 fire system rpr 6/25/13 Net Change= 332.58 2,478.47 = Ending Balance = 3210 -46330 Telephone & Telegraph 165 6/30/2013 Popp.com (Popp) 165 7/1/2013 Level One (eve) 165 7/2/2013 Comcast(comc3422) Net Change= 363.10 3430 -46330 Advertising Other Net Change =0.00 P- 341543 992117384 P- 339527 0338239IN P- 341457 8772105050196 3600 -46330 Insurance & Bonds 165 7/31/2013 :PostRecurring Monthly recurring entl- 168177 RC Net Change= 1,741.75 223.84 76.52 62.74 1,741.75 3810 -46330 Electric 165 7/11/2013 Xcel Energy (xcel) P- 342183 5150441553 07, 5,647.49 Net Change= 5,647.49 2,086.68 = Beginning Balance = 0.00 2,310.52 phone 07/13 0.00 2,387.04 rate plan 7/13 0.00 2,449.78 Internet 07/11 - 08/10/13 2,449.78 = Ending Balance = 65.00 = Beginning Balance = 65.00 = Ending Balance = 10,525.89 = Beginning Balance = 0.00 12,267.64 C of Columbia Heights In 12,267.64 = Ending Balance = 17,731.29 = Beginning Balance = 0.00 23,378.78 electric 6 /5- 7/6/13 23,378.78 = Ending Balance = 3820 -46330 Water 21240.76 = Beginning Balance = 165 7/8/2013 City of Columbia Heights (colu) P- 341393 31802450001 0'. 26.75 0.00 2,267.53 w 03/20- 06/20/13 165 7/8/2013 City of Columbia Heights (cola) P- 341395 31802500001 Of 1,592.31 0.00 3,859.84 w 03/20 - 06/20/13 165 7/8/2013 City of Columbia Heights (colu) P- 341455 31802550001 0' 26.90 0.00 3,886.74 w 03/20 - 06/20/13 Net Charge= 1,645.96 3,886.74 = Ending Balance = 3830 -46330 Gas 22,SS8.60 = Beginning Balance = 165 6/22/2013 Lubrication Technologies, Inc. (lubr9(P- 339415 625668 164.70 0.00 22,723.30 fuel 165 6/24/2013 Lubrication Technologies Inc(Iubr) P- 339417 624814 118.12 0.00 22,841.42 fuel oil 165 7/9/2013 CenterPolnt Energy (cent) P- 341489 55199657 07 /0S 574.72 0.00 23,416.14 9 06/04 - 07/05113 Net Change= 857.54 23,416.14 = Ending Balance = 3840 -46330 Refuse 31665.33 = Beginning Balance = 165 7/8/2013 City of Columbia Heights (cola) P- 341393 31802450001 0'. 3,753.87 0.00 7,419.20 t and taxes 03/20- 06/20, Net Change= 3,753.87 7,419.20 = Ending Balance = 3850 -46330 Sewer 1,070.04 = Beginning Balance = 165 7/8/2013 City of Columbia Heights (colu) P- 341393 3180245000101 247.09 0.00 1,317.13 s 03/20 - 06/20/13 165 7/8/2013 City of Columbia Heights (cola) P- 341395 31802500001 (L 795.46 0.00 2,112.59 s 03/20- 06/20/13 Net Chan9e=1,042.55 2,112.59 = Ending Balance 4000 -46330 Repair& Malnt. Services 28,272.35 = Beginning Balance = 165 6/24/2013 K. 0. Cleaning and Restoration LLC (k P- 339426 1461 700.00 0.00 28,972.35 paint, repair, finish floor 165 6/26/2013 Stanley Access Tecchnologles LLC (sl P- 340673 902794840 190.71 0.00 29,163.06 std /try labor 165 6126/2013 Kone Inc. (kone) P- 339384 150862826 786.38 0.00 29,949.44 Insp /restart elevator 06/'. 165 6/26/2013 LBP Mechanical, Inc (Ibpm) P- 339377 w18873 291.25 0.00 30,240.69 air cond maint 06/19 -06, 165 6/26/2013 LBP Mechanical, Inc (Ibpm) P- 339380 w18852 1,320.81 0.00 31,561.50 rplcd fan motor,pulley,b[ 165 6/30/2013 All Metro Lawn & Snow, LLC (allm2l. P- 341423 2581 262.50 0.00 31,824.00 mow,trim,biow 06/01 -06 165 7/10/2013 Cummins NPower LLC (cumm1600) P- 339972 10069560 1,063.50 0.00 32,887.50 annual pm Insp 05/30 -0! 165 7/17/2013 Kone Inc.(kone) P- 341417 221219873 700.01 0.00 33,587.51 elev malnt 07 /31/13 Net Change = 5,315.16 33,587.51 = Ending Balance = 4100 -46330 Rents & Leases 557.31 = Beginning Balance = Net Change =0.00 557.31 = Ending Balance = 4300 -46330 Miscellaneous Charges 0.00 = Beginning Balance = 165 7/5/2013 City Wide Locksmlthbtg, Inc. (city40` -P- 341564 1181 21.00 0.00 21.00 neut. bow dnd Net Change =21.00 21.00 = Ending Balance = 4315-46330 PILOT 12,708.06 = Beginning Balance = 165 7/31/2013 :PostRecurring Monody recurring entl- 168177 RC 2,027.15 0100 14,735.21 Anoka Cry Property Tax I Net Change= 2,027.15 14,735.21 = Ending Balance = 4390-46330 Miscellaneous Charges 1,243.38 = Beginning Balance = Net Change =0.00 1,243.38 = Ending Balance = 4500 -46330 Administrative Expenses 1,167.56 = Beginning Balance = 165 7/30/2013 CommonBond Housing (chc) P- 343123 07/24/13 -07/30 12.62 0.00 1,180.18 179831 If crd mbr 6/14 Net Change =12.62 1,180.18 = Ending Balance = 4850 -46330 Interest on Deposits 84.31 = Beginning Balance = 165 7/31/2013 Sec Delp Interest accrual 3- 168975 GIL 13.98 0.00 98.29 Sec Dep Interest accrual Net Change =13.98 98.29 = Ending Balance = 5120 -46330 Building & Improvement 1,839.76 = Beginning Balance = Net Change =0.00 1,839.76 = Ending Balance = 45,800.16 8,752.00 Parkview Villa North Bank Reconciliation Report 07/3112013 5016456 Balance Per Bank Statement as of 07/3112013 Outstanding Checks Check date Check number Payee 07/10/2013 2145 kocl - K.O. Cleaning and Restoration LLC 07/16/2013 2149 lubr - Lubrication Technologies Inc 07/16/2013 2150 Iubr900 - Lubrication Technologies, Inc. 07/23/2013 2153 alhn2136 - All Metro Lawn & Snow, LLC 07/3012013 2162 chc - CommonBond Housing 07/30/2013 2163 home? - I-ID Supply Facililles Maintenance, Ltd. 07130/2013 2164 home9055 - I1ome Depot Credit Services 07/30/2013 2165 xcel - Xcel Energy Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 0713112013 Reconciled Balance Per GIL Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items : Cleared Checks 44,275,53 Amount 700.00 118.12 164.70 262.50 23.74 26.49 13.80 5,647.49 6,956.64 37,318,69 08/02/2013 37,318.69 37,318.69 0.00 Date Tran # Notes Amount Date Cleared 06/18/2013 2128 10004007 - Sharp 81.70 07/31/2013 06/25/2013 2129 adam- Adam's Pest Control, Inc. 103.82 0713112013 0612512013- 2130 case701 -Case 202.55 07/31/2013 06/25/2013 - 2131 comc3474 - Comcast 56.89 07/31/2013 00/25/2013 2132 kocl - K.O. Cleaning and Restoration LLC 40.00 07/31/2013 06/26/2013 2133 Popp - Popp.com 223.50 07/31/2013 06/25/2013 2134 stan0371- Stanley Access Tecchnologlas LLC 188.71 07/31/2013 06/25/2013 2135 xcel - Xcat Energy 3,799.61 07/31/2013 07/02/2013 2136 cbc- Common6ond Communities - 75.39 07/31/2013 07/02/2013 2137 cent - CenterPoinl Energy 1,134.89 07131/2013 07/02/2013 2138 she CommonBond Housing _ 13,524.00 07/31/2013 0710212013 2139 home? - HD Supply Faoililies Maintenance, Ltd. 291.98 07/3112013 07/02/2013 2140 wa114 - Wallington Security Systems 130.24 07/3112013 Date 7/31/13 Page 1 Primary Account @XXXXX06456 Enclosures 33 ERA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- CHANGE NOTICE EFFECTIVE SEPTEMBER 1, 2013: *CANADIAN CHECK ITEM PROCESSING FEE - $1,000 OR LESS = $5.00, $1,001 OR - GREATER = $10.00. *REDEPOSITED RETURN ITEM FEE = $4.00 *AN INTEREST CHARGE FOR NEGATIVE AVERAGE COLLECTED BALANCE EQUAL TO AN INTEREST RATE OF PRIME PLUS 4% WILL BE APPLIED TO BUSINESS CHECKING ACCOUNTS ON ANALYSIS EACH STMT CYCLE. NORTHEAST PUBLIC FUNDS ACCT Number. of Images 33 Account Number BXXXXX @6456 Statement. Dates 7 /01/13 thru 7 /31/13 Previous Balance 26,728.94 Days in the Statement Period 31 4 Deposits /Credits 49,727.37 Average Ledger 46,736 30 Checks /Debits 32,180.78 Average Collected 44,366 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 44,275.53 Deposits and Credits Date Description Amount 7/05 DDA REGULAR DEPOSIT 25,475.00 7/10 MISC PAY HUD TREAS 310 19,836.00 CR 9101036151 07/10/13 ID i1- 411269646860103 TRACE i1- 101036150683215 7/11 DDA REGULAR DEPOSIT 4,132.00 7/12 DDA REGULAR DEPOSIT 284.37 Checks in serial order Date Chockii Amount Date Check# Amount 7/01 2128 81.70 7/05 2136 75.39 7/02 - 2129 103.82 7/17 2137 1,134.89 7/02 2130 202.55 7/05 2138 13,524.00 1/08 2131 56.89 7/11 2139 291.98 7/02 2132 40.00 7/08 2140 130.24 '7/02 2133 223.50 7/16 2141 58,84 7/08 2134 188.71 7/22 2142 135.72 7/02 2135 3,799.51 7/23 2143 1,063.50 * Indicates skip in check numbers Date 7/31/13 Page 2 Primary Account @XXXXX ©6456 Enclosures 33 NORTHEAST PUBLIC FUNDS ACCT OXXXXX06456 (Continued) Checks in serial order Balance Date Balance Date Date Checkli Amount Date Checkl6 Amount 7/23 2144 89.86 7/29 2155 6,415.48 7/23 2146* 786.38 7/30 2156 62.74 7/23 2147 1,612.06 7/29 2157 210.15 7/22 2148 76.52 7/29 2156 700.01 7/23 2151* 298.45 7/30 2159 49.76 7/24 2152 332.50 7/30 2160 223.84 7/29 2154* 21.00 7/30 2161 190.71 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 7/01 26,647.24 7/11 57,453.65 7/23 52,481.80 7/02 22,277.86 7/12 57,738.02 7/24 52,149.22 7/05 34,153.47 7/1.6 57,679.18 7/29 44,802.58 7/08 33,777,63 7/17 56,544.29 7/30 44,275.53 7/10 53,613.63 7/22 56,332.05 * * * R N D O F 9 T A T G M G N T Payment Summary Bank =165opr AND mm /yy= 07/2013- 07/2013 AND All Checks =Yes AND Include Voids =All Checks 34,440.94 Check Post Total Bank Cheek# Vendor Date Month Amount 165opr - Parkvlew Villa North 2136 chc - Commoneond Communities - 07/02/2013 07/2013 7539 165opr- Parkvlew Villa North 2137 cent- Centerfalnt Energy - 07/0212013 07/2013 1,134.89 165opr - Parkvlew Villa North 2138 chc - CommonBond Housing 07/02/2013 07/2013 13,524.00 165opr - Parkvlew Villa North 2139 home7 - tID Supply Facilities Maintenance, Ltd. 07/02/2013 07/2013 291.98 165om - Parkvlew Villa North 2140 well4 - Wellington Security Systems 07/02/2013 07/2013 130.24 165opr • Parkvlew Villa North 2141 offi8804 - Office Depot 07/09/2013 07/2013 58.84 165opr - Parkvlew Villa North 2142 buck0411 - Buckeye Cleaning Centers 07116/2013 07/2013 135.72 165opr - Parkvlew Villa North 2.143 cumm1600 - Cummins NPower LLC 07/16/2013 07/2013 1,063.50 165opr - Parkvlew Villa North - 2144 home7 - HD Supply Facilities Maintenance, Ltd. 07/16/2013 07/2013 89.86 165opr - Parkview Villa North 2145 kocl - K.O. Cleaning and Restoration LLC 07/16/2013 07/2013 700 165opr - Parkvlew Villa North 2146 kone - Kone Inc. 07/16/2013 07/2013 786,38 165opr - Parkvlew Villa North 2147 Ibpm - LBP Mechanical, Inc 07/16/2013 07/2013 1,612,06 165opr - Parkvlew Villa North 2148 love - Level One 07/16/2013 07/2013 76.52 165opr - Parkvlew Villa North 2149 lubr - Lubrication Technologies Inc 07/16/2013 07/2013 118.12 165opr - Parkview Villa North 2150 lubt900 - Lubrication Technologies, Inc. 07/16/2013 07/2013 164,7 165opr - Parkvlew Villa North 2151 sher4110 - Sherwin- Williams Co. 07/16/2013 07/2013 298.45 165opr - Parkvlew Villa North 2152 simp - Slmplex Grinnell 07/16/2013 07/2013 332.58 165opr - Parkvlew, Villa North 2153 allm2138 - All Metro Lawn & Snow, LLC 07/23/2013 07/2013 262.5 165opr - Parkview Villa North 2154 city4054 - City Wide Locksmlthing, Inc, 07/23/2013 07/2013 21 165opr - Parkview Villa North 2155 colu - City of Columbia Heights 07/23/2013 07/2013 6,415.48 165opr - Parkvlew Villa North 2156 comc3422 - Comcast 07/23/2013 0712013 62.74 165opr - Parkvlew Villa North 2157 home7 - HD Supply Facilities Maintenance, Ltd. 07/23/2013 07/2013 210.15 1650pr - Parkvlew Villa North 2158 kone - Kone Inc. 07123/2013 07/2013 700.01 165opr - Parkvlew Villa North 2159 off18804 - Office Depot 07/23/2013 07/2013 - 49.76 165opr - Parkvlew Villa North 2160 Popp - Popp.com 07/23/2013 07/2013 223.134 165opr - Parkvlew Villa North 2161 stan0371 - Stanley Access TecchnologleS LLC 07/23/1013 07/2013 190.71 165opr - Parkvlew Villa North 2162 chc - CommonBond Housing 07/30/2013 07/2013 23.74 165opr - Parkview Villa North 2163 home7 - HD Supply Facilities Maintenance, Ltd. 07/30/2013 07/2013 26.49 165opr - Parkvlew Villa North 2164 home9055 - Home Depot Credit Services 07/30/2013 0712013 13.8 165opr - Parkview Villa North 2165 xcel - Xcel Energy 07/30/2013. 07/2013 5,647.49 34,440.94 U;Idkm WJIK c W W C tl N O I 0 C c O O c C N 0 m0 N N c 0 N O -(J➢ 0 O N A -> O J W m m N A AOW1 0, N � O N W m c O O) d N c— � > N m W m U O W Ut Ut O Ut A (P O N m J W W O> > O N W fN 0 n C N N W Ci N D 0 toi+ N tOii N N cn z N• 0 0 S S K 1 0 c m -(J➢ 0 O A A -> O J W m 00fAli A AOW1 O O N W m fD O O) d 1 D c m -(J➢ A ' O W A O O� d W > N 1 S D m x O (D 2 Q C 40i O n N N O o 0 N O O C, C) > w o c oN O N > 0 W 91 N S O � N (D d z 0 W W O S -(J➢ J O W N O O� d W > N O W Ut Ut O Ut A (P O N m J W W O> > O N S D m x O (D 2 Q C 40i O n N N O o 0 N O O C, C) > w o c oN O N > 0 W 91 N S O � N (D d z 0 W W O S Parkview Villa South Financial Statement Overview August 2013 Revenue: Occupancy for the month of August was 89 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects lower occupancy Administrative Expenses: Administrative costs for South were under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) Audit Expense was over budget (unfavorable) and reflects audit fees paid to the City of Columbia Heights Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were under budget (favorable); however, this reflects some quarterly billings Fuel Oil was over budget (unfavorable) Electric was over budget (favorable) and reflects July billing Gas was under budget (favorable) and reflects a quarterly billing Water was over budget (unfavorable) and reflects the cost of meter replacement Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were over budget (unfavorable). Janitor Supplies were under budget (favorable) Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Elevator Maintenance and Repairs was over budget (unfavorable) and reflects the cost of replacing computer board in Elevator Heating and Cooling Maintenance and Repairs was under budget (favorable) Decorating Contract was under budget (favorable) ��oaoW w "OW.O. m �p oWNW� „a,9 W d ' N d o Cm 3a gg o �i m� Npp N j' � C S d W � m W •• � m mm° B A`mNDmu'n �iom� 31°$a�m `m 50 is q q O A tp (Op tWpN OrbWOON) ONA 000 JOOW NON GW)(WJ J(Wi�OWNO Y� NJD�o NWO(WJ 0d O+ W A W O N W W J V � fWJ N O W W wNZ W D W � N J c2 A A O A W b A N J � -i A al Z m D R W� n W 000 r W iNn O A P WW b p O O O O J O O O W V QI�y O) A W OI P OI O�OOi WAONiT�O A O G A A Wi O O> O O NAWAONI (WJ (ItONON NNPPA O�IWJOOW)ON �p OiOONIN ONO OW b 0)(Oi�N� OJONOJ 9 N Nm NN p� N O O O O O O 0 N 0 0 0 O N }NJ N N N O 0 O N w W O W moo m P Z� D °oo N J-•Dia � �IJJAN NC i �mN °o °m °O 'm °oo Wa i N N O o W O N N O N (p O Ip W 0 p� pJdp�� W0W N (N11 N a W N OO�O O OQwiOA O Z m DJ °o row Zw D °N N woU3 -u d N " � C O O O ro X ° S' 'g � � �9m m�agv� � �m�mooav�ox2mA C14)N C��m "d' �Ad v �SN - a0 t W O O A N wW J J N N W N J 0 + W J U A N W w w i N d b N N N W J JJ P wnwi W A w W O b + N q q N O v J W N N +J O(NJ rp0 A W J O W N O S OOOO OO N Owi0A00�AN00 SN wN0 P, O D w N�W'Wm AO O+ww� 0 O W J O 0 N NJ N NJ�O ww OW1J fAJ (wJA 00� W WW Owi w JJ INJ 1p O W 000 JO O IpJON4�ww wNW w J N O J O N O Z W b m O N W Owi O W p pop OwOJ OD O 4wiJ000JN�O W AO W WnmO N ��S by�pAp��+ yy IJNJ S N Wo1yy0A w�00N OOpNJ bNNN oN N (pNNOAww WNOW N-�W m �y W Jw UN O W O l0 o m Wj O W W W W O W O WW N A000 O�� W Uw+mOWOwONPA 000 ENO+ '`W'N (o NWWA +N WNw w0-+ vWO ooN� L+ 'wroNw�ov °o: +Wo -1 W 1y0 t0 IU A J yO� W A W A N W t�tppn 4m4 OJNNONAW+�ION yW 4110N � N WNN wlyyT��fJNA� WW W N N O O W W O O O O O O O W W N 00 N ON S V W N O SO O W N N +J O(NJ rp0 A W J O W N O S OOOO OO N Owi0A00�AN00 SN wN0 P, O D w N�W'Wm AO O+ww� 0 O W J O 0 N NJ N NJ�O ww OW1J fAJ (wJA 00� W WW Owi w JJ INJ 1p O W 000 JO O IpJON4�ww wNW w J N O J O N O Z W b m O N W Owi O W p pop OwOJ OD O 4wiJ000JN�O W AO W WnmO N ��S by�pAp��+ yy IJNJ S N Wo1yy0A w�00N OOpNJ bNNN oN N (pNNOAww WNOW N-�W m �y W Jw UN O W O l0 o m Wj O W W W W O W O WW N A000 O�� W Uw+mOWOwONPA 000 ENO+ '`W'N (o NWWA +N WNw w0-+ vWO ooN� L+ 'wroNw�ov °o: +Wo -i a nom o, �o �. Vin, pmt ipJWA ON W t�tppn 4m4 OJNNONAW+�ION yW 4110N N WNN wlyyT��fJNA� WW W O O W W O O O O O O O O O O O O O O O O O O 0 O N o W -u c 1 ar v � 110 N m lµ j N N t0N O p �V A g 0 OW N O N N JON J N JOON Ol V NOW °)OW y a y �v8i ..Do r y g mcc gA O° 3m 43 �N3 � Ip G y W� O NN V OJ Np0 (°bi O 00 00 N P D 6o O N 0 N ~ Z D O m° 4) O N POP 000 OI00 ee. e�e zzz zz 'n 'nn D'nn !v G, N J N A V A fNJ O fNiIA 00� O O O O O O tJ W_ I1Jp -� N A V A W O(NiIA OI00 zzz 7 DZZ DDD DD pl O O OIO O 8 § 3I�m) n np C �I o °o 8 n a „ N D � O N �w3 � 7 � O v fi ip ii0 . b uvO . +O �NNN�JO •Ni J mOW W Jm+00 -+W p�(nWNOW O� O y D DO D D oyo a x I- fi� A G v Cl N D RDR o A n�.3 m �a22d$ 62229 � a mm d$N V�� 0000a m m m � O O N Y Q v w 1� �mO NIi O>NA NNNNOO (A N N 0 W N O O O O MO O O O O �1 IJ rD0 WN000 z D�ZZZZ DD DDDD AWq m1�000 N I 011wo8 o i� O O O O O O O O O yN pT� W Ia J N N J 0 Y W O O O ZZ ZZ22Z DD DDDDD 00 °oI °0000 m v W o o. y m rs R D u T v ParWew Villa South (166) Balance August 2013 Books = Accrual Aug -13 Assets 6,750.98 10100 Cash Balance 89,713.82 10200 Petty Cash 279.00 10400 Investments 729,970.36 11300 Rent Receivable 3,914.94 11500 Accounts Receivable 75.63 15510 Prepaid Insurance 2,826.32 Total Assets 826,780.[17 Liabilities 20200 Accounts Payable 6,750.98 22000 Deposits 8,750.20 22200 Accrued PILOT 8,229.52 22210 Revenue Collected in Advance 806.00 Total Liabilities 24,536.70 Fund Balance 25300 Fund Balance 802,243.37 Total Fund Balance 802,243.37 Total Liabilities and Fund Balance 826,780.07 Parkview Villa -South (166) 90.38 0.37% 408.97 0.21% Income Statement 11.20 0.05% 1,444.52 0.74% For The Period Ending August 2013 0.00 0.00% 0.00 0.00% Books = Accrual 142.04 0.59% 2,149.41 1.11% Total Supplies Month to Date % Year to Date 2.06% Revenue 0.50% 3210 -46340 Telephone &Telegraph 36220 -46340 Gen. Government Rents 23,498.00 97.39% 187,810.50 96.83% 36225 -46340 Nondwelling Rents 462.00 1.91% 3,736.68 1.93% 36290 -46340 Other Miscellaneous Revenue 168.00 0.70% 2,411.11 1.24% 39120 -46340 Recovery Damage City - 0.00% - 0.00% Total Revenue 24,128.00 100.00% 193,958.29 100.000/0 Expenses Personal Services 1000 -46340 Accrued Salaries 3,932.00 16.30% 31,456.00 16.22% Total Personal Services 3,932.00 16.30% 31,456.00 16.220/a Supplies 2000-46340 Office Supplies 90.38 0.37% 408.97 0.21% 2010 -46340 Minor Equipment 11.20 0.05% 1,444.52 0.74% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 142.04 0.59% 2,149.41 1.11% Total Supplies 243.62 1.010/0 4,002.90 2.06% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 52.50 0.03% 3050 -46340 Expert & Professional Services 5,873.00 24.34% 5,873.00 3.03% 3060 -46340 Management Services 2,126.00 8.81% 17,008.00 8.77% 3100 -46340 Protective Services 0.00 0.00% 979.34 0.50% 3210 -46340 Telephone &Telegraph 159.95 0.66% 1,255.98 0.65% 3430 -46340 Advertising Other 0.00 0.00% 160.28 0.08% 3600 -46340 Insurance & Bonds -236.07 -0.98% 5,693.57 2.94% 3810 -46340 Electric 2,943.40 - 12.20% 16,791.77 8.66% 3820 -46340 Water 619.88 2.57% 1,816.58 0.94% 3830 -46340 Gas 565.83 2.35% 9,738.96 5.02% 3840 -46340 Refuse 78.54 0.33% 144.58 0.07% 3850 -46340 Sewer 0.00 0.00% 952.71 0.49% 4000 -46340 Repair & Maint. Services - 7,295.14 30.24% 25,536.81 13.17% 4100 -46340 Rents & Leases 40.00 0.17% 585.00 0.30% 4300 -46340 Miscellaneous Charges 0.00 0,00% 181.59 0.09% 4315 -46340 PILOT 1,028.69 4.26% 8,229.52 4.24% 4390 -46340 Taxes & Licenses 69.00 0.29% 627.62 0.32% 4500 -46340 Administrative Expenses 25.66 0.11% 322.93 0.17% 4850 -46340 Interest on Deposits 6.95 0.03% 51.49 0.03% Total Other Services & Charges 20,595.97 85.360/o 96,002.23 49.50% Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00% 0.00% 0.00 0.00% 24,771.59 102.67% 131,461.13 67.78% - 643.59 -2.67% 62,497.16 32.22% Parkview Villa South (166) 5,873.00 Cash Flow Statement 90.38 Period = August 2013 11.20 2160 Maint. & Construct Materials Month to Date Revenue 142.04 36220 Gen. Government Rents 23,498.00 36225 Nondwelling Rents 462.00 36290 Other Miscellaneous Revenue 168.00 39120 Recovery Damage City Property 0.00 Total Revenue 24,128.00 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 3,932.00 Supplies 5,873.00 2000 Office Supplies 90.38 2010 Minor Equipment 11.20 2160 Maint. & Construct Materials 0.00 2171 General Supplies 142.04 2175 Food Supplies 0.00 Total Supplies 243.62 Other Services & Charges 3050 Expert & Professional Services 5,873.00 3060 Management Services 2,126.00 3100 Protective Services 0.00 3210 Telephone &Telegraph 159.95 3430 Advertising Other 0.00 3600 Insurance & Bonds (236.07) 3810 Electric 2,943.40 3820 Water 619.88 3830 Gas 565.83 3840 Refuse 78.54 3850 Sewer 0.00 4000 Repair & Maint. Services 7,295.14 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 40.00 4300 Miscellaneous Charges 0.00 4315 PILOT 1,028.69 4390 Taxes & Licenses 69.00 4500 Administrative Expenses 25.66 4850 Interest on Deposits 6.95 Total Other Services & Charges 20,595.97 Total Expenses 24,771.59 Parkvlew Villa South (166) Cash Flow Statement Period = August 2013 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date - 643.59 0.00 0.00 1,857.17 55.00 (2,826.32) (236.43) (5,888.75) 272.78 1,028.69 254.00 (5,483.86) (6,127.45) Beg Cash End Cash Difference 95,841.27 89,713.82 (6,127.45) 279.00 279.00 ' 729,970.36 729,970.36 - 826,090.63 819,963.18 (6,127.45) 3060 -46340 Management Services 166 8/29/2013 Common8ond Housing (chc) 166 8/31/2013 :PostRecurring Recurring Net Change= 2,126.00 3100 -46340 Protective Services Net Change =0.00 3210 -46340 Telephone & Telegraph 166 7/31/2013 PoPp.com (Popp) 166 8/1/2013 Level One(leve) 166 8/2/2013 Con Cest(eerne3474) Net Change= 159.95 14,882.00 = Beginning Balance = P- 347288 08/17113-08/: 6,058.00 0.00 20,940.00 195517 mgnt fees 8/13 3- 170161 RC 0.00 3,932.00 17,008.00 R/C CHC PR M9mt Fee 17,008.00 = Ending Balance = 979.34 = Beginning Balance = 979.34 = Ending Balance = P- 345683 992123953 100.01 P-343553 0344976IN 34.38 P- 345681 877210505011 11096.03 = Beginning Balance = 0100 1,196.04 phone 08/13 0.00 1,230.42 mount plan 8/13 0.00 1,255.98 internet 08/11 - 09/10113 1,255.96 = Ending Balance = 3430 -46340 Advertising Other Net Change =0.00 3600 -46340 Insurance & Bonds 166 713112013 City of Columbia Heights (colu) P-346423 4062 8,479.00 0.00 166 8/31/2013 :PostRecurring Recurring 3- 170161 RC 0.00 8,715.07 Net Change =- 236.07 3810 -46340 Electric 166 8/12/2013 Xod Energy (xceH P- 346062 5150441553 C 2,943.40 0.00 Net Change =2,943.40 3820 -46340 Water 166 8131/2013 RC C of Columbla Hghts Water Mete, . )-171267 G36 619.88 0.00 Net Change= 619.88 3830 -46340 Gas Parkview Villa South (WE) 166 6/2212013 Lubrication Technologies Inc (lubr) P- 346642 General Ledger 0.00 166 6/24/2013 Lubrication Technologies Inc (lubr) P-346643 2225614 163.90 Period = Aug 2013 8/8/2013 CenterPonit Energy (cent) P- 345551 55271324 08/ 148.13 0.00 Book = Accrual; Tree = ysi tb Property Bate PersonIDescription control Reference Debit Credit Balance Remarks 1000-46340 Accrued Salaries 27,524.00 = Beginning Balance = 166 8/31/2013 :PostRecurring Recurring 3- 170161 RC 3,932.00 0.00 31,456.00 R/C CHC PR Mgmt Fee Net Change = 3,932.00 31,456.00 = Ending Balance = 2000 -46340 Office Supplies 318.59 = Beginning Balance = 166 7/19/2013 office Depot(of08804) P- 343933 6.67492E +11 14.15 0.00 332.74 mspd;sgrcrmrpens;ppr,pos' 166 7/19/2013 Office Depot(ofEli P- 343934 6.67492E +11 4.55 0.00 337.29 palm /wrist rest 166 7/31/2013 City of Columbia Heights (col.) P-346423 4062 71.68 0.00 408.97 1/13-6/13 copier allocation Net Change =90.38 408.97 = Ending Balance = 2010 -46340 Minor Equipment 1,433.32 = Beginning Balance = 166 8/2/2013 HD Supply Facilities Maintenance, Lt P- 344660 9123982852 11.20 0.00 1,444.52 vertical headrail Net Change =11.20 1,444.52 = Ending Balance = 2171 -46340 General Supplies 2,007.37 = Beginning Balance = 166 3/12/2013 Fratteone's/ Metro Ace (frat) P- 346607 014385R 13.66 0.00 2,021.03 fuse plugs;V belt 166 8/2/2013 Frattalone's /Metro Ace(frat) P- 344631 015909R 8.28 0100 2,029.31 basket strainer 166 8/2/2013 HD Sup Ply Facilities Maintenance, Lt P- 344660 9123982852 2.09 0.00 2,031.40 dry wall screws 166 812/2013 HD Supply Facilities Maintenance, Lt P-344660 9123982852 78.91 0.00 2,110.31 toilet tank & bowl 166 8/13/2013 HO Supply Facilities Maintenance, Lt P- 345771 9124223244 32.66 0.00 2,142.97 bath dssus;sponge;mop 166 8/13/2013 HD Supply Facilities Maintenance, Lt P- 345771 9124223244 6.44 0.00 2,149.41 vinyl gloves Net Change= 142.04 2,149.41 = Ending Balance = 3040 -46340 Legal Fees 52.50 = Beginning Balance = Net Change=0.00 52.50 = Ending Balance = 3050 -46340 Expert & Professional Services - 0.00 = Beginning Balance = 166 7/31/2013 City of Columbia Heights (colu) P- 346423 4062 123.00 (.00 123.00 audit fees 166 812/2013 Columbia Heights HM (coluhra) P- 344792 20131 5,750.00 0.00 5,873.00 2013 servicing fees Net Change= 5,873.00 5,873.00 = Ending Balance = 3060 -46340 Management Services 166 8/29/2013 Common8ond Housing (chc) 166 8/31/2013 :PostRecurring Recurring Net Change= 2,126.00 3100 -46340 Protective Services Net Change =0.00 3210 -46340 Telephone & Telegraph 166 7/31/2013 PoPp.com (Popp) 166 8/1/2013 Level One(leve) 166 8/2/2013 Con Cest(eerne3474) Net Change= 159.95 14,882.00 = Beginning Balance = P- 347288 08/17113-08/: 6,058.00 0.00 20,940.00 195517 mgnt fees 8/13 3- 170161 RC 0.00 3,932.00 17,008.00 R/C CHC PR M9mt Fee 17,008.00 = Ending Balance = 979.34 = Beginning Balance = 979.34 = Ending Balance = P- 345683 992123953 100.01 P-343553 0344976IN 34.38 P- 345681 877210505011 11096.03 = Beginning Balance = 0100 1,196.04 phone 08/13 0.00 1,230.42 mount plan 8/13 0.00 1,255.98 internet 08/11 - 09/10113 1,255.96 = Ending Balance = 3430 -46340 Advertising Other Net Change =0.00 3600 -46340 Insurance & Bonds 166 713112013 City of Columbia Heights (colu) P-346423 4062 8,479.00 0.00 166 8/31/2013 :PostRecurring Recurring 3- 170161 RC 0.00 8,715.07 Net Change =- 236.07 3810 -46340 Electric 166 8/12/2013 Xod Energy (xceH P- 346062 5150441553 C 2,943.40 0.00 Net Change =2,943.40 3820 -46340 Water 166 8131/2013 RC C of Columbla Hghts Water Mete, . )-171267 G36 619.88 0.00 Net Change= 619.88 3830 -46340 Gas 166 6/2212013 Lubrication Technologies Inc (lubr) P- 346642 2225493 250.81 0.00 166 6/24/2013 Lubrication Technologies Inc (lubr) P-346643 2225614 163.90 0.00 166 8/8/2013 CenterPonit Energy (cent) P- 345551 55271324 08/ 148.13 0.00 160.28 = Beginning Balance = 160.28 = Ending Balance = 5,929.64 = Beginning Balance = 14,408.64 prop & Ilab insurance 5,693.57 C of Columbia Heights Its Act 5,693.57 = Ending Balance = 13,848.37 = Beginning Balance = 16,791.77 electric 7/6- 8/5/13 16,791.77 = Ending Balance = 1,196.70 = Beginning Balance = 1,816.58 RC C of Columbia lights Wane 11816.58 = Ending Balance = 9,173.13 = Beginning Balance = 9,423.94 fuel oil 9,587.84 fuel oil 9,735.97 g 07/08 - 08/06/13 166 8/8/2013 CenterPoint Energy (cent) P- 345551 55271324 081 2.99 0.00 9,738.96 late fee Net Change= 565.83 9,738.96 = Ending Balance = 66.04 = Beginning Balance = 3840 -46340 Refuse 166 7/31/2013 Green Lights Recycling Inc(gree300 P- 344772 134283 78.54 0.00 144.58 garbage /reading 144.58 = Ending Balance = Net Change =78.54 952.71 = Beginning Balance = 3850 -46340 Sewer 952.71 = Ending Balance = Net Change =0.00 4000 -46340 Regal & Maint. Services 18,241.67 = Beginning Balance = 166 7/2912013 Adam's Pest Control, Inc. (adam) P- 344924 812321 23.32 0100 18,264.99 pest control - 7/29/13 166 7/3112013 All Metro Lawn & Snow, LLC (alini P- 344771 2609 117.94 0.00 18,382.93 weekly mowing 07/13 166 7/24/2013 Direct Home Appliance Services (din P- 346417 72413166 213.90 0.00 18,596.83 washer repair 166 7/29/2013 Kone Inc, Hkome) P- 343930 150878141 781.40 0.00 19,378.23 elevator maint 07/16 - 07/18/1 166 8/1/2013 none Inc.(kone) P- 345031 221245314 314.50 0100 19,692.73 elev maint 08/13 166 8/12/2013 Kane Inc. (Runs) P- 345931 150884020 5,128.66 0.00 24,821.39 elevator repair 07 /29- 30/201. 166 7/29/2013 -SP Mechanical, Inc (Rom) P-343932 .19044 135.42 0.00 24,956.81 His vlv; repair leak 07 /15-07/ 166 8/13/2013 K.O. Cleaning and Restoration LLC (I P- 345905 1499 250.00 0.00 25,206.81 paint walls #216 166 8/13/2013 K.O. Cleaning and Restoration LLC ('. P- 345906 1498 80.00 0.00 25,286.81 touch -up 8414 166 8113/2013 K.O. Cleaning and Restoration LLC (I P- 345908 1497 250.00 0.00 25,536.81 paint walls #322 Net Change= 7,295.14 25,536.81 = Ending Balance = 545.00 = Beginning Balance = 4100 -46340 Rents & Leases 166 7/31/2013 Multlhousing Credit Control (multi) P- 345452 13070378 40.00 0.00 585.00 residential screening 07113 Net Change =40.00 585.00 = Ending Balance = 4300 -46340 Miscellaneous Charges 181.59 = Beginning Balance = 181.59 = Ending Balance = Net Change=0.00 71200.83 = Beginning Balance = 4315 -46340 166 8/31/2013 PILOT :PostRemrring Recurring ) -170161 RC 1,028.69 0100 8,229.52 Anoka Cty, Property Tax Assoc Net Change = 1,028.69 8,229.52 = Ending Balance = 558.62 = Beginning Balance = 4390 -46340 Taxes & Licenses 166 8/2/2013 AN Dept of Labor & Industry (mndi P- 345762 ALR0030481T 69.00 0.00 627.62 elevator annual opera 627.62 = Ending Balance = Net Change =69.00 297.27 = Beginning Balance = 4500 -46340 Administrative Expenses 166 8/29/2013 Commori Housing (chi P- 347288 08/17/13 -08 /: 25.66 0.00 322.93 194820 carry training 7/25/12 322.93 = Ending Balance = Net Change =25.66 44.54 = Beginning Balance = 4850 -46340 Interest on Oeposlts 51.49 Sec Dep interest accrual 166 6/31/2013 Sec Dep interest accrual 1- 170800 GIL 6.95 0.00 Net Change =6.95 51.49 = Ending Balance = 38,036.54 13.266.95 Parkview Villa South Hank Reconciliation Report 08/31/2013 5016464 Balance Per Bank Statement as of 08131/2013 Outstanding Checks Check date Check number 06/18/2013 1782 06/18/2013 1786 08/06/2013 1830 08/20/2013 1835 08120/2013 1842 08/27/2013 1844 08/27/2013 1845 08/27/2013 1846 08/27/2013 1847 08/27/2013 1848 08/27/2013 1849 08/27/2013 1850 Less: Outstanding Checks Payee kocl - K.O. Cleaning and Restoration LLC t0011071 - Johnson t0010380 - Novak al1m2138 - All Metro Lawn & Snow, LLC oUi8804 - Office Depot colu - City of Columbia Heights comc3474 - Comeast dire - Direct Home Appliance Services keel - K.O. Cleaning and Restoration LLC kone - Kone Inc. lubr - Lubrication Technologies Inc xcel -Xcel Energy Reconciled Bank Balance Balance per GL as of 08131/2013 Reconciled Balance Per GIL 109,041.13 Difference (Reconciled Bank Balance And Reconciled Balance Per GIL) Cleared Items : Cleared Checks Amount 50.00 232.96 307.92 117.94 18.70 9,293.56 25.56 213.90 580.00 5,128.66 414.71 2,943.40 19,327.31 89,713,82 09104/2013 89,713.82 89,713.82 0.00 Date Tran 8 Notes Amount Dale Cleared 07/16/2013 1811 lubr- Lubrication Technologies Inc 53.10 08/3112013 07/16/2013 1812 lubr900 - Lubrication Technologies, Inc. 74.00 06/31/2013 07/23/2013 1814 allm2138 . All Metro Lawn & Snow, LLC 117.94 08131!2013 07/30/2013 1822 chc- Commonl3ond Housing 23.74 08/31/2013 07/30/2013 1823 home7 - HD Supply Facilities Maintenance, Ltd. 11.90 08/31/2013 07/30/20`13 1824 home9055 - Home Depot Credit Services 6.20 08/3112013 07/30/2013 1825 multi - Multihousing Credit Control 80.00 08/3112013 07/30/2013 1826 xcel - Xcel Energy 2,736.64 08/31/2013 08/06/2013 1827 cent- CenterPoint Energy 199.50 08/31/2013 Parkview Villa South 09/0412013 Bank Reconciliation Report 0$13112013 5016464 Cleared Checks Tran k Notes Amount Date Cleared Date 1828 chc- CommonBond Housing - 6,102.07 08/31/2013 08/06/2013 - 1829 home7 - HD Supply Facilities Maintenance, Ltd. 42.76 08/31/2013 08/06/2013 781.40 08131/2013 08/13/2013 1831 kone - Kone Inc. 135.42 08/31/2013 08/13/2013 1832 Ibpm - LBP Mechanical, Inc 34.38 08/31/2013 08/13/2013 1833 lave -Level One 23.32 08/31/2013 08120/2013 1834 adam •Adam's Pest Control, Inc. 1836 coluhra - Columbia Heights HRA 5,750.00 08/3112013 08/20/2013 1837 frat • Fratlalone's /Metro Ace 8.28 08/31/2013 08/20/2013 1838 gree1004 - Green Lights Recycling Inc 78.54 08/31/2013 08/20/2013 home7 - HD Supply Facilities Maintenance, Ltd. - 32.92 08/31/2013 08/20/2013 1839 314.50 08/31/2013 08/20/2013 1840 Kona - Kone Inc. - Multihousing Credit Control 40.00 08/31/2013 08/20/2013 1841 multi 100.01 08131/2013 08/20/2013 1843 Popp - Popp.com 16,746.62 Total Cleared Checks Cleared Deposits Tran # Notes Amount _ Date Cleared Date 23,507.00 08131/2013 OS/05I2013 388 620.00 08/31/2013 08/05/2013 389 450.00 08/31/2013 08/12/2013 391 250.00 08/31/2013 2/2013 08/1212013 392 919.00 08/31/2013 393 814.00 08131/2013 08/14/2013 394 26,560.00 Total Cleared Deposits Date 8/30/13 Page I Primary Account ®XXXXX ©6464 Enclosures 29 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/0 COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C it E C K I N G A C C O U N T S -- -- CHANGE NOTICE EFFECTIVE SEPTEMBER 1, 2013: *CANADIAN CHECK ITEM PROCESSING FEE - $1,000 OR LESS = $5.00, $1,001 OR = $4.00 GREATER = $10.00. *REDEPOSITED RETURN ITEM FEE *XuU INTEREST CHARGE FOR NEGATIVE AVERAGE COLLECTED BALANCE EQUAL TO INTERST TS OF � APPLIED .TO CHECKING ACCOUNTSPONM ANALYSIS EACH STMT NORTHEAST PUBLIC FUNDS ACCT Number of Images 0XXXXX @6464 Statement Dates 8/01/13 thru 29 8/31/13 Account Number Previous Balance 99,227.75 Days in the Statement Period - 31 112,337. 7 Deposits /Credits 27,201.00 Average Ledger Collected 111,486 23 Checks /Debits 17,387.62. Average Electronic Debit .00 Service charge .00 Interest Paid .00 Ending Balance 109,041.13 - *** W************* W******* W***** WW* WW* WW* W££* W£ W * * * * * *W *WW *W *££W * * *£ * * * *W£ *W * *W Deposits and Credits Amount Date Description 620.00 8/06 DDA REGULAR DEPOSIT 641.00 8/06 DDA REGULAR DEPOSIT 23,507.00 8/06 DDA REGULAR DEPOSIT 250.00 8/13 DDA REGULAR DEPOSIT 8/13 DDA REGULAR DEPOSIT 814.00 8/14 DDA REGULAR DEPOSIT 919.00. 8/14 DDA REGULAR DEPOSIT .Charges and Debits Amount Date Description 641.00 8/12 RETURN ITEM DEBIT WW**** W** W* W** W£* W****** W************£***** W* WW * *W * * *£ * *£ * *W *W£WW£ *W *££ * * *WW ** Checks in serial order Check# Amount Date Check #* Amount Date 8/.21 1811 53.10 8/06 1814 117.94 23.74 8/21 1812 - - 74.00 8/01 1822* * Indicates skip in check numbers Date 8/30/13 Page 2 Primary Account OXXXXXQ6464 Enclosures 29 NORTHEAST PUBLIC FUNDS ACCT QXXXXXQ6464 (Continued) Checks in Date serial order Check# Amount Date Check# Amount 8/07 1823 11,90 8/19 1833 34.38 8/05 1824 6.20 8/28 1834 23.32 8/09 1825 80.00 8/28 1836* 5,750.00 8/05 1826 2,736.64 8/29 1837 8.28, 8/12 7.827 199150 8/29 1838 78.54 8 /08 3.828 6,102.07 8/30 1839 32.92 8/13 1829 42.76 8/30 1840 314.50 8/19 1831* 781.40 8/28 1841 40.00 8/20 1832 135.42 8/29 1843* 100.01 * Indicates skip in check numbers Daily Balance Section Date alace Date alace Date alace 8/01 99,204.01 S /09 114,917.26 8/20 115,515.80 8/05 96,461.17 8/12 114,076.76 8/21 115,388.70 8/06 121,113.23 8/13 114,734.00 8/28 109,575.38 8/07 121,099..33 8/14 116,467.00 8/29 109,388.55 8/08 114,997.26 8/19 115,651.22 8/30 109,041.13 * * * E N D O F S T A T E M E N T * * * Payment Summary Bank= 1660pr AND mm /yy= 08/2013- 08/2013 AND All Checks =Yes AND Include Voids =All Checks Check Post Total Bank 166opr - Parkview Villa South 166opr - Parkview Villa South 166opr - Parkview Villa South 166opr - Parkview Villa South 166opr - Parkview Villa South 166opr- Parkview Villa South 166opr- Parkview Villa South 1660pr - Parkview Villa South 166opr - Parkview Villa South 166opr- Parkview Villa South 1660pr - Parkview Villa South 166opr- Parkview Villa South 1660pr - Parkview Villa South 166opr - Parkview Villa South 166opr- Parkview Villa South 166opr- Parkview Villa South 166opr- Parkview Villa South 166opr - Parkview Villa South 166opr- Parkview Villa South 166opr- Parkview Villa South 1660pr - Parkvlew Villa South 166opr- Parkview Villa South 166opr- Parkview Villa South 166opr- Parkview Villa South Check# 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 Vendor cent - CenterPOint Energy cm: - CommonBond Housing home7 - HD Supply Facilities Maintenance, Ltd. t0010380 - Novak kone - Kone Inc. born - LBP Mechanical, Inc leve - Level One adam - Adam's Pest Control, Inc. allm2138 - All Metro Lawn & Snow, LLC coluhra - Columbia Heights HRA frat - Frattalone's /Metro Ace gree1004 - Green Lights Recycling Inc home7 - HD Supply Facilities Maintenance, Ltd. kone -Kone Inc. multl - Multihousing Credit Control offi8804 - Office Depot Popp - Popp.com colu - City of Columbia Heights comc3474 - Comcas[ dire - Direct Home Appliance Services kocl - K.O. Cleaning and Restoration LLC kone -Kone Inc. lubr - Lubrication Technologies Inc xcel - Xcel Energy -- bate 08/06/2013 08/06/2013 08/06/2013. 08/06/2013 08/13/2013 08/13/2013 08/13/2013 08/20/2013 08/20/2013 08/20/2013 08/20/2013 08/20/2013 08/20/2013 08/20/2013 08/20/2013 08/20/2013 08/20/2013 08/27/2013 08/27/2013 08/27/2013 08/27/2013 08/27/2013 08/27/2013 08/27/2013 Month 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 08/2013 Amount 199.5 6,102.07 42.76 307.92 781.4 135.42 34.38 23.32 117.94 5,750.00 8.28 78.54 3292 314.5 40 18.7 100.01 9,293.56 25.56 213.9 580 5,128.66 414.71 2,943.40 _ 32,687.45 .45 Parliview Villa North Financial Statement overview August 2013 Revenue: Occupancy for the month of August 2013 was 99 % occupied; Rent Revenue was under budget (unfavorable) and reflects occupancy Total Revenue for August was under budget (unfavorable), however, we did not draw down the operating grant in August Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Legal Services was Linder budget (favorable) Audit Expenses was over budget (unfavorable) and reflects audit fees paid to the City of Columbia Heights Misc. Admin Expenses was under budget (favorable) Utilities: Utilities Expenses were under budget (favorable), however this reflects some quarterly billing Fuel Oil was over budget (unfavorable) Electric was over budget (unfavorable) and reflects July billing Gas was under budget (favorable) and reflects July billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were over budget (unfavorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was under budget (favorable) Garbage and Trash was under budget (favorable); however, this is a quarterly billing Elevator Maintenance Contract is over budget (unfavorable) and reflects the cost of upgrade replacement to the computer board for the elevator Heating, Cooling Maintenance and Repairs was under budget (favorable) Decorating Contract was under budget (favorable) Furniture and Fixtures was over budget (unfavorable) and reflects the cost of refrigerator replacement y 1!! N O z w ol v O N O O W J O J O O O O O A +� O O O O N O b w4 O W J O J O O O N mxO q Qon �^ M � obi A m fC�l 3 5 . 9x9 =�0 m 3.3 mea1p m "' 3 <�33 a v� WBo ap'meN m Om oR m y O m m T v (n m y ry �mn m N � 3 a I Y p pp 'i 1i W 0 N W o W W a J O W W WW v N W fJ W 0 i1 p W O J W O O O ;NiS O a y A ANwJ W bO W W AONN �rl O� OA N�NOIp ON0000 iW pJ�J lY W W J N � �A1 W i1 (W O + +A (WJ 4wiW ���� �mb AJA m00 ONO 00 ;pJ�N000 N NNN yA p p�Z �m Q SJO AOOOO l u N iD+ 'JO w 1PN N +(O W�Ap JAJ WPoOW `q 010vOm NT4A� O NO N m N �O N A O N O Ol AJ O N O� � O J W N +NW GOJwJONO mamlo +oo €� �wwo JO OiD -. °o oo WNm 1ooNO 3, NN N A+W� NO SN .w A�WW ^1 PwOo +P N �ONWJ �Np N. O O O oWN OOWi0000 Im AmYOW10 A AAO AAA AOPOOOWIPA ZSS 3S� � IJ JW N J t� N N N A 10 o N' d P W O A O N O Vwi :N m W N O t4 VT W Ili (WO pp�� qS ,W W wT0 TNN (OAW�NmI +A 01WOb00 .N } VATN(O 3 °ow wm w�AzyNOmA� 1NV OO1Wn J Ir W Vw°op �� O N A P IJ W i0 N 10 J W D m� N tO W ID Vi O J O Vi ;I1N O/ J J ' O + S:pmp 4y1 W 'N T WN+ SLD (Nil y m�-� A UI IN11PN W JfP+ OWWW 01NON +OI (W� 4]WWwJ �p AWP y 1!! N O z w ol v ,° mm� m m ommo m mN .WN mm N + V OI N OI o W N J OFm o w owl o B m a 2 owe o 0 . S.0 " ° N ao a d�aH =A9�� a o m K R 2 ° � O N 0 1mO OWI J O J$ 0 m T N N H O$ + ++ NN NN(NJ o N m W 01 Ji w mjmAN � +W i W iOm O W J 4 A 4 m IJ $A001 00 01 OWIAOOT mOW1N010 NAO (rNQ+ IJ� N +W ��Nm1O 0V�+ mNmJ 10 W+ W N po P W O O A OI W O N1 W Am 4y1 N OW1 OJNm 001 A �J010�0p11m VOW141W f11NJ 1p 1O � N 0� A N W O J 0 N ON W fAJ � L O N 1Jp N pN °1 J + N W WV W A l O1JpO W Nb NOOAW �$J X0100 N s 00 W p O rn ao omo °o °000 O N N A$ O 00 0 0000000000 0 + A A m mmm W N O O m m W O N+ A+ N 01 0 O pW� A J b J 1W� O O N N$ J V W O O J J J N J$ q N W O Oml J W j N q w O 1� W 10 < 1p Oi �J A NN 1' S (yO N S$ 0 W O N W> V N j 1,m0 N W O1 N O 1Wji p� J P � 1W0 C (li O N 0 1mO OWI J O J$ 0 m T N N H O$ + ++ NN NN(NJ o N m W 01 Ji w mjmAN � +W i W iOm O W J 4 A 4 m IJ $A001 00 01 OWIAOOT mOW1N010 NAO (rNQ+ IJ� N +W ��Nm1O 0V�+ mNmJ 10 W+ W N po P W O O A OI W O N1 W Am 4y1 N OW1 OJNm 001 A �J010�0p11m VOW141W f11NJ 1p 1O � N 0� A N W O J 0 N ON W fAJ � L O N 1Jp UI pN °1 O W A W Y A l W .l O N s 00 o rn ao omo °o °000 °o °0 p J 0 0000000000 0 + A A m 1y W N y W G O pW� A pO� A pW� A O WN N P M1 Q W i j N q w O 1� W 10 < 1p Oi �J A NN 1' J P � 1W0 C (li rU) F W O V N 0 W °1 0m� N � rip 1Npi (� +n m+ OPi OA1 A S O N 0 1mO OWI J O J$ 0 m T N N H O$ + ++ NN NN(NJ o N m W 01 Ji w mjmAN � +W i W iOm O W J 4 A 4 m IJ $A001 00 01 OWIAOOT mOW1N010 NAO (rNQ+ IJ� N +W ��Nm1O 0V�+ mNmJ 10 W+ W N po P W O O A OI W O N1 W Am 4y1 N OW1 OJNm 001 A �J010�0p11m VOW141W f11NJ 1p 1O � N 0� A N W O J 0 OOH OAJA ON J 1p0 Jm(OJONdJANfAJ OINW OJl W A l W .l O N s 00 o rn ao omo °o °000 °o °0 0 0000000000 0 a v W o o =. c D D .fin "�' O Z w 3 ° 10 d N. m N ,\ gp¥R ;.: , � ® ` I ] m j I ; ;;; A ; IS S +; !9Q m= /QQ A; . §, § wl )) ,» ]ƒ § , 7 m r!2[ ( \k{ (�k} \ (® C O 0 v N � �i0 �] �Np UW(NiINW WO NN(��jN ON ��pi � J NOW W JmoO -+W �N NO41 OlJ m D Oy O C ~ m m3m cg3w,p,w 0000av xa °o °o °o� v G NN N o 4N N I ONNJN WW000 L1 I,NJ ;NHNV NN000 -.I wo U® > U C 2 0 r D °l O t -1 m m � d IN O O O 000 O O O O ' °o °o °OO °o °O °0000 °o oo O O O i I AA N NiON l _ NN 1 JJ (W)l (11 ION bIWIi 00000 NVi�N 00 O N�mWN �No(AllO w+l� �z )z2zz Z`ZZZZ 7z a DD D DDDDD DDDDD DD DD D DDDDD DDDDD ➢D, m �{V NNNWN °0000 OOO Nm 00 O wO)O WdN �NONO wo U® > U C 2 0 r D °l O t -1 m m � d IN O O O O O O O O O O O O O O O O O O O Ta O OOIO l _ 1 JJ (W)l (11 ION bIWIi 00000 NVi�N 00 O N�mWN �No(AllO w+l� a z 2 z Z� z z z z z z z z 4. DD D DDDDD DDDDD ➢D, m 00000 °0000 oo� Parkview Villa -North (165) Balance Sheet August 2013 Books = Accrual Aug -13 Assets 10100 Cash Balance 9,188.64 10200 Petty Cash 871.00 10400 Investments 891,214.11 11300 Rent Receivable 2,842.10 11500 Accounts Receivable 390.12 15510 Prepaid Insurance 5,698.32 Total Assets 910,204.29 Liabilities 20200 Accounts Payable 26,361.24 20210 Accrued Other Expenses -0.00 20220 Due to Resident Council 551.74 22000 Deposits 18,174.43 22200 Accrued PILOT 16,217.20 22210 Revenue Collected in Advance 1,175.02 Total Liabilities 62,479.63 Fund Balance 25300 Fund Balance 847,724.66 Total Fund Balance 847,724.66 Total Liabilities and Fund Balance 910,204.29 Parkview, Villa -North (165) Income Statement For The Period Ending August 2013 Books = Accrual Revenue 33160 -46330 Federal Grant 36220 -46330 Gen. Government Rents 36225 -46330 Nondwelling Rents 36290 -46330 Other Miscellaneous Revenue 39120 -46330 Recovery Damage City Property Total Revenue Expenses Personal Services 1000 -46330 Accrued Salaries Total Personal Services Supplies 2000 -46330 Office Supplies 2010 -46330 Minor Equipment 2160 -46330 Maint. & Construct Materials 2171 -46330 General Supplies Total Supplies Other Services & Charges 3040 -46330 Legal Fees 3050 -46330 Expert and Professional Services 3060 -46330 Management Services 3100 -46330 Protective Services 3210 -46330 Telephone &Telegraph 3430 -46330 Advertising Other 3600 -46330 Insurance & Bonds 3810 -46330 Electric 3820 -46330 Water 3830 -46330 Gas 3840 -46330 Refuse 3850 -46330 Sewer 4000 -46330 Repair & Maint. Services 4100 -46330 Rents & Leases 4300 -46330 Miscellaneous Charges 4315 -46330 PILOT 4390 -46330 Taxes & Licenses 4500 -46330 Administrative Expenses 4850 -46330 Interest on Deposits Total Other Services & Charges 9/9/2013 12:04 PM Month to Date °/ Year to Date 25.07% - 0.00% 31,286.91 11.20% 28,684.00 97.09% 239,453.00 85.74% 363.00 1.23% 3,267.00 1.17% 498.00 1.69% 5,144.86 1.84% - 0.00% 130.00 0.05% 29,545.00 100.000/0 279,281.77 100.00% 8,752.00 29.62% 70,016.00 25.07% 8,752.00 29.62% 70,016.00 25.07% 187.18 0.63% 1,239.29 0.44% 587.94 1.99% 1,203.07 0.43% 198.71 0.67% 3,839.75 1.37% 87.03 0.29% 1,149.87 0.41% 1,060.86 3.59% 7,431.98 0.00 0.00% 3,740.95 1.34% 13,244.00 44.83% 13,244.00 4.74% 4,772.00 16.15% 38,176.00 13.67% 0.00 0.00% 2,478.47 0.89% 356.01 1.20% 2,805.79 1.00% 0.00 0.00% 65.00 0.02% - 795.57 -2.69% 11,472.07 4.11% 6,551.44 22.17% 29,930.22 10.72% 1,912.44 6.47% 5,799.18 2.08% 1,432.98 4.85% 24,849.12 8.90% 174.82 0.59% 7,594.02 2,72% 0.00 0.00% 2,112.59 0.76% 14,782.95 50.04% 48,370.46 17.32% - 90.00 0.30% 647.31 0.23% 0.00 0.00% 21.00 0.01% 2,027.15 6.86% 16,762.36 6.00% 31.00 0.00% 1,274.38 0.46% 25.66 0.09% 1,205.84 0.43% 13.98 0.05% 112.27 0.04% 44,618.86 151.02% 210,661.03 75.43% Page 1 of 2 9/9/2013 12:04 PM Capital Outlay 5120 -46330 Building & Improvements 0.00 0.00% 1,839.76 0.66% Total Capital Outlay 0.00 0.000/0 1,839.76 0166 -1a Total Expense 54,431.72 184.23% 289,948.77 103.82% Excess (Deficit) Revenue over Expense - 24,886.72 - 84.23% - 10,667.00 3.82% Page 2 of 2 91912013 11:40 AM Parkview Villa -North (165) Cash Flow Statement Period = August 2013 Book = Accrual Month to Date Revenue 33160 Federal Grant 0.00 36220 Gen. Government Rents 28,684.00 36225 Nondwelling Rents 363.00 36290 Other Miscellaneous Revenue 498.00 39120 Recovery Damage City Property 0.00 Total Revenue 29,545.00 Expenses Personnel Services 1000 Accrued Salaries 8,752.00 Total Personnel Services 8,752.00 Supplies 2000 Office Supplies 187.18 2010 Minor Equipment 587.94 2160 Maint. & Construct Materials 0.00 2171 General Supplies 285.74 2280 Vehicle Parts 0.00 Total Supplies 1,060.86 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 13,244.00 3060 Management Services 4,772.00 3100 Protective Services 0.00 3210 Telephone & Telegraph 356.01 3430 Advertising Other 0.00 3600 Insurance & Bonds - 795.57 3810 Electric 6,551.44 3820 Water 1,912.44 3830 Gas 1,432.98 3840 Refuse 174.82 3850 Sewer 0.00 4000 Repair & Maint. Services 14,782.95 4050 Garage, Labor Burd. 0.00 4100 Rent & Leases 90.00 4300 Miscellaneous Charges 0.00 4315 PILOT 2,027.15 4390 Taxes & Licenses 31.00 4500 Administrative Expenses 25.66 4850 Interest on Deposits 13.98 5120 Building & Improvement 0.00 Total Other Services & Charges 44,618.86 Total Expenses 54,431.72 Excess (Deficit) Revenue over Expenses 724,886.72 Page 1 of 2 Parkview Villa -North (165) Cash Flow Statement Period = August 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash 91912013 11:40 AM Month to Date 0.00 56.58 - 182.00 0.00 0.00 - 5,698.32 12,023.11 - 12,192.25 213.98 2,027.15 508.42 (3,243.33) (28,130.05) Beg Cash End Cash Difference 37,318.69 9,188.64 (28,130.05) 871.00 871.00 - 891,214.11 891,214.11 - 929,403.80 901,273.75 (28,130.05) Page 2 of 2 3600 -46330 Insurance & Bonds 165 7/31/2013 City of Columbia Heights (co P- 346432 4061 165 8/31/2013 :PostRecurring Monthly recu 3- 170160 RC 165 8/31/2013 Correct YTD insurance exper 3- 170794 GJ2 Net Change =- 795.57 12,267.64 = Beginning Balance = 17,095.00 0.00 29,362.64 prop & liab ins 0.00 17,890.84 11,471.80 C of Columbia Heights Ins At 0.27 0.00 11,472.07 Correct YTD insurance expen 11,472.67 = Ending Balance = 3810 -46330 Electric 23,378.78 = Beginning Balance = 165 8/12/2013 Xcel Energy (xcel) P- 346082 5150441553 08, 6,551.44 0.00 29,930.22 electric 7/6- 8/5/13 General Ledger Period = Aug 2013 Book = Accrual ; Tree = ysi_tb Property Date Person'/ Description Control ' Reference Debit'. Credit: Balance Remarks 1000 -46330 Accrued Salaries 61,264.00 = Beginning Balance = 165 8/31/2013 :PostRecurring Monthly recu 3- 170160 RC 8,752.00 0.00 70,016.00 R/C CHC PR Mgmt Fee Net Change = 8,752.00 70,016.00 = Ending Balance = 2000 -46330 Office Supplies 11052.11 = Beginning Balance = 165 7/19/2013 Office Depot (offi8804) P- 343933 6.67492E +11 31.51 0.00 1,083.62 mspd;sgr;crmr; pens; ppr; pos 165 7/19/2013 Office Depot (offi8804) P- 343934 6.67492E +11 10.13 0.00 1,093.75 palm /wrist rest 165 7/31/2013 City of Columbia Heights (co P- 346432 4061 145.54 0.00 1,239.29 01/13-06/13 copier allocation Net Change= 187.18 1,239.29 = Ending Balance = 2010 -46330 Minor Equipment 615.13 = Beginning Balance = 165 8/2/2013 HD Supply Facilities Mainten P- 344660 9123982852 24.94 0.00 640.07 vertical headmil 165 8/2/2013 All Inc. (all) P- 344735 x1316844001 563.00 0.00 1,203.07 refrigerator Net Change = 587.94 1,203.07 = Ending Balance = 2160 -46330 Maint. & Construct Materials 3,641.04 = Beginning Balance = 165 8/2/2013 Frattalone's /Metro Ace (frat) P- 344631 015909R 18.42 0.00 3,659.46 basket strainer 165 8/2/2013 HD Supply Facilities Mainten P- 344660 9123982852 175.65 0.00 3,835.11 toilet tank & bowl 165 8/2/2013 HD Supply Facilities Mainten P-344660 9123982852 4.64 0.00 3,839.75 dry wall screws Net Change= 198.71 3,839.75 = Ending Balance = 2171 -46330 General Supplies 1,062.84 = Beginning Balance = 165 8/13/2013 HD Supply Facilities Mainten P- 345771 9124223244 72.71 0.00 1,135.55 bath tissue;sponge;mop 165 8/13/2013 HD Supply Facilities Mainten P- 345771 9124223244 14.32 0.00 1,149.87 vinyl gloves Net Change=87.03 1,149.87 = Ending Balance = 3040 -46330 Legal Fees 3,740.95 = Beginning Balance = Net Change =0.00 3,740.95 = Ending Balance = 3050 -46330 Expert and Professional Services 0.00 = Beginning Balance = 165 7/31/2013 City of Columbia Heights (co P- 346432 4061 494.00 0.00 494.00 2013 audit fees for 2012 165 8/2/2013 Columbia Heights FIRA (colui P- 344807 20132 12,750.00 0.00 13,244.00 2013 servicing fees Net Change= 13,244.00 13,244.00 = Ending Balance = 3060 -46330 Management Services 33,404.00 = Beginning Balance = 165 8/29/2013 Common Bond Housing (chc) P- 347287 08/17/13-08/29 13,524.00 0.00 46,928.00 195516 mgmt fees 8/13 165 8/31/2013 :PostRecurring Monthly recu 7-170160 RC 0.00 8,752.00 38,176.00 R/C CHC PR Mgmt Fee Net Change = 41772.00 38,176.00 = Ending Balance = 3100 -46330 Protective Services 2,478.47 = Beginning Balance = Net Change =0.00 2,478.47 = Ending Balance = 3210 -46330 Telephone & Telegraph 2,449.78 = Beginning Balance = 165 7/31/2013 POPP.com (pope) P- 345683 992123953 222.60 0.00 2,672.38 phone 08/13 165 8/1/2013 level One (leve) P- 343553 0344976IN 76.52 0.00 2,748.90 mainL plan 8/13 165 8/2/2013 Comcast(comc3474) P- 345681 877210505019( 56.89 0.00 2,805.79 internet 08 /11- 09/10/13 Net Change= 356.01 2,805.79 = Ending Balance = 3430 -46330 Advertising Other 65.00 = Beginning Balance = Net Change =0.00 65.00 = Ending Balance = 3600 -46330 Insurance & Bonds 165 7/31/2013 City of Columbia Heights (co P- 346432 4061 165 8/31/2013 :PostRecurring Monthly recu 3- 170160 RC 165 8/31/2013 Correct YTD insurance exper 3- 170794 GJ2 Net Change =- 795.57 12,267.64 = Beginning Balance = 17,095.00 0.00 29,362.64 prop & liab ins 0.00 17,890.84 11,471.80 C of Columbia Heights Ins At 0.27 0.00 11,472.07 Correct YTD insurance expen 11,472.67 = Ending Balance = 3810 -46330 Electric 23,378.78 = Beginning Balance = 165 8/12/2013 Xcel Energy (xcel) P- 346082 5150441553 08, 6,551.44 0.00 29,930.22 electric 7/6- 8/5/13 29,930.22 = Ending Balance = Net Change = 6,551.44 3,886.74 = Beginning Balance = 3820 -46330 Water 1,912.44 0.00 5,799.18 water meter replacement 165 7/31/2013 City of Columbia Heights (co P-346432 4061 5,799.18 = Ending Balance = Net Change = 1,912.44 23,416.14 = Beginning Balance = 3830 -46330 165 6/22/2013 Gas Lubrication Technologies Inc P- 346642 2225493 558.25 0.00 23,974.39 fuel oil 165 6/24/2013 Lubrication Technologies Inc P-346643 2225614 364.82 0.00 24,339.21 fuel oil 165 8/7/2013 CenterPoint Energy (cent) P- 345394 55199657 08 /0; 8.62 0.00 24,347.83 late fee 165 8/7/2013 CenterPoint Energy (cent) P- 345394 55199657 08/0; 501.29 0.00 24,849.12 gas 7/5- 8/5/13 24,849.12 = Ending Balance = Net Change = 1,432.98 7,419.20 = Beginning Balance = 3840 -46330 Refuse 174.82 0.00 7,594.02 garbage/ recycling 165 7/31/2013 Green Lights Recycling Inc ( P- 344772 134283 7,594.02 = Ending Balance = Net Change= 174.82 2,112.59 = Beginning Balance = 3850 -46330 Sewer 2,112.59 = Ending Balance = Net Change =0.00 33,587.51 = Beginning Balance = 4000 -46330 Repair & Maint. Services 0.00 33,787.51 paint & wax floors #803 165 7/29/2013 K.O. Cleaning and Restoratic P- 345902 1489 200.00 165 7/29/2013 K.O. Cleaning and Restorati( P- 346041 1490 200.00 0.00 33,987.51 paint /wax #502 165 7/29/2013 Adam's Pest Control, Inc. (ai P- 344924 812321 51.91 0.00 34,039.42 pest control- 7/29/13 165 7/29/2013 K.O. Cleaning and Restoratic P- 345904 1491 100.00 0.00 34,139.42 repair area behind toilet #10 165 7/29/2013 LBP Mechanical, Inc (Ibpm) P- 343932 w19044 301.42 0.00. 34,440.84 rplc vlv;repair leak 07/15 -07, 165 7/29/2013 K.O. Cleaning and Restoratic P-345902 1489 250.00 0.00 34,690.84 paint & wax floors #803 165 7/29/2013 K.O. Cleaning and Restoratic P- 346041 1490 300.00 0.00 34,990.84 paint /wax #502 165 7/31/2013 All Metro Lawn & Snow, LLC P- 344771 2609 262.50 0.00 35,25334 weekly mowing 07/13 165 8/1/2013 Kone Inc. (kone) P- 345031 221245314 700.01 0.00 35,953.35 elev mainL 08/13 165 8/8/2013 Gardner Plumbing, LLC (gan P- 345030 2686 559.20 0.00 36,512.55 leak rprs #202,411,311,211 - 165 8/12/2013 Kone Inc.(kone) P- 345931 150884020 11,415.41 0.00 47,927.96 elevator repair 07 /29- 30/201 165 8/12/2013 LBP Mechanical, Inc (Ibpm) P- 345910 W19114 442.50 0.00 48,370.46 leak fix in #810 46,370.46 = Ending Balance = Net Change= 14,782.95 557.31 = Beginning Balance 4100 -46330 Rents & Leases 90.00 0.00 647.31 screening-07 /11- 07/18/13 165 7/31/2013 Multihousing Credit Control 1 P- 345453 13070377 647.31 = Ending Balance = Net Change =90.00 21.00 = Beginning Balance = 4300 -46330 Miscellaneous Charges 21.00 = Ending Balance = Net Change =0.00 14,735.21 = Beginning Balance = 4315 -46330 PILOT 2,027.15 0.00 16,762.36 Anoka Cry Property Tax Accrc 165 8/31/2013 :PostRecurring Monthly recu 3- 170160 RC 16,762.36 = Ending Balance = Net Change= 2,027.15 1,243.38 = Beginning Balance 4390 -46330 Taxes & Licenses 0.00 1,274.38 elevator annual opera 165 8/2/2013 MN Dept of Labor & Industry P- 345762 ALR0030481I 31.00 1,274.38 = Ending Balance = Net Change =31.00 1,180.18 = Beginning Balance = 4500 -46330 Adminstrative Expenses 0.00 1,205.84 194819 qtrly training 7/25/1: 165 8/29/2013 Common Bond Housing (chc) P- 347287 08/17/13 -08/29 25.66 1,205.84 = Ending Balance = Net Change =25.66 98.29 = Beginning Balance = 4850 -46330 Interest on Deposits 0.00 112.27 Sec Delp interest accrual 165 8/31/2013 Sec Dep interest accrual 3- 170793 G31 13.98 112.27 = Ending Balance = Net Change =13.98 81,074.56 26,642.84 Parkview Villa North Bank Reconciliation Report 08/3112013 5016456 Balance Per Bank Statement as of 08131/2013 Outstanding Checks Check date Check number 08/20/2013 2173 08/2.0/2013 2181 08/27/2013 2183 08127/2013 2184 08/27/2013 2185 08/27/2013 2187 08/27/2013 2188 08/27/2013 2189 Less: Outstanding Checks Payee allm2138 - All Metro Lawn & Snow, LLC off18804 - Office Depot colu - City of Columbia Heights comc3474 - Comcast kocl - K.O. Cleaning and Restoration LLC lbpm - LBP Mechanical, Inc lubr - Lubrication Technologies Inc xcel -Xcel Energy Reconciled Bank Balance Balance per GL as of 08131/2013 Difference Cleared Items : Cleared Checks Reconciled Balance Per GIL 38,163,66 (Reconciled Bank Balance And Reconciled Balance Per G /L) Date Tran # 07/16/2013 2145 07/16/2013 2149 07/16/2013 2150 07/23/2013 2153 07/30/2013 2162 07/30/2013 2163 07/3012013 2164 07130/2013 2165 08/06/2013 2166 08/06/2013 2167 08/06/2013 2168 08106/2013 2169 0811312013 2170 Amount 262.50 41.64 19,646.98 56.89 1,050.00 442.50 923.07 6,561.44 28,975.02 9,188.64 09104/2013 9,188,64 9,188.64 0.00 Amount Date Cleared Notes kocl - K.O. Cleaning and Restoration LLC 700.00 08/31/2013 lubr - Lubrication Technologies Inc 118.12 08/3112013 lubf900 - Lubrication Technologies, Inc. 164.70 08/31/2013 alim2138 - All Metro Lawn & Snow, LLC 262.50 08/31/2013 chc - CommonBond Housing 23.74 08/31/2013 home7 - HO Supply Facilities Maintenance, Ltd. 26.49 08/31/2013 home9055 - Home Depot Credit Services 13.80 08/31/2013 xcel - Xcel Energy 5,647.49 08/31/2013 cent - CenlerPoint Energy 57.4.72. 08/31/2013 chc - CommonBond Housing 13,568.06 08/31/2013 colu - City of Columbia Heights 26.90 08/31/2013 home7 - HD Supply Facilities Maintenance, Ltd. 95.18 08/31/2013 Ibpm - LBP Mechanical, Inc 301.42 08/31/2013 Parkview Villa North 09/04/2013 Total Cleared Deposits 30,128.00 Bank Reconciliation Report 08131/2013 5016456 Cleared Checks Date Tran # Notes Amount Dale Cleared 08/13/2013 2171 leve - Level One 76.52 08/31/2013 08/20/2013 2172 adam - Adam's Pest Control, Inc. 51.91 08/31/2013 08/2012013 2174 coluhra - Columbia Heights HRA 12,750.00 08/31/2013 0812.012013 2175 frat - Fraltalone's /Metro Ace _ 18.42 08/31/2013 08/20/2013 2176 gard1086 - Gardner Plumbing, LLC - 559.20 08/31/2013 08/2012013 2177 greel004 - Green Lights Recycling Inc 174.82 08/31/2013 08/20/2013 2178 home7 - 11D Supply Facilities Maintenance, Ltd. 73.27 08/31/2013 08/2012013 2179 kone - Kone Inc. 700.01 _ 08/31/2013 08/20/2013 2180 multi - Multihousing Credit Control 90.00 08/3112013 08/20/2013 2182 popp - Popp.com 222.60 08/31/2013 Total Cleared Checks 36,239.87 Cleared Deposits Date Tran # Notes Amount Data Cleared 08/05/2013 500' 24,049.00 08131/2013 08/0512013 501 - 215.00 08/31/2013 08/05/2013 503 1,663.00 08/31/2013 08/06/2013 502 1,429.00 08131/2013 08/06/2013 504 474.00 08/31/2013 08/06/2013 505 622.00 08/31/2013 08/09/2013 506 669.00 0813112013 08/12/2013 607 364.00 08/31/2013 08/13/2013 508 643.00 08/31/2013 Total Cleared Deposits 30,128.00 Date 8/30/13 Page 1 Primary Account OXXXXX@6456 Enclosures 32 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- CHANGE NOTICE EFFECTIVE SEPTEMBER 1, 2013: *CANADIAN CHECK ITEM PROCESSING FEE - $1,000 OR LESS = $5.00, $1,001 OR GREATER = $10.00. *REDEPOSITED RETURN ITEM FEE _ $4.00 *AN INTEREST CHARGE FOR NEGATIVE AVERAGE COLLECTED BALANCE EQUAL TO AN INTEREST RATE OF PRIME PLUS 4% WILL BE APPLIED TO BUSINESS CHECKING ACCOUNTS ON ANALYSIS EACH STMT CYCLE. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX06456 Previous Balance 44,275.53 9 Deposits /Credits 30,128.00 23 Checks /Debits 36,239,87 Electronic Debit .00 Service Charge .00 Interest Paid - .00 Ending Balance 38,163.66 Number of Images 32 Statement Dates 8/01/13 thru 8/31/13 Days in the Statement Period 31 Average Ledger 50,601 Average Collected 49,682 ****** W* W** W* w*** w* ww********************** W*** *W *WW * *W * * * * * * * * ** * *ww * *W * * * * *W Deposits and Credits Date Description Amount 8/06 DDA REGULAR DEPOSIT 215.00 8/06 DDA REGULAR DEPOSIT .1,429.00 8/06 DDA REGULAR DEPOSIT 1,663.00 8/06 DDA REGULAR DEPOSIT 24,049.00 8/07 DDA REGULAR DEPOSIT 474.00 8/07 DDA REGULAR DEPOSIT 622.00 8/12 DDA REGULAR DEPOSIT 669.00 8/13 DDA REGULAR DEPOSIT 364.00 8/13 DDA REGULAR DEPOSIT 643.00 Checks in serial order Date Check# Amount Date Check# ' Amount 8/16 2145 700,00 8/05 2164 13.80 8/21 2149* 118.12 8 /05 2165 5,647.49 8/21 2150 164.70 8/12 2166 574,72 8/06 2153* 262,50 8/08 2167 13,568.06 8 /01 2162* 23.74 8/09 2168 26.90 8/07 2163 26.49 8/13 2169 95.18 * Indicates skip in check numbers Date 8/30/13 Page 2 Primary Account @XXXXX @6456 Enclosures 32 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Date Checks in Date serial order Check# Amount Date Check$ Amount 8/20 2170 301.42 8/29 2177 174.82 8/19 2171 76.52 51.91 8/30 8/30 2178 2179 73.27 700.01 .. 8/28 8/28 2172 2174* 12,750.00 8/28 2180 90.00 8/29 2175 18.42 8/29 2182* 222.60 8/30 2176 559.20 M E N T * ** * Indicates skip in check numbers Daily Date Balance Section Balance Date Balance Date Balance 8/01 44,251.79 8/09 53,158.55 8/20 8/21 53,086.71 52,803.89 8/05 8/06 38,590.50 65,684.00 8/12 8/13 53,252.83 54,164.65 8/28 39,911.98 8/07 66,753.51 8/16 53,464.65 8/29 39,496.14 8/08 53,185.45 8/19 53,388.13 8/30 38,163.66 * * * E N D O F S T A T E M E N T * ** Payment Summary Bank= 165opr AND mm /yy= 08/2013- 08/2013 AND All Checks =Yes AND Include Volds =All Checks Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 2166 cent - CenterPoint Energy ..w.r 08/06/2013 08/2013 574.72 165opr - Parkvlew Villa North 2167 chc - CommonBond Housing 08/06/2013 08/2013 13,568.06 165opr - Parkview Villa North 2168 colu - City of Columbia Heights 08/06/2013 08/2013 26.9 165opr - Parkview Villa North 2169 home? - HD Supply Facilities Maintenance, Ltd. 08/06/2013 08/2013 95.18 165opr - Parkvlew Villa North 2170 Ibpm - LBP Mechanical, Inc 08/13/2013 08/2013 301.42 165opr - Parkvlew Villa North 2171 leve - Level One 08/13/2013 08/2013 76.52 165opr - Parkview Villa North 2172 adam - Adam's Pest Control, Inc. 08/20/2013 08/2013 51.91 165opr - Parkview Villa North 2173 allm2138 - All Metro Lawn & Snow, LLC 08/20/2013 08/2013 262.5 165opr - Parkvlew Villa North 2174 coluhra - Columbia Heights HRA 08/20/2013 08/2013 12,750.00 165opr - Parkvlew Villa North 2175 frat - Frattalone's /Metro Ace 08/20/2013 08/2013 18.42 165opr - Parkview Villa North 2176 gard1086 - Gardner Plumbing, LLC 08/20/2013 08/2013 559.2 165opr - Parkvlew Villa North 2177 gree1004 - Green Lights Recycling Inc 08/20/2013 08/2013 174.82 165opr - Parkvlew Villa North 2178 home? - HD Supply Facilities Maintenance, Ltd, 08/20/2013 08/2013 73.27 165opr - Parkview Villa North 2179 kone - Kone Inc. 08/20/2013 08/2013 700.01 165opr - Parkview Villa North 2180 multl - Multihousing Credit Control 08/20/2013 08/2013 90 165opr - Parkvlew Villa North 2181 off18804 - Office Depot 08/20/2013 08/2013 41.64 165opr - Parkview Villa North 2182 Popp - Popp.com 08/20/2013 08/2013 222.6 165opr - Parkview Villa North 2183 colu - City of Columbia Heights 08/27/2013 08/2013 19,646.98 165opr - Parkvlew Villa North 2184 comc3474 - Comcast 08/27/2013 08/2013 56.89 165opr - Parkvlew Villa North 2185 kocl - K.O. Cleaning and Restoration LLC 08/27/2013 08/2013 1,050.00 165opr - Parkview Villa North 2186 kone - Kone Inc. 08/27/2013 08/2013 0 165opr - Parkvlew Villa North 2187 Ibpm - LBP Mechanical, Inc 08/27/2013 08/2013 442.5 165opr - Parkvlew Villa North 2188 lubr - Lubrication Technologies Inc 08/27/2013 08/2013 923.07 165opr - Parkvlew Villa North 2189 xcei - Xcel Energy 08/27/2013 08/2013 6,551.44 58,258.05 �"I IK C N o w W N S 0 p 1 O ID c N a N N 0 0 C N �% C N N S o p 1 N a N N O m n N O J 00 N `—D 0, N c 2 N C_ 2 u N N 2 A N N 2 ti n C7 (on N W (7 0 N O A- N N Z N O O = X c w m s 0 n � c m N O N n Z O N O N N O O G 0 c 3 Q WJ UWi O� -• V W W O O m (D N n Z 0 c a m V W W N O1 m W m J UV1 -q Cl) J' W C J W 0 A N O V N O l0 lh W O J N W N O J A V W N O A U t N J O (T Ol W O J O W W d N N _ A O 3 W m W O J o W W W N N J JN(D V rn� A D m 0 W W 0 O J --� O Parliview Villa North Financial Statement Overview September 2013 Revenue: Occupancy for the month of September 2013 was 98 % occupied; Rent Revenue was under budget (unfavorable) and reflects occupancy Total Revenue for September was over budget (favorable) and this was due to drawing down the operating grant in September Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Legal Services was under budget (favorable) Utilities: Utilities Expenses were under budget (favorable), however this reflects some quarterly billing Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects August billing Gas was under budget (favorable) and reflects August billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing OperatinjI and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was under budget (favorable) Garbage and Trash was under budget (favorable); however, this is a quarterly billing Elevator Maintenance Contract is over budget (unfavorable) and reflects the cost of upgrade replacement to the computer board for the elevator Heating, Cooling Maintenance and Repairs was under budget (favorable) Decorating Contract was under budget (favorable) my O] ° g W < w O z P� N. m + �ONJNy BOO N iD +NS O NoNA O WS WW JN(Wi�AN nioNOO QO � + +0 N S S (D 1O WOwJO+ W VOON O -� OW ffJJ `iO J00000 3. c. mG S m n'yq� �'o m y °?$ m d n ?C �N.<N o.cc a a�3.m m(��aW m $3 <�38 �1j1 $$dm 3 N 0? N 1 1 J Y w A W W °o °o (O O O O O O O om °o oo °oa °O S O O O O O O W O i is 1! O(V1�lWJSSVWW OJ0000 �N� IJWmJN (WJ Ww0 jSW &W W�ONN W�N J�OOS,X� O O O yy�� to y V W S J N fJ WWS tt O A S S J J O O . ;j im j N S IVp LNi 1N11 N W O Z � . A A JN J U1W O+ O O N O W D O O W O O O O N W W O O N A {({N 1�pypy � Wm SA� WN J O OWY (nN+ W W WN + A Ol m J V V b P +1 yy O b A N pP� A O W N A O O OWl J 1N� �{NJ� b S N S N W S b O V� o W O+ O 0 0 0 . N N W S1 W .. 0 �J OA+ fwil W WW _ION 'J A+P(Ai� _NW iUl N N Q�pN iW(O OJNN �N y N, .+ 3L V N J i Np W W b J Q mO W N °�N� N N N JN(nNN O1 OWWI NW-�S OPN O1 m W J W N J 01 0 0+ 0 0 �'~J N WN Po P W A p IJ W W O j i N N N W T Iyya Z N A OI UWi Owi O N iqAq�� y •P . TNNDNOJ(�OJ ONO AA00�001 �f1 � N AWW N NAW y ONm G yN� $j O O P+ O N 00 6 my O] ° g W < w O z P� N. m + 0 v5'0 9a -Ni "m -g .- R � a = i N J WN (O� O IJn J m N O N O w N O N �A O i ON W A 0000 00 O �OOOOIOW W +O (OON +� �I NI oNNO W+ v °� bWONAAAtNp �°Ni NN W WOO Wo N � A-�N°I V W � J 0 4NI O N lJli O V J W O O J V J N J O N J N N A +P pP P W i 1Jli W O N W O N OWl J N OJI A d O A J W po J A A (WJ n in n (n °N i 888. tA1i N J O O J A NW °Ni yN 8% NW O Z W O °oD o `°mo °oo °oauym °+ w v W ° a N .fir vl 0 Z d m � m N J N J d S2 W mA�oNONO� ~ y jp q + W N O N W J m m O A A N +� W OI N N A N NO�WA nWj b NW N o W OBI 00 ON O q O +NOWNW N�N Ob�O A NN W W (An Ny O pmp 8; N A P 1° 10 N O N ^I Np N O W O it v v T WJ i J NA_f�J N A W NW W N +ONp pp�VO A �` 0 V��W AT +Jd pW WN W yv N(JJN +NOWiNW O 0000000000 0 O pWjW JAN (NnO w v W ° a N .fir vl 0 Z d m � m N J N J d S2 W mA�oNONO� ~ (O ON1 NO�WA (11 W O it BOO X00 OOOOO OD O 0000000000 0 O w v W ° a N .fir vl 0 Z d m � m N i 0 "s Z�zz 7 DZ� DDDD DD ji n j 1 W W W J yOy( W (s J J ,�^OyI A yW� L W A I i mk C y 4 A n y o O V - i o e yg y A � m ri� Q�G�aAg'n� AAAA�' }� R• E'3� �rv� A PP�a� y 9 w K^DAa } i y , i N � H p A A b pp� p �� p AO H�P) O 00 O -ry W NA WN O 000 pA InNO NiYI O 00 00 y OI ii iio I (O (O ,oJ1 N N O O OOO N (yO� A ,N QJj YS NN (O O O O O O O O O O (NJ W i �Hy W (Wil W yW W 0 l0 NP A Y p O m OJ NN �y� v mw o 000 v'iu °o i ,j'P (I °o o $ >> F z zzzz zz f � J m J 'O OO ,0000 p O 'O , O O D DD D DD`DD DDD i o I j J T A NN id ro AL 10 wIJ W W I A -`� (J !(J (WJ AA p N .8o0 b[ ai m m'J Z�zz 7 DZ� DDDD DD ji n j 1 W W W J yOy( W (s J J ,�^OyI A yW� L W A I i mk w A W a a " N N ��3 s d ^ Y y' 000 Cpl J O NN aN (� A 0000 HOO 00� 1N �y ti u R O DO O C o u O o a� a2 d.8 gFR222� m m Fag m 00000a v W 3 Pam »Q X08 08 =' v5 m D� F 9 9z N r v N �e qu 00 °0 N O A AN m O O O O O O ppppp O a O O O O O O 0 0 0 0 0 0 O W q + + W N+ N lypb W w N AOJb p� O 0 O VNi tW00 W W 0 0 0 O Ip Vii N 7Z ZZ2 fZZZZZ 2t DD D DDDDD DDDDDD D W N W+ W A W O P O .1. O O p O O O 0 0 0 0 0 0 N N m W+ A N N O 0 41A OHO A WN JNOO(ji0 + ZZ D>ZZZZZ DD DDDDD 00 Oo 000000 `Fgar V µ O O G n, m a. Q Parkview Villa -North (165) Balance Sheet September 2013 Books = Accrual Sep -13 Assets 46,793.29 10100 Cash Balance 871.00 10200 Petty Cash 891,214.11 10400 Investments 3,242.20 11300 Rent Receivable 408.12 11500 Accounts Receivable 4,273.74 15510 Prepaid Insurance 946,802.46 Total Assets _- Liabilities 20,798.44 20200 Accounts Payable 20210 Accrued Other Expenses 551.74 20220 Due to Resident Council 18,139.79 22000 Deposits 18,244.35 22200 Accrued PILOT 2,934.12 22210 Revenue Collected in Advance 60,668.44 Total Liabilities Fund Balance 886,134.02 25300 Fund Balance 886,134.02 Total Fund Balance - 946,802.46 Total Liabilities and Fund Balance Supplies 2000 -46330 Office Supplies 0.00 0.00% 1,239.29 0.36% 10110/2013 1:19 PM Parkview Villa -North (165) 0.00% 1,203.07 0.35% 2160 -46330 Maint. & Construct Materials 692.83 Income Statement 4,532.58 1,32% 2171 -46330 General Supplies 84.60 0.13% For The Period Ending September 2013 0.36% Total Supplies 777.43 1.190/0 8,209.41 Books = Accrual 3430 -46330 Advertising Other 0.00 0.00% 65.00 0.02% 3600 -46330 Insurance & Bonds Month to Date 2.18% % Year to Date 3810.46330 Electric Revenue 9.02% 35,814.55 10.40% 3820 -46330 Water 0.00 33160-46330 Federal Grant 36,676.50 1.68% 56.25% 67,963.41 19.74% 36220.46330 Gen. Government Rents 27,654.00 3840 -46330 Refuse 42.41% 267,107.00 77.60% 36225 -46330 Nondwelling Rents 363.00 0.00 0.56% 3,630.00 1.05% 36290 -46330 Other Miscellaneous Revenue 514.00 2.92% 0.79% 5,658.86 1.64% 39120 -46330 Recovery Damage City Property 0.10% - 0.00% (130.00) -0.04% Total Revenue 65,207.50 0.01% 100.000/0 344,229.27 100.00% Expenses S.46% 4390 -46330 Taxes & Licenses 69.00 0.00% 1,343.38 Personal Services 4500.46330 Administrative Expenses 0.00 0.00% 1,205.84 0.35% 1000-46330 Accrued Salaries 8,752.00 0.02% 13.42% 78,768.00 22.88% Total Personal Services 8,752.00 227,929.74 13.42% 78,768.00 22.88070 Supplies 2000 -46330 Office Supplies 0.00 0.00% 1,239.29 0.36% 2010 -46330 Minor Equipment 0.00 0.00% 1,203.07 0.35% 2160 -46330 Maint. & Construct Materials 692.83 1.06% 4,532.58 1,32% 2171 -46330 General Supplies 84.60 0.13% 1,234.47 0.36% Total Supplies 777.43 1.190/0 8,209.41 0.92% Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 3,740.95 1.09% 3050 -46330 Expert and Professional Services 0.00 0.00% 13,244.00 3.85% 3060 -46330 Management Services 4,772.00 7.32% 42,948.00 12.48% 3100 -46330 Protective Services 265.66 0.41% 2,744.13 0.80% 3210 -46330 Telephone & Telegraph 361.24 0.55% 3,167.03 0.92% 3430 -46330 Advertising Other 0.00 0.00% 65.00 0.02% 3600 -46330 Insurance & Bonds 1,424.58 2.18% 12,896.65 3.75% 3810.46330 Electric 5,884.33 9.02% 35,814.55 10.40% 3820 -46330 Water 0.00 0.00% 5,799.18 1.68% 3830 -46330 Gas 481.16 0.74% 25,330.28 7.36% 3840 -46330 Refuse 0.00 0.00% 7,594.02 2.21% 3850 -46330 Sewer 0.00 0.00% 2,112.59 0.61% 4000 -46330 Repair & Malnt. Services 1,907.25 2.92% 50,277.71 14.61% 4100 -46330 Rents & Leases 62.98 0.10% 710.29 0.21% 4300 -46330 Miscellaneous Charges 0.00 0.00% 21.00 0.01% 4315 -46330 PILOT 2,027.15 3.11% 18,789.51 S.46% 4390 -46330 Taxes & Licenses 69.00 0.00% 1,343.38 0.39% 4500.46330 Administrative Expenses 0.00 0.00% 1,205.84 0.35% 4850 -46330 Interest on Deposits 13.36 0.02% 125.63 0.04% Total Other Services & Charges 17,268.71 26.48% 227,929.74 66.21% Page 2 of 7 10/10/2013 1:19 PM Capital Outlay 5120 -46330 Building & Improvements 0.00 0.00% 1,839.76 0.53% Total Capital Outlay 0.00 0.000% 1,839.76 0.53% Total Expense 26,798.14 41.100/0 316,746.91 92.02% Excess (Deficit) Revenue over Expense 38,409.36 58.90% 27,482.36 7.98% Page 3 of 7 10/1012013 1:19 PM Parkvlew Villa -North (165) Cash Flow Statement Period = September 2013 Book = Accrual Month to Date Revenue 33160 Federal Grant 36,676.50 36220 Gen. Government Rents 27,654.00 36225 Nondwelling Rents 363.00 36290 Other Miscellaneous Revenue 514.00 39120 Recovery Damage City Property 0.00 Total Revenue 65,207.50 Expenses Personnel Services 1000 Accrued Salaries 8,752.00 Total Personnel Services 8,752.00 Supplies 2000 Office Supplies 0.00 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 692.83 2171 General Supplies 84.60 2280 Vehicle Parts 0.00 Total Supplies 777.43 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 0.00 3060 Management Services 4,772.00 3100 Protective Services 265.66 3210 Telephone & Telegraph 361.24 3430 Advertising Other 0.00 3600 Insurance & Bonds 1,424.58 3810 Electric 5,884.33 3820 Water 0.00 3830 Gas 481.16 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repair & Maint. Services 1,907.25 4050 Garage, Labor Burd. 0.00 4100 Rent & Leases 62.98 4300 Miscellaneous Charges 0.00 4315 PILOT 2,027.15 4390 Taxes & Licenses 69.00 4500 Administrative Expenses 0.00 4850 Interest on Deposits 13.36 5120 Building & Improvement 0.00 Total Other Services & Charges 17,268.71 Total Expenses 26,798.14 Excess (Deficit) Revenue over Expenses 38,409.36 Page 4 of 7 Parkview Villa -North (165) Cash Flow Statement Period = September 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash 10/10/2013 1:19 PM Month to Date 0.00 0.00 - 400.10 -18.00 0.00 1,424.58 - 5,562.80 0.00 -34.64 2,027.15 1,759.10 (804.71) 37,604.65 Cash End Cash Difference 9,188.64 46,793.29 37,604.65 871.00 871.00 - 891,214.11 891,214.11 - 901,273.75 938,878.40 37,604.65 Page 5 of 7 Parkview Villa -North (165) 1,239.29 = Beginning Balance = 2000-46330 Office Supplies 1,239.29 = Ending Balance = General Ledger Net Change =0.00 Period = Sep 2013 1,203.07 = Beginning Balance = 2010-46330 Minor Equipment Book = Accrual; Tree = ysi_tb Debit Balance Remarks Net Change =0.00 Date Person /DescNption Control Reference .Credit 70,016.00 = Beginning Balance = Property 1000-46330 Accrued Salaries 2160 -46330 8,752.00 0.00 78,768.00 R/C CHC PR Mgmt Fee 0.00 3,845.26 misc main supplies 9/30/2013 :PostRecurring Monthly recurring 1- 172460 RC 78,768.00 = Ending Balance = 165 Net Change = 8,752.00 9124521396 17.49 0.00 4,038.40 toilet tank/bowl 165 8/27/2013 1,239.29 = Beginning Balance = 2000-46330 Office Supplies 1,239.29 = Ending Balance = Net Change =0.00 1,203.07 = Beginning Balance = 2010-46330 Minor Equipment 1,203.07 = Ending Balance = Net Change =0.00 3,839.75 = Beginning Balance = 2160 -46330 Maim. & Construct Materials 5.51 0.00 3,845.26 misc main supplies 7/29/2013 Fratlalone's /Metro Ace (fron P- 350120 0124521 0.00 3,862.75 showerheads 165 8/27/2013 HD Supply Faclllties Maintenance, P- 347621 9124521396 17.49 0.00 4,038.40 toilet tank/bowl 165 8/27/2013 HD Supply Faclllties Maintenance, P- 347622 9124521393 175.65 0.00 4,055.89 heads 165 8/28/2013 HD Supply Facilities Maintenance, P- 347623 9124563941 1].49 0.00 4,379,56 shim 165 8129/2013 HD Supply Facilities Maintenance, P- 348268 9124529984 0.00 4,489.68 toilet boW 165 8/30/2013 HD Supply Faclllties Maintenance, P- 348214 9124619393 111.62 bar 165 9113/2013 HD Supply Facilities Maintenance, P- 349732 9124911014 39'72 0.00 4,532.58 puttybknife /joint cement 165 9/16/2013 Frattalone'S /Metro Are (flat) P- 350138 01636IR 4,532.58 = Ending Balance = 165 Net Change= 692.83 851.42 = Beginning Balance = 2171 -46330 General Supplies 84.60 0.00 936.02 towels 8/23/2013 Buckeye Cleaning Centers(buck8 P-348299 ]62101 936.02 = Ending Balance = 165 Net Change =84.60 - 3,740.95 = Beginning Balance = 3040 -46330 Legal Fees 3,740.95 = Ending Balance = Net Change =0.00 13,244.00 = Beginning Balance = 3050 -46330 Expert and Professional Services 13,244,00 = Ending Balance = Net Change =0.00 38,176.00 = Beginning Balance = 3060 -46330 Management Services 13,524.00 165 9/28/2013 Commoneand Housing (chc) P-351037 9281355501 0.00 8,7502.00 42,948.00 R/C CHC PR Mlgmt Fee 9/3012013 :PostRecurring Monthly recurring 1-172460 RC 42,948.00 = Ending Balance = 165 Net Change = 4,772.00 2,4]8.4] = Beginning Balance = 3100 -46330 Protective Services 265.66 0'00 /sprinkler 1 4.13 fir 9/1/2013 Trans -Alarm Inc (flan) P- 348460 RMR884233 2,7 Ending Balance 165 Net Change= 265.66 2,805.79 = Beginning Balance = 3210 -46330 Telephone & Telegraph 221.98 0.00 3,027.77 phone 9/13 165 8/31/2013 POPP. Cum (Popp) P- 349]39 992130536 26.52 0.00 3,104.29 phone 09/13 9/1/2013 Level One (]eve) P- 347782 035180J]N 5.52 0.00 3,109.81 late fee 9/2/13 165 9/2/2013 Comcast (comc3422) P- 349090 877210505019! 0.00 internet /13 165 9/2/2013 Cemcas[(comc3422) P- 349090 877210505019( 57.22 3,167.03 ng/Balance0 165 Net Change= 361.24 65.00 = Beginning Balance = 3430-46330 Advertising Other 65.00 = Ending Balance = Net Change =0.00 11,472.07 = Beginning Balance = 3600 -46330 Insurance & Bond - 1,A29.58 0.00 12,896.65 C of Columbia Hel9 Cs ns 9/30/2013 :PostRecurring Monthly recurring 1-172460 RC 12,896.65 = Ending Balance = 165 Net Change = 1,424.58 29,930.22 = Beginning Balance = 3810 -46330 Electric 350151 5150441553 09 5,884.33 0.00 35,814.55 - BEnding 165 9/11/2013 Xcel Energy (xcel) P- 814.55 Balance c Net Change= 5,884.33 5,799.18 = Beginning Balance = 3820 -46330 Water 5,799.18 = Ending Balance = Net Change =0.00 23,643.23 = Beginning Balance = 3830 -46330 Gas P- 349713 55199657 09/0 7,65 0.00 23,650.88 late fee 9 /6/13 165 916/2013 CenterPolnt Energy (cent) 4]3.51 0.00 9 BEnding /Balance 165 9/6/2013 CenterPolnt Energy (cent) P-349]13 55199657 09/0- 24124.39 = Net Change= 481.16 7,594.02 = Beginning Balance = 3840-46330 Refuse 71594.02 = Ending Balance = Net Change =0.00 2,112.59 = Beginning Balance = 3850 -46330 Sewer 2,112.59 = Ending Balance = Net Change =0.00 48,370.46 = Beginning Balance = 4000 -46330 Repair & Maint. Services 165 8/2512013 K.O. Cleaning and Restoration LL1 P-347767 1512 165 8127/2013 Adam's Pest Control, Inc Were) P-347380 820642 165 8/29/2013 HO Supply Facilities Maintenance, P- 348268 9124579984 165 8/3112013 All Metro Lawn & Snow, LLC (ail, P-3488465 22126]]36 165 9/1/2013 Kone Inc.(kne) P- 35038] 89204 165 9/912013 Drain King, nc.(dral7]40) 165 9/15/2013 Sitzmann Construction dba Sitzm P- 350446 579892 165 9/18/2013 Direct Home Appliance Services h P- 350066 91813165 Net Change = 1,907.25 4100 -46330 Rents & Leases 165 8/28/2013 Talx the Work Number (tali) P- 350725 1384809 165 9/11/2013 Tula the Work Number (taix) P- 348552 1396700 Net Change =62.98 4300 -46330 Miscellaneous Charges Net Change =0.00 4315 -46330 PILOT 165 9/30/2013 :PostRecurring Monthly recurring ]- 1]2460 RC Net Cha nge= 2,027.15 4390 -46330 Taxes & Licenses 165 9/1/2013 MN Dept of Labor & Industry (mn P- 349723 ALR00323891 Net Change =69.00 4500 -46330 Administrative Expenses Net Change =0.00 4850 -46330 Interest on Deposits 165 9/30/2013 Sec Dep interest accrual ]- 1]34]1 G11 Net Change =13.36 175.00 0.00 48,545.46 repair /paint closet #211 75,23 0.00 48,620.69 pest control #902 & 311 E 58.01 0.00 48,678.70 cleaning 262.50 0.00 48,941.20 grounds malnt 8/1- 16/201 700.01 0.00 49,641.21 maint- 09/01- 09/30/13 135.00 0.00 49,776.21 ks drain #608 9/9/13 334.65 0.00 50,110.86 repairs #903 6/7- 7/1/13 166.85 0.00 50,277.71 dryer repair 9/18/13 50,277.71 = Ending Balance = 647.31 = Beginning Balance = 56.23 0.00 703.54 commitment not met 6.75 0.00 710.29 emply verify 8/13 710.29 = Ending Balance = 21.00 = Beginning Balance = 21.00 = Ending Balance = 16,762.36 = Beginning Balance = 2,027.15 0.00 18,789.51 Anoka Cty Property Tax A, 18,789.51 = Ending Balance = 1,274.38 = Beginning Balance = 69.00 0.00 1,343.38 elev license 1,343.38 = Ending Balance = 1,205.84 = Beginning Balance = 1,205.84 = Ending Balance = 112.27 = Beginning Balance = 13.36 0.00 125.63 Sec Dep interest accrual 125.63 = Ending Balance = 35,550.14 8,752.00 Parkview Villa North Rank Reconciliation Report 09/30/2013 5016456 Balance Per Bank Statement as of 09/3012013 outstanding Checks Check date Check number 09/2512013 2203 09/25/2013 2204 09/2512013 2205 09/25/2013 2206 09/25/2013 2207 Less: Outstanding Checks 48,647.30 Payee Amount comc3422 - Comcast 62.74 dire- Direct Home Appliance Services 166.85 home7 - HD Supply Facilities Maintenance, Ltd. 702.43 kone - Kone Inc. 700.01 Popp - Popp.com 221.98 Reconciled Bank Balance Balance per GL as of 09130/2013 Reconciled Balance Per G/L Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items : Cleared Checks 1,854.01 46,793.29 10/08/2013 46.793.29 46,793.29 0.00 Date Tran # Notes Amount Date Cleared 08/20/2013 2173 allm2138 - All Metro Lawn & Snow, LLC 262.50 09/3012013 08/20/2013 2181 offi8804 - Office Depot 41.64 09/30/2013 0812712013 2183 colu - City of Columbia Heights 19,646.98 09/30/2013 08/27/2013 2184 comc3474 - Comcasl 56.89 09/30/2013 08/27/2013 2185 kocl - K.O. Cleaning and Restoration LLC 1,050.00 09/30/2013 08/2712013 2187 Ibpm - LBP Mechanical, Inc 442.50 09/3012013 08/27/2013 2188 lubr - Lubrication Technologies Inc 923.07 09/30/2013 0812712013 2189 xcel - Xcel Energy 6,551.44 09/30/2013 09/04/2013 2190 all - All Inc. - 563.00 09/30/2013 09/04/2013 2191 cent - CenterPoint Energy 509.91 09/30/2013 09/0412013 2192 home7 - HD Supply Facilities Maintenance, Ltd. 205.23 09/30/2013 09/04/2013 2193 mnde - MN Dept of Labor & Industry 31.00 09/30/2013 09/10/2013 2194 adam - Adam's Pest Control, Inc. 75.23 09130/2013 09/10/2013 2195 buck8411 - Buckeye Cleaning Centers 84.60 09/30/2013 09/10/2013 2196 chc - CommonBond Housing 13,549.66 09/30/2013 09/10/2013 2197 home7 - HD Supply Facilities Maintenance, Ltd. 87.03 09/30/2013 Cleared Checks Date Tran # 09/10/2013 2198 09/10/2013 2199 09/1012013 2200 09118/2013 2201 09118/2013 2202 Total Cleared Checks Cleared Deposits Date Tran # 09/03/2013 510 09/03/2013 513 09/04/2013 511 09104/2013 512 09/0412013 514 09/05/2013 515 09/05/2013 516 09/06/2013 520 09/09/2013 518 09/11/2013 517 Total Cleared Deposits Cleared Other Items Date Tran # 09/04/2013 JE 173231 09/06/2013 JE 174487 Total Cleared Other Items Parkview Villa North Bank Reconciliation Report 09/30/2013 5016456 Notes Amount kocl - K.O. Cleaning and Restoration LLC 175.00 kone - Kone Inc. - 11,415.41 leve - Level One 76.52 alim2138 - All Metro Lawn & Snow, LLC 262.50 chc - Common6ond Housing 6.75 56,016.86 Notes Notes Amount 568.00 19,130.00 725.00 2,511.00 2,473.00" 1,873.00 579.00 1,381.00 428.00 56.00 29,724.00 10/08/2013 Date Cleared 09/30/2013 0 9/3 012 01 3 09/30/2013 09/30/2013 09/30/2013 Date Cleared 09/30/2013 09/30/2013 09/30/2013 09/30/2013 09/30/2013 09/30/2013 09/30/2013 09/30/2013 09/30/2013 09/30/2013 Amount Date Cleared ELoccs Operating Fund Disbursement 36,676.50 09/30/2013 9/6 deposit error, bank dep was 1481 not 1381 100.00 09/30/2013 36,776.50 Date 9/30/13 Page 2 Primary Account @XXXXX @6425 Enclosures NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Checks in serial order Amount Date Check# Amount Date Check# 213.90 9/10 1853 13.66 9/06 1846 580.00 9/10 1854 92.20 9/17 9/04 1847 1848 5,128.66 9/09 1855 69.00 38.01 9/03 1849 414.71 9/16 9/17 1856 1857 39.10 9/03 1850 2,943.40 151.12 9/16 1858 34.38 9/12 1851 6,083.66 9/25 1859 117.94 9/09 1852 * Indicates skip in check numbers *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Balance Section Balance Date Balance Date Balance Date 9/09 107,906.12 9/16 108,004.75 9/01 109,041.13 9/10 107,800.26 9/17 107,335.65 9/03 96,271.52 9/11 108,228.26 9/25 107,217.71 9/04 114,208.24 9/12 108,077.14 9/27 107,403.71 9/06 114,058.78 * * * E N D O F S T A T E M E N T * * * Date 9/30/13 Page 1 Primary Account @XXXXX @6456 Enclosures 31 ERA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- CHANGE NOTICE EFFECTIVE SEPTEMBER 1, 2013: *CANADIAN CHECK ITEM PROCESSING FEE - $1,000 OR LESS = $5.00, $1,001 OR GREATER = $10.00. *REDEPOSITED RETURN ITEM FEE _ $4.00 *AN INTEREST CHARGE FOR NEGATIVE AVERAGE COLLECTED BALANCE EQUAL TO AN INTEREST RATE OF PRIME PLUS 4% WILL BE APPLIED TO BUSINESS CHECKING ACCOUNTS ON ANALYSIS EACH STMT CYCLE. NORTHEAST PUBLIC FUNDS ACCT Date Account Number @XXXXX @6456 Previous Balance 38,163.66 DDA REGULAR DEPOSIT 12 Deposits /Credits 67,114.50 9/04 21 Checks /Debits 56,016.86 DDA REGULAR DEPOSIT 1 Electronic Debit 614.00 9/06 Service Charge .00 Interest Paid ID #- 411269646860103 .00 Ending Balance 48,647.30 DDA CREDIT MEMO Number of Images 31 Statement Dates 9/01/13 thru 9/30/13 Days in the Statement Period 30 Average Ledger 55,051 Average Collected 53,919 *********************************************** * * * * * * * ** * * * * * ** * * ** * * * ** * * * * ** Deposits and Credits Date Description 9/04 DDA REGULAR DEPOSIT 9/04 DDA REGULAR DEPOSIT 9/04 DDA REGULAR DEPOSIT 9/04 DDA REGULAR DEPOSIT 9/05 DDA REGULAR DEPOSIT 9/05 DDA REGULAR DEPOSIT 9/06 HUD TR 0 9101036151 09/06/13 ID #- 411269646860103 TRACE #- 101036150434114 9/06 DDA CREDIT MEMO 9/06 DDA REGULAR DEPOSIT 9/06 DDA REGULAR DEPOSIT 9/11 DDA REGULAR DEPOSIT 9/27 Xfer from PUB FUND 0002 Amount 568.00 725.00 2,511.00 19,744.00 1,873.00 2,473.00 36,676.50 CR 100.00 CR 579.00 1,381.00 56.00 428.00 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Charges and Debits Date Description 9/27 Xfer to PUB FUND 0002 Amount 614.00 Date 9/30/13 Page 2 Primary Account @XXXXX @6456 Enclosures 31 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks Date in serial order Check# Amount Date Check# Amount 9/03 2173 262.50 9/09 2193 31.00 9/04 2181* 41.64 9/17 2194 75.23 84.60 9/03 2183* 19,646.98 56.89 9/16 9/13 2195 2196 13,549.66 9/06 9/17 2184 2185 1,050.00 9/17 2197 87.03 9/05 2187* 442.50 9/24 2198 175.00 9/03 2188 923.07 9/19 2199 11,415.41 9/03 2189 6,551.44 9/16 2200 76.52 9/09 2190 563.00 9/25 2201 262.50 9/12 2191 509.91 9/30 2202 6.75 9/10 2192 205.23 * Indicates skip in check numbers Daily Date Balance Section Balance Date Balance Date Balance 9/01 38,163.66 9/10 76,069.91 9/19 49,277.55 9/03 10,779.67 9/11 76,125.91 9/24 49,102.55 9/04 34,286.03 9/12 75,616.00 9/25 48,840.05 9/05 38,189.53 9/13 62,066.34 9/27 48,654.05 9/06 76,869.14 9/16 61,905.22 9/30 48,647.30 9/09 76,275.14 9/17 60,692.96 * * * E N D O F S T A T E M E N T Payment Summary Bank= 165opr AND mm /yy= 09/2013- 09/2013 AND All Checks =Yes AND Include Voids =All Checks Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 2190 all - All Inc. 09/04/2013 09/2013 563.00 165opr - Parkview Villa North 2191 cent - CenterPoint Energy 09/04/2013 09/2013 509.91 165opr - Parkview Villa North 2192 home7 - FID Supply Facilities Maintenance, Ltd. 09/04/2013 09/2013 205.23 165opr - Parkview Villa North 2193 mnde - MN Dept of Labor & Industry 09/04/2013 09/2013 31.00 165opr - Parkview Villa North 2194 adam - Adam's Pest Control, Inc. 09/10/2013 09/2013 75.23 165opr- Parkview Villa North 2195 buck8411 - Buckeye Cleaning Centers 09/10/2013 09/2013 84.60 165opr - Parkview Villa North 2196 chc - CommonBond Housing 09/10/2013 09/2013 13,549.66 165opr - Parkview Villa North 2197 home7 - HD Supply Facilities Maintenance, Ltd. 09/10/2013 09/2013 87.03 165opr - Parkvlew Villa North 2198 kocl - K.O. Cleaning and Restoration LLC 09/10/2013 09/2013 175.00 165opr - Parkview Villa North 2199 kone - Kone Inc. 09/10/2013 09/2013 11,415.41 165opr- Parkview Villa North 2200 leve - Level One 09/10/2013 09/2013 76.52 165opr - Parkview Villa North 2201 allm2138 - All Metro Lawn & Snow, LLC 09/18/2013 09/2013 262.50 165opr - Parkview Villa North 2202 chc - CommonBond Housing 09/18/2013 09/2013 6.75 1650pr - Parkview Villa North 2203 comc3422 - Comcast 09/25/2013 09/2013 62.74 165opr - Parkview Villa North 2204 dire - Direct Home Appliance Services 09/25/2013 09/2013 166.85 165opr - Parkview Villa North 2205 home7 - HD Supply Facilities Maintenance, Ltd. 09/25/2013 09/2013 702.43 1650pr - Parkview Villa North 2206 kone - Kone Inc. 09/25/2013 09/2013 700.01 165opr - Parkview Villa North 2207 Popp - Popp.com _ W 09/25/2013 w 09/2013 221.98 28,895.85 Parkview Villa South Financial Statement Overview September 2013 Revenue: Occupancy for the month of September was 89 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects lower occupancy Administrative Expenses: Administrative costs for South were under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were under budget (favorable); however, this reflects some quarterly billings Fuel Oil was under budget (favorable) Electric was over budget (favorable) and reflects August billing Gas was under budget (favorable) and reflects a quarterly billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor Supplies were under budget (favorable) Exterminating Contract was under budget (favorable) Maintenance Supplies was over budget (unfavorable) and reflects the cost of two toilet replacements Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Elevator Maintenance and Repairs was under budget (favorable) Decorating Contract was under budget (favorable) Furniture and Fixtures was over budget (unfavorable) and reflects the cost of replacing carpet and vinyl in two units N JOJ000� A N QO 10 Opp YIJ� qW ON 3mOl *MA� ��mcmv1°nRONiOmaI� �n ]ry1� Ozda�' m A��Amm m w�p] v o c a I fp m 8 m 2 o N U (INS N N yl 41 N p� q�W y ± UrNO ONOO ;[J NN W O� 0 O O O O O O O O O O l0 O 0 0 0 O O O N O N N N J p WO N W JNpN�6�(N11 � +ON(Ni� � N mK0 ,QQ W JJJWJmN JNOWNO I� �� q mWOW OoO JO�N�WfWJ I tNiIJOWO POOH JNONJ H� NJO�O m OIWOW Ob0 �(Wi1W UNiO I O pm IA'I:;Du °OJD mN °O °ob o0 °OX °o0 m SPDOO X' �A(J1�P0 � W OpJINWNNJNP 0��000 NNNN ,fWil+ W � W 0 0 0 O J O (Old O Nd RO, JS O W O pl d W O O pAi W fWil N N W pp W P (, ff N L1 WJ W� N J Nd J O N J A PP O'p0O I� J W N W A N J�IJbA O N N N Nm N O �O PN � tO W NOO(JO N O W N V �p W O N O P �pAOA A Wo J O J W N N N J J W J N O INj�i WANOONW NJO MINA O O+N�O (Nl� O OONJ N+ A J N J V J O� N OAi N W W blpZ OJdOJON 1p N�Z.AO i0 ION -1 p1A WO�NJN In 0 � Z,IY W (J J D W N J N J O IO o N O O O N iN J� D N O O b D W � I R W N P N NONI NJ -� O � N Om pN�W pN pN ,NW O O ONPONO O � v O G�10(Wi�N N00 'O ON�'O '00 O O , O O O W NCO O O O N OOOO O O O O O O O O O O IO O O O O O w�p] v o c a I fp m 8 m 2 o N U `AW'$. N.... mfAWJN N+ 0 J mOW �OOW N J Q A-+O SOW A NJ°1NNOIOJN �m A C v O a v o NFo ° u1 v W v D rt v N y0 ,� N J A N O J m(ji 0000 ONAOWOT�N� NOW 1p OHO In W 00 O d0 }J JJ W y NN4Yi O YAN�Om1AN +mW �VO�'.. W W A N W O W O Y Y O W NOT W (J Wq WW mW JO N YJANNNOJlWi1W 000'. (WJ IWiI A JJ N N 1WJ000 iN + � p� N+Y + TO O pWN PANNNA i�U pY�J J WW A WAOO J �TO(pNWOW1JW p , ITT. N � OJ � J OZ , pA�TA N4Wi N OD JJOoWOW00(p TOOAi pA 1D 000 O Q Ot 10 10 Jp A W W _N j + + � bW m N pA� W O W yy OI O qNW N j T b OI A VI b W O T O� A� IWO ooJOOi W N q N W N N N �I W (n O AU �O N W N � O W 41 N IJ i000� �O A lO O �O W 01 N Vi A NJ1O A+ W N 41 J O W O 01 A +OI W m mAN ONY �Yp (yWy q � N4Yi W (Apb N+' J.A N ^I IJ V AONY J O O Oa000btAp (NO W W U YN O W J J OWN O 0 O J J OI W O O W+ (OJ P 0 NNp WOO�O W+T�OT(Ai1 OON 00 O 10 O OY N N N 0O� W,fAJ N J T WW T O N b J O W T b A N A A O N W O+ WW41 q p O Q �y1 r N N o yY1 + T U O N+ A N WNN W WNA+ J N (n U N� 00 O N O 0 p0 IJ p pp Npp.. PIP O bp O O T O O O O H O O O O O O O O O O O O u1 v W v D rt v N y0 ,� N W N D J r J y Z j D O n N I Dln Wu A W N pb� � A 0 O W W A A O 0 0 00 loo 0 �NpAN b A 0 W fWJ A A O ZZZ Z`ZZ DDD DDD A W P AOA NiD (OJ 00- NNO 000 OI00 N S0(Ai� NbW NIJO ZZZ DD �ZZ DDD D o00 0°00 t RE J A) 9� n NA b V w v W v a < D D 2 n 0 - n O m �3 ro 'p S d y' m v ay0 y 0 6( q 4 8 c c ry T 4 co " W N D J r J y Z j D O n N I Dln Wu A W N pb� � A 0 O W W A A O 0 0 00 loo 0 �NpAN b A 0 W fWJ A A O ZZZ Z`ZZ DDD DDD A W P AOA NiD (OJ 00- NNO 000 OI00 N S0(Ai� NbW NIJO ZZZ DD �ZZ DDD D o00 0°00 t RE J A) 9� n NA b V w v W v a < D D 2 n 0 - n O m �3 ro 'p S d y' m v O m O Abp Y'O 288 O N N�IpJ W(NAJ (NJ CL1 NNNNNNNO i� rp N ONI88 + W ^WI O1OO+41i OIONWNOW D m o 2 r D wT °c. o �DDrv� �mm�'w$ bf m �Q4�z 4'x �3 m m C��'0 a'0 a.000aoa w 3 �T Palo a0 20 $ $ 0� 0 'D $ 8� wa wl WI�I -+ wld ` a < � w mv' O N $ � s � y m O I PIPIPP- ol00000 q d O 0 J O O + N 0 W J N J N O O O z Z DZZ2ZZ Z DD DDDDD D m 000 00 o n 'm +mq %pp°wo = �romoo °o in"v ymm ,q a ZZ Z ZZZZZ ZZZZZZ Z< DD D DDDDD DDDDDD DR'( WO �NJ Ow1O J� N+ 1OpmJOO O I PIPIPP- ol00000 q d O 0 J O O + N 0 W J N J N O O O z Z DZZ2ZZ Z DD DDDDD D Parkview Villa South (166) Balance September 2013 Books = Accrual Sep -13 Assets 10100 Cash Balance 103,008.23 10200 Petty Cash 279.00 10400 Investments 729,970.36 11300 Rent Receivable 3,435.11 11500 Accounts Receivable 40.00 15510 Prepaid Insurance 2,160.67 Total Assets 838,893.37 Liabilities 20200 Accounts Payable 9,886.29 22000 Deposits 8,492.45 22200 Accrued PILOT 9,258.21 22210 Revenue Collected in Advance 816.37 Total Liabilities 28,453.32 Fund Balance 25300 Fund Balance 810,440.05 Total Fund Balance 810,440.05 Total Liabilities and Fund Balance 838,893.37 Parkview Villa -South (166) 16.77% 35,388.00 16.28% 3,932.00 Income Statement 35,388.00 16.28% 0.00 0.00% For The Period Ending September 2013 0.19% 3,404.50 14.52% 4,849.02 Books = Accrual 0.00 0.00% 0.00 0.00% 346.84 Month to Date % Year to Date % Revenue 7,754.24 3.57% 0.00 0.00% 36220 -46340 Gen. Government Rents 22,884.00 97.62% 210,694.50 96.92% 36225 -46340 Nondwelling Rents 396.00 1.69% 4,132.68 1.90% 36290 -46340 Other Miscellaneous Revenue 162.00 0.69% 2,573.11 1.18% 39120 -46340 Recovery Damage City - 0.00% - 0.00% Total Revenue 23,442.00 100.000/0 217,400.29 100.000/0 Expenses Personal Services 1000 -46340 Accrued Salaries Total Personal Services Supplies 2000 -46340 Office Supplies 2010 -46340 Minor Equipment 2160 -46340 Maint. & Construct Materials 2171 -46340 General Supplies Total Supplies Other Services & Charges 3040 -46340 Legal Fees 3050 -46340 Expert & Professional Services 3060 -46340 Management Services 3100 -46340 Protective Services 3210 -46340 Telephone & Telegraph 3430 -46340 Advertising Other 3600 -46340 Insurance & Bonds 3810 -46340 Electric 3820 -46340 Water 383046340 Gas 3840 -46340 Refuse 3850 -46340 Sewer 4000 -46340 Repair & Maint. Services 4100 -96340 Rents & Leases 4300 -46340 Miscellaneous Charges 4315 -46340 PILOT 4390 -46340 Taxes & Licenses 4500 -46340 Administrative Expenses 4850 -46340 Interest on Deposits Total Other Services & Charges 3,932.00 16.77% 35,388.00 16.28% 3,932.00 16.77°70 35,388.00 16.28% 0.00 0.00% 408.97 0.19% 3,404.50 14.52% 4,849.02 2.23% 0.00 0.00% 0.00 0.00% 346.84 1.48% 2,496.25 1.15% 3,751.34 16.00°70 7,754.24 3.57% 0.00 0.00% 52.50 0.02% 0.00 0.00% 5,873.00 2.70% 2,126.00 9.07% 19,134.00 8.800/0 119.35 0.51% 1,098.69 0.51% 162.30 0.69% 1,418.28 0.65% 0.00 0.00% 160.28 0.07% 665.65 2.84% 6,359.22 2,93% 2,643.69 11.28% 19,435.46 8.94% 0.00 0.00% 1,816.58 0.84% 144.83 0.62% 9,883.79 4.55% 0.00 0.00% 144.58 0.07% 0100 0.00% 952.71 0.44% 608.84 2.60% 26,145.65 12.03% 25.05 0.11% 610.05 0.28% 0.00 0.00% 181.59 0.08% 1,028.69 4.39% 9,258.21 4.26% 31.00 0.13% 658.62 0.30% 0.00 0.000/0 322.93 0.15% 6.58 - 0.03% 58.07 0.03% 7,561.98 32.26070 103,564.21 47.64% Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00% 0.00 0.000/0 0.00 0.000/0 15,245.32 65.03% 146,706.45 67.48% 8,196.68 34.97% 70,693.84 32.52% Parkview Villa South (166) Cash Flow Statement Period = September 2013 Month to Date Revenue 36220 Gen, Government Rents 22,884.00 36225 Nondwelling Rents 396.00 36290 Other Miscellaneous Revenue 162.00 39120 Recovery Damage City Property 0.00 Total Revenue 23,442.00 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 3,932.00 Supplies 2000 Office Supplies 0.00 2010 Minor Equipment 3,404.50 2160 Maint. & Construct Materials 0.00 2171 General Supplies 346.84 2175 Food Supplies 0.00 Total Supplies 3,751.34 Other Services & Charges 3050 Expert & Professional Services 0.00 3060 Management Services 2,126.00 3100 Protective Services 119.35 3210 Telephone & Telegraph 162.30 3430 Advertising Other 0.00 3600 Insurance & Bonds 665.65 3810 Electric 2,643.69 3820 Water 0.00 3830 Gas 144.83 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repair & Maint. Services 608.84 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 25.05 4300 Miscellaneous Charges 0.00 4315 PILOT 1,028.69 4390 Taxes & Licenses 31.00 4500 Administrative Expenses 0.00 4850 Interest on Deposits 6.58 Total Other Services & Charges 7,561.98 Total Expenses 15,245.32 COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meeting of: October 22, 2013 AGENDA SECTION: Business Items ORIGINATING EXECUTIVE NO: DEPARTMENT: HRA DIRECTOR 9 APPROVAL ITEM: Adopt Resolution 2013 -09, Adopting the BY: Scott Clark BY: Proposed 2014 Budget for Parkview Villa DATE: October 15, 2013 North BACKGROUND: Parkview Villa North (PVVN) consists of 101 units of public housing, located at 965 40' AvenueNortNo theast. PVVN serves seniors and disabled persons. PVVN was constructed in 1975 with funds from the U.S. Department of Housing and Urban Development. CommonBond Housing provides management services to PVVN. Expenditures The proposed 2014 budget for PVVN is $598,251 and reflects a decrease of $8,200 from the FY2013 budget. CommonBond will walk through the budget at the meeting. Revenues Total proposed revenue is $566,125 and is a substantial reduction from the 2013 budget of $609,326. This reduction is caused by an anticipated reduction in the operating subsidy from HUD. Capital Improvement Plan The apartment modernization capital improvement plans previously developed will continue to be implemented. RECOMMENDATION MOTION: Staff recommends adopting Resolution 2013 -09 approving the 2014 PVV North Budget. RECOMMENDED MOTION: Motion: Move to waive the reading of Resolution 2013 -09, there being ample copies available to the public. Move to adopt Resolution 2013 -09, being a Resolution of the Housing and Redevelopment Authority in and for the City of Columbia Heights, adopting the 2014 Parkview Villa North Budget of $598,251 and recommending this to the City Council for approval. Attachments: Resolution 2013 -09, Budget sheets HRA ACTION: HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS HRA RESOLUTION 2013 -09 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT (HRA) ADOPTING THE 2014 BUDGET FOR PARKVIEW VILLA NORTH BE IT RESOLVED By the Columbia Heights Housing and Redevelopment Authority (HRA) of Columbia Heights, Minnesota as follows: WHEREAS, Parkview Villa North, a 101 unit rental apartment building, was constructed in 1975 for the purpose of providing affordable housing to seniors and disabled persons. NOW THEREFORE BE IT RESOLVED, BY THE HRA FOR THE CITY OF COLUMBIA HEIGHTS, MINNESOTA THAT: 1. The HRA adopts and recommends to the City Council for approval the 2014 Parkview Villa North budget of $598,251 The Executive Director is instructed to transmit a copy of this resolution to the City Manager and City Finance Director of the City of Columbia Heights, Minnesota. APPROVED THIS 22nd DAY OF OCTOBER, 2013. Motion By: Seconded by: Roll Call: Tammera Diehm, Chair Walter R. Fehst, Executive Director City of Columbia Heights 2014 Budget Worksheet 203 46330 Parkview Villa North Actual Expense 2011 Actual Expense 1 2012 Adopted Budget 2013 Department I Proposed 2014 Manager Proposed 2014 Council Adopted 2014 Line Item Description PERSONAL SERVICES 1000 ACCRUED SALARIES - - - - 1070 INTERDEPARTMENTAL LABOR SERV 25,500 25,500 25,500 25,500 - 1080 INTERDEPARTMENTAL LABOR CR - - - - 1210 P.E.R.A. CONTRIBUTION - - - - - 1220 F.I.C.A. CONTRIBUTION - - - - 1300INSURANCE - - - - 1510 WORKERS COMP INSURANCE PREM - - - - 1700 ALLOCATED FRINGE - - - - 1800 INTERDEPARTMENTAL FRINGE CR - - - - - 0999 TOTALS: PERSONAL SERVICES 25,500 25,500 25,500 25,500 - SUPPLIES 2000 OFFICE SUPPLIES 6,354 3,149 3,500 3,000 - 2010 MINOR EQUIPMENT 4,521 13,457 - - ' 2011 COMPUTER EQUIPMENT - - - - " 2020 COMPUTER SUPPLIES - - 600 600 - 2030 PRINTING & PRINTED FORMS - - - - - 2160 MAINT. & CONSTRUCT MATERIALS 6,200 - 10,100 10,100 - 2171 GENERAL SUPPLIES 4,112 13,489 10,990 10,990 - 2172 UNIFORMS - - - - - 2175 FOOD SUPPLIES - - - - 2280 VEHICLE REPAIR AND PARTS - - - - - 1999 TOTALS: SUPPLIES 21,186 30,096 25,190 24,690 - OTHER SERVICES & CHARGES 3040 LEGAL FEES 4,385 3,616 - - - 3041 ATTORNEY FEES -CIVIL PROCESS - - 5,350 5,000 - 3050 EXPERT & PROFESSIONAL SERV. 1,853 3,010 1,850 1,850 - 3060 MANAGEMENT SERVICES 154,824 161,666 163,414 163,414 - 3100 PROTECTIVE SERVICES 6,724 11,566 - - - 3105 TRAINING & EDUCACTIVITES - - - - - 3210 TELEPHONE & TELEGRAPH 3,919 5,023 6,000 6,000 - 3220 POSTAGE - - - - - 3250 OTHER COMMUNICATIONS - - - - ' 3310 LOCAL TRAVEL EXPENSE - - 150 150 - 3320 OUT OF TOWN TRAVEL EXPENSE - - - - - 3430 ADVERTISING OTHER 517 150 650 600 - 3500 LEGAL NOTICE PUBLISHING - - - - - 3600 INSURANCE & BONDS 20,950 20,966 21,946 21,946 - 3810 ELECTRIC 52,684 48,122 49,000 40,250 - 3820 WATER 12,458 14,571 12,100 13,000 - 3830 GAS 45,217 28,055 57,600 57,600 - 3840 REFUSE 8,150 9,112 6,536 6,536 - 3850 SEWER 6,773 11,549 13,312 13,212 - 4000 REPAIR & MAINT. SERVICES 99,500 162,077 96,645 99,998 - 4030 EXTRAORDINARY MAINTENANCE - - 550 - 4050 GARAGE, LABOR BURD. - 161 - - - 4100 RENTS & LEASES 1,003 1,191 1,500 1,500 - 4300 MISC. CHARGES 263 971 1,485 1,485 - 4315 PILOT 22,769 24,702 23,314 24,350 - 4330 SUBSCRIPTION, MEMBERSHIP - - - - - 4374 EMPLOYEE RECOGNITION - - - - - City of Columbia Heights 2014 Budget Worksheet 203 46330 Parkview Villa North Actual Expense 1 2011 Actual Expense 1 2012 Adopted Budget 2013 Department Proposed 1 2014 Manager Proposed 1 2014 Council Adopted 2014 Line Item Description 4376 MISCELLANEOUS CIVIC AFFAIRS 4380 COMMISSION & BOARDS 4390 TAXES & LICENSES 4395 STATE SALES TAX 4500 ADMINISTRATIVE EXPENSES 4850 INTEREST ON DEPOSITS 2999 TOTALS: OTHER SERVICES & CHARGES CAPITAL OUTLAY 5120 BUILDING & IMPROVEMENT 5170 OFFICE EQUIPMENT 4999 TOTALS: CAPITAL OUTLAY OTHER FINANCING USES 8100 CONTINGENCIES 6999 TOTALS: OTHER FINANCING USES TOTALS: PARKVIEW VILLA NORTH 1,808 1,443 2,000 2,000 - 2,052 2,802 - - 153 163 160 170 - 446,003 510,917 463,562 459,061 - 9,855 128,191 92,200 89,000 - 9,855 128,191 92,200 89,000 - 502,544 694,703 606,452 598,251 - City of Columbia Heights Federal Grant 34114 Excess Utilities 2014 Revenue Budget Worksheet Interest on Investments 36219 Change in Fair Value North 203 GENERAL Actual Actual Adopted Department Manager Council 00 REVENUE Revenue Revenue Budget Proposed Proposed Adopted Line Item Description 2011 2012 2013 2014 2014 2014 33160 Federal Grant 34114 Excess Utilities 36210 Interest on Investments 36219 Change in Fair Value 36220 General Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39101 Gain /Loss Sale Fixed Asset 39120 Recovery Damage City Property 39130 Equipment Rental 39140 Other Refunds & Reimbursements 500 Total Revenue 176,750 184,349 244,755 200,000 - - - 1,831 1,831 - 2,789 4,042 6,304 7,374 - 347,318 354,216 351,456 351,456 - 3,719 4,704 4,480 4,964 - 9,907 9,130 500 500 - 2,346 540,483 558,787 609,326 566,125 - h la LL ND E 4 z : ! , 2 | | i $ # ! ! # ® } §} ® }/} § ;R« § !R «q § 4¥4q § $R#q § !4#q ) §:B2! §;B2! 1;82* !; §yi §:§22 §;Bi« §w B2! !;§;e - 4 //} „ ■ \ « F: ! es :a; C! ,2!] {)% # /!!e \ \ \ o . 2 7«g\ #t. a'y # -:`w #Jgged3 \ \d� \aGewa%£ a! al:ale £6&6,2t� is § _ : ! . . ) 2 I ! � ! j 0 ! � !9n $ � ! � Ci ! \ } \��\ \ u ! § ;; )^ 2 I ! j 0 !9n \ } \��\ \ u ! § ;; )^ Allzo wo 2 tam &.R Bg r mv, O N q� N l0 N m p o � N N 10 'eW 0 � EJ O MN IN p N N t0 � O N N Lry Q If� � a N 0 LL r r® E' N_ IC O C N II ��tm Y N z m0 41 < g W o <�. �oN N i II c `m 1z mtt a" N N W n JN I <W N G} UO m m M� N a M r g a O N � m z O N q� N l0 N m p o � N N 10 'eW 0 � EJ O MN IN p N N t0 � O N N Lry Q If� � a N 0 LL r r® E' N_ IC O C N II ��tm Y N z m0 41 < g W o <�. �oN N i II c `m 1z mtt a" N N W n JN I <W N G} UO m m M� N a M r g a O COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meetin of: October 22, 2013 AGENDA SECTION: Business Items ORIGINATING DEPARTMENT EXECUTIVE NO. 10 HRA DIRECTOR APPROVAL ITEM: Adopt Resolution 2013 -10 Approving BY: Scott Clark BY: he Proposed 2014 Budget for Parkview Villa DATE: October 15, 2013 South BACKGROUND: Parkview Villa South (PVVS) is a 45 unit apartment building, located at 965 40to Ave Northeast. PVVS serves seniors age 55 or older. PVVS was constructed in 1991. PVVS is owned by the Housing and Redevelopment Authority and managed by CommonBond Housing. Expenditures The proposed 2014 budget for PVVS is $274,850. Of this amount, $35,000 is allocated for capital projects. There is an overall budget decrease of $8,200 from FY2013. This decrease is reflected in a reduction in utility costs. Revenues Proposed gross revenues are $320,700 and reflects a flat revenue stream from FY 2013.. RECOMMENDED MOTION: Staff recommends adopting Resolution 2013 -10 approving the 2014 PVV South Budget. RECOMMENDED MOTION: Move to waive the reading of Resolution 2013 -10, there being ample copies available to the public. Motion: Move to adopt Resolution 2013 -10 " Resolution of the Housing and Redevelopment Authority in and for the City of Columbia Heights Adopting the 2014 PVV South Budget of $274,850 and recommending this budget to the City Council for approval. Attachments: Resolution 2013 -10, budget sheets HRA ACTION: HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS HRA RESOLUTION 2013 -10 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT (HRA) ADOPTING THE 2014 BUDGET FOR PARKVIEW VILLA SOUTH BE IT RESOLVED By the Columbia Heights Housing and Redevelopment Authority (HRA) of Columbia Heights, Minnesota as follows: WHEREAS, THE City had constructed in 1991 Parkview Villa South (PVVS), a 45 unit rental apartment building, for the purpose of providing housing for seniors age 55 and older. NOW THEREFORE BE IT RESOLVED, BY THE HRA FOR THE CITY OF COLUMBIA HEIGHTS, MINNESOTA THAT: 1. The HRA adopts and recommends to the City Council for approval the 2014 Parkview Villa South budget of $274,850. The Executive Director is instructed to transmit a copy of this resolution to the City Manager and City Finance Director of the City of Columbia Heights, Minnesota. APPROVED THIS 22nd DAY OF OCTOBER, 2013. Attest by: Walter R. Fehst, Executive Director Tammera Diehm, Chair City of Columbia Heights 2014 Budget Worksheet 213 46340 Parkview Villa South Actual Expense 2011 Actual Expense 1 2012 Adopted Budget 1 2013 Department Proposed 1 2014 Manager Proposed 1 2014 Council Adopted 2014 Line Item Description PERSONAL SERVICES 1000 ACCRUED SALARIES 1070 INTERDEPARTMENTAL LABOR SERV 1300INSURANCE 1700 ALLOCATED FRINGE 0999 TOTALS: PERSONAL SERVICES SUPPLIES 2000 OFFICE SUPPLIES 2010 MINOR EQUIPMENT 2011 COMPUTER EQUIPMENT 2020 COMPUTER SUPPLIES 2030 PRINTING & PRINTED FORMS 2160 MAINT. & CONSTRUCT MATERIALS 2171 GENERALSUPPLIES 2172 UNIFORMS 2175 FOOD SUPPLIES 1999 TOTALS: SUPPLIES OTHER SERVICES & CHARGES 3040 LEGAL FEES 3041 ATTORNEY FEES -CIVIL PROCESS 3045 LEGAL FEES - OTHER 3050 EXPERT & PROFESSIONAL SERV. 3060 MANAGEMENT SERVICES 3100 PROTECTIVE SERVICES 3105 TRAINING & EDUCACTIVITES 3210 TELEPHONE & TELEGRAPH 3220 POSTAGE 3250 OTHER COMMUNICATIONS 3310 LOCAL TRAVEL EXPENSE 3320 OUT OF TOWN TRAVEL EXPENSE 3430 ADVERTISING OTHER 3500 LEGAL NOTICE PUBLISHING 3600 INSURANCE & BONDS 3810 ELECTRIC 3820 WATER 3830 GAS 3840 REFUSE 3850 SEWER 4000 REPAIR & MAINT. SERVICES 4100 RENTS & LEASES 4300 MISC. CHARGES 4315 PILOT 4330 SUBSCRIPTION, MEMBERSHIP 4374 EMPLOYEE RECOGNITION 4376 MISCELLANEOUS CIVIC AFFAIRS 4380 COMMISSION & BOARDS 4390 TAXES & LICENSES 4395 STATE SALES TAX 4500 ADMINISTRATIVE EXPENSES 4850 INTEREST ON DEPOSITS 11,500 11,500 11,500 11,500 2,769 1,054 4,968 17,986 1,762 55 1,037 7,650 - 19 10,536 26,764 45,634 24,300 6,810 1,760 348 10,113 20,488 5,759 18,159 6,350 2,554 42,463 523 (121) 12,970 11501:7 I 5,239 231 629 72,386 5,312 2,072 2,618 10,134 20,454 6,339 11,251 2,513 2,389 60,274 870 157 12,513 669 244 82 11,500 11,500 2,392 500 3,100 2,625 8,617 2,500 925 73,294 2,025 150 75 1,500 10,600 21,600 6,000 23,040 5,345 3,240 62,470 1,000 13,352 1,250 85 11,500 11,500 2,550 500 3,000 2,795 8,845 1,500 944 73,294 2,280 75 2,000 10,095 24,369 5,390 12,717 5,345 2,324 63,487 1,011 13,352 1,250 72 City of Columbia Heights 2014 Budget Worksheet 213 46340 Parkview Villa South ActualActual Expense 2011 Expense 2012 Adopted Budget 2013 Department Proposed 2014 Manager Proposed 2014 Council Adopted 1 2014 Line Item Description 2999 TOTALS: OTHER SERVICES & CHARGES 199,804 216,376 228,451 219,505 CAPITAL OUTLAY 5120 BUILDING & IMPROVEMENT - - 35,000 35,000 5170 OFFICE EQUIPMENT - - - - 4999 TOTALS: CAPITAL OUTLAY - - 35,000 35,000 OTHER FINANCING USES 8100 CONTINGENCIES 6999 TOTALS: OTHER FINANCING USES - - - - TOTALS: PARKVIEW VILLA SOUTH 221,840 254,639 283,568 274,850 213 GENERAL 00 REVENUE Line Item City of Columbia Heights 2014 Revenue Budget Worksheet Actual Actual Adopted Revenue Revenue Budget 2011 2012 2013 3artment Manager Council Proposed Proposed Adopted 2014 2014 2014 34114 Excess Utilities - - - - - - 36210 Interest on Investments 10,300 8,800 3,500 3,500 - - 36219 Change in Fair Value 5,700 600 - - - - 36220 General Government Rents 307,628 289,021 309,286 309,286 - - 36225 Nondwelling Rents 5,921 5,630 5,818 4,964 - - 36290 Other Miscellaneous Revenue 6,156 5,998 1,831 2,500 - 39120 Recovery Damage City Property - 256 300 450 - - 39140 Other Refunds & Reimbursements - - - - - " Total Revenue 335,705 310,306 320,735 320,700 - - <d YI O N N..o W IOW a NN N E N N ry i j$yq� d N N'h 10 O� N iN 1 m rV m c N N�W �N LE ii N N N W d OM1 N N lV ry 1V M Fd I� � N NI10 W mCl N N j I N W N N d W M N N N N N ry N n i Ii m I I LL N W M N N N C q El M'W O N pN M H d �m .O f M H.•b M O� OVN p pJQI c 4t � I W AD W U m Q N m jTVl� o c rc @fcf��°� 1-6 �6 38 and cast�E OGI �xc �mg E >� >mnAc a V C K KK U'�dK C FK -oU�> -OFD_ FK W oul °¢mesw m<9 m' W n Im �$ 'C y pE o a o ova o S oo o� p> 0 0 2 p o 8 ry m N p M � o a N M a O O E � c m o t3R � o Z y q N r N r 4 y y y lV r CI e' m I E e a LL i E ona'o � m a !ry mmnnp° n -Mry [y Z�vvi N I �Na E 11 �� NE ry6p�h rNT�N N 6C0 ° S.0 ��q ji�WPU Crj ��dK Z•N Oom °w °w��u°1.1a'rd`�n °¢w =; Tjn`m'° w �wvio $ wf w30rnn Eo m'IuUwci 'O :_ o3 e ':a o0o n n `��V Qx NMm eye( m r m o rnn m K u "Z •e m m�o� � m � rnD �D����� m �o �o m �o � �o o fn LL 0 v % Lp m gmi HELL Vi 2. 6 M no I.l SO mm to) so. O mW R 2 S S 1-2 21 1 A ow mE M 0 E 2-12 f11 tt O N rr m N =,.i�N ,N 4 °m Lm N N O °m N @ O 5 I� n _ � °m h 4 s a IL '� n �q r ;M b 0 .'... N •I ". VI E ':� II N 9p M C 0 D ,,:..� Z rn I� � oa.,,_ � v p S ri N rr m N =,.i�N ,N 4 °m Lm N N O °m N @ O 5 I� n _ � °m h 4 s a IL o u v �� v G 0 N N r ;M t5 0 E ':� II p � ;.N ,,:..� f � oa.,,_ '.. � Y N Z N � N� 6.. N II � E -'o. '!l3 °0 �2 "N a3 O n m !$ UO � � d � I.. i-� IL I q ]® ', O)o m m�a o u v �� v G 0 COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meeting of: October 22, 2013 AGENDA SECTION: Public Hearing ORIGINATING EXECUTIVE NO: 1 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Resolution 2013 -11 and 2013 -12- PHA Plan BY: Scott Clark BY: Amendment for FY2011, 2012 and 2013 DATE: October 15, 2013 BACKGROUND: One of the staffs strategies in the sale of Parkview Villa is to ensure that all allocated modernization funds are expended prior to closing with Aeon. At this time, Parkview Villa Noah holds approximately $165,000 in modernization funds that includes appropriations from FY 2011 and FY 2012 and a recent inflow of $80,000 from FY 2013. The goals for expenditures are 1) Have the funds expended by early 2014 2) Have these funds designated for improvements that need minimal bid specification work 3) The work can be performed within a short period of time and most critically- 4) The work is part of the rehabilitation plan of Aeon and 6) If the sale does not continence, the bid work will be beneficial to the long tefm viability of Parkview Villa North. The PHA Amendment that is before the HRA is the necessary statutory requirement that will allow the expenditure and reimbursement for the following work. Aeon will be doing the actual bid work (with some bid oversight by CommonBond) and all work will be acted on at a future HRA meeting. As such, this Amendment establishes the work items to be bid but does not grant authority to spend: I ) Door frames, doors and hardware for future ADA compliant units on the first floor ( $18,800) 2) Hallway carpet floors 1 thru 9- ($17,705) 3) Hallway Painting ($5,000 supplies only) 4) Elevator improvements ($43,349) 5) Fire alarm replacement ($81,917) Action on this item also includes a second motion that confirms that the notification process was adhered to ( 45 legal notice, access via and through City sources, etc.). RECOMMENDATION: Staff recommends approval of the PHA Amendment as written. RECOMMENDED MOTION: Motion to waive the reading of Resolution 2013-11 there being ample copies available to the public. Motion to Adopt Resolution 2013 -11 Approving a PHA Amendment for FY 2011, FY 2012 and Approving FY 2013 Physical Needs Work Statement. and Motion to waive the reading of Resolution 2013 -12 there being ample copies available to the public. Motion to Adopt Resolution 2013 -12 Approving the Public Housing Certification of Compliance With the FY 2011, FY 2012 and FY 2013 PHA Plan Amendment and related regulations, and Authorizing it's submission to HUD. Attachments: Resolutions 2013 -11 and 2013 -12 and PI -IA Amended Plan HRA ACTION: PHA 5 -Year and U.S. Department of Housing and Urban O1VD3 No. 2577 -0226 Development Expims 8/30/2011 Annual Plan Office of Public omit Iutliau Housing 1.0 PHA Information PHA Name: Columbia Heights housing and Redevelopment Amhority P11A Code: _MN105 PI- IA'fype: ® Small ❑ High Performing ❑ Standard ❑ HCV (Section 8) PHA Fiscal Year Beginning: (MM/YYYY): _01/2013 2.0 Inventory (based on ACC units at lime of FY beginning in 1.0 above) Number of PII units: 101 Number of IICV units: 3.0 Submission Type ❑ 5 -Year and Annual Plan ® Annual Plan Only ❑ 5 -Year Plan Only 4.0 PHA Consortia ❑ PHA Consortia: (Check box if submitting ajoint Plan and complete table below.) No. of Units in Each PHA Program(s) Included in the Programs Not in the Program Participating PHAs Code Consortia Consortia PH HCV PHA 1: PHA 2: PHA 3: 5.0 5 -Year Plait. Complete items 5.1 and 5.2 only at 5 -Year Plan update. 5.I Mission. State the PHA's Mission for serving the needs of low- income, very low- income, and extremely low income families in the PHA's jurisdiction for the next five years: To Promote adequate and affordable housing, economic opportunity and a suitable living environment free train discrimination. 5.2 Goals and Objectives. Identify the PHA's quantifiable goals and objectives that will enable the PRA to serve the needs of low - income and very low - income, and extremely low- income families for the next five years. Include a report on the progress the PHA has made in meeting rite goals and objectives described in the previous 5 -Year Plan. Expand the supply of assisted [tensing: Reduce public housing vacancies; Occupancy rates remain at 98% or above for over a year. Improve the quality of assisted housing: Improve public management; PHAS score of 95 or more. Increase customer satisfaction: Offer stable office hours and available staff to handle day to day issues. Renovate or modernize public housing units; Continue with the building modernization project until all floors have been renovated and then work on building nnodcrnizatieJrenovation projects. Provide an improved living environment: Implement public housing security improvements; Continue to improve upon security at the site, add additional cameras and lighting to the property Promote self sufficiency and asset development of assisted households: Provide or attract supportive services to increase independence for the elderly or families with disabilities; Continue to work with local agencies that provide supportive services to residents. Ensure equal opportunity and affirmatively fm•tber fair [leasing; Undertake affirnative measures to ensure access to assisted housing regardless of race, color, religion, national origin, sex, familial status and disability. Undertake affirmative measures to ensure accessible housing to persons with all varieties of disabilities regardless of unit size. PHA Plan Update 6.0 (a) Identify all PHA Plan elements that have been revised by the Pl -IA since its lest Annual Plan submission: Smoke Free. Lease Addendum (b) Identify the specific location(s) where the public truly obtain copies of the 5 -Year and Annual PHA Plan. For a complete list of PHA Plan elements, see Section 6.0 of the instructions. Main Adminisbation office of the PHA, PHA development management offices and Public Library. Hope VI, Mixed Finance Modernization m• Development, Demolition and /or Disposition, Conversion of Public Housing, Homeownership Programs, and Project -based Vouchers. The LIRA is submitting a voluntary conversion to HUD for its 101 units of public /rousing under Section 22 of the United States Housing Act of 1937and related requirements of the U.S. Department of Housing and Urban Development (HUD). The 7.0 attached Conversion Assessment and Conversion Plan describe this action and reasons for it. It is anticipated that, subject to fiilUMment of all HUD requirements, the result will be a renovated development assisted by project - based vouchers with continued availability to cut -cut and ftnure /oil, income households. In accordance with HUD requirements, the Conversion Assessment is submitted with the PHA's 5 -Year and Annual Plan as amended by this Significant Amendment and the Conversion Plan is made part of the 5 -Year and Annual Plan as amended by this Significant Amendment. 8.0 Capital Improvements. Please complete Parts 8.1 through 8.3, as applicable. Page I of 2 forth IIUD -50075 (4/2008) 11.0 Required Submission for HUD Field Office Review. In addition to the PIIA Plau template (HUD - 50075), PHAs nest submit the following documents. Items (a) through (g) may be submitted with signature by mail or electronically with scanned signatures, but electronic submission is encouraged. Items (h) through (i) must be attached electronically with the PHA Plan. Note: Foxed copies of these documents will not be accepted by the Field Office. (a) Form HUD- 50077, PIIA Certifications ofCompliance with the PHA Plans and Related Regulations (which includes all certifications relating to Civil Rights) (b) Form (IUD -50070, Certification fora Drug -Free Workplace (PHAs receiving CFP grants only) (c) Fornr HUD - 50071, Ceitifucation ofPaynenis to IrPuence Federal Transactions (PHAs receiving CFP grants only) (d) Form SF -LLL, Disclosure of Lobbying Activities (PHAs receiving CFP grans only) (c) Forni SF- LLL -A, Disclosure of Lobbying Activities Continuation Sheet (PHAs receiving CFP grants only) (f) Resident Advisory Board (RAB) comments. Comments received from the RAB must be submitted by the PHA as an attachment to the PHA Plan. PHAs must also include a narrative describing their analysis of the recommendations and the decisions made on these recommendations. (g) Challenged Elements (h) Form HUD- 50075.1, Capital Find Progran Annual Slateoient/Peifornance and Evaluation Report (PHAs receiving CFP grants only) (i) Point HUD - 50075.2, Capital Fmrd Program Five -Year Action Plan (PHAs receiving CFP grants only) Page 2 of 2 form HUD -50075 (4/2008) Capital Fond Program Annual Statement /Pe forniance quit Evaluation Report. As part of the PHA 5 -Yoar and Annual Plan, annually 8 1 complete and submit the Capital Fund Progran Annrml Statetuent/Perfornrance and Evaluation Report, form HUD - 50075.1, for each current and 9.1 open CFP grant and CFFP financing. Capital Fund Program Five -Year Action Plan. As part of the submission of the Annual Plan, PHAs must complete and submit the Capital Find 8 2 Aograni Five -Year Action Plan, form HUD-50075.2, and subsequent annual updates (on a rolling basis, e.g, drop current year, and add latest year for a five year period). Large capital items must he included in the Five -Year Action Plan. 8.3 Capital Fund Financing Program (CFFP). ❑ Check if the PHA proposes to use any portion of its Capital Fund Program (CFP) /Replacement Housing Factor (REF) to repay debt incurred to find ice capital improvements. Housing Needs. Based on information provided by the applicable Consolidated Plan, information provided by HUD, and other generally available data, make a reasonable effort to identify the housing needs of the low- income, very low- income, and extremely low- income families who reside in 9.0 the jurisdiction served by the PHA, including elderly families, families with disabilities, and households of various races and ethnic groups, and other familics who are on the public housing cord Section 8 tenant -based assistance wailing lists. The identification of (rousing needs must address issues of affordability, supply, quality, accessibility, size of units, and location. Quality affordable housing for extremely low income elderly families and familics with disabilities is a need within the jurisdiction. The PHA provides 101 one - bedroom units for qualified extremely low income elderly families and families with disabilities within the jurisdiction of the PHA. 11.0 Required Submission for HUD Field Office Review. In addition to the PIIA Plau template (HUD - 50075), PHAs nest submit the following documents. Items (a) through (g) may be submitted with signature by mail or electronically with scanned signatures, but electronic submission is encouraged. Items (h) through (i) must be attached electronically with the PHA Plan. Note: Foxed copies of these documents will not be accepted by the Field Office. (a) Form HUD- 50077, PIIA Certifications ofCompliance with the PHA Plans and Related Regulations (which includes all certifications relating to Civil Rights) (b) Form (IUD -50070, Certification fora Drug -Free Workplace (PHAs receiving CFP grants only) (c) Fornr HUD - 50071, Ceitifucation ofPaynenis to IrPuence Federal Transactions (PHAs receiving CFP grants only) (d) Form SF -LLL, Disclosure of Lobbying Activities (PHAs receiving CFP grans only) (c) Forni SF- LLL -A, Disclosure of Lobbying Activities Continuation Sheet (PHAs receiving CFP grants only) (f) Resident Advisory Board (RAB) comments. Comments received from the RAB must be submitted by the PHA as an attachment to the PHA Plan. PHAs must also include a narrative describing their analysis of the recommendations and the decisions made on these recommendations. (g) Challenged Elements (h) Form HUD- 50075.1, Capital Find Progran Annual Slateoient/Peifornance and Evaluation Report (PHAs receiving CFP grants only) (i) Point HUD - 50075.2, Capital Fmrd Program Five -Year Action Plan (PHAs receiving CFP grants only) Page 2 of 2 form HUD -50075 (4/2008) Strategy for Addressing Housing Needs. Provide a brief description of (he PI -IA's strategy for addressing the housing needs of families in the jurisdiction and on the waiting list in the upcoming year. Note: Small, Section 8 only, and High Performing PHAs complete only for Annual 9.1 Plan submission with the 5 -Year Plan. I lousing needs of those on the waiting list are for housing (hat is available for extremely low income elderly and disabled families. The PHA has a preference in place for those that live or work in the jurisdiction. The PHA plans to exceed the federal targeting requirement by targeting more than 40% of all new admissions to public housing to families at or below 30% of medimt income. Additional Information. Describe the following, as well as any additional information HUD has requested. 10.0 (a) Progress in Meeting Mission and Goals. Provide a brief statement of the PHA's progress in meeting (he mission and goals described in the 5- Year Plait. The PHA has maintained an occupancy rate of 98% or above for the past yem'. The PHA is improving the quality of assisted housing by continuing with (he building modernization plan. Six Floors have successfully been modernized. The PHA upgraded the security cameras at (he site in the past year. The PHA continues its relationship with Volunteers of America to provide dining services for those in the assisted housing. The PEA markets to all in the jurisdiction and continually works to ensure equal opportunity mid affiruratively fiuther fair housing. (b) Significant Amendment mid Substantial Deviation /Modification. Provide the PHA's definition of "significant amendment' and "substantial deviation /arodifrcation" 11.0 Required Submission for HUD Field Office Review. In addition to the PIIA Plau template (HUD - 50075), PHAs nest submit the following documents. Items (a) through (g) may be submitted with signature by mail or electronically with scanned signatures, but electronic submission is encouraged. Items (h) through (i) must be attached electronically with the PHA Plan. Note: Foxed copies of these documents will not be accepted by the Field Office. (a) Form HUD- 50077, PIIA Certifications ofCompliance with the PHA Plans and Related Regulations (which includes all certifications relating to Civil Rights) (b) Form (IUD -50070, Certification fora Drug -Free Workplace (PHAs receiving CFP grants only) (c) Fornr HUD - 50071, Ceitifucation ofPaynenis to IrPuence Federal Transactions (PHAs receiving CFP grants only) (d) Form SF -LLL, Disclosure of Lobbying Activities (PHAs receiving CFP grans only) (c) Forni SF- LLL -A, Disclosure of Lobbying Activities Continuation Sheet (PHAs receiving CFP grants only) (f) Resident Advisory Board (RAB) comments. Comments received from the RAB must be submitted by the PHA as an attachment to the PHA Plan. PHAs must also include a narrative describing their analysis of the recommendations and the decisions made on these recommendations. (g) Challenged Elements (h) Form HUD- 50075.1, Capital Find Progran Annual Slateoient/Peifornance and Evaluation Report (PHAs receiving CFP grants only) (i) Point HUD - 50075.2, Capital Fmrd Program Five -Year Action Plan (PHAs receiving CFP grants only) Page 2 of 2 form HUD -50075 (4/2008) r. d 9 w B ry O ti O O � O C � �a w C x �• w •4. � o H 6 d P O � p � O 9 oy 3 o a H Ht7n CZlu 00> old o AD � 'z o � a 5• by � � U0 ao Oa cr �x N N r 7 h' A O r A N 0 O N rn Eq O W � ` w ' m UQ, N �+ O w Y. w v 6? ❑ � A N V� N too O�. O m t ;� ro rn W A � C N � A o rt 0 �i U r. d 9 w B ry O ti O O � O C � �a w C x �• w •4. � o H 6 d P O � p � O 9 oy 3 o a b w V� IJ P 0 x c U N ti IX ro w r a A 0 A a s p C d m 3 A 0 00 n O a n ro a, c w n a k d P Y � N A p � � O 9 o ° 3 O a zoo w' ox e (D M N O M rC 0 ° W �^ M 0 ° N ! hV N ° m oC '10 E En P Q� w' � x M o M (D � x 0 n � o ro m � o A 7y y � d z rn c � K A O U ro w r a A 0 A a s p C d m 3 A 0 00 n O a n ro a, c w n a k d P Y � N A p � � O 9 o ° 3 O i d 0 O N A IJ O W 0 b b w b C d 3 R �x n O m O N M b � C w P � n a w C y d A O oxs O �O o ° 3 O 0 0 o o d b �O n d o. no a o 5 "d C m' o m �z a M o0 o rnCrn ANy ❑rn M OyO M P A a f 0o N O CD -P N „" � K y A C7 0 N N a 66 t a� C7�rn o Q' o O O o A�9 IC IQ a o M N O Hf W `o to J M co `O a J 0 O 0 b b w b C d 3 R �x n O m O N M b � C w P � n a w C y d A O oxs O �O o ° 3 O 0 { ƒ r / ( ƒ\ /(( k/} ( \f\ ri ® ®x (( ( zE&E /ee { \®7 J � }\ \ f m. = \} � � \\ m � f /(( 2 $\ ®z9$^ 2222$2) )7(,q &% / ® / \ zmB / \ } � ( r / ( ƒ\ /(( k/} i d n, w 3 0 o c o N ro c c � c � n �• w C q• o n ? d N A p � oxs o� o ° 3 o >> i d v s 00 o c o N � oa n a. d f." X 6 P z N A p oxs o� off s • i d v s 00 o c o N � oa n a. d f." X 6 P z N A p oxs o� off s