September 2017 General Fund

Report 5 Downloads 79 Views
Library Funding (Revenue)

September 2017

General Fund (City)

($

1,702,719.00 )

Grant Funds *

($

64,946.00 )

Gift Funds

($

1,197.50)

Friends of the Library *

($

41,000.00 )

($

1,809,862.50 )

Library Funding (Expenditures)

September 2017

General Fund (City)

($

207,186.32 )

Grant Funds *

($

560.12)

Gift Funds

($

7,019.80)

Friends of the Library (Gift Funds) *

($

197.76)

($

214,964.00 )

* Change over the year.

General Fund (City - Expense)

September 2017

101-6200-455-01-01

Salaries

($

93,045.22)

101-6200-455-01-02

Hourly/Seasonal

($

7,920.39)

101-6200-455-01-03

Administrative Pay

($

53.21)

101-6200-455-01-06

Management Leave Pay

($

5,604.72)

101-6200-455-01-11

Overtime Pay

($

440.27)

101-6200-455-01-25

Temporary Staffing

($

2,006.61)

101-6200-455-01-14

FSLA

($

-  )

101-6200-455-02-25

Medicare

($

1,532.65)

101-6200-455-02-30

Retierment

($

22,477.83)

101-6200-455-02-40

Group Insurance

($

20,477.83)

101-6200-455-02-50

Workers' Compensation

($

2,398.31)

101-6200-455-02-60

Education Incentive

($

400.00)

101-6200-455-03-09

Professional Services

($

2,318.30)

101-6200-455-03-30

Training

($

2,629.25)

101-6200-455-03-46

Facility Contract

($

-  )

101-6200-455-03-49

Contractual Services

($

-  )

101-6200-455-04-30

Equipment Repair and Maintence

($

27.97)

101-6200-455-04-33

Software Maintence

($

306.49)

101-6200-455-04-34

Building Repair and Maintence

($

482.00)

101-6200-455-04-44

Office Equipment Rental

($

58.00)

101-6200-455-05-40

Publicity and Special Events

($

141.44)

101-6200-455-05-42

Printing / Advertising

($

250.00)

101-6200-455-05-45

Membership / Publications

($

-  )

101-6200-455-05-80

Travel

($

2,171.45)

101-6200-455-06-01

Office Supplies

($

129.48)

101-6200-455-06-02

Postage / Shipping

($

-  )

101-6200-455-06-25

Operating Supplies

($

988.91)

101-6200-455-06-43

Janitorial Supplies

($

2,773.38)

101-6200-455-06-45

Books / Periodicals

($

32,170.18)

101-6200-455-06-60

Vehicle Fuel / Oil

($

-  )

101-6200-455-06-75

Small Furnishings

($

-  )

101-6200-455-07-10

Telephone

($

2,865.04)

101-6200-455-07-12

Power

($

3,242.92)

101-6200-455-07-13

Heating

($

274.47)

101-6200-455-09-50

Fleet Management

($

-  )

($

207,186.32)

($

-  )

101-6200-455-77-43

Furniture and Fixtures

PREPARED 09/11/2017, 10:31:50 DETAIL BUDGET REPORT BY CATEGORY PAGE 2 PROGRAM: GM267C 17% OF YEAR LAPSED ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------FUND 101 GENERAL FUND DEPT/DIV 6200 LIBRARY/ BA ELE OBJ ACCOUNT *********CURRENT********** **********YEAR-TO-DATE******* ANNUAL UNENCUMB. % SUB SUB DESCRIPTION BUDGET ACTUAL %EXP BUDGET ACTUAL %EXP ENCUMBR. BUDGET BALANCE BDGT -----------------------------------------------------------------------------------------------------------------------------------45 455 10 01 01 02 03 06 11 25 10 **

CULTURE AND RECREATION LIBRARIES Salaries and Wages SALARIES HOURLY/SEASONAL ADMINISTRATIVE PAY MANAGEMENT LEAVE PAY OVERTIME PAY TEMPORARY STAFFING Salaries and Wages

