Loading...
HomeMy WebLinkAboutItem 4.02 Financial Audit 1984-85 (2) CITY OF DUBLIN - AGENDA STATEMENT CITY COUNCIL MEETING DATE: January 27, 1986 SUBJECT Fiscal Year 1984-85 - City Audit EXHIBITS ATTACHED 1984-85 Financial Audit ; Management Letter ; Budget Change Forms RECOMMENDATION 1) Approve Budget Changes 2 ) Accept 6/30/85 Financial Statement FINANCIAL STATEMENT: See Below DESCRIPTION Financial Statements The City Auditor has completed his review of the City' s financial records for Fiscal Year 1984-85 . As indicated in the Auditor ' s Financial Statements, the City' s total revenues for Fiscal Year 1984-85 were $8 , 556 ,346 . This is approximately $1, 205 , 704 or 16 . 4% higher than the amount estimated in the 1984-85 Budget . This difference is primarily attributable to the following factors : 1 . Sales Tax was $730 ,866 higher than estimated as a result of the City winning its lawsuit with the County ( $518 , 157 ) and an improved level of retail sales throughout the business district ( $212, 709 ) . 2 . The creation of a Transient Occupancy Tax in October , 1984 generated $140 , 290 during Fiscal Year 1984-85 , which was not anticipated at the time the Budget was adopted. 3 . Building Permit issuance was stronger than anticipated, resulting in $96 , 059 in additional fees . 4 . Revenue from investment of reserves was $370 ,572 more than estimated. This was due to increased revenues, the non-completion of several capital projects and keeping operating expenses below Budget . 5 . The City sold right-of-way to Barratt Development realizing $124 ,884 that was not anticipated. 6 . The creation of three ( 3 ) assessment districts resulted in an additional $137 , 145 in revenue (not including interest ) . 7 . Charges for planning and engineering services were $96 , 394 higher than anticipated due to the high level of development activity. These increased revenues were offset by less revenues in the following major revenue categories : 1 . Park & Recreation fees were $123 , 122 less than estimated due to some unsuccessful programming during Fiscal 1984-85 and overestimating fees in the 1984-85 Budget . 2 . FAU funds were $189 , 798 less than anticipated due to the lack of progress on San Ramon Road Phase II . 3 . Park Dedication fees were $187 ,609 less than anticipated in the Budget because fees for a major project were deposited with the City during the last month of Fiscal Year 1983-84 instead of Fiscal 1984-85 as was anticipated in the Budget . ---------------------------------------------------------------------------- COPIES TO: ITEM N0. �♦ 4 . Contributions for capital projects were $107 , 800 less than anticipated due to 'the lack of progr on several capital projc 3 . Total actual expenditures for Fiscal Year 1984-85 were $4 , 985 , 502 as compared to $8 , 250 ,570 budgeted. The differences between the Adopted Budget and Actual Expenditures are shown below by major expenditure category: BUDGET ACTUAL % DIFF General Government $ 439 , 760 $ 375 , 462 ( 14 . 6% ) Public Safety 1, 562, 410 1, 495 , 834 ( 4 . 3% ). Transportation 391,968 346 ,740 ( 11 . 5% ) Health & Welfare 8 , 925 1, 275 ( 85 . 7% ) Culture & Leisure Services 323 , 703 220 ,453 ( 31 . 9% ) Community Development 701, 663 661 ,683 ( 5 . 7% ) Capital Projects 4 , 822 , 141 1 , 884 ,055 ( 60 . 9% ) Total $8 , 250 ,570 $4 ,985 , 502 ( 39 . 6% ) As indicated above, the primary reason for expenditures being less than the Adopted 1984-85 Budget relates to several capital projects not proceeding as fast as anticipated. The major capital expenditures which were delayed included: 1 . Sewage Facility Expansion 2 . Dublin Boulevard Utility Undergrounding 3 . Downtown Street Light Additions 4 . San Ramon Road Phase I & II 5 . Alcosta -Boulevard, Dublin Court, Clark Avenue and Stagecoach Road Traffic Signals 6 . Major Arterial Landscaping Prior to the end of the Fiscal Year 1984-85 , the City Council authorized the appropriation of the City ' s year-end fund balance to the Street Improvement Reserve and the Reserve for Authorized Projects . As of June 30 , 1985 , the City' s total reserves are as follows : Reserve General Traffic Gas Tax CDBG Park Capital Assessmt Safety Dedicatn Projects Districts Total Street Improvement $7,888,270 $ -0- $221,102 $ -0- $ -0- $ -0- $ -0- $8,109,372 Facility Acquisition & Construction 400,000 400,000 Authorized Projects 29,452 (13,277) 30,000 777,488 434,942 6,072 1,264,677 Total $8,317,722 $(13,277)$221,102 $30,000 $777,488 $434,942 $6,072 $9,774,049 The City' s year-end reserves are $3 , 570 ,850 greater than they were at the end of Fiscal Year 1983-84 . Budget Changes During the closing of the 1984-85 Accounting Records, the Auditor indicated that the City should be accounting for accrued vacation as an expense rather than as a liability. This necessitates a budget change ( see attached) . It was also noted that two payments on the Village Parkway Landscape & Sidewalk Project were improperly recorded to 1985-86 instead of 1984-85 . It was recommended that this be corrected with a budget change ( see attached) . It is recommended that the City Council approve these budget changes . Management Letter The Auditor has made several recommendations regarding the City ' s financial system. The City has either complied with these recommendations or is working toward compliance. In response to Recommendation #5 , the Auditor is requesting one written report which accommodates all of those features identified for investment control . At the time of the Audit, Staff was tracking certificate of deposit maturities and rollovers, and was checking- off interest income on each certificate of deposit as it was received. Audit Committee The Audit Committee has met with the Auditor and will be able to discuss the results of that meeting, if necessary. 1 CITY OF DUBLIN FINANCIAL STATEMENTS YEAR ENDED JUNE 30, 1985 With Report of Certified Public Accountant Perry H. Carter, Certified. Public Accountant 1 TABLE OF CONTENTS Page REPORT OF CERTIFIED PUBLIC ACCOUNTANT 1 FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types and Account Groups 2 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - All Governmental Fund Types 3 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - Budget (GAAP Basis) } and Actual - General, Special Revenue and Capital Projects Fund Types 4 i Notes to Financial Statements 5 i FINANCIAL STATEMENTS OF INDIVIDUAL FUNDS GENERAL FUND Balance Sheet 12 Statement of Revenues, Expenditures and Changes in Fund Balance 13 t t SPECIAL REVENUE FUNDS Combining Balance Sheet 16 1 Combining Statement of Revenues, Expenditures and Changes in Fund Balance 18 i i CAPITAL PROJECTS FUNDS a a Combining Balance Sheet 21 Combining Statement of Revenues, Expenditures and Changes in Fund Balances 30 Perry H. Carter, Certified Public Accountant r x 64�: Y .e. f. - r 'ltF uCS.C.:ih•«n,:T'�. G.+.., n ^ �'�Amehe'u Ott '� _ n Y.'.; 1 / TABLE OF CONTENTS Page SPECIAL ASSESSMENT FUNDS Combining Balance Sheet 40 Combining Statement of Revenues, Expenditures and Changes in Fund Balances 41 GENERAL FIXED ASSETS ACCOUNT GROUP Schedule of General Fixed Assets by Sources 43 I i Perry H. Carter, Certified Public Accountant i PERRY H. CARTER, C.P.A. CERTIFIED PUBLIC ACCOUNTANT 24326 MISSION BOULEVARD SUITE 4 HAYWARD,CALIFORNIA 94541 (415) 537-1835 REPORT OF CERTIFIED PUBLIC ACCOUNTANTS Honorable Mayor, Members of the City Council and City Manager City of Dublin Dublin, California I have examined the combined financial statements of the City of Dublin, California and its combining and individual fund finan- cial statements as of and for the year ended June 30, 1985 . My examination was made in accordance with generally accepted auditing standards and, accordingly, included such tests of the accounting records and such other auditing procedures as I considered necessary in the circumstances. In my opinion, the combined financial statements referred to above present fairly the financial position of the City of Dublin, California at June 30 , 1985, and the results of its operations for the year then ended, in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceeding year. Also, in my opinion, the combining and individual fund financial statements referred to above pre- sent fairly the financial position of the individual funds of the City of Dublin, California at June 30, 1985 and their results of operations for the year then ended in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year. PERRY H. CARTER November 8, 1985 CITY OF DUBLIN COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS June 30, 1985 Account Governmental Fund Types Group General Total Special Capital Special Fixed (Memorandum General Revenue Projects Assessments Assets Only) ASSETS Cash and investments $ 7,877,504 $ 1 ,033,354 $ 923,162 $ 135,467 $ $ 9,969,987 Y. Receivables: Taxes 8,894 Accounts 57,175 8,894 51 57,226 Accrued interest 151 ,038 151 ,038 Due from other governments 458,311 33,403 7,880 499,594 Due from other funds 282,033 282,033 Prepaid expenses 79,384 79,384 Machinery and equipment 3,545 153,545 15 Improvements 1 ,092 1 ,092 $ 8�914�339 $ 1066.757 $ 931 ,042 $ 13 .518 $ 154.637 $ 1 ,202,293 LIABILITIES AND FUND EQUITY LIABILITIES Accounts payable $ 283,914 $ 31 ,454 $ 304,057 $ 23,196 $ $ 642,621 Accrued wages 17,147 17,147 Accrued vacations 16,039 16,039 Deposits 279,517 36,250 315,767 Due to other funds _ 19,990 192,043 70,000 282,033 596,617 51 ,444 496,100 129,446 1 ,273,607 FUND EQUITY Investments in general fixed assets Fund balance: 154,637 154,637 Reserved for street improvement 7,888,270 221 ,102 8,109,372 Reserved for authorized expenditures/ projects 29,452 794,211 434,942 6,072 1 ,264,677 Reserved for facility design and acquisition 400,000 400,000 8,317,722 11015,313 434,942 6,072 154,637 9,928,686 TOTAL LIABILITIES AND FUND EQUI'PY $ 8,91439 $ 1G066�757 $ 931 ,042. $ U5,518 $ 15L4,67 $ 11202,293 j See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant CITY OF DUBLIN COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES Year Ended June 30, 1985 Special Capital Special Total General Revenue Projects Assessment (Memorandum Only) REVENUES Taxes $ 4,738,818 $ $ $ $ 4,738,818 Licenses and permits 333,982 333,982 Intergovernmental 785,881 671 ,049 1 ,456,930 Charges for services 260,217 260,217 Use of money and property 909,651 85,337 9,275 1 ,004,263 Fines and forfeits 15,162 53,139 68,301 t Other revenue 149,099 217,391 190,200 556,690 Special assessment 137,145 137,145 7,192,810 1 ,026,916 190,200 146,420 8,556,346 EXPENDITURES k: General government 361 ,392 361 ,392 Public safety 1 ,317,734 76,661 100,460 1 ,494,855 Highways and streets 65,571 252,739 937 319,247 1 Health and welfare 8,892 8,892 Community development 602,567 602,567 Culture and leisure 215,696 215,696 ` Capital outlay 30,308 29,534 1 ,884,054 38,951 1 ,982,847 2,593,268 367,826 1 ,884,054 140,348 4,985,496 .i� REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES 4,599,542 659,090 (1 ,693,854) 6,072 3,570,850 ?" OTHER FINANCING SOURCES (USES) Operating transfers in 26,978 1 ,671 ,928 1 ,698,906 Operating transfers (out) (1 ,099,806) ( 373,752) ( 225,348) (1,698,906) r TOTAL OTHER FINANCING SOURCES (USES) (1 ,072,828) ( 373,752) 11446,580 REVENUES AND OTHER FINANCING SOURCES IN EXCESS OF (LESS) THAN EXPENDITURES AND OTHER USES 3,526,714 285,338 ( 247,274) 6,072 3,570,850 ' FUND BALANCES, BEGINNING OF YEAR (NOTE 11 ) 4,791 ,008 729,975 682,216 6,203,199 FUND BALANCES, END OF YEAR $ 813172 $ 1015,313 $ 3i934�942 $ _ 6,OZ2 $ 9.774.099 - _ - - - See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -3- ,. CITY OF DUBLIN COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET (GAAP BASIS) AND ACTUAL - GENERAL, SPECIAL REVENUE AND CAPITAL PROJECTS FUND TYPES Year Ended June 30, 1985 General Fund _ Special Revenue Fund Types _ Capital Pro Budget Actual Variance iect Fund Types REVENUES Budget Actual Variance _ Budget Actual Variance Taxes $ 3,811 ,000 $ 4,738,818 $ 927,818 $ $ $ $ Licenses and permits 234,850 333,982 99,132 $ $ Intergovernmental 742,000 785,881 43,881 888,292 671 ,049 (217,243) Charges for services 281 ,000 260,217 ( 20,783) Fines and forfeits 6,000 15,162 9,162 55,000 53,139 ( 1 ,861 ) Use of money and property 571 ,500 909,651 338,151 33,500 85,337 51 ,837 Other revenue _ 29,500 149,099 124,599 405,000 217,391 609) 298000 190200 (187, , , (_ 107,800) 5,670,850 7,192,810 1,521 ,960 11381 ,792 1,026,916 (354,876) 298,000 190,200 ( 107,800) EXPENDITURES General government 419,040 361 ,392 57,648 Public safety 1 ,362,595 1 ,316,459 46,136 81 ,990 76,661 5,329 Highways and streets 67,972 65,571 2,401 265,616 252,739 12,877 Health and welfare 8,925 1 ,275 7,650 8,892 8,892 Community development 642,071 602,567 39,504 12,000 Culture and recreation 310,203 215,696 99,507 12,000 Capital outlay 53,893 30,308 23,535 95,500 29,534 15,966 4,814,035 1 ,884,054 2,929,981 i. 2,864,649 2,593,268 271 ,381 413,998 367,826 46,172 4,814,035 11884,054 2,929,981 REVENUES GREATER (LESS) THAN EXPENDITURES 2,806,201 4,599,542 1 ,793,341 967,794 659,090 (308,704) (4,516,035) (1 ,693,854) 2,822,181 OTHER FINANCING SOURCES (USES) Operating transfers in 26,978 26,978 Operating transfers 3,529,100 1 ,671 ,928 1 ,857,172 ; (out) (2,924,272) (1,099,806) 1 ,824,466 ( 630,500) ( 373,752) 256,748 ( 225,348) ( 225,348) (2,897,294) (19072,828) 1 ,824,466 ( 630,500) ( 373,752) 256,748 3,303,752 1 ,446,580 1 ,857,172 9Y:. REVENUES AND OTHER FINANCING SOURCES IN EXCESS OF (LESS) THAN EXPENDITURES AND OTHER USES ( 91 ,093) 3,526,714 3,617,807 337,294 285,338 ( 51 ,956) (1 ,212,283) ( 247,274) 965,009 FUND BALANCES, BEGIN- ! ` NING OF YEAR (NOTE 11 ) 4,791 ,008 41791 ,008 _ 729,975 729,975 682,216 682,216 FUND BALANCES, END OF YEAR 9 699 915 $ �_,__ $ 8,317722 $ 3,_617807 $ 1 ,067,269 $ 1 ,015E313 $( 51 956) $( _530-�067)$ 4 _ $34 942 5,009 -__ -- __- - _9.6 See accompanying notes to financial statements. Perry 11, Carter, Certified Public Accountant +c.,ao«eeia�+ra,rs-ztrtin ..rt-cttx-...—• .,. :ti CITY OF DUBLIN NOTES TO FINANCIAL STATEMENTS June 30, 1985 NOTE 1 -- SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Dublin was incorporated February 1 , 1982 under the Municipal Organization Act of 1977. The City operates under a Council-Manager form of government and provides services to resi- dents primarily by contracting with other governmental agencies and private contractors. The accounting policies of the City of Dublin conform to generally accepted accounting principles as applicable to governments. The following is a summary of the more significant policies : A -- FUND ACCOUNTING The accounts of the City are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self-balancing accounts that comprise its assets, liabilities, fund equity, revenues, and expenditures, or expen- ses, as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending act' vities are controlled. The funds required by the City of Dublin are grouped, in the financial statements of this report, into three generic fund types and one account group as follows: GOVERNMENTAL FUNDS General Fund - The general fund is the general operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds - Special revenue funds are used to account for the proceeds of specific revenue sources (other than special assessments, expendable trusts, or major capital projects) that are legally restricted to expenditures for specified purposes. Capital Projects Funds - Capital projects funds are used to account for financial resources to be used for the acquisition or construction of major capital projects (other than those financed by proprietary funds, special assessment funds and special reve- nue funds ) . Special Assessment Funds - Special assessment funds. are used to account of the financing of public improvements or services deemed to benefit the properties against which special assessments are levied. t :2 Perry H. Carter, Certified Public Accountant t� ,a -5- l t 1 CITY OF DUBLIN NOTES TO FINANCIAL STATEMENTS June 30, 1985 Account Group - General fixed assets are recorded as expenditures in the General Fund, Special Revenue Funds, and the Capital Projects Funds at the time of purchase. Such assets are accounted for in the General Fixed Assets account group. Depreciation is not provided for in the General Fixed Assets account group. All fixed assets are valued at historical cost. Donated assets are valued at their estimated fair market value at the date donated. The City has elected not to capitalize "improvements other than buildings" which would consist of nonenterprise expenditures relating to roads, bridges, curbs, gutters, streets, sidewalks, drainage systems, and lighting systems. The account group is not a fund. Consequently, it is concerned with the measurement of financial position only and not the results of operations. i B -- BASIS OF ACCOUNTING z Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported in the financial statements. Basis of accounting relates to the timing of the measurements made, regardless of the measurement focus applied. i All governmental funds and expendable trust funds are accounted ! for using the modified accrual basis of accounting. Their reve- nues are recognized when they become measurable and available as net current assets. Taxpayer assessed income, gross receipts, and sales taxes are considered "measurable" when in the hands of intermediary collecting governments and are recognized as revenue at that time. Anticipated refunds of such taxes are recorded as liabilities and reductions of revenue when they are measurable a and their validity seems certain. Expenditures are generally recognized under the modified accrual basis of accounting which is when the related fund liabi- lity is incurred. The City does not currently require the use of other than the general fund, special revenue fund, special assessment and capi- tal projects fund types. However, at such times as may be re- quired, proprietary or other funds will be used. Perry H. Carter, Certified Public Accountant -6- TCITY OF DUBLIN NOTES TO FINANCIAL STATEMENTS June 30, 1985 C -- BUDGETS AND BUDGETARY ACCOUNTING The City follows these procedures in establishing the budgetary data reflected in the financial statements; 1 . Prior to June 30, the City Manager submits to the City Coun- cil a proposed operating budget for the fiscal year commencing the following July 1. The operating budget in- cludes proposed expenditures and the means of financing them. 2. Public hearings are conducted to obtain taxpayer comments. 3. Prior to July 1 , the budget is legally enacted through pas- sage of an ordinance. 4. The City Manager is authorized to transfer budgeted amounts up to $2,500 within an activity, within any fund; however, any other budget transfer must be approved by the City Council. 5. Formal budgetary integration is employed as a management control device during he � revenue funds and capital year for the general fund, special p ital projects funds. ! 6 . Budgets for the general , special revenue, and capital pro- $ jects funds are adopted on a basis consistent with generally i accepted accounting principles (GAAP) . D -- INVESTMENTS t Investments are stated at cost or amortized cost, which a i mates market. approxi- mates E -- TOTAL COLUMNS ON COMBINED STATEMENT } Total columns on the combined statements are captioned Memorandum t Only to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present finan- cial Position, results of operations, or changes in financial a position in conformity with generally accepted accounting princi- ples. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the a this data. ggregation of Perry H. Carter, Certified Public Accountant -7- .., 1sg3iw9s1biYF.R'IL�o4:10i'ft'-',W'^y`r..vw.++wi.•4w.4Tot+:r." wti •+(. CITY OF DUBLIN NOTES TO FINANCIAL STATEMENTS June 30, 1985 NOTE 2 -- DUE FROM OTHER GOVERNMENTS Amounts due from other governments at June 30, 1985 consist of the following: Capital Special Projects General Revenue Fund Fund Fund Total Documentary transfer tax $ $ 6,155 $ $ 6,155 Fines and forfeitures 671 3 ,403 4,074 Trailer coach 1 ,326 1 ,326 Animal license 1 ,401 1 , 401 Motor vehicle in-lieu tax 38,238 38,238 Cigarette tax 7,084 7,084 Motor vehicle fees 201 201 Sales tax 264,000 264,000 Refund - Alameda County 83,840 83,840 Other 7,880 768 8,648 Revenue Sharing 54 ,627 54,627 $ 7 ,880 $ 458 ,311 $ 3 , 403 $ 469 ,594 NOTE 3 -- LONG-TERM DEBT The City had no long-term debt at June 30, 1985. NOTE 4 -- CHANGES IN GENERAL FIXED ASSETS A summary of changes in general fixed assets follows: Balance Balance July 1 , June 30, 1984 Additions Deletions 1985 Land $ $ $ $ Buildings Equipment 97,378 56,167 153,545 Construction-in- progress Improvements 1 ,092 1 ,092 $ 98. 470 $ 6 167 $ $ 154,637 Perry H. Carter, Certified Public Accountant S -8- ti CITY OF DUBLIN NOTES TO FINANCIAL STATEMENTS June 30, 1985 NOTE 5 -- OTHER REQUIRED INDIVIDUAL. FUND DISCLOSURES Generally accepted accounting principles require disclosure, as part of the Combined Statements, of certain information concern- ing individual funds including: Summary disclosures of debt service requirements to maturity for all types of outstanding debt. This requirement is met by Note 3. Summary disclosures of changes in general fixed assets by major asset class. This requirement is met by Note 4. Individual fund interfund receivable and payable balances. Interfund balances at June 30, 1985 consist of the following: Interfund Interfund Receivable Payable General Fund $ 282, 033 $ Capital Projects Fund 192,043 Traffic Safety Fund 19, 990 Special Assessments Fund 70, 000 $ 282 , 033 $ 282 .033 NOTE 6 -- MISCELLANEOUS REVENUES The schedule below sets out the detail of miscellaneous revenues for the year ended June 30, 1985 : General Fund Revenues Special Revenue Fund: $ 149, 099 f Park dedication fees Capital Projects Fund: 217, 391 Reimbursements 190,200 $ 556 .690 NOTE 7 -- RETIREMENT COMMITMENTS Substantially all of the City's employees are covered by the i Public Employee ' s Retirement System (PERS) . PERS is a defined benefit, contributory retirement plan administered by the State of California. Total pension expense and the amount funded for 1 the year ended June 30, 1985 was $41 ,168. A' Perry H. Carter, Certified Public Accountant ;. -9- CITY OF DUBLIN NOTES TO FINANCIAL STATEMENTS June 30, 1985 NOTE 8 -- COMMITMENTS The City was not obligated under any long-term lease agreements for facilities or equipment at June 30, 1985. NOTE 9 -- LITIGATION The City was involved in several lawsuits at June 30, 1985. City Management estimates that the potential claims against the City not covered by insurance resulting from such litigation would not materially affect the financial statements of the City. NOTE 10 -- CONTINGENT LIABILITIES The City participates in the General Revenue Sharing and other grant programs. These programs are subject to program compliance audits and/or financial audits by the grantor or their represen- tatives. Performance of such audits in the future may give rise to findings which will result in a liability on the part of the City. The City is of the opinion that any liability arising from a grantor' s audit will be immaterial. NOTE 11 -- PRIOR PERIOD ADJUSTMENT In fiscal year 1983/84 a receivable was recognized in the general fund in error. The following adjustment is to correct for that error: FUND BALANCE AT JUNE 30, 1984 AS PREVIOUSLY REPORTED $ 4,795,083 Correction of receivable ( 4, 075 ) FUND BALANCE AT JUNE 30, 1984 AS RESTATED $ 4 ,791 , 008 Perry H. Carter, Certified Public Accountant n -10- COMBINING AND INDIVIDUAL FUND STATEMENTS AND GENERAL FIXED ASSETS 3 1� r 1 1 i f 7 i :1 i :L CITY OF DUBLIN GENERAL FUND June 30, 1985 The purpose of the General Fund is to account for resources traditionally associated with City Government, which are not required to be accounted for in another fund. Revenues and expenditures of the Federal Revenue Sharing Program are accounted for in this fund. See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant R. CITY OF DUBLIN GENERAL FUND — BALANCE SHEET June 30, 1985 ASSETS Cash and investments $ 7,877,504 Receivables: Property taxes Accounts 8,894 Accrued interest 5 ,175 Due from other governments 1511 ,038 Due from other funds 458,311 Prepaid expenses 282,033 79 ,384 TOTAL ASSETS $ 8 ,914 ,339 LIABILITIES AND FUND EQUITY LIABILITIES Accounts payable $ 283 ,914 Accrued wages 17, 147 f Deposits 279,517 Accrued vacation 16 ,039 596 ,617 FUND EQUITY Fund balance: Reserved for facility acquisition 400,000 Reserved for street improvement .4 "),sss�i: Reserved for authorized projects 8,317,722 TOTAL LIABILITIES AND FUND EQUITY $ 8L914 ,339 a i� J M �3 See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant ' -12- • rr t..w "' `^. .ar,..t�...a:�S r � '� ` «,`ri.' ��:'+:.,a.t1.J.?w�S?� K.l.k,�.....C'14,�:.'�r,�er .;9'a�.'- :e ,r„ _ .;ua,�$ CITY OF DUBLIN GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended June 30, 1985 REVENUE Taxes: Property tax $ 388,514 $ Sales and use tax 41010,866 Real property transfer tax 49,220 Cable TV franchise tax 25,450 Electric franchise tax 91 ,519 Gas franchise tax 32,959 Transient occupancy tax 140,290 4,738,818 Licenses and permits: Building permits 320,059 Encroachment fees 6,671 Animal permits 6,946 Other permits 306 333,982 Intergovernmental: Trailer coach in-lieu tax 3,865 Motor vehicle in-lieu tax 442,089 Cigarette tax 104,897 Off highway motor vehicle in-lieu tax 159 Homeowner' s property tax relief 17,102 Revenue sharing 217,769 785,881 Charges for services: Zoning fees 66,472 Plan checking fees 144,922 Special police fees 9,277 Park and recreation fees 34,878 Sales of maps and documents 4 ,668 260,217 Fines and forfeits 15 ,162 Use of money and property: Interest 832,960 Rents and concessions 76,691 909,651 Sale of property 124,884 Miscellaneous 24,215 TOTAL REVENUE $ 7,,192 ,810 See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -13- CITY OF DUBLIN GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE Year Ended June 30, 1985 EXPENDITURES General government: Personal services $ 141 ,988 $ Services and supplies 219,017 Contract services 387 361 ,392 Public safety: Personal services 6,150 Services and supplies 8,624 Contract services 1 ,302,960 1 ,317,734 Highways and streets : Contract services _ 65 ,571 65,571 Community development: Personal services 153,814 Services and supplies 306,142 Contract services _ 142 ,611 602,567 Culture and leisure: Personal services 89,519 Services and supplies 58,656 Contract services _ 67 ,521 215,696 Capital outlay 30 ,308 TOTAL EXPENDITURES 2 ,593 ,268 EXCESS OF REVENUES OVER EXPENDITURES 4,599,542 OTHER FINANCING SOURCES (USES) Operating transfers in 26,978 Operating transfers out ( 110991806 ) ( 1 ,072,828 ) EXCESS OF REVENUES OVER EXPENDITURES AND OTHER FINANCING SOURCES (USES) 3,526,714 FUND BALANCE, BEGINNING OF YEAR (NOTE 11 ) 4 ,791 ,008 FUND BALANCE, END OF YEAR $ 8.317 .722 See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -14- 'i CITY OF DUBLIN SPECIAL REVENUE FUNDS June 30, 1985 Traffic Safety Fund - Resources of this fund are required to be used exclusively for official traffic control devices, maintenance thereof, equipment and supplies for traffic law en- forcement and maintenance, improvement, or construction of public streets, bridges and culverts within the City. State Gasoline Tax Fund - Resources of this fund are required to be used primarily for the research, planning, construction, im- provement, maintenance and operation of public streets and high- ways, and for certain other transportation related activities. County Gasoline Tax Fund - Resources of this fund are required to be used primarily for the research, planning, construction, im- provement, maintenance and operation of public streets and high- ways, and for certain other transportation related activities. Federal Aid Urban Fund - Resources of this fund are required to be used for improvements or restoration of roads, streets, fringe parking, and public transportation facilities within the boundaries of the local agency. Transportation Fund - Resources of this fund are required to be used for providing paratransit services to Dublin residents. CDBG Fund - Community development block grants .are accounted for in this fund. The resources of this fund are required to be used to meet program objectives which includes rehabilitation of existing housing, construction of public improvements, and the development of new affordable housing. Park Dedication Fund - Resources of this fund are required by State law to be used for the purpose of developing new or re- habilitating existing park or recreational facilities to serve the subdivision for which in-lieu fees were received. See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -15- CITY OF DUBLIN SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET June 30, 1985 Traffic Safety State Office of Transportation Fund Gasoline Tax Traffic Safety Fund ASSETS Cash and investments $ 15,752 $ 233,445 $ $ 6,669 Due from other governments 3,403 Due from other funds TOTAL ASSETS $ 19.155 $ 233,495 $ 6,669 LIABILITIES AND FUND EQUITY LIABILITIES Accounts payable $ 12,442 $ 12,343 $ $ 6,669 Due to other funds 19,990 32,432 12,343 6,669 FUND EQUITY Fund balance (13,277) Reserved for street improvements 221 ,102 TOTAL LIABILITIES AND FUND EQUITY $ 19.155 $ 233,495 $ $ 6,669 See accompanying notes to financial statements, , Perry H. Carter, Certified Public Accountant -15- CITY OF DUBLIN SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET June 30, 1985 Federal Aid Park Dedication Urban Highway Fund CDBG Fund Fund Total ASSETS Cash and investments $ $ $ 777,488 Due from other governments $ 1 ,033,354 30,000 Due from other funds 33,403 TOTAL ASSETS $ — $ 30.000 $ 77 48 $ 1 ,066.757 LIABILITIES AND FUND EQUITY LIABILITIES Accounts payable $ $ $ $ 31 ,454 Due to other funds 19,990 FUND EQUITY 51 ,444 Fund balance Reserved for street improvements 30,000 777,488 794,211 221 ,102 TOTAL LIABILITIES AND FUND EQUITY $ $ 30,000 $ 777,488 $ 1 .066.757 See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -17- i. 4."A. . CITY OF DUBLIN SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Traffic Safety State Office of Transportation Fund Gasoline Tax Traffic Safety Fund REVENUES Intergovernmental- Traffic study grant FAU grant $ $ $ 7,237 $ Gasoline tax 260,451 TDA Act funds CDBG Grant funds 8,892 Fines and forfeits Vehicle code fines 53,139 Use of money and property Interest 20,407 , All other Park dedication fees s ( 53,139 280,858 7,237 8,892 ) EXPENDITURES Public safety Service and supplies 20,799 € Contract services 46,190 9,672 € Highways and streets Contract services 252,739 Capital outlay 29,534 Health and welfare Contract services 8,892 66,989 291 ,945 8,892 REVENUES IN EXCESS OF (LESS THAN) EXPENDITURES (13,850) ( 11 ,087) 7,237 OTHER FINANCING SOURCES (USES) Operating transfers in Operating transfers out ( 1 ,500) (7,237) REVENUES IN EXCESS OF (LESS THAN) EXPENDITURES i. AND OTHER FINANCING USES (13,850) ( 12,587) FUND BALANCES, BEGINNING OF YEAR (NOTE 11 ) 573 233,689 T; FUND BALANCES, END OF YEAR $(1 3 X77) $ 221,1 02 $ h See accompanying notes to financial Statements. Perry H. Carter, Certified Public Accountant _18_ CITY OF DUBLIN SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Federal Aid Park Dedication Urban Highway Fund CDBG Fund REVENUES Fund Total Intergovernmental Traffic study grant FAU grant $ $ $ Gasoline tax 320,202 $ 7,237 TDA Act funds 320,202 CDBG Grant funds 260,451 Fines and forfeits 74,267 8,892 Vehicle code fines 74,267 Use of money and property Interest 53,139 All other Park dedication fees 64,930 85,337 217,391 _217,391 , 202 320, 74,267 282321 EXPENDITURES 1,026,916 Public safety Service and supplies Contract services Highways and streets 20,799 Contract services 55,862 Capital outlay Health and welfare 252,739 Contract services 29,534 8,892 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES _ 367,826 OTHER FINANCING SOURCES (USES) 320,202 79 267 282,321 ' 659,090 Operating transfers in Operating transfers out ( REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (320,202) (49,267) 596) (_ 373,752) AND OTHER FINANCING USES FUND BALANCES, BEGINNING OF YEAR (NOTE 11 ) 30,000 281 ,775 285,338 FUND BALANCES, END OF YEAR 495,713 _729,975 $ =._s= $ ;L0,900 $ 777,488 --- $ 1015.313 See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant 'k -19- CITY OF DUBLIN CAPITAL PROJECTS FUNDS June 30, 1985 Capital projects funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities or projects. �s See accompanying notes to financial statements. r{ Perry H. Carter, Certified Public Accountant -20- CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Traffic San Ramon Road Study AVB/ Improvements Dougherty Road City Base Phase I Improvements Map General Plan Dougherty Road ASSETS $ 5,258 $ Cash and investments k Due from other funds Due from other governments $ }' TOTAL ASSETS $ 5.258 $ - LIABILITIES AND FUND BALANCES LIABILITIES $ 420 $ Accounts payable Deposits Due to other funds TOTAL LIABILITIES 420 FUNDS BALANCES 4,838 Reserved for authorized projects $ $ $ TOTAL LIABILITIES AND FUND BALANCES $ 5.258 T i '1 f Continued See accompanying notes to financial statements. ' Perry H. Carter, Certified Public Accountant _11 _ CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Dougherty/ FAU Dublin Road Street Name Traffic Signal Rehabilitation Intersection Approach Traffic Signal AVB/San Ramon Major Arterials Modifications Signs Amador Plaza Road ASSETS Cash and investments $ 47,583 $ 22,391 $ 4,785 $ $ 70,883 Due from other funds 7,880 Due from other governments TOTAL ASSETS $ _55,==46-1 $ 22.391 $ 4,785 $ $ Z�883 LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ 47,584 $ $ $ $ Deposits Due to other funds 139,429 TOTAL LIABILITIES 187,013 FUNDS BALANCES Reserved for authorized projects (131 ,550) 22,391 4,785 70,883 TOTAL LIABILITIES AND FUND BALANCES $ 64U- $ X91 $ 4785 $ $ 70883 Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -22- CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Street Improvements Traffic Signal Amador Valley Sewage Facility Median Landscape Stagecoach Boulevard Expansion Bus Shelters ASSETS Cash and investments $ $ 75,746 $ 11 ,764 $ $ 27,088 Due from other funds Due from other governments TOTAL ASSETS $ $ _ZS 746 $ 11 ,764 $ $ 27,088 } LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ $ 13,982 $ 6,380 $ $ Deposits Due to other funds TOTAL LIABILITIES 13,982 6,380 FUNDS BALANCES Reserved for authorized projects _ 61 ,764 5,384 27,088 TOTAL LIABILITIES AND FUND BALANCES $ _ $ 5 ,746 $ 11 X769 $ $ 27,088 Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -23- CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 City Civic Entrance Street Tree Center Defective Village Signs Program Facility Sidewalk Repair Parkway Wall ASSETS Cash and investments $ 111 $ 31 ,868 $ $ 5,559 $ 2,920 Due from other funds Due from other governments TOTAL ASSETS $ 111 $ 31 ,868 $ $ 5.559 $ 2,920 LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ 220 $ 269 $ $ 232 $ 80 Deposits Due to other funds TOTAL LIABILITIES 220 269 232 80 FUNDS BALANCES Reserved for authorized projects (109) 31 ,599 5,327 2,840 TOTAL LIABILITIES AND FUND BALANCES $ 111 $ 1-1- a $ $ 5,559 $ 2,920 Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant _?4_ CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Village Parkway Word Downtown Landscape Annual Street Processing OTS Traffic Improvement Sidewalk Overlay Program Equipment Study Project Study ASSETS Cash and investments $ 15,783 $ $ $ 11 ,925 $ Due from other funds Due from other governments TOTAL ASSETS $ 15,783 $ $ $ 11 .925 $ LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ 25,258 $ $ $ 828 $ Deposits " Due to other funds 22,614 TOTAL LIABILITIES 25,258 23,442 FUNDS BALANCES Reserved for authorized projects ( 9,475) (11 ,517) TOTAL LIABILITIES AND FUND BALANCES $ Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Downtown Dublin Boulevard Street Lighting Kolb Park San Ramon San Ramon Undergrounding Additions Improvements Road Phase II Road Phase III ASSETS . Cash and investments 42,797 19,160 15,895 Due from other funds Due from other governments TOTAL ASSETS $ $ 42.797 $ $ 19,160 $ 15.895 LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ $ 10,301 $ $ 4,462 $ 9,502 Deposits Due to other funds TOTAL LIABILITIES 10,301 4,462 9,502 FUNDS BALANCES Reserved for authorized projects 32,496 14,698 6,393 TOTAL LIABILITIES AND FUND BALANCES $ =y $ 42f797 $ $ 19.160 $ 15-A25 Continued See accompanying notes to financial statements. Perry ll. Carter, Certified Public Accountant CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Traffic Signal Traffic Signal Alcosta/San Ramon Traffic Signal Dublin/ Traffic Signal Traffic Signal Boulevard Dublin/Sierra Dublin Court Dublin/Clark Interconnect ASSETS Cash and investments $ 38,496 $ 7,291 $ 99,509 $ 59,432 $ Due from other funds Due from other governments TOTAL ASSETS $ 38,A $ 7-1191 $ 99.509 $ $ LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ 1 ,553 $ 2,300 $ 43,722 $ 23,370 $ Deposits Due to other funds TOTAL LIABILITIES 1 ,553 2,300 43,722 23,370 FUNDS BALANCES Reserved for authorized projects 36,943 4,991 55,787 36,062 TOTAL LIABILITIES AND FUND BALANCES $ i&1A91 $ 7291 $ 99,509 $ x,_932 $ Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant _27_ CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Median Break Median Landscape Silvergate/ Village Parkway/ Median Landscape Handicapped Banner Pole Silvertree AVB to Kimball Major Arterials Curb-Ramps Foundations ASSETS Cash and investments $ 1 ,187 $ 4,868 $ 260,571 $ 11 ,085 $ Due from other funds Due from other governments TOTAL ASSETS $ X87 $ 9,868 $ 260,571 $ 11 ,085 $ LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ $ 5,722 $ 90,350 $ 9,476 $ Deposits 30,000 Due to other funds TOTAL LIABILITIES 5,722 90,350 39,476 FUNDS BALANCES 391 ) Reserved for authorized projects 1 ,187 ( 854) 170,221 (28, TOTAL LIABILITIES AND FUND BALANCES $ 1187 $ 4868 $ 260,57.1_ $ 11 ,085 $ Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1985 Fire Services DSRSD Services Study Study Total ASSETS Cash and investments $ 17,207 $ 12,000 $ 923,162 Due from other funds 7,880 Due from other governments TOTAL ASSETS $ 17.207 $ 12.000 $ 931 ,092 LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ 8,046 $ $ 304,057 Deposits Due to other funds 192,043 TOTAL LIABILITIES 8,046 496,100 FUNDS BALANCES Reserved for authorized projects 9,161 12,000 434,942 TOTAL LIABILITIES AND FUND BALANCES $ 17.207 $ 12000 $ 931 ,092 Concluded I See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant -29- CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Traffic Study San Ramon Road City Base AVB/Dougherty Improvements Dougherty Road Map General Plan Road Phase I Improvements REVENUES Other revenue (reimbursement) $ $ $ $ $ TOTAL REVENUE EXPENDITURES General government: Contractual services 10,162 6,705 2,048 Capital projects: Construction in progress Equipment 65,483 TOTAL EXPENDITURES 10,162 6,705 2,048 65,483 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (10,162) (6,705) (2,048) (65,483) OTHER FINANCING SOURCES (USES) Operating transfers in 15,000 6,705 Operating transfers (out) 44,267(2,026) (69,039) (13,468) REVENUES AND OTHER FINANCING SOURCES IN EXCESS OF (LESS) THAN EXPENDITURES 4,838 (4,074) (69,039) (34,684) FUND BALANCES, BEGINNING OF YEAR 4,079 69,039 34,689 !_ FUND BALANCES, END OF YEAR $ _4,838 $ _ $ $ $ Continued i See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant i i -30-- CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Dougherty/ FAU Dublin Road Street Name Traffic Signal Rehabilitation Intersection Approach Traffic Signal AVB/San Ramon Major Arterials Modifications Signs Amador Plaza Amador Valley REVENUES Other revenue (reimbursement) $ 7,880 $ $ $ 7,760 $ TOTAL REVENUE 7,880 7,760 EXPENDITURES General government: Contractual services Capital projects: Construction in progress 495,246 3,854 90� Equipment TOTAL EXPENDITURES 495,246 3,854 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (487,366) 3,854) 90) 7,760 OTHER FINANCING SOURCES (USES) Operating transfers in 324,698 Operating transfers (out) (10,838) REVENUES AND OTHER FINANCING SOURCES IN EXCESS OF (LESS) THAN EXPENDITURES (162,668) 3,854) 90) 3,078) FUND BALANCES, BEGINNING OF YEAR 31 ,118 26,245 4,875 3,078 70,883 FUND BALANCES, END OF YEAR $(131 .550) $ �2 391_ 4 785 $ $ 10,_883 'Continued See accompanying notes to financial statements. Perry If. Carter, Certified Public Accountant CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Street Improvements Median Traffic Signal Amador Valley Sewage Facility d Landscape Stagecoach Boulevard Expansion Bus Shelters REVENUES Other revenue (reimbursement) $ $ 100,000 $ $ $ TOTAL REVENUE 100,000 EXPENDITURES General government: Contractual services Capital projects: Construction in progress 38,648 6,700 Equipment TOTAL EXPENDITURES 38,648 6,700 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES 61 ,352 ( 6,700) OTHER FINANCING SOURCES (USES) Operating transfers in Operating transfers (out) (99,83_1 ) ( 5,000) REVENUES AND OTHER FINANCING SOURCES IN EXCESS OF (LESS) THAN EXPENDITURES (99,831 ) 56,352 ( 6,700) FUND BALANCES, BEGINNING -OF YEAR 99,831 5,412 12,084 27,088 FUND BALANCES, END OF YEAR $ $ =61 764 $ 5,389 $ $ 27,088 �P�L Continued y See accompanying notes to financial statements. Perry 11. Carter, Certified Public Accountant CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 City Civic Entrance Street Tree Center Defective Village Signs Program Facility Sidewalk Repair Parkway Wall REVENUES Other revenue (reimbursement) $ $ $ $ $ TOTAL REVENUE EXPENDITURES General government: Contractual services Capital projects: Construction in progress 1 ,109 2,401 5,200 39,016 257,129 Equipment TOTAL EXPENDITURES 1 ,109 2,401 5,200 39,016 257,129 . REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (1 ,109) ( 2,401 ) (5,200) (39,016) (257,129) OTHER FINANCING SOURCES Operating transfers in 1 ,000 34,000 , 5,200 42,500 74,138 Operating transfers (out) REVENUES AND OTHER FINANCING SOURCES IN xt, EXCESS OF (LESS) THAN EXPENDITURES ( 109) 31 ,599 3,484 (182,991 ) t' FUND BALANCES, BEGINNING OF YEAR 1 ,843 185,831 FUND BALANCES, END OF YEAR $(__109) $ 'F Continued See accompanying notes to financial statements. i Perry H. Carter, Certified Public Accountant _33_ CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Village Parkway Word Downtown Landscape Annual Street Processing OTS Traffic Improvement Sidewalk Overlay Program Equipment Study Project Study REVENUES Other revenue (reimbursement) $ $ $ $ $ TOTAL REVENUE EXPENDITURES General government: Contractual services 18,754 Capital projects: Construction in progress 145,106 119,131 Equipment 17,953 TOTAL EXPENDITURES 145,106 119,131 17,953 18,754 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (145,106) (119,131 ) (17,953) (18,754) OTHER FINANCING SOURCES (USES) Operating transfers in 29,500 119,131 17,953 7,237 Operating transfers (out) REVENUES AND OTHER FINANCING SOURCES IN EXCESS OF (LESS) THAN EXPENDITURES (115,606) (11 ,517) FUND BALANCES, BEGINNING OF YEAR 106,131 FUND BALANCES, END OF YEAR $(_9,_4752 $ $ $(11 ,x) $ . Continued See accompanying notes to financial statements. ' Perry H. Carter, Certified Public Accountant -34- CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Downtown Dublin Boulevard Street Lighting Kolb Park San Ramon San Ramon Undergrounding Additions Improvements Road Phase II Road Phase III REVENUES $ 2,980 $ $ 46,580 $ Other revenue (reimbursement) $ — TOTAL REVENUE 2,980 46,580 EXPENDITURES General government: Contractual services Capital projects: 70,984 546 100,921 33,607 Construction in progress Equipment — TOTAL EXPENDITURES 70,484 546 100,921 33,607 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (67,504) (546) ( 54,341 ) (33,607) OTHER FINANCING SOURCES (USES) 100,000 546 69,039 40,000 Operating transfers in Operating transfers (out) — REVENUES AND OTHER FINANCING SOURCES IN 14,698 6,393 EXCESS OF (LESS) THAN EXPENDITURES 32,496 FUND BALANCES, BEGINNING OF YEAR FUND BALANCES, END OF YEAR $ � $ 32996 $ a $ 14,698 $ 6,393 Continued See accompanying notes to financial statements. Perry H, Carter, Certified Public Accountant �c CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Traffic Signal Alcosta/ Traffic Signal San Ramon Traffic Signal Dublin/ Traffic Signal Traffic Signal Boulevard Dublin/Sierra Dublin Court Dublin/Clark Interconnect REVENUES $ $ $ Other revenue (reimbursement) $ 25,000 $ TOTAL REVENUE 25,000 EXPENDITURES General government: Contractual services Capital projects: 3,057 10,009 105,213 95,938 Construction in progress Equipment TOTAL EXPENDITURES 3,057 10,009 105,213 95,938 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES 21 ,943 (10,009) (105,213) (95,938) OTHER FINANCING SOURCES (USES) 15,000 15,000 173,500 144,000 Operating transfers in 12,500 12,000 Operating transfers (out) REVENUES AND OTHER FINANCING SOURCES IN 787 36,062 EXCESS OF (LESS) THAN EXPENDITURES 36,943 4,991 55, FUND BALANCES, BEGINNING OF YEAR FUND BALANCES, END OF YEAR $ 36,943 $ A.=M $ 55,78 $ Continued See accompanying notes to financial statements. ' Perry H. Carter, Certified Public Accountant CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Median Break Median Landscape Silvergate/ Village Parkway/ Median Landscape Handicapped Banner Pole Silvertree AVB to Kimball Major Arterials Curb-Ramps Foundations 3 I i REVENUES $ Other revenue (reimbursement) $ $ $ $ TOTAL REVENUE EXPENDITURES General government: Contractual services Capital projects: Construction in progress 18,188 29,867 133,627 31 ,669 2,854 Equipment TOTAL EXPENDITURES 18,188 29,867 133,669 31 ,669 2,854 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (18,188) (29,867) (133,627) (31 ,669) (2,854) OTHER FINANCING SOURCES (USES) 19,375 29,013 303,848 3,278 3,500 Operating transfers in 646 Operating transfers (out) REVENUES AND OTHER FINANCING SOURCES IN EXCESS (LESS) THAN OF EXPENDITURES 1 ,187 ( 854) 170,221 (28,391 ) FUND BALANCES, BEGINNING OF YEAR FUND BALANCES, END OF YEAR $ _�_�l 8� $( =-a-859) $ S 1 Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant CITY OF DUBLIN CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Fire Services DSRSD Services Study Study Total REVENUES Other revenue (reimbursement) $ $ $ 190,200 TOTAL REVENUE 190,200 EXPENDITURES General government: Contractual services 13,339 51 ,008 Capital projects: Construction in progress 1 ,815,093 Equipment 17,953 } TOTAL EXPENDITURES 13,339 1 ,884,054 REVENUES IN EXCESS OF (LESS) THAN EXPENDITURES (13,339) (1 ,693,854) OTHER FINANCING SOURCES (USES) 4 Operating transfers in 22,500 12,000 1 ,671 ,928 Operating transfers (out) 225,348 REVENUES AND OTHER FINANCING SOURCES IN EXCESS (LESS) THAN OF EXPENDITURES 9,161 12,000 ( 247,274) ?' FUND BALANCES, BEGINNING OF YEAR 682,216 FUND BALANCES, END OF YEAR $ _9�1�1 $ $ ___434,942 is F' �5 f: Continued See accompanying notes to financial statements. Perry H. Carter, Certified Public Accountant i- -38- r CITY OF DUBLIN SPECIAL ASSESSMENT FUNDS June 30, 1985 Special assessment funds are used to account for the financing of public improvements or services deemed to benefit the properties against which special assessments are levied. , r _2f Perry H. Carter, Certified Public Accountant -39- CITY OF DUBLIN , SPECIAL ASSESSMENT FUNDS COMBINING BALANCE SHEET Year Ended June 30, 1985 Street Lighting Landscape Assessment Amador Valley Assessment District Assessment District Boulevard Extension 83-1 83-2 Assessment District Total ASSETS Cash and investments $ 59,479 $ 27,559 $ 48,429 $ 135,467 Accounts receivable 51 51 TOTAL ASSETS $ 59530 $ 27,559 $ 48.429 $ 135_.518 LIABILITIES AND FUND EQUITY LIABILITIES Accounts payable $ 9,380 $ 1 ,396 Deposits $ 12,420 $ 23,196 Due to other funds 36,250 36,250 35,000 35,000 70,000 44,380 1 ,396 83,670 129,446 FUND EQUITY Fund balance 15,150 26,163 (35,241 ) 6,072 TOTAL LIABILITIES AND FUND EQUITY $ 59,530 $ 27.559 $ 48.429 $ ` i r. M mod' t , .S" accmpanying notes to financial statements. . .Parry 8. Carter, Certified Public Accountant -40- CITY OF DUBLIN SPECIAL ASSESSMENT FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND BALANCES Year Ended June 30, 1985 Street Lighting Landscape Assessment Assessment District Assessment District Boulevard dExtension Assessment District REVENUES 83-1 83-2 A Total Special assessment Use of money and property $ 111 ,900 $ 25,245 $ Interest $ 137,145 3,710 1 ,855 3,710 9,275 _115,610 27,100, EXPENDITURES 3.710 146;420 Public safety Service and supplies Highways and streets 100,460 Contract services 100,460 Capital outlay 937 937 38,951 38,951 REVENUES IN EXCESS OF 100,460 937 ?' 38,951 140,348 k: (LESS THAN) EXPENDITURES 15,150 26,163 (35,241 ) 6 072 ?UND BALANCES, BEGINNING OF YEAR , FUND BALANCES, END OF YEAR $ _ 15.150 $ 26.163 $( 24 ) $ 0 2 3, Yn' wt �e accompanying notes to financial statements. 'rry H. Carter, Certified Public Accountant k -41- CITY OF DUBLIN GENERAL FIXED ASSETS June 30, 1985 The purpose of the General Fixed Assets group of accounts is to account for fixed assets not used in proprietary fund operations or accounted for in Trust Funds. See accompanying notes to financial statements. µ Perry H. Carter, Certified Public Accountant -42- CITY OF DUBLIN SCHEDULE OF GENERAL FIXED ASSETS BY SOURCES June 30, 1985 GENERAL FIXED ASSETS Equipment Improvements $ 153,545 1 ,092 $ 154 ,637 INVESTMENT IN GENERAL FIXED ASSETS General fund purchases Gifts $ 154, 437 200 $ 154 . 637 j r„ See accompanying notes to financial statements. ,{ Perry H. Carter, Certified Public Accountant -43- CITY OF DUBLIN MANAGEMENT LETTER JUNE 30 , 1985 PERRY H. CAR'T'ER, C.P.A. CERTIFIED PUBLIC ACCOUN'T'ANT 2.1326 MISSION BOULEVARD SUITE 4 HAYWARD,CALIFORNIA 94541 (415) 537-1835 November 18, 1985 Honorable Mayor, Members of the City Council, and City Manager City of Dublin, California I have examined the financial statements of the City of Dublin for the year ended June 30, 1985 and have issued my report thereon dated November 8, 1985. As part of my examination, I made a study and evaluation of the City's system of internal accounting control to the extent I considered necessary to evaluate the system as required by gener- ally accepted auditing standards. Under these standards, the purposes of such an evaluation are to establish a basis for reliance on the system of internal accounting control in deter- mining the nature, timing, and extent of other auditing proce- dures that are necessary for expressing an opinion on the finan- cial statements and to assist the auditor in planning and per- forming his examination of the financial statements. The objective of internal accounting control is to provide reasonable, but not absolute, assurance as to the safeguarding of assets against loss from unauthorized use or disposition, and the reliability of financial records for preparing financial state- ments and maintaining accountability for assets. The concept of reasonable assurance recognizes that the cost of a system of internal accounting control should not exceed the benefits de- rived and also recognizes that the evaluation of these factors necessarily requires estimates and judgments by management. There are inherent limitations that should be recognized in considering the potential effectiveness of any system of internal accounting control. In the performance of most control proce- dures, errors can result from misunderstanding of instructions, mistakes of judgment, carelessness, or other personal factors. Control procedures whose effectiveness depend upon segregation of duties can be circumvented by collusion. Similarly, control procedures can be circumvented intentionally by management either with respect to the execution and recording of transactions or with respect to the judgments required in the preparation of financial statements. City of Dublin Perry H. Carter Page 2 November 18, 1985 Further, projection of any evaluation of internal accounting control to future periods is subject to the risk that the pro- cedures may become inadequate because of changes in conditions and that the degree of compliance with the procedures may deteriorate. My examination of the financial statements was made in accordance with generally accepted auditing standards, including the study and evaluation of the system of internal accounting control for the year ended June 30, 1985. The examination, which was made for the purposes set forth above, would not necessarily disclose all . weaknesses in the system because it was based on selective .tests of accounting records and related data. However, such evaluation disclosed the following conditions that I believe to be weaknesses, excluding those which were corrected before they came to my attention. In addition, I have included my recommenda- tions for improving the accounting system. These conditions were considered in determining the nature, timing, and extent of audit tests to be applied in my examination of the financial statements, and this report of such conditions does not modify my report dated November 8, 1985, on such finan- cial statements. My recommendations with respect to the City' s system of internal control is discussed below, and includes the status of the prior year's recommendations, along with the current year' s recommenda- tions. CURRENT YEAR RECOMMENDATIONS 1 -- ADDITIONAL STAFF FOR FINANCE As the volume of City business increases the finance function is directly impacted in terms of the number and complexity of trans- actions to be processed. This situation requires that available staff perform all finance functions, from clerical to review and analysis. At some point this results in an inefficient use of staff. I recommend that the City review the present staffing of the Finance function with the idea in mind of adding an account clerk position, either full or part time. Such a position would aid in maintaining segregation of accounting duties and provide for efficient use of staff. The City is currently in the process of recruiting a Finance Technician. This position, when filled, will provide substantial support to the finance function. City of Dublin Perry H. Carter Page 3 November 18, 1985 2 -- COMPUTER STUDY The City currently uses a one-write, manually-posted general ledger system. I believe that if the City activity continues to grow, this system will become increasingly cumbersome to main- tain. I recommend that the City prepare a study to determine if the City's financial operations should be computerized, and if so, to what extent. This recommendation is now being considered by the City's financial consultant,, who is currently reviewing available accounting software and computer equipment. 3 -- CASH RECEIPTS SYSTEM In 1984/85 the City implemented the prior year recommendation to use prenumbered cash receipts for other than "main office" re- ceipts. The next step is for the City to audit or account for the receipts during the year on a regular basis. I recommend that such a procedure be established during 1985/86. 4 -- APPROVAL OF ADJUSTING JOURNAL ENTRIES Adjusting journal entries constitute an important part of the City' s accounting system. Because journal entries constitute "access" to the financial records all entries must be properly prepared and authorized. Currently both preparation and review functions are performed by the City Manager, Assistant to the City Manager and the City' s financial consultant. The City Manager recognizes the importance of the control func- tion and has used the City' s financial consultant in this capacity. I believe that this is a workable solution given the current staffing of the City. However, the duties and responsi- bilities of the Financial Consultant should be formalized in writing. 5 -- INVESTMENT CONTROL The City has numerous certificates of deposits at several insti- tutions for reasons of insurance and interest rates. Currently, the investments are inventoried on a monthly basis and a report is prepared. , However, no formalized system of tracking certifi- cate of deposit maturities, rollovers, and interest income by certificate of deposit is used. I recommend that a procedure for tracking such information be developed. City of Dublin Perry H. Carter Page 4 November 18, 1985 6 -- RECORD SAFEKEEPING The City currently has a two-drawer fire-resistant file cabinet used to store certificates of deposit, the general ledger and other important documents. As City activity increases this one cabinet will not be adequate for such storage. I recommend that the City acquire at least one four-drawer fire-resistant safe in 1985/86. PRIOR YEAR RECOMMENDATIONS The following is a summary of the status of the prior year' s recommendations: 1 . Staffing recommendation - Repeated as current year recommen- dation. 2. Computer study - Repeated as current year recommendation. 3. Cash receipts - Implemented. 4. Cash disbursements - Implemented. I wish to thank the City Manager and his staff for their coopera- tion during the course of the audit. Should you wish to discuss any of the comments I have made, I will be happy to meet with you at your convenience. Sincerely, PERRY H. CARTER CITY OF DUBLIN BUDGET CMKE FOR II FROM TO APPROPRIATION ACCOUNT ACCOUINl Pfirl{'r ; TRANSFER h: 3,ate_ X 30 • �� 3- o oa 3-- --4-5!9 1 o r7 Ap ENc SENT JUSTIFICATION FOR CHANGE , a v t44t,;cf Vz0(NI6 :».cz �Gt ('�� Qe�` Ce-ec .,.e cue `e re �l I E,.II E COSTS al fj j °s T071AL g J06 I CITY FAMGER AFFROVAL DAIt / DA: . CI J`( COUNCIL/AFFROVAL � • - Wyss_ 3� Get_ _. CITY OF DUBLIN BUDGET CHANCE FONT - FRCM TO /-7 APPROPRIATION TRANSFER ACCOUNT WOLIN i ACCOUNT Pr�Ul�i Pr1ENl;i�>iNT l-I-joL-}�� i;7`js i-i- qol -3ci,c1 i, 3� JUSTIFICATION FOR CHANGE 'D varo.T.•��-� �� �q�`Il�s � Pt'2=,,ors. � (� ` _ I � j CeA,r&T � CGv���r� tl o 1l �� �c C `�2, FFENI: COSTS T01AL DA I CITY h,MAGER AFFROVAL - CITY COLNC�h/APPROVAL DAit .