CITY OF SEVEN HILLS OFFICE OF THE DIRECTOR OF FINANCE …

GENERAL FUND

SPECIAL REVENUE FUNDS 201 STREET MAINT AND REPAIR FUND 202 STATE HIGHWAY MAINTENANCE FUND 203 PARK EQUIPMENT FUND 204 DWI ENFORCEMENT FUND 205 MANDATORY DRUG FINE FUND 206 LAW ENFORCEMENT TRUST FUND 207 SEWER TAP IN FUND 208 FIRE DEPT SQUAD ASSISTANCE FD 209 REFUSE DISPOSAL FUND 211 TREE FUND 212 CITY OWNED VEHICLE FUND 213 FIRE LEVY 214 COMPENSATED ABSENSE FUND 215 SERVICE DEPT EQUIPMENT FUND 217 FIRE ACT GRANT 218 COPS GRANT 219 BULLETPROOF VEST PROGRAM 220 CITIZENS EMERGENCY RESPONSE 221 MAYOR'S COURT COMPUTER FUND 222 FEMA GRANT FUND 223 BYRNE JAG GRANT FUND 224 BROADVIEW ROAD TIF 225 PINNACLE ROCKSIDE TIFF 250 POLICE DISABILITY & PENSION FD

TOTAL SPECIAL REVENUE FUNDS

DEBT SERVICE FUNDS 310 GENERAL BOND RETIREMENT 320 SPEC ASSESSMENT BOND RETIREMNT

TOTAL DEBT SERVICE FUNDS

CAPITAL PROJECTS FUNDS 409 HILLSIDE ROAD RECONSTRUCTION 422 COMMUNITY REC. CENTER PROJECT 429 2019 ROAD PROGRAM 431 CONNECTOR TRAIL

CITY OF SEVEN HILLS OFFICE OF THE DIRECTOR OF FINANCE

FUND CASH BALANCE SHEET FOR THE MONTH ENDING April 30, 2019

PAGE 001

Beginning Year

Balance

5,788,599.82

Year-to-date Year-to-date

Actual

Expenditures/

Receipts

Expenses

3,861,481.46 3,320,412.21

Unexpended Balance

6,329,669.07

Outstanding Encumbrances

1,520,177.08

Unencumbered Balance

4,809,491.99

679,244.74

164,238.51

231,437.54

612,045.71

117,781.23

494,264.48

99,470.35

26,052.35

0.00

125,522.70

0.00

125,522.70

83,158.93

0.00

4,764.90

78,394.03

26,338.87

52,055.16

3,994.04

145.50

0.00

4,139.54

0.00

4,139.54

0.00

0.00

0.00

0.00

0.00

0.00

5,593.44

4,204.00

1,737.00

8,060.44

514.70

7,545.74

111,572.91

1,307.74

4,720.75

108,159.90

35,316.25

72,843.65

720,265.90

115,536.97

306,100.78

529,702.09

306,110.96

223,591.13

1,410,498.04

486,100.31

274,691.79 1,621,906.56

658,572.52

963,334.04

40,900.11

0.00

0.00

40,900.11

0.00

40,900.11

0.00

0.00

0.00

0.00

0.00

0.00

52,173.98

860,926.24

621,523.25

291,576.97

141,230.59

150,346.38

199,647.89

0.00

0.00

199,647.89

0.00

199,647.89

570,138.35

83,799.07

93.04

653,844.38

223,310.91

430,533.47

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

67,670.60

655.00

0.00

68,325.60

0.00

68,325.60

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

14,503.88

51,838.69

0.00

66,342.57

0.00

66,342.57

111,735.24

39,580.69

0.00

151,315.93

0.00

151,315.93

0.00

0.00

0.00

0.00

0.00

0.00

______________ ______________ ______________ ______________ ______________ ______________

4,170,568.40 1,834,385.07 1,445,069.05 4,559,884.42 1,509,176.03 3,050,708.39

520,017.47 7,256,636.25 7,012,835.96

763,817.76 1,876,030.22

29,853.58

103,791.71

1,923.67

131,721.62

172,364.39

