Audit Advisory Board Agreed Upon Procedures

Gcfjrp

Description

City Audit Board Agreed Upon Procedures September 10, 2008  1. Verify the accuracy of the schedule provided, including all calculations.   2. For any funds in which the fund balance represents more than 3‐months of operating expenditures, obtain an explanation/justification for the balance from management. 3.   If the representation regarding the fund balance indicates amounts that may be in           excess of operational needs, obtain additional representation about potential options to either reduce or lapse any excess fund balance.  4.  For any funds in which the fund balance is less than zero, obtain an explanation/ justification for the balance from management.  5.  For any fund with a designation for debt service, is the designation for debt service in excess of the actual outstanding debt. If so, provide an explanation/justification for the designation.  6.  Inquire of management whether there is any information that would lead management to believe the fiscal year 2007 fund balance designations are not appropriate. If so, have management provide further explanation.   Governmental FundsGeneral Street Federal Advance Athletic Field Cable Lincoln City Lincoln Area Tax SaleFund Construction Grants Acquisition & Fac Impr Access Libraries Ag on Aging Revolving1101 1211/1402 1214 1201 1202 1203 1204 1205 1206Fiscal Year 2004/2005Beginning Fund Balance 35,973,419 38,732,945 16,340,308 826,799 303,869 0 2,661,182 317,387 656,620Operating Revenues ...

Informations

• Publié par: Zoed
• Nombre de lectures: 281
• Langue: English

Extrait

CityAuditBoard AgreedUponProcedures September10,2008 1. Verifytheaccuracyofthescheduleprovided,includingallcalculations. 2. Foranyfundsinwhichthefundbalancerepresentsmorethan3‐monthsofoperating expenditures,obtainanexplanation/justificationforthebalancefrommanagement. 3.Iftherepresentationregardingthefundbalanceindicatesamountsthatmaybein excessofoperationalneeds,obtainadditionalrepresentationaboutpotentialoptionsto eitherreduceorlapseanyexcessfundbalance. 4.Foranyfundsinwhichthefundbalanceislessthanzero,obtainanexplanation/ justificationforthebalancefrommanagement. 5.Foranyfundwithadesignationfordebtservice,isthedesignationfordebtservicein excessoftheactualoutstandingdebt.Ifso,provideanexplanation/justificationforthe designation. 6.Inquireofmanagementwhetherthereisanyinformationthatwouldleadmanagement tobelievethefiscalyear2007fundbalancedesignationsarenotappropriate.Ifso,have managementprovide furtherexplanation.

Advance Acquisition 1201

59,243 19,143,000

19,143,000

54 63 No

(18,010) 256,233

Street Construction 1211/1402

19,373

670,390

Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

Cable Access 1203

Athletic Field & Fac Impr 1202

Governmental Funds

(584,458) (584,458) 18,558,542

35 121 70 154 > 25%No

Undesignated Fd Balance in Days of Revenues78 279(9) 10,0101,368 Unreserved Fd Balance in Days of Revenues91 522(9) 10,0101,368 Further Review?> 25%> 25%No >25% >25% No Are there revenues? Is there o/s debt related to this fund?yes ^yes @no no no no If so, how much? (as of 8/31/07)16,320,260 If so, when is the last payment date?3/15/2017 5/15/2027 * Notes: * LeasePayable @8/31/07 of$166,784in Information Service Fund  Internal Service Fund Type. @ Providesfunds for Highway User Allocation Bonds in 1306. ^ LeasesOutstanding Page 1 of 4

(719,513) 6,818

Tax Sale Revolvin 1206

Lincoln Area A 1205

76,652 (47,346) 2,518,610 3,374,715

826,799

303,869

(9,400) 362,393

34,214,006 (50,949,185) 5,598,107 17,664,311

108,876,525 (95,289,084) (12,466,775) 30,412,704

531,436 417,321

109,388,803 (96,184,725) (15,315,314) 29,292,038

no

no

(224,237) 205,854

67,924

7,393,820 (7,345,809) (13,066) 0 2,696,127

