HomeMy WebLinkAbout2012-04-24 HRA AGENDA PACKETHOUSING & REDEVELOPMENT AUTHORITY AGENDA
7:00 P.M.
April 24, 2012
PARKVIEW VILLA, COMMUNITY ROOM B, 965 40"" AVE., COLUMBIA HEIGHTS, MN
1. Call to Order
2. Roll Call Tanunera Diehm, Chair
Bobby Williams, Vice Chair
3. Pledge of Allegiance
CONSENT AGENDA
Bruce Nawrocki
Donna Sclunitt, Secretary /Treasurer
Gary Peterson
4. Approve minutes of January 24, 2012 and special meeting of March 5, 2012, Executive Session
March 5, 2012
5. Approve Financial Report and payment of bills for January, February and March 2012 on
Resolution 2012 -03.
Motion: Move to approve consent items as listed
BUSINESS ITEMS
6. Report of Management Company
7. Resident Council Minutes
8. Citizen Foram*
9. Approval of window analysis contract with Encompass
10. Other Business
a. Aeon update (no attachments)
The next regular HIUI meeting tvill be Tuesday, July 24. 2012 at Parkview Villa.
*At this time, citizens have an opportunity to discuss with the IIRA items not on the regular agenda. The citizen is requested to
limit their comments to five minutes. Please note the public may address the HRA regarding specific agenda items at the time the
item is being discussed.
HOUSING & REDEVELOPMENT AUTHORITY
MINUTES OF THE MEETING
OF JANUARY 24, 2012
1. Call to order— The meeting was called to order by Chair Diehm at 7:00 pm
2. Roll Call — Members present: Bruce Nawrocki, Garry Peterson, Donna Schmitt, Bobby
Williams, and'fammera Diehm.
Staff Present: Community Development Director -Scott Clark, Assistant Community
Development Director - Sheila Cartney, and Secretary - Shelley Hanson
Parkview /CommonBond staff: Laura Sheak, Laura Frost, and Jennifer Ells.
3. Pledge of Allegiance - Recited
4. Election of Officers for 2012
Peterson nominated Diehm for President, Williams for Vice President, Schmitt for
Secretary /Treasurer. No further nominations were made. Upon vote: All ayes.
CONSENT AGENDA
5. Approve Minutes from October 25, 2011.
6. Approve Financial Report and Payment of Bills for October, November, and December
2012 on Resolution 2012 -01.
uestions from members
Nawrocki questioned the December reports and noted that Revenues were down a little,
Expenses were up a little, and wondered why there wasn't an accounting of Interest on the
Bank Account.
Laura Frost said Revenues were less than anticipated because we have yet to receive a $29,971
grant payment from HUD. Once this amount is received, it would bring the total Revenues
closer to the budgeted amount. She said we should receive the payment in the first quarter of
2012. As for expenses, Frost stated that some of the utility bills came in higher than projected
and that legal fees were also higher during the year due to several tenant /policy issues.
Schmitt noted that many appliances have been replaced. She asked what the average age was
of the appliances. Laura Sheak said it varies, but the south building has had to have many of
the appliance replaced since they were the original ones from 1990. The north building has
been replacing appliances with the modernization of each floor, but the south building has not.
HRA Minutes
Page 2
7. Resolution 2012 -02 Designating Signatories
The attached Resolution 2012 -02, designates Northeast Bank as the depository for all Columbia Heights
HRA funds and authorizes signatories for accounts.
uestions from members
Nawrocki questioned who the signers would be. He thought that each check should be signed by one
person from CommonBond and the HRA Executive Director. Clark explained that two signatures are
required, but that two signatures from personnel at CommonBond also suffice. He said it has always
been this way and that is why we have a management company. Nawrocki thought it would be better
checks and balances if a City Staff person signed each check. Clark said the City and HRA Board
receive copies of each check and the financial reports each quarter which serves as the checks and
balances. He also pointed out that any expenditure over $15,000 requires pre - approval from the Board
as stipulated in the contract with CommonBond.
Nawrocki again asked for information about the interest paid to the City on the funds at NE Bank.
Frost will check with the bank and report back to Clark and Nawrocki on this.
Motion by Williams, seconded by Schmitt, to waive the reading of Resolution 2012 -01 & 2012 -02,
there being ample copies available. All ayes. MOTION PASSED.
Motion by Williams, seconded by Schmitt; to approve the minutes of October 25, 2011; to adopt
Resolution 2012 -01, a Resolution of the Columbia Heights Housing and RedevelopmentAuthority
(HRA) approving the Financial Statement and Payment of Bills for the months of October, November,
and December 2012; and to Adopt Resolution 2012 -02, a Resolution Designating Depository for the
Columbia Heights Housing and Redevelopment Authority (HRA).
Motion by Nawrocki, to remove the Resolution Designating Depository for the Columbia Heights IIRA
from the above motion. The motion died from lack of a second.
Roll call vote on original motion: ayes- Williams, Schmitt, Peterson, Diehm Abstain- Nawrocki
MOTION PASSED.
HRA RESOLUTION 2012 -01
RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY
(HRA) APPROVING THE FINANCIAL STATEMENT FOR OCTOBER, NOVEMBER, AND
DECEMBER, 2011 AND PAYMENT OF BILLS FOR THE MONTHS OF OCTOBER, NOVEMBER,
AND DECEMBER, 2011.
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
I -IRA's credits and assets and its outstanding liabilities; and
I -IRA Minutes
Page 3
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 it) its records; and
WHEREAS, the financial statement for the months of October, November, and December 2011 and the list of
bills for the months October, November, and December, 2011 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 I- leights 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 paymeut 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 24" day of January, 2012.
RESOLUTION NO. 2012-02
RESOLUTION DESIGNATING DEPOSITORY FOR THE COLUMBIA HEIGHTS HOUSING AND
REDEVELOPMENT AUTHORITY (HRA)
WHEREAS, the City of Columbia Heights Housing and Redevelopment Authority (herein referred to as the
"Corporation ") has entered into a Management Contract with Commonbond Housing (herein referred to as
"Management Company "), dated January 23, 2008, and amended on November 9, 2009 and extended on
October 25, 2011 and
WHEREAS, by Minnesota Statutes the Corporation must establish a depository agency, and
WHEREAS, the Corporation desires to have as authorized signatures both officers of the Corporation and the
Management Company.
IT IS IiEREBY RESOLVED, that Northeast Bank, is hereby designated as a depository of the funds of this
corporation.
IT IS FURTHER RESOLVED, that checks, drafts, or other withdrawal orders issued against the funds of this
corporation on deposit with said bank shall be signed by at least two of the following:
HRA Executive Director
Management Company CEO
Management Senior Vice President
Management Director of Administration
And that said bank is hereby fully authorized to pay and charge to the account of this Corporation any checks,
drafts, or other withdrawal orders.
HRA Minutes
Page 4
BE IT FURTHER RESOLVED, that the Northeast Bank, is designated depository of the Corporation and it is
hereby requested, authorized and directed to honor checks, drafts or other orders for the payment of money
drawn in this Corporation's name, including those drawn to the individual order of any person or person whose
name or names appear thereon as signer or signers thereof, when hearing or purporting to bear the facsimile
signatures of at least two of the following:
Management Company CEO
Management Company Senior Vice President
Management Company Director of Administration
And that Northeast Bank shall be entitled to honor and to charge this Corporation for all such checks, drafts or
other orders, regardless of by whom or by what means the facsimile signature or signatures thereon may have
been affixed thereto, if such facsimile signature resembles the facsimile specimens duly certified to or filed with
the Bank by the City Clerk or other officer of this Corporation.
BE IT FURTHER RESOLVED, that any and all resolutions heretofore adopted by the Corporation and
certified to as governing the operation of the Corporation's account(s) with it, be and are hereby continued in
full force and effect, except as the same may be supplemented or modified by the foregoing part of this
resolution.
BE IT FURTHER RESOLVED, that all transactions, if any relating to deposits, withdrawals, re- discounts and
borrowings by or on behalf of this Corporation with said bank prior to the adoption of this resolution be, and the
same hereby are, in all things ratified, approved and confirmed.
BE IT FURTHER RESOLVED, that any bank or savings and loan located in the State of Minnesota may be
used as depositories for investment purposes so long as the investments comply with authorized investments as
set forth in Minnesota Statutes.
BE IT FURTHER RESOLVED, that any brokerage firm located in the State of Minnesota may be used as a
depository for investment purposes so long as the investments comply with the authorized investments as set
forth in Minnesota Statutes.
Passed this 24th day of January, 2012
Offered by: Williams
Seconded by: Schmitt
Roll Call: Ayes - Williams, Schmitt, Peterson, Diehm
Abstain- Nawrocki
Chair
Shelley Hanson- Secretary
HRA Minutes
Page 5
8. Report of the Management Company
Laura Sheak asked if there were any questions on the newsletter items or on the monthly reports.
Williams noted there weren't any police calls in December, which was encouraging.
Nawrocki said contracts were approved for ductwork and the modernization of the second floor at the
last meeting. He wanted to know the status of these projects. Frost said the ductwork project is about
1/3 done and will be finished in the spring, and the modernization project begins March 12`x'. He
wanted to know what the delay was. Frost said Project One had to wait for specs from the Architect to
order the doors, which has now been done. Jenny said the delay was because each door had to be
individually measured and ordered due to settling of the building.
Clark told members that he has had discussions with Laura Sheak regarding the bay windows in the
south buildings that have been leaking. They are in the process of going out for bids for an Engineers
Report on the 36 large windows, to assess the damage and find out what corrections /repairs will be
necessary.
9. Resident Council Minutes
Lyn Miner reviewed the resident council minutes from the last meeting with the Board members.
Copies of the previous meetings were enclosed in the agenda packets. Lyn reported that the 2012
officers are:
President -
Vice President -
Secretary-
Treasurer-
Member at Large -
Sgt. At Arms-
Lyn Miner
Vivian Fagge
Jessie Clmdek
Ken Bloch
Lee Ann Miller
Matthew Kopacek
Lyn stated that each resident is given a copy of the minutes to keep them informed.
Diehm stated they appreciated receiving the minutes and being informed of resident activities. Clark
also stated that staff appreciated working with Rheta Nelson during 2011 and looks forward to
working with Lyn Miner in 2012. He feels communication has greatly improved over the last couple
years.
10. Citizen Forum
Barb Camp #608 -asked for a status report on the sale of Parkview. She said residents are concerned.
HRA Minutes
Page 6
Clark said the matter is progressing well. He said the entire process will probably take another 12 -15
months to complete. He said there will be another group meeting with residents in about 4 -5
weeks. Aeon is currently working on obtaining grants and financing to complete the purchase,
and will have more information by the end of February. The date of the meeting will be posted
and each resident will be notified individually.
Dianne #905 -Asked how to identify people who are not supposed to be on our property. Sheak told
her that any concerns about people in the building or on the grounds should be brought to
management staff and they will deal with it. And no one should be letting people into the
building. Anyone who belongs there will have access. If residents adhere to this policy, then
they are safe.
Jackie #707 -Asked if the laundry room on second floor will be closed during the modernization
project. Sheak told her yes, it would be, but residents will be notified ahead of time.
Ken Myhre #511 -If a friend comes in with him, is that ok? Sheak told him that, yes, that is ok, and
that residents are allowed visitors.
Barb Camp #608 -Told members that she appreciates the wonderful management team that has been in
place during the last 5 years. Residents think they do a great job.
Nawrocki asked residents how the new smoking shelter is working out. Most of the residents thought it
was a huge improvement and has been helpful in resolving most of the issues. However, Lyn
Miner, said she still hears a lot of noise and conversation coming from the shelter. Ken Bloch
said that all the traits have some type of noise to deal with. On the other side of the building it
is noise from the garbage trucks emptying the commercial dumpsters in the early morning.
Shirley Bennitz #324 said she also hears the street /parking lots being swept during the middle
of the night on her side. They both pointed out that noise cannot be eliminated completely
since they live in an urban area.
Malcolm Watson -1717 49 °1 Avenue- is interested in contacting James Lenhoff from Aeon regarding
the appraisal that will be done on Parkview Villa. He asked Scott Clark for help in getting a
hold of him as he would like to get the contract to do the appraisal of the buildings.
11. Confidentiality Agreement with Aeon
Clark explained that in May of 2011 the Housing and Redevelopment Authority (HRA) entered into a
memorandum of understanding with AEON to begin negotiations for the sale of Parkview North and
South. As we progress, it has become clear that AEON will need access to HRA file information that is
protected by the Minnesota Data Practices Act. The attached Confidentiality Agreement allows Aeon
access to this information with the caveat that they must adhere to all applicable State and Federal laws,
including holding the HRA harmless from any unlawful disclosure. This Agreement was written by the
HRA Attorney and has been reviewed by AEON.
Staff recommends approval this agreement.
HRA Minutes
Page 7
Question from members:
Nawrocki asked what kind of information they are seeking that would require this agreement. Clark
said an example would be the income levels of the residents that are needed for the grant applications.
By entering into this agreement, they will have the right to see information but would have to adhere to
the same Data Practices Rules that we do. They would be unable to share private information. They
can take the data received and compile it in a generalized, group format but could not provide any
specific information that would identify an individual.
Resident Adam Alieu said he thought the information could be used to decide who Aeon keeps as
residents versus those they want to get rid of. Diehm assured him that there are other separate
agreements in place that protect residents from that happening.
Motion by Peterson, seconded by Schmitt; to approve the Confidentiality Agreement with Aeon for
purposes of'implementing the goals of the Memorandum of Understanding.
All ayes. MOTION PASSED.
CONFIDENTIALITY AGREEMENT BETWEEN
AEON AND THE CITY OF COLUMBIA IIEIGHTS
HOUSING AND REDEVLOPMENT AUTHORITY
This CONFIDENTIALITY AGREEMENT is made by and between AEON and the CITY OF
COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY ( "HRA ") for purposes of
implementing the goals of the Memorandum of Understanding executed between the parties on January 24,
2012.
RECITALS
WHEREAS, the HRA owns and oversees operations of Parkview Villa South and Parkview Villa North,
which are attached multi -unit residential housing facilities located at 965 40 °i Avenue NE in Columbia Heights,
Minnesota (collectively "the Subject Properties ") ; and
WHEREAS, the HRA has identified Aeon as a qualified party of interest for purchasing the Subject
Properties subject to parties establishing a process for the sale consistent with the expressed goals of the HRA;
and
WHEREAS, the parties entered into the Memorandum of Understanding which outlines the goals and
expectation of each of the parties during the process leading up to the execution of a purchase agreement for the
sale of the Subject Properties by the PIRA; and
WHEREAS, Aeon has requested access to documents and data in the possession of the HRA for
purposes of implementing the goals and objectives of the HRA as identified in the Memorandum of
Understanding; and
WHEREAS, some of the documents and data sought by Aeon for review are classified as not public
under the Minnesota Data Practices Act, Minn. Stat. § 13.01 et seq.; and
HRA Minutes
Page 8
WHEREAS, access to the documents and data requested by Aeon is reasonably necessary for Aeon to
fulfill its obligations under the Memorandum of Understanding; and
WHEREAS, the Memorandum of Understanding may be modified by mutual agreement of the parties
in writing;
NOW THEREFORE, the parties hereby agree to the following:
1. The HRA will provide Aeon access to documents aid data in the possession of the HRA that
are reasonably necessary for purposes of Aeon implementing the goals and objectives of the HRA as identified
in the Memorandum of Understanding.
2. Aeon agrees to comply with the Minnesota Government Data Practices Act and all other
applicable state and federal laws relating to data privacy or confidentiality. All data created, collected, received
stored, used, maintained or disseminated by Aeon in performing its obligations under the Memorandum of
Understanding is subject to the requirements of the Act, and Aeon must comply with the requirements of the Act
as if it was a government entity. Aeon also agrees to hold the I -IRA, HRA Board members and its employees
harmless from any claims resulting from Aeon failure to disclose data maintained by Aeon and authorized for
release by the HRA, and from Aeon's unlawful disclosure or use of data protected under state and federal
laws. Any information, data, reports, records, contracts, work products or other materials given to or prepared
or assembled by Aeon under the Memorandum of Understanding shall be kept confidential and Aeon shall not
make any of this material available to any individual or organization without prior approval of the HRA. At the
termination of Memorandum of Understanding, all information, data, repots, records, contracts, work products
or other materials relating to the Aeon's assignment and duties under the Memorandum of Understanding shall
remain the property of the HRA.
AEON
By:
Alan Arthur
Its: President
Dated:
CITY OF COLUMBIA HEIGHTS
HOUSING AND REDEVELOPMENT AUTHORITY
By:
Walt Fehst
Its: Executive Director
HRA Minutes
Page 9
12. Appraisal
One of the many steps involved in the AEON negotiations is a need to commission an appraisal that will satisfy a
number of parties including the Minnesota Housing Finance Agency, tax credit investors and /or lending
institutions. Due to the nature of this transaction AEON views that it is best that an appraisal be conducted by the
Housing and Redevelopment Authority as the commissioning agency since we are the seller. Although the HRA
would order the appraisal AEON agrees that this would be done at their expense. Staff views that to order an
appraisal on AEON's behalf has no detrimental value to the FIRA, and is beneficial to have a third party opinion
regarding value. If the HRA is not satisfied with the appraisal and AEON is, the HRA can always elect at a future
date to expend funds to conduct a new appraisal.
Clark clarified that Aeon will select the appraiser based on companies they know to have the expertise in dealing
with these types of buildings and who are familiar with tax credits, fiord balances, and capital improvements. He
said there are very few firms out there who can provide an accurate appraisal taking all these factors into
consideration. He went on to explain this is not a binding appraisal for as or them. It is something they need in
order to obtain their financing.
Questions /Comments from members:
Nawrocki said he knows appraisers can come up with a wide range of figures. What do we do if we disagree with
the amount. Clark again stated this does not bind us to anything. It is an opportunity to get a first look at
someone's opinion about what the property might be worth. He said nothing stops the HRA from getting another
appraisal at a later date if we don't agree with the figure. Nawrocki thinks the City should be selecting the
appraiser, not Aeon. Clark told them that Aeon will identify three appraisers who are qualified to do this type of
appraisal and then will seek a RPP from them.
Diehm agreed there is nothing stopping us from getting another appraiser to either review their findings or to do a
whole separate appraisal if we choose to do so at a later time.
Motion by Peterson, seconded by Schmitt, to authorize Aeon sta�f'lo select an appraiser, on beha f of the HRA for
the purposes of an appraisal ofParkview Villa North and South wilh the understanding thatAEONwill he
financially responsible for all costs associated with this action.
Roll Call: All ayes. MOTIONPASSED.
13. Other Business
Move to Executive Session at 8:00 pin -To discuss the status of negotiations with AEON for sale of the
property at 965 40 °i Avenue NE.
The Executive Session and Regular meeting were adjourned at 8:45 pin.
The next regular HRA meeting is scheduled for Tuesday, April 24, 2012 at Parkview Villa.
Respectfully Submitted,
Shelley Hanson
Recording Secretary
HOUSING & REDEVELOPMENT AUTHORITY
MINUTES OF THE SPECIAL MEETING
OF MARCH 5, 2012
1. Call to order— The meeting was called to order by Chair Dichm at 7:20 pm
2. Roll Call — Members present: Bruce Nawrocki, Gary Peterson, Dolma Schmitt, Bobby
Williams, and Tammera Diehm.
Staff Present: Executive Director Walt Fehst, Community Development Director -Scott Clark,
and Secretary - Shelley Hanson
Aeon Representatives - James Lehnhoff, Gina Ciganik, and Melody Bridgeman (Consultant
from HM Collaborative).
3. Pledge of Allegiance - Recited
Move to an Executive Session at 7:20 pin to discuss Status of Negotiations with Aeon.
The Meeting re- convened at 8:13 pm.
BUSINESS ITEMS
4. Acknowledgement of Disclosure Statement
Notice was received that an attorney with Kennedy and Graven will be serving on the Board of
Directors with Aeon. The subject attorney will not be working with any Columbia Heights
HRA files and therefore does not create a conflict under the "Rules on Lawyers Professional
Responsibility or as a practical matter...." Clark explained a motion is needed to acknowledge
receipt of the notice dated February 23, 2012.
Questions from members:
No questions.
Motion by Schmitt, seconded by Williams, to authorize the Executive Director to sign an
Acknowledgment of Kennedy and Graven's Disclosure Letter dated February 23, 2012. All
ayes. MOTION PASSED.
5. Resolution 2012 -03 Authorizing HRA to submit SAC application
Clark explained that as part of the Special Application Center (SAC) process the HRA has to
provide authorization to make the application for the disposition of Parkview Villa North. Thi,,
Resolution provides that authorization. Staff recommends the HRA approve this Resolution.
Clark said the language states we are moving ahead with the sale of Parkview Villa. HUD will
not review anything that is not a bona fide application, so it has to contain this language and
must name Aeon as the purchaser. Aeon wants to have this submitted by the end of March.
Diehm said once the application is prepared, she wants to review a copy of it before it is sent
out, so she requested it be forwarded to them at least two days prior to it being sent.
Page 2
March 5, 2012
uestions from members:
Nawrocki stated he doesn't like the language in the Resolution as he believes it commits the City to go
through with the sale. He said he is not ready to commit to that since the final purchase price hasn't
been determined yet. Diehm clarified the language issues to Nawrocki and told him it doesn't lock us
in, just that we are supporting the process. Until there is a signed Purchase Agreement, either party
can terminate at any time in the process. He wants it on record that he is not in favor of committing to
the sale of Parkview until a sale price is negotiated in an acceptable amount.
Schmitt said the Resolution language should be changed to say "low- income and disabled adults and
seniors" (not just seniors).
Motion by Peterson, seconded by Williams, to waive the reading of Resolution 2012 -03 there being
ample copies available to the public. All ayes. MOTION PASSED.
Motion by Peterson, seconded by Williams, to adopt Resolution 2012 -03 with changes as noted
authorizing the HRA to submit application to HUD,for the disposition of Parkview Villa North.
Ayes- Diehm, Schmitt; Williams, Peterson Nay - Nawrocki MOTION PASSED.
RESOLUTION 2012 -03
COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY
RESOLUTION AUTHORIZING THE HRA TO SUBMIT APPLICATION TO HUD FOR THE
DISPOSITION OF PARKVIEW VILLA NORTH.
WHEREAS the City of Columbia Heights Housing and Redevelopment Authority (hereafter "HRA ")
currently owns Parkview Villa South, a 45 -unit residential building serving seniors; and
WHEREAS, the HRA also owns Parkview Villa North, a 101 -unit high rise with Public Housing
Authority designation serving low- income disabled adults and seniors; and
WHEREAS, Parkview Villa North and Parkview Villa South, together called "Parkview Villa ", provide
146 units of affordable apartment homes in the City of Columbia Heights; and
WHEREAS, Parkview Villa is the only property owned by the HRA; and
WHEREAS, The HRA determined that it would be in the best interest of the property to transfer
ownership to an entity that specializes in affordable housing rehabilitation, ownership, and management and has
the capacity to effectively operate the buildings over the long -term; and
WHEREAS, in Spring 2011 the HRA initiated a competitive selection process to identify a qualified
affordable housing developer that would meet the following HRA goals for the sale of Parkview Villa: 1)
Maintain the property as a strong and vibrant senior community; 2) Protect the existing rental price points for a
pre - determined period of time; 3) Agree to a long -term covenant that requires the property to operate as a senior
building; 4) Purchase the property at market price; and 5) Maintain a housing priority for Columba Heights
residents; and
WHEREAS, the HRA selected Aeon, a Minnesota 501(e)3 non -profit corporation, to own,rehabilitate,
and manage Parkview Villa.
Page 3
March 5, 2012
NOW THEREFORE BE IT RESOLVED, by the Columbia Heights HRA that the Authority expresses
its support of the request to dispose of the Public Housing units with its accompanying relocation plan; and
BE IT FURTHER RESOLVED, that the Executive Director is authorized to execute documents and
provide certifications and submit to HUD for approval a request to dispose of the 101 unit Parkview Villa North,
HUD project number MN 105000001.
Passed this 5th day of March, 2012
Offered by: Peterson
Seconded by: Williams
Roll Call: ayes- Dichm, Schmitt, Peterson, & Williams
Nay- Nawrocki
Chair
Shelley Hanson- Secretary
6. Update of Meeting regarding Notice to Residents-
A meeting was held February 22i" to notify residents of the process for relocation, even if it is not
needed. It is federally mandated to inform the residents and the language in the notice is
cumbersome as written by HUD. Clark explained that many residents are still confused by the
notice they received and the fact they have to sign a statement acknowledging receipt of the notice.
Therefore, staff and Aeon are meeting with the residents again Tuesday, March 6 °i at noon to
answer questions and alleviate any concerns they have. All residents have been personally notified
of this meeting, as well as a notice being posted. Copies of the notice were given to the Board
members in their packets.
Clark told the members that the individual who sent the letter to the Board has not attended any of
the meetings to date. Clark sent him a personal letter imploring him to attend the meeting on
March 6a' so his misunderstandings can be addressed. Diehm said she felt the meetings were
important and appreciates that Aeon is taking the time to explain the process to the residents. She
asked to see a copy of the original notice that HUD required. Aeon will get that to Clark who will
forward to each of the members. Diehm hopes that by appointing a member to the HRA from
Parkview that some of these issues could be prevented. She understands that incorrect information
can be very upsetting to some of the residents.
Page 4
March 5, 2012
6. Discussion of PHA Representative
Clark explained that the HRA has not had a PHA representative for over a year. The individual
who was selected has been unable to serve and was never sworn in. Over the next month, staff
will investigate filling the open position. If the individual cannot be sworn in at the April
meeting, staff wants direction on whether the Board wants to select another candidate from the
pool that was interviewed in 2011 or if they would like to restart the process. The goal is to
have a selection by the April meeting.
Comments from members:
Diehm said she will contact the resident who was appointed last year to see if she is willing to
serve and to be sworn in at the April meeting. If she is unable to do so, she is comfortable with
appointing one of the other two applicants that were interviewed last year. Nawrocki agreed
with Diehm and looks forward to appointing someone to fill the existing term at the April
meeting.
The next regular meeting will be Tuesday, April 24, 2012 at 7:00 pm at Parkview Villa.
The meeting was adjourned at 8:40 pm.
Respectfully submitted,
Shelley Hanson
Secretary
COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT AUTHORITY (HRA)
Meeting of: April 24, 2012
AGENDA SECTION: Consent Agenda
ORIGINATING
EXECUTIVE
NO: 5
DEPARTMENT: HRA
DIRECTOR
APPRO AL
ITEM: Financial Report and Payment of Bills
BY: Laura Frost
BY Alt
1/4
— Resolution 2012 -03
DATE: April 18, 2012
BACKGROUND:
A copy of the Financial Reports for the months of January, February and March 2012 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 2012 -03, there being ample copies
available to the public.
Motion: Move to approve Resolution 2012 -03, Resolution of the Columbia Heights Housing
and Redevelopment Authority (HRA) approving the Financial Statement and Payment of Bills
for the months of January, February and March 2012.
zu'iz -us ana
HRA ACTION:
HRA RESOLUTION 2012 -03
RESOLUTION OF THE COLUMBIA HEIGHTS HOUSING & REDEVELOPMENT
AUTHORITY (HRA) APPROVING THE FINANCIAL STATEMENT FOR JANUARY,
FEBRUARY, AND MARCH 2012 AND PAYMENT OF BILLS FOR THE MONTHS OF
JANUARY, FEBRUARY AND MARCH, 2012.
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
treasurer's vouchers or bills and if correct,
resolution in its records; and
HRA to examine the statement and
to approve them by resolution and enter the
WHEREAS, the financial statement for the months of January, February and March
2012 and the list of bills for the months January, February and March 2012 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 24th day of April 2012.
MOTION BY:
SECONDED BY:
AYES:
Chair
Attest by:
Shelley Hanson, Secretary
Parkview Villa Forth
Financial Statement Overview
March 2012
Revenue:
Occupancy for the month of March 2012 was 100% occupied;
Total Revenue was under budget amount (unfavorable). No Grant Income was
recognized in the month of March
Administrative Expenses:
Administrative costs for the North were under budget (favorable).
Other Renting Expenses were over budget (unfavorable), and reflect applicant screening
needed due to turnover.
Office Salary and Management fees are allocated incorrectly in February and March,
however the total matches budget
Office Supply expenses are under budget (favorable)
Computer Equipment and Maintenance reflects credit from February over charge
Legal Expenses was under budget (favorable).
Telephone, Answering Service and Internet expenses are under budget (favorable).
Utilities:
Utilities Expenses are under budget (favorable), however, these are quarterly billings
Electric was under budget (favorable)
Gas was under budget (favorable)
Water and Sewer were not invoiced in March
Operatinz and Maintenance Expense (supplies):
Operating and Maintenance Expenses are under budget (favorable).
Janitor Contract expenses were under budget (favorable)
Exterminating Contract is over budget (unfavorable)
Maintenance Supplies is slightly over budget (unfavorable)
Garbage and Trash are under budget (favorable); however, this is a quarterly billing
Security Contract is under budget (favorable).
Repairs Contract expenses were under budget (favorable)
Elevator Maintenance Contract is under budget (favorable)
Snow Removal is under budget (favorable).
Decorating Contract and Supplies were under budget (favorable)
Furniture and Fixtures is over budget (unfavorable) and reflects the replacement of 4
refrigerators, 4 ranges
Z
coos
b O O
0
O
D
�m vNn
o WboN
� j ONOUI
+ N 0000
WOO +VI (n +NO
AJZO NOWiJ U�AOm
D A O O N O O
wp. inv u
O O O O O V 0 O J O O 0
O O O O O O O O W O p O
O apses
b
b
00
00
N
O
0
O
W + U
b N N
;I;
S9900
m� 0
N OP+
IDW OI
ONi N O
P O P
Y A O
(A1JW
J W Y
O O O
O
E
0
m
10
e
C
0
a
2
n
d
n�
d
C
S A
d +
I N
o
X
O
o
N00Ni V AN
(Nil
Wow
°0
ooW +m�OO o mi°mo
OO °o °oo�l� °oo m:
m d3 n
Maas �i
moo Naameoo
IOOJNOI i
+N1lYN OW
ONOOJ4WiN VOOVVioo
p:
aNOaJ
�
N
IAmt
N WN
ON4WiN +IGN
W000
O O A O W
J
N j 8 l
J I
m
N o O P
b O J O O
O �fnTC
Y.
D 3.� m m c d OOd O�Da _.
N
m
AOm
OGI�
A
A� A q
0
m
^ z (�
C
N A
N
+
A
'm
o.
ov°i0
-
000800 A
a A+ aoaA.lo000om°no00 ion
mdr'mm
weowo0
i
Z
1.2� �-
cW i v AWn'.
_ _.cc
m
°m 2.3' 00?
WNW +(nNNNWN
O`l -.
N(NiI
p0+4+ OJiW
W W +OJOO(nY
OIO T VO
-.N -!
OI
OOi OViO l
mm -nm -lo
O
N m O+ 1
mN
J OmW
NAIWiINN +bNWa
j
AO
m NUi
OO O(N1lJ JWWN +VA
y'.
O:
llA+mo
NWN
NNm(n VAA�OJ�IAONPOOOOIOn
qqN
ppll
N
7
m m� NH N
P
?
0 2 F
N o m
m
m
m
coos
b O O
0
O
D
�m vNn
o WboN
� j ONOUI
+ N 0000
WOO +VI (n +NO
AJZO NOWiJ U�AOm
D A O O N O O
wp. inv u
O O O O O V 0 O J O O 0
O O O O O O O O W O p O
O apses
b
b
00
00
N
O
0
O
W + U
b N N
;I;
S9900
m� 0
N OP+
IDW OI
ONi N O
P O P
Y A O
(A1JW
J W Y
O O O
O
E
0
m
10
e
C
0
a
2
n
d
n�
d
C
S A
d +
I N
W
A + O
m Oma 00000
ONI
N00Ni V AN
(Nil
Wow
°0
ooW +m�OO o mi°mo
OO °o °oo�l� °oo m:
�. WNN��
+NO
Maas �i
moo Naameoo
IOOJNOI i
+N1lYN OW
ONOOJ4WiN VOOVVioo
p:
aNOaJ
�
N
N WN
ON4WiN +IGN
W000
O O A O W
J
N j 8 l
J I
coos
b O O
0
O
D
�m vNn
o WboN
� j ONOUI
+ N 0000
WOO +VI (n +NO
AJZO NOWiJ U�AOm
D A O O N O O
wp. inv u
O O O O O V 0 O J O O 0
O O O O O O O O W O p O
O apses
b
b
00
00
N
O
0
O
W + U
b N N
;I;
S9900
m� 0
N OP+
IDW OI
ONi N O
P O P
Y A O
(A1JW
J W Y
O O O
O
E
0
m
10
e
C
0
a
2
n
d
n�
d
C
S A
d +
I N
m Oma 00000
(Nil
(Nn
WN W WP
�. WNN��
+NO
J_.
A
OW
IOOJNOI i
+N1lYN OW
ONOOJ4WiN VOOVVioo
p:
aNOaJ
�
N
O O A O W
o o o o W W V S N o o
N
m
N o O P
b O J O O
Z W
Y.
N
O N D Ol O O J A+ N 0 0 0
A
O O O
0
N A
N
+
u °w
0o °o eao.Wn OlW.r -°•'u
o.
ov°i0
I
000800 A
a A+ aoaA.lo000om°no00 ion
Iw
weowo0
i
'
cW i v AWn'.
w
... 0
WNW +(nNNNWN
O`l -.
N(NiI
p0+4+ OJiW
W W +OJOO(nY
OIO T VO
-.N -!
OI
OOi OViO l
O
N m O+ 1
mN
J OmW
NAIWiINN +bNWa
j
AO
m NUi
OO O(N1lJ JWWN +VA
y'.
O:
llA+mo
NWN
NNm(n VAA�OJ�IAONPOOOOIOn
qqN
ppll
N
coos
b O O
0
O
D
�m vNn
o WboN
� j ONOUI
+ N 0000
WOO +VI (n +NO
AJZO NOWiJ U�AOm
D A O O N O O
wp. inv u
O O O O O V 0 O J O O 0
O O O O O O O O W O p O
O apses
b
b
00
00
N
O
0
O
W + U
b N N
;I;
S9900
m� 0
N OP+
IDW OI
ONi N O
P O P
Y A O
(A1JW
J W Y
O O O
O
E
0
m
10
e
C
0
a
2
n
d
n�
d
C
S A
d +
T ry o
o A O 90 °Ei
'OO -3 O e � � c �' �v�" '^ o` �.y �a?1'0 p1'00 m non •' m � 3.w V.� =C _ 00
O ll N j j C i N� 9 O ✓ 'Q S
'-`
A °x of
V
N
W
N
m
V
Q
J�o
O
O N
N
+ o
O o
(�
V
O A+ T.
W O. m...
X00
C1
O
JJ
� �
.
� � . � +mWO NN�OP
N
O O 100
O
O O W N O O V N O O+ IOOd
y
N
N O
L
W
O�
�W
q
+
m
o
' J +IJ 4a mNWNNN �
O +
+ 4
+W
VI
1Nli
W
W
m N O
VJ
O m N W
PP.. O m ONO W
O
O
O
�
W m
J 0
O W O J O J O W O O �1 J J N J O m
W 0
N
1Ai1
J
J
O
fJ
+JNA +NdN +1+
>O1 �1i
{n'1Nn
W
N
1010
d�mvi
m�om�0
mWmm 10 +aN
ulmm�`J'1n N- -Nm ?mw ,(Pn�'10
o
00
�W
mm0
p
A
JOJJ
+NOVW(11NOJ01A +JOWi VIWJ6
(�1'
+A1
fn
00
O
N
mV1
6008
0
NObV0+1N0
A.1�2o OLiA ODD
yO�
C
NN
'J+
p
Y
JA(o+ WOI fVnb TN0101i 41W
D
O
O J
ID
N
m A
W O A
)NO
VNi A w N m W J Y .+ m O V N O V N J N
00
OO
+
W
UI
W
IJN
IJ
W0W0
N
N
�OOtO
.P+ NmiN OOJ(N11JOA
+mNO N 1O m
U1
1Jm
A
O
LA
11N
m
NN
V IJ PN -�U JiO ID m InmIIN V
1V11N
J
(NII
1D
10 1NliON
0
Wt0...
0000.OJ(n >U0100 VJ
CN
O.
C�
AO
1010
O00
V
00100
+.00+0000..0
41
1Nj1
°i W
ID
N
i
IJ
INO
� � p
a
O
W W+.+W+N �+ W
W
NO�NO C�+IJN JIJ � O lY
WG
N 1
(VI1
1Jli O
A
V
AA
V b
tA.1 N P
V
A
A A (n W A NA N+
OA +�W �01N NmmJ +m 01N 1JJi
00
IJ
V
VI
V'V
AA
IJ'
+I
O
JtJ V
IJ0
0< mN0 m106F
- +Omm +bAN010DA ++ N1O
00
10
N
OO
m
10010
+OVVNDO•D 0m �J
Obi
O
D
p N
N A
N
N
N V
P
W A+ - W A N V m O W m W N
W
j
O
o
.�JI)i+pNO
y
pm Vi
°o
01
°o
O
O
O
M.
00AON00
O o 0 0 0 o O m ONO O
v i
0
o
bb
°o
IOIi
c
°o °0
W
obbb000bbbbbbobb
O N
°
N
°
�N oo
m
o
00
0
.............
OOOOO
00
O O
O O
9 O O
a
0
O O �
z z
DD D
0
S W
o
N O
O O
z
3
r
r
y
o
n
D
o 1
-1
m v W v
pD
-I 90
9
N
m_ 0
W
D
y
N
z
`-
4mi
N
H H
�rm
c 9
O
2
8 R
v
D
y
D
c a
c s n
r
m
00�
O
N
N H
GAAAA�'
o
b�
O N
a
ti
�O Z
�9r
na
a�w
�'
WHO
H
�A
ro
a
D�.�.
^
$D?
(pne
00
O O
O O
9 O O
a
0
O O �
z z
DD D
0
S W
o
N O
O O
A J
J
N Z
O
O <
aJ a
:V I
N [
a 5
o <
IJ" 1
A -. 3
N
a s
p c
o c
mNm memo
Ca V
000 OIO
O O O O O O
WW N N + W d
0 0 0 T W O
zzz zzz
DDD DDD
nN o0
�wN 'n rnN
O O O N N O
P.
z
3
n'D D
D
0.
A J
J
N Z
O
O <
aJ a
:V I
N [
a 5
o <
IJ" 1
A -. 3
N
a s
p c
o c
mNm memo
Ca V
000 OIO
O O O O O O
WW N N + W d
0 0 0 T W O
zzz zzz
DDD DDD
nN o0
�wN 'n rnN
O O O N N O
P.
popp.
POP
0.
zzz zzz
DDD D`DD
000
I
w
J
0
W', l
w --
V
o _
o y
W, l
G
00 2
A A
0
V V 0
W w
W b
mm G
W (VJ d
W W n
0
y� s
N (Wn
Ww O
O.� C
N N G
A Y
G
� v
� W
y
m
a v W
N
N
m
-
WW
r.
T
m
mu'Z
C
O
m
O
O O
O
O O O O O
O 6
m
o om
R m
.....
65m
(n
_a N
N
N N
N
lJ +
G
O; N
VNI
(Wli
VI
N G W ONi
+ �
V
J
J O
J
A
VI O O IJD
ip
A
L
N
N
VINO
WW
r.
O
m
O
O O
O
O O O O O
O 6
°
.....
65m
(n
_a N
N
N N
N
lJ +
G
O; N
VNI
(Wli
VI
N G W ONi
+ �
V
J
J O
J
A
VI O O IJD
ip
ZZ
zzzzz
�zG
DDDDD
D`Dm
O
N O
N
NI1�N00
AL
N.
s
W
o
N
�O_:
N
O
0
0 O
O
O O U O 000
J
N: lS
lU
0 W
W
O N
N
J
N O
00
N
NN(n00
AA0
z
z z Z Z
z G
N
D.D
DD
D
DDDDD
DD,
n
D
A
D
N
9 p +
O O
O
O
O
0000 00
C
.1.
d
L
Parkview Villa -North (165)
Balance Sheet March 2012
Books = Accrual
Assets
10100 Cash Balance
10200 Petty Cash
10400 Investments
11300 Rent Receivable
11500 Accounts Receivable
1.3200 Due From Other Government Units
Total Assets
Liabilities
20200 Accounts Payable
20210 Accrued Other Expenses
20220 Due to Resident Council
22000 Deposits
22200 Accrued PILOT
22210 Revenue Collected in Advance
Total Liabilities
Fund Balance
25300 Fund Balance
Total Fund Balance
Total Liabilities and Fund Balance
Mar -12
52,857.53
664.00
988,425.08
263.00
83.00
21,651.03
1,063,943.64
18,335.57
5,225.25
551.74
17,959.89
27,754.54
461.00
70,287.99
993,655.65
993,655.65
1,063,943.64
Pat kview Villa -North (165)
Income Statement
For The Period Ending March 2012
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
Month to Date
Year to Date
1
-
0.00%
-
0.00%
29,900.00
97.30%
86,220.00
96.58%
352.00
1.15%
1,024.00
1.15%
478.25
1.56%
2,030.63
2.27%
-
0.00%
-
0.00%
30,730.25
100.000/0
89,274.63
100.000/0
1000 -46330 Accrued Salaries
9,147.60
29.77%
25,861.60
Total Personal Services
9,147.60
29.770/a
25,861.60
Supplies
2000 -46330 Office Supplies
-811.90
-2.64%
598.67
2010 -46330 Minor Equipment
3,774.00
12.28%
3,774.00
2160 -46330 Maint. & Construct Materials
891.61
2.90%
2,500.25
2171 -46330 General Supplies
337.97
1.10%
876.08
Total Supplies
4,191.68
13.64%
7,749.00
Other Services & Charges
3040 -46330 Legal Fees
0.00
0.00°70
0.00
3050 -46330 Expert and Professional Services
0.00
0.00%
0.00
3060 -46330 Management Services
4,353.50
14.17%
14,089.50
3100 -46330 Protective Services
0.00
0.00%
3,667.00
3210 -46330 Telephone & Telegraph
480.70
1.56%
1,049.43
3430 -46330 Advertising Other
0.00
0.00%
-94.05
3600 -46330 Insurance & Bonds
1,741.75
5.67%
5,225.25
3810 -46330 Electric
3,496.50
11.38%
6,091.18
3820 -46330 Water
0.00
0.00%
0.00
3830 -46330 Gas
3,816.59
12.42%
8,683.98
3840 -46330 Refuse
279.21
0.91%
355.77
3850 -46330 Sewer
0.00
0.00%
0.00
4000 -46330 Repair & Maint. Services
2,713.96
8.83%
9,069.81
4050 -46330 Garage, Labor Burd.
161.15
0.52%
161.15
4100 -46330 Rents & Leases
186.75
0.61%
253.50
4300 -46330 Miscellaneous Charges
0.00
0.00%
25.00
4315 -46330 PILOT
1,850.30
6.02%
5,550.90
4390 -46330 Taxes & Licenses
0.00
0.00%
1,243.38
4500 -46330 Administrative Expenses
- 100.80
-0.33%
6,804.64
4850 -46330 Interest on Deposits
13.79
0.04%
40.14
Total Other Services & Charges
Capital Outlay
5120 -46330 Building & Improvements
Total Capital Outlay
Total Expense
Excess (Deficit) Revenue over Expense
950.14 3.09% 1,773.35 1.990/0
33,282.82 108.31% 97,600.53 109.330/a
- 2,552.57 - 8.31% - 8,325.90 -9.33%
7
18,993.40
950.14
61.81%
0.00%
62,216.58
1,773.35
69.69%
1.99%
950.14 3.09% 1,773.35 1.990/0
33,282.82 108.31% 97,600.53 109.330/a
- 2,552.57 - 8.31% - 8,325.90 -9.33%
7
Parkview Villa -North (165)
Cash Flow Statement
Period = March 2012
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
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, tabor 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,900.00
352.00
478.25
0.00
30,730.25
9,147.60
9,147.60
- 811.90
3,774.00
0.00
1,229.58
0.00
4,191.68
0.00
4,353.50
0.00
480.70
0.00
1,741.75
3,496.50
0.00
3,816.59
279.21
0.00
2,713.96
161.15
186.75
0.00
1,850.30
0.00
- 100.80
13.79
950.14
19,943.54
33,282.82
- 2,552.57
■
Parkview Villa -North (165)
Cash Flow Statement
Period = March 2012
Book = Accrual
Adjustments
10200 Petty Cash
10400 Investments
11300 Rent Receivable
11500 Accounts Receivable
13200 Due From Other Government Units
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
- 207.00
165,000.00
162.00
92.00
372.80
- 5,498.78
1,741.75
13.79
1,850.30
- 263.00
(166,736.14)
(169,288.71)
Beg Cash End Cash Difference
222,146.24
52,857.53
(169,288.71)
457.00
664.00
(207.00)
823,425.08
988,425.08
165,000.00
1,046,028.32
1,041,946.61
(4,495.71)
4/16/2012 3:54 PM
General Ledger (Accrual)
Paikvievv Villa -North - (165)
Months: Mar 2012
Property
Data
Period
Description Control
Refer
Debit
Credit
Balance
Remarks
1000 -46330
Accrued Salaries
16,714.00
= Beginning Balance =
165
313112012
03/12
(:Recur 339) :PoslRecurring Month [- 3 - 133241
RC
8,357.00
25,071.00
WC CHIC PR Mgmt Fee
165
3/3112012
03/12
Adj and reallocate 2 -3/12 mg 3- 133995
:Reversed by
790.60
25,861.60
Adj and reallocate 2 -3112 mg
NetChange= 9,147.60
25,861.60
= Ending Balance =
2000 -46330
Office Supplies
1,410.57
= Beginning Balance =
165
2122/2012
03/12
(offiBB04) Office Depot P -271072
5.96839E +ll
8.29
1,418.86
battery pk
165
2124/2012
03/12
(offiBB04) Office Depot P 272564
5.99436E +11
186.67
1,605.53
pens, shredder etc.
165
3/912012
03/12
(offiBB04) Office Depot P 273838
6.01382E +11
37.64
1,643.17
paper
165
3/14/2012
03/12
(chc) CommonBond Housing P- 272493
936636
9.46
1,652.63
on time delivery 02/12
165
3/21/2012
03/12
(offiBB04) Office Depot P- 274396
6.02616E +11
26.16
1,678.79
envelopes
165
3/27/201203/12
(chc) CommonBond Housing P- 274315
940918
1.55
1,68034
Postage 03/12
165
3/31/2012
03/12
Rev CHIC Comp Support billing 1- 133990
:Reversed by
1,081.67
598.67
Rev CHIC Comp Support billing
NetChange= - 811.90
598.67
= Ending Balance =
2010 -46330
Minor Equipment
0.00
= Beginning Balance =
165
3/21/2012
03/12
(all) All Inc. P- 274780
51200201.001
3,774.00
3,774.00
fings(4), ranges (4) etc.
NetChange= 3,774.00
3,774.00
= Ending Balance =
2160 -46330
Malnt. & Construct Materials
1,608.64
= Beginning Balance =
165
1/5/2012
03/12
(home7) HD Supply Facilities MaintE P- 271071
9/12756707
229.31
1,837.95
filter, tap gear
165
2/14/2012
03/12
(home32) Home Depot Credit Servl( P- 271068
5595107
106.38
1,944,33
kit faucet had, basscmft
165
2/24/2012
03/12
(home7) HD Supply Facilities Maink P- 271069
9113670130
91.05
2,035.38
angle stop, range hood etc.
165
2/28/2012
03/12
(wiim) Wilmar P- 272565
261575492
56.69
2,092.07
wrench, angle stop etc.
165
3/6/2012
03/12
(home7) HD Supply Facilities Maine P- 273295
9113858041pv
14.48
2,106.55
ice melt, pkg twist -n -lacks
165
3/12/2012
03/12
(home32) Home Depot Credit Semi( P-274397
821
27.87
2,134.42
vinyl tile, washers etc.
165
3/15/2012
03/12
(parki) Park Supply of America, Inc P- 273839
40746400
41.07
2,175.49
self tap screw
165
3/22/2012
03/12
(home7) HD Supply Facilities Malntc P- 274783
9114164643pv
324.76
2,500.25
bulbs etc.
NetChange= 891.61
2,500.25
= Ending Balance =
2171-46330
General Supplies
538.11
= Beginning Balance =
165
3/9/2012
03/12
(home7) HD Supply Facilities Maintc P- 273285
9113932796pv
SBb2
596.73
towels, gloves etc.
165
3/2112012
03112
(home7) HD Supply Facilities r intE P- 274782
911414481
68.02
664.75
cleaning prod
165
3121/2012
03112
(sher4110) Sherwin - Williams Co. P- 275409
78594
149.23
813.98
paint
165
3/23/2012
03/12
(peat) Peachtree Business Products P- 274779
P26632030001
62.10
876.08
Flags
NetChange= 337.97
876.08
= Ending Balance =
3060 -46330
Management Services
9,736.00
= Beginning Balance =
165
313012012
03/12
(chc) CommonBond Housing P- 274931
941335
13,548.00
23,284.00
mgmt fee 03112
165
3/31/2012
03/12
(:Recur 339) :PostRecuning Monlhl)- 133241
RC
8,357.00
14,927.00
R/C CHC PR Mgmt Fee
165
3/31/2012
03/12
Adj and reallocate 2 -3112 mg 3- 133995
:Reversed by
837.50
14,089.50
Adj and reallocate 2-3/12 mg
NetChange= 4,353.50
14,089.50
= Ending Balance =
3100 -46330
Protective Services
3,667.00
= Beginning Balance =
NetChange= 0.00
31667.00
= Ending Balance =
3210 -46330
'telephone & Telegraph
568.73
= Beginning Balance =
165
1/18/201203/12
(of86S8) Office of Enterprise Techm P- 271074
W111206BI112
132.17
700.90
phone svc- per end 12 /31/11
165
3/1/2012
03/12
(leve) Level One P- 272560
229214 -INpvn
93.43
794.33
answ svc - set up fees 3/12
165
3/2/2012
03/12
(comc3474) Comcast P- 272108
8.77211E +11
49.99
844.32
Internet svc 3/11 -4/10
165
3/7/2012
03/12
(cent9115) Centuryl-ink P- 272750
7637083978/0
38.90
883.22
phone svc - due 3124
165
3/1112017
03112
(mcic3718) MCI Comm Service P- 273837
7637883978pv
32.74
915.96
ph 2113 -3/8
165
3/21/201203/12.
(offi658) Office of Enterprise Techm P- 274398
200800187/02
133.47
1,049.43
phone svc - Per end 2 /29/12
NetChange= 480.70
1,049.43
= Ending Balance =
3430 -46330
Advedising Other
(94.05)
= Beginning Balance =
NetChanye= 0.00
(94.05)
= Ending Balance =
3600 -46330
Insurance & Bonds
3,483.50
= Beginning Balance =
165
3/31/201203/12
(:Recur 339):Posteecuning Monthh3- 133241
RC
1,741.75
5,225.25
C of Columbia Heights Ins Ac
NetChange= 1,741.75
5,225.25
= Ending Balance =
3810 -46330
Electric
2,594.68
= Beginning Balance =
165
3/12/2012
03/12
(xce0 %cel Energy P- 273049
5150441553/0
3,496.50
6,091.18
elec svc 2/06 -3/06
NetChange= 3,496.50
6,091.18
= Ending Balance =
3830 -46330
Gas
4,86739
= Beginning Balance =
165
3/7/2012
03112
(cent) CenterPoint Energy P- 272248
55199657/021
3,816.59
8,683.98
gas svc 2/03 -3/06
NetChange= 3,816.59
8,683.98
= Ending Balance =
1 Page 1
General Ledger (Accrual)
Parkview Villa -North - (165)
Months: Mar 2012
Property
Date Period Description Control
Refer
3840 -46330
Refuse
355.77 trash Svc -03/02
165
312/2012 03/12
Qpolll Green Lights Recycling I 272763
12- 2084pvn
50.86
6,406.71 angle stop, range hood etc.
NetChange= 279,21
6,463.64 sanding 2/28
4000 -46330
Repair & point. Services
65.55
165
2/24/2012 03112
(home7) HD Supply Facilities Mains P- 271069
9113670130
165
2/28/2012 03/12
(mgsp) MGS Professional Bldg Maim P- 272563
10396pvn
165
3/t/2012 03/12
leapt l) Eagle Elevator Corp. P-272757
113297 -Ipvn
165
3/3/2012 03/12
(a9sp)PIGS Professional Bldg Malnl P- 272562
10403pvn
165
3/3/2012 03/12
(mgsp) MG5 Professional Bldg MaInl P -272561
10419pvn
165
3/6/2012 03112
(dire) Direct Home Appliance Servlo P- 272752
030612pm
165
3/6/2012 03/12
(home7) HD Supply Facilities Maints P- 273295
9113858041pv
165
3/15/2012 03/12
RmI7740) Drain King, Inc. P- 275408
83633
165
3/1612012 03/12
(adam) Adam's Pest Control, Inc. P- 275406
707162
165
3119/2012 03/12
(adam) Adam's Pest Control, Inc. P- 275403
702932pvn
165
3/26/2012 03/12
(arbo) Arbor Barber, Inc. P- 274781
32612
165
3/27/2012 03/12
(cust5044) Custom Appliance Servlc P- 275407
8462
6,905.44 = Beginning Balance =
100.80
NetChange= 2,713.96
4050 -46330
Garage, Labor Boni.
13.79
165
3/2712012 03/12
(sign6160) Signs By RSG P- 275410
696pva
823.21 = Beginning Balance =
950.14
NetChange= 161.15
4100-46330
Rents & Leases
165
2/29/2012 03112
(mutt]) Multihousing Credit Control P- 273296
1202037/
165
3/20/2012 03112
(chc) CommonBond Housing P- 273378
937075
NetChange= 186.75
4300 -46330
Miscellaneous Charges
NetChange= 0.00
4315 -46330
PILOT
165
3131/2012 03/12
(a Recur339): PostRecurring Manthil- 133241
RC
NetChange= 1,850.30
4390 -46330
Taxes & Licenses
NetChange= 0.00
4500_46330
Administrative Expenses
165 12/31/2011 03/12
(10004027) Teague C- 937046
NetChange= - 100.80
4850 -46330
Interest on Deposits
165 3131/2012 03/12
Sec Dep interest accrual 3- 133243
G31
NetChange= 13.79
5120 -46330
Building & Improvement
165 3/19/2012 03/12
(wait) WAI Continuum P- 275411
11120
NetChange= 950.14
4/16/2012 3:54 PM
Debit Credit
Balance Remarks
76.56 = Beginning Balance =
278.21
355.77 trash Svc -03/02
355.77 = Ending Balance =
6,355.85 = Beginning Balance =
50.86
6,406.71 angle stop, range hood etc.
56.93
6,463.64 sanding 2/28
688.17
7,151.81 me malat -03112
65.55
7,217.36 snow ni 2/29
86.25
7,303.61 snow Ravi 3/01
84.00
7,387.61 washer repair
35.07
7,422.68 ice melt, pkg Nrisl -n -locks
215.00
7,637.68 plbg Svc -315
910.56
8,546.24 pest svc 3116
98.97
8,597.21 pest svc 3/19
295.32
8,892.53 om part per est - tree rmvl
177.28
9,069.81 oven we - 709
9,069.81 = Ending Balance =
0.00 = Beginning Balance =
161.15
161.15 bulbs, svc call
161.15 = Ending Balance =
66.75 = Beginning Balance =
180.00
246.75 bckgrnd cks 2/12
6.75
253.50 1 aix emply verif 02/12
253.50 o Ending Balance =
25.00 = Beginning Balance =
25.00 = Ending Balance =
3,700.60 = Beginning Balance =
1,850.30
5,55090 Anoka Cry Property Tax Accra
5,550.90 = Ending Balance =
1,243.38 = Beginning Balance =
1,243.38 = Ending Balance =
6,905.44 = Beginning Balance =
100.80
(1D0.80) Rev bad debt write off duet
6,804.64 = Ending Balance =
26.35 = Beginning Balance =
13.79
40.14 Sec pep interest accrual
40.14 = Ending Balance =
823.21 = Beginning Balance =
950.14
950.14 aKhttlactural rvc, to 03/18
1,773.35 = Ending Balance =
43,659.79 10,376.97
Page 2
5016456
Parkview Villa North 4/9/12
Bank Reconciliation Report
03/31/2012
Balance Per Bank Statement as of 03/31/2012
$53,744.88
02/09/2011
1199
court325 - Court Administration
55.00
02/09/2011
1200
coud325 - Court Administration
320.00
03121/2012
1640
dire - Direct Home Appliance Services
84.00
03121/2012
1644
mgsp - MGS Professional Bldg Maint Sery Inc
208.73
03/28/2012
1649
home7 - HD Supply Facilities Maintenance
108.17
03/28/2.012
1650
mcic3718 - MCI Comm Service
32.74
03/28/2012
1652
off i8804 - Office Depot
37.64
03/28/2012
1653
park/ - Park Supply of America, Inc.
41.07
Less:
Outstanding Checks
1616
$887.35
48.97
Reconciled
Bank Balance
$52,857.53
Balance per
GL as of 03/31/2012
chc - CommonBond Housing
$52,857.53
Reconciled
Balance Per G/L
$52,857.53
Difference 0.00
Cleared Items:
Cleared Checks
Date
Tran #
Notes
Amount
Date Cleared
12/22/2011
1545
t0004004- Alunovic
120.55
03/3112012
02115/2012
1607
mgsp - MGS Professional Bldg Mainl Sew Inc
65.55
03131/2012
02/23/2012
1611
cent - CenterPoint Energy
4,86739
03/31/2012
02/23/2012
1614
park1 - Park Supply of America, Inc.
144.04
03131/2012
03101/2012
1616
adam - Adam's Pest Control, Inc.
48.97
03/31/2012
03101/2012
1617
chc - CommonBond Housing
1,118.33
03/31/2012
03/01/2012
1618
colu - City of Columbia Heights
6,303.75
03131/2012
03/01/2012
1619
colu825 - Columbia Heights Fire Dept
1,243.38
03/31/2012
03/01/2012
1620
eagll - Eagle Elevator Corp.
543.00
03/31/2012
03/01/2012
1621
mcic3718 - MCI Comm Service
24.83
03/31/2012
03/0112012
1622
multi - Mullihousing Credit Control
60.00
03/31/2012
03/0112012
1623
of J8804 - Office Depot
70.57
03/31/2012
03/07/2012
1624
buck8411 - Buckeye Cleaning Centers
84.33
03/31/2012
03/07/2012
1625
cent9115 - Centuryl-ink
38.90
03/31/2012
03/07/2012
1626
chc - CommonBond Housing
13,548.00
03/31/2012
03/07/2012
1627
cus15044 - Custom Appliance Service LLC
177.32
03/31/2012
03/07/2012
1628
drai7740 - Drain King, Inc.
135.00
03/31/2012
I
I5
4/9/12_
Parkview Villa North
Bank Reconciliation Report
03/31/2012
5016456
03/07/2012
1629
mgsp - MGS Professional Bldg Maint Sew Inc
65.55
03131/2012
03/07/2012
1630
offi658 - Office of Enterprise Technology
136.88
03131/2012
03107/2012
1631
waic - WAI Continuum
235.54
03/31/2012
03/1412012
1632
cent - CenterPoint Energy
3,816.59
03/31/2012
03/14/2012
1633
comc3474 - Comcast
49.99
03/31/2012
03114/2012
1634
home32 - Home Depot Credit Services
106.38
03/31/2012
03/14/2012
1635
home7 - HD Supply Facilities Maintenance
371.22
03/3112012
03/14/2012
1636
offi658 - Office of Enterprise Technology
132.17
03/31/2012
03/14/2012
1637
offi8804 - Office Depot
8.29
03/3112012
03/2112012
1638
cent9115- CenturyLink
38.90
0313112012
03/21/2012
1639
chc - CommonBond Housing
1,254.42
03/31/2012
03/2112012
1641
eagll - Eagle Elevator Corp.
688.17
03/31/2012
03/21/2012
1642
gree1004 - Green Lights Recycling Inc
279.21
03/3112012
03/21/2012
1643
love - Level One
93.43
03131/2012
03/2112012
1645
offi8804 - Office Depot
186.67
03/3112012
03/21/2012
1646
wilm - Wilmar
56.69
03/31/2012
03/21/2012
1647
xcel - Xcel Energy
3,496.50
03/31/2012
03128/2012
1648
chc - CommonBond Housing
378.23
03/31/2012
03/28/2012
1651
multi - Multihousing Credit Control
180.00
03/31/2012
Total
$40,168.74
Cleared Deposits
Date
Tran #
Notes
Amount
Date Cleared
03/02/2012
384
operations
19,532.00
03131/2012
03/0612012
385
operations
9,874.00
03131/2012
03/08/2012
386
operations
429.00
03/31/2012
03/09/2012
387
operations
236.25
03/31/2012
03/13/2012
388
operations
380.80
0313112012
03/16/2012
389
operations
370.00
03131/2012
Total
$30,822.05
Cleared Other Items
Date
Tran #
Notes
Amount
Date Cleared
03/14/2012
JE 133245
NEB transfer to City investment
- 165,000.00
03/3112012
0313112012
JE 133244
NEB ei-OCCS Capital Fund Prog rec
372.80
03131/2012
Total
- $164,627.20
I5
4/9/12_
Date 3/30/12 Page 1
Primary Account @XXXXX @6456
Enclosures 42
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 - - --
EFFECTIVE MAY 1, ALL AUTOMATIC FUNDS TRANSFERS (AFTS) WILL
REDUCE YOUR AVAILABLE BALANCE AT THE START OF BUSINESS DAY
ON THE SCHEDULED TRANSFER DATE. II' YOUR TRANSFER IS
SCHEDULED FOR A MONDAY, THIS WILL AFFECT YOUR AVAILABLE
BALANCE ON THE WEEKEND OR HOLIDAY. EARLY ACCOUNT CLOSING FEE
OF $20 FOR HEALTH SAVINGS ACCOUNTS CLOSED PRIOR TO 3 MONTHS.
NORTHEAST PUBLIC FUNDS ACCT Number of Images 42
Account Number @XXXXX @6456 Statement Dates 3/01/12 thru 3/31/12
Previous Balance 227,718.77 Days in the Statement Period 31
7 Deposits /Credits 31,194.85 Average Ledger 134,206
37 Checks /Debits 205,168.74 Average Collected 132,348
Service Charge .00
Interest Paid .00
Ending Balance 53,744.88
Deposits
and Credits
Date
Description
Amount
3/02
DDA REGULAR DEPOSIT
19,532.00
3/07
DDA REGULAR DEPOSIT
9,874.00
3/08
DDA REGULAR DEPOSIT
429.00
3/09
DDA REGULAR DEPOSIT
236.25
3/13
MISC PAY HUD TREAS 303
372.80
CR
3031036218 03/1.3/12
ID #- 411269646860103
TRACE 4- 031036210104343
3/13
DDA REGULAR DEPOSIT
380.80
3/16
DDA REGULAR DEPOSIT
370.00
Charges and Debits
Date Description
3/1.4 Xfer to 0009 HRA OF CH SVGS
Amount
165,000.00
Date 3/30/12 Page 2
Primary Account 9XXXXX @6456
Enclosures 42
NORTHEAST PUBLIC FUNDS ACCT
@XXXXX @6456
(Continued)
Checks
in serial order
Date
Check#
Amount
Date
Check#
Amount
3/07
2
60.00
3/15
1630
136.88
3/05
1545*
120.55
3/14
1.631
235.54
3/21
1607*
65.55
3/21
1.632
3,816.59
3/01
1611*
4,867.39
3/22
1633
49.99
3/02
1614'"
144.04
3/20
1634
106.38
3/06
1616*
48.97
3/20
1635
371.22
3/05
1617
1,118.33
3/23
1636
132.17
3/08
161.8
6,303.75
3/23
1637
8.29
3/09
1619
1,243.38
3/27
1638
38.90
3/06
1620
543.00
3/26
1639
1,254.42
3/13
1621
24.83
3/26
1641*
688.17
3/16
1623*
70.57
3/30
1642
279.21
3/13
1624
84.33
3/30
1643
93.43
3/13
1.625
38.90
3/30
1645*
186.67
3/09
1626
13,548.00
3/26
1646
56.69
3/26
1627
177.32
3/26
1647
3,496.50
3/1.2
1628
135.00
3/30
1648
378.23
3/21
1629
65.55
3/30
1651*
180.00
* Indicates
skip in check
numbers
Daily
Balance Section
Date
Balance
Date
Balance
Date -
Balance
3/01
222,851.38
3/12
229,657.61
3/22
60,714.88
3/02
242,239.34
3/13
230,263.15
3/23
60,574.42
3/05
241,000.46
3/14
65,027.61
3/26
54,901.32
3/06
240,408.49
3/15
64,890.73
3/27
54,862.42
3/07
250,222.49
3/16
65,190.16
3/30
53,744.88
3/08
244,347.74
3/20
64,712.56
3/09
229,792.61
3/21.
60,764.87
* * * F. N
D O F
S
T A T E
M E
N T
1.17
Payment Summary
Bank= 1650pr AND mm /yy= 03/2012 - 03/2012 AND Check Date = 03/01/2012 - 03/31/2012 AND All Checks =Yes AND Include Voids =All Checks
6
Check
Post
Total
Date
Bank
Check#
Vendor
Date
Month
Amount
Reconciled
165opr - Parkview
Villa
North
1616
Adam - Adam's Pest Control, Inc.
03/01/2012
03/2012
48,97
03/31/2012
165opr- Parkview
Villa
North
1617
chc - Common Bond Housing
03/01/2012
03/2012
1,118.33
03/31/2012
165opr - Parkview
Villa
North
1618
coiu - City of Columbia Heights
03/01/2012
03/2012
6,303.75
03/31/2012
165opr - Parkview
Villa
North
1619
coh -825 - Columbia Heights Fire Dept
03/01/2012
03/2012
1,243.38
03/31/2012
165opr Parkview
Villa
North
1620
eagll - Eagle Elevator Corp.
03/01/2012
03/2012
543
03/31/2012
165opr - Parkvlew
Villa
North
1621
mcic3718 - MCI Comm Service
03/01/2012
03/2012
24.83
03/31/2012
165opr - Parkview
Villa
North
1622
multi - Multihousing Credit Control
03/01/2012
03/2012
60
03/31/2012
165opr - Parkview
Villa
North
1623
offi8804 - Office Depot
03/01/2012
03/2012
70.57
03/31/2012
165opr- Parkview
Villa
North
1624
buck8411 - Buckeye Cleaning Centers
03/07/2012
03/2012
84.33
03/31/2012
165opr - Parkview
Villa
North
1625
cem9115 - CenturyLink
03/07/2012
03/2012
38.9
03/31/2012
165opr- Parkview
Villa
North
1626
chc- Common Bond Housing
03/07/2012
03/2012
13,548.00
03/31/2012
165opr- Parkview
Villa
North
1627
cust5044 - Custom Appliance Service LLC
03/07/2012
03/2012
177.32
03/31/2012
165opr- Parkview
Villa
North
1628
drai7740 - Drain King, Inc.
03/07/2012
03/2012
135
03/31/2012
165opr - Parkview
Villa
North
1629
mgsp - MGS Professional Bldg Point Sery Inc
03/07/2012
03/2012
65.55
03/31/2012
165opr - Parkview
Villa
North
1630
offi658 - Office of Enterprise Technology
03/07/2012
03/2012
136.88
03131/2012
165opr- Parkview
Villa
North
1631
wale - WAI Continuum
03/07/2012
03/2012
235.54
03/31/2012
165opr- Parkview
Villa
North
1632
cent- CenterPoint Energy
03/14/2012
03/2012
3,81659
03/31/2012
165opr- Parkview
Villa
North
1633
comc3474 - Comcast
03/14/2012
03/2012
49.99
03/31/2012
165opr - Parkview
Villa
North
1634
home32 - Home Depot Credit Services
03/14/2012
03/2012
106.38
03/31/2012
165opr- Par kvlew
Villa
North
1635
home7 - I ID Supply Facilities Maintenance
03/14/2012
03/2012
371.22
03/31/2012
165opr Parkview
Villa
North
1636
offi658 - Office of Enterprise Technology
03/14/2012
03/2012
132.17
03/31/2012
165opr - Parkview
Vila
North
1637
offi8B04 - Office Depot
03/14/2012
03/2012
8.29
03/31/2012
165opr Parkview
Villa
North
1638
cent9115 - CenturyLink
03/21/2012
03/2012
38.9
03/31/2012
165opr - Parkview
Villa
North
1639
chc - Common Bond Housing
03/21/2012
03/2012
1,254.42
03/31/2012
165opi - Parkview
Villa
North
1640
dire - Direct Home Appliance Services
03/21/2012
03/2012
84
165opr- Parkview
Villa
North
1641
eagit - Eagle Elevator Corp.
03/21/2012
03/2012
688.17
03/31/2012
165opr- Parkview
Villa
North
1642
gree1004 - Green Lights Recycling Inc
03/21/2012
03/2012
279.21
03/31/2012
165opr- Parkview
Villa
North
1643
[eve - Level One
03/21/2012
03/2012
93.43
03/31/2012
165opr Parkview
Villa
North
1644
mgsp - PIGS Professional Bldg Paint Sery Inc
03/21/2012
03/2012
208.73
165opr - Parkview
Villa
North
1645
ofO8B04 - Office Depot
03/21/2012
03/2012
186.67
03/31/2012
165opr - Parkview
Villa
North
1646
wllm - Wllmar
03/21/2012
03/2012
56.69
03/31/2012
165opr- Parkview
Villa
North
1647
xcel- Xcel Energy
03/21/2012
03/2012
3,496.50
03/31/2012
165opr- Parkview
Villa
North
1648
chc - Common Band Housing
03/28/2012
03/2012
378.23
03/31/2012
165opr- Parkview
Villa
North
1649
home7 - HD Supply Facilities Maintenance
03/28/2012
03/2012
108.17
165ofer - Parkview
Villa
North
1650
mcic3718 - MCI Comm Service
03/28/2012
03/2012
32.74
165opr- Parkview
Villa
North
1651
multi - Multihousing Credit Control
03/28/2012
03/2012
180
03/31/2012
165opr - Parkview
Villa
North
1652
offl8804 - Office Depot
03/28/2012
03/2012
37.64
165opr - Parkvlew
Villa
North
1653
parkl - Park Supply of America, Inc.
03/28/2012
03/2012
41.07
35,483.56
6
Parkview Villa South
Financial Statement Overview
March 2012
Revenue:
Occupancy for the month of March was 93 % occupied
Total Revenue was slightly lower than budget amount (unfavorable)
Administrative Expenses:
Administrative costs for South are over budget (unfavorable)
Office Salaries and Management Pees were not allocated correctly, but total amount is correct per
budget
Advertising costs were over budget (unfavorable) and reflect the cost of ad for available units
Office Supplies were under budget (favorable)
There were no Legal Expenses billed out for March.
Telephone, Answering Service and Internet expenses are over budget (unfavorable) and reflect
payment of invoices from January and February
Utilities:
Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing
Electric was under budget (favorable)
Gas was over budget (unfavorable)
Water and Sewer were not unvoiced this month
Operating and Maintenance Expense
Operating and Maintenance Expenses were under budget (favorable)
Janitor and Cleaning Contracts was under budget (favorable)
IG
Exterminating Contract was under budget (favorable)
Garbage and Trash Removal are under budget (favorable); however this is a quarterly billing and
the amount billed is for recycling only
Repairs Material and Contract costs were under budget (favorable).
Grounds Contract is over budget (unfavorable) due to tree removal
Elevator Contract is over budget (unfavorable) and reflects the cost of repair service
Snow Removal costs were under budget (favorable)
Heating and Cooling Maint and Repairs was under budget (favorable)
Parking Lot Maint /Repairs was over budget (unfavorable) and reflects the cost of replacing light
bulbs in the parking lot and the lift truck
Decorating contract costs were over budget (unfavorable), and reflect cost associated with carpet
installation, painting and repairs to restored unit
2 v
V
O
a'OZd
O]
ANAA
rv�
C
_ Nw
S
T
m
m
c
"�
o�'°�"
m
F�310�<�8
m
�d
m
ry
N
3' T
Fi
EC
q m
o N N
A
x?
N
m x
N
O F
z
8
,�
a
N
O
p A O N
m
O m m 0 0 0 0
O O 0 0 0 0
V
N
O O N O
N
N
O N
d
W
N
O
A
+ .a
OI
(J
�T
ONi
ONi
b
b
+
N➢ ~O b
N
Q
N m
A
N
J'�
�
b
OOJJOW
O o O
m d m NNOiN
Ip.
NOm N
(O
NW
6
W
NJO(JIiO
mW�
00000
AmON(wJWN�l
1wJOWUIO
w NmNOm
�.
UmjmOOO
A
>'J
-P
m
r v r N
e
°o °Om °o v`.'OO °o °P
�o
+DOO
W
Wm➢
n
Om
J
N
N
O
J
J
(J A
W
O O
V
m O O J O O O O
JON
m
.M1
W
0 0 J
W
J
W
b O A
0
..........
Jw
�"`
J
Jt,Nli
n+
00000
+N
Ooi (OA INIiNNJm�
+OOWN
P
G
�
o 'O'
NOO
O'UNi 'O .Pm ➢'UJ
��D O
^I
A"
m0
+O(n0
m
m�OW
.�
00
00
Ui �D PID
m!
�o
Jm
O
pm�aommo-
+u,omJmN
�o�nm
(�
N
O (JJ
N
O N 0 A
mip
W W O O + O O+ O O J
+
N
N Z m O
!J
N
J N
m
ONO A
w
N+ N 0 0 0 O Oml JN O O W
N
N
O� D W 9
ONI
N
w A
i
O
D
�j
4� INJ
om�
N
N +NN N'J
AN
N
A
AN
O O
0➢
N 0
O
O A
VIOA
w
oO wOONO
,
9jO°o
°0000
°oo °P °. P°
N o
OPOPO o..O o
00
V
N
J
N
N �
m
m VWl
0
CJ
W N
J V
A
O
W
O
O
0
O
Q
D
TR
� N O
V �
0
f°l1
A4
000
NOAib
p W W
fJ
p'p
O
7
O
W
fWJ J
J O
I l8il
}tln0
h
C MU
J
A
N I[al
A
Y A
IWO
N
mw
um
°ou
a N
oo
a
N
A
U W
O V
+ OI
N
N W
W
3
O
J Jw
JW
q
a O
N
a
N.N
N m
NN
W
W
_V
p� -
V1
Ili 41
y
N O
o Wbtl �3 n3�lo N? W= N�
J N
N
O
A
� VI
VN O
._-Nemvp
�
�
W
W
p+ U >
N
J
N
N �
m
m VWl
0
CJ
W N
J V
A
O
W
O
O
0
O
Q
D
TR
� N O
J
V
ti
_ _ O
O W O O A O W O W O O A A O O b d
~V
O
p INiI O O O W° o O O W P O m J W �
yG
N d
NNPN +mNbNOWa(Wli >JN (1
OWOOOIW (ll °J mNUJiWNJOL m
Y N J OD N J W a W J O IO N O b D
s
N N v v O
41JN bNNN
W OOI (n NA W
O OOD - CO 0 >ONO 6
°on °o °o °o liOO �o� °om� °OO °om m
�JipNNW +(NIIN +NAOAJW m
A NN0 OWi OIm OOONNWN
�+DI°OVTDJOP OI (NJDOONNObm
O1 +1D N-�NWN WOr OIN
0000000 Nin +'o blo'O°'vb D
. ONINl�Ol00 O �
V �
�
f°l1
A4
000
NOAib
N
fJ
p'p
O
+W
O
W
fWJ J
J O
I l8il
}tln0
h
C MU
J
A
N I[al
A
Y A
IWO
N
mw
um
°ou
a N
oo
a
N
A
U W
O V
+ OI
N
N W
W
OI
W
J Jw
JW
W N
J
ONCo
N
NN
W
W
_V
p� -
V1
Ili 41
W
O
N O
J
J N
N
O
A
� VI
VN O
J
V
ti
_ _ O
O W O O A O W O W O O A A O O b d
~V
O
p INiI O O O W° o O O W P O m J W �
yG
N d
NNPN +mNbNOWa(Wli >JN (1
OWOOOIW (ll °J mNUJiWNJOL m
Y N J OD N J W a W J O IO N O b D
s
N N v v O
41JN bNNN
W OOI (n NA W
O OOD - CO 0 >ONO 6
°on °o °o °o liOO �o� °om� °OO °om m
�JipNNW +(NIIN +NAOAJW m
A NN0 OWi OIm OOONNWN
�+DI°OVTDJOP OI (NJDOONNObm
O1 +1D N-�NWN WOr OIN
0000000 Nin +'o blo'O°'vb D
. ONINl�Ol00 O �
�
NOAib
fJ
p'p
O
+W
V
Nmin
I l8il
}tln0
h
C MU
J
J
V
ti
_ _ O
O W O O A O W O W O O A A O O b d
~V
O
p INiI O O O W° o O O W P O m J W �
yG
N d
NNPN +mNbNOWa(Wli >JN (1
OWOOOIW (ll °J mNUJiWNJOL m
Y N J OD N J W a W J O IO N O b D
s
N N v v O
41JN bNNN
W OOI (n NA W
O OOD - CO 0 >ONO 6
°on °o °o °o liOO �o� °om� °OO °om m
�JipNNW +(NIIN +NAOAJW m
A NN0 OWi OIm OOONNWN
�+DI°OVTDJOP OI (NJDOONNObm
O1 +1D N-�NWN WOr OIN
0000000 Nin +'o blo'O°'vb D
. ONINl�Ol00 O �
J y 0 D o y ti e� W n
O v w a o ❑D❑ o o y v d
o O o D m n _ G g v �' y m z E n f? (p m
G mm(n (no a D�' G ti y a pG2 DDD �Cl� ol^
oc DSO C. rmii m �° HN SS SG °m
P y
N�vC FF z y Y' Nm K' ''Gg m''° G o tzn
2 0 0 9 a Q N 1p N D F G .'!1 (pU (pU N f1 o J W N n W
0 m P v
.1 n IFD N_ IAD N O N Po
G o S G
A N
Ala 4 k
N
Nm
000 ��O
OW1 O
f1N
O O O
Ui C
+
a
O
boo
000 °o
°o °° cc
fWil
W J
W
N
N W
o O o
O O �
mm o'
zz�zz
Zz
I
zi i
DDD
➢D DD
D:)
W
fWil
W J
W
N
N W
W
tN+�fn00 N(Wi�
W.
°0000
AA
(WII ' (
00
00000
00
0-
-'
O
000000
°° oao
b
°O
A
wWNwS
O
.w:.i
00
Nw
iDO W
O
ob°o
o °OO iaa
i
zzzzz
'nan
7 zl.
N
W W
n'n
an
a'
W
b
oO
boo
boo
W
2
J
c
°o
°o °O
°O °o boo
.o
°o
°O
.
90 °oo
OO
p'.
W
fWil
W J
W
Q
n
00
fJli
T(mO m
+W NJ
O
O
O�.
°O
A
o
O
v
00
IaD
iDO W
O
(J
N
W W
W
N
O
W
b
oO
boo
boo
W
J
p mm
J
c
°o
°o °O
°O °o boo
.o
°o
°O
.
O
oo
o°
boO
mW.W
(°i�N
N
U
OAR
00
90o0
Wm0
OWiJ
O
O
J6
K
z z
Z z �
z Z 0.
N O
8
6
v
DD
DD`D
➢DD
ism
°o
°o
O
O
ONi
� 40i W
OI O
O
O
A
°O
000
fIINO
WW
O
O
Od
J
IJ 2
N
W
�
00
O°
000
a00
OHO
�O
NYNI
W O
O°
ON
O
b
R
o.
o
e
z >z
�Z�
c
c
cy
'n
'n Dnn
a'nD
Poo
w�
o
0
°o
°o
°O
n
ob.
W
m
o > C_
N O a u? fO
NC7
as WT
O
z
O uNN
vm
V
A V
J
J N
N
N 0
� A
N
N
+Ut 01O
fAi1W
d
W
O
W
m
W
O' O
O
O O
O
O
P
0 �O
�O
O
O
O
O O
O O
•W .....
v
r
� A J �
01
(Oii
0
nnnan
0
W
n
(A11
O
O
W W J N
f 11 W
W
W p
N J 0
NA
O
J
W
P
Oo
O
o000o
a
..bob
m
m
A;
1O
1DON
+01
W W
W
W O
O
W W NJ W
A
W, W
W
W W
ANJO+
(d1
0
e
Z
L "L
a
rx/
o w
n
O N W
/
O O
P.
.....
.
9 O
O
C
C 0 0 0
� N
O�.
V
Parkview Villa South (166)
Balance March 7.012
Books = Accrual
Assets
10100 Cash Balance
10200 Petty Cash
10400 Investments
11300 Rent Receivable
11500 Accounts Receivable
Total Assets
Liabilities
20200 Accounts Payable
20210 Accrued Other Expenses
22000 Deposits
22200 Accrued PILOT
22210 Revenue Collected in Advance
Total Liabilities
Fund Balance
25300 Fund Balance
Total Fund Balance
Total Liabilities and Fund Balance
25
Mar -12
29,877.67
186.00
713,970.36
377.00
6.00
744,417.03
8,758.13
2,523.75
8,935.30
15,894.85
436.00
36,548.03
707,869.00
707,869.00
744,417.03
Parkview Villa -South (166)
Income Statement
For The Period Ending March 2012
Books = Accrual
Month to Date % Year to Date
Revenue
122.63
0.48%
201.59
0.26°6
I
2010 -46340 Minor Equipment
36220
-46340
Gen. Government Rents
24,620.42
96.35%
75,434.73
95.97%
36225
-46340
Nondwelling Rents
480.00
1.88%
1,533.00
1.95 0/a
36290
-46340
Other Miscellaneous Revenue
452.25
1.77%
1,632.93
2.080/c
39120
-46340
Recovery Damage City
-
0.00%
-
0.00%
Total
Revenue
3430 -46340
25,552.67
100.00 0/D
78,600.66
100.00%
Expenses
Personal Services
1000 -46340 Accrued Salaries 4,141.00 16.21% 11,587.00 14.740/c
Total Personal Services 4,141.00 16.21% 11,587.00 14.740/c
Supplies
2000 -46340 Office Supplies
122.63
0.48%
201.59
0.26°6
I
2010 -46340 Minor Equipment
1,071.00
4.19%
1,071.00
1.360/
2160 -46340 Maint. & Construct Materials
0.00
0.00%
0.00
0.00 ° /
2171 -46340 General Supplies
398.96
1.56%
616.36
0.78°/
Total Supplies
1,592.59
6.23°7°
1,888.95
2.40 ° /
Other Services & Charges
z `{f
0.00
0.00%
0.00
0.000/
3040 -46340
Legal Fees
3050.46340
Expert & Professional Services
0.00
0.00 0/D
0.00
0.000/
3060 -46340
Management Services
1,940.00
7.59%
6,2.77.00
7.990/
3100 -46340
Protective Services
0.00
0.00%
0.00
0.000/
3210 -46340
Telephone & Telegraph
215.97
0.85%
388.06
0.490/
3430 -46340
Advertising Other
820.00
3.21%
820.00
1.04 °,
3600 -46340
Insurance & Bonds
841.25
3.29%
2,523.75
3.21;
3810 -46340
Electric
1,415.79
5.54%
2,444.27
3.110,
0.00
0.00%
0.00
0.00;
3820 -46340
Water
3830 -46340
Gas
2,424.01
9.49%
4,889.08
6.22;
3840 -46340
Refuse
125.44
0.49%
159.83
0.209
0.00
0.00%
0.00
0.00°.
3850 -46340
Sewer
4000 -46340
Repair & Maint. Services
3,742.20
14.65%
13,149.00
16.73'
405046340
Garage, Labor Burd.
72.40
0.28%
72.40
0.091
4300 -46340
Miscellaneous Charges
0.00
0.00%
25.58
0.03(
4315 -46340
PILOT
1,059.66
4.15%
3,178.98
4.041
0.00
0.00%
558.62
0.711
4390 -46340
Taxes & Licenses
4500 -46340
Administrative Expenses
0.00
0.00%
3,232.74
4.11'
4850 -46340
Interest on Deposits
6.93
0.03%
21.57
0.031
Total Other
Services & Charges
12,663.65
49.56°/°
37,740.88
48.02°.
z `{f
Capital Outlay
5120 -46340 Building & Improvements
Total Capital Outlay
Total Expense
Excess (Deficit) Revenue over Expense
� -7
0.00%
0.00 0.00%
0.00
0.00 % 1
18,397.24 72.00% 51,216.83 65.16%
7,155.43 28.00% 27,383.83 34.84 °k
Parkview Villa South (166)
0.00
Cash Flow Statement
1,940.00
Period = March 2012
0.00
3210 Telephone & Telegraph
Month to Date
Revenue
820.00
36220 Gen. Government Rents
24,620.42
36225 Nondwelling Rents
480.00
36290 Other Miscellaneous Revenue
452.25
39120 Recovery Damage City Property
0.00
Total Revenue
25,552.67
Personnel Services
1000 Accrued Salaries 4,141.00
Total Personnel Services 4,141.00
Supplies
2000 Office Supplies 122.63
2010 Minor Equipment 1,071.00
2160 Maint. & Construct Materials 0.00
2171 General Supplies 398.96
Total Supplies 1,592.59
Other Services & Charges
3050 Expert & Professional Services
0.00
3060 Management Services
1,940.00
3100 Protective Services
0.00
3210 Telephone & Telegraph
215.97
3430 Advertising Other
820.00
3600 Insurance & Bonds
841.25
3810 Electric
1,415.79
3820 Water
0.00
3830 Gas
2,424.01
3840 Refuse
125.44
3850 Sewer
O.OD
4000 Repair & Maint. Services
3,742.20
4050 Garage, Labor But
72.40
4300 Miscellaneous Charges
0.00
4315 PILOT
1,059.66
4390 Taxes & Licenses
0.00
4500 Administrative Expenses
D.00
4850 Interest on Deposits
6'93
Total Other Services & Charges
12,663.65
Total Expenses 18,397.24
Zg
Parkview Villa South (166)
Cash Flow Statement
Period = March 2012
Excess (Deficit) Revenue over Expenses
Adjustments
10200 Petty Cash
10400 Investments
11300 Rent Receivable
11500 Accounts Receivable
15510 Prepaid Insurance
2.0200 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
W
Month to Date
7,155.43
(93.00)
(138,000.00)
(369.00)
(6.00)
0.00
(4,289.58)
841.25
(101.75)
1,059.66
171.00
(140,787.42)
(133,631.99)
Beg Cash End Cash Difference
163,509.66 29,877.67 (133,631.99)
93.00 186.00 (93.00)
575,970.36 713,970.36 (138,000.00)
739,573.02 744,034.03 (271,724.99)
4/16/2012 3:41 PM
General Ledger (Accrual)
ParlcvieW Villa South - (166)
Months: Mar 2012
Page 1
Control
Refer
Debit Credit
Balance Remarks
Property
Date Period
Description
7,446.00 = Beginning Balance =
1000 -46340
Accrued Salaries
3,723.00
11,169.00 RJC CHC PR Mgmt Fee
166
3/3112012 03/12 (:Recur
380) :PoStRecurring Recurr J- 133248
RC
11,587.00 Adj and reallocate 2 -3/12 mg
166
3131/2012 03/12
Adj and reallocate 23/12 mg ]-133997
:Reversed by
418.00
11,587.00 = Ending Balance=
NetChange= 4,141.00
78.96 = Beginning Balance =
2000 -46340
Office Supplies
83.86
162.82 pens, shredder etc
166
2/24/2012 03112
(offi8BO4) Office Depot P- 272576
5,99431 11
166
3/9/2012 03112
(of08809)O(Oce Depot P- 273842
6.01382E +11
19.91
1]9.]3 paper
189.19 on time delivery 02/12
166
3/1412012 03112
(chc) CommouBond Housing P- 272494
936637
9.46
200.94 envelopes
166
3/21/2012 03/12
(of08804)OfOce Depot P- 274401
6.02616E +11
11]5
201.59 postage 03 /l2
166
3/27/2012 03112
(chc) CommonBond Housing P- 274317
940919
0.65
201.59 = Ending Balance =
NetChange= 122.63
0.00 = Beginning Balance =
2010 -46340
Minor Equipment
P- 2]4403
512]9710.001
1,0]1.00
1,071.00 frig, range et..-nce
166
3/16/2012 03/12
(all) All Inc.
1,0]1.00 c Ending Balance =
NnlCha 1,071.00
217.40 = Beginning Balance =
2171 -46340
General Supplies
149.23
366.63 paint
166
3/5/2012 03/12
(sher4110) ShOwin- Williams Co. P- 2]'2773
7207-6
3.4.14 ice melt, pkg twisPn -locks
3/6/2012 03/12
(home]) HD Supply Facilities Mainh P- 273296
9113858D91Pv
6.51
166
3/9/2012 03/12
(home]) HD Supply Facilities Main, P- 273297
9113932796pv
26.33
399.47 towels, gloves etc
166
3/12/2012 03/12
gula 2) Home Depot Credit Servi P- 274402
8217694pvs
12.52
411.99 vinyl tiles, washers etc.
166
3/20/2012 03/12
(pea.) Peachtree Business Praluc6 P- 274788
926632030001
27.90
439.89 Flags
166
3/2112012 03/12
(home]) HD Supply Facilities Mainb P- 274786
9114144816pv
30.56
470.45 cleaning supplies
166
3/22/2012 03/12
(home]) HD Supply Facilities Mainb P- 274787
9114164643pv
145.91
616.36 bbi etc.
166
NelChange= 398.96
61 36 Balance =
4,337.00 = Beginning Balance =
3060 -46340
Management Services
6,035.00
10,372.00 mount fee 03/12
166
3/30/2012 03/12
(chc) Commor-Bond Housing 9- 274932
941336
3,723.00
6,649.00 R/C CHC PR Mgmt Fee
166
3/31/2012 03/12
(:Recur 380) :PoslRescurring Recurr 3133246
RC
372.00
6,277.00 Adj and reallocate 2.1/12 mg
166
3/3112012 03/12
Adj and reallocate 2 -3112 mg 3- 133997
:Reversed by
6,277.00 = Ending Balance =
NetChange= 1,940.00
172.09 Beginning Balance =
3210 -46340
Telephone &Telegraph
59.38
231.4] phone Svc par end l2 /31/11
166
1/18/2012 03112
(offi65B) Office of Enterprise Techn P- 271075
W11120681/12
273.45 answ Svc -set up fees 03/12
166
3/1/2012 03/12
(level Level One 9- 272577
2291214-INpv
41.98
295.91 Internet svc 3/11 -4110
166
3/2/2012 03112
(.00.3474) Comcast P -272111
8.77211E111
22.46
313.39 phone svc - due 3124
166
3/7/2012 03/12
(cen19115) Centuryl-ink P- 2]2]65
7637883978/0
17.48
328.10 ph 2/13 -318
166
3/11/2012 03112
(mcic3718) MCI Comm Service P- 273841
7637BB3978pv
14.71
388.06 phone svc - per end 2/29112
166
3/2112012 03/12
(of0658) Office of Enterprise Techn P- 274404
200BOO187/02
59.96
Ending Balance =
NelChange= 215.97
388.06 =
0.00 = Beginning Balance =
3430 -46340
Advertising Other
820.00
820.00 Advertising 3/12-3/13
166
3111/2012 03/12
gra) Liturgical Publications, Inc. P- 271078
204370148/03
820.00 = E Ending Balance=
NetChange= 820.00
1,682.50 = Beginning Balance =
3600 -46340
Insurance & Bonds
841.25
C of Columbia Ins Ac
166
3/31/2012 03/12
(:Recur 380) 9ostRecurring Recurr 3- 133298
RC
lances
2,523.75 = Ending Balance =
,523.75
NetChange- 841.25
1,028.48 = Beginning Balance =
3810 -46340
Electric
P- 273050
515044155310
1,415.]9
21,14.2] elecsvc2 /06-3an
166
3/12/2012 03/12
(xcel) Xcel Energy
2,444.27 = Ending Balance =
NetChange= 1,415.79
2,465.07 = Beginning Balance =
3830 -46340
166
3/812012 03/12
Gas
(cent) CenterPoint Energy P- 272585
552713241021
2,929.01
4,889.08 gas Svc 2/06 -3/06
41889,08 = Ending Balance =
NelChange= 2,424.01
34.39 = Beginning Balance =
3840 -46340
166
3/2/2012 03/12
Refuse
(gees 1004) Green Lights Recycling P- 272769
12- 2084pvs
125.44
159.81 trash svc 3/02
159.83 =Entling Balance =
NetChange= 125.4
9,406.80 = Beginning Balance =
4000-46340
Repair & MaNt. Services
375.00
9,]81.80 painting, repairs
166
2/23/2012 03112
Fred) K.O. Cleaning and Restoratioi P- 271077
2048
9,807.38 snow rmvl - 02/28
166
2/28/2012 03/12
(mgsp) MGS Professional Bldg Main P -272575
10396pvs
25.58
10,116.56 me maint -3/12
166
3/1/2012 03/12
(eagll) Eagle Elevator Corp. P- 272767
113297 -Ipvs
309.18
10,146.01 snow rmvl - 02/29
166
3/3/2012 03/12
(mgsp) MGS Professional Bldg Main P- 272574
W403pas
29.45
10,184.76 snow rmyl - 03/01
166
3/312012 03/12
(mgsp) MGS Professional Bldg Main P- 272573
10419pvs
38.75
10,200.52 ice melt, pkg twist- n-laks
3/6/2012 03/12
(home]) HD Supply Facilities Mainb P- 273296
9113858041pv
15.76
166
318/2012 03]12
(hame)Hamemick Decorating Cent P -287/1
CG201977
1,399'20
11,599.72 carp lost
3/16/2012 03/12
(eagLL) Eagle Elevator Corp. P- 275413
113500 -IN
922'00
3/19
12,521.72 of svc /19
166
3/19/2012 03/12
(adam) Adam's Pest Control, Inc. P- 275412
702932pvs
22'00
12,543.72 pest Svc
166
3/19/2012 03/12
(home) Hamernick Decorating Cent P- 273890
CG202154
328.56
12,87228 concrete repair 129
166
P- 2]4]84
032612pvs
132.68
13,004.96 part per est- tree rmvl etc
166
3/26/2012 03/12
hub-) Arbor Barber, Inc.
144.04
13,149.00 Dryer svc- Floors 3 & 4
166
3/26/2012 03/12
(dire) Direct Home Appliance Scovk P- 274785
032612pvs
13,149.00 = Ending Balance =
NetChange= 3,742.20 3
Page 1
4/16/2012 3:41 PM
General Ledger (Accrual)
Parkview Villa South - (166)
Months: Mar 2012
Property
Date
Period
Description Control
- Re(e,
Dehit
Credit Balance Remarks
4050 -46340
Garage, Labor Bard.
0.00 = Beginning Balance =
166
3/27/2012
03/12
(slgn6160) Signs By RSG P- 275414
646Pvs
72.10
71A0 bulbs, we call
NetChange =72.40
72.40 = Ending Balance=
4300-46340
Miscellaneous Charges
25.58 = Beginning Balance =
NetChange= 0.00
25.56 c Ending Balance =
4315 -46340
PILOT
2,119.32 = Beginning Balance =
166
3/31/2012
03/12
(:Recur 380) :POStRecurring Recur, 3133248
RC
1,059.66
3,178.98 Anoka Cly Property Tax Acce,
NetChange= 1,059.66
3,178.98 = Ending Balance =
4390 -46340
Taxes A, Licenses
558.62 = Beginning Balance =
NetChange= 0.00
556.62 = Ending Balance =
4500 -46340
Adra nistra0ve Expenses
3,232.74 = Beginning Balance =
NetChange= 0.00
3,232.74 = Ending Balance =
4850 -46340
Interest can Deposits
14.64 = Beginning Balance =
166
3/31/2012
03/12
Sec pep Interest accrual 3- 133251
G31
6.93
21.9 Sec Drip interest accrual
NetChange= 6.93
21.57 = Ending Balance =
22,492.24
4,095.00
3 1 Page 2
5016464
Parkview Villa South 419/12
Bank Reconciliation Report
03/31/2012
Balance Per Bank Statement as of 03/31/2012
$30,057.14
0211112009
389 mcic - MCI Comm Service
5.47
03121/2012
1354 mgsp - MGS Professional Bldg Maint Sew Inc
93.78
03/28/2012
1360 home7 - HD Supply Facilities Maintenance
48.60
03/28/2012
1361 mcic3718 - MCI Comm Service
14.71
03/28/2012
1362 off i8804 - Office Depot
16.91
Less:
Outstanding Checks
$179.47
03/01/2012
Reconciled Bank Balance
$29,877.67
Balance per GL as of 03/31/2012
Reconciled Balance Per G/L
Difference
Cleared Items:
Cleared Checks
$29,877.67
$29,877.67
Date
Tran #
Notes
Amount
Date Cleared
01/19/2012
1296
t0003793- Johnson
199.06
03/3112012
02/1512012
1321
mgsp - MGS Professional Bldg Maint Sew Inc
29.45
03/31/2012
02123/2012
1324
bfbp- BFB Painting, Inc.
280.00
03/31/2012
03/01/2012
1328
adam - Adam's Pest Control, Inc.
22.00
03/31/2012
03/01/2012
1329
bioc � Bio Corps, LLC
2,300.00
03/3112012
03101/2012
1330
colu - City of Columbia Heights
2,947.00
03/31/2012
03/01/2012
1331
colu825 - Columbia Heights Fire Dept
558.62
03/31/2012
03/01/2012
1332
home32 - Home Depot Credit Services
19.00
03/31/2012
03/01/2012
1333
mcic - MCI Comm Service
11.16
03/31/2012
03101/2012
1334
offi8804 - Office Depot
31.71
03/31/2012
03/07/2012
1335
buck8411 - Buckeye Cleaning Centers
37.89
03131/2012
03/07/2012
1336
cent9115 - Centuryl-ink
17.48
03/3112012
03/07/2012
1337
chc - CommonBond Housing
6,035.00
03/31/2012
03107/2012
1338
Ibpm - LBP Mechanical, Inc
449.67
03/31/2012
03/0712012
1339
mgsp - MGS Professional Bldg Maint Sew Inc
29.45
03/31/2012
03/07/2012
1340
offi658 - Office of Enterprise Technology
61.49
03/3112012
03/07/2012
1341
zeph- Zephyr Services Inc.
225.00
03/31/2012
03114/2012
1342
comc3474 - Comcast
22.46
03/31/2012
03/1412012
1343
kocl - K.O. Cleaning and Restoration LLC
375.00
03/3112012
03/14/2012
1344
litu - Liturgical Publications, Inc.
5 I�L
820.00
03131/2012
0.00
'53
4/9/12
Parkview Villa South
Bank Reconciliation Report
03/31/2012
5016464
03/14/2012
1345
offi658 - Office of Enterprise Technology
59.38
03/31/2012
03/1412012
1346
t0005261 - Fouks
308.68
03/31/2012
03/21/2012
1347
cent - CenterPoint Energy
2,424.01
03/31/2012
03/21/2012
1348
cen19115- Centuryt-ink
17.48
03/31/2012
03/21/2012
1349
chc- CommonBond Housing
9.46
03/31/2012
03/21/2012
1350
eag11 - Eagle Elevator Corp.
309.18
03/31/2012
03/2112012
1351
gree1004 - Green Lights Recycling Inc
125.44
03/31/2012
03/21/2012
1352
home - Hamernick Decorating Center
1,399.20
03/31/2012
03/21/2012
1353
leve - Level One
41.98
03/31/2012
03/2112012
1355
offi8804 - Office Depot
83.86
03/31/2012
03/2112012
1356
sher4110 Sherwin- Williams Co.
149.23
03/31/2012
03/21/2012
1357
xcel - Xcel Energy
1,415.79
03/31/2012
03/2812012
1358
chc - Commonl3ond Housing
371.48
03131/2012
03/28/2012
1359
hame - Hamernick Decorating Center
328.56
03/31/2012
Total
$21,515.17
Cleared Deposits
Date
Tran #
Notes
Amount
Date Cleared
03/0212012
295
operations
18,898.00
03131/2012
03106/2012
293
operations
5,625.00
03/31/2012
03/08/2012
294
661.42
0313112012
03/08/2012
294
operations
128.00
03131/2012
03109/2012
296
operations
236.25
03131/2012
Total
$25,548.67
Cleared Other Items
Date
Tran #
Notes
Amount
Date Cleared
03114/2012
JE 133249
NEB transfer to City invest acct
- 138,000.00
03/31/2012
Total
- $138,000.00
'53
4/9/12
HRA OF COLUMBIA HEIGHTS
PARKVIEW VILLA SOUTH
C/O COMMONBOND COMMUNITIES
328 KELLOGG BLVD WEST
ST PAUL MN 55102 -1900
- - -- C H E C K I N G
Date 3/30/12 Page 1
Primary Account @XXXXX @6464
Enclosures 38
A C C O U N T S - - --
EFFECTIVE MAY 1, ALL AUTOMATIC FUNDS TRANSFERS (AFTS) WILL
REDUCE YOUR AVAILABLE BALANCE AT THE START OF BUSINESS DAY
ON THE SCHEDULED TRANSFER DATE. IF YOUR TRANSFER IS
SCHEDULED
FOR A MONDAY,
THIS
WILL AFFECT YOUR AVAILABLE
3/02
BALANCE ON THE
WEEKEND OR
HOLIDAY. EARLY ACCOUNT CLOSING FEE
3/1.4
OF $20 FOR HEALTH SAVINGS
ACCOUNTS CLOSED PRIOR TO 3 MONTHS.
DEPOSIT
NORTHEAST PUBLIC FUNDS
ACCT
3/08
Number of Images
38
Account Number
@XXXXX @6464
Statement Dates 3/01/12 thru
3/31/12
Previous Balance
1.64,023.64
Days in the Statement Period
31
4 Deposits /Credits
25,548.67
Average Ledger
96,783
35 Checks /Debits
1.59,515.17
3/02
Average Collected
95,306
Service Charge
.00
1330
2,947.00
Interest Paid
.00
29.45
3/09
Ending Balance
30,057.14
3/20
1324*
Deposits and Credits
Date
Description
Amount
3/02
DDA REGULAR
DEPOSIT
18,898.00
3/1.4
3/07
DDA REGULAR
DEPOSIT
5,625.00
138,000.00
3/08
DDA REGULAR
DEPOSIT
789.42
in serial order
3/09
DDA REGULAR
DEPOSIT
236.25
Charges and Debits
Date
Description
Amount
3/1.4
Xfer to 0005
SAVINGS
138,000.00
Checks
in serial order
Date
Check#
Amount
Date
Check#
Amount
3/02
1296
199.06
3/08
1330
2,947.00
3/21
1321*
29.45
3/09
1331
558.62
3/20
1324*
280.00
3/09
1332
19.00
3/06
1328*
22.00
3/13
1333
11.16
3/16
1329
2,300.00
3/14
1334
31.71
* Indicates skip in check
numbers
-5<�l
Parkview Villa North
Financial Statement Overview
February 2012
Revenue:
Occupancy for the month of February 2012 was 100% occupied;
Total Revenue was under budget amount (unfavorable). No Grant Income was
recognized in the month of February
Administrative Expenses:
Administrative costs for the North were over budget (unfavorable). This reflects 2011
servicing fee paid to the City
Other Renting Expenses were under budget (favorable), and reflect minimum applicant
screening needed due to low turnover.
Office Salary and Management fee is allocated incorrectly in the month of February,
however, the total matches budget
Office Supply expenses are under budget (favorable)
Computer Equipment and Maintenance was over budget (unfavorable) and reflects an
error in billing. Credit will be issued.
Legal Expenses was under budget (favorable).
Telephone, Answering Service and Internet expenses are under budget (favorable).
Utilities:
Utilities Expenses are under budget (favorable), however, these are quarterly billings
Electric was under budget (favorable)
Gas was slightly over budget (unfavorable)
Water and Sewer were not invoiced in February
®peratina and Maintenance Expense (sunnlies):
Operating and Maintenance Expenses are under budget (favorable).
Janitor Contract expenses were under budget (favorable)
Exterminating Contract is under budget (favorable)
Maintenance Supplies is under budget (favorable)
Garbage and Trash are under budget (favorable); however, this is a quarterly billing
Security Contract is under budget (favorable).
Repairs Contract expenses were under budget (favorable)
Elevator Maintenance Contract is slightly over budget (unfavorable), and reflects service
call in February
Snow Removal is under budget (favorable).
Decorating Contract and Supplies were under budget (favorable)
Furniture and Fixtures is under budget (favorable)
FA
OWi pO J O
O b O NW O
f3 W u + W
� + W
NViW OO+WOJOOC
bOAAm0004Wi CIO 00C
es�na �ASe °e�ege8ss
6)'m
W b n� (n J P iWi (WO y W {Jli IWJ O O O O O
°a mo
O 4 O
°o °ooWa
A N
J 4
O O
N 10
N O O
O N N V
OWi000Wi0
IJ J O N
+ i Y
W O W O
000(NiIO
Q
D
V
W J N IAD
a � 000
+ N 00000
N
N 0 0 0 Ol NANO O
N d O O J OWl O N O O O
41J00 WNO
Ul W 0 0 0 W A 0 (Jil O Vl
J
O mNm N N
NIiO W�+AO aONO
°o °o amo °o S'lo °o °o °o
, Wmb�D��O �OWNb
�y O W Vl A
N J P OWi O W O O UNi O N
Ul W O O N W A W O
WN
O O O O J O O J O O O
°o °o °oo °OO °o °om °o °o o°
N
W
N � O
f!I N
A W
o p W
F. PD r
IU V(NnN OOJ
A fNil (Nil
b VbON+
O J W O O A
N
NNN ID
N(WilN00 N
i
J
J + O
A W
oo °O>
A b W
0 , bONOP
W: NNO+00
W � W
WJN_ +N
OAi NNN p'IJ
O O O O O O
O
J D
O
-ai
m O
A p1
N G
O W
i 1
O t]
O q
N
b �
m
w O
O
m
b l0
A p
o
v
A b
O
u �
O �
.8
P D z
O d a
D
�
=
G
° __ C
C
�
E 3
m
laic
m
� �
•�•
m
a a _
NNG mev
a
D 7mCN�0 Nm N[N ¢in
.�Dm'm
N
A
OyOGIj
pG1Ap
>H -
"
m3���,
� _ v
N N
m
OWi pO J O
O b O NW O
f3 W u + W
� + W
NViW OO+WOJOOC
bOAAm0004Wi CIO 00C
es�na �ASe °e�ege8ss
6)'m
W b n� (n J P iWi (WO y W {Jli IWJ O O O O O
°a mo
O 4 O
°o °ooWa
A N
J 4
O O
N 10
N O O
O N N V
OWi000Wi0
IJ J O N
+ i Y
W O W O
000(NiIO
Q
D
V
W J N IAD
a � 000
+ N 00000
N
N 0 0 0 Ol NANO O
N d O O J OWl O N O O O
41J00 WNO
Ul W 0 0 0 W A 0 (Jil O Vl
J
O mNm N N
NIiO W�+AO aONO
°o °o amo °o S'lo °o °o °o
, Wmb�D��O �OWNb
�y O W Vl A
N J P OWi O W O O UNi O N
Ul W O O N W A W O
WN
O O O O J O O J O O O
°o °o °oo °OO °o °om °o °o o°
N
W
N � O
f!I N
A W
o p W
F. PD r
IU V(NnN OOJ
A fNil (Nil
b VbON+
O J W O O A
N
NNN ID
N(WilN00 N
i
J
J + O
A W
oo °O>
A b W
0 , bONOP
W: NNO+00
W � W
WJN_ +N
OAi NNN p'IJ
O O O O O O
O
J D
O
-ai
m O
A p1
N G
O W
i 1
O t]
O q
N
b �
m
w O
O
m
b l0
A p
o
v
A b
O
u �
O �
.8
P D z
O d a
Z y
o U (JJ J
Op 5
= 9
N
A
U
'
p�
➢➢
J
�1
pN�
� N W N ➢
n
O
O
W➢
m
A
V� O O O O m J O O N O� J O O N
F...
�A�pp
yN
N
N O
W
-N+
O
J
O
P
V
0
W m
u m m
m
N f0 ➢ J +� NP N N N N O
m
VNiN
IJO
N
(WJW
+mN
O
VJ
(JI�WOOTOOm104WiO N� '+4iN0 N6
Po P Po
U
N A
N
N (li W
W OPoi C 4Poi J+ O
N 4Ni O
5
.. w
f
8 � 10
P
OO
IJ
AA'
fn
O,
OIO OOOJJ J ONONOOi Wo
00
Oi
+
NN
O(J
JO�O
IOGJ
O
00�O
OOOmO+ (OO ViT00
'O Vi 'O Lm
00
�
N
W
WJ00000�
O�O O'O NIJ (N�aO'OOfu (.�
-� +WD �OOWNO➢ W.�
YJ
0
WW
A�W
N
W J
'
Q
0
4
0 �p
A
A
N
J
WA
W
P ip
A
WyWO
�I
P O W
N
V
J A (J i0 IJ O1 A
N m W ➢+ J O� J O �O W (Nii N
OJ+ IOJOAOOJNW J(n
D
00
0
00
mW0
W
OE
TOQO�UNiONOFJO000iPA0U
Jd
AA
O
J
lJW
W
W
+
IJ
N tO
41
N
W 6�
W lil
_
(li W IJ O OI O
m
0o
a
o
mm
uwo
°°
a'norn
°o ow °u °m°HU�°'ow °° Vic
k.'S°OO
m
TO°rn
°Oaa °oa °O m°owwPAao e:�»
A
P Y
+
+
�
4�
-+ + + ➢
�
IJ
IJ ➢
C
� N
b W
_N
+ fli 4� W W N i0 N (J O A A N
ONNE
O
O W
Y
W
O
O O +ml
y+y1
A
4 N d W
N N N W W O N O O N W N O
i
W
A
°O
WOOPoi
PIJOANAOmib000PoimO0AVi NPF
00
>
W
W
W
D
NN
q
w
y
A
i
N
N NNO
J
A
W ➢ +(li (a ➢(nW. 00W.W N
'°°oo
(n OHOOO(n0
0
NCO �D
Ooo
W
Wo.ONOO
°.Om (Ai�00 NJ
.........
O O O O O O O O O O O
N
r r 1
nRnnn
w
N N
-
a -
�
TNm
A N'
o O
O O O O O O
8 @888
Z
D Z`ZZZZ
D DDDT D
e a:a,A
s x &ses
0 00 00
D DID n ➢D D
3
o c
•VV1 U
IJ. 1
N �
F �
D' D
b
o °- o
BIZ zzz
DDDDD
m �N
mouum
OIp 000
O O O O O
O O O O O O
i U
7'z zZZZ
nn'n a
g100000
o oo °OO °o
IF
� N �
I,
pp A
� N 6
Oi OOl
ww<
O
�Nn
IJ N d
N41�
(J lJ W
mmn
NA P y�
W W ?
C P tt
�Ne
ro
n
A
o
w°
o° Iv
N
5
D
vo
000
o c
•VV1 U
IJ. 1
N �
F �
D' D
b
o °- o
BIZ zzz
DDDDD
m �N
mouum
OIp 000
O O O O O
O O O O O O
i U
7'z zZZZ
nn'n a
g100000
o oo °OO °o
IF
� N �
I,
pp A
� N 6
Oi OOl
ww<
O
�Nn
IJ N d
N41�
(J lJ W
mmn
NA P y�
W W ?
C P tt
�Ne
ro
n
A
o
o° Iv
N
5
�
\ \
\\
®®
(
Rq q
�( »(
§)
m
G
§m)Gi
)
(`�
;
�
\ \
\\
G
§m)Gi
;
;>
\ ;
!;
!
;;;;[
�
Parkview Villa -North (165)
Balance Sheet
February 2012
Books = Accrual
Assets
10100 Cash Balance
10200 Petty Cash
10400 Investments
11300 Rent Receivable
11500 Accounts Receivable
13200 Due From Other Government Units
Total Assets
Liabilities
20200 Accounts Payable
20210 Accrued Other Expenses
20220 Due to Resident Council
22000 Deposits
22200 Accrued PILOT
22210 Revenue Collected in Advance
Total Liabilities
Fund Balance
25300 Fund Balance
Total Fund Balance
Total Liabilities and Fund Balance
Feb -12
222,146.24
457.00
823,425.08
425.00
175.00
22,023.83
1,068,652.15
23,834.35
3,483.50
551.74
17,946.10
25,904.24
724.00
72,443.93
996,208.22
996,208.22
1,068,652.15
I
Parkview Villa -North (165)
Income Statement
For the Period Ending February 2012
Books = Accrual
Expenses
Personal Services
1000 -46330 Accrued Salaries 8,357.00 28.92% 16,714.00 28.55%
Total Personal Services 8,357.00 28.92% 16,714.00 28.55%
Supplies
2000 -46330 Office Supplies
Month to Date
%
Year to Date
2.41%
Revenue
0.00
0.00%
0.00
0.00%
33160 -46330 Federal Grant
-
0.00%
-
0.00%
36220 -46330 Gen, Government Rents
27,762.00
96.08%
56,320.00
96.20°70
36225 -46330 Nondwelling Rents
352.00
1.22%
672.00
1.15%
36290 -46330 Other Miscellaneous Revenue
781.38
2.70%
1,552.38
2.65%
39120 -46330 Recovery Damage City Property
-
0.00%
-
0.00%
Total Revenue
28,895.38
100.000/0
58,544.38
100.000/0
Expenses
Personal Services
1000 -46330 Accrued Salaries 8,357.00 28.92% 16,714.00 28.55%
Total Personal Services 8,357.00 28.92% 16,714.00 28.55%
Supplies
2000 -46330 Office Supplies
1,188.90
4.11%
1,410.57
2.41%
2010 -46330 Minor Equipment
0.00
0.00%
0.00
0.00%
2160 -46330 Maint. & Construct Materials
378.52
1.31%
1,608.64
2.75%
2171 -46330 General Supplies
250.85
0.87%
538.11
0.92%
Total Supplies
1,818.27
6.290/D
3,557.32
6.08%
Other Services & Charges
3040.46330 Legal fees
0.00
0.00%
0.00
0.00%
3050 -46330 Expert and Professional Services
0.00
0.00%
0.00
0.00%
3060 -46330 Management Services
5,191.00
17.96%
9,736.00
16.63%
3100 -46330 Protective Services
455.00
1.57%
3,667.00
6.26%
3210 -46330 Telephone & Telegraph
387.61
1.340/.
568.73
0.97%
3430 -46330 Advertising Other
0.00
0.00%
-94.05
- 0.16%
3600 -46330 Insurance & Bonds
1,741.75
6.03%
3,483.50
5.95%
3810 -46330 Electric
2,594.68
8.98%
2,594.68
4.43%
3820 -46330 Water
0.00
0.00%
0.00
0.00%
3830 -46330 Gas
4,867.39
16.84%
4,867.39
8.31%
3840 -46330 Refuse
0.00
0.00%
76.56
0.13%
3850 -46330 Sewer
0.00
0.00%
0.00
0.00%
4000 -46330 Repair & Maint. Services
2,155.10
7.46070
6,355.85
10.86%
4100 -46330 Rents & Leases
60.00
0.21%
66.75
0.11%
4300 -46330 Miscellaneous Charges
25.00
0.09%
25.00
0.04%
4315 -46330 PILOT
1,850.30
6.40%
3,700.60
6.32%
4390 -46330 Taxes & Licenses
1,243.38
0.00%
1,243.38
2.12%
4500 -46330 Administrative Expenses
6,905.44
23.90%
6,905.44
11.80%
4850 -46330 Interest on Deposits
13.04
0.05%
26.35
0.05%
Total Other Services & Charges
27,489.69
95.14%
43,223.18
73.83%
Capital Outlay
5120 -46330 Building & Improvements
Total Capital Outlay
Total Expense
Excess (Deficit) Revenue over Expense
235.54 0.00% 523.21 0.89%
!11.54 0.820/0 523.21 0.890/0
37,900.50 131.16% 64,017.71 109.35 0/a
- 9,005.12
- 5,473.33 -9.350/.
91
Parkview, Villa -North (165)
Cash Flow Statement
Period = February 2012
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
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
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
27,762.00
352.00
781.38
0.00
28,895.38
8,357.00
8,357.00
1,188.90
0.00
0.00
629.37
0.00
1,818.27
0.00
5,191.00
455.00
387.61
0.00
1,741.75
2,594.68
0.00
4,867.39
0.00
0.00
2,155.10
60.00
25.00
1,850.30
1,243.38
6,905.44
13.04
235.54
27,725.23
37,900.50
- 9,005.12
I0
Parkview Villa -North (165)
Cash Flow Statement
Period = February 2012
Book = Accrual
Adjustments
11300 Rent Receivable
11500 Accounts Receivable
13200 Due From Other Government Units
20200 Accounts Payable
20210 Accrued Other Expenses
22.000 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
2,425.00
75.00
828.80
1,444.81
1,741.75
188.04
1,850.30
- 965.00
7,588.70
(1,416.42)
Beg Cash End Cash Difference
223,562.66
222,146.24 (1,416.42)
457.00
457.00 -
725,325.08
725,325.08 -
949,344.74
947,928.32 (1,416.42)
Pat kview Villa -North (165)
0.00
0.00%
0.00
0.00%
Income Statement
1,188.90
4.11%
1,410.57
2.41%
For The Period Ending February 2012
0.00
0.00%
0.00
0.00%
Books = Accrual
378.52
1.31%
1,608.64
2.75%
2171 -46330 General Supplies
Month to Date
%
Year to Date
%
Revenue
1,818.27
6.29%
3,557.32
6.080/a I
33160 -46330 Federal Grant
-
0.00%
-
0.00 %,
36220 -46330 Gen. Government Rents
27,762.00
96.08%
56,320.00
96.20%
36225 -46330 Nondwelling Rents
352.00
1.22%
672.00
1.15%
36290 -46330 Other Miscellaneous Revenue
781.38
2.70%
1,552.38
2.65%
39120 -46330 Recovery Damage City Property
-
0.00%
-
0.00%
Total Revenue
28,895.38
100.000/0
58,544.38
100.000/0
Expenses
Personal Services
1000 46330 Accrued Salaries 8,357.00 28.92% 16,714.00 28.55%
i
Total Personal Services 8,357.00 28.92% 16,714.00 28.55%
Supplies
0.00
0.00%
0.00
0.00%
2000 -96330 Office Supplies
1,188.90
4.11%
1,410.57
2.41%
2010 -46330 Minor Equipment
0.00
0.00%
0.00
0.00%
2160 -96330 Maint. & Construct Materials
378.52
1.31%
1,608.64
2.75%
2171 -46330 General Supplies
250.85
0.87%
536.11
0.92% I
Total Supplies
1,818.27
6.29%
3,557.32
6.080/a I
Other Services & Charges
3040 -46330 Legal Fees
0.00
0.00%
0.00
0.00%
3050 -46330 Expert and Professional Services
0.00
0.00%
0.00
0.00%
3060 -46330 Management Services
5,191.00
17.96%
9,736.00
16.63%
3100 -46330 Protective Services
455.00
1.57%
3,667.00
6.26%
3210 -46330 Telephone & Telegraph
387.61
1.34%
568.73
0.97%
3430 -46330 Advertising Other
0.00
0.00%
-94.05
-0.16%
3600 -46330 Insurance & Bonds
1,741.75
6.03%
3,483.50
5.95%
3810 -46330 Electric
2,594.68
8.98%
2,594.68
4.43%
3820 -46330 Water
0.00
0.00%
0.00
0.00%
3830 -46330 Gas
4,867.39
16.84%
4,867.39
8.31%
3840 -46330 Refuse
0.00
0.00%
76.56
0.13%
3850 -46330 Sewer
0.00
0.00%
0.00
0.00%
4000 -46330 Repair & Maint. Services
2,155.10
7.46%
6,355.85
10.86%
4100 -46330 Rents & Leases
60.00
0.21%
66.75
0.11%
4300 -46330 Miscellaneous Charges
25.00
0.09%
25.00
0.04%
4315 -46330 PILOT
1,850.30
6.40%
3,700.60
6.32%
4390 -46330 Taxes & Licenses
1,243.38
0.00%
1,243.38
2.12%
4500 -96330 Administrative Expenses
6,905.44
23.90%
6,905.44
11.80%
4850 -46330 Interest on Deposits
13.04
0.05%
26.35
0.05%
Total Other Services & Charges 27,489.69 95.14% 43,223.18 1 � 73.83%
Capital Outlay
5120 -46330 Building & Improvements 235.54 0.00% 523.21 0.89%
Total Capital Outlay 235.54 0.82% 523.21 0.890/c
Total Expense 37,900.50 131.16% 64,017.71 109.350A I
Excess (Deficit) Revenue over Expense - 9,005.12 - 31.16% - 5,473.33 -9.350/c
[2-.�
3/13/2012 3:16 PM
Parkvlew Villa
-North (165)
General
Ledger
Period =
Feb 2012
Book =
Accrual
Data
Period
Person/ D rlp86ontrol
Reference
Debit
Credit
Balance Remarks
Properly
1000 -46330
Accrued Salaries
8,357.00 = Beginning Balance =
165
2/2912012
02/2012
:POrlaccurring Mon)- 130482
RC
8,352.00
0.00
16,714.00 NC CHC PR Mgmt Fee
Net Change= 8,357.00
16,714.00 = Ending Balance =
20DO -46330
Office Supplies
221.67 = Beginning Balance =
165
2/3/2012
02/2012
Office Depot(offiBE P- 268839
596838943001pvn
31.42
0.00
253.09 pope, deskpad etc.
165
2/8/2012
02/2012
Office Depot(oRBE P- 268838
5968393330D1pvn
39.15
0.00
292.24 cards etc.
165
212112012
02/2012
Common8ond Horn P- 268741
922175
1,118.33
0.00
1,410.57 romp support 1/20 -2/20
Net Charge= 1,188.90
1,410.57 = Facing Balance =
2160 -46330
paint. & Construct Materials
1,230.12 = Imunnl "g Balance =
165
1 /17 /2012
02/2012
HD Supply Faciftle!P- 267442
9/12972202
190.47
0.00
1,420.59 angle slap
165
1/22/2012
02/2012
HD Supply Facilltic P- 262446
91131689021vn
44.01
0.00
1,464.60 ice melt' mr,cri .riles etc.
165
2/312012
02/2012
Park Supply of Anne P- 268273
40264400
144.04
0,00
1,608.64 handle, bolts etc.
Net Change = 378.52
1,608.64 = Ending Balance =
2171 -46330
General Supplies
287.26 = Staff nning Balance =
165
1/18/2012
02/2012
NO Supply r'aciftlm P- 267444
9112999196pvn
135.29
0.00
423.05 trash Ilners, specify etc.
165
1119/2012
02/2012
HD Supply Facilltie! P- 267443
9113025353pvn
30.73
0.00
453.78 glass cleaner, magic eraser
165
2/14/2012
02/2012
Ouckeye Claining(P- 270111
651311pvn
64.33
0.00
538.11 roll towel
Net Change= 250.65
536.11 = Ending Balance =
3060 -46330
Malragement Services
4,545.00 = BeglnNng Balance
165
2/29/2012
02/2012
CommmBand How P- 269943
926294
13,548.00
0.00
18,093.00 meat fees 02/12
165
2/29/2012
02/2012
:POStRecomag MoN- 130487
RC
0.00
8,357.00
9,236.00 R/C CHC PR M9ml Fee
Net Change = 5,191.0,
9,736.00 = Ending Balance =
3100 -46330
Protective Services
3,212.00 = Beginning Balance =
165
1/23/2012
02/2012
Simplex Grinnell Is P- 262476
62408341
455.00
0.00
3,662.00 Sec sys svc call -4th Boor
Net Cbange=455.00
3,667.00 = Ending Balance =
3210 -46330
Telephone & Telegraph
181.12 = Beginning Balance =
165
211/2012
02/2012
Level One (level P- 267447
225222 -IN
135.41
0.00
316.53 ans, svc - set up fees 02/12
165
2/2/2012
02/2012
Comcan (comc347 P- 267440
077210505019618:
51.59
0.00
366.12 Internet svc 2/11 -3110
165
212/2012
02/2012
Ceatc,Uak((ent9 P-27D112
7637883978/02121
38.90
0.00
402.02 phone svc - due 2/25
165
2/11/2012
02/2012
MCI Comm Service P- 269200
7637803978/0212!
24.83
0.00
431.85 phone svc - due 3/03
165
2/15/2012
0212012
Office of Enterprise P- 269884
W12010671/0112P
136.88
0.00
568.73 phone svc- per end 1/31/12
Net Change= 387.61
568.73 = Ending Balance =
3430 -46330
Advertising Other
-94.05 = Beglnning Balance =
Net Change: 0.00
-94.05 = Endbrg Balance -
3600 -46330
I.e., an.. & Bonds
1,741.75 = Beginning Balance =
165
2/2912012
02/2012
:PostRecurung Mon)- 130487
RC
1,241.75
0.00
3,483.50 C of Columbia Heights Ins Aa
Net Change = 1,741.75
3,483.50 = Ending Balance =
Electric
0.00 = Beginning Balance =
3810 -46330
165
2/13/2012
02/2012
Xcel Energy (xcel) P- 266606
5150441553101121
3,997.76
0.00
3,997.76 else credit/svc 1/07 -2/06
165
2/1312012
02/2012
Xcel Energy (xcel) P- 268606
5150441553/01121
0.00
1,399.83
2,597.93 elec nedit/svc 1/07 -2/06
165
2/13/2012
02/2012
Xcei Energy (,cell P- 268606
5150441553/01121
O.DO
3.25
2,594.68
Net Change= 2,594.68
2,594.68 = Ending Balance =
Gas
0.00 = Original", Balance =
3830 -46330
165
2/7/2012
02/2012
CenterPOlnt Energy P- 267951
5519965710112
4,867.39
0.01)
4,867.39 gas svc 1 /05 -2103
Net Cbange=4,867.39
4,867.39 = Ending Balance =
3840.46330
Refuse
76.56 = Beginning Balance =
Net Change =0.00
76.56 - Ending Balance =
Repair& Maine, Services
4,200.75 = Beginning Balance =
4000 -46330
165
1/18/2012
D2/2012
Adam's Pest Comic P- 268271
693236pvn
48.92
0,011
4,249.22 pest svc 1118
165
1/23/2012
02/2012
FIGS Professlonal B P- 267448
10361pvn
65.55
0.00
4,315.27 snow rmvl svc 1/23
165
1/22/2012
02/2012
HD Supply Facllitie!P- 267446
91131689D2pvn
35.07
0.01)
4,350.34 Ice melt, thermocouples etc.
165
1/31/2012
02/2012
LBP Mechanical, In P- 268272
W16456
347.50
0.00
4,697.84 HVAC svc (.1112/29
165
2/1/2012
02/2012
Eagle Elevator Carl P- 267441
112718 -Ipvn
688.17
0.00
5,386.01 mo main -2/12
165
2/8/2012
02/2012
AtlamY Pest COntrc P- 269173
698311pvn
48.97
0.00
5,434.98 pest svc 2/08
165
2/16/2012
0212012
Drain King, I.e.(d, P- 269092
82608
135.00
0.00
5,569.98 path, svc- 206
165
2/1612012
0212012
Custom Appliance'. P- 269904
8293
177.32
0.00
5,7473D oven sv( call -608
165
2/17/2012
02/2012
Eagle Elevator Carl P- 269175
112935 -IN
543.00
0.00
6,290.30 svc call 2/13
165
2121/2012
02/2012
MGS Professional B P- 269903
10378pvn
65.55
O.OD
6,355.85 snow crawl SVGS 2/21
Net Change= 2,155.10
6,355.85 = Ending Balance =
19
Page l oft
Property
Data
Period
4100 -46330
165
1/31/2012
02/2012
4300 -46330
165
2/312012
02/2012
4315 -46330
020312pvn
25.00
165
2/29/2012
02/2012
4390 -46330
165
2/22/2012
D2/2012
4500 -46330
165
2/16/2012
02/2012
165
2/12/2012
02/2012
165
2/21/2012
02/2012
4850 -46330
165
2/2912012
02/2012
5120 -46330
921931
593.25
165
2/2D/2012
02/2012
Parkview Villa-NOrtI, (165)
General Ledger
Period - Feb 2012
Book = Accrual
Person /DescNptbGOntrol
Reference
Dealt
Rents & Leases
Multihousing Credit P- 268036
120/0369
60.00
Net Cluenge=60,00
Miscellaneous Charges
Schander(1000397 P- 262449
020312pvn
25.00
Net Chenge=25.00
PILOT
POs ec.,na, Mon) - 130482
RC
1,050.30
Net Change=1,850.30
Taxes & Licenses
Columbia Heights FP- 269632
022212pvn
1,243.38
Net Clmnge=1,243.38
Administrative Expenses
Cournern nd Hour P- 266510
921039
8.44
CommonBOnd hour P- 268316
921931
593.25
City of Columbia in P- 269630
201lpvn
6,303.75
Net Change=6,905.44
Interest on Deposits
Sec Del interest a,)- 131745
G32
13.04
Net Change =13.04
Credit
0.00
0.00
0.00
0.00
o.OD
0.00
0.00
0.00
Building & Improvements
RC WAI#11094 AN- 131744 G)1 235.54 0100
Net Change =235.54
47,660.58 9,760.08
Page 2 of 2
3/13/2012 3:16 PM
Balance Remarks
6.75 = Beginning Balance =
66.25 bck,rnd cks 1/12
66.75 = Ending Balance =
0.00 = Beginning Balance =
25.00 returned security card key
25.00 = Ending Balance =
1,850.30 = Beginning Balance =
3,200.60 Anoka Cry Property Tax Accry
3,700.60 = Ending Balance =
0.00 = Beginning Balance =
1,243.38 Prop rental license - pvn
1,243.38 = Ending Balance =
O.DO = Beginning Balance =
8.44 2011- 1099 1CRP costs
601.69 2011 CRP fees
6,905.44 pvn 2011 servicing fees
6,905.44 = Ending Balance =
13.31 = Beginning Balance r
26.35 Sec Dan Interest accrual
26.35 = Entling, Balance =
587.67 = Beginning Balance =
623.21 RC WAI 411094 Arch Fee four
823.21 = Ending Balance =
15
5016456
Parkview Villa North
Bank Reconciliation Report
02/29/2012
Balance Per Bank Statement as of 02/29/2012
$227,718.77
02/09/2011
1199
courl325 - Court Administration
55.00
02/09/2011
1200
court325 - Court Administration
320.00
12122/2011
'1545
t0004004 - Alunovic
120.55
02/1512012
1607
mgsp - MGS Professional Bldg Maint Sery Inc
65.55
02/23/2012
1611
cent - CenterPoint Energy
4,867.39
02/23/2012
1614
park! - Part< Supply of America, Inc.
144.04
Less:
Outstanding Checks
237.53
$5,572.53
Reconciled Bank Balance
Balance per GL as of 02/29/2012
Reconciled Balance Per G /1-
Difference
Cleared Items:
Cleared Checks
$222,146.24
3/12/12_
$222,146.24
$222,146.24
0.00
Date
Tran 8
Notes
Amount
Date Cleared
0112512012
1572
cent - CenterPoint Energy
5,198.32
02/29/2012
01/25/2012
1575
gree1004 - Green Lights Recycling Inc
76.56
02/29/2012
1578
mgsp - MGS Professional Bldg Maint Sery Inc
12.2.48
02/29/2012
0112512012
1580
park! - Park Supply of America, Inc.
43.93
02/29/2012
01/25/2012
1581
pet1651s - Laura Sheak
237.53
02129/2012
01/25/2012
1584
zeph - Zephyr Services Inc.
478.45
02/2912012
01/2512012
1585
adam - Adam's Pest Control, Inc.
29.15
02/29/2012
02/01/2012
1586
bfbp - BFB Painting, Inc.
3,040.00
02/29/2012
02/01/2012
1587
cent9115 - Centuryl-ink
38.90
02/29/2012
0210112012
1588
dire Direct Home Appliance Services
84.00
02/29/2012
02/01/2012
1589
gard1086- Gardner Plumbing, LLC
868.86
02/29/2012
02/01/2012
1590
home? - HD Supply Facilities Maintenance
155.47
02/29/2012
02101/2012
1591
kocl - K.O. Cleaning and Restoration LLC
400.00
02/29/2012
02101/2012
1592
leve - Level One
50.00
02/29/2012
02/01/2012
02/01/2012
1593
mcic3718 - MCI Comm Service
17.13
02/2912012
1594
mgsp - MGS Professional Bldg Maint Sery Inc
131.10
02/29/2012
02/01/2012
1595
mndept64 - MN Dept Of Labor & Industry
305.00
02/29/2012
02/01/2012
1596
offi8804 - Office Depot
52.55
02/2912012
02/01/2012
Olsen Fire Inspection, Inc.
3,212.00
02129/2012 I
02/01/2012
1597
olse -
5016456
02/01/2012
02/01/2012
02/08/2012
02/08/2012
02/08/2012
02/15/2012
02/15/2012
02/15/2012
02/15/2012
02/15/2012
02/15/2012
02/23/2012
02/23/2012
02/23/2012
02/23/2012
Total
Cleared Deposits
1598
1599
1600
1601
1602
1603
1604
1605
1606
1608
1609
1610
1612
1613
161.5
Date
Tran #
02102/2012
377
02/02/2012
378
02103/2012
379
02/06/2012
380
02/0912012
382
02/14/2012
381
Total
Cleared Other Items
Date
02/14/2.012
Total
Tran #
JE 131743
Parkview Villa North
Bank Reconciliation Report
02/29/2012
sher4110 - Sherwin - Williams Co.
waic - WAI Continuum
the - Commonl3ond Housing
dra17740 - Drain King, Inc.
home32 - Home Depot Credit Services
comc3474 - Contrast
eagll - Eagle Elevator Corp.
home7 HD Supply Facilities Maintenance
[eve - Level One
simp - Simplex Grinnell
t0003976 - Schander
adam - Adam's Pest Control, Inc.
chic - Commonl3ond Housing
Ihpm - LBP Mechanical, Inc
xcel - Xcel Energy
Notes
laundry receipts
operations - pvn
rent deposits
operations
dep
dep
Notes
CFP Cap Fund Program receipt
275.10
02/29/2012
587.67
02/29/2012
12,902.00
02/29/2012
135.00
02/2912012
105.61
02/29/2012
51.59
02/29/2012
688.17
02/29/2012
436.07
02/29/2012
135.41
02/29/2012
455.00
02/29/2012
.25.00
02/29/2012
48.97
02/29/2012
601.69
02/29/2012
- 347.50
02129/2012
2,594.68
02/29/2012
$33,930.89
Amount
Date Cleared
289.38
02/29/2012
11,726.00
02/29/2012
9,123.00
02/2912012
7,598.00
02/29/2012
1,264.00
02129/2012
605.00
02/2912012
$30,605.38
Amount Date Cleared
828.80 02/29/2012
$828.80
3/12/12
6-7
Date 2/29/12 Page 1
Primary Account @XXXXX @6456
Enclosures 40
EPA OF COLUMBIA HEIGHTS
PARKVIEW VILLA NORTH
C/O COMMONBOND COMMUNITIES
328 KELLOGG BLVD WEST
ST PAUL MN 55102 -1900
-
1�
- - - C H E C K I N G A
C C O U N T S - - --
EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING
DOMESTIC WIRES WILI, BE INCREASED TO $20 AND AN EARLY ACCOUNT
CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS
CLOSED IN LESS THAN 3 MONTHS AND HEALTH SAVINGS ACCTS PRIOR
TO 3 YEARS. THE MAXIMUM DAILY
LIMIT FOR NSF PAID AND
RETURNED ITEM FEES (CONSUMER ONLY) IS $120.
NORTHEAST
PUBLIC FUNDS ACCT
Number of Images
40
Account Number
@XXXXX @6456
Statement Dates 2/01/12 thru
2/29/12
Previous
Balance 230,215.48
Days in the Statement Period
29
7 Deposits
/Credits 31,434.18
Average Ledger
235,497
34 Checks/Debits
33,930.89
Average Collected
234,079
Service Charge
.00
Interest
Paid .00
Ending Balance
227,718.77
Deposits
and Credits
Date
Description
Amount
2/02
DDA REGULAR DEPOSIT
289.38
2/02
DDA REGULAR DEPOSIT
11,726.00
2/03
DDA REGULAR DEPOSIT
9,123.00
2/06
DDA REGULAR DEPOSIT
7,598.00
2/09
DDA REGULAR DEPOSIT
1,264.00
2/14
MISC PAY HUD TREAS 303
828.80 CR
3031036218 02/14/12
ID #- 411269646860103
TRACE #-031036210833043
2/14
DDA REGULAR DEPOSIT
605.00
Checks in
serial order
Date
Check# Amount
Date Check#
Amount
2/02
1572 5,198.32
2/0'1 1584*
478.45
2/01
1575* 76.56
2/07 1585
29.15
2/27
1578* 122.48
2/07 1586
3,040.00
2/02
1580* 43.93
2/07 1587
38.90
2/01
1581 237.53
2/3.3 1588
84.00
* Indicates
skip in check numbers
1�
Date 2 /29/12 Page 2
Primary Account @XXXXX @6456
Enclosures 40
NORTHEAST
PUBLIC FUNDS ACCT
@XXXXX @6456 (Continued)
Checks in
serial order
Check#
Amount
Date
Check#
Amount
Date
2/07
1589
868.86
2/13
1.601
135.00
2/07
1590
155.47
2/7.4
1602
105.61
2/08
1591
400.00
2/22
3.603
51.59
2/06
1592
50.00
2/21
1604
688.17
2/10
1593
17.3.3
2/23
1605
436.07
2/27
1594
131.10
2/22
1606
135.41
2/06
1595
305.00
2/22
1608*
455.00
2/10
1596
52.55
2/27
3.609
25.00
48.97
2/06
1597
3,212.00
275.10
2/27
2/27
1610
3.612*
601.69
2/07
2/16
1598
1599
587.67
2/28
1613
347.50
2/10
1600
12,902.00
2/27
1615*
2,594.68
* Indicates
skip in check numbers
Daily Balance
Date
Section
Balance
Date
Balance
Date
Balance
2/01
229,901.39
2/09
245,806.59
2/22
232,026.26
2/02
236,674.52
2/10
232,834.91
2/23
231,590.19
2/03
245,797.52
2/13
232,615.91
2/27
228,066.27
2/06
249,828.52
2/14
233,944.10
2/28
227,718.77
2/07
244,942.59
2/16
233,356.43
2/08
244,542.59
2/21
232,668.26
* * * E N
D O F
S
T A T E
M E N T
H
Payment Summary
Bank = l6Sopr AND mm /yy= 02/2012- 02/2012 AND All Checks =Yes AND Include Voids= All Checks
2o)
Check
Post
Total
Bank
Check#
Vendor
Date
Month
Amount
16
1585
adam - Adam's Pest Control, Inc.
02/01/2012
02/2012
29.15
Sopr Parkview Villa North
165opr - Parkview Villa North
1586
bfbp - BFB Painting, Inc.
02/01/2012
02/2012
3,040.00
165opr - Parkview Villa North
1587
cent9115 - Centurylink
02/01/2012
02/2012
38.90
16Sopr - Parkview Villa North
1588
dire - Direct Home Appliance Services
02/01/2012
02/2012
84.00
165opr - Parkview Villa North
1589
gard1086 - Gardner Plumbing, LLC
02/01/2012
02/2012
868.86
16Sopr - Parkview Villa North
1590
home7 - HD Supply Facilities Maintenance
02/01/2012
02/2012
155.47
165opr - Parkview Villa North
1591
kocl - K.O. Cleaning and Restoration LLC
02/01/2012
02/2012
400.00
165opr - Parkview Villa North
1592
leve - Level One
02/01/2012
02/2012
50.00
165opr - Parkview Villa North
1593
mcic3718 - MCI Comm Service
02/01/2012
02/2012
17.13
1650pr - Parkview Villa North
1594
mgsp - PIGS Professional Bldg Maint Sery Inc
02/01/2012
02/2012
131.10
165opr - Parkvlew Villa North
1595
mndept64 - MN Dept Of Labor & Industry
02/01/2012
02/2012
305.00
165opr - Parkview Villa North
1596
offi8804 - Office Depot
02/01/2012
02/2012
52.55
16Sopr Parkview Villa North
1597
else - Olsen Fire Inspection, Inc.
02/01/2012
02/2012
3,212.00
165opr - Parkview Villa North
1598
sher4110 - Sherwin- Williams Co.
02/01/2012
02/2012
275.10
165opr - Parkview Villa North
1599
wale - WAI Continuum
02/01/2012
02/2012
587.67
16Sopr - Parkview Villa North
1600
chc - CommonBond Housing
02/08/2012
02/2012
12,902.00
165opr - Parkview Villa North
1601
drai7740 - Drain King, Inc.
02/08/2012
02/2012
135.00
165opr - Parkview Villa North
1602
home32 - Home Depot Credit Services
02/08/2012
02/2012
105.61
165opr - Parkview Villa North
1603
comc3474 - Comcast
02/15/2012
02/2012
51.59
165opr - Parkview Villa North
1604
eagll - Eagle Elevator Corp.
02/15/2012
02/2012
688.17
165opr - Parkview Villa North
1605
home7 - HD Supply Facilities Maintenance
02/15/2012
02/2012
436.07
165opr - Parkview, Villa North
1606
leve - Level One
02/15/2012
02/2012
135.41
165opr - Parkview Villa North
1607
mgsp - MGS Professional Bldg Maint Sery Inc
02/15/2012
02/2012
65.55
165opr - Parkview Villa North
1608
sirnp - Simplex Grinnell
02/15/2012
02/2012
455.00
165opr - Parkview Villa North
1609
1:0003976 - Schander
02/15/2012
02/2012
2.5.00
165opr - Parkvlew Villa North
1610
adam - Adam's Pest Control, Inc.
02/23/2012
02/2012
48.97
165opr - Parkvlew Villa North
1611
cent - CenterPoint Energy
02/23/2012
02/2012
4,867.39
165opr - Parkview Villa North
1.612
chc - CommonBond Housing
02/23/2012
02/2012
601.69
165opr .. Parkview, Villa North
1613
Ibpm - LBP Mechanical, Inc
02/23/2012
02/2012
347.50
165opr - Parkview Villa North
1614
parkl - Park Supply of America, Inc.
02/23/2012
02/2012
144.04
165opr - Parkvlew Villa North
1615
xcel - Xcel Energy
,. ,,.__:.....G..« ».,.., .....«,......._,... u.-.—...,-,.._. :.b..<«..,Tn,..m.,__..M.».:...,
02/23/2012
..__..ame.,..:......,
02/2012
„... ,.,��.
2,594.68
..,.,
........:.....m,,.,,.,...,, ... .m..,....<.,,R,m._,........
,..,.. ..z,.T®.- w....w«o...«...-
.T.,:.
32,650.60 0
2o)
Parkview Villa South
Financial Statement Overview
February 2012
Revenue:
Occupancy for the month of February was 96% occupied
Total Revenue was lower than budget amount (unfavorable)
Administrative Expenses:
Administrative costs for South are over budget (unfavorable) due to servicing fees paid out to the
City of Columbia Heights
Advertising costs were under budget (favorable).
Office Supplies were under budget (favorable)
There were no Legal Expenses billed out for February.
Telephone, Answering Service and Internet expenses are under budget (favorable).
Misc. Admin. Expenses is over budget and reflects the servicing fee
Utilities:
Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing
Electric was under budget (favorable)
Gas was over budget (unfavorable)
Water and Sewer were not invoiced in February
Operating and Maintenance Expense
Operating and Maintenance Expenses were under budget (favorable).
Exterminating Contract was under budget (favorable)
Garbage and Trash Removal are under budget (favorable); however this is a quarterly billing.
Repairs Material and Contract costs were under budget (favorable).
Elevator Contract is under budget (favorable)
Z
Snow Removal costs were under budget (favorable)
Heating and Cooling Maint and Repairs was over budget (unfavorable) and reflects cost of Zone
Valve replacements
Decorating contract costs were over budget (unfavorable), and reflect cost associated with carpet
installation and vinyl installation and paint in one unit
ZZ
N + b W N W
888 [�R�C�aO'SHU'�
NJAOJ NtOliO V1 WJ0N +bbNON
pm oln o.+ yy y01
11tO�ON 10aJRWWVIJNO W(NIiO
WON WpONNS S,W 0�0iOSS
(p OOWi �WW(OIiOSAORNS00
N +
A m(Oii O
J O m
W + W
O O O
O O O
A J
P
A N O O W N O O
A.SSSSOISSSS
P 4a J
IWi1 + +Np�A ONION
AJpON�i W p�N lP
0001010 >OWiO N00
AO+ OUZO (0)i 0101A�W1NN +N(N11
WSN NAA�N 0W+0Wn00�00
+O(PO+
N
OOS
O
m
OSNOO�OOJIN
e
o
J N
py.W
�Sb0 LJ
A
o m W
m
WJW
N
NOJ
ryO1 pJN
O A of
o
m
P
D
IJ
p y
'o momlNii �n
elJnw
o c
�
�
D� Omar
�
N
p
m
O O S O N
SOT V O�
F
�m �� m=
�� � �C)� v
m
�3 B
2n
g,m
1n
v
O
N
H
O
N + b W N W
888 [�R�C�aO'SHU'�
NJAOJ NtOliO V1 WJ0N +bbNON
pm oln o.+ yy y01
11tO�ON 10aJRWWVIJNO W(NIiO
WON WpONNS S,W 0�0iOSS
(p OOWi �WW(OIiOSAORNS00
N +
A m(Oii O
J O m
W + W
O O O
O O O
A J
P
A N O O W N O O
A.SSSSOISSSS
P 4a J
IWi1 + +Np�A ONION
AJpON�i W p�N lP
0001010 >OWiO N00
AO+ OUZO (0)i 0101A�W1NN +N(N11
WSN NAA�N 0W+0Wn00�00
+O(PO+
N
OOS
N N N
Np�N
+WN
OSNOO�OOJIN
(Nli�O V
J10�
J N
py.W
�Sb0 LJ
4JO
W+
O
WJW
N
NOJ
ryO1 pJN
O A of
o
m
P
D
IJ
p y
'o momlNii �n
elJnw
p
N
O m
O O
p
m
O O S O N
p1
O P N O O 01 O O ONi O N O
u
N
A
N N N
Np�N
+WN
W 0
(Nli�O V
J10�
J N
py.W
�Sb0 LJ
4JO
W+
0
WJW
➢�o °O m
NOJ
ryO1 pJN
O A of
o
m
P
p N + IJ
IJ
p y
'o momlNii �n
elJnw
NIJ ONS PI OiIWW
N
m
O
N N N
Np�N
+WN
W 0
q
O O N
N
J N
A
aCJi
Avis
Z +O Ll
WJW
➢�o °O m
NOJ
ryO1 pJN
O A of
v
+
O
A A
i
i W
O IOO W
aCJi
Avis
�l�p1O NO
{Ap
N O O Ili O
O
ryO1 pJN
O A of
O
O
p
goo
O S O
O
000 N
NNQOi
O W O 4
fJ A Z A O
J
W
U
D Nl1 O
�
O J N
A A
i
i W
AN N
Avis
�l�p1O NO
{Ap
N O O Ili O
O
ryO1 pJN
O A of
O
O
p
goo
O S O
O
d
yro
O
R
yG
nd
0
b
nV
E
N(
V
m
m
e
j d
Z3_ v
O
m
J
N
J
°O
W
A m
yW
A
°0 0
o °o
D
9 V a
A m
W O
O
V � O
!n
NZSON
!n
A
N
Pu
A
A A
n b
W
O O O
O O O O O O O O S O W m O O O O =
O
W
W W
j
UI
m
W
to
m
�0
o g+
m ui
yO
A
m
Iola
O
P O
(jl
O
Ill
(All A
a
umi
a J
J O
N
A
O
N
W
OO
VN
+N
WW1
8
O
O O
O
pO
O
O
pO
O
O S
A R_i of
O
m
J
N
J
°O
W
A m
yW
A
°0 0
o °o
D
9 V a
A m
W O
O
V � O
r
!n
NZSON
!n
A
N
Pu
A
A A
n b
W
O O O
O O O O O O O O S O W m O O O O =
O
W
W W
j
UI
m
W
to
m
�0
o g+
m ui
yO
A
m
Iola
O
P O
(jl
O
Ill
(All A
a
umi
a J
J O
r
!n
NZSON
!n
A
N
Pu
A
A A
n b
W
O O O
O O O O O O O O S O W m O O O O =
O
O O O O O O O O O S O O O O O O O d
to
m
�0
o g+
m ui
yO
A
m
Iola
O
W N
a
A
N
A
O
N
W
OO
VN
+N
0-I kI o19 SIN N
yT
N O
O Q O A (Oi1 b N O O O O m A O N
0 0 0 Oml W m 0 0 0 0 0� 0 0 0 W
��llII m
b"In000 °m °m �o,'o mSom v'w
OOOOO(Wi1WJSN(JIIJOJOW r.
v G
ONmOVWW�NbmOO mm AmpN�INI��,O fj1
OO +OAON�IONIJll �1 INJJOJ m
OON OJiON� OOONIJJ ON+N �
OOWD.W+NODOOO(Y�O�N
bb N N N+ A y p O J A
p O j O W 0 ONi O O O> A A O N
+ N
+ N m m P 4 O J OHO W W+ m
°oo °000mmwoo`r�owlJilm 6
°o °o °o °o °O mrn ki OO �o`6'g k1 OOm
' m
+IIIl��P AWJO� WOmNiO
OONONOJIWpO��OmOJAVOI !D ,(NIIW
O O+ O O Y O A O A O N O A O 001
o ++ N
NZSON
J Oi�2000O�b�WW G
N
OI +ION +NmNN WmmNN+
p�
OOO OO�LImmO+O(P 0O 1JO
O N N W O N O
W
O O O
O O O O O O O O S O W m O O O O =
O
O O O O O O O O O S O O O O O O O d
OAi
10
�0
�
0 10
yO
A
m
m
O
W N
a
A
O
O
W N
W
OO
+N
WW1
8
O
O O
O
pO
O
O
pO
O
O S
yT
N O
O Q O A (Oi1 b N O O O O m A O N
0 0 0 Oml W m 0 0 0 0 0� 0 0 0 W
��llII m
b"In000 °m °m �o,'o mSom v'w
OOOOO(Wi1WJSN(JIIJOJOW r.
v G
ONmOVWW�NbmOO mm AmpN�INI��,O fj1
OO +OAON�IONIJll �1 INJJOJ m
OON OJiON� OOONIJJ ON+N �
OOWD.W+NODOOO(Y�O�N
bb N N N+ A y p O J A
p O j O W 0 ONi O O O> A A O N
+ N
+ N m m P 4 O J OHO W W+ m
°oo °000mmwoo`r�owlJilm 6
°o °o °o °o °O mrn ki OO �o`6'g k1 OOm
' m
+IIIl��P AWJO� WOmNiO
OONONOJIWpO��OmOJAVOI !D ,(NIIW
O O+ O O Y O A O A O N O A O 001
A
N /
o ++ N
NZSON
J Oi�2000O�b�WW G
N
OI +ION +NmNN WmmNN+
p�
OOO OO�LImmO+O(P 0O 1JO
O N N W O N O
W
O O O
O O O O O O O O S O W m O O O O =
O
O O O O O O O O O S O O O O O O O d
A
N /
C 55 O n o 0
�nomZ E�m�m �D R m
y° i R ow
AA 0000
OR
bt m'o iR m R
oz �� w
aaG�a2m
g
A
N
SW (OWN O
m� o
00 00000 0
�� �irass
z gzzgz
DD DDDDD
'm m Vn1No
O o .1. O° U
$$ $$$$$
t N 8. W N N O O
+ O N+ W W O O S
0 000
,N O W N
1
Z Z
:N' m
i
Oi O O°
10: S 000
(Ny Nf
z
al a I a';`;
0 0
$ $
P
8
NJI Nm
41
O (WWI
O A
m
Ny
d
R
W ` S
cu_
gzzz
gzzzz
g
a'nan
a'n
n
°
o0o
boob
c
O S O O O S
0 000
,N O W N
1
Z Z
:N' m
i
Oi O O°
10: S 000
(Ny Nf
z
al a I a';`;
0 0
$ $
P
8
NJI Nm
41
O (WWI
O A
m
Ny
d
R
W ` S
cu_
D
z
D
P m
v
� v
0
°o
°o
v
0
D
m
M
o _p W
OLT
^. G
Elm
n m
D e
I
SAC
P
C
c
-o3 m
y
3a
r
N3
Fn
N
m
z
a
D
�
C_
0
°o
°o
v
0
D
m
Parkview Villa South (166)
Balance Sheet February 2012
Books = Accrual
Feb -12
Assets
20200 Accounts Payable
163,509.66
10100 Cash Balance
1,682.50
20210 Accrued Other Expenses
93.00
10200 Petty Cash
9,037.95
22000 Deposits
575,970.36
10400 Investments
14,835.19
22200 Accrued PILOT
9.00
11300 Rent Receivable
265.00
11500 Accounts Receivable
0.00
Total Liabilities
739,582.02
Total Assets
Liabilities
20200 Accounts Payable
12,745.47
1,682.50
20210 Accrued Other Expenses
9,037.95
22000 Deposits
14,835.19
22200 Accrued PILOT
22210 Revenue Collected in Advance
265.00
38,565.21
Total Liabilities
Fund Balance
700,713.57
25300 Fund Balance
700,713.57
Total Fund Balance
Total Liabilities and Fund Balance
739,278.78
ON
Parkview Villa -South (166)
Income Statement
For The Period Ending February 2012
Books = Accrual
Revenue
36220 -46340 Gen. Government Rents
36225 -46340 Nondwelling Rents
36290 -46340 Other Miscellaneous Revenue
39120 -46340 Recovery Damage City
Total Revenue
Expenses
Personal Services
1000 -46340 Accrued Salaries
Total Personal Services
Supplies
2000 -46340 Office Supplies
2010 -46340 Minor Equipment
2160 -46340 Maint. & Construct Materials
2171 -46340 General Supplies
Total Supplies
Other Services & Charges
3040 -46340 Legal Fees
3050 -46340 Expert & Professional Services
3060 -46340 Management Services
3100 -46340 Protective Services
3210 -46340 Telephone & Telegraph
3430 -46340 Advertising Other
3600 -46340 Insurance & Bonds
3810 -46340 Electric
3820 -46340 Water
3830 -46340 Gas
3840 -46340 Refuse
3850 -46340 Sewer
4000 -46340 Repair & Maint. Services
4100 -46340 Rents & Leases
4300 -46340 Miscellaneous Charges
4315 -46340 PILOT
4390 -46340 Taxes & Licenses
4500 -46340 Administrative Expenses
4850 -46340 Interest on Deposits
Total Other Services & Charges
Month to Date % Year to Date
24,878.31
94.72%
50,814.31
95.79%
509.00
1.94%
1,053.00
1.98%
877.68
3.34%
1,180.68
2.23%
- 0.00% - 0.00%
26,264.99 100.000/0 53,047.99 100.000/0
3,723.00 14.17% 7,446.00 14.04%
3,723.00 14.17% 7,446.00 14.04%
31.71
0.12%
78.96
0.15%
0.00
0.00%
0.00
0.00%
38.77
0.15%
104.70
0.20%
112.70
0.43%
112.70
0.21%
183.18
0.70%
296.36
0.56%
0.00
0.00%
0.00
0.00%
0.00
0.00%
0.00
0.00%
2,312.00
8.80%
4,337.00
8.18%
0.00
0.00%
0.00
0.00%
113.31
0.43%
172.09
0.32%
0.00
0.00%
0.00
0.00%
841.25
3.20%
1,682.50
3.17%
1,028.48
3.92%
1,028.48
1.94%
0.00
0.00%
0.00
0.00%
2,465.07
9.39%
2,465.07
4.65%
0.00
0.00%
34.39
0.06%
0.00
0.00%
0.00
0.00%
5,412.68
20.61%
9,406.80
17.73%
0.00
0.00%
0.00
0.00%
0.00
0.00%
25.58
0.05%
1,059.66
4.03%
2,119.32
4.00%
558.62
2.13%
558.62
1.05%
3,232.74
12.31%
3,232.74
6.09%
7.17
0.03%
14.64
0.03%
17,030.98
64.84%
25,077.23
47.27%
174
Capital Outlay
5120 -46340 Building & Improvements
Total Capital Outlay
Total Expense
Excess (Deficit) Revenue over Expense
0.00%
0.00
0.00%
0.00%
20,937.16 79.72% 32,819.59 61.87%
5,327.83 20.28% 20,228.40 38.13%
2�
Parkview Villa South (166)
Cash Flow Statement
Period = February 2012
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
Total Supplies
Other Services & Charges
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
4100 Rent & 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
24,878.31
509.00
877.68
0.00
26,264.99
3,723.00
3,723.00
31.71
0.00
0.00
151.47
183.18
0.00
2,312.00
0.00
113.31
0.00
841.25
1,028.48
0.00
2,465.07
0.00
0.00
5,412.68
0.00
0.00
1,059.66
558.62
3,232.74
7.17
17,030.98
20,937.16
Parkview Villa South (166)
Cash Flow Statement
Period = February 2012
Excess (Deficit) Revenue over Expenses
Adjustments
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
5,327.83
(2.00)
3.00
0.00
4,496.44
841.25
(230.54)
1,059.66
(923.71)
5,244.10
10,571.93
Cash End Cash Difference
152,937.73 163,509.66 50,571.93
93.00 93.00 -
575,970.36 575,970.36 -
729,001.09 739,573.02 10,571.93
�l
3/13/2012 3:12 PM
Parkview Villa South (166)
General Ledger
Period = Feb 2012
Book = Accrual
Property
Data
Period
P I..n/Pescrlptl COhIml
Reference
Debit
Credit
Uniame.
Remarks
1000 -46340
A cued Salaries
3,723.01)
= Beginning Bala,
166
2/29/2012
02/2012
PostRecurrin9 Roc 1-130488
RC
3,223.00
0.00
2,446.00
VC CDC PR From i
Net Change= 3,223.00
2,446.00
= Ending Balance
2000 -46340
Office Supplies
47.25
= Beginning Bala,
166
2/312012
02/2012
Office Depot(ofOBE P- 260840
596838943001pvs
14.12
0.00
61.37
Vape. deskped etc.
166
218/2012
02/2012
Office Depot (SOME P- 268837
596839333001pvs
17.59
0.00
28.96
cards etc.
Net Change=31.71
78.96
= Ending Balance
3160.46340
Malnt. & Construct Materials
65.93
= Beginning Bala,
166
1/27/2012
02/2012
HD Supply Focilitle, P- 267459
91131689O2pvs
19.72
0.00
85.70
thermocouples, ice
166
1/30/2012
02/2012
Home Oepot Credit P- 268842
561094
19.00
0.00
104.70
bulbs etc.
Net Chan9e=38.72
104.70
= Ending Balance
2121 -46340
General Supplies
0.00
= Beginning Bala,
166
1/18/2012
02/2012
HD Supply Pucllltiet P- 267453
9112999196pvs
61.O1
0.00
61.01
trash liners, sponge
166
1/19/2012
02/2012
HD Supply Facilltie!P- 267456
9113025353pvs
13.80
0.00
74.81
glass cleaner, magi
166
2/1412012
02/2012
Buckeye Cleaning ( P-26991D
651311
32.89
0.00
112.70
roll towel
Net Change= 112.70
112.20
= Ending Balance
3060 -46340
Management Services
2,025.00
= Beginning Bala,
166
2/29/2012
02/2012
Commonlord Hom P- 269944
926295
6,035.00
0.00
8,060.00
argue fees 02/12
166
2/29/2012
02/2012
Patt8ecurring Rec 1- 130488
RC
0.00
3,723.00
4,332.00
PVC CDC PR MgmtI
Net Change= 1,312.00
4,332.00
= Ending Balance
3210 -46340
Telephone & Telegraph
58.78
= Beglnning Bala,
166
2/2/2012
02/2012
ComCase(CU11c342 P- 267450
877210505019618:
23.18
0.00
81.96
Internet svc 2111 -3
166
217/2012
0212012
Centaryl.ink(ImArl P- 269900
7637883978/02121
17.48
0.00
99.44
phone svc 2/02 -3 /C
166
2/11/2012
02/2012
MCI Comm Service P- 269203
2637883978/02121
11.16
0.00
110.60
phone svc- due 3/1
166
2/15/2012
02/2012
Office of Enterprise P- 269905
W12010671/0112p
61.49
0.00
172.09
phone svc- perem
Net Change= 113.31
172.09
= Ending Balance
3600 -46340
Insurance & Bonds
84135
= Beginning Balm
166
2/2912012
02/2012
:Post Recurring Rec J- 130488
RC
841.25
0.00
1,6112.50
C of Columbia H.191
Net Change=841.25
1,682.50
= Ending Balance
3810 -46340
Electric
0.00
= Beginning Bala,
166
2/13/2012
02/2012
Xfel Energy (xce0 P- 268607
5150441553101121
0.00
561.88
- 561.88
at., cmdV vc 1/07
166
2/13/2012
02/2012
Scel Energy (scar) P- 268607
5150441553/01121
1,590.36
0.00
1,028.48
tie, creft /svc 1/07
Net Change= 1,028.48
1,028.48
= Ending Balance
3830 -46340
Gas
0.00
= Beginning Bala1
166
2/8/2012
02/2012
Camewo nt Energy P- 267952
5527132410112
2,465.07
DAD
2,465.07
gas svc 1/06 -2 /06
Net Change= 2,465.02
2,465.02
= Ending Balance
3840 -46340
Refuse
34.39
= Beginning Balm
Net Change =0.00
34.39
= Ending Balance
4000 -46340
Repair& Maine. Services
3,994.12
= Beginning Balm
166
1/18/2012
0212012
Adam's Pest COatrc P- 268269
693236pvs
22.00
0.00
4,016.12
pest svc 1/18
166
1/23/2012
02/2012
MGS Professional B P- 262463
10361pes
29.45
0.00
4,045.57
snow Inner svc 1/23
166
1/27/2012
02/2012
HD Supply Fadiitie!P- 267459
911316B902pvs
15 .76
0.00
4,061.33
thermocouples, Ice
166
1/31/2012
02/2012
USA Mechanical, Or P- 267462
W16439
843.66
0.00
4,904.99
Zone valve svc -41
166
1/3112012
02/2012
BFB Painting, Inc (P- 268270
1312012pvs
280.00
0.00
5,184.99
painting -415
166
2/1/2012
02/2012
Eagle Elevator Corr P- 267451
11271B rises
309.18
0.00
5,494.17
me mount 02/12
166
2/1/2012
02/2012
Jerry's Floor Store, P- 267460
X630778
180.98
0.00
5,625.15
vinyl inst -415
166
2/1/2012
02/2012
Jerry's Floor Store. P- 267461
X630769
705.53
0.00
6,380.68
last Carp- 415
166
2/6/2012
02/2012
Bio Corps, LLC(bio P- 269202
120201
2,300.00
0.00
8,680.68
2 tech, - bio clean
166
2/8/2012
02/2012
Adam's Pest Cmtw P- 269201
698311pvs
22.00
0.00
8,702.68
pest svc 2/08
166
2/16/2012
02/2012
LBP Mechanical, lm P- 269909
W16607
449.67
0.00
9,152.35
Zone valve service
166
2/21/2012
02/2012
MGS Professional P- 269906
1O378pvs
29.45
0.00
9,181.80
snow Omar svc 2/21
166
2/23/2012
02/2012
Zephyr Services lm P- 269907
427
225.00
0.00
9,406.80
Sfieetmck repair - :
Net Change= 5,412.68
9,406.80
= Ending Balance
430046340
Miscellaneous Charges
25.56
= Beginning Saint
Net Change=e.00
25.58
= Ending Balance
431546340
PILOT
1,O59.66
= Beginning Bala,
166
2/2912012
02/2012
:Post Recurring Rec J- 130488
RC
1,O59.66
0.00
2,119.32
Anoka Cry Property
Net Change= 1,059.66
2,119.32
= Ending Balance
Page 1 of 22
3113/2012 3:17 PM
Parkvlew Villa South (166)
General Ledger
Period = Feb 2012
Book = Accrual
Property
Oat.
Period
Par son /DescriPtl Control
Rot e...¢
Dealt
Credit
Balance
R.nlarke
0.00
= Beginning Bala
4390-46340
Taxes& Us ... Ea
166
2/22/2012
02/2012
Columbia Heights FP- 269633
022212pvs
558.62
0.00
558.62
Prop rental license
Net Clonge=558.62
558.62
= Ending Balance
0,00
= Beginning Bala,
4500 -46340
Administrative Expenses
166
2/16/2012
02/2012
Comman0onl Hom P- 268511
921840
2.49
0.00
7.49
2011- 1099 /CRP car
166
2/12/2012
02/2012
Common Bond Hom P- 268317
921932
228.25
0.00
285.24
2011 CRP lees
166
2/21/2012
02/2012
City of Columbia lh P- 269631
2Dltpvs
2,942.00
0.00
3,232.74
pvs 2011 servicing
Net Change= 3,232.74
3,23274
= Ending Balance
4850 -46340
Interest On Deposits
7.47
= Beginning Baia,
166
2/29/2012
02/2012
Sec Dep interest a,3131747
G31
7.12
O.OD
14.64
See Den interest ac
Net Change =7.17
14.64
= Ending Balance
25,22204 4,284.88
Page 2 of 22 ��
5016464
Parkview Villa South 3112/12
Bank Reconciliation Report
02/29/2012
Balance Per Bank Statement as of 02/29/2012
$164,023.64
02/1112009
389 mcic - MCI Comm Service
5.47
01/19/2012
1296 10003793 - Johnson
199.06
02/15/2012
1321 mgsp - MGS Professional Bldg Maint Sery Inc
29.45
02/23/2012
1324 bfbp - BFB Painting, Inc.
280.00
Less:
Outstanding Checks
$513.98
gree1004 - Green Lights Recycling Inc
Reconciled Bank Balance
$163,509.66
Balance per GL as of 02/29/2012 $163,509.66
Reconciled Balance Per G/L $163,509.66
Difference
0.00
Cleared Items:
Cleared Checks
Date
Tran #
Notes
Amount
Date Cleared
01/19/2012
1293
comc3474 - Comcast
20.13
02129/2012
01/25/2012
1297
cent - CenterPoint Energy
2,195.07
02/2912012
1299
gree1004 - Green Lights Recycling Inc
34.39
02/2912012
01125/2012
1301
mgsp - MGS Professional Bldg Maint Sery Inc
55.03
02/29/2012
01/25/2012
1304
pet1661s - Laura Sheak
64.21
02/2912012
01/25/2012
02/01/2012
1306
cent9115- Centuryl-ink
17.48
02/29/2012
02/01/2012
1307
gard1086 - Gardner Plumbing, LLC
201.50
02/29/2012
02101/2012
1308
home7 - HD Supply Facilities Maintenance
69.85
02/2912012
02/01/2012
1309
mcic3718 - MCI Comm Service
7.69
02/29/2012
1310
mgsp - MGS Professional Bldg Maint Sery Inc
58.90
02/29/2012
02/01/2012
1311
1nndpl - MN Dept of Labor & Industry
30.00
02/29/2012
02101/2012
1312
offi8804 - Office Depot
23.61
02/29/2012
02/01/2012
02/08/2012
1313
chc - CommonBond Housing
5,748.00
02/2912012
02108/2012
1314
eagl1 - Eagle Elevator Corp.
1,592.00
02/29/2012
1315
kocl - K.O. Cleaning and Restoration LLC
500.00
02/2912012
02/08/2012
1316
comc3474 - Comcast
23.18
02/29/2012
02/15/2012
1317
eagl1 - Eagle Elevator Corp.
309.18
02129/2012
0211512012
1318
home7 - HD Supply Facilities Maintenance
110.34
02/29/2012
02/15/2012
1319
lerrl - Jerry's Floor Store
886.51
02/2912012
02115/2012
Ibpm - LBP Mechanical, Inc
843.66
02129/2012
02/1512012
1320
02/29/2012
02/29/2012
02/29/2012
02/29/2012
02/29/2012
Date Cleared
02/29/2012
02/29/2012
02/29/2012
02/29/2012
02/29/2012
15
3/12/12
Parkview Villa South
Bank Reconciliation Report
02/29/2012
5016464
02/15/2012
1322
10006372 - Field
332.11
02/23/2012
1323
adam - Adam's Pest Control, Inc.
22.00
02/23/2012
1325
cent - CenterPoint Energy
2,465.07
02/23/2012
1326
clic- CommonBond Housing
285.74
02/23/2012
1327
xcel - Xcel Energy
1,028.48
$16,924.13
Total
Cleared Deposits
Date Tian
#
Notes
Amount
02/0212012
287
laundry receipt
289.39
02102/2012
288
rent deposit
16,423.00
02/03/2012
289
rent deposits
7,469.29
02106/2012
290
operations
596.00
02/14/2012
291
dep
659.00
$25,436.68
Total
02/29/2012
02/29/2012
02/29/2012
02/29/2012
02/29/2012
Date Cleared
02/29/2012
02/29/2012
02/29/2012
02/29/2012
02/29/2012
15
3/12/12
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
Date 2/29/12 Page 1.
Primary Account @XXXXX @6464
Enclosures 32
A C C O U N T S - - --
EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING
DOMESTIC WIRES WILL BE INCREASED TO $20 AND AN EARLY ACCOUNT
CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS
CLOSED IN LESS THAN 3 MONTHS AND LIEALTH SAVINGS ACCTS PRIOR
TO 3 YEARS. THE MAXIMUM DAILY LIMIT FOR NSY PAID AND
RETURNED TM
EMFEE(CONSUMER ONLY) IS$1220 .
NORTHEAST PUBLIC FUNDS ACCT @XXXXX @6464
Account Number
Previous Balance 155,511.09
6 Deposits /Credits 25,446.68
26 Checks /Debits 16,934.1030
Service Charge .00
Interest Paid 164,023.64
Ending Balance
Number of Images 32
Statement Dates 2/01/12 thru 2/29/12
Days in the Statement Period 29
Average Ledger 170,890
Average Collected 169,827
*********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **
Deposits
and Credits
Check#
Amount
Date
Description
58.90
289
39
2/02
DDA REGULAR
DEPOSIT
16,423.00
2/02
DDA REGULAR
DEPOSIT
7,469.29
2/03
DDA REGULAR
DEPOSIT
10.00
2/06
DDA REGULAR
DEPOSIT
596.00
2/06
DDA REGULAR
DEPOSIT
659.00
2/14
DDA REGULAR
DEPOSIT
*********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **
Charges and Debits Amount
Date Description 10.00 DR
2/03 DDA DEBIT MEMO
*********************************************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **
Checks in serial order
Date Check#
2/01 1
2/27 110*
2/01 1293*
* Indicates skip in check
Amount
Date
Check#
64.21
2/02
1297*
58.90
2/01
1299*
20.13
2/27
1301*
numbers
Amount
2,195.07
34.39
55.03
Date 2/29/12 Page 2
Primary Account @XXXXX @6464
Enclosures 32
NORTHEAST
PUBLIC FUNDS
ACCT @XXXXX @6464
(Continued)
Checks in
Date
serial order
Check#
Amount
Date
Checkdk
Amount
2/07
1306*
17.48
2/21
1317
309.18
2/07
1307
201.50
2/23
1318
110.34
2/08
1308
69.85
2/21
1319
886.51
2/10
1309
7.69
2/24
1320
843.66
2/06
1311*
30.00
2/24
1322*
332.11
2/09
1312
23.61
2/29
1323
22.00
2/10
1313
5,748.00
2/29
1325*
2,465.07
2/13
1314
1,592.00
2/27
1326
285.74
2/14
1315
500.00
2/27
1327
1,028.48
2/22
1316
23.18
* Indicates skip in check numbers
***********************************************
* *
* * * * * ** *
* * * * * * * *
* * * * * * * * * * * **
Daily Balance Section
Date Balance
Date
Balance
Date
Balance
2/01
155,392.36
2/09
177,632.53
2/23
169,114.63
2/02
169,909.68
2/10
171,876.84
2/24
167,938.86
2/03
177,368.97
2/13
170,284.84
2/27
166,510.71
2/06
177,944.97
2/14
170,443.84
2/29
164,023.64
2/07
177,725.99
2/21
169,248.15
2/08
177,656.14
2/22
169,224.97
* * *
E N D O F
S
T A T E
M
E N T
31
Payment Summary
Bank= 166opr AND mm /yy= 02/2012- 02/2012 AND All Checks =Yes AND Include Volds =All Checks
■
Check
Post
Total
Bank
Check#
Vendor
Date
Month
Amount
166opr - Parkview Villa South
1306
cent9115 - Century Link
02/01/2012
02/2012
17.48
166opr - Parkview Villa South
1307
gard1086 - Gardner Plumbing, LLC
02/01/2012
02/2012
201.50
166opr - Parkview Villa South
1308
home? - HD Supply Facilities Maintenance
02/01/2012
02/2012
69.85
166opr - Parkview Villa South
1309
mc1c3718 - MCI Comm Service
02/01/2012
02/2012
7.69
166opr - Parkview Villa South
1310
mgsp - MGS Professional Bldg Maint Sery Inc
02/01/2012
02/2012
58.90
166opr - Parkvlew Villa South
1311
mndpl - MN Dept of Labor & Industry
02/01/2012
02/2012
30.00
166opr - Parkview Villa South
1312
off18804 - Office Depot
02/01/2012
02/2012
23.61
166opr - Parkview Villa South
1313
chc - CommonBond Housing
02/08/2012
02/2012
5,748.00
166opr - Parkview Villa South
1314
eag11 - Eagle Elevator Corp.
02/08/2012
02/2012
1,592.00
166opr- Parkview Villa South
1315
kocl- K.O. Cleaning and Restoration LLC
02/08/2012
02/2012
500.00
166opr - Parkview Villa South
1316
comc3474 - Comcast
02/15/2012
02/2012
23.18
166opr - Parkvlew Villa South
1317
eaglI - Eagle Elevator Corp.
02/15/2012
02/2012
309.18
166opr - Parkview Villa South
1318
home7 - HD Supply Facilities Maintenance
02/15/2012
02/2012
110.34
166opr - Parkview Villa South
1319
jerrl - Jerry's Floor Store
02/15/2012
02/2012
886.51
166opr - Parkview Villa South
1320
Ibpm - LBP Mechanical, Inc
02/15/2012
02/2012
843.66
166opr - Parkvlew Villa South
1321
mgsp - MGS Professional Bldg Maint Sery Inc
02/15/2012
02/2012
29.45
166opr - Parkview Villa South
1322
t0006372 - Field
02/15/2012
02/2012
332.11
166opr - Parkvlew Villa South
1323
adam - Adam's Pest Control, Inc.
02/23/2012
02/2012
22.00
166opr - Parkvlew Villa South
1324
bfbp - BFB Painting, Inc.
02/23/2012
02/2012
280.00
166opr- Parkvlew Villa South
1325
cent- CenterPoInt Energy
02/23/2012
02/2012
2,465.07
166opr - Parkvlew Villa South
1326
chc - CommonBond Housing
02/23/2012
02/2012
285.74
166opr - Parkvlew Villa South
1327
xcel - Xcel Energy
02 23 12
02/2012
1,028.48
14,864.75
■
Parkview Villa North
Financial Statement Overview
January 2012
Revenue:
Occupancy for the month of January 2012 was 100% occupied;
Total Revenue was under budget amount (unfavorable). No Grant Income was
recognized in the month of January.
Administrative Expenses:
Administrative costs for the North were under budget (favorable).
Other Renting Expenses were under budget (favorable), and reflect minimum applicant
screening needed due to low turnover.
Office Salary line shows the staffing portion for North per contract, both office and
maintenance staff.
Office Supply expenses are under budget (favorable)
Legal Expenses Project was under budget (favorable).
Telephone, Answering Service and Internet expenses are under budget (favorable).
Utilities:
Utilities Expenses are under budget (favorable), however, these are quarterly billings
No Utilities were invoiced or paid in the month of January.
Oeeratine and Maintenance Expense (supplies):
Operating and Maintenance Expenses are under budget (favorable).
Janitor and Cleaning Supplies are under budget (favorable).
Janitor Contract expenses were slightly over budget (unfavorable),
Exterminating Contract is under budget (favorable)
Maintenance Supplies is over budget (unfavorable) and reflects cost of replacement of 2
toilets
Garbage and Trash are under budget (favorable); this reflects only recycling of
appliances, regular trash removal invoices quarterly.
Security Contract is over budget (unfavorable). This reflects the costs of replacing all
sprinkler heads
Repairs Contract expenses were under budget (favorable)
Elevator Maintenance Contract is under budget (favorable).
Snow Removal is under budget (favorable).
Decorating Contract and Supplies were under budget (favorable)
Furniture and Fixtures is under budget (favorable)
Z
O 0 0
Z A 6i 3 Z �' ° tCL m
Wd�m 71 0d00 G1AA C D` `e
a 3
z78
&' 3 S �^ m A O
N �
A N ?n m m m
W P. O P
O O O O O O O+ N 0 0 0 O J O UJi O UUi 0. O O O O O O O O O CCC-
+ A + A
O O W A
W Q N W N
+ A + P
O O O W A
W O N W W
W P N W N
88888
O O O O O
O O O O O
+ A + A
O N N
.0N..
+ P + A
i q O m
�O(NI�W (Jli
P
+OPAJNiONN +N
N O+ N O+ N N N O
OOJW(NIiOJ0000
+pAN U� p
O W+ Ili J O O U W N A
mWW JWN000(I�OU
+ WN
A W O O A O A A A O W
AW 000OJi00N000
A N
+ W A N W
W+ N +J M p a
+N000OJ OIJIi0U0i
p P W
N O N N O N N O
O O J W UNi O J O O O O
bm'p&NJ'ooNmNg
�OJWVNi000N0(01
O1N +� m miJ
N T 01 A N
u o m N N N o
W
mNT b U�NUWI
O O O + O
O O O N O
N J
VI VIN UNi
000 W ,NOW
O O O O O O O
P 8 C
cea i a-a
aa° d a•e
p� N
O> N +
N O J
qmo °o
A N 00 °O
Y N
AIUWi INn 0A o �
0 0 0 0 0
e �
� W O
0
mu
A
O
m
L °
iro
O O O O O
°oo °o °U °o
mo °WP.`d... °oNo °oo
D
N O(JI�O (li
AOOOOOVOOJO00
� N
00000
OIOOOOOOOONO00
O1N +� m miJ
N T 01 A N
u o m N N N o
W
mNT b U�NUWI
O O O + O
O O O N O
N J
VI VIN UNi
000 W ,NOW
O O O O O O O
P 8 C
cea i a-a
aa° d a•e
p� N
O> N +
N O J
qmo °o
A N 00 °O
Y N
AIUWi INn 0A o �
0 0 0 0 0
e �
� W O
0
mu
A
O
m
L °
iro
pm� pKp�'
'o
a o n w ia ia o$
fMi �T 8 d m 0o °'v o o M
s
T
N
S
D
O N
V �
� N
i
wpm wpm �mo0�
om�o����o °omNOso
(0J00010010 WW ONjP +NNO qN lm
W O J J O J S W O O J J J N J S Oi W
pp N
W A N J N J W S O O 4Wi + N N W O
p J J OI Ni � y y
mob +1OW00W NOONTOOVwiO O{bE{
O .0o.. O S O 1N 0 0 0. N O S. S
O' UNi
WO.
YyNOOIOm pw ON�P OIO N1
J O (wJ O J J S J S W O O I J N J O 001 R
n J N A Ww (NO r NO
W NWO�m OOi+O ONOSwNw
W> N J N J (WJ 0 0 0 W� N N IWJ O
r
O �NOSOAJZOONO�i S(JO O
pA�
A (O
•O
10 (b
S N
ffODJ
0
Oi W
� WO
OONSOO SOOQ�O (➢1100 N
w
JOJ
b 01
00
A A
is
N N
N O
O
S
S B
S S
A }F
fm0
b
tO
OI N
NV
W
pLl
m W
J O
Owl N
(ll
N 608
!D 4Ni
SS
YOJ
W
NN
fll
N(J)i
000
A
l0 f"li
W
W j
N N
0 S
W
W J
V O
wpm wpm �mo0�
om�o����o °omNOso
(0J00010010 WW ONjP +NNO qN lm
W O J J O J S W O O J J J N J S Oi W
pp N
W A N J N J W S O O 4Wi + N N W O
p J J OI Ni � y y
mob +1OW00W NOONTOOVwiO O{bE{
O .0o.. O S O 1N 0 0 0. N O S. S
O' UNi
WO.
YyNOOIOm pw ON�P OIO N1
J O (wJ O J J S J S W O O I J N J O 001 R
n J N A Ww (NO r NO
W NWO�m OOi+O ONOSwNw
W> N J N J (WJ 0 0 0 W� N N IWJ O
r
O �NOSOAJZOONO�i S(JO O
pA�
A (O
•O
10 (b
S N
ffODJ
0
Oi W
� WO
OONSOO SOOQ�O (➢1100 N
JOJ
b 01
00
A A
is
N N
N O
O
S
S B
S S
N
wpm wpm �mo0�
om�o����o °omNOso
(0J00010010 WW ONjP +NNO qN lm
W O J J O J S W O O J J J N J S Oi W
pp N
W A N J N J W S O O 4Wi + N N W O
p J J OI Ni � y y
mob +1OW00W NOONTOOVwiO O{bE{
O .0o.. O S O 1N 0 0 0. N O S. S
O' UNi
WO.
YyNOOIOm pw ON�P OIO N1
J O (wJ O J J S J S W O O I J N J O 001 R
n J N A Ww (NO r NO
W NWO�m OOi+O ONOSwNw
W> N J N J (WJ 0 0 0 W� N N IWJ O
r
O �NOSOAJZOONO�i S(JO O
W A N W➢ (P O W J O w W
_+ _W
OJOp0 N
OONSOO SOOQ�O (➢1100 N
N
o O O o O
boo
O O O O
+ O pO + O O
UJi00 +�00
Z Z z � Z Z Z
DDD DDDD
J N W P O O O
+ O O
N O O N+ O O
... O U O O
O O O O O O O
jNP al�0o
00
NOO �`�00
zzz
z,,
zzz
DDD
DDDD
D
o'
n
C
D
N
o 0
m
o
6I'
o W n
G '
D
Er
o
E
o o
P
R
"-�
z
o
P
s a a <
OO
� 0
000
0000
O
n
m
� N
N
y
C�
"
VIII`
- =nw
g2c"
5D�8
a
v,
N8go
°m
ol�sy�
-•
duo
i
riw.Zr
Q.nd
x
a000�
CG.p
°
Z
N
v
oGH =A
a'0
t{
P y
y.
o O z
�o��
adv
m
R
p�AA�
m^o
0°mom
�
m
A
o O O o O
boo
O O O O
+ O pO + O O
UJi00 +�00
Z Z z � Z Z Z
DDD DDDD
J N W P O O O
+ O O
N O O N+ O O
... O U O O
O O O O O O O
jNP al�0o
00
NOO �`�00
N
W N m
OWi J W
O O +1
O O
W
W N
01 J
O O
Z Z Z
DDDD D
N (NJ O
W N W
II 9Io o S
U O
7 O
W�
W N
mJ
o °o
DID D D
tl O O O O
3 O O O O O
A-
O Ji
� VI
I�
A O1
V J a
J J dE
9
V J O
W W
Vp J N
Omi N d
W N
yN
4i W i
s
0n
E
V J
+1 J dff
N J V
mm m w
W W 6
W � m
V J �O
N N
Nm8
N N e
WO
I N N
O O C
i 0001 W
zzz
z,,
zzz
DDD
DDDD
D
o'
v°
D
0
0
� 0
000
0000
O
� N
000
0000 O
N
W N m
OWi J W
O O +1
O O
W
W N
01 J
O O
Z Z Z
DDDD D
N (NJ O
W N W
II 9Io o S
U O
7 O
W�
W N
mJ
o °o
DID D D
tl O O O O
3 O O O O O
A-
O Ji
� VI
I�
A O1
V J a
J J dE
9
V J O
W W
Vp J N
Omi N d
W N
yN
4i W i
s
0n
E
V J
+1 J dff
N J V
mm m w
W W 6
W � m
V J �O
N N
Nm8
N N e
WO
I N N
O O C
i 0001 W
± / G)
§
®§|
]
-
§
\
\
/
®§�
4
)
(
t
± / G)
p ;
§
®§|
]
/
®§�
4
p ;
;;#
ƒ ( ƒ}
Parkview Villa -North (165)
Balance Sheet
January 2012
Books = Accrual
Assets
10100 Cash Balance
10200 Petty Cash
10400 Investments
11300 Rent Receivable
11500 Accounts Receivable
13200 Due From Other Government Units
Total Assets
Liabilities
20200 Accounts Payable
20210 Accrued Other Expenses
20220 Due to Resident Council
22000 Deposits
22200 Accrued PILOT
22210 Revenue Collected in Advance
Total Liabilities
Fund Balance
25300 Fund Balance
Total Fund Balance
Total Liabilities and Fund Balance
Jan -12
223,562.66
457.00
823,425.08
2,850.00
250.00
22,852.63
1,073,397.37
22,389.54
1,741.75
551.74
17,758.06
24,053.94
1,689.00
68,184.03
1,005,213.34
1,005,213.34
1,073,397.37
I
Parkview, Villa -North (165)
Income Statement
For The Period Ending January 2012
Books = Accrual
Month to Date % Year to Date
Revenue
0.00
0.00%
0.00
0.00% '..
33160 -46330 Federal Grant
-
0.00%
-
0.00%
36220 -46330 Gen. Government Rents
28,558.00
96.32%
28,558.00
96.32%
36225 -46330 Nondwelling Rents
320.00
1.08%
320.00
1.08%
36290 -46330 Other Miscellaneous Revenue
771.00
2.60%
771.00
2.60%
39120 -46330 Recovery Damage City Property
-
0.00%
-
0.00%
Total Revenue
29,649.00
100.000/0
29,649.00
100.000/0
Expenses
Personal Services
1000 -46330 Accrued Salaries 8,357.00 28.19% 8,357.00 28.19%
Total Personal Services 8,357.00 28.19"70 8,357.00 28.190/0
Supplies
0.00
0.00%
0.00
0.00% '..
2000 -46330 Office Supplies
221.67
0.75%
221.67
i
0.75%
2010 -46330 Minor Equipment
0.00
0.00%
0.00
0.00%
2160 -46330 Maint. & Construct Materials
1,230.12
9.15%
1,230.12
4.15%
2171 -46330 General Supplies
287.26
0.97%
287.26
0.97%
Total Supplies
1,739.05
5.87%
1,739.05
5.87016
Other Services & Charges
3040 -46330 Legal Fees
0.00
0.00%
0.00
0.00% '..
3050 -46330 Expert and Professional Services
0.00
0.00%
0.00
0.00%
3060 -46330 Management Services
4,545.00
15.33%
4,545.00
15.33%
3100 -46330 Protective Services
3,212.00
10.83%
3,212.00
10.83%
3210 -46330 Telephone & Telegraph
181.12
0.61%
181.12
0.61%
3430 -46330 Advertising Other
-94.05
0.00%
-94.05
- 0.32%
3600 -46330 Insurance & Bonds
1,741.75
5.87%
1,741.75
5.87%
3810 -46330 Electric
0.00
0.00%
0.00
0.00%
3820 -46330 Water
0.00
0.00%
0.00
0.00%
3830 -46330 Gas
0.00
0.00%
0.00
0.00%
3840 -46330 Refuse
76.56
0.26%
76.56
0.26%
3850 -46330 Sewer
0.00
0.00%
0.00
0.00%
4000 -46330 Repair & Maint. Services
4,200.75
14.17%
4,200.75
14.17%
4100 -46330 Rents & Leases
6.75
0.02%
635
0.02%
4300 -46330 Miscellaneous Charges
0.00
0.000%
0.00
0.00%
4315 -46330 PILOT
1,850.30
6.24%
1,850.30
6.24%
4390 -46330 Taxes & Licenses
0.00
0.00%
0.00
0.00%
4500 -46330 Administrative Expenses
0.00
0.00%
0.00
0.00%
4850 -46330 Interest on Deposits
13.31
0.04%
13.31
0.04%
Total Other Services & Charges
15,733.49
53.07070
15,733.49
53.07%
Capital Outlay
5120 -46330 Building & Improvements
Total Capital Outlay
Total Expense
Excess (Deficit) Revenue over Expense
587.67 0.00% 587.67 1.98%
587.67 1.980/0 587.67 1.980/0
26,417.21 89.10% 26,417.21 89.10%
3,231.79 10.900/0 3,231.79 10.900/0
I
Parkview Villa -North (165)
Cash Flow Statement
Period = January 2012
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
3060 Management Services
3100 Protective Services
3210 Telephone & Telegraph
3430 Advertising Other
3600 Insurance & Bonds
3810 Electric
3620 Water
3830 Gas
3840 Refuse
3850 Sewer
4000 Repair & Maint. Services
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
28,558.00
320.00
771.00
0.00
29,649.00
8,357.00
8,357.00
221.67
0.00
0.00
1,517.38
0.00
1,739.05
0.00
4,545.00
3,212.00
181.12
-94.05
1,741.75
0.00
0.00
0.00
76.56
0.00
4,200.75
6.75
0.00
1,850.30
0.00
0.00
13.31
587.67
16,321.16
26,417.21
3,231.79
10
Parkview Villa -North (165)
Cash Flow Statement
Period = January 2012
Book = Accrual
Adjustments
11300 Rent Receivable
11500 Accounts Receivable
13200 Due From Other Government Units
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
- 357.00
- 150.00
63,336.50
- 20,246.64
1,741.75
201.91
1,850.30
460.00
46,836.82
50,068.61
Cash End Cash Difference
173,494.05 223,562.66 50,068.61
457.00 457.00 -
725,325.08 725,325.08 -
899,276.13 949,344.74 50,068.61
3/12/2012 3:18 PM
Parkview Villa- North(165)
General Ledger
Period = ]an 2012
Book = Accrual
Period Person/ Description Control
Reference
Debit
Credit
Balance Remarks
Property :Date
0.00 = Beginning Balance =
1000 -46330
Accrued Salaries
8,357.00
0.00
8,357.00 R/C CHC PR Mgmt Fee
165
1/31/2012
01/2012 :POStRecurrl ng Monthly recurring enb 3- 128699
RC
8,357.00 = Ending Balance =
Net Change= 8,357.00
0.00 = Beginning Balance =
2000 -46330
Office Supplies
169.12
0.00
169.12 postage, cards
165
1/4/2012
01/2012 Laura Shook (pet1651s) P- 263602
010412pvn
1/11/2012
01/2012 Office Depot(of88804) P- 264721
593407841001pvn
5255
0.00
221.67 paper, envelopes etc.
165
221.67 = Ending Balance =
Net Change = 221.67
0.00 = Beginning Balance =
2160 -46330
Maim. & Construct Materials
0.00
56.25 wrap lens
16S
1/4/2012
01/2012 Laura Sheak(pet1651s) P- 263602
010412pvn
56.25
1/512012
01/2012 Gardner Plumbing, LLC (9ard1086) P- 264591
2388
868.86
0.00
925.11 wall hung water closets -.
165
01/2012 Park Supply of America, Inc. (parkl) P- 263600
39490300
43.93
0.00
969.04 wrench, Bush valve
165
3/6/2012
01/2012 HD Supply Facilities Maintenance (hoi P- 264594
9112865015pvn
113.38
0.00
1,082.42 spindle, steel chain etc.
165
1/11/2012
1/12/2012
01/2012 HD Supply Facilities Maintenance (ho, P- 264595
9112902652pvn
42.09
0.00
1,124.51 ice melt
165
1/19/2012
0112012 home Depot Credit Services (home3: P- 265899
1990873
105.61
0.00
wt thread seal etc.
165
1,2 0.12 Ending a
Net Change= 1,230.12
0.00 = Beginning Balance =
2171 -46330
General Supplies
12.16
0.00
12.16 spry paint, potting soil
165
1/4/2012
01/2012 Laura Shook (pet1651s) P- 263602
010412pvn
165
1/12/2012
01/2012 Sherwin - Williams Co. (Sher4110) P- 264725
5327 -4
275.10
0.00
287.26 paint
Net Change = 287.26
287.26 = Ending Balance =
0.00 = Beginning Balance =
3060 -46330
Management Services
12,902.00
0.00
12,902.00 mgmt fees 01/12
165
1/31/2012
01/2012 Comr-am and Housing (chc) P- 265228
911660
165
1/31/2012
01/2012 :POStRecurring Monthly recurring evil ]- 128699
RC
0.00
8,357.00
4,545.00 R/C CHC PR Mgmt Fee
41545.00 = Ending Balance =
Net Change = 4,545.00
0.00 = Beginning Balance =
3100 -46330
Protective services
3,212.00
0.00
3,212.00 sprnklr head real- 87
165
1/23/2012
01/2012 Olsen Fire Inspection, Inc. (else) P- 264723
54373
3,212.00 = Ending Balance =
Net Change = 3,212.00
0.00 = Beginning Balance =
3210 -46330
Telephone &Telegraph
0.00
30.27 answr Svc 01/12
165
1/1/2012
01/2012 AnswerLive LLC(answ) P- 262015
111204620101pvu
30.27
1/2/2012
01/2012 Comcast(comc3474) P- 262537
877210505019618
44.82
0.00
75.09 Internet Svc 1/11 -2/10
165
01/2012 Centur tink(cent9115) P- 264586
7637883978/0112,
38.90
0.00
113.99 phone Svc 01112
165
1/7/2012
Service(mcic3718) P- 264711
7637883978/12111
17.13
0.00
131.12 phone Svc 12/20 -01 /10
165
1/11/2012
01/2012 MCI Comm
0.00
181.12 set up fee answ Svc
165
1/19/2012
01/2012 Level One (love) P- 264705
219890 -IN
50.00
Net Change= 181.12
181.12 = Ending Balance =
0.00 = Beginning Balance
=
3430 -46330
Advertising Other
94.05
-94.05 Ad 10/20
165
1/27/2012
01/2012 Sun Newspaper(sunn) P- 264393
1344053- 264393
0.00
165
1/27/2012
01/2012 Sun Newspaper(sunn) P- 264393
1344053- 264393
94.05
0.00
D.00 Ad 10120
1/27/2012
01/2012 Sun Newspaper(sunn) P- 264393
1344053- 264393
0.00
94.05
-94.05 Ad 10/20
165
-94.05 = Ending Balance =
Net Change = -94.05
0.00 = Beginning Balance
=
3600 -46330
Insurance & Bonds
1,741,75
0.00
1,741.75 C of Columbia Heights Ins
165
1/31/2012
01/2012 :PostRecurring Monthly recurring enb]- 128699
RC
1,741.75 = Ending Balance =
Net Change = 1,741.75
0.00 = Beginning Balance
=
3840 -46330
Refuse
76.56
0.00
76.56 appl recycling 1/05
165
1/5/2012
01/2012 Green Lights Recycling Inc (gree1004 P- 263587
12- 1039pvn
76.56 = Ending Balance =
Net Change =76.56
0.00 = Beginning Balance
=
4000 -46330
Repair & Maint. Services
P
688.17
0.00
688.17 mo malnt - 01/12
165
111/2012
01/2012 Eagle Elevator Corp. (eag11) P- 263586
112124 -Ipvn
01/2012 K.O. Cleaning and Restoration LLC (k P- 262545
2031
400.00
0.00
1,088.17 painting etc. #211
165
1/3/2012
Cleaning and Restoration LLC (k P- 262545
2031
300.00
0.00
1,388.17 painting etc. 4211
165
1/3/2012
01/2012 K.O.
Bldg Paint Sery Inc P- 263598
10333pvn
122.48
0.00
1,510.65 snow rmvl Svc 01/01
165
1/6/2012
01/2012 MGS Professional
263601
424
478.45
0.00
1,989.10 prey malnt- pre nspec
165
1/8/2012
01/2012 Zephyr Services Inc.(reph) P-
0.00
2,894.39 vinyl lost - 221
165
1/9/2012
01/2012 Jerry's Floor Store (jerrl) P- 263596
X630716
905.29
1/9/2012
01/2012 Jerry's Floor Store ( jerrl) P- 263597
X630714
556.26
0.00
3,450.65 vinyl lnst- 104
165
165
1/12/2012
01/2012 Drain King, Inc. (dral7740) P- 265896
82563
135.00
0.00
3,585.65 Plbg Svc - 502
1/13/2012
01/2012 Direct Home Appliance Services (dire P- 264590
011312p m
84.00
0.00
3,669.65 water repair Svc
16S
Page
Iof2
1 Z
3/12/2012 3:18 PM
Parkview Villa -North (165)
General Ledger
Period = Ian 2012
Book = Accrual
.._r
165
1/13/2012
01/2012
_
K.O. Cleaning and Restoration LLC (k P- 264597
_.
2032
225.00
0.00
3,894.65 bath wall repair
165
1/13/2012
01/2012
K.O. Cleaning and Restoration LLC (k P- 264698
2033
50.00
0.00
3,944.65 wall base Inst - 206
165
1/13/2012
01/2012
K.O. Cleaning and Restoration LLC (k P- 264701
2034
125.00
0.00
4,069.65 cab door reface
165
1/16/2012
01/2012
PIGS Professional Bldg Maint Sew Inc P- 264719
10340pvn
65.55
0.00
4,135.20 snow rmvl svc 01/20
165
1/20/2012
01/2012
PIGS Professional Bldg Plaint Sew Inc P- 264717
10347pvn
65.55
0.00
4,200.75 snow rmvl svc 01/20
Net Change = 4,200.75
4,200.75 = Ending Balance =
0.00 = Beginning Balance =
4100 -46330
165
1/13/2012
01/2012
Rents & Leases
CommonBOnd Housing (chc) P- 263124
906310
6.75
0.00
6.75 Talx emply verif 12/11
6.75 = Ending Balance =
Net Change =6.75
0.00 = Beginning Balance =
4315 -46330
1/31/2012
01/2012
PILOT
:PostRecurring Monthly recurring enhl- 128699
RC
1,850.30
0.00
1,850.30 Anoka Cty Property Tax A(
165
Net Change= 1,850.30
1,850.30 = Ending Balance =
4850 -46330
Interest on Deposits
0.00 = Beginning Balance =
165
1/31/2012
01/2012
Sec Drip Interest accrual 1- 129296
G31
1331
0.00
13.31 Sec Dep interest accrual
Net Change =13.31
13.31 = Ending Balance =
5120 -46330
Building &Improvements
0.00 = Beginning Balance =
165
1/16/2012
01/2012
WAI Continuum (walc) P- 264728
11068
587.67
0.00
587.67 archi services to 01/15/12
Net Change = 587.67
567.67 = Ending Balance =
34,962.31
8,545.10
Page
2 of 2
13
5016456
Parkview Villa North
Bank Reconciliation Report
01/31/2012
Balance Per Bank Statement as of 01/31/2012
02/0912011
1199
court325 - Court Administration
02/09/2011
1200
court325 - Court Administration
12122/2011
1545
tOOD4004- Alunovic
01/25/2012
1572
cent - CenterPoint Energy
01/25/2012
1575
gree10D4 - Green Lights Recycling Inc
01/25/2012
1578
mgsp - MGS Professional Bldg Maint Saw Inc
01/25/2012
1580
park/ - Park Supply of America, Inc.
01125/2012
1581
pet1651s - Laura Sheak
01125/2012
1584
zeph - Zephyr Services Inc.
Less: Outstanding Checks
Reconciled Bank Balance
Balance.per GL as of 01/31/2012
Difference
Cleared Items:
Cleared Checks
Date
Tran #
12114/2011
1531
12/22/2011
1541
12/2212011
.1542
12/22/2011
1544
12129/2011 -
1546
12129/2011
1547
12/2912011
1548
12/2912011
1549
12/29/2011
1550
12/29/2011
1551
12129QOI1
1552
12/29/2011
1553
12/2972011
1554
01/0512012
1555
01/05/2012
1556
01/05/2012
1557
Reconciled Balance Per G/L
$230,215.48
55.00
320.00
120.55
5,198.32
76.56
122.48
43.93
237.53
478.45
$6,652.82
$223,562.66
2/16/12
$223,562.66
$223,562.66
0.00
Notes
Amount
Date Cleared
gard1086 -Gardner Plumbing, LLC
135.00
01/31/2012
ligh3326 - Lighting Plastics of MN INC
134.10.
01/31/2012
mgsp - MGS Professional Bldg Maint Sew Inc
122.48
01/31/2012
offi8804 - Office Depot
60.94
01/31/2012
adam - Adam's Pest Control, Inc.
492.94
01/31/2012
cent9115 - Centuryl-ink
38.78
01/31/2012
chc- CommonBond Housing
110.00
01/31/2012
home7 - HD Supply Facilities Maintenance
521.36
01131/2012
keel - K.O. Cleaning and Restoration LLC
300.00
01/31/2012
moc3716 - MCI Comm Service
24.30
01/31/2012
park1 - Park Supply of America, Inc.
145.98
01/31/2012
xcel- Xcel Energy
3,509.24
01131/2012
zeph- Zephyr Services Inc.
7,289 -.00
01131/2012
all - All Inc.
460.50
01131/2012
dire - Direct Home Appliance Services
89.01
01/31/2012
jeml - Jerry's Floor Store
190.52
01/31/2012
Parkview Villa North
Bank Reconciliation Report
01/31/2012
5016456
01/05/2012
1558
offi658- Office of Enterprise Technology
132.42
01/31/2012
01/05/2012
1559
zeph- Zephyr Services Inc.
505.00
01131/2012
01/11/2012
1560
chc - CommonBond Housing
13,161.31
01/31/2012
01/11/2012
1561
waic - WAI Continuum
3,729.24
01/31/2012
01/19/2012
1562
all - All Inc.
1,482.50
01/31/2012
01/19/2012
1563
answ - AnswerLive LLC
3027
01/31/2012
01/19/2012..
1564
bfbp - BFB- Painting, Inc.
1,675.00
01/31/2012
01/19/2012
1565
colu - -City of Columbia Heights
7,217.81
01/31/2012
01/19/2012
1566
comc3474 - Comcast
44.82
01/31/2012
01/19/2012
- 1567
kocl - K.O. Cleaning and Restoration LLC
700.00
01/31/2012
01/1912012
1568
offi8804 -Office Depot
68.37
01/31/2012
01/19/2012
1569
parkl - Park Supply of America, Inc.
666.39
01/31/2012
01/19/2012
1570
sher4110 - Sherwin- Williams Co.
275.10
01/31/2012
01/19/2012
1571
t0003996- Piersak
211.40
01/31/2012
01/25/2012
1573
chc - CommonBond Housing
6.75
01/3112012
01/25/2012
1574
eagll - Eagle Elevator Corp.
688.17
01/31/2012
01/25/2012
1576
home32 - Home Depot Credit Services
110.56
01/31/2012
01/25/2012
1577
jerrl - Jerry's Floor Store
1,461.55
01/31/2012
01/25/2012
1579
multi - Multihousing Credit Control
125.00
01/31/2012
01/25/2012
1582
shea - Laura Sheak
17.76
01/31/2012
01/25/2012
1583
xcel. - Xcel Energy
4,157.22
01/31/2012
Total $50,090.79
Cleared Deposits
Date
Tran #
Notes
Amount
Date Cleared
01/05/2012
367
dep - pvn - 01/05/12
25,692.00
01/31/2012
01/0912012
366
rent deposits
2,885.00
01/31/2012
01/11/2012
368
203.00
01/31/2012
01/11/2012
368
dep
617.00
01/31/2012
01/1312012
369
- op -pvn -01/12
605.00
01/31/2012
Total
$30,002.00
Cleared Other Items
Date
Tran #
Notes
Amount
Date Cleared
01/09/2012
JE 129300
ELoccs OFND Orr Fund receipt
63,336.50
01/31/2012
Total
$63,336.50
2/16/12
1 '�)
Northeast
Ban k Member FDIC
Date 1/31/12 Page 1
77 Broadway St. N.E., Minneapolis, MN 55413
612 - 379 -8811. 24 hour telephone banking 651- 628 -9807 Primary Account Ending 6456
Visit our website at www. northeastbank- nnn.com Enclosures 41
* * * * * * * * * ** * ** *AUTO * *3 -DIGIT 551
670 0.9740 AT 0.374 4 1 11
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 - - --
EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING
DOMESTIC WIRES WILL BE INCREASED TO $20 AND AN EARLY ACCOUNT
CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS
CLOSED IN LESS THAN 3 MONTHS AND HEALTH SAVINGS ACCTS PRIOR
TO 3 YEARS. THE MAXIMUM DAILY LIMIT FOR NSF PAID AND
RETURNED ITEM FEES (CONSUMER ONLY) IS $120.
NORTHEAST PUBLIC FUNDS ACCT
Account Number Ending 6456
Previous Balance 186,967.77
5 Deposits /credits 93,338.50
37 Checks /Debits 50,090.79
Service charge 100
Interest Paid .00
Ending Balance 230,215.48
Number of images 41
statement pates 1/01/12 thru 1/31/12
Days in the Statement Period 31
Average Ledger 231,680
Average collected 230,754
* {r kit it it it {r it kk irkkrtrtkk {rk kitrtrtrt *kirk itk kkir'h it it ir*ki: {rkkk kirkkkki:rt it {: tr *irk *kkit {r itkrtkrtk *kirk *kkk
Deposits and credits
Date
Description
Amount
1/05
DDA REGULAR DEPOSIT
25,692.00
1/09
DDA REGULAR DEPOSIT
2,885.00
1 /11
MISC PAY HUD TREAs 303
63,336.50 CR
1/05
3031036218 01/11/12
134.10
1/04
iD #- 411269646860103
300.00
1/06
TRACE #- 031036210387061
122.48
1 /11
DDA REGULAR DEPOSIT
820.00
1/13
DDA REGULAR DEPOSIT
605.00
rt{ r{ rkkkkkrt{ rkkkkkrtrtrtrtkkkirkk *kkkkkkrtirkkirkkrtrtk * {r k irrtrtrtkkrtkkrtkkkkkk * *irkkkkrt * *ir kirkrtkk
cheeks in serial order
Date
check#
Amount
Date
Check#
Amount
1/09
1531
135.00
1/06
1549
521.36
1/05
1541*
134.10
1/04
1550
300.00
1/06
1542
122.48
1/06
1551
24.30
1/04
1544*
60.94
1/04
1552
145.98
1/04
1546*
492.94
1/03
1553
3,509.24
1/04
1547
38.78
1/05
1554
7,289.00
1/03
1548
110.00
1/09
1555
460.50
* indicates skip in
check numbers
I�
819695 - 623
l �l
i <l
Date 1/31/12 Page 2
Primary Account Ending 6456
Enclosures 41
NORTHEAST
PUBLIC FUNDS ACCT
Ending
6456 (continued)
checks in
serial order
Date
check#
Amount
Date
check#
Amount
1/17
1556
89.01
1/25
1569
666.39
1/10
1557
190.52
1/27
1570
275.10
1 /18
1558
132.42
1/25
1571
211.40
1/13
1559
505.00
1127
1573*
6.75
1/17
1560
13,161.31
1/30
1574
688.17
1/20
1561
3,729.24
1/31
1576*
110.56
1/24
1562
1,482.50
1/30
1577
1,461.55
1/25
1563
30,27
1/30
1579*
125.00
1/25
1564
1,675.00
1/31
1582*
17.76
1/27
1566*
44.82
1/30
1583
4,157.22
1/24
1567
700.00
1/24
4565*
7,217.81
1/30
1568
68.37
* Indicates skip in check
numbers
it ir*Yr Yrrt rtitrtrtrt *ir it *rtYr * *Yr Yr it irrt *rtrtir
irrtrtrt *rt *Y:Y: Yr Yr
it *rtrtrti: *rt*Yr Yr
* * *irrt* *rtrtir
*Yr *rtirrt
irrtrtrt **ir *Yr *rtrt
Daily Balance section
Date
Balance
Date
Balance
Date
Balance
1/01
186,967.77
1 /10
202,009.63
1/24
239,753.84
1/03
183,348.53
1 /11
266,166.13
1/25
237,170.78
1/04
182,309.89
1/13
266,266.13
1/27
236,844.11
1/05
200,578.79
1/17
253,015.81
1/30
230,343.80
1/06
199,910.65
1/18
252,883.39
1/31
230,215.48
1/09
202,200.15
1/20
249,154.15
* * * EN
D O F S
T A T E M E
N T
61
819695 - 624
Payment Summary
Bank= 165opr AND mm /yy= 01/2012- 01/2012 AND All Checks—Yes AND Include Voids =All Checks
[Ito
Check
Post
Total
Bank
Check#
Vendor
Date
Month
Amount
165opr -
Parkview
Villa
North
1496
Bunn -Sun Newspaper
01/27/2012
01/2012
(94.05)
165opr -
Parkview
Villa
North
1555
all - All Inc.
01/05/2012
01/2012
460.50
165opr -
Parkview
Villa
North
1556
dire - Direct Home Appliance Services
01/05/2012
01/2012
89.01
165opr -
Parkview
Villa
North
1557
jerrl - Jerry's Floor Store
01/05/2012
01/2012
190.52
165opr -
Parkview
Villa
North
1558
offi658 - Office of Enterprise Technology
01/05/2012
01/2012
132.42
165opr -
Parkview
Villa
North
1559
zeph - Zephyr Services Inc.
01/05/2012
01/2012
505.00
165opr -
Parkview
Villa
North
1560
chc - Commoneond Housing
01/11/2012
01/2012
13,161.31
165opr -
Parkview
Villa
North
1561
wait - WAI Continuum
01/11/2012
01/2012
3,729.24
165opr -
Parkview
Villa
North
1562
all - All Inc.
01/19/2012
01/2012
1,482.50
165opr -
Parkview
Villa
North
1563
answ - AnswerLive LLC
01/19/2012
01/2012
30.27
165opr -
Parkview
Villa
North
1564
bfbp - BFB Painting, Inc.
01/19/2012
01/2012
1,675.00
165opr -
Parkview
Villa
North
1565
colu - City of Columbia Heights
01/19/2012
01/2012
7,217.81
165opr -
Parkview
Villa
North
1566
comc3474 - Comcast
01/19/2012
01/2012
44.82
165opr -
Parkview
Villa
North
1567
kocl - K.O. Cleaning and Restoration LLC
01/19/2012
01/2012
700.00
165opr -
Parkview
Villa
North
1568
offiB804 - Office Depot
01/19/2012
01/2012
68.37
1650pr -
Parkview
Villa
North
1569
parkl - Park Supply of America, Inc.
01/19/2012
01/2012
666.39
165opr -
Parkview
Villa
North
1570
sher4110 - Sherwin - Williams Co.
01/19/2012
01/2012
275.10
165opr -
Parkview
Villa
North
1571
t0003996 - Piersak
01/19/2012
01/2012
211.40
165opr -
Parkview
Villa
North
1572
cent - CenterPoint Energy
01/25/2012
01/2012
5,198.32
165opr -
Parkview
Villa
North
1573
chc - Common Bond Housing
01/25/2012
01/2012
6.75
165opr -
Parkview
Villa
North
1574
eagil - Eagle Elevator Corp.
01/25/2012
01/2012
688.17
165opr -
Parkview
Villa
North
1575
gree1004 - Green Lights Recycling Inc
01/25/2012
01/2012
76.56
165opr -
Parkview
Villa
North
1576
home32 - Home Depot Credit Services
01/25/2012
01/2012
110.56
165opr -
Parkview
Villa
North
1577
Jeri I - Jerry's Floor Store
01/25/2012
01/2012
1,461.55
165opr -
Parkview
Villa
North
1578
mgsp - MGS Professional Bldg Maint Sery Inc
01/25/2012
01/2012
122.48
165opr -
Parkview
Villa
North
1579
multi - Multihousing Credit Control
01/25/2012
01/2012
125.00
165opr -
Parkview
Villa
North
1580
parkl - Park Supply of America, Inc.
01/25/2012
01/2012
43.93
165opr -
Parkview
Villa
North
1581
pet1651s - Laura Sheak
01/25/2012
01/2012
237.53
165opr -
Parkview
Villa
North
1582
shea - Laura Sheak
01/25/2012
01/2012
17.76
165opr -
Parkview
Villa
North
1583
xcel - Xcel Energy
01/25/2012
01/2012
4,157.22
165opr -
Parkview
Villa
North
1584
zeph Zephyr Services Inc.
01/25/2012
01/2012
478.45
Po
...,.,,.W�.,.n
_.
......
-.,,..
43,269.89
[Ito
Parkview Villa South
Financial Statement Overview
January 2012
Revenue:
Occupancy for the month of January was 96% occupied
Total Revenue was slightly higher than budget amount (favorable)
Administrative Expenses:
Administrative costs for South are under budget (favorable).
Advertising costs were under budget (favorable).
Office Supplies were slightly over budget (unfavorable)
There were no Legal Expenses billed out for January.
Telephone, Answering Service and Internet expenses are under budget (favorable).
Utilities:
Utilities Expenses were under budget (favorable); however, this reflects a quarterly billing
No Utilities were invoiced or paid in January
Operating and Maintenance Expense
Operating and Maintenance Expenses were under budget (favorable).
Exterminating Contract was under budget (favorable)
Garbage and Trash Removal are under budget (favorable); however this is a quarterly billing.
Repairs Material and Contract costs were under budget (favorable).
Elevator Contract is over budget (unfavorable) and reflects the cost of the Elevator upgrade
Snow Removal costs were under budget (favorable)
Heating and Cooling Maint and Repairs was under budget (favorable)
Decorating contract costs were over budget (unfavorable), and reflect cost associated with carpet
installation and wall repairs in turnover units
M
O O O
O O O
S O S
oS8
O O O
ObnN
O O O
O O S
8888
S
S O O O O
Y
N o $ W w W+
w
+ ° 0
o 00,
O OP 00 S
$00000000
6.88 (I 1 NS00
+JOSOJiO nN000
� � &eeSe.Lt ave
k 8n aev av aaeks
m N wpp
OJJm(WJdN�ONfA IAN
W O (Jli W S N Y W O W N O
imp �JA O�Oyq�iiJ tOO (AAWN
AOJJWWUNiJWO(Wi14Ni0
AD6'(Ii00A ,fA00S
W S+ J O S UJi S A N S S O
N UNi N J
Oi P p� IA u W o m W J
WViOA NA ONO ONO
`4'OO °OO °0n °o °o °oa °o °o °o
el �IG.
P, I V, I N
yp H
O O O O S S O O O
N
N
p 0
-i
ti 3
-1
m
A A
ry W N
(ON
��� NJONS
OIWW
W
W
°a0
F 3. C
o
N W N
6 ?.
a i
r
S
A
6i
A z
ii $ �p
NAN
N
S O lNli O
O
O
A N
-cbobo
00000
g
$$
°o
c m
�2'
NG$
y
O
gmu
o J,`�'oo�o�w000
W:
oLm
°
$oS$o
o$�..S$o.o...
'o,
$$008
g
°$
d
Vim'
v
n
W
ry
m
m
u
S
N
0 0
J J m (J W+ O N w W N
INO:
W O (li
I,PD
N
W
�.
O O S O O
JOa
A
yW
O O lJl� W W N J W O W U O
;W�
N
JON O
W
W W
1
00000
JOW�WyW 0 -� +WHO ()iWN
JmWW.
OOm
OOSOO
1Np
NOJJW
W(IiJWOW(NI�
Nii
NWONS
qO
A
F
n�n
0
O O O
O O O
S O S
oS8
O O O
ObnN
O O O
O O S
8888
S
S O O O O
Y
N o $ W w W+
w
+ ° 0
o 00,
O OP 00 S
$00000000
6.88 (I 1 NS00
+JOSOJiO nN000
� � &eeSe.Lt ave
k 8n aev av aaeks
m N wpp
OJJm(WJdN�ONfA IAN
W O (Jli W S N Y W O W N O
imp �JA O�Oyq�iiJ tOO (AAWN
AOJJWWUNiJWO(Wi14Ni0
AD6'(Ii00A ,fA00S
W S+ J O S UJi S A N S S O
N UNi N J
Oi P p� IA u W o m W J
WViOA NA ONO ONO
`4'OO °OO °0n °o °o °oa °o °o °o
el �IG.
P, I V, I N
yp H
O O O O S S O O O
mm
N
N
N
�
m
m
m
O
OIOSN !D
(ON
��� NJONS
OIWW
W
W
iJ�
N W N
A
W N
�. N
WO
IWJ S tJn S A
OOH
P
J J
mm
88
a
o
>o
+DO °o
m
WAu
�
W
W
i
N
A
O
to •u
rAp
NAN
N
S O lNli O
O
O
A N
-cbobo
00000
g
$$
°o
m
Z J
q 6 qy y o
a b ti o c o y ii g o
$ a m -� 6 v a w o 6 A o o N N u) n v v x v
30 0.
°@ --a.e Ae 6�Ny`gm�Sm''=
Wq� 9 y % ] Ny •C 8 ?'bb�0 sld �OCjWA C. IiN�
O c t - m° o d ry Q
8A'°y Aa o
� po
O S
W
J W
N
(W�
J W
S O
O S
0
o °o
N
J W
N
m
p
O
n
D
e u
N �
J O
� O
� N O
A A pN�
N W S OI
N IAII A P O
W W J Y O
O O A O N
VI� OOb
+ + d O
W W J Y O
0 m N J m
N pA S in
IOC O Iy/W� � N
O O O O O
S O O O O
A
J
y
N
OJOOOOPO4)OOSOIOWOOS dE
N
.Vy{
+ O
mp�
+J WNJO V��OOWW W
J0000000(JJONIJIiJOJ
OIWJ
PNONWOJSNPPO
OO�OA°O1i J(WJ
N
()(11
m 0 0 0 WJ N O N W OJ J O Y
p °I J IYIi 0
IDN VI S 00 ....SSS
Z A Z 0 p�
IYIID S O SSWDNOOVID...O SSS
A +
O UNi W O N U� O+ O O O A N O O O
b' +m' +0000
N W O O O O A O 0 .........
I�.�J WNOP rVI A(li ..�+ pl
O N O O O S W O O S A O A J W
SOOOS(Wi14 JONUJi�OJOW
W (NIi pOWp�� VWNO OWOAN J(Wil J
S S P Z W O S O Z O O W OW1 O O O �
S °o mD� °o omDS °o lom000
W +ION +NWNN WO�OIN ......... N N INJ O O N O
O O O O O O O O N N p O O O O
S ........ S S S O O d
3 <
o O
_N3 °
V
y
V
N
z "zzzz z
`D 'n Dnn'D'D n
o + N
pow �mos°o
O O O O P.-PO
�O �O
O
O O O O
9
P
c
ra o p
n
o
D
o m W w
O v
9
a D
o O
(N� -1
q
a s
D
Dn(Dio
Or.
a
u
2�v.
=m.�:.a8a
m
0
l�1I'
a58
;'o
R
m
2
g
~
c.
ti
SN �i g
.c
d
�
A
m
I°ANNN
J J
+�DW
NO 00
00
AA
.P -'.
m'.
I�WW
AOp
O
W-
O
O
NN
g
JJ
J�000
(NON
00
A
OOP
,Np:
p
E
W
W!
W
m
N O
W
�
!O W
O
O O O
O
O O O O
O
Wo
p
O
O O O
O
O O O O
p
O
O0
p:
O
bob
O
O
J
+<p
NN
W
(Nil
F'.
01
P
O.66
Op
AA
OVNiNO
JNOOO
JVOOO
00
-A',
oNm
;
O
O
Jm
z "zzzz z
`D 'n Dnn'D'D n
o + N
pow �mos°o
O O O O P.-PO
�O �O
O
O O O O
a`Dan'D
a
ZD
R z
D
6N w
°o °o °o
Pi- 0
O O O
O
z
a n
000 0
g °OO °o
AI+
m:
O N'
J W..
a
°0
G
C
N(
V
a
W V V
zzzz
zzzzz
a`Dan'D
a
D
+ m
0000
00000
R z
D
6N w
°o °o °o
Pi- 0
O O O
O
z
a n
000 0
g °OO °o
AI+
m:
O N'
J W..
a
°0
G
C
N(
V
a
W V V
y
m o
m va7 v
CD `<
F
gnc
A
n
e
N 3
O
�
O
A
�
c_
7
n
N �
N o
9 N
Z�
Parkview Villa South (166)
Balance Sheet January 2012
Books = Accrual
Jan -12
Assets
10100
Cash Balance
152,937.73
841.25
10200
Petty Cash
93.00
13,775.53
10400
Investments
575,970.36
33,624.35
11300
Rent Receivable
6.00
695,385.74
11500
Accounts Receivable
3.00
729,010.09
Total
Assets
729,010.09
Liabilities
20200 Accounts Payable
8,551.27
20210 Accrued Other Expenses
841.25
22000 Deposits
9,267.59
22200 Accrued PILOT
13,775.53
22210 Revenue Collected in Advance
1,188.71
Total Liabilities
33,624.35
Fund Balance
25300 Fund Balance
695,385.74
Total Fund Balance
695,385.74
Total Liabilities and Fund Balance
729,010.09
24
Parkview Villa -South (166)
Income Statement
For The Period Ending January 2012
Books = Accrual
Month to Date % Year to Date
Revenue
36220 -46340 Gen. Government Rents 25,936.00 96.84% 25,936.00 96.84%
36225 -46340 Nondwelling Rents 544.00 2.03% 544.00 2.03%
36290 -46340 Other Miscellaneous Revenue 303.00 1.13% 303.00 1.13%
39120 -46340 Recovery Damage City - 0.00% -0.00 0.00%
Total Revenue 26,783.00 100.000/0 100.000/0
Expenses
Personal Services
1000 -46340 Accrued Salaries 3,723.00 13.90% 3,723.00 13.90%
Total Personal Services 3,723.00 13.90% 3,723.00 13.90%
Supplies
2000 -46340 Office Supplies
47.25
0.18%
47.25
0.18%
2010 -46340 Minor Equipment
0.00
0.00%
0.00
0.00%
2160 -46340 Maint. & Construct Materials
0.00
0.00%
0.00
0.00%
2171 -46340 General Supplies
65.93
0.25%
65.93
0.25%
113.18
0.42%
113.18
0.42%
Total Supplies
Other Services & Charges
0.00
0.00%
0.00
0.00%
3040 -46340 Legal Fees
3050 -46340 Expert & Professional Services
0.00
0.00%
0.00
0.00%
3060 -46340 Management Services
2,025.00
7.56%
2,025.00
7.56%
3100 -46340 Protective Services
0.00
0.00%
0.00
0.00%
3210 -46340 Telephone & Telegraph
58.78
0.22%
58.78
0.22%
3430 -46340 Advertising Other
0.00
0.00%
0.00
0.00%
3600 -46340 Insurance & Bonds
841.25
3.14%
841.25
3.14%
3810 -46340 Electric
0.00
0.00%
0.00
0.00%
0.00
0.00%
0.00
0.00%
3820 -46340 Water
0.00
0.00%
0.00
0.00%
3830 -46340 Gas
34.39
0.13%
34.39
0.13%
3840 -46340 Refuse
0.00
0.00%
0.00
0.00%
3850 -46340 Sewer
4000 -46340 Repair & Maint. Services
3,994.12
14.91%
3,994.12
14.91%
4100 -46340 Rents & Leases
0.00
0.000/0
0.00
0.00%
4300 -46340 Miscellaneous Charges
25.58
0.00%
25.58
0.10%
1,059.66
3.96%
1,059.66
3.96%
4315 -46340 PILOT
4390 -46340 Taxes & Licenses
0.00
0.00%
0.00
0.00%
4500 -46340 Administrative Expenses
0.00
0.00%
0.00
0.00%
4850 -46340 Interest on Deposits
7.47
0.03%
7.47
0.03%
Total Other Services & Charges
8,046.25
30.04°70
8,046.25
30.04°70
25
Capital Outlay
5120 -46340 Building & Improvements
Total Capital Outlay
Total Expense
Excess (Deficit) Revenue over Expense
0.00%
0.00%
0.00 0.000/0 0.00 0.000/0
11,882.43 44.37% 11,882.43 44.37%
14,900.57 55.63% 14,900.57 55.63%
�
u
Parkview, Villa South (166)
Cash Flow Statement
Period = January 2012
Month to Date
Revenue
36220 Gen. Government Rents 25,936.00
36225 Nondwelling Rents 544.00
36290 Other Miscellaneous Revenue 303.00
39120 Recovery Damage City Property 0.00
Total Revenue 26,783.00
Personnel Services
1000 Accrued Salaries 3,723.00
Total Personnel Services 3,723.00
Supplies
2000 Office Supplies 47.25
2010 Minor Equipment 0.00
2160 Maint. & Construct Materials 0.00
2171 General Supplies 65.93
Total Supplies 113.18
Other Services & Charges
3050 Expert & Professional Services
0.00
3060 Management Services
2,025.00
3100 Protective Services
0.00
3210 Telephone & Telegraph
58.78
3430 Advertising Other
0.00
3600 Insurance & Bonds
841.25
3810 Electric
0.00
3820 Water
0.00
3830 Gas
0.00
3840 Refuse
34.39
3850 Sewer
3,994.12
4000 Repair & Maint. Services
0.00
4100 Rent & Leases
0.00
4300 Miscellaneous Charges
25.58
4315 PILOT
1,059.66
4390 Taxes & Licenses
0.00
4500 Administrative Expenses
0.00
4850 Interest on Deposits
7.47
Total Other Services & Charges
8,046.25
Total Expenses 11,882.43
Excess (Deficit) Revenue over Expenses 14,900.57
21
Parkview Villa South (166)
Cash Flow Statement
Period = January 2012
Adjustments
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
(3.00)
(3.00)
0.00
(5,442.30)
841.25
(435.77)
1,059.66
123.00
(3,860.16)
11,040.41
Beg Cash End Cash Difference
141,897.32 152,937.73 11,040.41
93.00 93.00 -
575,970.36 575,970.36 -
717,960.68 729,001.09 11,040.41
ral
3/12/2012 3:26 PM
Page 1 of 1 v
Parkview Villa South (166)
0.00 = Beginning Balance =
3600 -46340
General Ledger
Insurance & Bonds
BM11.25
0.00
841.25 C of Columbia Heights Ins A.
166
1/31/2012
01/2012
Period = Jan 2012
RC
841.25 = Ending Balance =
Net Chang.= 841.25
Book Accrual
- -
Control
Reference
Debit
. Credit
Balance Remarks
property:
Date
Period
Person /Description
0.00
166
1/5/2012
0.00 = Beginning Balance =
1000-46340
12- 1039pvs
Accrued Salaries
34.39 =p Elnding'Balance =
3,]23.00
0.00
3,723.00 R/C CNC PR Mgmt Fee
166
1/31/2012
01/2012
:postRecurring Recurring
J- 12II]00
RC
3,723.00 = Ending Balance =
0.00 = Beginning Balance =
Net Change= 3,723.00
Repair & Maint. Services
P- 263604
112124 -s
309.18
0.00
309.18 prow maim 01/12
166
1/1/2012
01/2012
Eagle Elevator Corp.(eag11)
0.00 = Beginning Balance =
2000 -46340
1/6/2012
Office Supplies
MGS Professional Bldg Meet Sew Inc R P-263609
23.64
0.00
postage
166
166
1/4/2012
01/2012
Laura Shenk(pet1661s)
P- 263616
pc010412pv5
0.00
47. 5 paper, envelopes etc.
166
1/11/2012
01/2012
Office Depot(offi8804)
P- 264778
593407841001
23.61
7.225
47.25 = Ending Balance =
166
Gardner Plumbing, LLC (gard1086) P- 264759
2387
Net change =47.25
0.00
1,872.67 snow Fool secs 1/14
166
1/16/2012
01/2012
MGS Professional Bldg Malnt Sew Inc (r P- 264774
29.45
0.00
3,464.67 slew upgrade 1/11
166
166
1/20/2012
01/2012
0.00 = Beginning Balance =
2171 -46340
1,592.00
0.00
General Supplies
1/20/2012
14.99
0.00
14.99 bolts, brace etc.
29.45
1/4/2012
01/2012
Laura Sneak (et1661s)
p
P- 263616
pc010912pvs
K.O. Cleaning and Restoration LLC (kocl P- 265908
0.00
spindle, etc.
166
1/11/2012
01/2012
HD Supply Facilities Maintenance
(home P- 2647]1
9112869112865012w,
50'94
300.00
65.93 =Ending Balance
166
Net Chang-=65.93
Net Change= 31994.12
0.00 = Beginning Balance =
0.00 = Beginning Balance =
3060 -46340
Miscellaneous Charges
P- 263616
pc010412pvs
Management Services
0.00
25.58 keys
5,748.00
0.00
5,748.00 mgmt fees
166
1/31/2012
01/2012
CommonBond Housing (chc)
P- 265229
911661
3,723.00
PR Mgmt Fee
2,025.00 R=C Mgm
166
1/3112012
01/2012
:POStRecurting Recurring
1- 128700
RC
0.00
din
2,025.00 = Ending Balance =
0.00 = Beginning Balance =
Net Change = 2,025.00
PILOT
1,059.66
0.00
1,059.66 Anoka Cty Property Tax Aco
166
1/31/2012
01/2012
:PostRecurring Recurring ]- 128700
RC
0.00 = Beginning Balance =
3210 -46340
Telephone & Telegraph
1348
0.00
13.48 aternetc 01/12
1/1/2012
01/2012
AnswerLive LLC(answ)
P- 262016
111204620101
0.00 = Beginning Balance =
0.00
33.61 Internet sec 1/11 -2/10
166
1/2/2012
01/2012
Comcast (comc3474)
P- 262539
8]3710505019
20.13
01/2012
51.09 phone Svc 01/12
166
1/7/2012
01/2012
Centuryt-ink (cent9115)
P- 264756
763]883978/1
17.68
0.00
Ol /10
Svc
166
1/11/2012
01/2012
MCI Comm Service (mcic3718)
P- 2697]6
]637883978/1.
7.69
0.00
phone
58.78 = Ending Balance
166
Net change =58.78
Page 1 of 1 v
0.00 = Beginning Balance =
3600 -46340
Insurance & Bonds
BM11.25
0.00
841.25 C of Columbia Heights Ins A.
166
1/31/2012
01/2012
:PostRecurring Recurring ]- 128700
RC
841.25 = Ending Balance =
Net Chang.= 841.25
0.00 = Beginning Balance =
3840 -46340
Garbage & Trash Removal
34.39
0.00
166
1/5/2012
01/2012
Green Lights Recycling Inc (gree1004) P- 263606
12- 1039pvs
34.39 =p Elnding'Balance =
Net Change =34.39
0.00 = Beginning Balance =
4000 -46340
Repair & Maint. Services
P- 263604
112124 -s
309.18
0.00
309.18 prow maim 01/12
166
1/1/2012
01/2012
Eagle Elevator Corp.(eag11)
1/6/2012
01/2012
MGS Professional Bldg Meet Sew Inc R P-263609
0.00
1,622.81 Inst cap - 22101
166
166
1/9/2012
01/2012
Jerry's Floor Store (Jerrl) 63605
X6307p15s
1,258.60
t
166
1/12/2012
01/2012
LID Supply Facilities Maintenance (home P- 264772
9112902652pv
0.00
1,843 22 slower dram leak - 315
1/12/2012
0112012
Gardner Plumbing, LLC (gard1086) P- 264759
2387
201.50
0.00
1,872.67 snow Fool secs 1/14
166
1/16/2012
01/2012
MGS Professional Bldg Malnt Sew Inc (r P- 264774
29.45
0.00
3,464.67 slew upgrade 1/11
166
166
1/20/2012
01/2012
Eagle Elevator Corp.(eagll) P- 265903
112357 -[
112357 -1
1,592.00
0.00
3,494,12 snow svrs 1/20
1/20/2012
01/2012
MGS Professional Bldg paint Sew Inc (r P- 264775
10347pvs
29.45
0.00
3,694.12 repairrwtrl dam/paint - 215
166
166
1/23/2012
01/2012
K.O. Cleaning and Restoration LLC (kocl P- 265908
2039
200.00
0.00
/Balance
166
1/30/2012
01/2012
K.O. Cleaning and Restoration LLC (Red P- 265906
2042
300.00
=0
3 994.12 =aEnding
Net Change= 31994.12
0.00 = Beginning Balance =
4300 -46340
Miscellaneous Charges
P- 263616
pc010412pvs
25.58
0.00
25.58 keys
166
114/2012
01/2012
Laura Shook (pet1661s)
25.56 = Entling Balance =
Net Change =25.58
0.00 = Beginning Balance =
4315 -46340
PILOT
1,059.66
0.00
1,059.66 Anoka Cty Property Tax Aco
166
1/31/2012
01/2012
:PostRecurring Recurring ]- 128700
RC
1,059.66 = Ending Balance =
Net Change= 1,059.66
0.00 = Beginning Balance =
4850 -46340
Interest on Deposits
] 47
0. 00
7.47 Sec Dep Interest accrual
166
1/31/2012
01/2012
Sec Dep interest accrual 3- 129312
GIL
7,47 = Ending Balance =
Net Change =7.47
15,605.43
3,723.00
Page 1 of 1 v
5016464
Parkview Villa South
Bank Reconciliation Report
01/31/2012
Balance Per Bank Statement as of 01/31/2012
02/11/2009
389
mcic - MCI Comm Service
01/19/2012
1293
comc3474 - Comcast
01/19/2012
1296
10003793 - Johnson
01/25/2012
1297
cent - CenterPoint Energy
01/25/2012
1299
gree1004 - Green Lights Recycling Inc
01/25/2012
1301
mgsp - MGS Professional Bldg Maint Sery Inc
01/25/2012
1304
pet166Is - Laura Sheak
Less: Outstanding Checks
Reconciled Bank Balance
$155,511.09
5.47
20.13
199.06
2,195.07
34.39
55.03
64.21
$2,573.36
Balance per GL as of 01/31/2012 $152,937.73
2/10/12
$152,937.73
Reconciled Balance Per G/L $152,937.73
—j-51J 2111�)
Difference 0.00
Cleared Items:
Cleared Checks
Date
Tran ft
Notes
Amount
Date Cleared
'
11/30/2011
1250
cent9115 - Centuryl-ink
17.43
01131/2012
12/2212011
1276
mgsp - MGS Professional Bldg Maint Sery Inc
55.03
01/31/2012
12/22/2011
1278
offi8804 - Office Depot
27.38
01/31/2012
12122/2011
1279
t0003808- Jankowski
107.18
01/31/2012
12/29/2011
1280
adam - Adam's Pest Control, Inc.
44.00
01/31/2012
12/29/2011
1282
chc - CommonBond Housing
18.33
01/31/2012
12/29/2011
1283
home7 - HD Supply Facilities Maintenance
19.31
01/31/2012
12/29/2011
1284
Ibpm - LBP Mechanical, Inc
2,552.25
01131/2012
12/29/2011
1285
mcic3718 - MCI Comm Service
10.92
01/31/2012
12/29/2011
1286
xcel - Xcel Energy
1,386.84
01/31/2012
01/05/2012
1267
dire - Direct Home Appliance Services
39.99
01/31/2012
01/0512012
,1288
off1658 - Qffice of Enterprise Technology
59.50
01/31/2012
01/11/2012
1289
chc - CommonBond Housing
5,951.53
01131/2012
01/1912012
1290
answ - AnswerLive LLC
13.48
01131/2012
01119/2012
1291
bfbp - BFB Painting, Inc.
375.00
01131/2012
01/19/2012
1292
coin - City of Columbia Heights
3,306.41
01/31/2012
01/19/2012
1294
offi8804 -Office Depot
30.72
01/31/2012
01/19/2012
1295
t0003785 - Fransen
244.18
01131/2012
n
5016464
01125/2012
1298
01/2512012
1300
01/25/2012
1303
01/2512012
1305
Total
1,258.60
Cleared Deposits
Date
Tran #
01/05/2012
283
01/09/2012
284
01/1312012
285
Total
Parkview Villa South
Amount
Bank Reconciliation Report
dep - pvs - 01/05112
01/31/2012
0113112012
eagll - Eagle Elevator Corp.
309.18
jerr1 - Jerry's Floor Store
1,258.60
multi - Multihousing Credit Control
60.00
xcel - Xcel Energy
1,643.11
$17,530.37
01/31/2012
01/31/2012
01/31/2012
01/31/2012
Notes
Amount
Date Cleared
dep - pvs - 01/05112
24,482.00
0113112012
rent deposits
2,402.00
01/31/2012
op- pvs -01/12
16.00
01/31/2012
$26,900.00
2/10/12
1�21
Northeast
RLIV �
L a/ Member FDIC
77 Broadway St. N.E., Minneapolis, MN 55413 Date 1/31/12 Page -
612- 379 -8811 • 24 hour telephone banking 651- 628 -9807 Primary Account Ending 6464 4
Visit our website at www. northeastbank- mn.com Enclosures 25
** * * * * * * * * * * ** *AUTO * *3 -DIGIT 551
671 0.8140 AT 0.374 4 1 12
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 - - --
EFFECTIVE MARCH 1, 2012 WIRE TRANSFER FEES FOR OUTGOING
DOMESTIC WIRES WILL BE INCREASED TO $20 AND AN EARLY ACCOUNT
CLOSING FEE OF $20 WILL BE CHARGED FOR DDA AND SAVINGS ACCTS
CLOSED IN LESS THAN 3 MONTHS AND HEALTH SAVINGS ACCTS PRIOR
TO 3 YEARS, THE MAXIMUM DAILY LIMIT FOR NSF PAID AND
RETURNED ITEM FEES (CONSUMER ONLY) IS $120.
NORTHEAST PUBLIC FUNDS ACCT
Account Number Ending 6464
Previous Balance 146,141.46
3 Deposits /Credits 26,900.00
22 checks /Debits 17,530.37
Service charge .00
interest Paid .00
Ending Balance 155,511.09
Number of Images 25
statement Dates 1/01/12 thru 1/31/12
Days in the statement Period 31
Average 'Ledger 161,272
Average collected 160,424
wwi:w': it it trwwwir irwwwwwwir* wkww, Y irw*wwwwiriri: it ir. * *wrtirw w{rwWwwrtrtwwir irwwwirwwwrt '.rw {rw wi:wwwirwwww
Deposits
and credits
Amount
Date
Description
Amount
1/05
DDA REGULAR DEPOSIT
24,482.00
1/09
-DDA REGULAR DEPOSIT
2,402.00
1/13
DDA REGULAR DEPOSIT
16.00
rtwi:wwwrtirww w{r irw wirirwrtwww {rrt it *wwwwirwwwwir{r {rw irirwrtrtwwwwrtwwwirrtwwwwwrtwwww {rrtwwwwirwwwwwww
checks in serial order
Date
check#
Amount
Date
check#
Amount
1/06
1276
55.03
1/12
1288
59.50
1 /10
1278*
27.38
1/17
1289
5,951.53
1/12
1279
107.18
1/25
1290
13.48
1/04
1280
44.00
1/25
1291
375.00
1/03
1281
17.43
1/24
1292
3,306.41
1/03
1282
18.33
1/27
1294*
30.72
1/06
1283
19.31
1/24
1295
244.18
1/04
1284
2,552.25
1/31
1298*
309.18
1/06
1285
10.92
1/30
1300*
1,258.60
1/03
1286
1,386.84
1/30
1303*
60.00
1/17
1287
39.99
1/30
1305*
1,643.11
* Indicates skip in
check numbers
3Z
819696 - 627
LM
Date 1/31/12 Page 2
Primary Account Ending 6464
Enclosures 25
NORTHEAST PUBLIC FUNDS
ACCT Ending
6464 (Continued)
rtkkk *kir it itk krti: it it i:rt * *kkkkirrtkrtkkkkkir it irk it itk'.:k
kir irk rtirkrtkrtkkkkrtkrtkir
iskkkkkit
irk irkkkkrtrtirk
Daily
Balance Section
Date
Balance
Date
Balance
Date
Balance
1/01
146,141.46
1/09
168,921.35
1/24
159,201.18
1/03
144,718.86
1 /10
168,893.97
1/25
158,812.70
1/04
142,122.61
1/12
168,727.29
1/27
158,781.98
1/05
166,604.61
1/13
168,743.29
1/30
155,820.27
1/06
166,519.35
1117
162,751.77
1/31
155,511.09
* * *
E N D O F S
T A T E M E N T
* **
819696.- 628
Payment Summary
13ank= 166opr AND mm /yy= 01/2012- 01/2012 AND All Checks =Yes AND Include Voids =All Checks
/54
Check
Post
Total
Bank
Check#
Vendor
Date
Month
Amount
166opr -
Parkview
Villa
South
1287
dire Direct Home Appliance Services
01/05/2012
01/2012
39.99
166opr -
Parkview
Villa
South
1288
offi658 - Office of Enterprise Technology
01/05/2012
01/2012
59.50
166opr -
Parkview
Villa
South
1289
chc - Common8ond Housing
01/11/2012
01/2012
5,951.53
166opr -
Parkview
Villa
South
1290
answ - AnswerLive LLC
01/19/2012
01/2012
13.48
166opr -
Parkview
Villa
South
1291
bfbp - BFB Painting, Inc.
01/19/2012
01/2012
375.00
166opr -
Parkview
Villa
South
1292
colu - City of Columbia Heights
01/19/2012
01/2012
3,306.41
166opi -
Parkview
Villa
South
1293
comc3474 - Comcast
01/19/2012
01/2012
20.13
166opr -
Parkview
Villa
South
1294
off18B04 - Office Depot
01/19/2012
01/2012
30.72
166opr -
Parkview
Villa
South
1295
t0003785 - Fransen
01/19/2012
01/2012
244.18
166opr -
Parkview
Villa
South
1296
t0003793 - Johnson
01/19/2012
01/2012
199.06
166opr -
Parkview
Villa
South
1297
cent - CenterPoint Energy
01/25/2012
01/2012
2,195.07
166opr -
Parkview
Villa
South
1298
eag11 - Eagle Elevator Corp.
01/25/2012
01/2012
309.18
166opr -
Parkview
Villa
South
1299
gree1004 - Green Lights Recycling Inc
01/25/2012
01/2012
34.39
166opr -
Parkview
Villa
South
1300
jerrl - Jerry's Floor Store
01/25/2012
01/2012
1,258.60
166opr -
Parkview
Villa
South
1301
mgsp - MGS Professional Bldg Maint Sery Inc
01/25/2012
01/2012
55.03
166opr -
Parkview
Villa
South
1302
mhfa - Minnesota Housing Finance Agency
01/25/2012
01/2012
150.00
166opr -
Parkview
Villa
South
1302
mhfa - Minnesota Housing Finance Agency
01/27/2012
01/2012
(150.00)
166opr -
Parkview
Villa
South
1303
multl - Multihousing Credit Control
01/25/2012
01/2012
60.00
166opr -
Parkview
Villa
South
1304
pet1661s - Laura Sheak
01/25/2012
01/2012
64.21
166opr-
Parkview
Villa
South
1305
xcel- Xcel Energy
01/25/2012
01/2012
1,643.11
15,859.59
/54
Parkview Villa Apartments
965 40`x' 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 March 2012
Prepared by Jennifer Eells, Property Manager
Police Report
1— Domestic family, 1— Tenant dispute
Wait List
33 applicants for Parkview Villa North (resident of C.H., elderly, handicapped)
00 applicant for Parkview Villa North (employed in C.H.)
31 applicants for Parkview Villa North (non- resident, elderly, handicapped) (updated)
16 applicants for Parkview Villa North (no preference)
00 applicants for Parkview Villa South (resident C.H.)
02 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 101 out of 101 (100% occupancy) (caretaker unit included in total number of
units)
South is 42 out of 45 (93 % occupancy)
Move Outs
#502
3/31/12
#610
3/31/12
#216
3/31/12
#425
3/31/12
Move INS
Maintenance Report (See attached)
ParkVieW Villa
Apartments
Newsletter
Q ice nJ'o
Phone
763- 706 -3800
Hours
8 a.m. -4:30 p.m.
After Hour
Maintenance:
PV North
866 - 962 -8896
PV South
Managed by CommonBond Owned by the City of Columbia Heights
Communities
•�� • 11 s
By Carol GOOdrow
The lion and the Iamb may
never run together. Dad
blames it on their nature.
Mom says it's just the
weather. For when the
month of March comes
out, we hear the little chil-
dren shout. "We're wet
with snow. We're stuck
with sleet. The wind is
whipping at our feet. We
cannot run too fast today.
The Lion must be in our
way."
The Lion and the Iamb
may never run together.
Dad blames it on their
nature. Mom says it'sjust
the weather. But when we
hear the season of spring,
we hear the little children
sing. "We're sprinkled with
rain. We're warm with sun.
A gentle breeze has just
begun. We jump and
sprint and run and play.
The twin Iambs might be
born today. "
0®!
N N to U� 111 VI A P W N N N N N lD l0 W W V V 01 A W W N W om
w w w w w w w w N w w w w w w w w w w w w w w N w w N Qa w
�' • �
G G<<<<< N Z Z Z �^ Z Z �^ (A Z(n N 0 Z Z Z
Z Z Z Z Z Z Z °y
c
t0 l0 N w A un N N A m Ln N W A 00 W V U.
O O O O O O F-` N N O O O O N H I-` O iP
01 w w A N N l0 W V 00 N A 01 Ul F' O w
z (o c m c a i a °' ?• v v d m m vc,, c m d v= 3 v M > >> n a O a g m o is ° w c 3 CL CL
O N 1 l O w p
V
7C 7C N W 2 Q N A 7C o 2 z 05 m -1 -i 0 In v r N m� 7, n -1 •D G
s c s �. m m M �+ m rD .. =n M s c v _
7 O O O w '� O O�0 '-r w m O O 'O .•r O M, -� :n 7 w >> `� W 'O
O 1 '< � O � N a' w 3'
N _ O O Cr a• 'O O n �n. O — � v' G j O O :+ 3 N
on rr .'
D- v 3- w m° w °° °. w e m°n ov' m �o °. a c °w o
c o �c • '< o O - n m a 9
> > C
O� < D_ < x d 0Cj C N d4 C OU O N A O CL o
m m y D- M s f+ �, c o D
CL Z ', v m rD �, .°'. Ov, a• `� a°'o -wo c w o. O ro o• � o- <
° Z -woo o o oa < o c m n w M o o„ a o ° o m Lq
as r 3 x m' '•' 3• m o' m c a o_ m 3 o1 °o �
3
M M. -mow o ! a uc°." c m m °- w 3 n '?. v °�' M o.
T. D H a- m o_ w a• m w m o_ c y 0O M �. a
0n G O N w 3 C = a• N c " S O_ �' 0_ _ O pCj c N
CL
w N
OCU j N O< a p ,w.° O D' c W d (U fl' 7' C Ott CL D
m s 1 o m 0 z cC. o_ ° �° o ua a 3 3<
m a. a d a d 0 GAl
M ,�, w w' o M o n M s o m a E
M _ o_ a CL o o o_ M D, CL a
n a s m w 3 as a 3
CL
m o ° ° 0 3 ?° awo M P
d o
CL G)
N 6 N
e -' O-
i -p O M
_. d N
� s w
rF
N 0 G
O
O O C
0
0 O
0 3
• D
v
n
m
n
w w w w w w w w w w w w w w w w w O
\ \ \ \ \ \ \ \ \ \ \ \ \ \ w w w w w w w w w w w w \ \ \
M M Un M i� M 0 A W N N N W F�-� l\O W 0\0 W V V O\1 A W V N N 00 V l!� •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 N N N N
O O O O O O O O O O O O O O O O O O O O O O O O O O O O O M 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 N N N N N
�i
w
n
T
N
N
d
1
ASV
O1
d
a
a
n
f:0 D
13
0
�1
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 N N N N N
00 00 Q1 dl Dl Ol O1 Ol N A W W N Oo 00 01
d DI N N Dl d N DI N Dl D/ 411 d O1 Dl D! d N D) D! 01 d N D) N D! N D! d N
z < < z
Z Z Z Z Z Z N Z N Z Z Z N N Z N W Z Z W W Z N Z Z N N N
lD A A V V W V1 N W V1 a) A M N A M W A -P 01 A W lD A N N
O O Ln O N v N N O 0 A V J A O O m In m W lD -I lD O N N
r T 3 2= 2 fTl N = d N
HFD'
S = fD CR °..c d `t 0- 3 G1 r�D Dni w m 'J^ T J• J•
o o N
ov DD
o o � o p —j ;;: d N d O O. `0 v '(D (D c ,00 O, O O � O-• d 3 v O.
D
� o a J 00 O m o o o ° o �o c Q
•
'D O. (D 3' M N O (D 0 CL (D o O S O 7 7 S (m p Q O! J o o K �' ((Di
C Ol C 0oQ d a J cr Oi to N (D a O J 7 !� ((DD N J 'a 'O O cr `* ~
j 'O i O a .� _ A 6 N O d = ri -i C Vi N p� o
a vN, m 3 0. 3 0: °° '-c M ° m rt a v J n oo aJ O ,< °" J °°• m °_ 'c w
•CO J (<D ((DD N O CL p FA 1 � � "" n F < (D � 3 �• 7' �' Q 'O. N m n
J' ID a o S\ d N CL "" 1 N Vi n O J a O O
p Q. o " O J "O O, o N N S .(: Q S j d O 3 -�i D(D n .Ci d
Z. w 0. N N �. IDS• ,w C C (D O n! pq O N o O (-Di � a W rD C d O O
7c (D fD M d vi s ((DD 3 A (D 3 N > 0 (D O d .�•e w Dpi d N
ti4 C' (D d O D (D a
N O Q O N a N Q N
D D(. 'O 3 O C F d O
DD n ° = n d i (D N 'OO N a J Dl N (� J
(D CL N d (D
Q
w J V� 'O Dp :* J (D 1 w O O �� a on p4 0 n S \ o n rh * W. .O
J p c (D O J
o Vf (D 1n (D = K O O n CL 6: 0 n 0"
o
(D a' m C C .+ (D
O < Ian m a• < S Dl G 'O J 0!
� N N d (D
fD (D (D D l J J J O' O
m n. a
I y, _ Q p: a
w N (D N C _ N
5 ID -� 0 N fD (D 6
(D ti C. W-o, N
S O
* O D
D N C O 2
0 Q0
J N ? O
J n (Dn a
O i
O
J OJ w D
'
d
� N
O
a
T.
0
0
J
m
W W W W W W W W W W W W W W W W W W W W W W W W W W W W W W
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \
00 00 Q7 T Q1 dl dl a> Ol Dl N W N N F+ N N N F-� N N N O lD lD 1p O Vt 00 Ol
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \
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 N N N N N
O O O O O O O O O O O O O O O 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 N N N N N N N N N N N N N N N
0
4
y
m
F-
0
E
E
E
E
r-
0 0
0
0
0
0
c
a
a
ry
A¢�
A m
Tm
A m
Tm
,om
1D
am
am
d.,om
,,,,;nm
CO
M c0
Co .D
.�+ CO 'O
N co 10
m %D
Ln
c
c E
p w
o
W
0 ro
opp m
� E
C9 E
c
T Ki
LL O
O
U)
vc
M Vc
O
O
O
O
O
m
Ell
c m
e m
L m
C
mE
mE
mE
co
mE
a
w d
y n
d °•
,o
O
,o
O
,o
0
�o
O
�o
0 0
O
O
00
0
.•+ = 1�
N O
N 2 f�
X
N S f�
8
�
Y
u E
Y
Y sQ
a d
E E
L
F- c a
V`- o E
- E E E w
O
D_ O
- E° <
O ti 3 E V m
- E a
'C O u FCC
o
n
O
m u
d
0
0
gp
.29
W m u
F N
N
N V
u E
u E
E
o E
O ,c d
M c m
O E
m OL
M u E o0
0 U E 8
2 o
g
rn u E p
G
N
C N
O V O
L N
V H 0
1=/1 Q O
V 0 0 0
cy,� 0 N
O
_
N o m
0 m
=8g
< m
I m
M
m m
Z a j
co 6
m O C
6
d
o m
m m d
O M c
N cc d
6
C'i
O
c
N G
�
E d
U
E
C E
9.
CL
d
0 Co
LO Z m R
N
.-� all!
O
O
O
O
IIn
c
O �
e
E
E u
d M
o
v
o
0
In
u'� E
E
u r
u' c E
.o
u E
•o
E ci
E ci
ID
s
s LO j,
s
s LO
r view Villa
965 40`x' 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 February 2012
Prepared by Jennifer Eells, Property Manager
Police Report
There were no police calls for service the month of February.
Wait List
38 applicants for Parkview Villa North (resident of C.H., elderly, handicapped)
00 applicant for Parkview Villa North (employed in C.H.)
31 applicants for Parkview Villa North (non- resident, elderly, handicapped) (updated)
16 applicants for Parkview Villa North (no preference)
00 applicants for Parkview Villa South (resident C.H.)
02 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 101 out of 101 (100% occupancy) (caretaker unit included in total number of
units)
South is 42 out of 45 (93 % occupancy)
Move Outs
#414 2/29/12
#124 2/6/12
Move INS
#320 2/1/12
Maintenance Report (See attached)
r`
IV
IV
FEBRUARY 2012 A
IV
NEWSLETTER
Managed by CommonBond Communities
Owned by the City of Columbia Heights
IV
IV
Management lice: 763 - 706 -3800
IV
Hours: Monday through Friday
IV
IV
8:00 a.m. to 4:30 p.m.
IV
After Hours Maintenance Emergency:
IV
V -1- 66 -962- 6- -1- 66- -
Upcomin vents!
Create Valentines - Wednesday, February 1, 2:00 -4:00 p.m.
Simply Good Eating - Friday, February 3, 2:00 p.m.
Board Meeting- Monday, February 6, 7:00 p.m.
Resident Council Meeting- Monday, February 13, p.m.
Heart Day Featuring David Allen- Wednesday, February 15, 7:00 p.m.
Simply Good Eating- Friday, February 17, 2:00 p.m.
Movie of the Month Dolphin Tale— Wednesday, February 22, 3:00 p.m.
Thought for the Month
IV
"We find greatest joy, not in getting, but in expressing what we are. Men do
IV
not really live for honors or for pay; their gladness is not the taking and hold-
ing, but in doing, the striving, the building, the living. It is a higher joy to teach
than to be taught. It is good to get justice, but better to do it; fun to have things
but more fun to make them. The happy man is he who lives the life of love, not
IV
for the honors it may bring, but for the life itself'
R.J. Baughan
a
�
w
M
M
M
M
b
b
b
�D
�Iryp
q T
`=
a
W W
ti
Pl
P7
fA
Pa
N (A Pa
RI
�y l�
O
N
O
N
M
--i nbpD
0pp9
id
ro
�w pap��
V
V
pa9
U
5
a�
on
Pa
or
�.
N
W U
o
,w
N a
O
'}
T U U
OO
'd p
b
(!1
g
Qa �
'�`
f!1 �
y .O+
�^ Vl � (!1 g
Q
y
f!1 g
N
LG
P.
ti Pa
P.
N Pl fA P.
N W
P.
po��"
�]
c
(pV
O
d
Npp w e
� V F
O
euzm
vat
N
N
U
d
los
h
U
U
N U
u
a U u 0
N U
N
N N W W W W W N N N N H ® T
W W m m W m W m V m 01 m m W W N N N N` N IL O O ID II V` N m ✓S
m T T T T T m T m T T m T T T T T m T
S O' O' O' 6 6 ✓S 0' O' 6 6 6 O' O' O' 0' Q O' 6 > > > 7 > > _ > > > N
m m m W
N z z Z Z N Z Z Z � Z z z Z Z W Z z Z Z N N Z N z Z Z a
C
N N N N A J W N w lD T W A V1 N w w N W N N N N In N M.
N N O O N O O O N O O O O O N O F+ O O N O F+ O I O iP
N W Ol V w VI O O w m N 1p A N N A Ot W N 4D w O V
v In m -1 to
D s d 3 m< (D c ° c° « c° c o m m a
o a os m a m a '3° ° m 3 o o_ °� c a m
O c°< o X i s
3 c D0
3
�c v1 w N p z 0 -1 ;I� m z n n D n n �+ p w cn v+ n z n n -o -1 � v
�* N 3 (D C O .+ (D S N\ 0, S S (D "O S S O C S C d
0 3 a— 3 ,_, m s a°o p N m n �+ °(D° o m- s f D m n
N fD i = 021 O :°+ .' (D N °- ' T` : °O .* Oil m m O N m F 00 0 � •O r-« (D O
�' (D w o 3" (D m' 3 'm o m m a v s o 3 m° '^ �.
S ::p n Q S to O' •' OU f0 0 � _ °; (D O (D a Dl M 00 (D 0 ` (D
m 3 a °o v u> j s c° c N o m 3 S v m< D�
_ ° m
N (D �* .t n a O S 0, O S Crt O Vl a O• tl4 -Mi O '00 N ` d .*
O C z O
7c a '� O N �' C O 3 -11 4n O "O O 'O n N S 0 m N 2. 0'0
m o m c n '^ ° ('D o v m a g , 3 (D ° o m n
z6 F Q o c m? 3 m N° a 3 2 F° m a a 3
(D d w O ? (D 4v O 70 0 n '" 0 0 - (D w S a �
•O m a p: w m >> (D tr O0 — (D 7 M N A 0 CL p -1 m
(D O -0 O! d (D in "O N I (D .�. O fD N F 0 O S (D
N 7 O' n O d CL c
° 0 n of O O- A p 3 fD Q C
-O N vOi F N S d S = O 0 (D N O fD fD 0
(D o ID
0
°< ' m E '� o of o �,,° °< m o rD
a °
(D O <
N < v
a a m c (D
�m ° (D
rD• ° m o a a
4v c
'^ �,�n rD (D o. ..
o m CL i *. 0
S S O a 021 =+
a 0 a M <
m * (D
n , O_ °
(D
a (D
I
.<
D
((D 3 q a
-
o - Y
m
< F = o
m v 3 (D
m
' 3 (D
v \ D
r o
(D O —
o � d
C OO N
(D 3
� 6
(D
C)
\ \ \ N N N N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ N
W W O 0000 0\0 0\0 00 00 N O\) 0\i 0\1 D\1 W W N 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 N N N N e
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m
a
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 N N N N
V
d
C
C�
G
C
Ol
d
1
m
O
O
a
7
n
(D
m
O
ml
N N N N N N N N N N N N N W N N N N H N
l0 00 V V V V 01 W N N N O V V V Ot Ot .P W W
T T T T T T T T T T T T T T T T T 'fl T T
/D fD fD fD fD fD fD fD fD fD fD fD (O fD fD fD fU fD fD fD
a a a a a a a a a a a a s a a a a a a a
G G G C < < G C Z Z N Z Z Z N N Z Z W
Z Z Z Z Z Z Z Z
0) to V A l0 Vl lfl A N w W W N W A
0 O 0 0
O O O OOl O A 0 0 0 W ~i O
0 i ID
fl N D S S r '^ W W T N v w r W r T
c a* a a a on o F � r3< a ID O
O O d
O
o m z m 3 3 _T J
on O w J
(D c N
-I M O W !n N 7c
m n o 0 '00 = -
� n < ;o d 0 o n
O J j
•'i' .� �• JC Oq N J C N S �
o m N o 3 O C o J
J d Oil
(D
M -o a o ° fD o• W q'o wJ n 3 a o m c
0 Q p. a do '��' m O_ ln' N z .lD+ < M N _. Oil
O O O (D .. .. n "O \ i Ol W, a Oq Ob
J J N d -Oa x N x(D `N'� S N N 3 N N
M CL S V' N 3 c CL o N
� O S O ° ? d ° o
CL c o N •O N d o V 0 3 a
z J
o D a o of d m a 3 , m G S a
O O. C D n O o J O
a-
o"< N d S A
ry o = a o o <
n r x M J rD a o D n 3
F O1 N O M N = N O
� N a O. j m °• �• F
M Z • N a N D N n i^
o V� Dl N 0 d J d
CL J F o —
o w
* o Q m o
o C M m
CL M M -17 ?
x
as ^�
� c
3
M
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 N N N N N N N N N N N N N N N
l0 00 V V V V V W N N F+ W N W N 01 Ql Ql W W
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \
N N N N N N N N N N N N N N N N N N N N
O O O O O 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 N N N N N
Parkview Villa Apartments
965 40`x' 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 January 2012
Prepared by Laura Sheak, Property Manager
Police Report
There were no police calls for the month of January.
Wait List
39 applicants for Parkview Villa North (resident of C.H., elderly, handicapped)
00 applicant for Parkview Villa North (employed in C.H.)
31 applicants for Parkview Villa North (non- resident, elderly, handicapped) (updated)
16 applicants for Parkview Villa North (no preference)
00 applicants for Parkview Villa South (resident C.H.)
03 applicants for Parkview Villa South (non- resident)
00 applicant for Parkview Villa South 2BR (resident)
01 applicant for Parkview Villa South 2BR (non- resident)
Occupancy
North is 101 out of 101 (100% occupancy) (caretaker unit included in total number of
units)
South is 43 out of 45 (96 % occupancy)
Move Outs
#320 1/31/12
Move INS
#401 1/01/12
#211 1/05/12
Maintenance Report (See attached)
® -o
rt �
NJ J N J N N J N
-� g J\ J J 2
A W.W NN V V D7 O) NNN NNNJ0000(O CO CO (O CO (O W O 65 Ot A`W ` C
� G
W
< < G < < < < < < < < < < < < < < < < < < G < < < < < < < < < < o
ZZZZZ(nZZZZZ(n (n UI ZZZfn ZZCn (n ZZZZZZZZZZ�� N
(C i 3
N N
C
7 f�D
0) W 00 f0 V N N W (O W (It N N 0 N N A au W A N O) V (P V O) 0 N N NJ N
O
C)�22D'n�W'O OOV fAO ow 1 3 0) W SwZ n
ypy�wom °Fvi33�?om3�.a(ovw3= «°3x3
O <= N `G ° 0 0 7 n N = O O < i 1 0 ,< N ? 'O O O O 3 O a
CD
0� 0 a c - 0) �. O °: 0 O, 0 ,D„1 a s °-'. m 0 O N 0 S d �' 0 D7 9�7 (D ° O N
O 0 N 7 V1 S N O S .N. M D7 •O S O O
CD d S (O 0 .< a O -� 7< D) 0 0 7 D) (0 O
S� (i ° 7 5 7 0 0 N (D T. 7 7 0 7 0 0 0 4 0 � d O ='
7770 m m j 0 Qa '00, 3 am m 3 3� 3 0(D am 0 0 w.3 3 X33 o amp
u° oo°o0-0-oxFv-°ox-- r - =N2mo m.°Qo� xmo CD x a '� O. O '< �° (°« O 'O N(D (D °-' -O. (D f/1 0 m f0 d O 0 S 0 d N d
-� ° (a O 2. N O •O � (c0 d S M x S >> a 0' m o �.'- m S v0, ° 0 (o N
U3 N 3 N 0 O N o (O O O (n (a 77 • f� O d O
7 7 7, Cr =n N N �: a. j' 3 o M o 0? 'N"' Cn m o(D m V m °< 3 0. 9 O
0 3 A x v C N N d 0 p 7 O T d (D Q 0 O) (F CCD
C 7C (D O o o 'O p 7 S D7 O 7 d d 0 0. D) i 0 0 m° (D .O d
0��� M d v(D m n m n�0 � �' m �= A� m (0D m o� 0 C� v v
' N O O 0 O N 0 ?� G N 9 d °" 01 O' p'7 � (AD ((DD O
m. c 0 N N -J N N °: N -fj 7 N S O = i n a) =(d 0 T 0 O' 'O .5.
N (D
-I O M X X
K (� D N 0 Dj N 7. N o a a, N OT, o N m °. N O. a. j• N O CL
(D
CL O N a a- x o O c i m a m a. N �j ° O ' r n C a. ° 0' d CL w CL
y� 7 T' C O Doi m 9-0 .0.. d O' N N c S F 0
O' a. N° o N ' C N 'O0 1 �a 7 a (D N 'O d 0 O rt 0- CL
0 �: O o -, Jd O 0:O 7
. y o° 3 m° °- °° 0) o N d o m a 5- w v o 0 1p
c 0 cD d. o N 3 3 W c `< O 0
7 �'
CL Cl F a y m x °o
m m o No 3 °'N o �.
(�D �' O <D w 0 C 0
N T = CD
0 = NO N J O 0 0
O J (D 7
J n 0 O 'O
Co < F
(n
J j W N
N 7c CD R1
n
O
000000000000000000000000000000003
(�W AOe1 V V `��NNNN`J- �OOOJO00 (700(0 fO� W � W,O.,
J J J J J J J J J J J J! J! J N) J J J J J J J J J
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 N N N N N N N N a
\ §)()
&&i \k
/\_))
CD W
:3 0
-7i! CD
CD
—CL
\ \ \ \77
o 3 \\
§4 % ¥=
a CL
CD
! \i
\ x 0.
( §2\2
\3§\\
0
LL
Z
h
m
d
p
P
q
�
�
q
O
M
O
m
O
M
M
z
e
e
El n
ai �p
i
O
p
5
�
W N LQ P]
r
N 09
qq
a
.c
y❑ N N 8
N
N
�~p
O
N
❑ O
� p
b 0 U
^Mi Cl U
a
ON vl N U U
N 0 U
O O
O O
o �aa
o a
r O
o a
O
o a
h ],' U
ti x U
Q '.Lp' U
ry '✓p' U
y
X
U
Xyy
X
U F
F o q
F o �
F o gg
la
F o pp
cn
iCV
U
N
V }Oi%n ,.ry
O pp
(y+glJ A Nr O N
a
O I N
PQ
O
0
z p
O
99T
O
P7 _O
O
O A
O O U
O
O
y p u G
ti O
W
W W
a °i
0
Ca
cV r
Pi Si
U �
v
In
U b�
U 6(
U b(
U aC
co U m
U
N u
N U
• -,; =741
•
• •' .
• Jenny will check on POW flag for
the • pole • front
notice be posted when Jim Kordiak be
coming to help with renters rebates
Eff"TIS • • •
oCan have Service or • •, •
Parkview Villa
hours, please call the Maintenance Emergency
number
If you •. like a copy of
-mergency numbers, please stop by the office.
1.
2.
3.
4.
5.
6.
7.
8.
Febru
2012 Resident Council Meetinq Hili
Laura Sheak announced that she would be leaving Parkview Villa at the end of the month.
If you smell cigarette smoke coming from any apartment in the building, report it to the office.
If you have complaints about the food that SACA is giving us, do NOT call SACA; call our
president, Lyn Miner. Her number 781 -1042.
We welcomed our new resident, Pat Cassady, Apt.320.
We thanked Shirley Benitez and her committee for the nice decorations.
The VOA lunches are $3.50 per meal.
The Resident Council voted to pay half for bird food. [32 yes, 2 no]
Money winners were Jackie Ovshak, DeAnne Kunshier, Pat Cassady, and Arlene Peterson.
RESIDENT COUNCIL MEETING I LI °T ® 1-9-12
1. Meeting was called to order by outgoing Council President, Rheta Nelson.
2. Jennifer Eels gave the Manager's Report on several subjects:
Do not put grease down your sink or toilets, as it causes damage to the pipes. Dispose of
grease properly.
Laura is on vacation from January 12 to January 23.
Pets are not allowed in the common areas of the building unless they are service or
companion animals.
Wrap your cat waste properly, so that it does not spill on the floor by the trash chute.
Leave your recycle basket outside your door, Monday and Thursday mornings by 9:30 a.m.
DO NOT set it out the night before! If the Manager's Office is closed, there will be no pick -up that
day.
If the VOA lunch in the "B" Room refrigerator does not have your name on it, do NOT take it.
Do not let people into the building if you do not know them. A list of people who are banned
from the property is on the bulletin board behind the glass, in the front lobby. If you see such a
person on the property, contact the police. Let Management know if any resident gave access to the
building to any person who is banned.
The City of Columbia Heights has an excessive nuisance policy which could result in fines for
residents /buildings if three nuisance calls are received in a 12 -month period. Copies of the policy are
available for your viewing, in the office.
3. Ken Bloch gave the Treasurer's Report.
1. Terry introduced the new resident, Deb, in Apt. 211.
5. Cecelia gave the Sunshine Report. 30 get well cards were sent, and one sympathy card to
Tom Pilarsk, as his mother passed away.
6. Rheta Nelson introduced the new Board Members:
President — Lyn Miner
Vice President —Vivian Fahey
Secretary — Jessie Chudek
Treasurer — Kenneth Bloch
Member -at -Large — LeAnn Miller
Sergeant -at -Arms — Matthew Kopacek
7. Lyn M. showed a thank -you page that will be framed and given to Joe and Mary Lou Goodman to
thank them for all the help they give the Council.
8. $100 per month, from the Contingency Fund, can be authorized for purchases for unforeseen
expenses. Check with the President, before buying anything.
9. HRA meeting is Tuesday, January 24 at 7 p.m.
10. A new telephone list will be out in the next two weeks.
COLUMBIA HEIGHTS HOUSING AND REDEVELOPMENT AUTHORITY (HRA)
Meetin of: April 24, 2012
AGENDA SECTION: Business Items
ORIGINATING
EXECUTIVE
NO: 9
DEPARTMENT: HRA
DIRECTOR
APPROV
ITEM: Window Analysis Bid - Encompass
BY: Scott Clark
BY:
DATE: April 18, 2012
BACKGROUND: At the January 24, 2012 HRA meeting staff informed the HRA that a request for
proposal was being prepared by CommonBond for analysis of the windows at Parkview Villa South.
Over time it has become clear that a number of window envelopes have failed and that water intrusion
is becoming an issue. As such, a request for proposal was originally sent out for analysis of the
problem and contract preparation for bidding (similar to how the modernization plans and bids process
works). Only two bids were received- Encompass at $22,820 and Inspec at $36,675 (tabulation
enclosed).
Staff realizes that the issue of actually correcting problems, coupled with the installation of windows,
becomes complicated due to the potential sale to Aeon. In other words, does the HRA do window work
in 2012 and negotiate that as part of the sales price? Is the issue at hand something that can wait until
2013 so the efficiencies of a total rehabilitation work, that Aeon is proposing, can be implemented?
Based on these questions staff is recommending the following:
1) Staff asked Encompass to break their bid into two parts. Phase 1 ($9,660) is the analysis
and Phase 11 ($13,160) is the plan preparation, bidding, etc.
2) Staff recommends the issuing of the Phase I portion of the bid at this time. The information
derived from the analysis will serve as the foundation for discussions with all concerned
parties as to what the next steps should be. Put in another way, you can't discuss a solution
until you know what the problem is, and in this case, how big and extensive the issues
possibly are.
If approved, it is assumed that the Phase I work will be done in three months. Lastly, the Phase I will
be funded thorough line item 5120, Capital Improvements, in the approved 2012 Parkview Villa South
budget.
RECOMMENDATION: Approval of the Phase I contract with Encompass in the amount of $9,660 for
window analysis at Parkview Villa South.
RECOMMENDED MOTION: Motion to Approve Phase I of the Encompass Contract dated March 30,
2012 in the amount of $9,660.
630
HRA ACTION:
C.i>rnrnoni_iood
CUnl >i U N I I lG, fj
Memorandum
DATE: March 15, 2012
TO: Laura Frost
FROM: Brian Hon
RE: Parkview Villa South Apartments
Laura, below is the breakdown of the exterior architect /engineer services at
Parkview Villa South— the proposals from vendors are attached:
I would recommend Encompass, Inc. for the architect /engineer services for
Parkview Villa South Apartments.
WAI /Continuum,
Encompass,
Inspec
Inc,
Inc.
Totats
NIA
$22,820.00
$36,675.00
Building Envelope
N/A
$4,640.00
$7,080.00
Investigation &
Documentation
Analysis of
NIA
$3,520.00
Included
Conditions
Contract
N/A
$7,840.00
$11,075.00
Documents & Bid
Management
Construction
N/A
$5,320.00
$16,760.00
Observation
High Lift — Rental
NIA
$1,500.00
$1,760.00
equipment
I would recommend Encompass, Inc. for the architect /engineer services for
Parkview Villa South Apartments.
Bonn1.
engineering consultants
forensic analysis
March 30, 2012
Mr. Brian Hon
CommonBond Communities
328 Kellogg Boulevard West
St, Paul, MN 55102
Re: Professional Services Proposal
Parkview Villa South
965 401h Avenue NE
Columbia Heights, MN 55421
SCOPE OF SERVICES— PHASE I
Encompass, Inc. proposes to provide the following services:
1.0 Building Envelope Investigation & Documentation
The investigation will include documentation of existing conditions to assess and analyze
exterior envelope deficiencies, the focus of investigation will be on water intrusion issues
at window openings. Specifically, our investigation will include:
1.1 Document Review
Review available pertinent documents provided by the owner. Desirable documents
for review include design drawings, specifications, addenda, and other documents
related to the original construction; building repairs; maintenance reports or work
orders relative to the building envelope or any reported deficiencies.
1.2 Building Envelope Condition Documentation
1.2.1 Conduct an overall facade assessment to include a visual survey of the
exterior envelope conditions via a high lift, focus will be on the condition of
the windows.
1.2.2 Inspect available living units that are experiencing water intrusion and /or
reporting interior moisture intrusion.
1.2.3 Perform invasive openings through the facade at window openings to
determine wall construction configurations. Remove and re- install a window
to analyze window configuration and performance.
1.2.4 Window Testing
1.2.4.1 Conduct an AAMA 502 water test at two windows.
1.2.4.2 Subject windows will be based upon visual observations,
accessibility, and /or unit owner reports of window issues.
1.2.4.3 The purpose of testing will be to identify deficiencies with the
window units and /or window flashing details that are causal to
the reported water intrusion issues.
2.0 Analysis & Summary Report
2.1 Analyze field data and existing documentation and prepare a summary of findings
from the investigation, including conclusions relative to causes of distress.
2.2 Determine repair scope to address the root cause of the problems in order to ensure
the exterior envelope will resist moisture intrusion and reduce future maintenance
costs. Multiple repair options and phasing of repairs will be considered, when
possible and appropriate.
2.3 Discuss findings of investigation with owner and present repair options.
COST OF ENGINEERING SERVICES— PHASE I
The cost of the professional engineering services required for proposed Phase I of the exterior
envelope review of the Parkview Villa South building is as follows:
1. Building Envelope Investigation & Documentation $4,640.00
2. Analysis & Summary Report $3,520.00
3. High Lift Rental $1,500.00
Total $9,660.00
These proposed costs are valid for 90 days.
SCOPE OF SERVICES — PHASE II
3.0 Contract Documents
3.1 Encompass will produce restoration drawings /specifications and construction
documents to be utilized for bidding as specified by our report recommendations;
documents will include design drawings, summary of work, specifications,
instructions to bidders, general conditions, a bid form, and an agreement to be used
between owner and contractor.
3.2 Bid Management: Encompass will conduct a pre -bid meeting with bidding
contractors, a post -bid meeting with the apparent low bidder, and a pre- construction
meeting. This proposal and associated costs are based on bidding the project one
time. Should the owner to bid the project multiple times, additional costs may apply.
4.0 Construction Observation
4.1 During the construction phase of the exterior restoration, Encompass will perform
periodic on -site visits to observe construction activities.
4.2 Encompass will provide to the owner copies of all construction photographs and
construction observation reports.
4.3 This proposal and associated costs are based on performing 5 hours of construction
observation per week during an estimated construction duration of 6 weeks. Actual
cost associated with construction observation services will depend on the actual
duration of the construction project; should the construction project be longer than
6 weeks, additional construction observation costs may apply.
COST OF ENGINEERING SERVICES — PHASE II
The cost of the professional engineering services required for proposed Phase II of the exterior
envelope review of the Parkview Villa South building is as follows:
1. Contract Documents & Bid Management $7,840.00
2. Construction observation $5,320.00
Total $13,160.00
These proposed costs are valid for 120 days.
Thank you for the opportunity to present this proposal. Upon awarding of the contract, we will
schedule the project and coordinate commencement of the investigation with you.
Sincerely,
Kent J. Jones, P.E.
Vice President /Principal
Encompass, Inc.