______________ ______________ ______________ ______________ ______________ ______________

549,871.05 7,360,427.96 7,014,759.63

895,539.38 2,048,394.61

0.00 0.00 30,518.39 0.00

0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00

0.00 0.00 30,518.39 0.00

0.00 0.00 0.00 0.00

0.00 0.00 30,518.39 0.00

CAPITAL PROJECT FUNDS (CONT'D) 434 BROADVIEW/CHERRY/HILLSIDE 435 WESTCREEK -PHASE2/PHASE3 SEWER 436 HEMLOCK CREEK WATERSHED SS PRO 437 SWIF GRANT/PROJECT RAIN FUND 438 2018 Water Main 439 CAPITAL IMPROVEMENT FUND 440 RENEW ENERGY PROGRAM

TOTAL CAPITAL PROJECTS

ENTERPRISE FUNDS 501 SANITARY SEWERS 502 STORM SEWERS

TOTAL ENTERPRISE FUNDS

TRUST AND AGENCY FUNDS 702 BBS ASSESSMENT FUND 703 BUILDING BOND DEPOSIT FUND 704 DEVELOPER'S DEPOSIT FUND 705 PLANNING COMMISSION DEPOSIT FD 706 ARCHITECTURAL PLAN REVIEW FUND 707 PLATE CHECK FUND 708 TOPOGRAPHICAL CHECK FUND 709 MISCELLANEOUS CLEARANCE FUND 710 OTHER ENGINEERING FUND 711 EMPL HEALTH DEDUCTIONS & COBRA

TOTAL TRUST AND AGENCY

TOTAL ALL FUNDS

CITY OF SEVEN HILLS OFFICE OF THE DIRECTOR OF FINANCE

FUND CASH BALANCE SHEET FOR THE MONTH ENDING April 30, 2019

PAGE 002

Beginning Year

Balance

Year-to-date Year-to-date

Actual

Expenditures/

Receipts

Expenses

Unexpended Balance

Outstanding Unencumbered

Encumbrances

Balance

$ 0.00

$ 0.00

$ 0.00

$ 0.00

$ 0.00

$ 0.00

0.00

0.00

0.00

0.00

0.00

0.00

2,309,524.26 1,035,500.00 1,601,865.18 1,743,159.08

697,565.46 1,045,593.62

0.00

0.00

0.00

0.00

0.00

0.00

0.00 1,018,872.95

0.00 1,018,872.95 1,007,388.57

11,484.38

0.00

0.00

0.00

0.00

0.00

0.00

14,550.44

0.00

0.00

14,550.44

0.00

14,550.44

______________ ______________ ______________ ______________ ______________ ______________

2,354,593.09 2,054,372.95 1,601,865.18 2,807,100.86 1,704,954.03 1,102,146.83

604,214.90

25,267.83

86,043.90

543,438.83

50,540.37

492,898.46

555,615.94

58,958.26

120,312.55

494,261.65

51,387.38

442,874.27

______________ ______________ ______________ ______________ ______________ ______________

1,159,830.84

84,226.09

206,356.45 1,037,700.48

101,927.75

935,772.73

823.29

994.98

1,137.67

680.60

0.00

680.60

32,069.63

800.00

19,404.63

0.00

19,404.63

81,726.11

0.00

6,576.00

75,150.11

23,424.00

51,726.11

13,600.00

0.00

0.00

13,600.00

0.00

13,600.00

43,608.01

7,509.50

6,049.00

45,068.51

0.00

45,068.51

126,915.61

0.00

0.00

126,915.61

0.00

126,915.61

0.00

0.00

0.00

0.00

0.00

0.00

21,471.32

0.00

0.00

21,471.32

0.00

21,471.32

12,522.44

0.00

0.00

12,522.44

0.00

12,522.44

6,355.83

15,988.33

16,451.17

5,892.99

5,523.95

369.04

______________ ______________ ______________ ______________ ______________ ______________

339,092.24

12,627.81

31,013.84

320,706.21

28,947.95

291,758.26

14,362,555.44 15,207,521.34 13,619,476.36 15,950,600.42 6,913,577.45 9,037,022.97

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download