Lincoln Cit Libraries 1204

0 2,661,182317,387 656,620

67,698

217,386 (80,754)

7,646,264 (7,427,043) 920 2,916,268

no

0

68 68

6,818 6,818 6,818

1,456,586 (4,310,244) 2,690,983 251,820

1,531,776 (4,424,039) 2,949,382 414,495

1,439,494 (4,394,757) 2,995,252 357,376

7,644,770 (7,339,835) 516 3,221,719

381,788 (444,981)

22,921,047 (20,528,480) 635,728 17,575,827

83,191 (1,224,323) (1,030,015) 1,203,568

136,632

68,389

38,503 (51,866) (134,291) 1,055,914

35,973,419 38,732,945 16,340,308

104,565,234 (91,578,950) (17,556,429) 31,403,274

689,763

36,568

21,313,952 (23,389,461) 282,733 14,547,532

41,262,739 (55,760,315) 4,566,014 28,801,383

Fiscal Year 2006/2007 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

13,770

Fiscal Year 2006/2007 Endin Reserved For: Inventories Prepaid Items Grantor Loan Programs Debt Service Health Care (nonexpendable)

Federal Grants 1214

Improvements Restricted Funds

32,461,555 (37,136,717) 33,528,568 46,517,717

22,681,905 (22,215,483) 516,293 18,558,542

Unreserved: Designated for Debt Service Designated for Subsequent Yrs Exp Designated for Encumbrances Undesignated

0

0

0

Fiscal Year 2005/2006 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

59,243

379,035 3,079,398 569,068 23,188,433 27,215,934 30,412,704

Fund Balance

Fiscal Year 2004/2005 Beginning Fund Balance

73,439

8,296 28,727 214,797 251,820 251,820

9,309 21,659,898 24,789,267 46,458,474 46,517,717

256,233 256,233 256,233

85 36,438 36,916 73,439 73,439

616,422 70,247 2,535,050 3,221,719 3,221,719

1,055,914 1,055,914 1,055,914

1,593,303 654,710 3,196,770

0

General Fund 1101

0

1,923,631 (1,842,394)

0

0

3,613 3,083,131 3,086,744 3,086,744

480,205

95,000

0

20,008 1,008,000 428,587 0 1,456,595 0 1,936,800

0 0 No

no

no

no

no

Governmental Funds

4,962,893 (10,102,558) 5,041,265 123,566

221,966

Snow Removal 1208

Linc/Lanc Co Health 1207

Fiscal Year 2004/2005 Beginning Fund Balance

Social Securit 1210

StarTran 1218

Fiscal Year 2006/2007 Endin Reserved For: Inventories Prepaid Items Grantor Loan Programs Debt Service Health Care (nonexpendable)

1,613,277 1,792,708 1,792,708

179,431

Fund Balance

23,780 19,148 173,489 216,417 216,417

202,045

Improvements Restricted Funds

7,953

306,612 314,565 323,065

1,077 367,141 1,191,941 1,560,159 1,762,204

2,133,856 (1,950,491)

1,609,343

0

2,899,912 8,300,490 (2,899,912) (14,731,219) 5,859,834 0 1,936,800

7,245 2,835,328 (17,275) (1,462,530) (1,018,581) 244,885 3,326,176

12,581 2,976,753 (21,378) (1,858,974) (1,357,211) 236,088 3,086,744

Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

5,467,596 (16,216,113) 10,924,668 299,717

480,205

Unreserved: Designated for Debt Service Designated for Subsequent Yrs Exp Designated for Encumbrances Undesignated

Undesignated Fd Balance in Days of Revenues12 39273 276 Unreserved Fd Balance in Days of Revenues15 51375 307 Further Review?No >25% No> 25%No Are there revenues? Is there o/s debt related to this fund?yes ^no yes^ nono If so, how much? (as of 8/31/07)6,165,000 140,000 If so, when is the last payment date?8/31/2027 8/15/2009 * Notes: * LeasePayable @8/31/07 of$166,784in @ Providesfunds for Highway User Allocati ^ LeasesOutstanding