68798 3750 0 0 0 1250 73798

54094.05 4811.64 .00 4146.72 440.27 1440.69 64933.37

79 128 0 0 0 115 88

137596 7500 0 0 0 2500 147596

93045.22 7920.39 53.21 5604.72 440.27 2006.61 109070.42

68 106 0 0 0 80 74

.00 .00 .00 .00 .00 13490.88 13490.88

825587 45000 0 0 0 15000 885587

732541.78 11 37079.61 18 53.210 5604.720 440.270 497.49- 103 763025.70 14

21 02 25 30 40 50 60 21 **

EMPLOYEE BENEFITS MEDICARE RETIREMENT GROUP INSURANCE WORKERS' COMPENSATION EDUCATION INCENTIVE EMPLOYEE BENEFITS

1062 15200 13214 1690 83 31249

905.61 13259.71 11997.70 1245.84 .00 27408.86

85 87 91 74 0 88

2124 30400 26428 3380 166 62498

1532.65 22477.83 20396.02 2398.31 400.00 47204.81

72 74 77 71 241 76

.00 .00 .00 .00 .00 .00

12747 182400 158574 20280 1000 375001

11214.35 159922.17 138177.98 17881.69 600.00 327796.19

22 03 09 30 46 49 04 30 33 34 44 05 40 42 45 80 06 01 02 25 43 45 60 75 07 10 12 13 09 50 22 **

SERVICE AND SUPPLIES PROFESSIONAL SERVICES TRAINING FACILITY CONTRACT CONTRACTUAL SERVICES EQUIPMENT REPAIR & MAINT. SOFTWARE MAINTENANCE BUILDING REPAIR & MAINT. OFFICE EQUIPMENT RENTAL PUBLICITY & SPEC. EVENTS PRINTING / ADVERTISING MEMBERSHIP / PUBLICATIONS TRAVEL OFFICE SUPPLIES POSTAGE / SHIPPING OPERATING SUPPLIES JANITORIAL SUPPLIES BOOKS / PERIODICALS VEHICLE FUEL/OIL SMALL FURNISHINGS TELEPHONE POWER HEATING FLEET MANAGEMENT SERVICE AND SUPPLIES

3500 666 79 6499 74 458 39 214 470 416 125 291 666 1000 2099 400 14449 35 41 1450 2666 894 306 36837

2318.30 66 398.00 60 .00 0 .00 0 27.97 38 306.49 67 482.00 1236 58.00 27 141.44 30 250.00 60 .00 0 2171.45 746 129.48 19 .00 0 988.91 47 2773.38 693 28570.18 198 .00 0 .00 0 1545.55 107 2268.05 85 174.57 20 .00 0 42603.77 116

7000 1332 158 12998 148 916 78 428 940 832 250 582 1332 2000 4198 800 28898 70 82 2900 5332 1788 612 73674

2318.30 2629.25 .00 .00 27.97 306.49 482.00 58.00 141.44 250.00 .00 2171.45 129.48 .00 988.91 2773.38 32170.18 .00 .00 2865.04 3242.92 274.47 .00 50829.28

33 197 0 0 19 34 618 14 15 30 0 373 10 0 24 347 111 0 0 99 61 15 0 69

4435.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 13125.00 .00 .00 .00 .00 .00 .00 17560.00

42000 8000 950 77991 890 5500 471 2575 5640 5000 1500 3500 8000 12000 25188 4800 173390 420 500 17411 32000 10730 3675 442131

35246.70 16 5370.75 33 950.00 0 77991.00 0 862.03 3 5193.51 6 11.00- 102 2517.00 2 5498.56 3 4750.00 5 1500.00 0 1328.55 62 7870.52 2 12000.00 0 24199.09 4 2026.62 58 128094.82 26 420.00 0 500.00 0 14545.96 17 28757.08 10 10455.53 3 3675.00 0 373741.72 16

0 0

.00 .00

0 0

20560.00 20560.00

0 0

