Loading...
HomeMy WebLinkAbout2013-07-23 HRA AgendaHOUSING & REDEVELOPMENT AUTHORITY AGENDA 7:00 P.M. TUESDAY July 23, 2013 PARKVIEW VILLA, COMMUNITY ROOM B, 965 40TH AVE., COLUMBIA HEIGHTS, MN 1. Call to Order 2. Roll Call Tammera Dielnn, Chair Bobby Williams, Vice Chair Rheta Nelson 3. Pledge of Allegiance CONSENT AGENDA 4. Approve minutes of April 23, 2013 meeting Bruce Nawrocki Donna Schmitt, Secretary /Treasurer Gary Peterson 5. Approve Financial Report and payment of bills for April, May, June 2013 on Resolution 2013 -07. Motion: Move to approve consent agenda as presented. BUSINESS ITEMS 6. Report of Management Company 7. Resident Council Minutes S. Citizen Formn* 9. Aeon Update (no attachments) 10. Other Business The next regular HILL meeting will be Tuesday October 22, 2013 at Parkview Villa. *At this time, citizens have an opportunity to discuss with the HRA items not on the regular agenda. "rhe citizen is requested to limit their comments to five minutes. Please note the public may address the HRA regarding specific agenda items at the time the item is being discussed. HOUSING & REDEVELOPMENT AUTHORITY MINUTES OF THE MEETING OF APRIL 23, 2013 1. Call to order — The meeting was called to order by Chair Diehm at 7:00 pm. 2. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Donna Schmitt, Bobby Williams, Rheta Nelson, and Tammera Diehm. Staff Present: Executive Director -Walt Fehst, Community Development Director -Scott Clark, Assistant Community Development Director - Sheila Cartney, and Secretary- Shelley Hanson. CommonBond Staff - Laura Frost and Jeri Vota 3. Pledge of Allegiance — Recited CONSENT AGENDA 4. Approve Minutes of January 22, 2013 and March 4, 2013. 5. Approve Financial Reports and Payment of Bills for January, February, March 2013 on Resolution 2013 -06. Questions from members: Schmitt noted that the occupancy of the south building was 80% occupied according to the reports. She wondered if any more of the units had been rented since the reports were submitted. Laura stated that one unit was occupied as of April 1't, four are scheduled to move in May 1't, and that will leave one vacancy. She stated the move -in special is still in effect and has helped prompt interest in the units. Nawrocki stated there wasn't much interest for the first 3 months of that move -in special. Laura stated part of the reason is that older residents don't like to move during the winter months and it takes a while for the sign and other advertising to be noticed. Nawrocki asked about a figure in the March 01 minutes, first page, last paragraph. He noted the fund balance for the south building should be approximately $750,000, not $100,000 as stated. Clark confirmed that is correct and the minutes will be changed to reflect that correction. Nawrocki then asked about the use of the funds. Clark stated that would be discussed later in the sale process since the amount may fluctuate between now and the closing, and any decision made by the Council in regards to a new Library could also be part of the discussion. HRA Minutes Page 2 April 23, 2013 HRA RESOLUTION 2013 -06 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JANUARY, FEBRUARY AND MARCH 2013 AND PAYMENT OF BILLS FOR THE MONTHS OF JANUARY, FEBRUARY AND 2013. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (HRA) is required by Minnesota Statutes Section 469.096, Subd. 9, to prepare a detailed financial statement which shows all receipts and disbursements, their nature, the money on hand, the purposes to which the money on hand is to be applied, the HRA's credits and assets and its outstanding liabilities; and WHEREAS, said Statute also requires the BRA 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 2013 and the list of bills for the months of January, February and March 2013 are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that it has examined the attached financial statements and list of bills, which are attached hereto and made a part hereof, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the list of bills as presented in writing are approved for payment out of proper fiords; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 23"1 day of April 2013. MOTION BY: Nawrocki SECONDED BY: Peterson AYES: All ayes 6. Resolution 2013 -05 Interfund Loan to City Clark told members that inter -fund borrowing is a routine method of managing cash flow and maximizing interest income. By about May of each year, the City has usually spent down its short-term cash from the past December's tax collections. The City then sells some of its medium or longer term investments to maintain sufficient cash flow until it receives the June tax collections. This typically results in the City earning less on the investments sold early, compared to what these investments would pay if held to full maturity. HRA Minutes Page 3 April 23, 2013 Currently, the HRA's Parkview Villa North Fund 203 has a significant cash balance of approximately $900,000 held in a savings account that is only paying about 0.35% annual interest. This is held for long -term repair needs and not for current operations. This is not invested in longer -term assets paying a better interest rate because the HRA is in the process of selling the Parkview property. Analysis From the City's standpoint, if it received a sixty day loan from the HRA of $750,000 with a 1.0% per annum rate of interest, the City could hold more of its existing investments to full maturity, and repay the loan when the June tax collections are received. The interest paid to the HRA under these terms is less than the estimated interest penalty the City would incur to sell investments early. From the HRA's standpoint, issuing the loan provides a safe short -term investment at almost three times the rate of interest the HRA is currently earning on these funds. If some unexpected event was to occur, causing the HRA to need repayment of the loan sooner than sixty days, the loan provides the option to modify the terms by mutual resolution. Staff recommends that the HRA Board of Commissioners adopt the following Resolution. Questions /comments by members: There were no questions on this item. Motion by Nawrocki, seconded by Peterson, to waive the reading of Resolution 2013 -5 and 2013 -06 there being ample copies available to the public. All ayes. MOTION PASSED. Motion by Nawrocki, seconded by Peterson, to approve the consent agenda items with the correction to the minutes as noted, and to adopt Resolution 2013 -05 and 2013 -06. All ayes. MOTION PASSED. HRA RESOLUTION 2013 -5 COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY RESOLUTION APPROVING AND SPECIFYING TERMS OF INTER -FUND LOAN TO THE CITY OF COLUMBIA HEIGHTS RECITALS A. The City of Columbia I- [eights ( "City ") and its Housing and Redevelopment Authority ( "Authority ") desire to enter into a mutually - beneficial sixty (60) day inter -fund loan agreement. B. The Authority is currently undertaking to divest itself of all operations. Therefore it is impractical for the Authority to invest in long -term high- earning investments at this time. Consequently, the Authority's building repairs reserve for Parkview Villa North is currently invested in a demand deposit account with an interest rate of approximately 0.35 percent per annum. It would be advantageous for the Authority to safely earn a higher rate of interest for a sixty day period. HRA Minutes Page 4 April 23, 2013 C. The City receives two large payments of property taxes each year as its primary source of funds. Therefore the City invests upon receiving these payments, and then liquidates the investments over the following six months until the next tax collection. It would be advantageous for the City to hold more of these investments to full maturity beyond the next tax collection date of June 20, 2013, instead of liquidating them in the current market. NOW, THEREFORE, BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing and Redevelopment Authority: I . The Authority authorizes of a loan to the City in the maximum amount of $750,000 (the "Loan "), to be drawn fi•om Fund 203 — Parkview, Villa North. Such amount will be made available to the City at April 24 "i, 2013. 2. "Pile outstanding principal balance of the Loan bears interest at the rate of 1.0 percent per annum. Interest accrues from April 24d', 2013. 3. The Loan is payable from the City's Investment Fund 886 and shall be due in full, including all accrued interest, on June 24 °i 2013. 4. The principal sum and all accrued interest payable under the Loan are pre - payable in whole or in part at any time by the City without premium or penalty. All payments shall be applied first to accrued interest, and then to unpaid principal of the Loan. 5. The Authority and City may amend the terms of this Loan at any time by mutual resolutions. 6. The Authority authorizes and directs staff to take all actions and execute any documents necessary to carry out the intent of this resolution. Passed this 23rd day of April 2013 Offered by: Nawrocki Seconded by: Peterson Roll call: All ayes BUSINESS ITEM Report of Management Company Laura announced that the new on site manager started this week. Heidi Mindestrom has worked in affordable housing for over 20 years and came from Legacy /Premier Management. Laura also reported that Parkview has been awarded a grant for 2013 in the amount of $44,000. She said they have been working on the specs for the first floor rehab and the bid should go out in the next 8 weeks. Laura also stated there is a meeting set up for next week to discuss the replacement of the fire panel. HRA Minutes Page 5 April 23, 2013 8. Resident Council Minutes LeeAnn gave a brief report on the Resident Council items. She stated they recently had a guest speaker regarding how to build strength and maintain balance in order to prevent falls. They also have started an exercise and yoga class on site, have started a garden club, and recently had a magician perform for the residents. 9. Citizens Forum Laverne Harper #408 - voiced her concern about LaBelle Pond being taken over by weeds. Nawrocki commented that it was meant to be a natural wetland habitat. Fehst stated that he will pass on her concern to Public Works but we are regulated by the State to as to how much we can actually alter the site. Peterson and Schmitt both told residents that there is a project planned over the next couple of years to re -do the shoreline, remove the rotted timbers, and to do some pond cleanup, so hopefully they should see some improvements. Mary #703 - expressed her concern about the number of geese and ducks and how aggressive they are. It deters residents from actually walking around the pond area. LeeAnn 4424 -part of the problem is people in the area feed them so they keep hanging around. Diehm suggested they put up signs and pass out notices stating "do not feed the geese ". Rheta Nelson #510- people don't pay any attention to notices that are distributed or posted. Ms. Bircher #911 -she stated that it isn't the bird feeders that cause the problems —it's the food, chips, candy, and even meat that is thrown out to them. Fehst said he will have staff look into whether they could be rounded up and then relocate them. He said there have been programs in the past that have tried this approach. He said this problem is not exclusive to LaBelle Park, but is being experienced throughout many metro areas. 10. AEON Update Clark said that AEON has completed most of their investigation of the buildings and is preparing a plan as to what updates they will do to the buildings. He expects they will start holding meetings in June to inform residents what projects are planned. Clark then told members that staff has been working on the voluntary conversion plan which has proven to be a difficult process. He said in the last 10 days they have been assigned a worker to facilitate the process so it should go better from here forward. I-Ie expects this will be a 90 day process to complete. HRA Minutes Page 6 April 23, 2013 Clark reported that AEON had previously applied for HOME Funds and was tentatively awarded $325,000. He said the County took final action on this and approved that funding. He said he still expects the sale to close by year end. Adam #611 -asked what type of assistance residents will have. Clark stated it will be similar to what they have now and that rent structures will remain the same. I1. Other Business Diehm announced cookies were available after the meeting so residents could informally chat with members if they wished to. Dielnn stated the next regular meeting is scheduled for Tuesday, July 23"", 2013, at Parkview Villa. The meeting was adjourned at 7:30 pm. Respectfully submitted, Shelley Hanson Secretary COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) Meeting of: July 23, 2013 AGENDA SECTION: Consent Agenda ORIGINATING EXECUTIVE NO: 5 DEPARTMENT: HRA DIRECTOR APPROVAL ITEM: Financial Report and Payment of Bills BY: Laura Frost BY: — Resolution 2013 -07 DATE: July 17, 2013 BACKGROUND: A copy of the Financial Reports for the months of April, May and June 2013 are attached. RECOMMENDATION: Management staff will be available to answer specific questions. If the report is satisfactorily complete, we recommend the Board take affirmative action to receive the Financial Report and approve the payment of bills. RECOMMENDED MOTION: MOTION: Move to waive the reading of Resolution 2013 -07, there being ample copies available to the public. Motion: Move to approve Resolution 2013 -07, Resolution of the Columbia Heights Housing and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills for the months of April, May and June 2013. HRA ACTION: HRA RESOLUTION 2013 -07 RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR APRIL, MAY AND JUNE 2013 AND PAYMENT OF BILLS FOR THE MONTHS OF APRIL, MAY AND JUNE 2013. WHEREAS, the Columbia Heights Housing and Redevelopment Authority (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 2013 and the list of bills for the months of April, May and June 2013 are attached hereto and made a part of this resolution; and WHEREAS, the HRA has examined the financial statement and the list of bills and finds them to be acceptable as to both form and accuracy. NOW, THEREFORE BE IT RESOLVED by the Board of Commissioners of the Columbia Heights Housing & Redevelopment Authority that it has examined the attached financial statements and list of bills, which are attached hereto and made a part hereof, and they are found to be correct, as to form and content; and BE IT FURTHER RESOLVED the financial statements are acknowledged and received and the list of bills as presented in writing are approved for payment out of proper funds; and BE IT FURTHER RESOLVED this resolution and attachments are to be made a part of the permanent records of the Columbia Heights Housing & Redevelopment Authority. Passed this 23`d day of July 2013. MOTION BY: SECONDED BY: AYES: All ayes Chair Attest by: Shelley Hanson, Secretary Parkview Villa North Financial Statement Overview April 2013 Revenue: Occupancy for the month of April 2013 was 99 % occupied; Rent Revenue was over budget (favorable) for April Total Revenue for April was under budget (unfavorable), however, we did not draw down the operating grant in April Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Computer Equipment, Supplies and Maintenance was over budget (unfavorable) and reflects the cost of computer support Legal Services was under budget (favorable) Misc. Admin Expenses was under budget (favorable) Utilities: Utilities Expenses were over budget (unfavorable), however this reflects a quarterly billing Electric was under budget (favorable) and reflects quarterly billing Gas was over budget (unfavorable) and reflects quarterly billing Water was over budget (unfavorable) and reflects a quarterly billing Sewer was under budget (favorable) Operating and Maintenance Exnense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was under budget (favorable) Garbage and Trash was over budget (unfavorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs is over budget (unfavorable) and reflects the cost of Boiler repair on pumps #1 and #2 as well as Bath and kitchen exhaust fan repairs Snow Removal Contract was over budget (unfavorable) and reflects final snow removal in April Furniture and Fixtures was over budget (unfavorable) and reflects the cost of electric range replacement N m m m m m m m m m m m W m m m ( m N N m N O o O P ON - o T A m 0 A :� m D� ° u a m �-' o m A A m mm 3 r 2 I- 3 m m 71 �mc �• m Z o m m o m a 3 fa m H O T L c S O ? m m m m m (Cii ° �m� [!� to �m J am $ c 01 m c m mv'm m 'm m w m J C � �m���'3�� $°n m H 3 m v'N umi m N y V W O O O O O O O O V^� O O N N O N N O O !J O O O O O O O O O O O O O O O (D 00.00 O O O O O O O 00 A m O N O m °i (O (JT N -3 m .� N N Q (O Oml m V O m O N m N o N (n N m w m OJ o Ol O O O W O O J N W W W O W o V o O 0 O O O O W [NO V O O O o W W m V U V V V O ? O o m O O V N O o O N N P N O O O N N N j j N m Do°oo m JN w o ow J -J'N m O m In O N N N tO In m O O m A 0 0 0 O m N O O O O l0 m O O O O O o w omm o0 o w om0000 N O m O O O o N N N mm O N N N o w � O w m O Pl. O POP 4l f J N O O O m A m 01 O m O I m O N m W 0000 f.Jm m O m m m0 °Oi O tV0 O J W W A J T N N A N iD O O m w m o O O O O W A A V N N T N W mW� w m N O O PA O O O D o 000000 00 o O oOO OO < -, o OoO000 00 0 0 0 0 0 00 mvU3 v m ry n D R o'" 5 �p S N� 7 N m q o W v o c - mm m mmmmm mmm mm m �immO� m m&i � °� m m m w ww m m m www F n a �� n � •" N N N N N m N N N N N N N N A A A A A O l°NNNNNO O �O c0 m V mN AI D- AA (O A m AA W w W N N V m N NN N o (D V N W m W N� 0 0 W N V O V O O O O O C t m N („' �0 ° m1 A 0 m N v m 3 > >Q o °m 0 2 0.' m 0 lo n 'c' J n O �n RA 4i n m ) m — Gm E: ? N_ N m N q N N R �S wm N N N Imo O jE_L • N N ti S Woo A W<o m o N N (ll yy C_6J ITI (/1 Jv J m (N < N, 'O rt D N N 'J m N N O m N N N a m 2. 5' G n S'O O J m 4Y N N J l N 0 a m ^ . m J m w o 6 3 o° j W V o t 0 A J W OV V m N N NOWmVO O o WO j (NPOOl� ON UI NOOOm mON O m p G O O N A N W o A A IJ W N m Ot w N O� N O W O O W O A O N A ICm m O m m t0 W O- A W p N A A fD A (n N m p A O O O m A m t0 O m W N ID W W O A bn ' � V O m m W O V� a> m m? m Om W O f4J CJ OJ W N W O o o V �m N O V V W o o V V V N J o N W o W W W O o A A N W N m m W O N W W O m N N t 0 m (- N N ,m m O O) V N m N m w O (P m» m? I N V V J J N N t0 V <1N N N O m V W N m W mw. O N V N(O V m m(Ow A t0 W O O O I m O O� a O O p p O d m 0 O O J O. N O O W D A O oD wopom meow om - N [O m OJ v m. W A o W (O O O'A W O N N p t0 (D O o m m A W W m (O O W O N m V V N m O (O W W O O W ONj N O C OJ W OJAOOfO BOO V ON O ^I V V W Am mONi�. OO V NAOOm W(Om oV NA�JOO p m N X10 -1 m -Wm UN m O W W O W W m W (O N O m G V O .0 m m m w O N m N W O O m J m m m m m O V J O w w W m N W O O m W 6 O O m w N p O m m m m m o m N O N N N 1 W m Min m. N N N N m A J t o O m V W W- N- m N J W A W O p N A m N m m N m N O N m J p N O W N i N N V N O J t0 -` m m O O(O m -' O O V m�I O m N J m V m Pl IJ N fJ IJ W N N N V N ? m w' O o (O W N O O O N (D N m W m W W N �e ON A� (O N W V ( Woo O O O o m m f O Z O( I J -` l0 O O I V W A o- O m A I J J O D o +VI O m O O f 0 0 0 O A m O m m <D m O V O Y _ { m W N W m -' O m V m O m W N O N O N O N- V o N N W O A N O 00 m O O o N O m m a N 0 O O O O O N 0 0 0 0 0 O N PC N N p O o O p m o o p o o�O O .0 0 0 0 0 0 0 O 0.00 o 0 0 0 0 0 0 G� n_ 66 0 0 0 0 0 0 0 0-000. 0 v w 00 0 00. 0 0 0 0 0 q N j j V V J m w m w m V m V m m J V m m m m m m m m m m m N m m m m m N N N Ol N f 0 N O O O O N O O w w O N W V w m O ow - t 0 O m 0 O W O N m V 0 t 0 w m m m o A- 0 m 0 W W NN �woo1 Ry1 1yT 5m� O6'j' 5rt�f O Q' V T b j T 'G -- c x 1 � Na 0mNM W9 � 0 0 m ,0 3xm Sy N9 n N 0 .O m= W N 0 CC �I OI O'nW �N ✓ O Oµ (0 l �G M O p 0 4 f mC lry N G 'i C ; p CI O m IOC m O o X N [b �➢ 10 m 0 m N 0 T 0 O H N 3 C: VI N N CO NOC"vO ^ m m S Q O O C O d N � N N ti N N W Ip O O 0 o N N N (Nil O O O O N N N t� N N O O 0 0 O o Oo O o w W O O O O O O w W no O O 00 0 0 0 o °o N N O O O O 0 00 w A O O T Ir W m W rV N 'm O N l0 m �P N W N N °o W r O N N W r � W W PO W W � tm0 r J A A A O m m m m m G1 t0 (O W VI J W O O N V J N � W N N N N N � A A UI OJ w m N N 1J A A J � N O m m 00 0 °o N N V O o N o N N tOD m N O V W N m A N m N W O O O A u P o W w o w V W m V w m O m N � J W W m J m o m r W ID N Imo OAOOf N Y noon r O wI W NN �woo1 W W Vq A m N N A m N o mb o W O A 10 N N W 4J O la A o o 0 no W 00 o V (NII O W N NOOOi O m O A I O O V O N O (000 W OO OO' tmp o M o o p m O N O O A � N o m m V O W O I V O W O� f O O W O m I W O N O w t pI -V1 O own m 0000 wp w o w o w I l O O t P.41; 0 oLJow 0 0 0 o w E i � w A i 1 O A O N -1 g a < ii f0 m Rv 2 N 0 v W o L S� 01 O. m O N u y- O � W O 1p IID__ c a N z Nm w X41 N N n w X OcL m C N Z 9 c m P. O O (D O w W w l+ O OI W W O W l0 m w m N W W N W V W W VI m NI 1i1 V O O 80 09 yN 'n a 3C = 6 N 0 �0! N C O H rye. NJm ry O N 3 NN not O O O t0 V V � W � W W W w 0 T 0) N N o w W OI O o w N W W W W N w N N � O N N m mrn w ww <0 0 0 IJ J V W W W W W W N N N W N N V w w 41 W W N f0 (O W W w N tl� Oi m mrn (Wli P A 41 0 O V N N O O O O O O F 4 Q y ii N U w 0 Z ID V y' in O d N a f Parkview Villa -North (16S) Balance Sheet April 2013 Books = Accrual Apr -13 Assets 10100 Cash Balance 23,401.92 10200 Petty Cash 871.00 10400 Investments 891,214.11 11300 Rent Receivable 972.20 11500 Accounts Receivable 197.12 13200 Due From Other Government Units 23,847.09 Total Assets 940,503.44 Liabilities 20200 Accounts Payable 26,449.50 20210 Accrued Other Expenses 6,967.00 20220 Due to Resident Council 551.74 22000 Deposits 18,647.02 22200 Accrued PILOT 32,434.38 22210 Revenue Collected in Advance 386.60 Total Liabilities 85,436.24 Fund Balance 25300 Fund Balance 855,067.20 Total Fund Balance 855,067.20 Total Liabilities and Fund Balance 940,503.44 Parkview Villa -North (165) Income Statement For The Period Ending April 2013 Books = Accrual Revenue 33160 -46330 Federal Grant 36220 -46330 Gen. Government Rents 36225 -46330 Nondwelling Rents 36290 -46330 Other Miscellaneous Revenue 39120 -46330 Recovery Damage City Property Total Revenue Expenses Personal Services 1000 -46330 Accrued Salaries Total Personal Services Month to Date % Year to Date a/o - 0.00% 11,036.00 8.13% 29,988.00 96.96% 120,154.00 88.52% 429.00 1.39% 1,716.00 1.26% 510.00 1.65% 2,731.89 2.01% - 0.00% 105.00 0.08% 30,927.00 100.000/0 135,742.89 - 100.000/0 8,752.00 28.30% 35,008.00 25.79% 8,752.00 28.300/a 35,008.00. 25.79% Supplies Fees 0.00 0.00% 3,740.95 2000 -46330 office Supplies 132.29 Expert and Professional Services 0.43% 711.81 0.52% 2010 -46330 Minor Equipment 504.00 3060 -46330 1.63% 615.13 0.45% 2160 -46330 Maint. & Construct Materials 40.52 14.06% 0.13% 2,649.39 - 1.95% 2171 -46330 General Supplies 137.54 1,716.98 0.44% 332.17 0.24% 355.32 814.35 1.15% 2.63% 4,308.50 3.17% Total Supplies 0.00 0.00% 65.00 0.05% Other Services & Charges 3040 - 46330 -Legal Fees 0.00 0.00% 3,740.95 2.76% 3050 -46330 Expert and Professional Services 0.00 0.00% 0.00 0.00% 3060 -46330 Management Services 4,772.00 15.43% 19,088.00 14.06% 3100 -46330 Protective Services 598.15 1.93% 1,716.98 1.26% 3210 -46330 Telephone & Telegraph 355.32 1.15% 1,372.46 1.01% 3430 -46330 Advertising Other 0.00 0.00% 65.00 0.05% 3600 -46330 Insurance & Bonds 1,741.75 5.63% 6,967.00 5.13% 3810 -46330 Electric 3,857.54 12.47% 10,083.20 7.43% 3820 -46330 Water 1,928.07 6.23% 1,928.07 1.42% 5,166.73 16.71% 17,379.71 12.80% 3830 -46330 Gas 3840 -46330 Refuse 3,518.34 1138% 3,665.33 2.700/b 3850 -46330 Sewer 1,070.04 3.46% 1,070.04 0.79% 4000 -46330 Repair & Maint. Services 5,171.12 16.72°/% 20,297.82 14.95% 4100 -46330 Rents & Leases 105.00 0.34% 105.00 0.08% 4300 -46330 Miscellaneous Charges 0.00 0.00% 0.00 0.00% 4315 -46330 PILOT 2,027.15 6.55% 8,108.60 5.97% 4390 -46330 Taxes & Licenses 0.00 0.00% 1,243.38 0.92% 4500 -46330 Administrative Expenses 0.00 0.00% 1,023.51 0.75% 4850 -46330 Interest on Deposits 13.88 0.04% 56.04 0.04% Total Other Services & Charges 30,325.09 98.050/0 97,911.09 72.13% Capital Outlay 5120 -46330 Building & Improvements 1,402.50 0.00% 1,839.76 1.36% Total Capital Outlay 1,402.50 4.530/0 1,839.76 1.360/° Total Expense 41,293.94 133.52% 139,067.35 102.450/a Excess (Deficit) Revenue over Expense - 10,366.94 - 33.52% - 3,324.46 -2.450/° I Parkview Villa -North (165) Cash Flow Statement Period = April 2013 Book = Accrual Revenue 33160 Federal Grant 36220 Gen. Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Expenses Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies Other Services & Charges 3040 Legal Fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer - 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 4100 Rent & Leases 4300 Miscellaneous. Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services & Charges Total Expenses Excess (Deficit) Revenue over Expenses Month to Date 0.00 29,988.00 429.00 510.00 0.00 30,927.00 8,752.00 8,752.00 132.29 504.00 0.00 178.06 0.00 814.35 0.00 0.00 4,772.00 598.15 355.32 0.00 1,741.75 3,857.54 1,928.07 5,166.73 3,518.34 1,070.04 5,171.12 0.00 105.00 0.00 2,027.15 0.00 0.00 13.88 1,402.50 31,727.59 41,293.94 - 10,366.94 Parkview Villa -North (165) Cash Flow Statement Period = April 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flaw 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date - 207.00 0.00 68.00 5.00 0.00 0.00 3,749.90 1,741.75 13.88 2,027.15 - 201.50 7,197.18 (3,169.76) Cash End Cash Difference 26,571.68 23,401.92 (3,169.76) 871.00 871.00 - 891,214.11 891,214.11 - 918,656.79 915,487.03 (3,169.76) 5/13/2013 1:27 PM Page 1 of 2 Parkvlew Villa -North (165) General Ledger Period = Apr 2013 Book = Accrual; Tree = ysi_tb Property �° Date Period Person /Description Control Reference Debit Credit Balance Remarks 26,256.00 = Beginning Balance = 1000 - 46330 Accrued Salaries 165 4/3012013 04/2013 :PostRecurring Monthly recu rung en)- 161787 RC 8,752.00 0.00 35,008.00 RIC CHC PR Mgmt Fee 35,008.00 = Ending Balance = Net Change= 8,752.00 579.52 = Beginning Balance = 2000 -46330 4118/2013 04/2013 Office Supplies Common Bond Housing (chc) P- 330064 04/01/13- 04/18/: 3.96 0.00 583.48 123578 comp.supp mug 03/2: 165 165 4/30/2013 04/2013 CommgnBOnd Housing(chc) P- 331566 04/19/13 - 04/301: 128.33 0.00 711.81 132590 Comps upp 3/20 -4/2: 711.81 = Ending Balance = Net Change= 132.29 111.13 = Beginning Balance = 2010 -46330 Minor Equipment 165 4/17/2013 04/2013 All Inc. (all) P- 330097 s1308355001 504.00 0.00 615.13 elctric range 615.13 = Ending Balance = Net Change = 504.00 2160 -46330 Maint. & Construct. Materials 2,608.87 = Beginning Balance = 165 4 /1/2013 04/2013 Frattalone's /Metro Ace (frat) P- 326920 1429911- 326920 0.00 25.62 2,583.25 malnt supplies 165 4/1/2013 04/2013 Frattalone's /Metro Ace (brat) P- 326920 14299R- 326920 25.62 0.00 2,608.87 maint supplies 165 4/1/2013 04/2013 Frattalone'S /Metro Ace (frat) P- 326920 142998- 326920 0.00 25.62 2,503.25 malnt supplies 165 4/1/2013 04/2013 Frattalone's /Metro Ace (frat) P- 326921 01438511-326921 0100 13.66 2,569.59 mount supplies 165 4/1/2013 0412013 Frattalane's /Metro Ace (frat) P- 326921 014385R- 326921 13.66 0.00 2,583.25 maint supplies 165 411/2013 04/2013 Frattalone's /Metro Ace (frat) P- 326921 014385R- 326921 0.00 13.66 2,569.59 main supplies 165 4/11/2013 0412013 HD Supply Facilities Maintenance, LI P- 329289 9121624173 79.80 0.00 2,649.39 maint supplies 21649.39 = Ending Balance = Net Change =40.52 194.63 = Beginning Balance = 2171 -46330 General Supplies 165 4/4/2013 04/2013 HD Supply Facilities Maintenance, LI P- 328562 9121478845 137.54 0.00 332,17 janitorial supplies 332.17 = Ending Balance = Net Change =137.54 31740.95 = Beginning Balance = 3040 -46330 Legal Fees 3,740.95 = Ending Balance = Net Change =0.00 14,316.00 = Beginning Balance = 3060 -46330 Management Services 0100 27,840.00 133334 mgmt fees 4/13 165 4/30/2013 04/2013 Con-monBond Housing(chc) P- 331566 04/19/13-04130/: 13,524.00 165 4/30/2013 04/2013 :PostRecurring Monthly recurring en 1- 161787 RC 0.00 8,752.00 19,088.00 RIC CHC PR Mgmt Fee 19,088.00 = Ending Balance = Net Change= 4,772.00 11118.83 = Beginning Balance = 3100 -46330 Protective Services 165 3/29/2013 04/2013 Simplex Grinnell(simp) P- 328815 68800780 598.15 0100 1,716,98 security system repair 11716.98 = Ending Balance = Net Change= 598.15 3210 -46330 Telephone & Telegraph 1,017.14 = Beginning Balance = 165 3131/2013 0412013 Popp.com (Popp) P- 329099 992097582 221.91 0.00 1,239.05 tel sv. 4/1- 4/30/13 165 4/1/2013 04/2013 Level One (love) P- 327559 0309006IN 76.52 0.00 1,315.57 malnt plan /rll ovr pro numb 165 4/2/2013 04/2013 Comcast(comc3474) P-329093 87721050501961 56.89 0.00 1,372.46 Internet 4 /11- 5110/13 11372.46 = Ending Balance = Net Change= 355.32 3430 -46330 Advertising - Other 65.00 = Beginning Balance = 65.00 = Ending Balance = Net Change =0.00 5,225.25 = Beginning Balance = 3600 -46330 Insurance & Bonds 1,741.75 0.00 6,967.00 C of Columbia Heights Ins Ao 165 4/30/2013 04/2013 :PostRecurring Monthly recurring en )- 161787 RC 6,967.00 = Ending Balance = Net Change= 1,741.75 6,225.66 = Beginning Balance = 3810 -46330 4/11/2013 O4/2013 Electric Xcel Energy (xce1) P- 329504 5150441553 04/1 3,857.54 0.00 10,083.20, elec svc 03/06- 04106/2013 165 10,083.20 = Ending Balance = Net Change = 3,857.54 0.00 = Beginning Balance = 3820 -46330 Water 260.69 0.00 260.69 water 02 /20/2.012- 03/20/201 165 4/10/2013 04/2013 City of Columbia Heights (colu) P- 329202 31802450001 04, 4/10/2013 0412013 City of Columbia Heights (coin) P- 329203 31802500001 04, 1,640.53 0.00 1,901.22 water 12/20/2012- 03/20/201 165 165 4/10/2013 0412013 City of Columbia Heights (colu) P- 329204 31802550001 04, 26.85 0.00 1,928.07 water 12/20/2012- 03/20/201 - 1,928.07 = Ending Balance = Net Change= 1,928.07 Page 1 of 2 5/13/20131:27 PM 50,124.50 8,830.56 Page 2 of 2 Parkvlew Villa-Noah (165) General Ledger Period = Apr 2013 Book = Accrual; Tree = ysi_tb Property Date Period Person /Description Control Reference _Debit Credit Balance Remarks 12,212.98 = Beginning Balance = 3830 -46330 Gas 165 4/8/2013 04/2013 CenterPomt: Energy (cent) P- 329850 55199657 04/08/ 5,166.73 0.00 17,379.71 gas 3/5- 4/4/13 Net Change= 5,166.73 17,379.71 = Ending Balance = 3840 -46330 Refuse 146.99 = Beginning Balance = 165 4/10/2013 04/2013 City of Columbia Heights (cold) P-329202. 31802450001 041 3,518.34 0.00 3,665.33 trash 02/20/2012- 03/20/201: Net Change= 3,518.34 3,665.33 = Ending Balance = 0.00 = Beginning Balance = 3850 -46330 Sewer 165 4/10/2013 04/2013 City of Columbia Heights (colu) P- 329202 31802450001 041 248.68 0.00 248.68 sewer 02 /20/2012- 03/20/201 165 4/10/2013 04/2013 City of Columbia Heights (cold) P- 329203 31802500001 04, 821.36 0100 1,070.04 sewer 12/20/2012- 03/20/201 Net Change= 1,070.04 1,070.04 = Ending Balance = 4000 -46330 Repair & Malnt. Services 15,126.70 = Beginning Balance = 165 3/2812013 04/2013 LIMP Mechanical, Inc (Ibpm) P- 327521 W18415 1,387.80 0.00 16,514.50 Inspect apt 705 for mice 165 3/28/2013 04/2013 LBP Mechanical, Inc (Ibpm) P- 327522 WIB428 2,475.00 0100 18,989.50 eiev malnt cvrg 04/2013 165 4/1/2013 04/2013 Kane Inc.(kone) P- 329857 221149076 700.01 0.00 19,689.51 rewire /repair elevator llghtinc 165 4/4/2013 04/2013 Adam's Pest Control, Inc. Hmam) P- 329856 788986 75.23 0.00 19,764.74 HVAC repairs 165 4/10/2013 04/2013 SiUmann Constructed ribs SRaman P- 330124 579797 205.00 0.00 19,969.74 bailer sew 165 4/16/2013 04/2013 High Profile Grounds Maintenance, 1 P- 330123 26344 115.58 0.00 20,085.32 hvac repair 165 4/22/2013 04/2013 _BP Mechanical, Inc (hoped) P- 330639 W18485 212.50 0.00 20,297.82 snow rmvl 04/12 - 04/13/2013 Net Change= 5,171.12 20,297.82 = Ending Balance = 0.00 = Beginning Balance = 4100 -46330 Rents & Leases 165 1/31/2013 04/2013 Multihousing Credit Control (multi) P- 329730 13010357 105.00 0.00 105.00 tenant screening Net Change= 105.00 105.00 = Ending Balance = 6,081.45 = Beginning Balance = 4315 -46330 PILOT 165 4/3012013 04/2013 :PostRecurri ng Monthly recurring en J- 161787 RC 2,027.15 0.00 8,108.60 Anoka Cty Property Tax Accu Net Change = 2,027.15 8,108.60 = Ending Balance = 4390-46330 Taxes & Licenses 1,243.38 = Beginning Balance = Net Change =0.00 1,243.38 = Ending Balance = 4500 -46330 Adminstmtive Expenses 1,023.51 = Beginning Balance = Net Change =0.00 1,023.51 = Ending Balance = 4850 -46330 Interest on Deposits 42.16 = Beginning Balance = 165 4/30/2013 04/2013 Sec Dep interest accrual 3- 162301 GJI 13.88 0.00 56.04 Sec top interest accrual Net Change =13.88 56.04 = Ending Balance = 5120 -46330 Building & Improvements 437.26 = Beginning Balance = 165 3/18/2013 04/2013 WAI Continuum (wait) P- 328119 1502 1,402.50 0.00 1,839.76 architect Svcs through 3/17/1 Net Change= 1,402.50 11839.76 = Ending Balance = 50,124.50 8,830.56 Page 2 of 2 Parkview Villa North Bank Reconciliation Report 04/30/2013 5016456 Balance Per Bank Statement as of 04130/2013 Outstanding Checks Check date Check number 02/05/2013 2012 04/2312013 2074 Less: Outstanding Checks 23,998.32 Payee - Amount dire - Direct Home Appliance Services 480.82 high8236 - High Profile Grounds Maintenance, Inc. 115.58 Reconciled Bank Balance Balance per GL as of 04/30/2013 Reconciled Balance Per G/L 596.40 23,401.92 05/02/2013 23,401.92 23,401.92 Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) 0.00 Cleared Items : Cleared Checks j q Tran # Notes Amount Date Cleared Date 03/19/2013 2048 comc3474 - Comcast- 51.04 04/30/2013 2053 home7 - HD Supply Facilities Maintenance, Ltd. 358.14 04/30/2013 03/26/2013 2054 xcel - Xcel Energy 3,737.90 04/30/2013 03/26/2013 2055 adam - Adam's Pest Control, Ina 51.91 04/30/2013 04102/2013 2056 cent - CenterPoint Energy 5,691.18 04/3012013 04/02/2013 2057 chc - CommonBond Housing 12,920.25 04130/2013 04/0212013 2058 high8236 - High Profile Grounds Maintenance, Inc. 331.20 04/3012013 04/02/2013 home7 - HD Supply Facilities Maintenance, Ltd. 504.25 0413012013 04/0212013 2059 2060 kenn - Kennedy & Graven, Chartered 2,123.00 04/30/2013 04/0212013 2061 10009593 - Hembroff 229.32 - 04/3012013 04/0212013 2062 high8236 - High Profile Grounds Maintenance, Inc: 355.35 04130/2013 04/0912013 2063 home7 - HD Supply Facilities Maintenance, Ltd, 79.21 04/30/2013 04/09/2013 2064 Ibpm - LBP Mechanical, Inc 3,862.80 04/30/2013 04/09/2013 76.52 04/3012013 04/09/2013 2065 leve - Level One 26.85 04130/2013 04/16/2013 2066 colu - City of Columbia Heights 04/16/2013 2067 offi8804 - Office Depot 38.50 04/3012013 04/16/2013 2068 Popp - Popp.com 221.91 04130/2013 04/16/2013 2069 simp - Simplex Grinnell 598.15 04130/2013 04/1612013 2070 waic- WAI Continuum 1,402.50 04/30/2013 j q Cleared Checks Date Tran # 04/23/2013 2071 04/23/2013 2072 04/23/2013 2073 04/23/2013 2075 04/23/2013 2076 04/23/2013 2077 04123/2013 2078 0412312013 2079 Total Cleared Checks Cleared Deposits Date Tran # 04/03/2013 484 04105/2013 485 04/08/2013 486 .04/22/2013 487 Total Cleared Deposits 03/08/2013 - - JE 157965 03/08/2013 JE 160480 Parkview Villa North Bank Reconciliation Report 04/30/2013 5016456 Notes Amount adam - Adam's Pest Control, Inc. 75.23 chc - Common Bond Housing 3.96 comc3474 - Comcast 56.89 home7 - HD Supply Facilities Maintenance, Ltd. 336.15 kone - Kone Inc. 700.01 multi - Multihousing Credit Control 105.00 sitz - Sitzmann Construction dba Sitzmann Elect 205.00 xcel - Xcel Energy 3,857.54 Notes 03/08/2013 Payroll Rev PR billing error 37,999.76 05/02/2013 Date Cleared 04/30/2013 04/30/2013 04/30/2013 0413 0/2 01 3 04/30/2013 0413012013 04/30/2013 04/30/2013 Amount Date Cleared 21,887.50 04/30/2013 5,327.00 04/3012013 3,199.00 04/30/2013 385.00 04/30/2013 30,798.50 19.68 04/30/2013 -19.68 04130/2013 0 HRA OF COLUMBIA HEIGHTS PARKVIEW VILLA NORTH C/O COMMONBOND COMMUNITIES 328 KELLOGG BLVD WEST ST PAUL MN 55102 -1900 - - -- C H E C K I N G Date 4/30/13 Primary Account Enclosures A C C O U N T S - - -- Page 1 @XXXXX @6456 31 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 31,199.58 4 Deposits /Credits 30,798.50 27 Checks /Debits 37,999.76 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 23,998.32 Number of Images 31 Statement Dates 4/01/13 thru 4/30/13 Days in the Statement Period 30 Average Ledger 35,199 Average Collected 33,915 Deposits and Credits Amount Date Check# Date Description 2048 Amount 4/15 4/17 4/03 DDA REGULAR DEPOSIT 21,887.50 3,737.90 4/05 DDA REGULAR DEPOSIT 5,327.00 2055 4/08 DDA REGULAR DEPOSIT 3,199.00 4/17 4/22 DDA REGULAR DEPOSIT 385.00 221.91 Checks Date in serial order Check# Amount Date Check# Amount 4/01 2048 51.04 358.14 4/15 4/17 2063 2064 79.21 3,862.80 4/02 4/01 2053* 2054 3,737.90 4/15 2065 76.52 4/05 2055 51.91 4/24 2066 26.85 38.50 4/17 2056 5,691.18 4/23 2067 221.91 4/05 2057 12,920.25 4/19 2068 598.15 4/09 2058 331.20 504.25 4/23 4/23 2069 2070 1,402.50 4/10 4/05 2059 2060 2,123.00 4/29 2071 75.23 4/08 2061 229.32 4/30 2072 3.96 56.89 4/12 2062 355.35 4/30 2073 * Indicates skip in check numbers 9 Date 4/30/13 Page 2 Primary Account @XXXXX @6456 Enclosures 31 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) .tip Checks in Date serial order Check# Amount Date Check# Amount 4/30 2075* 336.15 4/30 2078 205.00 4/29 2076 700.01 4/30 2079 3,857.54 4/26 2077 1.05.00 * Indicates skip in check numbers Daily Balance Section Date Balance Date Balance Date Balance 4/01 27,410.64 4/10 41,306.07 4/23 29,364.95 4/02 27,052.50 4/12 40,950.72 4/24 29,338.10 4/03 48,940.00 4/15 40,794.99 4/26 29,233.10 4/05 39,171.84 4/17 31,241.01 4/29 28,457.86 4/08 42,141.52 4/19 31,019.10 4/30 23,998.32 4/09 41,810.32 4/22 31,404.10 * ** E N D O F S T A T E M E N T iI Payment Summary Bank= 165opr AND mm /yy= 04/2013- 04/2013 AND All Checks =Yes AND Include Voids =All Checks FEWA Check Post Total Bank Check# Vendor Date Month Amount 165opr - Parkview Villa North 2055 adam - Adam's Pest Control, Inc. 04/02/2013 04/2013 51.91 165opr - Parkview Villa North 2056 cent - CenterPoint Energy 04/02/2013 04/2013 5,691.18 165opr - Parkview Villa North 2057 chc - CommonBond Housing 04/02/2013 04/2013 12,920.25 1650pr - Parkvlew Villa North 2058 high8236 High Profile Grounds Maintenance, Ir 04/02/2013 04/2013 331.20 165opr - Parkview Villa North 2059 home? - HD Supply Facilities Maintenance, Ltd. 04/02/2013 04/2013 504.25 1650pr - Parkview Villa North 2060 kern - Kennedy & Graven, Chartered 04/02/2013 04/2013 2,123.00 165opr - Parkview Villa North 2061 1:0009593 - Hembroff 04/02/2013 04/2013 229.32 165opr - Parkview Villa North 2062 high8236 - High Profile Grounds Maintenance, Ir 04/09/2013 04/2013 355.35 165opr - Parkview Villa North 2063 home? - HD Supply Facilities Maintenance, Ltd. 04/09/2013 04/2013 79.21 165opr - Parkview Villa North 2064 Ibpm - LBP Mechanical, Inc 04/09/2013 04/2013 3,862.80 165opr - Parkview Villa North 2065 leve - Level One 04/09/2013 04/2013 76.52 165opr - Parkview Villa North 2066 colu - City of Columbia Heights 04/16/2013 04/2013 26.85 165opr - Parkview Villa North 2067 offi8804 - Office Depot 04/16/2013 04/2013 38.50 165opr - Parkview Villa North 2068 popp - Popp.com 04/16/2013 04/2013 221.91 165opr - Parkview Villa North 2069 simp - Simplex Grinnell 04/16/2013 04/2013 598.15 165opr - Parkview Villa North 2070 wait - WAI Continuum 04/16/2013 04/2013 1,402.50 165opr - Parkview Villa North 2071 adam - Adam's Pest Control, Inc. 04/23/2013 04/2013 75.23 165opr Parkview Villa North 2072 chc - CommonBond Housing 04/23/2013 04/2013 3.96 165opr - Parkvlew Villa North 2073 comc3474 - Comcast 04/23/2013 04/2013 56.89 165opr - Parkview Villa North 2074 high8236 - High Profile Grounds Maintenance, Ir 04/23/2013 04/2013 115.58 165opr - Parkvlew Villa North 2075 home7 - HD Supply Facilities Maintenance, Ltd. 04/23/2013 04/2013 336.15 165opr - Parkvlew Villa North 2076 kone - Kone Inc. 04/23/2013 04/2013 700.01 165opr - Parkvlew Villa North 2077 multi - Multihousing Credit Control 04/23/2013 04/2013 105.00 165opr - Parkvlew Villa North 2078 sitz - Sitzmann Construction dba Sitzmann Elect 04/23/2013 04/2013 205.00 165opr - Parkview Villa North 2079 xcel - Xcel Energy 04/23/2013 04/2013 3,857.54 33,968.26 FEWA Parkview Villa South Financial Statement Overview April 2013 Revenue: Occupancy for the month of April was 80% occupied Total Revenue was lower than budget amount (unfavorable) this is due to vacancy Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were over budget (unfavorable) and reflect the cost of background screenings for applicants Office Supplies was under budget (favorable) Legal Expenses were under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Utilities: Utilities Expenses were slightly over budget (unfavorable); however, this reflects a quarterly billing Electric was under budget (favorable) Gas was under budget (favorable) Water was over budget (unfavorable) and reflects a quarterly billing Sewer was over budget (unfavorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Heating and Cooling Maint and Repairs was under budget (favorable) Snow Removal was over budget (unfavorable) and reflects invoices from February and March Decorating Contract was slightly over budget (unfavorable) and reflects the cost of painting a unit Misc Operating Expenses was under budget (favorable) �O N O .o C a U) p ry V/) N¢ 2 7 m Q a mam° 00 O O OO 00 O O N W Oi tN IA N M M M (V Z q d d m O M N N M O M f0 fD vi o of m m m m (m n V z Z v N N 0 I�? I�? W O OJ (yyD f0 r V H N N N N (mo n o 0 N N IN M ml WIM O °m m O O $ Y Fd F n uS c C' a K O r O Oo y Z u N d O (NO OID °O CM} Em O m O O O^^ m ° .0 O r O O] O m N M m m o O acs ry 0 0 0 o z ° O O v� °O °Om Lq ry 0w y m 0_ 0 N N Nr- V N O N O r N m 6 o 0 O(oqfp o 6 E U W m N N O N O O 00 O o O O o G v j O O OM O N z0 O O O O N O O O O O N O 16- N r N (I ° V (V Owl O N O M O M N M O N OON 00 (O OOM O V (O o(ri (+i ror (o N r N O O O O N O N O O O M O OOmOOo 00(n Oa o oo(o or o Dorn No o N ` o r O O N O (O L() (p O 4 O N m O N r O N M O W (O r �OmiN� Cl OOOOVo O O O O N O O O ONO O m m m M � � w N 0 p C p C K c m UC N N N N N N N N O Q N W IL V Em m c rnA ��,Cg W-6 > 0w y m 0_ 0 m 6 o 6 E U W m N N O N C 0 N v j w N N z RLLU C O w z0 Qm ONjUU0 m v L C > 0 w N U um O O N N N N N N N N O Q N W IL V N �rn n. Win o no O o m 00.08 OO 000 o.0oo O O OO 00 Oms 00`¢ X0000 O O N 0000 Oo non °0°00 N OON w N O (sD/ 0000 00 OOIU m,6 000 lU 00 O CaC. ;wON]O m d V wO O N (0p W O(O O O(`m m -N Iqr W (DO O o Q w (V N w N M M d N M m w ""m d N m_ N N Iffll IL rnOOw M m W Olm( Mlh Mm -MM Yl NN MOONw O yyO N NI Ow N- OO m d m W w U?dm I M O6 -'t N Nr; an d rn rn G O O N O O M o O N e ` N I n- N O l m rn r O O N m '- ` p� NNNO r M O mMd'hfp mN O M N.-d r (O w rnmdOd N (O d N M w W m N l0 M V U M M M d M d V rn w OD r V M I�mwli d M tDN�() M I�Oih Nw m OiO61m mw w ^ N i n M w N w N vIN 'No N O OJ o0000 NN mom Om d W m O m m(O m lO m O (O O O OM") ( MO M O f0 00000 cq M m Om (O O m O NIMMMM m N O N w 0 0 0 0 O O m m 0 (O M M M M m O w O m N o r m h d u1 m M Om O O M O r w m w N O w O W M N w o h w M w m w O (Q r (V N d N M m i O no. N m w w r w M V d O w m d o O m C O O N d O O O o M O N N N O O�p(p N rn I�O OtYA °,p `� M O dm 47 V w wmw O O r m r O m m Q N w CN'l_O N 1 o O O M O N rn d r V' w o non O (p O .-00 m m O O Cl m O O ¢ O O r w ;ern N m O d w o N (O N O w V w O N O w O Z O (O N d O m d O w w M m M N O O O O] O m o o m w O O a? r 0 O C r N O Own m1 O N n ""(Df r. dM M rNN W. - V N drnh O d O w N O] Nh 0] 10 O O fJ�Or m W C muirai r O O d M w Mwwm01 (p N M (ddw O Or V r w O _ o �o c a M po-22y N 2 N 0: VI 1 � O Y 2. m d 6l M M M N m O o O O O O M m r O N m N � N O h O m M O r O N O O O O O M M w O IT h d rn I O w O w M h m 0.000 M M w O N m O r M h O w O O O O N h OI m m F m! m � M d N O w w �- O w O � N m M N d w M O r d h O O O d M O M r M A m O O w O d O O m O O NO O O w o w O O sY rn d' w w r O own r O O w w O m O O N (O O O (O M w N O O N O f0 O O r d' O O O O w w r w O (O M N w OM N rn V In 'm U. Uo� ���c �LU wh@ iy m M M o. c w n.. _A oZym Mo m (N K m= .5 UwU )m Eo �WO m w Da M � om rn -.6 E N x m �mw° :au Po o n>o io0 os$ °o °=p v w m c c MC v �¢I-v co a� -w�i0 w� (p er- ��w�U'ipw 0 Un a' W U `x�w a�w D F c o M c 5 O'' p o aEi m "m 'm n U 0 0 0 0 r O h d w y O N me} fpm w r moo w m r N� N (O m W o wwww (MO w w (O �(O (d0N�10 10 fw0w 'MM 00�20 m Ow m ww W w w w w w mmmm m n. 0 i$ M R n E^ w O ry - ffi my n o a [O IT °o °o °o, O O °o °o, O IN] 0 O G o0o aO N N N N V M N D .- 10 cl; N M °onrn r m No q i Booty 6 N • C O N a Mh O M V OI OM miO M N f0 M 9I O O m (M lh O CI 'ZI m N N M M N V a ONO N N 4 O d' m N r J O W (NO l`Ni G V V rQQ r N %YI �OOO O a v 6 6 o O INO 000 o O lV O O N IM e Iv IV M MMpp [MNy (NO O N r M M Mc� c0 M M N O O M N flfpNp M M O M lh M d V O N N m of N W O W N M N W N O a m� N N ool o 0 0 00 u? P O O 00 00 00 M M(�� M M W M M M M M ni M M M O O O O 00 og 00 O O OOc1 d' W .r- r O O N r M M N O m M M V �1 p a O V' N Cli N mm a v c N OOM OJ W (r0 r M M r MM O O M M Cl On Oj p0' of M ONJ W� N O1 OOOM OO (00O {(q 0 NN lNY V O S 0 0 N N o 0 O W M N 00 n 0 d m � y S NC N In � 6 9—'J � U � fyQ! CIS .pC �mC Q O y�j 01 m In _N • J 10 `q H O J 06C� U C� N N CUC,� � N x � J• U' !gym E1 Ham. $ N�� v• -� � N L N CC � S N J N C Ol 0 ,�L C o ai S$$g$pgqq C C X A g L �NN ouJ.�d�o O a .g In a r �. 2 Nbm mr g �' �� a r� �a o cNO aNO tNC cNO aNO IS i�c m o n n a N IL ■ \( !) E � \ m* ! w 0 CL . G§ e _ k � $ � { 2\ § \ \ ( ,, | . < E' \ ) ! ) 2 |) } ) \/ \� c � , \ ;) kiZE )! : \ /,� Parkview Villa South (166) Balance April 2013 Books = Accrual Apr -13 Assets 10100 Cash Balance 77,636.08 10,599.70 10200 Petty Cash 279.00 7,787.61 10400 Investments - 729,970.36 10.00 11300 Rent Receivable 1,650.93 11500 Accounts Receivable 76.63 771,391.64 Total Assets 809,613.00 Liabilities 20200 Accounts Payable 10,599.70 20210 Accrued Other Expenses 3,365.00 22000 Deposits 7,787.61 22200 Accrued PILOT 16,459.05 22210 Revenue Collected in Advance 10.00 Total Liabilities 38,221.36 Fund Balance 25300 Fund Balance 771,391.64 Total Fund Balance 771,391.64 Total Liabilities and Fund Balance 809,613.00 a Parkview, Villa -South (166) 0.39% 135.32 0.15% 0.00 Income Statement 49.93 0.05% 35.85 0.15% For The Period Ending April 2013 0.99% 61.79 0.26% 149.24 Books = Accrual 187.88 0.81% 1,238.88 1.35% 52.50 Month to Date % Year to Date 0.00 Revenue 0.00 0,00% 2,126.00 9.12% 36220 -46340 Gen. Government Rents 22,635.13 97.06% 88,330.13 96.48% 36225 -46340 Nondwelling Rents 462.00 1.98% 1,848.00 2.02% 36290 -46340 Other Miscellaneous Revenue 224.00 0.96% 1,372.70 1.50% 39120 -46340 Recovery Damage City - 0.00% ,. - 0.00% Total Revenue 23,321.13 100.000/0 91,550.83 100.000/0 Expenses 1,573.64 6.75% 7,414.56 8.10% Personal Services 0.00% 66.04 0.07% 468.63 1000 -46340 Accrued Salaries 3,932.00 16.86% 15,728.00 17.18% Total Personal Services 3,932.00 16.86% 15,728.00 17.18% Supplies 2000 -46340 Office Supplies 2010 -46340 Minor Equipment 2160 -46340 Maint. & Construct Materials 2171 -46340 General Supplies Total Supplies Other Services & Charges 3040 -46340 Legal Fees 3050 -46340 Expert & Professional Services 3060 -46340 Management Services 3100 -46340 Protective Services 3210 -46340 Telephone & Telegraph 3430 -46340 Advertising Other 3600 -46340 Insurance & Bonds 3810 -46340 Electric 3820 -46340 Water 3830 -46340 Gas 3840 -46340 Refuse 3850 -46340 Sewer 4000 -46340 Repair & Maint. Services 4100 -46340 Rents & Leases 4300 -46340 Miscellaneous Charges 4315 -46390 PILOT 4390 -46340 Taxes & Licenses 4500 -46340 Administrative Expenses 4850 -46340 Interest on Deposits Total Other Services & Charges 90.24 0.39% 135.32 0.15% 0.00 0.00% 49.93 0.05% 35.85 0.15% 904.39 0.99% 61.79 0.26% 149.24 0.16% 187.88 0.81% 1,238.88 1.35% 52.50 0.23% 52.50 0.06% 0.00 0.00% 0.00 0,00% 2,126.00 9.12% 8,504.00 9.29% 268.74 1.15% 771.41 0.84% 159.64 0.68% 616.60 0,67% 0.00 0.00% 160.28 0.18% 841.25 3.61% 3,365.00 3.68% 1,500.93 6.44% 7,767.78 8.48% 966.47 4.14% 100.87 0.11% 1,573.64 6.75% 7,414.56 8.10% 0.00 0.00% 66.04 0.07% 468.63 2.01% 444.63 0.49% 1,354.00 5.81% 8,396.50 9.17% 90.00 0.39% 170.00 0.19% 0.00 0.00% 181.59 0.20% 1,028.69 4.41% 4,114.76 4.49% 0.00 0.00% 558.62 0.61% 0.00 0.00% 229.43 0.25% 6.03 0.03% 23.95 0.03% 10,436.52 44.75% 42,938.52 46.90% 2.(0 Capital Outlay 5120 -46340 Building & Improvements Total Capital Outlay Total Expense 0.00% 0.00 0.00% 0.00% 0.000 /a 14,556.40 62.42% 59,905.40 65.43% Excess (Deficit) Revenue over Expense 8,764.73 37.58% 31,645.43 34.57% m l Parkview Villa South (166) Cash Flow Statement Period = April 2013 Month to Date Revenue 36220 Gen. Government Rents 22,635.13 36225 Nondwelling Rents 462.00 36290 Other Miscellaneous Revenue 224.00 39120 Recovery Damage City Property 0.00 Total Revenue 23,321.13 Personnel Services 1000 Accrued Salaries 3,932.00 Total Personnel Services 31932.00 Supplies 2000 Office Supplies 90.24 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 0.00 2171 General Supplies 97.64 2175 Food Supplies 0.00 Total Supplies 187.88 Other Services & Charges 3090 Legal Fees 52.50 3060 Management Services 2,126.00 3100 Protective Services 268.74 3210 Telephone & Telegraph 159.64 3430 Advertising Other 0.00 3600 Insurance & Bonds 841.25 3810 Electric 1,500.93 3820 Water 966.47 3830 Gas 1,573.64 3840 Refuse 0.00 3850 Sewer 468.63 4000 Repair & Maint. Services 1,354.00 4050 Garage, Labor Burd. 0.00 4100 Rents & Leases 90.00 4300 Miscellaneous Charges 0.00 4315 PILOT 1,028.69 4390 Taxes & Licenses 0.00 4500 Administrative Expenses 0.00 4850 Interest on Deposits 6.03 Total Other Services & Charges 10,436.52 Total Expenses 14,556.40 M Parkview Villa South (166) Cash Flow Statement Period = April 2013 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 8,764.73 (93.00) 0.00 (618.00) (76.63) 0.00 1,314.89 841.25 206.03 1,028.69 (35.00) 2,568.23 11,332.96 Beg Cash End Cash Difference 66,303.12 77,636.08 11,332.96 279.00 279.00 729,970.36 729,970.36 - 796,552.48 807,885.44 11,332.96 N 5/13/20131:31 PM Parkview Villa South (166) General Ledger Period = Apr 2013 Book = Accrual; Tree = ysi tb Property Date Period Person /Description Control Reference Debit cretlit Balance Remarks 1000 - 46340 Accruetl Salaries 11,796.00 = Beginning Balance = 166 4/30/2013 04/2013 :Post Recurring Recurring 3- 161788 RC 3,932.00 0.00 15,728.00 R/C CHC PR Mgmt Fee Net Change= 3,932.00 15,728.00 = Ending Balance = 2000 -46340 Office Supplies _ 45.08 = Beginning Balance = 166 3/31/2013 04/2013 City of Columbia Heights (cclu) P- 327857 3912 90.24 0.00 135.32 copier allocation Net Change =90.24 135.32 = Ending Balance = 2010 -46340 Minor Equipment 49.93 = Beginning Balance = Net Change =0.00 49.93 = Ending Balance = 2160 -46340 Maint. & Construct Materials 868.54 = Beginning Balance = 166 4/11/2013 04/2013 HD Supply Faculties Maintenance, It P- 329289 9121624173 35.85 0.00 904.39 maint supplies Net Chance =35.85 904.39 = Ending Balance = 2171 -46340 General Supplies 87.45 = Beginning Balance = 166 41412013 04/2013 HD Supply Facilities Maintenance, Lt P- 328562 9121478845 61.79 0.00 149.24 janitorial supplies Net Change =61.79 149.24 = Ending Balance = 3040 -46390 Legal Fees 0.00 = Beginning Balance = 166 3/31/2013 04/2013 Kennedy & Graven, Chartered (kenr P- 330562 113514 52.50 0.00 52.50 legal Own 2/28/13 Net Change =52.50 52.50 = Ending Balance = 3060 -46340 Management Services 6,378.00 = Beginning Balance = 166 4/30/2013 04/2013 Commoneond Housing (chc) P -331572 04/19/13- 04/30/13 6,058.00 0.00 12,436.00 133335 mgmt fees 4/13 166 4/30/2013 04/2013 :Post Recurring Recurring 3- 161788 RC 0.00 3,932.00 8,504.00 RIC CHC PR Mgmt Fee Net Chang.= 2,126.00 8,504.00 = Ending Balance = 3100 -46340 Protective Services 502.67 = Beginning Balance = 166 3/29/2013 04/2013 Simplex Grinnell (slmp) P- 328815 68800780 268.74 0.00 771.41 security system repair Net Change = 268.74 771.41 = Ending Balance = 3210 -46340 Telephone & Telegraph 456.96 = Beginning Balance = 166 3131/2013 04/2013 Popp.com (Popp) P- 329099 992097582 99.70 0.00 556.66 tel svcs 4/1- 4/30/13 166 411/2013 0412013 Level One (love) P- 327559 0309006IN 34.38 0.00 591.04 maint plan /ri ovr phn numb 411 166 4/2/2013 04/2013 Comcast(comc3474) P- 329093 877210505019618: 25.56 0100 616.60 Internet 4/11 - 5/10/13 Net Change= 159.64 616.60 = Ending Balance = 3430 -46340 Advertising Other 160.28 = Beginning Balance = Net Change =0.00 160.28 = Ending Balance = 3600 -46340 Insurance & Bonds 2,523.75 = Beginning Balance = 166 4/30/2013 04/2013 :PostRecurring Recurring 3-161788 RC 841.25 0100 3,365.00 C of Columbia Heights Ins Accrl Net Change= 841.25 3,365.00 = Ending Balance = 3810 -46340 Electric 6,266.85 = Beginning Balance = 166 4/11/2013 04/2013 %cei Energy (xcel) P- 329504 5150441553 04/11, 1,500.93 0.00 7,767.78 elec svc 03/06 - 04/06/2013 Net Change= 1,500.93 71767.78 = Ending Balance = 3820 -46340 Water - 865.60 = Beginning Balance = 166 4/10/2013 04/2013 City of Columbia Heights (colu) P- 329201 31802700001 04/1 26.85 0.00 - 838.75 water 12/20/12-03/20/13 166 4/1012013 04/2013 City of Columbia Heights (tole) P- 329205 31802650001 04/1 914.45 0.00 75.70 water 12/27/2012- 03/28/2013 166 4/10/2013 04/2013 City of Columbia Heights (colu) P- 329301 3180260000104/1 25.17 0.00 100.87 water 12/20/12- 3/20113 Net Change= 966.47 100.87 = Ending Balance = 3830 -46340 Gas 5,840.92 = Beginning Balance = 166 4/9/2013 04/2013 Center Point Energy (cent) P- 329592 55271324 04109/1: 1,573.64 0.00 7,414.56 gas 3/6- 4/5/13 Net Change= 1,573.64 7,414.56 = Ending Balance = 3840 -46340 Refuse 66.04 = Beginning Balance = Net Change =0.00 66.04 = Ending Balance = 3850 -46340 Sewer -24.00 = Beginning Balance = 166 4/10/2013 04/2013 City of Columbia Heights (cola) P- 329205 3180265000104/1 468.63 0.00 444.63 sewer 12/27/2012- 03/28/2013 Page 1 of 2 � 6 Parkview Villa South (166) General Ledger Period = Apr 2013 mk = Accrual: Tree = vsi Net Change = 468.63 4000 -46340 Repair & Paint. Services 166 2/20/2013 O4/2013 Twin City Garage Door Co. (twin) P- 330125 387240 166 4/1/2013 04/2013 cone Inc. (pone) P- 329857 221149076 166 4/16/2013 04/2013 High Profile Grounds Maintenance,( P- 330123 26344 166 4/8/2013 0412013 K.O. Cleaning and Restoration LLC ( P- 329781 1389 Net Change = 1,354.00 4100 -46340 Rents & Leases 166 3/31/2013 04/2013 Multihousing Credit Control(multl) P- 329114 13030365 Net Change =90.00 4300 -46340 Miscellaneous Charges Net Change =0.00 4315 -46340 PILOT 166 4/30/2013 0412013 :POStRecurring Recurring 3- 161788 RC Net Change= 1,028.69 4390 -46340 Taxes & Licenses Net Change =0.00 4500 -46340 Administrative Expenses Net Change=0.00 4850 -46340 Interest on Deposits 166 4/30/2013 04/2013 Sec Dep interest accrual 3- 162303 G31 Net Change =6.03 5/13/20131:31 PM 18,488.40 3,932.00 Page 2 of 2 6' I 444.63 = Ending Balance in 7,042.50 = Beginning Balance = 187.58 0.00 7,230.08 unspeci0ed repairs 314.50 0.00 7,544.58 elev paint cvrg 0412013 51.92 0.00 7,596.50 snow rmv104 /12- 04/13/2013 800.00 0100 8,396.50 paint unit 211 8,396.50 = Ending Balance = 80.00 = Beginning Balance = 90.00 0100 170.00 bkgrnd chk 3/1- 3/28/13 170.00 = Ending Balance = 181.59 = Beginning Balance = 181.59 = Ending Balance = 3,086.07 = Beginning Balance = 1,028.69 0.00 4,114.76 Anoka Cty Property Tax Accrual 4,114.76 = Ending Balance = 558.62 = Beginning Balance = 558.62 = Ending Balance = 229.43 = Beginning Balance = 229.43 = Ending Balance = 17.92 = Beginning Balance = 6.03 0.00 23.95 Sec Died interest accrual 23.95 = Ending Balance = 18,488.40 3,932.00 Page 2 of 2 6' I Parkview Villa South Bank Reconciliation Report 04/30/2013 5016464 Balance Per Bank Statement as of 04/3012013 Outstanding Checks Check date Check number 04/23/2013 1742 Less: Outstanding Checks Payee high8236 - High Profile Grounds Maintenance, Inc. Reconciled Bank Balance Balance per GL as of 04/30/2013 Reconciled Balance Per G/L Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) Cleared Items : Cleared,Checks 05/02/2013 77,688.00 Amount 51.92 51.92 77,636.08 77,636.08 77,636.08 0.00 Date Tran # Notes Amount Date Cleared 03/19/2013 1719 comc3474 - Comcast 22.93 ^ 04/30/2013 03126/2013 1725 home? - HD Supply Facilities Maintenance, Ltd. 160.91 04/30/2013 03/26/2013 - 1726 xcel - Xcel Energy 1,679.34 04/3012013 04/02/2013 1727 adam - Adam's Pest Control, Inc. 23.32 04/30/2013 04/0212013 1728 cent - CenterPoint Energy 1,976.33 04/30/2013 04/02/2013 1729 chc - CommonBond Housing 5,764.00 04/3012013 0410212013 1730 high8236 - High Profile Grounds Maintenance, Inc. 148.80 04/30/2013 04/02/2013 1731 home? - HD Supply Facilities Maintenance, Ltd. 226.56 04130/2013 04/02/2013 1732 kocl - K.O. Cleaning and Restoration LLC 480.00 04/3012013 04109/2013 1733 colu - City of Columbia Heights 90.24 04/3012013 04/09/2013 1734 high8236 - High Profile Grounds Maintenance, Inc. 159.65 04130/2013 04/0912013 1735 home? - HD Supply Facilities Maintenance, Ltd. 35.59 04/3012013 0410912013 1736 leve - Level One 34.38 04/30/2013 04/1612013 1737 multi - Multihousing Credit Control 90.00 04/30/2013 0411612013 1738 offi8804 - Office Depot 17.29 04/30/2013 04/16/2013 1739 Popp - Popp.com 99.70 04/30/2013 04/1612013 1740 simp - Simplex Grinnell 268.74 04/30/2013 04/23/2013 1741 comc3474 - Comcast 25.56 04/30/2013 04/23/2013 1743 home7 - HD Supply Facilities Maintenance, Ltd. 151.03 04/30/2013 04/2312013 1744 kone - Kone Inc. 314.50 04/3012013 M Cleared Checks Date Tran # 04/2312013 1745 Total Cleared Checks' Cleared Deposits Date Tran # 04/03/2013 369 04/03/2013 369 0410512013 372 04/08/2013 373 04/22/2013 374 04/2212013 376 Total Cleared Deposits Cleared Other Items Date Tran # - 04/08/2013 RC 926427 0411112013 RC 929022 Total Cleared Other Items Parkview Villa South Bank Reconciliation Report 04/30/2013 5016464 Notes xcel - Xcel Energy 05/02/2013 Amount Date Cleared 1,500.93 04/30/2013 13,269.80 Notes Amount Date Cleared 18,926.00 04/30/2013 653.00 04/30/2013 1,854.00 04/30/2013 647.00 04/30/2013 1,267.00 04/30/2013 711.50 04/30/2013 24,058.50 Notes Amount Date Cleared Returned item t0010630 - 620.00 04130/2013 Returned item 10011178 - 647.00 04130/2013 - 1,267.00 33 Date 4/30/13 Page 1 Primary Account @XXXXX @6464 Enclosures 25 BRA 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 25 Account Number @XXXXX @6464 Statement Dates 4/01/13 thru 4/30/13 Previous Balance 68,166.30 Days in the Statement Period 30 4 Deposits /Credits 24,058.50 Average Ledger 79,178 23 Checks /Debits 14,536.80 Average Collected 78,276 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 77,688.00 Deposits and Credits Date Description Date Amount Amount 4/03 DDA REGULAR DEPOSIT 19,579.00 4/01 4/05 DDA REGULAR DEPOSIT 1,854.00 1728 4/08 DDA REGULAR DEPOSIT 647.00 4/22 DDA REGULAR DEPOSIT 1,978.50 1726 Charges and Debits Date Description 4/08 RETURN ITEM DEBIT 4/11 RETURN ITEM DEBIT Amount 620.00 647.00 Checks in serial order Date Check# Amount Date Check# Amount 4/01 1719 22.93 4/10 1728 1,976.33 4/02 1725* 160.91 4/05 1729 5,764.00 4/01 1726 1,679.34 4/09 1730 148.80 4/05 1727 23.32 4/10 1731 226.56 * Indicates skip in check numbers E Date 4/30/13 Page 2 Primary Account @XXXXX @6464 Enclosures 25 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Checks in serial order Date Check# Amount Date Check# Amount 4/22 1732 480.00 4/19 1739 99.70 4/26 1733 90.24 4/23 1740 268.74 4/12 1734 159.65 4/30 1741 25.56 4/15 1735 35.59 4/30 1743* 151.03 4/15 1736 34.38 4/29 1744 314.50 4/19 1737 90.00 4/30 1745 1,500.93 4/23 1738 17.29 * Indicates skip in check numbers *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Daily Balance Section Date Balance Date Balance Date Balance 4/01 66,464.03 4/10 79,624.11 4/23 79,770.26 4/02 66,303.12 4/11 78,977.11 4/26 79,680.02 4/03 85,882.12 4/12 78,817.46 4/29 79,365.52 4/05 81,948.80 4/15 78,747.49 4/30 77,688.00 4/08 81,975.80 4/19 78,557.79 4/09 81,827.00 4/22 80,056.29 * ** E N D O F S T A T E M E N T Payment Summary Bank= 166opr AND mm /yy= 04/2013-04/2013 AND All Checks =Yes AND Include Voids =All Checks 0 Check Post Total Bank Check# Vendor Date Month Amount 166opr - Parkview Villa South 1727 adam - Adam's Pest Control, Inc. 04/02/2013 04/2013 23.32 166opr - Parkview Villa South 1728 cent - CenterPoint Energy 04/02/2013 04/2013 1,976.33 166opr - Parkview Villa South 1729 chc - CommonBond Housing 04/02/2013 04/2013 5,764.00 166opr - Parkview Villa South 1730 high8236 - High Profile Grounds Maintenance, Ir 04/02/2013 04/2013 148.80 166opr - Parkview Villa South 1731 home7 - HD Supply Facilities Maintenance, Ltd. 04/02/2013 04/2013 226.56 166opr - Parkview Villa South 1732 kocl - K.O. Cleaning and Restoration LLC 04/02/2013 04/2013 480.00 166opr - Parkview Villa South 1733 colu - City of Columbia Heights 04/09/2013 04/2013 90.24 166opr - Parkview Villa South 1734 high8236 - High Profile Grounds Maintenance, Ir 04/09/2013 04/2013 159.65 166opr - Parkview Villa South 1735 home7 - HD Supply Facilities Maintenance, Ltd. 04/09/2013 04/2013 35.59 166opr - Parkview Villa South 1736 leve - Level One 04/09/2013 04/2013 34.38 166opr - Parkview Villa South 1737 multl - Multihousing Credit Control 04/16/2013 04/2013 90.00 166opr - Parkview Villa South 1738 offi8804 - Office Depot 04/16/2013 04/2013 17.29 166opr - Parkview Villa South 1739 Popp - Popp.com 04/16/2013 04/2013 99.70 166opr - Parkview Villa South 1740 simp - Simplex Grinnell 04/16/2013 04/2013 268.74 166opr - Parkview Villa South 1741 comc3474 - Comcast 04/23/2013 04/2013 25.56 166opr - Parkview Villa South 1742 high8236 - High Profile Grounds Maintenance, Ir 04/23/2013 04/2013 51.92 166opr - Parkview Villa South 1743 home7 - HD Supply Facilities Maintenance, Ltd. 04/23/2013 04/2013 151.03 166opr - Parkview Villa South 1744 kone - Kone Inc. 04/23/2013 04/2013 314.50 166opr - Parkview Villa South 1745 xcel - Xcel Energy 04/23/2013 04/2013 _... 1,500.93 ..�......».. _m....... - __ 11,458.54 0 Parlcview Villa North Financial Statement Overview May 2013 Revenue: Occupancy for the month of May 2013 was 100 % occupied; Rent Revenue was over budget (favorable) for May Total Revenue for May was under budget (unfavorable), however, we did not draw down any of the operating grant in May Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget (favorable) Computer Equipment, Supplies and Maintenance was under budget (favorable) Legal Services was under budget (favorable) Misc. Admin Expenses was over budget (unfavorable) and reflects payment of mileage and an accounting error. The error will be corrected on the June financials. Utilities: Utilities Expenses were under budget (favorable) Electric was under budget (favorable) and reflects quarterly billing Gas was under budget (favorable) and reflects quarterly billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was under budget (favorable) Garbage and Trash was over budget (unfavorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is under budget (favorable) Heating, Cooling Maintenance and Repairs is over budget (unfavorable) and reflects the cost of Boiler motor and switch replacement Snow Removal Contract was over budget (unfavorable) and reflects final snow removal in April Furniture and Fixtures was under budget (favorable) N m m m m m m m m O l O) N N N N N N f T N 0 N O O O N � W+J (Ni ADO O pO eWepp t�tpp� � � mO �P � V OON � O o A +000 o N S (O ODO m J o+ ry 0 a m m o m m 0 m ate. N C N ry O< N m a m X m � 3 c N O N N � N A w N OOJi NNOO O ONO 0 0 A m Owi NN N N-N N O N MP O W O m O O N O W O J O o O o N W o N O V N O W ONO 0 0 O W N O O O (0 . O o W O w O N O O O O w w o 0 o A 1p o 0 0 [o .,.'.,.. O O V O J O N O W O O O m J O 3 ADmmm `m m i Ul � V O ip N (O (NP N N m O W 0 O N N p O N � _ O A O N O N O O O O 0 3 o 0 0 0 m [m0 O O O V N (mll cc m m 4J <J O 0) LN O u. mwoc000 � N � A O O W O A � w W 0 W A A O W O O " 0 y A � O N O O N O N O P. Oo ➢ .� -.. w O O 0 0 0 0 0 000000 O O N o O J A o 0 o A 1p o 0 0 [o .,.'.,.. +0 0 0 + O 80 W ° G)8 `m 3 ADmmm `m m i Ul � V O ip Z m� a � N � _ O A O C O O m 0 3 o 0 0 0 m w e cc m m m c � N � � m � m A � i N N o O J A o 0 o A 1p o 0 0 [o .,.'.,.. +0 0 0 + O N N N V N (O N O i Ul � V O ip NIW W V ? N N o O J NO V N N O O .,.'.,.. AN Umi O N N O N N NIW W V ? ?l�,M N N o O J NO V N N O O .,.'.,.. AN Umi O N N V [O W la N V N (O N O i Ul � V O ip ?l�,M 'IF'iI NIW w+ NO m N m UNi t�0 W .,.'.,.. m Umi O N N w <p V O J N N W W O 'IF'iI NIW W (wli A NO UNi t�0 W tD A P W J w <p V O J N i wm w N O A O O o 0 0 0 oI 81 o Mo ]OM 41 W G1 O w W w o W W A W N N N o AO A (W» W W N W O O O o O O OWi A m m m o N (mll (ml� O j A w J W w O N N N O NI NI AN N N A m o m O O 00 g r w � o O w� T ➢1 N. m v W W m W m N N m W W W m m W p! m W W W p� p3 W m W m N W N N N OO��N N N N mom N N N A A A A? Apps W W W W W W W) A A W W W N N O ( p N N N N N O O l0 c 0 W J W N A (AO N N J W N (ll O (O J N W OI w N -` O O W N V O J O O o O d N N N O_ Ro C ? dvcn w2� m �1 S o G��m -n= v m ' m m w �� �. �D N m m= > j Eg � m WE �D a� � >. 93 oo �C �.� 5 mom Wm W�oa o N vai '7' m m m 3»m » N sn C m 0 n m » m pp o °mm o3 m0 on N 0 RS 00 xm » m n Q m>£ 90 M nm C) 5 w o x m 2✓ .� O v o �o O 5 � o- W O O O O1 O O O A O w . N W tD O O O J o W O O W W o W m W O N m A N W O V O N W W O N N W M W A MO N O V V W O O V V J N V O N N W W W 0 0 0 J A N V N O W A N O O W O., O O V O D J A W O O( O N O O N W V V W O O N J O W O N 0 O W W N W A O P, N O O N W A O o 0) A A O O N W N N W N N W T O O N is W(O oW W N W O N N N N W W wl W N A N— W O W W m O N W p W V W o NW W WOO W W NO NO O P (O W J N O W (O A O A W W W N A N WON N T W J (JlI (WJI N NtOOOO W W A N N V A w (p OP P N O A O W O gO O O N O W O O O w O P O O O W A W w O W W N W W O W W W IV WOW W W W (h ONO W A (o N W A b, A O W N W O No, O o O O N N O J O V O (11 O NON O 90,,,w N J N N W m O V O J O �NJ N A pN O N ? i N PP m W � —moo o mm— O N O N N N pWpAN W w W J V AW N O W W W A (O UI W IV U� ao - J V V V O W� W W W O qO W O O O N N N O O PP 0 0 0 0 0o a0 0 0 0 0 A W J Gl N A O O O p W N O W O O V W O O NW W O O T J V O O J w -W` t00 A P wm pp D W W O O A N W f0 (O W O W N W O V W O W N Z A N N A N f0W11 N W A N N W V W O W W W N 0 O N J 00.00 w Oo N ? 0 O O 00 N 0 0 O O O O W O N O O b 00 0 O O O O 0o . w 00 O 00000 000 O O V A w (p OP P N O A O W O gO O O N O W O O O w O P O O O W A W w O W W N W W O W W W IV WOW W W W (h ONO W A (o N W A b, A O W N W O No, O o O O N N O J O V O (11 O NON O 90,,,w N J N N W m O V O J O �NJ N A pN O N ? i N PP m W � —moo o mm— O N O N N N pWpAN W w W J V AW N O W W W A (O UI W IV U� ao - J V V V O W� W W W O qO W O O O N N N O O PP 0 0 0 0 0o a0 0 0 0 0 A �4,I W N N J W N A O (O o( (11 V 4 t J 4 O O V O O lU A W A W V O N OV] I N N W J Gl N A O O O p W N O W O O V W O O X 0 0 N i OWi NJN A P wm pp D W W O O A N W f0 (O W O W N W O V W O W N Z A N N A N f0W11 W AD W W W 40. V W 00 N 0 0 0 0 0 p N (p iW Z N O O W O O W O o O °o °O w mD a �4,I W N N J W N A O (O o( (11 V 4 t J 4 O O V O O lU A W A W V O N OV] I N N mva7 'v $ a C a D dn« N, m -1 N N Gl W m O O O (O A J orno ow-� O N N O O N N N i OWi NJN A P wm 01 O) W V K)w O w N W f0 (O W W N O W O m O W N Z O O J �ON f0W11 W AD W W N w 00 N 0 0 0 0 0 66 bbo O O o O O O O mva7 'v $ a C a D dn« N, m -1 N N �i V V V m m m mm m moI p� m m m mm m� n a OO O O �U oWp J Jo Vp mmrn m N N NNNN y i d ID"' � i e w 3 z W �N z $ �. 3 R C% $ Nj Nc m cn 0 7 El N O � O A + N N W N p 00 Ql m N N O� GJ N 0000_ yy i' �OJ ( O N N eo N m N O m A (W(pp f T J N O W t0 mN W N W OO6 co O (.J OJ OJ 0 mw N �I O wo AOm O O NN O V W W p�p� mN N V JNO��� N l n W N V V N m I O A O N w 0 0 O O IJ 44 4l O 1 pp j pw tIf A 000 Ne 00 IO A A O N Q1 l0 0000 00 OJ A N m A 00 O N 000 (O q (J Oo N W W w C 4l V V �1 W lU o (JI W O�oO� ow app m 83pI 00 O � N N O N N N N O(mP00 {:a o w NN OI A W W J pm pW VNOOIN O m .>(� S O N N O O lV0 W OVi O U m O O O 18 N Oo m :k A A W mho N ? oNOm G 00 T � OVI m N oN W (D OAOOid N I NN W J N N N W V fNII W A ji tO1i N �I U � ro W o w J }V coo W V D u p o O O O 0 O } e ) 7 77 ! §: - o ® ®7 ! 7 j S§ \ ) ( ( !§ ( � ) ( \ ` ^ } \ k k ! \ d B §& } � � � ( $ \ ( ( )§ | 5 er \ \ \ \\ \ \ m Parkview Villa-North (165) Balance Sheet May 2013 Books = Accrual May -13 Assets 10100 Cash Balance 18,757.53 10200 Petty Cash 871.00 10400 Investments 891,214.11 11300 Rent Receivable 1,793.20 11500 Accounts Receivable 235.12 13200 Due From Other Government Units 0.00 Total Assets 912,870.96 Liabilities 20200 Accounts Payable 19,202.25 20210 Accrued Other Expenses 8,708.75 20220 Due to Resident Council 551.74 22000 Deposits 18,661.52 22200 Accrued PILOT 10,135.75 22210 Revenue Collected in Advance 1,028.60 Total Liabilities 58,288.61 Fund Balance 25300 Fund Balance 854,582.35 Total Fund Balance 854,582.35 Total Liabilities and Fund Balance 912,870.96 Parkview Villa -North (165) income Statement For The Period Ending May 2013 Books = Accrual Revenue 33160 -46330 Federal Grant 36220 -46330 Gen. Government Rents 36225 -46330 Nondwelling Rents 36290 -46330 Other Miscellaneous Revenue 39120 -46330 Recovery Damage City Property Total Revenue Expenses Personal Services 1000 -46330 Accrued Salaries Total Personal Services Supplies 2000 -46330 Office Supplies 2010 -46330 Minor Equipment 2160 -46330 Maint. & Construct Materials 2171 -46330 General Supplies Total Supplies Other Services & Charges 3040 -46330 Legal Fees 3050 -46330 Expert and Professional Services 3060 -46330 Management Services 3100 -46330 Protective Services 3210 -46330 Telephone & Telegraph 3430 -46330 Advertising Other 3600 -46330 Insurance & Bonds 3810 -46330 Electric _ 3820 -46330 Water 3830 -46330 Gas 3840 -46330 Refuse 3850 -46330 Sewer 4000 -46330 Repair & Maint. Services 4100 -46330 Rents & Leases. 4300 -46330 Miscellaneous Charges 4315 -46330 PILOT 4390 -46330 Taxes & Licenses 4500 -46330 Administrative Expenses 4850 -46330 Interest on Deposits Total Other Services & Charges Month to Date % Year to Date °/a 414.91 1.31% 11,450.91 6.84% 30,199.00 95.71% 150,353.00 89.87% 429.00 1.36% 2,145.00 1.28% 510.00 1.62% 3,241.89 1.94% - 0.00% 105.00 0.06% 31,552.91 100.00 0/0 167,295.80 100.000/0 8,752.00 27.74% 43,760.00 26.16% 8,752.00 27.74% 43,760.00 26.16% 176.52 0.56% 888.33 0.53% 0.00 0.00% 615.13 0.37% 157.23 0.50% 2,806.62 1.68% 180.48 0.57% 512.65 0.31% 514.23 1.63 0/a 4,822.73 2.88% 0.00 0.00% 3,740.95 2.24% 0100 0.00% 0.00 0.00% 4,772.00 15.12% 23,860.00 14.26% 298.67 0.95% 2,015.65 1.20% 357.31 1.13% 1,729.77 1,03% 0.00 0.00% 65.00 0.04% 1,741.75 5.52% 8,708.75 5.21% 3,848.58 12.20% 13,931.78 8.33% 0.00 0.00% 1,928.07 1.15% 4,044.00 12.82% 21,423.71 12.81% 0.00 0.00% 3,665.33 2.19% 0.00 0.00% 1,070.04 0.64% 4,544.77 14.40% 24,842.59 14.85% 402.31 1.28% 507.31 0.30% 0.00 0.00% 0.00 0.00% 2,572.31 8.15% 10,680.91 638% 0.00 0.00% 1,243.38 0.74% 175.33 0.56% 1,198.84 0.72% 14.50 0.05% 70.54 0.04% 22,771.53 72.17% 120,682.62 72.14% i Capital.qutlay 5120 -46330 Building & Improvements Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00 0.00% 1,839.76 1.10% ).00 0.000/0 1,839.76 1.100/0 32,037.76 101.54% 171,105.11 102.28% - 484.85 -1.54% - 3,809.31 -2.280/a Parkview Villa -North (16S) Cash Flow Statement Period = May 2013 Book = Accrual Revenue 33160 Federal Grant 36220 Gen. Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Expenses Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2280 Vehicle Parts Total Supplies Other Services & Charges 3040 Legal fees 3050 Expert & Professional Services 3060 Management Services 3100 Protective Services 3210 Telephone & Telegraph 3430 Advertising Other 3600 Insurance & Bonds 3810 Electric 3820 Water 3830 Gas 3840 Refuse 3850 Sewer 4000 Repair & Maint. Services 4050 Garage, Labor Burd. 4100 Rent & Leases 4300 Miscellaneous Charges 4315 PILOT - 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits 5120 Building & Improvement Total Other Services .& Charges Total Expenses Excess (Deficit) Revenue over Expenses Month to Date 414.91 30,199.00 429.00 510.00 0.00 31,552.91 8,752.00 8,752.00 176.52 0.00 0.00 337.71 0.00 514.23 0.00 0.00 4,772.00 298.67 357.31 0.00 1,741.75 3,848.58 0.00 4,044.00 0.00 0.00 4,544.77 0.00 402.31 0.00 2,572.31 175.33 0.00 14.50 0.00 22,771.53 32,037.76 - 484.85 �D Parkview Villa -North (165) Cash Flow Statement Period = May 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 0.00 0.00 - 821.00 -38.00 23,847.09 0.00 - 7,247.25 1,741.75 14.50 - 22,298.63 642.00 (4,159.54) (4,644.39) Beg Cash End Cash Difference 23,401.92 18,757.53 (4,644.39) 871.00 871.00 - 891,214.11 891,214.11 - 915,487.03 910,842.64 (4,644.39) 6/1812013 8:02 AM Page 1 of 2 Parkvlew Villa -North (165) General Ledger Period = May 2013 Book = Accrual; Tree = ysl_tb Property - Data Person /Description Central Reference Debit Credit r Balance Remar ks 1000-46330 Accrued Salaries 35,008.00 = Beginning Balance = 165 5/31/2013 :POStRecurring Monthly recurring en 3- 163684 RC 8,752.00 0.00 43,760.00 R/C CHC PR Mgmt Fee Net Change = 8,752.00 431760.00 = Ending Balance = 2000 -46330 Office Supplies 711.81 = Beginning Balance = 165 4/26/2013 Office Depot (af88B04) P- 332657 6.55101E +11 95.80 0.00 807.61 office supplies 165 5/1/2013 Office Depot(offi8804) P- 332678 6.55799E +11 37.96 0.00 845.57 office supplies 165 5/21/2013 Office Depot (off18804) P- 335326 6.58594E +11 42.76 0.00 888.33 office supplies Net Change= 176.52 688.33 = Ending Balance = 2010 -46330 Minor Equipment 615.13 = Beginning Balance = Net Change =0.00 615.13 = Ending Balance = 2160 -46330 Mount. & construct Materials 21649.39 = Beginning Balance = 165 5/14/2013 HD Supply Facilities Maintenance, Lt P-333985 9122291663 150.23 0.00 2,799.62 cleaning supplies /light bulbs 165 5/23/2013 Frattalone's /Metro Ace (flat) P- 335271 0150968 7.00 0.00 2,806.62 grease mutt sm, Net Change= 157.23 21806.62 = Ending Balance = 2171 -46330 General Supplies 332.17 = Beginning Balance = 165 5/312013 Buckeye Cleaning Centers (bucd841 P- 333426 739172 156.48 0.00 488.65 roll towel /grn crt foam hnd 165 5/14/2013 HD Supply Facilities Maintenance, Lt P- 333985 9122291663 24.00 0.00 512.65 cleaning supplles/Iight bulbs Net Change= 180.48 512.65 = Ending Balance = 3040 -46330 Legal Fees 3,740.95 = Beginning Balance = Net Change =0.00 3,740.95 = Ending Balance = 3060 -46330 Management Services 19,088.00 = Beginning Balance = 165 5/30/2013 CommonBand Housing (chc) P- 335568 05/18/13 -05/3( 13,524.00 0.00 32,612.00 148814 mgmt fees 05/13 165 5/31/2013 :PostRecurring Monthly recurring an 3- 163684 RC 0.00 8,75200 23,860.00 R/C CHC PR Mgmt Fee Net Change= 4,772.00 23,860.00 = Ending Balance = 3100 -46330 Protective Services 11716.98 = Beginning Balance = 165 4/2712013 C & D Communications, Inc. (c &dc) P- 331337 24145 148.91 0.00 1,865.89 phn jacks dont work rm 103 165 5/17/2013 C & D Communications, Inc. (c &dc) P- 334286 24165 149.76 0.00 2,015.65 replace wall jack #511 Net Change= 298.67 21015.65 = Ending Balance = 3210 -46330 Telephone & Telegraph 1,372.46 = Beginning Balance o 165 413012013 Popp.com (Popp) P- 333190 992104215 223.90 0.00 1,596.36 tel svcs 05/2013 165 5/112013 Level One (leve) P- 331856 0315595IN 76.52 0.00 1,672.88 maim pin/roll over phn # 5/20: 165 5/2/2013 Comcast(comc3474) P- 332757 8772105050191 56.89 0100 1,729.77 internet 5/11 - 6/10/13 Net Change= 357.31 1,729.77 = Ending Balance = 3430 -46330 Advertising Other 65.00 = Beginning Balance = Net Change =0.00 65.00 = Ending Balance = 3600 -46330 Ensure nice & Bonds 6,967.00 = Beginning Balance = 165 5/31/2013 :PostRecurring Monthly recurring on )- 163684 RC 1,741.75 0.00 8,708.75 C of Columbia Heights Ins Accrl Net Change = 1,741.75 81708.75 = Ending Balance = 3810 -46330 Electric 10,083.20 = Beginning Balance = 165 5/1312013 Xcel Energy (xcel) P- 334629 5150441553 05 3,828.04 0.00 13,911.24 elec 4/6- 5/6/13 165 5/13/2013 Xcel Energy (xcel) P- 334629 5150441553 05 16.29 0.00 13,927.53 auto proteRlve let 4/6- 5/5/13 165 5/13/2013 Xcel Energy (xcel) P- 334629 5150441553 0_` 4.25 0.00 13,931.78 addl facll chg 4/6- 5/5/13 Net Change= 3,848.58 13,931.78 = Ending Balance = 3820 -46330 Water 11920.07 = Beginning Balance = Net Change =0.00 1,928.07 = Ending Balance = 3830 -46330 Gas 17,379.71 = Beginning Balance = 165 5/7/2013 CenterPolnt Energy (cent) P- 333452 55199657 05/0 77.50 0.00 17,457.21 late fee 165 5/7/2013 CenterPolnt Energy (cent) P- 333452 55199657 05/0 3,966.50 0.00 21,423.71 gas 4/4- 5/3113 Net Change = 4,044.00 21,423.71 = Ending Balance = Page 1 of 2 6/18/2013 8:02 AM 41,301.86 9,264.10 Page 2 of 2 15 Parkvlew Villa -Narth (165) General Ledger Period = May 2013 Book = Accrual; Tree = ysi_tb Property Date Person /Description Control Reference Debit. Credit Balance Remarks 3840 -46330 Refuse 3,665.33 = Beginning Balance = Net Change =0.00 3,665.33 = Ending Balance = 3850 -46330 Sewer 1,070.04 = Beginning Balance = Net Change =0.00 1,070.04 = Ending Balance = 4000 -46330 Repair & Malnt. Services 20,297.82 = Beginning Balance = 165 2/13/2013 Drain King, Inc.(dra17740) P- 334494 86390 135.00 0.00 20,432.82 clogged kitchen sink repair 165 4/24/2013 High Profile Grounds Maintenance, 1 P- 331336 26772 231.15 0.80 20,663.97 plow /de -Ice 4/18 - 4/19113 165 4/25/2013 Direct Home Appliance Services (din P- 332763 42513165 252.36 0100 20,916.33 valve coils /air duct assy 165 - 4/30/2013 Kone Inc.(kone) P- 332353 150835953 275.98 0.00 21,192.31 elev repair 4/16/13 165 4/30/2013 LBP Mechanical, Inc (Ibpm) P- 332651 W18550 813.93 0100 22,006.24 replace motor /switch 165 4/3012013 LBP Mechanical, Inc (Ibpm) P- 332656 W18571 212.50 0.00 22,218.74 repair damper motor linkage 165 5/1/2013 Kone Inc.(kone) P- 333073 221174087 700.01 0.00 22,918.75 maint coverage 05/2013 165 5/3/2013 BMM Inc (bmmi) P- 333463 26015 142.50 0.00 23,061.25 gen rprs /prev maint 4/29 -5/1/1 165 5/6/2013 K.O. Cleaning and Restoration LLC ( P- 333072 1414 125.00 0.00 23,186.25 repair /re- texture unit 905 165 5/9/2013 LBP Mechanical, Inc (Ibpm) P- 333425 W18594 317.50 0.00 23,503.75 align blower wheels /oil bearing 165 5/15/2013 City Wide Locksmithing, Inc (clty40 P- 334096. 3031 96.84 0.00 23,600.59 repair Hie cabinet 165 5/20/2013 Direct Home Appliance Services (dir P- 334346 52013165 134.71 0.00 23,735.30 replace thermo fuse 165 5/21/2013 K.O. Cleaning and Restoration LLC ( P- 335063 1425 900.00 0.00 24,635.30 paint unit 404 165 5/22/2013 Direct Home Appliance Services (din P- 334389 011713165a -31 0.00 240.41 24,394.89 dryer repair 165 5/22/2013 Direct Home Appliance Services (doe P- 334389 011713165a -33 240.41 0.00 24,635.30 dryer repair 165 5/22/2013 Direct Home Appliance Services (din P-334389 011713165a -33 0.00 240.41 24,394.89 dryer repair 165 5/23/2013 LBP Mechanical, Inc (Ibpm) P- 335041 W18630 447.70 0.00 24,842.59 recce valy to ask brd heat 470 Net Change= 41544.77 24,842.59 = Ending Balance = 4100 -46330 Rents & Leases 105.00 = Beginning Balance = 165 4/30/2013 Multhmoseg Credit Control (multi) P- 333555 13040376 85.00 0.00. 190.00 bkgrnd chk(s) 4/25- 4130/13 165 5/9/2013 Sherwin- Williams Co. (sher4110) P- 333567 43663 303.81 0.00 493.81 paint 165 5/17/2013 Common6ond Housing (chc) P- 334141 05101/13 -05/1: 13.50 0.00 507.31 143697 talx empty verif 4113 Net Change = 402.31 507.31 = Ending Balance = 4315 -46330 PILOT 8,108.60 = Beginning Balance = 165 5/1/2013 Anoka County (taxa) P- 330486 36- 30- 24 -32 -0( 545.16 0.00 8,653.76 2013 property tax (paid in full) 165 5/31/2013 :PostRecurring Monthly recurring an 1- 163684 RC 2,027.15 0.00 10,680.91 Anoka Cty Property Tax Accrual Net Change = 2,572.31 10,680.91 = Ending Balance = 4390 -46330 Taxes & Licenses 1,243.38 = Beginning Balance = Net Change =0.00 1,243.38 = Ending Balance = 4500 -46330 Administrative Expenses 11023.51 = Beginning Balance = 165 11/7/2012 Jennifer Bells (eel]) P- 332738 1.10712E +11 69.39 0.00 1,092.90 mileage 8/23- 11/7/12 165 4/24/2013 Jennifer Eells (sell) P- 332923 42413165 33.28 0.00 1,126.18 exp reimburse 4/24/13 165 5/7/2013 Laura Frost(fros) P- 334602 50713 31.28 0.00 1,157.46 exp reimburse 5/7/13 165 5/7/2013 Laura Frost(fros) P- 334602 50713 0.00 31.28 1,126.18 exp reimburse 5/7/13 165 5/7/2013 Laura Frost(Fros) P- 334602 50713 31.28 0100 1,157.46 exp reimburse 5/7/13 165 5/17/2013 CommonBond Housing (chc) P- 334141 05/01/13 -05/1; 10.10 0.00 1,167.56 133957 quarterly training 4/18, 165 5/30/2013 Commaneond Housing (chc) P- 335568 05/18/13 -05/3( 31.28 0.00 1,198.84 148659 If crd mbr 5/7/13 Net Change= 175.33 1,198.84 = Ending Balance = 4850 -46330 Interest on Deposits 56.04 = Beginning Balance = 165 5/31/2013 Sec Dep Interest accrual )- 164234 GJ1 14.50 0.00 70.54 Sec Delp Interest accrual Net Change= 14.50 70.54 = Ending Balance = 5120 -46330 Building & Improvements 11839.76 = Beginning Balance = Net Change =0.00 11839.76 = Ending Balance = 41,301.86 9,264.10 Page 2 of 2 15 Parkview Villa North 06/07/2013 Bank Reconciliation Report 05/31/2013 5016456 Balance Per Bank Statement as of 05131/2013 23,456.64 Outstanding Checks Check date Check number Payee Amount 05/21/2013 2101 comc3474 - Comcasl 56.89 05121/2013 2102 dire - Direct Home Appliance Services 240.41 05129/2013 2107 c &dc - C & D Communications, Inc. 149.76 05/29/2013 2108 dire - Direct Home Appliance Services 134.71 05129/2013 2109 drai7740 - Drain King, Inc. 135.00 05129/2013 2111 offi8804 - Office Depot 133.76 05/2912013 2112 xcel - Xcel Energy 3,848.58 Less: Outstanding Checks 05/1512013 4,699.11 c &dc - C & D Communications, Inc. Reconciled Bank Balance 18,757.53 Balance per GL as of 0513112013 18,757.53 Reconciled Balance Per G/L 18,757.53 Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) 0.00 Cleared Items Cleared Checks Date Tran # Notes Amount Date Cleared 04/23/2013 2074 high8236 - High Profile Grounds Maintenance, Inc. 115.58 05/31/2013 05/01/2013 2080 home7 - FID Supply Facilities Maintenance, Ltd. 137.54 05/31/2013 05/0112013 2081 Ibpm - LBP Mechanical, Inc 212.50 05/31/2013 05/01/2013 2082 petl65hm - Heidi Mindestrom 207.00 05/3112013 05/02/2013 2083 taxa - Anoka County 24,870.94 05131/2013 05/15/2013 2084 all - All Inc. 504.00 05/31/2013 05/1512013 2085 c &dc - C & D Communications, Inc. 148.91 05/31/2013 05/1512013 2086 cent- CenterPoint Energy 5,166.73 05/31/2013 05115/2013 2087 chc - CommonBond Housing 13,652.33 05/31/2013 05/15/2013 2088 colu - City of Columbia Heights 6,489.60 05/3112013 05/15/2013 2089 dire - Direct Home Appliance Services 252,36 05/31/2013 05/15/2013 2090 eell - Jennifer Eells 102.67 05131/2013 05/15/2013 2091 high8236 - High Profile Grounds Maintenance, Inc. 231.15 05131/2013 05/15/2013 2092 home7 - HD Supply Facilities Maintenance, Ltd. 79.80 05/31/2013 N Total Cleared Checks 55,724.68 Cleared Deposits Date Tran # 05/06/2013 491 05/1012013 492 Total Cleared Deposits Cleared Other Items Date Tran # 05/09/2013 JE 164236 Total Cleared Other Items Notes Amount Date Cleared Parkview Villa North 05/31/2013 06/07/2013 05/31/2013 Bank Reconciliation Report 05/31/2013 5016456 Cleared Checks Date Tran # Notes Amount Date Cleared 05/15/2013 2093 kocl - K.O. Cleaning and Restoration LLC 125.00 05/31/2013 05/1512013 2094 kone - Kone Inc. 975.99 05131/2013 05/1512013 2095 Ibpm - LBP Mechanical, Inc 1,026.43 05131/2013 05/15/2013 2096 leve - Level One 76.52 05/31/2013 0512112013 2097 bmmi - BMM Inc 142.50 05/31/2013 05/2112013 2098 buck8411 - Buckeye Cleaning Centers 156.48 05131/2013 05121/2013 2099 chc- CommonBond Housing 23.60 05/31/2013 05/21/2013 2100 city4054 - City Wide Locksmithing, Inc. 96.84 05/31/2013 05/2112013 2103 Ibpm - LBP Mechanical, Inc 317.50 05/31/2013 05/2112013 2104 multi - Multihousing Credit Control 85.00 05/31/2013 05121/2013 2105 Popp - Popp.com 223.90 05131/2013 05121/2013 2106 sher4116- Sherwin - Williams Co. 303.81 05/31/2013 Total Cleared Checks 55,724.68 Cleared Deposits Date Tran # 05/06/2013 491 05/1012013 492 Total Cleared Deposits Cleared Other Items Date Tran # 05/09/2013 JE 164236 Total Cleared Other Items Notes Amount Date Cleared 28,034.00 05/31/2013 2,887.00 05/31/2013 30,921.00 Notes Amount Date Cleared ELoccs Operating Fund Receipt 24,262.00 05/31/2013 24,262.00 2 Date 5/31/13 Page 1 Primary Account @XXXXX 96456 Enclosures 28 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 @XXXXX @6456 Number of Images Statement Dates 5/01/13 thru 28 5/31/13 Account Number Balance 23,998.32 Days in the Statement Period 31 Previous 3 Deposits /Credits 55,183.00 Average Ledger 45,474 44,364 26 Checks /Debits 55,724.68 Average Collected Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 23,456.64 Deposits and Credits Amount Date Description 5/06 DDA REGULAR DEPOSIT 28,034.00 5/09 HUD TR05/09/13 24,262.00 CR 9101036151 ID #- 411269646860103 TRACE #- 101036150624993 2,887.00 5/10 DDA REGULAR DEPOSIT Checks in serial order Check# Amount Date Check# Amount Date 5/01 2074 115.58 5/21 2088 6,489.60 252.36 5/09 2080* 137.54 212.50 5/28 2089 5/24 2090 102.67 5/09 2081 5/03 2082 207.00 5/23 2091 ?.31.15 79.80 5/17 2083 24,870.94 5/21 2092 5/24 2093 125.00 5/21 2084 504.00 5/22 2085 148.91 5/21. 2094 975.99 5/23 2086 5,166.73- 5/21 2095 1,026.43 76.52 5/22 2087 13,652.33 5/22 2096 * Indicates skip in check numbers E NORTHEAST PUBLIC FUNDS ACCT Date 5/31/13 Primary Account Enclosures @XXXXX @6456 (Continued) Checks Date in serial order Check# Amount Date check# 5/29 2097 142.50 5/17 5/29 2103* 5/28 2098 156.48 23,675.74 5/30 2104 5/24 2099 23.60 5/06 5/29 2105 5/29 2100 96.84 5/30 2106 * Indicates skip in check numbers 5/10 Page 2 @XXXXX @6456 28 Amount 317.50 85.00 223.90 303.81 Daily Date Balance Section Balance Date Balance Date Balance 5/01 23,882.74 5/17 53,637.76 5/28 5/29 24,626.19 23,845.45 5/03 23,675.74 5/21 5/22 44,561.94 30,684.18 5/30 23,456.64 5/06 51,709.74 5/09 75,621.70 5/23 25,286.30 5/10 78,508.70 5/24 25,035.03 * * * E N D O F S T A T E M E N T 1� Payment Summary Bank = i65opr AND mm /yy= 05/2013- 05/2013 AND All Checks =Yes AND Include Voids =All Checks 0 Check Post Total Bank Check# Vendor Date Month Amount i65opr -Parkview Villa North 2012 dire - Direct Horne Appliance Services GS/22/2013 05/2013 (480.82) 165opr - Parkview Villa North 2080 home? - HD Supply Facilities Maintenance, Ltd. 05/01/2013 05/2013 137.54 165opr - Parkvlew Villa North 2081 Ibpm - LBP Mechanical, Inc 05/01/2013 05/2013 212.50 165opr - Parkvlew Villa North 2082 pet165hm - Heidi Mlndestrom 05/01/2013 05/2013 207.00 165opr - Parkview Villa North 2083 taxa - Anoka County 05/02/2013 05/2013 24,870.94 165opr - Parkview Villa North 2084 all - All Inc. 05/15/2013 05/2013 504.00 165opr - Parkview Villa North 2085 c &dc - C & D Communications, Inc. 05/15/2013 05/2013 148.91 165opr - Parkview Villa North 2086 cent - CenterPoint Energy 05/15/2013 05/2013 5,166.73 165opr - Parkview Villa North 2087 chc - CommonBond Housing 05/15/2013 05/2013 13,652.33 165opr - Parkview Villa North 2088 cod - City of Columbia Heights 05/15/2013 05/2013 6,489.60 165opr - Parkview Villa North 2089 dire - Direct Home Appliance Services 05/15/2013 05/2013 25236 165opr - Parkview Villa North 2090 eell - Jennifer Fells 05/15/2013 05/2013 102.67 165opr - Parkview Villa North 2091 high8236 - High Profile Grounds Maintenance, Ir 05/15/2013 05/2013 231.15 165opr - Parkview Villa North 2092 home7 - HD Supply Facilities Maintenance, Ltd. 05/15/2013 05/2013 79.80 165opr - Parkview Villa North 2093 kod - K.O. Cleaning and Restoration LLC 05/15/2013 05/2013 125.00 165opr - Parkview Villa North 2094 kone - Kone Inc. 05/15/2013 05/2013 975.99 165opr - Parkview Villa North 2095 Ibpm - LBP Mechanical, Inc 05/15/2013 05/2013 1,026.43 165opr - Parkview Villa North 2096 leve - Level One 05/15/2013 05/2013 76.52 165opr - Parkview Villa North 2097 bmml - BMM Inc 05/21/2013 05/2013 142.50 165opr - Parkview Villa North 2098 buck8411 - Buckeye Cleaning Centers 05/21/2013 05/2013 156.48 165opr - Parkview Villa North 2099 chc - Commoneond Housing 05/21/2013 05/2013 23.60 165opr - Parkview Villa North 2100 city4054 - City Wide Locksmithing, Inc. 05/21/2013 05/2013 96.84 165opr Parkview Villa North 2101 comc3474 - Comcast 05/21/2013 05/2013 56.89 165opr - Parkview Villa North 2102 dire - Direct Home Appliance Services 05/21/2013 05/2013 240.41 165opr - Parkview Villa North 2103 Ibpm - LBP Mechanical, Inc 05/21/2013 05/2013 317.50 165opr - Parkview Villa North 2104 multl - Multihousing Credit Control 05/21/2013 05/2013 85.00 165opr - Parkview Villa North 2105 Popp - Popp.com 05/21/2013 05/2013 223.90 165opr - Parkview Villa North 2106 sher4110 - Sherwin- Williams Co. 05/21/2013 05/2013 303.81 165opr Parkvlew Villa North 2107 c &dc - C & D Communications, Inc. 05/29/2013 05/2013 149.76 165opr - Parkvlew Villa North 2108 dire - Direct Home Appliance Services 05/29/2013 05/2013 134.71 1650pr - Parkvlew Villa North 2109 drai7740 - Drain King, Inc. 05/29/2013 05/2013 135.00 165opr - Parkvlew Villa North 2110 fros - Laura Frost 05/29/2013 05/2013 31.28 165opr - Parkvlew Villa North 2110 fros - Laura Frost 05/31/2013 05/2013 (31.28) 165opr - Parkvlew Villa North 2111 ofFi8804 - Office Depot 05/29/2013 05/2013 133.76 165opi - Parkview Villa North 2112 xcel - Xcel Energy _.... my 05/29/2013 05/2013. 3,848.58 59,827.39 0 L J O 0 O Z `tU 3 L Y Ol � _ ' O � M N E N � J � O @ w U } o N y UM 0 N N J -0 N O X W Q 2 d C t6 f0 ni NI'O 1 C t0 l N U 1 } IC w Q C O U N ttl U d 9 O U N O Q N c N M r r of N N O M M (O N W � W M M V O d � N m `m L U 65 N N U N N ar tq O t ] O N N M O O i0 M M O N � M (O l0 O N O � 0 O C M M O � V U M M Q � N a) r Ol M c r O I O t0 V I� (O M c0 OJ N O N N O) `m L U w N U N N a� U- L � O 1i Parkview Villa South Financial Statement Overview May 2013 Revenue: Occupancy for the month of May was 95 % occupied Total Revenue was slightly lower than budget amount (unfavorable) and reflects uo raise. income such as laundry or damages fees Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were over budget (unfavorable) and reflect the cost of background screenings for applicants Office Supplies was under budget (favorable) Legal Expenses were under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Misc. Admin Expenses is over budget (unfavorable) and reflects an accounting error. This will be corrected on the June financials Utilities: Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing Electric was wider budget (favorable) and reflects a quarterly billing Gas was under budget (favorable) and reflects a quarterly billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense RICH Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Snow Removal was over budget (unfavorable) and reflects invoices from April Decorating Supplies was over budget (unfavorable) and reflects the cost of painting supplies Furniture and Fixtures was slightly over budget (unfavorable) and reflects the cost of appliance replacement S W W N N N W N N N N N N N N N N N N � N N N O O O y III A n m' m� Da m � � �` ° umi � m � o m ' m ^' 'rt1 vw�i• 8,' s m DD 3 m ;,u �'8 N M p z( o p,No G)wo W D om. ? N r 30Z W O� m W A W G) W.:U;U; m m 0 o W W ca m m rn m �. m mOW mi oc3� mm ",m =m-n 3B c A .o. Win= W c WvvN v c d y .Zl imn N 2' m W r W q W m 90 »< m °=°ooh 0 0 (W m m m m N w � O O O O O o i E N N N rip. N lND 0 N UNi A O. W '6 E� A CJ fJ (Np N N O O N W d' N P P [O W N 1 E 0N o N O O O Z O o O O ? Z oC O N O W O O ID W O O J 'J V Vd oJO�000 NA D' o o V v W Do m m N m p 0 M u,00 m,�Nio m o 0 o m N.m c oNOOON o °o °o o °o w W °o °ow Ilv O N O O O W i O N N. N ? N N N N N N W (J W (OP (D IJ O mw E , o A ro W m o O N N N W (Ni1 N W iN W A O N A 10 O W N J CJ O m IJ J �� N w o N N N N m O o O ^I V N o N E E N (ll O ie O (O O V O A N Z O (G O V O A o W O m A O W d oAONOW aWD a N !" O A W N V O W O O W O A A W O N O O N O != v J No N A IC /� n O O O O �O O O O O �O O O O O m T w O N O O O O O O O O O 0 O 0 00 o T Q7 a 0 c F a a _ W NN W W W N W W W W N mm m &i &i n WAp&i � w w w wwww 'y' u(C) Do O (n N N fpD p n O i W V 7 v 3 P.0 O N cM 6. 7 N w .iL L.Od O(n G7 f11C Nt'OW DN ����NCw�' =v Oww 0 OM _mA G7 L�tn 47 3 w w N �w * w U^ w wo 0ow(7wwoo_n p1 p-' 2.2. m �Nwmw >> a �wm o mo O N j E w O N w c i w 0 0 ? C O y �� 3 w N» NO > > w 2 m Wla :LI Wrom o y n o. ,7 io m 'c. C = C Re v�' m; m .xo w w o nNO po c. ()(n u � S^ W o ,xo O N N w O0 J^ .a ti w N (0 ? 9 N N N ww 'gym n�'9 ' 0 O 0 A Fw o 0 0 lo » 0 w �w R ^ µ po w ! i� A W A q O OOW O wm000 000 O N O NO W A !0 V N OO W O O N O O O N O n 0 0 p O O T O O I� w o" S o O N J O J a N 0) O NAN�OI N0) W N !O V N O O W V J W J w N.4 O N O V (O J O W N O O] W W O O o O O r O J 0 W W w O V O N J V ANN N O V W W O O O O O J O w N W W w i� N O O N W V O N J O w N (O a) W N P O J O Q7 m T O W O W W il] p T O J (O T T Y? J ? W m W N G 1 O A O W f D O J N N W W ANN N W V W A ONO (D W A l O NNW W O O O w m. 0 0 O v 0 O j 8W V O? iW 0 o O OZ O (OW000 O O ON O<OO V A J0 OONig O O O w t O O O O O V O O D 7 O O U 1 O O A W N W O O N w O O D O N o O O O o A O O (O W O J O N W S ? O �O tp O N V J f0 N W A N' fJ N V Ol j O N O J (J 0 0 N U1 fO O o A J O O A W NON O tJN O O woo.- O O A 0 O m o W o W? O W CI <It N O N O I m N O N O A W N O W O W? V (D G W W W W � W N N W N' ' ? t0 N (D V W W O m !J V W N IJ N (O A A w m N O ' O W i W N W O W A o N A N (II W N N p 0 0 W W W W J lC O W O (O NOJA N W �I O W N N O O O O O N J N W N p L)p T b, IJ'J ? ow TT OOOOO W N A JAT' rt N N W O (P O O N N N O O O O O N O O NON N c N po ' W 0 N'N W W O Ul J m -' G 2 O w N O j w w A `�• N W W O N J m V N W N V O W [O N A N p [O i N W N t 0 J N ANN A w N N 9). N N( O O o N I J A io O N W c` W N W N A O N N W O A N J- N N O J t0 W tO W V N N O N N E� i {i N O N O N N O O J fO N (O (O A N 8 w UI -` Ey N O N O W W p O N J N N A tl1 V O N N N (0 N mom O A NlN�N O O (ll O O l0 O 0 n 0 O T W J -� O J (D (O J A A o m INO �y (p o N O (O O O O W W O p W" W W N V O T i ! p N (O N' ? W N N W N W N A W W W W A N W N 0001 A O (ON? N O o (9 N O N W O N N o? o O 00 N OOONN NOO 00 00000 Ol O '0 � O 00 O 00000 000 00 00000 {J O O 0000!C yJ_ N N � N (O N O �D O O 1p fD n� u o AO1 f0 fn O O O t0 O N f0 v m ow m ioow N r m , � mo W N W n m 1 ry o O o 2 9Z an m 0 m m� mp v m O O +a N qo -� N O O N p O 3 =mm mm'a O m m �. m m m c c -.T c m n 90 �ns 'n cn no C �mo��I N m m m m 7 4 d m Im A O A O m W O o A J w W W 'm o W O m W 10 LI 0 0 A f 41 (1� O A (N11 m o t0 N O O� p O W V p 'W 'm O (J <J W po � Ol rn A G m � 0 N J 1O• m m O N N m A W O p P15 w� OJ W O N W W (O W W W m J W W f0 i p p • P O A A N p J m W G W t0 ^! J ? om W W OJ V y 00 W m m m m O (P W m O W m O O 1� N fm A P m m O 1 N N W W V W In m iG O o O O] m m m UI (O A ! O O A A W O A A m m N 00 O N JmIW <WN fh mOm NN Ao(Nli�6 j� A O m m A Op V J W W m m N O W W N m m �O � NOOi.m+ N N N m UI N I N 1 m N W A G tpp0oo W 'n. j o+I p N v o O, A tWp ?ONi o JO m W AoN� NN N W 0 0 W W 0 0 m m A A m J J t 0 m V N( G 1J IJ m V G (O f I m .(WpI 9 m N p O N ON O O pp Pin O O 'O 00 VI O O o O 00 O O OOOim O v -I 0 c m 0 z NCl) N to i FO N o X O "'0000 N Z �b v r A c m 90 PI O W W N O W N O O O O O O 1p V UI O (O V O O O C O Am O 0 p J q 0 W O � Nm F' mF To 3C c m �d m o. N x-11 w o o j N � T � 3 � n m m o_ m I p O O O 00 O O O W N N W fp <D N N of O +I V W N N � � p OI Ol at O v m O 00 O O O O O O O 90 0. O O O V OW W N W W O W W O N In io A A J � � OI W W O W W O O o O O O O O O O 00 A W W m W0 W G O O O O p p O o ao p O O m v W o ry c w � 91 O V V a 2 Parkview Villa South (166) Balance May 2013 Books = Accrual May -13 Assets 7,641.29 20200 Accounts Payable 78,011.82 4,206.25 10100 Cash Balance 8,794.78 279.00 10200 Petty Cash 5,143.45 22200 Accrued PILOT 729,970.36 377.00 10400 Investments 26,162.77 2,887.93 11300 Rent Receivable 785,052.97 66.63 11500 Accounts Receivable 785,052.97 Total Fund Balance 811,215.74 811,215.74 Total Assets Liabilities !/ o 7,641.29 20200 Accounts Payable 4,206.25 20210 Accrued Other Expenses 8,794.78 22000 Deposits 5,143.45 22200 Accrued PILOT 377.00 22210 Revenue Collected in Advance 26,162.77 Total Liabilities Fund Balance 785,052.97 25300 Fund Balance 785,052.97 Total Fund Balance 811,215.74 Total Liabilities and Fund Balance !/ o Parkview Villa -South (166) 79.30 0.30% 214.62 0.18% 3050 -46340 Expert & Professional Services Income Statement 2.16% 625.93 0.53% 2010 -46340 Minor Equipment 2,126.00 For The Period Ending May 2013 10,630.00 8.99% 2160 -96340 Maint. & Construct Materials 70.64 0.279/b Books = Accrual Month to Date 2171 -46340 General Supplies % Year to Date % Revenue 3430 -46340 Advertising Other 0.00 0.00% 160.28 0.14% 36220 -46340 Gen. Government Rents 25,954.00 3.16% 97.44% 114,284.13 96.70% 36225 -46340 Nondwelling Rents 508.00 9,260.89 1.91% 2,356.00 1.99% 36290 -46340 Other Miscellaneous Revenue 174.00 0.09% 0.65% 1,546.70 1.31% 8,567.11 7.25% - 0.00% - 0.00% 39120 -46390 Recovery Damage City 3850 -46340 Sewer 0.00 0.00% 444.63 0.38% 4000 -46340 Repair & Maint. Services 26,636.00 3.45% 100.000/0 118,186.83 100.000/0 Total Revenue 0.54% 315.00 0.27% 4300 -46340 Miscellaneous Charges 0.00 Expenses Personal Services 1000 -46340 Accrued Salaries 3,932.00 14.76% 19,660.00 16.63% Total Personal Services 3,932.00 14.76% 19,660.00 16.63% Supplies 2000 -46340 Office Supplies 79.30 0.30% 214.62 0.18% 3050 -46340 Expert & Professional Services 576.00 2.16% 625.93 0.53% 2010 -46340 Minor Equipment 2,126.00 7.98% 10,630.00 8.99% 2160 -96340 Maint. & Construct Materials 70.64 0.279/b 975.03 0.820/a 2171 -46340 General Supplies 379.54 1.42% 528.78 0.45% Total Supplies 1,105.48 4.15% 2,344.36 1.980/0 Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 52.50 0.04% 3050 -46340 Expert & Professional Services 0.00 0.00% 0.00 0.00% 3060 -46340 Management Services 2,126.00 7.98% 10,630.00 8.99% 3100 -46340 Protective Services 0.00 0.00% 771.41 0.65% 3210 -46340 Telephone & Telegraph 155.93 0.59% 772.53 0.65% 3430 -46340 Advertising Other 0.00 0.00% 160.28 0.14% 3600 -46340 Insurance & Bonds 841.25 3.16% 4,206.25 3.56% 3810 -46340 Electric 1,493.11 5.61% 9,260.89 7.84% 3820 -46340 Water 0.00 0.00% 100.87 0.09% 3830 -46340 Gas 1,152.55 4.33% 8,567.11 7.25% 3840 -46340 Refuse 0.00 0.00% 66.04 0.06% 3850 -46340 Sewer 0.00 0.00% 444.63 0.38% 4000 -46340 Repair & Maint. Services 918.35 3.45% 9,314.85 7,88% 4100 -46340 Rents & Leases 145.00 0.54% 315.00 0.27% 4300 -46340 Miscellaneous Charges 0.00 0.00% 181.59 0.15 0/0 4315 -46340 PILOT 1,028.69 3.86% 5,143.45 4.35% 4390 -46340 Taxes & Licenses 0.00 0.00% 558.62 0.47% 4500 -46340 Administrative Expenses 69.14 0.26°/% - 298.57 0.25% 4850 -46340 Interest on Deposits 7.17 0.03% 31.12 0.03% Total Other Services & Charges 7,937.19 29.80% 50,875.71 43.05% 0` Capital Outlay - 0.00/0 - 0.00% 5120 -46340 Building & Improvements 0.00 O.00a /a 0.00 0.000/0 Total Capital Outlay 12,974.67 48.710/a 72,880.07 61.67% Total Expense Excess (Deficit) Revenue over Expense 13 661.33 � 51.29% 45,306.76 38.330/a M Parkview Villa South (166) Cash Flow Statement Period = May 2013 Revenue 36220 Gen. Government Rents 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 39120 Recovery Damage City Property Total Revenue Personnel Services 1000 Accrued Salaries Total Personnel Services Supplies 2000 Office Supplies 2010 Minor Equipment 2160 Maint. & Construct Materials 2171 General Supplies 2175 Food Supplies Total Supplies Other Services & Charges 3040 Legal Fees 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 Rents & Leases 4300 Miscellaneous Charges 4315 PILOT 4390 Taxes & Licenses 4500 Administrative Expenses 4850 Interest on Deposits Total other Services & Charges Total Expenses Month to Date 22,635.13 462.00 224.00 0.00 23,321.13 3,932.00 3,932.00 90.24 0.00 0.00 97.64 0.00 187.88 52.50 2,126.00 268.74 159.64 0.00 841.25 1,500.93 966.47 1,573.64 0.00 468.63 1,354.00 0.00 90.00 0.00 1,028.69 0.00 0.00 6.03 10,436.52 14,556.40 t Parkview Villa South (166) Cash Flow Statement Period = May 2013 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 8,764.73 (93.00) 0.00 (618.00) (76.63) 0.00 1,314.89 841.25 206.03 1,028.69 (35.00) 2,568.23 11,332.96 Beg Cash End Cash Difference 66,303.12 77,636.08 11,332.96 279.00 279.00 729,970.36 729,970.36 - 796,552.48 807,885.44 11,332.96 F1 6/18/2013 8:17 AM Parkview Villa South (166) General Ledger Period = May 2013 Book = Accrual ; Tree = ysi_tb 1000 -46340 Accrued Salaries 15,728.00 = Beginning Balance = 166 5/31/2013 :PostRecurring Recurring 3- 163685 RC 3,932.00 0.00 19,660.00 R/C CHC PR Mgmt Fee Net Change= 3,932.00 166 4/30/2013 19,660.00 = Ending Balance = 2000 -46340 Office Supplies 135.32 = Beginning Balance = 166 4/26/2013 Office Depot(off18804) P- 332657 6.55101E +11 43.03 0.00 178.35 office supplies 166 5/1/2013 Office Depot (offi8804) P- 332678 6.55799E +11 17.06 0.00 195.41 office supplies 166 5/21/2013 Office Depot (offi8804) P- 335326 6.58594E +11 19.21 0.00 214.62 office supplies Net Change =79.30 166 5/2/2013 214.62 = Ending Balance = 2010 -46340 Minor Equipment 49.93 = Beginning Balance = 166 5/6/2013 All Inc. (ail) P- 332824 51309580001 576.00 0.00 625.93 refrigerator 314 Net Change= 576.00 625.93 = Ending Balance = 2160 -46340 Maint. & Construct Materials 904.39 = Beginning Balance = 166 5/14/2013 HD Supply Facilities Maintenance P- 333985 9122291663 67.50 0.00 971.89 cleaning supplies /light bulbs 166 5/23/2013 Frattalone's /Metro Ace (frat) P- 335271 0150968 3.14 0.00 975.03 grease mult sery Net Change =70.64 975.03 = Ending Balance = 2171 -46340 General Supplies 149.24 = Beginning Balance = 166 3/21/2013 Sherwin - Williams Co. (sher4130 P-333566 24358 298.45 0.00 447.69 paint 166 5/3/2013 Buckeye Cleaning Centers (buck P- 333426 739172 70.30 0.00 517.99 roll towel /grn Crt foam had 166 5/14/2013 HD Supply Facilities Maintenance P- 333985 9122291663 10.79 0.00 528.78 cleaning supplies /light bulbs Net Change= 379.54 528.78 = Ending Balance = 3040 -46340 Legal Fees 3- 163685 52.50 = Beginning Balance = Net Change =0.00 0.00 52.50 = Ending Balance = 3060 -46340 Management Services 8,504.00 = Beginning Balance = 166 5/30/2013 CommonBond Housing (chc) P- 335569 05/18/13- 05/30/1: 6,058.00 0.00 14,562.00 148815 mgmt fees 05/13 166 5/31/2013 :PostRecurring Recurring 3- 163685 RC 0.00 3,932.00 10,630.00 R/C CHC PR M9mt Fee 3810 -46340 Net Change= 2,126.00 10,630.00 = Ending Balance = 3100 -46340 Protective Services Net Change =0.00 771.41 = Beginning Balance = 771.41 = Ending Balance = 3210 -46340 Telephone & Telegraph 616.60 = Beginning Balance = 166 4/30/2013 Popp.com (Popp) P- 333190 992104215 95.99 0.00 712.59 tel svcs 05/2013 166 5/1/2013 Level One (leve) P- 331856 0315595IN 34.38 0.00 746.97 maint pin /roll over phn # 5/201 166 5/2/2013 Comcast(comc3474) P- 332757 877210505019618 25.56 0.00 772.53 internet 5/11- 6/10/13 Net Change= 155.93 772.53 = Ending Balance = 3430 -46340 Advertising Other 160.28 = Beginning Balance = Net Change =0.00 160.28 = Ending Balance = 3600 -46340 Insurance & Bonds 3,365.00 = Beginning Balance = 166 5/31/2013 :PostRecurring Recurring 3- 163685 RC 841.25 0.00 4,206.25 C of Columbia Heights Ins Accrl Net Change= 841.25 4,206.25 = Ending Balance = 3810 -46340 Electric 7,767.78 = Beginning Balance = 166 5/13/2013 Xcel Energy (xcel) P- 334629 5150441553 05/13 1,483.88 0100 9,251.66 elec 4/6- 5/6/13 166 5/13/2013 Xcel Energy (xcel) P- 334629 5150441553 05/1? 7.32 0.00 9,258.98 auto protective lgt 4 /6- 5/5/13 166 5/13/2013 Xcel Energy (xcel) P- 334629 5150441553 05/13 1.91 0.00 9,260.89 addl facil chg 4/6-5/5/13 Net Change= 1,493.11 9,260.89 = Ending Balance = 3820 -46340 Water Page 1 of 2 100.87 = Beginning Balance = Parkview Villa South (166) General Ledger Period = May 2013 Book = Accrual; Tree = ysi_ Net 6/1812013 8:17 AM 100.87 = Ending Balance = 3830 -46340 Gas 7,414.56 = Beginning Balance = 166 5/8/2013 CenterPoint Energy (cent) P- 333453 55271324 05/08/1 23.60 0.00 7,438.16 late fee 166 5/8/2013 CenterPoint Energy (cent) P- 333453 55271324 05/08/1 1,128.95 0.00 8,567.11 gas 4/5-5/6/13 Net Change= 1,152.55 8,567.11 = Ending Balance = 3840 -46340 Refuse 66.04 = Beginning Balance = Net Change =0.00 66.04 = Ending Balance = 3850 -46340 Sewer 444.63 = Beginning Balance = Net Change =0.00 444.63 = Ending Balance = 4000 -46340 Repair & Maint. Services 8,396.50 = Beginning Balance = 166 4/24/2013 High Profile Grounds Maimenanc P- 331336 26772 103.85 0.00 8,500.35 plow /de -ice 4/18-4/19/13 166 4/30/2013 Kone Inc. (kone) P-332353 150835953 123.99 0.00 8,624.34 elev repair 4 /16/13 166 5/1/2013 Kane Inc. (kone) P- 333073 221174087 314.50 0.00 8,938.84 maint coverage 05/2013 166 5/3/2013 BMM Inc (bmmi) P- 333463 26015 332.50 0.00 9,271.34 gen rprs /prev maint 4/29 -5/1/1 166 5/15/2013 City Wide Locksmithing, Inc. (cit P- 334096 3031 43.51 0.00 9,314.85 repair file cabinet Net Change = 918.35 9,314.85 = Ending Balance = 4100 -46340 Rents & Leases 170.00 = Beginning Balance = 166 4/30/2013 Multihousing Credit Control(mul P- 333407 13040377 145.00 0.00 315.00 bkgrnd chks 4/1- 4/30/13 Net Change = 145.00 315.00 = Ending Balance = 4300 -46340 Miscellaneous Charges 181.59 = Beginning Balance = Net Change =0.00 181.59 = Ending Balance = 4315 -46340 PILOT 4,114.76 = Beginning Balance = 166 5/31/2013 :PostRecurring Recurring )-163685 RC 1,028.69 0.00 5,143.45 Anoka Cy Property Tax Accrual Net Charge= 1,028.69 5,143.45 = Ending Balance = 4390 -46340 Taxes & Licenses 558.62 = Beginning Balance = Net Change =0.00 558.62 = Ending Balance = 4500 -46340 Administrative Expenses 229.43 = Beginning Balance = 166 11/7/2012 Jennifer Fells (eell) P- 332738 1.10712E +11 31.18 0.00 260.61 mileage 8/23- 11/7/12 166 5/7/2013 Laura Frost (fros) P-334602 50713 13.93 0.00 274.54 exp reimburse 5/7/13 166 5/7/2013 Laura Frost(fros) P- 334602 50713 0.00 13.93 260.61 exp reimburse 5/7/13 166 5/7/2013 Laura Frost(fros) P- 334602 50713 13.93 0.00 274.54 exp reimburse 5/7/13 166 5/17/2013 Common Bond Housing (chc) P- 334142 05/01/13- 05/17/1: 10.10 0.00 284.64 133958 quarterly training 4/18/ 166 5/30/2013 Common Bond Housing (chc) P- 335569 05/18/13- 05/30/1: 13.93 0.00 298.57 148660 If crd mbr 5/7/13 Net Change =69.14 298.57 = Ending Balance = 4850 -46340 Interest on Deposits 23.95 = Beginning Balance = 166 5/31/2013 Sec Dep interest accrual 1-164242 G31 7.17 0.00 31.12 Sec Dep interest accrual Net Change =7.17 31.12 = Ending Balance = 16,920.60 3,945.93 Page 2 of 2 3 Parkview Villa South 06/07/2013 Bank Reconciliation Report 0513112013 5016464 Balance Per Bank Statement as of 05/31/2013 79,735.58 Outstanding Checks Check date Check number Payee Amount 05121!2013 1765 comc3474 - Comcast 25.56 05/29/2013 1769 multi - Multihousing Credit Control 145.00 05129/2013 1770 offi8804 - Office Depot 60.09 05/2912013 1771 xcel - Xcel Energy 1,493.11 Less: Outstanding Checks 1,723.76 1747 Reconciled Bank Balance 78,011.82 Balance per GL as of 05/31/2013 78,011.82 Reconciled Balance Per G/L 78,011.82 Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) 0.00 Cleared Items : Cleared Checks Date - Tran # Notes Amount Date Cleared 04/23/2013 1742 high8236 - High Profile Grounds Maintenance, Inc. 51.92 05/31/2013 05/0112013 1746 home7 - HD Supply Facilities Maintenance, Ltd. 61.79 05/3112013 05/01/2013 1747 kenn - Kennedy & Graven, Chartered 52.50 05131/2013 05/01/2013 1748 kocl - K.O. Cleaning and Restoration LLC 800.00 05/31/2013 05/01/2013 1749 pet166hm - Heidi Mindestrom 93.00 05/3112013 05/02/2013 1750 taxa - Anoka County 12,344.29 05/31/2013 05/07/2013 1751 cent - CenterPoint Energy 1,573.64 05/31/2013 05/0712013 1752 chc- Common8ond Housing 6,058.00 05/31/2013 05/07/2013 1753 colu - City of Columbia Heights 1,435.10 05/3112013 05/07/2013 1754 high8236 - High Profile Grounds Maintenance, Inc. 103.85 05131/2013 05107/2013 1755 home7 - HD Supply Facilities Maintenance, Ltd. 35.85 05/31/2013 05/07/2013 1756 twin - Twin City Garage Door Co. 187.58 05131/2013 05/15/2013 1757 cell - Jennifer Eells 31.18 05/31/2013 05/15/2013 1758 kone - Kone Inc. 438.49 05/31/2013 05115/2013 1759 leve - Level One 34.38 05/3112013 05/2112013 1760 all - All Inc. 576.00 05131/2013 05121/2013 1761 bmmi - BMM Inc 332.50 05/31/2013 �3 Cleared Checks Date Tran # 05121/2013 1762 05/21/2013 1763 05121/2013 1764 05/21/2013 1766 05121/2013 1767 Total Cleared Checks Cleared Deposits Date Tran # 05/06/2013 378 05/10/2013 379 Total Cleared Deposits Parkview Villa South Bank Reconciliation Report 05/31/2013 5016464 Notes buck8411 - Buckeye Cleaning Centers chc - CommonBond Housing city4054 - City Wide Locksmithing, Inc. Popp - PopP.com sher4110 - Sherwin- Williams Co. Notes 06/07/2013 Amount Date Cleared 70.30 05131/2013 10.10 05/31/2013 43.51 05/31/2013 95.99 05/31/2013 298.45 05/3112013 24,728.42 Amount 21, 835.00 - .4,941.00 26,776.00 Date Cleared 05/31/2013 05/31/2013 34 Date 5/31/13 Page 1 Primary Account @XXXXX @6464 Enclosures 24 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 Number ACCT @XXXXX @6464 Number of Images Statement Dates 5/01/13 thru 24 5/31/13 Account Previous Balance 77,688.00 Days in the Statement Period 31 2 Deposits /Credits 26,776.00 Average Ledger 87,089 22 Checks /Debits 24,728.42 Average Collected 85,918 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 79,735.58 *********************************************** * * * * * * * * * * * * * * ** * * * * * * * * * * * ** ** Deposits and Credits Amount Date Description 5/06 DDA REGULAR DEPOSIT 21,835.00 5 /10 DDA REGULAR DEPOSIT 4,941.00 Checks in serial order Date Check# Amount Date Check# Amount 5/01 1742 51 .92 5/15 1756 187.58 5/09 1746* 61.79 5/24 1757 31.18 5/06 1747 52.50 5/21 1758 438.49 5/07 1748 800.00 5/22 1759 34.38 5/03 1749 93.00 5/29 1760 576.00 5/17 1750 12,344.29 5/29 1761 332.50 5/16 1751 1,573.64 5/28 1762 70.30 5/14 1752 6,058.00 5/24 1763 10.10 5/15. 1753 1,435.10 5/29 1764 43.51 5/24 1754 103.85 5/29 1766* 95.99 5/17 1755 35.85 5/30 1767 298.45 * Indicates skip in check numbers IN Date 5/31/13 Page 2 Primary Account @XXXXX @6464 Enclosures 24 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Daily Date Balance Section Balance Date Balance Date Balance 5/01 77,636.08 5/14 97,346.79 5/24 81,152.33 5/03 77,543.08 5/15 95,724.11 5/28 81,082.03 5/06 99,325.58 5/16 94,150.47 5/29 80,034..03 5/07 98,525.58 5/17 81,770.33 5/30 79,735.58 5/09 98,463.79 5/21 81,331.84 5/10 103,404.79 5/22 81,297.46 * * * E N D O F S T A T E M E N T M Payment Summary Bank= 166opr AND mm /yy= 05/2013 - 05/2013 AND All Checks =Yes AND Include Voids =All Checks �1 Check Post Total Bank Check# Vendor Date Month Amount 166opr - Parkview Villa South 1746 home? - HD Supply Facilities Maintenance, Ltd. 05/01/2013 05/2013 61.79 166opr - Parkview Villa South 1747 kern - Kennedy & Graven, Chartered 05/01/2013 05/2013 52.50 166opr = Parkview Villa South 1748 kod - K.O. Cleaning and Restoration LLC 05/01/2013 05/2013 800.00 166opr - Parkview Villa South 1749 pet166hm - Heidi Mlndestrom 05/01/2013 05/2013 93.00 166opr- Parkview Villa South 1750 taxa - Anoka County 05/02/2013 05/2013 12,344.29 166opr - Parkview Villa South 1751 cent - CenterPoint Energy 05/07/2013 05/2013 1,573.64 166opr - Parkview Villa South 1752 chc - CommonBond Housing 05/07/2013 05/2013 6,058.00 166opr - Parkview Villa South 1753 colu - City of Columbia Heights 05/07/2013 05/2013 1,435.10 166opr - Parkview Villa South 1754 high8236 - High Profile Grounds Maintenance, it 05/07/2013 05/2013 103.85 166opr - Parkview Villa South 1755 home? - HD Supply Facilities Maintenance, Ltd. 05/07/2013 05/2013 35.85 166opr - Parkview Villa South 1756 twin - Twin City Garage Door Co. 05/07/2013 05/2013 187.58 166opr - Parkview Villa South 1757 eeil - Jennifer Fells 05/15/2013 05/2013 31.18 1660pr - Parkview Villa South 1758 kone - Kone Inc. 05/15/2013 05/2013 438.49 166opr - Parkview Villa South 1759 leve - Level One 05/15/2013 05/2013 34.38 166opr - Parkview Villa South 1760 all - All Inc. 05/21/2013 05/2013 576.00 166opr - Parkview Villa South 1761 bmmi - BMM Inc 05/21/2013 05/2013 332.50 166opr - Parkview Villa South 1762 buck8411 - Buckeye Cleaning Centers 05/21/2013 05/2013 70.30 166opr - Parkview Villa South 1763 chic - CommonBond Housing 05/21/2013 05/2013 10.10 166opr - Parkview Villa South 1764 dty4054 - City Wide Locksmithing, Inc. 05/21/2013 05/2013 43.51 166opr - Parkview Villa South 1765 comc3474 - Comcast 05/21/2013 05/2013 25.56 166opr - Parkview Villa South 1766 Popp - Popp.com 05/21/2013 05/2013 95.99 166opr - Parkview Villa South 1767 sher4110 - Sherwin - Williams Co. 05/21/2013 05/2013 298.45 166opr - Parkview Villa South 1768 fros - Laura Frost 05/29/2013 05/2013 13.93 166opr - Parkview Villa South 1768 fros - Laura Frost 05/31/2013 05/2013 (13.93) 166opr - Parkview Villa South 1769 multi - Multihousing Credit Control 05/29/2013 05/2013 145.00 166opr - Parkview Villa South 1770 offi8804 - Office Depot 05/29/2013 05/2013 60.09 166opr - Parkview Villa South 1771 xcel - Xcel Energy 05/29/2013 05/2013 1,493.11 26,400.26 �1 L J O U) 06 tf Z ro 3 m L Y 0) ro � d M S i O (0 M N O O N E N � J O l0 U } o N O N (0 N U LL `o J a c a X aW K 2 d U c ro m IM mlO) I ro 7 U a ro Q r _U O ` Z VI m ro U d 3 0 y O > U Y a a (D m N C N �O cf inrn 00 N O m C m m a N m o r c N N C C O N N n 0 N O N 00J � m r N N W d o m V a N n m m m m w L O U M j N C U O N Q N: 0 a in OUF s O N O m m m N N th r V N N �(�ON O W N m m O � O � M � O N N O C � � O N m O d rn L O Z mmv � j N C N U) O 0 N m d N J L 0 p a. u) 0 F- 34 0 M G (7 O m U U M M Q O N N 34 Parkview Villa North Financial Statement Overview June 2013 Revenue: Occupancy for the month of June was 100 % occupied; Rent Revenue was over budget (favorable) for June, due to increase in parking garage fees Total Revenue for June was under budget (unfavorable), however, we did not draw down the from the operating grant in June Administrative Expenses: Administrative costs for the North were under budget (favorable) Other Renting Expenses were under budget (favorable) Office Supply expenses were under budget ('favorable) Computer Equipment, Supplies and Maintenance was under budget (favorable) Legal Services was under budget (favorable) Misc. Admin Expenses was under budget (favorable) and reflects a correction to May expense Utilities: Utilities Expenses were under budget (favorable) Electric was under budget (favorable) and reflects quarterly billing Gas was under budget (favorable) and reflects quarterly billing Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) Operating and Maintenance Expense (supplies): Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract is under budget (favorable) Maintenance Supplies was under budget (favorable) Repairs Contract was under budget (favorable) Garbage and Trash was over budget (unfavorable); however, this is a quarterly billing Security Contract is under budget (favorable). Elevator Maintenance Contract is over budget (unfavorable) and reflects au invoice from March that was unpaid Heating, Cooling Maintenance and Repairs is over budget (unfavorable) and reflects the cost of Boiler motor and switch replacement Furniture and Fixtures was under budget (favorable) I my py v o m G g a < W _ � s N y' N N 1 Q T A T 0 W o 9 W m`m 3 c z 3 m m mG7 xl m c mO G) 0 on °� '� W A W W ry W m W V O W W M. @ 0 ET ET Tom w W C o R' s= m a W m m v'tnWm w 3 w w r r O � m N N 0 fWD N W O w O O O V 74 m. O PP O O S oV O O O O O A O O O O O O O O � N N (O A W O fD fD N O (h O N N W W w 0 W O m O O m O W W W V N W W W O W o J O O O O N w W N N W J O o O W W W V m W O W O O of moo rw o 0 o 0 0 0 0 0 0 io o m o 0 0 0 0 0 o V J w O W O O O O O O m 0 0 0 J fn N N W W N Y V N O V V V [WO W A O O N p ON O Qo bb 0 0 0 0 m O N O O O O �OJ � (p 4J IJ 0 01 0 0 �1 O N O m PP. p 0 S O O m N O 00 A 000 .OpA O oO 0 0 O O O O O O O O 0 0 0 0 my py v o m G g a < W _ � s N y' N N 1 A P A A A W WSW N N m mm O N N N p 0 b 0 w W m w A (P N OI Ut N N fT m N N m m (p A? o tp W Ol N N J D7 N N O (O V N W Ol W N� O O W N V O V O O O O b 3 mm(n v oAm dro w ,' oo p _ mom x90 ° "p2m7m �� . Lw ?1v pa_ m N m m pm° ag� m d va pmm' myLn y � mo � E m a a c� wm pwm m NQ 0 A O] ()o 00 9 Vi.o 0 o g_ c o m ,0 o m 'm p m o _ m'm pDO i e °ca,x m o m» w m w ?N , 3 m N N O W W O wl O O O O (A� O O O W O O O o N N A O o A .00 N O O A m W w0-+P A AtNO N W OJ O m W O N A OI Ol O N O J V w O O J V J Nml O LA m0 m wNfA�N A t m O 0 O (P N OJ A O W V W O V O O N V W O V O A m O O O Z (Om O P O (O o J A O O O D (O tOm V 00 O Nm OO N tD OJi N O N J O m N pp N OOi m A O (AT m O A O t 0 w W mcw m m A O N W W J O O] W -+m 001 O p m N O O O p O p N J o N W W OOO i N O O N O O p N N W p 0 N N N N Op W p N N N Nm N AJNJO N N V A m m N A O w O m N 9) p W > > W i p � m O m ' pm -` �mA00 mw: ON $i mw m W A N m W J m O W m W o O N O SIN O N N O o O O O m O W O A 00 m O O 00. O O m O m pp '0 00 O 00000 000 00 0O O O O O O o 000 O O W W O P N 00 O O (WO -0 A O O O W A N (O O W W Ot N w p w w w N � W V t0 O 0 m m N m fD m A (O (p fP N W N %pmwmp OOOWi (WO NO W N N J m O (11 !J V O V N A W 0 W m W m A N m m o n N m O A (O V (OpmOtO IOA NN m p m m m (J N m W m pippp UN IJ W V N P. WWA A O O (m0 W W W N m N O A W N V O m m O N V M m W 0 J m A mo pumi Np N O o O O p O O O O O W m I o 6. w AO NJw VD W W WO m o O N N V m w ° 0 0 A m p W OO inZ � (iJ M.0 N m O D N O O N � A N W W O O A m OW O O V W W O V W m I o 6. w I AO NJw pl W Jm N N V m w N O O 00 A �Z W OO inZ � (iJ M.0 A p m m O D N O O N N W (p O V o pJ mp 0 N J ? 9) 0 000 Jm i W O W W m W N p�ppp N0 p N N J (O O N V o N A .AAp W W O W O O N I m y U3 v v ` go t c O z w9 y y' u m m i Jm N N V O N w N N inZ o0two A A p m P w D o a o m N m O 00 0 000 O p pp m y U3 v v ` go t c O z w9 y y' u m m i 0 0 o OwO °V'O.3 mmo o § a -g-.g 3 � m ajd K.n 30 °.� mn = m m $ m 52 g c $ IK a> j0. c o N m o m �i ply o, �N �N m.oc NN 0 1 $O A A N ON N A OONO�I I NN O � NAw�I (�pp (tpO W O O I� NfNii OPI wJ W W t0 O� N co O W W w O J w IO O W. N I I N N�p � (JI fP V UNi O J 00 O O I 00 Ol IWD A O O A OpJJ d I O O (WO (JO N W JA N N N AO N N �tNO t00 .p W W O] OJ O fll w O O O 0 W W fWD tW0 .P W N O w m O N NN P N N N (JT V N V J N Om N r N �O m pO� 0106 N 0 0 p q pWD O O N W A N O O o O N �o m (� pr v .api wN N N O Am N g o bo N (p 6 A m m N U1 O N� N O V W O N W w Op O W L] A A O AID N W O tD V �o O N v N O W O <1 t W A N o W V n n' a N N ONI A A W O W pV j OAON ceN 00 N O N m,P OA W OOON o O p C O O O O O O 0000 z w 80. O O O O O 0 o O O O O o 0 m� OOv a 0 0 z af w� w N. m 7 N `� 5 o f0 OWO N V OI O W so v D c !- 9 E m ?Z N m f0 O W W (D O PO o' n C w � 4> fJ U � H mN Z N p C� 0 R^ W O S m W V O 'o W V O O a� r� �NRN T 6 'C 5� N q$ N Q. w O_ mI 031 w (O� W OI 9 WIm m H O 0 V T O O 6T -1 c a v' 90 o. w 0 N � N j IN, J J W W W W J J m (� W W W QO O d O N mw $i m o w tJ N mm {o 0 1J N OHIO N N O O O O O o w v p7 'u 8 d � Y " N i o u� m- N. m S d0 o f �f Parkview Villa -North (165) Balance Sheet June 2013 Books = ACCrU81 Jun -13 Assets 22,032.26 10100 Cash Balance 871.00 10200 Petty Cash 891,214.11 10400 Investments 2,158.99 11300 Rent Receivable 212.12 11500 Accounts Receivable 0.00 13200 Due From Other Government Units 916,488.48 Total Assets Liabilities 15,513.79 20200 Accounts Payable 10,450.50 20210 Accrued Other Expenses 551.74 20220 Due to Resident Council - 18,450.78 22000 Deposits - 12,162.90 22200 Accrued PILOT 614.60 22210 Revenue Collected in Advance 57,744.31 Total Liabilities Fund Balance 858,744.17 25300 Fund Balance 858,744.17 Total Fund Balance 916,488.48 Total Liabilities and Fund Balance 1 7/8/2013 3:22 PM Parkview Villa -North (165) Income Statement For The Period Ending June 2013 Books = Accrual % Year to Date Month to Date Revenue - 0.00% 11,450.91 5.76% 33160.46330 Federal Grant 30,621.00 97.13% 180,974.00 91.02% 36220 -46330 Gen. Government Rents 396.00 1.26% 2,541.00 1.28% 36225 -46330 Nondwelling Rents 508.60 1.61% 3,750.49 - 1.89% 36290 -46330 Other Miscellaneous Revenue - 0.00% 105.00 0.05% 39120 -46330 Recovery Damage City Property 31,525.60 100.00% 198,821.40 100.000/0 Total Revenue Expenses Personal Services 8,752.00 27.769/b 52,512.00 26.41% 1000 -46330 Accrued Salaries 8,752.00 27.76% 52,512.00 26.41% Total Personal Services Supplies 58.84 0.19% 947.17 0.48 % 2000 -46330 Office SupPlles Office 0.00 0.00% 615.13 0.31% 2010 -46330 Minor Equipment 2160 -46330 Maint. &Construct Materials 441.69 1.40% 3,248.31 1.63% 298.45 0.95% 811.10 0.41% 2171 -46330 General Supplies 798.98 2.53% 5,621.71 Total Supplies Other Services & Charges 0.00 0.00% 3,740.95 1.88% 3040 -46330 Legal Fees 0.00 0.00% 0.00 0.00% 3050 -46330 Expert and Professional Services 4,772.00 15.14% 28,632.00 14.40% 3060 -46330 Management Services 130.24 0.41% 2,145.89 1.08% 3100 -46330 Protective Services 356.91 1.13°7° 2,086.68 1.05% 3210 -96330 Telephone &Telegraph 0.00 0.000/0 65.00 0,03% 3430 -46330 Advertising Other 1,817.14 5,76% 10,525.89 5.29% 3600 -46330 Insurance & Bonds 3,799.51 12.05% 17,731.29 8.92% 3810 -46330 Electric 312.71 0.99% 2,240.78 1.13% 3820 -46330 Water 1,134.89 3.60% 22,558.60 11.35% 3830 -46330 Gas 0.00 0.00% 3,665.33 1.84% 3840 -46330 Refuse 0.00 0,00% 1,070.04 0.54% 33501V6330 Sewer 3,429.76 10.88% 28,272.35 14.22% 4000 -46330 Repair & Malnt. Services 50.00 0.160/0 557.31 0.28% 4100 -46330 Rents &Leases 0.00 0.00% 0.00 0.00% 4300 -46330 Miscellaneous Charges 2,027.15 6.43% 12,708.06 6.39% 4315 -46330 PILOT 0.00 0.00% 1,243.38 0.63% 4390 -46330 Taxes &Licenses -31.28 -0.10% 1,167.56 0.S9% 4500 -96330 Administrative Expenses 13.77 0.04% 84.31 0.04% 4850 -46330 Interest on Deposits 17,812.80 56.50% 138,495.42 69.66% Total Other Services &Charges Page 1 of 2 I 7/812013 3:22 PM Capital Outlay 0.00% 1,839.76 0.93% 5120 -46330 Building & Improvements 0.00 1,839.76 0.93% 0.00 0.00 0 /° Total Capital Outlay 27,363.78 86.80% - 198,468.89 99.82% Total Expense 4,161.82 13.20% 352.51 0.18% Excess (Deficit) Revenue over Expense Page 2 of 2 71812013 3:23 PM Parkvieoi Villa -North (165) Cash Flow Statement Period = June 2013 Book = Accrual Month to Date Revenue 0.00 33160 Federal Grant 30,621.00 36220 Gen. Government Rents 396:00 36225 Nondwelling Rents 508.60 36290 Other Miscellaneous Revenue 0.00 39120 Recovery Damage City Property 31,525.60 Total Revenue Expenses Personnel Services - 8,752.00 1000 Accrued Salaries 8,752.00 Total Personnel Services Supplies 58.84 2000 office Supplies 0.00 2010 Minor Equipment 0.00 2160 Maint. & Construct Materials 740.14 2171 General Supplies 0.00 2280 Vehicle Parts 798,98 Total Supplies Other Services & Charges 0.00 3040 Legal Fees 0.00 3050 Expert & Professional Services 4,772.00 3060 Management Services 130.24 3100 Protective Services 356.91 3210 Telephone & Telegraph 0.00 3430 Advertising Other 1,817.14 3600 Insurance & Bonds 3,799.51 3810 Electric 312.71 3820 Water 1,134.89 3830 Gas 0.00 3840 Refuse 0.00 3850 Sewer 3,429.76 4000 Repair & Maint. Services 0.00 4050 Garage, Labor Burd. 50.00 4100 Rent & Leases 0.00 4300 Miscellaneous Charges 2,027.15 4315 PILOT 0.00 4390 Taxes & Licenses - _31.28 4500 Administrative Expenses 13.77 4850 Interest on Deposits 0.00 5120 Building & Improvement 17,812.80 Total Other Services & Charges 27,363.78 Total Expenses 4,161.82 Excess (Deficit) Revenue over Expenses Page 1 of 2 ' 0 Parkview Villa- tiorth (165) Cash Flow Statement Period = June 2013 Book = Accrual Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 13200 Due From Other Government Units 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expenses 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash 7/812013 3:23 PM Month to Date 0.00 0.00 - 365.79 23.00 0.00 0.00 - 3,688.46 1,741.75 - 210.74 2,027.15 - 414.00 (887.09) 3,274.73 Beg Cash End Cash Difference 18,757.53 22,032.26 3,274.73 871.00 871.00 - 891,214.11 891,214.11 ' 910,842.64 914,117.37 3,274.73 Page 2of2 7/8/2013 3:21 PM 1 Parkview Villa -North (165) General Ledger Period = Jun 2013 Book = Accrual; Tree = ysl_tb Property : Date Contra] Person /Description _. Reference - Debit Credit- Balance Remarks 43,760A0 = Beginning Balance = 1000 -46330 Accrued Sala rtes 8,]52.00 0.00 165 6/30/2013 :Post Recurring Monthly recurring enb 3- 165939 RC 522512.00 =/E ding Balance = ' Net Change. 8,]52.00 888.33 = Beginning Balance = 2000 -46330 Office Supplies 42.67 0.00 931.00 cups /candy 165 6/8/2013 Office Depot(CM8804) P- 338042 6.61371E +11 0.00 947.17 Coffee /pens,maistener, envelop( 165 - 6 /30 /2013 office Depot (m,8804) P- 338044 6.6137E+11 16.17 947.17 = Ending Balance = Net Change =58.84 615.13 = Beginning Balance = 2010-46330 minor Equipment 615.13 = Ending Balance = Net Chenge=0.00 2,806.62 = Beginning Balance = 2010 -46330 Maint. & Construct Materials 111.48 0.00 2,918.10 malnt supplies 165 5/8/2013 Home Depot Credit Services (home9( P- 336165 6190946 0.00 2,952.41 maint supplies 165 5/23/2013 Home Depot Credit Services (home9[ P- 336160 1193117 34.31 2,956.33 distilled water gallon 165 6/3/2013 Frattalone's /Metro Ace (frat) P- 336384 015212R 3.92 0.00 iVAC /Plu Balance 165 617/2013 HD Supply Facilities Maintenance, Ltd P- 337172 9122796676 291.98 0.00 3 ,248.31 = Net Change= 441.69 . 512.65 = Beginning Balance = 2171 -46330 General Supplies 298.45 0.00 811.10 paint 165 6/13/2013 Sherwin- Wllllams Co.(sher4110) P- 337661 58190 811.10 = Ending Balance = Net Change= 298.45 31740.95 = Beginning Balance = 3040-46330 Legal Fees 3,740.95 = Ending Balance = Net Change =0.00 23,860.00 = Beginning Balance = 3060 -46330 Management Services 338992 06/15/13- 06/27/1 13,524.00 0.00 37,309.00 163575 mgmt fees 06/13 165 6/27/2013 CammonBOntl Housing (cm) P- 0.00 8,752.00 28,632.00 R/C CHC PR Mgmt Fee 165 6/30/2013 :Post Recurring Monthly recurring can I- 165939 RC 28,632.00 = Ending Balance = Net Change = 41772.00 21015.65 = Beginning Balance = 3100-46330 Protective Services 130.24 0.00 smvlce supplies 165 6/7/2013 Wellington Security Systems (well4) P- 338414 104988 2 145.89 Ending Net Change = 130.24 1,729.77 = Beginning Balance = 3210-46330 Telephone &Telegraph 223.50 0100 1,953.27 phone 06/13 165 5/31/2013 Popp.cam (poppy P- 337561 992110809 0.00 2,029.79 malnt plan /roll over pin # 06/1 165 6/1/2013 Level One (/eve) P- 335804 0325059IN 76.52 0.00 2,086.68 Internet 06 /11- 07/10/13 165 6/2/2013 Comcast(comc3474) P- 337524 877210505019611 56.89 2,086.68 = Ending Balance = Net Change= 356.91 65.00 = Beginning Balance = 3430 -46330 Advertising Other 65.00 = Ending Balance = Net Change =0.00 81708.75 = Beginning Balance = 3600 -46330 Insurance Bands 75.39 0.00 8,784.14 Directly Expense Come 1 165 6/26/2013 Directly Expense Yearly Crime Insum ]- 16]081 a hts Ins Aarl 0.00 ight, 165 6/30/2013 :PostRecurring Monthly recurring enb 1- 165939 RC RC 1,]41.75 100525.89 C Ending Balance Net Change= 1,817.14 13,931.78 = Beginning Balance = 3810-46330 Electric P- 338232 5150941553 06 /1 3,799.51 0.00 17,731.29 a OS /06- 06/05/13 165 6/11/2013 Xcel Energy (x<el) 17,731.29 = Ending Balance = Net Change = 3,799.51 1,928.07 = Beginning Balance = 3820 -46330 5/20/2013 Water City of Columbia Heights (Coiu) P- 335669 31802450001 05/: 189.61 0.00 2,117.68 late fee 165 5/20/2013 City of Columbia Heights (Col.) P- 335670 31802500001 05/: 123.10 fee 0100 2,224400.78 IatEnding 165 Balance = Net Change =312.71 21,423.71 = Beginning Balance = 3830 -46330 Gas Energy (Cent) P- 337781 55199657 06/06/1 1,134.89 0.00 9 /landing 5/ -066/04/13 165 6/6/2013 CenterPoint 22 558.60 Net Change = 1,134.89 3,665.33 = Beginning Balance = 3840-46330 Refuse 3,665.33 = Ending Balance = Net Change =0.00 - - 1,070.04 = Beginning Balance = 3850 -46330 Sewer 11070.04 = Ending Balance = Net Change =0.00 24,842.59 = Beginning Balance = 4000 -46330 Repair & Malnt. Services 700.01 0.00 25,592.60 Maint Coverage 03/13 165 3/1/2013 Kone Inc.(kone) P- 336752 221125731 0lc 106/13 165 5/6/2013 Adam's Pest Control, Inc. (adam) P- 338083 798410 0.00 25,85].01 Monthly services 165 5/22/ ?013 All Metro Lawn & Snow, LTC (a11m213 P- 337217 2435 26250 contract 165 5124/2013 Stanley Access Tecchnologles LLC (st. P- 336280 902737530 18&71 wn care /debris tlispi 26,457.56 Contract/Lawn 165 5/31/2013 All Metro Lawn & Snow, LLC (alim2l_' P- 337216 2455 411.84 0.00 Page 6 of 7 1 Parkvlew Villa -North (165) General Ledger Period = Jun 2013 nk = Accrual: Tree = vsl_ Property - Date Person /Description Control Reference. 165 5/31/2013 Case (case701) P- 337892 24348 165 5/31/2013 LBP Mechanical, Inc(lbpm) P- 337218 W18712 165 5/31/2013 LBP Mechanical, Inc(lbpm) P- 337218 W18712 165 5/31/2013 LBP Mechanical, Inc (ibpm) P- 337218 W18712 165 611/2013 Kong Inc. (pone) P- 337215 221196368 165 6/10/2013 K.O. Cleaning and Restoration LLC (k P- 337868 1450 165 6/19/2013 Adam's Pest Control, Inc. (adam) P- 338175 805548 Net Change = 3,429.76 4100 -46330 Rents & Leases 165 5131/2013 Multihousing Credit Control (multl) P -337289 13050412 Net Change =50.00 4315 -46330 PILOT 165 6/30/2013 :PostRecurring Monthly recurring enbl- 165939 RC Net Change = 21027.15 4390 -46330 Taxes & Licenses Net Change =0.00 4500 -46330 Administrative Expenses 165 3119/2013 Doreen lablonske (Jabl) P- 336344 31913165 165 6/3/2013 Laura Frost (fros) P- 335629 050713- 335629 165 6/312013 Laura Frost(fros) P- 335629 050713- 335629 165 6/3/2013 Laura Frost(fros) P- 335629 050713- 335629 165 6/14/2013 Doreen lablonske(jabl) P- 337373 031913165 -33737 Net Change = -31.28 4850 -46330 Interest on Deposits 165 6/30/2013 Sec Lop interest accrual )- 167082 G12 Net Change =13.77 5120 -46330 Building & Improvement Net Change =0.00 Page 7 of Debit Credit 202.55 0.00 135.32 0.00 630.00 0.00 55.00 0.00 700.01 0.00 40.00 0.00 51.91 0.00 50.00 0.00 2,027.15 0.00 230.52 0.00 0.00 31.28 31.28 0.00 0.00 31.28 0.00 230.52 13.77 0.00 36,408.86 9,045.08 7/812013 3:21 PM Balance Remarks 26,660.11 repair bank equip /alarms panel 26,795.43 Materials 05/15- 05/29/13 27,425.43 Labor 05 /15- 05/29/13 27,480.43 Travel 05/15- 05/29/13 28,180.44 maintenance 06/01- 06/30/13 28,220.44 repair bthrm walls /touch up eni 28,272.35 ca prevent plus 06/19/13 28,272.35 = Ending Balance = 507.31 = Beginning Balance = 557.31 residential screening 05/13 557.31 = Ending Balance = 10,680.91 = Beginning Balance = 12,708.06 Anoka Cty Property Tax Accrue 12,708.06 = Ending Balance = 1,243.38 = Beginning Balance = 1,243.38 = Ending Balance = 1,198.84 = Beginning Balance = 1,429.36 mileage 2/27- 3/19/13 1,398.08 exp reimburse 5/7/13 11429.36 exp reimburse 517/13 1,398.08 exp reimburse 5/7/13 1,167.56 mileage 2/27 - 3/19/13 1,167.56 = Ending Balance = 70.54 = Beginning Balance = 84.31 Sec Dep Interest accrual 84.31 = Ending Balance = 11839.76 = Beginning Balance = 1,839.76 = Ending Balance = Parkview Villa North 07102/2013 Bank Reconciliation Report 06/30/2013 5016456 Balance Per Bank Statement as of 06/30/2013 26,728.94 Outstanding Checks Check date Check number Payee Amount 06118/2013 2128 10004007 - Sharp 81.70 06/25/2013 2129 adam - Adam's Pest Control, Inc. 103.82 06/25/2013 2130 case701 - Case 202.55 06/25/2013 2131 comc3474 - Comcast 56.89 06/2512013 2132 kocl - K.O. Cleaning and Restoration LLC 40.00 06/25/2013 2133 Popp - Popp.com 223.50 06/25/2013 - 2134 stan0371 - Stanley Access Tecchnologies LLC 188.71 06/2512013 2135 xcel - Xcel Energy 3,799.51 Less: Outstanding Checks 4,696.68 06/0412013 2113 Reconciled Bank Balance 22,032.26 Balance per GL as of 06/30/2013 22,032.26 Reconciled Balance Per G/L 22,032.26 Difference (Reconciled Bank Balance And Reconciled Balance Per G /L) 0.00 Cleared Items : Cleared Checks Date Tran # Notes Amount Date Cleared 05/21/2013 2101 comc3474 - Comcast 56.89 06/30/2013 05121/2013 2102 dire - Direct Home Appliance Services 240.41 06/30/2013 05/29/2013 2107 c &dc - C & D Communications, Inc. 149.76 06/30/2013 05/29/2013 2108 dire - Direct Home Appliance Services 134.71 06/30/2013 0512912013 2109 drai7740 -- Drain King, Inc. 135.00 06/30/2013 05/29/2013 2111 offi8804 - Office Depot 133.76 06/30/2013 05/2912013 2112 xcel - Xcel Energy 3,848.58 06/3012013 06/0412013 2113 cent - CenterPoint Energy 4,044.00 06/30/2013 06/04/2013 2114 frat - Frattalone's /Metro Ace - 7.00 06130/2013 2115 kocl - K.O. Cleaning and Restoration LLC 900.00 06/30/2013 06104/2013 2116 Ibpm - LBP Mechanical, Inc 447.70 06/30/2013 06/04/2013 06/1112013 2117 chc - CommonBond Housing 13,555.28 06/30/2013 06111/2013 2118 colu - City of Columbia Heights 312.71 06/3012013 Cleared Checks Date Tran # 06/11/2013 2119 06/11/2013 2120 06/11/2013 2121 06/18/2013 2122 06118/2013 - 2123 06/18/2013 2124 06118/2013 2125 06118/2013 2126 06/18/2013 2127 Total Cleared Checks Cleared Deposits Date Tran # 06/03/2013 494 06/06/2013 495 06/18/2013 496 Total Cleared Deposits Parkview Villa North 07 /0212013 Bank Reconciliation Report 06/30/2013 5016456 Notes Amount Date Cleared frat - Frattalone's /Metro Ace 3.92 06/30/2013 home7 - HD Supply Facilities Maintenance, Ltd. 174.23 06/30/2013 leve - Level One 76.52 06/3012013 allm2138 - All Metro Lawn & Snow, LLC 674.34 06/30/2013 home9055 - Home Depot Credit Services 145.79 06/30/2013 kone - Kone Inc. 1,400.02 06130/2013 Ibpm - LBP Mechanical, Inc 820.32 06/30/2013 multi - Multihousing Credit Control 50.00 06/3012013 offi8804 - Office Depot 42.76 06/30/2013 27,353.70 Notes Amount Date Cleared 19,831.00 06/30/2013 10,065.00 06/30/2013 730.00 06/30/2013 30,626.00 I,� Date 6/28/13 Page 1 Primary Account @XXXXX @6456 Enclosures 25 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 @XXXXX @6456 Number of Images Statement Dates 6/01/13 thru 25 6/30/13 Account Number Previous Balance 23,456.64 Days in the Statement Period 30 34,580 3 Deposits /Credits 30,626.00 Average Ledger Collected 33,576 22 Checks /Debits 27,353.70 Average Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 26,728.94 *********************************************** * ** * * * * * * * * * * * * * * * * * * * * * * * * * * ** Deposits and credits Amount Date Description 6/03 DDA REGULAR DEPOSIT 19,831.00 6/06 DDA REGULAR DEPOSIT 10,065.00 730.00 6/18 DDA REGULAR DEPOSIT Checks in serial order Check# Amount Date Check# Amount Date 6/03 2101 56.89 6/14 2117 13,555.28 312.792 6/03 2102 240.41 6/17 2118 6/06 2107* 149.76 134.71 6/18 2119 6/18 2120 174.23 6/10 2108 6/05 2109 135.00 6/18 2121 76.52 674.34 6/05 2111* 133.76 3,848.58 6/25 2122 6/24 2123 145.79 6/04 2112 6/11 2113 4,044.00 6/25 2124 1,8020.032 6/10 2114 7.00 6/25 2125 6/25 2126 50.00 6/20 2115 900.00 447.70 6/27 2127 42.76 6111 .2116 * Indicates skip in check numbers M Date 6/28/13 Page 2 Primary Account @XXXXX @6456 Enclosures 25 NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6456 (Continued) Daily Date Balance Section Balance Date Balance Date Balance 6/01 23,456.64 6/10 48,646.53 6/20 6/24 29,862.17 29,716.38 6/03 6/04 42,990.34 39,141.76 6/11 6/14 44,154.83 30,599.55 6/25 26,771.70 6/05 38,873.00 6/17 30,286.84 6/27 26,728.94 6/06 48,788.24 6/18 30,762.17 * * * E N D O F S T A T E M E N T �11 Payment Summary Bank= 165opr AND mm /yy= 06/2013- 06/2013 AND All Checks—Yes AND Include Voids =All Checks Check Post Total Bank Check# Vendor Date Month Amount_ i65oFir - Parkview Villa North 2113 cent - CeuterPmnt Energy 06/04/2013 06/2013 4,044.00 165opr - Parkview Villa North 2114 frat - Fratta lone's/ Metro Ace 06/04/2013 06/2013 7.00 165opr - Parkview Villa North 2115 keel - K.O. Cleaning and Restoration LLC 06/04/2013 06/2013 900.00 165opr - Parkview Villa North 2116 Ibpm -LBP Mechanical, Inc 06/04/2013 06/2013 447.70 165opr - Parkview Villa North 2117 cm: - Commoneond Housing 06/11/2013 06/2013 13,555.28 1650pr - Parkview Villa North 2118 colu - City of Columbia Heights 06/11/2013 06/2013 312.71 1 165opr - Parkview Villa North 2119 frat - Frattalone's /Metro Ace 06/11/2013 06/2013 3.92 165opr - Parkview Villa North 2120 home] - HD Supply Facilities Maintenance, Ltd. 06/11/2013 06/2013 174.23 165opr - Parkview Villa North 2121 leve -Lever One 06/11/2013 06/2013 76.52 165opr - Parkview Villa North 2122 allm2138 - All Metro Lawn & Snow, LLC 06/18/2013 06/2013 674.34 165opr - Parkview Villa North 2123 home9055 - Home Depot Credit Services 06/18/2013 06/2013 145.79 1650pr - Parkview Villa North 2124 kone - Kone Inc. 06/18/2013 06/2013 1,400.02 165opr - Parkview Villa North 2125 Ibpm - LBP Mechanical, Inc 06/18/2013 06/2013 820.32 165opr - Parkview Villa North 2126 multl - Multihousing Credit Control 06/18/2013 06/2013 50.00 1650pr - Parkview Villa North 2127 offi8804 - Office Depot 06/18/2013 06/2013 4276 165opr - Parkview Villa North 2128 t0004007 - Sharp 06/18/2013 06/2013 81.70 165opr - Parkview Villa North 2129 adam - Adam's Pest Control, Inc. 06/25/2013 06/2013 103.82 165opr - Parkview Villa North 2130 case701 -Case 06/25/2013 06/2013 202.55 165opr - Parkview Villa North 2131 comc3474 - Comcast 06/25/2013 06/2013 56.89 165opr - Parkview Villa North 2132 keel - K.O. Cleaning and Restoration LLC 06/25/2013 06/2013 40.00 06/25/2013 06/2013 223.50 165opr - Parkview Villa North 2133 Popp - Popp.com 06/25/2013 06/2013 188.71 1650pr - Parkview Villa North 2134 stan0371 - Stanley Access Tecchnologies LLC 165opr - Parkview Villa North 2135 xcel - Xcel Energy 06/25/2013 06/2013 3,799.51 27,351.27 Parlkview Villa South Financial Statement Oveiview Jane 2013 Revenue: Occupancy for the month of June was 82% occupied Total Revenue was lower than budget amount (unfavorable) this is due to vacancy Administrative Expenses: Administrative costs for South are under budget (favorable). Advertising costs were under budget (favorable) Other renting expenses were over budget (unfavorable) and reflect the cost of background screenings for applicants Office Supplies was under budget (favorable) Telephone, Answering Service and Internet expenses were under budget (favorable) Misc. Admin Expenses is under budget (favorable) and reflects a correction from May Utilities: Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing Electric was slightly over budget (unfavorable) and reflects a quarterly billing Gas was under budget (favorable) Water was under budget (favorable) and reflects a quarterly billing Sewer was under budget (favorable) and reflects a quarterly billing Operating and Maintenance Expense Operating and Maintenance Expenses were under budget (favorable). Exterminating Contract was under budget (favorable) 11 Maintenance Supplies was under budget (favorable) Garbage and Trash Removal were under budget (favorable); however this is a quarterly billing. Repairs Contract was under budget (favorable) Heating and Cooling Maint and Repairs was over budget (unfavorable) and reflects costs of zone valve replacement and repairing leaks in South Community room Furniture and Fixtures was over budget (unfavorable) and reflects the cost of electric dryer m m m m m m m m m (� m f[1 m c m .0 T N 0 � T( o o m W W W NNNO O Op (O cU C0 m m W rD O lmU O O W V O O m J o .02 � O n m = A Z f 3 m m� c y m Z 'm 'm n G�mQmD N 'OZ m o0i m pmm on m m (Cfi 00i @$ N' m c 3 m m= m a m e m .T m m eu m 0 m- m m a4� g. 8 m B 3 �a sm�n 0 o mm X $ S S m � m y N °m o O N ➢ W o ON1N 000 O A O O O O p W O O O O W N (O N N m W O 0 m W O N V (11 O W N O V N O O O O V pp O N O O O O W A tNO 0A1 m O N (1 B O O o O O O O N O m O O O m W N I J i n N J P. p V W P N A V O N O O W O O m W 0 W W OP. O O V O O O O O U J N f n ONO N O N m O V O 000 m O A O O ow N V O A W m J O O N ? O N O O N O O O O N N A A O O O O O O O O O N N O W O N V O N N tNii m °O m o S m Z O O gwD o0 °o O O O O O o im N NOO U O O ONO W O A O O N O O N O W O W i Z N O m m D w 0 Nq W w j O O O $oo 0 G CC N m � � v + N m m m (O O J O O O O O 7 Z W m m m N NT W J m PO A O W A m Om w o w G CC O m N N w o 7 Z W V N w J D j j A m N W W W O O W N V V N A m m i W N Np W fNO .Np Im p Z zo m m m D m W O w m fT N [O W IV p ? pp A W O m m O O O O O m�u p7 v y n N r n O.m w V 3 ry l a m , mom rn� W rn W W W rn rn rn rn rn W rn rn rn W w w W W W W N N N N N N N N N N N N N N (p 10 W rn N? N W A A A A P W W W N N � rn W N i 0 10j N J O J o O O O p m w N m m m 3 C -1 °m 0 :. v ,'� - m > > m .L. �rnG1 m �d �N� ' mm c� m Omv(nm4�w -G�3m m m m m w m vi T m omoom omm G) E mam v 'Q 0 2 NN.M oxN�,. d Ro10 m Wm o N m m eZ m 5 Q° d C EH C Lq� m w K m i'o m,or� 3 m�51E: 0 rno Ro m Ow %w = c, o nwtw °< mo � 3. �v=o @ rmn� wa 0 N N m D �', m'^ - ni o of 0, n(7� m0N �-°o0 10 3 m a w J rn O N N O O O rn (O N O W O A N O O 100 (O (00 V W rn 000 O 0 0 O 0 0 f 0 0 (1 N boo 0 0 � OO N N 1W0 W] W m 0 0 0 O O O O O J O- O N A O O o m W v ° u a o ,z Nrt 0 0 w � d 7. w i O N O A N rn W W N O O V V J W V O V (C W J W N W J A (Wl� -` 10 V O W N O N W W G O o O O O N O W O w �rn A V A O W W w O O O O O O O O O O V O O N W W W �.+ O O V O N V J A N N N O V w W III) O O A O O N N O W W O O O O O P N O W O W Moo W N m O W W W�0 0 V V J N A Now W W 10 O W N A O V O i m j O W W W J J O Oe AOON � O O Z W W N o O A N rn O (0 V �p O o IJ p p W J IJ O I V O UJ O ow" O W O N N O (T J N o O D W A rn V O N W N f W NW ' t0 JiDQ VAAJ� m Q N N T <0 W O O N o rn 0 O N N O O W t0 O W N O O O W O W W N O N W O N wi� W O AlJO Q1 O W A ll1 O N N O O N N t� N (A0 A 6 N O O O A J N V W NN V O O "op 10 10 p<0 00000 N O 00 V N O O N O o t O (0 O O O O p W p W W W I r a O 66 f l 1 O? N N N N N o N O N W W co o 0 0 0 O N� N N N N W N N W N N W J N m N N O N rn � N O w W W m W V V N J N y (O N V W y O N W W rn W W N W N N rn O W (0 l0 w a J 'O to W m AW W OBI ?NN AtOA (001 W low A W W N A fAO t0 W N N W W N N W N �p N J N J W i0 0)N�wlO J W O O(O O O N W JN V O W O (0 N O N N W W w A N w W V W -I O N v 00� W b m N [0 wq N A W N N W (T O N W N Woo A 0 00 W W rn W A A 0 0 N ]a p O p O O W 0 O O W lO J N N O O N N N N P O O (T 00 O O 00 W 00000 p N N N o O G 0000 /1 �U No O D O 00 00 N O 000 00000 000 00 00000 O O O O O N o O Oo00 N w O O O O O O O O O O O O O O O W N a N J m O W Ol c2 0 °W N Y N tNO NW A r 3�m� iX 0� 3 YF 'i Imo�N� pe 90 yxm0(O py3j 9 m O �p 5 7 N NN njn V w0 Q m I� (/� N 3 °�. m m U n N c pp N N w N N N i➢ i f N N O V O O o W OW N N pWp� O W A (N� j p p J W A A (O o tW0 N A ONO f� I FO O W W W A N W W W o N 4f 0p Ul w 0 0� W w W J N w A V J N N w o 0�,,.. W ° u a o O m o " W W fli O V N W O W O O O pO 1O0 O O A ou N J W Wp oo0 p° O N N W W W O (((( pWp + N N W W 91 :,4 w °ppp °W w N N D w WWI 0 0 W lD p 00 W O W N N t0 W W i� yq f N W � I op N W W w J of O o y ` NN m tll fn y 'U � N p O Op N o N 0 000u a p p °o 0 0 0 0 0 o of ➢ o tWO �W{pp TWtOp WG A ? � A o (O 00 N J N O W 0 1�nn 66ii O 7X� m �31 z $ 3 A R' ma a � N � �I �I ehl OI O W W N O WI V O O O O O W N O O W N C O S O A O O m' W WIO W m N O OIO O N N O O N W c s. w ail a , N N 3 i, PIP O O N N 10 t0 y� tP V v N N i� to mm V SIO O O 0 0 J J O N O O O O O O N N W J J NN UN W O O 0 O N N O O O O O O O 00 A W W p N N (P O O O O O O O O O O O O O O N�Wv °.oaF y n � w n '/ Parkview Villa South (166) Balance June 2013 Books = Accrual Jun -13 Assets 10100 Cash Balance 88,188.93 10200 Petty Cash 279.00 10400 Investments 729,970.36 11300 Rent Receivable 3,911.11 11500 Accounts Receivable 60.63 Total Assets 822,410.03 Liabilities 20200 Accounts Payable 7,704.06 20210 Accrued Other Expenses 5,047.50 22000 Deposits 8,373.13 22200 Accred PILOT 6,172.14 22210 Revenue Collected in Advance 443.00 Total Liabilities 27,739.83 Fund Balance 25300 Fund Balance 794,670.20 Total Fund Balance 794,670.20 Total Liabilities and Fund Balance 822,410.03 �r v Parkview Villa -South (166) 26.43 0.10% 241.05 0.17% 2010 -46390 Minor Equipment Income Statement 3.17% 1,433.32 1.00% 2160 -46340 Maint. & Construct Materials 0.00 For The Period Ending June 2013 0.00 0.00% 2171 -46340 General Supplies 214.02 0.84% Books = Accrual 1.20% Total Supplies 1,047.84 - 4.12% 3,392.20 2.36% Month to Date % Year to Dale Telephone & Telegraph Revenue 0.63% 932.89 0.65% 3430 -46340 36220 -46340 Gen. Government Rents 24,787.40 0.00% 97.47% 139,071.53 96.83% 36225 -46340 Nondwelling Rents 429.00 882.14 1.69% 2,785.00 1.94% 36290 -46340 Other Miscellaneous Revenue 214.00 Electric 0.84% 1,760.70 1.23% 39120 -46390 Recovery Damage City 7.74% - 0.00% - 0.00% Total Revenue 25,430.40 0.12% 100.00% 143,617.23 100.000/0 Expenses Personal Services 1000- -46340 Accrued Salaries 3,932.00 15.46% 23,592.00 16.43% Total Personal Services 3,932.00 15.46% 23,592.00 16.43% Supplies 2000 -46340 Office Supplies 26.43 0.10% 241.05 0.17% 2010 -46390 Minor Equipment 807.39 3.17% 1,433.32 1.00% 2160 -46340 Maint. & Construct Materials 0.00 0.00% 0.00 0.00% 2171 -46340 General Supplies 214.02 0.84% 1,717.83 1.20% Total Supplies 1,047.84 - 4.12% 3,392.20 2.36% Other Services & Charges 3040 -46340 Legal Fees 0.00 0.00% 52.50 0.04% 3050 -46340 Expert & Professional Services 0.00 0.00% 0.00 0.00% 3060 -46340 Management Services 2,126.00 8.36% 12,756.00 8.88% 3100 -46340 Protective Services 58.51 0.23% 829.92 0.58% 3210 -46340 Telephone & Telegraph 160.36 0.63% 932.89 0.65% 3430 -46340 Advertising Other 0.00 0.00% 160.28 0.11% 3600 -46340 Insurance & Bonds 882.14 3.47% 5,088.39 3.54% 3810 -46340 Electric 1,850.84 7.28% 11,111.73 7.74% 3820 -46340 Water 69.15 0.27% 170.02 0.12% 3830 -46340 Gas 279.42 1.10% 8,846.53 6.16% 3840 -46340 Refuse 0.00 0.00% 66.04 0.05% 3850 -46340 Sewer 0.00 0.00% 444.63 0.31% 4000 -46340 Repair & Maint. Services 4,235.62 16.66% 13,550.47 9.44% 4100 -46340 Rents & Leases 150.00 0.59% 465.00 0.32% 4300 -46340 Miscellaneous Charges 0.00 0.00% 181.59 0.13% 4315 -46340 PILOT 1,028.69 4.05% 6,172.14 4.30% 4390 -46340 Taxes & Licenses 0.00 0.00% 558.62 0.39% 4500 -46340 Administrative Expenses -13.93 -0.05% 284.64 0.20% 4850 -46340 Interest on Deposits 6.53 0.03% 37.65 0.03% Total Other Services & Charges 10,833.33 42.60% 61,709.04 42.970/a 2� Capital Outlay 5120 -46340 Building & Improvements r Total Capital Outlay Total Expense Excess (Deficit) Revenue over Expense 0.00% 0.00 0.00% 0.00% u.uu U.UU' u 15,813.17 62.18% 88,693.24 61.76% 9,617.23 37.82% 54,923.99 38.24% TA Paftiew Villa South (166) Cash HOW Statement Period = June 2013 Month to Date Revenue 36220 Gen. Government Rents 24,787.40 429.00 36225 Nondwelling Rents 36290 Other Miscellaneous Revenue 214.00 0.00 39120 Recovery Damage City Property Total Revenue 25,430.40 Personnel Services 1000 Accrued Salaries 3,93200 Total Personnel Services 3,932.00 Supplies 26.43 2000 Office Supplies 807.39 2010 Minor Equipment 0.00 2160 Maiht. & Construct Materials _ 2171 General Supplies 214.02 2175 Food Supplies 0.00 1,047.84 Total Supplies 882.14 Other Services & Charges 0.00 3040 Legal Fees 2,126.01 3060 Management Services 58.51 3100 Protective Services 16036 3210 Telephone & Telegraph 0.00 3430 Advertising Other 882.14 3600 Insurance & Bonds 1,850.84 3810 Electric 69.15 3820 Water 279.42 3830 Gas 0.00 3840 Refuse 0.00 3850 Sewer 4,235.62 4000 Repair & Maint. Services 0.00 4050 Garage, Labor Burd. 150.00 4100 Rents & Leases 0.00 4300 Miscellaneous Charges 1,028.69 4315 PILOT 0.00 4390 Taxes & Licenses (13.93) 4500 Administrative Expenses 6.53 4850 Interest on Deposits 10,833.33 Total Other services & Charges 15,813.17 Total Expenses a ParlcvieO Villa South (166) Cash Flow Statement Period = June 2013 Excess (Deficit) Revenue over Expenses Adjustments 10200 Petty Cash 10400 Investments 11300 Rent Receivable 11500 Accounts Receivable 15510 Prepaid Insurance 20200 Accounts Payable 20210 Accrued Other Expense 22000 Deposits 22200 Accrued PILOT 22210 Revenue Collected in Advance Total Adjustments Cash Flow 10100 Cash Balance 10200 Petty Cash 10400 Investments Total Cash Month to Date 9,617.23 0.00 0.00 (1,023.18) 6.00 0.00 62.77 841.25 (421.65) 1,028.69 66.00 559.88 10,177.11 Beg Cash End Cash Difference 78,011.82. 88,188.93 10,177.11 279.00 279.00 729,970.36 729,970.36 808,261.18 818,438.29 10,177.11 Parkview Villa South (166) General Ledger Period = Inn 2013 Book = Accrual ; Tree = ysi- 166 V Yo,yV 6/30/2013 :PostRecurring Recurring 3- 165940 RC 3,932.00 0.00 Net Change =0.00 Net Change = 3,932.00 3850 -46340 Sewer 2000 -46340 Office Supplies Net Change =0.00 0.00 166 6/8/2013 'Office Depot(Of08804) P- 338042 6.61371E +11 19.17 166 1/22/2013 166 6/10/2013 Office Depot(OM8804) P- 338044 6.6137E. +11 7.26 Kone Inc.(kone) P- 336752 0.00 314.50 Net Change =26.43 5/6/2013 Adam's Pest Control, Inc. (adam P- 338083 798410 23.32 2010 -46340 5/22/2013 Minor Equipment 2435 117.94 166 6/12/2013 HD Supply Facilities Malntenanct P- 337891 9122892046 807.39 0.00 Net Change= 807.39 2171 -46340 Mamt. & Construct. Materials 166 5/8/2013 Home Depot Credit Services (he P- 336165 6190946 50.09 0.00 166 5/23/2013 Home Depot Credit Services (he P- 336160 1193117 15.41 0.00 166 6/3/2013 Frattalone's /Metro Ace (frat) P- 336384 015212R 1.76 0.00 166 6/7/2013 HD Supply Facilities Malntenanc( P- 337172 9122796676 131.18 0.00 166 6/10/2013 Frattalone's /Metro Ace (frat) P- 337562 01531SR 15.58 0.00 Net Change = 214.02 3040 -46340 Legal Fees Net Change =0.00 3060-46340 Management Services 0.00 166 6/27/2013 Common6ond Housing (chc) P- 338993 06/15/13- 06/27/ 6,058.00 166 6/30/2013 :PostRecurring Recurring 1- 165940 RC 0.00 3,932.00 Net Change = 2,126.00 3100 -46340 Protective Services 0.00 166 6/7/2013 Wellington Security Systems (wr P- 338414 104488 58.51 Net Change =58.51 3210 -46340 Telephone & Telegraph 166 5/31/2013 POPP.COm (Popp) P- 337561 992110809 100.42 0.00 166 6/1/2013 Level One (leve) P- 335804 0325059IN 34.38 0.00 166 6/2/2013 Comcast(comc3474) P- 337524 8772105050196: 25.56 0.00 ` Net Change= 160.36 3430 -46340 Advertising Other Net Change =0.00 3600 -46340 insurance & Bands 0.00 166 6/30/2013 :PostRecurring Recurring )- 165940 RC 841.25 166 6/30/2013 Directly Expense Yearly Crime Ir 1- 166814 G32 40.89 0.00 Net Change = 882.14 3810 -46340 166 6/11/2013 Electric Xcel Energy (xcel) P- 338232 5150441553 06/ 1,850.84 0.00 Net Change= 1,850.84 3820 -46340 166 5/29/2013 - Water City of Columbia Heights (colu) P- 335671 31802650001 05 69.15 0.00 Net Change =69.15 3830 -46340 166 6/7/2013 Gas CenterPolnt Energy (cent) P- 337814 55271324 06/07 279.42 0.00 Net Change = 279.42 3840 -46340 Refuse Net Change =0.00 3850 -46340 Sewer Net Change =0.00 4000 -46340 Repair & Maint. Services 166 1/22/2013 LIP Mechanical, Inc (Ibpm) P-336247 W18095 665.51 166 3/1/2013 Kone Inc.(kone) P- 336752 221125731 314.50 166 5/6/2013 Adam's Pest Control, Inc. (adam P- 338083 798410 23.32 166 5/22/2013 All Metro Lawn & Snow, LLC (alir P- 337217 2435 117.94 Page 6 of 7 718/2013 3:21 PM 19,660.00 = Beginning Balance = 23,592.00 R/C CHC PR Mgmt Fee 23,592.00 = Ending Balance = 214.62 = Beginning Balance = 233.79 cups /candy 241.05 coffee /pens,meistener envelope 241.05 = Ending Balance = 625.93 = Beginning Balance = 1,433.32 eldre dryr 1,433.32 = Ending Balance = 1,503.81 = Beginning Balance = 1,553.90 maint supplies 1,569.31 maint supplies 1,571.07 distilled water gallon 1,702.25 HVAC /Plumbing 1,717.83 seam bndr 1,717.83 = Ending Balance = 52.50 = Beginning Balance = 52.50 = Ending Balance = 10,630.00 = Beginning Balance = 16,688.00 163576 mgmt fees 06/13 12,756.00 R/C CHC PR Mgmt Fee 12,756.00 = Ending Balance = 771.41 = Beginning Balance = 829.92 service call /shop supplies 829.92 = Ending Balance = 772.53 = Beginning Balance = 872.95 phone 06/13 907.33 maint plan /roll over phn # 06/1 932.89 Internet 06 /11- 07/10/13 932.89 = Ending Balance = 160.28 = Beginning Balance = 160.28 = Ending Balance = 4,206.25 -= Beginning Balance = 5,047.50 C of Columbia Heights Ins Accrl 5,088.39 Directly Expense Yearly Crime Ii 5,088.39 = Ending Balance = 9,260.89 = Beginning Balance = 11,111.73 a 05/06- 06105/13 11,111.73 = Ending Balance = 100.87 = Beginning Balance = 170.02 late fee 170.02 = Ending Balance = 8,567.11 = Beginning Balance = 8,846.53 g 05/06 - 06/05/13 8,846.53 = Ending Balance = 66.04 = Beginning Balance = 66.04 = Ending Balance = 444.63 = Beginning Balance = 444.63 = Ending Balance = 91314.85 = Beginning Balance = 0.00 9,980.36 replce zone valve unit 423 0.00 10,294.86 Maint Coverage 03/13 0.00 10,318.18 pest control 05/06/13 0.00 10,436.12 Monthly services 04/13 ✓ Parkvlew Villa South (166) General Ledger Period = mn 2013 Book = Accrual ; Tree = ysi_ 166 5/31/2013 All Metro Lawn & Snow, LLC (allr P- 337216 2455 185.03 Laura Frost(fros) 0.00 166 5/31/2013 Case(case701) P- 337892 24348 91.00 0.00 166 6/1/2013 Kane Inc.(kone) P- 337215 221196368 314.50 6/30/2013 0.00 166 6/10/2013 K.O. Cleaning and Restoration LI P- 337482 1449 50.00 0.00 166 6/17/2013 LBP Mechanical, Inc (Ibpm) P- 338090 W18778 2,450.50 0.00 166 6/19/2013 Adam's Pest Control, Inc. (adam P- 338175 805548 23.32 0.00 Net Change = 4,235.62 4100 -46340 Rents & Leases 166 5/31/2013 Multihousing Credit Control (mul P- 337341 13050413 150.00 0.00 Net Change= 150-00 4300 -46340 Miscellaneous Charges Net Change =0.00 4315 -46340 PILOT RC 1,028.69 0.00 166 6/30/2013 :PostBecurring Recurring 1- 165940 Net Change= 1,028.69 4390 -46340 Taxes & Licenses Net Change =0.00 4500 -46340 Administrative Expenses 166 6/3/2013 Laura Frost(fros) 166 6/3/2013 Laura Frost(fros) 166 6/3/2013 Laura Frost(tros) Net Change= -13.93 4850 -46340 Interest on Deposits 166 6/30/2013 Sec Dep Interest accrual Net Change =8.53 P- 335629 050713- 335629 P- 335629 050713- 335629 P- 335629 050713- 335629 3- 166812 G11 0.00 13.93 0.00 6.53 718/2013 3:21 PM 10,621.15 ContraWLawn care /debris dispc 10,71115 repair bank equip /alarms panel 11,026.65 maintenance 06/01- 06/30/13 11,076.65 Touch up walls Unit 123 13,527.15 Repairs/ materials, labor /travel 13,550.47 ca prevent plus 06/19/13 17,550.47 = Ending Balance = 315.00 = Beginning Balance = 465.00 residential screening 05/13 465.00 = Ending Balance = 181.59 = Beginning Balance = 181.59 = Ending Balance = 51143.45 = Beginning Balance = 6,172.14 Anoka Cty Property Tax Accrual 6,172.14 = Ending Balance = 558.62 = Beginning Balance = 558.62 = Ending Balance = 298.57 = Beginning Balance = 13.93 284.64 exp reimburse 5/7/13 0.00 298.57 exp reimburse 5/7113 13.93 284.64 exp reimburse 5/7113 284.64 = Ending Balance = 31.12 = Beginning Balance = 0.00 37.65 Sec Dep Interest accrual 37.65 = Ending Balance = 19,773.03 3,959.86 Page 7 of 7 2� Parkview Villa South Bank Reconciliation Report 06/30/2013 5016464 Balance Per Bank Statement as of 0 613 0/2 01 3 Outstanding Checks Check date Check number. 06/18/2013 1782 06/18/2013 1786 06/25/2013 1787 06/25/2013 1788 06125/2013 1789 06/25/2013 1790 06/2512013 1791 06/2512013 1792 06/25/2013 1793 Less: Outstanding Checks Payee kocl - K.O. Cleaning and Restoration LLC t0011071 -Johnson adam - Adam's Pest Control, Inc. case701 - Case comc3474 - Comcasl fral - Frattalone's /Metro Ace Ibpm - LBP Mechanical, Inc Popp - Popp.com xcel - Xcel Energy Reconciled Bank Balance Balance per GL as of 06/30/2013 Reconciled Balance Per G/L 93,052.43 Amount 50.00 232.96 46.64 91.00 25.56 15.58 2,450.50 100.42 1,850.84 4,863.50 07/02/2013 88,188.93 88,188.93 Difference (Reconciled Bank Balance And Reconciled Balance Per G1L) 0.00 Cleared Items : Cleared Checks ✓- Amount Date Cleared Date Tran # Notes 25.56 06/30/2013 05!21/2013 1765 comc3474 - Comcast 145.00 06/30/2013 1769 multi - Multihousing Credit Control 05/29/2013 60.09 06130/2013 05/29/2013 1770 off 8804 - Office Depot 1 a93.11� 06/30!2013 05/29/2013 1771 xcel - Xcel Energy 1,152.55 06/30/2013 06/04/2013 1772 cent - Centerpoint Energy 3.14 06130/20 "13 0610412013 1773 frat - Frattalone's /Metro Ace 6,071.93 06/30/2013 06/11/2013 1774 chc - Commonl3ond Housing 59.15 06/30/2013 06/1112013 1775 colu -City of Columbia Heights 1.76 06/30/2013 06111/2013 1776 frat - Frattalone's /Metro Ace 1777 home? - HD Supply Facilities Maintenance, Ltd. 06/11/2013 Ibpm - LBP Mechanical, Inc 665.51 06/30/2013 06/11/2013 1778 34 38 06/30/2013 06/11/2013 1779 lave - Level One ✓- Cleared Checks Date Tran # 06/1812013 1780 06118/2013 1781 06/18/2013 1783 06118/2013 1784 06118/2013 1785 Total Cleared Checks Cleared Deposits Date Tran # 06103/2013 381 06/0612013 382 06118/2013 383 Total Cleared Deposits loarkview Villa South Bank Reconciliation Report 06/30/2013 5016464 07/02/2013 Notes - Amount Date Cleated allm2138 - All Metro Lawn & Snow, LLC 302.97 06(30/2013 home9055 - Home Depot Credit Services 65.50 06/30/2013 kone - Kone Inc. 629.00 06/30/2013 multl - Multihousing Credit Control 150.00 06(30/2013 offi8804 - Office Depot 19.21 06/30/2013 Notes 10, 967.15 Amount 20,600.00 3,088.00 596.00 24,284.00 Date Cleared 06/30(2013 06/30/2013 06/30/2013 ✓'?7 Date 6/28/13 Page 1 Primary Account @XXXXX @6464 Enclosures 20 ERA 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 Account Number @XXXXX @6464 Previous Balance 79,735.58 3 Deposits /Credits 24,284.00 17 Checks /Debits 10,967.15 Electronic Debit .00 Service Charge .00 Interest Paid .00 Ending Balance 93,052.43 Number of Images 20 Statement Dates 6/01/13 thru 6/30/13 Days in the Statement Period 30 Average Ledger 95,427 Average Collected 94,732 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Deposits and Credits Date Description Amount 6/03 DDA REGULAR DEPOSIT 20,600.00 6/06 DDA REGULAR DEPOSIT 3,088.00 6/18 DDA REGULAR DEPOSIT 596.00 *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Checks in Date serial order Check# Amount Date Check# Amount 6/03 1765 25.56 6/18 1777 78.29 6/04 1769* 145.00 6/18 1778 665.51 6/05 1770 60.09 6/18 1779 34.38 6/04 1771 1,493.11 6/25 1780 302.97 6/11 1772 1,152.55 6/24 1.781 65.50 6/10 1773 3.14 6/25 1783* 629.00 6/14 1774 6,071.93 6/25 1784 150.00 6/17 1775 69,15 6/27 1785 19.21 6/18 1776 1.76 * Indicates skip in check numbers *********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** bate 6/28/13 Primary Account Enclosures NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464 (Continued) Daily Balance Section Date Balance Date Balance Date 6101 79,735.58 6/10 101,696.68 6/24 6/03 100,310.02 6/11, 100,544.13 6/25 6/04 98,671.91 6/14 94,472.20 6/27 6/05 98,611.82 6/17 94,403.05 6/06 101,699.82 6/18 94,219.11 * * * E N D O F S T A T E M E N T Page 2 @XXXXX @6464 20 Balance 94,153.61 93,071.64 93,052.43 $6 Payment Summary Bank = I66opr AND mm /yy= 06/2013- 06/2013 AND All Checks =Yes AND Include Voids =All Checks 14,106.89 Check Post Total Bank Check# Vendor - Date Month Amount I66opr - Parkview Villa South 1772 cent - CenterPoint Energy 06/04/2013 06/2013 1,152.55 166opr - Parkview Villa South 1773 frat - Frattalone's /Metro Ace 06/04/2013 06/2013 3.14 166opr - Parkview Villa South 1774 chc - Commoneond Housing 06/11/2013 06/2013 6,071.93 166opr - Parkview Villa South 1775 colu - City of Columbia Heights 06/11/2013 06/2013 69.15 166opr - Parkview Villa South 1776 frat - Frattalone's /Metro Ace 06/11/2013 06/2013 1.76 166opr - Parkview Villa South 1777 home7 - HD Supply Facilities Maintenance, Ltd. 06/11/2013 06/2013 78.29 166opr - Parkview Villa South 1778 Ibpm - LBP Mechanical, Inc 06/11/2013 06/2013. 665.51 166opr - Parkview Villa South 1779 leve - Level One 06/11/2013 06/2013 34.38 166opr - Parkview Villa South 1780 allm2138 - All Metro Lawn & Snow, LLC 06/18/2013 06/2013 302.97 166opr - Parkview Villa South 1781 home9055 - Home Depot Credit Services 06/18/2013 0612013 65.50 166opr - Parkview Villa South 1782 kocl - K.O. Cleaning and Restoration LLC 06/18/2013 06/2013 50.00 166opr - Parkview Villa South 1783 kone - Kone Inc. 06/18/2013 06/2013 629.00 166opr Parkview Villa South 1784 multi - Multihousing Credit Control 06/18/2013 06/2013 150.00 166opr - Parkview Villa South 1785 offi8804 - Office Depot 06/18/2013 06/2013 19.21 166opr - Parkview Villa South 1786 t0011071 - Johnson 06/18/2013 06/2013 232.96 166opr - Parkview Villa South 1787 adam - Adam's Pest Control, Inc. 06/25/2013 06/2013 46.64 I66opr- Parkview Villa South 1788 case701 - Case 06/25/2013 06/2013 91.00 166opr - Parkview Villa South 1789 comc3474 Comcast 06/25/2013 06/2013 25.56 166opr - Parkview Villa South 1790 frat - Frattalone's /Metro Ace 06/25/2013 06/2013 15.58 166opr - Parkview Villa South 1791 Ibpm - LBP Mechanical, Inc 06/25/2013 06/2013 2,450.50 166opr - Parkview Villa South 1792 Popp Popp.com 06/25/2013 06/2013 100.42 166opr - Parkview Villa South 1793 xcel - Xcel Energy 06/25/2013 06/2013 1,850.84 14,106.89 Parkview Villa Apartments 965 40`h Avenue NE, Columbia Heights, MN 55421 Owned by the City of Columbia Heights HRA Managed by CommonBond Communities Management report for Parkview Villa for the month of April 2013 Prepared by Jenn Votta, Assistant Property Manager Police Report There were 2 calls for service. Wait List 45 applicants for Parkview Villa North (resident of C.H., elderly, handicapped) 00 applicants for Parkview Villa North (employed in C.H.) 18 applicants for Parkview Villa North (non- resident, elderly, handicapped) 16 applicants for Parkview Villa North (no preference) 00 applicants for Parkview Villa South (resident C.H.) 00 applicants for Parkview Villa South (non- resident) 00 applicant for Parkview Villa South 2BR (resident) 00 applicant for Parkview Villa South 2BR (non- resident) Occupancy North is 100 out of 101 (99% occupancy) units) South is 40 out of 45 (89 % occupancy) Move Outs Move INS Maintenance Report (See attached) J'~Vfv� (caretaker unit included in total number of O O. D: w u C m C w Y C .0 G m 'd a M N a ao m m m m M m m m m m m m m m m m N ti ti N N ti N ti ti N ti ti v o O o O O O o 0 o O O O o O O o 0 � (14 � N N m m w V \ M \ N N 00 \\ dl N N Ol \ H H Il N N N N N Ol N N N N N N 0 v 3 ai m v v = w c c w E c u w ?i w w 06 Y w O O N "O Y " cu ;m aj _ w 0 L y 0 U o t0 K 0 w "O Y m w vi CL u m a a 3 a a a m N OL K N C Y ,° 3 .O C C w N Oi O GC 0 y 0 03 U 7 O v� C V .4 O C N 'NO vwi O ° 3 _a.0 C U-Z 0� O H T w "00 O O c 3 v 0 m m m - w c o -a ° s 06 3 m z N oj N " a) ° 0 O 'w 0 m c y 0 0) M o o c u v °o v w° u u Y r (V +m 3 v 3 o Lb_.0 O W '� N L ? y D �'C 'O L G T O .wC Y L VI IA U _�CYY L QJ L C c N C_ m 4F W O .0 Y C l m c °6 m r 4= L o T� aw c o w w o m w r a"i r ,m, o° o o o^ r o c °-� to o 0 m a M m n O1 >> i° w— Y s o Y °c c -0 u O u C N c .s Q 'w c u c w a o w m Y w^ L= u c m 0 u m u r 0) N O O` u w O n u u w u O 5 r m w cL a w w w w m b4 c .N L w a_+ a+ L m OD 'Y O 0 •� O O. L O O a L m U L Y F 0 m m C N v 1Y/1 w Y 0 H m m t 0 Y N O = Y O� w m U -i c J VI U CO J Z lD M M N M 00 �--� H N N ID E O O O N O H N O r-I ti O 0 O V d' 01 N 14 m N u1 11 O try i C C m CL O cu S � W J G J W Z Z Z Z Z Z LI VI Z Z Z Z Z Z Z Z d G. d d 1 m d d d d d m C d d (L 0- m m m m m m m M m m m m m M m Ol N N N N N H H c-I N N H .--I IH ci c-I a O O O O O O O O O O O O O O O N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ V w M u1 00 00 m Ol 0 ID I, m m c N N N N m v v a s v d v v v v a v a v v 0 zzmm� yƒ±±± / ova0 \ \ \\ \\ )k� CL \ lu zzmm� yƒ±±± / ova0 )k� CL \ lu \ \u (U \ \ \ \) cu \ \ }\\ \\ &s Ja o a - l;yz /= < ® *tm == /a\»g[Q -- 0=5 �« \a :E o \) {� {0 0 0 CL \ /3Ln wF- k/) _ crE—E 2 aJ�& c zzmm� yƒ±±± / C 7 C <D 0 1 VI rt ME e ti o o o o by o o 'b w w a N m m w 9 5 10 O O - 00 � >4 O. .� o 00 A a p p 0O G G N C rn N N N to 09 O O O 0 O J J J J Ory{ a b [1y tlOtl !Ory1 ryry N N N rn W N V O W N O rn iN w Q tz w 0 v 5 C 7 C <D 0 1 VI rt ME Parkview Villa Apartments Newsletter 0 V 00 r12 ® Phone 763 - 706 -3800 Hours 8 a.m. -4:30 p.m. After Hours Maintenance: PV North 866 - 962 -8896 PV South Managed by CommonBond Communities Owned by the City of Columbia Heights Fairview Physical Therapy Info April 3rd :11:00arr Resident Council Meeting —April '. 7:00 ! Simply Good .. April 10th i ! Rff • 40 Lid;you Jim Kordiak, and his tax have your cur- assistants, will be coming rent income to Parkview Villa on information or Wednesday April 24th your federal 2013 from 1:00- 3:30pm. 1040, and your He will be helping residents CRP. file their CRP form. Man- agement will post a sign up sheet at the office as the hb time gets closer. Please ME Parkview Villa Apartments Newsletter ®ff * Iri'fi) Phone 763.706 -3800 Hours 8 a.m. -4:30 p.m. After Hours Maintenance: PV North 866 - 962 -8896 PV South Managed by CommonBond Owned by the City of Columbia Heights Communities � O WZMP Board Meeting June 3rd 3:00 pm Resident Council Meeting —June 10th 7:00 pm Columbia Heights Jamboree Festival June 26th through June 30th . Jamboree Parade -June 28th 6:00pm- 8:00pm Fathers Day — Sunday June 16th. The month of June is Dairy month. So raise a glass of milk, have a slice of cheese. Have some cot- tage cheese with pineap- ple. Enjoy Dairy products in the month of June. Milk it does a body good. Did you knowi kill Fathers Day June 13th 2013 o Chicken Breast w /Apricot To- mato Chutney o Garden Salad w /Ranch dress- ing 0 4 way veggie blend o Multi Grain bread w /Marg I would like to Introduce the new property manager to all of you. If you have not had the opportunity to meet her, come down to the office and introduce yourself. Her name is Heidi Mindestrom. She comes from a long back- ground in property management. She has been working in this field since 1998. She not only 0 Introduction brings experience, but Heidi is a personable person that loves her job. She has an open door pol- icy. So come on down to the of- fice and say hello. Heidi and Jenn make a great team for Com- monbond. o Frosted Spice Cake o RCD: unfrosted cake Please be sure to order your meal three days in advance with Joan. 763 - 789 -7018 Flower for the month of June The flower for the month of June is a Rose. You don't have to wait until Valentines Day to give someone a rose. During the whole month of June you can give a Rose. June is National Rose Month. Give one, give 2 or give someone a dozen. \ � m 0�711 I--,--% � I I � � § ■ § m { { \ \ \Q \ \\ %ce [ ƒ ! \ [ \ ! \ a 4 % E ® \ ® ) ® 2 ® r > q q \ \ }\ \ \/ \ \\ \} > m * m \\ \\ \} \} { { { { ) \ \ \ \ % % \ % < r m r , r m r M (§2{ �§\ Fj §t ;2 § \ \\ \ \r \ \r \ \r \ \ \ $ / iy O 6 O: m u c m c as c m m 'd 6 IL m m m m M M Mm M M m m mm mm 0 o O o o O o O o 0 0 0 m N N N N N N N N N N N N N N Y \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ m .-� N m l0 l0 i� h LO n 00 er m V1 V1 V) V1 VI V1 VI V1 Vl V7 V) V) ELn Ln t 1 Ln tl V\7 LLn O u ai C= 'O O C T O C Q) C '0 a) vpi O O O y V 'O '` y N N O Y L Y a m Y ac) c 3 m o m E a c i c v C ai B Y d pa y m O O m m O Q) CL O � W D 0 O u u C N a) ° C ' C a L N n c 0 u O O a m m 42 u E 0 m 0 m c Y C 0 u ,W -o a) m '^ a 0 C m �e a m v m a a a) •n o v o N ,v, 3 m m O a u p y O a) K `1 V p m 3 L O. E? °- ^° v u 0 O o u o2i vim. -o z Y o m qp u nu c ,0 > .c 0• Y°-a a _ 'm u CL 'c CL •> U 0 U '�° °� o c ° a m w a) 0 = a 0) o `� m a m m Y o p n o 5 � > E Y m p N v v -0 c y o v v m Otj K o C 'o > a o "m0 N L U Y Q .p0 E o� � o �' u c c 'c m a m +�.' ai to 0- c to otf .o 0 0 m v E c c co 0 =-0 :n d o s ;0 c w E w N L CL 0) m CL 0 `w `m w o o m' 0 0 0 3 c u C, m t C 0� Y 3 o s E Lm 0 °ca v Z r- 0 v° m u m o Y O° Sa o r 0 0 co 06 v c 3 0 0 0 E c v` v c c¢ ac v v¢ v pu E b a) o m .o 0 '�, u O -Y 7 > 3 Y C C > = C W U m pu y O L C ay_+ c m O N O Y a) u U 0 O o u 9 °c m m :.Y o= kr- Q) L fL0 up y o v w.0 m m u m n 3 vm c c L T o ° o 3 a o a m c m L m C m� c c c o m a m 3 0 m v Y_ a m m v u m o p CL v ao _ y m m- L m v 0 m L m m= a L a u a .0 C L m a) N 0 0 N L O al L U CL O) a.+ = +u_' r u O a1 L O N to E 3 m> CL L G = ]d m Y O G F C Y C] K J d O U w 5 O_ F- F m K O_ N C m L m m `1 m o > > °-N a 3 o v v m a Z) > E L (. w z m Y m Z F I[ O LL �[ z V) V) m ui a s t0 m o Ln H o 00 LD H Ln o Ln aLF) Ln H N N H H ci H O N O O O N O 1-1 Ct r1 V7 m N N N N I' E Vl m M H m V) O Y O a m z z z V) z in z z z z zt/) z z > > > > > > > > > > > > > > > > m a a a a a a a a o. Q. a a o. M a a M T m m m m m m m m m m m m m m m p m H H i-I H H N i r H H N H H � H O O O O O O O O O O O 0 0 O O T N N N N N N N N N N N N N N N m \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ N N lO l0 LO t0 w i, W O M d' d' '7 d' 0 \ \ \ \ \ \ \ \ \ N m Vl V7 V) VI V1 Vl V) Vf Ln N 0 Ln Ln m Ln Ln m m mm m M M M m m C o m m M M N N H �--1 rl rl N N N N N N H ri N O O O O O O O O O O O O O O O N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ 00 \ \ i, lD O O O O O O N O N 00 00 O O N N N N N N N N N N N N N N N M M Oj c C LYj 'p Ln Lr) Ln LI) Ln Lr) Lf) N L Ln Ln Ln Ln Ln ai c O O ai c 0 v c m L 3 N .o a v m CL v o�J L u 10 a OJ K N O C C 0 O O > 0 H O ❑ ❑ 000 C C c Q Oj c C LYj 'p t0 O E° a o p o v m m Y n C o w ❑ a c v ❑ o m m c .[Z Q p Y E Y Y C Q❑ .fT C O ❑ C 01 O p •� L E c❑ O) E E .�.+ v 0 on u —CL .0 m c c —� w= 0 v .moo N v o c c '°-,� O o aj v v a o Z -o 3 m� o o a ��° o v o O h i-i V C N 00 O y, U u u O) OY1 C v `^ C o o YC O' O a a 5 v) u a c u 3 z o c E r c L o m s E= o 0 ti4 m ao 0 3 o .3 o❑ 0 - .o E o w c c_ •a -0 p a o ao O 3 r a c 3 u aw w o° o w w L > E o 3❑ v L_ ap o E oo M O N .O O O/ C v w E 0 _ _ E C ❑= tl0 C K o Y 00 C N 'Z O1 �. W C w o f E E O W L CL m C ?' n C 5 C% C O/ f0 f0 w C O c N 7 44* f0 Ol O) O) C W L EO N L .O t. O/ ` O1 a+ O1 cl .O Y > = O 'O 'O O 01 Y Y O) 00 Ol .- 'in = 'O O1 Z. �. O/ L� N C in E C O O - = K N F❑❑ H H H N 0[ J ❑ Ln 0_ u Y J N 'c0 ,Op C in j C H C +� .00 tC � � � � C N 'a' •(0 m � � � � L (0 LL V) 2 'J to �O m❑ W J 0 U L/1 00 N N } L! LD O 00 O O O 0 N n N n M V V d' M C N Z Z Z Z N Z Z N Z Z Z N N Z N a a a s a a d a a s a a a a s m m m m m m m m m m m m m m m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N N N \O \0 V\1 l\0 n n n 00 00 N 00 00 O O c-1 ei N H N N N N N N N N N M M V\7 V\1 Ln L 1 V\1 l\ l\f1 V\7 it t! I L ll Ln if ai c O O ai c 0 v c m L 3 N .o a v m CL v o�J L u 10 a OJ K Parkview Villa Incident Report May 1 — 31, 2013 5/12/20133:53 NEIGHBORHOOD DISPUTE 13101758 965 40 AVE NE 5/6/201323:17 CHECK WELFARE 13097502 965 40 AVE NE 5/5/2013 17:33 SUSPICIOUS - PERSON 13096314 965 40 AVE NE Parkview Villa Apartments Newsletter EMI M Phone 763- 706 -3800 Hours 8 a.m. -4:30 p.m. After Hours Maintenance: PV North 866 - 962 -8896 PV South 866 - 962 -8897 Managed by CommonBond Owned by the City of Columbia Heights Communities • ♦ Board Meeting —July 1st @ 3:00 pm Office CLOSED Tbursday July 4th ♦ Resident Council Meeting —July 8th 7:00 pm Guest Speaker: John Larkin from C.H.F.D will speak on Fire Safety. ♦ HRA Meeting July 23rd @ 7pm Since 1985, America has cele- brated July as the nation's official Park and Recreation month. This month we want everyone talking about what they love about Parks and Recreation and why Parks and recreation are so vital in our lives. LUEMMM N 9 3 i d C N a 0 M b N N tC N U `tl U U �1tyyO ~ ~ k W O W O O q b O u 0 oro� a 0 O O ti O O O O h O O V U U U U N� w iUG Ej k k k p W O W O W p W O 04 N N N N N . W Ppa � W `� T T ❑� ❑� N Pk U b Z M U O N q Ln 0 0 a G1 .0 P4 0.041 ro Fi0 0.i 0.1 09 m U m U U W qq q o o 'p o 'p o ro 'p o a�i U K U W 0 W ° 0 v o 0 N °° ° a a o o a o P . 04 a 1� 6 d u u C 10 C al Y C m 2 m ,v M m C 7 m m m m m m M m m M m m mm m m m 4) o O o o O O o 0 0 o O O O o 0 0 0 o 0 O d N N N N N N N N N N N N N N N N N Y \ \ \ \ \ \ \ \ \ \ \ N \ M \ M \ Ct \ \ \ W d C(' Vl V1 V) l0 I, O O c•I N \ \ \ \ o \ \ a-I \ N \ N \ rl \ \ \ \ \ \ \ \ `D Eo 0 u a o w c° v v v o •�, ai 0 o bA as Q O V L O 0 Y O. 'C N >° N N V L a u Q Y N 0. (U L '0 a) c O u 'o be fO Y o H a) N >• O Y a c a OZ 0• c ° v a) v v � 0 a s a N r -00 v 3 Y W N c N ;D O f0 u bo L c ` a m E o u a c C_ u m U/ o m O Wu u o � > c u O 0 a N Q N (U C° 7 u Li Y W a) u b4 ° N o v u ^ o c f0 0 z o2f b c^ c a a ° � o v -0 > > o Q u E— cu m ) 06 u c C Oa 0 L 0 L v� O O m — O 0> ww Y a= o s v E c r O v u °iS _^ r° v LIO ac n -0 c° 3 N E c c G EO N p� W O H o c iti -a/0 �O F L O N 3? vYi a1 v a1 •p C C N O 3 0 0 c L v c L o on a c w t 0 3 0 as o s v `-' a '�' v° 5 i• o= Y u `° v° no o v 3 o ai c 'O ° 0 •� ao v = r - 'c '� .L.+ o w w u,,, 0 `o D '0 W vc, C CL ,'.+ C °6 > N N bA N C oz .°_ O L n 0 E > U > E- ~ ... O u L Y E' 0 00 90 a`-' i0i1 Z a u Z w a v 2 o c 0 3 u c o2i .a o v a ai v m a v a o r r t co c v v N c .�� v 0 u c '° c u fl. v v „ •c in a1 Y o •> .`c m .� 'o m W a N !-' a c (0 O O Y al L L a� al L 0 (0 _ +_ Z• m L O c0 O Y N K d O Y K F- F -1 2 K F E c0 Y 3° m Q. ° 3 � Y H V al Y c c a1 C H a) ti 0 O d 9 O a E .D L U O a m O °' m a U O z O °• Z-4 Q Q J V) W LL v m h if o h m v h In v O O O c-I rI N O ti O ti O h N h VI m d' N c-I N 00 J J J J LL J LL LL LL LL a L a a a = N V M N N bJD Z V1 Z Z Z V) V1 to V1 V1 Z Z Z VI Z 0 Z .0 > > > > > > > > > > > > > > > > > 00 a a s a a n m a a. a a d o_ a a a a c m m m m m m m m m m m m m m m m ei H N N N rl N N N co O O O 0 0 0 0 0 0 0 0 0 O 0 o 0 0 O o 0 N N N N N N \ \ \ \ \ \ \ \ \ \ \ N \ N N N \ V \ ct 00 y ct ut V1 l0 r O o O ti N .--I 1p lD 1p lD 1p \ \ \ \ \ \ \ \ \ W \ W \ �o ° �0 W LD LD w (o w m m m m m m m m m m m m m m m m ti ti ti N N N N N N N N ti ti ti N ti 0 0 O o O O O N N N N N N N N N N N N N N N N N N N N N (N N N N 0 0 O O 0 ti to W-D 00 N H m U7 Ln Lf) H N N N N N N N N N N N N N N N O) N a C C C m 0 O r O Cl d u Ul C N O oz q-' •O O m c D u 3 .cm, v" o a Y ci c 00 ° a t Lnn o u b 00 r o 0 m CL U) j N d 0 m O U O N L o ° o¢ m e °— ab o> aY a v v y Ci= m u Y ) 3 K O` C W C a a N m m O Y � ¢ V V O �- N O) m K U ® L > C O vOi 0 U a+ C U L a >> ° r c n o v o a i m 3 3 _ u c a L GD Y L m O C 3 a u N bD N O O C a° s L., 3 m Y c o T u 0c a a CL w a, d v c o u Y Y 0i `- c `- 0O c N § 3 p c E c 0 E � , E E E D O. c 0 m '° v G W 30 H E L W C v w s O v N = N ° L F '" L a N a W aU_ l L •. .i Y m o o v w c 3 v 0 r : g te OJ aj r �0 EQ F H m s O O Z F vi a a v� c c •—° m m c v o E ° > 3 v v Y m me o E Y H Y C L H J O O O > d in J O Z m 2 O K U m r, 00 v N co n m d o 00 o n 00 rn m N N c-I N r-I O O O ti N O c-I N O m 4 N m lD rl m ti m I, m N m J LL a C N N N N N Z Z Z Z Ln Z VI Z N N Z a a a a s a s a a a a a a a a as m m m m m m m m m m m m m m m m 0 o o o O 0 N N N N N N N N N N N N N N N N 0000 0 0 0 0 0 0 -1�+ a vii vii 0 0 0 0 N N N N N N N N N N N N N N N N LDD ko -DD to to LD to tDD tDD kDD LDD to W lDD LDD lDD Parkview Villa Incident Report June 1 — 30, 2013 6/24/201318:44 CHECK WELFARE 13138373 965 40 AVE NE 6/21/2013 12:50 TRESPASS NOTICE 13135294 965 40 AVE NE Meeting minutes 4/8/2013 Meeting was opened with Pledge of allegiance. Jan read the treasury report with a current balance of 2,757.39 in checking and 16.75 in petty cash. Sunshine report was read by Cecelia 4 cards were sent out. 150.00 dollars was voted on for the magician to come and was approved by a vote. He will be here on April 17. A vote was proposed for a guitar player to come and entertain will vote on this next meeting. Rheta said Aeon will come to talk about amenities it is proposing a date has not been set. This will be posted. Rheta also is looking into getting the golden tones to come in October no charge just coffee and cookies. Monday at 1:00 P.M. there will be a yoga tape played in the B room all are invited to attend. It was suggested we bring in a chiropractor to talk about wellness and things to do. This had no interest and so was shelved. We need to setup 90' birthday party for residence turning 90 this year Dianne was organizing it because Jessie is part of the party this year and we need to take care of her for a change. Adam, Rheta, and Leanne volunteered to help. At the next meeting we will set a date. Garden committee needs a spokes person to talk for the group. Dianne wanted to put a collage of pictures of residents at activities in the B room there was no interest. We will only send cards and no money for hospitalization or bereavement. Minutes of Resident Council Meeting - May 13, 2013 Meeting was opened with Pledge of Allegiance to the flag. Treasury Report was read by Jan Field: Checking Amount = $2,164.39 Petty Cash Amount = 16.75 Sunshine Report by Cecelia Rothbauer - No cards were sent since the last meeting. Bingo Report was read by Jackie Ovshak. LeAnn Miller (President) has a list of names of people who have volunteered for the Garden Club. There was some confusion about meeting times, and LeAnn said that the Resident Council Meeting will always be at 7 p.m. The 90th Birthday Party is scheduled for May 22 "d. Diann Powell and Jessie Chudek are making the arrangements. Diann has also tentatively scheduled a Pizza Party for July and the Men's Barbecue for August. There was some confusion about who is doing what, when, and discussion followed. LeAnn had to leave early, and Darlene Miller (Vice President) read the $5.00 winners. They were: Carroll Hinrichs Jessie Chudek Barb Camp Lynn Jantzen Darlene ended the meeting at 7:25. Meeting June 10th 2013 • The meeting was open at 7:00pm with the Pledge of Allegiance • 2 cards were sent out by Cecele • Treasury report stated we have paid $75.00 to Lou, the nurse & $20.00 in Miscellaneous • We are having a►ot of bad & hurtful rumors going around. We as a counsel are not broke. Leanne is not a thief. We need to quit saying hurtful things and think before we speak. • The 90th Birthday party was very nice. Everyone enjoyed it. • The flower garden is looking very nice & everyone is enjoying it. • It was asked if we are going to renew the Sam's Club card this year & decided not to as some people here have membership we can use. • Leanne is resigning immediately for personal reasons. We will post for nominations. They must be posted by the next board meeting. We will then be voting in the next month. We will be carrying into January & February or beyond until we know when Aeon is taking over. • There were four winners of the $5.00 drawings: Barb Camp, Ken Bloch, Ruth Hillestad & Joan Bixler. • Meeting adjourned at 8:00pm June 29, 2013 To Whom It May Concern: This note is to tender my resignation as member -at -large on the Parkview Villa Resident Council Board, effective immediately. Lyn H. Miner' June 10, 2013 To All Parkview Residents After much thought, strong recommendation from my physician, family obligations and many very personal reasons, I am stepping away from my position as Resident Council President. I thank everyone who assisted me and supported me. LeAnn Miller On June 14th Jan Field, Darlene Miller, Rheta Nelson & Joan Bixler were outside talking. Jan turned to Joan and said "I am quitting & if I ever run for anything else again stop me ". Jan was mad when she said this. I took her statement to mean she was quitting. Darlene Miller