HomeMy WebLinkAboutAgenda Report - March 18, 2020 C-13c-13Crrv or Loor
CouNcrr ConnMUNrcATroN
AGENDA TITLE:
MEETING DATE:
PREPARED BY:
Receive for File the Following Reports and Financial Statements Submitted by The
Pun Group, LLP and the Finance Department for FY2018-2019 lncluding Single
Audit Report, Agreed-upon Procedures for the Gann Limit, and Agreed-upon
Procedures for National Transit Database
March 18,2Q20
Accounting Manager
RECOMMENDED ACTION Receive for file the following reports and financial statements
submitted by The Pun Group, LLP and the Finance Department for
Fiscal Year 2018-2019.
. Single Audit Report. Agreed-upon Procedures for the GANN Limit. Agreed-upon Procedures for National Transit Database
BACKGROUND INFORMATION: The annual audit was conducted to assure the City Council and
other interested parties that the City's financial reports are prepared
in accordance with generally accepted accounting principle (GAAP)
against loss from unauthorized use or disposition of assets and that the City has complied with all
agreements and covenants to obtain grant funds and debt financing. The Pun Group, LLP issues and
"unmodified opinion".
The agreed upon procedures for the above reports, were agreed upon by the City and the League of
California Cities and performed solely to assist in meeting the requirements of Section 1.5 of Article Xlll-B
of the California Constitution; the requirements of the Federal Transit Administration (FTA) as set forth in
its applicable National Transit Database (NTD). The agreed upon procedures engagements were
conducted in accordance with attestation standards established by the American lnstitute of Certified
Public Accountants. City's management is responsible for preparing each of the reports.
The reports will be provided to federal and State oversight agencies, bond trustees and insurance
companies for their review and evaluation. Copies of the reports are provided to the City Council and
also available to the public by contacting the Financial Services Division.
FISCAL IMPAGT: No fiscal impact.
FUNDING AVAILABLE: No funding requested
Manager
oz,
APPROVED
rew Keys,
Stephen Schwabauer, City Manager
City of Lodi
Lodi, California
Single Audit and
Independent Auditors’ Reports
For the Year Ended June 30, 2019
City of Lodi
Table of Contents
Page
Independent Auditors’ 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 ................................................................... 1
Independent Auditors’ Report on Compliance for Each Major Federal Program,
on Internal Control Over Compliance Required by the Uniform Guidance,
and on Schedule of Expenditures of Federal Awards ..................................................................................... 3
Schedule of Expenditures of Federal Awards ............................................................................................................ 7
Notes to the Schedule of Expenditures of Federal Awards ........................................................................................ 8
Schedule of Findings and Questioned Costs .............................................................................................................. 9
This page intentionally left blank
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
Independent Auditors’ Report
To the Honorable Mayor and Members of City Council
of the City of Lodi
Lodi, California
We have audited, in accordance with the 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 Controller
General of the United States, the financial statements of the governmental activities, the business-type activities, each
major fund, and the aggregate remaining fund information of the City of Lodi, California (the “City”), as of and for the
year ended June 30, 2019, and the related notes to the basic financial statements which collectively comprise the City’s
basic financial statements and have issued our report thereon dated February 10, 2020.
Internal Control Over Financial Reporting
In planning and performing our audit of the financial statements, we considered the City’s internal control over
financial reporting (internal control) to determine the audit procedures that are appropriate in the circumstances for the
purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the
effectiveness of the City’s internal control. Accordingly, we do not express an opinion on the effectiveness of the
City’s internal control.
A deficiency in internal control 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 and correct,
misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal
control, such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will
not be prevented, or detected and corrected on a timely basis. A significant deficiency is a deficiency, or a combination
of deficiencies, in internal control that is less severe than a material weakness, yet is important enough to merit
attention by those charged with governance.
Our consideration of internal control was for the limited purpose described in the first paragraph of this section and
was not designed to identify all deficiencies in internal control that might be material weaknesses or significant
deficiencies and therefore, material weaknesses or significant deficiencies may exist that have not been identified. We
did identify certain deficiencies in internal control, described in the accompanying Schedule of Findings and
Questioned Costs as item 2019-001, 2019-002, 2019-003, 2019-004, and 2019-005 that we consider to be material
weaknesses.
2121 North California Blvd., Suite 290, Walnut Creek, California 94596
Tel: 925-974-3394 • Fax: 949-777-8850
www.pungroup.com
3939352 Pun & McGeady_L_final.pdf 3 1/14/14 3:48 PM
To the Honorable Mayor and Members of City Council
of the City of Lodi
Lodi, California
Page 2
2
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the City’s basic financial statements are free from 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 opinion on compliance with those provisions was not an objective of our
audit, and accordingly, we do not express such an opinion.
Response to Findings
The City’s responses to the findings identified in our audit is described in the accompanying Schedule of Findings and
Questions Costs. The City’s response was not subjected to the auditing procedures applied in the audit of the basic
financial statements and, accordingly, we express no opinion on it.
Purpose of this Report
The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the
results of that testing, and not to provide an opinion on the effectiveness of the City’s internal control or on
compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in
considering the entity’s internal control and compliance. Accordingly, this communication is not suitable for any other
purpose.
Walnut Creek, California
February 10, 2020
REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM,
ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY THE
UNIFORM GUIDANCE, AND ON SCHEDULE OF EXPENDITURS OF FEDERAL AWARDS
Independent Auditors’ Report
To the Honorable Mayor and Members of City Council
of the City of Lodi
Lodi, California
Report on Compliance for Each Major Federal Program
We have audited the City of Lodi, California’s (the “City”) compliance with the types of compliance requirements
described in the OMB Compliance Supplement that could have a direct and material effect on each of the City’s major
federal programs for the year ended June 30, 2019. The City’s major federal programs are identified in the summary of
the auditors’ results section of the accompanying schedule of findings and questioned costs.
Management’s Responsibility
Management is responsible for compliance with federal statutes, regulations, and terms and conditions of federal
awards applicable to its federal programs.
Auditors’ Responsibility
Our responsibility is to express an opinion on compliance for each of the City’s major federal programs based on our
audit of the types of compliance requirements referred to above. We conducted our audit of compliance in accordance
with auditing standards generally accepted in the United States of America; the standards applicable to financial audits
contained in Government Auditing Standards, issued by the Controller General of the United States; and the audit
requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost
Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Those standards and the Uniform
Guidance 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 on compliance for each major federal program.
However, our audit does not provide a legal determination of the City’s compliance.
Opinion on Each Major Federal Program
In our opinion, the City complied, in all material respects, with the compliance requirements referred to above that
could have a direct and material effect on each of its major federal programs for the year ended June 30, 2019.
2121 North California Blvd., Suite 290, Walnut Creek, California 94596
Tel: 925-974-3394 • Fax: 949-777-8850
www.pungroup.com
3939352 Pun & McGeady_L_final.pdf 3 1/14/14 3:48 PM
To the Honorable Mayor and Members of City Council
of the City of Lodi
Lodi, California
Page 2
4
Other Matters
The results of our auditing procedures disclosed instances of noncompliance which are required to be reported in
accordance with the Uniform Guidance and which are described in the accompanying Schedule of Findings and
Questioned Costs as item 2019-006. Our opinion on each major federal program is not modified with respect to these
matters.
The City’s response to the noncompliance findings identified in our audit is described in the accompanying Schedule
of Findings and Questioned Costs. The City’s response was not subjected to the auditing procedures applied in the
audit of compliance and, accordingly, we express no opinion on the response.
Report on Internal Control Over Compliance
Management of the City is responsible for establishing and maintaining effective internal control over compliance with
the types of compliance requirements referred to above. In planning and performing our audit of compliance, we
considered City’s internal control over compliance with the types of requirements that could have a direct and material
effect on each major federal program to determine the auditing procedures that are appropriate in the circumstances for
the purpose of expressing an opinion on compliance for each major federal program and to test and report on internal
control over compliance in accordance with the Uniform Guidance, 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 City’s internal control over compliance.
A deficiency in internal control over compliance exists when the design or operation of a control over compliance does
not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect
and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. A material
weakness in internal control over compliance is a deficiency, or combination of deficiencies, in internal control over
compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance
requirement of a federal program will not be prevented, or detected and corrected, on a timely basis. A significant
deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in internal control over
compliance with a type of compliance requirement of a federal program that is less severe than a material weakness in
internal control over compliance, yet important enough to merit attention by those charged with governance. We did
identify certain deficiencies in internal control, described in the accompanying Schedule of Findings and Questioned
Costs as item 2019-06 that we consider to be a significant deficiency.
Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of
this section and was not designed to identify all deficiencies in internal control over compliance that might be material
weaknesses or significant deficiencies. We did not identify any deficiencies in internal control over compliance that we
consider to be material weaknesses. However, material weaknesses may exist that have not been identified.
The City’s response to the internal control over compliance findings identified in our audit is described in the
accompanying Schedule of Findings and Questioned Costs. The City’s response was not subjected to the auditing
procedures applied in the audit of compliance and, accordingly, we express no opinion on the response.
The purpose of this report on internal control over compliance is solely to describe the scope of our testing of internal
control over compliance and the results of that testing based on the requirements of the Uniform Guidance.
Accordingly, this report is not suitable for any other purpose.
5
To the Honorable Mayor and Members of City Council
of the City of Lodi
Lodi, California
Page 3
Schedule of Expenditures of Federal Awards
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 as of and for the year ended June 30, 2019, and have issued
our report thereon dated February 10, 2020 which contained unmodified opinions on those financial statements. Our
audit was conducted for the purpose of forming our opinions on the City’s Basic Financial Statements. The
accompanying Schedule of Expenditures of Federal Awards, as required by Title 2 U.S. Code of Federal Regulations
Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, is
presented for purposes of additional analysis and is not a required part of the financial statements. Such information is
the responsibility of management and was derived from and relates directly to the underlying accounting and other
records used to prepare the financial statements. The information has been subjected to the auditing procedures applied
in the audit of the basic financial statements and certain other procedures, including comparing and reconciling such
information directly to the underlying accounting and other records used to prepare the financial statements or to the
financial statements themselves, and other additional procedures in accordance with auditing standards generally
accepted in the United States of America. In our opinion, the Schedule of Expenditures of Federal Awards is fairly
stated in all material respects in relation to the basic financial statements as a whole.
Walnut Creek, California
February 10, 2020
6
This page intentionally left blank
City of Lodi
Schedule of Expenditures of Federal Awards
For the Year Ended June 30, 2019
7
Federal Grant
CFDA Identification Federal
Number Number Expenditures
U.S. Department of Housing and Urban Development
CDBG - Entitlement Grants Cluster
Direct Program:
Community Development Block Grant 14.218 B-14-MC-06-0038 14,222$
Community Development Block Grant 14.218 B-15-MC-06-0038 17,663
Community Development Block Grant 14.218 B-16-MC-06-0038 154,907
Community Development Block Grant 14.218 B-17-MC-06-0038 194,688
Community Development Block Grant 14.218 B-18-MC-06-0038 501,544
Total CDBG - Entitlement Grants Cluster 883,024
Total U.S. Department of Housing and Urban Development 883,024
U.S. Department of Transportation
Direct Program:
Edward Byrne Memorial Justice Assistance Grant Program 16.738
2018-DJ-BX-0641 23,496
Passed through California Office of Traffic Safety:
Bulletproof Vest Partnership 16.607
1121-0235 19,613
Total U.S. Department of Transportation 43,109
U.S. Department of Transportation
Federal Transit Cluster
Direct Program:
Federal Transit - Formula Grants 20.507
CA-2019-106 1,400,000
Total Federal Transit Cluster 1,400,000
Highway Planning and Construction Cluster
Passed through California Department of Transportation:
Highway Planning and Construction 20.205
STPL-5154(047)1,097,182
Highway Planning and Construction 20.205
STPL-5154(043)842,224
Total Planning and Construction Cluster 1,939,406
Passed through California Office of Traffic Safety:
Minimum Penalties for Repeat Offenders for DWI 20.608
PT19059 98,846
Total U.S. Department of Transportation 3,438,252
U.S. Environmental Protection Agency
Direct Program:
Title III - NSIP C1 Incentive 66.818
99T30201 213,526
Total U.S. Environmental Protection Agency 213,526
Total Expenditures of Federal Awards 4,577,911$
Federal Grantor/Pass - Through
Grantor/Program Title
See accompanying Notes to the Schedule of Expenditures of Federal Awards.
City of Lodi
Notes to the Schedule of Expenditures of Federal Awards
For the Year Ended June 30, 2019
8
Note 1 – Reporting Entity
The financial reporting entity, as defined by the Governmental Accounting Standard Board (“GASB”), consists of the
primary government, which is the City of Lodi, California (the “City”), organizations for which the primary
government is financially accountable, and other organizations for which the nature and significance of their
relationship with the primary government are such that exclusion would cause the reporting entity’s financial
statements to be misleading or incomplete.
Note 2 – Basis of Accounting
Funds received under the various grant programs have been recorded within the governmental and proprietary fund
types of the City. The City utilizes the modified accrual method of accounting for the governmental fund types and the
full accrual method of accounting for the proprietary fund types. The accompanying Schedule of Expenditures of
Federal Awards (“Schedule”) is presented in accordance with the requirements of Title 2 U.S. Code of Federal
Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal
Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from amounts presented
in, or used in, the preparation of the City’s basic financial statements.
Note 3 – Schedule of Expenditures of Federal Awards
The accompanying Schedule presents the activity of all federal financial assistance programs of the City. Federal
financial assistance received directly from federal agencies as well as federal financial assistance passed through the
State of California is included in the Schedule. The Schedule was prepared from only the accounts of various grant
programs and, therefore, does not present the financial position, change in fund balance, or results of operations of the
City.
Note 4 – Indirect Cost Rate
The City has not elected to use the 10-percent de minimis indirect rate as allowed under the Uniform Guidance.
City of Lodi
Schedule of Findings and Questioned Costs
For the Year Ended June 30, 2019
9
Section I – Summary of Auditor’s Results
Financial Statements
Type of report the auditors issued on whether the financial
statements audited were prepared in accordance with GAAP: Unmodified
Internal control over financial reporting:
Material weakness(es) identified? Yes, 2019-001, 2019-002,
2019-003, 2019-004,
2019-05
Significant deficiency(ies) identified? No
Noncompliance material to financial statements noted? No
Federal Awards
Internal control over major programs:
Material weakness(es) identified? No
Significant deficiency(ies) identified? Yes, 2019-006
Type of auditor’s report issued on compliance for major programs Unmodified
Any audit findings disclosed that are required to be reported in
accordance with 2 CFR 200.516(a)? 2019-006
Identification of major programs:
CFDA Number(s) Name of Federal Program or Cluster Expenditures
20.507 Federal Transit Cluster 1,400,000$
Total Expenditures of All Major Federal Programs 1,400,000$
Total Expenditures of Federal Awards 4,577,911$
Percentage of Total Expenditures of Federal Awards 30.58%
Dollar threshold used to distinguish between type A and type B program $750,000
Auditee qualified as low-risk auditee in accordance with 2 CFR 200.520? Yes
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
10
Section II – Financial Statement Findings
A. Current Year Findings – Financial Statement Audit
Finding 2019-001 Improve Internal Controls Over Financial Reporting
Criteria:
Management is responsible for the preparation and fair presentation as well as the accuracy of its financial
statements including disclosures in accordance with accounting principles generally accepted in the United States
of America; this includes the design, implementation, and maintenance of internal control relevant to the
preparation and fair presentation of financial statements that are free from material misstatement, whether due to
fraud or error. As part of satisfying that responsibility, staff should possess that skills, knowledge, and experience
necessary to complete year-end close and diligently employ that knowledge, skill, and experience to produce
reliable and accurate financial information.
Generally accepted auditing standards defined internal control as a process – affected by the Members of City
Council, management, and other personnel – designed to provide reasonable assurance regarding the achievement
of objectives in the following categories:
Reliability of financial reporting
Effectiveness and efficiency of operations, and
Compliance with applicable laws and regulations.
The Committee of Sponsoring Organizations of the Treadway Commission (“COSO”) established the following
framework that stress the need for policies and procedures to promote effective internal control for an entity:
Control Environment – Establish structures, reporting lines, authorities and responsibilities
Control Activities – Select and develop control activities that mitigate risks
Control Activities – Deploy control activities through policies and procedures
Information and Communication – Communicate internal control information internally
Monitoring – Evaluations are used to determine if controls are present and functioning
An overall purpose of internal control over financial reporting is to foster the preparation of reliable financial
statements. Reliable financial statements must be materially accurate.
Condition:
During the audit, we noted the following conditions that resulted in material audit adjustments to the financial
statements:
Accuracy in External Financial Reporting
The year-end closing process was not thorough and did not ensure that account balances were reconciled and
accurate in advance of the audit requiring a significant number of adjusting journal entries to correct the
financial statements. It appears these errors were primarily caused because the trial balance was prepared from
data that was not complete, contained errors and appropriate year-end reconciliations were not performed.
Some of the more significant entries were as follows:
Discounts to low-income customers were not reflected in the Electric Utility Fund (Approximately
$500,000).
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
11
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-001 Improve Internal Controls Over Financial Reporting (Continued)
Accuracy in External Financial Reporting (continued)
Adjustment to reconcile capital assets was needed (Approximately $15.6 million).
Allocate accrued payroll by fund (Approximately $1.5 million).
Adjust interest payable (Approximately $1.2 million).
Adjustments were made to reconcile bond premium and deferred amount on refunding of debt
(Approximately $996,000).
CDBG Grant Receivable was understated (Approximately $505,000).
Record unearned revenue in various funds (Approximately $934,000).
Amounts were recorded to reclassify negative cash (Approximately $1.0 million).
Bank Reconciliation
The City’s monthly bank reconciliation process was not completed in a timely manner during the period of the
audit. During our review of the bank reconciliation process, we found that all of the fiscal year 2018-19 bank
reconciliations had not been finalized. In addition, there were unreconciled difference in the amount of
approximately $563,000 that could not be identified. The City was able to subsequently identify and reconcile the
amounts. The most significant unreconciled difference was a payroll posting error that caused accounts payable
and cash to both be overstated.
Revenue, Receivables, and Cash Receipts
The internal control procedures as described and documented included segregation of duties within the cash receipt
process. However, in certain instances we were unable to verify that the review process existed because signatures
and/or any type of documentation or evidence to identify which personnel specifically reviewed and released the
cash receipt batches were not available. We found four (4) out of the twenty-five (25) batches selected for testing
were appropriately stamped and signed-off by the CSR Supervisor indicating the review and release process had
taken place.
Payroll
During our consideration of internal controls over payroll, we found that ten (10) out of the twenty-five (25)
timesheets or timecards that were selected for testing for proper authorization, were missing the required
approvals.
Context:
Various financial statement amounts were not accurate and were either under or overstated by a material amount
after the audit began and the books were closed. Misstatements in financial statements are material when they can
reasonably be expected to influence the decisions taken based on those financial statements and exceed the level of
tolerable misstatements.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
12
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-001 Improve Internal Controls Over Financial Reporting (Continued)
Effect:
Reconciliations and adjustments to year end balances that either are not recorded or are posted after the preparation
of fiscal year end reports decrease the reliability and usefulness of the reports. In addition, not following formal
policies and procedures regarding internal control over individual transaction cycles could lead to inconsistency in
processing transactions and also increases the risk that errors will not be detected and corrected in a timely manner.
Cause:
The City has experienced significant turnover in key personnel in the City’s finance department in past years.
Absent robust accounting policies and procedures, when vacancies occur information can be lost and as
individuals are getting up to speed, some processes may not be fully executed if they are manual and not fully
embedded into an automated system. In addition, the City experienced a Ransomware attack late in the year.
During our testing period alternative processes had to be employed while the systems were restored. This caused
different processes to be followed which was not necessarily consistent with the documented processes. Staff had
to take on additional responsibilities and did not have sufficient resources to properly review and reconcile the sub-
ledger to the general ledger to ensure the accuracy of the financials.
Recommendation:
We recommend that the City put in place procedures in order to reduce the amount of material journal entries and
errors found after the closing process and reduce the risk of errors in the preparation of the City’s Comprehensive
Annual Financial Report. This should contemplate if there are sufficient resources not only available to prepare a
complete set of financial statements but to provide a review process in order to detect errors prior to delivery for
the audit. In addition, the City should contemplate whether additional personnel are needed in order to enhance its
review processes for internal control over the financial reporting and within each transaction cycle to ensure that
they are thoroughly evaluated, reviewed and recorded in order to facilitate the accurate and complete year-end
closing of the general ledger.
View of Responsible Officials:
The City concurs with the recommendation. New procedures including additional checks and balances have been
put in place to ensure more accurate closing, reconciliations, cash receipting and payroll processes. New
procedures have been drafted by an outside industry expert to ensure better processing of bank reconciliations.
New restrictions have been placed in Munis so no batches will automatically release without review. In addition,
all batch paperwork will be stamped released, with the date, and the signature/initials of the one release the batch
for posting. Training to departments on timesheet management will be provided by the end of the current fiscal
year. City will also be implementing workflow processes and moving to Employee Self Service for time
management of employees.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
13
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-002 Capital Asset Accounting – Multi-Year Projects
Criteria:
Accounting principles generally accepted in the United States of America (GAAP), as prescribed by the
Governmental Accounting Standards Board, require entities to track and record the original cost of capital assets
and to calculate depreciation on certain of those capital assets and expense the costs over their useful life from the
date placed in service.
Condition:
During our review of the capital assets schedules and the detail additions report, we found that the Construction-in-
Progress (CIP) additions consisted of both CIP additions in the current year and CIP additions from prior years.
The prior year additions were related to the costs of certain multi-year capital projects in CIP and / or completed
Asset along with the related depreciation expense that were not capitalized when the assets were placed in service.
These projects should have been capitalized in prior years. The projects included a storage pond, electric screen in
the Wastewater fund ($108,145), Phase 7 of the Water Meter project in the Water Fund ($549,219), and facility
upgrades, bus stop shelter, and equipment in the Transit Fund ($398,669). Because these capital outlay costs
spanned multiple years but were expensed as opposed to being capitalized, capital assets and net position were
understated in prior years by a material amount.
Context:
A total of $1.3 million was recorded as an increase in net position in the governmental activities and business type
activities on the government-wide financial statements.
Effect:
The detailed capital assets schedules contained errors and were not reconciled to the capital outlay accounts on an
annual basis. Information obtained from the related department also did not possess accurate tracking of capital
assets and therefore were incorrectly reported to the Finance Department.
Recommendation:
We recommend that the City establish procedures to periodically reconcile the capital outlay accounts to the asset
additions report and project expenditure reports to ensure that all capital outlay is captured as an addition in the
current year, if it meets the City’s capitalization threshold, or expensed.
View of Responsible Officials:
The City concurs with the recommendation. Additional review layers have been put in place to be ensure all
completed capital projects are captured each year from the departments responsible for delivering the capital asset.
Accounting will verify cost associated with the capital asset, including any invoices that cross fiscal years, to
ensure all cost are captured.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
14
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-003 Capital Asset Accounting and Valuation – Electric Utility Lines
Criteria:
Accounting principles generally accepted in the United States of America (GAAP), as prescribed by the
Governmental Accounting Standards Board, require entities to track and record the original cost of capital assets
and to calculate depreciation on certain of those capital assets and expense the costs over their useful life from the
date placed in service.
Electric public utilities and licensees within the Federal Energy Regulatory Commission jurisdiction are required
to maintain their books and records in accordance with the Commission's Uniform System of Accounts (CUSA).
Though not GAAP for local electric utilities, the CUSA provides useful information on the basics of accounting
for transmission and distribution systems including public utilities.
A transmission system means (1) All land, conversion structures, and equipment employed at a primary source of
supply (i.e., generating station, or point of receipt in the case of purchased power) to change the voltage or
frequency of electricity for the purpose of its more efficient or convenient transmission; (2) All land, structures,
lines, switching and conversion stations, high tension apparatus, and their control and protective equipment
between a generating or receiving point and the entrance to a distribution center or wholesale point; and (3) All
lines and equipment whose primary purpose is to augment, integrate or tie together the sources of power supply. A
distribution system means all land, structures, conversion equipment, lines, line transformers, and other facilities
employed between the primary source of supply (i.e., generating station, or point of receipt in the case of
purchased power) and of delivery to customers, which are not includible in transmission system, whether or not
such land, structures, and facilities are operated as part of a transmission system or as part of a distribution system.
Plant inventory record means company plant records for retirement units and mass property that provide, as either
a single record, or in separate records readily obtainable by references made in a single record, the following
information for each retirement unit: (1) the name or description of the unit, or both; (2) the location of the unit;
(3) the date the unit was placed in service; (4) the cost of the unit; and (5) the control account to which the cost of
the unit is charged.
Each utility shall record all construction and retirements of electric plant by means of work orders or job orders.
Separate work orders may be opened for additions to and retirements of electric plant or the retirements may be
included with the construction work order, provided, however, that all items relating to the retirements shall be
kept separate from those relating to construction and provided, further, that any maintenance costs involved in the
work shall likewise be segregated. Each utility shall keep its work order system to show the nature of each addition
to or retirement of electric plant, the total cost thereof, the source or sources of costs, and the electric plant account
or accounts to which charged or credited. Work orders covering jobs of short duration may be cleared monthly. In
the case of major utilities, each utility shall maintain records in which, for each plant account, the amounts of the
annual additions and retirements are classified to show the number and cost of the various record units or
retirement units.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
15
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-003 Capital Asset Accounting and Valuation – Electric Utility Lines (Continued)
Condition:
The City’s plant inventory records as of June 30, 2019 and in prior years for the City’s electric utility lines
contained insufficient data to determine the unit, location of the unit, date the unit was placed in service, and actual
cost of the unit. In past years, the City had accounted for all miles of utility line as one unit using a single
replacement cost for all miles of line. The units of additions and repairs that extended the useful life of existing
lines, additions for expansion of the current system for new lines, the retirements of existing line replaced, and the
actual cost based on work order system was not being used and accounted for in the detailed inventory records for
the City.
In addition, in our sample of the work order system used to determine the actual cost of the replacement of the
utility lines in the current year included duplicate charges for the materials used in the project. Meaning the
materials were expensed twice to the project accounting record. The impact of the duplicate charges results in an
understatement of the ending inventory for materials relieved to the job cost report that are still held by the Electric
Utility. Because periodic inventories are taken, there are large accounting adjustments being made to account for
the actual physical inventory counts taken which offsets the understatement. However, in a perpetual materials
inventory accounting system, we would not expect these large variations to occur in materials inventory.
Context:
The years in which lines were placed in service were not available from data within the system and detailed
inventory reports. Only a unit replacement cost was used and had not been updated in five or more years resulting
in a grossly undervalued inventory of utility lines ($8.9 million) and related accumulated depreciation ($4.9
million). The work order/job cost ledger did not contain reliable costs accounting information due to the duplicate
entries made. This appeared to be a systematic error across all work orders.
Effect:
The overall effect is that capital assets and net position were understated by a material amount in the Utility Fund
and Business-Type Activities financial statements in prior years.
Recommendation:
We recommend the City implement a work order system to show the nature of each addition to or retirement of
electric plant, the total cost thereof, the source or sources of costs, and the electric plant account or accounts to
which charged or credited. Work orders covering jobs of short duration may be cleared monthly. In the case of
major utilities, each utility shall maintain records in which, for each plant account, the amounts of the annual
additions and retirements are classified to show the number and cost of the various record units or retirement units.
This information should be maintained by the department and reconciled with the Finance Department for use in
the capital asset accounting.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
16
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-003 Capital Asset Accounting and Valuation – Electric Utility Lines (Continued)
View of Responsible Officials:
The City concurs with the recommendation. This was a long-standing issue. The report has been updated and the
electric utility has updated its procedure to keep a better count of line units and update its cost annually. New
replacement cost is determined for each project completed and accounting/department will ensure that all work
papers are reflecting the new cost of the project.
The City has made changes to warehouse operations that ensure inventory is checked out and back in timely to job
beginning and completion. The City is currently exploring work order software to enhance these process and
control improvements.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
17
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-004 Establish a Comprehensive Set of Safeguards over Cyber Security
Criteria:
Cybersecurity is computer security that provides the protection of computer systems and networks from the theft
of or damage to their hardware, software, or electronic data, as well as from the disruption or misdirection of the
services they provide with a focus on technical controls or safeguards, data location, criticality, risk exposure, and
an attack and defend mindset. Information technology general computer controls are part of an overall program
but are not a comprehensive set of safeguards designed to protect information assets from breach or compromise.
The National Institute of Standards and Technology (NIST), Framework for Improving Critical Infrastructure
Cybersecurity, Version 1.1 (April 2018) is one framework that provides a common language for understanding,
managing, and expressing cybersecurity risk to internal and external stakeholders. It can be used to help identify
and prioritize actions for reducing cybersecurity risk, and it is a tool for aligning policy, business, and
technological approaches to managing that risk. It can be used to manage cybersecurity risk across entire
organizations, or it can be focused on the delivery of critical services within an organization. The Framework
Core, which consists of five functions – identify, protect, detect, respond and recover - provides a set of activities
to achieve specific cybersecurity outcomes, and references examples of guidance to achieve those outcomes. There
are other frameworks outside of NIST that also provide standards for protection.
Condition:
In April 2019, the City was impacted by a Ransomware attack after a staff member clicked on an email
attachment. Ransomware is a malicious software, or “malware” attack that threatens to publish or block access to
a computer, a computer system’s files or data until a ransom is paid. The email that was inadvertently opened
contained “malware” that was spread through the city’s network of computers. This “malware” encrypted critical
files that interrupted several key phone lines and critical accounting systems within the Finance Department.
Along with the “malware”, the unidentified attackers demanded the City pay a “Bitcoin” ransom in exchange for
the encryption keys, like passwords, that would release the servers, systems, and underlying data. Bitcoin, as an
unregulated form of virtual currency, has become the most popular method for demanding ransom because
transactions are anonymous. The hackers demanded a ransom of 75 Bitcoins (estimated at approximately $400,000
at the time) to be paid to restore systems. The City opted instead to restore systems from their normal system
backups relying on established controls to protect critical data.
Context:
Though little to no data was lost as a result of the attack, the attack exposed that the City lacked procedures to
provide adequate protection of computer systems and networks from theft and or damage. Vulnerabilities clearly
existed within the City’s security and access controls, training, and other areas that allowed outside attackers to
access the City’s systems in a way that gave them the capabilities to sufficiently deploy malware intended to bring
down and compromise critical systems, including those systems needed for financial accounting and reporting.
Effect:
Internal controls over financial reporting were compromised while critical accounting systems within finance
could not be completely restored for approximately 6 weeks. Contingency plans for manual processing were
deployed in order to mitigate the loss of system usage which are often inefficient. Though contingency plans
functioned during this timeframe, the City was exposed to other financial risks while the internal controls were not
functioning in an automated environment such as manual overrides, processes that do not conform to policy, and
potential misstatement due to the loss of data.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
18
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-004 Establish a Comprehensive Set of Safeguards over Cyber Security (Continued)
Recommendation:
There are many simple and effective steps cities can take to avoid vulnerabilities and reinforce cybersecurity best
practices as follows:
Establish a common language for communicating cybersecurity risks across the organization
Adopt a Cybersecurity Framework that is aligned with the organization’s objectives
Ensure the cybersecurity program is adequately funded and resourced
Identify one individual to be responsible for cybersecurity programs
Make digital hygiene an institutional priority
Promote cybersecurity awareness and user responsibilities
Conduct an analysis and develop a risk ledger of local government vulnerabilities
Ensure data is properly backed up
Implement multi-factor authentication
Create policies or plans to manage potential attacks including periodic penetration testing, controlled
phishing campaigns and other procedures to identify gaps and take corrective action
Ensure public communication is part of your attack response plan
View of Responsible Officials:
The City concurs with the recommendation. The City has moved ERP resources to the cloud, and is in the process
of upgrading firewalls, email filters, virus protection and penetration testing. The City is also working to develop
better written disaster response plans. The $500,000 grant received from the State of California should help to
implement some measures in this area.
The City has continually improved networking, cybersecurity and data protection methods over the past year. In
2018 and 2019 the City had initiated a series of projects that have improved overall network reliability and
security. Many systems were first deployed in 2016 when the City launched a new data center that introduced an
improved network design, data storage and virtualization environment. Since the launch of the new data center the
City has initiated or is in the process of migrating services to newer security appliances, data protection services
and cyber security and awareness training for employees. The City has either fully migrated services to, or is in
the execution phase of, migrating the following devices and services:
Back up appliance with cloud-based storage and recovery points
Firewalls in high availability featuring software defined networking
New training and awareness services for employees
New email filtering and data protection services
New network monitoring and behavioral base threat detection
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
19
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-005 Accounting for Sick Leave Conversion Bank
Criteria:
Under Governmental Accounting Standards Board Statement (“GASB”) No. 16, Accounting for Compensated
Absences sick leave and other compensated absences with similar characteristics should be accrued as a liability as
the benefits are earned by the employees but only to the extent it is probable that the employer will compensate the
employees for the benefits through cash payments conditioned on the employees' termination or retirement
("termination payments"). Alternatively, the liability should be measured based on the sick leave and other
compensated absences with similar characteristics accumulated at the balance sheet date for those employees who
currently are eligible to receive termination payments as well as other employees who are expected to become
eligible in the future to receive such payments. When the liability is calculated, these accumulations should be
reduced to the maximum amount allowed as a termination payment.
Condition:
The City offers sick leave conversion benefits to certain eligible retirees. Eligible retirees may choose between
conversion option or bank option for accumulated but unused sick leave amounts. Under the conversion option,
accumulated unused sick leave is converted to a period during which the City will pay for a retiree’s health
premiums. The amount of premium paid by the City each year shall be the same amount as paid at the time of
retirement. Retirees are responsible for paying for future increases in the health premiums. Under the bank
option, accumulated unused sick leave is converted to a dollar amount and becomes the employee’s “Bank”.
Medical premiums are paid out of this account until it is depleted. Accumulated unused sick leave under the
conversion option is accounted for under GASB No. 75, Accounting and Financial Reporting for Postemployment
Benefits Other Than Pensions whereas accumulated unused sick leave benefits under the bank option should be
accounted for under GASB No. 16, Accounting for Compensated Absences.
Upon implementation of GASB No. 75, the City inadvertently removed the accumulated unused sick leave under
the bank option from the long-term liabilities in the financial statements because the bank option was thought to be
included in the GASB No. 75 actuarially determined liability. The Finance Department was unaware that a
separate actuarial report had been obtained to determine the value of the bank option benefits under GASB No. 16.
Context:
Long-term liabilities for compensated absences for the sick leave bank option as of June 30, 2019 and 2018 was
$8.1 million and $8.5 million, respectively.
Effect:
Net position on the government-wide financial statement was overstated by $8.5 million as of the beginning of the
year. The preparation of the government-wide financial statement in the current year had understated net position
by $8.1 million. Both were materially misstated, and an audit adjustment was made to correct the error.
Recommendation:
The Finance Department should, in collaboration with human resources, perform a thorough review of all
collective bargaining agreements to ensure that any compensation related benefits are properly identified,
cataloged and accounted for under generally accepted accounting principles.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
20
Section II – Financial Statement Findings (Continued)
A. Current Year Findings – Financial Statement Audit (Continued)
Finding 2019-005 Accounting for Sick Leave Conversion Bank
View of Responsible Officials:
The City concurs with the recommendation. The City is aware of this issue and will have this correctly allocated in
the Fiscal Year 2019-20 CAFR.
B. Prior Year Findings – Financial Statement Audit
No findings were noted on the City’s financial statement audit for the year ended June 30, 2018.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
21
Section III – Federal Award Findings (Continued)
A. Current Year Findings and Questioned Costs – Major Federal Award Program Audit
Finding 2019-006 Procurement, Suspension, and Debarment
Program:
Federal Transit - Formula Grants (CFDA Number 20.507, U.S. Department of Transportation)
Criteria:
Suspension and Debarment - Non-Federal entities are prohibited from contracting with or making subawards under
covered transactions to parties that are suspended or debarred. “Covered transactions” include those procurement
contracts for goods and services awarded under a non-procurement transaction (e.g., grant or cooperative
agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR
section 180.220. All non-procurement transactions entered into by a recipient (i.e., subawards to subrecipients),
irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR
section 180.215.
When a non-Federal entity enters into a covered transaction with an entity at a lower tier, the non-Federal entity
must verify that the entity, as defined in 2 CFR section 180.995 and agency adopting regulations, is not suspended
or debarred or otherwise excluded from participating in the transaction. This verification may be accomplished by
(1) checking the System for Award Management (“SAM”) Exclusions maintained by the General Services
Administration (GSA) and available at https://www.sam.gov/portal/public/SAM/ (Note: The OMB guidance at 2
CFR part 180 and agency implementing regulations still refer to the SAM Exclusions as the Excluded Parties List
System (EPLS)), (2) collecting a certification from the entity, or (3) adding a clause or condition to the covered
transaction with that entity (2 CFR section 180.300).
Condition:
During our testing of the Federal Transit - Formula Grants, the City could not provide the supporting documents
demonstrating the department verified the project contractor selected for testing was not debarred from receiving
federal funding prior to awarding the vendor the contract. Though the vendor was licensed in California, their
registration had been inactive in SAM for more than a year. Therefore, information was not available within the
system.
Questioned Costs:
Total expenditures paid to the vendor for the contract was $402,202.
Context:
See condition above for context of the finding.
Effect:
Without verifying whether vendors are suspended or debarred from working on federally-funded projects prior to
the contract awarded, the City could be contracting with vendors that are prohibited from working on federally
funded projects.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
22
Section III – Federal Award Findings (Continued)
A. Current Year Findings and Questioned Costs – Major Federal Award Program Audit (Continued)
Finding 2019-006 Procurement, Suspension, and Debarment (Continued)
Cause:
The City does not have formal policies and process in maintaining proper documentation in regards to their
suspension, and debarment review process over vendors that the City contracted with federally-funded projects.
Identification as a Repeat Finding, if Applicable:
Not applicable.
Recommendation:
We recommended the City retain documentation of the monitoring of the suspension, and debarment process
through a checklist in the vendor files to ensure vendors are not suspended or debarred from federally-funded
purchases.
View of Responsible Officials:
The City concurs with the recommendation. The staff responsible for review SAM registrations have been
educated on the importance of reviewing for contractor registration in addition to agency registration.
Management feels this is a onetime occurrence that with proper training of current and future staff should not
occur again.
City of Lodi
Schedule of Findings and Questioned Costs (Continued)
For the Year Ended June 30, 2019
23
Section III – Federal Award Findings (Continued)
B. Prior Year Findings and Questioned Costs – Major Federal Award Program Audit
Finding 2018-001 Procurement Policy
Condition:
The City has not updated its purchasing policies and procedures to bring it into compliance with the requirements
of Uniform Guidance. The City has also not formally documented whether it has decided to extend its applicable
date of compliance with 2 CFR part 200 to be effective beginning July 1, 2018.
Effect:
The City is not in compliance with the procurement policy provisions of 2 CFR part 200 and the Uniform
Guidance. Not updating the City’s procurement policy could lead to future findings and questioned costs related to
federal awards. The current audit did not identify noncompliance with direct and material compliance requirements
of the major federal award program.
Recommendation:
The City should evaluate and update existing purchasing policies and procedures in order to bring the City into
compliance with the procurement policy requirements of 2 CFR part 200 and the Uniform Guidance. The updated
policy should include, among other things:
1. Thresholds and appropriate approval procedures for allowable federal procurement methods.
2. Written standards for how conflicts of interest involving employees engaged to select, award, and
administer contracts will be governed.
3. How to ensure that contracts and awards are made only to responsible and eligible contractors and how
oversight of contractor performance will be monitored.
4. How records will be maintained in order to document the history of federal procurements.
Status:
Finding has been implemented subsequent to June 30, 2019.
24
This page intentionally left blank.
City of Lodi
Lodi, California
Independent Accountants’ Report on
Agreed-Upon Procedures Applied to
Appropriations Limit Schedule
For the Year Ending June 30, 2020
INDEPENDENT ACCOUNTANTS’ REPORT ON
APPLYING AGREED-UPON PROCEDURES
To the Honorable Mayor and Members of City Council
of the City of Lodi
Lodi, California
We have performed the procedures enumerated below to the accompanying Appropriations Limit Schedule of the
City of Lodi, California (the “City”), for the year ending June 30, 2020. These procedures, which were agreed to by
the City and the League of California Cities (as presented in the publication entitled Agreed-upon Procedures
Applied to the Appropriations Limitation Prescribed by Article XIII-B of the California Constitution), were
performed solely to assist you in meeting the requirements of Section 1.5 of Article XIII-B of the California
Constitution. The City’s management is responsible for the Appropriations Limit Schedule. This agreed-upon
procedures engagement was conducted in accordance with attestation standards established by the American Institute
of Certified Public Accountants. The sufficiency of these procedures is solely the responsibility of those parties
specified in this report. Consequently, we make no representation regarding the sufficiency of the procedures
described below either for the purpose for which this report has been requested or any other purpose.
The procedures performed and our findings are described below:
1. We obtained the completed worksheets used by the City to calculate its appropriations limit for the year
ending June 30, 2020 and compared the limit and annual calculation factors to those adopted by resolution of
City Council.
Finding: No exceptions were noted as a result of our procedures.
2. We obtained the “Price and Population Factors” from the California Department of Finance used for
Appropriation Limits for the year ending June 30, 2020 and compared these factors to the worksheets used
by the City to calculate its appropriate limits for the fiscal year June 30, 2020.
Finding: The calculation factor used for the percentage change in city population for fiscal year
June 30, 2020 was not correct resulting in an understatement in the ending appropriation limit amount of
$32,947. Subsequently, the City made an adjustment to correct these errors but the correction did not take
effect until adopted by City Council resolution on November 6, 2019, when the fiscal year June 30, 2020
appropriation limit worksheet was approved. The amended calculation is shown in the accompanying
appropriations.
3. We recalculated the amended Appropriation Limit Worksheets for the year ending June 30, 2020 in the
accompany appropriation limit worksheet.
Finding: No exceptions were noted as a result of our procedures.
4. We agreed the current year information for the fiscal year June 30, 2020 presented in the accompanying
Appropriations Limit Worksheets to the supporting worksheets as described in 1 above.
Finding: Except as described in Finding 2 above, no exceptions were noted as a result of these procedures.
2121 North California Blvd., Suite 290, Walnut Creek, California 94596
Tel: 925-974-3394 • Fax: 949-777-8850
www.pungroup.com
3939352 Pun & McGeady_L_final.pdf 3 1/14/14 3:48 PM
To the Honorable Mayor and Members of City Council
of the City of Lodi
Lodi, California
Page 2
2
We were not engaged to, and did not conduct an audit, the objective of which would be the expression of an opinion
on the accompanying Appropriations Limit Schedule. Accordingly, we do not express such an opinion. Had we
performed additional procedures, other matters might have come to our attention that would have been reported to
you. No procedures have been performed with respect to the determination of the appropriations limit for the base
year, as defined by Article XIII-B of the California Constitution.
This report is intended solely for the information and use of the City Council and management of the City and is not
intended to be and should not be used by anyone other than these specified parties.
Walnut Creek, California
February 19, 2020
City of Lodi
Appropriations Limit Schedule
For the Year Ending June 30, 2020
See accompanying Notes to the Appropriations Limit Schedule.
3
Amount Source
A. Appropriations Limit FY 2018-19 105,753,512$ Prior year appropriations
limit adopted by the City
B. Calculation Factors:
1) Population increase % 1.0183 California Department of Finance
2) Inflation increase % 1.0385 California Department of Finance
3) Total adjustment % 1.0575 (B1 x B2)
C. Annual Adjustment Increase 6,081,308 {(B3 - 1) x A}
D. Other Adjustments:
1) Loss responsibility (-) - N/A
2) Transfer to private (-) - N/A
3) Transfer to fees (-) - N/A
4) Assumed responsibility (+) - N/A
E. Total Adjustments 6,081,308 (C + D)
F. Appropriations Limit FY 2019-2020 111,834,820$ (A + E)
City of Lodi
Notes to the Appropriations Limit Schedule
For the Year Ending June 30, 2020
4
Note 1 – Purpose of Limited Procedures Review
Under Article XIIIB of the California Constitution (the Gann Spending Limitation Initiative), California
governmental agencies are restricted as to the amount of annual appropriations from proceeds of taxes. Effective
for years beginning on or after July 1, 1990, under Section 1.5 of Article XIIIB, the annual calculation of the
appropriations limit is subject to a limited procedures review in connection with the annual audit.
Note 2 – Method of Calculation
Under Section 10.5 of Article XIIIB, for fiscal years beginning on or after July 1990, the appropriations limit is
required to be calculated based on the limit for the fiscal year 1986-87, adjusted for the inflation and population
factors discussed in Notes 3 and 4 below.
Note 3 – Population Factors
A California governmental agency may use as its population factor either the annual percentage change of the
jurisdiction’s own population or the annual percentage change in population of the county where the jurisdiction
is located. The factor adopted by the City for the year ending June 30, 2020, represents the annual percentage
change in population for the County of San Joaquin.
Note 4 – Inflation Factors
A California governmental agency may use as its inflation factor either the annual percentage change in the 4th
quarter per capita personal income (which percentage is supplied by the California Department of Finance) or the
percentage change in the local assessment roll from the preceding year due to the change of local nonresidential
construction. The factor adopted by the City for the year ending June 30, 2020, represents the annual percentage
change for per capita personal income.
Note 5 – Other Adjustments
A California government agency may be required to adjust its appropriations limit when certain events occur,
such as the transfer of responsibility for municipal services to, or from, another government agency or private
entity. The City had no such adjustments for the year ending June 30, 2020.
INDEPENDENT ACCOUNTANTS’ REPORT ON
APPLYING AGREED UPON PROCEDURES
To the City Council
of the City of Lodi
Lodi, California
We have performed the procedures enumerated below, on the application of the requirements of the Federal Transit
Administration (“FTA”) as set forth in its applicable National Transit Database (“NTD”) Uniform System of
Accounts (“USOA”) by the City of Lodi (the “Organization”) for the fiscal year ended June 30, 2019. Such
procedures, which were agreed to by the management of the Organization and the FTA, were performed to assist the
Organization and FTA in determining conformance with USOA requirements based on the following assertion by the
Organization’s management:
The accounting system from which the NTD reports for the year ended June 30, 2019, were derived,
uses the accrual basis of accounting and is directly translated, using a clear audit trail, to the
accounting treatment and categories specified by the USOA.
The Organization’s management is responsible for conformance with the requirements described above. The
sufficiency of these procedures is solely the responsibility of the parties specified in this report. Consequently, we
make no representation regarding the sufficiency of the procedures described below either for the purpose for which
this report has been requested or for any other purpose.
The agreed-upon procedures and associated findings are as follows:
1. Procedure: NTD Crosswalk
a. Obtained the Reduced Reporter Form RR-20 prepared by management for the year ended June 30, 2019.
b. Obtained the reconciliation documentation management prepares (referred to as “the crosswalk” throughout
this report) to reconcile the chart of accounts, general ledger, and/or trial balance and other supporting
documents such as Excel spreadsheets (collectively referred to as the accounting system) to Form RR-20.
c. Inquired of management as to whether the crosswalk obtained in procedure 1.b is supported by the
accounting system.
d. For a transit agency that is part of a larger reporting entity, inquire of management as to whether the
crosswalk includes the full cost of providing transit service, including costs incurred by the larger reporting
entity to specifically support the agency’s transit service.
e. Inspected the crosswalk to determine that it incorporates NTD reporting using the applicable mode(s) and
types of service identified in Form RR-20.
Findings:
No exceptions were found as a result of this procedure.
200 E. Sandpointe Avenue, Suite 600, Santa Ana, California 92707
Tel: 949-777-8800 • Fax: 949-777-8850 • www.pungroup.com
3939352 Pun & McGeady_L_final.pdf 1 1/14/14 3:48 PM
To the City Council
of the City of Lodi
Page 2
2. Procedure: Accrual Accounting
a. Obtained the most recent audited financial statements that include the transit agency and inspect the notes to
the financial statements to determine whether the accrual basis of accounting was used.
b. Inquired of management as to whether the accrual basis of accounting has continued to be used since the last
audited reporting period and that it is used for NTD reporting in the current period.
c. If the notes to the financial statements indicate that an accrual basis of accounting is not being used, or the
results of the inquiry to management in procedure 2.b indicate the accrual basis of accounting is not being
used in the current period, inspect the crosswalk to determine that the transit agency made adjustments to
convert to an accrual basis for NTD reporting.
Findings:
No exceptions were found as a result of this procedure.
3. Procedure: Sources of Revenue Expended
a. Traced and agreed the two largest directly generated fund passenger fare revenue modes (all service types)
from Form RR-20 to the accounting system.
b. Traced and agreed the largest source of funds expended (other than passenger fares) in the following major
categories of funds from Form RR-20 to the accounting system: (1) Other Directly Generated Funds; (2)
Revenue Accrued Through a PT Agreement; (3) Non-Federal Funds; and (4) Federal Funds.
c. For each of the largest source of funds expended in 3b, inspect the crosswalk to determine that it identifies,
evaluates, and classifies financial transactions into categories of funds expended on operations and funds
expended on capital (USOA Section 2) for the reporting year.
Findings:
No exceptions were found as a result of this procedure.
4. Procedure: Funds Expended
a. Traced and agreed the aggregate of total funds expended for operations and total funds expended for capital
from Form RR-20 to the accounting system using the crosswalk or other written expense documentation.
b. For the two largest modes/type of services, trace and agree funds expended on operations and funds
expended on capital from Form RR-20 to the crosswalk or other written documentation of functional
expenses.
Findings:
No exceptions were found as a result of this procedure.
To the City Council
of the City of Lodi
Page 3
This agreed-upon procedures engagement was conducted in accordance with attestation standards established by the
American Institute of Certified Public Accountants. We were not engaged to, and did not, conduct an examination or
review, the objective of which would be the expression of an opinion or conclusion, respectively, the Organization’s
conformance with the requirements described above, for the year ended June 30, 2019. Accordingly, we do not
express such an opinion or conclusion. Had we performed additional procedures, other matters might have come to
our attention that would have been reported to you.
This report is intended solely for the information and use of management of the Organization and the FTA and is not
intended to be and should not be used by anyone other than these specified parties.
Santa Ana, California
October 24, 2019