30 CAPITAL OUTLAY 77 43 FURNITURE AND FIXTURES 30 ** CAPITAL OUTLAY

0 0

.00 .00

0 0

20560.0020560.00-

12 12 13 12 40 13

0 0

PREPARED 09/11/2017, 10:31:50 DETAIL BUDGET REPORT BY CATEGORY PAGE 3 PROGRAM: GM267C 17% OF YEAR LAPSED ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------FUND 101 GENERAL FUND DEPT/DIV 6200 LIBRARY/ BA ELE OBJ ACCOUNT *********CURRENT********** **********YEAR-TO-DATE******* ANNUAL UNENCUMB. % SUB SUB DESCRIPTION BUDGET ACTUAL %EXP BUDGET ACTUAL %EXP ENCUMBR. BUDGET BALANCE BDGT -----------------------------------------------------------------------------------------------------------------------------------45 455

CULTURE AND RECREATION LIBRARIES 30 CAPITAL OUTLAY 455 ** ** LIBRARIES

141884

134946.00

95

283768

207104.51

73

51610.88

1702719

1444003.61

15

45

141884

134946.00

95

283768

207104.51

73

51610.88

1702719

1444003.61

15

141884

134946.00

95

283768

207104.51

73

51610.88

1702719

1444003.61

15

141884

134946.00

95

283768

207104.51

73

51610.88

1702719

1444003.61

15

141884

134946.00

95

283768

207104.51

73

51610.88

1702719

1444003.61

15

141884

134946.00

95

283768

207104.51

73

51610.88

1702719

1444003.61

15

** ** CULTURE AND RECREATION

DIV

6200 TOTAL *******

DEPT

62 TOTAL ******* LIBRARY

FUND 101 GRAND

TOTAL ********* GENERAL FUND TOTAL *********

Grant Fund (Expense)

September 2017

275-6200-455-12-13 State Collection Development

($

-  )

275-6200-455-12-40 Community Development

($

-  )

($

60.12)

275-6200-455-12-92 Statewide Reading (Summer Learning Challenge)

($

500.00)

275-6206-455??-??

($

-  )

($

560.12)

NASA @ My Library Makerspace Grant

*MM = Mobile Makerspace Grant

PREPARED 09/11/2017, 10:34:01 DETAIL BUDGET REPORT BY CATEGORY PAGE 2 PROGRAM: GM267C 17% OF YEAR LAPSED ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------FUND 275 GRANT FUND DEPT/DIV 6200 LIBRARY/ BA ELE OBJ ACCOUNT *********CURRENT********** **********YEAR-TO-DATE******* ANNUAL UNENCUMB. % SUB SUB DESCRIPTION BUDGET ACTUAL %EXP BUDGET ACTUAL %EXP ENCUMBR. BUDGET BALANCE BDGT -----------------------------------------------------------------------------------------------------------------------------------45 455 22 12 13 40 50 92 22 **

CULTURE AND RECREATION LIBRARIES SERVICE AND SUPPLIES STATE COLLECTION DEVELOP EL DIA DE LOS NINOS NASA @ MY LIBRARY STATEWIDE READING 2010-20 SERVICE AND SUPPLIES

444 175 0 233 852

.00 .00 60.16 500.00 560.16

0 0 0 215 66

888 350 0 466 1704

.00 .00 60.16 500.00 560.16

0 0 0 107 33

.00 .00 .00 .00 .00

5333 2100 0 2800 10233

5333.00 2100.00 60.162300.00 9672.84

455 ** ** LIBRARIES

852

560.16

66

1704

560.16

33

.00

10233

9672.84

6

45

852

560.16

66

1704

560.16

33

.00

10233

9672.84

6

852

560.16

66

1704

560.16

33

.00

10233

9672.84

6

852

560.16

66

1704

560.16

33

.00

10233

9672.84

6

852

560.16

66

1704

560.16

33

.00

10233

9672.84

6

852

560.16

66

1704

560.16

33

.00

10233

9672.84

6

** ** CULTURE AND RECREATION