8,500

202,045

1,792,708

Page 2 of 4

0

8,500

0

0 1,908,297270,200 3,202,274131,606

19 4,093378 1,449 64 6,849378 1,449 > 25%> 25%> 25%

1,531,680 (3,143,079) 1,857,930 323,065

1,109,195 (2,810,817) 1,678,957 1,762,204

2,282,159 3,000,967 (2,282,159) (8,169,080) 5,508,255 0 2,248,439

Fiscal Year 2005/2006 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

1,402,452

911

1,624,682 (3,133,871) 1,487,947 82,618

1,043,408 (2,347,315) 1,700,045 1,275,848

1209

879,710

5,246,322 (10,351,267) 5,021,645 216,417

1,967,317 (1,841,663)

103,860

141,088 236,088 236,088

Fiscal Year 2006/2007 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

59,486 (639,283) 528,694 236,150

5,588 3,076,903 (20,873) (1,762,333) (1,544,885) 254,915 2,971,959

Unemplo Compensation 1212

75,192 (610,999) 817,758 287,253

Police & Fire Pension Contrb 1219

1,058,222 (2,131,618) 1,582,417 1,784,869

1,414,779 (3,148,213) 1,727,350 76,534

236,150 236,150 236,150

2,909,024 3,336,042 (2,909,024) (8,761,749) 5,684,963 0 2,507,695

32,607 (643,947) 485,036 5,302

Special Assessments 1215

Keno 1213

1,528,106

Page 3 of 4

0 0 No

yes yes yes 9,313,000 61,020,00071,595,000 12/1/2020 6/1/20275/15/2027

0 0 No

0 4,766,048

0 5,327,078

Fund Balance

Improvements Restricted Funds

(7,867)

923 2,092 1,114 933 2,092 1,114 > 25%> 25%No

292,547 292,547 292,547

8,500 769,700 778,200 778,200

5,759,145 (6,320,847) 284,268 6,633,214

388,952

259,690

6,910,648

Bond Interest Tax Supported & RedemptBonds 1302 1304/1305/1306

5,600

108,901 (108,114)

299

5,441

159

12,976 20,432 4,307,938 4,341,346 4,341,346

(8,217)

98,575 (98,225)

Propert Refunds 1216

Impact Fees 1220

Buildin Safet 1217

Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

Fiscal Year 2004/2005 Beginning Fund Balance

4,955,797

4,379,426 (5,188,128) 807,043 4,954,138

0 0

372,323 (252,090) (11,941) 594,374

Parks & Rec Spec Pro 3111

486,082

Seniors Foun of Linc/Lanc 3112

Governmental Funds

0 3,883,753

97,094 1,843,752 (164,593) (877,660) (1,336,797) 321,453 5,210,292

no

0

0

0 5,327,078 4,766,0483,883,753

0

no

no

6,016,213 (7,057,740) 2,582,323 4,766,048

(24) (24) > 25%

0

104,209 2,273,894 (107,526) (977,211) (1,179,897) 318,136 5,327,078

292,547

279,653

3,184,839 (7,154,778) 561,977 3,225,252

5,899

(7,080)

Librar Special Trust 3113

Tax Allocation 1301

Unreserved: Designated for Debt Service Designated for Subsequent Yrs Exp Designated for Encumbrances Undesignated

4,766,048

3,883,753

0

5,327,078

Fiscal Year 2006/2007 Endin Reserved For: Inventories Prepaid Items Grantor Loan Programs Debt Service Health Care (nonexpendable)

5,899 5,899 5,899

(7,080) (7,080) (7,080)

69,724 (49,761)

277,181 (199,340) (157) 672,058

85,948 (91,499)

(2,666)

116

5,325

3,187,150

1,435,325 (3,236,002) 1,818,460 3,204,933

304,492 (197,162) (1,188) 778,200

51,031 (38,137)

1,640,345 (2,983,736) 1,566,138 3,427,680

57,679 (58,752)

260,763

93,937 (151,787)

