The URL can be used to link to this page

04-JANUARY 2013 FINANCIAL STATEMENT JANUARY 2013 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department March 8, 2013 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR REVENUE SUMMARY Taxes13,247,165 2,571,596.337,712,706.488,499,420.08- Franchises1,665,763125,072.86469,563.80380,884.08- Permits1,051,84064,815.00280,934.00285,606.00- Licenses70,20011,067.5020,897.5025,574.50- Fees2,997,169225,852.51734,642.17871,741.16- Fines25,0002,269.137,893.718,784.43- Inter-Jurisdictional640,16740,876.12188,129.58154,382.46- Fund Transfers1,950,742142,678.25435,002.36636,795.57- Miscellaneous455,54728,601.10170,202.71129,338.40(132.10) TOTAL REVENUES22,103,5933,212,828.8010,019,972.3110,992,526.68(132.10)11,111,198.42 EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,6061,540.206,951.265,511.73- Supplies400116.9995.98488.575.49 City Support Services39,6156,087.89866.8633,785.26589.30 Operations Support500--294.97- Staff Support20,8503,878.8214,041.7711,117.461,635.32 Operating Equipment700---- TOTAL CITY COUNCIL84,67111,623.9021,955.8751,197.992,230.11 CITY MANAGER Personnel Services924,28070,263.15229,938.76280,536.11- Supplies4,100258.632,207.30351.49159.99 Operations Support100---- Staff Support39,5501,185.3613,282.899,684.501,172.25 Operating Equipment----- TOTAL CITY MANAGER968,03071,707.14245,428.95290,572.101,332.24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR MUNICIPAL COURT Personnel Services281,30019,562.5077,792.5579,149.37- Supplies3,000-617.24788.3874.51 City Support Services1,000---- Operations Support3,500-1,558.00898.00860.00 Staff Support7,10091.061,278.66788.2645.47 Court Support800---- Professional Services65,2504,664.2918,167.5018,050.5420,086.20 Maintenance Services2,80050.00249.94250.001,750.00 Operating Equipment800-797.14-- TOTAL MUNICIPAL COURT365,55024,367.85100,461.0399,924.5522,816.18 CUSTOMER RELATIONS-311 Personnel Services107,8537,850.9527,374.5331,434.72- Supplies200-27.64-- Staff Support1,750---- Operating Equipment500-142.00-- TOTAL CUSTOMER RELATIONS-311110,3037,850.9527,544.1731,434.72- PLANNING & ZONING Personnel Services140,97310,314.1042,141.0242,193.31- Supplies2,85090.00686.04205.51114.88 Operations Support75035.00-70.00- Staff Support16,160-1,720.85606.47- Professional Services25,150-13,144.282,751.76- Operating Equipment----- TOTAL PLANNING & ZONING185,88310,439.1057,692.1945,827.05114.88 LEGAL SERVICES Operations Support12,00084.76-740.0284.76 Professional Services348,00082,178.7860,891.3882,293.7812.87 TOTAL LEGAL SERVICES360,00082,263.5460,891.3883,033.8097.63 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR FACILITIES MAINTENANCE Personnel Services563,70339,083.63177,860.37190,051.83- Supplies65,8971,693.0823,683.9615,296.435,749.51 Utility Services106,4486,131.2023,822.5325,396.211,064.36 Staff Support12,0991,598.224,824.522,644.82486.96 Maintenance Services64,41210,432.7833,133.3529,163.115,337.77 Rental/Leasing---458.25- Operating Equipment4,950---- Capital Outlay----- TOTAL FACILITIES MAINTENANCE817,50958,938.91263,324.73263,010.6512,638.60 BUILDING 6-8 MAINTENANCE Supplies28,4002,235.83-4,832.712,185.30 Utility Services91,7004,891.79-18,399.03570.09 Maintenance Services67,7003,465.99-9,686.858,367.71 Operating Equipment9,6009,249.00-9,249.00- TOTAL FACILITIES MAINTENANCE197,40019,842.61-42,167.5911,123.10 CITY SECRETARY Personnel Services168,50612,611.4948,968.5149,548.31- Supplies1,250-576.0560.57166.28 City Support Services7,500--2,307.78- Staff Support7,850280.002,074.451,786.74671.93 TOTAL CITY SECRETARY185,10612,891.4951,619.0153,703.40838.21 NON-DEPARTMENTAL Supplies--10.71-- City Support Services438,337853.03168,395.27189,694.3136,400.00 Operations Support154,50016,180.9048,377.7934,995.5827.28 City Assistance699,43398,957.42192,093.82197,914.84- Professional Services165,220(248.74)20,307.9139,689.241,021.25 Fund Chrgs/Transfrs-Spec Events Fnd55,000---- Capital Outlay269---- TOTAL NON-DEPARTMENTAL1,512,759115,742.61429,185.50462,293.9737,448.53 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR PUBLIC AFFAIRS Personnel Services286,25313,956.3475,852.22104,360.29- Supplies3,50031.981,004.34985.0125.57 Operations Support27,1004,559.007,690.086,617.381,793.35 Staff Support5,90095.381,037.73194.03291.05 TOTAL PUBLIC AFFAIRS322,75318,642.7085,584.37112,156.712,109.97 RECORDS MANAGEMENT Personnel Services48,1443,574.3114,746.8514,766.02- Supplies400-71.005.28- Staff Support1,560602.6585.00718.18193.20 Professional Services12,000180.501,204.501,732.50- TOTAL RECORDS MANAGEMENT62,1044,357.4616,107.3517,221.98193.20 SCHERTZ TALES MAGAZINE Personnel Services130,56010,023.6938,657.6339,012.30- Supplies200--71.54- Opperations Support200---- Staff Support2,005-85.74200.1079.30 Professional Services300,70015,370.8692,445.38148,801.5813,123.94 Fund Charges/Transfers10,000---- TOTAL SCHERTZ TALES MAGAZINE443,66525,394.55131,188.75188,085.5213,203.24 ENGINEERING Personnel Services258,7099,722.2523,979.0039,721.28- Supplies1,10024.76134.8785.65116.93 Utility Services1,44060.4960.19179.73- Staff Support6,741150.00130.00150.00- Professional Services43,0001,740.0034,892.5014,567.503,287.50 Maintenance Services--3,345.29-- Operating Equipment5,216-1,737.31-- Capital Outlay--23,714.00-- TOTAL ENGINEERING316,20611,697.5087,993.1654,704.163,404.43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR GIS Personnel Services128,3569,658.9536,291.3737,933.24- Supplies2,800-552.02283.95- Staff Support2,725765.00-765.00- Professional Services1,500---- TOTAL GIS135,38110,423.9536,843.3938,982.19- TOTAL GENERAL GOVERNMENT6,067,320486,184.261,615,819.851,834,316.38107,550.32 PUBLIC SAFETY POLICE Personnel Services4,677,560351,862.551,353,734.351,356,822.89- Supplies41,5935,015.897,518.0710,556.754,293.17 City Support Services25,800-19,518.4120,657.01- Utility Services133,7358,986.0734,926.3428,655.60- Operations Support1,750220.00675.001,380.95120.00 Staff Support57,201456.877,026.292,477.502,484.04 City Assistance9,7651,415.002,217.74(1,238.79)583.00 Professional Services28,3371,200.00642.852,183.91- Maintenance Services48,7402,578.3910,811.958,352.673,052.35 Operating Equipment139,1006,382.1422,526.1534,236.2635,581.94 Capital Outlay147,831131,776.00142,521.25137,290.50- TOTAL POLICE 5,311,412509,892.911,602,118.401,601,375.2546,114.50 FIRE RESCUE Personnel Services2,593,286214,097.14801,155.46877,209.05- Supplies16,200147.2211,243.39718.02175.30 Utility Services51,5004,945.0316,504.9512,150.11254.51 Operations Support1,200246.63-481.29- Staff Support113,8006,608.3638,384.7932,753.9425,487.14 City Assistance16,200825.008,366.30825.00- Professional Services17,000-22.19-12,172.00 Maintenance Services49,9002,303.237,722.505,244.49217.83 Operating Equipment62,3793,311.318,988.3614,112.59877.50 Capital Outlay--31,116.00-- TOTAL FIRE 2,921,465232,483.92923,503.94943,494.4939,184.28 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR INSPECTIONS Personnel Services428,70031,907.26126,455.09128,099.10- Supplies2,638418.30566.83699.50203.64 Utility Services6,500254.341,599.521,360.84- Operations Support1,500--286.0032.50 Staff Support6,600197.301,490.211,581.2443.65 Professional Services8,890---- Operating Equipment500---47.61 TOTAL INSPECTIONS 455,32832,777.20130,111.65132,026.68327.40 MARSHAL SERVICE Personnel Services545,21940,381.21164,624.76167,242.62- Supplies4,30051.531,334.60200.55- Utility Services16,000843.664,058.333,449.11- Operations Support4,000-986.41-- Staff Support11,600-3,992.67460.87- Maintenance Services16,5001,145.00149.003,055.001,005.00 Operating Equipment21,000-14,684.08-- Capital Outlay--25,545.00-- TOTAL MARSHAL SERVICE618,61942,421.40215,374.85174,408.151,005.00 TOTAL PUBLIC SAFETY9,306,824817,575.432,871,108.842,851,304.5786,631.18 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR PUBLIC ENVIRONMENT STREETS Personnel Services688,83448,500.56213,274.44213,449.71- Supplies7,100294.621,994.681,603.63937.26 Utility Services121,9009,178.7435,726.6929,726.571,088.38 Staff Support10,265256.801,722.631,864.84675.79 Maintenance Services180,4002,780.1563,205.0225,335.122,060.28 Rental/Lease200---- Operating Equipment3,500-3,485.993,280.00- TOTAL STREETS 1,012,19961,010.87319,409.45275,259.874,761.71 TOTAL PUBLIC ENVIRONMENT1,012,19961,010.87319,409.45275,259.874,761.71 PARKS & RECREATION PARKS DEPARTMENT Personnel Services503,32736,288.88149,460.31154,171.83- Supplies41,9054,678.5514,928.157,538.048,087.84 Utility Services143,8009,694.9935,157.4359,606.323,594.48 Operations Support350---- Staff Support8,823893.303,823.912,060.48159.75 Professional Services45,61010,480.5022,934.0016,791.50- Maintenance Services19,5003,570.646,128.614,496.832,303.26 Rental/Leasing44,0006,681.8516,257.2013,132.6529,218.75 Operating Equipment3,000--304.97700.00 TOTAL PARKS DEPARTMENT810,31572,288.71248,689.61258,102.6244,064.08 SWIM POOL Supplies20,700-516.58376.6748.94 Utility Services29,0001,647.965,370.506,013.58216.79 Staff Support925-750.00-- Maintenance Services203,378-4,000.003,633.94- Rental/Lease500---- TOTAL SWIM POOL254,5031,647.9610,637.0810,024.19265.73 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR EVENT FACILITIES Personnel Services56,5354,035.5117,769.8015,313.69- Supplies27,000597.475,157.154,018.961,224.04 Utility Services48,2002,733.308,696.849,320.58335.90 Operations Support27,3322,360.002,830.264,209.00152.00 Staff Support2,72765.36722.46325.6215.00 Professional Services1,600-150.00-- Operating Equipment--5,660.70-- TOTAL COMMUNITY/CIVIC CNTR163,3949,791.6440,987.2133,187.851,726.94 TOTAL PARKS & RECREATION1,228,21283,728.31300,313.90301,314.6646,056.75 CULTURAL LIBRARY Personnel Services704,94049,029.97215,467.93196,832.62- Supplies12,00081.853,966.404,015.691,970.99 Utility Services51,0003,282.309,750.4510,533.71204.34 Operations Support3,500165.99174.00350.0815.99 Staff Support4,04055.00622.16356.0040.00 Professional Services2,225-2,140.002,140.00- Maintenance Services2,400-800.00400.00- Operating Equipment75,0003,068.1716,207.5214,352.177,472.12 TOTAL LIBRARY855,10555,683.28249,128.46228,980.279,703.44 TOTAL CULTURAL855,10555,683.28249,128.46228,980.279,703.44 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR HEALTH ANIMAL SERVICES Personnel Services300,10822,147.4189,293.9178,722.37- Supplies23,5001,202.666,389.885,432.482,317.02 Utility Services11,200397.532,978.842,228.44- Operations Support500---155.95 Staff Support12,7601,096.162,869.251,752.86752.39 City Assistance13,500987.471,750.822,208.081,047.66 Professional Services13,5001,583.001,651.002,904.221,750.63 Maintenance Services7,280120.002,340.00360.00133.84 Operating Equipment9,000350.001,374.38350.00- TOTAL ANIMAL SERVICES391,34827,884.23108,648.0893,958.456,157.49 TOTAL HEALTH391,34827,884.23108,648.0893,958.456,157.49 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services274,64020,627.8386,850.9381,570.28- Supplies3,00052.7568.84118.34- City Support Services395,762-59,543.6361,837.21147,861.90 Utility Services167,86615,466.7553,395.7543,459.506,846.33 Staff Support18,250715.644,340.233,596.86872.17 Professional Services2,500---- Maintenance Services8,000-5,732.44-2,850.00 Operating Equipment106,5004,519.3019,833.257,936.5616,434.98 Capital Outlay-1,896.40-3,530.408,253.97 TOTAL INFORMATION TECHNOLOGY976,51843,278.67229,765.07202,049.15183,119.35 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR HUMAN RESOURCES Personnel Services311,71020,523.5675,158.2579,791.843,405.00 Supplies1,329-781.5743.2044.33 Human Services55,1566,445.9512,969.048,960.95- Operations Support16,5962,819.851,432.413,843.60139.56 Staff Support14,897262.077,227.734,060.861,294.02 City Assistance9,860875.501,725.002,099.00850.00 Operating Equipment--4,162.83-- TOTAL HUMAN RESOURCES409,54830,926.93103,456.8398,799.455,732.91 FINANCE Personnel Services443,30632,908.35142,399.83132,022.58- Supplies3,500-1,809.061,047.98106.45 Operations Support300-97.31-- Staff Support16,060-988.671,735.45150.00 Rental/Leasing2,230---- Operating Equipment--266.47-- TOTAL FINANCE465,39632,908.35145,561.34134,806.01256.45 PURCHASING & ASSET MGT Personnel Services247,93618,480.3973,976.6774,821.51- Supplies950-119.70102.97120.69 Utility Services600-249.9773.41- Operations Support100-50.00-- Staff Support7,875137.501,862.20822.50260.00 Operating Equipment250-7,590.82-- TOTAL PURCHASING & ASSET MGT257,71118,617.8983,849.3675,820.39380.69 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR FLEET SERVICE Personnel Services218,52814,973.7857,023.8756,397.84- Supplies143,6508,101.9849,174.6154,451.3813,447.41 City Support Services2,400-1,500.001,488.00400.00 Utility Services7,200323.441,252.771,022.2711.81 Operations Support400---- Staff Support4,50082.40880.41418.54103.25 Maintenance Services65,7509,730.089,890.9623,302.396,160.02 Rental/Lease200-269.80-- Operating Equipment5,0002,503.635,349.972,503.631,380.85 TOTAL FLEET SERVICE447,62835,715.31125,342.39139,584.0521,503.34 BUILDING MAINTENANCE Personnel Services75,1426,848.96-6,848.96- Supplies43---- Utility Services2,952---- Staff Support356129.99-129.99- Maintenance Services49,8883,657.46-3,657.4610,748.35 Rental/Leasing1,400---375.00 Capital Outlay60,000--10,642.5014,107.50 TOTAL PURCHASING & ASSET MGT189,78110,636.41-21,278.9125,230.85 TOTAL INTERNAL SERVICE2,746,582172,083.56687,974.99672,337.96236,223.59 MISC & PROJECTS CITY ASSISTANCE Patient Assistance5,000-2,500.005,000.00- Children's Advocacy Assistance5,000---- Senior Citizen's Hot Meals42,00010,500.0010,500.0021,000.0021,000.00 TOTAL CITY ASSISTANCE52,00010,500.0013,000.0026,000.0021,000.00 COURT - RESTRICTED FUNDS Operating Equipment51,053--18,185.003,240.00 TOTAL CITY ASSISTANCE51,053--18,185.003,240.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR TOTAL MISC & PROJECTS103,05310,50013,00044,18524,240 TOTAL EXPENDITURES21,710,643 1,714,649.946,165,403.576,301,657.16521,324.48 14,887,661.42 REVENUE OVER(UNDER) EXPEND.392,9504,690,869.52 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Taxes 000-411100Advalorem Tax - Current7,481,207 2,180,144.986,082,062.236,532,204.25- 000-411200Advalorem Tax - Delinquent50,0001,370.5830,899.0422,502.86- 000-411300Advalorem Tax - P&I50,000566.669,772.968,313.13- 000-411500Sales Tax Revenue-Gen Fund5,637,958389,514.111,576,196.011,928,890.70- 000-411700Mixed Beverage Tax28,000.00-13,776.247,509.14- TOTAL Taxes 13,247,165 2,571,596.337,712,706.488,499,420.08-4,747,744.92 Franchises 000-421200Center Point/Entex Energy58,7637,606.5315,624.5623,435.49- 000-421220City Public Service375,00026,770.67105,255.25103,936.92- 000-421240Guadalupe Valley Elec Co-op430,00032,024.67126,693.43121,996.97- 000-421250New Braunfels Utilities50,0003,540.2714,672.7613,360.29- 000-421300Time Warner-State Franchise350,00029,815.22114,832.7729,815.23- 000-421460AT&T Franchise Fee190,00016,704.7659,769.5851,171.79- 000-421480Other Telecom Franchise110,000100.20433.242,239.71- 000-421500Solid Waste Franchise Fee102,0008,510.5432,282.2134,927.68- TOTAL Franchises1,665,763125,072.86469,563.80380,884.08- Permits 000-431100Home Occupation Permit49035.00175.00245.00- 000-431205Building Permit - Residential408,61835,778.00137,584.00136,227.00- 000-431210Building Permit - Commercial203,149-9,857.0011,519.00- 000-431215Building Permit - General118,7145,068.0033,634.0035,830.00- 000-431300Mobile Home Permit325100.0040.00100.00- 000-431400Signs Permit1,700242.00275.001,616.00- 000-431500Food Establishmnt Permit33,000700.009,475.0012,445.00- 000-431600Garage Sale Permit8,160280.002,860.003,475.00- 000-431700Plumbing Permit117,3248,082.0036,534.0029,584.00- 000-431750Electrical Permit45,0204,380.0013,440.0017,840.00- 000-431800Mechanical Permit48,4404,420.0015,400.0015,280.00- 000-431900Solicitor/Peddler Permit1,00050.00250.00550.00- 000-431950Animal/Pet Permit2,000105.00710.00370.00- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR 000-432000Cert. of Occupancy Prmt10,900850.002,700.002,450.00- 000-432100Security Alarm Permit45,0003,900.0015,475.0014,350.00- 000-435000Fire Permit8,000825.002,525.003,725.00- TOTAL Permits1,051,84064,815.00280,934.00285,606.00- Licenses 000-441000Alcohol Beverage License6,000117.501,032.501,687.50- 000-441300Mobile Home License200--160.00- 000-442000Contractors License60,00010,505.0018,415.0022,410.00- 000-444000Pet License4,000445.001,450.001,317.00- TOTAL Licenses70,20011,067.5020,897.5025,574.50- Fees 000-451000Municipal Court Fines1,610,000105,008.05303,469.23437,381.93- 000-451100Arrest Fee52,7344,743.3916,277.5319,556.26- 000-451110Expunction Fee120---- 000-451200Warrant Fees138,50012,685.3239,061.0048,783.41- 000-451210Court - Claims & Judgements--1,842.23-- 000-451320Civil Justice Fee-Court827.5825.6830.98- 000-451321Civil Justice Fee-State73768.00231.85278.93- 000-451340Judicial Fee - City7,022639.522,143.562,623.09- 000-451400Traffic Fine Costs TTL27,0112,426.468,425.439,991.28- 000-451500Teen Court Admin Fee50020.00220.00120.00- 000-451510Juvenile Case Mgmt Fee58,5825,329.4417,872.2121,894.52- 000-451600Technology Fund Fee47,1224,257.7114,390.0617,489.69- 000-451700Security Fee34,3403,193.2910,792.6213,117.26- 000-451800Time Payment Fee - City5,598660.381,696.811,842.85- 000-451850State Fines 10% Service Fee61,20419,067.4728,248.0244,273.32- 000-451900DPS Payment - Local10,9561,047.633,115.604,010.17- 000-452000Child Safety Fee23,0001,496.3010,081.246,756.59- 000-452050Indigent Defense Fee22,5242,115.676,933.638,673.12- 000-452100Platting Fees77,000500.0017,000.007,500.00- 000-452200Site Plan Fee30,0002,000.006,000.006,500.00- 000-452300Plan Check Fee289,40119,568.50102,352.0087,788.00- 000-452310Miscellaneous Review Fee10,800-3,000.00-- 000-452320Tree Mitigation Admin Fee10,500-780.00-- 000-452400BOA/Zoning Fees6,500-2,750.00-- 000-452500Food Handler Class3,0003,600.001,530.0010,580.00- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR 000-452520Fire Training Classes1,000---- 000-452600Specific Use/Zone Chng Fee47,7006,000.0012,350.006,000.00- 000-452710Zoning Ltr & Dev Rights2,100-1,050.00600.00- 000-453100Reinspection Fees39,5003,750.0012,825.0013,975.00- 000-453110Swim Pool Inspection Fee1,000---- 000-453200Lot Abatement5,000-710.834,017.79- 000-453211Admin Fee-Inspections7,480200.001,140.00800.00- 000-453310Misc Inspection Fee250-19.49-- 000-453710Foster Care750150.00250.00400.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 Fee750150.00250.00400.00- 000-458100Sale of Merchandise----- 000-458300Sale of Property/Auction25,000-8,933.30855.12- 000-458400Civic Center Rental Fees132,20014,285.7533,000.2548,763.00- 000-458401Capital Recovery Fee-Civic Cntr4,800275.00850.001,072.00- 000-458450North Center Rental Fees23,0001,880.007,702.925,270.00- 000-458500Community Center Rental Fees26,0002,173.007,888.998,130.40- 000-458550Pavilion Rental Fees18,000310.002,972.002,935.00- 000-458560Chamber of Comm rent11,7001,950.003,900.003,900.00- 000-458570Non-Resident SYSA League19,000-15,935.004,940.00- 000-458650NonResident User Fee-BVYA17,000-2,670.003,340.00- 000-458660BVYA Utility Reimbursement5,000-3,195.72-- 000-458670SYSA Utility Reimbursement7,500-2,098.92-- 000-458675Lions Futbol Utility Reimbursement-2,400.00-3,572.00- 000-458680Tournament Fees-Soccer3,000-7,625.00600.00- 000-458700Vehicle Impoundment5,779---- 000-459200NSF Check Fee250170.00-490.00- 000-459300Notary Fee25042.00114.00114.00- 000-459400Maps, Copies, UDC, & Misc F250-58.105.00- 000-459600Animal Adoption Fee14,0001,741.004,242.505,368.50- 000-459700Pet Impoundment Fee14,0001,271.054,765.254,754.05- 000-459800Police Reports Fee8,677670.001,801.202,247.90- TOTAL Fees2,997,169225,852.51734,642.17871,741.16- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Fines 000-463000Library Fines25,0002,269.137,893.718,784.43- TOTAL Fines25,0002,269.137,893.718,784.43- Inter-Jurisdictional 000-473100Bexar Co - Fire21,0721,756.487,025.927,025.92- 000-473200City of Seguin - Fire Contract31,4523,355.2613,421.0413,421.04- 000-473300Guad Co - Library208,343-63,605.3267,987.06- 000-473400Randolph AFB-Animal Cntrl 1,000-300.001,400.00- 000-474200Library Services - Cibolo20,000---- 000-474210Library Services-Selma18,393---- 000-474400Dispatch Service - Cibolo133,30533,326.2533,326.2533,326.25- 000-474600School Crossing Guard-Bexar27,0002,438.1310,278.4310,664.25- 000-474610School Cross Guard-Guadalupe24,602-10,172.628,057.94- 000-474700School Officer Funding155,000-50,000.0012,500.00- TOTAL Inter-Jurisdictional640,16740,876.12188,129.58154,382.46- Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.0029,280.0029,280.00- 000-480100Indirect Costs - Hotel/Motel157,51713,126.4247,542.0052,505.68- 000-481000Transfer From Reserves----- 000-485000Interfund Charge-Drainage49,7084,142.3313,945.0016,569.32- 000-486000Interfund Chrges-Admin W&S1,060,96388,413.58293,740.68353,654.32- 000-486000Transfer In-W&S80,000---- 000-486322Transfer-In - Library Grants----- 000-487000Interfund Charges-Fleet112,7619,396.7532,828.0037,587.00- 000-488000Interfund Charges-4B243,35020,279.1717,666.6881,116.68- 000-489000Transfer In158,603--66,082.57- 000-490020Transfer In-SEDC----- TOTAL Fund Transfers1,950,742142,678.25435,002.36636,795.57- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Miscellaneous 000-491000Interest Earned350-76.8130.49- 000-491200Investment Income45,000-14,347.4710,244.14- 000-491800Gain/Loss--247.42-- 000-491900Unrealized Gain/Loss(26,000)-(9,300.80)(8,636.25)- 000-492100Proceeds-Sale of Land--57,867.85-- 000-493120Donations-Public Library---7,500.00- 000-493130Donations-Writing the Next Chap.2,00050.004,754.34200.00- 000-493400Donation - Animal Control4,000390.511,559.011,108.76- 000-493401Donations-A/C Microchip2,000175.00675.00595.00- 000-493402Donations-Spay&Neuter12,0002,425.004,247.005,570.89- 000-493503Donations - Fire Rescue---150.00- 000-494481LawEnforcemtOfficersStnd&Ed----- 000-494482Grants - Police2,997---- 000-495040Friends of N. Schertz Park--3,074.00885.00- 000-495100Mobile Stage Rental Fees2,000---- 000-497000Misc Income-Gen Fund50,000(49.57)(35,150.45)6,391.34(132.10) 000-497005Schertztales Advertising220,00018,796.0058,214.0075,774.00- 000-497007Misc Income-Schertz Artz-(90.00)-10.00- 000-497100Misc Income-Police20,000715.001,979.044,631.76- 000-497150Misc Income-Fire Department---292.37- 000-497200Misc Income-Library4,000323.251,377.541,313.50- 000-497210Misc Income-Library Copier12,000866.254,569.214,532.90- 000-497300Misc Income-Animal Control200175.00105.00190.00- 000-497400Misc Income-Streets Dept.15,0001,101.506,121.887,194.80- 000-497500Misc Income-TML Insurance2,000---- 000-497550Misc Income-TML Reimbursemt15,000-4,133.894,938.66- 000-497600Misc Income-Vending Mach.2,000365.98646.59686.22- 000-498000Reimbursmnt-Gen Fund50,0003,357.1820,792.024,676.58- 000-498100Reimbursmnt Fire - Training1,000---- 000-498105Reimburmnt Police - DEA--569.871,058.24- 000-498110Reimbursmnt Fire - Emg. Acti-O20,000-29,296.02-- TOTAL Miscellaneous455,54728,601.10170,202.71129,338.40(132.10) TOTAL REVENUES 22,103,593 3,212,828.80 10,019,972.31 10,992,526.68(132.10) 11,111,198.42 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 1,807,232.95 Cash in Investments LOGIC Investment-General Fund4,063,369.71 LOGIC Investment-Equip Replacement73,514.22 LOGIC Investment-Veh Replacement102,557.87 LOGIC Investment-Air Condi Replacment146,777.31 CAPITAL ONE Investment-General Fund1,341,555.64 Total Cash in Bank & Investments$ 7,681,589.54 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 292,988636,9643,422,1072,180,145 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 40% $500,000 2% 2% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 439,433575,041474,246424,191 2011-12 428,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: JANUARY 31st, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 106-SPECIAL EVENTS FUNDCURRENTCURRENTPRIORCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Fund Transfers75,150.00----75,150.00 Wilenchik Walk for Life31,000.00110.0040.00110.00-30,890.00 Hal Balwin Scholarship24,000.00-60.0018,155.00- Miscellaneous1,150.00110.00748.45933.99- TOTAL REVENUES131,300.00220.00848.4519,198.99-112,101.01 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00---- TOTAL GENERAL GOVERNMENT5,150.00---- CULTURAL Other Events4,265.00--485.00- Festival of Angels14,750.001,267.9713,050.4614,365.46- Employee Appreciation Event6,485.00--4,500.00- National Night Out150.00---- Wilenchik Walk for Life31,000.00-160.00--31,000.00 Schertz Sweetheart37,500.00206.782,983.161,527.3569.3435,903.31 Jazzfest20,000.00----20,000.00 Hal Baldwin Scholarship12,000.00-1,000.007,912.27-4,087.73 TOTAL CULTURAL126,150.001,474.7517,193.6228,790.0869.3497,290.58 TOTAL EXPENDITURES131,300.001,474.7517,193.6228,790.0869.34102,440.58 REVENUE OVER(UNDER) EXPEND-(9,591.09) SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 36,247.75 Cash in Investments MBIA Special Events46,723.37 Total Cash in Bank & Investments$ 82,971.12 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 110-PEG FUNDCURRENTCURRENTPRIORCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Franchises98,000.00-23,287.4522,919.78-75,080.22 Fund Transfers33,000.00----33,000.00 Miscellaneous--19.34-- TOTAL REVENUES131,000.00-23,306.7922,919.78-108,080.22 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental131,000.009,511.47123.1920,181.96-110,818.04 TOTAL GENERAL GOVERNMENT131,000.009,511.47123.1920,181.96-110,818.04 TOTAL EXPENDITURES131,000.009,511.47123.1920,181.96-110,818.04 REVENUE OVER(UNDER) EXPEND-2,737.82 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Franchises 000-421350Time Warner - PEG Fee65,000-16,039.5014,960.80-50,039.20 000-421465AT&T PEG Fee33,000-7,247.957,958.98-25,041.02 TOTAL Franchises98,000-23,287.4522,919.78-75,080.22 Fund Transfers 000-481000Transfer In - Reserves33,000----33,000.00 TOTAL Fund Transfers33,000----33,000.00 Miscellaneous 000-491000Interest Earned--19.34-- TOTAL Miscellaneous--19.34-- TOTAL REVENUES131,000-23,306.7922,920-108,080.22 PEG FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Cash Balance$ 381,361.06 Total Cash in Bank & Investments$ 381,361.06 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWER CURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE REVENUE SUMMARY Franchises187,920-31,014.33--187,920.00 Fees 14,655,3761,159,143.445,097,972.905,144,001.51-9,511,374.49 Fund Transfers1,419,2989,941.5028,224.6839,766.00-1,379,532.00 Miscellaneous430,148194.63193,259.00182,309.64-247,838.36 TOTAL REVENUES16,692,7421,169,279.575,350,470.915,366,077.15-11,326,664.85 EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services436,69430,181.01110,079.50115,613.86-321,080.14 Supplies4,6007.841,404.52473.8283.17 Human Services100--122.00- City Support Services1,000---- Operations Support110,0001,560.8734,865.7916,426.14308.84 Staff Support7,15034.36404.7494.49273.40 Professional Services23,000-7,251.983,983.28- Fund Charges/Transfers20,000---- Maintenance Services11,000-3,180.005,260.005,280.00 Operating Equipment2,3001,428.705,932.941,428.70- TOTAL BUSINESS OFFICE615,84433,212.78163,119.47143,402.295,945.41466,496.30 W & S ADMINISTRATION Personnel Services1,184,01376,677.28352,577.81308,665.54-875,347.46 Supplies199,050666.7721,902.8933,246.3961,255.17104,548.44 Human Services1,000141.00-141.00- City Support Services77,5001,901.2734,329.5934,362.40- Utility Services2,727,313171,326.731,098,901.78224,453.01534.912,502,324.72 Operations Support9,250256.011,259.82768.03- Staff Support31,5002,427.866,229.778,128.051,639.21 City Assistance1,912-150.00303.00- Professional Services212,40013,608.2377,896.9216,623.631,591.01194,185.36 Fund Charges/Transfers3,137,04799,959.251,053,666.77378,087.00-2,758,960.00 Maintenance Services5,586,250537,877.511,536,323.451,529,454.5778,124.373,978,671.06 Other Costs40,000-1,250.0029,541.85- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWER CURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE Debt Service1,353,891103,991.33890.22103,991.33-1,249,899.19 Rental-Leasing6,070-2,516.68442.18- Operating Equipment6,000-12,000.00757.50- Capital Outlay188,00072,450.0070,000.0082,450.00430.30105,119.70 TOTAL PUBLIC WORKS 14,761,1951,081,283.244,269,895.702,751,415.48143,574.9711,866,204.71 MISC & PROJECTS PROJECTS City Support Services----- Operations Support----- Professional Services----- Maintenance Services902,000----902,000.00 TOTAL PROJECTS902,000----902,000.00 AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- Operations Support500---- Professional Services48,000---- Maintenance Services334,500----334,500.00 TOTAL AVIATION HEIGHTS WTR IMP400,000----400,000.00 TOTAL MISC & PROJECTS1,302,000----1,302,000.00 TOTAL EXPENDITURES16,679,0391,114,4964,433,0152,894,818149,52013,634,701 ** REVENUE OVER(UNDER)EXPENSES **13,7032,471,259.38 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWERCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Franchises 000-421490Tower Leasing187,920-31,014.33-- TOTAL Franchises187,920-31,014.33-- Fees 000-455200Garbage Collection Fee3,600,000275,256.151,173,971.141,179,319.80-2,420,680.20 000-455600Fire Line Fees20,000-19,690.0020,635.00- 000-455700Recycle Fee Revenue250,00020,883.9283,974.1689,985.70- 000-455800W&S Line Constructn Reimbursemnt30,0001,650.008,632.086,297.82- 000-457100Sale of Water7,279,626543,371.922,523,062.192,566,242.08-4,713,383.92 000-457110Edwards Water Lease166,25028,532.85138,590.6055,232.85- 000-457120Water Transfer Charge-Selma20,0007,719.2013,657.9521,648.48- 000-457130Water Transfer Charge-U. C. 2,0001,306.722,199.973,073.12- 000-457140Water Transfer Charge-Converse15,0008,074.24-18,723.68- 000-457200Sale of Meters90,0004,531.8519,720.5816,707.05- 000-457400Sewer Charges3,000,000251,808.411,050,088.761,100,366.01-1,899,633.99 000-457500Water Penalties180,00015,848.1863,155.4764,709.92- 000-459200NSF Check Fee-Water&Sewer2,500160.001,230.001,060.00- TOTAL Fees 14,655,376 1,159,143.445,097,972.905,144,001.51-9,511,374.49 Fund Transfers 000-481000Transfer In- Reserve1,300,000----1,300,000.00 000-486100Transfer In----- 000-486204Interfnd Chrg-Drainage Bill119,2989,941.5028,224.6839,766.00- TOTAL Fund Transfers1,419,2989,941.5028,224.6839,766.00-1,379,532.00 Miscellaneous 000-490000Misc Charges20046.0073.05774.30- 000-491000Interest Earned1,600-685.63269.13- 000-491200Investment Income12,000-5,533.45670.56- 000-493400Donations-Christmas Activities--750.00-- 000-496050SSLG - SAWS Reservation269,000-134,500.00134,500.00- 000-497000Misc Income-W&S40,000148.6326,017.5719,593.54- 000-498100Reimbursement-EMS Loan----- 000-498110Reimbursement-SSLGC107,348-25,699.3026,502.11- TOTAL Miscellaneous430,148194.63193,259.00182,309.64- TOTAL REVENUES 16,692,742 1,169,279.575,350,470.915,366,077.15- 11,326,664.85 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank $ (192,917.73) Claim on Operating Cash Pool-Checking Cash in Investments Lone Star Investment-Water&Sewer2,069,007.30 Lone Star Investment-W&S Customer Deposits294,555.17 Lone Star Investment-W&S Equip Replacement374,199.29 Lone Star Investment-W&S Veh Replacement545,627.31 Lone Star Investment-Water/SSLGC SAWS539,242.68 Schertz Bank & Trust-Certificate of Deposit1,060,132.25 $ 4,882,764.00 Total Cash in Bank & Investments$4,689,846.27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 203-EMSCURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE REVENUE SUMMARY Fees431,317.681,042,622.70 1,563,042.97(725.00) 2,587,084.03 4,149,402 Inter-Jurisdictional321,294.98661,797.45692,348.38-794,374.62 1,486,723 Miscellaneous236,5002,195.5424,743.2827,775.35-208,724.65 TOTAL REVENUES754,808.201,729,163.432,283,166.70(725.00)3,590,183.30 5,872,625 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services214,399.19846,936.33852,622.04- 1,963,099.98 2,815,722 Supplies345,08934,104.90125,410.84101,344.1338,107.85205,637.02 Human Services80071.00-132.00- City Support Services32,500-10,277.4013,888.85-18,611.15 Utility Services107,6009,712.9335,959.8132,665.54329.5174,604.95 Operations Support45,1522,803.2927,930.2529,452.27103.8015,595.93 Staff Support60,9007,368.6022,202.3818,218.2716,226.2526,455.48 City Assistance9,200702.001,885.001,804.001,500.005,896.00 Professional Services166,93612,361.9140,842.1852,290.324,896.24109,749.44 Fund Charges/Transfers10,541.75269,021.96174,694.00- 1,805,361.00 1,980,055 Maintenance Services53,7006,220.006,208.0020,120.002,138.4731,441.53 Debt Service110,54564,766.505,863.0064,766.50-45,778.17 Rental-Leasing12,000----12,000.00 Operating Equipment117,0002,877.3536,379.5111,051.31147,677.29(41,728.60) Capital Outlay----- TOTAL PUBLIC SAFETY365,929.421,428,916.661,373,049.23210,979.414,273,170.05 5,857,199 TOTAL EXPENDITURES365,929.421,428,916.661,373,049.23210,979.414,273,170.05 5,857,199 ** REVENUE OVER(UNDER) EXPENSES **15,426910,117.47 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 203-EMSCURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE Fees 000-456100Ambulance/Mileage Transport3,908,602407,732.641,000,840.70 1,526,407.93- 2,382,194.07 000-456110Subscription Program Fees40,00011,055.0016,075.0015,575.00-24,425.00 000-456120EMT Class - Fees100,80012,240.0023,901.0020,750.00(725.00)80,775.00 000-459200Paramedic Class Fees100,000---100,000.00 000-456130Immunization Fees--1,806.00-- 000-456140Billing Fees - Alamo Heights-290.04-290.04-(290.04) 000-459200NSF Check Fee---20.00-(20.00) TOTAL Fees4,149,402431,317.681,042,622.70 1,563,042.97(725.00) 2,587,084.03 Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,12623,844.0495,376.1695,376.16-190,749.84 000-474300Cibolo Support228,83057,207.55111,049.96114,415.10-114,414.90 000-475100Comal Co ESD #685,41822,008.7127,635.3042,735.19-42,682.81 000-475200Live Oak Support165,18841,296.9980,164.7682,593.98-82,594.02 000-475300Universal City Support233,10758,276.85113,975.66116,553.70-116,553.30 000-475400Selma Support69,69317,423.3033,821.7034,846.60-34,846.40 000-475500Schertz Support395,83098,957.42192,093.82197,914.84-197,915.16 000-475600Santa Clara Support9,1212,280.124,426.124,560.24-4,560.76 000-475800Marion Support13,410-3,253.973,352.57-10,057.43 TOTAL Inter-Jurisdictional1,486,723321,294.98661,797.45692,348.38-794,374.62 Miscellaneous 000-491200Investment Income500-173.31154.51-345.49 000-493203Donations-EMS4,00015.00475.00181.00-3,819.00 000-493204Donations-Dilworth Fund2,000----2,000.00 000-493205Donations- Golf Tournament----- 000-497000Misc Income130,0002,035.5423,204.9723,776.03-106,223.97 000-497100Recovery of Bad Debt100,000145.00890.003,663.81-96,336.19 TOTAL Miscellaneous236,5002,195.5424,743.2827,775.35-208,724.65 TOTAL REVENUES5,872,625754,808.201,729,163.43 2,283,166.70(725.00) 3,590,183.30 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank $ (194,037.56) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,616.23 Total Cash in Bank & Investments$ 107,578.67 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Fees998,15785,686.10253,899.70340,214.00-657,943.00 Miscellaneous800120.00300.76611.31-188.69 TOTAL REVENUES998,95785,806.10254,200.46340,825.31-658,131.69 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services447,40624,265.59106,743.22114,223.28-333,182.72 Supplies8,300156.12549.101,120.8234.677,144.51 Human Services325----325.00 City Support Services28,855-1,508.721,463.58-27,391.42 Utility Services28,8881,647.396,391.625,838.50153.4822,896.02 Operations Support2,460----2,460.00 Staff Support7,875238.92615.94801.11258.666,815.23 City Assistance84045.0057.0060.00-780.00 Professional Services65,800-5,250.002,100.00-63,700.00 Fund Charges/Transfers189,13615,694.6647,143.6862,778.64-126,357.36 Maintenance Services22,000--2,107.56-19,892.44 Other costs200100.00-100.00-100.00 Debt Service18,0911,345.351,632.071,345.35-16,745.65 Rental/Leasing500----500.00 Capital Outlay139,90045,500.79-63,725.5961,551.4414,622.97 TOTAL DRAINAGE960,57688,993.82169,891.35255,664.4361,998.25642,913.32 TOTAL EXPENDITURES960,57688,993.82169,891.35255,664.4361,998.25642,913.32 ** REVENUE OVER(UNDER) EXPEND38,38185,160.88 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *********************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 204-DRAINAGECURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE Fees 000-457500Drainage Penalties4,000656.921,771.172,465.97-1,534.03 000-457600Drainage Fee994,157252,128.53337,748.03-656,408.97 85,029.18 TOTAL Fees998,157253,899.70340,214.00-657,943.00 85,686.10 Miscellaneous 000-491000Interest Earned100-26.037.21-92.79 000-491200Investment Interest600-253.94250.24-349.76 000-497000Misc Income-Drainage100120.0020.79353.86-(253.86) TOTAL Miscellaneous 800120.00300.76611.31-188.69 TOTAL REVENUES998,957254,200.46340,825.31-658,131.69 85,806.10 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking 130,401.21 Cash in Investments Lone Star Investment-Drainage Maint Fund484,217.01 Total Cash in Bank & Investments$ 614,618.22 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Taxes492,41739,010.8188,110.3376,864.69-415,552.31 Fund Transfers------ Miscellaneous300-84.62142.13-157.87 TOTAL REVENUES492,71739,010.8188,194.9577,006.82-415,710.18 EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies2,000-231.08--2,000.00 City Support Services68,37827,411.0035,814.0035,945.56-32,432.44 Operations Support99,175-8,430.294,386.00-94,789.00 Professional Services5,625--7,850.00-(2,225.00) Fund Charges/Transfers248,76713,126.4247,542.0052,505.68-196,261.32 Operating Equipment50,000428.5915,208.869,152.5410,343.7530,503.71 Capital Outlay8,000----8,000.00 TOTAL NONDEPARTMENTAL481,94540,966.01107,226.23109,839.7810,343.75361,761.47 TOTAL EXPENDITURES481,94540,966.01107,226.23109,839.7810,343.75361,761.47 REVENUE OVER(UNDER) EXPENDITURE10,772(32,832.96) C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Taxes 000-411800Hotel Occupancy Tax492,41739,010.8188,110.3376,864.69-415,552.31 TOTAL Taxes492,41739,010.8188,110.3376,864.69- 415,552.31 Miscellaneous 000-491000Interest Earned150-39.963.08-146.92 000-491200Investment Interest150-44.66139.05-10.95 TOTAL Miscellaneous300-84.62142.13-157.87 TOTAL REVENUES492,71739,010.8188,194.9577,006.82- 415,710.18 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 59,133.17 Cash in Investments MBIA - Hotel Tax220,336.78 Federated Investment-Hotel/Motel78,298.47 Total Cash in Bank & Investments$ 357,768.42 ØÑÌÛÔ ÑÝÝËÐßÒÝÇ ÌßÈ üêðôððð üëðôððð üìðôððð üíðôððð üîðôððð üïðôððð üó ÑÝÌÒÑÊÜÛÝÖßÒÚÛÞÓßÎßÐÎÓßÇÖËÒ îðïîóïí íëôèëïíçôìíçíîôíçî îðïïóïî ííôïîèíîôêéëíîôïìííëôèîçíêôîïëìëôðéïíêôëïèìðôííëìèôíçéëíôêîî îðïðóïï îéôêèçîëôïïîîíôîíïïçôêïçîîôêêéíêôéîèîèôîïëíìôïëéìëôèëìëíôìíí îððçóïð îíôêîëîîôðîêîðôéêèïçôçîìîíôïêçííôêíèîêôëíïíîôíêèíêôêéêìêôðêç îððèóðç ïéôëìçîðôïíìïèôìêïïéôîëëïëôïíèïçôîçéïçôëìèîìôéêçîçôêçëíîôííê C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 317-PARKCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Parkland Dedication Fees150,00033,000.0052,575.00131,000.00-19,000.00 Miscellaneous300-225.1258.14-241.86 TOTAL REVENUES150,30033,000.0052,800.12131,058.14-19,241.86 EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services--13,000.00545.00-(545.00) Fund Charges/Transfers------ Maintenance Services-Landscape------ Operating Equipment--27,979.651,210.00979.50(2,189.50) Capital Outlay107,600-23,416.00--107,600.00 TOTAL PARKLAND DEDICATION107,600-64,395.651,755.00979.50104,865.50 TOTAL EXPENDITURES107,600-64,395.651,755.00979.50104,865.50 REVENUE OVER(UNDER) EXPEND42,700129,303.14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 317-PARKCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCE Fees 000-458800Parkland Dedication150,00033,000.0052,575.00131,000.00-19,000.00 TOTAL Fees150,00033,000.0052,575.00131,000.00-19,000.00 Miscellaneous 000-491000Interest Earned--6.782.48-(2.48) 000-491200Investment Interest300-218.3455.66-244.34 TOTAL Miscellaneous300-225.1258.14-241.86 TOTAL REVENUES150,30033,000.0052,800.12131,058.14-19,241.86 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$116,753.82 Cash in Investments Federated Investment-Park Fund167,480.71 Total in Investment Pool167,480.71 Total Cash in Bank & Investments$284,234.53 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 319-TREE MITIGATIONCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Tree Mitigation Fees35,000-4,420.00--35,000.00 Miscellaneous61,725--1,737.49-59,987.51 TOTAL REVENUES96,725-4,420.001,737.49-94,987.51 EXPENDITURE SUMMARY TREE MITIGATION Fund Charges/Transfers------ Maintenance Services-Trees73,299-390.0033,300.00-39,998.94 Operating Equipment------ Capital Outlay23,226-19,900.0023,226.06-- TOTAL TREE MITIGATION96,525-20,290.0056,526.06-39,998.94 TOTAL EXPENDITURES96,525-20,290.0056,526.06-39,998.94 REVENUE OVER(UNDER) EXPEND200(54,788.57) C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 319-TREE MITIGATIONCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCE Fees 000-458900Tree Mitigation35,000-4,420.00--35,000.00 TOTAL Fees35,000-4,420.00--35,000.00 Miscellaneous 000-491000Interest Earned----- 000-491200Investment Interest200--47.49-152.51 000-497000Misc Income---1,690.00-(1,690.00) 000-499000Transfer In Reserves61,525----61,525.00 TOTAL Miscellaneous61,725--1,737.49-59,987.51 TOTAL REVENUES96,725-4,420.001,737.49-94,987.51 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$64,432.38 Cash in Investments Federated Investment-Tree Mitigation97,176.74 Total in Investment Pool97,176.74 Total Cash in Bank & Investments$161,609.12 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 411-CAPITAL RECOVERYCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Fees1,924,20091,842.00444,799.08374,139.00- 1,550,061.00 Fund Transfers1,542,674---- 1,542,674.00 Miscellaneous298,750-5,628.992,918.31-295,831.69 TOTAL REVENUES3,765,62491,842.00450,428.07377,057.31-3,388,566.69 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000---5,000.00 Operations Support109-108.50--109.00 Professional Services450,0001,521.871,415.666,682.76-443,317.24 Fund Charges/Transfers----- Maintenance Services10,000----10,000.00 Debt Service206,515-108,671.00--206,515.00 TOTAL NON DEPARTMENTAL671,6241,521.87110,195.166,682.76-664,941.24 MISC & PROJECTS Water Projects1,680,000-10,488.422,759.64- 1,677,240.36 Sewer Projects1,414,00029,566.46-53,196.4612,859.221,347,944.32 TOTAL MISC & PROJECTS3,094,00029,566.4610,488.4255,956.1012,859.223,025,184.68 TOTAL EXPENDITURES3,765,62431,088.33120,683.5862,638.8612,859.223,690,125.92 REVENUE OVER(UNDER) EXPENDITURES-314,418 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2012 **************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 411-CAPITAL RECOVERYCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Fees 000-455900Capital Recovery - Water1,173,60049,878.00312,639.00224,451.00- 000-455910Capital Recovery - Waste Wtr667,20038,364.00124,960.08110,088.00- 000-455913Cap Recovery-North Sewer Tr83,4003,600.007,200.0039,600.00- TOTAL Fees1,924,20091,842.00444,799.08374,139.00-1,550,061.00 Fund Transfers 000-481000Transfer from Reserves1,542,674----1,542,674.00 000-486202Transfer in-Water----- TOTAL Fund Transfers1,542,674----1,542,674.00 Miscellaneous 000-491000Interest Earned250-88.4326.38- 000-491200Investment Income40,000-15,535.0314,150.83- 000-491800Gain/Loss--(768.78)-- 000-491900Unrealized Gain/Loss-Cap One(25,000)-(9,225.69)(11,258.90)- 000-497000Misc Income----- 000-498200Re-imbursement-Water Meters283,500---- TOTAL Miscellaneous298,750-5,628.992,918.31- TOTAL REVENUES3,765,62491,842.00450,428.07377,057.31-3,388,566.69 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 908,031.84 Cash in Investments Lone Star Investment-Capital Recovery Water2,112,038.10 Lone Star Investment-Capital Recovery Sewer866,905.81 Capital One-Investment1,718,775.56 Total Cash in Bank & Investments$5,605,751.31 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JAUNARY 31st, 2013 ****************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 505-TAX I&SCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Taxes5,032,646 1,462,320.163,778,878.274,393,943.07-638,702.93 Fund Transfers55,000----55,000.00 Miscellaneous381,625-47.758,456.32-373,168.68 TOTAL REVENUES5,469,2711,462,320.163,778,926.024,402,399.39-1,066,871.61 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services42,350550.0036,210.39550.00-41,800.00 Debt Service5,159,586 1,853,524.131,915,513.891,853,524.13- 3,306,061.37 Other Financing Sources----- TOTAL GENERAL GOVERNMENT5,201,9361,854,074.131,951,724.281,854,074.13-3,347,861.37 TOTAL EXPENDITURES5,201,9361,854,074.131,951,724.281,854,074.13-3,347,861.37 ** REVENUE OVER(UNDER) EXPEND267,3362,548,325.26 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JAUNARY 31st, 2013 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 505-TAX I & SCURRENTCURRENTPRIOR YEARCURRRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Taxes 000-411900Property Tax Revenue5,032,6461,462,320.163,778,878.274,393,943.07-638,702.93 TOTAL Taxes5,032,646 1,462,320.163,778,878.274,393,943.07-638,702.93 Fund Transfers 000-486401Transfer In Fund 40155,000----55,000.00 TOTAL Fund Transfers55,000----55,000.00 Miscellaneous 000-491000Interest Earned50-27.872.71- 000-491200Investment Earnings12,500-8,135.938,453.61- 000-495015Contribution from SED369,075----369,075.00 000-497000Misc Income--(8,116.05)-- TOTAL Miscellaneous381,625-47.758,456.32-373,168.68 TOTAL REVENUES5,469,271 1,462,320.163,778,926.024,402,399.39- 1,066,871.61 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JAUNARY 31st, 2013 505-TAX I & S***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARCURRENTY-T-D NON DEPARTMENTALBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBR Professional Services 101-541500Paying Agent2,350-400.00-- 101-541502Cost of Bond Issuance40,000550.0035,810.39550.00- TOTAL Professional Services42,35055036,210.39550.00- 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-100,000.00-- 101-555626.1LS&D SR2006-Interest642,982-325,490.64-- 101-555628CO Bond 2007-Principal109,534---- 101-555628.1CO Bond 2007-Interest18,4999,249.0710,864.439,249.07- 101-555629GO Bond 2007-Principal235,000235,000.00225,000.00235,000.00- 101-555629.1GO Bond 2007-Interest189,56197,109.43101,750.0097,109.43- 101-555630GO Bond SR2008 Principal385,000385,000.00370,000.00385,000.00- 101-555630.1GO Bond SR2008 Interest349,089178,519.25186,159.75178,519.25- 101-555631GO Bond SR2009 Principal510,000---- 101-555631.1BO Bond SR2009 Interest327,950---- 101-555633GO SR2011 Principal200,000200,000.0090,000.00200,000.00- 101-555633.1GO SR2011 Interest367,238186,118.75346,167.71186,118.75- 101-555634GO SR2011A Refund Principal70,00070,000.00140,000.0070,000.00- 101-555634.1GO SR2011A Refund Interest153,08176,948.2520,081.3676,948.25- 101-555635GO SR2012 Principal295,000295,000.00-295,000.00- 101-555635.1GO SR2012 Interest233,784120,579.38-120,579.38- TOTAL Debt Service5,159,586 1,853,524.131,915,513.891,853,524.13- 3,306,061.37 Other Financing Sources 101-556300Payment to Refund Debt----- TOTAL Other Financing Sources----- TOTAL EXPENDITURES5,201,9361,854,0741,951,7241,854,074- 3,347,861.37 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JAUNARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 870,887.74 Cash in Investments MBIA Investment- Tax I&S1,802,867.47 Federated Investment-Tax I&S56.94 Total Cash in Bank & Investments$2,673,812.15 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Taxes2,820,260185,321.39788,098.05955,009.69-1,865,250.31 Fund Transfers------ Miscellaneous17,450505.51615.323,531.28-13,918.72 TOTAL REVENUES2,837,710185,826.90788,713.37958,540.97-1,879,169.03 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies--10,288.81--- Utility Service--21,923.48--- Maintenance Services--23,372.72--- TOTAL NONDEPARTMENTAL--55,585.01--- ECONOMIC DEVELOPMENT Personnel Services294,59320,901.7365,195.1978,721.40-215,871.60 Supplies2,200-230.5596.7024.452,078.85 Human Services200----200.00 City Support Services16,500-7,698.291,269.13137.9215,092.95 Utility Services5,95074.62590.91336.109.995,603.91 Operations Support166,1004,595.5159,649.0555,667.43359.60110,072.97 Staff Support20,250206.6110,105.023,574.554,388.1712,287.28 City Assistance1,025,000108.2610,000.00587.95-1,024,412.05 Professional Services97,50053,513.2747,962.7553,513.2719,217.7124,769.02 Fund Charges/Transfers615,64720,547.6718,661.6882,190.68-533,456.32 Debt Service428,504275,526.75275,195.75275,526.75-152,977.25 Operating Equipment2,000114.27-114.27219.971,665.76 TOTAL ECONO DEVELOPMENT2,674,444375,588.69495,289.19551,598.2324,357.812,098,487.96 TOTAL EXPENDITURES2,674,444375,588.69550,874.20551,598.2324,357.812,098,487.96 ** REVENUE OVER(UNDER) EXPEND163,266406,942.74 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARCURRENTY-T-D BUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Taxes 000-411500Sales Tax Revenue (4B)2,820,260185,321.39788,098.05955,009.69-1,865,250.31 TOTAL Taxes2,820,260185,321.39788,098.05955,009.69-1,865,250.31 Miscellaneous 000-491000Interest Earned200-64.5210.79- 000-491200Investment Earnings12,250505.512,740.623,520.49- 000-497000Misc Income5,000-(2,189.82)-- TOTAL Miscellaneous17,450505.51615.323,531.28- TOTAL REVENUES2,837,710185,826.90788,713.37958,540.97-1,879,169.03 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 574,753.72 Cash in Investments MBIA Investment-Economic Development Corp2,679,082.29 Schertz Bank & Trust-Certificate of Deposit1,038,541.60 Total Cash in Bank & Investments$ 4,292,377.61 4B SALES TAX $350,000 24% $300,000 40% $250,000 2% 2% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 219,717287,520237,123212,096 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 Ý × Ì Ç Ñ Ú Í Ý Ø Û Î Ì Æ ×ÒÊÛÍÌÓÛÒÌ ÎÛÐÑÎÌ ÚÑÎ ÓÑÒÌØ ÛÒÜ×ÒÙ ÖßÒËßÎÇ íï¬ô îðïí ×ÒÊÛÍÌÓÛÒÌ ÐÑÑÔÍÐ¿®Þ»¹·²²·²¹Ü»°±·¬ñÛ²¼·²¹Û²¼·²¹ Ê¿´«»Þ±±µ Ê¿´«»Ç·»´¼Ð«®½¸¿»É·¬¸¼®¿©¿´Þ±±µ Ê¿´«»Óµ¬ Ê¿´«» ÑÐÛÎßÌ×ÑÒÍóÞßÒÕ ÝßÍØ Í½¸»®¬¦ Þ¿²µ ú Ì®«¬ ó Ð±±´»¼ Ý¿¸ ëôêììôçíêòéî ìôëíëôîïìòîððòðëðð èôéêèôìðëòðè éôêëèôêèîòëê ëôêììôçíêòéî ëôêììôçíêòéî Í½¸»®¬¦ Þ¿²µ ú Ì®«¬ ó ÐÛÙ Ú«²¼ íèïôíêïòðê íçðôèéîòëíðòðððð ó çôëïïòìé íèïôíêïòðê íèïôíêïòðê ÌÑÌßÔ ÑÐÛÎßÌ×ÑÒÍ êôðîêôîçéòéè ìôçîêôðèêòéí èôéêèôìðëòðè éôêêèôïçìòðí êôðîêôîçéòéè êôðîêôîçéòéè ÔÑÙ×Ý Ù»²»®¿´ Ú«²¼ ìôðêíôíêçòéï îôèêîôçééòçîðòïëëí ïôîððôíçïòéç ó ìôðêíôíêçòéï ìôðêíôíêçòéï ÙñÚóÛ¯«·°³»²¬ Î»°´¿½»³»²¬ éíôëïìòîî éíôëðìòëêðòïëëí çòêê ó éíôëïìòîî éíôëïìòîî ÙñÚóÊ»¸·½´» Î»°´¿½»³»²¬ ïðîôëëéòèé ïðîôëììòíêðòïëëí ïíòëï ó ïðîôëëéòèé ïðîôëëéòèé ÙñÚóß·® Ý±²¼·¬·±²»® Î»°´¿½»³»²¬ ïìêôéééòíï ïìêôéëéòçëðòïëëí ïçòíê ó ïìêôéééòíï ïìêôéééòíï ÍÎîððç Þ±²¼óÍ¬®»»¬ Ð®±¶»½¬ø××÷ ïôêçîôðçèòìð ïôêçïôèéëòîîðòïëëí îîíòïè ó ïôêçîôðçèòìð ïôêçîôðçèòìð ÌÑÌßÔ ÔÑÙ×Ý êôðéèôíïéòëï ìôèééôêêðòðï ïôîððôêëéòëð ó êôðéèôíïéòëï êôðéèôíïéòëï ÔÑÒÛÍÌßÎ Ý¿°·¬¿´ Î»½±ª»®§ ó Í»©»® èêêôçðëòèï èêêôééïòðððòïèðð ïíìòèï ó èêêôçðëòèï èêêôçðëòèï Ý¿°·¬¿´ Î»½±ª»®§ ó É¿¬»® îôïïîôðíèòïð îôïïïôéðçòêéðòïèðð íîèòìí ó îôïïîôðíèòïð îôïïîôðíèòïð Ü®¿·²¿¹» Ú«²¼ ìèìôîïéòðï ìèìôïìïòéïðòïèðð éëòíð ó ìèìôîïéòðï ìèìôîïéòðï ÙÑ ÍÎîðïï ß²·³¿´ Í¸»´¬»® îôðêëôïðèòêí îôðêìôéèéòëððòïèðð íîïòïí ó îôðêëôïðèòêí îôðêëôïðèòêí ÙÑ ÍÎîðïï ß¬¸´»¬·½ Ú·»´¼ îôçèëôêîîòìð îôçèëôïëèòïíðòïèðð ìêìòîé ó îôçèëôêîîòìð îôçèëôêîîòìð ÙÑ ÍÎîðïï Í±½½»® Ú·»´¼ îôéêðôëðêòéç îôéêðôðééòëîðòïèðð ìîçòîé ó îôéêðôëðêòéç îôéêðôëðêòéç ÙÑ ÍÎîðïï Í©·³³·²¹ Ð±±´ êôîðëôìëçòêè êôîðìôìçìòéïðòïèðð çêìòçé ó êôîðëôìëçòêè êôîðëôìëçòêè ÙÑ ÍÎîðïî Ü±©²¬±©² ×³°®±ª»³»²¬ ïôðððôèðçòéé ïôðððôêëìòïìðòïèðð ïëëòêí ó ïôðððôèðçòéé ïôðððôèðçòéé ÉñÍóÝ«¬±³»® Ü»°±·¬ îçìôëëëòïé îçìôëðçòíéðòïèðð ìëòèð ó îçìôëëëòïé îçìôëëëòïé ÉñÍóÛ¯«·°³»²¬ Î»°´ñÝ¿°ò×³° íéìôïççòîç íéìôïìïòïððòïèðð ëèòïç ó íéìôïççòîç íéìôïççòîç É¿¬»®úÍ»©»® îôðêçôððéòíð îôðêèôêèëòëêðòïèðð íîïòéì ó îôðêçôððéòíð îôðêçôððéòíð ÉñÍóÊ»¸·½´» Î»°´¿½»³»²¬ ëìëôêîéòíï ëìëôëìîòìêðòïèðð èìòèë ó ëìëôêîéòíï ëìëôêîéòíï É¿¬»®ñÍÍÔÙ ó ÍßÉÍ ëíçôîìîòêè ëíçôïëèòèíðòïèðð èíòèë ó ëíçôîìîòêè ëíçôîìîòêè ÌÑÌßÔ ÔÑÒÛÍÌßÎ îîôíðíôîççòçì îîôîççôèíïòéð íôìêèòîì ó îîôíðíôîççòçì îîôíðíôîççòçì ÓÞ×ß Ì¿¨ ×úÍ ïôèðîôèêéòìé íôððîôìïðòëíðòïèðð ìëêòçì ïôîððôðððòðð ïôèðîôèêéòìé ïôèðîôèêéòìé Ð±´·½» Ú±®º»·¬«®» ííèôíìëòìê ííèôîçîòêçðòïèðð ëîòéé ó ííèôíìëòìê ííèôíìëòìê Û½±²±³·½ Ü»ª»´±°³»²¬ Ý±®°±®¿¬·±² îôêéçôðèîòîç íôîéèôëéêòéèðòïèðð ëðëòëï êððôðððòðð îôêéçôðèîòîç îôêéçôðèîòîç Ø±¬»´ Ì¿¨ îîðôííêòéè îîðôíðîòííðòïèðð íìòìë ó îîðôííêòéè îîðôííêòéè Í°»½·¿´ Ûª»²¬ Ú«²¼ ìêôéîíòíé ìêôéïêòðêðòïèðð éòíï ó ìêôéîíòíé ìêôéîíòíé ÛÓÍ Ì¿¨ Ò±¬» îðïð íðïôêïêòîí íðïôëêçòîëðòïèðð ìêòçè ó íðïôêïêòîí íðïôêïêòîí ÌÑÌßÔ ÓÞ×ß ëôíèèôçéïòêð éôïèéôèêéòêì ïôïðíòçê ïôèððôðððòðð ëôíèèôçéïòêð ëôíèèôçéïòêð ÚÛÜÛÎßÌÛÜ ÍÎîððé¿ Þ±²¼óÝ·¬§ É·¼» Ð®±¶»½¬ èêçôêííòïç èêçôëêðòìçðòïððð éîòéð ó èêçôêííòïç èêçôêííòïç Ø±¬»´ Ñ½½«°¿²½§ Ì¿¨ éèôîçèòìé éèôîçïòçîðòïððð êòëë ó éèôîçèòìé éèôîçèòìé Ð¿®µ Ú«²¼ øÜ»ª»´±°»® Ú»»÷ ïêéôìèðòéï ïêéôìêêòéïðòïððð ïìòðð ó ïêéôìèðòéï ïêéôìèðòéï Ð¿®µ Ú«²¼ øÌ®»» Ó·¬·¹¿¬·±²÷ çéôïéêòéì çéôïêèòêîðòïððð èòïî ó çéôïéêòéì çéôïéêòéì Ì¿¨ ×úÍ ëêòçì ëêòçìðòïððð ó ó ëêòçì ëêòçì Ô·¾®¿®§ Þ±¿®¼ Ú«²¼ ììôééçòîî ììôééëòìèðòïððð íòéì ó ììôééçòîî ììôééçòîî ÌÑÌßÔ ÚÛÜÛÎßÌÛÜ ïôîëéôìîëòîé ïôîëéôíîðòïê ïðëòïï ó ïôîëéôìîëòîé ïôîëéôìîëòîé ×ÒÊÛÍÌÓÛÒÌ ÓßÒßÙÛÜ ßÝÝÑËÒÌ Ý¿°·¬¿´ Ñ²» Ù»²»®¿´ Ú«²¼ ïôîèîôèèîòèé ïôíëðôëìëòíðîòèèðð ïôìèëòíç îééòéì ïôíëïôéëîòçë ïôíìïôëëëòêì Ý¿°·¬¿´ Ñ²» Ý¿°·¬¿´ Î»½±ª»®§ Í»©»® ïôêíêôììêòêç ïôéêïôðïîòêíîòèëðð ïôêðëòîê íëêòîð ïôéêîôîêïòêç ïôéïèôééëòëê ÌÑÌßÔ ÝßÐ×ÌßÔ ÑÒÛ îôçïçôíîçòëê íôïïïôëëéòçí íôðçðòêë êííòçì íôïïìôðïìòêì íôðêðôííïòîð Ý·¬§ Ð±®¬º±´·± Þ§ ×²ª»¬³»²¬ Ì§°» ÌÑÌßÔ ÝßÐ×ÌßÔ ÑÒÛ ÌÑÌßÔ ÝòÜò êû ëû ÌÑÌßÔ ÑÐÛÎßÌ×ÑÒÍ ïíû ÌÑÌßÔ ÚÛÜÛÎßÌÛÜ íû ÌÑÌßÔ ÔÑÙ×Ý ÌÑÌßÔ ÓÞ×ß ïîû ÌÑÌßÔ ÔÑÒÛÍÌßÎ ìèû Ý·¬§ Ð±®¬º±´·± Þ§ Ë» Ü»·¹²¿¬»¼ Ú«²¼ô Í°»½·¿´ Î»ª»²«» üïôçíðôíìçòçç Ú«²¼ô üçôèðïôïçèòëí Ü»¾¬ Í»®ª·½» Ú«²¼ô üïôèðîôçîìòìï Ð®±¶»½¬ô üïèôïïèôìèïòëì ÓÑÒÌØÔÇ Ç×ÛÔÜÍ íòëð íòðð îòëð îòðð ïòëð ïòðð ðòëð ðòðð ÑÝÌóïîÒÑÊóïîÜÛÝóïîÖßÒóïíÚÛÞóïíÓßÎóïíßÐÎóïíÓßÇóïíÖËÒóïíÖËÔóïí ï Ó±²¬¸ ÌóÞ·´´ ðòðçðððòïïðððòðîðððòðìðð í Ó±²¬¸ ÌóÞ·´´ ðòïïðððòðèðððòðëðððòðéðð ê Ó±²¬¸ ÌóÞ·´´ ðòïêðððòïíðððòïïðððòïîðð Í½¸»®¬¦ Ð±®¬º±´·± ðòìíðððòíçëìðòìïîèðòíçðð Í½¸»®¬¦ Þ¿²µúÌ®«¬ ðòðëðððòðëðððòðëðððòðëðð ÝÜ íêë Ü¿§ ðòìððððòìððððòìððððòìððð ÝÜ ïèð Ü¿§ ðòíððððòíððððòíððððòíððð ÔÑÙ×Ý ðòïçéïðòïèðìðòïéèëðòïëëí Ô±²»Í¬¿® ðòîíðððòîïðððòîïðððòïèðð ÓÞ×ß ðòîïðððòïçðððòîïðððòïèðð Ú»¼»®¿¬»¼ ðòïëðððòïíðððòïîðððòïððð Ý¿°·¬¿´ Ñ²» îòèèððîòèéððîòèéððîòèêðð Ý × Ì Ç Ñ Ú Í Ý Ø Û Î Ì Æ ×²ª»¬³»²¬ Î»°±®¬ Ý¿°·¬¿´ Ñ²» ß»¬ Ü¿¬»æïñíïñîðïí Ù»²»®¿´ Ú«²¼ ß»¬ Ý¿¸ ú Û¯«·ª¿´»²¬Ü«»Ó¿¬«®·¬§Í¸¿®»Ý±¬Ó®µ Ê¿´«» Ú·¼»´·¬§ Ð®·³» Ó³µ¬ Ð±®¬ Ú¼ ýêçðîîôèèîòèéîîôèèîòèéîîôèèîòèé Ì±¬¿´ Ý¿¸ ú Û¯«·ª¿´»²¬îîôèèîòèéîîôèèîòèéîîôèèîòèé Ú·¨»¼ ×²½±³» Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼èñïíñîðïìëëçòððïîëôðððòððïìïôçèéòíðïíëôîîïòîë Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼êñîïñîðïíïìïòððèðôðððòððèîôððìòìðèðôëëðòìð Ú»¼»®¿´ Ú¿®³ Ý® Þµ Ý±² Í§¬»³©·¼» Þ¼ïîñïêñîðïëïðìçòððïððôðððòððïïêôïèëòððïïîôëðëòðð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Ü»¾ïïñïëñîðïíîèèòððïéðôðððòððïçïôðèìòîëïéêôìðéòíð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß² Ó»¼«·³ ¬»®³ Ò¬çñîìñîðïíîíêòððîëðôðððòððîëðôðððòððîëêôèîîòëð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Î»º»®»²½» Ò¬ïïñîëñîðïìêêíòððîððôðððòððîððôêðçòìðîðïôéíìòðð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß² éñîèñîðïëçðèòððïîëôðððòððïíîôèîèòêíïíïôîçëòðð ËÍ Ì®»¿«®§ Ò±¬»ïïñíðñîðïëïðííòððêðôðððòððêïôçíêòéîêïôêëçòêð ËÍ Ì®»¿«®§ Ò±¬»ëñíïñîðïêïîïêòððëðôðððòððëîôìéêòëêëîôðçèòðð ËÍ Ì®»¿«®§ Ò±¬»îñîèñîðïìíçíòððïððôðððòððççôéëéòèîïððôðèêòðð Ì±¬¿´ Ú·¨»¼ ×²½±³»ïôîêðôðððòððïôíîèôèéðòðèïôíðèôíéçòðë Ì±¬¿´ ß»¬ëëîòçëïôîèîôèèîòèéïôíëïôéëîòçëïôííïôîêïòçî Ý¿° Î»½±ª»®§ Ú«²¼ ß»¬ Ý¿¸ ú Û¯«·ª¿´»²¬Ü«»Ó¿¬«®·¬§Í¸¿®»Ý±¬Ó®µ Ê¿´«» Ú·¼»´·¬§ Ð®·³» Ó³µ¬ Ð±®¬ Ú¼ ýêçðìêôììêòêçìêôììêòêçìêôììêòêç Ì±¬¿´ Ý¿¸ ú Û¯«·ª¿´»²¬ìêôììêòêçìêôììêòêçìêôììêòêç Ú·¨»¼ ×²½±³» Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼èñïíñîðïìëëçòððïêëôðððòððïèéôìîíòîìïéèôìçîòðë Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼êñîïñîðïíïìïòððïððôðððòððïðîôëðëòëðïððôêèèòðð Ú»¼»®¿´ Ú¿®³ Ý® Þµ Ý±² Í§¬»³©·¼» Þ¼ïîñïêñîðïëïðìçòððîððôðððòððîíðôééçòððîîëôðïðòðð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Ü»¾ïïñïëñîðïíîèèòððîëðôðððòððîèïôððêòîëîëçôìîîòëð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß² Ò¬ïðñïëñîðïíîëéòððîððôðððòððîîíôððïòêðîðêôíïêòðð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Î»º»®»²½» Ò¬ïïñîëñîðïìêêíòððîîðôðððòððîîðôðéèòêèîîïôçðéòìð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß²éñîèñîðïëçðèòððïíëôðððòððïìíôìëìòçïïìïôéçèòêð ËÍ Ì®»¿«®§ Ò±¬»ïïñíðñîðïëïðííòððëðôðððòððëïôêðçòëéëïôíèíòðð ËÍ Ì®»¿«®§ Ò±¬»ëñíïñîðïêïîïêòððïîëôðððòððïíïôïçïòìïïíðôîìëòðð ËÍ Ì®»¿«®§ Ò±¬»îñîèñîðïìíçíòððïìëôðððòððïììôéêìòèìïìëôïîìòéð Ì±¬¿´ Ú·¨»¼ ×²½±³»ïôëçðôðððòððïôéïëôèïëòððïôêêðôíèéòîë Ì±¬¿´ ß»¬ëçíòîëïôêíêôììêòêçïôéêîôîêïòêçïôéðêôèííòçì