DIV

0 0 0 18 6

6200 TOTAL *******

DEPT

62 TOTAL ******* LIBRARY

FUND 275 GRAND

TOTAL ********* GRANT FUND TOTAL *********

PREPARED 09/11/2017, 10:34:32 DETAIL BUDGET REPORT PAGE 1 PROGRAM: GM267C 17% OF YEAR LAPSED ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------REPORT SELECTIONS Fiscal year . . . . . . . . . . . . . . . . . : 2018 Fund . . . . . . . . . . . . . . . . . . . . : 275 Department . . . . . . . . . . . . . . . . . : 62 Division . . . . . . . . . . . . . . . . . . : 06 Suppress accounts with zero balances . . . . : Y -----------------------------------------------------------------------------------------------------------------------------------GRAND TOTAL ********* 0 .00 0 0 .00 0 .00 0 .00 0

September 2017 Gift Fund (Expense) Including Friends

Gift Fund

Friends Funding

230-0000-455-01-02

Hourly/Seasonal

($

18.48) ($

-  ) ($

230-0000-455-01-25

Temporary Staffing

($

-  ) ($

197.76)

230-0000-455-02-25

Medicare

($

0.27) ($

-  )

230-0000-455-02-50

Workers' Compensation

($

0.69) ($

-  )

230-0000-455-03-09

Professional Services

($

74.16) ($

-  )

230-0000-455-05-70

Facility FFE Non Capital

($

-  ) ($

-  )

230-0000-455-05-73

Facility FFE Friends Non Capital

($

-  ) ($

-  ) ($

230-0000-455-05-80

Travel

($

-  ) ($

-  )

230-0000-455-06-25

Operating Supplies

($

377.49) ($

-  )

230-0000-455-06-30

Collection - Friends of the Library

($

6,000.00) ($

-  )

230-0000-455-06-31

Youth Programming

($

166.00) ($

-  )

230-0000-455-06-32

National Library Week

($

-  ) ($

-  )

230-0000-455-06-36

Community Programming

($

382.71) ($

-  )

230-0000-455-06-39

Mobile Makerspace Match

($

-  ) ($

-  )

230-0000-455-06-45

Books / Periodicals

($

-  ) ($

-  )

($

7,019.80) ($

197.76)

18.48)

-  )

PREPARED 09/11/2017, 10:33:31 DETAIL BUDGET REPORT BY CATEGORY PAGE 2 PROGRAM: GM267C 17% OF YEAR LAPSED ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------FUND 230 LIBRARY GIFT DEPT/DIV 0000 BA ELE OBJ ACCOUNT *********CURRENT********** **********YEAR-TO-DATE******* ANNUAL UNENCUMB. % SUB SUB DESCRIPTION BUDGET ACTUAL %EXP BUDGET ACTUAL %EXP ENCUMBR. BUDGET BALANCE BDGT -----------------------------------------------------------------------------------------------------------------------------------45 455

CULTURE AND RECREATION LIBRARIES 10 Salaries and Wages 01 02 HOURLY/SEASONAL 25 TEMPORARY STAFFING 10 ** Salaries and Wages

0 0 0

.00 197.76 197.76

0 0 0

0 0 0

18.48 197.76 216.24

0 0 0

.00 .00 .00

0 0 0

18.48197.76216.24-

0 0 0

21 02 25 50 21 **

0 0 0

.00 .00 .00

0 0 0

0 0 0

.27 .69 .96

0 0 0

.00 .00 .00

0 0 0

.27.69.96-

0 0 0

0 916 416 1166 564 333 0 1250 0 4645

74.16 0 .00 0 .00 0 377.49 32 6000.00 1064 .00 0 166.00 0 .00 0 382.71 0 7000.36 151

0 1832 832 2332 1128 666 0 2500 0 9290

74.16 .00 .00 377.49 6000.00 .00 166.00 .00 382.71 7000.36

0 0 0 16 532 0 0 0 0 75

.00 .00 .00 .00 .00 .00 .00 .00 .00 .00

