10-9-17 Handouts Purvis
Gray &
Company
COMMUNICATION WITH THOSE CHARGED WITH GOVERNANCE
To the Honorable Mayor and
City Commissioners
Atlantic Beach, Florida
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 Atlantic Beach,Florida,(the City),
for the year ended September 30, 2016, and have issued our report thereon dated August 8, 2017.
Professional standards require that we provide you with information about our responsibilities under
generally accepted auditing standards,as well as certain information related to the planned scope and timing
of our audit. We have communicated such information in our engagement letter to you dated September 16,
2016. Professional standards require that we provide you with the following information related to our
audit:
Significant Audit Findings
Qualitative Aspects of Accounting Practices
Management is responsible for the selection and use of appropriate accounting policies. The significant
accounting policies used by the City are described in Note 1 to the financial statements. The following new
pronouncement was adopted during the year ended September 30, 2016:
• The City implemented GASB Statement No. 72, Fair Value Measurement and Application. The
statement addresses accounting and financial reporting issues related to fair value measurements, and
requires disclosures to be made about fair value measurements, the level of fair value hierarchy, and
valuation techniques. See Note 2 for these disclosures.
Future Adoption of New Accounting Standards
• GASB Statement No. 75, Accounting and Financial Reporting for Postemployment Benefits Other
Than Pensions, replaces the requirements of Statement No.45,Accounting and Financial Reporting by
Employers for Postemployment Benefits Other Than Pensions, as amended, and No. 57, OPEB
Measurements by Agent Employers and Agent Multi-Employer Plans, for OPEB. This statement
establishes new accounting and financial reporting requirements for governments whose employees are
provided with OPEB, including the recognition and measurement of liabilities, deferred outflows of
resources, deferred inflows of resources, and expenses.
We noted no transactions entered into by the governmental unit during the year for which there is a lack of
authoritative guidance or consensus. All significant transactions have been recognized in the financial
statements in the proper period.
Certified Public Accountants
P.O. Box 141270 • 222 N.E. 1st Street • Gainesville, Florida 32614-1270 • (352)378-2461 • FAX (352) 378-2505
Laurel Ridge Professional Center • 2347 S.E. 17th Street • Ocala, Florida 34471 • (352) 732-3872 • FAX(352) 732-0542
443 East College Avenue • Tallahassee, Florida 32301 • (850)224-7144 • FAX (850)224-1762
5001 Lakewood Ranch Blvd. N., Suite 101 • Sarasota, Florida 34240 • (941) 907-0350 • FAX(941)907-0309
MEMBERS OF AMERICAN AND FLORIDA INSTITUTES OF CERTIFIED PUBLIC ACCOUNTANTS
MEMBER OF AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS PRIVATE COMPANIES AND S.E.C.PRACTICE SECTIONS
1
To the Honorable Mayor and
City Commissioners
Atlantic Beach, Florida
Significant Audit Findings (Continued)
Qualitative Aspects of Accounting Practices (Concluded)
Accounting estimates are an integral part of the financial statements prepared by management and are based
on management's knowledge and experience about past and current events and assumptions about future
events. Certain accounting estimates are particularly sensitive because of their significance to the financial
statements and because of the possibility that future events affecting them may differ significantly from
those expected. The most sensitive estimates affecting the financial statements were:
• Management's estimate of the depreciation and accumulated depreciation which is based on the useful
lives determined by asset type.
■ Management's estimate of the allowance for uncollectible accounts which is based on historical trends
and an analysis of the collectability of individual accounts.
• Management's estimate of the other Postemployment Benefits Obligation which is based on actuarial
assumptions and estimates.
• Management's estimate of the net pension liability for the City's two defined benefit pension plans is
based on the actuarial valuations performed by a qualified actuaries. As permitted by GASB Statement
No. 68,the City has elected to use a measurement date to record the net pension liabilities and related
deferred inflows and outflows of resources,that is one year prior to the reporting date. The net pension
liability represents the difference between the value of the pension plan assets and the total pension
liability,which is measured using various actuarial assumptions. These assumptions, if changed,could
have a significant impact on recorded amounts.
• Management's estimate of the value of donated infrastructure is based on developer schedule of values
which are subject to various assumptions and estimates.
• Management's estimate of compensated absences which is based on payroll data as of year-end,
including the employees'current rate of pry and accrued hours for vacation and sick leave.
Certain financial statement disclosures are particularly sensitive because of their significance to financial
statement users. The most sensitive disclosures affecting the financial statements was:
■ The disclosure in Note 7 that discusses Pension Plans for the City.
We evaluated the key factors and assumptions used to develop the estimates described above in determining
that they are reasonable in relation to the financial statements taken as a whole.
Difficulties Encountered in Performing the Audit
The completion of our audit was delayed due to delays in receiving all of the necessary information to
complete the audit.
Corrected and Uncorrected Misstatements
Professional standards require us to accumulate all known and likely misstatements identified during the
audit, other than those that are trivial, and communicate them to the appropriate level of management.
Management has corrected all such misstatements. As described in the Independent Auditors' Report on
Internal Control Over Financial Reporting and Compliance on Other Matters, we detected misstatements
that we consider to be material. All material misstatements identified were corrected and posted by
management. A listing of journal entries has been attached to this letter.
2
To the Honorable Mayor and
City Commissioners
Atlantic Beach,Florida
Significant Audit Findings (Concluded)
Disagreements with Management
For purposes of this letter, professional standards define a disagreement with management as a financial
accounting, reporting, or auditing matter, whether or not resolved to our satisfaction, that could be
significant to the financial statements or the auditors' report. We are pleased to report that no such
disagreements arose during the course of our audit.
Management Representations
We have requested certain representations from management that are included in the management
representation letter dated August 8,2017.
Management Consultations with Other Independent Accountants
In some cases, management may decide to consult with other accountants about auditing and accounting
matters,similar to obtaining a"second opinion"on certain situations. If a consultation involves application
of an accounting principle to the governmental unit's financial statements or a determination of the type of
auditors' opinion that may be expressed on those statements, our professional standards require the
consulting accountant to check with us to determine that the consultant has all the relevant facts. To our
knowledge,there were no such consultations with other accountants.
Other Audit Findings or Issues
We generally discuss a variety of matters, including the application of accounting principles and auditing
standards, with management each year prior to retention as the governmental unit's auditors. However,
these discussions occurred in the normal course of our professional relationship and our responses were not
a condition to our retention.
Other Matters
We applied certain limited procedures to the Required Supplementary Information (RSI), which
supplements the basic financial statements. Our procedures consisted of inquiries of management regarding
the methods of preparing the information and comparing the information for consistency with
management's responses to our inquiries,the basic financial statements,and other knowledge we obtained
during our audit of the basic financial statements. We did not audit the RSI and do not express an opinion
or provide any assurance on the RSI.
We were engaged to report on supplementary information which accompany the financial statements but
are not RSI. With respect to this supplementary information, we made certain inquiries of management
and evaluated the form,content,and methods of preparing the information to determine that the information
complies with accounting principles generally accepted in the United States of America, the method of
preparing it has not changed from the prior period, and the information is appropriate and complete in
relation to our audit of the financial statements. We compared and reconciled the supplementary
information to the underlying accounting records used to prepare the financial statements or to the financial
statements themselves.
We were not engaged to report on other statistical information,which accompany the financial statements
but are not RSI. Such information has not been subjected to the auditing procedures applied in the audit of
the basic financial statements, and accordingly, we do not express an opinion or provide any assurance on
it.
3
To the Honorable Mayor and
City Commissioners
Atlantic Beach, Florida
Restriction on Use
This information is intended solely for the information and use of the City Commission and management
of the City of Atlantic Beach, Florida and is not intended to be, and should not be, used by anyone other
than these specified parties.
alga-x.41
August 8, 2017
Gainesville,Florida
4
City of Atlantic Beach
Year End:September 30,2016
Adjusting Journal Entries
Date: 10/1/2015 To 9/30/2016
Date Type Name Account No Debit Credit
9/30/2016 N POOLED CASH ACCOUNT 161-0000-104-00-00 161 -1,115.40
9/30/2016 N POLICE GRANT PROCEEDS 161-0000-331-22-00 161 1,115.40
9/30/2016 N POOLED CASH ACCOUNT 162-0000-104-00-00 162 1,115.40
9/30/2016 N POLICE GRANT PROCEEDS 162-0000-331-22-00 162 -1,115.40
9/30/2016 N FY2001 LLEBG 161 800-0000-290-10-61 800 1,115.40
9/30/2016 N BYRNE GRANT-POLICE 162 800-0000-290-10-62 800 -1,115.40
'Identified during audit-Audit
Adj 162 grant proceeds put into 161
grant fund-redass-client AJE#4221
9/30/2016 N POOLED CASH ACCOUNT 001-0000-104-00-00 001 -6,850.00
9/30/2016 N SALARIES 001-2002-521-12-00 001 6,850.00
9/30/2016 N POOLED CASH ACCOUNT 161-0000-104-00-00 161 6,850.00
9/30/2016 N SALARIES 161-2002-521-12-00161 -6,850.00
9/30/2016 N GENERAL FUND 001 800-0000-290-01-00 800 6,850.00
9/30/2016 N FY2001 LLEBG 161 800-0000-290-10-61 800 -6,850.00
•Idenitifed during audit,audit
ADJ
-PBC#AJE 4223-Salaries in fund
161 exceeded grant amount,redass to GF
9/30/2016 N DROP CONTRIB-10AA 401 601-0000-151-07-00 601 -184,154 05
9/302016 N DROP-ICMA 401-FMV ADJ 601-0000-151x07-00 601 12,946.74
9/30/2016 N DROP PLAN-ICMA 401 601-0000-361-30-11 601 -12,946.74
9/30/2016 N DROP PAY-ICMA 401 PLAN 601-8010-518-36-10 601 184,154.05
9/30/2016 N DROP CONTRIB-ICMA 401 603-0000-151-07-00 603 1,831.65
9/30/2016 N DROP PLAN-ICMA 401 603-0000-361-30-11 603 -1,831.65
PGC identified issue-PBC-
Pension Drop J/E-Client
#4240/4241
9/30/2016 N POOLED CASH ACCOUNT 001-0000-104-00-00 001 -50,854.92
9/30/2016 N HEALTH 001-1003-513-23-01001 6,593.36
9/30/2016 N HEALTH 001-1005-515-23-01 001 504.71
9/30/2016 N HEALTH 001-1007-512-23-01001 2,145.00
9/30/2016 N HEALTH 001-1009-519-23-01001 779.48
9/30/2016 N HEALTH 001-1010-513-23-01001 1,337.64
9/30/2016 N HEALTH 001-1011-516-23-01001 1,985.40
9/30/2016 N HEALTH 001-1012-519-23-01001 1,186.14
9/30/2016 N HEALTH 001-2001-521-23-01001 3,123.00
9/30/2016 N HEALTH 001-2002-521-23-01001 12,718.76
9/30/2016 N HEALTH 001-2002-521-23-01001 504.71
9/30/2016 N HEALTH 001-2003-521-23-01001 504.71
9/30/2016 N HEALTH 001-2004-521-23-01001 2,852.32
9/30/2016 N HEALTH 001-2007-521-23-01001 1,319.80
9/30/2016 N HEALTH 001-2007-521-23-01001 793.23
9/30/2016 N HEALTH 001-5001-541-23-01001 3,526.51
9/30/2016 N HEALTH 001-5002-541-23-01001 4,535.17
9/30/2016 N HEALTH 001-6010-572-23-01001 1,842.35
9/30/2016 N HEALTH 001-6020-572-23-01001 4,350.28
9/30/2016 N HEALTH 001-6025-541-23-01001 252.35
9/30/2016 N POOLED CASH ACCOUNT 400-0000-104-00-00 400 -5,002.87
9/30/2016 N HEALTH 400-5502-533-23-01400 1,996.99
9/30/2016 N HEALTH 400-5504-533-23-01400 3,005.88
9/30/2016 N POOLED CASH ACCOUNT 410-0000-104-00-00 410 -9,195.15
9/30/2016 N HEALTH 410-5506-535-23-01410 2,667.88
9/30/2016 N HEALTH 410-5508-535-23-01410 6,527.27
9/30/2016 N POOLED CASH ACCOUNT 420-0000-104-00-00 420 -343.32
9/30/2016 N HEALTH 420-4201-534-23-01420 343.32
9(30/2016 N POOLED CASH ACCOUNT 455-0000-104-00-00 455 -2,529.17
9(302016 N HEALTH 455-1008-524-23-01455 Z529.17
9/302016 N POOLED CASH ACCOUNT 470-0000-104-00-00 470 -1,544 59
9/30/2016 N HEALTH 470-0000-538-23-01470 1,544.59
9/30/2016 N GENERAL FUND 001 800-0000-290-01-00 800 50,854.92
9/30/2016 N WATER FUND 400 800-0000-290-40-40 800 5,002.87
9/30/2016 N SEWER FUND 410 800-0000-290-40-41 800 9,195.15
9/30/2016 N SANITATION FUND 420 800-0000-290-40-42 800 343.32
9/30/2016 N STORM WATER DRAIN FUND 470 800-0000-290-40-47 800 1,544.59
9/30/2016 N BUILDING CODE ENFORC 455 800-0000-290-40-55 800 2,529.17
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 -9,195.15
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 -50,854.92
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 -5,002.87
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 -343.32
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 -2,529.17
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 -1,544.59
9/30/2016 N POOLED CASH ACCOUNT 801-0000-104-00-00 801 69,470.02
9/30/2016 N HEALTH-FLORIDA BLUE-HMO 801-0000-218-10-16 801 -439.00
9/30/2016 N VISION-HUMANA 801-0000-218-10-20 801 16.51
9/30/2016 N LIFE-STANDARD 801-0000-218-10-21801 165.42
9/30/2016 N DISABILITY-LINCOLN-ST 801-0000-218-10-22 801 178.48
9/30/2016 N DISABILITY-LINCOLN-LT 801-0000-218-10-23 801 -587.19
9/30/2016 N HEALTH-UHC-HMO 801-0000-218-10-24 801 -68,778.26
9/30/2016 N DENTAL-HMO 801-0000-218-10-26 801 13.31
9/30/2016 N DENTAL-PPO 801-0000-218-10-27 801 -53.89
9/30/2016 N AFLAC 801-0000-218-10-28 801 14.60
'PGC identified issue with 801 Gearing account.Client prepared journal entry to correct-due
to this not being identified until audit considered audit related adjustment
9/30/2016 N POOLED CASH ACCOUNT 001-0000-104-00-00 001 57,149.63
9/30/2016 N WORKERS'COMPENSATION 001-1001-511-24-00 001 -90.86
9/30/2016 N WORKERS'COMPENSATION 001-1002-512-24-00 001 -212.23
9/30/2016 N WORKERS'COMPENSATION 001-1003-513-24-00 001 -1,457.40
9/30/2016 N WORKERS'COMPENSATION 001-1005-515-24-00 001 -493.75
9/30/2016 N WORKERS'COMPENSATION 001-1006-524-24-00 001 -464.87
9/30/2016 N WORKERS'COMPENSATION 001-1007-512-24-00 001 -154.31
9/30/2016 N WORKERS'COMPENSATION 001-1009-519-24-00 001 -33.91
9/30/2016 N WORKERS COMPENSATION 001-1010-513-24-00 001 -137.76
9/30/2016 N WORKERS'COMPENSATION 001-1011-516-24-00 001 -192.93
9/30/2016 N WORKERS'COMPENSATION 001-1012-519-24-00 001 -762.61
9/30/2016 N WORKERS'COMPENSATION 001-2001-521-24-00 001 -2,452.37
9/30/2016 N WORKERS'COMPENSATION 001-2002-521-24-00 001 -21,777.00
9/30/2016 N WORKERS'COMPENSATION 001-2002-521-24-00 001 -1,049.49
9/30/2016 N WORKERS'COMPENSATION 001-2003-521-24-00 001 -1,055.17
9/30/2016 N WORKERS'COMPENSATION 001-2004-521-24-00 001 -175.73
9/30/2016 N WORKERS COMPENSATION 001-2005-562-24-00 001 -295.63
9/30/2016 N WORKERS COMPENSATION 001-2006.521-24-00 001 -120 72
9/302016 N WORKERS'COMPENSATION 001-2007-521-24-00 001 -1248.90
9/30/2016 N WORKERS'COMPENSATION 001-2007-521-24-00 001 -1,011.69
9/30/2016 N WORKERS'COMPENSATION 001-3005-522-24-00 001 -4,842.92
9/30/2016 N WORKERS'COMPENSATION 001-5001-541-24-00 001 -4,207.68
9/30/2016 N WORKERS'COMPENSATION 001-5002-541-24-00 001 -6,317.20
9/30/2016 N WORKERS'COMPENSATION 001-6010-572-24-00 001 -2,896.15
9/30/2016 N WORKERS'COMPENSATION 001-6020-572-24-00 001 -5,000.15
9/30/2016 N WORKERS'COMPENSATION 001-6025-541-24-00 001 -698.20
9/30/2016 N POOLED CASH ACCOUNT 400-0000-104-00-00 400 7,377.88
9/30/2016 N WORKERS'COMPENSATION 400-5502-533-24-00 400 -3,095.24
9/30/2016 N WORKERS'COMPENSATION 400-5504-533-24-00 400 -4,282.64
9/30/2016 N POOLED CASH ACCOUNT 410-0000-104-00-00 410 12,835.28
9/30/2016 N WORKERS'COMPENSATION 410-5506-535-24-00 410 -2,915.46
9/30/2016 N WORKERS'COMPENSATION 410-5508-535-24-00 410 -9,919.82
9/30/2016 N POOLED CASH ACCOUNT 420-0000-104-00-00 420 347.72
9/30/2016 N WORKERS'COMPENSATION 420-4201-534-24-00 420 -347.72
9/30/2016 N POOLED CASH ACCOUNT 455-0000-104-00-00 455 1,436.47
9/30/2016 N WORKERS'COMPENSATION 455-1008-524-24-00 455 -1,436.47
9/30/2016 N POOLED CASH ACCOUNT 470-0000-104-00-00 470 3,175.88
9/30/2016 N WORKER'S COMPENSATION 470-0000-538-24-00 470 -3,175.88
9/30/2016 N POOLED CASH ACCOUNT 801-0000-104-00-00 801 -82,322.86
9/30/2016 N WORKERS'COMPENSATION 801-0000-218-15-00 801 82,322.86
PGC identified issue with 801 Gearing account.Client prepared journal entry to correct-due
to this not being identified until audit considered audit related adjustment
9/30/2016 N IMPR OTHER BLDG-CONTRIBUT 470-0000-164-92-00 470 361,489.00
9/30/2016 N IMPR OTHER BLDG-CONTRIBUT 470-0000-16492-00 470 1,279,222.00
9/30/2016 N A/D-IMPR OTHER-PURCHASED 470-0000-165-91-00 470 -32,814.20
9/30/2016 N FROM BEACHES HABITAT 470-0000-389-40-02 470 -361,489.00
9/30/2016 N FROM BEACHES HABITAT 470-0000-389-40-02 470 -1,279,222.00
9/30/2016 N IMPR OTHER THAN BLD-PURCH 470-0000-538-59-03 470 32,814.20
9/30/2016 N IMPR OTHER BLDG-PURCHASED/ROAD 11900-0000-164-91-02 900 277,946.00
9/30/2016 N IMPR OTHER BLDG-PURCHASED/ROAD 11900.0000-164-91-02 900 201,683.00
9/30/2016 N IMPR OTHER BLDG-PURCHASED/ROAD 11900-0000-164-91-02 900 702,005.00
9/30/2016 N A/D-IMPR OTHER BUILDING/ROAD IMPRC 900-0000-167-97-02 900 -11,816.31
9/30/2016 N CONT/DONATIONS PRV SOURCE 900-0000-366-00-00 900 -277,946.00
9/30/2016 N CONT/DONATIONS PRV SOURCE 900-0000-366-00-00 900 -201,683.00
9/30/2016 N CONT/DONATIONS PRV SOURCE 900-0000-366-00-00 900 -702,005.00
9/30/2016 N ROAD IMPROVEMENTS 900-1005.515-59-02 900 11,816.31
'Audit Adjustment-Entry PBC—
After PGC inquired of items;
record Atlantic Beach Country Club donated infrastructure-Client AJE 4253/4255
9/30/2016 N ND-IMPR OTHER BUILDING/ROAD IMPRC 900-0000-167-97-02 900 -305.606.26
9/30/2016 N AIWMPR OTHER BUILDING/StOEWALKS 900-0000-167-97-03 900 -31,409.21
9/30/2016 N ROAD IMPROVEMENTS 900-5002-541-59-02 900 305,606.26
9/30/2016 N SIDEWALKS 900-5002-541-59-12 900 31,409.21
'Audit Adjustment-Record GASB 34
Retro
Infrastructure,not recorded by client in CY-Client#4259
9/30/2016 N IMPR OTHER BLDG-CONTRIBUT 400-0000-164-92-00 400 426,115.00
9/30/2016 N IMPR OTHER BLDG-CONTRIBUT 400-0000-164-92-00 400 272,174.00
9/30/2016 N A/D-IMPR OTHER-CONTRIBUT 400-0000-165-92-00 400 -13,965.77
9/30/2016 N CAPITAL CONTRIBUTIONS-PRIVATE SOU400-0000-389-80-00 400 -426,115.00
9/30/2016 N CAPITAL CONTRIBUTIONS-PRIVATE SOU 400-0000-389-80-00 400 -272,174.00
9/30/2016 N IMP OTHER THAN BL-CONTRIB 400-0000-533-59-04 400 13,965.77
9/30/2016 N LAND EASEMENT-ACCUM AMORT 410-0000-161-90-02 410 -190.26
9/30/2016 N IMPR OTHER BLDG-CONTRIBUT 410-0000-164-92-00 410 639,035.00
9/30/2016 N ND-IMPR OTHER-CONTRIBUT 410-0000-165-92-00 410 -12,780.70
9/30/2016 N CAPITAL CONTRIBUTIONS-PRIVATE SOU 410-0000-389-80-00 410 -639,035.00
9/30/2016 N IMP OTHER THAN BL-CONTRIB 410-0000-535-59-04 410 12,780.70
9/30/2016 N LAND IMPROVEMENTS 410-0000-535-59-11 410 190.26
•Audit Adj-Client Prepared JE-
Record Additional Donated
Infrastructure.Found by PGC,AJE prepared by client;record added infrastructure CY
depreciation-Client AJE#4261/4263
9/30/2016 N INTERNAL CLEARING 800-0000-100-00-00 800 101,775.00
9/30/2016 N DEPOSIT-BANK OF AMERICA 800-0000-101-12-00 800 -101,775.00
Client Prepared Journal Entry to
Correct Internal Clearing Account
9/30/2016 N GENERAL FUND 001 800-0000-290-01-00 800 -57,149.63
9/30/2016 N WATER FUND 400 800-0000-290-40-40 800 -7,377.88
9/30/2016 N SEWER FUND 410 800-0000-290-40-41 800 -12,835.28
9/30/2016 N SANITATION FUND 420 800-0000-290-40-42 800 -347.72
9/30/2016 N STORMWATER DRAIN FUND 470 800-0000-290-40-47 800 -3,175.88
9/30/2016 N BUILDING CODE ENFORC 455 800-0000-290-40-55 800 -1,436.47
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 57,149.63
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 7,377.88
9/302016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 12,835.28
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 347.72
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 1,436.47
9/30/2016 N PAYROLL CLEARING 801 800-0000-290-80-81 800 3,175.88
•Audi Adjustment—Rec orraie
equity in pooled cash
balances to each Fund Pooled cash balance
9/30/2016 N OPEB LIABILITY 400-0000-237-00-00 400 -1,910.34
9/30/2016 N FUND BALANCE 400-0000-271-00-00400 1,910.34
9/30/2016 N OPEB LIABILITY 410-0000-237-00-00 410 -4,459.52
9/30/2016 N FUND BALANCE 410-0000-271-00-00 410 4,459.52
9/30/2016 N OPEB LIABILITY 455-0000-237-00-00 455 -955.68
9/30/2016 N FUND BALANCE 455-0000-271-00-00 455 955.68
9/30/2016 N OPEB LIABILITY 470-0000-237-00-00 470 -635.76
9/30/2016 N FUND BALANCE 470-0000-271-00-00 470 635.76
9/30/2016 N LIABILITY&OTHER CREDITS/OPEB LIABI 950-0000-237-00-00 950 -21,655.70
9/30/2016 N FUND BALANCE/FUND BALANCE 950-0000-271-00-00 950 21,655.70
*Audit Adjustment—PY OPEB Accrual not recorded by client
9/30/2016 N POOLED CASH ACCOUNT 001-0000-104-00-00 001 -65,132.90
9/30/2016 N Due from Other Funds 001-0000-131-00-00 001 65,132.90
9/30/2016 N POOLED CASH ACCOUNT 110-0000-104-00-00 110 65,132.90
9/30/2016 N DUE FROM OTHER GOVT AGEN 110-0000-133-00-00 110 64,793.22
9/30/2016 N DUE FROM OTHER GOVT AGEN 110-0000-133-00-00 110 37,929.50
9/30/2016 N CONTRACT-RETAINAGE PAYABL 110-0000-206-00-00 110
9/30/2016 N Due to GF 110-0000-207-00-00 110 -65,132.90
9/30/2016 N DEFERRED REVENUE 110-0000-223-00-00 110 -64,793.22
9/30/2016 N DEFERRED REVENUE 110-0000-223-00-00 110 -37,929.50
9/30/2016 N DEFERRED REVENUE 110-0000-223-00-00 110 65,132.90
9/30/2016 N AUDIT ADJUSTMENT 110-0000-223-04-00 110 -102,722.73
9/30/2016 N CDBG FUNDS FR CITY OF JAX 110-0000-331-54-00 110 102,722.73
9/30/2016 N CDBG FUNDS FR CITY OF JAX 110-0000-331-54-00 110 -65,132.90
9/30/2016 N INFRASTRUCTURE 110-5002-541-63-00110
9/30/2016 N GENERAL FUND 001 800-0000-290-01-00 800 65,132.90
9/30/2016 N COMM DEV BLOCK GRANT 110 800-0000-290-10-11 800 -65,132.90
•Reclass entry/Audit Adjustment
—Record due from/due to for 110
fund negative cash,record deferred revenue for payment received after 60 days of YE Move
pooled cash
9/30/2016 N POOLED CASH ACCOUNT 120-0000-104-00-00 120 -17,000.00
9/30/2016 N FIND-DOCK EXT-DESIGNBCONS 120-0000-334-70-02 120 17,000.00
9/30/2016 N POOLED CASH ACCOUNT 320-0000-104-00-00 320 17,000.00
9/30/2016 N FIND-MARSH MASTER PLAN 320-0000-334-70-04 320 -17,000.00
9/30/2016 N CONVENTION DEVELP TAX 120 800-0000-290-10-12 800 17,000.00
9/30'2016 N CAP ili?RV-MARSH MAST PLAN 800-0000-290-30-32 800 -17.000 00
•Audit Adjustment—Move FIND
grant to capital
projects fund
9/30/2016 N Deferred Outflows 950-0000-190-00-00 950 2,992,625.26
9/30/2016 N NPL General 950-0000-239-00-00 950 -3,085,694.49
9/30/2016 N NPL Police 950-0000-239-00-02 950 -4,727,662.00
9/30/2016 N OTHER LONG-TERM LIABILITS/OPEB ACC 950-0000-239-90-30 950
9/30/2016 N FUND BALANCE/FUND BALANCE 950-0000-271-00-00 950 4,860,558.23
9/30/2016 N Deferred Inflows-Pensions 950-0000-290-00-00 950 -39,827.00
Audit Adjustment,PY Journal
Entries not recored—Record Opening Balances for
Pensions
9/30/2016 N FIXED ASSETS/CONSTRUCTION IN PROC 900-0000-169-90-00 900 2,740.00
9/30/2016 N CAPITAL EXPENSE RECLASS 900-0000-599-69-99 900 -2,740.00
*Audit Adj—Correct/Remove AJE
4233 for GFA
CIP Deletion-amount was included already in GFA AJE#4232
9/30/2016 N OPERATING SUPPLIES 001-2001-521-52-00 001 -1,764.99
9/30/2016 N MOTOR VEHICLES 001-2001-521-64-01 001 1,764.99
'Audit Adjustment to reconcile
—Redass between capital outlay and
r&m
9/30/2016 N Deferred Outflows Pension Related 400-0000-190-00-00 400 844,811.92
9/30/2016 N Net Pension Liability 400-0000-239-00-00 400 -1,827,528.86
9/30/2016 N FUND BALANCE 400-0000-271-00-00 400 982,716.94
9/30/2016 N Deferred Outflows-Pension Related 420-0000-190-00-00 420 10,153.03
9/30/2016 N NPL General Pension 420-0000-239-00.00 420 -21,963.40
9/30/2016 N FUND BALANCE 420-0000-271-00-00420 11,810.37
9/3012016 N Deferred Outflow-Pension Related 455-0000-190-00-00 455 105,043.25
9/30/2016 N NPL General Employee Pension 455-0000-239-00.00 455 -227,233.51
9/30/2016 N FUND BALANCE 455-0000-271-00-00 455 122,190.26
9/30/2016 N Deferred Outflows-Pension Related 470-0000-190-00-00 470 43,192.54
9/30/2016 N NPL General Employee Pension 470.0000-239-00.00 470 -93,435.70
9/30/2016 N FUND BALANCE 470-0000-271-00-00 470 50,243.16
•Audit Adjustment-PY Pension JE
not made by Brent
9f30/2016 N POOLED CASH ACCOUNT 001-0000.104-00-00 001 -9,901.50
9/30/2016 N POOLED CASH ACCOUNT 001-0000-104-00-00 001 -2,447.89
9/30/2016 N POOLED CASH ACCOUNT 001-0000-104-00-00 001 10,781.45
9/30/2016 N POOLED CASH ACCOUNT 001-0000-104-00-00 001 -583.86
9/30/2016 N Due from Other Funds 001-0000-131-00-00 001 9,901.50
9/30/2016 N AUDIT ADJUSTMENT 001-0000-133-02-00 001 -10,781.45
9/30/2016 N A/P-PAYROLL 001-0000-202-03-00 001 2,447.89
9/30/2016 N NP-PAYROLL 001-0000-202-03-00 001 583.86
9/30/2016 N POOLED CASH ACCOUNT 161-0000-104-00-00 161 583.86
9/30/2016 N A/P-PAYROLL 161-0000-202-03-00 161 -583.86
9/30/2016 N POOLED CASH ACCOUNT 162-0000-104-00-00 162 -10,781.45
9/30/2016 N POOLED CASH ACCOUNT 162-0000-104-00-00 162 9,901.50
9/30/2016 N POOLED CASH ACCOUNT 162-0000-104-00-00 162 2,447.89
9/30/2016 N DUE FROM OTHER GOVT AGEN/AUDIT A1162-0000-133-02-00 162 9,901.50
9/30/2016 N NP-PAYROLL 162-0000-202-03-00 162 -2,447.89
9/30/2016 N LIABILITIES 8 OTHER CR E D 162-0000-207-00-00 162 -9,901.50
9/30/2016 N AUDIT ADJUSTMENT 162-0000-223-04-00 162 -9,901.50
9/30/2016 N AUDIT ADJUSTMENT 162-0000-223-04-00 162 10,781.45
9/30/2016 N GENERAL FUND 001 800-0000-290-01-00 800 1,567.94
9/30/2016 N GENERAL FUND 001 800-0000-290-01-00 800 583.86
9/30/2016 N FY2001 LLEBG 161 800-0000-290-10-61 800 -583.86
9/30/2016 N BYRNE GRANT-POLICE 162 800-0000-290-10-62 800 -1,567.94
'Audit Adjustment Fund
Clean-up--CY Receiveable in 162 fund
recorded as a debit to deferred revenue and credit to revenue,corrected.PY receivable
collected in GF but not properly reversed in CY
9/30/2016 N MSSB 601-0000-361-30-13 601 -19,771.39
9/30/2016 N MSSB 601-0000-361-30-13 601
9/30/2016 N INVESTMENT EXPENSES 601-8010-513-31-02 601 19,771.39
9/30/2016 N MSSB 603-0000-361-30-13 603 -35,368.15
9/30/2016 N MSSB 603-0000-361-30-13 603
9/30/2016 N INVESTMENT EXPENSES 603-8030-513-31-02 603 35,368.15
*Audit Adjustment-Identified by
PGC during review,entry prepared by client