2007 Reports on Compliance
0
0
CITY OF ALBERTVILLE
' Wright County, Minnesota
Reports on Compliance with
' GovernmentAuditing Standards,
OMB Circular A-133 and Legal Compliance
For the Fiscal Year Ended December 31, 2007
7
i
~'~
1
r
CITY OF ALBERTVILLE
Wright County, Minnesota
' TABLE OF CONTENTS
SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS ..................................... 1
NOTE TO THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS ........ 2
REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING
AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN
' AUDIT OF FINANCIAL STATEMENTS PERFORMED IN
ACCORDANCE WITH GOVERNMENTAUDITINGSTANbARDS ......................... 3
' REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE
TO EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER
COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 ....................... 5
SCHEDULE OF FINDINGS AND QUESTIONED COSTS IN
ACCORDANCE WITH OMB CIRCULAR A-133 .......................................................... 8
REPORT ON LEGAL COMPLIANCE ............................................................................ 11
SCHEDULE OF FINDINGS ON LEGAL COMPLIANCE
AND INTERNAL CONTROL ......................................................................................... 12
i
C
L
LJ
L
ii
' CITY OF ALBERTVILLE
Wright County, Minnesota
' SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
December 31, 2007
Federal
CFDA
Federal Funding Source Number
Through Minnesota Department of Transportation:
' USDOT 20.205
Grant Name
Highway Planning and Construction
2007
Expenditures
$ 527,887
1
0
CITY OF ALBERTVILLE
Wright County, Minnesota
NOTE TO THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
December 31, 2007
BASIS OF PRESENTATION
The accompanying Schedule of Expenditures of Federal Awards includes the federal grant
activity of the City of Albertville, Minnesota, and is presented on the modified accrual basis of
accounting. The information in this Schedule is presented in accordance with requirements of
OMB Circular A-133, Audits of States, Local Governments and Nonprofit Organizations.
Therefore, some amounts presented in this Schedule may differ from amounts presented in, or
used in the preparation of, the basic financial statements.
7
i~
C'
r
n
0
0
u
,i
I~DV
Expert advice. When you need it. s"'
REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING
AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT
OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE
WITH GOVERNMENT AUDITING STANDARDS
' Apri17, 2008
J
Honorable Mayor and Members
of the City Council
City of Albertville
Albertville, Minnesota
We have audited the financial statements of the governmental activities, the business-type
activities, each major fund and the aggregate remaining fund information of the City of
Albertville, Minnesota, as of and for the year ended December 31, 2007, and have issued our
report thereon dated Apri17, 2008. We conducted our audit in accordance with U.S. generally
accepted auditing standards and the standards applicable to financial audits contained in
Government Auditing Standards, issued by the Comptroller General of the United States.
INTERNAL CONTROL OVER FINANCIAL REPORTING
In planning and performing our audit, we considered the City's internal control over financial
reporting as a basis for designing our auditing procedures for the purpose of expressing our
opinion on the financial statements but not for the purpose of expressing an opinion on the
effectiveness of the City's internal control over financial reporting. Accordingly, we do not
express an opinion on the effectiveness of the City's internal control over financial reporting.
n
0
Our consideration of internal control over financial reporting was for the limited purpose
described in the preceding paragraph and would not necessarily identify all deficiencies in
internal control over financial reporting that might be significant deficiencies or material
weaknesses. However, as discussed below, we identified certain deficiencies in internal control
over financial reporting that we consider to be significant deficiencies.
A control deficiency exists when the design or operation of a control does not allow management
or employees, in the normal course or performing their assigned functions, to prevent or detect
misstatements on a timely basis. A significant deficiency is a control deficiency, or combination
of control deficiencies, that adversely affects the entity's ability to initiate, authorize, record,
process or report financial data reliably in accordance with U.S. generally accepted accounting
principles such that there is more than a remote likelihood that a misstatement of the City's
financial statements that is more than inconsequential will not be detected by the City's internal
control. We consider the deficiencies described in the accompanying Schedule of Findings and
Questioned Costs in accordance with OMB Circular A-133 as Audit Findings 06-02 and 06-03 to
be significant deficiencies in internal control over financial reporting.
n
J
t
I~DV
A material weakness is a significant deficiency, or combination of significant deficiencies, that
results in more than a remote likelihood that a material misstatement of the financial statements
will not be prevented or detected by the City's internal control.
Our consideration of the internal control over financial reporting for the limited purpose
described in the first paragraph of this section and would not necessarily identify all deficiencies
m the internal control that might be significant deficiencies and, accordingly, would not
necessarily disclose all significant deficiencies that are also considered to be material
weaknesses. However, we consider the deficiency described in the accompanying Schedule of
Findings and Questioned Costs in accordance with OMB Circular A-133 as Audit Finding 06-02
to be a material weakness in internal control over financial reporting.
COMPLIANCE AND OTHER MATTERS
As part of obtaining reasonable assurance about whether the City's basic financial statements are
free of material misstatement, we performed tests of its compliance with certain provisions of
laws, regulations, contracts and grant agreements, noncompliance with which could have a direct
and material effect on the determination of financial statement amounts. However, providing an
i opinion on compliance with those provisions was not an objective of our audit and, accordingly,
we do not express such an opinion. The results of our tests disclosed no instances of
noncompliance that are required to be reported under Government Auditing Standards.
We also noted certain additional matters that we reported to management of the City in a
separate letter dated April 7, 2008.
' This report is intended solely for the information and use of the City Council, management and
state and federal awarding and oversight agencies and is not intended to be and should not be
used by anyone other than those specified parties.
KERN, DEWENTER, MERE, LTD.
Minneapolis, Minnesota
I
~ '
I~DV
Expert advice. When you need it. `""
REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE
TO EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER
COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133
Apri17, 2008
t
1
t
Honorable Mayor and Members
of the City Council
City of Albertville
Albertville, Minnesota
COMPLIANCE
We have audited the compliance of the City of Albertville, Minnesota, with the types of
compliance requirements described in the U.S. Office of Management and Budget OMB Circular
A-133 Compliance Supplement that are applicable to its major federal program for the year ended
December 31, 2007. The City's major federal programs are identified in the Summary of
Auditors' Results section of the accompanying Schedule of Findings and Questioned Costs in
Accordance with OMB Circular A-133. Compliance with the requirements of laws, regulations,
contracts and grants applicable to the major federal program is the responsibility of the City's
management. Our responsibility is to express an opinion on the City's compliance based on our
audit.
We conducted our audit of compliance in accordance with U.S. generally accepted auditing
standards; the standards applicable to financial audits contained in Government Auditing
Standards, issued by the Comptroller General of the United States and OMB Circular A-133,
Audits of States, Local Governments and Nonprofit Organizations. Those Standards and OMB
Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about
whether noncompliance with the types of compliance requirements referred to above that could
have a direct and material effect on a major federal program occurred. An audit includes
examining, on a test basis, evidence about the City's compliance with those requirements and
performing such other procedures as we considered necessary in the circumstances. We believe
that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal
determination of the City's compliance with those requirements.
In our opinion, the City of Albertville, Minnesota, complied, in all material respects, with the
requirements referred to above that are applicable to its major federal program for the year ended
December 31, 2007.
LJ
II
1
I~DV
INTERNAL CONTROL OVER COMPLIANCE
The management of the City is responsible for establishing and maintaining effective internal
control over compliance with the requirements of laws, regulations, contracts, and grants
applicable to federal programs. In planning and performing our audit, we considered the City's
internal control over compliance with the requirements that could have a direct and material
effect on a major federal program in order to determine our auditing procedures for the purpose
of expressing our opinion on compliance, but not for the purpose of expressing an opinion on the
effectiveness of internal control over compliance. Accordingly, we do not express an opinion on
the effectiveness of the City's internal control over compliance.
A control deficiency in the City's internal control over compliance exists when the design or
operation of a control does not allow management or employees, in the normal course of
performing their assigned functions, to prevent or detect noncompliance with a type of
compliance requirement of a federal program on a timely basis. A significant deficiency is a
control deficiency, or a combination of control deficiencies, that adversely affects the City's
ability to administer a federal program such that there is more than a remote likelihood that
noncompliance with a type of compliance requirement of a federal program that is more than
inconsequential will not be prevented or detected by the City's internal control.
A material weakness is a significant deficiency, or combinations of significant deficiencies, that
results in more than a remote likelihood that material noncompliance with a type of compliance
requirement of a federal program will not be prevented or detected by the City's internal control.
Our consideration of internal control over compliance was for the limited purpose described in
the preceding paragraph and would not necessarily identify all deficiencies in internal control
that might be significant deficiencies or material weaknesses as defined above. We did not
identify any deficiencies in internal control over compliance that we consider to be material
weaknesses, as defined above.
SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
We have audited the financial statements of the governmental activities, business-type activities,
each major fund and the aggregate remaining fund information of the City of Albertville,
Minnesota, as of and for the year ended December 31, 2007, and have issued our report thereon
dated April 7, 2008. Our audit was performed for the purpose of forming opinions on the
financial statements that collectively comprise the City's basic financial statements. The
accompanying Schedule of Expenditures of Federal Awards is presented for purposes of
additional analysis as required by OMB Circular A-133 and is not a required part of the basic
financial statements. Such information has been subjected to the auditing procedures applied in
the audit of the basic financial statements and, in our opinion, is fairly stated, in all material
respects, in relation to the basic financial statements taken as a whole.
The City's response to the findings identified in our audit is described in the accompanying
Schedule of Findings and Questioned Costs in Accordance with OMB Circular A-133. We did
not audit the City's response and, accordingly, we express no opinion on it.
~ ,.
I~DV
This report is intended solely for the information and use of management, the City Council,
federal awarding agencies and pass-through entities and is not intended to be and should not be
used by anyone other than these specified parties.
KERN, DEWENTER, MERE, LTD.
Minneapolis, Minnesota
ri
t
~ '
~l
u
CITY OF ALBERTVILLE
Wright County, Minnesota
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
IN ACCORDANCE WITH OMB CIRCULAR A-133
December 31, 2007
SECTION I -SUMMARY OF AUDITORS' RESULTS
Financial Statements
Type of auditors' report issued:
Internal control over financial reporting:
• Material weakness(es) identified?
• Significant deficiency(ies) identified that is not
considered to be a material weakness(es)?
Noncompliance material to financial statements noted?
Federal Awards
Type of auditors' report issued on compliance
for major programs:
Internal control over major programs:
• Material weakness(es) identified?
• Significant deficiency(ies) identified that is not
considered to be a material weakness(es)?
Any audit findings disclosed required to be reported
in accordance with section 510(a) of OMB Circular
A-133?
Identification of Major Programs
CFDA No.:
Name of Federal Program or Cluster:
Dollar Threshold used to Distinguish
between Type A and Type B programs:
Auditee qualified as low risk auditee?
Unqualified
Yes, Audit Finding 06-02
Yes, Audit Finding 06-03
No
Unqualified
No
No
No
20.205
Highway Planning and Construction
$ 300,000
No
~ "
CITY OF ALBERTVILLE
Wright County, Minnesota
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
IN ACCORDANCE WITH ONIB CIRCULAR A-133
December 31, 2007
SECTION II -FINANCIAL STATEMENT FINDINGS
Audit Finding 06-02
Criteria or Specific Requirement:
Internal control that supports the City's ability to initiate, record, process and report capital asset
data consistent with the assertions of management in the financial statements requires.
Condition:
Prior period adjustments were required to restate capital asset balances
i Questioned Costs:
None
Context.•
This finding impacts the internal control for capital asset recording and tracking functions.
Effect.•
The lack of control over record keeping related to capital assets could adversely affect the City's
ability to initiate, record, process and report capital asset data consistent with the assertions of
management in the financial statements.
Cause:
There are a limited number of office employees.
Recommendation:
Continue to review the capital asset recording and tracking system, including changes that may
occur.
Management's Response:
The City of Albertville in conjunction with our auditors miscoded and overlooked capitalizing
these items and was required to do a prior period adjustment to record these items correctly. The
City of Albertville in conjunction with two auditing firms now believe that controls are in place
to properly present completed projects and present them appropriately on the financial statements
in the future.
CITY OF ALBERTVILLE
Wright County, Minnesota
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
IN ACCORDANCE WITH OMB CIRCULAR A-133
December 31, 2007
SECTION II -FINANCIAL STATEMENT FINDINGS
Audit Finding 06-03
Criteria or Specifac Requirement:
Internal control that supports the City's ability to initiate, record, process and report data
consistent with the assertions of management in the financial statements requires.
Condition:
The City does not have adequate segregation of accounting duties.
Questioned Costs:
None
Context:
This finding impacts the internal control for all significant accounting functions.
Effect:
The lack of adequate segregation of accounting duties could adversely affect the City's ability to
initiate, record, process and report financial data consistent with the assertions of management in
the financial statements.
Cause:
There are a limited number of office employees.
Recommendation:
Continue to review the accounting system, including changes that may occur. Implement
' segregation whenever practical.
Management's Response:
The City of Albertville continues to review the segregation of duties on a periodic basis and
works on improving them where possible with the limited staffing.
' SECTION III -FEDERAL AWARD FINDINGS AND QUESTIONED COSTS
None
i
10
Apri17, 2008
~~
I~DV
Expert advice. When you need it. `'"
REPORT ON LEGAL COMPLIANCE
Honorable Mayor and Members
of the City Council
City of Albertville
Albertville, Minnesota
We have audited the financial statements of the governmental activities, the business-type
activities, each major fund and the aggregate remaining fund information of the City of
Albertville, Minnesota, for the year ended December 31, 2007, which collectively comprise the
City's basic financial statements and have issued our report thereon dated April 7, 2008.
We conducted our audit in accordance with U.S. generally accepted auditing standards and the
provisions of the Minnesota Legal Compliance Audit Guide for Local Government, promulgated
by the State Auditor pursuant to Minnesota .Statute Sec. 6.65. Accordingly, the audit included
such tests of the accounting records and such other auditing procedures as we considered
necessary in the circumstances.
The Minnesota Legal Compliance Audit Guide for Local Government covers seven main
categories of compliance to be tested: contracting and bidding, deposits and investments,
conflicts of interest, public indebtedness, claims and disbursements, miscellaneous provisions
and tax increment financing. Our study included all of the listed categories.
The results of our tests indicate that for the items tested, the City of Albertville complied with the
material terms and conditions of applicable legal provisions, except as listed on the Schedule of
Findings on Legal Compliance and Internal Control.
This report is intended solely for the information and use of the City Council, management and
the Office of the State Auditor, and is not intended to be and should not be used by anyone other
than those specified parties.
KERN, DEWENTER, VIERS, LTD.
Minneapolis, Minnesota
11
D
i
LI
0
CITY OF ALBERTVILLE
Wright County, Minnesota
SCHEDULE OF FINDINGS ON LEGAL COMPLIANCE
AND INTERNAL CONTROL
December 31, 2007
CURRENT YEAR LEGAL COMPLIANCE FINDING:
Audit Finding 07-01-Out of State Travel Policy
The City does not have a policy regarding travel outside of Minnesota. Minnesota
Statutes 471.661 states all cities must have an approved policy that controls travel outside the
state of Minnesota which specifies when out of state travel is appropriate, the expense limits of
out of state travel and procedures for approval of the travel.
We recommend the City comply with state statutes and develop a written policy for out of state
travel, which is approved by the City Council. The policy should specify when out of state travel
is appropriate, expense limits for out of state travel and procedures for approval of out of state
travel.
Managements Response:
The City of Albertville is currently working on developing a written policy for out of state travel.
Audit Finding 07-02 -Obtain Sufficient Collateral on Deposits
Minnesota Statutes 118A.03 provides all deposits with financial institutions must be
collateralized in an amount equal to 110% of deposits in excess of Federal Deposit Insurance
Corporation (FDIC) insurance. If irrevocable standby letters of credit from federal home loan
banks are used, the collateral amount must be equal to the amount of the excess deposit plus
interest at the close of the banking day.
Deposits at Premier Bank were undercollateralized by $ 27,008 at December 31, 2007.
We recommend the City monitor the collateral held at all banks during the year to ensure the
City's deposits are adequately secured and in compliance with statutes.
Managements Response:
The City of Albertville maintains adequate collateral at all times. This instance was that the city
offices were closed on December 31st and an investment was called early with no warning. The
money was put into our account on 12!31 /07 and the bank did not have enough time to get
collateral and it just happened to be the last day of the year.
12
CITY OF ALBERTVILLE
Wright County, Minnesota
SCHEDULE OF FINDINGS ON LEGAL COMPLIANCE
AND INTERNAL CONTROL
December 31, 2007
'~
7
1
C
t
PRIOR YEAR LEGAL COMPLIANCE FINDING:
During our previous audit, we noted there was an expenditure to purchase employee gift
certificates. Expenditures by a city should meet a public purpose test. The Minnesota Attorney
General's Office has the opinion that payments for employee appreciation do not qualify as a
public purpose expenditure.
In 2007, the City refrained from paying for these items.
13