0 11000 5000 14000 6769 4000 0 15000 0 55769

74.1611000.00 5000.00 13622.51 769.00 4000.00 166.0015000.00 382.7148768.64

0 0 0 3 89 0 0 0 0 13

455 ** ** LIBRARIES

4645

7198.12

155

9290

7217.56

78

.00

55769

48551.44

13

45

** ** CULTURE AND RECREATION

4645

7198.12

155

9290

7217.56

78

.00

55769

48551.44

13

97 971

FUND BALANCE ENDING FUND BALANCE 01 TAXES 30 00 UNRESERVED FUND BALANCE 01 ** TAXES

416 416

.00 .00

0 0

832 832

.00 .00

0 0

.00 .00

5000 5000

5000.00 5000.00

0 0

971 ** ** ENDING FUND BALANCE

416

.00

0

832

.00

0

.00

5000

5000.00

0

97

416

.00

0

832

.00

0

.00

5000

5000.00

0

5061

7198.12

142

10122

7217.56

71

.00

60769

53551.44

12

5061

7198.12

142

10122

7217.56

71

.00

60769

53551.44

12

5061

7198.12

142

10122

7217.56

71

.00

60769

53551.44

12

EMPLOYEE BENEFITS MEDICARE WORKERS' COMPENSATION EMPLOYEE BENEFITS

22 SERVICE AND SUPPLIES 03 09 PROFESSIONAL SERVICES 05 70 FACILITY FFE NON CAPITAL 80 TRAVEL 06 25 OPERATING SUPPLIES 30 COLLECTION - FOL 31 YOUTH PROGRAMMING 36 COMMUNITY PROGRAMMING 45 BOOKS / PERIODICALS 14 75 SUMMER LEARNING PROGRAM 22 ** SERVICE AND SUPPLIES

DIV DEPT

** ** FUND BALANCE 0000 TOTAL ******* 00 TOTAL *******

FUND 230

TOTAL ********* LIBRARY GIFT

PREPARED 09/11/2017, 10:33:31 DETAIL BUDGET REPORT BY CATEGORY PAGE 3 PROGRAM: GM267C 17% OF YEAR LAPSED ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------FUND 230 LIBRARY GIFT DEPT/DIV 0000 BA ELE OBJ ACCOUNT *********CURRENT********** **********YEAR-TO-DATE******* ANNUAL UNENCUMB. % SUB SUB DESCRIPTION BUDGET ACTUAL %EXP BUDGET ACTUAL %EXP ENCUMBR. BUDGET BALANCE BDGT -----------------------------------------------------------------------------------------------------------------------------------GRAND

TOTAL ********* 5061

7198.12

142

10122

7217.56

71

.00

60769

53551.44

12

PREPARED 09/11/2017, 10:35:51 ACCOUNT ACTIVITY LISTING PAGE 1 PROGRAM GM360L ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------GROUP PO ACCTG ----TRANSACTION---YTD/CURRENT CURRENT NBR NBR PER. CD DATE NUMBER DESCRIPTION ENCUMBRANCE DEBITS CREDITS BALANCE -----------------------------------------------------------------------------------------------------------------------------------FUND 230 LIBRARY GIFT 230-0000-455.01-02 SALARIES AND WAGES / HOURLY/SEASONAL 88 01/18 AJ 07/14/17 PR0714 PAYROLL SUMMARY 88 01/18 AJ 07/14/17 PR0714 PAYROLL SUMMARY ACCOUNT TOTAL

46.20 27.72 .00

230-0000-455.01-25 SALARIES AND WAGES / TEMPORARY STAFFING 592 03/18 AP 08/22/17 0371506 MARATHON STAFFI WK ENDING 07/29/17 DB-LIBRARY 592 03/18 AP 08/22/17 0371506 MARATHON STAFFI WK ENDING 08/05/17 DB-LIBRARY 459 02/18 AP 08/10/17 0371127 MARATHON STAFFI WEEK ENDING 07-22-2017 KK - LIBRARY ACCOUNT TOTAL