1,751,506 (901,711) (502,663) 5,580,997

5,233,865

446,802

4,101,492 (5,292,116) 756,400 4,341,346

1,872,208 (3,474,569) 2,058,434 3,883,753

318,136 318,136 318,136

Fiscal Year 2006/2007 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

4,280,185 (5,252,672) 793,919 4,775,570

Fiscal Year 2005/2006 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

Undesignated Fd Balance in Days of Revenues Unreserved Fd Balance in Days of Revenues Further Review?> 25% Are there revenues? Is there o/s debt related to this fund?no If so, how much? (as of 8/31/07) If so, when is the last payment date? * Notes: * LeasePayable @8/31/07 of$166,784in @ Providesfunds for Highway User Allocati ^ LeasesOutstanding

383 7,201 386 7,201 > 25%No < $1000 no no

2002 AntVal Bonds 1413

0

0

0

486,658 2,535,236 0 3,021,894 0 3,021,894

0

2,260,912 11,860,309 0 14,121,221 0 14,121,221

no

1,895,311 (95) (474,196) 8,491,735

Governmental Funds

9,933,914 9,933,914

Vehicle Tax 1403

9,933,914

Storm Sewer Bonds 1407

Storm Sewer Construction 1401

1999 GOVP Bonds 1411

1,811,880

2,839,207

78,495 8,252,191 (1,045,084) 924,921 (5,419,006) 165,735 5,672,392

207,403

37,118 (752,785)

793 882,95727,360 152,9721,352,077 (7,725,891) (16,306)(1,205,811) (7,238,144) (116,597) 10,095,926(746,684) 3,883,489 6,102 17,102,4161,076,250 1,317,992 2,076,726

941

121,906 13,849,424

Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

Fiscal Year 2004/2005 Beginning Fund Balance

2,370,831

Other Capital Pro 1409

4,079,304

Downtown Redev Bds 1405

1991 GOVP Bonds 1404

44,677

79,023 79,023 79,023

Fiscal Year 2005/2006 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

Undesignated Fd Balance in Days of Revenues0 4,190273 7,256No Revenue?3,229 598 Unreserved Fd Balance in Days of Revenues1,824 4,263273 7,256No Revenue?3,844 598 Further Review?> 25%> 25%> 25%> 25%> 25%> 25%> 25%No Are there revenues?< $1000 Is there o/s debt related to this fund?no no no no no no no no If so, how much? (as of 8/31/07) If so, when is the last payment date? * Notes: * LeasePayable @8/31/07 of$166,784in @ Providesfunds for Highway User Allocati ^ LeasesOutstanding

1,988,294 (88) (546,027) 9,933,914

1,299

39 977,33331,085 (7,753,584) (6,141) 13,977 0 10,340,1421,107,335

962,175 (11,343,955) 9,876,113 1,571,059

Fiscal Year 2006/2007 Operating Revenues Operating Expenditures Net Other Financing Sources/Uses Ending Fund Balance

45,618

0 638 0 760 > 25%

16,438 9,426,531 (42,185) 191,201 (8,214,900) 191,975 7,051,220

7,051,220 7,051,220 7,051,220

0

49,402

0

3,286 188,689 191,975 191,975

Fund Balance

Unreserved: Designated for Debt Service Designated for Subsequent Yrs Exp Designated for Encumbrances Undesignated

Improvements Restricted Funds

602,325

16,503 1,451,351 (618,828) (8,021,477) 8,020,961 0 3,021,894

Special Assessments 1303

1,340,722 48,240 (5,143,147) (13,317) 7,583,504 (1,063,235) 0 14,121,22179,023

0

0

0

49,402 49,402 49,402

7,344,884

1,561,069 (104,433) (1,730,805) 7,070,715

Fiscal Year 2006/2007 Endin Reserved For: Inventories Prepaid Items Grantor Loan Programs Debt Service Health Care (nonexpendable)

23,888 8,419,997 (180,515) 17,413 (8,252,800) 26,521 5,839,589

Page 4 of 4

46,917

2,485