City of Ashland, Oregon / City Recorder / City Council Information / Packet Archives / Year 2002 / 11/19 / CAFR
CAFR
[ Council Communication ] [ Committee
Letter ] [ Auditor's Report ] [
Minutes ]
Council Communication
| Title: |
Acceptance of Audit Committee report dated November
1, 2002 and the June 30, 2002 Comprehensive
Annual Financial Report |
| Dept: |
Finance Department |
| Date: |
November 19, 2002 |
| Submitted By: |
Lee Tuneberg, Finance Director |
Reviewed
By:
........................ |
Brian Almquist, Interim City Administrator |
| Synopsis: |
The Audit Committee has met with staff and Pauly,
Rogers and Company, P.C. to review and accept the annual audit for the fiscal
year ended June 30, 2002. The committee's report can be found in the annual
report on page xvii and the auditor opinion on page 1. Copies of those pages
and meeting minutes are attached. |
| Recommendation: |
The Audit Committee recommends acceptance of the
2001-2002 Comprehensive Annual Financial Report and staff concurs. |
| Fiscal Impact: |
None from adoption. |
| Background: |
The annual report is a complex document containing
a tremendous amount of information. From an overview stand point, the city
is in good financial health and is maintaining or making progress on budgeted
activities. Some activities like capital projects have suffered from delays
causing elevated fund balances in related funds, yet the total city fund
balance decreased $5.5 million during the fiscal year. Cash and investments
echoed this change with a similar decrease.
During the current year the city will finish many of these projects
and make sizeable debt service payments related to their financing which
will all work toward further reduced fund balances by June 30, 2003.
Background:
The Comprehensive Annual Financial
Report is prepared annually as part of the state-required audit by an
independent, certified and municipally licensed auditor. In Ashland, the
auditor reports to the Audit Committee established by the city. The committee
receives the auditor opinion, management letter and annual financial reports
prepared by staff. When satisfied with the reports and related information,
the committee forwards the report to council with a recommendation to
accept.
The city is responsible for completeness and accuracy of the annual
report and this year's document was prepared, cover to cover, by city staff.
The necessary auditor reports are included in the document and presented
on their letterhead.
Key places to look within the document are:
Page |
|
Subject matter |
| i - xi |
|
Transmittal letter from staff |
| xvii |
|
Report of Audit Committee accepting the
audit |
| 1 - 2 |
|
Auditor's unqualified opinion |
| 4 - 12 |
|
Combined balance sheet and other financial
statements |
| 15 - 45 |
|
Notes explaining the general purpose financial statements |
| 49 - 132 |
|
Supplementary reports, schedules and statistical
tables |
| 133 - 144 |
... |
Other required auditor comments and disclosures |
|
|
|
Questions on the Comprehensive Annual Financial Report can be directed
to the Finance
Department. |
End of Document - Back to Top
November 1,2002
The City Council
City of Ashland, Oregon
The Audit Committee advises the City Council on matters concerning the City's
financial reporting process. In fulfilling its responsibilities, the Committee
recommends the independent certified public accountants to be engaged by
the City Council as the City's auditors. The Committee discusses with the
selected independent certified public accountants the overall scope and specific
plans for the audit.
The Committee also discusses with the City's auditors the City's financial
accounting and reporting, processes, including the preparation of the financial
statements. In addition, the Committee discusses including the safeguarding
of the City's assets and other resources against unauthorized acquisition,
use or disposition.
At the conclusion of the annual audit, the Committee meets with the City's
auditors to discuss the results of their audit and their evaluation of the
City's financial reporting.
Based on the Committee's discussions with the City's auditors, we accept
the City's 2001-2002 Comprehensive Annual Financial Report (CAFR) and the
related audit reports of the independent certified public accountants. Based
on our acceptance, we recommend the CAFR and auditor's reports be accepted
by the City Council.
Respectfully submitted,
The Audit Committee
End of Document - Back to Top
PAULY, ROGERS AND CO., PC. CERTIFIED PUBLIC ACCOUNTANTS
12700 sw 72ND AVENUE · TIGARD, OREGON 97223
(503) 620-2632 · FAX (503) 684-7523
To the City Council ,September 6, 2002
City of Ashland
Jackson County, Oregon
INDEPENDENT AUDITORS' REPORT
We have audited the general purpose financial statements of City of Ashland,
Jackson County, Oregon, as of and for the year ended June 30, 2002 as
listed in the table of contents. The general purpose financial statements
are the responsibility of the City's management. Our responsibility is to
express an opinion on these general purpose financial statements based on
our audit. The financial statements of City of Ashland, Jackson County, Oregon
as of June 30, 2001 were audited by other auditors whose report dated October
19, 2001, expressed an unqualified opinion on those statements.
We conducted our audit in accordance with auditing standards generally accepted
in the United States of America and the standards applicable to financial
audits contained in Government Auditing Standards, issued by the Comptroller
General of the United States. Those standards require that we plan and perform
the audit to obtain reasonable assurance about whether the general purpose
financial statements are free of material misstatement. The financial statements
of Ashland Parks and Recreation Commission were not audited in accordance
with Government Auditing Standards. An audit includes examining, on a test
bash, evidence supporting the amounts and disclosures in the general purpose
financial statements. An audit also includes assessing the accounting principles
used and significant estimates made by management, as well as evaluating
the overall general purpose financial statement presentation. We believe
that our audit provides a reasonable basis for our opinion.
In our opinion, the general purpose f'financial statements referred to above
present fairly, in all material respects, the financial position of City
of Ashland, Jackson County, Oregon, at June 30, 2002, and the results of
its operations and cash flows of its proprietary fund types and similar trust
fund for the year then ended, in conformity with accounting principles generally
accepted in the United States of America.
In accordance with Government Auditing Standards, we have also issued our
report dated September 6, 2002, on our consideration of City of Ashland's
internal control over f'financial! reporting and our tests of its compliance
with certain provisions of laws) regulations, contracts and grants. Those
reports are an integral part of an audit performed in accordance with Government
Auditing Standards and should be read in conjunction with this report in
considering the results of our audit.
Our audit was conducted for the purpose of forming an opinion on the general
purpose financial statements of City of Ashland, Jackson County, Oregon,
taken as a whole. The accompanying schedule of expenditures of federal awards,
as listed in table of contents, is presented for purposes of additional analysis
as required by U.S. Office of Management and Budget Circular A-133, Audits
of States, Local Governments, and Non-Profit Organizations, and is not a
required part of the general purpose financial statements. The supplementary
data of combining and individual fund and account group statements and other
financial schedules, as listed in the table of contents, is presented for
purposes of additional analysis and is also not a required part of the general
purpose financial statements. Such information has been subjected to the
auditing procedures applied in the audit of the general purpose financial
statements and, in our opinion, is fairly stated, in all material respects,
in relation to the general purpose financial statements taken as a whole.
The other data included in this report, designated as the statistical section
in the table of contents, has not been audited by us; and accordingly, we
express no opinion on such data.
PAULY, ROGERS AND CO., P.C.
End of Document - Back to Top
| These are DRAFT minutes pending approval by the
Audit Committee. The Audit Committee meets again in Fall 2003. |
Audit Committee Minutes
November 1, 2002, 2:30pm
Civic Center Council Chambers, 1175 East Main Street Call to Order
Chairperson Marty Levine called the meeting to order at 2:34pm.
Call to Order
Chairperson Marty Levine called the meeting to order at 2:34pm.
Introductions
Finance Director Lee Tuneberg made introductions. Levine summarized the three
functions of the audit committee. 1) Recommend to the council an independent
firm to perform the annual audit of the City. 2) Review annual audit report
and make recommendations regarding significant findings. 3) Make recommendations
to council regarding the annual financial statements, management letter,
and response to management letter submitted by city staff.
Roll Call
Committee Members Emile Amarotico, CPA, Marty Levine, CPA and City
Recorder/Treasurer Barbara Christensen were present. Council Liaison, Mayor
Alan DeBoer and Staff Liaison, Finance Director Lee Tuneberg was present.
Staff Accounting Supervisor Joanie Baker, Staff Accountant Patrick Caldwell
and Administrative Assistant Kirsten Bakke were present. Roy Rogers, CPA
and Kenny Allen, CPA were present from Pauly, Rogers and Company, P.C. Committee
Member Roberta Stebbins, CPA was absent.
Approval of Minutes
Committee Members Amarotico/Christensen m/s to approve the February 13, 2002
audit committee minutes as written.
Presentation by the Auditors
Rogers began the presentation by distributing an executive summary of the
audit process and copies of the Management Letter. Rogers commented that
the audit process went well. He discussed the Executive Summary of the audit
process saying that they found no exceptions or significant audit adjustments.
He summarized by saying the accounting records were in good condition and
commended the staff for their assistance and support during the audit.
Tuneberg suggested that Accounting Supervisor Joan Baker respond to the
Management Letter after it was presented. Rogers pointed out that the staff
was open to suggestions and ways for improvement.
Management Letter
Rogers turned the presentation over to Allen. He began discussing the Management
Letter noting each item. He pointed out on item 1 that the bank
reconciliations were not being reviewed by anyone in the accounting department,
recommending that all bank reconciliations be reviewed and signed off by
the Finance Director or a designee other than the reconciler.
Levine recommended that Barbara Christensen review the bank statements. Tuneberg
pointed out that it should be someone in accounting who is independent of
the duties of handling the cash, doing the investments and reconciling the
bank accounts.
Allen continued, referring to item 2 two instances were noted where
the EDEN software system could not produce needed reports. He went on to
discuss item 3 saying that they noted an instance where a payroll
tax deposit was not made in a timely manner, recommending that a procedure
be put into place to ensure that all payroll tax deposits are made on time.
There was some discussion regarding the EDEN software system.
Allen went over item 4 noting that some invoices containing retainage
payable were not accounted for properly, recommending that accounting put
procedures in place to ensure that retainage does get accrued as a liability.
Amarotico asked if retainage was being recorded at all. Allen replied that
it was for some invoices, but not for others.
Rogers talked about the last two issues under Other Matters in the
Management Letter, stating that item 1 is an accounting pronouncement
from the Governmental Accounting Standards Board (GASB). He gave a brief
overview of the new financial reporting model for State and Local Governments
(GASB 34). He explained that it was more like a reporting model for a private
business. Beyond report format changes other material new requirements are
calculation of depreciation expense on fixed assets, including infrastructure,
and accrual of property taxes in the year levied. There was some discussion
regarding accrual basis accounting.
He moved on to Other Matters item 2 describing the General
Accounting Office (GAO) recently issued independence standard that will affect
the Parks Department as a component unit of the City. He said that the standard
lays out items which auditors can and cannot perform. Going into effect for
fiscal year 2003-2004, it states that we can prepare the financial statements
for our audit clients, if we assess the client and believe that the client
could prepare and understand the report on their own. He pointed out
that the standard says that auditors cant propose or make any adjusting
journal entries. The Committee discussed this further.
City Staff Response
Baker responded to the reportable conditions in the Management Letter beginning
with Item 1 saying that effective immediately the Finance Director
or a designee will review bank reconciliations on a monthly basis as
they are completed. The City has the following major bank accounts; Pool
or Local Government Investment Pool (LGIP), Concentration, City Investments,
Payroll, and Accounts Payable. The City also has minor bank accounts including
Bank of America and Wells Fargo. The City does not, at this time, reconcile
the Parks and Recreation accounts. There was discussion regarding the
Citys bank accounts. Ann Benedict Business/Personnel Manager for Parks
and Recreation spoke to the specific issues relating to the Parks bank
accounts. Tuneberg clarified the timing and scope of the consolidation of
the Parks accounting with the City.
Baker continued, moving to Item 2 the City sent two finance staff
to the annual EDEN users conference held the second week of October.
The purpose of staff attendance was to pursue reporting needs, acquire more
knowledge about the softwares capabilities, increase staffs knowledge
of the system to be able to use the software to its full capacity and
to address the need for reports, particularly the accounts payable and the
lien program reports referred to above. The City will continue to address
identified needs and pursue additional EDEN software that would be helpful
to the Finance Department.
Levine asked about the ability to print reports. Baker replied that one of
the staff went to classes on report writing using Crystal Reports and
thats where we will be able to get more out of the system.
Tuneberg detailed the challenges in employing and developing the software.
He discussed the improvements and conversions anticipated in the coming year.
DeBoer asked for the Auditors opinion regarding the EDEN software.
Rogers responded saying that they didnt see the economy and efficiency
that could be realized and a lot of records were being kept manually. Tuneberg
spoke of the evolution in the Finance Department and the effects of staff
turnover on the software conversion. Levine verified that the challenge is
to learn and implement the software. Tuneberg clarified that the software
problems were not insurmountable. There was discussion regarding the software
RFP process.
Baker continued referring to item 2 explaining the purpose networking
at the EDEN users conference and the process that staff used to bring
all issues to the table at the conference.
Tuneberg informed the Committee there were 3 conversions anticipated by June
30th that would eliminate some of the subsystems, and accommodate
miscellaneous receivables. Baker clarified that a miscellaneous receivable
was something that falls outside of the standard revenue stream. Baker commented
that Parks is currently using Springbrook software and will be treated as
a separate entity.
Baker spoke to item 3 the non-payment of the tax deposit was discovered
by finance staff while performing a routine bank reconciliation. The Accounting
Division has implemented additional procedures to ensure all payroll tax
payments are timely. The additional procedures include additional review
processes and check off lists to be initialed during payroll processing.
DeBoer asked about waving penalties. Baker said that there had been another
penalty before that the IRS wouldnt wave. She said they considered
it a clerical error. Baker said 3 times this year the federal withholding
went over $100,000 and that penalties have been involved when taxes went
over $100,000. Levine suggested routinely making one day tax deposits. Tuneberg
pointed out that a procedure had been established where an independent person
checked confirmation numbers on tax deposits and that there shouldnt
be any more issues. The discussion ensued.
Baker concluded by addressing item 4 saying that the City
recognized the difficulty with both the understanding of retainage (holding
a portion of funds due until project completion) and the coding of retainage.
Effective immediately accounting staff will review all construction project
invoices prior to accounts payable processing to assure retainage is properly
coded and set aside per contract agreement. DeBoer asked where the error
was found. Caldwell said it was found in the Library project on a Request
for Check. The payments to the contractor were accurate but the accrued liability
was not recorded. There was further discussion. Baker closed by thanking
the Auditors.
Amarotico pointed out a misspelling on the bottom of the second paragraph
on page iii. He indicated that on page vi the percentage of
food and beverage tax did match page iii. He questioned the
decrease in food and beverage tax as compared to transient tax. More discussion
followed.
Parks
Tuneberg asked if there were any questions regarding the Parks report.
Rogers passed out the Parks executive summary saying there was no management
letter. Rogers recommended that the Audit Committee review the Parks
financial report in addition to the Citys. Levine said that there was
no distinction between the Parks and the City mentioned in the Resolution.
The discussion developed and DeBoer said with Parks concurrence the Council
could amend that that ordinance. Christensen recommended appointing a member
of the Parks Commission to the Audit Committee. Tuneberg concluded that it
could be resolved this year.
Amarotico referred to a table of food and beverage taxes on page 117
saying that it was inconsistent with page vi. Tuneberg noted the correct
number as 307.
Rogers continued saying there was nothing to report on Parks. Levine asked
about merging the Citys and Parks accounting. Rogers said they
had no objections and that Springbrook is a good system. Levine asked if
they had other clients with EDEN. Rogers answered that they did not. Tuneberg
indicated that the City of Wilsonville was expanding their use of EDEN.
City Staff Response
Tuneberg thanked the Finance and Parks staff. He remarked that this was the
first time in five years that there hasnt been a technical violation
on the Budget Appropriations. He addressed some of the procedures that have
been improved such as routine monthly closings. He described the challenges
in the Finance Department and concluded by thanking the Auditors. DeBoer
asked if the Auditors time on the audit was within the scope of their
bid. Rogers affirmed that it was as anticipated. Benedict concurred with
Tuneberg that this years audit process went well.
Signing the Annual Letter
Members Amarotico/Christensen m/s to approve the Comprehensive Annual
Financial Report (CAFR) as submitted. Voice Vote: all AYES. Motion passed.
Other
DeBoer pointed out that on page xii Chris Hearn should replace David
Fine.
Adjournment
Meeting was adjourned at 4:02pm. Respectfully submitted by Kirsten Bakke,
Administrative Assistant to the Finance Director
End of Document - Back to Top
|