Loading...
HomeMy WebLinkAbout01-28-2014 HRA AgendaHOUSING & REDEVELOPMENT AUTHORITY AGENDA 7:00 P.M. January 28, 2014 Parkview Villa, Community Room B, 965 40ru AVE., COLUMBIA HEIGHTS, MN 1. Call to Order 2. Roll Call Tammera Diehm, Chair Bruce Nawrocki Bobby Williams, Vice Chair Donna Schmitt Secretary /Treasurer Rheta Nelson Gary Peterson 3. Pledge of Allegiance 4. Election of Officers A. B. Vice C. Secretary /Treasurer CONSENT AGENDA 5. Approve minutes of October 22, 2013 and January 13, 2014 6. Resolution 2014 -02 — Designating Signatories 7. Resolution 2014 -03 —Approve Financial Report and Payment of Bills for October, November and December 2013 Motion: Move to approve consent items as listed. BUSINESS ITEMS S. Report of Management Company 9. Resident Council Minutes 10. Citizen Forum* 11. Resolution 2014 -04 — Approval of Management Contract with CommonBond Housing Management Motion: Move to waive the reading of Resolution 2014 -04 there being ample copies available to the public. Motion: Move to Adopt Resolution 2014 -04 Extension of ConunonBond Housing Management Contact Until January 31, 2015 For Management of Parkview Villa North and South. 12. Security Issues Discussion PUBLIC HEARING 13. Resolution 2014 -05 - Columbia Heights Housing and Redevelopment Authority Confirming Approval of the 2014 PHA Certification of Compliance Motion; Move to waive the reading of Resolution 2014 -05 there being ample copies available to the public. Motion: Move to Adopt Resolution 2014 -05 Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) Confirming Approval of the 2014 Public Housing Agency Certification of Compliance With the PHA and Related Regulations. 14. Administrative Update The next FIRA meeting will he April 22, 2014 at Parkview Villa. *At this time, citizens have an opportunity to discuss with the FIRA items not on the regular agenda. The citizen is requested to limit their comments to five minutes. Please note the public may address the HRA regarding specific agenda items at the time the item is being discussed. HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE MEETING OF OCTOBER 22, 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 Diehm. Staff Present: Executive Director -Walt Fehst, Community Development Director -Scott Clark, Secretary - Shelley Hanson, and Elizabeth Holmbeck, Intern. CommonBond Staff - Laura Frost and Heidi Mindestrom 3. Pledge of Allegiance — Recited CONSENT AGENDA 4. Approve Minutes of July 23, 2013. 5. Approve Financial Reports and Payment of Bills for July, August, and September 2013 on Resolution 2013 -08. Questions from members: Nawrocki again questioned the $37,000 in administration fees that is paid to the City of Columbia Heights. I-Ie still feels this charge is too much and wants a detailed accounting to justify the amount and where the funds go. Clark told him an accounting was provided to him 3 -4 years ago. The amount budgeted hasn't been changed for several years. Clark explained that this is an amount to cover the expense of owning and overseeing the management of a Public Housing Facility, constantly making sure we comply with HUD requirements. City staff from many departments (Police, Fire, Finance, Community Development, City Manager, etc.) spend time at this site, or on issues regarding the property, and /or its' residents, that is owned by the HRA and that some of the cost must be charged to the facility. Motion by Peterson, seconded by Williams, to approve items on the Consent Agenda as presented. All ayes. MOTIONPASSED. HRA RESOLUTION 2013 -08 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOI2 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 HRA Minutes Page 2 October 22, 2013 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: Peterson SECONDED BY: Williams AYES: All ayes BUSINESS ITEM 6. Report of Management Company Nawrocki questioned the continued vacancy rates of the two buildings. At the last meeting there was an 80% occupancy of the south building and it is still only at about 90 %. Frost said occupancy at the north building has been holding at about 98 %. She went on to say that they are processing applications for the south building. There have been several move -outs and move -ins, so the occupancy rate has not changed much. She also said they have had to deny some of the applicants. Nawrocki requested a more detailed report of the number of move -ins and outs for each building similar to one that used to be provided to the members. Frost said she would provide that information in the future. Frost said there aren't any projects in progress at the present time so there is nothing further to report. HRA Minutes Page 3 October 22, 2013 7. Resident Council Minutes Shirley Benitz read the minutes of the October 14, 2013 Resident Council meeting. She reviewed the activities that will be taking place in the next couple months. She said the residents at the meeting voted to retain the current officers until Aeon takes over. Lyn Miner stated that she thought that would have to be voted on by the entire Resident Body, not just the people who attended the meeting, according to the by -laws. 8. Citizens Forum Laverne Harper, unit 408 —said she wasn't aware that the building had been opened up from seniors and disabled. Clark said the north building is a senior (62 +) and disabled persons facility and that HUD defines what "disabled" is. He said the south building is still for people 55 years of age and older. Clark said that over time more disabled people have applied and there are fair housing laws that prohibit discrimination based on race, age, or family status. Rheta Nelsen said some of the residents don't appear to be handicapped and they have no problem staying up late and partying. Diehm said some disabilities aren't always apparent or physical. Clark reminded everyone that all residents have to abide by the rules and there are consequences if they're not followed. There is a process that is followed when violations occur. Sometimes the process takes time, but it is used. Laverne Harper asked how many incidents have to happen before action is taken. Diehm asked Frost to explain the process. She said depending on the level of the violation, written warnings are issued for certain violations. If the violation is more serious, or a number of violations have occurred then a notice to terminate the lease is issued. Residents then have the right to appeal. Management moves as quickly as possible on these matters, but realistically they can take 3 -4 weeks to resolve due to following the legal process. Clark said often times attorneys must be consulted, notices must be served, court dates need to be scheduled, and the option for a trial can prolong the process. Ms. Miller from unit 306 — stated she has lived there for 9 years and never felt she was in danger until the last 1 %2 years. Now she locks her doors and is scared to leave her unit after dark. Ken Bloch, unit 315 — reminded residents to report all incidents to the management office as soon as possible, and not just gossip about incidents with other residents. Rheta Nelsen said she gets a lot of complaints about residents burning incense. She said this is very hurtful for those suffering from COPD or allergies. Frost said this is not currently addressed in the lease agreements, but Minneapolis just passed an addendum to their lease documents that prohibits the use of candles, incense, drugs, and e- cigarettes. She said HRA Minutes Page 4 October 22, 2013 CommonBond is also considering adopting this type of policy for their buildings that would restrict the burning of any plant based substances. Ken Bloch asked if there was anything in the lease agreement regarding other strong smells such as paint or other solvents. Frost said she would look at that also. Nawrocki asked what the procedure is for residents to follow if they feel threatened. Frost said they are to report all incidents to the management office as soon as possible. She said a written complaint or report is preferred, but verbal information is also taken. If something happens after hours, residents are to call 911. Shirley Benitz said Police have been called, but just take information and leave the violators on site which makes others uncomfortable. She said these incidents have gotten more frequent and more serious over the last 6 -7 months. Diehm suggested possibly creating a resident group similar to a neighborhood group to help the management staff keep an eye on things throughout the building. Schmitt asked if staff could appoint floor captains. Frost stated that they cannot appoint anyone, that residents would have to volunteer for such a position. Heidi said that most of the problems occur after she leaves for the night, and the people involved know when she leaves. Lyn Miner, unit 202 —said she came home not long ago and two guys tried to follow her into the building. She stopped them and told them to buzz whoever they were there to see. They just left without doing so. She said the problem with a volunteer resident group is that the residents are elderly or handicapped and are too vulnerable to confront anyone. Dielnn said maybe the Police could do random walk throughs of the building to curtail some of these behaviors. Clark said the Police have been doing that for the last couple of weeks during the evening hours. Management staff is also working with the Police Department personnel to come up with other ideas to deal with the changing situation in the building. Clark said he has had discussions with the City Manager and various residents of the building to determine what the best course of action might be. Leeami Miller, unit 424 —said it would be helpful for residents to be made aware of incidents when they happen or that some type of action has been taken regarding an incident. Heidi said she can try to do that, but is restricted as to how much information can be provided due to privacy protections. Person from unit 118 asked if a mandatory meeting could be held for the residents to discuss what is acceptable behavior, and what is not. Frost said that meetings cannot be mandatory. Walt said it sounds as though there have been several issues and that they all need to be reported to management staff so we can better determine the course of action to take. It sounds like some of the issues haven't been reported, and they need to be properly documented. Staff will continue to discuss this item and look into the possibility of additional security. HRA Minutes Page 5 October 22, 2013 9. Approval of Parkview Villa North 2014 Budget Background: Parkview Villa North (PVVN) consists of 101 units of public housing, located at 965 40 °i Avenue Northeast. 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. Clark explained that CommonBond staff would review the figures with the Board. Expenditures The proposed 2014 budget for PVVN is $598,251 and reflects a decrease of $8,200 from the FY2013 budget. 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. Staff recommends adopting Resolution 2013 -09 approving the 2014 PV V North Budget. Questions from the members: Nawrocki asked about the amount going to the City. He again stated he wants to know how that amount is arrived at. Clark repeated that this figure that has been used for several years to partially cover expenses of owning and overseeing this complex. Nawrocki thought it increases the expense to the residents. Clark said it really doesn't since the residents are on subsidized assistance and that this building doesn't pay its fair share of taxes compared to other apartment buildings since it is on the PILOT tax program. Clark also made it clear that the City shouldn't bear the total expense of the HRA operations for this building. The City and HRA are two separate entities and there should be some kind of accountability for the expenses incurred. Nawrocki still wanted to know where the revenue is credited. Clark suggested that Nawrocki set up a meeting with him and the Finance Director so they can review the information that was previously provided to him. Schmitt asked about line item 3100. She was told this amount was for the installation of security cameras. She asked if there were funds for possibly adding night security for the building. Clark said he will bring that back to the City Council in December when the final budget is approved by them. Motion by Peterson, seconded by Williams, to waive the reading of Resolution 2013 -09, there being ample copies available to the public. All ayes. MOTION PASSED. HRA Minutes Page 6 October 22, 2013 Motion by Peterson, seconded by Williams, 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. All ayes. MOTION PASSED. HOUSING AND REDEVELOPMENT AUTHORITY IN AND FOR THE CITY OF COLUMBIA HEIGHTS BRA 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 22"" DAY OF OCTOBER, 2013. Motion By: Peterson Seconded by: Williams Roll Call: All ayes Tammera Diehm, Chair R. Fehst, Executive Director 10. Approval of Parliview Villa South 2014 Budget Background: Parkview Villa South (PVVS) is a 45 unit apartment building, located at 965 40 °i 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. Again, staff reviewed the budget with the members. HRA Minutes Page 7 October 22, 2013 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. Staff recommends adopting Resolution 2013 -10 approving the 2014 PVV South Budget. Questions by members: Nawrocki stated he thinks more than $37,000 is going to the City for the servicing fees. Clark told him the 2014 Budget Worksheet shows that $25,500 is the servicing fees for the north building and that $11,500 is the amount for the south building. These figures will be discussed in the meeting with the Finance Director as noted earlier. Motion by Peterson, seconded by Williams, to waive the reading of Resolution 2013 -10, there being ample copies available to the public. All ayes. MOTIONPASSED. Motion by Peterson, seconded by Williams, 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. All ayes. MOTION PASSED. 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. HRA Minutes Page 8 October 22, 2013 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 11. PUBLIC HEARING Approval of PHA Plan Amendment - Resolutions 2013 -11 and 2013 -12 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 North holds approximately $165,000 in modernization funds that includes appropriations from FY 201 land 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 commence, the bid work will be beneficial to the long term 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: 1) Door frames, doors and hardware for future ADA compliant units on the first floor ( $18,800) 2) Hallway carpet floors I 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 day legal notice, access via and through City sources, etc.). Staff recommends approval of the PHA Amendment as written. Questions by members: Clark said these projects will be bid out and work started within the next 4 -5 weeks. Nawrocki asked what the status of the elevators were. Frost said the motor drive is what shut down the elevators for 3 weeks. The parts were ordered and installed at a cost of approximately $15,000. The $43,349 will be used to repair the doors, rollers, and working mechanisms of the elevator which is necessary maintenance due to the age of the elevators. Aeon will be spending an additional $85,000 on the elevators once they take over I -IRA Minutes Page 9 October 22, 2013 Clark told members that a major priority right now is the replacement of the Fire Alarm System. The Fire Chief said this is a necessary improvement since the original system is nearing its life expectancy and we do not want to risk this system not being in working order. Nawrocki asked if the system could be modified to work as a security alarm to the Police in addition to a Fire Alarm. Clark said the Fire Chief indicated the two systems have to be separate. Schmitt asked about replacement of the computers on page 6 of the plan. Frost said that is part of the 5 year projection plan and that it covers replacement of two computers, as well as the software, interfacing with other components of the system, and any other equipment necessary. The Public Hearing was Opened. Leeann Miller asked if the Federal Funds can only be used for the North side. Diehm stated that was correct The Public Hearing was Closed. Motion by Peterson, seconded by Schmitt, to waive the reading of Resolution 2013 -11 there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Peterson, seconded by Williams, to Adopt Resolution 2013 -11 Approving a PHA Amendment for FY 2011, FY 2012 and Approving FY 2013 Physical Needs Work Statement. and Motion by Peterson, seconded by Williams, to waive the reading of Resolution 2013 -12 there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Peterson, seconded by Williams, 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. BRA RESOLUTION 2013 -11 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) CONFIRMING APPROVAL OF THE FY 2011, FY 2012 and FY2013 PUBLIC HOUSING AGENCY CERTIFICATIONS OF COMPLIANCE WITH AMENDED PHA PLANS AND RELATED REGULATIONS. WHEREAS, The Department of the Housing and Urban Development has requested that Public Housing Agencies submit a Certification in regard to Public Housing Agency Compliance with PHA Plans and related Regulations; and WHEREAS, Amendments to the FY 2011, FY 2012 and FY 2013 PHA Plan was published for review and comment in the local newspaper and is located at the local Public Library, administrative offices of the PHA, and the PHA development management office. WHEREAS, such Certification also requires the formal approval of the Board of Commissioners; HRA Minutes Page 10 October 22, 2013 NOW, THEREFORE, BE IT RESOLVED, BY THE Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that the attached (Appendix) Public Housing Agency Certification of Compliance with the Amended PHA Plans and related Regulations is hereby approved. ADOPTED THIS day of Motion by: Peterson Seconded by: Williams Roll Call: All ayes 2013. HOUSING AND REDEVELOPMENT AUTHORITY Tammera Diehm, Chair Walter R. Fehst, Executive Director HRA RESOLUTION 2013 -12 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT (HRA) CONFIRMING APPROVAL OF THE 2014 PHA PLAN AMENDMENT WHEREAS, The 2012 PHA Plan was published for review and comment in the local newspaper and is located at the local Public Library, administrative offices of the PHA, and the PHA development management office. WHEREAS, such Amendment also requires the formal approval of the Board of Commissioners; NOW, THEREFORE BE IT RESOLVED, by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that the attached (Appendix) Amended PHA Plan is hereby approved. ADOPTED THIS 22 "d of October, 2013. MOTION BY: Peterson SECONDED BY: Williams ROLL CALL: All ayes HOUSING & REDEVELOPMENT AUTHORITY Tammera Diehm Executive Director - Walter Fehst HRA Minutes Page 11 October 22, 2013 Administrative Update Clark reported that the sale process came to an impasse with HUD about 6 -7 weeks ago. Aeon then got Congressman Ellison involved. Carol Wayman from his office had been pushing HUD to move on this. Then the government shut down happened which closed down that office. Once re- opened, HUD made contact with Aeon and Ellison's office. HUD was going to submit a letter of response, but Carol Wayman told them not to send the letter until it could be verbally discussed first, so that the process would not be slowed down once again. Staff, Aeon, and Ellison's office will be in communication regarding this again this week so that they can try to keep the process moving forward. The key message staff is relaying is that HUD needs to do something to help the residents that live here. Diehm stated the next regular meeting is scheduled for Tuesday, January 28, 2014, at Parkview Villa. The meeting was adjourned at 8:35 pm. Respectfully submitted, Shelley Hanson Secretary HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE SPECIAL MEETING OF January 13, 2014 Call to order — The meeting was called to order by Chair Diehm at 8:20 pm Roll Call — Members present: Bruce Nawrocki, Donna Schmitt, Gary Peterson, Rheta Nelson, Bobby Williams and Tammera Diehm. Staff Present: Executive Director -Walt Fehst, Community Development Director -Scott Clark, Assistant Community Development Director -Joe Hogeboom and Community Development Intern - Elizabeth Holmbeck. 3. Pledge of Allegiance - Recited Business Item Approval of the Rental Assistance Demonstration Application (RAD) on Resolution 2014- 01 MOTION: Move to approve the RAD Application on Resolution 2014 -1. Chair Diehm introduced the business item and informed the HRA that staff will be explaining the Rental Assistance Demonstration (RAD) program. Director Clark explained that RAD is an alternate method of conversion of public housing, offered through the United States Department of Housing and Urban Development (HUD), which would enable the sale of the Parkview Villa property to Aeon. Clark explained that the method differs from conversion tools previously discussed by the HRA, in that RAD works with a collaboration of the public and private sectors. Director Clark explained that Aeon had previously attempted to facilitate the sale of Parkview Villa through HUD's "Voluntary Conversion" process and also through HUD's "Demolition and Disposition" process. hi late 2013, City staff and Aeon staff spoke with United States Congressman Keith Ellison, who in turn spoke with HUD leadership. Clark explained that the conversations resulted in a special staff person from HUD being assigned as a liaison for the Parkview Villa conversion project. Director Clark stated that the HUD liaison advised Aeon to submit an application for participation in the RAD program. Clark explained that it appears that contract rent calculations will not align with RAD application requirements; however, it is still necessary to submit the application per HUD's request. Clark stated that RAD applications are due it) late January, and an executed resolution from the HRA is a necessary component of that application. Executive Director Fehst asked if HUD would consider a hybrid process in which RAD could be applied simultaneously with an alternate conversion process in order to facilitate the sale. Director Clark said that would be a possibility, and that staff will have further discuss the possibility with I -IUD. Clark explained that the "Voluntary Conversion" process is still valid to the project, and is still under consideration. Commissioner Nawrocki asked questioned the future status of the HRA, if the RAD process were to be implemented. Clark stated that, based on his understanding of the RAD program, he believes that the HRA would still technically exist, but its role would be minimal. Management of Parkview Villa would be the responsibility of Aeon. Executive Director Fehst announced that he has reached out to U.S. Congressman Ellison's office in Washington D.C. to arrange a possible meeting between HUD and HRA staff. Commissioner Schmitt stated that she feels it important for Aeon to participate in the meeting. Commissioner Nawrocki questioned what the cost of the sale and acquisition process of Parkview Villa is to the City /HRA. Director Clark estimates that the total cost of the sale process to the City, so far, has been approximately $6,000. Clark pointed out that the cost to Aeon has been significantly more, estimating it to be around $250,000. Chair Diehm summarized the action step, and requested a motion to move forward. Motion by Peterson, seconded by Schmitt, to waive the reading of Resolution 2014 -01 there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Peterson, seconded by Schmitt, to adopt Resolution 2014 -01, approving Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) Approving Submission of a Rental Assistance Demonstration Application for Parkview Villa North. Roll Call: ayes- Peterson, Schmitt, Diehm, Nelson, Nawrocki, Williams MOTION PASSED. HRA RESOLUTION 2014 -1 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING SUBMISSION OF A RENTAL ASSISTANCE DEMONSTRATION APPLICATION FOR PARKVIEW VILLA NORTH WHEREAS, the HRA owns and operates 101 units of public housing at Parkview Villa North (PVN), including one unit currently used for management; and WHEREAS, PVN has deferred maintenance, capital and resident service needs that appear not to be able to be met through continued insufficient funding under the public housing program; and WHEREAS, the Consolidated and Further Continuing Appropriations Act of 2012 (Public Law 112 -55, approved November 18, 2011) created the Rental Assistance Demonstration (RAD) Program, which allows Public Housing Authorities (PHAs) to convert public housing subsidies into long -term, project -based Section 8 rental assistance subsidies with the hope that this funding source will provide more stable and predictable annual funding and better facilitate leveraging of other resources such as low- income housing tax credits than public housing; and WHEREAS, HRA staff has prepared a RAD application for PVN and is following all required procedural steps to submit the application to the U.S. Department of Housing and Urban Development (HUD); and WHERE AS, the HRA previously submitted an application to HUD for voluntary conversion of PVN to vouchers that would provide more sufficient resources for PVN than RAD, including for critical supportive services, but that application may not be approved or may be partially approved by HUD; NOW, THEREFORE BE IT RESOLVED, that the Board of Commissioners of the HRA (1) approves the attached Board Approval Form for a RAD application to HUD for the conversion of PVN from public housing to Section 8 project -based assistance, (2) otherwise authorizes the Executive Director to execute and submit the RAD application and any related documents to HUD, and (3) authorizes the Executive Director to take any necessary actions to comply with all requirements of the RAD program. ADOPTED THIS 13 °i Dav of Januarv, 2014 MOTION BY: SECONDED BY: ROLL CALL: HOUSING & REDEVELOPMENT AUTHORITY Chair - Tammera Diehm Executive Director - Walter Fehst Passed this 13 °i day of January 2014. Motion by: Peterson Second by: Schmitt Roll Call: ayes - Peterson, Schmitt, Diehm, Nelson, Nawrocki, Williams Tammera Diehm, Chair Shelley Hanson, Secretary Motion by Peterson, seconded by Schmitt to adjourn the meeting at 9:20 pm. Respectfully Submitted, Joe Hogeboom Acting Recording Secretary COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meeting of: January 28, 2014 AGENDA SECTION: Consent ORIGINATING EXECUTIVE NO: 6 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Adopt Resolution 2014 -02 BY: Scott Clark BY: Designating Depository for the HRA DATE: January 22, 2014 BACKGROUND: The attached Resolution 2014 -02, designates Northeast Bank as the depository for all Columbia Heights HRA funds and authorizes signatories for accounts. This is an annual function approved at the first meeting of the year. RECOMMENDATION: Staff recommends adoption of Resolution 2014 -02, designating a depository for the HRA and authorizing signatures. RECOMMENDED MOTION: Move to waive the reading of Resolution 2014 -02, there being an ample amount of copies available to the public. Move to Adopt Resolution 2014 -02, a Resolution Designating Depository for the Columbia Heights Housing and Redevelopment Authority (HRA). HRA ACTION: RESOLUTION NO. 2014 -02 RESOLUTION DESIGNATING DEPOSITORY FOR THE COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) WHEREAS, the City of Columbia Heights Housing and Redevelopment Authority (herein referred to as the "Corporation ") has entered into a Management Contract with Commonbond Housing (herein referred to as "Management Company "), dated January 23, 2008, and amended on November 9, 2009 and extended on October 25, 2011 and January 22, 2013, and WHEREAS, by Minnesota Statutes the Corporation must establish a depository agency, and WHEREAS, the Corporation desires to have as authorized signatures both officers of the Corporation and the Management Company. IT IS HEREBY RESOLVED, that Northeast Bank, is hereby designated as a depository of the funds of this corporation. IT IS FURTHER RESOLVED, that checks, drafts, or other withdrawal orders issued against the funds of this corporation on deposit with said bank shall be signed by at least two of the following: HRA Executive Director Management Company CEO Management Senior Vice President Management Director of Administration And that said bank is hereby fully authorized to pay and charge to the account of this Corporation any checks, drafts, or other withdrawal orders. BE IT FURTHER RESOLVED, that the Northeast Bank, is designated depository of the Corporation and it is hereby requested, authorized and directed to honor checks, drafts or other orders for the payment of money drawn in this Corporation's name, including those drawn to the individual order of any person or person whose name or names appear thereon as signer or signers thereof, when bearing or purporting to bear the facsimile signatures of at least two of the following: Management Company CEO Management Company Senior Vice President Management Company Director of Administration And that Northeast Bank shall be entitled to honor and to charge this Corporation for all such checks, drafts or other orders, regardless of by whom or by what means the facsimile signature or signatures thereon may have been affixed thereto, if such facsimile signature resembles the facsimile specimens duly certified to or filed with the Bank by the City Clerk or other officer of this Corporation. BE IT FURTHER RESOLVED, that any and all resolutions heretofore adopted by the Corporation and certified to as governing the operation of the Corporation's account(s) with it, be and are hereby continued in full force and effect, except as the same may be supplemented or modified by the foregoing part of this resolution. BE IT FURTHER RESOLVED, that all transactions, if any relating to deposits, withdrawals, re- discounts and borrowings by or on behalf of this Corporation with said bank prior to the adoption of this resolution be, and the same hereby are, in all things ratified, approved and confirmed. BE IT FURTHER RESOLVED, that any bank or savings and loan located in the State of Minnesota may be used as depositories for investment purposes so long as the investments comply with authorized investments as set forth in Minnesota Statutes. BE IT FURTHER RESOLVED, that any brokerage firm located in the State of Minnesota may be used as a depository for investment purposes so long as the investments comply with the authorized investments as set forth in Minnesota Statutes. Passed this 28th day of January, 2014 Offered by: Seconded by: Roll Call: 0 inn Shelley Hanson- Secretary COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) Meeting of: January 28, 2014 AGENDA SECTION: Consent Agenda ORIGINATING EXECUTIVE NO: 7 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Financial Report and Payment of Bills BY: Joe Hogeboom BY: — Resolution 2014 -03 DATE: January 22, 2014 BACKGROUND: A copy of the Financial Reports for the months of October, November and December 2013 is attached. RECOMMENDATION: Parkview Villa and City staff will be available to answer specific questions about the Financial Reports. Following questions (if any), it is recommended that 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 2014 -03, there being ample copies available to the public. Motion: Move to approve Resolution 2014 -03, Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of October, November and December 2013. ,vaacnmencs: nesoivaon ZU iv -vo anu nnanwai 6Ld WHicnw HRA ACTION: HRA RESOLUTION 2014 -03 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR OCTOBER, NOVEMBER AND DECEMBER 2013 AND PAYMENT OF BILLS FOR THE MONTHS OF OCTOBER, NOVEMBER, AND DECEMBER 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 October, November and December 2013 and the list of bills for the months of October, November and December 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 28th day of January 2014. MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary 0 it �4flrwTmw Parkview Villa North Financial Statement Overview October 2013 Revenue: Occupancy for the month of October 2013 was 95 % occupied; Rent Revenue was under budget (unfavorable) and reflects occupancy Total Revenue for October was under budget (unfavorable) as no grant income was drawn down 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 September billing Gas was under budget (favorable) and reflects September 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 (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 over budget (unfavorable); however, this is a quarterly billing Security Contract was over budget (unfavorable) and reflects Fire Alarm Inspection and Fire Sprinkler Inspection costs Irrigation Systems was over budget (unfavorable) and reflects the cost of system shut down Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs was over budget (unfavorable) and reflects the cost of Boiler replacement Decorating Contract was over budget (unfavorable) and reflects the cost of unit turnover Furniture and Fixtures was over budget (unfavorable) and reflects the cost of replacement washing machine P P P P 41 P N P P P P P P P P P P P. P m N ...... N N VI r r r N A N N N A N A A W w w N O O O N W W A N M O O O P W P w o W N V o O A r o N M O N m o W V O Y W V O O N Y O nc o n n m y0 g o A » m w z Er n ryry x ^ c n a�? 0 6 " mil'° ry e m o 6 � 1 O N O p N b O O Y b V N V O w w r l+ r J O J W O O b W A b W N A W � N P N A b P p OI O 0 0 0 0 W N A r m O 0m W m v b m N A r N W m A N W r P N O W O O A v O N O W N m O O N O O o O T N N O V O V O W O O O O O O O Y A v A W A m O y O r N N N r A O W W W W VI W O O J W W O J O O O O W N r m 0 W IAn N AW � O IAi1 A 111 W O O O N O J ON A W N W Y A O V W W O Nil O O O O N O b O O O A O w J N O °o °a o n °o °O 00 w °o 1 00 °o O O d W O A W W V J P N ym v A N o r P IW/I N 6 N N N A O W 0 0 0 lwll A J b O W O r O N O VI O b W r O O m A O W W O O O O lPil T W b v A m N V r O A A N W b V p J b W r W VI N J J J P O O 10 lNll O W t4 O Vwl O P VI O v O O A Z b J P r N N O W 0 W D T N 10 W J J O D) O O P v N w 0 r OmW�PUlO VIrP O O O O O O O O A O O .......... O i m m a m O m W O O p O O O O O O O N Y b � J Nll O O O r N A O W 0m O r W N A T W V UI � N pN b N O b w � W O VIm V N P W O O P A W o o W N N J w 0 0 wol I `3 W ne 0 10 wc& E W 3 b b b W V V V Y Y V V V Vi Qi N N N b Ol b Y A A A A O O O b W V V J V O N W N V T o w N O W N M W N V N o W o Y H Z y Z = 6 0 '-� o v v O O m � D O a it m o x m E m E b 3 n °m e E -� E° c d C � a n O O 9 V q 9 i o W 1w, O p O O O O N N N " W W Nil O O W O O J Y N W N VI w O o Y r oO O O p O O O O O N N W N V O p oV, O O m o 0 P m P N N Oi P P N P P P P P P P P N. N Obi 'O o Qj N V N O A rob m m vi N w J N VWl V� d i %— ry u a mr°i'o o o 2 O Q d b !01 C o c �0 �fl m m OIW N mIW m O In N J A O' O O A N F, q o W m m m A m m b W P m m N y Pein IOiI r O A O O W N O V O N A 0 A C, r r W O N VVI O J J W O O O V V r N rN O V� W IWn W r N O r P q VVI O b m b N o o N �O N N U J N h O D r r O D O O O O A N b O N A r � O VI O N r Vi NP O r A O O W O O A O N A W A N r✓ r N N W r P A w O O W O r A W O A V W O O VI N P W O N VI O V V O J J 0 0 0 0 0 0 0 o O O O o 0 u"'ine WN m`p"p m VVI U 1�Oil V °nnooumo v°i °mm °O mm e xs;v55$E„ eaee W A r VI W A In J P W O N W r A O N N O O O O O N O O O . . . . . O O O O O O O O O O O O O O W C 0 0 O � 0 a p3 o^ o Q O 3 ) / fk f§! �)\ C) L7 # \ $ e \(( \( ] � , / \ o }\j .� }$/ a 1 ■ ; ) @ 2 }(\ 7 /\[ \ ƒ E ; | } � j k) *6 1 ■ ; ) @ 2 ) \}/ ƒ E ; 1 ■ ; a ) @ 2 ) . ƒ E ; } � j k) *6 \ ))t { ) )sM * \//) 0 {/ ƒ ! « 0 � U) a ! @ 2 ) \ \ < 0 ; a Parkview Villa -North (165) Balance Sheet October 2013 Books = Accrual IGTi5ki ssets 10100 Cash Balance 34,795.91 10200 Petty Cash 871.00 10400 Investments 891,214.11 11300 Rent Receivable 3,050.20 11500 Accounts Receivable 463.12 15510 Prepaid Insurance 2,849.16 Total ssets 933,243.50 is ilities 20200 Accounts Payable 21,636.44 20210 Accrued Other Expenses - 20220 Due to Resident Council 551.74 22000 Deposits 18,173.79 22200 Accrued PILOT 20,271.50 22210 Revenue Collected in Advance 3,072.12 Total is ilities 63,705.59 un alance 25300 Fund Balance 869,537.91 Total un alance 869,537.91 Total is ilities an un alance 933,243.50 1/1312014 1:45 PM Parkview Villa -North (165) Income Statement For The Period Ending October 2013 Books = Accrual Page 1 of 2 Month to Date %o year to Date 0/ Revenue 33160 -46330 Federal Grant - 0.00% 67,963.41 18.19% 36220-46330 Gen. Government Rents 28,360.00 97.17% 295,467.00 79.07% 36225 -46330 Nondwelling Rents 330.00 1.13% 3,960.00 1.06% 36290 -46330 Other Miscellaneous Revenue 496.00 1.70% 6,154.86 1.65% 39120 -46330 Recovery Damage City Property - 0.00% 130.00 0.03% Total Revenue 29,186.00 100.000/0 373,675.27 300.00^/0 Expenses Personal Services 1000 -46330 Accrued Salaries 8,752.00 29.99% 87,520.00 23.42% Total Personal Services 8,752.00 29.990/0 87,520.00 23.42% Supplies 2000 -46330 Office Supplies 191.42 0.66% 1,430.71 0.38% 2010 -46330 Minor Equipment 605.14 2.07% 1,808.21 0.48% 2160 -46330 Maim. & Construct Materials 405.96 1.39% 4,938.54 1.32% 2171 -46330 General Supplies 411.86 1.41% 1,646.33 0.44% Total Supplies 1,614.38 5.530/0 9,823.79 Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 3,740.95 1.00% 3050 -46330 Expert and Professional Services 0.00 0.00% 13,244.00 3.54% 3060 -46330 Management Services 4,772.00 16.35% 47,720.00 12.77% 3100 -46330 Protective Services 1,387.29 4.75% 4,131,42 1.11% 3210-46330 Telephone & Telegraph 354.98 1.22% 3,522.01 0.94% 3430 -46330 Advertising Other 0.00 0.00% 65.00 0.02% 3600 -46330 Insurance & Bonds 1,424.58 4.88% 14,321.23 3.83% 3810 -46330 Electric 4,982.32 17.07% 40,796.87 10.92% 3820 -46330 Water 2,296.66 7,87% 8,095.84 2.17% 3830 -46330 Gas 511.96 1.75% 25,842,24 6.92% 3840 -46330 Refuse 3,750.06 12.85% 11,344.08 3.04% 3850 -46330 Sewer 1,612.78 5.53% 3,725.37 1.00% 4000 -46330 Repair & Maim. Services 12,123.78 41.54% 62,401.49 16.70% 4100 -46330 Rents & Leases 0.00 0.00% 710.29 0.19% 4300 -46330 Miscellaneous Charges 55.10 0.19% 76.10 0.02% 4315 -46330 PILOT 2,027.15 6.95% 20,816.66 5.57% 4390 -46330 Taxes & Licenses 103.50 0.00% 1,446.88 0.39% 4500 -46330 Administrative Expenses 0.00 0.00% 1,205.84 0.32% 4850 -46330 Interest on Deposits 13.57 0105% 139.20 0.04% Total Other Services & Charges 35,415.73 121.34% 263,345.47 70.47% Page 1 of 2 111 3/2 01 4 1:45 PM Capital Outlay 5120 -46330 Building & Improvements 0.00 0.00% 1,839.76 0.49% Total Capital Outlay 0.00 0.000/0 1,839.76 0.49^/0 Total Expense 45,782.11 156.86^/0 362,529.02 97.02% Excess (Deficit) Revenue over Expense - 16,596.11 - 56.86% 11,146.25 2.98% Page 2 of 2 Parkview Villa -North (1.65) Cash to State ent Period = October 2013 Book == Arcrual Month to Date 1/13/201412:43 PM Revenue 33160 Federal Grant 0.00 36220 Gen. Government Rents 28,360.00 36225 Nondwelling Rents 330.00 36290 Other Miscellaneous Revenue 496.00 39120 Recovery Damage City Property 0.00 Total Revenue 29,186.00 Expenses Personnel Services 1000 Accrued Salaries 8,752.00 Total Personnel Services 8,752.00 Supplies 2000 Office Supplies 191.42 2010 Minor Equipment 605.14 2160 Malnt. & Construct Materials 0.00 2171 General Supplies 817.82 2280 Vehicle Parts 0.00 Total Supplies 1,614.38,, Other Services & Charges;. 3040 Legal Fees 0.00 3050 Expert & Professional Services 0.00 3060 Management Services 4,772.00 3100 Protective Services 1,387.29 3210 Telephone & Telegraph 354.98 3430 Advertising Other 0.00'.x, 3600 Insurance & Bonds 1,424.58 3810 Electric 4,982.32 3820 Water 2,296.66 3830 Gas 511.96 3840 Refuse 3,750.06 3850 Sewer 1,612.78 4000 Repair & Maint. Services 12,123.78 4050 Garage, Labor Burd. 0.00 4100 Rent & Leases 0.00 4300 Miscellaneous Charges 55.10 4315 PILOT 2,027.15 4390 Taxes & Licenses 103.50 4500 Administrative Expenses 0.00 4850 Interest on Deposits 13.57 5120 Building & Improvement 0.00 Total Other Services & Charges 35,415.73 Total Expenses 45,782.11 Excess (Deficit) Revenue over Expenses - 16,596.11 Page 4 of Parkvlew Villa-North (165; Cash to State ent Period = October 201; Book -= Accrual ust ants 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government nits 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total ust ents Cash to 10100 Cash alance 10200 Petty Cash 10400 nvest ants Total Cash 1/13/2014 12:43 PM Month to Date 0.00 0.00 192.00 -55.00 0.00 1,424.58 838.00 0.00 34.00 2,027.15 138.00 4,598.73 (11,997.38) eg Cash En Cash Difference 46,793.29 34,795.91 (11,997.38) 871.00 871.00 - 891,214.11 891,214.11 - 938,878.40 926,881.02 (11,997.38) Page 6 of Parkview Villa -North (165) General Ledger Period = Oct 2013 Book = Accrual ; Tree = Ysl_ 1000 -46330 Accrued Salaries 78,768.00 = Beginning Balance = 165 10/31/2013 :PostRecurring Monthly recurring entry 1- 175469 RC 8,752.00 0100 87,520.00 R/C CHC PR Mgmt Fee 165 10131/2013 :PostRecurring Monthly recurring Net Change = 8,752.00 RC 0.00 8,752.00 47,720.00 87,520.00 = Ending Balance = 2000 -46330 Office Supplies 47,720.00 1,239.29 = Beginning Balance = 165 10/3/2013 Office Depot(off18804) P- 353953 6.73596E +11 39.20 0.00 1,278.49 paper /candy 165 10/3/2013 Office Depot(off18804) P- 353956 6.73597E +11 6.63 0.00 1,285.12 candy 165 10/17/2013 CommonBond Housing (chc) P- 354249 101713racy opt 145.59 0.00 1,430.71 opm forms 1/13 -10/13 Net Change= 191.42 = Ending Balance = 3210 -46330 Telephone &Telegraph 1,430.71 = Ending Balance = 2160 -46330 Minor Equipment = Beginning Balance = 165 9/30/2013 Popp.com (popp) P-354047 11203.07 = Beginning Balance = 165 10/3/2013 HD Supply Facilities Maintenance, Ltd. ( P- 352325 9125318039 605.14 0.00 1,808.21 washer 3,499.50 phone -Oct. rate plan Net Change= 605.14 Level One (leve) P- 352244 03586781N 76.52 11808.21 = Ending Balance = 2160 -46330 Maint. & Construct Materials Level One (leve) P- 352203 0358678IN -352 0.00 4,532.58 = Beginning Balance = 165 9/24/2013 HD Supply Facilities Maintenance, Ltd. ( P- 352298 9125100751 197.74 0.00 4,730.32 ktchn fct/popup 165 9/24/2013 NO Supply Facilities Maintenance, Ltd. ( P- 352300 9125100749 114.71 0.00 4,845.03 chrome faucet 165 9/27/2013 Frattalone's /Metro Ace (frat) P- 351627 016459R 8.96 0.00 4,853.99 top pivot gulde;glue;insct! 165 10/18/2013 Frattalone's /Metro Ace (frat) P- 354562 016652R 3.92 0.00 4,857.91 distilled water 165 10/23/2013 HD Supply Facilities Maintenance, Ltd. ( P- 355056 9125721513 80.63 0.00 4,938.54 faucet supp /bulbs /polymer 1,424.58 0100 Net Change= 405.96 C of Columbia Heights Ins, Net Change= 1,424.58 4,938.54 = Ending Balance = 2171 -46330 General Supplies 1,234.47 = Beginning Balance = 165 8/2/2013 Sherwin- Williams Co.(sher4110) P- 354191 82471 205.93 0.00 1,440.40 paint 165 9/12/2013 Sherwin - Williams Co.(sher4110) P- 354192 47750 205.93 0.00 1,646.33 paint Net Change= 411.86 1,646.33 = Ending Balance = 3040 -46330 Legal Fees Net Change =0.00 3,740.95 = Beginning Balance = 3,740.95 = Ending Balance = 3060 -46330 Management Services 42,948.00 = Beginning Balance = 165 10/29/2013 CommonBOnd Housing (chc) P- 355475 102913mgmt It 13,524.00 0.00 56,472.00 regret fee 10/13 165 10131/2013 :PostRecurring Monthly recurring entry 1- 175469 RC 0.00 8,752.00 47,720.00 R/C CHC PR Mgmt Fee Net Change = 4,772.00 47,720.00 = Ending Balance = 3100 -46330 Protective Services 2,744.13 = Beginning Balance = 165 10/24/2013 Olsen Fire Protection, Inc. (olse) P- 355397 3144 759.00 0.00 3,503.13 fire sprinkler Inspect 165 10/25/2013 Total Life Security LLC (tota321) P- 355696 2162 628.29 0.00 4,131.42 alarm inspctn 10/11/13 Net Change= 1,387.29 4,131.42 = Ending Balance = 3210 -46330 Telephone &Telegraph 3,167.03 = Beginning Balance = 165 9/30/2013 Popp.com (popp) P-354047 992137111 221.57 0.00 3,388.60 phone - 10/01- 10/31/13 165 10/1/2013 Level One (leve) P-351901 03586781N 110.90 0.00 3,499.50 phone -Oct. rate plan 165 10/1/2013 Level One (leve) P- 352244 03586781N 76.52 0.00 3,576.02 phone -Oct. rate plan 165 10/4/2013 Level One (leve) P- 352203 0358678IN -352 0.00 110.90 3,465.12 phone -Oct. rate plan 165 10/2/2013 ComCast(COmC3474) P- 353813 877210505019, 56.89 0.00 56.89 Internet 10 /11- 11/10/13 Net Change = 354.98 3,522.01 = Ending Balance = 3430 -46330 Advertising Other 65.00 = Beginning Balance = Net Change =0.00 65.00 = Ending Balance = 3600 -46330 Insurance & Bonds 12,896.65 = Beginning Balance = 165 10/31/2013 :PostRecurring Monthly recurring entry 1-175469 RC 1,424.58 0100 14,321.23 C of Columbia Heights Ins, Net Change= 1,424.58 14,321.23 = Ending Balance = 3810 -46330 Electric 35,814.55 = Beginning Balance = 165 10/11/2013 Xcel Energy(xcel) P- 354292 5150441553 IC 4,982.32 0.00 40,796.87 E- 09/04- 10/05/13 Net Change= 4,982.32 40,796.87 = Ending Balance = 3820 -46330 Water 5,799.18 = Beginning Balance = 165 10/10/2013 City of Columbia Heights (colu) P- 353450 318025000011 2,269.91 0.00 8,069.09 W-06/20- 09/27/13 165 10/10/2013 City of Columbia Heights (colu) P- 353791 318024500011 26.75 0.00 8,095.84 W- 06/20- 09/20/13 Net Change = 2,296.66 8,095.84 = Ending Balance = 3830 -46330 Gas 25,330.28 = Beginning Balance = 165 10/7/2013 CenterPoInt Energy (cent) P- 353825 55199657 10/0 511.96 0.00 25,842.24 G- 09/04- 10/03/13 Net Change = 511.96 25,842.24 = Ending Balance = 3840 -46330 Refuse 71594.02 = Beginning Balance = 165 10/10/2013 City of Columbia Heights (colu) P- 353791 318024500011 3,518.34 0.00 11,112.36 Trash /recycl- 06/20- 09/20/ 165 10/21/2013 Green Lights Recycling Inc (gree1004) P- 355403 135451 231.72 0.00 11,344.08 appliance recycling Net Change= 3,750.06 11,344.08 = Ending Balance = 3850.46330 Sewer 2,112.59 = Beginning Balance = 165 10/10/2013 City of Columbia Heights (colu) P- 353450 318025000011 1,130.16 0.00 3,242.75 5- 06/20- 09/27/13 165 10/10/2013 City of Columbia Heights (colu) P- 353791 318024500011 482.62 0.00 3,725.37 5- 06/20- 09/20/13 Net Change = 1,612.78 3,725.37 = Ending Balance = 4000 -46330 Repair & Maint. Services 50,277.71 = Beginning Balance = 165 9/25/2013 Adam's Pest Control, Inc.(adam) P- 353423 828402 51.91 0.00 50,329.62 extern treat- 09/25/13 165 9/30/2013 All Metro Lawn & Snow, LLC (allm2138) P- 353310 2796 262.50 0.00 50,592.12 mow /trm /biw- 09/01 -09/27 165 9/25/2013 Fridley Snowplowing and Removal (frid4 P- 353307 22989 185.06 0.00 50,777.18 ung repair 165 9/13/2013 BMM Inc (bmmp P- 351742 26915 629.28 0.00 51,406.46 repairs 9/9- 13/2013 165 9/18/2013 Direct Home Appliance Services (dire) P- 352212 091813165a 171.85 0.00 51,578.31 washer /dryer repair 165 9/30/2013 Direct Home Appliance Services (dire) P- 353767 93013165166 61.41 0.00 51,639.72 washer sery 165 10/5/2013 Drain King, Inc. (dra17740) P- 354285 89239 277.50 0.00 51,917.22 drain clear /labor 165 10/1/2013 Kone Inc.(kone) P- 353337 221291680 700.01 0.00 52,617.23 elev maint 10/13 165 9/30/2013 LBP Mechanical, Inc (Ibpm) P- 353309 W19278 7,834.26 0.00 60,451.49 boiler replace- 07/29 -08/13 165 10/14/2013 K.O. Cleaning and Restoration LLC (kocl P- 353902 1547 800.00 0.00 61,251.49 painting 165 10/14/2013 K.O. Cleaning and Restoration LLC (kod P- 353916 1549 500.00 0.00 61,751.49 painting /finish 165 10/14/2013 K.O. Cleaning and Restoration LLC (kocl P- 353917 1550 650.00 0.00 62,401.49 painting /finish Net Change= 12,123.78 62,401.49 = Ending Balance = 4100 -46330 Rents & Leases 710.29 = Beginning Balance = Net Change =0.00 710.29 = Ending Balance = 4300 -46330 Miscellaneous Charges 21.00 = Beginning Balance = 165 10/8/2013 City Wide Locksmlthing, Inc. (city4054) P- 353338 1630 4.99 0.00 25.99 keys 165 10/23/2013 HD Supply Facilities Maintenance, Ltd. ( P- 355056 9125721513 50.11 0.00 76.10 lacks Net Change =55.10 76.10 = Ending Balance = 4315 -46330 PILOT 18,789.51 = Beginning Balance = 165 10/31/2013 :PostRecurring Monthly recurring entry 3- 175469 RC 2,027.15 0.00 20,816.66 Anoka Cty Property Fax Aci Net Change= 2,027.15 20,816.66 = Ending Balance = 4390 -46330 Taxes & Licenses 1,343.38 = Beginning Balance = 165 10/2/2013 MN Dept of Labor & Industry (mndpl) P- 353308 ABR00782591 34.50 0.00 1,377.88 boiler 165 10/2/2013 Minnesota Depart of Labor & Industry (i P- 353429 ALR00333801 69.00 0.00 1,446.88 annual elev oper Net Change= 103.50 1,446.88 = Ending Balance = 4500.46330 Administrative Expenses 1,205.84 = Beginning Balance = Net Change =0.00 1,205.84 = Ending Balance = Parkview Villa North Bank Reconciliation Report 10/31/2013 5016456 Balance Per Bank Statement as of 1013112013 Outstanding Checks Check date Check number 10/2212013 2232 10/22/2013 2236 10129/2013 2240 10/2912013 2241 10/29/2013 2242 10/29/2013 2243 10/29/2013 2244 Less: Outstanding Checks Payee dire - Direct Home Appliance Services kocl - K.O. Cleaning and Restoration LLC aerotek - Aerotek Professional Services home? - HD Supply Facilities Maintenance, Ltd mndol - Minnesota Depart of Labor & Industry mndpl - MN Dept of labor & Industry xcel - Xcel Energy Reconciled Bank Balance I Balance per GL as of 1013112013 Reconciled Balance Per GIL Difference (Reconciled Bank Balance And Reconciled Balance Per GIL) Cleared Items : Cleared Checks 11/07/2013 42,961.96 Amount 61.41 1,960.00 463.68 605.14 69.00 34.50 4,982.32 8,166.05 34,795,91 34,795.91 34,795.91 0.00 Date Tran # Notes Amount Date Cleared 09/25/2013 2203 comc3422 - Comcasl 62.74 10/31/2013 00/2512013 2204 dire - Direct Home Appliance Services 166.85 t 0WI2013 09/25/2013 2205 home? - HD Supply Facilities Maintenance, Ltd. 702.43 10/31/2013 09/2512.013 2206 kone - Kone Inc. 700.01 10/31/2013 09/25/2013 2207 Popp - Popp.com 221.98 10/31/2013 1010112013 - 2208 cent - CenterPoint Energy 481.16 10/31/2013 1010112013 2209 chc- CommonBend Housing 56.23 10/31/2013 10/01/2013 2210 drai7740 - Drain King, Inc. 135.00 10/31/2013 1010112073 2211 frat - Fraltalone's /Metro Ace 15.23 10/31/2013 10/01/2013 2212 mndpl - MN Dept of Labor & Industry 69.00 10/31/2013 10/01/2013 2213 sltz - Sllzmann Construction dba Sitzmann Elect 334.65 10/31/2013- 10/01/2013 2214 tran - Trans -Alarm Inc 265.66 10/31/2013 10/01/2013 2215 xcel - Xcel Energy 51884.33 10/31/2013 10108/2013 2216 bmmi - SIAM Inc 629.28 10/31/2013 Parkview Villa North 11107/2013 Bank Reconciliation Report 10/31/2013 5016456 Cleared Checks Date Tran # Notes Amount Date Cleared 10/08/2013 2217 chc - CommonBond Housing 13,524.00 10/31/2013 10/08/2013 2218 dire - Direct Home Appliance Services 171.85 10/31/2013 10/08/2013 2219 fiat - Fraltalone's /MetroAce 8.96 10/31/2013 10/08/2013 2220 home7 - HD Supply Facilities Maintenance, Ltd. 33.18 10/31/2013 10115/2013 2221 adam - Adam's Pest Control, Inc. 51.91 10/31/2013 10/15/2013 2222 aerotek - Aerotek Professlonal Services 579.60 10/31/2013 10/15/2013 '2223 ollm2138 - All Metro Lawn & Snow, LLC 262.50 10/3112013 10/15/2013 2224 ci1y4054 - City Wide Locksmithing, Inc. 4.90 1013112013, 10/15/2013 2225 frld4908 - Fridley Snowplowing and Removal 185.06 10131/2013 10/15/2013 2226 kone - Kone Inc. 700.01 10/31/2013 10/15/2013 2227 Ibpm . LBP Mechanical, Inc 7,834.20 10/31/2013 10/15/2013 2228 lave - Level One 76.52 10/31/2013 10/22/2013 2229 aerotek - Aerotek Professional Services 579.60 10/31/2013 10/22/2013 2230 chc - Commonl3ond Housing 145.59 10/31/2013 10/22/2013 2231 comc3474 - Comcast 56.89 10/31/2013 10/22/2013 2233 dm17740 - Drain King, Inc. 277.50 10131/2013 10/22/2013 '2234 fiat - Frallalone's/Metro Ace 3.92 10/31/2013 10122J2013 2235 home7 - HD Supply Facilities Maintenance, Ltd, 312.45 10/31/2013 10/22/2.013 2237 popp - Popp.com 221.57 1013112013 10/22/2013 2238 sher4110 - Sherwin- Williams Co. 411.86 10/31/2013 10/2212013 2239 t0005163 - Holmberg - 102.57 10/31/2013 Total Cleared Checks 35,269.34 Cleared Deposits Date Iran # Notes Amount Date Cleared 10/07/2013 521 26,918.00 10/31/2013 10/07/2013 521 403.00 10/31/2013 10/08/2013 522 1,667.00 10/31/2013 10/10/2013 523 257.00 10/31/2013 10/10/2013 523 20.00 10/31/2013 10/18/2013 526 319.00 10/31/2013 Total Cleared Deposits 29,584.00 Date 10/31/13 Page 1 Primary Account @XXXXXO6456 Enclosures 40 BRA 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 - - -- NOW.YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S NEB BROWSER OR OUR MOBILE BANKING APP1 YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOGGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Account Number ®XXXXXQ6456 Previous Balance 48,647.30 4 Deposits /Credits 29,784.00 36 Checks /Debits 35,469.34 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 42,961,96 Number of Images 40 Statement Dates 10/01/13 thru 10/31/13 Days in the Statement Period 31 Average Ledger 51,280 Average Collected 50,317 wwww * ** www**** ww* w** x** Wxxw* wxx**** x*** x* x***** x *xxW * * * *Wx * * * * * * * * * * * * *Wx *WWxW Deposits and Credits Date Description Amount Amount 10/07 DDA REGULAR DEPOSIT 27,521.00 10/10 DDA REGULAR DEPOSIT 277.00 10/10 DDA REGULAR DEPOSIT 1,667.00 10/18 DDA REGULAR DEPOSIT 319.00 ************** * * *w *ww * * *wwwww * * *ww * *w *w * * * * ** www ** *www * * * * * * * *xW * *w * * * * * * * * * ** Charges and Debits Date Description 10/07 DDA DEBIT MEMO Amount 200.00 DR Checks in serial order Date 'Check# Amount 10/03 2203 62.74 10/07 2204 166.85 10/01 2205 702,43 10/02 2206 700.01 10 /O1 2'207 221.98 '* Indicates skip in check numbers Date Check# Amount 10/07 2208 481.16 10/03 2209 56.23 10/09 2210 135.00 10/08 2211 15.23 10/04 2212 69.00 Date 10/31/13 Page 2 Primary Account @XXXXX96456 Enclosures 40 NORTBEAST PUBLIC FUNDS ACCT OXXXXXQ6456 (Continued) Checks in serial order Date Check# Amount Date Checkik Amount 10 /08 2213 334.65 10/22 2226 700.01 10/07 2214 265.66 10/23 2227 7,834.26 10/07 2215 5,884.33 10/21 2228 76.52 10 /11 2216 629.28 1.0/28 2229 579.60 10/10 2217 13,524.00 10/25 2230 145.59 10/16 2218 171.85 10/29 2231 56.89 10/17 2219 8.96 10/28 2233* 277.50 10/15 2220 33.18 10/28 2234 3.92 10/18 2221 51.91 10/28 2235 312.45 10/21 2222 579.60 10/28 2237* 221.57 10/25 2223 262.50 10/29 2238 411.86 10 /18 2224 4.99 10/25 2239 102.57 10/22 2225 185.06 * Indicates skip in check numbers *** wwwwwwwwwwxwwwwwwwwwwwwxwxw: rww* wwwwwwwwwwwwwwwwwwwwww wwwwwwwwwwwwwwwwwwww *w Daily Balance section Date Balance Date Balance Date Balance 10/01 47,722.89 10 /10 55,293.03 10/22 53,170.67 10/02 47,022.88 10 /11 - 54,663.75 10/23 45,336.41 10/03 46,903.91 10/15 54,630.57 10/25 44,825.75 10/04 46,834.91 10/16 54,458.72 10/28 43,430.71 10/07 67,357.91 10/17 54,449.76 10/29 42,961.96 10 /08 67,008.03 10 /18 54,711.86 10/09 66,873.03 10/21 54,055.74 * * * E N D O F S T A T E M E N T Payment Summary bank- 165opr AND mm /yy= 10/2013 - 10/2013 AND All Checks -Yes AND Include Volds =All Checks Check Post Total Date Bank Check# Vendor Date Month Am_ ount Reconclled _'165opr-Parkviev Villa North's 2208 Cent - CenterPOln[ Energy � � _ _ 10/01/2013 10/2013 _ 4R1.36 10/31/2013 ]65apr - Parkvlew Villa North 2209 chc - CommonBOnd Housing 1001/2013 10/2013 56.23 10/31/2013 165opr - Parkview Villa North 2210 dral7740 - Draln King, Inc, 10/01/2013 10/2013 135 10/31/2013 165opr- Parkview Villa North -2211 frat - Frattalone's /Metro Ace 10/01/2013 10/2013 IS.23 10/31/2013 165opr - Parkvlew Villa North 2212 mndpl - I-IN Dept of labor & Industry 10/01/2013 10/2013 69 10/31/2013 165opr - Parkvlew Villa North 2213 sitz - Sitzma rn Construction dba Sltzmano Elect 10/01/2013 10/2013 334.65 10/31/2013 165opr- Parkvlew Villa North 2214 Iran - Trans -Alarm Inc - 10/01/2013 10/2013 265.66 10/31/2013 165opr - Parkvlew Villa North 2215 xcel - Keel Energy 10/01/2013 1012013 5,884.33 10/31/2013 165opr - Parkvlew Villa North 2216 bound - OMM Inc 10/08/2013 10/2013 629.20 10/31/2013 165apr - Parkvlew Villa North 2217 chc - Conlm ummul Housing 10/08/2013 10/2013 13,524,00 10/31/2013 165apr - Parkvlew Villa North 2218 dire - Direct Home Appliance Services 10/08/2013 10/2013 171.85 10/31/2013 165opr - Parkvlew Villa North 2219 fiat - Frattaknuys /Metro Ace 10/08/2013 10/2013 8.96 - 10/31/2013 165opr - Parkvlew Villa North 2220 home? - HD Supply Facilities Maintenance, Ltd. 10/08/2013 10/2013 33.18 10/31/2013 165opr - Parkvlew Villa North 2221 adam - Adam's Pest Control, Inc. 10/15/2013 10/2013 51.91 10/31/2013 365opr - Parkvlaw Villa North 2222 aerotek - Aerotek Professional services 10/15/2013 10/2013 579.6 10/31/2013 1650pr - Parkvlew Villa North 2223 alim2138 - All Pietro Lawn & Sway, LLC 10/15/2013 10/2013 262.5 10/31/2013 165apr - Parkview Villa North 2224 city4054 - City Wide Locksmlthln0, Inc, 10/15/2013 1012013 4.99 10/31/2013 165opr - Parkvlew Villa North 2225 frld4908 - Fridley Snowplowing and Removal 10/15/2013 1012013 185.06 10/31/2013 165opr- Parkview Villa North 2226 kone - Kane Inc. 10/15/2013 10/2013 709.01 10/31/2013 165apr • Parkvlew Villa North 2227 Ibpm - LOP Mechanical, Inc 10/15/2013 10/2013 7,834,26 10/31/2013 !65apr - Parkvlew Villa North 2226 leve - Level One 10/15/2013 10/2013 76.52 10/31/2013 165opr - Parkview Villa North 2229 aerotek- Aerotek Professlonal Services 10/22/2013 10/2013 579.6 10/31/2013 365opr - Parkvlevr Villa North 2230 chc - CommonBond Housing 10/22/2013 10/2013 145.59 10/31/2013 165opr - Parkvlew VI11a North 2231 comc3474 - Comcast 10122/2013 10/2013 56.89 10/31/2013 165opr - Parkvlew Villa North 2232 dire - Direct Home Appliance Services 10122/2013 10/2013 61.41 165opr- Parkvlew Villa North 2233 dra17140 - Drain King, Inc. 10122/2013 10/2013 277.5 10/31/2013 165opr- Parkvlew Villa North 2234 frat - Frattaioae's /Metro Ace 10/22/2013 1012013 3.92 10/31/2013 1650pr - Parkview Villa North 2235 home7 - HD Supply Facilities Maintenance, Ltd. 10/2212013 10/2013 312.45 10/31/2013 1650pr - Parkvlew Villa North 2236 kocl - K.O. Cleaning and Restoration LLC 10/22/2013 10/2013 1,950.00 1650pr- Parkviev Villa North 2237 Popp - Popp•com 10/22/2013 10/2013 221.57 10/31/2013 165opr- Parkvlew Villa North 2238 sher4310- Sherwin- Vrilllams Co. 10/22/2013 10/2013 411.86 10/31/2013 16Sopr - Parkvlevr Villa North 2239 t0005163 - Holmberg 10/22/2013 10/2013 102.57 10/31/2013 165opr - Parkvlew Villa North 2240 aerotek - Aeratek Professional Services 10129/2013 10/2013 463.60 165opr- Parkview Villa North 2241 home7 - HD Supply Facilities Maintenance, Ltd. 10129/2013 10/2013 605,14 365opr - Parkvlew Villa North 2242 mndai - Minnesota Depart of Labor & Industry 10/29/2013 10/2013 69 165opr - Parkview Villa North 2243 mood! - MIN Dept of Labor & Industry 10/29/2013 10/2013 34.5 165opr- Parkview( Villa North 2244 xcel - Xcel Energy 10/29/2013 10/2013 4,982.32 41,581.38 4860 -46330 Interest on Deposits 125.63 = Beginning Balance = 165 10/31/2013 Sec Dep interest accrual 3- 177625 G31 13.57 0.00 139.20 Sec Dep interest accrual Net Change =13.57 139.20 = Ending Balance = 5120 -46330 Building @ Improvements 1,839.76 = Beginning Balance = Net Change =0.00 1,839.76 = Ending Balance = 54,645.01 8,862.90 72Ttr4TpMW I K Parkview Villa North Financial Statement Overview November 2013 Revenue: Occupancy for the month of November 2013 was 95% occupied; Rent Revenue was over budget (favorable) Total Revenue for November was over budget (favorable) due to grant income drawn down Administrative Expenses: Administrative costs for the North were over budget (unfavorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Legal Services was over budget (unfavorable) and reflects cost of attorney services Misc. Admin Expenses 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 under budget (favorable) Gas was under budget (favorable) Water was under budget (favorable) 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 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 under budget (favorable) Heating, Cooling Maintenance and Repairs was under budget (favorable) Decorating Contract was over budget (unfavorable) and reflects the cost of the paint and supplies for the hallways P P V1 4 PP A A P W W W P P N P W N N O P O P N O b N In N b b �O b b P N A N N N N (n N r O N N O O VWI Y N A N L A W W W W o b bN o o M V % N O b J VI yOj P w N r o o yOj N V o J o O O o o A r O o O N Y O b W J V O O N d �' 6T' N ry T r' u D 3 m N c b O j N C ➢n m O on- 6 d F n m F d? s m R vi < r 7 rt x a'o0° m v A P N P N W O r W Y V W Y J M W A N W W pN N N ywj r O VI O O O O O .O O W O. O A N N N O O m m N O O W O O O O a 0 0 0 0 0 O O 0 0 W O N O N O V O O O 0 O P O O W O VJI O 0 O O Y Y N r N N P U r NO q O A V N N r U Y Y W d Ubl N tO O W W IAi� N W VI O V W O J O O O Y VI O P W V N O m W W W W W W O P W W W O A r WA r b W Y Y r AW bW N J N r W b O W N �p b W N N O O P A W IOn O N J W N J W .P O UAI W m v m .ro P P V V W W N O O A W t` W A W 'D O W INII A V O W O r O 0 O W O O O O N P O O W N N r N N O A O A r 2 P b pi m W O O b O b O w w D A O W O W O O V N W b N"➢ O O N W W �' N W b aD O W O b W O O yW Y W W ybj A N N m N N N W O O A P N V J O VI A NO N b m N J A N O T N J O uWl N A m N A O T V V O V VP1 q q .P P P O W O . O N W O A 0 0 V V V O W O N O O O O t0 N N N N W W W N N W p r N r A N r N O� V N N W In � VI VI N r A V J T A V V N W O N O P P :A p V P O O lbn A A O W N VJI V O P W O 0 N M PA m r O W N N 0 ✓- VI 0 .W V Y q J P P W W P O N J O W O Y 0 u N N V P A A A V1 V1 r W O P W ~ W Y A N Y N O W O N N V W V W b W. O VI b N O W 0.1 V U N V N b O N A N% N V N N y W WN NW Vbl J 40 u m N �D J N W .1 v m m N o J P A O P b W 'r P O O V A w lY V V w O V o O� N P M `O W r W W O VI O W�� 2 y N A O J W� N O W W J b V W W J A O W O 0 P W m D N A V O O V P f0 D Y P N W W N w V N W m b W m A N N A r P r In O W W W N V N b A A o N o O A o N o A W O m P o m VAI O o N H o O O O :A O VI O O O o o o O O O o m O D O O O' 0 O O O O O O O O O O O a o O O O O O O O O O O O 0 O o C O y a O a _ d N ^ O' ] N W 3 b e e m V V J N v r V V m m m m m m P m b O 1mIp D b m D N N V O O O N N O N g m m O b w W b O W O M m b O W P +o N N m O m m bm m r m m N m m m m . m N . m v m m m .m . m o m p O W � 2 a 9 c � n n i w 4 2 V y ] O y y V P y % • m x h F° ry w c 01 N Vim'° m n 0= R a s o a o N a ele ce': �IW b10. N WIW OIV w A m r p N m A J. ffw: W sit J w A q Q r r m W V P N mle W W W 10 � C Y ie. °O 2188 i W O O N O N b P I E F WO A J O m T W P N O N W O V V W O O O J V V A r pI r y J W O O b A N W N Im/I O N r A A J W% N lVn W V N W O O O V V V O lmn O O A O VI W O O O A W Z z r . A 1, 18 G . A r m O m b V O O O V r� lWl1 O J W V J A O r N O O N Oi O O T A O N W A N A b A N N A A W J A b P M M r O b N W P O W O N VNI O V V W O O O J J J N A P A N A A V O b N N A b b O V r b W N b N VNI W b w w N N o W V W N A r O A W A W J O O W VI V Z O i+ 10 W r mP W% O V W A N➢ W O V A VI w A r W A N 01 W O m N O W O O O r J VI O VNI O O N O O O O O O 0 0 °o °o °0 0 0 0 0 0 0 0 °o °o W aF � b < n 3 y u G u 3 O W V V V 01 ro W m � m m W nNi P y1 w W W W W W � M P b N V pWVI o N W W W W w v � r V O O O O p O N O O O O W W V p A I+ yAI N W W W ymj p1 N li O N Ip w A O O O T N V V q A p N V 10 N O V W r V M Y P q W W W W W w N W W W N W P � o tA0 V V V J ele ce': �IW b10. N WIW OIV w A m r p N m A J. ffw: W sit J w A q Q r r m W V P N mle W W W 10 � C Y ie. °O 2188 i W O O N O N b P I E F WO A J O m T W P N O N W O V V W O O O J V V A r pI r y J W O O b A N W N Im/I O N r A A J W% N lVn W V N W O O O V V V O lmn O O A O VI W O O O A W Z z r . A 1, 18 G . A r m O m b V O O O V r� lWl1 O J W V J A O r N O O N Oi O O T A O N W A N A b A N N A A W J A b P M M r O b N W P O W O N VNI O V V W O O O J J J N A P A N A A V O b N N A b b O V r b W N b N VNI W b w w N N o W V W N A r O A W A W J O O W VI V Z O i+ 10 W r mP W% O V W A N➢ W O V A VI w A r W A N 01 W O m N O W O O O r J VI O VNI O O N O O O O O O 0 0 °o °o °0 0 0 0 0 0 0 0 °o °o W aF � b < n 3 y u G u 3 9 1 y„ O c m � COO z (D N n a m m N ONi A W W A N W W W �rnw O W t0 N w,p w A W (O P w a d o n W O 0 w r C C) c m 1D '4 0 N � N 90 3' C i n C, O' 7 a d V N W t0 W N D n d_ N N (T O> +a W C 0 �N V ow W d m wmw CO (J J {�i �a 0 xQxm tY a 'm N O ^It n N O O O pOj O N N C 3 'x j 'O m O W .�. w z 0 Qo Cl) Parkview villa -North (165) Balance Sheet November 2013 Books = Accrual ssets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance Total ssets la ilities 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total la ilities un alance 25300 Fund Balance Total un alance Total is ilities an un alance ov 13 70,342.91 871.00 891,214.11 4,590.45 279.12 1,424.58 968,722.17 28,273.47 551.74 17,941.41 22,298.64 2,829.12 71,894.38 896,827.79 896,827.79 968,722.17 1/13/20141:42 PM Parkview, Villa -North (165) Income Statement For The Period Ending November 2013 Books = Accrual Supplies 2000 -46330 Office Supplies Month to Date % Year to Date % Revenue 0.00 0.00% 1,808.21 0.41% 33160 -46330 Federal Grant 30,383.00 48.76% 98,346.41 22.56% 36220 -46330 Gen. Government Rents 31,090.00 49.89% 326,557.00 74.90% 36225 -46330 Nondwelling Rents 330.00 0.53% 4,290.00 0.98% 36290 -46330 Other Miscellaneous Revenue 513.00 0.82% 6,667.86 1.53% 39120.46330 Recovery Damage City Property - 0.00% 130.00 0.03% Total Revenue 62,316.00 100.000/0 435,991.27 100.000/0 Expenses 4,772.00 7.66% 52,492.00 12.04% personal Services 0.00 0.00% 4,131.42 0.95% 1000 -46330 Accrued Salaries 8,752.00 14.04% 96,272.00 22.08% Total personal Services 8,752.00 14.04070 96,272.00 22.08070 Supplies 2000 -46330 Office Supplies 86.38 0.14% 1,517.09 0.35% 2010 -46330 Minor Equipment 0.00 0.00% 1,808.21 0.41% 2160 -46330 Maint.& Construct Materials 296.70 0.48% 5,235.24 1.20% 2171 -46330 General Supplies 5,006.08 8.03% 6,652.41 1.53% Total Supplies 5,389.16 8.65% 15,212.95 Other Services & Charges 3040 -46330 Legal Fees 5,044.06 8.09% 8,785.01 2.01% 3050 -46330 Expert and Professional Services 0.00 0.00% 13,244.00 3.04% 3060 -46330 Management Services 4,772.00 7.66% 52,492.00 12.04% 3100 -46330 Protective Services 0.00 0.00% 4,131.42 0.95% 3210 -46330 Telephone & Telegraph 355.78 0.57% 3,877.79 0.89% 3430 -46330 Advertising Other 0.00 0.00% 65.00 0.01% 3600 -46330 Insurance & Bonds 1,424.58 2.29% 15,745.81 3.61% 3810 -46330 Electric 3,630.39 5.83% 44,427.26 10.19% 3820 -46330 Water 0.00 0.00% 8,095.84 1.86% 3830 -46330 Gas 3,120.49 5.01% 28,962.73 6.64% 3840 -46330 Refuse 0.00 0.00% 11,344.08 2.60% 3850 -46330 Sewer 0.00 0.00% 3,725.37 0.85% 4000-46330 Repair & Maint. Services 403.44 0.65% 62,804.93 14.41% 4100 -46330 Rents & Leases 86.75 0.14% 797.04 0.18% 4300 -46330 Miscellaneous Charges 7.23 0.01% 83.33 0.020/0 4315 -46330 PILOT 2,027.14 3.25% 22,843.80 5.24% 4390 -46330 Taxes & Licenses 0.00 0.00% 1,446.88 0.33% 4500 -46330 Administrative Expenses 0.00 0.00% 1,205.84 0.28% 4850 -46330 Interest on Deposits 13.10 0.02% 15230 0.03% Total Other Services & Charges 20,884.96 33.51070 284,230.43 65.190/a Page 1 of 2 1113/2014 1:42 PM Capital Outlay 5120 -46330 Building & Improvements 0.00 0.00% 1,839.76 0.42% Total Capital Outlay 0.00 0.000/0 1,839.76 0.420% Total Expense 35,026.12 56.21% 397,555.14 91.18% Excess (Deficit) Revenue over Expense 27,289.88 43.79% 38,436.13 8.82% Page 2 of 2 Pat kview Villa-North (1.65) Cash to State ent Perlcd = November 2013 Book = Accnaal Revenue 33160 Federal Grant 36220 Gen. Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Expenses Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services & Charges Total Expenses Excess (Deficit) Revenue over Expenses Page 4 of 1/13/201412: 2 PM Month to Date 30,383.00 31,090.00 330.00 513.00 0.00 62,316.00 8,752.00 8,752.00 86.38 0.00 296.70 5,006.08 0.00 5,389.16 5,044.06 0.00 4,772.00 0.00 355.78 0.00 1,424.58 3,630.39 0.00 3,120.49 0.00 0.00 403.44 0.00 86.75 7.23 2,027.14 0.00 0.00 13.10 0.00 20,884.96 35,026.12 27,289.88 Parkview Villa -Noith (165) Cash to State ent Period = November 2013 Book_ Accmal ust ants 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government nits 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Total ust ents Cash to 10100 Cash alance 10200 Petty Cash 10400 nvest ants Total Cash 1/13/2014 12: 2 PM Month to Date 0.00 0.00 - 1,540.25 184.00 0.00 1,424.58 6,637,03 0.00 - 232.38 2,027.14 - 243.00 8,257.12 35,547.00 eg Cash En Cash Difference 34,795.91 70,342.91 35,547.00 871.00 871.00 891, 214.11 891, 214.11 926,881.02 962,428.02 35,547.00 Page of Parkview Villa -North (165) General Ledger pencil Nov 2013 Pr9pgrhLate Cegtsoi_ . Reference ,: „ , `UehR .. Credit - _ - ;Balance genlarks, 1000 -46330 Accrued Salaries 85,897.12 Beginning Balance = 165 11/30/2013 :PostRecurring Monthly recurring entry 3- 180492 RC 8,752.00 0.00 94,649.12 R/C CHC PR Mgmt Fee Net Change = 8,752.00 94,649.12 = Ending Balance = 2000 -46330 Office Supplies 1,430.71 = Beginning Balance = 165 10/29/2013 Office Depot(offi8804) P- 356667 680544659001 7.51 0.00 1,438.22 canister /envelope /notebook 165 10129/2013 Office Depot (of08804) P- 356673 680544658001 3.67 0.00 1,441.89 creamer 165 1012912013 Office Depot(offi88(M) P- 356674 680544657001 6.63 0.00 1,448.52 pens 165 10/29/2013 Office Depot(offi8804) P- 356675 680544511001 23.58 0.00 1,472,10 calendars 165 11/12/2013 Office DepOt(Offi8804) P- 358880 682830462001 44.99 0.00 1,517.09 paper /pen /binders Net Change =86.38 1,517.09 = Ending Balance = 2010 -46330 Minor Equipment 1,808.21= Beginning Balance= Net Change =0.00 1,808.21 = Ending Balance = 2160 -46330 Maint. & Construct Materials 4,938.54 = Beginning Balance = 165 10/30/2013 HD Supply Facilities Maintenance, Ltd. (home: P- 356292 9125864140 32.23 0.00 4,970.77 drk roller shade 165 10/30/2013 HD Supply Facilities Maintenance, Ltd, (home: P- 356292 9125864140 41.26 0.00 5,012.03 shwr dvrtr hdl /assy;washer 165 10/3012013 Home Depot Credit Services (home9055) P- 357705 1593774 46.43 0.00 5,058.46 various malnt supp 165 11/11/2013 Park Supply of America, Inc.(parkl) P- 358604 57887200 60.16 0.00 5,118.62 reversible backspiach 165 11/12/2013 Fraltalone's /Metro Ace (frat) P- 358061 016878R 12.73 0100 5,131.35 cm sckttollet blRelm;wax 165 11/1512013 HD Supply Facilities Maintenance, Ltd. (home: P- 358859 9126214343 103.89 0.00 5,235.24 mrmct/tape /wx rng /tilts /ho Net Change = 296.70 5,235.24 = Ending Balance = 2171 -46330 General Supplies 11646.33 = Beginning Balance = 165 10/29/2013 HD Supply Facilities Maintenance, Ltd. (home: P- 356263 9125834851 174.79 0100 1,821.12 kieenex;bath tissue;toweis; 165 L3 /1/2013 Buckeye Cleaning Centers (buck8411) P- 358648 776669 90.91 0.00 1,912.03 tollet paperpaper towels 165 11/1312013 Sherwin - Williams Co.(cher4110) P- 358191 31627 4,740.38 0.00 6,652.41 paint& painting supplies Net Change= 5,006.08 6,652.41 = Ending Balance = 3040 -46330 Legal Fees 3,740.95 = Beginning Balance = 165 11/15/2013 Kennedy & Graven, Chartered (keno) P- 359127 103113165 5,044.06 0.00 8,785.01 legal srv. through 1.0 /31/1 Net Change = 5,044.06 8,785.01 = Ending Balance = 3060 -46330 Management Services 47,720.00 = Beginning Balance = 165 11/25/2013 CommanBand Housing (chc) P- 359414 112513mgmt (11 13,524.00 0.00 61,244.00 mgmt fee 11/13 165 1113012013 :PostRecurring Monthly recurring entry 3- 180492 RC 0.00 8,752.00 52,492.00 R/C CHIC PR Mgmt Fee Net Change = 4,772.00 52,492.00 = Ending Balance = 3100.46330 protective Services 4,131.42 = Beginning Balance = Net Change =0.00 4,131.42 = Ending Balance = 3210 -46330 Telephone & Telegraph 3,522.01 = Beginning Balance = 165 10/31/2013 Popp.com (Popp) P- 357700 992143693 222.37 0.00 3,744.38 phone- 11 /01. 11/30/13 165 11/1/2013 Level One (love) P- 356321 0365507IN 76.52 0100 3,820.90 phone -11/13 165 11/2/2013 Comcest(comc3474) P- 357670 8772105050196. 56.89 0.00 3,877.79 net- 11/11- 12/10/13 Net Change= 355.78 3,877.79 = Ending Balance = 3430 -46330 Advertising Other 65.00 = Beginning Balance = Net Change =0.00 65.00 = Ending Balance = 3600 -46330 Insurance & Bonds 14,321.23 = Beginning Balance = 165 11/30/2013 :PostRecurring Monthly recurring entry 3- 180492 RC 1,424.58 0100 15,745.81 C of Columbia Heights ins 4 Net Change= 1,424.58 15,745.81 = Ending Balance = 3810 -46330 Electric 40,796.87 = Beginning Balance = 165 11/11/2013 Xcel Energy(xcel) P- 358761 5150441553 11/ 3,630.39 0.00 44,427.26 E- 10/05- 11/02/13 Net Change= 3,630.39 44,427.26 = Ending Balance = 3820 -46330 Water 8,095.84 = Beginning Balance = Net Change =0.00 8,095.84 = Ending Balance = 3830 -46330 Gas 25,842.24 = Beginning Balance = 165 1116/2013 CenterPolnt Energy (cent) P- 357850 55199657 11 /06 3,112.81 0.00 28,955.05 G- 10/03- 11/04/13 165 11/6/2013 CenterPolnt Energy (cent) P- 357850 55199657 11/06 7.68 0100 28,962.73 late fee Net Change = 3,120.49 28,962.73 = Ending Balance = 3840 -46330 Refuse 11,344.08 = Beginning Balance - Net Change =0.00 11,344.08 = Ending Balance = 3850 -46330 Sewer 3,725.37 = Beginning Balance = Net Change=0.00 3,725.37 - Ending Balance = 4000 -46330 Repair& Maint. Services 62,401.49 = Beginning Balance = 165 10/21/2013 Adam's Pest Control, Inc. (adam) P- 356002 836905 51.91 0.00 62,453.40 exterm serv- 10/21/13 165 11/1/2013 Fridley Snowplowing and Removal (fdd4908) P- 358849 22991 85.70 0.00 62,539.10 Irrig repair & winterization 165 11/1/2013 Cummins NPower LLC R- 1019179 383371 0.00 469.25 62,069.85 Overpayment of Invoice 101 165 11/1/2013 Kone Inc.(kone) P- 358217 221316176 700.01 0.00 62,769.86 elev maint- 11/01- 11/30/13 165 10/30/2013 HD Supply FacllRles Maintenance, Ltd. (home: P- 356292 9125864140 35.07 0.00 62,804.93 lacuna melt Net Change = 403.44 62,804.93 = Ending Balance = 4100 -46330 Rents & Leases 710.29 = Beginning Balance = 165 10/31/2013 Multihousing Credit Control (multl) P- 357626 13100388 80.00 0.00 790.29 screen sere -10/13 165 11/11/2013 Talx the Work Number (taix) P- 357908 1454054SItes 6.75 0.00 797.04 empty verify 10/13 Net Change =86.75 797.04 = Ending Balance = 4300 -46330 Miscellaneous Charges 76.10 = Beginning Balance = 165 11/15/2013 City Wide Locksmlthing, Inc. (ciW4054) P- 358881 1935 7.23 0100 63.33 single key cut Net Change =7.23 83.33 = Ending Balance = 4315 -46330 PILOT 20,816.66 = Beginning Balance = 165 11/30/2013 :PostRecurnng Monthly recurring entry 3- 180492 RC 2,027.14 0.00 22,843.80 Anoka Cry Property Tax Au Net Change = 2,027.14 22,843.80 = Ending Balance = 4390 -46330 Taxes & Licenses 1,446.88 = Beginning Balance = Net Change =0.00 1,446.88 = Ending Balance = 4500 -46330 Administrative Expenses 1,205.84 = Beginning Balance = Net Change =0.00 1,205.84 = Ending Balance = 4850 -46330 Interest on Deposits 139.20 = Beginning Balance = 165 11/3012013 Sec Dep interest accrual ]- 179755 G11 13.10 0.00 152.30 Sec Dep interest accrual Net Change =13.10 152.30 = Ending Balance = 5120 -46330 Building &Improvement 1,839.76 = Beginning Balance = Net Change =0.00 1,839.76 = Ending Balance = 44.247.37 9.221.25 Parkview Villa North Bank Reconciliation Report 1.1130/2013 6016458' Balance Per Bank Statement as of 11/3012013 Reconciled Bank Balance Balance per OL as of 11130/2013 Reconcllod Balance Per G/L Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items t Cleared Checks 70,342.91 70,342.91 12102/2013 70,342.91 70,342.91 0,00 Dale Tran S Notes Amount Date Cloarod 10/2212013 2232 dire - Direct Home Appliance Services - 61.41 1113012013 10122/2013 2236 kocl - K.O. Cleaning and Restoration 110 1,950.00 11/30/2013 10/2912013 2240 aerotek - AerotekProfessionalServices 463.68 11/30/2013 1012912013 2241 homo7 - HD Supply Facillllos Maintenance, Ltd. 605.14 11/30/2013 10/29/2013 2242 mndol - Minnesota Depart of Labor & Industry 09.00 1 V30/2013 10/29/2013 2243 mndpl - MN Dept of Labor & industry 34.50 ' 11/30/2013 10129/2013 2244 xcol - Xcol Energy 4,982.32 1-1/3012013 11/05/2013 2246 adam- Adam's Post Control, Ina. 51.91 11/3012013 1110512013 2246 cent- CenterPotnt Energy 611.96 11/3012013 11/05/2013 2247 chc - CommomflondHousing 13,624.00 11/30/2013 11/06/2013 2248 role - City of Columbia Heights 7,427.78 11/3012013 11/0512013 2249 greo1004 -Green Lights Recycling Inc 231.72 11/3012013 11!0512013 2250 of88804 -Office Depot 46.83 11/30/2013 11/0512013 2261 lola321 - Total life Security LLC 828.29 11/3012013 1-1/1212013 2252 love - Level One 76,62 11/30/2013 11/1912013 2263 - aerotek - Aerotek Professional Services 1,246.14 11130/2013 1111912013 2264 (rat - Frallalone's/Metro Ace - 12.73 11130/2013 11/19/2013 2266 home? -HD Supply Facilities Maintenance, Ltd. 130.74 11/30/2013 11/1912013 2256 ,kone - KoneInc. 700.01 11130/2013 11/19/2013 2267 mull / - Multihousing Credit Control 60.00 11/30/2013 11/19/2013 ' 2258 else - Olsen Fire Protection, Inc. 759.00 11130/2013 11/19/2013 2269 Popp • Popp.com 222.37 11/30/2013 Total Cleared Checks 33,815.05 Cleared Deposits Dale Tran4 00/1212013 632 11/01 /2013 629 11/06/2013 528 11106/2013 628 11/00/2013 • 530 N/1312M 631 11/14/2013 637 11/1612013 638 11/18/2013 633 11/18/2013 634 11 /18/2013 635 Total Cleared Deposits Cleared Other Items Data Tran B 11/04/2013 JE 179352 11/1212013 RC 1026046 Total Cleared Other Items Parkview Villa North Bank Reconciiiation Report 1113012013 5016466 Notes 12/0212013 Amount Data Cleared 700.00 11130/2613 469.26 11/30/2013 300.10 1113012013 25,674.76 11/3012013 2,187.00 11/30/2013 320.90 i1/3012013 282.00 11/3012013 561.00 11!3012013 146.00 11/30/2013 89.00 11/30/2013 244.00 11/30/2013 30,973,00 Notes Amount Date Cleared ELoccs Operating Fund receipt 30,383.00 11130/2013 Returned Item L0009650 •160.00 11/30/2013 30,223,00 HRA OF COLU61BIA HEIGHTS PARKVIE91 VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 -- C H E C K I N G Date 11/29/13 Page 1 Primary Account @XXXXX @6456 Enclosures 3,? ACCOUNTS - - - - NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S WEB BROWSER OR OUR MOBILE.BANKING APPI YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOOGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS. ACCT Account Number @XXXXX @6456 Previous Balance 42,961.96 11 Deposits /Credits 61,365.90 24 Checks /Debits 33,964.95 Electronic Debit 100 Service Charge .00 Interest Paid .00 Ending Balance 70,342.91 Number of Images 32 Statement Dates 11/01/13 thru 11/30/13 Days in the Statement Period 30 Average Ledger. 74,999 Average Collected 73,948 Deposits and Credits Date Description 11/04 MISC PAY HUD TREAS 310 9101036151 ' 11/04/13 ID 11- 411269646860103 TRACE 11-101036150318441 DDA REGULAR DEPOSIT .11106 11/06 DDA REGULAR DEPOSIT 11/07 DDA REGULAR DEPOSIT 11/14 DDA REGULAR DEPOSIT. . 11/15 Xfer from PUB FUND 0002 Correct rent deposit. -Lars 11/15 DDA REGULAR DEPOSIT 11/15 DDA REGULAR DEPOSIT 11/19 DDA REGULAR DEPOSIT 11/19 DDA REGULAR DEPOSIT 11/19 DDA REGULAR DEPOSIT Amount 30,383.00 CR 469.25 25,984.75 2,187.00 320.90 700.00 282.00 561.00 89.00 145,00 244.00 Charges and Debits Date Description Amount 11/06 DDA DEBIT MEMO 9.90 DR Date 11/29/13 Page 2 Primary Account OXXXXX ©6456 Enclosures 3,2 NORTHEAST PUBLIC FUNDS ACCT ©XXXXXO6456 (Continued) Charges and Debits Date Description amount 11/12 RETURN ITEM DEBIT 160.00 ********* k* xx* x******* xx******** x**** x** x** xx** * * +tx *x *x * *xx * * * * * ** * * * * * * * * *x* Checks in serial order Date Check$ Amount Date Checks{ Amount 11/06 2232 61.41 17./7.9 2249 231.72 11/13 2236* 1,950.00 11/20 2250 45.83 11/04 2240* 463.68 11/15 2251 628.29 11/04 2.241 605.14 11/19 2252 76.52 11/01 2242 69.00 11/1.5 2253 1,246.14 11 /O1 2243 34.50 11/25 2254 12.73 11/04 2244 4,982,32 11/26 2255 130.74 11/18 2245 51.91 11/26 2256 700.01 11/18 2246 511,96 11/26 2257 80.00 11/13 2247 13,524.00 11/25 2258 759.00 11/15 2246 7,427.78 11/22 2259 222.37 * Indicates skip in check numbers Daily Balance Section - Date Balance Date - Balance Date Balance 11 /01, 42,858.46 11/13 80,126.01 11/20 73,493 ;90 11/04 67,190.32 11/14 80,446.91 11/22 73,271.53 11/06 93,573.01 11/15 73,933.84 11/25 71,253.66 11/07 95,760.01 11/18 73,369.97 11/26 70,342.91 11/12 95,600.01 13,/19 73,539.73 * ** E N D O F S T A T E M E N T Payment Summary Bank - l65opr AND mm /yy =I1 /2013- 11/2013 AND All Checks =Yes AND Include Voids -All Checks 25,649.00 Check post Total Bank Check# Vendor Pate Month Amount 165opr - Parkview Villa North 2245 adam - Adam's Pest Control, Inc. d 11/05/20131/05/2013 11/2013 51.91 165opr - Parkvlew Villa North 2246 cent - CenterPolnt Energy 11/0512013 11/2013 511.96 165opr - Parkview Villa North 2247 chc - CommonBond Housing 11/05/2013 11/2013 13,524.00 165opr - Parkview Villa North 2248 colu - City of Columbia Heights 11105/2013 11/2013 7,427.78 165opr - Parkvlew Villa North 2249 gree1004 - Green Lights Recycling Inc 11/05/2013 11/2013 231.72 165opr - Parkvlew Villa North 2250 ofn8804 - Office Depot 11/05/2013 11/2013 45.83 165opr - Parkvlew Villa North 2251 tota321 -Total Life Security LLC 11/05/2013 11/2013 628.29 165opr - Parkvlew Villa Nardi 2252 [eve - Level One 11/12/2013 11/2013 76.52 165opr - Parkview Villa North 2253 aerotek - Aerotek Professional Services 11/19/2013 1112013 1,246.14 l65opr - Parkvlew Villa North 2254 Prat - Frattalone's /Metro Ace 11/19/2013 11/2013 12.73 165opr- Parkview Villa North 2255 home7 - HD Supply Facilities Maintenance, Ltd. 11/19/2013 11/2013 130.74 165opr- Parkvlew Villa North 2256 kone - Kone Inc. 11/19/2013 11/2013 700.01 165opr - Parkvlew Ville North 2257 multi - Multihousing Credit Control 11/19/2013 11/2013 80.00 165opr - Parkvlewi Villa North 2258 else - Olsen Fire Protection, Inc. 11/19/2013 11/2013 759.00 165opr - Parkvlew Villa North 2259 Popp - PopP•com 11/19/2013 11/2013 222.37 25,649.00 UP ff RM W 171?M's I I I Gr4 Parkview Villa North Financial Statement Overview December 2013 Revenue: Occupancy for the month of December 2013 was 95% occupied; Rent Revenue was under budget (unfavorable) Total Revenue for December was over budget (favorable), and reflects grant income drawn down 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 under budget (favorable) Legal Services was under budget (favorable) Misc. Admin Expenses was over budget, (unfavorable) and reflects petty cash reconciliation Utilities: Utilities Expenses were under budget (favorable) Fuel Oil was under budget (favorable) Electric was slightly over budget (unfavorable) and reflects November billing Gas was over budget (unfavorable) and reflects November billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and also reflects quarterly billing OperatinE 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 Security Contract is under budget (favorable). Grounds Contract was over budget (unfavorable) and reflects billing from November clean up Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs is over budget (unfavorable) and reflects the cost of boiler repairs Snow Removal Contract was under budget (favorable) Decorating Contract was under budget (favorable) N N P N pp�� Q� N N N T W N W N N P P 01 OI OI N N VI VI VI W N N N N W Y N N N VI N A N N A A A A W W W P W W N O O O b b '4 b b N b A N r O O O v vi y°j P w N r o O y°j N V o. o N A 0 o r O Op O b b b J m O O b b N O O O O O O O A r o O N O b W O i0 0 V O p p q V O O N p o p H 4 N a H A Amm "" d � N b a n� a 3 n -1 ➢ 3 n� N O W➢ a � m � ^ O Z� .0 io n RR m:4 0010'. w�95 ^ m " < n m G V Y A W W w w w a V o r o VNI O w w o o N N O A N o 0 o W A W O o o 0 00 o N °o °o °o °O w o °o °o °O o o °o °° o °O o o °o ° °O Ip+ N O Y b N O M A H A W A W V N 01 N N O m b° m W VI b W W O O A Vi m N N VI N O V N IN/I O W r N w V w y m � � o O V W V O A O V A N mA O N N O P m w VA1 N b O O yo N U IVJ A J V A W O V O V O W W W J J O O O O O O N O m V• J O O r P 9, P W° N Z Z b o r o r O W A v D D O w o In o 0 0 0 (p r O N q N r m O O A A O O A V A . N A J b A A W W N O O P N O A 0 0 O W r O . b. N O N r V 0 O O O O A O O O O O O O O O O O O 0 0 0 0 0 0 0 0 >a mN W r�wr mrN J W r h p p� O r W g b b N O b O N O UWI O r N W N OI A A m W A O r O N A O OI O yAi w N pl y� b w A r 1+ J O o o b Z p b W 0 JN O O O O OI r `YWi W OI VI O W r °O IW/I O O b lOi1 O O A O °o °o °o °o Y w J O N W VI D O O O N VI A O V O W o r A VI J O N O O O O O N O W Imn A W n N o w A N °o °o °oo N b O m P A P O A O W C v 6 3 v9 ° b - u � H G 9 A b 0 m m O b W N V m O W m O W N N N V m o yOj q N o yOj N V P o A N O b m P VPI N m V m vWi V� o b E '^ K < _ m q F H a Rdmn 5 o Am ox a � m a a n i ? ml R� °_ a Vc I ^ o " a @ ow n 3 W a� - �o m m » 3 x x o X a N n w 5 R A - �' Q T W O Y P W 3 W W r N o W m W yoj b O q O O O O O W Y A A V O V � P O O O W J O IOn b O N O N W O N O O O O p W V 111 UI Y O W W O 00 O N J O A 00 P b N A O5 O O O O O P N W W A O A m N O O O O w J t• V O N O N �' R F b A P 0 V W V N O °o O O Y u U O N O O � � N b N W O W m m A o a m w W W v1 Y m N N G Y r W V N V N o. m N V m W Y N W N w Lm ~ W O W m m A o > O o O o 0 O V O W 1Vll � A N O O N O o w R " o m 'agora o O o o w N VI O w O m W l z z � O O O O O N INII O O ➢➢ O A O r p � y1 p W r N N N r w P N F+ m o N N A A V w OVi N O A% r V1 W A r W> VI N J N O O O lNll IN/I O O O° O O O T° M m O O b O w V m N O O O V N w A N N IPII W p r W A W m J m ' O w N VNI O O O O O O O O W O O 3 v: V v p W tA ,ONi W q O V g O p V p m W •WL N W NroA N m V M ZD � � N b N W O W m m A o a m w W W v1 Y m N N G Y r W V N V N o. m N V m W Y N W N w Lm ~ W O W m m A o > O o O o 0 O V O W 1Vll � A N O O N O o w R " o m 'agora o O o o w N VI O w O m W l z z � O O O O O N INII O O ➢➢ O A O r p � y1 p W r N N N r w P N F+ m o N N A A V w OVi N O A% r V1 W A r W> VI N J N O O O lNll IN/I O O O° O O O T° M m O O b O w V m N O O O V N w A N N IPII W p r W A W m J m ' O w N VNI O O O O O O O O W O O 3 Y V v p W W ,ONi W q O V g O p V p m W •WL N W NroA N m V M � � N b N W O W m m A o a m w W W v1 Y m N N G Y r W V N V N o. m N V m W Y N W N w Lm ~ W O W m m A o > O o O o 0 O V O W 1Vll � A N O O N O o w R " o m 'agora o O o o w N VI O w O m W l z z � O O O O O N INII O O ➢➢ O A O r p � y1 p W r N N N r w P N F+ m o N N A A V w OVi N O A% r V1 W A r W> VI N J N O O O lNll IN/I O O O° O O O T° M m O O b O w V m N O O O V N w A N N IPII W p r W A W m J m ' O w N VNI O O O O O O O O W O O 3 City of Columbia Heights HRA Expenditures for Fiscal Year 2013 - Parkvlew Villa North & South as of December, 2013 Account Object Code Classification Actual YTD Actual MTO Budget Balance 203.46330 Parkvlew Villa North Personnel Services 105,024 8,752 105,028 4 Supplies 16,145 933 21,550 5,405 Other Services & Charges 312,539 24,860 376,547 64,008 Capital Outlays 1 840 - 92,200 90,360 Totals 209 46330 476,648 34,544 595,326 159,777 213.46340 Parkvlew Villa South Personnel Services 47,164 3,932 47,186 2 Supplies 16,667 2,543 10,675 -5,992 Other Services & Charges 139,314 12,321 186,240 46,926 Parkview Villa -North (165) Balance Sheet December 2013 Books = Accrual Dec -13 Assets 10100 Cash Balance 80,194.19 10200 Petty Cash 457.00 10400 Investments 891,214.11 11300 Rent Receivable 3,207.39 11500 Accounts Receivable 304.12 13100 Due from Other Funds (CommonBond) 4,200.97 Total Assets 979,577.78 Liabilities 20200 Accounts Payable 481.60 20210 Accrued Other Expenses - 20220 Due to Resident Council 551.74 22000 Deposits 17,841.09 22200 Accrued PILOT 24,325.78 22210 Revenue Collected in Advance 3,546.12 Total Liabilities 46,746.33 Fund Balance 25300 Fund Balance 932,831.45 Total Fund Balance 932,831.45 Total Liabilities and Fund Balance 979,577.78 Expenses Personal Services 1000 -46330 Accrued Salaries 8,752.00 12.58% 105,024.00 20.77% Total Personal Services 8,752.00 12.58% 105,024.00 20.77% Supplies -46330 Legal Fees 0.00 0.00% 1/13120141:38 PM Parkview, Villa -North (165) 244.23 0,35% 1,761.32 0.35% Income Statement 0.00 0.00% 1,808.21 0,36% For The Period Ending December 2013 532.67 0.77% 5,767.91 1.14% Books = Accrual 12.83 0.02% 6,665.24 1.32% Total Supplies Month to Date % Year to Date o/o Revenue -46330 Advertising Other 0.00 0.00% 65.00 33160 -46330 Federal Grant 40,731.50 58.53% 139,077.91 27.51% 36220 -46330 Gen, Government Rents 28,069.00 40.33% 354,626.00 70.14% 36225 -46330 Nondwelling Rents 330.00 0.47% 4,620.00 0.91% 36290 -46330 Other Miscellaneous Revenue 463.00 0.67% 7,130.86 1.41% 3912046330 Recovery Damage City Property - 0.00% 130.00 0.03% Total Revenue 69,593.50 100.00010 505,584.77 100.00% Expenses Personal Services 1000 -46330 Accrued Salaries 8,752.00 12.58% 105,024.00 20.77% Total Personal Services 8,752.00 12.58% 105,024.00 20.77% Supplies -46330 Legal Fees 0.00 0.00% 8,785.01 2000 -46330 Office Supplies 244.23 0,35% 1,761.32 0.35% 2010 -46330 Minor Equipment 0.00 0.00% 1,808.21 0,36% 2160 -46330 Maint. & Construct Materials 532.67 0.77% 5,767.91 1.14% 2171 -46330 General Supplies 12.83 0.02% 6,665.24 1.32% Total Supplies 789.73 1.13% 16,002.68 0.84% Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 8,785.01 1.74% 3050 -46330 Expert and Professional Services 0.00 0.00% 13,244.00 2.62% 3060 -46330 Management Services 4,772.00 6.86% 57,264.00 11.33% 3100 -46330 Protective Services 426.42 0.61% 4,557.84 0.90% 3210-46330 Telephone &Telegraph 362.90 0.52% 4,240.69 0.84% 3430 -46330 Advertising Other 0.00 0.00% 65.00 0.01% 3600 -46330 Insurance & Bonds 1,424.58 2.05% 17,170.39 3.40% 3810 -46330 Electric 4,185.81 6.01% 48,613.07 9.62% 3820 -46330 Water 0.00 0.00% 8,095.84 1.60% 3830 -46330 Gas 4,901.45 7.04% 33,864.18 6.70% 3840 -46330 Refuse 0.00 0.00% 11,344.08 2.24% 3850 -46330 Sewer 0.00 0.00% 3,725.37 0.74% 4000 -46330 Repair & Maint. Services 5,708.67 8.20% 68,513.60 13.55% 4100 -46330 Rents & Leases 90.00 0.13% 887.04 0.18% 4300 -46330 Miscellaneous Charges 0.00 0.00% 83.33 0.02% 4315 -46330 PILOT 2,027.14 2.91% 24,870.94 4.92% 4390 -46330 Taxes & Licenses 0.00 0.00% 1,446.88 0.29% 4500 -46330 Administrative Expenses 135.40 0.19% 1,341.24 0.27% 4850 -46330 Interest on Deposits 13.74 0.02% 166.04 0.03% Total Other Services & Charges 24,048.11 34.56% 308,278.54 60.97% Page 2 of 7 1/13/20141:38 PM Capital Outlay 5120 -46330 Building & Improvements 0100 0.00% 1,839.76 0.36% Total Capital Outlay 0.00 0.00% 1,839.76 0.36% Total Expense 33,589.84 48.27% 431,144.98 85.28% Excess (Deficit) Revenue over Expense 36,003.66 51.73% 74,439.79 14.72% Page 3 of 7 Parkview Villa -North (165) Cash Flow Statement Period - December 2013 Book -- Accrual Revenue 33160 Federal Grant 36220 Gen. Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Expenses Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services & Charges Total Expenses Excess (Deficit) Revenue over Expenses Page 4 of 7 1/1312014 1:38 PM Month to Date 40,731.50 28,069.00 330.00 463.00 0.00 69,593.50 8,752.00 8,752.00 244.23 0.00 0.00 545.50 0.00 789.73 0.00 0.00 4,772.00 426.42 362.90 0.00 1,424.58 4,185.81 0.00 4,901.45 0.00 0.00 5,708.67 0.00 90.00 0.00 2,027.14 0.00 135.40 13.74 0.00 24,048.11 33,589.84 36,003.66 Pmrkviev Villa -North (165) Cash Flow Statement Period = Dix -embor 2013 Book =- ACCf UBl 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 1113120141:38 PM Month to Date 0.00 0.00 1,383.06 -25.00 0.00 1,424.58 - 31,992.84 0.00 - 100.32 2,027.14 717.00 (26,566.38) 9,437.28 Beg Cash End Cash Difference 70,342.91 80,194.19 9,851.28 621.00 207.00 (414.00) 891,214.11 891,214.11 - 962,178.02 971,615.30 9,437.28 Page 5 of 7 Parkvlew Vilia-NOHh (165) General Ledger Period = Dec 2013 Book Accrual, Tree ysi tb _ Prop poke Person /,pescr(pNO» ,Referenoe ':,pstill - Balance;, R4ntarks __, - 'Ci -- - 1000 -46330 _ Accrued Salaries 96,272.00 - Beginning Balance = 165 12/31/2013 :PostRecurring Monthly recurring entry RC 8,752.00 0.00 105,024.00 R/C CHC PR Mgmt Fee Net Change= 8,752.00 105,024.00 = Ending Balance = 2000 -46330 Office Supplies 1,517.09 = Beginning Balance= 165 11/5/2013 Office Depot OB18804) 6.81617E +11 13.16 0100 1,530.25 post- Its -69 165 11/5/2013 Office Depot (of08804) 6.81617E +11 26.61 0.00 1,556.86 stamper-69% 165 11/15/2013 Office Depot (offi8804) 6.83465E +11 S5.55 0.00 1,612.41 toner; notebooksJoumal ca 165 11/26/2013 Office Depot(of88804) 6.84274E +11 13.41 0.00 1,625.82 candy;heavy weight plastic 165 11/26/2013 Office Depot(off)8804) 6.84273E +11 25.23 0.00 1,651.05 cndy;pens;crrctn tape;8drs 165 12/30/2013 Eells petty cash reimbursement C1 110.27 0.00 1,761.32 Walgreens /US Postal /Isanti Net Change= 244.23 1,761.32 = Ending Balance = 2010 -46330 Minor Equipment 11808.21 = Beginning Balance = Net Change=0.00 1,808.21 = Ending Balance = 2160 -46330 Maint. & Construct Materials 5,235.24 = Beginning Balance = 165 12/6/2013 HD Supply Facilities Maintenance, Ltd.(homr 912678401 120.61 0.00 5,355.85 hose /gsktgulde /clip /pop -u 165 12/6/2013 HD Supply Facilities Maintenance, Ltd,(homr912678401 54.19 0.00 S,410.04 hose /gskVgulde /clip /pop -u 165 12/6/2013 Home Depot Credit Services (home905S) 4194484 59.04 0.00 5,469.08 fan /utility heaters -69% 165 12/13/2013 HD Supply Facllltles Maintenance, Ltd.(homr 9126725488 6.58 0.00 5,475.66 doorstops 165 12/13/2013 HD Supply Facilities Maintenance, Ltd.(homt 9126725488 126.83 0.00 5,602.49 2 -bulb ballasts;batteries 165 12/17/2013 Frattalone's /Metro Ace (hat) 017197R 46.32 0.00 5,648.81 pig kit;fuse plgs;drill bits;n 165 12/17/2013 HO Supply Facilities Maintenance, Ltd.(home9126774975 52.70 0.00 5,701.51 light bulbs -69 165 12/30/2013 Sheak Petty cash reimbursement 7.49 0.00 5,709.00 Frattallone - Sheak Petty a 165 12/30/2013 Fells petty cash reimbursement CI 58.91 0.00 5,767.91 Walgreens - Fells Petty cas Net Change= 532.67 5,767.91 = Ending Balance= 2171 -46330 General Supplies 6,652.41 = Beginning Balance = 165 12/30/2013 Sheak Petty cash reimbursement 12.83 0.00 6,665.24 Target- Sheak Petty Cash Net Change =12.83 6,665.24 = Ending Balance = 3040 -46330 Legal Fees 81785.01 = Beginning Balance = Net Change =0.00 8,785.01 = Ending Balance = 3060 -46330 Management Services 52,492.00 = Beginning Balance = 165 12/28/2013 Commoneond Housing (chc) 122813mgmtl 13,524.00 0.00 66,016.00 mgmt fee 12/13 165 12/31/2013 :PostRecurring Monthly recurring entry RC 0.00 8,752.00 57,264.00 R/C CHC PR Mgmt Fee Net Change= 4,772.00 57,264.00 = Ending Balance = 3100 -46330 Protective Services 4,131.42 = Beginning Balance = 165 12/3/2013 Total Life Security LLC (tota321) 2278 426.42 0.00 4,557.84 fire ext malnt 11/4/13 Net Change= 426.42 4,557.84 = Ending Balance = 3210 -46330 Telephone& Telegraph 3,877.79 = Beginning Balance= 165 11/30/2013 Popp.com (Popp) 992150290 223.64 0.00 4,101.43 phone -69% 11/1- 12/31/13 165 12/1/2013 Level One (leve) 0372338IN 76.52 0.00 4,177.95 phone -12/13 165 12/2/2013 Comcast(comc3422) 877210505011 56.89 0.00 4,234.84 Internet-69% 12/11/13 -1/1 165 12/2/2013 Comcast(COmc3422) 877210505011 5.52 0.00 4,240.36 late fee -69% 12/2/13 165 12/2/2013 Comcast (comc3422) 87721050501'. 0.33 0.00 4,240.69 cable tv franchise fee-69% Net Change= 362.90 4,240.69 = Ending Balance = 3430 -46330 Advertising Other 65.00 = Beginning Balance = Net Change =0.00 65.00 = Ending Balance = 3600 -46330 Insurance & Bands 15,745.81 = Beginning Balance = 165 12/31/2013 :PostRecurring Monthly recurring entry RC 1,424.SB 0.00 17,170.39 C of Columbia Heights ins , Net Change= 1,424.58 17,170.39 = Ending Balance = 3810 -46330 Electric 44,427.26 = Beginning Balance = 165 12/11/2013 Xcel Energy (xcel) 5150441553 1 4,185.81 0.00 48,613.07 a 11/1- 12/6/13 -69% Net Change = 4,185.81 48,613.07 = Ending Balance = 8,095.84 = Beginning Balance = 3820 -46330 Water 8,095.84 = Ending Balance = Net Change =0.00 3830 -46330 Gas 28,962.73 = Beginning Balance = 165 12/6/2013 CenterPolnt Energy (cent) 55199657 12/ 4,901.45 0.00 33,864.18 G- 11/04- 12/04/13 Net Change= 4,901.45 33,864.18 = Ending Balance = 3840 -46330 Refuse 11,344.08 = Beginning Balance = Net Change =0.00 11,344.08 = Ending Balance = 3850 -46330 Be.., 3,725.37 = Beginning Balance = Net Change =0.00 3,725.37 = Ending Balance = 4000 -46330 Repair and Maint. Services 62,804.93 = Beginning Balance = 165 10/31/2013 All Metro Lawn & Snow, LLC (aHm2138) 2826 262.50 0.00 63,067.43 grounds maint 10/1- 11/20: 165 10/31/2013 LBP Mechanical, Inc (Ibpm) W19485 1,609.89 0.00 64,677.32 boiler repair- 09/26- 10/16/1 165 11/30/2013 All Metro Lawn & Snow, LLC (alIm2138) 2900 447.22 0.00 65,124.54 grounds mount 11/20 -30/2( 165 11/30/2013 LBP Mechanical, Inc (Ibpm) W19634 422.31 0.00 65,546.85 zone valve rep- 11/25 -12/0 165 12/1/2013 Kone Inc. Hmne) 221339109 700.01 0.00 66,246.86 malnt- 12/01 - 12/31/13 165 12/10/2013 Adam's Pest Control, Inc. (adam) 845202 51.91 0.00 66,298.77 pest control -69% 11/25/13 165 12/10/2013 Gardner Plumbing, LLC (gard1086) 2755 105.27 0.00 66,404.04 In w pipe repair #401 12 /1( 165 12/13/2013 HD Supply Fact ities Mal ntenance, Ltd. (homr 9126725488 19.56 0.00 66,423.60 heat thermostat 165 12/16/2013 High Profile Grounds Maintenance, Inc. (high 28443 351.90 0.00 66,775.50 snow removal 1/14 -69 165 12/1712013 HD Supply Facilities Maintenance, Ltd. (homr 9126774975 42.09 0.00 66,817.59 Ice melt -69% 165 12/19/2013 LBP Mechanical, Inc (Ibpm) W19663 1,569.75 0.00 68,387.34 heat repairs 11/25- 12/13/1 165 12/23/2013 LBP Mechanical, Inc (Ibpm) W19689 126.26 0.00 68,513.60 heat maint-rplcmnt Fluters -: Net Change = 51708.67 68,513.60 = Ending Balance = 4100 -46330 Rents & Leases 797.04 = Beginning Balance = 165 11/30/2013 Multihousing Credit Control (multi) 13110372 90.00 0.00 887.04 screen sew-11/13 Net Change =90.00 887.04 = Ending Balance = 4300 -46330 Miscellaneous Charges 83.33 = Beginning Balance = Net Change =0.00 83.33 = Ending Balance = 4315 -46330 PILOT 22,843.80 = Beginning Balance = 165 12/31/2013 :PostRecurring Monthly recurring entry RC 2,027.14 0.00 24,870.94 Anoka Cty Property Tax Ac( Net Change= 2,027.14 24,870.94 = Ending Balance = 4390 -46330 Taxes and Licenses 1,446.88 = Beginning Balance = Net Change =0.00 1,446.88 = Ending Balance = 4500 -46330 Adminstrative Expenses 1,205.84 = Beginning Balance = 165 12/30/2013 Sneak Petty cash reimbursement 48.84 0.00 1,254.68 Sam's Club /Dollar Tree - St 165 12/30/2013 Eells petty cash reimbursement C3 27.47 0.00 1,282.15 Pizza Man - Eells Petty cast 165 12/31/2013 CommonBond Housing (chc) 123113manua 59.09 0.00 1,341.24 manual ck cost 2013 Net Change= 135.40 1,341.24 = Ending Balance = 4850 -46330 Interest on Deposits 152.30 = Beginning Balance = 165 12/31/2013 Sec Dep interest accrual G32 13.74 0.00 166.04 Sec Dep Interest accrual Net Change= 13.74 166.04 = Ending Balance = 5120 -46330 Building & Improvement 1,839.76 = Beginning Balance = Net Change =0.00 1,839.76 = Ending Balance = 42,341.84 8,752.00 Parkview Villa North Bank Reconciliation Report 12131/2013 6016456 Balance Per Bank Statement as of 12131/2013 Outstanding Checks Check data Check number 12117/2013 2280 12/30/2013 2287 12/30/2013 2288 12/30/2013 2289 12/30/2013 2290 12/30/2013 2291 12/30/2013 2292 12/30/2013 2293 12/30/2013 2294 12/30/2013 2295 Less: Outstanding Checks Payee gard1086 - Gardner Plumbing, LLC cent - CenlerPoinl Energy chc - Common8ond Housing comc3422 - Comcast frat • Frallalone's /Metro Ace high8236 - High Profile Grounds Maintenance, Inc. kone - Kone Inc. Ibpm - LBP Mechanical, Inc oMB804 - Offce Depot xcel - Xcal Energy Reconciled Bank Balance Balance per GL as of 12/3V20113 Difference Cleared Items : Cleared Checks Reconciled Balance Per GIL 0109/2014 105,846.11 (Reconciled Bank Balance And Reconciled Balance Per G /L) Dale Tran # 12/03/2013 2260 12/03/2013 2261 12/03/2013 2262 12/03/2013 2263 12103/2013 2264 12/03/2013 2265 12/03/2013 2266 12/03/2013 2267 12/03/2013 2268 12/03/2013 2269 12/03/2013 2270 Amount 105.27 4,901.45 13,524.00 62.74 46.32 351.90 700.01 1,696.01 78.41 4,185.81 25,651,92 80,194.19 80,194.19 80,194,19 0.00 Notes Amount Date Cleared aerotek- Aefotek Professional Services 579.60 12/31/2013 buck8411 - Buckeye Cleaning Centers 90.91 12/31/2013 cent - CenlerPolnl Energy 3,120.49 12/31/2013 chc- CommonBond Housing 13,536.75 12131/2013 cfty4054 - City Wide Locksmilhing, Inc. 7.23 12131/2013 como3474 - Comcast 56.89 12131/2013 fdd4908 - Fridley Snowplowing and Removal 85.70 12/3112013 home7 - HD Supply Facilities Maintenance, Ltd, 283.35 12/31/2013 off18804 - Office Depot 41.39 1213112013 parkt - Park Supply of America, Inc. 60.16 12/31/2013 10009778 - LaMonica 255.48 12131 /2013 Parkview Villa North Bank Reconciliation Report 1213112013 5016456 Cleared Checks Date Tran# Notes Amount 12/10/2013 2271 aerolek - Aerotek Professional S; ces 811.44 12/1012013 2272 home7 - HD Supply Facilities Maintenance, Ltd. 103.89 12/10/2013 2273 kenn - Kennedy & Graven, Chartered 5,044.06 12/10/2013 2274 lave - Level One 76.52 12/10/2013 2275 of08804 - Office Depot 44.99 12/10/2013 2276 lota321 -total Life Security LLC 426.42 12110/2013 2277 xcel - Xcel Energy 3,630.39 12/17/2013 2278 adam- Adam's Pest Control, Inc. 51.91 12/17/2013 2279 allm2138 -All Metro Lawn & Snow, LLC 709.72 12/1712013 2281 home9055 - Home Depot Credit Services 46.43 12/17/2013 2282 Ibpm - LBP Mechanical, Inc 2,032.20 12/17/2013 2283 multi - Mullihousing Credit Control 90.00 12/17/2013 2284 offi8804 -Office Depot 55.55 12/17/2013 2285 Popp - Popp.com 223.64 12117/2013 2286 sher4110- Sherwin-Williams Co. 4,740.38 Total Cleared Checks 36,199.49 Cleared Deposits Date Tran # Notes Amount 12/04/2013 541 23,797.00 12/05/2013 542 3,954.00 12/06/2013 543 1,809.00 12/09/2013 544 817.00 12/10/2013 545 89.00 12/11/2013 546 247.00 12!1312013 547 110.00 Total Cleared Deposits 30,823.00 Cleared Other Items Date Lan # 1 213 012 01 3 JE 181830 12/30/2013 JE 181833 1 213 012 01 3 JE 183314 Total Cleared Other Items 0v09/2014 Date Cleared 12/3112013 12/31/2013 12/31/2013 12/3112013 12/31/2013 12/31/2013 -1213112013 12/31/2013 12/31/2013 12131/2013 12/31/2013 12/31/2013 12/31/2013 12/31/2013 12/31/2013 Date Cleared 1 213112 01 3 12/31/2013 12/31/2013 1 2131/2 01 3 1213112013 12/31/2013 12/31/2013 Notes Amount Date Cleared Shook Petty cash reimbursement 137.84 12131/2013 Eells petty cash reimbursement 10.35 12/31/2013 ELoccs Opr Fund receipt 40,731.50 12/31/2013 40,879.69 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 Date 12/31/13 Primary Account Enclosures A C C O U N T S - - -- Page 1 @XXXXX @6456 34 NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING APP! YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOGGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX @6456 Previous Balance 70,342.91 9 Deposits /Credits 71,702.69 26 Checks /Debits 36,199.49 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 105,846.11 Number of Images 34 Statement Dates 12/01/13 thru 12/31/13 Days in the Statement Period 31 Average Ledger 112,127 Average Collected 111,001 Deposits and Credits Date Description Amount 12/04 DDA REGULAR DEPOSIT 23,797.00 12/05 MISC PAY HUD TREAS 310 40,731.50 CR 9101036151 12/05/13 ID #- 411269646860103 TRACE #- 101036150436843 12/05 DDA REGULAR DEPOSIT 3,954.00 12/06 DDA REGULAR DEPOSIT 1,809.00 12/09 DDA REGULAR DEPOSIT 817.00 12/10 DDA REGULAR DEPOSIT 89.00 12/11 DDA REGULAR DEPOSIT 247.00 12/13 DDA REGULAR DEPOSIT 110.00 12/30 DDA REGULAR DEPOSIT 148.19 *********************************************** * * * * * * * * * * * * * * * * ** * * ** * * * * * * * ** Checks in serial order Date Check# Amount Date Check# Amount 12/09 2260 579.60 12/06 2263 13,530.75 12/10 2261 90.91 12/10 2264 7.23 12/11 2262 3,120.49 12/12 2265 56.89 * Indicates skip in check numbers Date 12/31/13 Page 2 Primary Account @XXXXX @6456 Enclosures 34 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 12/10 2266 85.70 12/17 2276 426.42 12/11 2267 283.35 12/17 2277 3,630.39 12/17 2268 41.39 12/23 2278 51.91 12/11 2269 60.16 12/24 2279 709.72 12/20 2270 255.48 12/23 2281* 46.43 12/16 2271 811.44 12/24 2282 2,032.20 12/17 2272 103.89 12/24 2283 90.00 12/19 2273 5,044.06 12/31 2284 55.55 12/17 2274 76.52 12/24 2285 223.64 12/17 2275 44.99 12/24 2286 4,740.38 * Indicates skip in check numbers *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Date Balance Section Balance Date Balance Date Balance 12/01 70,342.91 12/11 124,029.22 12/20 113,647.75 12/04 94,139.91 12/12 123,972.33 12/23 113,549.41 12/05 138,825.41 12/13 124,082.33 12/24 105,753.47 12/06 127,103.66 12/16 123,270.89 12/30 105,901.66 12/09 127,341.06 12/17 118,947.29 12/31 105,846.11 12/10 1.27,246.22 12/19 113,903.23 * ** E N D O F S T A T E M E N T Payment Summary Bank= 165opr AND mm /yy= 12/2013- 12/2013 AND All Checks =Yes AND Include Voids =All Checks Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa 1 2260 aerotek - Aerotek Professional Services 12/03/2013 12/2013 579.60 165opr - Parkview Villa 1 2261 buck8411 - Buckeye Cleaning Centers 12/03/2013 12/2013 90.91 165opr - Parkview Villa 1 2262 cent - CenterPoint Energy 12/03/2013 12/2013 3,120.49 165opr - Parkview Villa 1 2263 chc - CommonBond Housing 12/03/2013 12/2013 13,530.75 165opr - Parkview Villa 1 2264 city4054 - City Wide Locksmithing, Inc. 12/03/2013 12/2013 7.23 165opr - Parkview Villa 1 2265 comc3474 - Comcast 12/03/2013 12/2013 56.89 165opr - Parkview Villa 1 2266 frid4908 - Fridley Snowplowing and Remo, 12/03/2013 12/2013 85.70 165opr - Parkview Villa 1 2267 home? - HD Supply Facilities Maintenance, 12/03/2013 12/2013 283.35 165opr - Parkview Villa 1 2268 offi8804 - Office Depot 12/03/2013 12/2013 41.39 165opr - Parkview Villa 1 2269 parkl - Park Supply of America, Inc. 12/03/2013 12/2013 60.16 165opr- Parkview Villa 2270 t0009778 - La Monica 12/03/2013 12/2013 255.48 165opr - Parkview Villa 1 2271 aerotek - Aerotek Professional Services 12/10/2013 12/2013 811.44 165opr - Parkview Villa 1 2272 home7 - HD Supply Facilities Maintenance, 12/10/2013 12/2013 103.89 165opr- Parkview Villa 2273 kern- Kennedy & Graven, Chartered 12/10/2013 12/2013 5,044,06 165opr - Parkview Villa 1 2274 leve - Level One 12/10/2013 12/2013 76.52 165opr - Parkview Villa 1 2275 offi8804 - Office Depot 12/10/2013 12/2013 44.99 165opr - Parkview Villa 1 2276 tota321 - Total Life Security LLC 12/10/2013 12/2013 426.42 165opr - Parkview Villa 1 2277 xcel - Xcel Energy 12/10/2013 12/2013 3,630.39 165opr - Parkview Villa I 2278 adam - Adam's Pest Control, Inc. 12/17/2013 12/2013 51,91 165opr - Parkview Villa 1 2279 allm2138 - All Metro Lawn & Snow, LLC 12/17/2013 12/2013 709.72 165opr - Parkview Villa 1 2280 gard1086 - Gardner Plumbing, LLC 12/17/2013 12/2013 105.27 165opr - Parkview Villa 1 2281 home9055 - Home Depot Credit Services 12/17/2013 12/2013 46.43 165opr - Parkview Villa 1 2282 Ibpm - LBP Mechanical, Inc 12/17/2013 12/2013 2,032.20 165opr - Parkview Villa 1 2283 multl - Multihousing Credit Control 12/17/2013 12/2013 90.00 165opr - Parkview Villa 1 2284 offi8804 - Office Depot 12/17/2013 12/2013 55.55 165opr - Parkview Villa 1 2285 popp - Popp.com 12/17/2013 12/2013 223.64 165opr - Parkview Villa 1 2286 sher4110 - Sherwin - Williams Co, 12/17/2013 12/2013 4,740.38 165opr - Parkview Villa 1 2287 cent - CenterPoint Energy 12/30/2013 12/2013 4,901.45 165opr - Parkview Villa 1 2288 chc - Common8ond Housing 12/30/2013 12/2013 13,524.00 165opr - Parkview Villa 1 2289 comc3422 - Comcast 12/30/2013 12/2013 62.74 165opr - Parkview Villa 1 2290 frat - Frattalone's /Metro Ace 12/30/2013 12/2013 46.32 165opr - Parkview Villa 1 2291 high8236 - High Profile Grounds Maintenai 12/30/2013 12/2013 351.90 165opr - Parkview Villa 1 2292 kone - Kone Inc. 12/30/2013 12/2013 700.01 165opr - Parkview Villa 1 2293 Ibpm - _BP Mechanical, Inc 12/30/2013 12/2013 1,696.01 165opr - Parkview Villa 1 2294 offi8804 - Office Depot 12/30/2013 12/2013 78.41 165opr - Parkview Villa 1 2295 xcel - Xcel Energy 12/30/2013 12/2013 4,185.81 61,851.41 T Parkview Villa South Financial Statement Overview October 2013 Revenue: Occupancy for the month of October was 82 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects lower occupancy as well as rent concessions paid out for the Move In Specials Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were over budget (unfavorable) and reflect the costs of background screening of new applicants 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 under budget (favorable); however, this reflects some quarterly billing Electric was over budget (favorable) and reflects September 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 over budget (unfavorable). 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. Irrigation Systems was over budget (unfavorable) and reflects the seasonal shut down of the system Repairs Contract was over budget (unfavorable) and reflects the cost of Water Meter Replacement and Cummins bi- annual inspection of Generators Heating and Cooling Maintenance and Repairs was over budget (unfavorable) and reflects South portion of Boiler replacement Decorating Contract was under budget (favorable) Furniture and Fixtures was over budget (unfavorable) and reflects cost of carpet and vinyl replacement in one unit o b v VI W m w N O O W N V O O o N Y O in w a u c- c o' w a x m ^' "— R m �% '� t o •• �, ,2 m n 9 ''' �° c o 3'�° am n. S m - n N m r W N O m pl W O A O V N O O Y A O P W O N lPll W N O O O� N b O A P b O O O O O O N O O w J% V O J r r N lPll P Nil IJn W W W J IWn O W Vl O m A P P W W W V N O l0 Nn O i O O N O W O W O O r N O O b O A O pm O O W W A J W N O N O b r J O O O O J O V O W N tA O P A W O P O V O W N r O r N b 1p W O O O O W O J O N mN r W N A A r N W O O W b Ipil V b r N N W N m w A tOn A N Vl W O l` O O O O O O N 0 N O o VI W m W yl O p O O O O 0 o b m In N W lr m m m V m N Vl N q w o w r b w m m mp WO A O A W V N P O lG N N r m m v w N In N W N N lPll W N O O O� N b O A P b O O O O O O N O O w J% V O J r r N lPll P Nil IJn W W W J IWn O W Vl O m A P P W W W V N O l0 Nn O i O O N O W O W O O r N O O b O A O pm O O W W A J W N O N O b r J O O O O J O V O W N tA O P A W O P O V O W N r O r N b 1p W O O O O W O J O N q z W W a z r O W J ➢ O O N r r�u°lW O O N P P W A O O O O O O O O O O ONi P m In N W lr m m m V m N Vl N q w o dl N N/I m m mp WO A O m m v jp iy0 w w iw � Qb N V O N O pp y m u� W W a m n q z W W a z r O W J ➢ O O N W lWJ ➢ r NN w wNa M O O Y O O m In N W lr m m m V m N Vl N q w o dl ? W o P m w m m v jp iy0 w w iw � Qb N V O N O N N m o O N � ➢ T C v 6 x n O d W ^ O - = m a 3 N m W P A A A O O O b m V V J V m N m m b N VI m o b N V m O OW m O W N M W N V P o yOj P •a O WO N V 00 o a� < a d 'o o n 3 -Q2a a�" N VI R O (]f i 9 b; O b •L 9 N C O N x aG3 C N ] N b H c n P �' n W ] pp C J n w n p N R A A y O �< N n c ] ,L 2 % C a i R m m y a a o dA•'•w ry - � n m .n b Jr4 N V N J V O M b w N Y W w r u r N V O ry O O O O V m O O m q m W N V VI O O b P W r O W V W P OW m N O o 0 J N O O O O W Y N N b O b W N N VI A O O A O A P O W r N a U T J PI �N m o m O m O O O O ig O N Y Y O N W O m V O W ymj A N O 'VIE W > m O q N J Imll V W W M N Y J Y Y n m A w W w W yb O A m o Y i m � V Y V N W O m O Y W w % V W > m O O N N Y J W O W O A m o Y O m O N m m V YI C m q Q W O N C C N C C J W N O T O H 2 � N J m w V r VI sxw T8 O 0 0 A O V A O O O J V N J J O N N IJi� N 4<i t m IOn P o V v N V m A N N v r� A< 0 lop ;No9 w_oyS b p W dN r O O N 0� O P O � 0 0 P� -�' O o 2 . �p W W W O lmll V r D ' v A r V W V (o w N O d N A O r N W A O W A O r dN O m J b N O VI W N N A W O J b Y N r m A W m m V1 N O N P T d W W p O P g b b U O O P J A m A A W Y N r J e m W m A e W m W N °n Vml lOn W r o O In N v W Z o o P A % N lmll O r b W O D Y O VI N m O O N b J 1n O O O O O VI O O O N N 0 0 0 o O o 0 0 0 0 o O o �6 3 Parkview Villa South (166) Balance October 2013 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance Total Assets Liabilities 20200 Accounts Payable 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected In Advance Total Liabilities Fund Balance 25300 Fund Balance Total Fund Balance Total Liabilities and Fund Balance 0ct-13 107,138.11 279.00 729,970.36 3,071.11 85.00 1,440.45 841,984.03 10,336.97 8,580.92 10,286.90 4,291.52 33,496.31 808,487.72 808,487.72 841,984.03 Parkview Villa -South (166) 98.00 0.52% 506.97 Income Statement 2010 -46340 Minor Equipment 1,970.05 10.39% 6,819.07 For The Period Ending October 2013 2.88% 2160 -46340 Maint. & Construct Materials 0.00 0.00% Books = Accrual 0.00% 2171 -46340 General Supplies 433.21 2.28% Month to Date °/a Year to Date Total Supplies Revenue 13.19% 10,255.50 4.34% Other Services & Charges 36220 -46340 Gen. Government Rents 18,419.00 97.12% 229,113.50 96.93% 36225 -46340 Nondwelling Rents 396.00 2.09% 4,528.68 1.92% 36290 -46340 Other Miscellaneous Revenue 150.00 0.79% 2,723.11 1.15% 39120 -46340 Recovery Damage City - 0.00% - 0.00% Total Revenue 18,965.00 100.000/0 236,365.29 100.000/0 Expenses 1,721.97 0.73% 3210 -46340 Telephone & Telegraph Personal Services 0.84% 1,577.77 0.67% 1000 -46340 Accrued Salaries 3,932.00 20.73% 39,320.00 16.64% Total Personal Services 3,932.00 20.73% 39,320.00 16.64 0/a Supplies 2000 -46340 Office Supplies 98.00 0.52% 506.97 0.21% 2010 -46340 Minor Equipment 1,970.05 10.39% 6,819.07 2.88% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 433.21 2.28% 2,929.46 1.24% Total Supplies 2,501.26 13.19% 10,255.50 4.34% Other Services & Charges 3040 -46340 legal Fees 0.00 0.00% 52.50 0.02% 3050 -46340 Expert & Professional Services 0.00 0.00% 5,873.00 2.48% 3060 -46340 Management Services 2,126.00 11.21% 21,260.00 8.99% 3100 -46340 Protective Services 623.28 3.29% 1,721.97 0.73% 3210 -46340 Telephone & Telegraph 159.49 0.84% 1,577.77 0.67% 3430 -46340 Advertising Other 0.00 0.00% 160.28 0.07% 3600 -46340 Insurance & Bonds 720.22 3.80% 7,079.44 3.00% 3810 -46340 Electric 2,344.43 12.36% 21,779.89 9.21% 3820 -46340 Water 1,180.64 6.23% 2,997.22 1.27% 3830 -46340 Gas 203.40 1.07% 10,087.19 4.27% 3840 -46340 Refuse 104.11 0.55% 248.69 0.11% 3850 -46340 Sewer 596.64 3.15% 1,549.35 0.66% 4000 -46340 Repair & Maint. Services 5,018.95 26.46% 31,164.60 13.18% 4100 -46340 Rents & Leases 129.92 0.69% 739.97 0.31% 4300 -46340 Miscellaneous Charges 39.22 0.00% 220.81 0.09% 4315 -46340 PILOT 1,028.69 5.42% 10,286.90 4.35% 4390 -46340 Taxes & Licenses 46.50 0.25% 705.12 0.30% 4500 -46340 Administrative Expenses 155.94 0.82% 478.87 0.20% 4850 -46340 Interest on Deposits 6.64 0.04% 64.71 0.03% Total Other Services & Charges 14,484.07 76.37% 118,048.28 49.94% 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 20,917.33 110.29% 167,623.78 70.92 0/a - 1,952.33 - 10.29% 68,741.51 29.08% Parkview Villa South (166) 0.00 Cash Flow Statement 98.00 Period = October 2013 1,970.05 2160 Maim. & Construct Materials Month to Date Revenue 433.21 36220 Gen. Government Rents 18,419.00 36225 Nondwelling Rents 396.00 36290 Other Miscellaneous Revenue 150.00 39120 Recovery Damage City Property 0.00 Total Revenue 18,965.00 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 3,932.00 Supplies 0.00 2000 Office Supplies 98.00 2010 Minor Equipment 1,970.05 2160 Maim. & Construct Materials 0.00 2171 General Supplies 433.21 2175 Food Supplies 0.00 Total Supplies 2,501.26 Other Services & Charges 3050 Expert & Professional Services 0.00 3060 Management Services 2,126.00 3100 Protective Services 623.28 3210 Telephone & Telegraph 159.49 3430 Advertising Other 0.00 3600 Insurance & Bonds 720.22 3810 Electric 2,344.43 3820 Water 1,180.64 3830 Gas 203.40 3840 Refuse 104.11 3850 Sewer 596.64 4000 Repair & Maint. Services 5,018.95 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 129.92 4300 Miscellaneous Charges 39.22 4315 PILOT 1,028.69 4390 Taxes & Licenses 46.50 4500 Administrative Expenses 155.94 4850 Interest on Deposits 6.64 Total Other Services & Charges 14,484.07 Total Expenses 20,917.33 Parkview Villa South (166) Cash Flow Statement Period = October 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 - 1,952.33 0.00 0.00 364.00 (45.00) 720.22 450.68 0.00 88.47 1,028.69 3,475.15 6,082.21 4,129.88 Beg Cash End Cash Difference 103, 0 08.23 107,138.11 4,129.88 279.00 279.00 - 729,970.36 729,970.36 - 833,257.59 837,387.47 4,129.88 Park4lew Villa South (166) General Ledger Period - Oct 2013 Book = Account ; Tree = y5L-tb Prop r Pe sonnf,j[hescription -:coltrat] ,,.'R-farance Debit Credit 1006-46340 Accrued Salaries 35,388.00 = Befilmalrig Balance= 166 10/31/2013 :POSIRecurring Recurring J-175470 RC 3,932.00 0.00 39,320.00 RIC CHC PR Mgmt Fee Not Change-3,932.00 39,320.00 - Ending Balance = 2000.46340 Office Supplies 408.97 - Beginning Balance w 166 10/312013 Office Depot (OU18804) P-353953 6.73596E+11 17.61 0.00 426,50 paper/candy 166 1013/2013 Office [)spot (offif]804) P-353956 6.73597C+l1 2.98 0.00 429.56 candy 166 1011712013 Commontond Housing (chc) P- 354249 I01713,8CY of 77.41 0.00 506.97 opm forms 1/13-10113 Not Chang.u98.00 506.97 w Ending Balance - 2000-46340 Minor Equipment 4,849.02 . Beginning Balance, 166 10/3/2013 HD Supply Facilities Maintenance, Ltd. (I P-352325 9125318039 271.87 0.00 5,120.89 washer 166 10/15/2013 Hamemickoetorating Center(hame) P-354224 CG311387 1,698.18 0.00 6,819.07 carpet Installation #117 Net Change-1,970.05 6,819.07 . Ending Balance - 217l.46340 General Supplies 2,496.25 u Beginning Balance 166 8/2/2013 Stle"jul-VIIIIIams Co. (sher4110) P-35401 82471 92.52 0.00 2,508.77 paint 166 9/12/2013 Sherwin-Wililams Co. (sher4110) P-354192 47750 92.52 0.00 2,681.29 paint 166 9/24/2013 HD Supply Facilities flolmonance, Ltd. (I P-352298 9125100791 88.84 0.00 2,770.13 ktchn fect/popup 166 9124/2013 HD Supply F8CI11UeS Maintenance, Ltd. (I P-352300 9125100749 51.53 0.00 2,821.66 chrome faucet 166 9/27/2013 Rattalone's/fleb-0 Ace (frat) P-351627 016459R 19.95 0.00 2,841.61 top pivot guJde;qIue;Insct s 166 10/18/2013 Frattalonn's/Metro Ace (rrat) P-354562 016652R 1.76 0.00 2,843.37 distilled water 166 10/22/2013 HO Supply FacHnies Maintenance, Ltd. (I P-355401 9125698319 49.87 0.00 2,093.24 toilet tank 166 10123/2013 HD Supply Facilities Maintenance, Ltd. (I P-355056 9125721513 36.22 0.00 2,929.46 faucet sUpp/bulbs/polymer Net Change.433,21 2,929.46 . Ending Balance - 3040-46340 Legal Pees 52.50 . Beginning Balance. Not Cliango=0.00 52.50 = Ending Balance 3060.46340 Management Services 19,134.00 - Beginning Balance - 166 1012912013 CammonBand Housing (chc) P-355475 102913mgmt 6,058.00 0.00 25,192.00 mgmt fee 10/13 166 10/31/2013 :Postlkecurring Recurring 1-175470 RC 0.00 3,932.00 21,260.00 RIC CHC PR Mgmt Fee Net Change-1,126.00 21,260.00 . Ending Balance - 3100-46340 Protective Services 11098,69 = Beginning Balance = 166 10124/2013 Olsen fire Protection, b1c. (else) P-355397 3144 341.00 0.00 1,439.69 Bre sprinkler inspect 166 10/25/2013 Total Life Security LLC (to0321) P-355696 2162 282.28 0.00 1,721.97 alarm lnspctn 10111/13 Not Chango=023.26 1,721.97 = Ending Balance - 3210.46340 Telephone & Telegraph 1,418.28 . Beginning Balance - 166 9/30/2013 POPP-40M (POPP) P-354047 992137111 99.55 0.00 1,517,83 plione-10/01-10/31/13 166 10/1/2013 Level One (love) P-352244 03586781ti 34.38 0.00 1,552.21 phone-Oct. rate plan 166 10/2/2013 Comcast (comc3474) P-353813 67721050501! 25.56 0.00 1,577.77 Internet 10/li,11/10113 Not Changem159.49 11577,77 n Ending Balance = 3430-46340 Advertising Other 160.28 . Beginning Balance - Net Change=0.00 160.28 = Ending Balance - 3600-46340 Insurance & bonds 0,369.22 - Beginning Balance - 166 10/31/2013 :PostRecurring Recurring J-175470 PC 720.22 0.00 7,079.44 C of Columbia Heights Ins I Not Change= 720.22 7,079.44 - Ending Balance n 3810-46340 Electric 19,435.46 . Beginning Balance a 166 10/11/2013 Xcel Energy (xcel) P-354292 5150441553 1 2,344.43 0.00 21,779,89 E-09/04-10105/13 Net Change=20344.43 21,770.89 - Smiling Balance 3820-46340 Water 10816.58 = Beginning Balance= 166 10/10/2013 City of Columbia Heights (colu) P-353451 31802650001 1,180.64 0.00 2,997.22 W-06127.09/27/13 N0tChRn00mI,IU0.64 2,997.22 . Ending Balance 3830-40340 Gas 9,883.79 = Beginning Balance - 166 10/812013 CenteTPoInt Energy (cent) P-353942 55271324 10/ 2.17 0.00 9,085.96 late fee 166 10/8/2013 CerwarPoint Energy (cent) P-353942 55271324 10/ 201.23 0.00 10,087.19 G-09106-10107/13 Net Change.203.40 10,087.19 n Ending Balance 4850 -46340 Inarest on Deposits 1 58.07 v Beginning Balance = 166 10/31/2013 Sec Dep Interest accrual 3-177628 G)1 6.64 0100 64.71 $ee Cap Balance a al Net Change-6.64 24,849.33 3,932.00 144,58 = Beginning Balance = 3840.46340 166 1012112013 Refuse Green Lights Recycling Inc(greef004) P-355403 135451 104111 0.00 248.69 appilance recycling Net Chongo- 1044i 248,69 = Ending Balance 952.71 = Beginning Balance = 3850.46340 166 10/10/2013 Sewer City of Columbia helghis(cotu) P- 353451 31802650001 596.64 0.00 1,549.35 5.06127. 09/27/13 Not Change =596.64 1,549,35 = Ending Balance = 4000 -46340 Repalr& Maint. SO"ICe$ 20,145.65 = Beginning Balance = 166 9/13/2013 8P141 Inc (hu (humid) P-351742 26915 282.72 0.00 26,428.37 repairs 9/9-13/2013 1(,6 9/25/2013 Adam's Pest Control, Inc.(adam) P- 353423 828402 23.32 0.00 26,451.69 extern lteat-09 /25113 166 9/25/2013 Fridley Snowplowing and Removal(RId4 P- 353307 22989 83.14 0.00 26,534.83 brig repair 166 9/3012013 All Metro Lawn & Snow, LLC(alIM2138) P- 353310 2796 117.94 0.00 26,652.77 mow /um/biw- 09/01- 09/27 166 9/30/2013 Direct home Appliance Sewices(dire) P- 353767 93013165166 27.59 0,00 26,680.36 washer law 166 9/3012013 LBP Mechanical, Inc (Ibpm) P- 353309 W19278 3,519.74 0.00 30,200.10 boiler replace- 07/29-08/13 166 10/1/2013 Kone Inc. (k0ne) P- 353337 221291680 314.50 0.00 30,514.60 elevnaint 10113 166 10/14/2013 K.O. Cleaning and Restoration LLC(kocl P- 353903 1546 400.00 0.00 30,914.60 painting 166 10/14/2013 K.O. Cleaning and Restoration LLC (kocl P-353918 1548 250.00 0.00 31,164.60 painting Net Change- S,OL8.95 31,364,60 = EOding Balance = 610.05 o Beginning Balance= 4100 -46340 Rem$ &Losses Muldhousing Credit Control (Muhl) P- 353227 13090397 20.00 0100 630.05 residential screening 9113 166 166 9/30/2013 1011/2013 RC Gacek manual refund )- 177629 G12 109.92 0.00 739.97 RC Gacek manual refund 739.97 = Ending Balance = Not Chango= 129.92 181.59 = Beginning Balance u 4300.46340 Miscellaneous Charges 166 10/8/2013 City Wide Loeksmithing, Inc. (dty4054) P- 353338 1630 2.24 0100 183.83 keys 166 10122/2013 City Wide Loeksmilhing, Inc. (city4054) P- 355399 1909 14.46 0.00 198.29 keys cut 166 10/2317.013 HD Supply Facift es Maintenance, Ltd, (I P- 355056 9125721513 22.52 0.00 220.81 locks 220.81 = Ending Balance = Not Change =39.22 9,258.21 u Beginning Balance = 4315 -46340 166 10/31/2013 PILOT :PostRecuning Recurring 3- 175470 RC 1,028.69 0.00 10,28690 Anoka Cty Property Tax An Net Changan 1,028.69 10,286.90 u Ending Balance - 658.62 = Beginning Balance = 4390 -46340 Taxes & Licensee 15.50 0100 674.12 bolter 166 10/2/2013 MN Dept of Labor & Industry (nndpp P-353308 ABR00782591 166 10/212013 Minnesota Depart of Labor &Industry(n P- 353429 ALR00333801 31.00 0100 705.12 annual el ev oper 705.12 = Ending Balance = Net Chango =46.50 322.93 = Beginning Balance = 4500.46340 Administrative Expenses Doreen)ablonske (labl) P- 355383 82813166 155,94 0.00 478.87 mileage 8/15-28/2013 166 8/26/2013 478.87 v Ending Balance - Net Change= 155.94 4850 -46340 Inarest on Deposits 1 58.07 v Beginning Balance = 166 10/31/2013 Sec Dep Interest accrual 3-177628 G)1 6.64 0100 64.71 $ee Cap Balance a al Net Change-6.64 24,849.33 3,932.00 Payment Summary Bank= 166opr AND mm /yy= 10/2013- 10/2013 AND All Checks =Yes AND Include Voids= All Checks Check Post Total Bank Check* Vendor Date Month Amount 166opr - Parkview Villa South 1865 chc - CommonBOnd Housing 10/01/2013 10/2013 25.05 166opr - Parkview Villa South 1866 frat - Frattalone's /Metro Ace 10/01/2013 10/2013 4.37 166opr - Parkview Villa South 1867 mndpl - MN Dept of Labor & Industry 10101/2013 10/2013 31.00 166opr - Parkview Villa South 1868 sitz - Sitzmann Construction rite Sitzmann EIC 10/01/2013 10/2013 150.35 166opr - Parkvlew Villa South 1869 10003778 - Booth 10/01/2013 10/2013 141.81 166opr- Parkview Villa South 1870 10003819 - Johansen 10/01/2013 10/2013 250.69 166opr- Parkview Villa South 1871 Iran - Trans -Alarm Inc 10/01/2013 10/2013 119.35 166opr - Parkview Villa South 1872 xcel - Xcel Energy 10/01/2013 10/2013 2,643.69 166opr - Parkvlew Villa South 1873 bmmi - BMM Inc 10/08/2013 10/2013 282.72 166opr - Parkview Villa South 1874 cent - CenterPoint Energy 10/08/2013 10/2013 144.83 166opr - Parkview Villa South 1875 chc - Common Bond Housing 10/08/2013 10/2013 6,058.00 166opr - Parkview Villa South 1876 frat - Frattalone's /Metro Ace 10/08/2013 10/2013 19.95 166opr - Parkview Villa South 1877 home7 - HD Supply Facilities Maintenance, Ltl 10/08/2013 10/2013 14.91 166opr - Parkview Villa South 1878 adam - Adam's Pest Control, Inc. 10/15/2013 10/2013 23.32 166opr - Parkvlew Villa South 1879 aerotek - Aerotek Professional Services 10/15/2013 10/2013 260.40 166opr - Parkvlew Villa South 1880 allm2138 - All Metro Lawn & Snow, LLC 10/15/2013 10/2013 117.94 166opr - Parkview Villa South 1881 city4054 - City Wide Locksmithing, Inc. 10/15/2013 10/2013 2.24 166opr - Parkview Villa South 1882 frid4908 - Fridley Snowplowing and Removal 10/15/2013 10/2013 83.14 166opr - Parkview Villa South 1883 kone - Kone Inc. 10/15/2013 10/2013 314.50 166opr- Parkview Villa South 1884 Ibpm - LBP Mechanical, Inc 10/15/2013 10/2013 3,519.74 166opr- Parkview Villa South 1885 [eve - Level One 10/15/2013 10/2013 34.38 166opr - Parkvlew Villa South 1886 muitl - Multihousing Credit Control 10/15/2013 10/2013 20.00 166opr - Parkview Villa South 1887 10003806 - Putz 10/15/2013 10/2013 134.17 166opr - Parkview Villa South 1888 aerotek - Aerotek Professional Services 10/22/2013 10/2013 260.40 166opr - Parkview Villa South 1889 comc3474 - Comcast 10/22/2013 10/2013 25.56 166opr - Parkvlew Villa South 1890 dire - Direct Home Appliance Services 10/22/2013 10/2013 27.59 166opr - Parkview Villa South 1891 frat - Frattalone's /Metro Ace 10/22/2013 10/2013 1.76 166opi - Parkview Villa South 1892 home7 - HD Supply Facilities Maintenance, Lu 10/22/2013 10/2013 140.37 166opr - Parkvlew Villa South 1893 kocl - K.O. Cleaning and Restoration LLC 10/22/2013 10/2013 650.00 166opr - Parkview Villa South 1894 Popp - Popp.com 10/22/2013 10/2013 99.55 166opr - Parkview Villa South 1895 sher4110 - Sherwin- Williams Co. 10/22/2013 10/2013 185.04 166opr - Parkview Villa South 1896 1:0003805 - Gacek 10/22/2013 10/2013 109.92 166opr- Parkview Villa South 1897 aerotek - Aerotek Professional Services 10/29/2013 10/2013 208.32 166opr- Parkview Villa South 1898 chc - CommonBond Housing 10/29/2013 10/2013 77.41 166opr - Parkview Villa South 1899 home7 - HD Supply Facilities Maintenance, Lt, 10/29/2013 10/2013 271.87 166opr - Parkvlew Villa South 1900 mndol - Minnesota Depart of Labor & Industry 10/29/2013 10/2013 31.00 166opr- Parkvlew Villa South 1901 mndpl - MN Dept of Labor & Industry 10/29/2013 10/2013 15.50 166opr- Parkview Villa South 1902 xcel - Xcel Energy 10/29/2013 10/2013 2,344.43 18,845.27 Parkview Villa South Bank Reconciliation Report 10/31/2013 5016464 Balance Per Bank Statement as of 10/31/2013 Outstanding Checks Check date Check number 06/18/2013 1786 10/22/2013 1890 10/22/2013 1893 10/29/2013 1897 10/29/2013 1899 10/2912013 1900 10/29/2013 1901 10/29/2013 1902 Less: Outstanding Checks Payee 10011071- Johnson dire - Direct Home Appliance Services kocl - K.O. Cleaning and Restoration LLC aerolek - Aerotak Professional Servlces home7 - HD Supply Facilities Malntenance, Ltd. mndol - Minnesota Doparl of Labor & Industry mndpl - MN Dept of Labor & Industry xcel - Xcel Energy Reconciled Bank Balance Balance per GL as of 1013112013 Difference Cleared Items : Cleared Checks Reconciled Balance Per GIL 110,919.78 (Reconciled Bank Balance And Reconciled Balance Per GIL) Date Tran # 09/25/2013 1860 09/25/2013 1861 09/25/2013 1862 09/26/2013 1863 09125/2013 1864 10/01/2013 1865 10/01/2013 1866 10/01/2013 1867 10/01/2013 1868 10/01/2013 1869 10/0112013 1870 10/0112013 1871 10/01/2013 1872 Amount 232.96 27.69 650.00 208.32 271.87 31.00 15.50 2,344.43 3,781.67 107,138.11 11/07/2013 107,138.11 107,138.11 0.00 Notes Amount Dale Cleared como3422 - Comcast 28.19 10/3112013 home - Hamemick Decorating Center 3,404.50 10/31/2013 home7 - HD Supply Facilities Maintenance, Ltd. 315.60 10/31/2013 kone - Kone Inc. 314.50 10/31/2013 Popp - Popp.com 99.73 10/31/2013 chc - CommonBond Housing 25.05 10/31/2013 fret - Frattalone's/Metro Ace 4.37 10/3112013 mndpi - MN Dept of Labor & Industry 31.00 10/31/2013 sitz - Silzmann Construction dba Sltzmann Elect 150.35 10/31/2013 10003778 - Booth 141.81 10/31/2013 10003819- Johansen 250.69 10/31/2013 Iran - Trans -Alarm Inc 119.35 10131/2013 xcel -Xcel Energy 2,643.69 10/31/2013 Parkview Villa South 11/07/2013 Bank Reconciliation Report 10/31/2013 5016464 Cleared Checks Date Tran # Notes Amount Date Cleared 10/08/2013 1873 bmmi - BMM Inc 282.72 1Q/31/2013 10/08/2013 1874 cent - CenlerPoinl Energy 144.83 10/31/2013 10/08/2013 1876 chc - CommonBond Housing 6,058.00 10131/2013 10/08/2013 1876 Prat - Fraltalone'a /Metro Ace 19.95 10/31/2013 10/08/2013 1877 home7 - HD Supply Facilities Maintenance, Ltd. 14.91 10/31/2013 10/15/2013 1878 adam - Adam's Pest Control, Inc. 23.32 10/31/2013 10/1512013 1879 aerolek- Aerotek Professional Services 200.40 10/31/2013 10/15/2013 1880 alim2138 -All Metro Lawn & Snow, LLC 117.94 10/31/2013 10115/2013 1881 ci1y4054 -City Wide Locksmithing, Inc. 2.24 10/31/2013 10/15/2013 1882 frld4908 - Fridley Snowplowing and Removal 83.14 10/31/2013 10115/2013 1883 kone - Kane Inc. 314.50 10131/2013 10/16/2013 1884 Ibpm - LBP Mechanicel, Inc 3,519.74 10/3112013 10/15/2013 1885 lave - Level One 34.38 10/31/2013 10/15/2013 1888 multi - Mutihousing Credit Control 20.00 10/31/2013 10/15/2013 1887 t0003806 - Putz 134.17 10/31/2013 10/22/2013 1888 aerotek- Aerotek Professional Services 260.40 10/31/2013 10/22/2013 1889 camc3474- Comcast 25.56 10131/2013 10122/2013 1891 fret - Frattalone'slMetro Ace 1.76 10/31/2013 10122/2013 1892 home7- HD Supply Facilities Maintenance, Lid. 140.37 10131/2013 10/22/2013 1894 Popp - POpp.com 99.55 10/31/2013 10/22/2013 1895 sher4110- Sherwin- Wiillams Co. 185.04 10/31/2013 1012212013 1896 t0003805 - Gacek 109.92 10/31/2013 10/29/2013 1898 chc - CommonBond Housing 77.41 10131/2013 Total Cleared Checks 19,459.08 Cleared Deposits Dale Tran # Notes Amount Date Cleared 10/04/2013 401 20,718.15 10/31/2013 10/07/2013 402 787.00 10/31/2013 10/08/2013 403 614.00 10131/2013 10/08/2013 403 200.00 10/31/2013 10110/2013 404 - 10.00 10/3112013 10/18/2013 407 646.00 10131/2013 Total Cleared Deposits 22,975.15 Date 10/31/13 Page 1 Primary Account @XXXXX @6464 Enclosures 41 HRA OF COLUMBIA HEIGHTS PARKVIEW 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 - - -- NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING APP! YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOOGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX @6464 Previous Balance 107,403.71 5 Deposits /Credits 22,975.15 36 Checks /Debits 19,459.08 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 110,919.78 Number of Images 41 Statement Dates 10/01/13 thru 10/31/13 Days in the Statement Period 31 Average Ledger 112,783 Average Collected 112,135 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Deposits and Credits Amount Date Date Description 10/03 Amount 10/07 DDA REGULAR DEPOSIT 787.00 10/07 DDA REGULAR DEPOSIT 20,718.15 10 /10 DDA REGULAR DEPOSIT 10.00 10 /10 DDA REGULAR DEPOSIT 814.00 10/18 DDA REGULAR DEPOSIT 646.00 Checks Date in serial order Check# Amount Date Check# Amount 10/03 1860 28.19 10/09 1870 250.69 10/01 1861 3,404.50 10/07 1871 119.35 10 /01 1862 315.60 10/07 1872 2,643.69 10/02 1863 314.50 10 /11 1873 282.72 10 /01 1864 99.73 10/15 1874 144.83 10/03 1865 25.05 10 /10 1875 6,058.00 10 /08 1866 4.37 10/17 1876 19.95 10/04 1867 31.00 10 /15 1877 14.91 10/08 1868 150.35 10/18 1878 23.32 10/15 1869 141.81 10/21 1879 260.40 * Indicates skip in check numbers Date 10/31/13 Page 2 Primary Account @XXXXX @6464 Enclosures 41 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 10/25 1880 117.94 10/28 1888 260.40 10 /18 1881 2.24 10/29 1889 25.56 10/22 1882 83.14 10/28 1891* 1.76 10/22 1883 314.50 10/28 1892 140.37 10/23 1884 3,519.74 10/28 1894* 99.55 10/21 1885 34.38 10/29 1895 185.04 10/21 1886 20.00 10/29 1896 109.92 10/23 1887 134.17 10/31 1898* 77.41 * Indicates skip in check numbers *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Balance Section Date Balance Date Balance Date Balance 10 /01 103,583.88 10 /10 116,287.84 10/23 111,937.73 10/02 103,269.38 10/11 116,005.12 10/25 111,819.79 10/03 103,216.14 10 /15 115,703.57 10/28 111,317.71 10/04 103,185.14 10/17 115,683.62 10/29 110,997.19 10/07 121,927.25 10/18 116,304.06 10/31 110,919.78 10/08 121,772.53 10/21 115,989.28 10/09 121,521.84 10/22 115,591.64 * * * E N D O F S T A T E M E N T VAROP 0 r E� I C Parkview Villa South Financial Statement Overview November 2013 Revenue: Occupancy for the month of November was 82 % occupied Total Revenue was lower than budget amount (unfavorable) and reflects lower occupancy Administrative Expenses: Administrative costs for South were tinder budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were over budget (unfavorable) and reflect the cost of background screening Office Supplies was under budget (favorable) Legal Services 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 raider budget (favorable) Gas was under budget (favorable) and reflects a quarterly billing Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operatina and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor Supplies were over budget (unfavorable) and reflect cost of goods 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) Decorating Contract was over budget (unfavorable) and reflects cost of paint for unit turnover Furniture and Fixtures was over budget (unfavorable) and reflects cost of two units vinyl and carpet replacement W OC F b r gfp!£ A 5 4 v 9 o y W N o O a 3 R a IR R ; m a = C• N n _ c - H< N ` o d o c A n a' R "dp'c C „ H@ $ n_ w w w w N P W Yp Pq Py b r A N w P L A O N N W o J W N O o O O N W O w N b O P O W a V A O O O o O O W W O O W yNj '� O J P N 0 S A O 0 0 J O Y O P O W OO O OO OO rW 0 0 0 0 O VI O W O O O O N m c m P O 0 0 0 0 Y V O V1 W W W V VWI O W V1 O O W Y N J o J w w 0 0 N N N N Y b W' r V V r W W W O b O W o � W O O W P J O W O W W V O O W O M O N O O� O W W J A V INII O W W A Q O O 0 0 0 0 W O 0 P m O W ! O W O r O p W N N 0 P 2 0 q y 0➢ w Z N W O b O b O q� 0 N11 N O N O D N V O N V V vi U w N V W P N b b b N J N r VN W r J W N T O N N b 'O 'O NA W Y W O W Wr J r N O O O O W O J O W N W O W O W N W Y O VWI T N W W N A V P P w r �^ V1 N w WPW qWq r A W N � O Y -W W b A W N w m N A W O P O M W O W IJiI N W W O VJ1 W r O O N O O OP N V N J� N O V o o N N w 0 0 0 0 0 V O V1 W W V N W O O J W W 0 Y W r A O O b J r J $ WO A A w WW N O rW j b W m A 0 A A A O N A N W b A O A N W Y m W O Vbl O A N N N N P' P A O O O W W W N N O O O W A N m J V r W r w P N V N O P O W O W N W O Z r W b r Y V N V1 V Z IWII o 4 D o W W W O r N N W W A o D 1p o b N N r b W O N W W Y W w o N 0 00 o m A v N r o N W W W N WY o W P A m O m o p o 0 0 O O O O O o O O O o O o 0 yNl o ° o O o W OC F b r gfp!£ A 5 4 v 9 o y W N o O a 3 O N N N N N N INn N N N P N q. g N P b O W N V N o R r o b m m N ro O. v - D a X ° ] r u a a n y d ao '^ R� ^3.oS'o w.rvary c c 'n m & 3 a f c T b K n i a 0 N o ^ d� N a `C Q� � ] % N R � ; d ] N _. - b° o a Y h � % � � � R P - P •• - Q T T ° V A Y 3 � .• Y w q P p W i bW O o C o ro N N O b N p q O N O O O O m A •w O A N O O A O 0 0 0 0 O o O O O O O R ] Cl yAy O b q WP q P w w N w w W W yA Y N N w P N O A H m N p W N A g A J O N V A S O O O O N VI N C v 6 $ O 2 _ a _ W P o Ci w 3 i t V A A A O y p O �p N V o b O V W➢ D O O O j N P N P o w 1 1 0 V N � 0 ro o 0 P o b u V A r J b r r W w O J pP� W o o > w A N A ', N O N J N �° � O o A N W N .ov •NU W w o J ro •n JP o r ro O m W q V J w r V V r r � N o rN• W w VWI A w o J b. q V Y N b O O o O yuj O W N W M r q q Vy r A m r J A N p O p 0 1Nll O O u y q m N N E P °� r a lJl1 O W w V 0 Nw o o A O. V W V V y W P N vNi N W o O O V W N J V O O W A W Y r Y W O b N r W w P O r W W Nii A A O M P q P W .A W '4 W W% W VOI W b q N W W q P N W W J A r N A V N W W C v 6 $ O 2 _ a _ W P o Ci w 3 N 0 in P N V � 0 ro o 0 P o b u N N P O W w O V y Y A w W v � O b O O O o O yuj O o o N o 0 o o o 0 VI lAl1 .0 P N O p N p O p 0 1Nll O O u O O O O O O O O. O O O O O O O .o O o O O O O C v 6 $ O 2 _ a _ W P o Ci w 3 Parkview Villa South (166) Balance November 2013 Books = Accrual Nov -13 Assets 20200 Accounts Payable 10100 Cash Balance 113,976.15 8,787.42 10200 Petty Cash 279.00 22200 Accrued PILOT 11,315.59 729,970.36 852.52 10400 Investments 32,621.64 Total Liabilities 11300 Rent Receivable 4,703.11 11500 Accounts Receivable 91.15 817,118.35 720.22 15510 Prepaid Insurance 849,739.99 849,739.99 Total Assets Liabilities 20200 Accounts Payable 11,666.11 8,787.42 22000 Deposits 22200 Accrued PILOT 11,315.59 22210 Revenue Collected In Advance 852.52 32,621.64 Total Liabilities Fund Balance 25300 Fund Balance 817,118.35 817,118.35 Total Fund Balance Total Liabilities and Fund Balance 849,739.99 Parkview Villa -South (166) 38.81 0.16% 545.78 0.21% Income Statement 3,084.34 12.94% 9,903.41 3.81% For The Period Ending November 2013 0.00 0.00% 0.00 0.00% Books = Accrual Month to Date % Year to Date 1.41% Revenue 3,868.60 16.24% 14,124.10 5.43% 36220 -46340 Gen. Government Rents 23,187.73 97.32% 252,301.23 96.97% 36225 -46340 Nondwelling Rents 495.00 2.08% 5,023.68 1.93% 36290 -46340 Other Miscellaneous Revenue 144.00 0.60% 2,867.11 1.10% 3820 -46340 Water - 0100% - 0.00% 39120 -46340 Recovery Damage City 1,090.18 4.58% 11,177.37 4.30% 3840 -46340 Refuse 23,826.73 100.00% 260,192.02 100.000/. Total Revenue 0.00 0.00% 1,549.35 0.60% Expenses Personal Services 1000 -46340 Accrued Salaries 3,932.00 16.50% 43,252.00 16.62% Total Personal Services 3,932.00 16.50% 43,252.00 16.62% Supplies 2000 -46340 Office Supplies 38.81 0.16% 545.78 0.21% 2010 -46340 Minor Equipment 3,084.34 12.94% 9,903.41 3.81% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 745.45 3.13% 3,674.91 1.41% Total Supplies 3,868.60 16.24% 14,124.10 5.43% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 52.50 0.02% 3050 -46340 Expert & Professional Services 0.00 0.00% 5,873.00 2.26% 3060 -46340 Management Services 2,126.00 8.92% 23,386.00 8.99% 3100 -46340 Protective Services 0.00 0.00% 1,721.97 0.66% 3210 -46340 Telephone & Telegraph 159.85 0.67% 1,737.62 0.67% 3430 -46340 Advertising Other 0.00 0.00% 160.28 0.06% 3600 -46340 Insurance & Bonds 720.23 3.02% 7,799.67 3.00% 3810 -46340 Electric 1,405.47 5.90% 23,185.36 8.91% 3820 -46340 Water 0.00 0.00% 2,997.22 1.15% 3830 -46340 Gas 1,090.18 4.58% 11,177.37 4.30% 3840 -46340 Refuse 0.00 0.00% 248.69 0.10% 3650 -46340 Sewer 0.00 0.00% 1,549.35 0.60% 4000 -46340 Repair& Maim, Services 798.58 3.35% 31,963.18 12.28% 4100 -46340 Rents & Leases 60.00 0.25% 799.97 0.31% 4300 -46340 Miscellaneous Charges 0.00 0.00% 220.81 0.08% 4315 -46340 PILOT 1,028.69 4.32% 11,315.59 4.35% 4390 -46340 Taxes & Licenses 0.00 0.00% 705.12 0.27% 4500 -46340 Administrative Expenses 0.00 0.00% 478.87 0.18% 4850 -46340 Interest on Deposits 6.50 0.03% 71.21 0.03% Total Other Services & Charges 7,395.50 31.04% 125,443.78 48.21% Capital Outlay 5120 -46340 Building & Improvements - 0.00% - 0.00% Total Capital Outlay 0.00 0.000/0 0.00 0.00% 15,196.10 63.78% 182,819.88 70.26% Total Expense Excess (Deficit) Revenue over Expense 8,630.63 36.22% 77,372.14 29.74% Parkview Villa South (166) Cash Flow Statement Period Nnvembm 2013 Month to Date Revenue 36220 Gen. Government Rents 23,187.73 36225 Nondwelling Rents 495.00 36290 Other Miscellaneous Revenue 144.00 39120 Recovery Damage City Property 0.00 Total Revenue 23,826.73 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 3,932.00 Supplies 0.00 2000 Office Supplies 38.81 2010 Minor Equipment 3,084.34 2160 Maint. & Construct Materials 0.00 2171 General Supplies 745.45 2175 Food Supplies 0.00 Total Supplies 3,868.60 Other Services & Charges 3050 Expert & Professional Services 0.00 3060 Management Services 2,126.00 3100 Protective Services 0.00 3210 Telephone & Telegraph 159.85 3430 Advertising Other 0100 3600 Insurance & Bonds 720.23 3810 Electric 1,405.47 0.00 3820 Water 1,090.18 3830 Gas 3840 Refuse 0.00 0.00 3850 Sewer 4000 Repair & Maint. Services 798.58 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 60.00 4300 Miscellaneous Charges 0.00 1,028.69 4315 PILOT 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 0.00 4850 Interest on Deposits 6.50 Total Other Services & Charges 7,395.50 15,196.10 Total Expenses Parkview Villa South (166) Cash Flow Statement Period = November 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 8,630.63 0.00 0.00 (1,632.00) (6.15) 720.23 1,329.14 0.00 206.50 1,028.69 (3,439.00) (1,792.59) 6,838.04 Beg Cash End Cash Difference 107,138.11 113,976.15 6,838.04 279.00 279.00 - 729,970.36 729,970.36 - 837,387.47 844,225.51 6,838.04 Parkview Villa South (166) General Ledger Period = Nov 2013 Book = Accrual; Tree = ysi_tb ptaper,gatd '; . Pereonf0eseriptlon - = Conti al Reference .= .Oabit ; Cradite 8alppca REtnarks ,` -. 1000 -46340 Accrued Salaries 39,320.00 = Beginning Balance = 166 11/30/2013 :PostRecurring Recurring 3- 180493 RC 3,932.00 0.00 43,252.00 R/C CHC PR Mgmt Fee Net Change = 3,932.00 43,252.00 = Ending Balance = 2000 -46340 Office Supplies 506.97 = Beginning Balance = 166 10/29/2013 Office Depot(offi8804) P- 356667 68054465900: 3.37 0.00 510.34 can lster /envelope /notebook 166 10/29/2013 Office Depot (off18804) P- 356673 68054465800: 1.65 0.00 511.99 creamer 166 10/29/2013 Office Depot(off18804) P- 356674 68054465700: 2.98 0.00 514.97 pens 166 10/29/2013 Office Depot(offi8804) P- 356675 68054451100: 10.60 0.00 525.57 calendars 166 11/12/2013 Office Depot (off18804) P- 358880 68283046200: 20.21 0.00 545.78 paper /pen /binders Net Change =38.81 545.78 = Ending Balance = 2010.46340 Minor Equipment 6,819.07 = Beginning Balance = 166 10/31/2013 Hamernick Decorating Center (home) P- 356523 CG312457 1,800.18 0.00 8,619.25 carpet /vinyl install 166 11/25/2013 Hamernick Decorating Center (home) P- 359730 CG313371 1,284.16 0.00 9,903.41 Install carpet #321 Net Change= 3,084.34 9,903.41 = Ending Balance = 2171 -46340 General Supplies 2,929.46 = Beginning Balance = 166 10/29/2013 HD Supply Facilities Maintenance, Ltd. ( P- 356263 9125834851 78.53 0.00 3,007.99 kleenex;bath tissue;towels;r 166 10/30/2013 HD Supply Facilities Maintenance, Ltd. ( P- 356292 9125864140 14.48 0.00 3,022.47 drk roller shade 166 10/30/2013 HD Supply Facilities Maintenance, Ltd. ( P- 356292 9125864140 18.54 0.00 3,041.01 shwr dvrtr hdl /assy;washers 166 10/30/2013 Home Depot Credit Services (home9055 P- 357705 1593774 20.86 0.00 3,061.87 various malnt supp 166 11/1/2013 Buckeye Cleaning Centers(buck8411) P- 358648 776669 40.84 0.00 3,102.71 toilet paper;paper towels 166 11/5/2013 Sherwin- Williams Co. (sher41 10) P- 357032 28300 492.78 0.00 3,595.49 paint 166 11/11/2013 Park Supply of America, Inc. (parkl) P- 358604 57887200 27.03 0.00 3,622.52 reversible backsplash 166 11/12/2013 Frattalone's /Metro Ace (frat) P- 358061 016878R 5.72 0.00 3,628.24 cm sckt;toilet blt &scrw;wax 166 11/15/2013 HD Supply Facilities Maintenance, Ltd. ( P- 358859 9126214343 46.67 0.00 3,674.91 thrmst /tape /wx mg /bits /hoc Net Change= 745.45 3,674.91 = Ending Balance = 3040 -46340 Legal Fees 52.50 = Beginning Balance = Net Change =0.00 52.50 = Ending Balance = 3060 -46340 Management Services 21,260.00 = Beginning Balance = 166 11/25/2013 Common Bond Housing (chc) P- 359414 112513mgmt 6,058.00 0.00 27,318.00 mgmt fee 11/13 166 11/30/2013 :PostRecurring Recurring 3- 180493 RC 0.00 3,932.00 23,386.00 R/C CHC PR Mgmt Fee Net Change = 2,126.00 23,386.00 = Ending Balance = 3100 -46340 Protective Services 1,721.97 = Beginning Balance = Net Change =0.00 1,721.97 = Ending Balance = 3210 -46340 Telephone &Telegraph 1,577.77 = Beginning Balance = 166 10/31/2013 Popp.com (popp) P- 357700 992143693 99.91 0.00 1,677.68 phone- 11 /01- 11/30/13 166 11/1/2013 Level One Heve) P- 356321 0365507IN 34.38 0.00 1,712.06 phone -11/13 166 11/2/2013 Comcast(comc3474) P- 357670 87721050501! 25.56 0.00 1,737.62 net - 11/11- 12/10/13 Net Change= 159.85 1,737.62 = Ending Balance = 3460 -46340 Advertising Other 160.28 = Beginning Balance = Net Change =0.00 160.28 = Ending Balance = 3600 -46340 Insurance & Bonds 7,079.44 = Beginning Balance = 166 11/30/2013 :PostRecurring Recurring 3- 180493 RC 720.23 0.00 7,799.67 C of Columbia Heights Ins A Net Change= 720.23 7,799.67 = Ending Balance = 3810 -46340 Electric 21,779.89 = Beginning Balance = 166 11/11/2013 Xcel Energy (xcel) P- 358761 5150441553 1 1,405.47 0.00 23,185.36 E- 10/05-11/02/13 Net Change = 1,405.47 23,185.36 = Ending Balance = 3820 -46340 Water 2,997.22 = Beginning Balance = Net Change =0.00 2,997.22 = Ending Balance = 3830 -46340 Gas 10,087.19 = Beginning Balance = 166 11/7/2013 CenterPoint Energy (cent) P- 358820 55271324 11/ 1,090.18 0.00 11,177.37 g 10/7- 11/6/13 Net Change = 1,090.18 11,177.37 = Ending Balance = 3840 -46340 Refuse Net Change =0.00 3850 -46340 Sewer Net Change =0.00 4000 -46340 Repair & Maint. Services 166 10/21/2013 Adam's Pest Control, Inc.(adam) P- 356002 836905 166 10/30/2013 HD Supply Facilities Maintenance, Ltd. ( P- 356292 9125864140 166 10/30/2013 K.O. Cleaning and Restoration LLC (kocl P- 357031 1591 166 11/1/2013 Kone Inc.(kone) P- 358217 221316176 166 11/14/2013 Drain King, Inc. (drai7740) P- 359717 89745 Net Change = 798.58 4100 -46340 Rents & Leases 166 10/31/2013 Multihousing Credit Control (multl) P- 357627 13100389 Net Change =60.00 4300 -46340 Miscellaneous Charges Net Change =0.00 4315 -46340 PILOT 166 11/30/2013 :PostRecurring Recurring Net Change= 1,028.69 4390 -46340 Taxes & Licenses Net Change =0.00 4500 -46340 Adminstrative Expenses 15.76 0.00 Net Change =0.00 4850 -46340 Interest on Deposits 166 11/30/2013 Sec Dep Interest accrual Net Change =6.50 10,286.90 = Beginning Balance = 1- 180493 RC 1,028.69 0.00 11,315.59 Anoka Cty Property Tax Acci 11,315.59 = Ending Balance = 705.12 = Beginning Balance = 705.12 = Ending Balance = 478.87 = Beginning Balance = 478.87 = Ending Balance = 64.71 = Beginning Balance = 1- 179756 G11 6.50 0.00 71.21 Sec Dep interest accrual 71.21 = Ending Balance = 19,128.10 3,932.00 248.69 = Beginning Balance = 248.69 = Ending Balance = 1,549.35 = Beginning Balance = 1,549.35 = Ending Balance = 31,164.60 = Beginning Balance = 23.32 0.00 31,187.92 extern serv40 /21113 15.76 0.00 31,203.68 traction melt 250.00 0.00 31,453.68 painting 314.50 0.00 31,768.18 elev maint- 11/01 - 11/30/13 195.00 0.00 31,963.18 unclog KS #123 11/14/13 31,963.18 = Ending Balance = 739.97 = Beginning Balance = 60.00 0.00 799.97 screen sew-10 /13 799.97 = Ending Balance = 220.81 = Beginning Balance = 220.81 = Ending Balance = 10,286.90 = Beginning Balance = 1- 180493 RC 1,028.69 0.00 11,315.59 Anoka Cty Property Tax Acci 11,315.59 = Ending Balance = 705.12 = Beginning Balance = 705.12 = Ending Balance = 478.87 = Beginning Balance = 478.87 = Ending Balance = 64.71 = Beginning Balance = 1- 179756 G11 6.50 0.00 71.21 Sec Dep interest accrual 71.21 = Ending Balance = 19,128.10 3,932.00 Parkview Villa South Bank Reconciliation Report 11130/2013 5016464 Balance Per Bank Statement as of 11130/2013 Outstanding Checks Check date Check number 06/18/2013 1788 11/12/2013 1913 Less: Outstanding Checks Payee 10011071 - Johnson kod - K.O. Cleaning and Restoration LLC Reconciled Bank Balance 12102/2013 114,459:11 Amount 232.96 250.00 482.96 113,976.15 Balance per GL as of 11/30/2013 113,97615 Reconciled Balance Per GIL 113,976.15 Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) 0.00 pP io2 ^�o Cleared Items : Cleared Checks Tran fF Notes Amount Dale Cleared Date 10/22/2013 1890 dire - Direct Home Appliance Services 27.59 11/30/2013 1893 kocl - K.O. Cleaning and Restoration LLC 650.00 11/30/2013 10/22/2013 1897 aerotek - Aerotek Professional Services 208.32 11/30/2013 10/29/2013 1899 home7. 11D Supply Facilities Malnlenance, Ltd. 271.87 11130/2013 10/29/2013 1900 mndol - Minnesota Depart of Labor & Industry 31.00 11/3012013 10/29/2013 1901 mndpl - MN Dept of Labor &Industry 15.50 11/30/2013 10/29/2013 1902 xcel - Xcel Energy 2344.43 11130/2013 10/29/2013 1903 adam - Adam's Pest Control, Inc. 23,32 11/30/2013 11/05/2013 1904 cant - Coint Energy 203.40 11/30/2013 11/05/2013 1905 chc - CommonmmonBond Housing 605800 11/30/2013 1110512013 1906 city4054 - City Wide Locksmithing, Inc.. 11/05/2013 1907 colu - City of Columbia Heights 1,777.28 /30/2013 11/05/2013 -Green Lights Recycling Inc 104 11 11130/2013 11/05/2013 Me gree1004 labl - Doreen Jablonske 155.94 11/30/2013 11/05/2013 1909 1910 offi8804 - Office Depot 20.59 11/30/2013 11105/2013 to1a321 -Total Life Security LLC 282.28 11/30/2013 11/05/2013 1911 1912 hame- Hamernick Decorating Center 1,698.18 11/30/2013 11/12/2013 34.38 11/3D/2013 11112/2013 1914 /eve -Level One - Aerotek Professional Services 559.86 11/30/2013 11/1912013 1915 aerotek Parkview Villa South 12/02/2013 Bank Reconciliation Report 11/30/2013 5016464 Cleared Checks Cleared Deposits Tran # Notes Tran# Notes Amount _ Date Cleared Date 11/19/2013 1916 Prat - Frattalone'slMelro Ace 5.72 11/30/2013 11/19/2013 1917 home7 - HD Supply Facilities Maintenance, Ltd, 108.61 11/3012013 11/19/2013 1918 kone - Kone Inc. 314.50 0.00 11130/2013 11/3012013 11/19/2013 1919 multi - Multihousing Credit Control l _ 11/3012013 1113012013 11/19/2013 1920 olse - Olsen Fire Protection, Inc. .341.00 99.91 11130/2013 11/19/2013 1921 Popp - Popp.com 15,410.25 Total Cleared Checks Cleared Deposits Tran # Notes Amount Dale Cleared Date 18,294.00 11/30/2013 11/0512013 408 39.00 11/30/2013 11/06/2013 409 470.58 11/3012013 11/14/2013 410 200.00 1113012.013 11/14/2013 414 646.00 11/3012013 11/18/2013 411 19,649.58 Total Cleared Deposits Cleared Other Items Date Tran # 08/12/2013 RC 982130 08112/2013 RC 982131 Total Cleared Other Items Notes Amount Dale Cleared Returned item t0010628 - 450.00 11/30/2013 Returned item 10010628 •- 250.00 11/3012013 - 700.00 Date 11/29/13 Page 1 Primary Account ©XXXXX ®64249 Enclosures HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONSOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - -- C H E C K I N G A C C 0 U N T S - --- NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE APPI YOU CAN OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING CHECK BALANCES, TRANSACTIONS, NEY AND MUCH MORL'.REYOUTCAN THEPAY iOSBILLS, DDOWNLOAD OR STORES. ANDROID LLERAPPS CREDENTIALS APPLE WILL ALLOW GOGGLE ACCESSPLAY TOA MOBILEBANKING. NORTHEAST PUBLIC FUNDS ACCT OXXXXXO6464 Number of Images Statement Dates 11/01/13 thru 29 11/30/13 Account Number Previous Balance 110,919.78 Days in the Statement Period 117,418 4 Deposits /Credits 19,649.58 Average Ledger Collected 116,798 25 Checks /Debits 15,410.25 Average 1 Electronic Debit 700.0000 Service Charge Interest Paid ,00 Ending Balance 114,458,11 *********************************************** * * * * * * * * * ** * * * * * * * * * * *** * * * * * ** Deposits and Credits Amount Date - Description 18,294.00 - 11/06 DDA REGULAR DEPOSIT 39.00 11/07 DDA REGULAR DEPOSIT 670.58 11/15 DDA REGULAR. DEPOSIT 646.00 11/19 DDA REGULAR DEPOSIT Charges and Debits Amount Date Description 11/15 Xfer to PUB FUND 0001 700.00 Correct rent deposit -Lars Checks in serial order check# Amount Date Check# Amount Date 27.59 11/01 1900 31.00 15,50 t11 /113 1893* 650.00 208.32 11/01 1901 11/04 1902 2,344.43 11/04 1897* 11/04 1899* 271.87 , 11/18 1903 23.32 * Indicates skip in check numbers Date 11/29/13 Page 2 Primary Account QXXXXX @6429 Enclosures - NORTHEAST PUBLIC FUNDS ACCT OXXXXX@6464 (Continued) checks Date in serial order - Check# Amount Date checkH Amount 8 3 110,873.28 203.40 6,058.00 11/19 11/25 1914* - 1915 559.86 11/13 11/15 1905 1906 14.46 11/25 1916 5 72 108.61 11/15 1907 1,777.28 104.11 11/26 11/26 1917 1918 314.50 11/13 1909 155.94 11/26 1919 60.00 11/14- * * * 20.59 11/25 1920 341.00 99.91 11/15 1911 282.28 11/22 1921 11/18 1912 1,698.18 * Indicates skip in check numbers **********************************'************* * * * * * ** * * * * * * * * * * * * * * * * * * * * * * ** Daily Date Balance Section Balance Date Balance Date 11/22 Balance 115,848.80 11/01 110,873.28 11/14 11/15 119,490.13 117,386.69 11/25 114,942.22 11/04 11/06 108,048.66 126,315.07 11/18 115,461.79 11/26 114,459.11 11/07 126,354.07 11/19 13.5,969.30 11/13 119,646.07 11/20 115,948.71 - * * * E N D O F S T A T E M E N T Payment Summary Bank= 166opr AND mm /yy= 11/2013- 11/2013 AND All Checks— Yes AND Include Vol ds =All Checks Check Post Total Bank Check# Vendor Date Month Amount Spr - Parkview Villa 66o South 1903 adam - Adam's Pest Control, [nc. 11/05/2013 11/2013 23.32 166opr - Parkview Villa South 1904 cent - CenterPoint Energy 11/05/2013 11/2013 203.40 1660pr - Parkvlew Villa South 1905 chc - CommonBOnd Housing 11/05/2013 11/2013 6,058.00 166opr - Parkview Villa South 1906 city4054 - City Wide Locksmithing, Inc. 11/05/2013 11/2013 14.46 166opr - Parkvlew Villa South 1907 colu - City of Columbia Heights 11/05/2013 11/2013 1,777.28 166opr - Parkview Villa South 1908 gree1004 - Green Lights Recycling Inc 11/05/2013 11/2013 104.11 1660pr - Parkview Villa South 1909 Jabl - Doreen Jablonske 11/05/2013 11/2013 155.94 166opr - Parkvlew Villa South 1910 off8804 - Office Depot 11/05/2013 11/2013 20.59 166opr - Parkview Villa South 1911 tota321 -Total Life Security LLC 11/05/2013 11/2013 282.28 1660pr - Parkvlew Villa South 1912 home - Hamernick Decorating Center 11/12/2013 11/2013 1,698.18 166opr- Parkview Villa South 1913 kocl- K.O. Cleaning and Restoration LLC 11/12/2013 11/2013 250.00 166opr - Parkview Villa South 1914 leve -Level One 11/12/2013 11/2013 34.38 166opr- Parkview Villa South 1915 aerotek - Aerotek Professional Services 11/19/2013 11/2013 559.86 166opr - Parkvlew Villa South 1916 frat - Fra tta I one's/ Metro Ace 11/19/2013 11/2013 5.72 166opr - Parkview Villa South 1917 home7 - HD Supply Facilities Maintenance, Ltd. 11/19/2013 11/2013 108.61 166opr - Parkview Villa South 1918 kone - Kone Inc. 11/19/2013 11/2013 314.50 166opr - Parkvlew Villa South 1919 multi - Multihousing Credit Control 11/19/2013 11/2013 60.00 166opr - Parkview Villa South 1920 olse - Olsen Fire Protection, Inc. 11/19/2013 11/2013 341.00 11/ 19/ 2013 11/2013 99.91 166opr - Parkvlew Villa South 1921 Popp - Popp.com - .. 12,111.54 7610= H 1 �' m :I Parkview Villa South Financial Statement Overview December 2013 Revenue: Occupancy for the month of December was 82 % 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 over budget (unfavorable) and reflect cost of print ad in Northeaster and North News 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 under budget (favorable); however, this reflects some quarterly billing Electric was slightly over budget (unfavorable) and reflects November billing Gas was slightly over budget (unfavorable) and reflects November 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 over budget (unfavorable). 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) Heating and Cooling Maintenance and Repairs was over budget (unfavorable) and reflects South portion of Boiler repairs and filter replacements Decorating Contract was under budget (favorable) Furniture and Fixtures was over budget (unfavorable) and reflects cost of carpet and vinyl replacement in one unit f -C b b 5 U $ E y 00 > ro 00 m ° N M ry a � Z i I rya ola m w 0 C c rC ry O( N( i lCh. o °o alp to ° ry o „Ie Im b M O P N M N N ry b f o O O O ° N O O IC O C M 1 o�oomn ry „o o;m viorvry No owe n a e N N °o ry IP...... ry m o e m m N n °o O a`V m a n°� rieon H M N ry N n N 0 0 0 0 °O O O O T ti 0 I I rl i I rya ola m w 0 C c rC ry O( N( i lCh. o °o alp to ° ry o „Ie Im b M O P N M N N ry b f o O O O ° N O O IC O C M 1 o�oomn ry „o o;m viorvry No owe n a e N N °o ry IP...... ry m o e m m N n °o O a`V m a n°� rieon H M N ry N n N 0 0 0 0 °O O O O T ti 0 I P b ry e MMo n b n W N n P N (V N as Co z 6 0 ON o O ° O O N O 0 P O O O O m O P N rr a r o ' °o o °O 0 0 0 aC M b m o 0 VI N O O O 0 o m �O m m a n n M M �o b M w O o O O N m T E s v m c o �@ m 0 0 0 0° r0 v�°n ow+ -n+P b N b v N in b b b b i n vbi uPi YI b b b b b b b w N b n b b b� b w b N b y b b u� b N b b b b I P b ry e MMo n b n W N n P N (V N as Co z 6 0 ON o O ° O O N O 0 P O O O O m O P N rr a r o ' °o o °O 0 0 0 aC M b m o 0 VI N O O O 0 o m �O m m a n n M M �o b M w O o O O N m T E s v m c o �@ m 0 0 0 0° r0 v�°n ow+ -n+P b N b v N in b b b b i n vbi uPi YI b b b b b b b w N b n b b b� b w b N b y b b u� b N b b b b O O H Nn 0� O O o m O loll N N i.i to d� d n M IN m N M N N V lm0 Vl N O N , ry °nMOn m '`gin a m'" ry ti .J n m w .r ill N U Z O p O � N eys go$xii?: j ✓O1i, b N N a N > °O °° °O °° °° o o °° °o ° ° M N J W m ^ nm Lq :J n °a O a b 1°V O m M m M M T 0 n n 4i N N N ri V O O H Nn 0� O O o m O loll N N i.i to d� d n M IN m N M N N V lm0 Vl N O N , ry °nMOn m '`gin a m'" ry ti .J n m w .r ill N U Z O p O � N eys go$xii?: j ✓O1i, b N N a N M N J W m ^ nm Lq :J n °a O a b 1°V O m M m M M T 0 n i N N N ri V n N ce m b O M n M N N rJ M V M N ^1 O O N 0 N L! M N M W m ^ a Lq °a °a It m b T U •l O m M m M M T M OO O O N m N n O N ce m b O M n 0 N L! a molwil °ow °o °Om 16°°000 °o .mi m °o m "1 N m m °o °o o o m o �O m b o o ° d o V o o 0 o ry o m � � ° m e o ~ LL y� L n y yy Lo qm d .Ll c " a1 u 1'n 3 M o f u E c ry u c F° c ,y a w tAC v q y w b c ° O {N� £ II i A F A g V O V q A V C W O li £ Q g q d V „ d O P O q O V O LL m V LL q Z Q M 0 LL F (L V O Lo ul M M N W Om O b n N M o m b M N b n N M N N M N b M b n N W M o ow 00 ne b mlo b b b b n n n^ n n °n n n b m m e�e��obW wW m m N O b °a °a It m OO O O O O N n od O M O M N N rJ M V O O O, O O O b 'J ° O ° O N M M q M N N M M W N O O o O O O M m O O p O O O N � N N n M M o o ti ry ° M m M N H n n N ry N N M O O m M 10 1Mp b M a molwil °ow °o °Om 16°°000 °o .mi m °o m "1 N m m °o °o o o m o �O m b o o ° d o V o o 0 o ry o m � � ° m e o ~ LL y� L n y yy Lo qm d .Ll c " a1 u 1'n 3 M o f u E c ry u c F° c ,y a w tAC v q y w b c ° O {N� £ II i A F A g V O V q A V C W O li £ Q g q d V „ d O P O q O V O LL m V LL q Z Q M 0 LL F (L V O Lo ul M M N W Om O b n N M o m b M N b n N M N N M N b M b n N W M o ow 00 ne b mlo b b b b n n n^ n n °n n n b m m e�e��obW wW m m Parkvlew Villa South (166) Balance December 2013 Books = Accrual Dec -13 Assets 109,892.22 10100 Cash Balance 93.00 10200 Petty Cash 729,970.36 10400 Investments 4,144.11 11300 Rent Receivable 116.00 11500 Accounts Receivable Fund Balance 0.00 15510 Prepaid Insurance 821,588.38 25300 Fund Balance 844,215.69 Total Assets 821,588.38 Liabilities 596.43 20200 Accounts Payable 6,492.23 22000 Deposits 12,344.28 22200 Accrued PILOT 1,194.37 22210 Revenue Collected in Advance 22,627.31 Total Liabilities Fund Balance 821,588.38 25300 Fund Balance 821,588.38 Total Fund Balance 844,215.69 Total Liabilities and Fund Balance Parkview, Villa -South (166) 69.70 031% 615.48 0.22% Income Statement 2,208.03 9.70% 12,111.44 4.28% For The Period Ending December 2013 0.00 0.00% 0.00 0.00% Books = Accrual Month to Date o/u Year to Date % Revenue 2,408.69 10.580/. 16,532.79 5.84% 36220 -46340 Gen. Government Rents 22,103.00 97.08% 274,404.23 96.98% 3040 -46340 Legal Fees 495.00 2.17% 5,518.68 1.95% 36225 -46340 Nondwelling Rents 0.00 2,126.00 191.58 163.05 0.00% 9.34% 0.84% 0.72% 5,873.00 25,512.00 1,913.55 1,900.67 2.08% 9.02% 0.68% 0.67% 36290 -46340 Other Miscellaneous Revenue 169.00 0.74% 3,036.11 1.07% 3820 -46340 Water 3830 -46340 Gas - 0.00% - 0.00% 39120 -46340 Recovery Damage City 0.00 0.00 0.00% 0.00% 248.69 1,549.35 0.09% 0.55% 9000 -46340 Repair & Maint. Services 4100 -46340 Rents & Leases 4300 -46340 Miscellaneous Charges 4315 -46340 PILOT 22,767.00 100.000/0 282,959.02 100.000/0 Total Revenue 0.00 0.00% 705.12 0.25% Expenses 142.54 0.63% 621.41 0.22% Personal Services 6.81 0.03% 78.02 0.03% 1000 -46340 Accrued Salaries 3,932.00 17.27% 47,184.00 16.68% 3,932.00 17.27% 47,184.00 16.68% Total Personal Services Supplies 2000 -46340 Office Supplies 69.70 031% 615.48 0.22% 2010 -46340 Minor Equipment 2,208.03 9.70% 12,111.44 4.28% 2160 -46340 Malnt. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 130.96 0.58% 3,805.87 1.35% Total Supplies 2,408.69 10.580/. 16,532.79 5.84% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 52.50 0.02% 3050 -46340 Expert & Professional Services 3060 -46340 Management Services 3100 -46340 Protective Services 3210 -46340 Telephone & Telegraph 0.00 2,126.00 191.58 163.05 0.00% 9.34% 0.84% 0.72% 5,873.00 25,512.00 1,913.55 1,900.67 2.08% 9.02% 0.68% 0.67% 3430 -46340 Advertising Other 3600 -46340 Insurance & Bonds 3810 -96340 Electric 192.00 720.22 1,880.58 0.84% 3.16% 8.26% 352.28 8,519.89 25,065.94 0.12% 3.01% 8.86% 3820 -46340 Water 3830 -46340 Gas 0.00 1,950.23 0.00% 8.57% 2,997.22 13,127.60 1.06% 4.64% 3840 -46340 Refuse 3850 -46340 Sewer 0.00 0.00 0.00% 0.00% 248.69 1,549.35 0.09% 0.55% 9000 -46340 Repair & Maint. Services 4100 -46340 Rents & Leases 4300 -46340 Miscellaneous Charges 4315 -46340 PILOT 3,554.58 0.00 0.00 1,028.69 15.61% 0.00% 0.00% 4.52% 35,517.76 799.97 220.81 12,344.28 12.55% 0.28% 0.08% 4.36% 4390 -46340 Taxes & Licenses 0.00 0.00% 705.12 0.25% 4500 -46340 Administrative Expenses 142.54 0.63% 621.41 0.22% 4850 -46340 Interest on Deposits 6.81 0.03% 78.02 0.03% Total Other Services & Charges 11,956.28 52.52% 137,400.06 48.56% 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 0.00 0/0 18,296.97 80.37% 201,116.85 71.08% 4,470.03 19.63% 81,842.17 28.92% Parkview Villa South (t66) Cash Flow Statement Period = December 2013 Month to Date Revenue 36220 Gen. Government Rents 22,103.00 36225 Nondwelling Rents 495.00 36290 Other Miscellaneous Revenue 169.00 39120 Recovery Damage City Property 0.00 Total Revenue 22,767.00 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 3,932.00 Supplies 0.00 2000 Office Supplies 69.70 2010 Minor Equipment 2,208.03 2160 Malnt. & Construct Materials 0.00 2171 General Supplies 130.96 2175 Food Supplies 0.00 Total Supplies 2,408.69 Other Services & Charges 3050 Expert & Professional Services 0.00 3060 Management Services 2,126.00 3100 Protective Services 191.58 3210 Telephone & Telegraph 163.05 3430 Advertising Other 192.00 3600 Insurance & Bonds 720.22 3810 Electric 1,880.58 3820 Water 0.00 3830 Gas 1,950.23 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repair & Maint. Services 3,554.58 4050 Garage, Labor Burd, 0.00 4100 Rents & Leases 0.00 4300 Miscellaneous Charges 0.00 4315 PILOT 1,028.69 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 142.54 4850 Interest on Deposits 6.81 Total Other Services & Charges 11,956.28 Total Expenses 18,296.97 Parkview Villa South (166) Cash Flow Statement Period = De:cember 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 4,470.03 0.00 0.00 559.00 (24.85) 720.22 (11,069.68) 0.00 (295.19) 1,028.69 341.85 (8,739.96) (4,269.93) Beg Cash End Cash Difference 113,976.15 109,892.22 (4,083.93) 93.00 279.00 (186.00) 729,970.36 729,970.36 - 844,039.51 840,141.58 (4,269.93) Park0ew Villa South (166) General Ledger Period = Dec 2013 Book = Accrual ; Tree = ysi_tb ,. M _ PiPpe Data ^„ Persod[Deacd)#Nop :' " ,'- , ,. Ref4rance ; ., ' ;' ; Dab3�`, ; - -, . CrediE Eialaaca Re...... l 1000 -46340 Accrued Salaries 43,252.00 - Beginning Balance 166 12/31/2013 :PostRecurring Recurring RC 3,932,00 0.00 47,184.00 R/C CHC PR Mgmt Fee Net Change= 3,932.00 47,184.00 = Ending Balance = 2000 -46340 Office Supplies 545.78 = Beginning Balance= 166 11/5/2013 Office Depot (ogi8804) 6.81617E +11 5.91 0.00 551.69 post-Its-31% 166 11/5/2013 Office Depot(oHi8804) 6.81617E +11 11.96 0.00 563.65 stamper -31% 166 11/15/2013 Office Depot(offi8804) 6.83465E +11 24.95 0.00 588.60 toner; notebooks;JournaI cas( 166 11/26/2013 Office Depot (Offi8804) 6.84274E +11 6.03 0.00 594.63 candy;heavy weight plastic 166 11/26/2013 Office Depot (ofn8804) 6.84273E +11 11.34 0.00 605.97 cndy;pens;crrctn tape;Odrs;( 166 12/3/2013 OfOCe Depot(offi8804) 6.83465E +11 3.76 0.00 609.73 coffee 166 12/30/2013 Eells petty cash reimbursement C2 5.75 0.00 615.48 US Postal - Eels petty cash Net Change =69.70 615.48 = Ending Balance = 2010 -46340 Minor Equipmenmt 9,903.41 = Beginning Balance= 166 11/27/2013 Hamernlck Decorating Center(hame) CG313831 2,208.03 0.00 12,111.44 carpet Installation #215 Net Change = 2,208.03 12,111.44 = Ending Balance = 2171 -46340 General Supplies 3,674.91 = Beginning Balance = 166 12/6/2013 Home Depot Credit Services (home9055) 4194484 26.53 0.00 3,701.44 fan /utility heaters-31% 166 12/1312013 HD Supply Facilities Maintenance, Ltd. (homy 9126725488 2.96 0.00 3,704.40 door stops 166 12/13/2013 HD Supply Facilities Maintenance, Ltd, (home 9126725488 56.98 0.00 3,761.38 2 -bulb ballasts; batteries 166 12/17/2013 Frattalone's /Metro Ace (frat) 017197R 20.81 0.00 3,782.19 pig kit;fuse plgs;drill bits :no 166 12/17/2013 HD Supply Facilities Maintenance, Ltd. (he., 9126774975 23.68 0.00 3,805.87 light bulbs -31% Net Change= 130.96 3,805.87 = Ending Balance = 3040 -46340 Legal Fees 52.50 = Beginning Balance = Net Change =0.00 52.50 = Ending Balance = 3060 -46340 Management services 23,386.00 = Beginning Balance = 166 12/28/2013 Common6ond Housing (chc) 122813ni 6,058.00 0.00 29,444.00 mgmt fee 12/13 166 12/31/2013 :PostRecurring Recurring RC 0.00 3,932.00 25,512.00 R/C CHC PR Mgmt Fee Net Chang.= 2,126.00 25,512.00 = Ending Balance = 3100 -46340 Protective Services 1,721.97 = Beginning Balance = 166 12/3/2013 Total Life Security LLC (tota321) 2278 191.58 0.00 1,913.55 fire ext malnt 1114/13 Net Change= 191.58 1,913.55 = Ending Balance = 3210.46340 Telephone & Telegraph 1,737.62 = Beginning Balance = 166 11/30/2013 Popp.com (POPP) 992150290 100.48 0.00 1,838.10 phone -31% 11/1- 12/31/13 166 12/1/2013 Level One (love) 037233SIN 34.38 0.00 1,872.48 phone -12/13 166 12/2/2013 Comcast(comc3422) 8772105050196 25.56 0.00 1,898.04 Internet -31% 12/11/13 -1/10 166 12/2/2013 Comcast (comc3422) 8772105050196 2.48 0.00 1,900.52 late fee-31% 12/2/13 166 12/2/2013 Con-cast (comc3422) 8772105050196. 015 0.00 1,900.67 cable tv franchise fee -31 % Net Change= 163.05 1,900.67 = Ending Balance = 3430 -46340 Advertising Other 160.28 = Beginning Balance = 166 12/19/2013 Northeaster and North News (nort2844) 79304 192.00 0.00 352.28 classified ad 12/18/13 Net Change= 192.00 352.28 = Ending Balance = 3600 -46340 Professional Liability Insurance 7,799.67 = Beginning Balance = 166 12/31/2013 :PostRecurring Recurring RC 720.22 0.00 8,519.89 C of Columbia Heights Ins A( Net Change= 720.22 8,519.89 = Ending Balance = 3810 -46340 Electric 23,185.36 = Beginning Balance = 166 12/11/2013 Xcel Energy (xcel) 5150441553 12/ 1,880.58 0.00 25,065.94 a 11/1-12/6/13-31% Net Change= 1,880.58 25,065.94 = Ending Balance = 3820 -46340 Water 2,997.22 = Beginning Balance = Net Change =0.00 2,997.22 = Ending Balance = 3830 -46340 Gas 11,177.37 = Beginning Balance = 166 12/9/2013 CenterPoint Energy (cent) 55271324 12/09 1,933.88 0.00 13,111.25 g 11/6- 1215/13 166 12/9/2013 Center-Point Energy (cent) 55271324 12/09 16.35 0.00 13,127.60 late fee 12/9/13 Net Change= 1,950.23 13,127.60 = Ending Balance = 3840 -46340 Garbage & Trash Removal 248.69 = Beginning Balance = Net Change =0.00 248.69 = Ending Balance = 3850 -46340 Sewer Utilities 1,549.35 = Beginning Balance = Net Change =0.00 1,549.35 = Ending Balance = 4000 -46340 Repair & Maint. Services 31,963.18 = Beginning Balance = 166 10/31/2013 All Metro Lawn & Snow, LLC (alIm2138) 2826 117.94 0.00 32,081.12 grounds malnt 10/1- 11/201: 166 10/31/2013 LBP Mechanical, Inc (Ibpm) W19485 72128 0.00 32,804.40 holler repair- 09/26 - 10/16/1: 166 11/12/2013 K.O. Cleaning and Restoration LLC (kocl) 1597 750.00 0.00 33,554.40 painting #215 166 11/30/2013 All Metro Lawn & Snow, LLC (atIM2138) 2900 200.92 0.00 33,755.32 grounds maint 11/20- 30/201 166 11/30/2013 LBP Mechanical, Inc (Ibpm) W19634 189.74 0.00 33,945.06 zone valve mp-11 /25- 12/03, 166 12/1/2013 Kone Inc, (kone) 221339109 314.50 0.00 34,259.56 maint- 12/01 - 12/31/13 166 12/6/2013 HD Supply Facilities Maintenance, Ltd. (hom,912678401 42.09 0.00 34,301.65 Ice melt 166 12/6/2013 HD Supply Facilities Maintenance, Ltd. (horm 912678401 18.91 0.00 34,320.56 Ice melt 166 12/10/2013 Adam's Pest Control, Inc.(adam) 845202 23.32 0.00 34,343.88 pest control -31% 11/25/13- 166 12/13/2013 HD Supply Facilities Maintenance, Ltd (homi9126725488 8.79 0.00 34,352.67 heat thermostat 166 12/16/2013 High Pro0le Grounds Maintenance, Inc. (high 28443 158.10 0.00 34,510.77 snow removal 1/14 -31% 166 12/17/2013 HD Supply Facilities Maintenance, Ltd. (hom(9126774975 18.91 0.00 34,529.68 Ice melt -31 166 12/19/2013 LBP Mechanical, Inc (Ibpm) W19663 705.25 0.00 35,234.93 heat repairs 11 /25- 12/13/13 166 12/23/2013 LBP Mechanical, Inc (Ibpm) W19689 282.83 0.00 35,517.76 heat main- rplcmnt filters -65 Net Change= 3,554.58 35,517.76 = Ending Balance = 4100 -46340 Rents & Leases 799.97 = Beginning Balance = Net Change =0.00 799.97 = Ending Balance = 4300 -46340 Miscellaneous Charges 220.81 = Beginning Balance = Net Change =0.00 220.81 = Ending Balance = 4315 -46340 PILOT 11,315.59 = Beginning Balance = 166 12/31/2013 :PostRecurring Recurring RC 1,028.69 0.00 12,344.28 Anoka Cty Property Tax Accr Net Change = 1,028.69 12,344.28 = Ending Balance = 4390 -46340 Taxes & Licenses 705.12 = Beginning Balance = Net Change =0.00 705.12 = Ending Balance = 4500 -46340 Administrative Expenses 478.87 = Beginning Balance = 166 12/30/2013 bells petty cash reimbursement C2 87.25 0.00 566.12 Dollar Tree /Rainbow/Target/ 166 12/31/2013 Commoneood Housing (chc) 123113manual ( 55.29 0.00 621.41 manual ck cost 2013 Net Change= 142.54 621.41 = Ending Balance = 4850 -46340 Interest on Deposits 71.21 = Beginning Balance = 166 12/31/2013 Sec dep interest accrual G)1 6.81 0.00 78.02 Sec dep Interest accrual Net Change =6.81 78.02 = Ending Balance = 22,228.97 3,932.00 Payment Summary Bank= 166opr AND mm /yy= 12/2013- 12/2013 AND All Checks =Yes AND Include Voids =All Checks Check Post Total CheckA 166opr - Parkview Villa E 192: buck8411 - Buckeye Cleaning Centers 12/03/201 12/2013 40.84 166opr - Parkview Villa E 192, cent - CenterPoint Energy 12/03/201 12/2013 1,090.18 166opr - Parkview Villa E 192! chc - CommonBond Housing 12/03/201 12/2013 6,058.00 166opr - Parkview Villa E 1921 Comc3474 - Comcast 12/03/201 12/2013 25,56 166opr - Parkview Villa E 192: drai7740 - Drain King, Inc. 12/03/201 12/2013 195.00 166opr - Parkview Villa E 1921 hame - Hamernick Decorating Center 12/03/201 12/2013 1,800.18 166opr - Parkview Villa E 1921 home? - HD Supply Facilities Maintenance 12/03/201 12/2013 127.31 166opr - Parkview Villa E 193( off18804 - Office Depot 12/03/201 12/2013 18.60 166opr - Parkview Villa E 193: parkl - Park Supply of America, Inc. 12/03/201 12/2013 27.03 166opr - Parkview Villa E 193: aerotek - Aerotek Professional Services 12/10/201 12/2013 364.56 166opr - Parkview Villa E 193: home? - HD Supply Facilities Maintenance 12/10/201 12/2013 46.67 166opr - Parkview Villa E 193, leve - Level One 12/10/201 12/2013 34.38 166opr - Parkview Villa E 193! offi8804 - Office Depot 12/10/201 12/2013 20.21 166opr - Parkview Villa E 1931 tota321 - Total Life Security LLC 12/10/201 12/2013 191.58 166opr - Parkview Villa E 193: xcel - Xcel Energy 12/10/201 12/2013 1,405.47 166opr - Parkview Villa E 1931 adam - Adam's Pest Control, Inc. 12/17/201 12/2013 23.32 166opr - Parkview Villa E 193! allm2138 - All Metro Lawn & Snow, LLC 12/17/201 12/2013 318.86 166opr - Parkview Villa E 194( home9055 - Home Depot Credit Services 12/17/201 12/2013 20.86 166opr - Parkview Villa E 194: kocl - K.O. Cleaning and Restoration LLC 12/17/201 12/2013 750.00 166opr - Parkview Villa E 194: Ibpm - LBP Mechanical, Inc 12/17/201 12/2013 913.02 166opr - Parkview Villa E 194: off18804 - Office Depot 12/17/201 12/2013 24.95 166opr - Parkview Villa E 194, popp - Popp.com 12/17/201 12/2013 100.48 166opr - Parkview Villa E 194! sher4110 - Sherwin - Williams Co. 12/17/201 12/2013 492.78 166opr - Parkview Villa E 194( chc - CommonBond Housing 12/30/201 12/2013 6,058.00 166opr - Parkview Villa E 194'. comc3422 - Comcast 12/30/201 12/2013 28.19 166opr - Parkview Villa E 1941 frat - Frattalone's /Metro Ace 12/30/201 12/2013 20.81 166opr - Parkview Villa E 194! hame - Hamernick Decorating Center 12/30/201 12/2013 3,492.19 166opr - Parkview Villa E 1951 high8236 - High Profile Grounds Maintena 12/30/201 12/2013 158.10 166opr - Parkview Villa E 195: kone - Kone Inc. 12/30/201 12/2013 314.50 166opr - Parkview Villa E 195: Ibpm - LBP Mechanical, Inc 12/30/201 12/2013 988.08 166opr - Parkview Villa E 195: nort2844 - Northeaster and NorthNews 12/30/201 12/2013 192.00 166opr - Parkview Villa E 195, offi8804 - Office Depot 12/30/201 12/2013 35.24 166opr - Parkview Villa E 195! xcel - Xcel Energy 12/30/201 12/2013 1,880.58 27,517.93 Parkview Villa South Bank Reconciliation Report 12/31/2013 5016464 Balance Per Bank Statement as of 12/3112013 Outstanding Checks Check date Check number Payee 06/18/2013 1786 10011071- Johnson 12/30/2013 1946 chc - CommonBond Housing 12130/2013 1947 comc3422- Comcast 12/30/2013 1g48 fret - Fratlalone's/Metro Ace 12/30/2013 1949 hams - Hamernick Decorating Center 12/30/2013 1950 high8236 - High Profile Grounds Maintenance, Inc. 12/30/2013 1951 kone - Kone Inc. 12/30/2013 1952 Ibpm - LBP Mechanical, Inc 12/30/2013 1053 nort2844 - Northeaster and NodhNews 12/30/2013 1954 ofl8804. Office Depot 12/30/2013 1955 xcel - Xcel Energy Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 1213112013 Reconciled Balance Per GIL 123,292.87 Amount 232.96 6,058.00 28.19 20.81 3,492.19 158.10 314.50 988.08 192.00 35.24 1,880.58 13,400,65 109,892.22 01/0912014 109,892.22 109,892.22 Difference (Reconciled Bank Balance And Reconciled Balance Per GIL) 0,00 Cleared Items : Cleared Checks Date Tran N Notes Amount Date Cleared 11/12/2013 1913 kocl - K.O. Cleaning and Restoration LLC 250.00 12131/2013 12/03/2013 1922 aerotek - Aorotek Professional Services 260.40 12/31/2013 1210312013 1923 buck8411 - Buckeye Cleaning Centers 40.84 12/31/2013 12/03/2013 1924 cent- CenlerPoinl Energy 1,090.18 12/3112013 12/03/2013 1925 chc - CommonBond Housing 6,068.00 12/3112013 12/03/2013 1926 comc3474- Comcast 25.56 12/3112013 12/03/2013 1927 dra17740 - Drain King, Inc. 195.00 12/31/2013 12/03/2013 1928 home - Hamernick Decorating Center 1,800.18 12/31/2013 12/03/2013 1929 home7 - HD Supply Facilities Maintenance, Ltd. 127.31 12131/2013 12/03/2013 1930 offi8804 - Office Depot 18.60 12/31/2013 Total Cleared Checks 14,600.24 Cleared Deposits Dale Tran # Parkview Villa South 415 01/0912014 415 12/05/2013 Bank Reconciliation Report 12/1012013 417 12/20/2013 419 12/31/2013 5016464 Cleared Checks Date Tran # Notes Amount Date Cleared 1210312013 1931 park/ - Park Supply of America, Inc. 27.03 12/31/2013 12/10/2013 1932 aerotek- Aerotek Professional Services 364.56 12/31/2013 12110/2013 1933 home7 - HD Supply Facilities Maintenance, Ltd. 46.67 12/31/2013 12/1012013 1934 lave - Level One 34.38 12/31/2013 1211012013 1935 offi8804 -Office Depot 20.21 12/31/2013 12/10/2013 1936 tota321 - Total Life Security LLC 191.58 1213112013 12/10/2013 1937 xcel - Xcel Energy 1,405.47 12/31/2013 1211712013 1938 adam - Adam's Pest Control, Inc. 23.32 12/31/2013 12/17/2013 1939 allm2138 -All Metro Lawn & Snow, LLC 318.86 12/31/2013 12/17/2013 1040 home9055 - Home Depot Credit Services 20.86 12/31/2013 12/17/2013 1941 kocl - K.O. Cleaning and Restoration LLC 750.00 12131/2013 12/17/2013 1942 Ihpm - LSP Mechanical, Inc 913.02 12/31/2013 12/17/2013 1943 offi8804 - Office Depot 24.95 12/3112013 12/17/2013 1944 Popp - Popp.com 100.48 12/31/2013 12/17/2013 1945 sher4110- Sherwin-Williams Co. 492.78 12/31/2013 Total Cleared Checks 14,600.24 Cleared Deposits Dale Tran # 12104/2013 415 12/04/2013 415 12/05/2013 416 12/1012013 417 12/20/2013 419 Total Cleared Deposits Cleared Other Items Date Tran # 12104/2013 RC 1044953 12180/2013 JE 183308 Total Cleared Other Items Notes Amount Date Cleared 18,561.00 12/31/2013 620.00 12/31/2013 3,017.00 12131/2013 1,117.00 12/3112013 646.00 1213112013 23,961.00 Notes Amount Date Cleared Returned item t0010630 - 620.00 12131/2013 Petty cash refund - Ells 93.00 1213112013 527.00 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA SOUTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G Date 12/31/13 Primary Account Enclosures A C C O U N T S - - -- Page 1 @XXXXX @6464 30 NOW YOU CAN BANK ANYWHERE, ANYTIME BY USING YOUR SMARTPHONE OR TABLET'S WEB BROWSER OR OUR MOBILE BANKING APP! YOU CAN CHECK ACCOUNT BALANCES, VIEW RECENT TRANSACTIONS, PAY BILLS, TRANSFER MONEY AND MUCH MORE. YOU CAN DOWNLOAD THE iOS OR ANDROID APPS FROM THE APPLE OR GOOGLE PLAY APP STORES. YOUR NETTELLER CREDENTIALS WILL ALLOW ACCESS TO MOBILE BANKING. NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX @6464 Previous Balance 114,459.11 5 Deposits /Credits 24,054.00 26 Checks /Debits 15,220.24 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 123,292.87 Number of Images 30 Statement Dates 12/01/13 thru 12/31/13 Days in the Statement Period 31 Average Ledger 125,503 Average Collected 124,725 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Deposits and Credits Amount Date Date Description Date 12/11 Amount 12/04 DDA REGULAR DEPOSIT 19,181.00 12/05 DDA REGULAR DEPOSIT 3,017.00 12/10 DDA REGULAR DEPOSIT 1,117.00 12/20 DDA REGULAR DEPOSIT 646.00 12/30 DDA REGULAR DEPOSIT 93.00 *********************************************** * ** * * * * * * * * * * * * * * * * * * * * * * * * * * ** Charges and Debits Date Description 12/09 RETURN ITEM DEBIT Amount 620.00 *********************************************** * * * * * ** * * * * * * * * * * * * * * * * * * * * * * ** Checks in serial order Check# Amount Date Check# Amount Date 12/11 1913 250.00 12/06 1925 6,058.00 12/09 1922* 260.40 12/12 1926 25.56 12/10 1923 40.84 12/11 1927 195.00 12/11 1924 1,090.18 12/09 1928 1,800.18 * Indicates skip in check numbers NORTHEAST PUBLIC FUNDS ACCT Checks in serial order Date Check# 12/11 1929 12/17 1930 12/11 1931 12/16 1932 12/17 1933 12/17 1934 12/17 1935 12/17 1936 12/17 1937 * Indicates skip in @XXXXX @6464 Amount 127.31 18.60 27.03 364.56 46.67 34.38 20.21 191.58 1,405.47 check numbers Date 12/23 12/24 12/23 12/24 12/24 12/31 12/24 12/24 Date 12/31/13 Primary Account Enclosures (Continued) Check# 1938 1939 1940 1941 1942 1943 1944 1945 Page 2 @XXXXX @6464 30 Amount 23.32 318.86 20.86 750.00 913.02 24.95 100.48 492.78 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Date Balance Section Balance Date Balance Date Balance 12/01 114,459.11 12/10 12/11 128,994.69 127,305.17 12/20 12/23 125,844.14 125,799.96 12/04 12/05 133,640.11 136,657.11 12/12 127,279.61 12/24 123,224.82 12/06 130,599.11 12/16 12/17 126,915.05 125,198.14 12/30 12/31 123,317.82 123,292.87 12/09 127,918.53 * * * E N D O F S T A T E M E N T * * * Parkview Villa Resident Council Meeting Minutes from Nov 11 , 2013 The Meeting was called to order at 7PM. Pledge of Allegiance was said Last month's Minutes were read by DeAnn Kunshier. Sunshine Club report given by Cecelia Rothbauer, a card was sent to Rheta Nelson on the death of her brother, DeAnn Kunshier after her terrible fall, and one to Lois C after the death of her brother. We are still looking for a volunteer to take over the Sunshine club in January 2014. Bingo report by Jackie Ovshak Received from Resident Council $120.00 Treasure report given by Rose Lash checking account as of Nov 1, 2013 balance $1616.10. Deposit from laundry $870.05, balance $2292.15 Safety and security meeting Monday Nov 18, at 6 -7pm with City, management, and police dept. Starting 12 -15 of Nov Aeon will be here repairing walls, tearing molding off. Then on Thurs the 15`h there will be several shifts of volunteers painting the walls. This is for the North side only; the South side is not affected. 32 Ballots were collected and counted for either 1. Leave the current council in place 2.hold new election. 28 counted to leave in place current council, 2 to not hold anything, 2 for a new election. Current council will remain in place until we see when Aeon takes over and what they will want in place. When we have invited guest here and we serve refreshments. Please let them go first in line. We always have enough for everyone. This needs to stopl Christmas Dinner was discussed, we may not have one this year, and we will let everyone know when things have been finalized. Drawing was held $5.00 was given to the following Candl S, Ardelle S, Kathy 0, and Dorothy L. Meeting adjourned at 8pm. Parkview Villa Resident Council Meeting Minutes from Dec .9 , 2013 The Meeting was called to order at 7PM. Pledge of Allegiance was said Last month's Minutes were read by DeAnn Shirley read the treasury report for December 2013 Beginning balance $2,533. Ending balance $1,563.00 after expenses paid out for Dec. Party, entrainment, Nurse, and Bingo Sunshine Club report given by Cecelia Rothbauer. . Diann Powell is the new coordinator for the Sunshine Club. Bingo report given by Jackie Ovshak. MANAGER HEIDI REPORT. If you see a NON resident in the building and they are not with whom they are visiting, the Office needs to know. I will need to speak to that Resident. They are not allowed to roam the building alone. 2. Volunteers will be coming before the end of the month to finish the painting with Aeon. 1 will let you all know when this will take place. 3. the dog bite situation is being taken care of. The office was notified the day after the incident. I am taking the steps to handle this. 4. REMINDER My office door is open at all times for you to talk to me. Anything we discuss is held in confidence. S. I appreciate the prompt attention when you receive a notice to come into the office to sign anything Thank you. 6. Jenn will be back tomarrow. Welcome her back with a BIG smile.. Ginger is done as of today. She will continue working with CommonBond out in St. Paul. YEAH Calendar this month is wrong several items were left off Please let the office know if you see things wrong. Discussing about the Hairdresser charges to much, different charge for different people Shirley will investigate this. Bingo ideas are being looked at in order to save money, we are noftaking in as much money as we were a year ago. Drawing for $5.00 winners were Ron B, Kathy D, Joan B, and Gerry N. mtg adjourned 8:15 Pry COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meeting of: January 28, 2014 AGENDA SECTION: Business ORIGINATING EXECUTIVE NO: 11 DEPARTMENT: HRA DIRECTOR 2013 2014 APPROVAL ITEM: Resolution 2014 -04 Extension of BY: Scott Clark BY: CommonBond Management Contract DATE: January 22, 2014 $19,583 BACKGROUND: The City's Housing and Redevelopment Authority (HRA) has held CommonBond Housing under contract for management of Parkview Villa North and South since 2008. Since the Memorandum of Understanding was signed in May of 2011 with Aeon for the sale of the subject property CommonBond has been on a year to year contract. The contract under review would run from February 1, 2014 until January 31, 2015. There is a 60 day out period when the sale to Aeon occurs. As part of this review, Aeon is seeking a 2% increase for a total contract amount of $239,700. Historically, they had a 5% increase in 2012; including the proposed increase, the contract will average out as a 1 % increase over the subject 7 years (2008- 2014). Staff views that this is a modest increase and coupled with satisfaction with performance staff is recommending the increase as proposed. A history of the contract amounts follow: RECOMMENDATION: Staff recommends an extension of the contract and resolution as written, which includes the 2% increase. 2008 2009 2010 2011 2012 2013 2014 Monthly $18,650 $18,650 $18,650 $18,650 $19,583 $19,583 $19,975 Compensation Monthly $6,570 $6,570 $6,570 $6,570 $6,900 $6,900 $7,038 Management Fee Monthly $12,080 $12,080 $12,080 $12,080 $12,683 $12,683 $12,937 Payroll Expenses Annual $223,800 $223,800 $223,800 $223,800 $234,996 $234,996 $239,700 Compensation %Increase 0 0 0 0 5% 0 2% Other Terms No 60 -day 60 -day increases notice notice for first 5 based on based on years Aeon sale Aeon sale RECOMMENDATION: Staff recommends an extension of the contract and resolution as written, which includes the 2% increase. RECOMMENDED MOTION: Motion: Move to waive the reading of Resolution 2014 -04 there being ample copies available to the public. Motion: Move to Adopt Resolution 2014 -04 Extension of CommonBond Housing Management Contract Until January 31, 2015 For Management of Parkview Villa North and South rtesuiuuuii cu iv -v�r HRA ACTION: HRA RESOLUTION 2014 -04 EXTENSION OF COMMONBOND HOUSING MANAGEMENT CONTRACT UNTIL JANUARY 31, 2015 FOR MANAGEMENT OF PARKVIEW VILLA NORTH AND SOUTH WHEREAS, on January 23, 2008 the City of Columbia Heights's Housing and Redevelopment Authority (HRA) approved a management agreement with CommonBond Housing (CommonBond) which included a provision for a five -year contract, and WHEREAS, the Department of Housing and Urban Development (HUD) denied the ability of the I -IRA to enter into a five -year contract based on a previously approved 1969 Annual Contributions Contract which limits all contracts to two years, and WHEREAS, in order to meet the spirit and intent of the originally approved five year contract both HUD and the HRA agreed to a management contract term of an initial two year period with three one -year extensions, and WHEREAS, this language is memorialized in Section 1.3 of the final and approved contract approved by the HRA on April 22, 2008, and WHEREAS, a new contract period is desired with the understanding that the sale of the subject property is probable in 2014, and WHEREAS, the HRA is satisfied by the performance and competence of CommonBond and desire to extend the subject term until the time of the sale; NOW THEREFORE BE IT RESOLVED, 1) The HRA approves a one -year management contract extension running from February I, 2014 to January 31, 2015 2) Section 9.1 shall be amended to read in part, "... The compensation which the Agent shall be entitled to receive for all services performed under this Agreement shall be a flat fee of $19,975 per month; which consists of $7,038 per month as a management fee and $12,937 per month for payroll related expenses...." 3) Section 10.2 shall be amended to read, "This Agreement shall be terminated upon the sale of the Premises or in the case of building demolition caused by natural or man -made causes. In the case of sale, the Owner retains the right to give the Agent a 60 calendar day notice of termination at any point in the sales process." 4) All other provisions of the contract dated April 22, 2008 Management Agreement between CommonBond and the HRA remains in place. Passed this 28'x' of January 2014.. MOTION BY: SECONDED BY: Chair Attest by: Shelley Hanson, Recording Secretary COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meeting of: January 28, 2014 AGENDA SECTION: Business Items ORIGINATING EXECUTIVE NO: 12 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Security BY: Scott Clark BY: DATE: January 22, 2014 BACKGROUND: At the October 2013 HRA meeting there was an extensive discussion about security issues at Parkview Villa. After that meeting the Community Development staff met with the Police Department and CommonBond Management, and from that meeting, a listening session was held with the residents on October 18, 2013. At the last mentioned meeting, a detailed discussion was held about issues that should be brought to the attention of management immediately and those that should be handled by the Police. It was obviously emphasized that at any time a resident feels threatened in a situation that a 911 call should be made. After reviewing the past history of calls at Parkview, and verbal information, staff is recommending that formal security is not warranted. However, staff is of the opinion that productive alternative is to form a Neighborhood Watch Group. The Police Department is ready to meet and immediately start the program. RECOMMENDATION: Have staff continue to work with the Management and the Resident Council to determine their desire to form a Neighborhood Watch Group. RECOMMENDED MOTION: No formal motion. Attachments: 201 HRA ACTION: PARKVIEW VILLA 965 40 AVE NE Address Apartment Date _Report Time _AssignecOffense_Description 96540 AVE NE 01/03/13 1700 UNWANTED PERSON 965 40 AVE NE 01/03/13 1700 TRESPASS NOTICE 965 40 AVE NE 02/18/13 1446 SUSPICIOUS - PHONE CALLS 965 40 AVE NE 02/22/13 2002 SUSPICION - ALL OTHER ACTIVITY 965 40 AVE NE 04/29/13 2258 CRIM AGNST ADM JUST -MS -GIVE FLSE NAM POL 965 40 AVE NE 04/29/13 2258 COMPLAINTS - ALL OTHER 965 40 AVE NE 05/06/13 2317 CHECK WELFARE 965 40 AVE NE 05106/13 2317 SUICIDE THREAT (NO ACTUAL ATTEMPT) 96540 AVE NE 05/05/13 1733 SUSPICIOUS - PERSON 965 40 AVE NE 05/05/13 1733 EXTRA PATROL 965 40 AVE NE 03/20/13 0219 CHECK WELFARE 96540 AVE NE 06/21/13 1250 BUSINESS ASSIST 965 40 AVE NE 06/21/13 1250 TRESPASS NOTICE 965 40 AVE NE 08105/13 1031 SUSPICION - ALL OTHER ACTIVITY 965 40 AVE NE 08/08/13 1600 BUSINESS ASSIST 965 40 AVE NE 08/26113 2013 CHECK WELFARE 965 40 AVE NE 08/26/13 2013 SOCIAL SERVICES REFERRALS 965 40 AVE NE 08/29113 1634 PUBLIC ASSIST 965 40 AVE NE 09/05/13 0445 OC - NOISE RESIDENTIAL 965 40 AVE NE 09/17/13 1500 BUSINESS ASSIST 965 40 AVE NE 09117/13 1500 TRESPASS NOTICE 965 40 AVE NE 10102/13 1412 ASLT 5 -MS -FEAR BOD HRM- HANDS - ETC - ADLT -ACQ 965 40 AVE NE 10/06/13 1613 OC - NOISE RESIDENTIAL 965 40 AVE NE 10/07/13 1403 ASLT 3- SUBSTANTIAL INJURY -HANDS ETC - ADLT -ACQ 965 40 AVE NE 10107/13 1403 PROP DAMAGE -MS- PRIVATE -UNK INTENT 965 40 AVE NE 10/07113 1403 EMERGENCY MEDICAL COMMITMENT /HOLD 96540 AVE NE 10/09/13 1425 SOCIAL SERVICES REFERRALS 96540 AVE NE 10/20/13 0215 OC - NOISE RESIDENTIAL 965 40 AVE NE 10/27/13 1846 SUICIDE THREAT (NO ACTUAL ATTEMPT) 96540 AVE NE 11/05/13 1322 ASSIST OTHER LAW ENFORCEMENT AGENCY 96540 AVE NE 11/05/13 1322 DETOXTRANSPORT - ADULT 96540 AVE NE 11/05/13 1322 TRESPASS NOTICE 965 40 AVE NE 12/04/13 1452 OC - NOISE RESIDENTIAL 965 40 AVE NE 12/13/13 0538 ASSIST OTHER LAW ENFORCEMENT AGENCY 965 40 AVE NE 12/14/13 1745 OC - NOISE RESIDENTIAL 965 40 AVE NE 12116/13 0256 EMERGENCY MEDICAL COMMITMENT /HOLD 965 40 AVE NE 12/18/13 2016 CHECK WELFARE 965 40 AVE NE 12/18/13 2016 DOMESTIC - FAMILY 965 40 AVE NE 09/17/13 0015 BUSINESS ASSIST 965 40 AVE NE 09117/13 0015 UNWANTED PERSON 965 40 AVE NE 12/26/13 0519 CIVIL DISPUTE 965 40 AVE NE 12126113 0519 FOLLOW UP 965 40 AVE NE 12/26/13 1231 THEFT -500 OR LESS MS PERSON -OTHER PROPERTY 965 40 AVE NE 09/17113 0936 DEATH (DOA) 965 40 AVE NE 12/23/13 0002 CHECK WELFARE 965 40 AVE NE 12/23/13 0002 SOCIAL SERVICES REFERRALS 965 40 AVE NE 07/12/13 1037 NEIGHBORHOOD DISPUTE 965 40 AVE NE 12/03/13 1300 DOMESTIC ESCORT nna0 419419n4d Pann4 PARKVIEW VILLA 965 40 AVE NE Address Anartmant Date—Report 965 40 AVE NE 04/06/13 965 40 AVE NE 03/13/13 965 40 AVE NE 03/13/13 965 40 AVE NE 06/24/13 965 40 AVE NE 05/12113 965 40 AVE NE 10115/13 965 40 AVE NE 09/06/13 965 40 AVE NE 02/23/13 965 40 AVE NE 08/11/13 Time_AssignecOffen se_Description 0948 THEFT - 501 - 2500- FE -FRM PERSON -0TH PROP 1930 CHECK WELFARE 1930 EMERGENCY MEDICAL COMMITMENT /HOLD 1844 CHECK WELFARE 0353 NEIGHBORHOOD DISPUTE 1212 THEFT -MS- IDENTITY THEFT-UNK LOSS 0358 OC - NOISE RESIDENTIAL 1821 OC - NOISE RESIDENTIAL 2205 SUSPICION - ALL OTHER ACTIVITY ,In 1 . - n COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA) Meeting of: January 28, 2014 AGENDA SECTION: Public Hearing ORIGINATING EXECUTIVE No. 13 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: PHA Plan Certification BY: Scott Clark BY: DATE: January 22, 2014 BACKGROUND: Based on recent HUD rules the HRA only has to approve a Public Housing Agency Plan every five years (this includes both narrative goals and a five year capital improvement plan). However, every year a resolution certifying compliance with the document must occur. The PHA Plan that was formerly amended at the last meeting, is attached. In addition, the Plan was formally advertised and held for public review (with no comments) for the statutory period of time. For the HRA's information, it is likely that the 2014 stated capital improvements will come back to the Board for amendments, depending on the schedule of the sale to Aeon. RECOMMENDATION: Staff recommends the motions as written. RECOMMENDED MOTION: Motion: Move to waive the reading of Resolution 2014 -05 there being ample copies available to the public. Motion: Move to adopt Resolution 2014 -05 Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) Confirming Approval of the 2014 Public Housing Agency Certifications of Compliance With the PHA Plans and Related Regulations. HRA ACTION: HRA RESOLUTION 2014 -05 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) CONFIRMING APPROVAL OF THE 2014 PUBLIC HOUSING AGENCY CERTIFICATIONS OF COMPLIANCE WITH THE PHA PLANS AND RELATED REGULATIONS. WHEREAS, The Department of the Housing and Urban Development has requested that Public Housing Agencies submit a Certification in regard to Public Housing Agency Compliance with the PHA Plans and Related Regulations; and WHEREAS, The 2014 PHA Plan was published for review and comment in the local newspaper and is located at the local Public Library, administrative offices of the PHA, and the PHA development management office. WHEREAS, such Certification also requires the formal approval of the Board of Commissioners; NOW THEREFORE BE IT RESOLVED, by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that the attached (Appendix) Public Housing Agency Certification of Compliance with the PHA Plans and Related Regulations is hereby approved ADOPTED THIS day of 12014 MOTION BY: SECONDED BY: AYES: NAYS: HOUSING AND REDEVELOPMENT AUTHORITY Chair — Tammera Diehm Executive Director — Walter R. Fehst [Annual EA 5-Year aIlll Us. Department of IIonsing and Urban =N185/7 Devolopmcnt Plan Office of Public and I»dian Mousing 1.0 1'HA Infornnntimn PIiA Nnmo: Columbia Heights Housing and Redovelopnlcn( Authority PHA Code: _MN105_,- , PHA •type: N Small [] high PeiTonning ❑ 5laldrrd ❑IICV (Section 8) PHA Fiscal Yen, Beginning: (MM /YYYY): _01/2013 2.0 Itventay (based on ACC units wt time of FY hcginniug in 1.0 above) Number of IICV units: Namibia of PH units: __101_ -- 3.0 Submdssion'fYpe O 5 -Year and Poniard Plan ® Annual Plan Only ❑ 5 -Year Plan Only 4.0 PHA Consordif ❑ PI LA Consm4ia: (Check box if submitting ajoint Pice and complete (able below.) No, of Unhs In ranch PIIA P,ogran(s) Included in file Programs Not in (he Pro ram plj IICV Participating PH As I g Cole C011sortin Consul (in PHA 1; —- PHA 7.: -- PHA 3: 5.0 5 -Veal• Plan. Complete items 5.1 And 5.2 only lit 5 -Year Plan update. 5,1 Mission. State the IAA's Mission for serving the needs of low - income, very ow-income, slid exiremely lose income families In the PI IA's suitable living environment free Oren' jurisdiction for the next five years; To Promote ndequate And affordable housing, economic opporbality laid a discrimination. 5.2 Goals And ol)jcetive5. Identify (Ito PIIA's quantiriable goals And objectives dial will "Able tllc PIIA to SCIYe (lie 111¢115 of lo\v-hleollle slid very the (he PIIA has etude in meeting 101 goals low- income, slid extremely low - income families for the next five yews. Include a repellant progress And objectives described in the previmis 5 -Year Phla. Expand the supply of Assisted lousing: Reduce public housing vacaloics; Occupancy rates remain at 98 %or above for over n year. of 95 or more. Increase customer sntisfnctiml: Offer stable Improve the quality of Assisted housing: bnprove public maagenlcot PHAS score office hours and available staff to handle day to day issues. Renovate or modcnnize public housing units; Continue with the building modoniiza(iou project until all floors line been renovated and than work on building ntodernim ioldrenova(ion projects. housing inquovononts; Continue to improve upon security Al the site, add Provide nn Improved living euvirunment: Implement public security Additional cameras and lighting to the Property Promote self sufficlmoy And asset development of Assisted households: Provide or attract supportive services to lainfutse independence to' the elderly or fanlidics with disabilities; Continue to work with dotal agencies that provide supportive services to residents. housing; Undertake affumndvo measures to ensure access to assisted housing Ensure equal OPPortmnity And afarnmtively further fah• regardless of race, color, religion, national origin, sex, familial slabls and disabili(y. Undertake Affirmative measures to ensure Accessible housing to persons with fill varieties of disabilities regardless of unit size. PRA Plan update 6.0 I. Identify all PHA Plan elements that have been revised by (he PHA since its last Annual Plat submission: Smoke Free Lease Addendum (b) Identify the specific location(s) where file public may obtuio copies of the 5 -Year and Annual PIIA Plan. Fora complete list of PHA Plan eloulems, see Section 6.0 of the instructions. Main Adminish'alion office of (he PHA, PHA development alalagenont offices find Public Library. Hope VI, Mixed Finance Modernization or Developuant, Demolition And /or Disposition, Conversion of Public Housing, Hamemvna•ship convers'los to HUD for ilr 101 tnafts of public /rousing under Section 1'rugrnos, and Protect- lnsctl Vonehcrs. 7'he 11RA is subndffh?g el vo(unta+y 22 of the United Slates (lousing Act of 1937and related requh emeals of ilia U.S. Department of /Tossing and Urban Development (HUD). The 7.0 a!lncherl Convensios Assessmmu and Conversion Plmr describe this action nod reasons fa• it. 1115 anticlpafed Ural, subject loft +j /il(nlenf of alllfUD requirenleols, !ha rasa(! till / be n renovated development arsfsted Gy profec/ -based varchers mllh conlimred nvnllabllfly to cnrrenl lardfndure louv Is with Ilia PHA 's 5 -Year acrd Annual Plan as Income households, 1n accordance moth HUD requirements, the Canverslmn Assessrnen submitted amended by tills Signtfload Amendment and the Conversion Plat' Is made parl of (be 5 -Year and Annual Plan as amended by lids S(gntricaut Amendment. 8.0 Cnplud improvements. Please complete Parts 8.1 through 8.3, as applicable. Page I of 2 torn Hun -o0v n pULUUOI 8 1 capita Fluid Program AHall el StatelllciiVPCrrarInnlice Gild P.vnhlntlolI Rcpol•t. As purl of life PI A 5 -Yeuu and Annual Plan, nnuunlly complete call submit file Copftal Fund Proglrun Annonl Slarernelr( /Performance and lfvaluallon Repent. fmnl IIUD- 50075.1, for Cecil current and Opel CFP grant and CPPP ffnaloing. I Capital Fund Progrmu hive•Yenr Action I'Inu. As part of the submission of file Annonl Plan, PHAs Cost- complete and submit the Capital Finul 8.2 Prograar Five -Year Action Plat, faun IIUD- 50075.2, mid subsequcot mmual updates (on a rolling basis, e.g., drop current year, and add Infest your for a five year flat led). Large capital items must be included in the Five -Yee Action Pha. 83 Cnpitnl Fund Financhlg Program (CFFP), CJ Check Check if the PI IA proposes to use any portion of its Capital fund Progrnul (CFP)llieplacemmll Housing Factor (RFIF) to repay debt incurred to 10.0 fine uce capital i ilprovenlents. Houslag Needs. Dosed ml iufommtion provided by the applicable Consolidated Pinu, information provided by HUD, and other generally available thin, nlnke a renso able effort to identify the housing needs of the low -f lcafile, very low - income, and extremely low- income families who reside in 9.0 thejurisdiction served by the PFIA, including elderly fnnlilics, fauliiies with disabilities, and households of various races anti ethnic groups, and othel flunilles who are oil the public housing will Section 8 tellont -lased assist tico Wmfng lists. Tile identification of houshig ]'calls "must Address issues of affordability, supply, quallly, accessibility, size ofurl($, find location. Quality affordable housing for extremely low income elderly families slid families with disabilities is a need within thejurisdiction. The PHA provides 101 one - bedroom units for qualified extremely low income elderly fnnlilics and families with disabilities within thejurisdiction of the PHA. Requh•ed Submission far IIUD Field Office Review. In addition (a (he PIIA Plan template (HUD - 50075), PRAs falls( submit the following documents. Items (u) through (g) rally be submitted w4h signahlre by mail or electronically with scanned signatures, but electronic submission is encouraged, Items (h) through (1) must be attached e]ectronicHlly with (he PHA Phil). Note: faxed copies of These documents will col be accepted by the Field Office. (a) Form IIUD- 50077, PHA CertUications of Compliance with the PHA Plans and Related Regulations (which includes all Get I! relating to Civil Righ(s) (b) Fans HUD - 50070, Ce•I[Tcation for• o Drug -Free iVorkpl ice (PI IAs receiving CFP grants only) (o) Perm HUD - 50071, Cerlocation ofPayineuts to h>nuence Federal Dvnsaeflons (PIIAs receiving CFP grants only) (d) Ponn SF -LLL, Disclosine of Lobbying Activilies (PFIAs receiving CFP grans only) (e) Fonu SF•LLL -A, Disclosure ofLobbying Activities Conhnua(lon Sheet (PlIAs receiving CFP 91 Hills only) (f) Resident Advisory Board (RAH) continents, Comments received from [be RAB must be submitted by (lie PHA as en aftnciuned to the PIIA Plan. PHAs roust also include H narrialive describing their analysis of the recommendations and the decisions inside on those recommendations. (g) Challenged Elements (h) Fora Hl1DS0075, 1, Capped Mind Program Amaral Sialenreril/Peifornrarce andGval a llon Report (PI IAs receiving CPP grams only) (1) Form HUD- 50075.2, Capllal Frond Pragiarn Five -Year Action Plan (PHAs receiving CFP grants only) Page 2 of 2 form HUD -50075 (4/2008) Strategy for Addresshng 11011sing Needs. Provide a brief description of the Pf IA's shnfegy for addressing tam ]musing needs of fnnlilics in file jurisdiction Hall on the waiting list in the upcoming year. Note: Snell, Section 8 only, ofd High perform Iug PHAs complete anly for AruuaI I Plan submission with the 5 -Yee• flan. Housing needs of those on the waiting list are for housing (lint is available for exhcnlely low incolnc elderly and disabled families. The PIIA has a preference in place for those that live or work in thejurisdiction. The PI IA plans to exceed (he federal Iargeing requirenlonl by targeting more than 40% of all new admissions to public housing to famllllCa A Of below 30% of median illcollle. Additional li fm•nmtion. Duscribe [lie following, m well as any additional iofornnatiou I IUD hnx requcstcd 10.0 (a) Progress ill Meeting Mission and Goals. Provide H brief sialemcm of the PI Ws progress ill ,,acting the mission and goals described in the 5- Year Plan, The PHA lips umintained no occupancy rate of 98 %o' Hbove for the past yom. The PIIA is improving the quality of assisted housing by continuing with the holding modernization plan. Six Floors have successfully been modernized. The PFIA upgraded the sccurily cameras fit the si(e in (he past ycnr.'I'hc PIIA continues ifs relationship with VolOntcois of Annerica to provide dining services for those in the assisted ]lensing. The PHA markets to Hit in thejurisdiction and continually works to ensure cquN Opportunity and nffirnmlively further fair houdug. definition ",significant nmendmer" and "substantial (b) Significant Arnendnrent and Substantial Devialion/Modificadoo, Provide the PHA's of devintioudmod i ficatiod' Requh•ed Submission far IIUD Field Office Review. In addition (a (he PIIA Plan template (HUD - 50075), PRAs falls( submit the following documents. Items (u) through (g) rally be submitted w4h signahlre by mail or electronically with scanned signatures, but electronic submission is encouraged, Items (h) through (1) must be attached e]ectronicHlly with (he PHA Phil). Note: faxed copies of These documents will col be accepted by the Field Office. (a) Form IIUD- 50077, PHA CertUications of Compliance with the PHA Plans and Related Regulations (which includes all Get I! relating to Civil Righ(s) (b) Fans HUD - 50070, Ce•I[Tcation for• o Drug -Free iVorkpl ice (PI IAs receiving CFP grants only) (o) Perm HUD - 50071, Cerlocation ofPayineuts to h>nuence Federal Dvnsaeflons (PIIAs receiving CFP grants only) (d) Ponn SF -LLL, Disclosine of Lobbying Activilies (PFIAs receiving CFP grans only) (e) Fonu SF•LLL -A, Disclosure ofLobbying Activities Conhnua(lon Sheet (PlIAs receiving CFP 91 Hills only) (f) Resident Advisory Board (RAH) continents, Comments received from [be RAB must be submitted by (lie PHA as en aftnciuned to the PIIA Plan. PHAs roust also include H narrialive describing their analysis of the recommendations and the decisions inside on those recommendations. (g) Challenged Elements (h) Fora Hl1DS0075, 1, Capped Mind Program Amaral Sialenreril/Peifornrarce andGval a llon Report (PI IAs receiving CPP grams only) (1) Form HUD- 50075.2, Capllal Frond Pragiarn Five -Year Action Plan (PHAs receiving CFP grants only) Page 2 of 2 form HUD -50075 (4/2008) ro 1� N w d R. W o� M ry� ry h C. O C III r i yd N 5 n M °n C Q P N O n a w C � o � H a ro � � e �o oxo O 9 00 �• 9 �n�nytid ed � ��. zdo � o � O in K� M O t" V1 p P C �T• O n ry�ry to O W v 0 0 N p• mm (C b J ° O Y tlp � K� 9 w v ❑ 6 K to ° N N iJ S Fpry1� O Y b w tl Q M P �• g o z to N :tJY A g o^ �C w d R. W o� M ry� ry h C. O C III r i yd N 5 n M °n C Q P N O n a w C � o � H a ro � � e �o oxo O 9 00 �• 9 b c a ro a v� �• c a O p b p C d 9 °' µ � o c o � �n Ca Q F n a w C X 6 V b. G '� %� �' d A p � OO'd om3 ei � r� UQ .a T O W b a a ro v� k �i a. p ro J I v1D X B 0 o O C M C C � Q C a m C X d P �• n y w p m o y r � p N tlQ + e • • • b a a ro v� k �i a. p ro J I v1D X B 0 o O C M C C � Q C a m C X d P �• n y w p m o y r � p N tlQ +