.00

230-0000-455.06-30 SUPPLIES / COLLECTION - FOL 708 02/18 AP 08/31/17 1000195 BANK OF AMERICA

543.84

543.84

.67 .40 .00

.67

.40

.27

1.73 1.04 .00

1.73

1.04

.69

.00

74.16

.00

377.49

74.16 .00

230-0000-455.06-25 SUPPLIES / OPERATING SUPPLIES 708 02/18 AP 08/31/17 1000195 BANK OF AMERICA Baker, Diane CC-COMM-UTILITY-PMNT 708 02/18 AP 08/31/17 1000195 BANK OF AMERICA Klug, Kristin AMAZON MKTPLACE PMTS ACCOUNT TOTAL

.00

197.76

230-0000-455.03-09 PROFESSIONAL SERVICES / PROFESSIONAL SERVICES 260 02/18 AP 07/26/17 0370787 MARATHON STAFFI WEEK ENDING 7/15/2017 KK-LIBRARY ACCOUNT TOTAL

18.48

197.76

230-0000-455.02-50 EMPLOYEE BENEFITS / WORKERS' COMPENSATION 88 01/18 AJ 07/14/17 PR0714 PAYROLL SUMMARY 88 01/18 AJ 07/14/17 PR0714 PAYROLL SUMMARY ACCOUNT TOTAL

27.72

148.32

230-0000-455.02-25 EMPLOYEE BENEFITS / MEDICARE 88 01/18 AJ 07/14/17 PR0714 PAYROLL SUMMARY 88 01/18 AJ 07/14/17 PR0714 PAYROLL SUMMARY ACCOUNT TOTAL

46.20

74.16

332.50 44.99 .00

377.49

6,000.00

PREPARED 09/11/2017, 10:35:51 ACCOUNT ACTIVITY LISTING PAGE 2 PROGRAM GM360L ACCOUNTING PERIOD 02/2018 CITY OF CARSON CITY -----------------------------------------------------------------------------------------------------------------------------------GROUP PO ACCTG ----TRANSACTION---YTD/CURRENT CURRENT NBR NBR PER. CD DATE NUMBER DESCRIPTION ENCUMBRANCE DEBITS CREDITS BALANCE -----------------------------------------------------------------------------------------------------------------------------------FUND 230 LIBRARY GIFT 230-0000-455.06-30 SUPPLIES / COLLECTION - FOL Rush, Kathy OVERDRIVE DIST ACCOUNT TOTAL 230-0000-455.06-36 SUPPLIES / 708 02/18 AP 08/31/17 Wood, Natalie 708 02/18 AP 08/31/17 Wood, Natalie 592 03/18 AP 08/22/17 WIFI - PEDAL BIKE

.00

COMMUNITY PROGRAMMING 1000195 BANK OF AMERICA THE BIKE SMITH 1000195 BANK OF AMERICA THE BIKE SMITH 0371584 TSA CUSTOM CAR DB-LIBRARY

ACCOUNT TOTAL 230-0000-455.14-75 PROGRAMS / 708 02/18 AP 08/31/17 Wood, Natalie 708 02/18 AP 08/31/17 Wood, Natalie 459 02/18 AP 08/10/17 SUMMER LEARNING 459 02/18 AP 08/10/17 SUMMER LEARNING

continued 6,000.00

.00

6,000.00

.00

1,166.00

94.00 72.00 1,000.00 .00

SUMMER LEARNING PROGRAM 1000195 BANK OF AMERICA WAL-MART #3408 1000195 BANK OF AMERICA MY MYSTERY PARTY 0371148 PATCHWORK GIRAF KK - LIBRARY 0371087 COMMUNITY YOGI KK - LIBRARY

1,166.00

17.76 39.95 200.00 125.00

ACCOUNT TOTAL

.00

382.71

.00

382.71

FUND TOTAL

.00

8,592.80

29.16

8,563.64

GRAND TOTAL

.00

8,592.80

29.16

8,563.64