The URL can be used to link to this page

02-NOVEMBER 2012 FINANCIAL STATEMENT NOVEMBER 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department February 19, 2013 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL REVENUE SUMMARY Taxes 13,247,165 1,075,657.882,544,183.19 Franchises1,665,763115,795.81241,406.11 Permits1,051,84076,235.00141,968.00 Licenses70,2004,647.505,125.00 Fees2,997,169200,931.17344,146.31 Fines25,0001,921.243,860.03 Inter-Jurisdictional640,16738,932.1784,028.81 Fund Transfers1,950,742208,760.82217,501.18 Miscellaneous455,54734,568.89113,449.75 TOTAL REVENUES22,103,5931,757,450.483,695,668.38 EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,6061,065.031,481.26 Supplies40057.30- City Support Services31,50048.00269.98 Operations Support500-- Staff Support20,8502,573.002,800.01 Operating Equipment700-- TOTAL CITY COUNCIL76,5563,743.334,551.25 CITY MANAGER Personnel Services924,28052,212.5845,733.92 Supplies4,100-147.88 Operations Support100-- Staff Support39,5504,587.621,098.75 Operating Equipment--- TOTAL CITY MANAGER968,03056,800.2046,980.55 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL MUNICIPAL COURT Personnel Services281,30014,884.2415,391.29 Supplies3,000415.45164.83 City Support Services1,000-- Operations Support3,500-- Staff Support7,100-385.20 Court Support800-- Professional Services65,2504,405.254,882.50 Maintenance Services2,800-- Operating Equipment800-- TOTAL MUNICIPAL COURT365,55019,704.9420,823.82 CUSTOMER RELATIONS-311 Personnel Services107,8535,780.155,089.28 Supplies200-- Staff Support1,750-- Operating Equipment500-- TOTAL CUSTOMER RELATIONS-311110,3035,780.155,089.28 PLANNING & ZONING Personnel Services140,9737,887.198,169.56 Supplies2,850-161.45 Operations Support750-- Staff Support16,160(23.83)300.00 Professional Services25,150-- Operating Equipment--- TOTAL PLANNING & ZONING185,8837,863.368,631.01 LEGAL SERVICES Operations Support12,000-- Professional Services348,000-- TOTAL LEGAL SERVICES360,000-- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL FACILITIES MAINTENANCE Personnel Services563,70342,169.7531,290.44 Supplies65,8972,795.251,574.19 Utility Services106,448-1,707.16 Staff Support12,09924.00108.24 Maintenance Services64,4126,194.15673.05 Operating Equipment4,950-- Capital Outlay--- TOTAL FACILITIES MAINTENANCE817,50951,183.1535,353.08 BUILDING 6-8 MAINTENANCE Supplies28,400-- Utility Services91,7004.47- Maintenance Services67,700350.00- Operating Equipment9,600-- TOTAL FACILITIES MAINTENANCE197,400354.47- CITY SECRETARY Personnel Services168,5069,428.379,811.60 Supplies1,25023.8057.30 City Support Services7,500-- Staff Support7,85018.00- TOTAL CITY SECRETARY185,1069,470.179,868.90 NON-DEPARTMENTAL Supplies--- City Support Services450,000132,598.265,325.00 Operations Support154,5006,432.327,965.91 City Assistance699,43398,957.4296,046.91 Professional Services165,22022,269.882,410.57 Fund Chrgs/Transfrs-Spec Events Fnd55,000-- Capital Outlay--- TOTAL NON-DEPARTMENTAL1,524,153260,257.88111,748.39 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL PUBLIC AFFAIRS Personnel Services286,25316,349.2612,939.87 Supplies3,500-57.81 Operations Support27,1001,868.79- Staff Support5,9009.24196.44 TOTAL PUBLIC AFFAIRS322,75318,227.2913,194.12 RECORDS MANAGEMENT Personnel Services48,1442,725.542,858.77 Supplies400-- Staff Support1,560-- Professional Services12,000191.00- TOTAL RECORDS MANAGEMENT62,1042,916.542,858.77 SCHERTZ TALES MAGAZINE Personnel Services130,5607,686.108,077.96 Supplies200-- Opperations Support200-- Staff Support2,005-- Professional Services300,700115,425.0012,569.94 Fund Charges/Transfers10,000-- TOTAL SCHERTZ TALES MAGAZINE443,665123,111.1020,647.90 ENGINEERING Personnel Services258,7096,967.186,031.69 Supplies1,100-28.65 Utility Services1,440-- Staff Support6,741-- Professional Services43,000-1,425.00 Maintenance Services--- Operating Equipment5,216-- Capital Outlay--- TOTAL ENGINEERING316,2066,967.187,485.34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL GIS Personnel Services128,3567,456.497,299.12 Supplies2,800-- Staff Support2,725-- Professional Services1,500-- TOTAL GIS135,3817,456.497,299.12 TOTAL GENERAL GOVERNMENT6,070,599573,836.25294,531.53 PUBLIC SAFETY POLICE Personnel Services4,677,560240,057.91266,138.82 Supplies41,59319.951,661.01 City Support Services25,80020,657.01- Utility Services133,735-- Operations Support1,750-90.00 Staff Support57,2011,054.502,515.60 City Assistance9,765-- Professional Services28,337200.00- Maintenance Services48,740690.00- Operating Equipment139,100-14,410.65 Capital Outlay147,831-- TOTAL POLICE 5,311,412262,679.37284,816.08 FIRE RESCUE Personnel Services2,593,286204,507.17149,147.62 Supplies16,200155.329,276.23 Utility Services51,500-7.64 Operations Support1,200-- Staff Support113,80011,644.7722,703.10 City Assistance16,200-2,758.50 Professional Services17,000-- Maintenance Services49,900169.753,565.81 Operating Equipment59,100-1,987.29 Capital Outlay--- TOTAL FIRE 2,918,186216,477.01189,446.19 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL INSPECTIONS Personnel Services428,70024,512.6224,657.57 Supplies2,63891.54142.32 Utility Services6,500-- Operations Support1,500-- Staff Support6,600360.43551.76 Professional Services8,890-- Operating Equipment500-- TOTAL INSPECTIONS 455,32824,964.5925,351.65 MARSHAL SERVICE Personnel Services545,21932,944.0831,639.64 Supplies4,30033.69285.10 Utility Services16,000-- Operations Support4,000-- Staff Support11,60065.872,257.08 Maintenance Services16,500505.00- Operating Equipment21,000-4,602.17 Capital Outlay--- TOTAL MARSHAL SERVICE618,61933,548.6438,783.99 TOTAL PUBLIC SAFETY9,303,545537,669.61538,397.91 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL PUBLIC ENVIRONMENT STREETS Personnel Services688,83452,709.6240,461.97 Supplies7,100118.3221.04 Utility Services121,900476.804,414.30 Staff Support10,265528.25172.17 Maintenance Services180,4002,091.98930.75 Rental/Lease200-- Operating Equipment3,500-- TOTAL STREETS 1,012,19955,924.9746,000.23 TOTAL PUBLIC ENVIRONMENT1,012,19955,924.9746,000.23 PARKS & RECREATION PARKS DEPARTMENT Personnel Services503,32732,306.0528,794.84 Supplies41,905878.25755.91 Utility Services143,800892.507,427.19 Operations Support350-- Staff Support8,823395.2360.93 Professional Services45,610-5,496.50 Maintenance Services19,500-44.99 Rental/Leasing44,000-- Operating Equipment3,000-- TOTAL PARKS DEPARTMENT810,31534,472.0342,580.36 SWIM POOL Supplies20,700194.50- Utility Services29,000101.802,289.15 Staff Support925-750.00 Maintenance Services203,3782,200.004,000.00 Rental/Lease500-- TOTAL SWIM POOL254,5032,496.307,039.15 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL EVENT FACILITIES Personnel Services56,5352,948.283,027.36 Supplies27,00010.921,127.61 Utility Services48,200-359.61 Operations Support27,332-- Staff Support2,727-439.45 Professional Services1,600-150.00 Operating Equipment--- TOTAL COMMUNITY/CIVIC CNTR163,3942,959.205,104.03 TOTAL PARKS & RECREATION1,228,21239,927.5354,723.54 CULTURAL LIBRARY Personnel Services704,94036,194.3442,882.17 Supplies12,000828.71136.54 Utility Services51,000-1,342.36 Operations Support3,500-174.00 Staff Support4,040-104.32 Professional Services2,225-- Maintenance Services2,400-400.00 Operating Equipment75,00098.96188.08 TOTAL LIBRARY855,10537,122.0145,227.47 TOTAL CULTURAL855,10537,122.0145,227.47 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL HEALTH ANIMAL SERVICES Personnel Services300,10816,128.3517,749.57 Supplies23,5002,087.50350.89 Utility Services11,200100.8587.26 Operations Support500-- Staff Support12,760-655.48 City Assistance13,500-- Professional Services13,500-- Maintenance Services7,280-2,340.00 Operating Equipment9,000-723.93 TOTAL ANIMAL SERVICES391,34818,316.7021,907.13 TOTAL HEALTH391,34818,316.7021,907.13 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services274,64016,310.7816,557.52 Supplies3,000-- City Support Services395,7626,840.00450.00 Utility Services167,866-3,866.12 Staff Support18,250254.311,957.64 Professional Services2,500-- Maintenance Services8,000-- Operating Equipment106,500-3,207.62 Capital Outlay--- TOTAL INFORMATION TECHNOLOGY976,51823,405.0926,038.90 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL HUMAN RESOURCES Personnel Services311,71015,460.0212,923.08 Supplies1,329-122.30 Human Services55,1561,267.00654.00 Operations Support16,596-532.56 Staff Support14,897-550.72 City Assistance9,860-- Operating Equipment--390.03 TOTAL HUMAN RESOURCES409,54816,727.0215,172.69 FINANCE Personnel Services443,30624,990.3227,357.38 Supplies3,5004.1011.71 Operations Support300-- Staff Support16,06080.00- Rental/Leasing2,230-- Operating Equipment--266.47 TOTAL FINANCE465,39625,074.4227,635.56 PURCHASING & ASSET MGT Personnel Services247,93613,933.4614,494.09 Supplies95035.19- Utility Services600-- Operations Support100-- Staff Support7,875-65.00 Operating Equipment250-- TOTAL PURCHASING & ASSET MGT257,71113,968.6514,559.09 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL FLEET SERVICE Personnel Services218,52811,120.4110,651.34 Supplies143,65018,773.532,972.15 City Support Services2,400-- Utility Services7,200-- Operations Support400-- Staff Support4,500-637.81 Maintenance Services65,7505,681.541,583.76 Rental/Lease200-- Operating Equipment5,000-- TOTAL FLEET SERVICE447,62835,575.4815,845.06 BUILDING MAINTENANCE Personnel Services75,142-- Supplies43-- Utility Services2,952-- Staff Support356-- Maintenance Services49,888-- Rental/Leasing1,400-- Capital Outlay60,000-- TOTAL PURCHASING & ASSET MGT189,781-- TOTAL INTERNAL SERVICE2,746,582114,750.6699,251.30 MISC & PROJECTS CITY ASSISTANCE Patient Assistance5,000-- Children's Advocacy Assistance5,000-- Senior Citizen's Hot Meals42,00010,500.00- TOTAL CITY ASSISTANCE52,00010,500.00- COURT - RESTRICTED FUNDS Operating Equipment51,053-- TOTAL CITY ASSISTANCE51,053-- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL TOTAL MISC & PROJECTS103,05310,500- TOTAL EXPENDITURES 21,710,643 1,388,047.731,100,039.11 REVENUE OVER(UNDER) EXPEND.392,950 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Taxes 000-411100Advalorem Tax - Current7,481,207636,963.581,771,884.95 000-411200Advalorem Tax - Delinquent50,0007,212.2516,174.53 000-411300Advalorem Tax - P&I50,0002,365.745,018.59 000-411500Sales Tax Revenue-Gen Fund5,637,958429,116.31744,075.05 000-411700Mixed Beverage Tax28,000.00-7,030.07 TOTAL Taxes 13,247,165 1,075,657.882,544,183.19 Franchises 000-421200Center Point/Entex Energy58,7635,276.328,841.12 000-421220City Public Service375,00026,770.6750,512.61 000-421240Guadalupe Valley Elec Co-op430,00032,977.4561,065.76 000-421250New Braunfels Utilities50,0003,273.347,211.86 000-421300Time Warner-State Franchise350,00027,685.5257,765.66 000-421460AT&T Franchise Fee190,00011,489.0129,856.96 000-421480Other Telecom Franchise110,0003.6311,928.88 000-421500Solid Waste Franchise Fee102,0008,319.8714,223.26 TOTAL Franchises1,665,763115,795.81241,406.11 Permits 000-431100Home Occupation Permit490-35.00 000-431205Building Permit - Residential408,61835,199.0067,614.00 000-431210Building Permit - Commercial203,149-- 000-431215Building Permit - General118,71415,430.0017,813.00 000-431300Mobile Home Permit325-- 000-431400Signs Permit1,700252.00195.00 000-431500Food Establishmnt Permit33,0004,725.009,425.00 000-431600Garage Sale Permit8,1601,115.002,280.00 000-431700Plumbing Permit117,3247,069.0020,471.00 000-431750Electrical Permit45,0203,800.006,740.00 000-431800Mechanical Permit48,4403,160.008,600.00 000-431900Solicitor/Peddler Permit1,000250.00130.00 000-431950Animal/Pet Permit2,000-580.00 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL 000-432000Cert. of Occupancy Prmt10,900300.00600.00 000-432100Security Alarm Permit45,0003,810.006,360.00 000-435000Fire Permit8,0001,125.001,125.00 TOTAL Permits1,051,84076,235.00141,968.00 Licenses 000-441000Alcohol Beverage License6,000912.50660.00 000-441300Mobile Home License20040.00- 000-442000Contractors License60,0003,425.003,875.00 000-444000Pet License4,000270.00590.00 TOTAL Licenses70,2004,647.505,125.00 Fees 000-451000Municipal Court Fines1,610,000111,724.10153,415.38 000-451100Arrest Fee52,7345,360.897,487.33 000-451110Expunction Fee120-- 000-451200Warrant Fees138,50010,692.5518,255.10 000-451210Court - Claims & Judgements--1,842.23 000-451320Civil Justice Fee-Court828.5511.87 000-451321Civil Justice Fee-State73777.10106.71 000-451340Judicial Fee - City7,022707.60981.94 000-451400Traffic Fine Costs TTL27,0112,745.683,898.01 000-451500Teen Court Admin Fee50060.00160.00 000-451510Juvenile Case Mgmt Fee58,5825,917.038,192.77 000-451600Technology Fund Fee47,1224,730.506,694.14 000-451700Security Fee34,3403,547.885,020.66 000-451800Time Payment Fee - City5,598477.05927.02 000-451850State Fines 10% Service Fee61,204-13,466.72 000-451900DPS Payment - Local10,956829.271,542.79 000-452000Child Safety Fee23,0002,241.835,790.34 000-452050Indigent Defense Fee22,5242,338.273,143.80 000-452100Platting Fees77,0003,500.005,000.00 000-452200Site Plan Fee30,0001,500.004,500.00 000-452300Plan Check Fee289,40124,232.5040,912.50 000-452310Miscellaneous Review Fee10,800-- 000-452320Tree Mitigation Admin Fee10,500-- 000-452400BOA/Zoning Fees6,500-1,500.00 000-452500Food Handler Class3,0001,240.00990.00 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL 000-452520Fire Training Classes1,000-- 000-452600Specific Use/Zone Chng Fee47,700-12,350.00 000-452710Zoning Ltr & Dev Rights2,100150.00300.00 000-453100Reinspection Fees39,5001,425.006,500.00 000-453110Swim Pool Inspection Fee1,000-- 000-453200Lot Abatement5,000190.00315.00 000-453211Admin Fee-Inspections7,480200.00400.00 000-453310Misc Inspection Fee250-19.49 000-453710Foster Care75050.00200.00 000-454100Swim Pool Reservation Fee--55.00 000-454200Pool Gate Admission Fee20,000-- 000-454300Seasonal Pool Pass Fee7,500-- 000-456500Haz Mat Fees1,500-- 000-456600Fire Re-inspection Fee75050.00200.00 000-458100Sale of Merchandise--- 000-458300Sale of Property/Auction25,000213.871,390.39 000-458400Civic Center Rental Fees132,20010,168.0015,294.00 000-458401Capital Recovery Fee-Civic Cntr4,80075.00675.00 000-458450North Center Rental Fees23,0001,125.004,503.00 000-458500Community Center Rental Fees26,0002,136.002,691.80 000-458550Pavilion Rental Fees18,000445.002,017.00 000-458560Chamber of Comm rent11,700-- 000-458570Non-Resident SYSA League19,000-1,880.00 000-458650NonResident User Fee-BVYA17,000-2,670.00 000-458660BVYA Utility Reimbursement5,000-3,195.72 000-458670SYSA Utility Reimbursement7,500-- 000-458675Lions Futbol Utility Reimbursement--- 000-458680Tournament Fees-Soccer3,000-- 000-458700Vehicle Impoundment5,779-- 000-459200NSF Check Fee250-- 000-459300Notary Fee2506.0036.00 000-459400Maps, Copies, UDC, & Misc F250-3.10 000-459600Animal Adoption Fee14,0001,295.002,220.50 000-459700Pet Impoundment Fee14,000939.002,485.00 000-459800Police Reports Fee8,677532.50906.00 TOTAL Fees2,997,169200,931.17344,146.31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Fines 000-463000Library Fines25,0001,921.243,860.03 TOTAL Fines25,0001,921.243,860.03 Inter-Jurisdictional 000-473100Bexar Co - Fire21,072-1,756.48 000-473200City of Seguin - Fire Contract31,4523,355.266,710.52 000-473300Guad Co - Library208,34317,361.9131,802.66 000-473400Randolph AFB-Animal Cntrl 1,000-- 000-474200Library Services - Cibolo20,000-- 000-474210Library Services-Selma18,393-- 000-474400Dispatch Service - Cibolo133,305-33,326.25 000-474600School Crossing Guard-Bexar27,0002,879.545,224.08 000-474610School Cross Guard-Guadalupe24,6022,835.465,208.82 000-474700School Officer Funding155,00012,500.00- TOTAL Inter-Jurisdictional640,16738,932.1784,028.81 Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.0014,640.00 000-480100Indirect Costs - Hotel/Motel157,51713,126.4223,771.00 000-481000Transfer From Reserves--- 000-485000Interfund Charge-Drainage49,7084,142.336,972.50 000-486000Interfund Chrges-Admin W&S1,060,96388,413.58146,870.34 000-486000Transfer In-W&S80,000-- 000-486322Transfer-In - Library Grants--- 000-487000Interfund Charges-Fleet112,7619,396.7516,414.00 000-488000Interfund Charges-4B243,35020,279.178,833.34 000-489000Transfer In158,60366,082.57- 000-490020Transfer In-SEDC--- TOTAL Fund Transfers1,950,742208,760.82217,501.18 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Miscellaneous 000-491000Interest Earned350-25.54 000-491200Investment Income45,0003,377.856,445.69 000-491800Gain/Loss--(19.83) 000-491900Unrealized Gain/Loss(26,000)(2,159.80)(4,343.15) 000-492100Proceeds-Sale of Land--57,867.85 000-493120Donations-Public Library-7,500.00- 000-493130Donations-Writing the Next Chap.2,00050.00503.00 000-493400Donation - Animal Control4,0001.25297.02 000-493401Donations-A/C Microchip2,000175.00375.00 000-493402Donations-Spay&Neuter12,000974.502,341.00 000-493503Donations - Fire Rescue--- 000-494481LawEnforcemtOfficersStnd&Ed--- 000-494482Grants - Police2,997-- 000-495040Friends of N. Schertz Park-200.003,074.00 000-495100Mobile Stage Rental Fees2,000-- 000-497000Misc Income-Gen Fund50,0001,743.09(37,381.61) 000-497005Schertztales Advertising220,00017,091.0035,757.00 000-497100Misc Income-Police20,000340.00768.90 000-497150Misc Income-Fire Department--- 000-497200Misc Income-Library4,000286.50769.44 000-497210Misc Income-Library Copier12,0001,229.002,630.76 000-497300Misc Income-Animal Control2005.00105.00 000-497400Misc Income-Streets Dept.15,0002,187.915,046.88 000-497500Misc Income-TML Insurance2,000-- 000-497550Misc Income-TML Reimbursemt15,000354.20837.00 000-497600Misc Income-Vending Mach.2,000155.15445.75 000-498000Reimbursmnt-Gen Fund50,000-8,608.49 000-498100Reimbursmnt Fire - Training1,000-- 000-498105Reimburmnt Police - DEA-1,058.24- 000-498110Reimbursmnt Fire - Emg. Acti-O20,000-29,296.02 TOTAL Miscellaneous455,54734,568.89113,449.75 TOTAL REVENUES 22,103,593 1,757,450.483,695,668.38 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 802,102.69 Cash in Investments LOGIC Investment-General Fund662,848.95 LOGIC Investment-Equip Replacement73,493.41 LOGIC Investment-Veh Replacement102,528.83 LOGIC Investment-Air Condi Replacment146,735.71 CAPITAL ONE Investment-General Fund1,342,107.06 Total Cash in Bank & Investments$ 3,276,398.49 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 292,988636,964 2011-12 1,540,041228,9242,439,1231,871,054635,71964,19027,87829,91918,03926,509 2010-11 1,406,160244,2552,331,4871,725,242735,329174,68737,34143,10815,12026,143 2009-10 1,277,0061,642,355702,8741,730,904562,689(32,792)59,54534,76219,83629,955 2008-09 703,3501,823,090757,6021,345,602699,462114,53710,51445,08736,65925,468 Sales Tax -General Fund $700,000 24% $600,000 $500,000 2% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 439,433575,041 2011-12428,995463,636339,192415,822461,400365,083347,395535,930398,080408,851 2010-11 339,709332,264347,605353,229470,399324,575283,300425,848408,664342,513 2009-10 300,384338,514281,259288,350477,063293,178273,874366,704350,314324,169 2008-09 332,597414,845371,763300,829434,646298,499282,410394,233317,296310,159 2007-08 336,749350,854312,547327,798421,873330,131287,316355,054336,094328,147 CITY PUBLIC SERVICE üïîðôððð üïððôððð üèðôððð üêðôððð üìðôððð üîðôððð üó ÑÝÌÒÑÊÜÛÝÖßÒÚÛÞÓßÎßÐÎÓßÇÖËÒÖËÔ îðïîóïí ïðïôììð îðïïóïî çêôíçîéêôìïìééôíçè îðïðóïï èíôìííêîôêçîêéôëêï îððçóïð ééôíëìêïôìêèêíôîéê îððèóðç ééôíðèëíôðéïëéôëðê C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 106-SPECIAL EVENTS FUNDCURRENTCURRENTPRIOR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL REVENUE SUMMARY Fund Transfers75,150.00-- Wilenchik Walk for Life31,000.00-- Hal Balwin Scholarship24,000.00-- Miscellaneous1,150.007.3115.73 TOTAL REVENUES131,300.007.3115.73 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00-- TOTAL GENERAL GOVERNMENT5,150.00-- CULTURAL Other Events4,265.00485.00- Festival of Angels14,750.0095.97500.00 Employee Appreciation Event6,485.004,500.00- National Night Out150.00-- Wilenchik Walk for Life31,000.00-- Schertz Sweetheart37,500.00242.691,382.32 Jazzfest20,000.00-- Hal Baldwin Scholarship12,000.001,676.87- TOTAL CULTURAL 126,150.007,000.531,882.32 TOTAL EXPENDITURES131,300.007,000.531,882.32 REVENUE OVER(UNDER) EXPEND- SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 49,711.90 Cash in Investments MBIA Special Events46,707.81 Total Cash in Bank & Investments$ 96,419.71 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 110-PEG FUNDCURRENTCURRENTPRIOR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL REVENUE SUMMARY Franchises98,000.0014,960.8023,287.45 Fund Transfers33,000.00-- Miscellaneous--19.34 TOTAL REVENUES131,000.0014,960.8023,306.79 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental131,000.0010,670.49123.19 TOTAL GENERAL GOVERNMENT131,000.0010,670.49123.19 TOTAL EXPENDITURES131,000.0010,670.49123.19 REVENUE OVER(UNDER) EXPEND- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 110-PEG FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Franchises 000-421350Time Warner - PEG Fee65,00014,960.8016,039.50 000-421465AT&T PEG Fee33,000-7,247.95 TOTAL Franchises98,00014,96123,287.45 Fund Transfers 000-481000Transfer In - Reserves33,000-- TOTAL Fund Transfers33,000-- Miscellaneous 000-491000Interest Earned--19.34 TOTAL Miscellaneous--19.34 TOTAL REVENUES131,00014,96123,306.79 PEG FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Cash Balance$ 390,872.53 Total Cash in Bank & Investments$ 390,872.53 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWERCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL REVENUE SUMMARY Franchises187,920-31,014.33 Fees 14,655,376 1,204,680.362,763,719.42 Fund Transfers1,419,2989,941.5014,112.34 Miscellaneous430,148135,805.70169,238.42 TOTAL REVENUES16,692,7421,350,427.562,978,084.51 EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services436,69437,370.6758,789.46 Supplies4,600130.48572.58 Human Services100- City Support Services1,000- Operations Support110,00012,333.6813,631.10 Staff Support7,15017.18169.63 Professional Services23,0002,181.344,357.43 Fund Charges/Transfers20,000- Maintenance Services11,0004,840.00840.00 Operating Equipment2,300-500.00 TOTAL BUSINESS OFFICE615,84456,873.3578,860.20 W & S ADMINISTRATION Personnel Services1,184,01394,147.42186,180.00 Supplies199,05019,047.086,308.39 Human Services1,000- City Support Services77,500114.3728,610.66 Utility Services2,727,31328,834.85532,431.68 Operations Support9,250-255.98 Staff Support31,5001,290.871,039.50 City Assistance1,912-15.00 Professional Services212,4001,295.4063,372.66 Fund Charges/Transfers3,137,04792,709.25579,993.89 Maintenance Services5,586,250393,960.06671,397.21 Other Costs40,00029,541.851,250.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWERCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL Debt Service1,353,891- Rental-Leasing6,070442.18 Operating Equipment6,000520.00 Capital Outlay188,00010,000.0070,000.00 TOTAL PUBLIC WORKS 14,761,195671,903.332,140,854.97 MISC & PROJECTS PROJECTS City Support Services-- Operations Support-- Professional Services-3,378.00 Maintenance Services902,000- TOTAL PROJECTS902,0003,378.00 AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000- Operations Support500- Professional Services48,000- Maintenance Services334,500- TOTAL AVIATION HEIGHTS WTR IMP400,000- TOTAL MISC & PROJECTS1,302,0003,378.00 TOTAL EXPENDITURES16,679,039732,1552,219,715 ** REVENUE OVER(UNDER)EXPENSES **13,703 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWERCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Franchises 000-421490Tower Leasing187,920-31,014.33 TOTAL Franchises187,920-31,014.33 Fees 000-455200Garbage Collection Fee3,600,000293,241.58609,640.99 000-455600Fire Line Fees20,000-19,690.00 000-455700Recycle Fee Revenue250,00020,833.9743,307.91 000-455800W&S Line Constructn Reimbursemnt30,0001,443.005,310.08 000-457100Sale of Water7,279,626606,647.001,469,047.66 000-457110Edwards Water Lease166,250-13,235.00 000-457120Water Transfer Charge-Selma20,000-1,376.83 000-457130Water Transfer Charge-U. C. 2,000-2,199.97 000-457140Water Transfer Charge-Converse15,000- 000-457200Sale of Meters90,0004,126.9010,755.58 000-457400Sewer Charges3,000,000261,824.90555,936.78 000-457500Water Penalties180,00016,283.0132,608.62 000-459200NSF Check Fee-Water&Sewer2,500280.00610.00 TOTAL Fees 14,655,376 1,204,680.362,763,719.42 Fund Transfers 000-481000Transfer In- Reserve1,300,000- 000-486100Transfer In-- 000-486204Interfnd Chrg-Drainage Bill119,2989,941.5014,112.34 TOTAL Fund Transfers1,419,2989,941.5014,112.34 Miscellaneous 000-490000Misc Charges200460.00 000-491000Interest Earned1,600117.63357.12 000-491200Investment Income12,000534.341,009.83 000-493400Donations-Christmas Activities-- 000-496050SSLG - SAWS Reservation269,000134,500.00134,500.00 000-497000Misc Income-W&S40,000193.737,647.17 000-498100Reimbursement-EMS Loan-- 000-498110Reimbursement-SSLGC107,348-25,699.30 TOTAL Miscellaneous430,148135,805.70169,238.42 TOTAL REVENUES 16,692,742 1,350,427.562,978,084.51 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 735,700.28 Cash in Investments Lone Star Investment-Water&Sewer2,068,322.61 Lone Star Investment-W&S Customer Deposits294,457.70 Lone Star Investment-W&S Equip Replacement374,075.46 Lone Star Investment-W&S Veh Replacement545,446.75 Lone Star Investment-Water/SSLGC SAWS539,064.24 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $ 4,877,275.38 Total Cash in Bank & Investments$5,612,975.66 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 203-EMSCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL REVENUE SUMMARY Fees398,396.35519,758.86 4,149,402 Inter-Jurisdictional47,688.08328,846.74 1,486,723 Miscellaneous236,5006,327.355,710.11 TOTAL REVENUES452,411.78854,315.71 5,872,625 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services246,120.14432,055.16 2,815,722 Supplies345,08918,464.3558,965.81 Human Services800-- City Support Services32,500-10,277.40 Utility Services107,60011,603.698,250.00 Operations Support45,1523,270.2722,416.47 Staff Support60,9005,263.797,080.53 City Assistance9,200-250.00 Professional Services166,9368,320.9123,416.23 Fund Charges/Transfers66,660.40234,604.79 1,980,055 Maintenance Services53,70012,210.00450.00 Debt Service110,545-- Rental-Leasing12,000-- Operating Equipment117,0006,730.5831,695.46 Capital Outlay--- TOTAL PUBLIC SAFETY378,644.13829,461.85 5,857,199 TOTAL EXPENDITURES378,644.13829,461.85 5,857,199 ** REVENUE OVER(UNDER) EXPENSES **15,426 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 203-EMSCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Fees 000-456100Ambulance/Mileage Transprt3,908,602 393,986.35496,287.86 000-456110Subscription Program Fees40,000250.008,405.00 000-456120EMT Class - Fees100,8004,160.0013,600.00 000-459200Paramedic Class Fees100,000-- 000-456130Immunization Fees--1,466.00 000-459200NSF Check Fee--- TOTAL Fees4,149,402 398,396.35519,758.86 Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,12647,688.0847,688.08 000-474300Cibolo Support228,830-55,524.98 000-475100Comal Co ESD #685,418-13,817.65 000-475200Live Oak Support165,188-40,082.38 000-475300Universal City Support233,107-56,562.83 000-475400Selma Support69,693-16,910.85 000-475500Schertz Support395,830-96,046.91 000-475600Santa Clara Support9,121-2,213.06 000-475800Marion Support13,410-- TOTAL Inter-Jurisdictional1,486,72347,688.08328,846.74 Miscellaneous 000-491200Investment Income50047.4070.69 000-493203Donations-EMS4,00020.00200.00 000-493204Donations-Dilworth Fund2,000-- 000-493205Donations- Golf Tournament--- 000-497000Misc Income130,0005,066.145,439.42 000-497100Recovery of Bad Debt100,0001,193.81- TOTAL Miscellaneous236,5006,327.355,710.11 TOTAL REVENUES5,872,625 452,411.78854,315.71 1,114,869.44 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank $ (298,414.16) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,516.53 Total Cash in Bank & Investments$ 3,102.37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 204-DRAINAGECURRENTCURRENTPRIOR YEARCURRENT FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL REVENUE SUMMARY Fees998,15785,081.63130,886.55 Miscellaneous800147.55136.31 TOTAL REVENUES998,95785,229.18131,022.86 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services447,40638,560.7059,966.36 Supplies8,300926.84364.62 Human Services325-- City Support Services28,855-1,508.72 Utility Services28,8882,131.901,977.51 Operations Support2,460-- Staff Support7,875119.09389.18 City Assistance840-57.00 Professional Services65,8002,100.00- Fund Charges/Transfers189,13615,694.6623,571.84 Maintenance Services22,000240.78- Other costs200-- Debt Service18,091-- Rental/Leasing50016,724.80- Capital Outlay139,900-- TOTAL DRAINAGE960,57676,498.7787,835.23 TOTAL EXPENDITURES960,57676,498.7787,835.23 ** REVENUE OVER(UNDER) EXPEND38,381 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *********************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 204-DRAINAGECURRENTCURRENTPRIOR YEARY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUAL Fees 000-457500Drainage Penalties4,000566.47812.351,029.95 000-457600Drainage Fee994,157130,074.20167,842.93 84,515.16 TOTAL Fees998,157130,886.55 168,872.88 85,081.63 Miscellaneous 000-491000Interest Earned100-11.27 000-491200Investment Interest60082.93113.49 000-497000Misc Income-Drainage10064.6211.55 TOTAL Miscellaneous 800147.55136.31 TOTAL REVENUES998,957131,022.86 169,114.63 85,229.18 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking 101,818.55 Cash in Investments Lone Star Investment-Drainage Maint Fund484,056.77 Total Cash in Bank & Investments$ 585,875.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 314-HOTEL TAXCURRENTCURRENTPRIOR YEARCURRENT FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL REVENUE SUMMARY Taxes492,41727,518.872,318.32 Fund Transfers--- Miscellaneous30043.1734.64 TOTAL REVENUES492,71727,562.042,352.96 EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies2,000-231.08 City Support Services68,378395.9920,407.00 Operations Support99,1751,600.007,087.29 Professional Services5,6255,025.00- Fund Charges/Transfers248,76713,126.4223,771.00 Operating Equipment50,000193.897,043.88 Capital Outlay8,000-- TOTAL NONDEPARTMENTAL481,94520,341.3058,540.25 TOTAL EXPENDITURES481,94520,341.3058,540.25 REVENUE OVER(UNDER) EXPENDITURE10,772 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 314-HOTEL TAXCURRENTCURRENTPRIOR YEARCURRENT REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL Taxes 000-411800Hotel Occupancy Tax492,41727,518.872,318.3227,518.87 TOTAL Taxes492,41727,518.872,318.3227,518.87 Miscellaneous 000-491000Interest Earned150-19.66 000-491200Investment Interest15043.1714.98 TOTAL Miscellaneous30043.1734.64 TOTAL REVENUES492,71727,562.042,352.9627,614.60 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 77,259.41 Cash in Investments MBIA - Hotel Tax220,263.68 Federated Investment-Hotel/Motel78,284.17 Total Cash in Bank & Investments$ 375,807.26 ØÑÌÛÔ ÑÝÝËÐßÒÝÇ ÌßÈ üêðôððð üëðôððð üìðôððð üíðôððð üîðôððð üïðôððð üó ÑÝÌÒÑÊÜÛÝÖßÒÚÛÞÓßÎßÐÎÓßÇÖËÒ îðïîóïí íëôèëïíçôìíç îðïïóïî ííôïîèíîôêéëíîôïìííëôèîçíêôîïëìëôðéïíêôëïèìðôííëìèôíçéëíôêîî îðïðóïï îéôêèçîëôïïîîíôîíïïçôêïçîîôêêéíêôéîèîèôîïëíìôïëéìëôèëìëíôìíí îððçóïð îíôêîëîîôðîêîðôéêèïçôçîìîíôïêçííôêíèîêôëíïíîôíêèíêôêéêìêôðêç îððèóðç ïéôëìçîðôïíìïèôìêïïéôîëëïëôïíèïçôîçéïçôëìèîìôéêçîçôêçëíîôííê C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 317-PARKCURRENTCURRENTPRIOR YEARCURRENT FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL REVENUE SUMMARY Parkland Dedication Fees150,00098,000.0046,575.00 Miscellaneous30018.2687.98 TOTAL REVENUES150,30098,018.2646,662.98 EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services-545.00- Fund Charges/Transfers--- Maintenance Services-Landscape--- Operating Equipment--- Capital Outlay107,600-- TOTAL PARKLAND DEDICATION107,600545.00- TOTAL EXPENDITURES107,600545.00- REVENUE OVER(UNDER) EXPEND42,700 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 317-PARKCURRENTCURRENTPRIOR YEARCURRENT REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL Fees 000-458800Parkland Dedication150,00098,000.0046,575.0098,000.00 TOTAL Fees150,00098,000.0046,575.0098,000.00 Miscellaneous 000-491000Interest Earned--6.03 000-491200Investment Interest30018.2681.95 TOTAL Miscellaneous30018.2687.98 TOTAL REVENUES150,30098,018.2646,662.9898,041.55 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$149,232.26 Cash in Investments Federated Investment-Park Fund167,450.12 Total in Investment Pool167,450.12 Total Cash in Bank & Investments$316,682.38 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 317-PARKCURRENTCURRENTPRIOR YEARCURRENT FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL REVENUE SUMMARY Tree Mitigation Fees35,000-- Miscellaneous61,72516.43- TOTAL REVENUES96,72516.43- EXPENDITURE SUMMARY TREE MITIGATION Fund Charges/Transfers--- Maintenance Services-Trees73,29923,325.00390.00 Operating Equipment--- Capital Outlay23,226-19,900.00 TOTAL TREE MITIGATION96,52523,325.0020,290.00 TOTAL EXPENDITURES96,52523,325.0020,290.00 REVENUE OVER(UNDER) EXPEND200 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 317-PARKCURRENTCURRENTPRIOR YEARCURRENT REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL Fees 000-458900Tree Mitigation35,000-- TOTAL Fees35,000-- Miscellaneous 000-491200Investment Interest20016.43- 000-499000Transfer In Reserves61,525-- TOTAL Miscellaneous61,72516.43- TOTAL REVENUES96,72516.43- PARK FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$675.00 Cash in Investments Federated Investment-Tree Mitigation128,156.47 Total in Investment Pool128,156.47 Total Cash in Bank & Investments$128,831.47 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 411-CAPITAL RECOVERYCURRENTCURRENTPRIOR YEARCURRENT FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUAL REVENUE SUMMARY Fees1,924,200106,233.00227,040.00 Fund Transfers1,542,674-- Miscellaneous298,7502,164.342,067.79 TOTAL REVENUES3,765,624108,397.34229,107.79 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000- Operations Support109-- Professional Services450,0004,449.95707.07 Fund Charges/Transfers--- Maintenance Services10,000-- Debt Service206,515-- TOTAL NON DEPARTMENTAL671,6244,449.95707.07 MISC & PROJECTS Water Projects1,680,0002,495.0010,488.42 Sewer Projects1,414,00023,630.00- TOTAL MISC & PROJECTS3,094,00026,125.0010,488.42 TOTAL EXPENDITURES3,765,62430,574.9511,195.49 REVENUE OVER(UNDER) EXPENDITURES- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ****************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 505-TAX I&SCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL REVENUE SUMMARY Taxes5,032,646431,700.901,105,823.61 Fund Transfers55,000-- Miscellaneous381,6252,665.15(4,660.45) TOTAL REVENUES5,469,271434,366.051,101,163.16 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services42,350-- Debt Service5,159,586-- Other Financing Sources--- TOTAL GENERAL GOVERNMENT5,201,936-- TOTAL EXPENDITURES5,201,936-- ** REVENUE OVER(UNDER) EXPEND267,336 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 505-TAX I & SCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Taxes 000-411900Property Tax Revenue5,032,646431,700.901,105,823.61 TOTAL Taxes5,032,646431,700.901,105,823.61 Fund Transfers 000-486401Transfer In Fund 40155,000-- TOTAL Fund Transfers55,000-- Miscellaneous 000-491000Interest Earned50-8.32 000-491200Investment Earnings12,5002,665.153,447.28 000-495015Contribution from SED369,075-- 000-497000Misc Income--(8,116.05) TOTAL Miscellaneous381,6252,665.15(4,660.45) TOTAL REVENUES5,469,271434,366.051,101,163.16 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 505-TAX I & S GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEAR NON DEPARTMENTALBUDGETPERIODY-T-D ACTUAL Professional Services 101-541500Paying Agent2,350-- 101-541502Cost of Bond Issuance40,000-- TOTAL Professional Services42,350-- Debt Service 101-555612Bond-GO Refunding 2010-Principal250,000-- 101-555612.1Bond-GO Refunding 2010 Interest77,125-- 101-555622Schertz C O SR2003-Principal210,000-- 101-555622.1Schertz C O SR2003-Interest3,833-- 101-555624Comm Proj Bond-SR04-Principal325,000-- 101-555624.1Comm Proj Bond SR04-Interest6,910-- 101-555626LS&D SR2006-Principal200,000-- 101-555626.1LS&D SR2006-Interest642,982-- 101-555628CO Bond 2007-Principal109,534-- 101-555628.1CO Bond 2007-Interest18,499-- 101-555629GO Bond 2007-Principal235,000-- 101-555629.1GO Bond 2007-Interest189,561-- 101-555630GO Bond SR2008 Principal385,000-- 101-555630.1GO Bond SR2008 Interest349,089-- 101-555631GO Bond SR2009 Principal510,000-- 101-555631.1BO Bond SR2009 Interest327,950-- 101-555633GO SR2011 Principal200,000-- 101-555633.1GO SR2011 Interest367,238-- 101-555634GO SR2011A Refund Principal70,000-- 101-555634.1GO SR2011A Refund Interest153,081-- 101-555635GO SR2012 Principal295,000-- 101-555635.1GO SR2012 Interest233,784-- TOTAL Debt Service5,159,586-- Other Financing Sources 101-556300Payment to Refund Debt--- TOTAL Other Financing Sources--- TOTAL EXPENDITURES5,201,936-- TAX I&S CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 431,703.61 Cash in Investments MBIA Investment- Tax I&S333,168.21 Federated Investment-Tax I&S Total Cash in Bank & Investments$ 764,928.75 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 620-SED CORPORATIONCURRENTCURRENTPRIOR YEARPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUAL REVENUE SUMMARY Taxes2,820,260287,520.36-372,037.54 Fund Transfers---- Miscellaneous17,450444.38-(3,373.78) TOTAL REVENUES2,837,710287,964.74-368,663.76 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies---2,602.80 Utility Service---7,633.02 Maintenance Services---9,412.96 TOTAL NONDEPARTMENTAL---19,648.78 ECONOMIC DEVELOPMENT Personnel Services294,59321,416.64-37,841.66 Supplies2,200--124.41 Human Services200--- City Support Services16,50046.65-4,683.79 Utility Services5,95093.14-139.63 Operations Support166,1001,047.90-54,834.35 Staff Support20,2502,778.15-4,723.57 City Assistance1,025,000--10,000.00 Professional Services97,500--30,935.60 Fund Charges/Transfers615,64720,547.67-9,330.84 Debt Service428,504--- Operating Equipment2,000--- TOTAL ECONO DEVELOPMENT2,674,44445,930.15-152,613.85 TOTAL EXPENDITURES2,674,44445,930.15-172,262.63 ** REVENUE OVER(UNDER) EXPEND163,266 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 620-SED CORPORATIONCURRENTCURRENTPRIOR YEARPRIOR YEAR REVENUESBUDGETPERIODEXPENSEY-T-D ACTUAL Taxes 000-411500Sales Tax Revenue (4B)2,820,260287,520.36-372,037.54 TOTAL Taxes2,820,260 287,520.36-372,037.54 Miscellaneous 000-491000Interest Earned200-- 000-491200Investment Earnings12,250444.38-274.37 000-497000Misc Income5,000--(3,691.26) TOTAL Miscellaneous17,450444.38-(3,373.78) TOTAL REVENUES2,837,710 287,964.74-368,663.76 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 380,833.91 Cash in Investments MBIA Investment-Economic Development Corp2,828,036.10 Schertz Bank & Trust-Certificate of Deposit1,037,007.40 Total Cash in Bank & Investments$ 4,245,877.41 4B SALES TAX $350,000 24% $300,000 $250,000 2% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 219,717287,520 2011-12 214,497231,818169,596207,911230,700182,541173,698267,965199,040204,426 2010-11 171,042166,132173,802177,864235,199163,627141,650212,924204,332171,256 2009-10 150,192169,257140,629144,175238,531146,589136,939184,582175,160163,328 2008-09 166,298207,422185,879150,414217,323149,249141,205197,117158,648155,080 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING NOVEMBER 30th, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust - Pooled Cash4,376,187.503,017,878.570.05005,677,450.004,319,141.074,376,187.50 N/A4,376,187.50 86,582.22.05004,960.800,670.4990,872.5390,872.53 Schertz Bank & Trust - PEG Fund390,872.53 301133 TOTAL OPERATIONS4,767,060.03,404,460.79,692,410.80,329,811.56,767,060.03,767,060.03 35444 LOGIC General Fund662,848.95662,750.650.1804 -98.30662,848.95 N/A662,848.95 G/F-Equipment Replacement73,493.413,482.52.1804 -0.893,493.41 N/A3,493.41 70177 G/F-Vehicle Replacement102,528.83102,513.610.1804 -15.22102,528.83 N/A102,528.83 G/F-Air Conditioner Replacement146,735.7146,713.97.1804 -1.7446,735.71 N/A46,735.71 10211 SR2009 Bond-Street Projects(II)1,691,618.75,691,367.91.180450.84-,691,618.75,691,618.75 10211 TOTAL LOGIC2,677,225.652,676,828.66 -396.992,677,225.652,677,225.65 LONESTAR Capital Recovery - Sewer866,618.9366,470.47.2100 -48.4666,618.93 N/A66,618.93 80188 Capital Recovery - Water2,111,339.182,110,977.480.2100 -361.702,111,339.18 N/A2,111,339.18 Drainage Fund484,056.7783,973.84.2100 -2.9384,056.77 N/A84,056.77 40844 GO SR2011 Animal Shelter2,064,425.242,066,491.590.2100353.722,420.072,064,425.24 N/A2,064,425.24 GO SR2011 Athletic Fields2,984,634.39,984,123.08.2100 -11.31,984,634.39 N/A,984,634.39 20522 GO SR2011 Soccer Fields2,759,593.272,785,204.880.2100473.3826,084.992,759,593.27 N/A2,759,593.27 GO SR2011 Swimming Pool6,433,881.65,497,594.67.2100,103.764,816.78,433,881.65 N/A,433,881.65 601666 GO SR2012 Downtown Improvements1,000,478.581,000,307.190.2100 -171.391,000,478.58 N/A1,000,478.58 Water & Sewer Corp72.3136,539.39.21002.3136,539.392.31 N/A2.31 407477 W/S-Customer Deposits294,457.70294,407.260.2100 -50.44294,457.70 N/A294,457.70 W/S-Equipment Repl/Cap.Imp374,075.4674,011.38.2100 -4.0874,075.46 N/A74,075.46 30633 Water&Sewer2,068,250.30924,545.970.21001,143,704.33-2,068,250.30 N/A2,068,250.30 W/S-Vehicle Replacement545,446.75 545,353.310.2100 -93.44545,446.75 N/A545,446.75 Water/SSLG - SAWS539,064.2404,475.11.210034,589.13-39,064.2439,064.24 40155 TOTAL LONESTAR22,526,394.7721,774,475.621,281,780.38529,861.2322,526,394.7722,526,394.77 MBIA Tax I&S333,168.2192,674.27.1900 -40,493.9433,168.21 N/A33,168.21 10133 Police Forfeiture338,233.44338,180.290.1900 -53.15338,233.44 N/A338,233.44 Economic Development Corporation2,828,036.10,827,591.72.1900 -44.38,828,036.10 N/A,828,036.10 20422 Hotel Tax220,263.68220,229.050.1900 -34.63220,263.68 N/A220,263.68 Special Events Fund46,707.816,700.50.1900 -.316,707.81 N/A6,707.81 40744 EMS Tax Notes 2010301,516.5301,469.13.19007.40-01,516.5301,516.53 30433 TOTAL MBIA4,067,925.773,926,844.96 -141,080.814,067,925.774,067,925.77 FEDERATED SR2007a Bond-City Wide Projects869,474.3669,379.55.1300 -4.8169,474.36 N/A69,474.36 80988 Hotel Occupancy Tax78,284.1778,275.630.1300 -8.5478,284.17 N/A78,284.17 Park Fund (Developers Fee)167,450.1267,431.86.1300 -8.2667,450.12 N/A67,450.12 10111 Park Fund (Tree Mitigation)128,156.47152,140.040.130016.4324,000.00128,156.47 N/A128,156.47 Tax I&S56.936.92.1300 -.016.93 N/A6.93 50055 Library Board Fund44,771.044,766.16.1300.88-4,771.044,771.04 40444 TOTAL FEDERATED1,288,193.091,312,050.16142.9324,000.001,288,193.091,288,193.09 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,278,765.43,342,168.80.8900 277.15,743.86,347,635.51 N/A,342,107.06 12511 Capital One Capital Recovery Sewer1,629,740.93,747,554.38.8600,356.50354.95,755,555.93,720,200.19 12811 TOTAL CAPITAL ONE2,908,506.363,089,723.18 632.1014,100.363,103,191.443,062,307.25 City Portfolio By Investment Type TOTAL CAPITAL ONE TOTAL C.D.s 7% 5% TOTAL OPERATIONS 12% TOTAL FEDERATED 3% TOTAL LOGIC 7% TOTAL MBIA 10% TOTAL LONESTAR 56% City Portfolio By Use Designated Funds, $1,929,733.24 Operations, Special Revenue $9,896,247.27 Funds, $9,979,646.45 Debt Service Fund, $333,225.14 Projects, $18,343,170.48 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-12NOV-12DEC-12JAN-13FEB-13MAR-13APR-13MAY-13JUN-13JUL-13AUG-13SEP-13 0.09000.1100 1 Month T-Bill 0.11000.0800 3 Month T-Bill 0.16000.1300 6 Month T-Bill 0.43000.3954 Schertz Portfolio 0.05000.0500 Schertz Bank&Trust 0.40000.4000 CD 365 Days 0.30000.3000 CD 180 Days 0.19710.1804 LOGIC 0.23000.2100 LoneStar 0.21000.1900 MBIA 0.15000.1300 Federated 2.88002.8700 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:11/30/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt Cl III #69118,765.4318,765.4318,765.43 Total Cash & Equivalent8,765.418,765.48,765.4 s13313 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014621.00125,000.00141,987.30136,212.506,875.00 Federal Home Loan Bks Cons Bds6/21/2013203.0080,000.0082,004.4080,753.601,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151111.00100,000.00116,185.00114,032.004,875.00 Federal Home Ln Mtg Corp Deb11/15/2013350.00170,000.00191,084.25177,656.808,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013298.00250,000.00250,000.00258,457.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014725.00200,000.00200,609.40201,818.001,500.00 Federal Natl Mtg Assn 7/28/2015970.00125,000.00132,828.63131,686.252,968.00 US Treasury Note11/30/20151095.0060,000.0061,936.7261,847.40825.00 US Treasury Note5/31/20161278.0050,000.0052,476.5652,355.50875.00 US Treasury Note2/28/2014455.00100,000.0099,757.82100,047.00 Total Fixed Income1,260,000.001,328,870.081,314,866.553 Total Assets615.781,278,765.431,347,635.511,333,631.983 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #69139,740.9339,740.9339,740.933.000.01 Total Cash & Equivalent9,740.939,740.99,740.9 s33333 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014621.00165,000.00187,423.24179,800.509,075.00 Federal Home Loan Bks Cons Bds6/21/2013203.00100,000.00102,505.50100,942.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151111.00200,000.00230,779.00228,064.009,750.00 Federal Home Ln Mtg Corp Deb11/15/2013350.00250,000.00281,006.25261,260.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013319.00200,000.00223,001.60207,704.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014725.00220,000.00220,078.68221,999.801,650.00 Federal Natl Mtg Assn7/28/2015970.00135,000.00143,454.91142,221.153,206.00 US Treasury Note11/30/20151095.0050,000.0051,609.5751,539.50687.00 US Treasury Note5/31/20161278.00125,000.00131,191.41130,888.752,187.00 /28/201455.0045,000.00144,764.8445,068.15 US Treasury Not e2411 Total Fixed Incom,590,000.01,715,815.0,669,487.8 e100155 Total Assets656.111,629,740.931,755,555.931,709,228.785