Loading...
HomeMy WebLinkAbouthra aprilColumbia ®Heights HOUSING & REDEVELOPMENT AUTHORITY AGENDA Tuesday, April 28, 2015 7 P.M. Parkview Villa - Community Room B 965 40T" AVE. NE COLUMBIA HEIGHTS, MN 1. Call to Order 2. Roll Call 3. Pledge of Allegiance Tammera Diehm, Chair Bruce Nawrocki, Secretary /Treasurer Rheta Nelson CONSENT AGENDA 4. Approve minutes of January 27, 2015 Donna Schmitt, Vice Chair Gary Peterson John Murzyn Jr. S. Resolution 2015 -04 — Approve Financial Report and Payment of Bills for January, February and March, 2015 Motion: Move to approve consent items as listed. BUSINESS ITEMS 6. Resolution 2015 -05 — Approving the Addition of Definitions of "Substantial Deviation" and "Significant Amendment of Modification" to the Parkview Villa PHA Plan. Motion: Move to waive the reading of Resolution 2015 -05 there being ample copies available to the public. Motion: Move to adopt Resolution 2015 -05 approving the additions to the Parkview Villa PHA Plan as presented. 7. Report of Management Company 8. Resident Council Update 9. Citizen Forum* 10. Adjourn EXECUTIVE SESSION 11. Parkview Villa Sale Discussion and Negotiation The next regular HRA meeting will be July 28.2015 at Parkview Villa. HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE MEETING OF JANUARY 27, 2015 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, John Murzyn Jr, Tammera Diehm, and Rheta Nelson. Staff Present: Community Development Director - Joseph Hogeboom, and Secretary- Shelley Hanson. CommonBond Staff- Laura Frost and Heidi Mindestrom 3. Pledge of Allegiance — Recited 4. Swearing in of New Members: Gary Peterson, Donna Schmitt, Tammera Diehm and John Murzyn Jr. all took their oath of office. 5. Election of Officers: Motion by Schmitt to nominate Diehm as Chair and Motion by Peterson to nominate Schmitt as Vice Chair and Nawrocki as Secretary/Treasurer, seconded by Diehm, to elect officers as nominated. All ayes. MOTIONPASSED. Therefore, officers are as follows: Chair- Diehm Vice Chair- Schmitt Secretary /Treasurer- Nawrocki CONSENT AGENDA 6. Approve Minutes of October 28, 2014. Resolution 2015 -01: Approve Financial Reports and Payment of Bills for October, November, and December 2015. Questions from members: Schmitt questioned how much the elevator project actually cost as payments were indicated on the reports over several months. Frost said the actual cost was a little over $40,000. CommonBond paid the contractor and Frost told members that she is waiting to receive the capital grant funds that will reimburse the account. Schmitt then asked about the late fee that was paid to the city for the water bill. Frost said the bills are sent directly to the accounting firm they use to make payments. She said payments are usually made in a timely manner. She will check with City staff to see how much lead time the accounting firm actually has to make these payments. Motion by Peterson, seconded by Schmitt, to approve items on the Consent Agenda as presented. All ayes. MOTIONPASSED. HRA Minutes Page 2 January 27, 2015 HRA RESOLUTION 2015 -01 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR OCTOBER, NOVEMBER, AND DECEMBER, 2014 AND PAYMENT OF BILLS FOR THE MONTHS OF OCTOBER, NOVEMBER, AND DECEMBER 2014 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 2014 and the list of bills for the months of October, November, and December 2014 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 27th day of January, 2015. MOTION BY: Peterson SECONDED BY: Schmitt AYES: All ayes Chair Attest by: Shelley Hanson, Secretary HRA Minutes Page 3 January 27, 2015 BUSINESS ITEM 8. Resolution 2015 -02 Designation of Depository Resolution 2015 -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. Motion by Peterson, seconded by Murzyn, to waive the reading of Resolution 2015 -02 there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Peterson, seconded by Murzyn, to adopt Resolution 2015 -02 approving Northeast Bank as the designated depository offends for the Housing and Redevelopment Authority for 2015. All ayes. MOTIONPASSED. RESOLUTION NO. 2015-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 January 28, 2014 and January 27, 2015, 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. HRA Minutes Page 4 Jan 27, 2015 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 27`" day of of January, 2015 Offered by: Peterson Seconded by: Murzyn Roll Call: All ayes Chair Shelley Hanson- Secretary HRA Minutes Page 5 January 27, 2015 9. Sale Update /Aeon Presentation Hogeboom told members that Miranda Walker from Aeon was present to update members on the purchase of Parkview. He said that she recently held a meeting for the residents to keep them up to date on the progress. Walker then told members that the closing should take place between May I" -15'. Final negotiations are taking place over equipment such as computers, copiers, printers, etc. Aeon is also working out the final financing and reports to state agencies required to close. Attorneys are working on easements and agreements in regards to the Antennas located on the roof of Parkview. Documentation is also being prepared for the transition. Aeon is working with Metro HRA to make the transition as smooth as possible. They will be meeting with each resident individually to make sure everything is in order according to HUD requirements. She explained the Voluntary Conversion has been approved and that process is what held things up for so long. The items listed above could not proceed until the conversion was approved. Nawrocki questioned what happens to the antennas on the roof. Walker explained that the City will have access to the antennas and will retain the lease and fees from them for a period of time. They are currently working on an easement and legal agreements to solidify this. A resident asked what remodeling or projects Aeon would undertake first. He said he believes heating and window replacement should be the first items to consider. Walker stated she said believes major work will take place during the first year of Aeon owning the building. Windows are among the top priorities and they will be more efficient and some may have tinting if deemed appropriate. The resident asked if Aeon has enough money to purchase the building and to do the renovations that soon. Walker responded that Aeon has built these costs into the financing they are obtaining. She explained that Aeon has access to funds that the City or HUD don't necessarily have 10. Resolution 2015 -03 Extension of Management Contract with Common Bond Housing Hogeboom explained that the current contract with CommonBond expires February 1, 2015. When the last contract was approved it was anticipated that the sale of the property would have closed sometime during 2014. Due to issues with U.S. Dept of HUD the sale was pushed back. Therefore, staff is recommending an extension be approved until July 31, 2015 since the anticipated closing date is now May 2015. The City /HRA can give a 60 day notice to terminate the contract when the sale date is actually set. CommonBond Housing is needed to continue managing and operating while the HRA is still the owner of the property since there are certain HUD reporting requirements for public housing that Aeon is not able to fulfill. Hogeboom noted that there is no increase in cost from the old agreement. HRA Minutes Page 6 Jan. 27, 2015 Motion by Peterson, seconded by Nawrocki, to waive the reading of Resolution 2015 -03 approving the extension of the Management Agreement with CommonBond Housing for Parkview Villa North and South. All ayes. MOTIONPASSED. Motion by Peterson, seconded by Nawrocki, to adopt Resolution 2015 -3, being a resolution of the Housing and Redevelopment Authority in and for the City of Columbia Heights, approving an extension to the Management Agreementfor Parkview Villa North and South and authorizing the Chairperson and executive Director of the HRA to execute the contract. All ayes. MOTIONPASSED. HRA RESOLUTION NO. 2015-03 RESOLUTION APPROVING SIX -MONTH EXTENSION TO MANAGEMENT AGREEMENT FOR PARKVIEW VILLA NORTH AND SOUTH WITH COMMONBOND HOUSING BE IT RESOLVED BY the Board of Commissioners ('Board ") of the Columbia Heights Housing and Redevelopment Authority (the "Authority ") as follows: Section 1. Recitals. 1.01. The Authority previously entered into a Management Agreement dated February 1, 2008 (the "Agreement") with CommonBond Housing (the "Agent') for the management of a housing facility known as Parkview Villa North and South (the "Property"). 1.02. The original term of the Agreement has expired, and the Authority has previously entered into four one -year extensions of the Agreement, the latest of which terminates on January 31, 2015. 1.03. The parties have agreed to an additional six -month extension of the Agreement (the "Extension'), to allow for continued management of the Property by the Agent until the Property is conveyed to a third party, which conveyance is expected to take place in May, 2015. Section 2. Extension Approved. 2.01. The Extension as presented to the Board is hereby in all respects approved, subject to modifications that do not alter the substance of the transaction and that are approved by the Chair and Executive Director, provided that execution of the Extension by such officials shall be conclusive evidence of approval. The Chair and Executive Director are hereby authorized to execute, on behalf of the Authority, the Extension. Adopted by the Board of Commissioners of the Columbia Heights Housing and Redevelopment Authority, this 27th day of January, 2015. Char ATTEST: Secretary HRA Minutes Page 7 January 27, 2015 11. Resolution 2015 -04 Approving Public Housing Authority Plan The U.S. Dept of HUD requires that housing authorities approve an annual Resolution that certifies that the agency is in compliance with the Public Housing Agency Plan. This is a 5 year plan and it should be the last time we have to submit this. No modernization funds were included in the report due to the sale of the property. However, it is still required that we submit the report since the closing has not yet taken place. The Public Housing Agency Plan was formally advertised and held for public review (with no comments) for the statutory period of time. Staff recommends approval of the Plan. Nawrocki asked if we used up all the previously approved modernization funds. Frost told him that we are still waiting for payments for the elevator project and that there should be about $40,000 left of those funds. Hogeboom asked if Nawrocki was wondering if any money was being left unused or on the table, and he said that staff is working with Aeon to identify some small projects that could be done to use the remaining funds prior to the closing. Motion by Peterson, seconded by Nawrocki, to waive the reading of Resolution 2015 -04 there being ample copies available to the public. All ayes. MOTIONPASSED. Motion by Peterson, seconded by Nawrocki, to adopt Resolution 2015 -04 being a Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) confirming approval of the 2015 Public Housing Agency Certifications of Compliance with the PHA Plans and Related Regulations. All ayes. MOTIONPASSED. HRA RESOLUTION 2015 -04 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMNET AUTHORITY (HRA) CONFIRMING APPROVAL OF THE 2015 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 2015 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 Certifications of Compliance with the PHA Plans and related Regulations is hereby approved. ADOPTED THIS 27th day of January, 2015. MOTION BY: Peterson SECONDED BY: Nawrocki ROLL CALL: All Ayes Chair Executive Director- Walter R. Fehst BRA Minutes Page 8 Jan. 27, 2015 12. Report of Management Company Frost stated they had filed an operating subsidy request that is required by HUD. CommonBond stated they have been drawing these funds down quarterly during the last couple years in anticipation of the pending sale so not much would have to be repaid at the time of closing. Frost also stated that a HUD required inspection will be done March 10`". The goal is to score 90+ out of 100. Staff is working on items to ensure a good score. Mindestrom reviewed the vacancy stats with the members. Nawrocki asked why they are having a hard time filling the units. Mindestrom said that from January 2014 through the current date that 31 applications had been received but that only 9 of those were approved. He wanted to know what things would prevent a person from being approved. Mindestrom said a variety of issues such as unfavorable previous rental history, non - payment of rent, criminal history, etc. 13. Resident Council Update Hogeboom told members that they didn't have a report from the Resident Council since the secretary had resigned. He said a special election is being held for the position on Tuesday, February 3rd from 10 am – 2 pm. Two interested parties have put their names in the hat thus far. He said whoever takes the position will not have to do it for long or provide reports to the city once the sale takes place, unless the Council continues under Aeon's ownership. 14. Citizen Forum Diane Kucher #911 — questioned the timeframe for voting. Hogeboom reiterated it would take place from 10 am to 2 pm on Feb. P. Diana Kruger #217— stated she works and wouldn't be available to vote during that timeframe. Hogeboom said he would try to arrange for absentee ballots for those that can't make it during the designated timeframe. 15. Administrative Update Hogeboom stated that staff is investigating what role the HRA will play once the sale goes through. Joe will provide that information to the Commissioners later. He said HUD may require ongoing reports which may necessitate commission action even after the sale is complete as it will be taking place mid -year. He also reminded members that special meetings may have to be called prior to the actual closing taking place. He said he would try to schedule these prior to other City Council meetings whenever possible so it doesn't interfere with members' schedules too much. HRA Minutes Page 9 Jan. 27, 2015 Diehm said the next regular meeting is scheduled for April 28, 2015 although there may be other special meetings called if needed prior to the closing of the sale. The meeting was adjourned at 7:40 pm. Respectfully submitted, Shelley Hanson, Secretary HRA RESOLUTION 2015 -04 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JANUARY, FEBRUARY, AND MARCH, 2015 AND PAYMENT OF BILLS FOR THE MONTHS OF JANUARY, FEBRUARY, AND MARCH, 2015. 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 January, February and March, 2015 and the list of bills for the months of January, February and March, 2015 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 April, 2015. MOTION BY: SECONDED BY: AYES: Chair Attest by: Shelley Hanson, Secretary Parkview Villa North Financial Statement Overview January 2015 Revenue: Occupancy for the month of January 2015 was 93 % occupied; Rent Revenue was under budget (unfavorable) and reflects occupancy Total Revenue for January was under budget (unfavorable) and reflects no grant money recognized for the month Administrative Expenses: Administrative costs for the North were under budget (favorable) Office Supply expenses were under budget (favorable) Audit expense Misc. Admin Expense was under budget (favorable) Utilities: Utilities Expenses were under budget (favorable) Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects December billing Gas was under budget (unfavorable) and reflects a MN interim refund from CenterPoint Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing OOveratine and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflect the cost of contract cleaning Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash was under budget (favorable); however, this is a quarterly billing Elevator Contract was under budget (favorable) Snow Removal Contract was under budget (favorable) Decorating Supplies was under budget (favorable) Miscellaneous Operating and Maintenance Expense was over budget (unfavorable) and reflects Parkview Villa -North Balance Sheet January 2015 Books = Accrual Assets 10100 Cash Balance 13,487.18 10200 Petty Cash 457.00 10400 Investments 898,424.28 11300 Rent Receivable 5,416.92 11500 Acounts Receivable 6.00 13200 Due From Other Government Units 123,999.00 Total Assets 1,041,790.38 Liabilities 20200 Accounts Payable 55,894.00 20210 Accrued Other Expenses 20,500.58 20220 Due to Resident Council 551.74 22000 Deposits 18,478.06 22200 Accrued PILOT 22,497.25 22210 Revenue Collected in Advance 3,385.94 Total Liabilities 121,307.57 Fund Balance 25300 Fund Balance 920,482.81 Total Fund Balance 920,482.81 Total Liabilities and Fund Balance 1,041,790.38 2/1912015 12:12 PM Parkview Villa -North Income Statement January 2015 Books = Accrual Revemre Month to Date % Year to Date % 3316046330 Federal Grant - 0.00% - 0.00% 3622046330 Gen. Government Rents 28,043.00 96.54% 28,043.00 96.54% 36225 -46330 Nondwelling Rents 306.00 1.05% 306.00 1.05% 3629046330 Other Miscellaneous Revenue 700.00 2.41% 700.00 2.41% 39120 -46330 Recovery Damage City Property - 0.00% - 0.00% Total Revniotue 29,049.00 100.00% 29,049.00 100A0% Expenses 4,721.58 16.25% 4,721.58 16.25% Personal Services 0.00 0.00% 0.00 0.00% 100046330 Accrued Salaries 8,929.00 30.74% 8,929.00 30.74% Total Personal Services 81929.00 30.74% 8,929.00 30.74% Supplies 0.00 0.00% 0.00 0.00% 200D -46330 Office Supplies -80.57 -0.28% -80.57 -0.28% 20IG46330 Minor Equipment 0.00 0.00% 0.00 0.00% 2160 -46330 Maint. & Construct Materials 524.27 1.80% 524.27 1.80% 217146330 General Supplies 255.73 0.88% 255.73 0.88% Total Supplies 699.43 2.41% 699A3 5.96% Other Services & Charges 304046330 Legal Fees 0.00 O.DD% 0.00 0.00% 305046330 Expert and Professional Services - 641.11 -2.21% - 641.11 -2.21% 306046330 Management Services 4,866.00 16.75% 4,866.00 16.75% 310046330 Protective Services 0.00 0.00% 0.00 0.00% 321046330 Telephone & Telegraph 137.81 0.47% 137.81 0.47% 343046330 Advertising Other 0.00 0.00% 0.00 0.00% 360046330 Insurance & Bonds 1,424.58 4.90% 1,424.58 4.90% 381046330 Electric 4,721.58 16.25% 4,721.58 16.25% 382046330 Water 0.00 0.00% 0.00 0.00% 383046330 Gas - 570.13 -1.96% - 570.13 -1.96% 384046330 Refuse 83.50 0.29% 83.50 0.29% 385046330 Sewer 0.00 0.00% 0.00 0.00% 400046330 Repair & Maint. Services 2,664.41 9.17% 2,664.41 9.17% 405046330 Garage, Labor 0.00 0.00% 0.00 0.00% 410046330 Rents & Leases 0.00 0.00% 0.00 0.00% 430046330 Miscellaneous Charges 166.69 0.57% 166.69 0.57% 431546330 PILOT 1,730.56 5.96% 1,730.56 5.96% 439046330 Taxes & Licenses 0.00 0.00% 0.00 0.00% 4500 -46330 Administrative Expenses 0.00 0.00% 0.00 0.00% 485046330 Interest on Deposits 14.42 0.05% 14.42 0.05% Total Other Services S, Charges 14,598.31 50.25% 14,59&31 50.25% Page 2 of 9 2/19/2015 12:12 PM Capital Outlay 5120 -46330 Building & Improvements 0.00 0.00/ - 0.00% Total Capital Outlay 0.00 0.000/0 0.00 0.00% Total Expense 24,226.74 83.40% 24,226.74 83.40% Excess (Deficit) Revenue over Expense 4,822.26 16.60% 4,822.26 16.60% Page 3 of 9 Parkview Villa -North (165) Cash Flow Statement Period - )anuary 2015 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 & Maim. 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 9 2/19/2015 12:12 PM Month to Date 0.00 28,043.00 306.00 700.00 0.00 29,049.00 8,929.00 8,929.00 -80.57 0.00 0.00 780.00 0.00 699.43 0.00 - 641.11 4,866.00 0.00 137.81 0.00 1,424.58 4,721.58 0.00 - 570.13 83.50 0.00 2,664.41 0.00 0.00 166.69 1,730.56 0.00 0.00 14.42 0.00 14,598.31 24,226.74 4,822.26 Parkview Villa -North (165) Cash Flow Statement Period = January 2015 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 2/19/2015 12:12 PM Month to Date 0.00 0.00 122.00 -6.00 0.00 0.00 40,488.74 - 45,683.43 0.00 214.42 1,730.56 744.00 (2,389.71) 2,432.55 Beg Cash End Cash Difference 10100 Cash Balance 11,054.63 13,487.18 2,432.55 10200 Petty Cash 457.00 457.00 - 10400 Investments 895,256.27 895,256.27 - Total Cash 906,767.90 909,200.45 2,432.55 Page 5 of 9 3060-46330 Management Services 165 1/30/2015 CommonEond Housing (chc) 165 1/31/2015 :PostRecurring Monthly recurring entry Net Change= 4,866.00 3210 -46330 Telephone ■ Telegraph Parkview Villa -North (165) 12/31/2014 Pupp.wm (popp) 165 1/1/2015 Level One (law) General Ledger 1/1/2015 Accrue 12/14 exp Inv W 1/15 165 1/2/2015 Comcest(wmc3517) Period = San 2015 4,866.00 = Ending Balance = Net Change =13741 0.00 = Beginning Balance a Book = Accrual; Tree = ysl_tb 222.72 0.00 Prope Data Person /Description Reference DebR Credit Balance Remarks 1000-46330 Accrued Saherles 222.72 76.52 Accrue 12/14 exp Inv to 1/15 - Popp.wm 0.00 = Beginning Balance = 165 1/31/2015 :POstRecuming Monthly recurring entry RC 8,929.00 0.00 8,929.00 R/C CHC PR Mgmt Fee 137.81 = Ending Balance = Net Change= 8,929.00 0.00 = Beginning Balance = 8,929.00 = Ending Balance = 2000 -46330 Office Supplies - 1,981.04 Accrue C of CH 7/31/14 #4448 invoice PC 0.00 = Beginning Balance = 165 12/19/2014 Office Depot (oHi8804) 7.46616E +31 37.12 0.00 37.12 stamo /pens /postage fee 165 12/24/2014 FedEx (fedex) 288749857sitw 9.01 0.00 46.13 shipments 12/19/14 165 12/31/2014 City of Columbia Heights (wlu) 4787 90.21 0.00 136.34 copier remit-06/14 -11/14 165 12/31/2014 City of Columbia Heights ([MU) 4788 44.43 0.00 180.77 w0ier -remb- 06/14 -11/14 165 1/1/2015 Accrue C of CH 7/31/14 *4 fl Invoice :Reversal of 22( 0.00 118.68 62.09 Accrue C of CH 7/31/14 #444S Invoice 165 1/1/2015 Accrue 12/14 exp Inv to 1115 - :Reversal of 221 0.00 37.12 24.97 Accrue 12/14 exp Inv W 1/15 - 081ce Depot 165 1/1/2015 Accrue 12114 exp Inv to 1/15 - :Reversal of 221 0.00 9.01 15.96 Accrue 12/14 exp Inv to 1115 - FedEx 165 1/1/2015 Accrue 12/14 exp Inv to 1/15 - :Reversal of 221 0.00 134.64 - 118.68 Accrue 12/14 exp Inv to 1/15 - C of Columbia 165 1/8/2015 Office Depot (o0i8804) 7.50045E +11 38.11 ON -80.57 paper /penciis NO Change= -80.57 -80.57 = Ending Balance = 2160.46330 Plaint B Construct Materiels 0.00 = Beginning Balance = 165 1/9/2015 HD Supply Facilities Maintenance, Ltd. (horr 9134709355 52.93 0.00 52.93 trip W.is -69% 165 119/2015 HD Supply Facilities Maintenance, Ltd. (hon 9134709355 58.68 0.00 111.61 hinges/pins;privacy lever -69% 165 1/9/2015 HD Supply Facilities Maintenance, Ltd. (hon9134709355 38.74 0.00 150.35 light bulbs-69% 165 1/9 /2015 HD Supply Facilities Maintenance, Ltd. (hon9134709355 64.51 0.00 214.86 cartridges -69% 165 1/1312015 Home Depot Credit Services (home9055) 1142449 19.73 0.00 234.59 maim supplies 165 1/20/2015 Frattalone's/Metre Ace (frat) 02093OR 6.70 0.00 241.29 seal knockout;fastenem -69% 165 1/22/2015 HD Supply Facilities Maintenance, Ltd. (hon 9134976653 16.24 0.00 257.53 knockout seal;wnn wr;cmpnd -69% 165 1/22/2015 HD Supply Fxllities Maintenance, ltd. (hon9134976653 154.26 0.00 411.79 It fxtm; lamp ceges;lt bulbs -69% 165 1/22/2015 HD Supply Facilities Maintenance, Ltd. (hon 9134976653 112.48 0.00 524.27 sealant;caulk gun -69% Net Change=524.27 524.27 = Ending Balance = 2171 -46330 General SupplNS 0.00 = Beginning Balance = 165 10/9/2014 Sherwin- Wi0lams Co. (sher4110) S9875 109.14 0.00 109.14 paint 165 1/1/2015 Accrue 12/14 exp my to 1/15 - :Reversal of 221 0.00 109.14 0.00 Accrue 12/14 exp only to 1/15 - Sher Win Willis 165 1/9/2015 HD Supply Facilities Maintenance, Ltd. (hon 9134709355 35.09 0.00 35.09 bath tissue -69% 165 1/14/2015 Sherwin- Williams Co. (sher4110) 46125 220.64 0.00 255.73 paint Net Change= 255.73 255.73 = Ending Balance = 3050 -46330 Expert & Professional Services 0.00 = Beginning Balance = 165 12131/2014 City of Columbia Heights (Colu) 4787 1,272.28 0.00 1,272.28 audit reimb -2014 165 12/31/2014 city of Columbia Heights (wlu) 4788 363.51 0.00 1,635.79 dud8-2014 165 1/1/2015 Accrue C of CH 7/31/14 #444B Invoice :Reversal of 22C 0.00 641.11 994.68 Acttue C of CH 7/31/14 #4448 Invoice 165 1/1/2015 Accrue 12114 exp inv to 1/15 - :Reversal of 221 0.00 1,635.79 - 641.11 Accrue 12/14 exp Inv to 1/15 - C of Columbia Net Change =- 641.11 - 641.11 = Ending Balance = 3060-46330 Management Services 165 1/30/2015 CommonEond Housing (chc) 165 1/31/2015 :PostRecurring Monthly recurring entry Net Change= 4,866.00 3210 -46330 Telephone ■ Telegraph 165 12/31/2014 Pupp.wm (popp) 165 1/1/2015 Level One (law) 165 1/1/2015 Accrue 12/14 exp Inv W 1/15 165 1/2/2015 Comcest(wmc3517) 4,866.00 = Ending Balance = Net Change =13741 3600-46330 Insurance 6 Bonds 165 1/1/2015 Accrue C of CH 7/31/14 #4448 Invoice 165 1/31/2015 :PosVi curring Monthly recurri entry 165 1/31/2015 Re- accrue 12/31 insurance accrual Net Changea1,424.38 3810 -46330 Electric 165 1/12/2015 %cel Energy (stall 0.00 = Beginning Balance = 013015mgmt 13,795.00 0.00 13,795.00 mgmt fee 01/15 RC 0.00 8,929.00 4,866.00 R/C CHC PR Mgmt Fee 4,866.00 = Ending Balance = 0.00 = Beginning Balance a 992234733 222.72 0.00 222.72 phone -69% 1/15 0471821IN 76.52 0.00 299.24 answering service 1/15 :Reversal of 221 0.00 222.72 76.52 Accrue 12/14 exp Inv to 1/15 - Popp.wm 877210505019E 61.29 0.00 137.81 internet -69% 1/11- 2/10/14 137.81 = Ending Balance = 0.00 = Beginning Balance = :Reversal of 22( 0.00 1,981.04 - 1,981.04 Accrue C of CH 7/31/14 #4448 invoice PC 1,424.58 0.00 - 556.46 C of Columbia Heights Ins Accd :Reversed by 22 1,981.04 0.00 1,424.58 Re -accrue 12/31 Insurance accrual 1,424.58 = Ending galenical = 0.00 a Beginning Balance c 5150441553 01, 4,721.58 0.00 4,721.58 e-69% 12/6/14- 117/15 Net Gunge =4,721.58 4,721.58 = Ending Balance = 3830-46330 Gas 0.00 = Beginning Balance = 165 1/1/2015 Accrue 12/14 exp Inv W 1115 - :Reyemi of 223 0.00 7,228.38 - 7,228.38 Accrue 12/14 exp Inv W 1/15 - Center Point I 165 1/8/2015 Centeftint Energy (cent) 55199657 01/01 7,228.38 0.00 0.00 g 12/4/14-116/15 165 1/8/2015 Centerucint Energy (cent) 55199657 01 /0f 0.00 570.13 - 570.13 MN Interim refund 12/12/14 Net Change =- 570.13 - 570.13 = Ending Balance = 3840.46330 Refuse 0.00 = Beginning Balance a 165 111/2015 Accrue 12/14 exp Inv to 1/15 - :Reversal of 221 0.00 3,898.28 - 3,898.28 Accrue 12/14 exp Inv W 1/15 - C of Columbia 165 1/10/2015 City of Columbia Heights (colu) 318024500010 3,898.28 0.00 0.00 garbage 9/29 - 12/31/14 165 1/16/2015 Green Lights Recycling Inc (greef004) 151275 83.50 0.00 83.50 recycling -69% Net Change =83.50 83.50 = Ending Balance = 4000 -46330 Repair 8 Malnt Services 0.00 = Beginning Balance = 165 12/26/2014 Integrity Cleaning Solutions (inte929) 1 331.20 0.00 331.20 bid mainb12122- 12/26/14 165 12/26/2014 Integrity Cleaning Solutions (inte929) 2 82.80 0.00 414.00 bid maint- 12122 - 12/26/14 165 12/31/2014 Drain King, Inc,(dra17740) 94379 135.00 0.00 549.00 clear shower drain 12/31/14 165 12/31/2014 LBP Mechanical, Inc (Ibpm) W21430 1,423.88 0.00 1,972.88 heat repairs-69% 11/12 - 12/4/14 165 12/31/2014 -BP Mechanical, Inc (Ibpm) W21458 725.88 0.00 2,698.76 heating repairs-69% #309 165 1/1/2015 Accrue 12/14 exp Inv to 1/15 - :Reversal of 221 0.00 796.95 1,901.81 Accrue 12114 exp Inv to 1/15 - Integrity Clea 165 1/1/2015 Accrue 12/14 exp Inv to 1/15 - :Reversal of 223 0.00 135.00 1,766.81 Active 12/14 loop Inv W 1/15 - Drain King 165 1/1/2015 Kone Inc.(kone) 221650449 738.10 0.00 2,504.91 elev maint -69% 1/15 165 1/1/2015 Active 12114 exp Inv W 1/15 - :Reversal of 221 0.00 1,423.88 1,081.03 Accrue 12/14loxp Inv to 1/15 - LEIP Mechanic 165 1/2/2015 Integrity Cleaning Solutions (inte929) 33 382.95 0.00 1,463.98 cieaning- 12/29/14- 01/02115 165 1/1012015 Integrity Cleaning Solutions (inte929) 56 331.20 0.00 1,795.18 bldg, main -69% 1/5- 9/2015 165 1/10/2015 Integrity Cleaning Solutions (Inte929) 56 72.45 0.00 1,867.63 Ice removal -69% 1/5- 9/2015 165 1/14/2015 Adam's Past Control, Inc. (adam) 947630 51.91 0.00 1,919.54 past control -69% #118 1/14/15 165 1114/2015 FrattaloneWhIetru Ace (frat) 0208BIR 11.05 0.00 1,930.59 V beks -69% 165 1/14/2015 High Profile Grounds Maintenance, Inc. (hug 31932 131.10 0.00 2,061.69 snow /Ice removal -69% 1/9/15 165 1/15/2015 Stanley Access Tecchnologles LLC (stan037'. 903795590 125.58 0.00 2,187.27 repairs-69% 165 1/15/2015 HD Supply Faclobes Maintenance, Ltd. (hon9134832803 23.03 0.00 2,210.30 V- belts -69% 165 1/15/2015 HD Supply Facilities Maintenance, LW. (hon9134832803 36.66 0.00 2,246.96 Traction Melt -69% 165 1/15/2015 High Profile Grounds Maintenance, Inc. (hig 32011 351.90 0.00 2,598.86 p1owing -02115 165 1/20/2015 High Profile Grounds Maintenance, Inc. (hig 32059 65.55 0.00 2,664.41 skid plow - 01/17/15 Net Change = 2,664.41 2,664.41 a Ending Balance a 4300 -46330 Miscellaneous Charges 0.00 or Beginning Balance a 165 12123/2014 Peachtree Business Products (peac) P333468800015 87.22 0.00 87.22 pet signs 165 12/29/2D14 Central Lock 8 Safe (cent2000) 122914165 125.00 0.00 212.22 drill lock 165 12/29/2014 Tom Satter (sate) 122914165 125.00 0.00 337.22 exp reimburse 12129/14 165 1/1/2015 Accrue 12/14 exp Inv to 1/15 - :Reversal of 221 0.00 67.22 250.00 Accrue 12/14 exp Inv W 1/15 - Peachtree 165 1/1/2015 Accrue 12/14 exp Inv to 1/15 - :Reversal of 221 0.00 125.00 125.00 Accrue 12/14 exp Inv to 1115 - Central Lock 165 1/1/2015 Accrue 12114 exp Inv W 1/15 - :Reversal of 221 0.00 125.00 0.00 Accrual 12/14 exp Inv W 1/15 - Columbia Hell 165 3/9 /2015 HD Supply Facilities Maintenance, LW. (horn 9134709355 9.67 0.00 9.67 tool gloves -69% 165 1/13/2015 HD Supply Facilities Maintenance, Ltd. (hon9134550278 157.02 0.00 166.69 schlage Saturn Interconnect-69% Net Change= 166.69 166.69 = Ending Balance = 4315 -46330 PILOT 0.00 = Beginning Balance = 165 1/31/2015 :PostRecurhng Monthly recurring entry RC 1,730.56 0.00 1,730.56 Anoka Cty Property Tax Accrual Net Change= 1,730.56 1,730.56 = Ending Balance = 4850-46330 Interest on Deposits 0.00 = Beginning Balance = 165 1/31/2015 Sec dep interest accrual 331 14.42 0.00 14.42 Sec dep interest accrual Net Change =14.42 14.42 = Ending Balance 52,434.83 28,208.09 Parkview Villa North Payment Summary Bank= 165opr AND mm/yy= 01/2015 - 01/2015 AND All Checks =Yes AND Include Voids =A11 Checks 27,676.45 Check Post Total Bank Check* Vendor Date Month Amount 165opr - Parkview Villa North 2626 chc - CommonBond Housing 01/07/2015 01/2015 13,914.24 1650pr - Parkview Villa North 2627 home7 - HD Supply Facilities Maintenance, Ltd. 01/07/2015 01/2015 91.02 1650pr - Parkview Villa North 2628 Inte929 - Integrity Cleaning Solutions 01/07/2015 01/2015 796.95 165opr - Parkview Villa North 2629 kod - K.O. Cleaning and Restoration LLC 01/07/2015 01/2015 650.00 165opr - Parkview Villa North 2630 koci7025 - K O Cleaning and Remodeling, Inc. 01/07/2015 01/2015 750.00 165opr - Parkview Villa North 2631 leve - Level One 01/07/2015 01/2015 76.52 165opr - Parkview Villa North 2632 OM8804 - Office Depot 01/07/2015 01/2015 37.12 165opr - Parkview Villa North 2633 peac - Peachtree Business Products 01/07/2015 01/2015 87.22 165opr - Parkview Villa North 2634 cent2000 - Central Lock 6 Safe 01/14/2015 01/2015 125.00 165opr - Parkview Villa North 2635 chc - CommonBond Housing 01/14/2015 01/2015 9.01 165opr - Parkview Villa North 2636 colu - City of Columbia Heights 01/14/2015 01/2015 2,479.75 165opr - Parkview Villa North 2637 satz - Tom Satzer 01/14/2015 01/2015 125.00 165opr - Parkview Villa North 2638 comc3517 - Comcast 01/21/2015 01/2015 61.29 165opr - Parkview Villa North 2639 drai7740 - Drain King, Inc. 01/21/2015 01/2015 135.00 165opr - Parkview Villa North 2640 frat - Frattalone's /Metro Ace 01/21/2015 01/2015 11.05 165opr - Parkview Villa North 2641 home7 - HD Supply Facilities Maintenance, Ltd. 01/21/2015 01/2015 157.02 165opr - Parkview Villa North 2642 Inte929 - Integrity Cleaning Solutions 01/21/2015 01/2015 403.65 165opr - Parkview Villa North 2643 kone - Kone Inc. 01/21/2015 01/2015 738.10 165opr - Parkview Villa North 2644 Ibpm - LBP Mechanical, Inc 01/21/2015 01/2015 1,423.88 165opr - Parkview Villa North 2645 multl - Multihousing Credit Control 01/21/2015 01/2015 380.00 165opr - Parkview Villa North 2646 Popp - Popp.com 01/21/2015 01/2015 222.72 165opr - Parkview Villa North 2647 sher4110 - Sherwin- Williams Co. 01/21/2015 01/2015 109.14 165opr - Parkview Villa North 2648 adam - Adam's Pest Control, Inc. 01/28/2015 01/2015 51.91 165opr - Parkview Villa North 2649 colu - City of Columbia Heights 01/28/2015 01/2015 3,625.28 165opr - Parkview Villa North 2650 frat - Frattalone's /Metro Ace 01/28/2015 01/2015 6.70 165opr - Parkview Villa North 2651 hlgh8236 - High profile Grounds Maintenance, Inc. 01/28/2015 01/2015 483.00 165opr - Parkvlew Villa North 2652 Ibpm - LBP Mechanical, Inc 01/28/2015 01/2015 725.88 27,676.45 Parkview Villa North Bank Reconciliation Report 01/31/2015 5016456 Balance Per Bank Statement as of 01/3112015 21,443.94 Outstanding Checks Check date Check number Payee Amount 02/04/2014 2327 t0008445 - Schuster 419.94 06/17/2014 2446 t0013260 - Vig 0.65 08119/2014 2488 t0004040 - Camp 276.52 01/14/2015 2634 cent2000 - Central Lock & Safe 125.00 01/14/2015 2637 satz - Tom Satzer 125.00 01121/2015 2644 Ibpm- LBP Mechanical, Inc 1,423,88 01/28/2015 2648 adam - Adam's Pest Control, Inc. 51.91 01/28/2015 2649 colu - City of Columbia Heights 3,625.28 01/28/2015 2650 Prat - Frattalone's /Metro Ace 6.70 01/28/2015 2651 high8236 - High Profile Grounds Maintenance, Inc. 483.00 01/28/2015 2652 Ibpm - LBP Mechanical, Inc 725.88 Less: Outstanding Checks 7,263.76 Other Items Date Notes Amount 01/12/2015 Returned item 10008243 - 693.00 Plus /Minus: Other Items - 693.00 Reconciled Bank Balance Balance per GL as of 01/31/2015 Difference Cleared Items : Cleared Checks Reconciled Balance Per G/L (Reconciled Bank Balance And Reconciled Balance Per G /L) 13,487.18 02/04/2015 13,487.18 13,487.18 0.00 Date Tran # Notes Amount Date Cleared 12/1612014 2612 t0006227- Griese 235.52 01131/2015 12/16/2014 2613 (0009628 - Schake 122.29 0113112015 Parkview Villa North Bank Reconciliation Report 01131/2015 5016456 Cleared Checks Date Tran # Notes Amount 12/31/2014 2615 adam - Adam's Pest Control, Inc. 125.08 12131/2014 2616 cent - CeraerPoint Energy 6,705.89 12/31/2014 2617 chc - CommonBond Housing 76.44 12131/2014 2618 drai7740 - Drain King, Inc. 195.00 12/31/2014 2619 fral - Frattalone's/Metro Ace 5,87 12/31/2014 2620 high8236 - High Profile Grounds Maintenance, Inc. 351.90 12131/2014 2621 home? - HD Supply Facilities Maintenance, Ltd. 293.03 12/31/2014 2622 inte929 - Integrity Cleaning Solutions 1,062.60 12131/2014 2623 kone - Kone Inc. 716.82 12/3112014 2624 0(118804.Office Depot 48.94 12/31/2014 2625 xcel - Xcel Energy 4,398.37 01/07/2015 2626 Cho - CommonBond Housing 13,914.24 01/07/2015 2627 home? - HD Supply Facilities Maintenance, Ltd. 91.02 01/07/2015 2628 inte929 - Integrity Cleaning Solutions 796.95 01/07/2015 2629 kod - K.O. Cleaning and Restoration LLC 650.00 01/0712015 2630 koc17025 - K O Cleaning and Remodeling, Inc. 750.00 01/07/2015 2631 leve - Level One 76.52 01/0712015 2632 offi8804 - Office Depot 37.12 01/07/2015 2633 peat - Peachtree Business Products 8722 01/14/2015 2635 chc - CommonBond Housing 9.01 01114/2015 2636 colu - City of Columbia Heights 2,479.75 01/21/2015 2638 comc3517- Comcest 61.29 01/21/2015 2639 drai7740 - Drain King, Inc. 135.00 01/21/2015 2640 hat - Frattalone's/Metro Ace 11,05 01/21/2015 2641 home7 - HD Supply Facilities Maintenance, Ltd. 157.02 01/21/2015 2642 inte929 - Integrity Cleaning Solutions 403.65 01/21/2015 2643 kone - Kone Inc. 738.10 01/21/2015 2645 multl - Muldhousing Credit Control 380,00 01/21/2015 2646 Popp - Popp.com 222.72 01/21/2015 2647 sher4110- Shemin-Williams Co. 109.14 Total Cleared Checks 35,447.55 Cleared Deposits Date Tran # Notes Amount 01/02/2015 672 17,286.00 01/05/2015 673 6,367.00 01/06/2015 674 222.00 01106/2015 675 4,419.00 01108/2015 676 1,271.00 01/09/2015 677 1,051.00 01/12/2015 680 1100 01/13/2015 679 8100 01/15/2015 681 94.00 Total Cleared Deposits 30,802.00 02/04/2015 Date Cleared 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01 /3112 01 5 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 Date Cleared 01/31/2015 01/3112015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 Date 1/30/15 Page 1 Primary Account @XXXXX ®6456 Enclosures 41 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - - - C H E C K I N G A C C O U N T S - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: - SAME DAY DELIVERY OF STATEMENT - PASSWORD PROTECTED - EASY STORAGE CONTACT YOUR BANKER FOR DETAILS! NORTHEAST PUBLIC FUNDS ACCT Account Number @XXXXX @6456 Previous Balance 26,089.49 9 Deposits /Credits 30,802.00 32 Checks /Debits 35,447.55 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 21,443.94 Number of Images 41 Statement Dates 1/01/15 thru 1/31/15 Days in the Statement Period 31 Average Ledger 29,608 Average Collected 27,551 xxxxxx + + +xxxxx +xxxxx+ xxxx +xxxxxxx +xxx++ xxxx ++ xxxx + + +xxx +xxxxxxxxxx+ +xxxx +xx + ++ Deposits and Credits Date Description Amount Amount 1/02 DDA REGULAR DEPOSIT 17,286.00 1 /05 DDA REGULAR DEPOSIT 6,367.00 1/06 DDA REGULAR DEPOSIT 222.00 1/06 DDA REGULAR DEPOSIT 4,419.00 1 /08 DDA REGULAR DEPOSIT 1,271.00 1/09 DDA REGULAR DEPOSIT 1,051.00 1/12 DDA REGULAR DEPOSIT 11.00 1/13 DDA REGULAR DEPOSIT 81.00 1/15 DDA REGULAR DEPOSIT 94.00 xxx +xxxxxxxx +xxxx + ++ xxxx ++ xxxx +xxxxx + +xx + + + +xxx + +xxx ++ +xxxx + +xxx + +xxxxx +xxxxxx Checks in serial order Date Check# Amount Date Check# Amount 1/27 2612 235.52 1/08 2619 5.87 /09 122.29 1/12 2620 351.90 1 2615* 125.08 1/07 2621 293.03 1/07 2616 6,705.89 1106 2622 1,062.60 1/02 2617 76.44 1/06 2623 716.82 1/12 2618 195.00 1/06 2624 48.94 * Indicates skip in check numbers Date 1/30/15 Page 2 Primary Account @XXXXX @6456 Enclosures 41 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 1/06 2625 4,398.37 1/20 2636 2,479.75 1/09 2626 13,914.24 1/28 2638* 61.29 1/15 2627 91.02 1/28 2639 135.00 1/15 2628 796.95 1/29 2640 11.05 1/14 2629 650.00 1/27 2641 157.02 1/14 2630 750.00 1/28 2642 403.65 1/12 2631 76.52 1/29 2643 738.10 1/13 2632 37.12 1/27 2645* 380.00 1/15 87.22 1/28 2646 222.72 2635* 9.01 1/29 2647 109.14 * Indicates skip in check numbers Daily Balance Section Date 1 /01 Balance 26,089.49 Date 1/09 Balance 29,235.92 Date 1/20 Balance 23,897.43 1/02 43,299.05 1/12 28,623.50 1/27 23,124.89 1/05 49,540.97 1/13 28,667.38 1/28 22,302.23 1/06 47,955.24 1/14 27,267.38 1/29 21,443.94 1/07 40,956.32 1/15 26,386.19 1/08 42,221.45 1116 26,377.18 * * * E N D O F S T A T E M E N T q tqn N N P N N A Y A P P W W g q q W W q q N O O O W O b N �A V b W A M W r i j O N V VI y P W N r O O W N V O V O O O O d r O O O O y y p b W O N W V g O O Y N H W O tp V v O O O O Y O O W V N O c ry ! 3'0 6 ',.ao e C °m m c m oa .m.m m����^o micro < T ? N N m mnm o m F c a ( s O o d r N Y O O O r N O> V r o N O O N o O b O p o 0 o b b q ydi hm -� EY' q b in �.l N N N V d t0 w O W W W q W V V N AN VI O O b g y q d S P N O A Vqi O 0 g O O N N N O W N N r W Y Y Y O V u W O W J J V V O N r N bo' a obo' W V W O S S O O O :d t d r r •' b Oo r r "m'.: P C 9 0 O r V r W J o O w N i+ W o o O O O O b N d S wq J w V V S V p A 5 i f'isodz N Iqn N W O O r O O O ~ O S! A o O N N O O O N W S S O N {, O N m r w N P O o u o J N O O J O O N N N N W N a A A q A I(4{ M � w A r W N O O O r O N O A J r O P O O b O O O b 0 0 0 0 0 b b q ydj m_' O 4FF O O V O O S O O O O S O O O O I {�y b P w r .P A W W IY V 1Np Cd IC W V N W W V V O N w J O W 0 0 0 0 0 0 b N A O 0 J O V W V V Sr k.,. d b W W N N W A W N O N q r V P J W O A V prj P p J O W O O V M O O O O V INJI N O A PN W O N r J O r Vr w W V O O O b N T O W V V V V O 1 t m` W q r N W V A Z N P A Y w N P N O N O V O S N O J A O O W O S Z V W O P O g D O N O N A D O O S N N W VNi 1F ' l M V y N P O o In r O N o N H A S IPn O O O S O O o S y 0 .qV o S nbi O O A O O a N N J d O Ir O O O O N n Yml. O S O O O O O S S S O p S O O O O O O O O O S O yN W W 0 S O S O O 0.. y z q q A r O O O b O b b O n N P O O Y n O b b O b O r O 1p b b w a m m H v o n q N V p o W N N N V q O W p b O W N V p oar O b J m W .n ry Y IZ O N � E m 5 S N zR T 9 O f '•,m N A N q ry O O� N A p O o p m 0 0 0 o V m m tNi� o o w m'. V O ^ O O V V N N O m A O 3 O o O A A q w p o m N O N o d o o m m 0 0 o S 0 0 a li �;IImI OI of Ok 2M4!1 s O °o Z a a n N N N V V � N N N O O p O O p P W V W N W O O m S P r W O v r w O P a W N V O W O N lVi� S J V 0 0 0 W O W N V O W O N VVI O V V 0 0 0 W S b g N H V rN a N N Ibll W w r A w o u P v o � ewmnai �i ar.Ni °o op °ow p N S A S O ➢ N O O O- p. O w W W A V VNi O A O S N P P P D O O N a N w S A G Y A� O V N tVO O P N W O N mi: ¢bpAF a b� q N N N P O W N S A O O g a N O O J vi V W p a q S �lkt q P m o O O o V N m o P N O Ll V OPSOPPOOSSOOie.':I W N V O W O N VVI O V V 0 0 0 W S b g N H V rN a N N Ibll W w r A w o u P v o � ewmnai �i ar.Ni °o op °ow p N S A S O ➢ N O O O- p. O w W W A V VNi O A O S N P P P D O O N 3 S A G Op o S uNi uWi S S O w Soo N (i N 3 Parkview Villa North Financial Statement Overview February 2015 Revenue: Occupancy for the month of February 2015 was 95% occupied; Rent Revenue was over budget (favorable) Total Revenue for October was over under budget (unfavorable) as grant income was not recognized Administrative Expenses: Administrative costs for the North were over budget (unfavorable) Other Renting Expenses were over budget (unfavorable) and reflect the cost of background screening of applicants Office Supply expenses were slightly over budget (unfavorable) Audit expense was over budget (unfavorable) Misc. Admin Expense was under budget (favorable) Utilities: Utilities Expenses were over budget (unfavorable) Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects Jan. billing Gas was over budget (unfavorable) and reflects Jan. billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operatina and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflects cost of contract cleaning Maintenance Supplies was over budget (unfavorable) and reflects cost of repair items needed Snow Contract was slightly over budget (unfavorable) Repairs contract was over budget (unfavorable) and reflects the cost of Generator 6 month maintenance Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs was under budget (favorable) Furniture and Fixtures was over budget (unfavorable) and reflects the cost of refrigerator replacement in one unit Parkview Villa -North Balance Sheet February 2015 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Acounts Receivable 13200 Due From Other Government Units Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 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 21,290.56 457.00 898,424.28 1,591.92 200.00 108,010.00 1,029,973.76 68,804.14 3,179.34 551.74 18,700.79 24,227.81 4,072.19 119,536.01 910,437.75 910,437.75 1,029,973.76 3/17/2015 1:06 PM Parkview Villa -North Income Statement February 2015 Books = Accrual Expenses personal Services 1000 -46330 Accrued Salaries Month to Date % Year to Date % Revenue 8,929.00 29.93% 17,858.00 30.33% 33160 -46330 Federal Grant - 0.00% - 0.00% 36220 -46330 Gen. Government Rents 29,695.00 99.53% 57,738.00 98.05% 36225 -46330 Nondwelling Rents 340.00 1.14% 646.00 1.10% 3629046330 Other Miscellaneous Revenue (199.00) -0.67% 501.00 0.85% 39120 -46330 Recovery Damage City Property - 0.00% - 0.00% Total Revenue 29,636.00 100.00% 58,885.00 100.00% Expenses personal Services 1000 -46330 Accrued Salaries 8,929.00 29.93% 17,858.00 30.33% Total Personal Services 8,929.00 29.93% 17,858.00 30.33% Supplies 4,866.00 16.31% 9,732.00 16.53% 2000 -46330 Office Supplies 286.00 0.96% 205.43 0.35% 2010 -46330 Minor Equipment 795.23 2.67% 795.23 1.35% 2160 -46330 Maint. & Construct Materials 1,425.13 4.78% 1,949.40 3.31% 2171 -46330 General Supplies 291.38 0.98% 547.11 0.93% Total Supplies 2,797.74 9.38% 3,497.17 15.65% Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 0.00 0.00% 3050-46330 Expert and Professional Services 641.11 2.15% 0.00 0.00% 3060-46330 Management Services 4,866.00 16.31% 9,732.00 16.53% 3100 -46330 Protective Services 170.78 0.57% 170.78 0.29% 3210 -46330 Telephone &Telegraph 361.69 1.21% 499.50 0.85% 3430 -46330 Advertising Other 0.00 0.00% 0.00 0.00% 3600 -46330 Insurance & Bonds 1,754.76 5.88% 3,179.34 5.40% 3810-46330 Electric 4,493.50 15.06% 9,215.08 15.65% 382046330 Water 0.00 0.00% 0.00 0.00% 383G 46330 Gas 6,381.19 21.39% 5,811.06 9.87% 3840 -46330 Refuse 0.00 0.00% 83.50 0.14% 3850 -46330 Sewer 0.00 0.00% 0.00 0.00^/ 4000.46330 Repair & Maint. Services 7,003.65 23.47% 9,668.06 16.42% 4050 -46330 Garage, Labor 0.00 0.00% 0.00 0.00% 4100 -46330 Rents & Leases 685.00 2.30% 685.00 1.16% 4300.46330 Miscellaneous Charges 53.03 0.18% 219.72 0.37% 4315 -46330 PILOT 1,730.56 5.80% 3,461.12 5.88% 4390.46330 Taxes & Licenses 0100 0.00% 0.00 0.00% 4500 -46330 Administrative Expenses 0.00 0.00% 0.00 0.00% 485046330 Interest on Deposits 13.05 0.04% 27.47 0105% Total Other Services & Charges 28,154.32 94.36% 42,752.63 72.60% Page 2 of 10 3/17/2015 1:06 PM Capital Outlay 5120-46330 Building & Improvements 0.00 0.00 % - 0.00% Total Capital Outlay 0.00 0.00% 0.00 0.00% Total Expense 39,881.06 133.670/a 64,107.80 108.87% Excess (Deficit) Revenue Over Expense - 10,045.06 -33.67% - 5,222.80 -8.87% Page 3 of 10 Parkview Vilia -North (165) Cash Flow Statement Period = February 2015 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 10 3/17/2015 1:06 PM Month to Date 0.00 29,695.00 340.00 - 199.00 0.00 29,836.00 8,929.00 8,929.00 286.00 795.23 0.00 1,716.51 0.00 2,797.74 0.00 641.11 4,866.00 170.78 361.69 0.00 1,754.76 4,493.50 0.00 6,381.19 0.00 0.00 7,003.65 0.00 685.00 53.03 1,730.56 0.00 0.00 13.05 0.00 28,154.32 39,881.06 - 10,045.06 Parkview Villa -North (165) Cash Flow Statement Period = February 2015 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash 3/17/2015 1:06 PM Month to Date 0.00 0.00 3,825.00 - 194.00 15,989.00 0.00 12,910.14 - 17,321.24 0.00 222.73 1,730.56 686.25 17,848.44 7,803.38 Beg Cash End Cash Difference 13,487.18 21,290.56 7,803.38 457.00 457.00 - 898,424.28 898,424.28 - 912,368.46 920,171.84 7,803.38 Page 5 of 10 Parkview Villa -North (165) General Ledger Period = Feb 2015 Book = Accrual; Tree = ysi_tb Prof Date Person /Description Reference Debit Credit Balance Remarks 1000 -46330 Accrued Salaries 8,929.00 = Beginning Balance = 165 2/28/2015 :PostRecurring Monthly recurring er RC 8,929.00 0.00 17,858.00 R/C CHC PR Mgmt Fee Net Change = 8,929.00 17,858.00 = Ending Balance = 2000 -46330 Office Supplies -80.57 = Beginning Balance = 165 7/31/2014 City of Columbia Heights (colu) 4448 118.68 0.00 38.11 copler0l /01- 05/31/14 165 7/31/2014 City of Columbia Heights (colu) 4448 0.00 118.68 -80.57 copierOl /01- 05/31/14 165 7/31/2014 City of Columbia Heights (colu) 4448 118.68 0.00 38.11 copier0l /01- 05/31/14 165 2/2/2015 Office Depot (offi8804) 7.5323E +11 6.89 0100 45.00 post -it popup dispenser -69% 165 2/2/2015 Office Depot(ofh8804) 7.5323E +11 91.56 0.00 136.56 stamps; shts;envlps;post- its -69; 165 2/5/2015 Office Depot (offi8804) 7.5401E +11 24.13 0.00 160.69 stamp;candy -69% 165 2/7/2015 Office Depot (offi8804) 7.5401E +11 17.24 0.00 177.93 stamps -69% 165 2/20/2015 Common Bond Housing (chc) 022015comps 27.50 0.00 205.43 computer support 01/26- 02/19/ Net Change = 286.00 205.43 = Ending Balance = 2010 -46330 Minor Equipment 0.00 = Beginning Balance = 165 2/5/2015 HD Supply Facilities Maintenance, L 9135265317 50.18 0.00 50.18 cove base -69% 165 2/12/2015 HD Supply Facilities Maintenance, L9135420261 79.03 0.00 129.21 roller shades -69% 165 2/19/2015 HD Supply Facilities Maintenance, L9135568268 86.02 0.00 215.23 ceiling tile -69% 165 2/19/2015 All Inc. (all) 51353532001 580.00 0.00 795.23 fridge #206 Net Change= 795.23 795.23 = Ending Balance = 2160 -46330 Maint. & Construct Materials 524.27 = Beginning Balance = 165 1/23/2015 Home Depot Credit Services (home, FCH00555694 13.80 0.00 538.07 late fee -69% 165 1/27/2015 HD Supply Facilities Maintenance, L9135060964 599.15 0.00 1,137.22 cvr /flppr /seat/rng hldr /o mg... 165 1/27/2015 HD Supply Facilities Maintenance, L 9135060961 165.49 0.00 1,302.71 seal /corn cvr /bibs /Imp cage.... 165 1/28/2015 HD Supply Facilities Maintenance, L9135098183 0.00 146.18 1,156.53 bib /seal /cvr /cage /seal - credit 165 1/29/2015 HD Supply Facilities Maintenance, L9135121086 5.01 0.00 1,161.54 duct seal 165 1/29/2015 HD Supply Facilities Maintenance, L 9135121085 74.54 0.00 1,236.08 kwik seal 165 2/5/2015 HD Supply Facilities Maintenance, L9135265622 0.00 81.72 1,154.36 misc maint supply -69% -credit 165 2/5/2015 HD Supply Facilities Maintenance, L9135265317 38.79 0.00 1,193.15 range hood -69% 165 2/5/2015 HD Supply Facilities Maintenance, L 9135265317 22.97 0.00 1,216.12 mat strp;clips;smk alrm -69% 165 2/5/2015 HD Supply Facilities Maintenance, L9135265317 123.32 0.00 1,339.44 ballasts -69%A 165 2/5/2015 HD Supply Facilities Maintenance, L 9135265317 22.80 0.00 1,362.24 duct tape -69% 165 2/9/2015 Frattalone's /Metro Ace (frat) 021145R 18.52 0.00 1,380.76 misc main supplies -69% 165 2/12/2015 HD Supply Facilities Maintenance, L 9135420261 38.79 0.00 1,419.55 range hood -69% 165 2/12/2015 HD Supply Facilities Maintenance, L9135420261 15.77 0.00 1,435.32 door kickplate -69% 165 2/12/2015 HD Supply Facilities Maintenance, L9135420261 74.36 0.00 1,509.68 light bulbs -69% 165 2/12/2015 HD Supply Facilities Maintenance, L 9135420261 10.32 0.00 1,520.00 Liquid Nails -69% 165 2/12/2015 HD Supply Facilities Maintenance, L9135420261 37.25 0.00 1,557.25 sink strainer -69% 165 2/19/2015 HD Supply Facilities Maintenance, L9135568268 392.15 0.00 1,949.40 k faucets;misc malnt supply -69° Net Change= 1,425.13 1,949.40 = Ending Balance = 2171 -46330 General Supplies 255.73 = Beginning Balance = 165 2/2/2015 HD Supply Facilities Maintenance, L 9135186743 30.04 0.00 285.77 vac bags 165 2/6/2015 Buckeye Cleaning Centers (buck841869555 120.49 0.00 406.26 paper towels -69% 165 2/11/2015 Sherwin - Williams Co. (sher4110) 51620 140.85 0.00 547.11 paint -69% Net Change = 291.38 547.11 = Ending Balance = 3050 -46330 Expert and Professional Services - 641.11 = Beginning Balance = 165 7/31/2014 City of Columbia Heights (colu) 4448 641.11 0.00 0.00 audit fees -2013 165 7/3112014 City of Columbia Heights (colu) 4448 0.00 641.11 - 641.11 audit fees -2013 165 7/31/2014 City of Columbia Heights (colu) 4448 641.11 0.00 0.00 audit fees -2013 Net Change = 641.11 0.00 = Ending Balance = 3060 -46330 Management Services 4,866.00 = Beginning Balance = 165 2/27/2015 CommonBond Housing (chc) 022715mgmt 13,795.00 0.00 18,661.00 mgmt fee 02/15 165 2/28/2015 :PostRecurring Monthly recurring er RC 0.00 8,929.00 9,732.00 R/C CHC PR Mgmt Fee Net Change = 4,866.00 9,732.00 = Ending Balance = 3100 -46330 Protective Services 0.00 = Beginning Balance = 165 1/31/2015 Sitzmann Construction dba Sitzman580140 170.78 0.00 170.78 fire alarm panel -69% 9/8/14 Net Change= 170.78 170.78 = Ending Balance = 3210 -46330 Telephone & Telegraph 137.81 = Beginning Balance = 165 1/31/2015 Popp.com (pope) 992241194 223.88 0.00 361.69 phone -69% 2/15 165 2/1/2015 Level One (leve) 04791461N 76.52 0.00 438.21 answering service 2/15 165 2/2/2015 Comcast(comc3517) 87723050501 61.29 0.00 499.50 interne( -69% 2/11- 3/10/15 Net Change= 361.69 499.50 = Ending Balance = 3600 -46330 Insurance & Bonds 1,424.58 = Beginning Balance = 165 7/31/2014 City of Columbia Heights (colu) 4448 19,076.00 0.00 20,500.58 insurance -2014 165 7/31/2014 City of Columbia Heights (colu) 4448 0.00 19,076.00 1,424.58 insurance -2014 165 7/31/2014 City of Columbia Heights (colu) 4448 19,076.00 0.00 20,500.58 insurance -2014 165 2/28/2015 :PostRecurring Monthly recurring er RC 0.00 17,321.24 3,179.34 C of Columbia Heights Ins Accrl Net Change= 1,754.76 3,179.34 = Ending Balance = 3810 -46330 Electric 4,721.58 = Beginning Balance = 165 2/11/2015 %cel Energy (xcel) 5150441553 1 4,493.50 0.00 9,215.08 e-69% 1/7- 2/7/15 Net Change= 4,493.50 9,215.08 = Ending Balance = 3830 -46330 Gas - 570.13 = Beginning Balance = 165 2/6/2015 CenterPoint Energy (cent) 55199657 02/ 6,281.32 0.00 5,711.19 g 1/6- 2/4/15 165 2/6/2015 CenterPoint Energy (cent) 55199657 02/ 99.87 0.00 5,811.06 late fee Net Change = 6,381.19 5,811.06 = Ending Balance = 3840 -46330 Refuse 83.50 = Beginning Balance = Net Change =0.00 83.50 = Ending Balance = 4000 -46330 Repair & Maint. Services 2,664.41 = Beginning Balance = 165 1/16/2014 Integrity Cleaning Solutions (inte9258 331.20 0.00 2,995.61 cleaning 1/12- 16/2015 -69% 165 1/16/2014 Integrity Cleaning Solutions (inte9258 72.45 0.00 3,068.06 heavy salt -69% 165 12/11/2014 All Seasons Garage Door Company 43898 99.44 0.00 3,167.50 door parts 165 12/30/2014 Integrity Cleaning Solutions (inte9235 334.65 0.00 3,502.15 bldg maint #A;B 12/29/14 -1/2/ 165 1/9/2015 Cummins NPower LLC (cumm) 10092828 1,144.63 0.00 4,646.78 maint/repairs -69% 1/15 165 1/24/2015 Integrity Cleaning Solutions (inte92235 148.35 0.00 4,795.13 cleaning- 01/19- 01/24/15 165 1/24/2015 Integrity Cleaning Solutions (Inte92231 403.65 0.00 5,198.78 caretaking- 01/19- 01/24/15 165 1/24/2015 Integrity Cleaning Solutions (inte92233 200.00 0.00 5,398.78 full detail 165 1/2812015 K O Cleaning and Remodeling, Inc. 3281 125.00 0.00 5,523.78 repairs 165 1/28/2015 K O Cleaning and Remodeling, Inc. 3281 650.00 0.00 6,173.78 painting/finishing 165 1/30/2015 Integrity Cleaning Solutions (inte92536 414.00 0.00 6,587.78 bid cleaning-69% #A;B 165 1/31/2015 Sitzmann Construction dba Sitzman 580141 398.48 0.00 6,986.26 misc repairs -69% 1/30/15 165 1/31/2015 Sitzmann Construction dba Sitzman 580139 170.00 0.00 7,156.26 A/C repairs #901 8/14/14 165 2/1/2015 Kone Inc. (kone) 221675738 738.10 0.00 7,894.36 elev maint -69% 2115 165 2/3/2015 Direct Home Appliance Services (dii 2.0315E +10 61.41 0.00 7,955.77 repairs -69% 165 2/4/2015 Sitzmann Construction dba Sitzman580156 120.00 0.00 8,075.77 repairs 11/11/14 165 2/4/2015 Sitzmann Construction dba Sitzman580157 162.50 0.00 8,238.27 repairs #903 7/1/14 165 2/6/2015 Integrity Cleaning Solutions (inte92263 331.20 0.00 8,569.47 building mains -69% #A;B 165 2/6/2015 Adam's Pest Control, Inc. (adam) 954079 75.23 0.00 8,644.70 pest control 2/6/15 165 2/6/2015 Integrity Cleaning Solutions (inte92263 72.45 0.00 8,717.15 heavy salt -69% 165 2/9/2015 High Profile Grounds Maintenance, 132171 103.50 0.00 8,820.65 snow /ice removal -69% 2/3/15 165 2/12/2015 HD Supply Facilities Maintenance, L9135420261 36.66 0.00 8,857.31 Traction Melt -69% 165 2/13/2015 Integrity Cleaning Solutions (inte926010 386.40 0.00 9,243.71 janitorial services-69% #A;B 165 2/13/2015 Integrity Cleaning Solutions (inte926010 72.45 0.00 9,316.16 Heavy salt -69% 165 2/16/2015 High profile Grounds Maintenance, 132306 351.90 0.00 9,668.06 snow /ice removal -69% 3/15 Net Change= 7,003.65 9,668.06 = Ending Balance = 4100 -46330 Rents & Leases 0.00 = Beginning Balance = 165 1/31/7015 Muldhousing Credit Control (multi) 15010335 685.00 0.00 685.00 screening serv-01/15 Net Change = 685.00 685.00 = Ending Balance = 4300 -46330 Miscellaneous Charges 166.69 = Beginning Balance = 165 2/3/2015 Frattalone's /Metro Ace (frat) 0230908 53.03 0.00 219.72 hi security condo keys-69% Net Change =53.03 219.72 = Ending Balance = 4315 -46330 PILOT 1,730.56 = Beginning Balance = 165 2/28/2015 :PostRecurnng Monthly recurring er RC 1,730.56 0.00 3,461.12 Anoka Cty Property Tax Accrual Net Change = 1,730.56 3,461.12 = Ending Balance = 4850 -46330 Interest on Deposits 14.42 = Beginning Balance = 165 2/28/2015 Sec Dep interest accrual GJ2 13.05 0.00 27.47 Sec Delp interest accrual Net Change= 13.05 27.47 = Ending Balance = 86,194.99 46,313.93 5016456 Parkview Villa North Bank Reconciliation Report 02/28/2015 Balance Per Bank Statement as of 02/28/2015 $49,001.53 02/04/2014 2327 t0008445 - Schuster 419.94 06/17/2014 2446 t001 3260 - Yg 0.65 08/19/2014 2488 (0004040 -Camp 276.52 01/14/2015 2634 cent2000 - Central Lock & Safe 125.00 02111/2015 2661 colu - City of Columbia Heights 23,899.56 02118/2015 2673 inte929 - Integrity Cleaning Solutions 403.65 02/18/2015 2676 sitz - Sitzmann Construction dba Sitzmann Elect 1,021.76 02/25/2015 2677 adam - Adam's Pest Control, Inc. 75.23 02125/2015 2678 buck8411- Buckeye Cleaning Centers 120.49 02/25/2015 2679 dire - Direct Home Appliance Services 61.41 02/25/2015 2680 fiat - Fmttalone's/Metro Ace 53.03 02125/2015 2681 high8236 - High Profile Grounds Maintenance, Inc. 103.50 02/25/2015 2682 inte929 - Integrity Cleaning Solutions 334.65 02/2512015 2683 offi8804 - Office Depot 122.58 Less: Outstanding Checks $27,017.97 01/12/2015 Returned item t0008243 - 693.00 Plus /Minus: Other items - $693.00 Reconciled Bank Balance Balance per GL as of 02/28/2015 Difference Cleared Items: Cleared Checks Date Tran # 01/14/2015 2637 01/21/2015 2644 01/28/2015 2648 01128/2015 2649 01/28/2015 2650 01/28/2015 2651 01/28/2015 2652 02/04/2015 2653 Reconciled Balance Per G/L $21,290.56 Notes Amount satz - Tom Satzer 125.00 Ibpm - LBP Mechanical, Inc 1,423.88 adam - Adam's Pest Control, Inc. 51.91 colu - City of Columbia Heights 3,625.28 fiat - Frattalone's/Metro Ace 6.70 high8236 - High Profile Grounds Maintenance, Inc. 483.00 Ibpm - LBP Mechanical, Inc 725.88 alls2529 - All Seasons Garage Door Company 99.44 3/2/15 $21.290.56 $21,290.56 Date Cleared 02/28/2015 02/28/2015 02/28/2015 02/28/2015 02/28/2015 02/28/2015 02/28/2015 02/28/2015 M KI 3/2/15 Parkview Villa North Bank Reconciliation Report 02/28/2015 5016456 02/04/2015 2654 cent - CenterPoint Energy 6,658.25 02/2812015 02104/2015 2655 gree1004 - Green Lights Recycling Inc 83.50 02/28/2015 02104/2015 2656 high8236 - High Profile Grounds Maintenance, Inc. 65.55 02/28/2015 02/04/2015 2657 home? - HD Supply Facilities Maintenance, Ltd. 319.31 02/28/2015 02104/2015 2658 inte929 - Integrity Cleaning Solutions 752.00 02/28/2015 02/04/2015 2659 t0004054 - Hinrichs 190.32 02/28/2015 02/04/2015 2660 xcel - Xce1 Energy 4,721.58 02/28/2015 02111/2015 2662 home7 - HD Supply Facilities Maintenance, Ltd. 980.99 02/28/2015 02/11/2015 2663 home9055 - Home Depot Credit Services 19.73 02/28/2015 02/11 /2015 2664 inte929 - Integrity Cleaning Solufions 414.00 02/28/2015 02111/2015 2665 leve - Level One 76.52 02/2812015 02/11/2015 2666 multi - Muldhousing Credit Control 685.00 02/28 /2015 02/11 /2015 2667 0168804 -Office Depot 38.11 02/28/2015 02/11/2015 2668 sher4110 - Sherwin- Williams Co. 220.64 02/28/2015 02/11/2015 2669 stan0371 - Stanley Access Tecchnologies LLC 125.58 02/28/2015 02/18/2015 2670 comc3517 - Comcast 61.29 02128/2015 02/18/2015 2671 fiat - Frattalone's/Metro Ace 18.52 02 /28/2015 02/18/2015 2672 home9055 - Home Depot Credit Services 13.80 02/2812015 02/1812015 2674 koc17025 - K O Cleaning and Remodeling, Inc. 775.00 02/28/2015 02/18/2015 2675 Popp- Popp.com 223.88 02128/2015 Total $22,984.66 Cleared Deposits Date Tran # Notes Amount Date Cleared 02/04/2015 685 21,647.00 02/28/2015 02106/2015 686 7,266.25 02/28/2015 0211012015 687 760.00 02 /28 /2015 02/13 /2015 688 222.00 02 /28/2015 02/2412015 690 206.00 02 /28/2015 02125/2015 691 4,452.00 02/28/2015 Total $34,553.25 Cleared Other Items Date Tran # Notes Amount Date Cleared 02/28/2015 JE 223518 ELoocs Operafing Fund receipt 15,989.00 02/28/2015 Total $15,989.00 3/2/15 Date 2/27/15 Page 1 Primary Account @XXXXX @6456 Enclosures 34 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C 0 U N T S - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: - SAME DAY DELIVERY OF STATEMENT - PASSWORD PROTECTED - EASY STORAGE CONTACT YOUR BANKER FOR DETAILS! NORTHEAST PUBLIC FUNDS Account Number Previous Balance 7 Deposits /Credits 28 Checks /Debits Electronic Debit Service Charge Interest Paid Ending Balance ACCT @XXXXX @6456 21,443.94 50,542.25 22,984.66 .00 .00 .00 49,001.53 Number of Images 34 Statement Dates 2/01/15 thru 2/28/15 Days in the Statement Period 28 Average Ledger 34,302 Average Collected 32,892 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Deposits and Credits Date Description Amount 2/04 DDA REGULAR DEPOSIT 21,647.00 2/06 DDA REGULAR DEPOSIT 7,266.25 2/10 DDA REGULAR DEPOSIT 760.00 2/13 DDA REGULAR DEPOSIT 222.00 2/25 DDA REGULAR DEPOSIT 206.00 2/25 DDA REGULAR DEPOSIT 4,452.00 2/27 MISC PAY HUD TREAS 310 15,989.00 CR 6,658.25 9101036151 02/27/15 6.70 2/12 ID #- 411269646860103 83.50 * Indicates skip TRACE #- 101036152792631 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Checks in serial order Date Check# Amount Date Check# Amount 2/09 2637 125.00 2/05 2651 483.00 2/02 2644* 1,423.88 2/03 2652 725.88 2/03 2648* 51.91 2/10 2653 99.44 2/03 2649 3,625.28 2/13 2654 6,658.25 2/05 2650 6.70 2/12 2655 83.50 * Indicates skip in check numbers Date 2/27/15 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 2/17 2656 65.55 2/18 2666 685.00 2/12 2657 319.31 2/18 2667 38.11 2/11 2658 752.00 2/20 2668 220.64 2/11 2659 190.32 2/19 2669 125.58 2/11 2660 4,721.58 2/25 2670 61.29 2/18 2662* 980.99 2/24 2671 18.52 2/17 2663 19.73 2/23 2672 13.80 2/17 2664 414.00 2/26 2674* 775.00 2/18 2665 76.52 2/25 2675 223.88 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 2/01 21,443.94 2/10 44,576.10 2/20 29,447.02 2/02 20,020.06 2/11 38,912.20 2/23 29,433.22 2/03 15,616.99 2/12 38,509.39 2/24 29,414.70 2/04 37,263.99 2/13 32,073.14 2/25 33,787.53 2/05 36,774.29 2/17 31,573.86 2/26 33,012.53 2/06 44,040.54 2/18 29,793.24 2/27 49,001.53 2/09 43,915.54 2/19 29,667.66 * * * E N D O F S T A T E M E N T Parkview Villa North Payment Summary Bank= 1650pr AND mm/yy= 02/2015- 0212015 AND All Checks =Yes AND Include Voids =All Checks 42,738.87 Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 2653 alls2529 - All Seasons Garage Door Company 02/04/2015 02/2015 99.44 165opr- Parkview Villa North 2654 cent- CenterPoint Energy 02/04/2015 02/2015 6,658.25 165opr - Parkview Villa North 2655 gree1004 - Green Lights Recycling Inc 02/04/2015 02/2015 83.5 165opr - Parkview Villa North 2656 high8236 - High Profile Grounds Maintenance, I 02/04/2015 02/2015 65.55 1650pr - Parkvlew Villa North 2657 home? - HD Supply Facilities Maintenance, Ltd. 02/04/2015 02/2015 319.31 165opr - Parkview Villa North 2658 inte929 - Integrity Cleaning Solutions 02/04/2015 02/2015 752 165opr- Parkvlew Villa North 2659 10004054 - Hinrichs 02/04/2015 02/2015 190.32 165opr- Parkvlew Villa North 2660 ncel- Xcel Energy 02/0412015 02/2015 4,721.58 1650pr - Parkview Villa North 2661 colu - City of Columbia Heights 02/11/2015 02/2015 23,899.56 165opr - Parkview Villa North 2662 home? - HD Supply Facilities Maintenance, Ltd, 02/11/2015 02/2015 980.99 1650pr - Parkview Villa North 2663 home9055 - Home Depot Credit Services 02/11/2015 02/2015 19.73 1650pr - Parkview Villa North 2664 inte929 - Integrity Cleaning Solutions 02/11/2015 02/2015 414 165opr- Parkview Villa North 2665 leve - Level One 02/11/2015 02/2015 76.52 165opr - Parkview Villa North 2666 multi - Multihousing Credit Control 02/11/2015 02/2015 685 1650pr - Parkvlew Villa North 2667 ofir,8804 - Office Depot 02111/2015 02/2015 38.11 165opr - Parkview Villa North 2668 sher4110 - Sherwin- Williams Co. 02/11/2015 02/2015 220.64 165opr - Parkview Villa North 2669 stan0371 - Stanley Access Tecchnologies LLC 02/11/2015 02/2015 125.58 165opr - Parkview Villa North 2670 comc3517 - Comcast 02/18/2015 02/2015 61.29 1650pr - Parkvlew Villa North 2671 frat - Frattalone's /Metro Ace 02/18/2015 02/2015 18.52 165opr - Parkview Villa North 2672 home9055 - Home Depot Credit Services 02/18/2015 02/2015 13.8 165opr - Parkview Villa North 2673 Inte929 - Integrity Cleaning Solutions 02/18/2015 02/2015 403.65 165opr - Parkview Villa North 2674 koc17025 - K O Cleaning and Remodeling, Inc. 02/18/2015 02/2015 775 165opr- Parkview Villa North 2675 Popp - Popp.com 02/18/2015 02/2015 223.88 165opr - Parkview Villa North 2676 sitz - Sitzmann Construction dba Sitzmann Elec 02/18/2015 02/2015 1,021.76 165opr - Parkvlew Villa North 2677 adam - Adam's Pest Control, Inc. 02/25/2015 02/2015 75.23 165opr- Parkview Villa North 2678 buck8411 - Buckeye Cleaning Centers 02/25/2015 02/2015 120.49 1650pr - Parkvlew Villa North 2679 dire - Direct Home Appliance Services 02/25/2015 02/2015 61.41 165opr - Parkview Villa North 2680 frat - Frattalone's /Metro Ace 02/25/2015 02/2015 53.03 165opr - Parkvlew Villa North 2681 high8236 - High Profile Grounds Maintenance, 1 02/25/2015 02/2015 103.5 165opr - Parkvlew Villa North 2682 Inte929 - Integrity Cleaning Solutions 02/25/2015 02/2015 334.65 165opr - Parkvlew Villa North 2683 offi8804 - Office Depot 02/25/2015 02/2015 122.58 42,738.87 N m N P O1 m P P n n P P P P m e m m N N N N N N N in in N N O O W W w W w w N O O r O O N J VI W m W N r O W N V O O O A O O N O b m O b W V O Y Y m V O O N b m D 3 a ➢� w o� a p c n a � U m O z� 0 a n -� m ? b m e Q' •'• c m n •a• b u m m d p m n m m m a N b a °m F _ d aT " ° b a N n Wr P a N b W m �' W W N VVI N O P O W Y O w 9 m m N troll O O P b ip O O o N N O 1b11 N N UI e 0 i o C O m o r O 0 Vi O O O C 0 0 W W W b O b O N O VI N r O 0 0 0 0 0 0 O O O O O O O O O O O V d N b W W N 0 N N r m Y P V V N N Y V N W O J J J O W J N O in O J N W O O O O O O O b N A O 0 V W V V V O N b b m m N b a o.0 p N 41� e W 6 W W a o N N N N V U m m N W o oN O V Y O W W P O W W V O C6> r N O w w p r �p Z V J P Z O O Tall O O O W W N J Y V➢ Y r O b O O N O O O O O P D O O O O O b Y O O W D O O O r N Y N m W r b Y N N N m V m q m N r N W 0 A W m Y d W N N O Vmi V n O r O V° J b O O N N V 0 N O O N O p O O mW A A p q o 4 u N r o a o m P o o' Z. O O G G C o 0 A o m O O J o 0 0 o O w o 0 0 o O O O o 0 0 o O o O o Y m r r N b v V m b b N i0 m m W V O A V A N r Nm r P N P O O m o Y O N m W W m W a woo O 0 O O N N A O VI O m V A p N O VI W W f° V O A T O A d 4 d O m O P A A O N O O O O O O O O A 0 O N A U A A A O Y l N P w w b m m o A A A m V o O r m 0 A N W W P O Y y O r O N O N N> N VI O N W O b m W > d N Cl Cl . yoj rm O O P 4 O P O O O O O m P W O S O N A A A O O Z 4l m m V O O w O O N o O v 0 0 M o 00 o O O N N y� o O C V V �O O N m A O O J m O O➢ O O N O r D O O N N N W Y O W w N V A N N pyO1 P V O m O N N V ~~ N O Y N W r N P r V J a A A P r d o Ia/I O o O o 0 o O O Y O o N o° N o O A O o N N V W p N N n o°O a b'o°000 o o'NO°o o'o°o°o° ° oo° A am °OO °o °o a eo°o Ir: T r p n O y p 6 A G b a W N y O s g Y m ry _ass p m 1 p D C p m n A G d a G _D s 3 0 N O b b O N V H O O O b m0 V 10 N O 1Pp P P O O V N b w P A P A d W m o b q N V P o W N Y w N V P o w P `o o W N V P o 4 r o P J P N m 2 y 'pJ y^ 9 y y y P r 2 = d O O b O O 0 A O ] O d IxmE 1 O n a X a n r Sr rt0 R °m b y w °c w 3vm O � 3� 00 d u x ma4)Ll� Gl m° C ° a y^ m °-' .m. 'm• 3 x an d y �o P n 3. 8 S} � jp g a a c o q m a b a • m i n a a w44dDm m p Q a N O q O O O V N A A O O W 1D W O O b O r 0 0 0 d' O O N O O N P O 3 O O O N N N U q o m b O w w IW/I o o r O O N O o W o m ] R y °A 0 m e O °o 2 2 2 z D D D D WO DI OI Olo AI WI Olo b, D N V O O z z z a a n Y Y N N N V V � q q O O p O O O N y N q Y y O Y q N A m a J P o o m oo m `rp m o v iD o n N w �o 0 o VO m o p o o m o 4 O d A b O W � P W N Y N r A P VI N R 6 b q V o H F v A V J o Irll FAi IVII .A- V V m o o N o F °ns r � w m m �p .1p.na o °awmn°� n °oo °o. N S N q Y y O D WArVIWpVImr AmC P o o n N w �o 0 o VO m o p o o m o 4 O A b O r L q V O P O O V O W W J O INII N n N D y ] r WArVIWpVImr AmC 3 Parkview Villa North Financial Statement Overview March 2015 Revenue: Occupancy for the month of March 2015 was 97% occupied; Rent Revenue was slightly under budget (unfavorable) Total Revenue for March was over budget (favorable) as grant income was recognized Administrative Expenses: Administrative costs for the North were slightly over budget (unfavorable) Other Renting Expenses were over budget (unfavorable) and reflect the cost of background screening of applicants Office Supply expenses were slightly over budget (unfavorable) Utilities: Utilities Expenses were over budget (unfavorable) Fuel Oil was under budget (favorable) Electric was over budget (unfavorable) and reflects Feb. billing Gas was over budget (unfavorable) and reflects Feb. billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operatine and Maintenance Expense (supplies): Operating and Maintenance Expenses were over budget (unfavorable) and reflect costs of preparation for REAC Inspection Janitor and Cleaning Contract was over budget (unfavorable) and reflects cost of contract cleaning Maintenance Supplies was over budget (unfavorable) and reflects cost of repair items needed Garbage and Trash was under budget (favorable) Snow Contract was slightly over budget (unfavorable) Repairs contract was under budget (favorable) Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs was over budget (unfavorable) and reflects the cost of water heater repairs and fan repair Decorating contract was over budget (unfavorable) and reflects the cost of unit turn overs Misc. Operating and Maintenance Expense was under budget (favorable) Parkview Villa -North Balance Sheet March 2015 Books = Accrual Assets 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Amounts Receivable 13100 Due From Other Funds 13200 Due From Other Government Units Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 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 20,830.37 457.00 898,424.28 2,445.40 0.00 36.12 108,010.00 1,030,203.17 56,721.27 4,769.49 551.74 19,013.03 25,958.37 7,328.92 114,342.82 915,860.35 915,860.35 1,030,203.17 r. 4/13/2015 2:54 PM Parkview Villa -North Income Statement March 2015 Books = Accrual Expenses Personal Services 1000 -46330 Accrued Salaries Month to Date % Year to Date % Revenue 8,929.00 16.14% 26,787.00 23.45% 33160 -46330 Federal Grant 24,974.26 45.13% 24,974.26 21.8746 36220 -46330 Gen. Government Rents 29,388.00 53.11% 87,126.00 76.28% 36225 -46330 Nondwelling Rents 306.00 0.55% 952.00 0.83% 36290.96330 Other Miscellaneous Revenue 664.14 1.20% 1,165.14 1.02% 39120 -46330 Recovery Damage City Property - 0.00% - 0.00% Total Revenue 55,332.40 100.00% 114,217.40 100.000/6 Expenses Personal Services 1000 -46330 Accrued Salaries 8,929.00 16.14% 26,787.00 23.45% Total Personal Services 8,929.00 16.14% 26,787.00 23.45% Supplies 4,866.00 8.79% 14,598.00 12.78% 2000 -46330 Office Supplies 198.68 0.36% 404.11 0.35% 2010 -46330 Minor Equipment 94.53 0.17% 889.76 0.78% 2160 -46330 Maint. & Construct Materials 1,518.82 2.74% 3,468.22 3.04% 2171 -46330 General Supplies 740.79 1.34% 1,287.90 1.13% Total Supplies 2,552.82 4.61% 6,049.99 11.80% Other Services & Charges 3040 -46330 Legal Fees 0.00 0.00% 0.00 0.00% 3050 -46330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 3060 -46330 Management Services 4,866.00 8.79% 14,598.00 12.78% 3100 -46330 Protective Services 0.00 0.00% 170.78 0.15% 3210 -46330 Telephone &Telegraph 361.68 0.65% 861.18 0.75% 3430 -46330 Advertising Other 0.00 0.00% 0100 0.00% 3600 -46330 Insurance & Bonds 1,590.15 2.87% 4,769.49 4.18% 3810 -46330 Electric 4,261.34 7.70% 13,476.42 11.80% 3820 -46330 Water 0.00 0.00% 0.00 0.00% 3830 -46330 Gas 6,730.03 12.16% 12,541.09 10.98% 3840.46330 Refuse 32.29 0.06% 115.79 0.10% 3850 -46330 Sewer 0.00 0.00% 0.00 0.00% 4000.46330 Repair & Maint. Services 17,381.70 31.41% 27,049.76 23.68% 4050 -46330 Garage, Labor 0.00 0.00% 0.00 0.00% 4100 -46330 Rents & Leases 636.75 1.15% 1,321.75 1.16% 4300 -46330 Miscellaneous Charges - 420.91 -0.76% - 201.19 -0.18% 4315 -46330 PILOT 1,730.56 3.13% 5,191.68 4.55% 4390 -46330 Taxes & Licenses 1,243.38 0.00% 1,243.38 1.09% 4500 -46330 Administrative Expenses 0.00 0.00% 0.00 0.00% 4850.46330 Interest on Deposits 15.01 0.03% 42.48 0.04% Total Other Services & Charges 38,427.98 69.450/a 81,180.61 71.08% Page 2 of 10 4113/2015 2:54 PM Capital Outlay 5120 -46330 Building & Improvements 0.00 0,00% - 0.00% Total Capital Outlay 0.00 0.00% 0.00 0.00% Total Expense 49,909.80 90.20% 114,017.60 99.83% Excess (Deficit) Revenue over Expense 5,422.60 9.80% 199.80 0.17% Page 3 of 10 4/13/2015 2:54 PM Parkvicw Villa -North (165) Cash Flow Statement Period = March 2015 Book = Accrual Month to Date Revenue 33160 Federal Grant 24,974.26 36220 Gen. Government Rents 29,388.00 36225 Nondwelling Rents 306.00 36290 Other Miscellaneous Revenue 664.14 39120 Recovery Damage City Property 0.00 Total Revenue 55,332.40 Expenses Personnel Services 1000 Accrued Salaries 8,929.00 Total Personnel Services 8,929.00 Supplies 2000 Office Supplies 198,68 2010 Minor Equipment 94.53 2160 Maint. & Construct Materials 0.00 2171 General Supplies 2,259.61 2280 Vehicle Parts 0.00 Total Supplies 2,552.82 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 0.00 3060 Management Services 4,866.00 3100 Protective Services 0.00 3210 Telephone & Telegraph 361.68 3430 Advertising Other 0.00 3600 Insurance & Bonds 1,590.15 3810 Electric 4,261.34 3820 Water 0.00 3830 Gas 6,730.03 3840 Refuse 32.29 3850 Sewer 0.00 4000 Repair & Maint. Services 17,381.70 4050 Garage, Labor Burd. 0.00 4100 Rent & Leases 636.75 4300 Miscellaneous Charges 420.91 4315 PILOT 1,730.56 4390 Taxes & Licenses 1,243.38 4500 Administrative Expenses 0.00 4850 Interest on Deposits 15.01 5120 Building & Improvement 0.00 Total Other Services & Charges 38,427.98 Total Expenses 49,909.80 Exce ss (Deficit) Revenue over Expenses 5,422.60 Page 4 of 10 Cash Flow Statement Period = March 201 S Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 20220 Due to Resident Council 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Page 5 of 10 4/13/2015 2:54 PM Month to Date 0.00 0.00 - 853.48 200.00 -36.12 0.00 - 12,082.87 1,590.15 0.00 312.24 1,730.56 3,256.73 (5,882.79) (460.19) Beg Cash End Cash Difference 21,290.56 20,830.37 (460.19) 457.00 457.00 - 898,424.28 898,424.28 - 920,171.84 919,711.65 (460.19) Parkview Villa -North (165) General Ledger Period = Mar 2015 Book = Accrual; Tree = ysi_tb Proper Date Person /Description Reference Debit Credit Balance Remarks 1000 -46330 Accrued Salaries 17,858.00 = Beginning Balance = 165 3/31/2015 :PostRecurring Monthly recurring a RC 8,929.00 0.00 26,787.00 R/C CHC PR Mgmt Fee Net Change = 8,929.00 0 26,787.00 = Ending Balance = 2000 -46330 Office Supplies 205.43 = Beginning Balance = 165 2/20/2015 Office Depot (offi8804) 7.56559E +11 50.95 0.00 256.38 wipes /pinnr /fidr /pens... 165 2126/2015 Office Depot (offi8804) 7.57771E +11 89.49 0.00 345.87 ppr;corr tape;pncl cup;fldrs -699 165 2/27/2015 Office Depot (offi8804) 7.57771E +11 3.24 0.00 349.11 folders-69% 165 3/23/2015 CommonBond Housing (chc) 032315compsupp 55.00 0.00 404.11 computer support 02/20- 03/23/ Net Change= 198.68 404.11 = Ending Balance = 2010 -46330 Minor Equipment 795.23 = Beginning Balance = 165 3/11/2015 Hamernick Decorating Center (hart CG502281 94.53 0.00 889.76 min installation charge -69% Net Change =94.53 889.76 = Ending Balance = 2160 -46330 Maint. & Construct Materials 1,949.40 = Beginning Balance = 165 2/20/2015 DecoShleld Systems II, Inc. (deco: 22763 19.67 0.00 1,969.07 plugs /end caps 165 2/24/2015 Home Depot Credit Services (home FCH005583420 13.80 0.00 1,982.87 late fee -69% 165 2/27/2015 HD Supply Facilities Maintenance, 19135731938 194.32 0.00 2,177.19 protectors/bibs 165 2/28/2015 Frattalone's /Metro Ace (frat) 021315R 47.49 0.00 2,224.68 kilz/lock kit/bibs/seal knock... 165 3/5/2015 HD Supply Facilities Maintenance, 19135854844 38.30 0.00 2,262.98 range splash guards -69% 165 3/5/2015 HD Supply Facilities Maintenance, 19135854844 3.51 0.00 2,266.49 plate screws -69% 165 3/5/2015 HD Supply Facilities Maintenance, 19135854844 135.08 0.00 2,401.57 stn s1r;0 tape;spry pnt;K S -69% 165 3/6/2015 HD Supply Facilities Maintenance, 19135900532 148.49 0.00 2,550.06 ceiling fixture -69% 165 3/6/2015 Home Depot Credit Services (hom(9140212 6.31 0.00 2,556.37 pb blaster -69% 165 3/612015 Home Depot Credit Services (hom(9140209 156.04 0.00 2,712.41 lamp kits; bskts; misc -69% 165 3/8/2015 Home Depot Credit Services (home 7192187 84.99 0.00 2,797.40 maint supplies 165 3/9/2015 Frattalone's /Metro Ace (frat) 02141OR 5.15 0.00 2,802.55 misc maint supplies -69% 165 3/912015 Frattalone's /Metro Ace (frat) 021411R 30.93 0.00 2,833.48 Kwik Seal -69% 165 3/9/2015 Frattalone's /Metro Ace (frat) 021408R 12.56 0.00 2,846.04 foam cvr;pntbmh;caps;plugs -69 165 3/9/2015 HD Supply Facilities Maintenance, 19135929078 200.72 0.00 3,046.76 misc plumbing supplies -69% 165 3/9/2015 HD Supply Facilities Maintenance, 19135929078 35.84 0.00 3,082.60 cabinet knobs -69% 165 3/9/2015 HD Supply Facilities Maintenance, 19135929078 49.64 0100 3,132.24 light fixtures -69% 165 3/13/2015 HD Supply Facilities Maintenance, 19136058397 38.18 0.00 3,170.42 light bulbs -69% 165 3/13/2015 HD Supply Facilities Maintenance, 19136058397 277.48 0.00 3,447.90 kfaucet-69% 165 3/13/2015 Frattalone's /Metro Ace (frat) 021458R 5.59 0.00 3,453.49 gasket spud 165 3/1312015 Frattalone's /Metro Ace (frat) 02146OR 14.73 0.00 3,468.22 faucet supply Net Change= 1,518.82 3,468.22 = Ending Balance = 2171 -46330 General Supplies 547.11 = Beginning Balance = 165 2/25/2015 Sherwin - Williams Co. (sher4110) 3568 220.64 0.00 767.75 paint -69% 165 2/26/2015 Sherwin- Williams Co.(sher4110) 3980 110.32 0.00 878.07 paint 165 3/6/2015 Buckeye Cleaning Centers (1buck84875126 152.66 0.00 1,030.73 twls /bags /fuel 165 3/23/2015 Sherwin- Williams Co. (sher4130) 59391 220.64 0.00 1,251.37 paint/recycle 165 3/25/2015 HD Supply Facilities Maintenance, 19136301375 36.53 0.00 1,287.90 TP Net Change= 740.79 1,287.90 = Ending Balance = 3060 -46330 Management Services 9,732.00 = Beginning Balance = 165 3/31/2015 CommonBond Housing (chc) 033115mgmt 13,795.00 0.00 23,527.00 mgmt fee 03/15 165 3/31/2015 :PostRecurring Monthly recurring a RC 0.00 8,929.00 14,598.00 R/C CHC PR Mgmt Fee Net Change= 4,866.00 14,598.00 = Ending Balance = 3100.46330 Protective Services 170.78 = Beginning Balance = Net Change =0.00 170.78 = Ending Balance = 3210 -46330 Telephone & Telegraph 499.50 = Beginning Balance = 165 2/28/2015 Popp•com (Popp) 992247623 223.87 0.00 723.37 phone -69% 3/15 165 3/1/2015 Level One (leve) 0486561IN 76.52 0.00 799.89 answering service 3/15 165 3/2/2015 Comcast (comc3517) 877210505019618: 61.29 0.00 861.18 internet -69% 3/11- 4/10/15 Net Change= 361.68 861.18 = Ending Balance = 3600 -46330 Insurance & Bonds 3,179.34 = Beginning Balance = 165 3/31/2015 :PostRecurring Monthly recurring a RC 1,590.15 0.D0 4,769.49 C of Columbia Heights Ins Accrl Net Change= 1,590.15 4,769.49 = Ending Balance = 3810 -46330 Electric 9,215.08 = Beginning Balance = 165 3/11/2015 %cel Energy (xcel) 5150441553 03/11, 4,261.34 0.00 13,476.42 e-69% 2/7- 3/9/15 Net Change= 4,261.34 13,476.42 = Ending Balance = 3830 -46330 Gas 5,811.06 = Beginning Balance = 165 3/9/2015 CenterPoint Energy (cent) 55199657 03/09/1' 6,634.31 0.00 12,445.37 G- 02/04- 03/05/15 165 3/9/2015 CenterPoint Energy (cent) 55199657 03/09/1! 95.72 0.00 12,541.09 late fee Net Change= 6,730.03 12,541.09 = Ending Balance = 3840 -46330 Refuse 83.50 = Beginning Balance = 165 2/28/2015 Advanced Disposal(advo6484) G50004067780 32.29 0.00 115.79 trash -69% 2/20/15 Net Change =32.29 0 115.79 = Ending Balance = 4000 -46330 Repair & Maint. Services 9,668.06 = Beginning Balance = 165 12/31/2014 LBP Mechanical, Inc (Ibpm) W21764 275.00 0.00 9,943.06 repair heater 12/30/14 165 2/16/2015 C & D Communications, Inc. (c&dc 24513 213.72 0.00 10,156.78 repairs #309 2/13/15 165 2/18/2015 Drain King, Inc.(drai7740) 95258 97.98 0100 10,254.76 shower line clear 165 2/20/2015 Integrity Cleaning Solutions (inte9:4202 545.10 0.00 10,799.86 bid maint 165 2/20/2015 Integrity Cleaning Solutions (inte9:42022 386.40 0.00 11,186.26 bldg maint/cleaning 2/16- 20/20: 165 2/20/2015 Integrity Cleaning Solutions (inte9:42022 72.45 0.00 11,258.71 heavy salt 165 2/24/2015 LBP Mechanical, Inc (Ibpm) W21606 414.20 0.00 11,672.91 water heater repair- 01/07/15 165 2/25/2015 LBP Mechanical, Inc (Ibpm) W21676 1,054.40 0.00 12,727.31 wtr htr rep- 01/23- 01/27/15 165 2/25/2015 LBP Mechanical, Inc (Ibpm) W21620 837.95 0.00 13,565.26 fan repair- 01/14- 01/16/15 165 2/27/2015 Integrity Cleaning Solutions (Inte9:4201 403.65 0.00 13,968.91 bid maint - 02/23- 02/27/15 165 2/27/2015 LBP Mechanical, Inc (Ibpm) W21784 512.33 0.00 14,481.24 fix glycol leak -69% 2110115 165 2/27/2015 LBP Mechanical, Inc (Ibpm) W21747 1,213.03 0.00 15,694.27 water heater repairs -69% 2/15/ 165 2/27/2015 LBP Mechanical, Inc (Ibpm) W21748 204.84 0.00 15,899.11 heating repairs-69% 2/15/15 165 3/1/2015 Kone Inc.(kone) 221698593 738.10 0.00 16,637.21 main- 03/01- 03/31/15 165 3/4/2015 Integrity Cleaning Solutions (inte9:2630 207.00 0.00 16,844.21 garbage removal -69% #A 165 3/4/2015 Integrity Cleaning Solutions (inte9.2630a 403.65 0.00 17,247.86 cleaning /detail elevators 165 3/5/2015 Adam's Pest Control, Inc. (adam) 959432 72.61 0.00 17,320.47 exterm serv- 03/05/15 165 3/6/2015 K O Cleaning and Remodeling, Inc.3335 750.00 0.00 18,070.47 paint/finish/rep 165 3/6/2015 K 0 Cleaning and Remodeling, Inc. 3336 5,000.00 0.00 23,070.47 repairs/painting -molt apts 165 3/8/2015 Integrity Cleaning Solutions (inte9:2623 310.50 0.00 23,380.97 cleaning /groundskeeping 165 3/9/2015 Integrity Cleaning Solutions (inte9:2624 1,276.50 0.00 24,657.47 Spring cleaning -69% #A;B 165 3/13/2015 Integrity Cleaning Solutions (inte9:2622 69.00 0.00 24,726.47 caretaking-69% 165 3/13/2015 Integrity Cleaning Solutions (mte%2621 403.65 0.00 25,130.12 caretaking -69% 165 3/20/2015 Integrity Cleaning Solutions (inte9:2628 382.95 0.00 25,513.07 caretaking -69% 165 3/20/2015 Integrity Cleaning Solutions (inte9: 2628 72.45 0.00 25,585.52 heavy salt -69% 165 3/21/2015 Integrity Cleaning Solutions (inte9:9 586.50 0.00 26,172.02 cleaning 165 3/25/2015 HD Supply Facilities Maintenance, 19136301375 77.34 0.00 26,249.36 filters 165 3/26/2015 Integrity Cleaning Solutions (inte9:8 138.00 0.00 26,387.36 caretaking 165 3/27/2015 Integrity Cleaning Solutions(inte9: 10 258.75 0.00 26,646.11 cleaning- 03/23- 03/27/15 165 3/27/2015 Integrity Cleaning Solutions (inte9:7 403.65 0.00 27,049.76 mnt/clean /salt- 03/23- 03/27/15 Net Change= 17,381.70 27,049.76 = Ending Balance = 4100 -46330 Rents & Leases 685.00 = Beginning Balance = 165 2/28/2015 Multihousing Credit Control (multi 15020333 630.00 0.00 1,315.00 residential screening 2/15 165 3/8/2015 Talx the Work Number (talx) 1785871sites 6.75 0.00 1,321.75 ee verify 02/15 Net Change= 636.75 1,321.75 = Ending Balance = 4300 -46330 Miscellaneous Charges 219.72 = Beginning Balance = 165 3/19/2015 City Wide Lock & Safe (cit4054) 14268 136.14 0.00 355.86 cut keys /service call 165 3/31/2015 Blaine Lock Safe Inc 2963 0.00 557.05 - 201.19 Refund - Billed incorrectly 06.09 Net Change =- 420.91 - 201.19 - Ending Balance = 4315 -46330 PILOT 3,461.12 = Beginning Balance = 165 3/31/2015 :PostRecurring Monthly recurring a RC 1,730.56 0.00 5,191.68 Anoka Cty Property Tax Accrual Net Charge= 1,730.56 5,191.68 = Ending Balance = 4390 -46330 Taxes & Licenses 0.00 = Beginning Balance = 165 3/30/2015 Columbia Heights Fire Dept (colu8: 032515165166 -429 1,243.38 1,243.38 annual rental license Net Change= 1,243.38 1,243.38 = Ending Balance = 4850 -46330 interest on Deposits 27.47 = Beginning Balance = 165 3/31/2015 Sec Dep interest accrual Gil 15.01 0.00 42.48 Sec Dep interest accrual Net Change= 15.01 42.48 = Ending Balance = 59,395.85 9,486.05 Parkview Villa North Bank Reconciliation Report 03/31/2015 5016456 Balance Per Bank Statement as of 0 3/3112 01 5 Outstanding Deposits Deposit date Deposit number 0313112015 705 Plus: Outstanding Deposits Outstanding Checks Check date Check number 02/04/2014 2327 06/17/2014 2446 08/19/2014 2488 01/14/2015 2634 03/18/2015 2710 03/18/2015 2711 03/25/2015 2716 03/25/2015 2717 03/2512015 2719 03/25/2015 2721 Less: Outstanding Checks Other Items Pavee t0008445 - Schuster t0013260 - Vig t0004040 - Camp cent2000 - Central Lock 8 Safe siva7400 - David Sivanich t0004019 - Haugland frat - Frattalone's /Metro Ace home7 - HD Supply Facilities Maintenance, Ltd koc17025 - K O Cleaning and Remodeling, Inc. off8804 - Office Depot Date Notes 01/12/2015 Returned item t0008243 Plus /Minus: Other Items Reconciled Bank Balance Balance per GL as of 03131/2015 Reconciled Balance Per G/L Difference Cleared Items : (Reconciled Bank Balance And Reconciled Balance Per G /L) 04/02/2015 21,671.27 Amount 2,048.05 2,048.05 Amount 419.94 0.65 276.52 125.00 6.33 166.52 32.88 325.38 750.00 92.73 2,195.95 Amount - 693.00 - 693.00 20,830.37 20,830.37 20,830.37 0.00 Parkview Villa North 04/02/2015 Bank Reconciliation Report 03/31/2015 5016456 Cleared Checks Date Tran # Notes Amount Date Cleared 02/18/2015 2673 inte929 - Integrity Cleaning Solutions 403.65 03/31/2015 02/18/2015 2676 sitz - Sitzmann Construction dba Sitzmann Elect 1,021.76 03/31/2015 02125/2015 2677 adam - Adam's Pest Control, Inc. 75.23 03/31/2015 02/25/2015 2678 buck8411 - Buckeye Cleaning Centers 120.49 03/31/2015 02/25/2015 2679 dire - Direct Home Appliance Services 61.41 03/31/2015 02125/2015 2680 frat- Frattalone's/Metro Ace 53.03 03/310015 02/25/2015 2681 high8236 - High Profile Grounds Maintenance, Inc. 103.50 03/31/2015 02/25/2015 2682 inte929 - Integrity Cleaning Solutions 334.65 03131/2015 02125/2015 2683 offi8804 - Office Depot 122.58 03/31/2015 03/04/2015 2684 chc - CommonBond Housing 13,795.00 03/31/2015 03/04/2015 2685 cumm - Cummins NPower LLC 1,144.63 03/31/2015 03/04/2015 2686 inte929 - Integrity Cleaning Solutions 403.65 03/31/2015 03/04/2015 2687 kone- Kone Inc. 738.10 03/31/2015 03/04/2015 2688 xcel - Xcel Energy 4,493.50 03/31/2015 03/11/2015 2689 cent - CenterPoint Energy 6,381.19 03/31/2015 03/11/2015 2690 colu - City of Columbia Heights 4,063.77 03/31/2015 03/11/2015 2691 coluhra - Columbia Heights HRA 25,500.00 03/31/2015 03/11/2015 2692 deco272 - DecoShield Systems II, Inc. 19.67 03/31/2015 03/11/2015 2693 frat - Frattalone's/Metro Ace 47.49 03/31/2015 03/11/2015 2694 high8236 - High Profile Grounds Maintenance, Inc. 351.90 03131/2015 03/11/2015 2695 home7 - HD Supply Facilities Maintenance, Ltd. 1,171.05 03/31/2015 03/11/2015 2696 inte929- Integrity Cleaning Solutions 1,866.45 03/31/2015 03/1112015 2697 Ibpm - LBP Mechanical, Inc 4,511.75 03/31/2015 03/1112015 2698 leve - Level One 76.52 03/31/2015 03/11/2015 2699 offi8804 - Office Depot 17.24 03/31/2015 03/11/2015 2700 sher4110 - Sherwin- Williams Co. 471.81 03/31/2015 03/18/2015 2701 advc6484- Advanced Disposal 32.29 03/31/2015 03/18/2015 2702 all - All Inc. 580.00 03/31/2015 03118/2015 2703 c &dc - C & D Communications, Inc. 213.72 03/31/2015 03/18/2015 2704 chc - CommonSond Housing 13,822.50 03/31/2015 03/18/2015 2705 comc3517- Comcast 61.29 03/31/2015 03/18/2015 2706 frat- Frattalone's/Metro Ace 36.08 03/31/2015 03/18/2015 2707 multi - Mulfihousing Credit Control 630.00 03/31/2015 03/18/2015 2708 offi8804 - Office Depot 50.95 03/31/2015 03/18/2015 2709 Popp - Popp.00m 223.87 03/31/2015 03/25/2015 2712 adam - Adam's Pest Control, Inc. 72.61 03/31/2015 03/25/2015 2713 buck8411 - Buckeye Cleaning Centers 152.66 03/31/2015 03/25/2015 2714 chc - CommonBond Housing 6.75 03/31/2015 03/25/2015 2715 drai7740 - Drain King, Inc. 97.98 03/31/2015 03/25/2015 2718 home9055 - Home Depot Credit Services 169.84 03/31/2015 03/25/2015 2720 kone - Kone Inc. 738.10 03/31/2015 Total Cleared Checks 84,238.66 Cleared Deposits Date Tran # Notes Amount Date Cleared 03/03/2015 692 18,079.00 03/31/2015 0310512015 693 9,588.00 03/31/2015 03/0612015 694 2,039.00 03/31/2015 03/09/2015 695 786.00 03/31/2015 Cleared Deposits Date Tran # 03/11/2015 696 03/18/2015 698 03/19/2015 699 03/20/2015 697 03/20/2015 701 03/25/2015 700 03/26/2015 704 Total Cleared Deposits Cleared Other Items Parkview Villa North Bank Reconciliation Report 03/31/2015 5016456 Notes 04/02/2015 Amount Date Cleared 51.00 03/31/2015 503.00 03/31/2015 263.00 03/31/2015 72.14 03/31/2015 89.00 03/31/2015 348.00 03131/2015 419.00 03/3112015 32,237.14 Date Tran # Notes Amount Date Cleared 03/10/2015 JE 227584 ELoccs Operating Fund receipt 8,473.00 03/31/2015 03/11/2015 RC 1254152 Returned item t0014864 - 303.00 03/31/2015 03/27/2015 JE 227583 ELoccs Operating Fund receipt 16,501.26 03/31/2015 Total Cleared Other Items 24,671.26 Date 3/31/15 Page 1 Primary Account @XXXXX @6456 Enclosures 52 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G A C C O U N T S - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: Deposits and Credits Date - SAME DAY DELIVERY OF STATEMENT 3/03 DDA REGULAR DEPOSIT - PASSWORD PROTECTED DDA REGULAR DEPOSIT 9,588.00 - EASY STORAGE DDA REGULAR DEPOSIT 2,039.00 CONTACT YOUR BANKER FOR DETAILS! 8,473.00 CR NORTHEAST PUBLIC FUNDS ACCT Number of Images 52 Account Number @XXXXX @6456 Statement Dates 3/01/15 thru 3/31/15 Previous Balance 49,001.53 Days in the Statement Period 31 13 Deposits /Credits 57,211.40 Average Ledger 43,663 42 Checks /Debits 84,541.66 Average Collected 42,415 Electronic Debit .00 DDA REGULAR DEPOSIT 503.00 Service Charge .00 89.00 3/25 Interest Paid .00 3/26 DDA REGULAR DEPOSIT Ending Balance 21,671.27 MISC PAY HUD TREAS 310 16,501.26 CR Deposits and Credits Date Description Amount 3/03 DDA REGULAR DEPOSIT 18,079.00 3/05 DDA REGULAR DEPOSIT 9,588.00 3/06 DDA REGULAR DEPOSIT 2,039.00 3/10 MISC PAY HUD TREAS 310 8,473.00 CR 9101036151 03/10/15 ID #- 411269646860103 TRACE #- 101036151211971 3/10 DDA REGULAR DEPOSIT 786.00 3/11 DDA REGULAR DEPOSIT 51.00 3/19 DDA REGULAR DEPOSIT 72.14 3/19 DDA REGULAR DEPOSIT 263.00 3/19 DDA REGULAR DEPOSIT 503.00 3/23 DDA REGULAR DEPOSIT 89.00 3/25 DDA REGULAR DEPOSIT 348.00 3/26 DDA REGULAR DEPOSIT 419.00 3/27 MISC PAY HUD TREAS 310 16,501.26 CR 9101036151 03/27/15 ID #- 411269646860103 TRACE #- 101036153204390 Date 3/31/15 Page 2 Primary Account @XXXXX @6456 Enclosures 52 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Charges and Debits Date Description Date Balance Amount Balance 3/01 3/11 RETURN ITEM DEBIT 65,833.45 3/24 303.00 3/02 47,859.26 3/11 64,843.35 3/25 Checks in serial order 65,759.55 3/16 62,976.90 3/26 6,672.62 Date Check# Amount Date Check# Amount 3/09 2673 403.65 3/16 2696 1,866.45 3/06 3/02 2676* 1,021.76 3/18 2697 4,511.75 74,862.95 3/03 2677 75.23 3/17 2698 76.52 E N D 0 F 3/02 2678 120.49 3/24 2699 17.24 3/04 2679 61.41 3/18 2700 471.81 3/05 2680 53.03 3/25 2701 32.29 3/03 2681 103.50 3/24 2702 580.00 3/09 2682 334.65 3/31 2703 213.72 3/06 2683 122.58 3/23 2704 13,822.50 3/10 2684 13,795.00 3/26 2705 61.29 3/09 2685 1,144.63 3/26 2706 36.08 3/09 2686 403.65 3/24 2707 630.00 3/11 2687 738.10 3/27 2708 50.95 3/10 2688 4,493.50 3/25 2709 223.87 3/19 2689 6,381.19 3/30 2712* 72.61 3/18 2690 4,063.77 3/30 2713 152.66 3/17 2691 25,500.00 3/31 2714 6.75 3/18 2692 19.67 3/30 2715 97.98 3/19 2693 47.49 3/30 2718* 169.84 3/18 2694 351.90 3/31 2720* 738.10 3/19 2695 1,171.05 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 3/01 49,001.53 3/10 65,833.45 3/24 6,259.15 3/02 47,859.26 3/11 64,843.35 3/25 6,350.99 3/03 65,759.55 3/16 62,976.90 3/26 6,672.62 3/04 65,698.14 3/17 37,400.38 3/27 23,122.93 3/05 75,233.11 3/18 27,981.48 3/30 22,629.84 3/06 77,149.53 3/19 21,219.89 3/31 21,671.27 3/09 74,862.95 3/23 7,486.39 * * * E N D 0 F S T A T E M E N T Parkview Villa North Payment Summary March 2015 59,416.64 Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 2661 colu - City of Columbia Heights 03/09/2015 03/2015 (23,899.56) 165opr - Parkview Villa North 2684 chc - CommonBond Housing 03/04/2015 03/2015 13,795.00 165opr - Parkview Villa North 2685 cumm - Cummins NPower LLC 03/04/2015 03/2015 1,144.63 1650pr - Parkview Villa North 2686 inte929 - Integrity Cleaning Solutions 03/04/2015 0312015 403.65 165opr- Parkview Villa North 2687 kone - Kone Inc. 03/04/2015 03/2015 738.10 165opr- Parkview Villa North 2688 xcel- Xcel Energy 03/04/2015 03/2015 4,493.50 165opr- Parkview Villa North 2689 cent- CenterPoint Energy 03/11/2015 03/2015 6,381.19 1650pr - Parkview Villa North 2690 colu - City of Columbia Heights 03/11/2015 03/2015 4,063.77 165opr - Parkview Villa North 2691 coluhra - Columbia Heights HRA 03/11/2015 03/2015 25,500.00 3650pr - Parkview Villa North 2692 dec0272 - DecoShield Systems 11, Inc. 03/11/2015 03/2015 19.67 3650pr - Parkview Villa North 2693 frat - Frattalone's /Metro Ace 03/11/2015 03/2015 47.49 1650pr - Parkview Villa North 2694 high8236 - High Profile Grounds Maintenance, 1 03/11/2015 03/2015 351.90 165opr - Parkview Villa North 2695 home? - HD Supply Facilities Maintenance, Ltd. 03/11/2015 03/2015 1,171.05 1650pr - Parkview Villa North 2696 inte929 - Integrity Cleaning Solutions 03/11/2015 03/2015 1,866.45 1650pr - Parkview Villa North 2697 Ibprrl - LBP Mechanical, Inc 03/11/2015 03/2015 4,511.75 165opr - Parkview Villa North 2698 leve - Level One 03/11/2015 03/2015 76.52 1650pr - Parkvlew Villa North 2699 oR18804 - Office Depot 03/11/2015 03/2015 17.24 1650pr - Parkview Villa North 2700 sher4130 - Sherwin- Williams Co. 03/11/2015 03/2015 471.81 165opr- Parkview Villa North 2701 advc6484 - Advanced Disposal 03/18/2015 03/2015 32.29 1650pr - Parkview Villa North 2702 all - All Inc. 03/18/2015 03/2015 580.00 3650pr - Parkview Villa North 2703 c &dc - C & D Communications, Inc. 03/18/2015 03/2015 213.72 1650pr - Parkview Villa North 2704 chc - CommonBond Housing 03/18/2015 03/2015 13,822.50 165opr - Parkview Villa North 2705 comc3517 - Comcast 03/18/2015 03/2015 61.29 1650pr - Parkvlew Villa North 2706 frat - Frattalone's /Metro Ace 03/18/2015 03/2015 36.08 3650pr - Parkview Villa North 2707 multl - Multihousing Credit Control 03/18/2015 03/2015 630.00 3650pr - Parkview Villa North 2708 of08804 - Office Depot 03/18/2015 03/2015 50.95 165opr - Parkview Villa North 2709 Popp - Popp.com 03/18/2015 03/2015 223.87 1650pr - Parkvlew Villa North 2710 siva7400 - David Sivanlch 03/18/2015 03/2015 6.33 1650pr - Parkvlew Villa North 2711 10004019 - Haugland 03/18/2015 03/2015 166.52 1650pr - Parkview Villa North 2712 adam - Adam's Pest Control, Inc. 03/25/2015 03/2015 72.61 165opr - Parkview Villa North 2713 buck8411 - Buckeye Cleaning Centers 03/25/2015 03/2015 152.66 165opr - Parkview Villa North 2714 chc - CommonDond Housing 03/25/2015 03/2015 6.75 1650pr - Parkview Villa North 2715 dral7740 - Drain King, Inc. 03/25/2015 03/2015 97.98 1650pr - Parkvlew Villa North 2716 Prat - Frattalone's /Metro Ace 03/25/2015 03/2015 32.88 1650pr - Parkview Villa North 2717 home? - HD Supply Facilities Maintenance, Ltd. 03/25/2015 03/2015 325.38 165opr - Parkvlew Villa North 2718 home9055 - Home Depot Credit Services 03/25/2015 03/2015 169.84 1650pr - Parkview Villa North 2719 koc17025 - K O Cleaning and Remodeling, Inc. 03/25/2015 03/2015 750.00 3650pr - Parkview Villa North 2720 kone - Kone Inc. 03/25/2015 03/2015 738.10 165opr - Parkvlew Villa North 2721 0115i8804 - Office Depot 03/25/2015 03/2015 92.73 59,416.64 mj - f!{ ®/ _ ! | , • , ® ., , , / � ( \ }k\ � !(� ) / \[\ \[ | \ \ §| \ }k\ � !(� ) T O q P A Y r O O O x O V V V P P P P q N N N b P N V q O W N O N V P O W P b O W N V g O A r O J N N Vi 0 0 u Z j E Y Sj A y ? j y T y Y Y F = W O 9 d O b X O% - Z i O T x 9 O R O N ?' i O N W T p rer N X 3 X aG G .Oi y 2 2 0 0 L 0 2 m P Q- N - ^ny = 3 P v R aaa Z m ° _. o W y N a N a x d T G v N •, N gb 9 R X W O d Y N P'L '� p n 3 O S) N g O pOJ g d O 9 j i i i ]�0.'�.�^.� Oa m ] m w 3 c P y ^ x x m ] 3 N R p a - K 5 X G N v n G G P a ? m= a Sul m T T y A V N O b o W A N A tDi a N J a V r C u b O q O O O O b P O O W W Om - m O O O b N V1 A m P b N r W o o O O N O o 0 0 0 R ] O T W V V W Y N b O O m n O O O o b q q m O q V m N w O O w g m O N r q V 0 0 O O O q V N O W O N °O g V V V O W V IVII V 0 o O W O r d N N b d O w w G v Y O O O O Y b V V W J W N W P N O O g O W O O O O O P A d b J J o O O O O W N W q P r V P N N= uPi W N W i W 2 Z 2 W N W U U P W o o W D D Z D W y N O N D fp tNl1 W Y Y 0Y A P r A N r W w D WU r c V O O O V A 1•PO W w b r° o r N a m i o O o 0 o U u A p O x b q q W N Y Y y O W W Y P P m O m W W O N N U N N Y V A N J N> N N S W O O O O W Y O O 0 0 N O p O W °o w e o 0 o e r o x n a o° O .°- y< O M 0 0 0 o y A b;O A wm A N m m m o .Ni mV q �O ma P�INn ^ .o b o o 0 o r w r O 2 2 2 N D D D D N P N v V V W W W A N A N Y D Q W N N N O c Y V V V m O O O 0 p O W W N N N O O O p N O O O O o o P A O O O O O o W O O O O O O VNI O O O O O o D O O o o O o 0 0 0 0 0 0 o O o 0 0 0 3 Parkview Villa South Financial Statement Overview January 2015 Revenue: Occupancy for the month of January was 89% occupied Total Revenue was less that budget amount (unfavorable) and reflects occupancy and no misc. income Administrative Expenses: Administrative costs for South were under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were under budget (favorable) Office Supplies was under budget (favorable) 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 slightly over budget (unfavorable) Gas was under budget (favorable) Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operatine and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was under budget (favorable) Heating and Cooling Repairs Contract was over budget (unfavorable) and reflects the cost of Boiler valve repairs Decorating Contract was under budget (favorable) d m — � O elf N N M O 1 N A M M O V (O Q t0 OI Q N N A R m OD M O N Q O Q M N O Q R O Q m N � m n y n N O t•! W �() N D r M N Qi L mOOJ A N mn 0 O m N' N M O O U ao a o n � _ N L A 0 o Z Q m 3 v m 0 'no N E $ � `° ° N N U LL _o N d a � C c C � u W W O O A A N A N V Y u ed O Y U ^6 N> Q W Z > d aco 0 N w 00 N 00 C N In C O N fn N N N dL ag y GL a in O OU 0 0 c � � 0 o � � u u ri ai Q o N N Parkview Villa -South Balance Sheet January 2015 Books = Accrual 10100 Cash Balance 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds Total Assets Liabilities 20200 Accounts Payable 20210 Accrued Other Expenses 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 Jan -15 233,778.41 93.00 748,380.12 2.00 0.00 0.00 982,253.53 13,828.46 10,863.46 9,169.68 12,269.37 962.61 47,093.58 935,159.95 935,159.95 982,253.53 Parkview Villa -South Income Statement January 2015 Books = Accrual Month to Date %o Year to Date % Revenue 36220 -46340 Gen. Government Rents 25,896.00 99.73% 25,896.00 99.73% 36225 -46340 Nondwelling Rents 544.00 2.09% 544.00 2.09% 36290.46340 Other Miscellaneous Revenue (473.00) - 1.82% -073.00 -1.82% 39120 -46340 Recovery Damage City - 0.00% 0.00 0.00% Total Revenue 25,967.00 100.000/0 25,967.00 100.00% Expenses Personal Services 1000 -46340 Accrued Salaries Total Personal Services Supplies 200046340 Office Supplies 2010 -46340 Minor Equipment 216046340 Maint. & Construct Materials 217146340 General Supplies Total Supplies Other Services & Charges 304046340 Legal Fees 305046340 Expert & Professional Services 306046340 Management Services 310046340 Protective Services 3210 -46340 Telephone & Telegraph 343046340 Advertising Other 360046340 Insurance & Bonds 381046340 Electric 382046340 Water 383046340 Gas 384046340 Refuse 385046340 Sewer 400046340 Repair & Maint. Services 410046340 Rents & Leases 430046340 Miscellaneous Charges 431546340 PILOT 439046340 Taxes & Licenses 4500-46340 Administrative Expenses 4850 -46340 Interest on Deposits Total Other Services & Charges 4,012.00 15.45% 4,012.00 15.45% 4,012.00 15.45% 4,012.00 15.45% -41.34 -0.16% 41.34 - 0.16% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 350.45 1.35% 350.45 1.35% 309.11 1.19% 309.11 1.19% 0.00 0.00% 0.00 0.00% - 325.68 -1.25% - 325.68 -1.25% 2,168.00 8.35% 2,168.00 8.35% 61.91 0.24% 61.91 0.24% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 720.22 2.77% 720.22 2.77% 2,121.29 8.17% 2,121.29 8.17% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 37.52 0.14% 37.52 0.14% 0.00 0.00% 0.00 0.00% 1,197.05 4.61% 1,197.05 4.61% 0.00 0.00% 0.00 0.00% 74.90 0.00% 74.90 0.29% 943.80 3.63% 943.80 3.63% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 7.47 0.03% 7.47 0.03% 7,006.48 26.98% 7,006.48 26.98% Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense - 0.00% - 0.00% 0.00 0.00% 0.00 0.00% 11,327.59 43.62% 11,327.59 43.62% Excess (Deficit) Revenue over Expense 14,639.41 56.38% 14,639.41 56.38% Parkview Villa South (166) Cash Flow Statement Period = January 2015 Month to Date Revenue 36220 Gen. Government Rents 25,896.00 36225 Nondwelling Rents 544.00 36290 Other Miscellaneous Revenue - 473.00 39120 Recovery Damage City Property 0.00 Total Revenue 25,967.00 Personnel Services 1000 Accrued Salaries 4,012.00 Total Personnel Services 4,012.00 Supplies 2000 Office Supplies -41.34 2010 Minor Equipment 0.00 2160 Malnt. & Construct Materials 0.00 2171 General Supplies 350.45 2175 Food Supplies 0.00 Total Supplies 309.11 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services (325.68) 3060 Management Services 2,168.00 3100 Protective Services 0,00 3210 Telephone & Telegraph 61.91 3430 Advertising Other 0.00 3600 Insurance & Bonds 720.22 3810 Electric 2,121.29 3820 Water 0.00 3830 Gas 0.00 3840 Refuse 37.52 3850 Sewer 0.00 4000 Repair & Maint. Services 1,197.05 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 0.00 4300 Miscellaneous Charges 74.90 4315 PILOT 943.80 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 0.00 4850 Interest on Deposits 7.47 Total Other Services & Charges 7,006.48 Total Expenses 11,327.59 Parkview Villa South (166) Cash Flow Statement Period = January 2015 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 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 14,639.41 0.00 0.00 966.00 280.00 0.00 0.00 6,326.38 (18,527.81) (398.71) 943.80 (69.48) (10,479.82) 4,159.59 Beg Cash End Cash Difference 229,618.82 233,778.41 4,159.59 93.00 93.00 - 748,380.12 748,380.12 - 978,091.94 982,251.53 4,159.59 2/19/201522:28 PM Page 6 o a Parkview Villa South (166) General Ledger Period - no 2015 Book - ACC.ual : Tree ='la t6 Proper Property Name Oat. Peron /Descnptbn RogWnm ONN pe0k SaWm Remarb 1000 -46340 ponied Salaries 0.00= Indraln0 Baanm is 166 Partvlew Villa South 1/3112015 POIUMPurrin9 Recuning RC 4,01200 0.00 4,012.00 RIC CHIC PR HOml Fee Net Cbangaa4,012.00 4,022.00 a Ending Belenm = 2000 -414340 OMm SupOINS 0.00= NBInednO Balance or 165 Parkview VIIIa South 12/19/2014 Office Depot (.IRB80f) 7.46616E +11 16.62 0.00 16.67 stamp/pens/posrage fee 166 Parkview Villa South 11/24/2014 FetlEk (fides) 28874985751tes 9.02 0.00 25.69 shipments 1WI9 114 166 Parkview villa South 12/31/2014 Coyol Columbia Heights cold) 4787 40.53 0.00 66.22 copier relmb -06 /14.11 114 166 Parkvlm "I'd South 12/31/2014 City of Columbia Hell Centel) 47M 19.96 0.00 86.10 copier -rtUM- 06/14 -11/14 166 Parkview Villa South 111/2015 Acue 13/14 vp Inv to 1/15 - :ReverSnl of 22001 ON 9.02 77.16 Mvue 12/14 exp Inv to 1/15 - pool 166 Parkview Villa South I /1/2015 Mwe 12/14 eap Inv to 1/15 - :Reversal or 22MI 0.00 16.67 WAS Mvue 12/14 exp inv to 1/15 - Office Cape, 166 Parkview Mile South 1/1 /2015 Mvue IVA nap Inv to 1/15 - : Reversal of 220)1 0.00 60.49 000 Aame 12/14 eap Inv to 1/15 - C of Columb 166 Parkvlm W Ila South 1/1/2015 Aame C of CH 7/31/14 .4448lnvo1m :Revernal of 22014 0.00 58.46 -58.46 Amue C of CH 7/31/11 #44481nvelm 166 PaW.vlew Villa SOUq 1/ &2015 Office Depot Illylk" ) 7.50045Ei11 V.II 0.04 41.34 pamr /pencils Net thongs= -41.31 -41.34 a Ending Salaam = 2171 -INTO" General Supplies 0.00 or Beginning Salaam = I66 Partvlew Villa South I &9/2014 Shemin- WHINsons Co. (mr.110) 59875 49.03 0.00 49.03 paint 166 Payless. villa Saudi 1/1 /2045 Made 1V14 evp Inv t. 1115 - :Reversal of 22MI 0.00 4903 0.00 Mwe 12/34 cup Inv to 1/15 - Sherwin Will 166 Parceled Who South 1/912015 NO Supply Facilities Maintenance, Ltd. (9134709355 15.77 0.00 15.77 Irish 0isueJl% 166 PeM1VIm Mile South (/9/2015 NO Supply Facilities Maintenance, Ud. ( 9134709355 23.78 0.00 39.55 top bowls -31% 166 Parkview Wile SOUM 1/9/2015 HD Supply Facilities Mamenancq 04 .(9134709355 26.36 0.00 6591 hinges/pinamdvacy lever -31% 166 Persian Villa South 1/9/2015 HO Supply Facilities Maintenance, Ltd.(913470yll 17.41 0.00 03.32 light bulbs -31% 166 Parkview villa South 1/912015 NO Supply Facilities Malnhnanm, Ltd. ( 9134709355 28.90 0.00 112.30 mraldges -31% 165 Parkview WIla South 1/13/2015 Home Depot Credit Servim(homaSKIM 114449 B.B7 0.00 121.17 main supplies 166 Parkview Villa South 1/14/2015 Sherwin-Williams Co. (sher4110) 06125 99.13 0100 220.30 paint 166 Parkvew Wile South 1/2 &2015 praates, UMeao Me (first) 020930R 3.01 OAO 22331 Past knockout;fadenen -31% 166 Pa*vlm Wile South 1/22/2015 NO Supply Facilities Maintenance, Ltd. (9134976653 7.00 0.00 230.60 knockout sml;mnn ParomOnd -31% 166 Fairview villa South 1/222015 ND Supply Facilities Maintenance, Ltd. (9134976653 69.31 0.00 299.91 It fatrs; lamp Pages; It WIM -31% 166 PaMVIm WIIe South 1/2180/5 NO Supply Facilities Maintenance, M.(9134976653 50,54 am 350.455ealanpoullcquir 1% Met Change=350.45 350.5 a Ending Salaries = 3050 -46340 EaMrt St Pr.M1S sal Berrhom 0.00 - Beginning MNnma 166 Parkview Wile South IV31 /Mll CDy, of Columbia Heights (calu) 4787 571.61 O.CO 571.61 audit relarg 2014 166 Parkview W Ila South 12/31/20/4 qty of Columbia Heights (old) 4700 163.32 0.00 734,93 audIC2014 166 Parkview Who Scheib 11]/2015 Accrue lyl4 asp Ins W 1115- : Reversal of 22MI 000 734.93 0.00 same 12/14 cap Inv [01 /15 -C of COlumb 166 PalkAnor Wile Saudi I/U2015 Maus C of CH 7131/14 #4443 Invoice :Reversal of 22014 000 325.68 - 325.68 Aame C of CH 7/31/14 #4448 Invoice Net Changes- 325.63 - 325.68 a Ending Baanm = 3060 -46340 Management Servim. 0.00 = B it ning BeYnce s 166 ParkNm Ville South I/3 &2015 CammoaBOnal Housing (dRC) 013015mant 6,180.00 am 6,180.00 sago! lee 01/15 166 Parkview Villa South 1/31/2015 :POesReorr ng Recurring RC 0.00 4,012.00 2,168.00 R/C CHC PR Mgmt Fee Net Chis"002,16SA0 2,368.00 is Ending Salaam = 3210 -46340 TeNOheso BTaleprapll 0.00aBagMnk,Sebnce= 166 Parkview Villa Saudi 12/31/2014 PeOPmm (popp) 992234733 100.06 0.00 100.06 phone -31% 1/15 166 Farina. "It. SOUM I/U2015 Level One(leve) OJ71921IN 34130 DOD 134,44 anmWng service 1/15 166 Parkview Mile South 1/1/2015 Mvue 12/14 cap Inv to 1115 - : Reversal Of 22001 OAO 100106 34.30 Aame II14 el Inv to 1115 - Popp.om I" Parkvlew Villa South 1/2/2015 Comust(or ll) 877210505019618 27.53 am 61.911ntemet -31 %1111 - 2110 /14 Net Chm0aa61.91 61.91 a Ending Baanm a 3600 -46340 ansuranm A Banda 0.00 - Be9lnnlnB liaanm or 166 Parkview Mlle South 1118015 Martin C of CH 7/3U14 #44481mcdes :Reversal of 22014 0.00 1,198.36 - 1,198.36 Aame C of CH 7/31134 #4408 Invoice 166 Partvlew Villa South 1/318015 :POStRecuMng occurring RC 80.22 0.00 478.14 C Columbia Heights Ins ACCd IRE Parkvew Villa South 1/31/2015 Re carve IW31 Insurance G33 1,198.36 0.00 80.22 Re aarue IW31 Insurance Net Chen0aa720.22 320.22 a Ending Salaam, = 3810 -46340 ENGrin 0.00=Beginning Salaam = 166 Partvlew Villa South 1/1220/5 %ml Energy(acep 51504455301/12 2,121.29 OAO 3,121.29 a -31 %12/6/14 -18/15 Net COan9e- 2,121.29 2,121.29 = Ending Balance = 3840 -46300 Re.- 0.00 a Beginning Balanm a 166 ParkVlew Wile South 1/1 612015 Green Lights Rerytlln9 Inc(greel00q 155275 37.52 ON 37.52 recycling-31% Net Cha agsa37.53 37.52 a Ending Sa Wnm is 4000 -46340 Ron." 0 MaMt. Services 0.00 a Spinnln0 B.I.S. = 166 Parkview villa South IN26/2014 Inteinty Cleaning Solutions (Intel 1 140.80 090 148.80 bid men[- II/22-1V26/14 166 Parkview Villa South 1N26/MI4 Integrity Cleaning Solutions (Intel 2 37.20 OR` 106.00 bid maNt- 1N22- 1N2 &14 166 Parkview villa Saudi IV31IN14 LBP Mechanical, Inc (Italian) W21430 639.8 0.00 025.72 heat recairs-31 %11/12- IW4 /l4 166 Parkview Villa South IV31/2014 LBP Mechanical, Inc(Ibpm) W21458 326.12 am 1,151.34 heating repalm -31 %#309 166 Parkview Villa South 111/2015 Amue 12114 eap Inv 0 1/15 - :Revernal of 22001 0.00 350.05 793.79 Aame 1N34 eap Inv W 1/15 - Intel On 166 Panniers villa South 1/1/2015 Kane Inc. (Inae) 221650449 331.61 O.W 1,125.40 des main- 31 %t /15 166 Parkview Mile South 1/112015 Amue IN14 eap Inv W 1/15 - : Reversal of 22001 0.00 639.72 485.68 Amue II/N ¢p Inv 0 1/15 - LBP Mactanl 166 Partvlew Villa South 1/2/2015 oregriry, Cleaning Solutons(Inte929) 33 172.05 0.00 657.73 dmning- 11/29/14 - 01/02/15 166 Parkvew Villa South 1/IO /2015 Ntegriry Cleaning Solutions(intral 56 148.80 0.00 00653 bldg. main- 31 %1/5 -91MIS Page 6 o a Page 7 u38 2/19/201512:28 PM 094/2 CmOB Bounce Remarb Parkvlew Villa SouN (166) 1 039.08 - removal- 31 %1./5- 9/2015 23.32 General Ledger 062.40 pest control -31% #1181/14/15 4.96 0.00 Penoa = )an 2615 50.90 0.00 92636 snow /Ice semoval -31 %1/9/15 Book = Ar-al , Tree - y5 _tb Proper pro"" Name Oata paewn /Da omp60n Eastman. 166 PahNew Villa Sourk 1/10/2015 lm g0ty 0eanln9 Solutions (Inte929) 56 166 Pamvlew Villa SoutM1 1/14/2015 Acorn's Pest Control, Inc (slam) 942630 I" Parkvlew Villa South 1/14/2015 Fratulene's/Nttro eve (fret) O"ft91R 166 Parkvlew Villa Boom 1/14/2015 High Profile Grounds Maintenance, Inc. 31932 166 Prevent Villa South 1/15/2015 Stanley Access TeccOnelegles 0.0 (sun1903295590 166 Parkvlew Vola South 1/15/2015 MD Suppy Faclllues Maintenance, Ltd. ( 9INS32803 166 Parkvlew Mile Soum 1/15/2015 MD Supply Facilities Maintenance, Ltd. ( 9134832003 166 Parkvlew Vllla South 1/15 12015 High Profile Grounds Maintenance, Inc. 32011 166 Pakvlew VOIa South 1/20/2015 High Profile Grounds Maintenance, Nc, 32059 0.00 943.00 Anoka Cry Property Tax normal Net COangav1,193.05 4300453" MY Mneaus Charged 1" Pakvlew Villa South 1223/2014 Peachtree Damage Products (peso) P33346BBO0015 166 Parkvlew WE South 111/2015 Active 12/14 exp Inv to 1/15 - :Reversal of 22001 166 Parkvlew Villa Scum 1/9/2015 HD Supply Facilities Maintenance, LW. (9134709355 166 Park View Villa Soum 1/13/2015 HD Solidly Facilities Maintenance, Ltd. (9134550228 Net COange:30.90 4315 -46340 PILOT 166 Mall Mile South 1/3U2015 :POStRecurdn9 Recurring RC Net COangaa943.90 4830 -46340 let enA On Depesb 166 Parkvlew Mile SPUM 1/3112015 Sec dap Interest aurual W1 Nat Cbange =7.0 Page 7 u38 2/19/201512:28 PM 094/2 CmOB Bounce Remarb 32.55 1 039.08 - removal- 31 %1./5- 9/2015 23.32 0.00 062.40 pest control -31% #1181/14/15 4.96 0.00 863.36 V bNb -31% 50.90 0.00 92636 snow /Ice semoval -31 %1/9/15 56.42 0.00 91 repalrs -31% 10.35 0.00 993.03 V- 1,elts -69% 16.42 0.00 1,009.50 Tracben Melt -31% 158.10 0.00 1,167.60 plowin9.02/15 29.45 0.00 1,192.05 skid plow- 01/17/15 1,191.03 a Exxon, Bounty 0.00 a Beginning Bounty = 39.19 0.00 39.19 pot signs 0.00 39.19 O.W Accrue IV14 trip Inv to 1115 - Proortme 4.35 0,00 4.35 tool plov¢s-31% 20.55 0.00 24.90 [Moshe Saturn Interconnect-31% 34.90 B Ending Yunp = 0.00 a Beginning sawn" = 943.80 0.00 943.00 Anoka Cry Property Tax normal 943.80 = Ending Baunw = 0.00 z Beginning Sauna. = 3.41 0.00 7,47 Sec dep interest acooal ].4] = Ending Balance: 15,929.29 3,601." Parkview Villa South Bank Reconciliation Report 01/31/2015 5016464 Balance Per Bank Statement as of 01/31/2015 Outstanding Deposits Deposit date Deposit number 01/12/2015 524 Plus: Outstanding Deposits Outstanding Checks Check date Check number 04129/2014 2062 01/21/2015 2280 01/2812015 2284 01128/2015 2285 01128/2015 2286 01/28/2015 2287 Less: Outstanding Checks Pavee t0011071 - Johnson Ibpm - LBP Mechanical, Inc adam - Adam's Pest Control, Inc. frat - Frattalone's /Metro Ace high8236 - High Profile Grounds Maintenance, Inc Ibpm - LBP Mechanical, Inc Reconciled Bank Balance 02/04/2015 234,527.54 Amount 693.00 693.00 Amount 232.96 639.72 23.32 3.01 217.00 326.12 1,442.13 233,778.41 Balance per GL as of 01/31/2015 233,778.41 Reconciled Balance Per G/L 233,778.41 Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) 0.00 Cleared Items : Cleared Checks Date Tran # Notes Amount Date Cleared 12/31/2014 2250 adam - Adam's Pest Control, Inc. 56.20 01/31/2015 12131/2014 2251 cent - CenterPoint Energy 3,003.44 0113112015 12/3112014 2252 chc- CommonBond Housing 29.40 01/31/2015 12/31/2014 2253 dire - Direct Home Appliance Services 89.00 01/31/2015 12/31/2014 2254 fiat - Frattalone's /Metro Ace 2.64 01/31/2015 12/31/2014 2255 high8236 - High Profile Grounds Maintenance, Inc. 158.10 01/3112015 12/31/2014 2256 home7 - HD Supply Facilities Maintenance, Ltd. 131.66 01/31/2015 12/31/2014 2257 inte929 - Integrity Cleaning Solutions 477.40 01/31/2015 Date 1/30/15 Page 1 Primary Account QXXXXXQ6464 Enclosures 44 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 - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: - SAME DAY DELIVERY OF STATEMENT - PASSWORD PROTECTED - EASY STORAGE CONTACT YOUR BANKER FOR DETAILS! NORTHEAST PUBLIC FUNDS ACCT Number of Images 44 Account Number @XXXXX @6464 Statement Dates 1/01/15 thru 1/31/15 Previous Balance 236,551.74 Days in the Statement Period 31 11 Deposits /Credits 26,456.52 Average Ledger 244,321 33 Checks /Debits 28,480.72 Average Collected 242,370 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 234,527.54 xxxxxx+ x++ xxxxxxxxxxxxxxxxxxx++ x+ xxxx++ xx+ xxxxxxxxxxxxxxxxxxxx +xxxxxxxxxxxxxxx Deposits and Credits Date Description Amount 1/02 DDA REGULAR DEPOSIT 16,663.00 1/05 DDA REGULAR DEPOSIT 3,231.10 1/06 DDA REGULAR DEPOSIT 634.00 1/06 DDA REGULAR DEPOSIT 1,942.00 1/08 DDA REGULAR DEPOSIT 630.00 1/09 DDA REGULAR DEPOSIT 672.00 1/12 DDA REGULAR DEPOSIT 958.42 1/15 DDA REGULAR DEPOSIT 632.00 1/16 DDA REGULAR DEPOSIT 640.00 1/20 DDA REGULAR DEPOSIT 154.00 1/27 DDA REGULAR DEPOSIT 300.00 xxxx+++++ xxxxxxxxxxxxxxxx++++++++ xxxxxxxxxxxxxxxxxxxxx + + + + + + + + + + + + + +xxxxxxxxxx Checks in serial order Date Check# Amount Date Check# Amount 1/05 2250 56.20 1/08 2254 2.64 1/07 2251 3,003.44 1/12 2255 158.10 1/02 2252 29.40 1/07 2256 131.66 1/09 2253 89.00 1/06 2257 477.40 * Indicates skip in check numbers Date 1/30/15 Page 2 Primary Account @XXXXX @6464 Enclosures 44 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 1/06 2258 322.05 1/20 2271 1,114.10 1/14 2259 432.00 1/21 2272 11,500.00 1/06 2260 21.99 1/28 2273 209.37 1/06 2261 1,976.08 1/27 2274 202.81 1/09 2262 6,299.24 1/28 2275 27.53 1/12 2263 861.95 1/29 2276 4.96 1/15 2264 40.89 1/27 2277 70.55 1/15 2265 358.05 1/28 2278 181.35 1/14 2266 300.00 1/29 2279 331.61 1/12 2267 34.38 1/27 2281* 30.00 1/13 2268 16.67 1/28 2282 100.06 1/15 2269 39.19 1/29 2283 49.03 1116 2270 9.02 * Indicates skip in check numbers Daily Balance section Date Balance Date Balance Date Balance 1 /01 236,551.74 1/09 247,914.74 1/20 246,934.81 1/02 253,185.34 1/12 247,818.73 1/21 235,434.81 1/05 256,360.24 1/13 247,802.06 1/27 235,431.45 1/06 256,138.72 1/14 247,070.06 1/28 234,913.14 1/07 253,003.62 1/15 247,263.93 1/29 234,527.54 1/08 253,630.98 1/16 247,894.91 * * * E N D O F S T A T E M E N T Parkyiew Villa South Payment Summary Bank -16604 ANO m Yyy -Oil /20 1 5 01/2 015 AM N Olepa -YS ONO k,Npe VOnn-AIIQecka Page 1 of 1 22,989.43 https: // mail. commonbond. org/ owa /ev.owa ?ns= WebReady &ev= GetFile &canary= 3oxMl2r... 4/17/2015 Chalk Taal Bent aedna Venda. ore Ananunt 156W- Porltyia, Vile Soup, 2262 CM -O Mnwni Homing O 07/2M5 6M9.7 166W - Pa, y Vile Soup, 2261 home - Msnem t O ©ratim Center OU0712015 %l.% 166W - Parlaiew Vile Soup, 2260 heme7 - HO S4,nly Fedibs Dbirtereme, lt1 Oil /07/2015 /OA9 166W - Psrla. Vila Scull 2265 p, @929 - Wearily (]vn" SOIVtiOM 01/0712015 358.05 I%W - Party Vila Soup, 22% kac17MS -K0 Oeannp anP nlinq, Im OU07/2015 300.W 166W -Rarl a Vila So 2261 Ice - tud One 01/0712015 30.35 166w N-kyiav Ville Scull 2268 dfie004 -off. Oepo[ 01/07/2015 16.67 166W- itrlainn Vib SauM 2269 peep - Pead,.fluaine:s Prwutla 01/0112015 39.19 166mr- � Vile SOM 22M tic- Cbm.ftn,i MOusinp OU14/2015 9.0 166tgr -Iblt: Vila Sn 2212 mil -C* rCalrtbn H.,hts 01/1412015 1,114.10 166W - Perk, Vila Sautl, 22n mWye - CA ntna Hepl,a iM 01/14,2015 131500AO 1 %Oa- Parnen, Vib SOud, 2213 tM12W6- Jown*m 61114,201$ 209.37 View - Pakeiw Vile SOuM 2274 tOO12836 - ❑ntklmm 01/1412015 812.81 166W - Pb, „ Vila SuM 2275 CS17 - tanmst 01/21/2015 27.53 166W -I Iyinv Vila Sm 2276 het- Frattalorc's/Melm AR 01/21/2015 4.% 166W - nA'kiew villa SbuM 2212 lya -MO Supply Po 1*11. Mane., Ih1 01/21/2035 70.55 View - itrknpw Vile SaNh 2278 me929 - kt Sriy ck m seltOm 01/212015 151.39 t %mr - Pskys v Vila Sar, 2279 Imne - KAIe Im. OU2112m5 331.61 166W- Pa,lnAw Vila SOUP, 2280 Ibpm- lSP MecIVmna, Inc Oil /2U2W5 639.72 I%w - talk Vib Soup 2281 mukl- MUl[nominpCnMk COntml OU2112MS 30.W 165W -wk,ew Vib SVM 2282 pope - PapP.mm 01/21/2015 100.% 166w -Par, Vile SO 2263 sher6110- Shawn- 1NIlsnsln OU2112015 49.W 166W -Rrtk iev Vila SouO, 2254 a0em- Atlanta Poet COmml, In, 0112W2015 23.32 Va6 - q-knew V16 south 2285 Gr - Fattelone'NMebo Am 01/28/2015 3.01 166W -lwk Vila SUM 22% hiph8235- Nigh Profile Grounak Maintena,m, Inc 01 /2e/2015 217.W 166mr- ftrbeav Vila Sar, 22W Ibpm- LBP Mmheniral, lou OUM2MS 326.12 22,989.43 https: // mail. commonbond. org/ owa /ev.owa ?ns= WebReady &ev= GetFile &canary= 3oxMl2r... 4/17/2015 P P q N N N °� P A q q q °� P P W P P P P P P q q N N t/i N N N N in to N N N lqn Iqn r N N A A N A A A W W W w N A Ol vWi uwi O N V r O N W b W v O q w r O W O N b p A O V V O O O o d r O O O O N Y O b O b b Y q O JW V Y N � v v O O O Y O m V N O e m 'o '^ @a W `m o6 m �DmR•'•�Rm''o< N u S a < m °oal°�lo0�00 u�Gm �• ��Om �" x u°i N m<no A F a a S & N N N q P N N Py A O O V N m O W O O W O O O O O O O A r 0 0 O O A O o O O O O O O O o 0 A r v q A ONI P V P i0 A V v m uAi r W W �' tJn o m o N o mow N P r v m q vNi A O o A P o J O N N g W W q O 00 W O O O W O N N O O O P m V V V O V 1p O N O V O 0 O O V O N O O O O O O O O W N r q A N OV O N ~ O r W r v% Q W W N N m P P VVIO N O Oqi r 0 0 q VNI O r P O 0 P VNI V W W O O N N W N V o r C N O W O O q N V O W p O P n O N N Ol O N O ' m N N W f0 O O V W O O b O O N O O O O O O O O W J P m O O r N v r N N N 8 8 88 p r O W p 88, O i+ J VNI W N O O ^ b N N O O O 00 N O N O O M O W N O o O N q Z Z yNj p W N N➢ D N P N v N N N q q N m w O O V N m r N O O O rl N 0 r O J r O O N O O O q V V W V W O O A O A O A pbf O O N N w m V N O O O N W. p J r W O O O v N O b P A O O O O O O D O O O O O O A P w q N N v m g r W N N V m VA1 A P N V N o N o g o w Iv/I m r N N� P lull A X 0 0 0 � a o 0 N v V W W V q O O V O O V O W O O V N O W W V O V o O O N O O O O O O O V W N N mC v O WP H N m P r p w r a q P N N r V q IVII O O Ol m O O W VNl r T O W g N V W W O O N N y O N r C Vl W O O W N V O O V W G N N O b N O N O m O N W O W O O J W O O A O VI O O O O O O O O W V O O r N lid O O O r N N r O r J O W N O O O V W N W O po m N N O O O O r N O O b N N O o O O W G N q (Pii 2 Z P O O y p A O W r W O g O O O r W O b W O O O O O N N D D q q V W W W m N N r P r P N N VN1 W N l+ J r r .W W r r A A N N N N O O O O O O O O O O a W P O O O O W r P i0 N mq IAII 0 0 0 0 0 0 0 O W O O °o O O' O A A q O O O O O O O O O O 0 0 0 0 p A O o 0 o Y A n o e@ C ,4 $ A F All O N o a 0 !A b 3 r 0 W P P A r O O O O P V J V P m m P P N N O 1bp P N V P O W N M P N V P O W P b O W N V P O> r O N AP N N N � b y O O O � m a ` m x d- in — n a .0 a .. w �aA$3� N O m 9 a m a a a T Y O O 3 w D p Y n b V O q O O O V P O O W O W O A O b O rA+ W - A b O O O o '➢ N N N O° o N N O O W O O V W r N 0 r d m a q L N N N b0 0 OM O N p O O p A W P Y W W V � N N N N p N O O p qD W N N W W w M Y O O O p W N O O O O M A W P b V O O O O r b O O O o 0 O A A O O O r O O O V J O r r W W A O N V V N o N O O W O w N N O o O i �a is Y O N m w p1a °m b N VNI O INi� IVn r N O n N O O O O O V P N O O G d V ` V N N tV)I O W P N P N A b i � N9S o y N N q d O ` b O N A z O Z r A m O O O D O w r b➢ K y O D N W W L O A O - b b O✓ O O A A P N O O w O O V w r N t 1 O N C P u W N N N O n N u N O O O O O P O V N O O O D O V W N O O d W � V � V N r O R N N P o W o o, 0 0 m W V O O O twit A W O 0 o a N Z ~ m > A Z m r A W W N O N O O V 0 N V N O O O O O V N O O 0 0 0 0 0 0 go. O S 3 0 OM 0 O A A O O O r O O O V J O r r W W A O N V V N o N O O W O w N N O o O i �a is Y O N m w p1a °m b N VNI O INi� IVn r N O n N O O O O O V P N O O G d V ` V N N tV)I O W P N P N A b i � N9S o y N N q d O ` b O N A z O Z r A m O O O D O w r b➢ K y O D N W W L O A O - b b O✓ O O A A P N O O w O O V w r N t 1 O N C P u W N N N O n N u N O O O O O P O V N O O O D O V W N O O d W � V � V N r O R N N P o W o o, 0 0 m W V O O O twit A W O 0 o a N Z ~ m > A Z m r A W W N O N O O V 0 N V N O O O O O V N O O 0 0 0 0 0 0 go. O S 3 Parkview Villa South Financial Statement Overview February 2015 Revenue: Occupancy for the month of February was 87% occupied Total Revenue was under budget (unfavorable) and reflects occupancy and No laundry income for the month Administrative Expenses: Administrative costs for South were slightly over budget (unfavorable). Advertising costs were over budget (unfavorable) and reflect cost of ongoing marketing of units Office Supplies was under budget (favorable) Legal Services was under budget (favorable) Audit expense was over budget (unfavorable) but on target for year Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were slightly over budget (unfavorable); however, this reflects some quarterly billings Fuel Oil was under budget (favorable) Electric was under budget (favorable) Gas was over budget (unfavorable) and reflects Jan.. billing Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Janitor Supplies were under budget (favorable) Exterminating Contract was under budget (favorable) Maintenance Supplies was under over budget (unfavorable) and reflects cost of supplies Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Snow Contract was over budget (unfavorable) sand includes cost of ice melt products Repairs Contract was under budget (favorable) Decorating Contract was over budget (unfavorable) and reflects the cost of painting unit Furniture and Fixtures was over budget (unfavorable) and reflects the cost of replacement of vinyl in one unit V M N O O V V O O N OI N O � eD m t M I� N o N ep N O o m r w o ro M L � C � o � Z Q M cj m v o el A N ' ml L Y cO f� M 0 W R h M O N V M N O O V V O O N OI N O � eD m t M I� N N ep N O o m r w o ro M L � C � o � Z Q m 3 v N ' L Y cO f� M 0 W R h M O N GO C r O M = a N M N V co N O N A � Q Uy� o o � U iL `o N d r a C O c x C G W 2 » (A Q d d 1 N U Np O_N U N O Z' N w' w w m 0 v y) 0 c c av N L'nt "6a m0 .ocn ari)OUF 0.U)0 0 c � � � M M O N N U C d O C) M Q o N N Parkview Villa -South Balance Sheet February 2015 Books = Accrual Feb -15 Assets 10100 Cash Balance 228,961.32 10200 Petty Cash 93.00 10400 Investments 714,752.82 11300 Rent Receivable 7.00 11500 Accounts Receivable 0.00 13100 Due From Other Funds 0.00 Total Assets 943,814.14 Liabilities 20200 Accounts Payable 10,118.07 20210 Accrued Other Expenses 1,942.40 22000 Deposits 9,176.40 22200 Accrued PILOT 13,213.17 22210 Revenue Collected in Advance 1,049.61 Total Liabilities 35,499.65 Fund Balance 25300 Fund Balance 908,314.49 Total Fund Balance 908,314.49 Total Liabilities and Fund Balance 943,814.14 Parkview Villa -South Income Statement February 2015 Books = Accrual Month to Date % Year to Date % Revenue 36220 -06340 Gen. Government Rents 25,264.00 97.48% 51,160.00 98.60% 36225 -46340 Nondwelling Rents 510.00 1.97% 1,054.00 2.03% 36290 -06340 Other Miscellaneous Revenue 144.00 0.56% - 329.00 -0.63% 39120 -46340 Recovery Damage City - 0.00% 0.00 0.00% Total Revenue 25,918.00 100.00% 51,885.00 100.00% Expenses Personal Services 1000 -46340 Accrued Salaries Total Personal Services Supplies 2000-06340 Office Supplies 2010 -06340 Minor Equipment 2160 -46340 Maint. & Construct Materials 217146340 General Supplies Total Supplies Other Services & Charges 304046340 Legal Fees 305046340 Expert & Professional Services 3060 -46340 Management Services 310046340 Protective Services 321046340 Telephone & Telegraph 3430 -46340 Advertising Other 360046340 Insurance & Bonds 381046340 Electric 382046340 Water 3830-46340 Gas 384046340 Refuse 3850 -46340 Sewer 400046340 Repair & Malnt. Services 410046340 Rents & Leases 430046340 Miscellaneous Charges 431546340 PILOT 439046340 Taxes & Licenses 450046340 Administrative Expenses 485046340 Interest on Deposits Total Other Services & Charges 4,012.00 15.48% 8,024.00 15.46% 4,012.00 15.48% 8,024.00 15.46% 121.27 0.47% 79.93 0.15% 925.89 3.57% 925.89 1.78% 0.00 0.00% 0.00 0.00% 771.17 2.98% 1,121.62 2.16% 1,818.33 7.02% 2,127.44 4.10% 0.00 0.00% 0.00 0.00% 325.68 1.26% 0.00 0.00% 2,168.00 8.36% 4,336.00 8.36% 76.72 0.30% 76.72 0.15% 162.49 0.63% 224.40 0.43% 432.00 1.67% 432.00 0.83% 919.94 3.55% 1,640.16 3.16% 2,018.82 7.79% 4,140.11 7.98% 0.00 0.00% 0.00 0100% 2,819.48 10.88% 2,819.48 5.43% 0.00 0.00% 37.52 0.07% 0.00 0.00% 0.00 0.00% 3,360.43 12.97% 4,557.48 8.78% 30.00 0.12% 30.00 0.06% 23.82 0.00% 98.72 0.19% 943.80 3.64% 1,887.60 3.64% 0.00 0.00% 0.00 0.00% 17.93 0.07% 17.93 0.03% 6.72 0.03% 14.19 0.03% 13,305.83 51.34% 20,312.31 39.15% Capital Outlay 5120 -06340 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00 0.00% 0.00% 19,136.16 73.83% 30,463.75 58.71% 6,781.84 26.17% 21,421.25 41.29% Parkview Villa South (166) Cash Flow Statement Period = February 2015 Month to Date Revenue 36220 Gen. Government Rents 25,264.00 36225 Nondwelling Rents 510.00 36290 Other Miscellaneous Revenue 144.00 39120 Recovery Damage City Property 0.00 Total Revenue 25,918.00 Personnel Services 1000 Accrued Salaries 4,012.00 Total Personnel Services 4,012.00 Supplies 2000 Office Supplies 121.27 2010 Minor Equipment 925.89 2160 Maint. & Construct Materials 0.00 2171 General Supplies 771.17 2175 Food Supplies 0.00 Total Supplies 1,818.33 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 325.68 3060 Management Services 2,168.00 3100 Protective Services 76,72 3210 Telephone & Telegraph 162.49 3430 Advertising Other 432.00 3600 Insurance & Bonds 919.94 3810 Electric 2,018.82 3820 Water 0.00 3830 Gas 2,819.48 3840 Refuse 0.00 3850 Sewer 0.00 4000 Repair & Maint. Services 3,360.43 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 30.00 4300 Miscellaneous Charges 23.82 4315 PILOT 943.80 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 17.93 4850 Interest on Deposits 6,72 Total Other Services & Charges 13,305.83 Total Expenses 19,136.16 Parkview Villa South (166) Cash Flow Statement Period = February 2015 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 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 6,781.84 0.00 0.00 (5.00) 0.00 0.00 0.00 (3,710.39) (8,921.06) 6.72 943.80 87.00 (11,598.93) (4,817.09) Beg Cash End Cash Difference 233,778.41 228,961.32 (4,817.09) 93.00 93.00 - 748,380.12 748,380.12 - 982,251.53 977,434.44 (4,817.09) 3/17/20151:13 PM Page 6 of 9 Parkview Villa South (166) General Ledger Period = Feb 2015 Book = Accrual; Tree = ysi_tb Property Date Person /Description Reference Debit Credit Balance Remarks 1000 -46340 Accrued Salaries 4,012.00 = Beginning Balance = 166 2/28/2015 :PostRecurring Recurring RC 4,012.00 0.00 8,024.00 R/C CHIC PR Mgmt Fee Net Change = 4,012.00 8,024.00 = Ending Balance = 2000 -46340 Office Supplies -41.34 = Beginning Balance = 166 7/31/2014 City of Columbia Heights (colu) 4449 58.46 0.00 17.12 copier - 01/01 - 05/31/14 166 7/31/2014 City of Columbia Heights (colu) 4449 0.00 58.46 -41.34 copier- 01 /01- 05/31/14 166 7/31/2014 City of Columbia Heights (Colu) 4449 58.46 0.00 17.12 copier- 01/01- 05/31/14 166 2/2/2015 Office Depot(of8804) 7.53227E +11 3.10 0.00 20.22 post -it popup dispenser -31% 166 2/2/2015 Office Depot (offi8804) 7.53227E +11 41.13 0.00 61.35 stamps; shts;envlps;post- its -311 166 2/5/2015 Office Depot(of8804) 7.54005E +11 10.84 0.00 72.19 stamp;candy -31% 166 2/7/2015 Office Depot(offi8804) 7.54005E +11 7.74 0.00 79.93 stamps -31% Net Change= 121.27 79.93 = Ending Balance = 2010 -46340 Minor Equipment 0.00 = Beginning Balance = 166 1/27/2015 Hamernick Decorating Center (hame CG500445 829.19 0.00 829.19 vinyl install 166 2/5/2015 HD Supply Facilities Maintenance, U-9135265317 22.54 0.00 851.73 cave base -31% 166 2/12/2015 HD Supply Facilities Maintenance, Lb9135420261 35.51 0.00 887.24 roller shades -31% 166 2/19/2015 HD Supply Facilities Maintenance, Lb9135568268 38.65 0.00 925.89 ceiling file -31% Net Change= 925.89 925.89 = Ending Balance = 2171 -46340 General Supplies 350.45 = Beginning Balance = 166 1/23/2015 Home Depot Credit Services (home9 FCH005556940 6.20 0.00 356.65 late fee -31% 166 1/27/2015 HD Supply Facilities Maintenance, Lb9135060964 269.17 0.00 625.82 cvr /0ppr /seattrng hldr /o mg... 166 1/27/2015 HD Supply Facilities Maintenance, Lb9135060961 74.35 0.00 700.17 seal /conn cvr /blbs /Imp cage.... 166 1/28/2015 HD Supply Facilities Maintenance, U9135098183 0.00 65.68 634.49 blb /seal /cvr /cage /seal - credit 166 1/29/2015 HD Supply Facilities Maintenance, Lb 9135121086 2.25 0.00 636.74 duct seal 166 1/29/2015 HD Supply Facilities Maintenance, Lb9135121085 33.48 0100 670.22 kwik seal 166 2/2/2015 HD Supply Facilities Maintenance, Lb9135186743 13.50 0.00 683.72 vac bags 166 2/5/2015 HD Supply Facilities Maintenance, Lb 9135265622 0.00 36.71 647.01 misc maint supply -31 %- credit 166 2/5/2015 HD Supply Facilities Maintenance, Lb9135265317 10.24 0.00 657.25 duct tape -31% 166 2/5/2015 HD Supply Facilities Maintenance, Lo9135265317 55.41 0.00 712.66 ballasts -31 %A 166 2/5/2015 HD Supply Facilities Maintenance, Lb 9135265317 10.32 0.00 722.98 mnt strp;clips;smk alrm -31% 166 2/5/2015 HD Supply Facilities Maintenance, Lb 9135265317 17.43 0.00 740.41 range hood -31% 166 2/6/2015 Buckeye Cleaning Centers (buck841:869555 54.14 0.00 794.55 paper towels -31% 166 2/9/2015 Frattalone's /Metro Ace (frat) 021145R 8.32 0.00 802.87 misc maint supplies -31% 166 2/11/2015 Sherwin - Williams Co.(sher4110) 51620 63.28 0.00 86615 paint -31% 166 2/12/2015 HD Supply Facilities Maintenance, Lo9135420261 17.43 0.00 883.58 range hood -31% 166 2/12/2015 HD Supply Facilities Maintenance, Lb9135420261 16.74 0.00 900.32 sink strainer -31% 166 2/12/2015 HD Supply Facilities Maintenance, Lb9135420261 4.63 0.00 904.95 Liquid Nails -31% 166 2/12/2015 HD Supply Facilities Maintenance, U.9135420261 33.41 0.00 938.36 light bulbs -31% 166 2/12/2015 HD Supply Facilities Maintenance, Lb9135420261 7.08 0.00 945.44 door klckplate -31% 166 2/19/2015 HD Supply Facilities Maintenance, Lb9135568268 176.18 0.00 1,121.62 k faucets;misc maint supply-3V Net Change= 771.17 1,121.62 = Ending Balance = 3050 -46340 Expert & Professional Services - 325.68 = Beginning Balance = 166 7/31/2014 City of Columbia Heights (colu) 4449 325.68 0.00 0.00 audit fees -2013 166 7/31/2014 City of Columbia Heights (C01u) 4449 0.00 325.68 - 325.68 audit fees -2013 166 7/31/2014 City of Columbia Heights (colu) 4449 325.68 0.00 0.00 audit fees -2013 Net Change= 325.68 0.00 = Ending Balance = 3060 -46340 Management Services 2,168.00 = Beginning Balance = 166 2/27/2015 Common Bond Housing (chc) 022715mgmt 6,180.00 0.00 8,348.00 mgmt fee 02/15 166 2/28/2015 :PostRecurring Recurring RC 0.00 4,012.00 4,336.00 R/C CHC PR Mgmt Fee Page 6 of 9 3/17/2015 1:13 PM Parkview Villa South (166) General Ledger Period = Feb 2015 Book = Accrual; Tree - ysi tb Property Date Person/ Description Reference Debit Credit Balance Remarks Net Change= 2,168.00 4,336.00 = Ending Balance = 3100 -46340 Protective Services 0.00 = Beginning Balance = 166 1/31/2015 Sitzmann Construction dba Sitzmanr 580140 76.72 0.00 76.72 fire alarm panel -31 %9/8/14 Net Change =76.72 76.72 = Ending Balance = 3210 -46340 Telephone & Telegraph 61.91 = Beginning Balance = 166 1/31/2015 Popp.com (popp) 992241194 100.58 0.00 162.49 phone-31% 2/15 166 2/1/2015 Level One (]eve) 0479146IN 34.38 0.00 196.87 answering service 2/15 166 2/2/2015 Comcast(comc3517) 877210505019618 27.53 0.00 224.40 internet -31% 2/11 - 3/10/15 Net Change = 162.49 224.40 = Ending Balance = 3430 -46340 Advertising Other 0.00 = Beginning Balance = 166 1/29/2015 Northeaster and NorthNews (nort28r80656 432.00 0.00 432.00 display ads - 01/14- 01/28/15 Net Change= 432.00 432.00 = Ending Balance = 3600 -46340 Insurance & Bonds 720.22 = Beginning Balance = 166 7/31/2014 City of Columbia Heights (colu) 4449 9,841.00 0.00 10,561.22 insurance -2014 166 7/31/2014 City of Columbia Heights (colu) 4449 0.00 9,841.00 720.22 insurance -2014 166 7/31/2014 City of Columbia Heights (colu) 4449 9,841.00 0.00 10,561.22 insurance -2014 166 2/2812015 :PostRecurring Recurring RC 0.00 8,921.06 1,640.16 C of Columbia Heights Ins Aced Net Change= 919.94 1,640.16 = Ending Balance = 3810 -46340 Electric 2,121.29 = Beginning Balance = 166 2/11/2015 Xcel Energy (xcel) 5150441553 02/11 2,018.82 0.00 4,140.11 e-31% 1/7- 2/7/15 Net Change = 2,018.82 4,140.11 = Ending Balance = 3830 -46340 Gas 0.00 = Beginning Balance = 166 2/9/2015 CenterPoint Energy (cent) 55271324 02/09/1 46.03 0.00 46.03 late fee 2/9/15 166 2/9/2015 CenterP0lnt Energy (cent) 55271324 02/09/1 2,773.45 0.00 2,819.48 g 1/7- 2/5/15 Net Change = 2,819.48 2,819.48 = Ending Balance = 3840 -46340 Refuse 37.52 = Beginning Balance = Net Change =0.00 37.52 = Ending Balance = 4000 -46340 Repair & Maint. Services 1,197.05 = Beginning Balance = 166 1/16/2014 Integrity Cleaning Solutions (inte92S 58 148.80 0.00 1,345.85 cleaning 1/12- 16/2015 -31% 166 12/30/2014 Integrity Cleaning Solutions(Inte92S 35 150.35 0.00 1,496.20 bldg maint #A;B 12/29/14 -1/2/ 166 1/24/2015 Integrity Cleaning Solutions (inte92S 235 66.65 0.00 1,562.85 cleaning- 01/19- 01/24/15 166 1/24/2015 Integrity Cleaning Solutions (inte92S 234 200.00 0.00 1,762.85 cleaning #425 166 1/24/2015 Integrity Cleaning Solutions (Inte92S 231 181.35 0.00 1,944.20 caretaking- 01/19 - 01/24/15 166 1/24/2015 Integrity Cleaning Solutions (inte92S232 200.00 0.00 2,144.20 cleaning #123 166 1/30/2015 Integrity Cleaning Solutions (inte92S 536 186.00 0.00 2,330.20 bid cleaning -31% #A;B 166 2/6/2015 Integrity Cleaning Solutions (inte92S 263 148.80 0.00 2,479.00 building maint -31% #A;B 166 12/11/2014 All Seasons Garage Door Company (.43898 44.68 0.00 2,523.68 door parts 166 1/9/2015 Cummins NPower LLC (cumm) 10092828 514.26 0.00 3,037.94 maint/repalrs -31% 1/15 166 1/31/2015 Sitzmann Construction dba Sltzmanr 580141 179.02 0.00 3,216.96 misc repairs -31% 1/30/15 166 2/3/2015 Direct Home Appliance Services (din 20315165166 27.59 0.00 3,244.55 repairs -31% 166 2/9/2015 Direct Home Appliance Services (din 20915166 89.00 0.00 3,333.55 repairs 2/9/15 166 2/1/2015 Kone Inc.(kone) 221675738 331.61 0.00 3,665.16 elev maint -31% 2/15 166 1/16/2014 Integrity Cleaning Solutions (inte92S 58 32.55 0.00 3,697.71 heavy salt -31% 166 2/6/2015 Integrity Cleaning Solutions (inte925263 32.55 0.00 3,730.26 heavy salt -31% 166 2/9/2015 High Profile Grounds Maintenance, Ir 32171 46.50 0.00 3,776.76 snow /ice removal -31% 2/3/15 166 2/12/2015 HD Supply Facilities Maintenance, L69135420261 16.47 0.00 3,793.23 Traction Melt -31% Page 7 of 9 4100 -46340 Rents & Leases 166 1/31/2015 Multihousing Credit Control (multi) 15010336 Net Change =30.00 4300 -46340 Miscellaneous Charges 166 2/3/2015 Frattalone's /Metro Ace (frat) Net Change =23.82 4315 -46340 PILOT 166 2/28/2015 :PostRecurring Recurring Net Change= 943.80 4500 -46340 Administrative Expenses 166 2/16/2015 US Bank(usba790) Net Change. 17.93 4850 -46340 Interest on Deposits 166 2/2812015 Sec Dep interest accrual Net Change =6.72 021090R RC 30.00 23.82 943.80 3/17/2015 1:13 PM Credit Balance Remarks Parkview Villa South (166) 3,966.83 janitorial services -31% #A;B 0.00 3,999.38 Heavy salt -31% General Ledger 4,157.48 snow /Ice removal -31% 3/15 0.00 4,407.48 painting Period = Feb 2015 4,557.48 painting 4,557.48 = Ending Balance = Book = Accrual; Tree = ysi_tb 0.00 = Beginning Balance = Property Date Person /Description Reference Debit 166 2/1312015 Integrity Cleaning Solutions (inte9256010 173.60 166 2/13/2015 Integrity Cleaning Solutions (inte9256010 32.55 166 2/16/2015 High Profile Grounds Maintenance, 1132306 158.10 166 1/28/2015 K O Cleaning and Remodeling, Inc. ( 3283 250.00 166 1/28/2015 K O Cleaning and Remodeling, Inc. ( 3282 150.00 Net Change= 3,360.43 4100 -46340 Rents & Leases 166 1/31/2015 Multihousing Credit Control (multi) 15010336 Net Change =30.00 4300 -46340 Miscellaneous Charges 166 2/3/2015 Frattalone's /Metro Ace (frat) Net Change =23.82 4315 -46340 PILOT 166 2/28/2015 :PostRecurring Recurring Net Change= 943.80 4500 -46340 Administrative Expenses 166 2/16/2015 US Bank(usba790) Net Change. 17.93 4850 -46340 Interest on Deposits 166 2/2812015 Sec Dep interest accrual Net Change =6.72 021090R RC 30.00 23.82 943.80 3/17/2015 1:13 PM Credit Balance Remarks 0100 3,966.83 janitorial services -31% #A;B 0.00 3,999.38 Heavy salt -31% 0.00 4,157.48 snow /Ice removal -31% 3/15 0.00 4,407.48 painting 0.00 4,557.48 painting 4,557.48 = Ending Balance = 0.00 = Beginning Balance = 0.00 30.00 residential screening 1/15 30.00 = Ending Balance = 74.90 = Beginning Balance = 0.00 98.72 hi security condo keys -31% 98.72 = Ending Balance = 943.80 = Beginning Balance = 0.00 1,887.60 Anoka Cry Property Tax Accrual 1,887.60 = Ending Balance = 448559455559124 17.93 0.00 G32 6.72 0.00 42,396.75 23,260.59 Page 8 of 9 0.00 = Beginning Balance = 17.93 LAURA B FROSTSARNAS CLASS] 17.93 = Ending Balance = 7.47 = Beginning Balance = 14.19 Sec Dep Interest accrual 14.19 = Ending Balance = 5016464 Parkview Villa South Bank Reconciliation Report 02/28/2015 Balance Per Bank Statement as of 02/28/2015 01/12/2015 524 Plus: Outstanding Deposits 12/31/2014 04/29/2014 2062 (0011071 -Johnson 02/11/2015 2299 colu - City of Columbia Heights 02/18/2015 2313 inte929 - Integrity Cleaning Solufions 02118/2015 2315 sitz - Sitzmann Construction dba Sitzmann Elect 02/25/2015 2316 buck8411 - Buckeye Cleaning Centers 02/25/2015 2317 cent- CenterPoint Energy 02/25/2015 2318 dire - Direct Home Appliance Services 02125/2015 2319 fral- Frattalone's/Metro Ace 02/25/2015 2320 high8236 - High Profile Grounds Maintenance, Inc. 02/25/2015 2321 inte929 - Integrity Cleaning Solutions 02125/2015 2322 offi8804 - Office Depot Less: Outstanding Checks Reconciled Bank Balance Balance per GL as of 02/28/2015 Difference Cleared Items: Cleared Checks Date Tran # 12/31/2014 2250 12131/2014 2251 12131/2014 2252 12/31/2014 2253 12/31/2014 2254 12/31/2014 2255 12/31/2014 2256 12131/2014 2257 12/31/2014 2258 12/31 12014 2259 12131/2014 2260 Reconciled Balance Per G/L $242,340.46 693.00 $693.00 232.96 10,225.14 181.35 255.74 54.14 2,819.48 27.59 23.82 46.50 150.35 55.07 $14,072.14 $228,961.32 Notes Amount adam - Adam's Pest Control, Inc. 56.20 cent - CenterPoint Energy 3,003.44 chc - CommonBond Housing 29.40 dire - Direct Home Appliance Services 89.00 fiat - Frattalone's/Metro Ace 2.64 high8236 - High Profile Grounds Maintenance, Inc. 158.10 home7 - HD Supply Facilities Maintenance, Ltd. 131.66 inte929 - Integrity Cleaning Solutions 477.40 kone - Kone Inc. 322.05 nort2844 - Northeaster and NorthNews 432.00 offi8804 - Office Depot 21.99 3/2/15 $228,961.32 $228,961.32 Date Cleared 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 01/31/2015 3/2/15 Parkview Villa South Bank Reconciliation Report 02/28/2015 5016464 12/31/2014 2261 xcel - Xcel Energy 1,976.08 01/31/2015 01107/2015 2262 chc- CommonBond Housing 6,299.24 01/31/2015 01/07/2015 2263 hame - Hamemick Decorating Center 861.95 01/31/2015 01/07/2015 2264 home7 - HD Supply Facilities Maintenance, Ltd. 40.89 01131/2015 01/0712015 2265 inte929 - Integrity Cleaning Solutions 358.05 01/31/2015 01/07/2015 2266 koc17025 - K O Cleaning and Remodeling, Inc. 300.00 01131/2015 01/07/2015 2267 leve - Level One 34.38 01/31/2015 01/07/2015 2268 of08804 -Office Depot 16.67 01/31/2015 01/07/2015 2269 peac - Peachtree Business Products 39.19 01/31/2015 01/14/2015 2270 chc- CommonBond Housing 9.02 01/31/2015 01/14/2015 2271 colu- City of Columbia Heights 1,114.10 01/31/2015 01/14/2015 2272 celuhm - Columbia Heights HRA 11,500.00 01/3112015 01/14/2015 2273 t001 2306 - Jourden 209.37 01/31/2015 01/14/2015 2274 t0012836- Lindstrom 202.81 01/3112015 01/21/2015 2275 cemc3517- Comcast 27.53 01131/2015 01/21/2015 2276 Prat- Frattalone's/Metro Ace 4.96 01/31/2015 01/21/2015 2277 home7 - HD Supply Facilities Maintenance, Ltd. 70.55 01/31/2015 01/21/2015 2278 inte929 - Integrity Cleaning Solutions 181.35 01/31/2015 01/21/2015 2279 kone - Kane Inc. 331.61 01/31/2015 01/21/2015 2280 Ibpm - LBP Mechanical, Inc 639.72 02/2812015 01/21/2015 2281 multi - Multihousing Credit Control 30.00 01/31/2015 01/21/2015 2282 Popp - Popp .com 100.06 01/31/2015 01121/2015 2283 sher4110- Shemin-Williams Co. 49.03 01/3112015 01/28/2015 2284 adam - Adam's Pest Control, Inc. 23.32 02/28/2015 01/2812015 2285 frat - Frattalone's /Metro Ace 3.01 02128/2015 01/28/2015 2286 high8236 - High Profile Grounds Maintenance, Inc. 217.00 02/28/2015 01/28/2015 2287 Ibpm - LBP Mechanical, Inc 326.12 02/28/2015 02104/2015 2288 alls2529 - All Seasons Garage Door Company 44.68 02128/2015 02/04/2015 2289 cent- CenterPoint Energy 3,068.50 02/2812015 02104/2015 2290 colu - City of Columbia Heights 1,939.55 02/2812015 02104/2015 2291 gres1004 - Green Lights Recycling Inc 37.52 02128/2015 02/04/2015 2292 high8236 - High Profile Grounds Maintenance, Inc. 29.45 0212812015 02/04/2015 2293 home7 - HD Supply Facilities Maintenance, Ltd. 143.47 02/28/2015 02/04/2015 2294 inte929 - Integrity Cleaning Solutions 648.00 02/28/2015 02/0412015 2295 koc17025 - K 0 Cleaning and Remodeling, Inc. 400.00 02/28/2015 02/04/2015 2296 nort2844 - Northeaster and NorthNews 432.00 02/28/2015 02/04/2015 2297 xcel - Xcel Energy 2,121.29 02/28/2015 02111/2015 2298 chc- CommonBond Housing 6,180.00 02128/2015 02111/2015 2300 hame - Hamernick Decorating Center 829.19 02/28/2015 02/11/2015 2301 home7 - HD Supply Facilities Maintenance, Ltd. 440.71 02/28/2015 02/1112015 2302 home9055 - Home Depot Credit Services 8.87 02/28/2015 02111/2015 2303 inte929 - Integrity Cleaning Solutions 186.00 02/2812015 02/11/2015 2304 leve - Level One 34.38 02/2812015 02/11/2015 2305 multi - Multihousing Credit Control 30.00 02/28/2015 02111/2015 2306 offi8804 - Office Depot 17.12 02/28/2015 02/11/2015 2307 sher4110- Sherwin- Williams Co. 99.13 02/26/2015 02/1112015 2308 stan0371 - Stanley Access Tecchnologies LLC 56.42 02/28/2015 02/18/2015 2309 comc3517 - Comcast 27.53 02128/2015 02118/2015 2310 dire - Direct Home Appliance Services 89.00 02/28/2015 02118/2015 2311 fral - Frattalone's/Metro Ace 8.32 02/28/2015 02/18/2015 2312 home9055 - Home Depot Credit Services 6.20 02128/2015 02118/2015 2314 Popp - Popp. corn 100.58 02/28/2015 Total $46,667.80 3/2/15 5016464 Cleared Deposits Date Tran # 0110212015 518 01/0512015 519 01/06/2015 520 01/06/2015 521 01/08/2015 522 01/0912015 523 01/1212015 525 01/15/2015 531 01/1612015 526 01/20/2015 527 01/27/2015 530 02104/2015 532 02/06/2015 533 02/10/2015 534 02/13/2015 535 Total Parkview Villa South Bank Reconciliation Report 02/28/2015 Notes Amount Date Cleared 16,663.00 01/31/2015 3,231.10 01/3112015 634.00 01/31/2015 1,942.00 01131/2015 630.00 01/31/2015 672.00 01/31/2015 958.42 01/31/2015 632.00 01/31/2015 640.00 01/31/2015 154.00 01/31/2015 300.00 01/31/2015 20,832.00 02/28/2015 2,594.00 02128/2015 651.00 02/28/2015 1,923.00 02/28/2015 $52,456.52 3/2/15 Date 2/27/15 Page 1 Primary Account @XXXXX @6464 Enclosures 34 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 - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: - SAME DAY DELIVERY OF STATEMENT - PASSWORD PROTECTED - EASY STORAGE CONTACT YOUR BANKER FOR DETAILS! NORTHEAST PUBLIC FUNDS ACCT Number of Images 34 Account Number @XXXXX @6464 Statement Dates 2/01/15 thru 2/28/15 Previous Balance 234,527.54 Days in the Statement Period 28 4 Deposits /Credits 26,000.00 Average Ledger 245,804 30 Checks /Debits 18,187.08 Average Collected 244,365 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 242,340.46 * x++ xx+ x+ xxx++++++ xx++ x++ x++ x+ xxxxxxxxx+++++ xxxxxxx + +xxxxxx +xx + +xxx +x +xx + + +xx+ Deposits and Credits Date Description Amount 2/04 DDA REGULAR DEPOSIT 20,832.00 2/06 DDA REGULAR DEPOSIT 2,594.00 2/10 DDA REGULAR DEPOSIT 651.00 2/13 DDA REGULAR DEPOSIT 1,923.00 + x++ x+ xx+++ x+++ xx+ x++ xx+ x++ x+ xx+ xx+++++ x+ xx++ xxxxxx +xx + + + +xx + +xx + + + + +xxxxxxxx+ Checks in serial order Date Check# Amount Date Check# Amount 2/02 2280 639.72 2/11 2294 648.00 2/03 2284* 23.32 2/12 2295 400.00 2/05 2285 3.01 2/18 2296 432.00 2/05 2286 217.00 2/11 2297 2,121.29 2/03 2287 326.12 2/12 2298 6,180.00 2/10 2288 44.68 2/18 2300* 829.19 2/13 2289 3,068.50 2/18 2301 440.71 2/10 2290 1,939.55 2/17 2302 8.87 2/12 2291 37.52 2/17 2303 186.00 2/17 2292 29.45 2/18 2304 34.36 2/12 2293 143.47 2/18 2305 30.00 * Indicates skip in check numbers NORTHEAST PUBLIC FUNDS ACCT Checks in serial order Date 2/27/15 Primary Account Enclosures @XXXXX @6464 (Continued) Date Check# Amount Date Check# 2/18 2306 17.12 2/26 2310 2/20 2307 99.13 2/24 2311 2/19 2308 56.42 2/23 2312 2/25 2309 27.53 2/25 2314* * Indicates skip in check numbers 2/23 242,565.89 Page 2 @XXXXX @6464 34 Amount 89.00 8.32 6.20 100.58 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx *xxxxxxxxxxxxx Daily Balance Section Date Balance Date Balance Date Balance 2/01 234,527.54 2/10 255,411.14 2/19 242,671.22 2/02 233,887.82 2/11 252,641.85 2/20 242,572.09 2/03 233,538.38 2/12 245,880.86 2/23 242,565.89 2/04 254,370.38 2/13 244,735.36 2/24 242,557.57 2/05 254,150.37 2/17 244,511.04 2/25 242,429.46 2/06 256,744.37 2/18 242,727.64 2/26 242,340.46 * * * E N D O F S T A T E M E N T * ** Parkvlew Villa South Payment Summary Bauk -166W AHD.Ww -() al5- 02/2045 AMMG -YaaMD Inckde VoidvMllCMCo Page 1 of 1 30,012.09 https: // mail. commonbond.org/ owa lev.owa ?ns= WebRead-y &ev= GetFile &canary= 3oxM12r... 4/17/2015 Duds Post total BsY, Wald Vettlw pale a.If Amount 166Wr- Iw4vlay VOW South 22M ds¢50- All smswts Garage Cow Cmpeny WW2015 02/2015 44.68 166W- Pw1oew VOW south 22M ¢p - Cadersbint EmW WON2015 ovals 3,06&50 166W -PS hew VOW South 22% mit- City d COlsrtk Heists W0412MS OW2015 11939,55 166ppr - l for VOW South 22% wee1000 - G¢m L'hh; papyd" lrc 2/04/2015 02/2015 $7.52 166¢x- Pwkvkw VOW sort 22W hyh8236- High P�IeGrWMt Miin¢nan¢, 1w 0210V2DIS Ov20I5 2%45 166Wr- iwkvew VOW Sarth 220 1..7 M S,* Fadtin laaipawee, lid W0412015 02/2015 14147 166W - Pwk 2/w VAi Salth 22% hk929 .1p[gtY O m SOheuW =olvals OW2015 fi4 m 166W -Psbiw Vik Seth 22% Imc17025- M 0 Hearing aM Remoddiny Im. OVDV2015 0212015 40000 166Wr- lwkvkw VOW Spurt 22% m 2844 -H hmaotmr and HwtliNevs WOV2015 02/2015 43100 166Wr- lwkview VOW SOM 22W .1 - %¢I Enegy 2/04/2015 OW2025 2,121.29 1 %aw- Rrksew VOW South 22% prc- CwnmonBOM HO¢in9 WII/2DI5 OV2015 6,38000 156Wr - Iwkvlay VOW South 22% ¢lu -City of C&.10 Heights WI1/2DI5 02/2015 10,20.14 1s6Wr -;whew VOW South 23M Mme - Ma,.& Decorating Crrrtw 2/31/2015 OW201S 829.19 166Wr -lbi VOW Sorts 2301 hceu7 -MC) SspptyF Athea 6kipawee, ud WIW2015 ovals 440,71 166W - swloiew VOW South 2302 ho a 055 - lone Depot 6edit s i¢s W1112M5 ovals SZ7 166W - PwkNM VOW saAh 2303 hwm - Megriy C3ea m Spitons 02/15/2MS 02/2015 18600 166Wr- 10rkaew VOW Sant 2300 1. -14vd Ore a2mini5 0212015 30.30 166aw- Ferhkw VOW Sough 23M roukt - HUkhousinO Edo COmml W121201S OW2015 3000 I66W-lb Vila South 23% pfi %04 -office pX W1112015 0212015 17.12 lww - twhaew VOW Sad+ 2307 sht,4110 - 9rerwrvY011kmiCn =11/2015 02/2915 9%13 1%wY -ftm, a Vila South 23M &aW37l- Stanley 2/31/2035 O21200 56,42 166Wr- Prksaew VOW SaAh 23M .6517- mnront WIW2015 Ov2015 27.53 166W -Ww "Vik Sant 23M dire - Diep Morin Agplian¢ S om; WM015 OV2015 89.00 1 %2/r - Mhaesy Vile South 2311 fret - F2dal..s/Me6o Ace =18(2015 ovals 832 166w - iwloi VOW South 2312 MnrG9055 -HOme Dmd aadit Same. W14112015 02/2015 6.20 166Wr- lerkew VOW South 2313 hk929.lrtM amnmso". wle/N15 OW200 181.35 1665,0 Wloi VOW fart 2314 poop - PtpP.mm =18/20IS 02/20L9 10058 low Haksey VOW spud) 230 sift - S..ii,i CGmHUCtlon *e Si iin Elxt 2/18/2015 02/2015 25574 1%Wr - Aa,k VOW South 23M huds8411 - Bud" Clemi, CaOen W25r2015 02/2015 54.14 3 %pw - Mkiw Wk Sort 2317 cart - CmtwPoiM Energy W28r2015 02/2015 2,819,48 166Wr -Iwloi VOW Sant 2318 die -Ghat Home AWlkripe Sauaut 0212IV2015 OV200 27.59 166Wr- FSkrew VOW South 2319 (rat - Prattaomall4obv Aca W25r2015 OW2019 2182 166Wr- as-biew VOW South 23M higM2M- High PrcfikGrcunds Meinknm¢, iw W251201S 02/2D35 4850 165W lwh Vote South 23M tuai%si 91Wrty Uemiq Sipoia W25/2015 OV2015 ISM35 166w - Pakvkw Va. Sort 23M cifi8804 - o fi¢ Depot 2/2512015 0212015 S&07 30,012.09 https: // mail. commonbond.org/ owa lev.owa ?ns= WebRead-y &ev= GetFile &canary= 3oxM12r... 4/17/2015 N P N N w W W P O P W P P P P P W W W N N N N N N N N N N q IWII N O b V r N N O W A b P A P a A O OW N'. O A V O Y Y Y O O O O p m ti • r y A A i.: a 4)N 41dw ry �' d N a F y D 3.°- =Dr3o m w pcti� n m m �a v0 A W pp A i m i . T =: 'J N G � m� C N I u0i N N� P �' ] _• C � C M j `� � x N .� _ Ap x �n n. °m 2.m �i'o � C ]- Z m w � .p t c'" m� o.'. 0 8a�a c cmm N u 'o °' x N x m e 3 Q A 3 x m i e D d m7 R x - °n A V N N N N 7] N N A A O O A A O A o N ON. O b A W O m o N O b N id N V O O b W N N 0 0 0 O O O O O O O O O O O O O O A r N Gf W p q N w OWj d N w V ✓ W r W r Y r N N A II m u r 1Jn o m 0 �' N o a w N w Y N N A O o o O a P a w tRV� nj O J N S w P O. N O O o O O P o N N N O O w V I J W W V V O V O b ......... N O O O O O O O V W :f EDi m a ? tJll �nmm n o� NNOr omP° °Nl .aY'r ° tPO ° fm G W N N P W O1 O d J w O p G Vl O P V O N G O O VI N O O G G N N y (O j� $ n' Ww w W N W O w O V N r o w O O O O O O O O O W W � A S O r r IN O W O A O A m N O P O tNjl O A N O O N N g O tall Y O Y Y O A O ppp�,•I O W O r A V W% N w l0 O O W A O O W O O D D W W W w 4f1 O P w N W O W b O a0 O W J P d O O P O N A O O w w Y N VI N o m o A b o 0 0 o G W o O' O N N O N O O r N W. O O O O O O O O O O O O O O O O i - -a; b W N N N �( a u w m m P W W w as P A w H N vNi N A N w N N w r O:+ A J O P Ml O O W N O W O Owl O A P N O b O O O O b b m V li O d d P P A O O A O O N A W A O N O O W O D A O O O O O O O O O A N i �a� N N N r V c6 O' N O INII O O O O N N N a b b O N N Vw N P> W O N d N J N P O O °V O N t°O N W O A A O O O O O O O O O P T O A Vbl P P A P O r r N V N O O 0 0 0 N ww O N Y N O O O b im N N O� O Y 2 O O r Y W V J toll O O O O W W N O O A W D D Y Y b IVII N W r w W 9i(( °o W W N N N N N uwi to tan °oo °po o° °oo °o °OO W o00 °om °o °o artJn °o P ? m m 0 0° 0 0 0 O o 0 0 o O o o O° C o o O O O 0 0 O o O o 0 0 0 0 0 0 0 0 0 A O O o o A A A o g 3 W H O W Y V V V V V V P P q P q P g m q q q P N m m m m m m m N W W A r 0 O O W W V V J V g N m q q N N v, in o O W O b b O O Y b O b b v O b "10 O b b P A A N N w O b W N V q O W N W N V P .w q `o o W N V g O A r ... P O p O N r 2 _ x � m O C H 6 N b m R a C O W a w N Z O o T s, N O A N A W 4 m 9 C d 3 T x N p � 3 T p O d N 2 T A Ll ay m 3.0 8 F a a`n rv,o % Iqi, N F ^ a % d ,C lai, 9 m N .me n �Orr d i m 9 IF4 q ] Y b n o N L la1 O P'n b^ O n 3 O e. rp p % x a O ^ 320 fP O O A ub b W p P o O o a yP r .W r O o W m V p P m O o 0 Olo mlw O NO N A N O N O O O O O V O% VI O O ooao'.N -IJm � m x n i moo n+ooNP A.no F 8 nt o y Pw q zm p iNnp z eiam�n�o °O� v n 4 O K 4 O W C O n O O N O O m a m WpN u�m zyn u. z W A V D VOI N r w D a 0000vJii O O O O O V N O O 0 0 0 0 0 0 0 0 0 A a 3 Parkview Villa South Financial Statement Overview March 2015 Revenue: Occupancy for the month of March was 91 % occupied Total Revenue was higher than budget amount (favorable) and reflects a 3% increase in rent Administrative Expenses: Administrative costs for South were slightly over budget (unfavorable). Advertising costs were over budget (unfavorable) and reflect cost of ongoing marketing Other renting expenses were under budget (favorable) 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 slightly over budget (unfavorable); however, this reflects some quarterly billings Electric was under budget (unfavorable) Gas was over budget (unfavorable) and reflects Feb. billing Water was under budget (favorable) and reflects quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were over budget (unfavorable). Janitor and Cleaning Contract was over budget (unfavorable) and reflect the cost of contract cleaners Exterminating Contract was under budget (favorable) Maintenance Supplies was over budget (unfavorable) and reflects cost of faucet replacement, ceiling fixture replacement, plumbing supplies Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Heating and Cooling Repairs Contract was over budget (unfavorable) and reflects cost of water heater repairs Decorating Contract was under budget (favorable) Decorating Supplies was over budget (unfavorable) and reflects cost of paint Furniture and Fixtures was over budget (unfavorable) and reflects cost of carpet and vinyl replacement W O N N W O O m N W O A OD O OI N A O [D O � rn O N M � A N N W O O + A A � W m O OI W N O m w m W N �mm � O V OD N W O V W Oo N N A In t0 N tT N W W <O w tp N O O Uf V iD A N W A W O � W 1p (O O V W W A W m O N > 1 I° d 1 loom yt ■ W C a A W d m n N ]2 D m x a m n c m' N 0 n d 0 N — � � C d N N O d O ' S N � N d �p F � N G d Z 90 W W c S o D w w n O O A O O C W A W W � O O O C N N 0 C eO� (gyp W d N N N N= N 2 O N N 9 d W d ID N V d A N 2 A N N 2 r�i 90 < w 90 < Cf C) E E d d W W O N N W O O m N W O A OD O OI N A O [D O � rn O N M � A N N W O O + A A � W m O OI W N O m w m W N �mm � O V OD N W O V W Oo N N A In t0 N tT N W W <O w tp N O O Uf V iD A N W A W O � W 1p (O O V W W A W m O N > 1 I° d 1 loom yt ■ W C a A W d m n N ]2 D m x a m n c m' N 0 n d 0 N — � � C d N N O d O ' S N � N d �p F � N G d Z 90 W W c S Parkview Villa -South Balance Sheet March 2015 Books = Accrual Mar -15 10100 Cash Balance 241,142.34 10200 Petty Cash 93.00 10400 Investments 714,752.82 11300 Rent Receivable 399.00 11500 Accounts Receivable 0,00 13100 Due From Other Funds 0.00 Total Assets 956,387.16 Liabilities 20200 Accounts Payable 11,758.44 20210 Accrued Other &penes 2,762,48 22000 Deposits 9,412.81 22200 Accrued PILOT 14,156.97 22210 Revenue Collected in Advance 5,701.51 Total Liabilities 43,792.21 Fund Balance 25300 Fund Balance 912,594.95 Total Fund Balance 912,594.95 Total Liabilities and Fund Balance 956,387.16 Parkview Villa -South Income Statement March 2015 Books = Accrual Month to Date % Year to Date % Revenue 3622046340 Gen. Government Rents 26,635.00 97.55% 77,795.00 98.24% 3622546340 Nondwelling Rents 476.00 1.74% 1,53040 1.93% 3629046340 Other Miscellaneous Revenue 193.11 0.71% - 135.89 -0.17% 3912046340 Recovery Damage City - 0.000/0 0.00 0.00% Total Revenue 27,304.11 100.00% 79,189.11 100.00% Expenses Personal Services 100046340 Accrued Salaries Total Personal Services Supplies 200046340 Office Supplies 2010 -46340 Minor Equipment 216046340 Maint. & Construct Materials 217146340 General Supplies Total Supplies Other Services & Charges 3040 -46340 Legal Fees 305046340 Expert & Professional Services 306046340 Management Services 310046340 Protective Services 3210 -46340 Telephone & Telegraph 343046340 Advertising Other 360046340 Insurance & Bonds 381046340 Electric 382046340 Water 383046340 Gas 384046340 Refuse 3850 -46340 Sewer 4000-46340 Repair & Maim Services 410046340 Rents & Leases 430046340 Miscellaneous Charges 431546340 PILOT 439046340 Taxes & Ucenses 450046340 Administrative Expenses 4850 -46340 Interest on Deposits Total Other Services & Charges 4,012.00 14.69% 12,036.00 15.20% 4,01L00 14.69% 12,036.00 15.20% 64.54 0.24% 144.47 0.18% 1,799.90 6.59% 2,725.79 3.44% 0.00 0.000/0 0.00 0.00% 1,095.74 4.01% 2,217.36 2.80% 2,960.18 10.849/b 5,087.62 6.42% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 2,168.00 7.94% 6,504.00 8.21% 0.00 0.00% 76.72 0.10% 162.49 0.60% 386.89 0.49% 864.00 3.16% 1,296.00 1.64% 820.08 3.00% 2,460.24 3.11% 1,914.52 7.01% 6,054.63 7.65% 0.00 0.00% 0.00 0.00% 3,250.37 11.90% 6,069.85 7.67% 14.51 0.05% 52.03 0.07% 0.00 0.00% 0.00 0.00% 5,256.25 19.25% 9,813.73 12.39% 30.00 0.11% 60.00 0.08% 61.16 0.000/0 159.88 0.20% 943.80 3.46% 2,831.40 3.58% 558.62 2.05% 558.62 0.71% 0.00 0.00% 17.93 0.02% 7.67 0.03% 21.86 0.03% 16,051.47 58.79% 36,363.78 45.92% 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.00% 23,023.65 84.32% 53,487.40 67.54% 4,280.46 15.68% 25,701.71 32.46% Parkview Villa South (166) Cash Flow Statement Period = March 2015 Month to Date Revenue 36220 Gen. Government Rents 26,635.00 36225 Nondwelling Rents 476.00 36290 Other Miscellaneous Revenue 193.11 39120 Recovery Damage City Property 0.00 Total Revenue 27,304.11 Personnel Services 0.00 1000 Accrued Salaries 4,012.00 Total Personnel Services 4,012.00 Supplies 0.00 2000 Office Supplies 64,54 2010 Minor Equipment 1,799.90 2160 Maint. & Construct Materials 0,130 2171 General Supplies 1,095.74 2175 Food Supplies 0.00 Total Supplies 2,960.18 Other Services & Charges 3040 Legal Fees 0.00 3050 Expert & Professional Services 0.00 3060 Management Services 2,168.00 3100 Protective Services 0.00 3210 Telephone & Telegraph 162.49 3430 Advertising Other 864.00 3600 Insurance & Bonds 820.08 3810 Electric 1,914.52 3820 Water 0.00 3830 Gas 3,250.57 3840 Refuse 14.51 3850 Sewer 0.00 4000 Repair & Maint. Services 5,256.25 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 30.00 4300 Miscellaneous Charges 61.16 4315 PILOT 943.80 4390 Taxes & Licenses 558.62 4500 Administrative Expenses 0,00 4850 Interest on Deposits 7,67 Total Other Services & Charges 16,051.67 Total Expenses 23,023.85 Parkview Villa South (166) Cash Flow Statement Period = March 2015 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13100 Due From Other Funds 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,280.26 0.00 0.00 (392.00) 0.00 0.00 0.00 1,640.37 820.08 236.41 943.80 4,651.90 7,900.56 12,180.82 Beg Cash End Cash Difference 228,961.32 241,142.34 12,181.02 93.00 93.00 - 748,380.12 748,380.12 - 977,434.44 989,615.46 12,181.02 4/13/2015 2:57 PM Page 6 of 9 Parkview Villa South (166) General Ledger Period = Mar 2015 Book = Accrual; Tree = ysi_tb Propert Date Person/ Description Reference Debit Credit Balance Remarks 1000 -46340 Accrued Salaries 8,024.00 = Beginning Balance = 166 3/31/2015 :PostRecurring Recurring RC 4,012.00 0.00 12,036.00 R/C CHC PR Mgmt Fee Net Change= 4,012.00 12,036.00 = Ending Balance = 2000 -46340 Office Supplies 79.93 = Beginning Balance = 166 2/20/2015 Office Depot(offi8804) 7.56559E +11 22.89 0.00 102.82 wipes /pinnr /Fldr /pens... 166 2/26/2015 Office Depot(offi8804) 7.57771E +I1 40.20 0.00 143.02 ppr;corr tape;pncl cup;Odrs -31q 166 2/27/2015 Office Depot (offiB804) 7.57771E +11 1.45 0.00 144.47 folders -31% Net Change =64.54 144.47 = Ending Balance = 2010 -46340 Minor Equipment 925.89 = Beginning Balance = 166 2/26/2015 Hamernick Decorating Center (hame) CG502007 1,757.43 0.00 2,683.32 carpet/vinyl Install 166 3/11/2015 Hamernick Decorating Center (hame) CG502281 42.47 0.00 2,725.79 min installation charge -31% Net Change = 1,799.90 2,725.79 = Ending Balance = 2171 -46340 General Supplies 1,121.62 = Beginning Balance = 166 2/20/2015 DecoShield Systems II, Inc. (deco272) 22763 8.84 0.00 1,130.46 plugs/end Caps 166 2/24/2015 Home Depot Credit Services (home905 FCH005583420 6.20 0.00 1,136.66 late fee -31% 166 2/25/2015 Sherwin - Williams Co.(sher4110) 3568 99.13 0.00 1,235.79 paint-31% 166 2/26/2015 Sherwin - Williams Co. (sher4110) 3980 49.56 0.00 1,285.35 paint 166 2/27/2015 HD Supply Facilities Maintenance, Ltd. 9135731938 87.30 0.00 1,372.65 protectors/blbs 166 2/28/2015 Frattalone's /Metro Ace (frat) 021315R 21.34 0.00 1,393.99 kllz/lock kit/bibs/seal knock... 166 3/5/2015 HD Supply Facilities Maintenance, Ltd. 9135854844 17.20 0.00 1,411.19 range splash guards -31% 166 3/5/2015 HD Supply Facilities Maintenance, Ltd. 9135854844 1.57 0.00 1,412.76 plate screws -31% 166 3/5/2015 HD Supply Facilities Maintenance, Ltd. 9135854844 60.69 0.00 1,473.45 stn slr;0 tape;spry pnt;K S -310A 166 3/6/2015 Buckeye Cleaning Centers(buck8431) 875126 68.58 0.00 1,542.03 twis/bags /fuel 166 3/6/2015 HD Supply Facilities Maintenance, Ltd. 9135900532 66.72 0.00 1,608.75 ceiling fixture -31% 166 3/6/2015 Home Depot Credit Services (home9059140212 2.84 0.00 1,611.59 pb blaster -31% 166 3/6/2015 Home Depot Credit Services (home9059140209 70.11 0.00 1,681.70 lamp kits;bskts;misc -31% 166 3/8/2015 Home Depot Credit Services (home9057192187 38.19 0.00 1,719.89 malnt supplies 166 3/9/2015 Frattalone's /Metro Ace (frat) 02141OR 2.31 0.00 1,722.20 misc malnt supplies -31% 166 3/9/2015 Frattalone's /Metro Ace (frat) 021411R 13.89 0.00 1,736.09 Kwik Seal -31% 166 3/9/2015 Frattalone's /Metro Ace (frat) 021408R 5.65 0.00 1,741.74 foam cyr;pntbrsh;caps;plugs -31 166 3/9/2015 HD Supply Facilities Maintenance, Ltd. 9135929078 16.10 0.00 1,757.84 cabinet knobs -31% 166 3/9/2015 HD Supply Facilities Maintenance, Ltd. 9135929078 22.30 0.00 1,780.14 light fixtures -31% 166 3/9/2015 HD Supply Facilities Maintenance, Ltd. 9135929078 90.18 0.00 1,870.32 misc plumbing supplies -31% 166 3/13/2015 HD Supply Facilities Maintenance, Ltd. 9136058397 17.16 0.00 1,887.48 light bulbs -31% 166 3/13/2015 HD Supply Facilities Maintenance, Ltd. 9136058397 124.66 0.00 2,012.14 k faucet -31% 166 3/13/2015 Frattalone's /Metro Ace (frat) 021458R 2.51 0.00 2,014.65 gasket spud 166 3/13/2015 Frattalone's /Metro Ace (frat) 02146OR 6.62 0.00 2,021.27 faucet supply 166 3/23/2015 Sherwin- Williams Co. (sher4130) 59391 99.13 0.00 2,120.40 paint/recycle 166 3/25/2015 HD Supply Facilities Maintenance, Ltd. 9136301375 16.41 0.00 2,136.81 TP 166 3/25/2015 HD Supply Facilities Maintenance, Ltd. 9136301375 55.58 0.00 2,192.39 bib /backpiate 166 3/25/2015 HD Supply Facilities Maintenance, Ltd. 9136301375 24.97 0.00 2,217.36 bib /backpiate Net Change=1,095.74 2,217.36 = Ending Balance = 3060 -46340 Management Services 4,336.00 = Beginning Balance = 166 3/31/2015 Common Bond Housing (chc) 033115mgmt 6,180.00 0.00 10,516.00 mgmt fee 03/15 166 3/31/2015 :PostRecurring Recurring RC 0.00 4,012.00 6,504.00 R/C CHC PR Mgmt Fee Net Change =2,168.00 6,504.00 = Ending Balance = 3100 -46340 Protective Services 76.72 = Beginning Balance = Net Change =0.00 76.72 = Ending Balance = 3210 -46340 Telephone & Telegraph 224.40 = Beginning Balance = Page 6 of 9 4/13/2015 2:57 PM Page 7 of 9 Parkview Villa South (166) General Ledger Period = Mar 2015 Book = Accrual; Tree = ysi_tb Proper! Date Person /Description Reference Debit Credit Balance Remarks 166 2/28/2015 Popp.com (popp) 992247623 100.58 0.00 324.98 phone-31% 3/15 166 3/1/2015 Level One (leve) 0486561IN 34.38 0.00 359.36 answering service 3/15 166 3/2/2015 Comcast(comc3517) 877210505019618 27.53 0.00 386.89 Internet -31% 3/11- 4/10/15 Net Change = 162.49 386.89 = Ending Balance = 3430 -46340 Advertising Other 432.00 = Beginning Balance = 166 2/26/2015 Northeaster and NurthNews(nort2844;80759 432.00 0.00 864.00 display ads - 02/11- 02/25/15 166 3/26/2015 Northeaster and NorthNews (nort2844; 80853 432.00 0.00 1,296.00 classified ads- 03/11 &03/25/15 Net Change= 864.00 1,296.00 = Ending Balance = 3600 -46340 Insurance & Bonds 1,640.16 = Beginning Balance = 166 3/31/2015 :PostRecurring Recurring RC 820.08 0.00 2,460.24 C of Columbia Heights Ins Accrl Net Change= 820.08 2,460.24 = Ending Balance = 3810 -46340 Electric 4,140.11 = Beginning Balance = 166 3/11/2015 Xcel Energy (xcel) 5150441553 03/11 1,914.52 0.00 6,054.63 a -31% 2/7- 3/9/15 Net Change= 1,914.52 6,054.63 = Ending Balance = 3830 -46340 Gas 2,819.48 = Beginning Balance = 166 3/10/2015 CenterPoint Energy (cent) 55271324 03/10/1 3,250.37 0.00 6,069.85 G- 02/05 - 03/06/15 Net Change= 3,250.37 6,069.85 = Ending Balance = 3840 -46340 Refuse 37.52 = Beginning Balance = 166 2/28/2015 Advanced Disposal(advc6484) G50004067780 14.51 0100 52.03 trash -31% 2/20/15 Net Change =14.51 52.03 = Ending Balance = 4000 -46340 Repair & Maint. Services 4,557.48 = Beginning Balance = 166 2/18/2015 Drain King, Inc.(dra17740) 95258 44.02 0.00 4,601.50 shower line clear 166 2/20/2015 Integrity Cleaning Solutions (inte929) 4202 244.90 0.00 4,846.40 bid maint 166 2/20/2015 Integrity Cleaning Solutions (inte929) 42022 173.60 0.00 5,020.00 bldg maint/cleaning 2/16 -20/20 166 2/20/2015 Integrity Cleaning Solutions (inte929) 42022 32.55 0.00 5,052.55 heavy salt 166 2/24/2015 LBP Mechanical, Inc (Ibpm) W21606 186.09 0.00 5,238.64 water heater repair- 01/07/15 166 2/25/2015 LBP Mechanical, Inc(Ibpm) W21676 473.71 0.00 5,712.35 wtr htr mp-01 /23- 01/27/15 166 2/25/2015 LBP Mechanical, Inc(lbpm) W21620 376.47 0.00 6,088.82 fan repair- 01/14 - 01/16/15 166 2/27/2015 Integrity Cleaning Solutions (inte929) 4201 181.35 0.00 6,270.17 bid malnt- 02/23- 02/27/15 166 2/27/2015 LBP Mechanical, Inc(Ibpm) W21784 230.17 0.00 6,500.34 Ox glycol leak -31% 2/10/15 166 2/27/2015 LBP Mechanical, Inc(Ibpm) W21747 544.98 0.00 7,045.32 water heater repairs -31% 2/15/ 166 2/27/2015 LBP Mechanical, Inc(Ibpm) W21748 92.03 0.00 7,137.35 heating repairs -31% 2/15/15 166 3/1/2015 Kone Inc.(kone) 221698593 331.61 0.00 7,468.96 maint- 03/01- 03/31/15 166 3/4/2015 Integrity Cleaning Solutions (inte929) 2630 93.00 0.00 7,561.96 garbage removal -31% #A 166 3/4/2015 Integrity Cleaning Solutions (inte929) 2630a 181.35 0.00 7,743.31 cleaning /detail elevators 166 3/5/2015 Adam's Pest Control, Inc.(adam) 959432 32.62 0.00 7,775.93 exterm serv- 03/05/15 166 3/6/2015 K O Cleaning and Remodeling, Inc. (ko 3334 250.00 0.00 8,025.93 painting #119 166 3/8/2015 Integrity Cleaning Solutions (inte929) 2623 139.50 0.00 8,165.43 cleaning /groundskeeping 166 3/9/2015 Integrity Cleaning Solutions (inte929) 2624 573.50 0.00 8,738.93 Spring cleaning -31% #A;B 166 3/13/2015 integrity Cleaning Solutions (inte929) 2622 31.00 0.00 8,769.93 caretaking -31% 166 3/13/2015 Integrity Cleaning Solutions (inte929) 2621 181.35 0.00 8,951.28 caretaking -31% 166 3/20/2015 Integrity Cleaning Solutions (inte929) 2628 172.05 0.00 9,123.33 caretaking -31% 166 3/20/2015 Integrity Cleaning Solutions (inte929) 2628 32.55 0.00 9,155.88 heavy salt -31% 166 3/21/2015 Integrity Cleaning Solutions (inte929) 9 263.50 0.00 9,419.36 cleaning 166 3/25/2015 HD Supply Facilities Maintenance, Ltd. 9136301375 34.75 0.00 9,454.13 filters 166 3/26/2015 Integrity Cleaning Solutions (inte929) 8 62.00 0.00 9,516.13 caretaking 166 3/27/2015 Integrity Cleaning Solutions (inte929) 10 116.25 0.00 9,632.38 cleaning- 03/23- 03/27/15 166 3/27/2015 Integrity Cleaning Solutions (Inte929) 7 181.35 0.00 9,813.73 mnt/clean /salt- 03/23- 03/27/15 Net Change= 5,256.25 9,813.73 = Ending Balance = Page 7 of 9 Pa,WeW Villa South (166) General Ledger Period = Mar 2015 Book = Accrual; Tree = ysi_tb Proped Date Person/ Description Reference Debit 4100 -46340 Rents & Leases 166 2/28/2015 Multihousing Credit Control (multi) 15020334 Net Change =30.00 4300 -46340 Miscellaneous Charges 166 3/19/2015 City Wide Lock & Safe (cit4054) 14268 Net Change =61.16 4315 -46340 PILOT 166 3/31/2015 :PostRecurring Recurring RC Net Change= 943.80 4390-46340 Taxes & Licenses 166 3/30/2015 Columbia Heights Fire Dept (co1u825) 032515165166 -42� Net Change = 558.62 4500 -46340 Administrative Expenses Net Change =0.00 4850 -46340 Interest on Deposits 166 3/31/2015 Sec Dep interest accrual Gil Net Change =7.67 Credit 30.00 0.00 61.16 0.00 943.80 0.00 558.62 0.00 7.67 0.00 27,035.65 4,012.00 Page 8 of 9 4/13/2015 2:57 PM Balance Remarks 30.00 = Beginning Balance = 60.00 residential screening 2/15 60.00 = Ending Balance = 98.72 = Beginning Balance = 159.88 cut keys /service call 159.88 = Ending Balance = 1,887.60 = Beginning Balance = 2,831.40 Anoka Cty Property Tax Accrual 2,831.40 = Ending Balance = 0.00 = Beginning Balance = 558.62 annual rental license 558.62 = Ending Balance = 17.93 = Beginning Balance = 17.93 = Ending Balance = 14.19 = Beginning Balance = 21.86 Sec Dep interest accrual 21.86 = Ending Balance = Parkview Villa South Bank Reconciliation Report 03/31/2015 5016464 Balance Per Bank Statement as of 03/31/2015 Outstanding Deposits Deposit date Deposit number 01/12/2015 524 03/31/2015 545 Plus: Outstanding Deposits Outstanding Checks Check date Check number 04129/2014 2062 03/18/2015 2347 03/25/2015 2350 03/25/2015 2352 03/25/2015 2353 03/2512015 2355 03/25/2015 2357 Less: Outstanding Checks Paves t0011071- Johnson t0003780 - Bennethum cent - Center-Point Energy frat - Frattalone's /Metro Ace home? - HD Supply Facilities Maintenance, Ltd koc17025 - K O Cleaning and Remodeling, Inc. oifi8804 - Office Depot Reconciled Bank Balance 241,384.54 Amount 693.00 3,172.00 3,865.00 Amount 232.96 171.26 3,250.37 14.78 146.18 250.00 41.65 4,107.20 04/02/2015 241,142.34 Balance per GL as of 03131/2015 241,142.34 Reconciled Balance Per G/L 241,142.34 Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) 0.00 Cleared Items : Cleared Checks Date Tran # 02/18/2015 2313 02/18/2015 2315 02/25/2015 2316 02/25/2015 2317 02125/2015 2318 02/25/2015 2319 inte929 - Integrity Cleaning Solutions sitz - Sitzmann Construction dba Sitzmann Elect buck8411 - Buckeye Cleaning Centers cent - CenterPoint Energy dire - Direct Home Appliance Services frat - Frattalone's /Metro Ace Amount Date Cleared 181.35 03/31/2015 255.74 03/31/2015 54.14 03/31/2015 2,819.48 03/3112015 27.59 03/31/2015 23.82 03/3112015 Parkview Villa South 04/0212015 Bank Reconciliation Report 03/31/2015 5016464 Cleared Checks Date Tran # Notes Amount Date Cleared 02/25/2015 2320 high8236 - High Profile Grounds Maintenance, Inc. 46.50 03/31/2015 02125/2015 2321 inte929 - Integrity Cleaning Solutions 150.35 03/31/2015 02/25/2015 2322 offi8804 - Office Depot 55.07 03/31/2015 03/04/2015 2323 cumm - Cummins NPower LLC 514.26 03/31/2015 03/0412015 2324 inte929 - Integrity Cleaning Solutions 181.35 03/31/2015 03/04/2015 2325 kone- Kone Inc. 331.61 03/31/2015 03/04/2015 2326 xcel - Xcel Energy 2,018.82 03/31/2015 03/11/2015 2327 chc - CommonBond Housing 6,180.00 03/31/2015 03/11/2015 2328 odu - City of Columbia Heights 10,225.14 03/31/2015 03/11/2015 2329 deco272 - DecoShield Systems 11, Inc. 8.84 03/31/2015 03/11/2015 2330 fiat - Frattalone's/Metro Ace 21.34 03/31/2015 03/11/2015 2331 high8236 - High Profile Grounds Maintenance, Inc. 158.10 03/31/2015 03/11/2015 2332 home? - HD Supply Facilities Maintenance 526.13 03/31/2015 03/11/2015 2333 inte929 - Integrity Cleaning Solutions 838.55 03/31/2015 03/11/2015 2334 Ibpm - LBP Mechanical, Inc 1,903.45 03/31/2015 03111/2015 2335 leve - Level One 34.38 03131/2015 03/11/2015 2336 nort2844 - Northeaster and NorthNews 432.00 03/31/2015 03/11/2015 2337 offi8804 - Office Depot 7.74 03/31/2015 03111/2015 2338 sher4110- Shemin-Williams Co. 211.97 03/31/2015 03/18/2015 2339 advc6484- Advanced Disposal 14.51 03/31/2015 03/18/2015 2340 chc - CommonBond Housing 17.93 03/31/2015 03/18/2015 2341 comc3517- Comcast 27.53 03/31/2015 03118/2015 2342 fiat - Frattalone's /Metro Ace 16.20 03/31/2015 03/18/2015 2343 hame - Hamemick Decorating Center 1,757.43 03/31/2015 03/18/2015 2344 multi - Mullihousing Credit Control 30.00 03/31/2015 03/18/2015 2345 o118804 - Office Depot 22.89 03/31/2015 03/18/2015 2346 Popp - Popp.com 100.58 03/31/2015 03/25/2015 2348 adam - Adam's Pest Control, Inc. 32.62 03/31/2015 03/25/2015 2349 buck8411 - Buckeye Cleaning Centers 68.58 03/31/2015 03/25/2015 2351 dra17740 - Drain King, Inc. 44.02 03/31/2015 03/25/2015 2354 home9055 - Home Depot Credit Services 76.31 03/31/2015 03/25/2015 2356 kone - Kone Inc. 331.61 03/31/2015 Total Cleared Checks 29,747.93 Cleared Deposits Date Tran # Notes Amount Date Cleared 03/03/2015 536 19,039.00 03/31/2015 03105/2015 537 3,778.00 03/31/2015 03/09/2015 538 2,141.00 03/31/2015 03/11/2015 539 651.00 03/31/2015 03/18/2015 541 651.00 03/31/2015 03/20/2015 540 30.11 03/31/2015 03/25/2015 542 1,507.90 03131/2015 03/25/2015 543 343.00 03/31/2015 03/26/2015 544 651.00 03/31/2015 Total Cleared Deposits 28,792.01 Date 3/31/15 Page 1 Primary Account @XXXXX @6464 Enclosures 47 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 - - -- HAVE YOU CONSIDERED RECEIVING YOUR STATEMENT ELECTRONICALLY? SOME OF THE BENEFITS INCLUDE: - SAME DAY DELIVERY OF STATEMENT - PASSWORD PROTECTED - EASY STORAGE CONTACT YOUR BANKER FOR DETAILS! NORTHEAST PUBLIC FUNDS Account Number Previous Balance 9 Deposits /Credits 38 Checks /Debits Electronic Debit Service Charge Interest Paid Ending Balance ACCT @XXXXX @6464 242,340.46 28,792.01 29,747.93 .00 .00 .00 241,384.54 Number of Images 47 Statement Dates 3/01/15 thru 3/31/15 Days in the Statement Period 31 Average Ledger 250,064 Average Collected 248,899 xxxxxxx++++++++ xxxxxxx++++++++ xxx+++ x++++++ xxxxxx +x + + + + + + +xxxxxxxxxx +x + + +xxxxx Deposits and Credits Date Description Amount Amount 3/03 DDA REGULAR DEPOSIT 19,039.00 3/05 DDA REGULAR DEPOSIT 3,778.00 3/10 DDA REGULAR DEPOSIT 2,141.00 3/11 DDA REGULAR DEPOSIT 651.00 3/19 DDA REGULAR DEPOSIT 30.11 3/19 DDA REGULAR DEPOSIT 651.00 3/25 DDA REGULAR DEPOSIT 343.00 3/25 DDA REGULAR DEPOSIT 1,507.90 3/26 DDA REGULAR DEPOSIT 651.00 ++ xxxxxxxx+++++++++++ xx++ x++++++ xxxxxxxx++++ x++ +xxxxxxx + +xxx + + + + + + +xxxxx + + + + ++ Checks in serial order Date Check# Amount Date Check# Amount 3/09 2313 181.35 3/03 2320 46.50 3/02 2315* 255.74 3/09 2321 150.35 3/02 2316 54.14 3/06 2322 55.07 3/05 2317 2,819.48 3/09 2323 514.26 3/04 2318 27.59 3/09 2324 181.35 3/05 2319 23.82 3/11 2325 331.61 * Indicates skip in check numbers Date 3/31/15 Page 2 Primary Account @XXXXX @6464 Enclosures 47 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Date Checks in serial order 3/10 260,969.99 3/23 Date Check# Amount Date Check# Amount 3/10 2326 2,018.82 3/25 2339 14.51 3/13 2327 6,180.00 3/23 2340 17.93 3/18 2328 10,225.14 3/26 2341 27.53 3/18 2329 8.84 3/26 2342 16.20 3/19 2330 21.34 3/24 2343 1,757.43 3/18 2331 158.10 3/24 2344 30.00 3/19 2332 526.13 3/27 2345 22.89 3/16 2333 838.55 3/25 2346 100.58 3/18 2334 1,903.45 3/30 2348* 32.62 3/17 2335 34.38 3/30 2349 68.58 3/17 2336 432.00 3/30 2351* 44.02 3/24 2337 7.74 3/30 2354* 76.31 3/18 2336 211.97 3/31 2356* 331.61 * Indicates skip in check numbers xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Daily Balance Section Date Balance Date Balance Date Balance 3/01 242,340.46 3/10 260,969.99 3/23 241,412.66 3/02 242,030.58 3/11 261,289.38 3/24 239,617.49 3/03 261,023.08 3/13 255,109.38 3/25 241,353.30 3/04 260,995.49 3/16 254,270.83 3/26 241,960.57 3/05 261,930.19 3/17 253,804.45 3/27 241,937.68 3/06 261,875.12 3/18 241,296.95 3/30 241,716.15 3/09 260,847.81 3/19 241,430.59 3/31 241,384.54 * * * E N D O F S T A T E M E N T * ** Parkyiew Villa Smah Payment Summary Mn-15 Page 1 of 1 2%7x.99 https: // mail. commonbond. org /owa /ev.owa ?ns= WelRe.y &ev= GetFile &canary= 3oxM12r... 4/17/2015 Chad[ Past 3LLd &ad (heahf Vendor W. Mond Arll.a 166W -W Vile Spr0, 2299 air -oly d Cak to Me9jds 03/09/2015 OY200 (10,225.14) I66w - Wb,bv. Vib Sant 2323 omm m N ns fl ba I 03/00/2015 OY2015 514.26 166mr - Wksiw Vib Sant 2320 imm - 85eipty @ N S uws W/OV2m5 03/2015 181.35 1661ry -wla Vile ScM 2325 k"m "ne In. 0Y04F2015 OY2015 331.61 166W Wk Vila Sant 2326 Taa1 -%as1& ' 031OV2015 03/2015 2,018.82 166p -Wkven Vib SauM 2322 Tc- Canmonmed MOmin9 8'1/13/2015 0312015 61180.00 166W - Wkuiew Vib SauM 23M mk -6q d(btmbb Mertz 81/1112015 03/2015 10,225.14 i661pr - Wk Vib SvM 2329 mm272 - DecoShetl Syatbn B, Inc. 03111/2015 03/2015 8.04 166epr- p6-kybW V46 sm6, 23M hat - fnKekmWMetm Am 03/1112015 03/2015 21.34 166opr- Wksie. Vib sad, 2331 hgh8236 -K11,P I.Grmnds Meinannm, Irc 89/1172015 03/2015 1 513.10 166w - W Vib S 2332 home) - I Spph E Aies Midma,ce, pd 03/1112D35 03120!5 526.13 166W - wl s Vile So 23M wMM - hearty 0 M W.. 0 IVZ015 03/2015 538.55 I66W -WkybM Vib Sadl, 23M Ibpm - LW Mechanical, Inc WIV2015 OY2015 1,981.45 166yr- Wk,.iew VdbS 23M 1p -dal Oro 03/1112015 OY2015 3438 166W Wkiea V16 23% nort2844- Nmthmsbr and N.'thflvs 03/1112015 OY2015 432.00 I66w Wk Vila scr 23r, ffiw 4- ffFiceN X 03/1112015 03(2015 7.74 166w -Wkvbw Vila Saul, 23M sher4110 -9,mvi MlliansC 89/1312015 0312015 211.97 166W - Wlaiew Vib S 23M eM� 4 .mIl (). o l 0VIBMS 03/2015 1431 law plksicw' Vila SOM 2340 d,c- Cm,monBOMMOlain9 03/182015 OY2015 17.93 I%w - wly Vib SOUK 2341 aomCl517- mnlmet 03/182015 03/2015 27.53 I"w - Wk Vila Sam, 2362 Fat- fnfWOraLMefm Am 03/182015 03/2015 16.20 I6 MWksisv Vib Sant 2343 Na. - 1Yma,ti6 Dea,etinil Center M /182015 DY2015 1,]5).43 166mr- serle,ew Vib SUN 23M muItl- MUhnpasinOCmdd Unbn) 03/182015 0Y2015 M.00 166apr -Wk bw V&S 2345 01p04 -Office 0amt 89/182015 OY2035 4.59 MW Wk Vila SCUI, 2346 poop - Popp.mm 03 /182015 OY2015 1M.58 166cp-- Ibksiea vib SUM 2347 tM3MO0 &.alum 03/182015 03/2015 1%.26 16Sw - sskrew Vib SOUK 23M adem - /[tun's Pea GM.I, Inc 03/23/2015 03/2015 32.62 166W -Wlx Vib S7Nh 23M bpd[Ball- S 6,,a 0enin9 Centers 03/282015 03/2015 68.58 I" -Wk Vib Sw 23M mrt - Centapoim E.W 03/2512015 03,2015 3,250.37 166w - Wk Vib S 2351 drei7740 0rein Kna, Inc. M /2512015 03/2015 46.02 166W- Wksies Vila Sant 2352 hat - 6rsttdarc's/M Am 03/23/2015 0312015 14.78 166apr - IWk vib SmU 2353 home? - t S lv Po Ibs M s nm, pd 03/23/2015 OV2015 146.18 IMW - Wk i.e Vila S 2350 1ame9055 - Mane Depot O'Wl9ayima 03/2512015 0312015 76.31 166[pr -Wb vow 2355 I 7(125 - K 00M6na and PSmoddinµ l2 03/2512015 0Y2035 250.00 166W - Pabrs Vila Sant 23M karc- MM Irc. 03/2512015 0312015 333.61 166W- PerkaieM Vib South 23P dfi(1IW -0115m Depot 03/25/2015 OY20Z 41.55 2%7x.99 https: // mail. commonbond. org /owa /ev.owa ?ns= WelRe.y &ev= GetFile &canary= 3oxM12r... 4/17/2015 P q N P N q q q q P W W w g w w q P P P q q q N N y� N N N N N m N N N 1Pi1 lPn r O O N V' VI O O b VNI 0 r O O O W W tD J m J O O �•''� e 6 Nita d fm- °m D 3= m nm w o n a Qmga a m oz6 °� n a ci A < m [t,. 3 m 4 s e S x a a °m Q m c m a m. y' x �. a bn '^ IF m � o cn Q m 1 N V V V V m n N J q W r N N 0 A O 0 b r N P r O A N N Y p A O O O d W O J N O O W O p P W wq a p Y Y q w Or W N J b W O V O d O O N O O O Y Y p O O r O O O W O N W O V O N O O O O O J N O O A O O O Y Y O O r O a O O O y O r N q V r� P N N W r IAIi r w w b ~ 0 O N O w P r H W% q (Njl b 0 O O N O P A p y"j A V N g w W V q o O O J O O V O O N O VI W V O O V O b W O N O O O O O O O O J W d J A P R 0 w r O r q W IV11 P P IWiI V W O N W VI O r O O W y y N N N A O p P N � s P Pd 2 mO V N o V V W o r O J g O VI b O O O w V T. S. n S N a L O P O T VI V W O O O W N O A A O O O O W N P O 1r N N r N W W ' O q� A b b O P O d O O W O 00 W W J� J� A A N. O O VWI 0 W 9 O O W N 0 O W O O O O V O n A q N➢ N D N N N A O A N q O b V b r D W W � P P N 0 VNI m A O b O A V r P O O A O A P O V N W w O P b N A N N p p N N N N p ybj - N °w � N a owom m'qm Op 000po p'op 'op m bop r e c p' 0 J b N A A N N n P P N b N U yNj O O O W N O O O V. A N T N 0 N W N q O O. O W W N r K O O O C N O O 00 L O G O p 0o N O O oO N N o A V O A O O O O P� O O O O < N N r N O �m P , b P W P IVII T O N b O VPI N N • W r W �P N O INII W o b O N A y y� A O Y N p V m w w N VI P r W O In J N V r A O O r W b b O O b o O O b r O 3 v O 1b0 qb N V q o W N Y bW N V T o W P `O O W N V g o a r O b w T VA1 N V y Y Y 2 Y c T N 0 9 9 O E ^ 9 N O by Ip E O sr N 3 O O N 2 m A 4] Gl T y£ °^ C uxi �X 9 n S P e a A a ^ _� v m a a. »SRA�ga� [[[. i- T 4 w 3 w N r u m 1i: N N i O W f0 N N N W N V N N r yy Aid p W O T N O 3 O 00. N O OR p 9 Y N A b N O W Y q N O a .. a p N N b �p N W O V W Iqn �O N lNn O W Z N Z O o a V A n W N W o�ouD war °D o 3 d w A O W V W V W q N P O N O O V N A w O m$ n 4 d � N m N N N b W �p q A W P N r Y d N V b N d J A J W W yY � N A d V p T Z �O N lbli A m hqi A m P w D m r r m➢ o. O W N N N W V N a N N � V O O O O 0 b N G N O N A d = O q A A N N o b V ip O O tJp O qN y y O o N w w b o 0 t 1 N • q N N W O p O q V T N M j+ N W 4 V N O N o N r N N O N N A P v tVn O N O lVn N r S T N N O O N o A O o Y r o OV1 N O O O O O� A N 0 0➢ a .. a p N N b �p N W O V W Iqn �O N lNn O W Z N Z O o a V A n W N W o�ouD war °D o 3 HRA RESOLUTION 2015 -05 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT (HRA) APPROVING THE ADDITION OF DEFINITIONS OF "SUBSTANTIAL DEVIATION" AND "SIGNIFICANT AMENDMENT OR MODIFICATION" TO THE PARKVIEW VILLA PHA PLAN. WHEREAS, The Department of the Housing and Urban Development require that Public Housing Agencies submit a Certification in regard to Public Housing Agency Compliance with the PHA Plans and Related Regulations; and WHEREAS, the PHA Plan for Parkview Villa was last approved by the HRA in October, 2014; and WHEREAS, the amended PHA Plan includes the phrases "Substantial Deviation" and "Significant Amendment or Modification ", for which HUD requires official definitions. NOW, THEREFORE BE IT RESOLVED, by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that the attached definitions are hereby approved. ADOPTED THIS 28`h DAY OF APRIL, 2015. MOTION BY: SECONDED BY: ROLL CALL: HOUSING & REDEVELOPMENT AUTHORITY Chair - Tammera Diehm Executive Director - Walter Fehst COLUMBIA HEIGHTS HRA DEFINITIONS OF "SUBSTANTIAL DEVIATION" AND "SIGNIFICANT AMENDMENT OR MODIFICATION" TO PHA PLAN Substantial Deviation: A substantial deviation is a decision made by the Board of Commissioners to change the HRA's mission statement, goals or objectives identified in the 5 year plan. It is also when goals or objectives are changed that affect the residents or have a significant impact in the HRA's financial situation. Significant Amendment or Modification: A significant amendment or modification is a change in HRA plans or policies that require formal approval by the Board of Commissioners. Executive Director Date First Quarter 2015 Occupancy Report Parkview Villa North January: 93% February: 95% March: 97% Parkview Villa South January: 89% February: 87% March: 91 % Votta, Jennifer r'b &'t' `A C("c e From: LINDA FOLTA [firstheaart@yahoo.com] Sant: Monday, February 16, 2015 8;19 PM To: Mlndestrom, Heidi /v ,,M(V\ Cc: Votta, Jennifer Subject: Parkview Villa minutes for Feb.9 2015 Parkview Villa Resident Council Minutes for February 9th 2015 Meeting called to order 7pm, Pledge of Allegiance was said Secretaries report was read from December as no meeting was held in January Treasurers report: Beginning balance $1661.78 Check to Lou the nurse $75 Ending balance $1586.78 Petty cash on hand: $79.88 Sunshine Ladies report; 2 cards given to Roy Kramer #416 and Victoria Larsen #415 both in Hospital. Old business: Reports of people still knocking on doors between 12am and 3am ... this must stopl Also garbage still being tossed on elevators. Please respect our public areas it makes us look bad when people from outside come in and see this. New business: Please stop taking down the signs that management or residents put up to inform us of what kind of activities are coming up, Also reports of someone messing with the peepholes on peoples doors, Discussion brought up to have Birthdays every 2 to 3 months as we need to watch the money in the resident councils checking account. There was a discussion on having a rummage sale to make money for the council. Idea was brought up to have a "springfling" type of party. Would cost $150.00 to have the Floras Band again, There was no managers report or HRA report. Meeting was adjourned at 734pm (tea rc (�u^CA�\ �..ea.�v(�� qq Mares, � 2015 Resident Council meeting was called to order at 7:00 pm. Pledge of Allegiance was said Secretary's report was read by new secretary Terry White Treasurer's report: Beginning balance for March was $1497.23 Deposit of $239.00 for Vending was made. Still waiting for Laundry deposit from management. Check for $75 for Lou the the Wellness nurse $25 for councils gift to Jenn Votta's going away party. Ending balance $1636.36 Petty cash begining balance $79.81 $30 to Rheta for sheet cake and $5 for gas ending balance $44.81 No managers report was given. Sunshine report: 5 cards for the month of February were given out to Cecilia Rauthbauer for loss of son In law Diann Powell for loss of brother in law Kumba for illness Deanne Kurcher for loss of aunt and to the family of Esther Linden for her passing Old business: No HRA report, But discussion was brought up about smoking still very strong in places in the building. Also it was mentioned about strong pot smell in the halls of certain floors, Complaints about cigarette butts just being dumped in places they shouldn't be inside and outside especially. Also someone mentioned about finding dog feces is the garage right by their car. And right in front of the building. Please call police or management If you see any of these problems. Garbage is still being dumped on floors of elevators and just anywhere that people feel like it. Please keep our building clean! We all have to live here. Heavy discussion on the use of the B room for making popcorn on Friday nights, It was brought up that this is totally fine since the room had been rented. But the person was kind enough to leave the doors open so people could still come in and be sociable. Also it is not the council nor the boards right to say anything. We have no control over B room. Should be brought to management not the council. New business: We were going to have a discussion about a spring party. But there weren't enough people at the start to constitute a vote. It was mentioned that we should put up a flyer about the party. Also discussion about a rummage sale was put on hold, Meeting adjourned at 734 pm. First Quarter 2015 Maintenance Calls Parkview Villa January: 7`h -Entry Door for Building not opening 10`h- Clogged Toilet February: 12'h- Refridgerator is freezing food March: 2n4-Apt. door lock stuck 5th- Shower drain is slow 8th -Apr. door lock not working 12d'- Resident dropped something in toilet, afraid to use it 20th- Clogged toilet 22nd- Entry Door for building not working 24th- toilet overlfowing 27th- Clogged Toilet 29th- resident locked out of unit