GA A. ioo ,R. I R49.. l''!Ci4-95 STATE OF GEORGIA DEPARTMENT OF AUDITS 254 WASHINGTON STREET ATLANTA. GEORGIA 30334 AUDIT REPORT STATE OF GEORGIA DEPARTMENT OF REVENUE YEARENDEDJUNE30, 1995 DEPARTMENT OF REVENUE - TABLE OF CONTENTS - SECTION I FINANCIAL INDEPENDENT AUDITOR'S COMBINED REPORT ON FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION EXHIBITS FINANCIAL STATEMENTS A COMBINED BALANCE SHEET (STATUTORY BASIS) ALL FUND TYPES AND ACCOUNT GROUPS 2 B COMBINED STATEMENT OF CHANGES IN FUND BALANCES (STATUTORY BASIS) GOVERNMENTAL FUND TYPES 5 C STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES BUDGETFUND 6 D STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES COMPARED TO BUDGET BUDGET FUND 9 E STATEMENT OF CASH RECEIPTS AND DISBURSEMENTS STATE REVENUE COLLECTIONS FUND 10 F NOTES TO THE FINANCIAL STATEMENTS 12 SUPPLEMENTARY INFORMATION G COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES. FIDUCIARY FUND TYPE -AGENCY FUNDS 28 SCHEDULES I SCHEDULE OF APPROVED BUDGET 29 2 CASH AND CASH EQUIVALENTS 30 3 SCHEDULEOFFEDERALREVENUES 31 4 SCHEDULE OF OTHER OPERATING EXPENSES 32 5 SCHEDULE OF EXTRAORDINARY EXPENDITURES 33 6 ANALYSIS OF STATE REVENUE COLLECTIONS 34 SECTION II FINDINGS AND IMPROPER OR QUESTIONED COSTS SCHEDULE OF FINDINGS AND IMPROPER OR QUESTIONED COSTS SECTION I FINANCIAL CLAUDE L. VICKERS STATE AUDITOR (404) 856-217.. DEPARTMENT OF AUDITS 254 Washington Street, S.W., Suite 214 Atlanta, Georgia 30334-8400 November 9, 1995 Honorable Zell Miller, Governor Members of the General Assembly ofGeorgia and Honorable Marcus E. Collins, Sr., Commissioner Department ofRevenue INDEPENDENT AUDITOR'S COMBINED REPORT ON FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION Ladies and Gentlemen: We have audited the accompanying financial statements (Exhibits A through F) ofthe Department ofRevenue as of and for the year ended June 30, 1995. These financial statements are the responsibility of the Department's management. Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free ofmaterial misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. As described in Note 1, these financial statements were prepared on a prescribed basis of accounting that demonstrates compliance with the budgetary statutes and regulations of the State of Georgia, which is a comprehensive basis ofaccounting other than generally accepted accounting principles. In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position (statutory basis) ofthe Department ofRevenue as of June 30, 1995, and the results of its operations (statutory basis) for the year then ended, on the basis ofaccounting described in Note 1. Our audit was made for the purpose offorming an opinion on the financial statements taken as a whole. The accompanying supplementary information (Exhibit G and Schedules 1 through 6) is presented for purposes ofadditional analysis and is not a required part ofthe financial statements of the Department ofRevenue. Such 95ARL-l infonnation has been subjected to the auditing procedures applied in the audit of the financial statements and, in our opinion, is fairly presented in all material respects in relation to the financial statements taken as a whole. Respectfully submitted, ~~~t~ Claude L. Vickers State Auditor CLV:cm 95ARL-l FINANCIAL STATEMENTS - I- ASSETS Cash and Cash Equivalen1s (See Schedule) Accounts Receivable s - Appropriation Federal Financial Assistance Other Prepaid Hems lnventDries Fixed Assets Equipment Amount 10 be Provided for Payment of Accrued Compensated Absences Total Assets LIABILITIES AND FUND EQUITY Liabilities Cash OWrdraft Accounts Payable Payroll Wllhholdings Funds Held for Others Compensated Absences Total Liabilities Fund Equity Investment in General Fixed Assets Fund Balances Reserved Inventories S - Revenue Collections Fund Unreserved Designated Surplus Total Fund Eqoity Total Liabilities and Fund Equity GOVERNMENTAL FUND TYPES STATE REVENUE BUDGET COLLECTIONS s 1,225,715.24 $ s 10,119,706.78 0.00 48,673.58 $ 10,168,380.36 $ 89481.67 $ 36.47e.os 605614.64 $ 11 520 0"...5.33 $ 605614.64 0.00 11,1TT,838.12 2,561.04 $ 11,1eo,,.1s.16 $ 3S 000.00 $ 605,614.64 30C 616.17 $ 339,616.17 $ 605,614.64 $ 11,52':J,035.33 $ 605614.64 The notes 10 lhe financial s1atements are an integral part of this s1atement -2- EXHIBIT"A" FIDUCIARY FUND TYPE AGENCY ACCOUNT GROUPS GENERAL GENERAL FIXED LONG-TERM ASSETS DEBT TOTALS !Memorandum On!l'.l JUNE 30, 1995 JUNE 30, 1994 $ 9 744,351.08 $ 11,575,680.96 $ 18,119,980.79 $ 10,119,706.78 $ 0.00 48,673.58 $ 10 168,380.36 $ $ 89,461.67 $ $ 36,478.06 $ 5,665,034.55 27,502.69 810,774.12 6,503 311.36 15,685.20 38,227.30 $ 8,527,609.11 $ 8,527,609.11 $ 7,825,049.24 $ 4,348,805.14 $ 4,348,805.14 $ 4,226,567.10 $ 9744351.08 $ 8527609.11 $ 4 348 805.14 $ 34 746 415.30 $ 36 728 820.99 $ 9,744,351.08 $ 9,744,351.08 $ $ 4,348,805.14 $ 4,348,805.14 $ 0.00 $ 11,177,838.12 2,581.04 9,744,351.08 4,348,805.14 25,273,575.38 $ 75,226.33 5,995,476.96 4,170.25 13,206,212.64 4,226,567.10 23,507,653.29 $ 8,527,609.11 $ 8,527,609.11 $ 7,825,04924 39,000.00 805,614.64 46,000.00 4,913,768.15 $ 8,527,609.11 300,616.17 436,350.32 $ 9,472,839.92 $ 13,221,167.71 9 744 351.08 $ 8 527 609.11 $ 4 348,805.14 $ 34 746,415.30 $ 36,728,820.99 -3- DEPARTMENT OF REVENUE COMBINED STATEMENT OF CHANGES IN FUND BALANCES /STATUTORY BASIS} GOVERNMENTAL FUND TYPES VEAR ENDED JUNE 30 1995 EXHIBIT"B" FUND BAI .wees JULV 1 RUnNISOIWd Dosignatad Surplus ~ Adjustments to Prio, Yoafs Accounts Payable Call Raooipls for the Year Elchibit"E" Excess d Funds Available O\l8t' Elcpendiluros Elchlblt"C" Raimbursement d Priot Yeofs Elcpendiluros PEQUCTIONS UnNISOIWd Fund Balanc:e (Surplus) Returned to Office olTIMSUry and Fosc:al Services Year Ended June 30, 1993 Year Ended June 30,, 199-4 Cash Disbursements for the Year Exhibit RasaMld Fund Balanc:e Carried Ovarlrom Prior Year as Funds Available FLJNQ BALANCES IUNF (To Elchiblt "A") BUDGET STATE REVENUE COLLECTIONS TOTALS tMemorandum Q!!!l:l YEAR ENDED JUNE 30, 1895 JUNE 30, 1994 5,000.00 $ 4,813,768.15 $ 4,959,768.15 $ 1,415,751.90 436,350.32 482,350.32 4,813,768.15 $ 436.350.32 5,396,118.47 366,249.11 1,782,001.01 24,721A2 24,721.42 $ 9,179,383,393.95 9,179,383,383.95 314,894.75 314,894.75 0.00 0.00 339,616.17 $ 9,179.393,383.95 $ 9,179,733,010.12 30,612.11 8,510,988,539.70 447,59121 4,147.00 8,511,470,890.02 0.00 436.350.32 0.00 436,350.32 $ 9,183,701,547.I 9,183,701,547.I i!XXJOO 1,000.00 12,350.32 $ 9,183,701,547.I $ 9,184,183,897.78 366,249.11 0.00 8,507,438,052.15 52,471.30 8.507.856,m.56 339,616.17 $ 605,614.64 $ 945,230.81 $ 5,396,118.47 The notes to the financial statements are an integral part of this statement. DEPARTMENT OF REVENUE STATEMENT OF FUNDS AVAIi ABLE AND EXPENDITURES BUDGET FUND YEAR ENnED JUNE 30 1995 EXHIBIT"C" FUNDS AVAILABLE REVENUES STATE APPROPRIATION General Appropriation Amended Appropriation Total S-App,oprialion FEDERAL REVENUES (See Schedule) OTHER REVENUES RETAINED Indirect Services Funding Department of Administralhle SeNice& Unclaimed Property Receipts Total Other Rewnues Retained Total Rewnues CARRY-OVER FROM PRIOR YEAR Transfer from Reserved Fund Balance Federal Financial - n e e lnventones Total carry-Over from Prior Year Total Funds Available EXPENDITURES PERSONAL SERVICES Salaries and Wages Employer's Contributions for. F.I.CA Retirement Health Insurance Personal Liabillty Insurance Unemployment Compensation Insurance Workers' Compensation Insurance Assessments by Merit System Drug Testing REGULAR OPERATING EXPENSES Motor Vehicle Expenses Supplies and Materials Repairs and Maintenance Ulillties Rents (Other than Real Estate) Insurance and Bonding Other Operating Expenses (See Schedule) Ex!rao.30 156608.94 $ $ 33,360,300.71 39710.'5 33,400,011.16 101938.83 $ 33,298,072.33 429376.68 s _ _;::;33;;i;72=7.:;449=.o..,1 552,396.46 1249912.75 $ $ 31,495,763.12 >S 751.81 $ 1,802,309.21 23624.87 1,825,934.08 31 901 514.93 33 727 449.01 403.07 19.28 $ s _ _...,.99=1033=.::o._3 422.35 990610.68 991 033.03 See notes to the financial statements. -38- PEPA,RJMENT OF BMNUE ANALYSIS QF STATE BE\fENUE COLLECTIONS YEAR fNDEP JUNE 39 1995 SCHEDULE"6" TAXES BMFP ON SALES Sales and Uae Tax Monthly Collections by General Accounting Office Regular Motor Fuel Pena- ndlRegular Motor Fuel I.Mo: Refunds Through Olfoce of T.--ury and Flocal Services Regular Motor Fuel 3,557,527,701.56 141 705 455.31 $ 3,699,233,156.87 $ 6,109,751.82 297379.35 6407131.17 $ 3,705,640,288.04 $ 21,094,505.55 16964.35 21111 469.90 $ 3 684 528 818.14 Commieolons Paid o n - . Regular Motor Fuel Net to State Regular Motor Fuel Cash Balance July 1, 1994 June 30, 1995 $ 35,475,213.54 3 390 626.69 $ 38,865,840.23 $ 3,506,939,197.00 138 595 243.62 3,645,534,440.62 $ -188,131.54 316668.83 128537.29 $ 3 684 528 818.14 See notes to the financial statements. -39- DEPARTMENT OE BMNUE ANALYSIS QF STATE BE\/ENUE COLLECDONS YEAR ENPEP JUNE a0 1995 SCHEDULE"6" TAXES SASEP ON SALES Alcoholic-Beer Matt Beverage Tax I.Ma: Reru- Through Office of Treasury and Foocal 5enrices NettoS- CUh Balance July 1, 1994 $ June 30, 1995 Liquor Stamp Sales Lea: Refund& Through Office of Treasury and FISCal services Netto State Wine Wine Tax Leos: Refu- Through Office of Treasury and FIIC81 Services Netto State Cigars and Cigarettes Stamp Sales Leas: Refunds Through Office of Treasury and FISCal services Commisaions Paid on Above (Retained at Collecting Source) Netto State cash Balance July 1, 1994 $ June 30, 1995 $ $ -300.00 -100.00 70,568,505.58 9951.25 $ 70,558,954.33 ~.00 70 558 554.33 $ 70 558 554.33 $ 34,056,331.79 4,223,972.09 $ 29 832 359.70 $ 29 832 359.70 $ 14,297,800.56 7,176.25 $ 14 290 624.31 14 290 624.31 $ 88,986,400.37 146,440.85 $ 88 837 959.52 $ -3, 736,080.00 10639.78 2,661,239.88 89,923,439.44 -3 746 719.78 $ 88 837 959.52 See notes to the financial statements. -40- PEPABJMENT OF REVENUE ANALYSIS OE STATE BE\/ENUE COLLECTIONS VEAR FNPFP JUNE 30 1995 SCHEDULE"6" TAXES BASED ON SALES - -MotorFuel Collecliona A,,iation Dealers Special Fuel Dealers llielel Operators Bonded L. P. Gao Operators Bonded Second Motor Fuel Tax on OUl-of-State carriers Undistributed by Fuel Type Penalties and lntereot CcmmlMiono Allowed Motor C.rrier Mileage Tax Collectiono Undistributed by Type Penalties and Interest Late FHings Leo&: Tolal Returned Checks Through Motor Fuel Revolving Accounts Refura Through Office of Treasury and Foscal Services Agriculture MotorC.rrier Retail Dealers Ccmmisalono Paid on above (Retained at Collecting Source) Netto Slate Cash Balance July 1, 1994 June 30, 1995 74,442.21 301,342,137.82 432,145.82 83,429,425.81 406,991.57 460,275.41 491,083.70 798 738.90 $ 387,435,241.24 2 835 798.61 $ 390,271,039.85 3.470,659.28 180,156.55 293,681.01 40107.13 3,984,603.97 1,593,243.06 9,240,770.02 127.272.16 246,753.82 10 961 285.24 $ 383 047 604.76 6,264.06 1718.65 2,835,798.61 380,203,823.44 7982.71 $ 383 047 604.76 See notes to the financial statements. -41- CEe6BIMEKr QE B~NUE ANAi YIS QE STATE RFVENUE COLLECTIONS VEAR ENPEP JUNE 30 1@ SCHEDULE"6" FINES ANC FOBEEITYBES Beer-Ma-- Liquor W,ne Cigars and Cigarettes BOND FQBEEmJBES s -e&0.00 $ 38,654.n ~ ~.856.15 $ 110,5116.21 379,205.15 2 002 874.69 IQIAL e,996.15 1~,250.93 379,205.15 2 002 874.69 s 37994.n s 2 542 332.20 S 2580326.92 Netto Slate $ 2 580328.92 eE~E QFEl"EBS ANtl PBQSE"YIQBS lBAl~IN~ E!JNQ Fees from Court Fl,- and Bond Folfeitures Netto Slate Cnh Balance July 1, 1994 $ June 30, 1995 $ 15 004 266.92 s -12,687.43 308518.50 14,708,435.85 295831.07 s 15 004 268.92 \JNQLAIMcC! ~!lQPc!lIY Proceeds from Sale of Abandoned Property Netto State $ 18 277 697.68 s 18 277 697.68 TAIi; Q!:l!LC!!l~N':i I!lUllT F!,!t!C! Fees from Marriage Licenses and Divorce cases Netto State Cnh Balance July 1, 1994 June 30, 1995 $ 1 209575.00 $ 1,209,225.00 $ -100.00 450.00 350.00 $ 1 209575.00 See notes to the financial statements. DEPARTMENT QF REVENUE ANALXS1SOE STATE REVENUE COLLECTIONS YEAR ENDED JUNE 30 1995 SCHEDULE"6" EARNING GfNfRAL GQYERNMENT Local Option Sales Tax Collection Cost MARTA Sales Tax Collection Cost MolorCll!rioR' FMolor Fuel Truck Regiotndion Decals Temporary Permits Penaltioo to, Non-Registration RaUroad car Tax Collection Coot Real Ellale Transfer Tax Collection Cost Special Purpooe Sales Tax Collection Coot otherFFeea on Contracts Liquor IIMllligation Fees Miocella,_. Collecliono Molar Fuel Dealeni Regl11tration Fee& Penaltioo and lnten,st Motor Fuel Unallocated Collections. Motor Fuel Unallocated Collections. Alcohol and Tcbacco Leu: Refunds Through Office of T,-ury and Fiscal Serw:eo Net to Slate CUh Balance July 1, 1994 June 30,1995 $ 6,623,856.42 2,247,225.31 2,608,595.00 339040.00 $ 2,947,635.00 58549.01 4,no.oo 82,500.00 5,249,801.96 2,820.00 14,600.00 30,719.39 1,106,907.76 30618.80 3,006, 184.01 29,221.94 151,825.06 4,764,391.96 6481450.33 $ 23 284155.03 $ 23,848,713.08 -632,227.09 69669.04 $ 23 284155.03 See notes to the financial statements. SECTION II FINDINGS AND IMPROPER OR QUESTIONED COSTS DEPARTMENT OF REVENUE SCHEDULE OF FINDINGS AND IMPROPER OR QUESTIONED COSTS YEAR ENDED JUNE 30 199S STATUS OF PRIOR YEAR FINDINGS AND IMPROPER OR QUESTIONED COSTS The status ofthe findings disclosed in the report for the year ended June 30, 1994, is summarized below: Audit Control Number Status ofFinding 474-94-01 474-94-02 Corrective Action Implemented Corrective Action Implemented CURRENT YEAR Cash and Cash Equivalents Uncollateralized Time Deposit Financial Statements Audit Control Number 474-95-01 At June 30, 199S, the Department ofRevenue failed to have the following time deposit fully collateralized as provided for by the Official Code of Georgia Annotated Section S0-17-59: First Union National Bank, Macon, Georgia Certificate ofDeposit Amount: $320,353.44 This condition resulted from the Department's failure to ensure that the bank had provided collateral for the amount of the time deposit in excess of the Federal depository insurance amount of $100,000.00. This resulted in $220,353.44 of the time deposit being uncollateralized. The Department should establish the necessary controls to ensure that all time deposits are fully collateralized in compliance with state laws governing deposits and investments.