Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
March Financials
Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 3/31/2013 ASSETS ASSETS CASH IN BANK (71,968)$ * INVESTMENTS 1,148,648 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 33,189 ACCOUNTS RECEIVABLE - PID EMER SERVICES 5,507 OTHER RECEIVABLES 24,656 TOTAL ASSETS 1,140,032$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 38,697$ ACCOUNTS PAYABLE 146,273 TOTAL LIABILITIES 184,970$ FUND BALANCE UNASSIGNED FUND BALANCE 955,062 TOTAL LIABILITIES AND FUND BALANCE 1,140,032$ * Texpool Transfer to cover March Accounts Payable and Payroll not completed until April. March 31, 2013 6/12 Months (50% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 1 14:59 04/11/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40001-000-000 Assessment - Emerg Svcs 252,084.00- 252,084.00- 927.58- 249,497.19- 98.974 2,586.81- 122-40003-000-000 Emer Svcs Assessmen/Delinquent 4,700.00- 4,700.00- 5.36- .114 4,694.64- 122-40010-000-000 Property Taxes/MUD Fire 1,050,349.00- 1,050,349.00- 8,840.52- 1,040,350.82- 99.048 9,998.18- 122-40011-000-000 Property Taxes/Fire-Delinquent 5,800.00- 5,800.00- 193.32- 3,868.94- 66.706 1,931.06- 122-40015-000-000 Property Taxes/Assessments P&I 750.00- 750.00- 11.76- 192.40- 25.653 557.60- 122-40020-000-000 Property Taxes/Fire P&I 4,500.00- 4,500.00- 629.28- 2,732.13- 60.714 1,767.87- Subtotal: 1,318,183.00- 1,318,183.00- 10,602.46- 1,296,646.84- 98.366 21,536.16- 122-42014-000-000 Fire Plan Review>6,000 sq ft 6,000.00- 6,000.00- 1,200.00- 3,600.00- 60.000 2,400.00- Subtotal: 6,000.00- 6,000.00- 1,200.00- 3,600.00- 60.000 2,400.00- 122-43400-000-000 Fire Inspections 500.00- 500.00- 225.00- 675.00- 135.000 175.00 122-43415-000-000 Denton County Pledge-Fire 10,000.00- 10,000.00- 10,000.00- 100.000 Subtotal: 10,500.00- 10,500.00- 225.00- 10,675.00- 101.667 175.00 122-49900-000-000 Miscellaneous Income 1,200.00- 1,200.00- 1,675.00- 5,239.26- 436.605 4,039.26 Subtotal: 1,200.00- 1,200.00- 1,675.00- 5,239.26- 436.605 4,039.26 Program number: 1,335,883.00- 1,335,883.00- 13,702.46- 1,316,161.10- 98.524 19,721.90- Department number: Fire Revenues 1,335,883.00- 1,335,883.00- 13,702.46- 1,316,161.10- 98.524 19,721.90- Revenues Subtotal ----------- 1,335,883.00- 1,335,883.00- 13,702.46- 1,316,161.10- 98.524 19,721.90- . glbase_tbam rgonzale Trophy Club MUD #1 Page 2 14:59 04/11/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-50005-045-000 Salaries & Wages 444,717.00 444,717.00 49,868.59 210,272.23 47.282 234,444.77 122-50010-045-000 Overtime 31,375.00 31,375.00 2,167.86 18,538.04 59.085 12,836.96 122-50011-045-000 DPS Holiday Pay 13,083.00 13,083.00 12,080.51 92.337 1,002.49 122-50016-045-000 Longevity 4,266.00 4,266.00 4,266.11 100.003 .11- 122-50017-045-000 Certification 4,896.00 4,896.00 625.00 3,012.25 61.525 1,883.75 122-50020-045-000 Retirement 69,242.00 69,242.00 7,288.41 35,419.54 51.153 33,822.46 122-50026-045-000 Medical Insurance 48,327.00 48,327.00 3,551.20 20,662.95 42.757 27,664.05 122-50027-045-000 Dental Insurance 3,635.00 3,635.00 327.33 1,917.86 52.761 1,717.14 122-50028-045-000 Vision Insurance 824.00 824.00 67.51 394.86 47.920 429.14 122-50029-045-000 Life Insurance & Other 4,250.00 4,250.00 605.45 2,986.70 70.275 1,263.30 122-50030-045-000 Social Security Taxes 30,897.00 30,897.00 3,074.23 14,971.23 48.455 15,925.77 122-50035-045-000 Medicare Taxes 7,226.00 7,226.00 718.98 3,501.32 48.454 3,724.68 122-50040-045-000 Unemployment Taxes 1,481.00 1,481.00 76.28 1,980.06 133.698 499.06- 122-50045-045-000 Workman's Compensation 10,000.00 10,000.00 10,000.00 100.000 122-50060-045-000 Pre-employment Physicals/Test 675.00 675.00 283.05 41.933 391.95 122-50075-045-000 Tuition Reimbursement 1,500.00 1,500.00 1,500.00 Subtotal: 676,394.00 676,394.00 68,370.84 340,286.71 50.309 336,107.29 122-55045-045-000 Legal 1,296.80 2,007.40 2,007.40- 122-55080-045-000 Maintenance & Repairs 9,562.00 9,562.00 859.53 4,516.50 47.234 5,045.50 122-55090-045-000 Vehicle Maintenance 14,850.00 14,850.00 2,154.05 14.505 12,695.95 122-55095-045-000 Equipment Maintenance 9,808.00 9,808.00 466.60 6,518.15 66.457 3,289.85 122-55100-045-000 Building Maintenance 6,500.00 6,500.00 384.51- 1,586.16 24.402 4,913.84 122-55110-045-000 Maintenance-Radios 1,103.00 1,103.00 405.50 36.763 697.50 122-55160-045-000 Professional Outside Services 2,500.00 2,500.00 2,500.00 Subtotal: 44,323.00 44,323.00 2,238.42 17,187.76 38.778 27,135.24 122-60005-045-000 Telephone 106.00 106.00 3.59 30.61 28.877 75.39 122-60010-045-000 Communications/Pagers/Mobiles 2,500.00 2,500.00 217.07 2,335.59 93.424 164.41 122-60020-045-000 Electricity/Gas 6,167.00 6,167.00 486.93 3,276.26 53.126 2,890.74 122-60025-045-000 Water 1,400.00 1,400.00 142.04 623.95 44.568 776.05 122-60030-045-000 Rent And/Or Usage 308,000.00 308,000.00 308,000.00 100.000 122-60035-045-000 Postage 100.00 100.00 13.40- 41.20 41.200 58.80 122-60055-045-000 Insurance 10,000.00 10,000.00 10,000.00 100.000 122-60066-045-000 Publications/Books/Subscrips 410.00 410.00 410.00 122-60070-045-000 Dues & Memberships 7,500.00 7,500.00 170.00 7,955.91 106.079 455.91- 122-60075-045-000 Meetings 75.00 75.00 75.00 122-60080-045-000 Schools & Training 5,000.00 5,000.00 1,644.00 32.880 3,356.00 122-60096-045-000 Emergency Management 1,000.00 1,000.00 1,000.00 100.000 122-60100-045-000 Travel & per diem 4,800.00 4,800.00 576.68 1,738.58 36.220 3,061.42 122-60110-045-000 Physicals/Testing 2,000.00 2,000.00 2,000.00 122-60125-045-000 Advertising 150.00 150.00 122.35 81.567 27.65 . glbase_tbam rgonzale Trophy Club MUD #1 Page 3 14:59 04/11/13 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-60160-045-000 Programs & Special Projects 4,200.00 4,200.00 2,198.94 52.356 2,001.06 122-60180-045-000 Fire Inspection/Enforcement 1,900.00 1,900.00 738.97 38.893 1,161.03 122-60195-045-000 Flags & Repair 2,543.00 2,543.00 659.75 25.944 1,883.25 122-60243-045-000 Prior Year Expense 2,088.44 2,088.44 2,088.44- 122-60245-045-000 Miscellaneous Expense 1,237.00 1,237.00 489.63 39.582 747.37 Subtotal: 359,088.00 359,088.00 3,671.35 342,944.18 95.504 16,143.82 122-65005-045-000 Fuel & Lube 10,000.00 10,000.00 3,816.63 38.166 6,183.37 122-65010-045-000 Uniforms 4,357.00 4,357.00 915.32 21.008 3,441.68 122-65015-045-000 Protective Clothing 7,600.00 7,600.00 670.00 8.816 6,930.00 122-65030-045-000 Chemicals 1,000.00 1,000.00 402.00 40.200 598.00 122-65035-045-000 Small Tools 5,000.00 5,000.00 466.01 1,242.92 24.858 3,757.08 122-65085-045-000 Office Supplies 1,200.00 1,200.00 103.40 8.617 1,096.60 122-65095-045-000 Maintenance Supplies 2,785.00 2,785.00 705.81 25.343 2,079.19 122-65105-045-000 Printing 106.00 106.00 106.00 Subtotal: 32,048.00 32,048.00 466.01 7,856.08 24.513 24,191.92 122-69006-045-000 Grant Match 3,000.00 3,000.00 3,000.00 122-69008-045-000 Short Term Debt-Principal 72,932.00 72,932.00 2,966.05 4.067 69,965.95 122-69050-045-000 Radios 2,500.00 2,500.00 353.13 14.125 2,146.87 122-69195-045-000 GASB34/Reserve for Replacement 145,598.00 145,598.00 145,598.00 Subtotal: 224,030.00 224,030.00 3,319.18 1.482 220,710.82 Program number: 1,335,883.00 1,335,883.00 74,746.62 711,593.91 53.268 624,289.09 Department number: Fire 1,335,883.00 1,335,883.00 74,746.62 711,593.91 53.268 624,289.09 Expenditures Subtotal ----------- 1,335,883.00 1,335,883.00 74,746.62 711,593.91 53.268 624,289.09 Fund number: 122 Trophy Club MUD Fire Dept. 61,044.16 604,567.19- 604,567.19 . glpdatb2 rgonzale Trophy Club MUD #1 Page 1 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40001-000-000 Assessment - Emerg Svcs 1202 03/05/2013 Property Taxes/Assessments (248,569.61) (97.11) (248,666.72) GL 1204 03/06/2013 Property Taxes/Assessments (416.15) (249,082.87) GL 1210 03/12/2013 Property Taxes/Assessments (86.87) (249,169.74) GL 1214 03/15/2013 Property Taxes/Assessments (109.76) (249,279.50) GL 1215 03/18/2013 Property Taxes/Assessments (67.72) (249,347.22) GL 1218 03/21/2013 Property Taxes/Assessments (108.64) (249,455.86) GL 1223 03/28/2013 Property Taxes/Assessments (41.33) (249,497.19) GL _______________ Account: 122-40001-000-000 Assessment - Emerg Svcs Totals: (927.58) (249,497.19) ** (252,084.00) Budgeted (2,586.81) Remaining 99 % Used Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent (5.36) .00 (5.36) _______________ Account: 122-40003-000-000 Emer Svcs Assessmen/Delinquent Totals: .00 (5.36) ** (4,700.00) Budgeted (4,694.64) Remaining 0 % Used Account: 122-40010-000-000 Property Taxes/MUD Fire 1198 03/01/2013 Property Taxes/Assessments (1,031,510.30) (175.03) (1,031,685.33) GL 1200 03/04/2013 Property Taxes/Assessments (550.69) (1,032,236.02) GL 1201 03/05/2013 Property Taxes/Assessments (2,427.02) (1,034,663.04) GL 1203 03/06/2013 Property Taxes/Assessments (97.62) (1,034,760.66) GL 1205 03/07/2013 Property Taxes/Assessments (35.49) (1,034,796.15) GL 1207 03/08/2013 Property Taxes/Assessments (161.68) (1,034,957.83) GL 1208 03/11/2013 Property Taxes/Assessments (867.15) (1,035,824.98) GL 1209 03/12/2013 Property Taxes/Assessments (926.90) (1,036,751.88) GL 1211 03/13/2013 Property Taxes/Assessments (610.25) (1,037,362.13) GL 1212 03/14/2013 Property Taxes/Assessments (8.25) (1,037,370.38) GL 1213 03/15/2013 Property Taxes/Assessments (892.84) (1,038,263.22) GL 1216 03/19/2013 Property Taxes/Assessments (193.92) (1,038,457.14) GL 1217 03/21/2013 Property Taxes/Assessments (153.15) (1,038,610.29) GL 1219 03/22/2013 Property Taxes/Assessments (207.21) (1,038,817.50) GL 1220 03/25/2013 Property Taxes/Assessments (218.91) (1,039,036.41) GL 1220 03/25/2013 Property Taxes/Assessments (454.35) (1,039,490.76) GL 1221 03/27/2013 Property Taxes/Assessments (441.99) (1,039,932.75) GL 1222 03/28/2013 Property Taxes/Assessments (418.07) (1,040,350.82) GL _______________ Account: 122-40010-000-000 Property Taxes/MUD Fire Totals: (8,840.52) (1,040,350.82) ** (1,050,349.00) Budgeted (9,998.18) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 2 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-40011-000-000 Property Taxes/Fire-Delinquent 1198 03/01/2013 Property Taxes/Assessments (3,675.62) (106.99) (3,782.61) GL 1213 03/15/2013 Property Taxes/Assessments (159.16) (3,941.77) GL 1220 03/25/2013 Property Taxes/Assessments 4.66 (3,937.11) GL 1221 03/27/2013 Property Taxes/Assessments 72.83 (3,864.28) GL 1222 03/28/2013 Property Taxes/Assessments (4.66) (3,868.94) GL _______________ Account: 122-40011-000-000 Property Taxes/Fire-Delinquent Totals: (193.32) (3,868.94) ** (5,800.00) Budgeted (1,931.06) Remaining 67 % Used Account: 122-40015-000-000 Property Taxes/Assessments P&I 1214 03/15/2013 Property Taxes/Assessments (180.64) (1.98) (182.62) GL 1218 03/21/2013 Property Taxes/Assessments (9.78) (192.40) GL _______________ Account: 122-40015-000-000 Property Taxes/Assessments P&I Totals: (11.76) (192.40) ** (750.00) Budgeted (557.60) Remaining 26 % Used Account: 122-40020-000-000 Property Taxes/Fire P&I 1198 03/01/2013 Property Taxes/Assessments (2,102.85) (28.89) (2,131.74) GL 1200 03/04/2013 Property Taxes/Assessments (17.80) (2,149.54) GL 1201 03/05/2013 Property Taxes/Assessments (181.12) (2,330.66) GL 1203 03/06/2013 Property Taxes/Assessments (6.83) (2,337.49) GL 1205 03/07/2013 Property Taxes/Assessments (2.49) (2,339.98) GL 1207 03/08/2013 Property Taxes/Assessments (14.56) (2,354.54) GL 1208 03/11/2013 Property Taxes/Assessments (48.30) (2,402.84) GL 1209 03/12/2013 Property Taxes/Assessments (77.74) (2,480.58) GL 1211 03/13/2013 Property Taxes/Assessments (21.60) (2,502.18) GL 1212 03/14/2013 Property Taxes/Assessments (.83) (2,503.01) GL 1213 03/15/2013 Property Taxes/Assessments (117.24) (2,620.25) GL 1217 03/21/2013 Property Taxes/Assessments (.89) (2,621.14) GL 1220 03/25/2013 Property Taxes/Assessments (11.78) (2,632.92) GL 1220 03/25/2013 Property Taxes/Assessments (34.90) (2,667.82) GL 1221 03/27/2013 Property Taxes/Assessments (22.05) (2,689.87) GL 1222 03/28/2013 Property Taxes/Assessments (42.26) (2,732.13) GL _______________ Account: 122-40020-000-000 Property Taxes/Fire P&I Totals: (629.28) (2,732.13) ** (4,500.00) Budgeted (1,767.87) Remaining 61 % Used Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft 1184 03/31/2013 Town Invoice 1015 billed AR 20130330-20130331 User: (2,400.00) (1,200.00) (3,600.00) AR . glpdatb2 rgonzale Trophy Club MUD #1 Page 3 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-42014-000-000 Fire Plan Review>6,000 sq ft Totals: (1,200.00) (3,600.00) ** (6,000.00) Budgeted (2,400.00) Remaining 60 % Used Account: 122-43400-000-000 Fire Inspections 1184 03/31/2013 Town Invoice 1015 billed AR 20130330-20130331 User: (450.00) (225.00) (675.00) AR _______________ Account: 122-43400-000-000 Fire Inspections Totals: (225.00) (675.00) ** (500.00) Budgeted 175.00 Remaining 135 % Used Account: 122-43415-000-000 Denton County Pledge-Fire (10,000.00) .00 (10,000.00) _______________ Account: 122-43415-000-000 Denton County Pledge-Fire Totals: .00 (10,000.00) ** (10,000.00) Budgeted .00 Remaining 100 % Used Account: 122-49900-000-000 Miscellaneous Income 1184 03/31/2013 Town Invoice 1015 billed AR 20130330-20130331 User: (3,564.26) (1,675.00) (5,239.26) AR _______________ Account: 122-49900-000-000 Miscellaneous Income Totals: (1,675.00) (5,239.26) ** (1,200.00) Budgeted 4,039.26 Remaining 437 % Used Department Totals: ------------------------------------------------------------------------------------------------ (1,316,161.10) ** (1,335,883.00) Budgeted (19,721.90) Remaining 99 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 4 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50005-045-000 Salaries & Wages 1047 03/01/2013 FD Payroll 3/1/13 160,403.64 16,560.83 176,964.47 GL 1123 03/15/2013 FD Payroll 3/15/13 16,675.80 193,640.27 GL 1169 03/28/2013 FD Payroll 3/28/13 16,631.96 210,272.23 GL _______________ Account: 122-50005-045-000 Salaries & Wages Totals: 49,868.59 210,272.23 ** 444,717.00 Budgeted 234,444.77 Remaining 47 % Used Account: 122-50010-045-000 Overtime 1123 03/15/2013 FD Payroll 3/15/13 16,370.18 2,167.86 18,538.04 GL _______________ Account: 122-50010-045-000 Overtime Totals: 2,167.86 18,538.04 ** 31,375.00 Budgeted 12,836.96 Remaining 59 % Used Account: 122-50011-045-000 DPS Holiday Pay 12,080.51 .00 12,080.51 _______________ Account: 122-50011-045-000 DPS Holiday Pay Totals: .00 12,080.51 ** 13,083.00 Budgeted 1,002.49 Remaining 92 % Used Account: 122-50016-045-000 Longevity 4,266.11 .00 4,266.11 _______________ Account: 122-50016-045-000 Longevity Totals: .00 4,266.11 ** 4,266.00 Budgeted (.11) Remaining 100 % Used Account: 122-50017-045-000 Certification 1047 03/01/2013 FD Payroll 3/1/13 2,387.25 625.00 3,012.25 GL _______________ Account: 122-50017-045-000 Certification Totals: 625.00 3,012.25 ** 4,896.00 Budgeted 1,883.75 Remaining 62 % Used Account: 122-50020-045-000 Retirement 1047 03/01/2013 FD Payroll 3/1/13 28,131.13 2,345.49 30,476.62 GL 1123 03/15/2013 FD Payroll 3/15/13 2,649.42 33,126.04 GL 1169 03/28/2013 FD Payroll 3/28/13 2,293.50 35,419.54 GL _______________ Account: 122-50020-045-000 Retirement Totals: 7,288.41 35,419.54 ** 69,242.00 Budgeted 33,822.46 Remaining 51 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 5 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-50026-045-000 Medical Insurance 1047 03/01/2013 FD Payroll 3/1/13 17,111.75 1,775.59 18,887.34 GL 1123 03/15/2013 FD Payroll 3/15/13 1,775.61 20,662.95 GL _______________ Account: 122-50026-045-000 Medical Insurance Totals: 3,551.20 20,662.95 ** 48,327.00 Budgeted 27,664.05 Remaining 43 % Used Account: 122-50027-045-000 Dental Insurance 1047 03/01/2013 FD Payroll 3/1/13 1,590.53 163.64 1,754.17 GL 1123 03/15/2013 FD Payroll 3/15/13 163.69 1,917.86 GL _______________ Account: 122-50027-045-000 Dental Insurance Totals: 327.33 1,917.86 ** 3,635.00 Budgeted 1,717.14 Remaining 53 % Used Account: 122-50028-045-000 Vision Insurance 1047 03/01/2013 FD Payroll 3/1/13 327.35 33.77 361.12 GL 1123 03/15/2013 FD Payroll 3/15/13 33.74 394.86 GL _______________ Account: 122-50028-045-000 Vision Insurance Totals: 67.51 394.86 ** 824.00 Budgeted 429.14 Remaining 48 % Used Account: 122-50029-045-000 Life Insurance & Other 1047 03/01/2013 FD Payroll 3/1/13 2,381.25 302.73 2,683.98 GL 1123 03/15/2013 FD Payroll 3/15/13 302.72 2,986.70 GL _______________ Account: 122-50029-045-000 Life Insurance & Other Totals: 605.45 2,986.70 ** 4,250.00 Budgeted 1,263.30 Remaining 70 % Used Account: 122-50030-045-000 Social Security Taxes 1047 03/01/2013 FD Payroll 3/1/13 11,897.00 970.13 12,867.13 GL 1123 03/15/2013 FD Payroll 3/15/13 1,072.91 13,940.04 GL 1169 03/28/2013 FD Payroll 3/28/13 1,031.19 14,971.23 GL _______________ Account: 122-50030-045-000 Social Security Taxes Totals: 3,074.23 14,971.23 ** 30,897.00 Budgeted 15,925.77 Remaining 48 % Used Account: 122-50035-045-000 Medicare Taxes 1047 03/01/2013 FD Payroll 3/1/13 2,782.34 226.88 3,009.22 GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 6 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1123 03/15/2013 FD Payroll 3/15/13 2,782.34 250.93 3,260.15 GL 1169 03/28/2013 FD Payroll 3/28/13 241.17 3,501.32 GL _______________ Account: 122-50035-045-000 Medicare Taxes Totals: 718.98 3,501.32 ** 7,226.00 Budgeted 3,724.68 Remaining 48 % Used Account: 122-50040-045-000 Unemployment Taxes 1047 03/01/2013 FD Payroll 3/1/13 1,903.78 75.95 1,979.73 GL 1123 03/15/2013 FD Payroll 3/15/13 .01 1,979.74 GL 1169 03/28/2013 FD Payroll 3/28/13 .32 1,980.06 GL _______________ Account: 122-50040-045-000 Unemployment Taxes Totals: 76.28 1,980.06 ** 1,481.00 Budgeted (499.06) Remaining 134 % Used Account: 122-50045-045-000 Workman's Compensation 10,000.00 .00 10,000.00 _______________ Account: 122-50045-045-000 Workman's Compensation Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-50060-045-000 Pre-employment Physicals/Test 283.05 .00 283.05 _______________ Account: 122-50060-045-000 Pre-employment Physicals/Test Totals: .00 283.05 ** 675.00 Budgeted 391.95 Remaining 42 % Used Account: 122-50075-045-000 Tuition Reimbursement .00 .00 _______________ Account: 122-50075-045-000 Tuition Reimbursement Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 122-55045-045-000 Legal 1113 03/21/2013 March A/P Legal/Prime Construction 710.60 1,296.80 2,007.40 WHITAKER CHALK SWINDLE 32385 AP _______________ Account: 122-55045-045-000 Legal Totals: 1,296.80 2,007.40 ** .00 Budgeted (2,007.40) Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 7 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-55080-045-000 Maintenance & Repairs 1113 03/21/2013 March A/P Rug Service 3,656.97 24.51 3,681.48 G & K SERVICES 32365 AP 1113 03/21/2013 March A/P Rug Service 24.51 3,705.99 G & K SERVICES 32365 AP 1113 03/21/2013 March A/P Generator Maintenance/Semi ann 810.51 4,516.50 ENTECH SALES AND SERVICE INC 32362 AP _______________ Account: 122-55080-045-000 Maintenance & Repairs Totals: 859.53 4,516.50 ** 9,562.00 Budgeted 5,045.50 Remaining 47 % Used Account: 122-55090-045-000 Vehicle Maintenance 2,154.05 .00 2,154.05 _______________ Account: 122-55090-045-000 Vehicle Maintenance Totals: .00 2,154.05 ** 14,850.00 Budgeted 12,695.95 Remaining 15 % Used Account: 122-55095-045-000 Equipment Maintenance 1113 03/21/2013 March A/P Radio Repair, antenna replacem 6,051.55 466.60 6,518.15 AMERICAN COMMUNICATIONS 32352 AP _______________ Account: 122-55095-045-000 Equipment Maintenance Totals: 466.60 6,518.15 ** 9,808.00 Budgeted 3,289.85 Remaining 66 % Used Account: 122-55100-045-000 Building Maintenance 974 03/01/2013 Firefighter cable/Feb, Mar 1,970.67 (240.00) 1,730.67 GL 1192 03/26/2013 April Firefighter Cable (120.00) 1,610.67 GL 1161 03/31/2013 Town Billing Inv 1013, 1014 AR 20130330-20130331 User: (24.51) 1,586.16 AR _______________ Account: 122-55100-045-000 Building Maintenance Totals: (384.51) 1,586.16 ** 6,500.00 Budgeted 4,913.84 Remaining 24 % Used Account: 122-55110-045-000 Maintenance-Radios 405.50 .00 405.50 _______________ Account: 122-55110-045-000 Maintenance-Radios Totals: .00 405.50 ** 1,103.00 Budgeted 697.50 Remaining 37 % Used Account: 122-55160-045-000 Professional Outside Services .00 .00 _______________ Account: 122-55160-045-000 Professional Outside Services Totals: .00 .00 ** 2,500.00 Budgeted 2,500.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 8 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-60005-045-000 Telephone 1113 03/21/2013 March A/P Feb PCards/Zieverink 27.02 3.59 30.61 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (3.59) 27.02 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 3.59 30.61 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 122-60005-045-000 Telephone Totals: 3.59 30.61 ** 106.00 Budgeted 75.39 Remaining 29 % Used Account: 122-60010-045-000 Communications/Pagers/Mobiles 1047 03/01/2013 FD Payroll 3/1/13 2,118.52 76.50 2,195.02 GL 1113 03/21/2013 March A/P Verizon Invoice 140.57 2,335.59 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Verizon Invoice (140.57) 2,195.02 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Verizon Invoice 140.57 2,335.59 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 122-60010-045-000 Communications/Pagers/Mobiles Totals: 217.07 2,335.59 ** 2,500.00 Budgeted 164.41 Remaining 93 % Used Account: 122-60020-045-000 Electricity/Gas 1113 03/21/2013 March A/P Elec 2/13-3/14 2,789.33 787.14 3,576.47 HUDSON ENERGY SERVICES, LLC 32367 AP 1137 03/26/2013 March A/P 2/18-3/18 gas at fire station 186.72 3,763.19 ATMOS ENERGY 32395 AP 1161 03/31/2013 Town Billing Inv 1013, 1014 AR 20130330-20130331 User: (486.93) 3,276.26 AR _______________ Account: 122-60020-045-000 Electricity/Gas Totals: 486.93 3,276.26 ** 6,167.00 Budgeted 2,890.74 Remaining 53 % Used Account: 122-60025-045-000 Water 1113 03/21/2013 March A/P Feb Water 481.91 142.04 623.95 TROPHY CLUB MUD (WATER BILLS) 32382 AP _______________ Account: 122-60025-045-000 Water Totals: 142.04 623.95 ** 1,400.00 Budgeted 776.05 Remaining 45 % Used Account: 122-60030-045-000 Rent And/Or Usage 308,000.00 .00 308,000.00 _______________ Account: 122-60030-045-000 Rent And/Or Usage Totals: .00 308,000.00 ** 308,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60035-045-000 Postage . glpdatb2 rgonzale Trophy Club MUD #1 Page 9 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1139 03/28/2013 Rev JE289/Nov postage used 54.60 (27.25) 27.35 GL 1146 03/28/2013 Oct Postage meter usage Fire postage used 13.85 41.20 GL _______________ Account: 122-60035-045-000 Postage Totals: (13.40) 41.20 ** 100.00 Budgeted 58.80 Remaining 41 % Used Account: 122-60055-045-000 Insurance 10,000.00 .00 10,000.00 _______________ Account: 122-60055-045-000 Insurance Totals: .00 10,000.00 ** 10,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60066-045-000 Publications/Books/Subscrips .00 .00 _______________ Account: 122-60066-045-000 Publications/Books/Subscrips Totals: .00 .00 ** 410.00 Budgeted 410.00 Remaining 0 % Used Account: 122-60070-045-000 Dues & Memberships 1113 03/21/2013 March A/P Training Facility fees 7,785.91 170.00 7,955.91 TX COMM ON FIRE PROTECTION 32384 AP _______________ Account: 122-60070-045-000 Dues & Memberships Totals: 170.00 7,955.91 ** 7,500.00 Budgeted (455.91) Remaining 106 % Used Account: 122-60075-045-000 Meetings .00 .00 _______________ Account: 122-60075-045-000 Meetings Totals: .00 .00 ** 75.00 Budgeted 75.00 Remaining 0 % Used Account: 122-60080-045-000 Schools & Training 1,644.00 .00 1,644.00 _______________ Account: 122-60080-045-000 Schools & Training Totals: .00 1,644.00 ** 5,000.00 Budgeted 3,356.00 Remaining 33 % Used Account: 122-60096-045-000 Emergency Management . glpdatb2 rgonzale Trophy Club MUD #1 Page 10 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1,000.00 .00 1,000.00 _______________ Account: 122-60096-045-000 Emergency Management Totals: .00 1,000.00 ** 1,000.00 Budgeted .00 Remaining 100 % Used Account: 122-60100-045-000 Travel & per diem 1120 03/22/2013 March A/P PCard reimb 1,161.90 576.68 1,738.58 TOWN OF TROPHY CLUB 32392 AP _______________ Account: 122-60100-045-000 Travel & per diem Totals: 576.68 1,738.58 ** 4,800.00 Budgeted 3,061.42 Remaining 36 % Used Account: 122-60110-045-000 Physicals/Testing .00 .00 _______________ Account: 122-60110-045-000 Physicals/Testing Totals: .00 .00 ** 2,000.00 Budgeted 2,000.00 Remaining 0 % Used Account: 122-60125-045-000 Advertising 122.35 .00 122.35 _______________ Account: 122-60125-045-000 Advertising Totals: .00 122.35 ** 150.00 Budgeted 27.65 Remaining 82 % Used Account: 122-60160-045-000 Programs & Special Projects 2,198.94 .00 2,198.94 _______________ Account: 122-60160-045-000 Programs & Special Projects Totals: .00 2,198.94 ** 4,200.00 Budgeted 2,001.06 Remaining 52 % Used Account: 122-60180-045-000 Fire Inspection/Enforcement 738.97 .00 738.97 _______________ Account: 122-60180-045-000 Fire Inspection/Enforcement Totals: .00 738.97 ** 1,900.00 Budgeted 1,161.03 Remaining 39 % Used Account: 122-60195-045-000 Flags & Repair 659.75 .00 659.75 . glpdatb2 rgonzale Trophy Club MUD #1 Page 11 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-60195-045-000 Flags & Repair Totals: .00 659.75 ** 2,543.00 Budgeted 1,883.25 Remaining 26 % Used Account: 122-60243-045-000 Prior Year Expense 1187 03/31/2013 P/Y TWC due Town 1,476.05 1,476.05 GL 1188 03/31/2013 PY 7/20 P/R Cert Pay supplemen 612.39 2,088.44 GL _______________ Account: 122-60243-045-000 Prior Year Expense Totals: 2,088.44 2,088.44 ** .00 Budgeted (2,088.44) Remaining 0 % Used Account: 122-60245-045-000 Miscellaneous Expense 489.63 .00 489.63 _______________ Account: 122-60245-045-000 Miscellaneous Expense Totals: .00 489.63 ** 1,237.00 Budgeted 747.37 Remaining 40 % Used Account: 122-65005-045-000 Fuel & Lube 3,816.63 .00 3,816.63 _______________ Account: 122-65005-045-000 Fuel & Lube Totals: .00 3,816.63 ** 10,000.00 Budgeted 6,183.37 Remaining 38 % Used Account: 122-65010-045-000 Uniforms 915.32 .00 915.32 _______________ Account: 122-65010-045-000 Uniforms Totals: .00 915.32 ** 4,357.00 Budgeted 3,441.68 Remaining 21 % Used Account: 122-65015-045-000 Protective Clothing 670.00 .00 670.00 _______________ Account: 122-65015-045-000 Protective Clothing Totals: .00 670.00 ** 7,600.00 Budgeted 6,930.00 Remaining 9 % Used Account: 122-65030-045-000 Chemicals 402.00 .00 402.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 12 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 122-65030-045-000 Chemicals Totals: .00 402.00 ** 1,000.00 Budgeted 598.00 Remaining 40 % Used Account: 122-65035-045-000 Small Tools 1113 03/21/2013 March A/P Feb PCards/Zieverink 776.91 29.99 806.90 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Feb PCards/Zieverink 436.02 1,242.92 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (29.99) 1,212.93 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (436.02) 776.91 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 29.99 806.90 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 436.02 1,242.92 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 122-65035-045-000 Small Tools Totals: 466.01 1,242.92 ** 5,000.00 Budgeted 3,757.08 Remaining 25 % Used Account: 122-65085-045-000 Office Supplies 103.40 .00 103.40 _______________ Account: 122-65085-045-000 Office Supplies Totals: .00 103.40 ** 1,200.00 Budgeted 1,096.60 Remaining 9 % Used Account: 122-65095-045-000 Maintenance Supplies 705.81 .00 705.81 _______________ Account: 122-65095-045-000 Maintenance Supplies Totals: .00 705.81 ** 2,785.00 Budgeted 2,079.19 Remaining 25 % Used Account: 122-65105-045-000 Printing .00 .00 _______________ Account: 122-65105-045-000 Printing Totals: .00 .00 ** 106.00 Budgeted 106.00 Remaining 0 % Used Account: 122-69006-045-000 Grant Match .00 .00 _______________ Account: 122-69006-045-000 Grant Match Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 13 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 122 Trophy Club MUD Fire Dept. Department: 45 Fire Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 122-69008-045-000 Short Term Debt-Principal 2,966.05 .00 2,966.05 _______________ Account: 122-69008-045-000 Short Term Debt-Principal Totals: .00 2,966.05 ** 72,932.00 Budgeted 69,965.95 Remaining 4 % Used Account: 122-69050-045-000 Radios 353.13 .00 353.13 _______________ Account: 122-69050-045-000 Radios Totals: .00 353.13 ** 2,500.00 Budgeted 2,146.87 Remaining 14 % Used Account: 122-69195-045-000 GASB34/Reserve for Replacement .00 .00 _______________ Account: 122-69195-045-000 GASB34/Reserve for Replacement Totals: .00 .00 ** 145,598.00 Budgeted 145,598.00 Remaining 0 % Used Department 45 Totals: ------------------------------------------------------------------------------------------------ 711,593.91 ** 1,335,883.00 Budgeted 624,289.09 Remaining 53 % Used Fund 122 Totals: ------------------------------------------------------------------------------------------------------ (604,567.19) .00 Budgeted 604,567.19 Remaining 0 % Used Municipal Utility District No 1 - O & M Interim Balance Sheet Balance @ 3/31/2013 ASSETS ASSETS CASH ON HAND 400 CASH IN BANK 60,837 INVESTMENTS-TEXPOOL 2,074,365 INVESTMENTS-CD-BANK OF THE WEST 120,000 INVESTMENTS-CD-PROSPERITY BANK 200,000 RESTRICTED ASSETS: INVESTMENTS 432,326 PREPAID EXPENSES 3,931 ADVALOREM PROPERTY TAXES RECEIVABLE 3,675 UTILITY AND OTHER ACCOUNTS RECEIVABLE 626,864 TOTAL ASSETS 3,522,398$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,675$ ACCOUNTS PAYABLE 260,439 CUSTOMER DEPOSITS 218,077 TOTAL LIABILITIES 482,191 FUND BALANCE NON-SPENDABLE FUND BALANCE - ASSIGNED/WATER REPLACEMENT 90,000 ASSIGNED/TECHNOLOGY REPLACEMENT 82,359 ASSIGNED/FIRE DEPT REPLACEMENT 41,890 ASSIGNED FUND BALANCE 456,156 UNASSIGNED FUND BALANCE 2,369,802 TOTAL FUND BALANCE 3,040,207 TOTAL LIABILITIES AND FUND BALANCE 3,522,398$ March 31, 2013 6/12 Months (50% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 4 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 Property Taxes 99,884.00- 99,884.00- 840.72- 98,933.33- 99.048 950.67- 135-40002-000-000 Property Taxes/Delinquent 500.00- 500.00- 18.23- 623.73- 124.746 123.73 135-40015-000-000 Property Taxes/P & I 1,200.00- 1,200.00- 68.24- 657.80- 54.817 542.20- Subtotal: 101,584.00- 101,584.00- 927.19- 100,214.86- 98.652 1,369.14- 135-47000-000-000 Water 3,545,609.00- 3,545,609.00- 185,779.29- 1,264,905.61- 35.675 2,280,703.39- 135-47005-000-000 Sewer 1,653,747.00- 1,653,747.00- 132,065.52- 798,372.11- 48.277 855,374.89- 135-47020-000-000 Standby 576.00- 576.00- 149.90- 26.024 426.10- 135-47025-000-000 Penalties 64,580.00- 64,580.00- 3,177.49- 26,272.52- 40.682 38,307.48- 135-47030-000-000 Service Charges 11,625.00- 11,625.00- 738.42- 6,319.94- 54.365 5,305.06- 135-47035-000-000 Plumbing Inspections 1,800.00- 1,800.00- 250.00- 550.00- 30.556 1,250.00- 135-47045-000-000 Sewer Inspections 5,200.00- 5,200.00- 750.00- 2,100.00- 40.385 3,100.00- 135-47070-000-000 TCCC Effluent Charges 77,575.00- 77,575.00- 12,578.15- 16.214 64,996.85- 135-47400-000-000 Water-Out of Dist/Port Meters 27.19 Subtotal: 5,360,712.00- 5,360,712.00- 322,733.53- 2,111,248.23- 39.384 3,249,463.77- 135-48005-000-000 Utility Fees 644,000.00- 644,000.00- 41,400.00- 184,000.00- 28.571 460,000.00- Subtotal: 644,000.00- 644,000.00- 41,400.00- 184,000.00- 28.571 460,000.00- 135-49010-000-000 Interest Income 5,500.00- 5,500.00- 362.94- 2,763.76- 50.250 2,736.24- 135-49016-000-000 Cell Tower Revenue 10,164.00- 10,164.00- 910.53- 5,399.65- 53.125 4,764.35- 135-49018-000-000 Building Rent Income 7,000.00- 7,000.00- 2,333.32- 33.333 4,666.68- 135-49030-000-000 Vending Revenue 350.00- 350.00- 3.50- 36.34- 10.383 313.66- 135-49035-000-000 Prior Year Reserves 305,748.00- 305,748.00- 305,748.00- 135-49075-000-000 Oversize Meter Reimbursement 73,000.00- 73,000.00- 8,477.69- 30,860.69- 42.275 42,139.31- 135-49141-000-000 Interfund Trans In (Cap Proj) 38,101.42- 38,101.42- 38,101.42 135-49900-000-000 Miscellaneous Income 1,000.00- 1,000.00- 1,135.22- 9,212.64- 921.264 8,212.64 135-49901-000-000 Records Management Revenue 109.00- 109.00 135-49903-000-000 Recovery of Prior Year Expense 2,117.50- 2,117.50- 2,117.50 135-49905-000-000 Gas Well Revenue 200.00- 200.00- 286.02- 143.010 86.02 Subtotal: 402,962.00- 402,962.00- 51,108.80- 91,220.34- 22.637 311,741.66- Program number: 6,509,258.00- 6,509,258.00- 416,169.52- 2,486,683.43- 38.202 4,022,574.57- Department number: Revenues 6,509,258.00- 6,509,258.00- 416,169.52- 2,486,683.43- 38.202 4,022,574.57- Revenues Subtotal ----------- 6,509,258.00- 6,509,258.00- 416,169.52- 2,486,683.43- 38.202 4,022,574.57- . glbase_tbam rgonzale Trophy Club MUD #1 Page 5 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 213,321.00 213,321.00 19,593.14 80,722.46 37.841 132,598.54 135-50010-010-000 Overtime 13,250.00 13,250.00 1,030.27 7,597.90 57.343 5,652.10 135-50016-010-000 Longevity 3,080.00 3,080.00 3,080.00 100.000 135-50017-010-000 Certification 5,100.00 5,100.00 375.00 2,250.00 44.118 2,850.00 135-50020-010-000 Retirement 32,725.00 32,725.00 1,885.65 36,598.23 111.836 3,873.23- 135-50026-010-000 Medical Insurance 28,920.00 28,920.00 2,113.96 11,393.64 39.397 17,526.36 135-50027-010-000 Dental Insurance 2,091.00 2,091.00 145.51 834.87 39.927 1,256.13 135-50028-010-000 Vision Insurance 519.00 519.00 33.91 196.89 37.936 322.11 135-50029-010-000 Life Insurance & Other 1,204.00 1,204.00 88.45 766.25 63.642 437.75 135-50030-010-000 Social Security Taxes 14,555.00 14,555.00 1,281.60 5,943.14 40.832 8,611.86 135-50035-010-000 Medicare Taxes 3,404.00 3,404.00 299.74 1,389.93 40.832 2,014.07 135-50040-010-000 Unemployment Taxes 945.00 945.00 35.11 296.27 31.351 648.73 135-50045-010-000 Workman's Compensation 6,109.00 6,109.00 11,444.00 187.330 5,335.00- 135-50060-010-000 Pre-emp Physicals/Testing 200.00 200.00 63.00 63.00 31.500 137.00 135-50070-010-000 Employee Relations 350.00 350.00 82.65 23.614 267.35 Subtotal: 325,773.00 325,773.00 26,945.34 162,659.23 49.930 163,113.77 135-55005-010-000 Engineering 3,000.00 3,000.00 3,000.00 135-55080-010-000 Maintenance & Repairs 50,000.00 50,000.00 1,348.68 18,920.78 37.842 31,079.22 135-55090-010-000 Vehicle Maintenance 3,700.00 3,700.00 13.28 2,324.56 62.826 1,375.44 135-55105-010-000 Maintenance-Backhoe/SkidLoader 2,900.00 2,900.00 1,767.04 60.932 1,132.96 135-55135-010-000 Lab Analysis 4,500.00 4,500.00 240.00 2,691.34 59.808 1,808.66 Subtotal: 64,100.00 64,100.00 1,601.96 25,703.72 40.099 38,396.28 135-60010-010-000 Communications/Pagers/Mobiles 2,000.00 2,000.00 175.53 703.18 35.159 1,296.82 135-60020-010-000 Electricity 162,410.00 162,410.00 7,150.20 47,421.95 29.199 114,988.05 135-60066-010-000 Publications/Books/Subscripts 500.00 500.00 500.00 135-60070-010-000 Dues & Memberships 150.00 150.00 150.00 100.000 135-60080-010-000 Schools & Training 1,672.00 1,672.00 351.00 20.993 1,321.00 135-60090-010-000 Safety Program 500.00 500.00 500.00 135-60100-010-000 Travel & per diem 700.00 700.00 551.69 78.813 148.31 135-60105-010-000 Rent/Lease Equipment 500.00 500.00 6.00 6.00 1.200 494.00 135-60135-010-000 TCEQ Fees & Permits 35,800.00 35,800.00 40,524.75 113.198 4,724.75- 135-60150-010-000 Wholesale Water 2,028,447.00 2,028,447.00 499,848.97 24.642 1,528,598.03 135-60243-010-000 Prior Year Expense 756.00 756.00 756.00- 135-60245-010-000 Miscellaneous Expenses 500.00 500.00 500.00 135-60280-010-000 Property Maintenance 4,200.00 4,200.00 488.95 11.642 3,711.05 135-60285-010-000 Lawn Equipment & Maintenance 250.00 250.00 250.00 135-60360-010-000 Furniture/Equipment < $5000 1,500.00 1,500.00 38.99 2.599 1,461.01 Subtotal: 2,239,129.00 2,239,129.00 8,087.73 590,841.48 26.387 1,648,287.52 . glbase_tbam rgonzale Trophy Club MUD #1 Page 6 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65005-010-000 Fuel & Lube 17,661.00 17,661.00 4,726.98 26.765 12,934.02 135-65010-010-000 Uniforms 2,680.00 2,680.00 1,617.82 60.366 1,062.18 135-65030-010-000 Chemicals 6,200.00 6,200.00 416.35 2,221.92 35.837 3,978.08 135-65035-010-000 Small Tools 1,500.00 1,500.00 267.19 17.813 1,232.81 135-65040-010-000 Safety Equipment 2,000.00 2,000.00 256.82 12.841 1,743.18 135-65050-010-000 Meter Expense 143,550.00 143,550.00 97,393.00 67.846 46,157.00 135-65085-010-000 Office Supplies 109.68 109.68- Subtotal: 173,591.00 173,591.00 416.35 106,593.41 61.405 66,997.59 135-69005-010-000 Capital Expenses 181,800.00 181,800.00 1,094.96- 2,050.04 1.128 179,749.96 135-69008-010-000 Short Term Debt-Principal 387,037.00 387,037.00 387,037.00 135-69009-010-000 Short Term Debt-Interest 10,376.98 10,376.98- 135-69195-010-000 Gasb34/Reserve for Replacement 30,000.00 30,000.00 30,000.00 135-69280-010-000 Capital Repairs 270,000.00 270,000.00 59,869.00 22.174 210,131.00 135-69281-010-000 Capital Repair-Ground Storage 150,000.00 150,000.00 100,816.54 67.211 49,183.46 Subtotal: 1,018,837.00 1,018,837.00 1,094.96- 173,112.56 16.991 845,724.44 Program number: 3,821,430.00 3,821,430.00 35,956.42 1,058,910.40 27.710 2,762,519.60 Department number: Water 3,821,430.00 3,821,430.00 35,956.42 1,058,910.40 27.710 2,762,519.60 . glbase_tbam rgonzale Trophy Club MUD #1 Page 7 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-020-000 Salaries & Wages 196,781.00 196,781.00 24,144.13 91,563.47 46.531 105,217.53 135-50010-020-000 Overtime 10,166.00 10,166.00 1,445.88 7,273.77 71.550 2,892.23 135-50016-020-000 Longevity 2,858.00 2,858.00 2,857.50 99.983 .50 135-50017-020-000 Certification 4,200.00 4,200.00 350.00 2,100.00 50.000 2,100.00 135-50020-020-000 Retirement 29,821.00 29,821.00 2,329.41 37,625.89 126.172 7,804.89- 135-50026-020-000 Medical Insurance 29,034.00 29,034.00 3,293.23 16,861.59 58.075 12,172.41 135-50027-020-000 Dental Insurance 2,112.00 2,112.00 226.46 1,205.40 57.074 906.60 135-50028-020-000 Vision Insurance 552.00 552.00 57.40 309.96 56.152 242.04 135-50029-020-000 Life Insurance & Other 920.00 920.00 99.29 842.74 91.602 77.26 135-50030-020-000 Social Security Taxes 13,268.00 13,268.00 1,466.75 5,787.48 43.620 7,480.52 135-50035-020-000 Medicare Taxes 3,103.00 3,103.00 343.02 1,353.50 43.619 1,749.50 135-50040-020-000 Unemployment Taxes 756.00 756.00 36.00 309.05 40.880 446.95 135-50045-020-000 Workman's Compensation 2,939.00 2,939.00 7,853.00 267.200 4,914.00- 135-50060-020-000 Pre-emp Physicals/Testing 150.00 150.00 126.00 126.00 84.000 24.00 135-50070-020-000 Employee Relations 350.00 350.00 62.37 17.820 287.63 Subtotal: 297,010.00 297,010.00 33,917.57 176,131.72 59.302 120,878.28 135-55070-020-000 Independent Labor 1,000.00 1,000.00 11,058.00 45,933.00 4,593.300 44,933.00- 135-55080-020-000 Maintenance & Repairs 40,000.00 40,000.00 810.52 35,704.13 89.260 4,295.87 135-55090-020-000 Vehicle Maintenance 2,000.00 2,000.00 352.29- 3,348.64 167.432 1,348.64- 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,500.00 1,500.00 1,080.96 72.064 419.04 135-55125-020-000 Dumpster Services 15,000.00 15,000.00 21,536.94 143.580 6,536.94- 135-55135-020-000 Lab Analysis 30,000.00 30,000.00 2,276.00 12,884.50 42.948 17,115.50 Subtotal: 89,500.00 89,500.00 13,792.23 120,488.17 134.624 30,988.17- 135-60010-020-000 Communications/Pagers/Mobiles 2,700.00 2,700.00 262.00 1,008.54 37.353 1,691.46 135-60020-020-000 Electricity 153,045.00 153,045.00 12,563.45 64,017.33 41.829 89,027.67 135-60066-020-000 Publications/Books/Subscripts 500.00 500.00 161.45 32.290 338.55 135-60080-020-000 Schools & Training 3,272.00 3,272.00 660.66 20.191 2,611.34 135-60090-020-000 Safety Program 250.00 250.00 250.00 135-60100-020-000 Travel & per diem 1,400.00 1,400.00 816.27 58.305 583.73 135-60105-020-000 Rent/Lease Equipment 1,500.00 1,500.00 1,020.00 68.000 480.00 135-60125-020-000 Advertising 2,000.00 2,000.00 112.50 5.625 1,887.50 135-60135-020-000 TCEQ Fees & Permits 56,000.00 56,000.00 7,887.19 14.084 48,112.81 135-60243-020-000 Prior Year Expense 801.59 801.59 801.59- 135-60245-020-000 Miscellaneous Expenses 200.00 200.00 148.10 74.050 51.90 135-60285-020-000 Lawn Equipment & Maintenance 500.00 500.00 345.15 69.030 154.85 Subtotal: 221,367.00 221,367.00 13,627.04 76,978.78 34.774 144,388.22 135-65005-020-000 Fuel & Lube 8,527.00 8,527.00 15.39 5,220.70 61.226 3,306.30 135-65010-020-000 Uniforms 2,574.00 2,574.00 773.70 30.058 1,800.30 . glbase_tbam rgonzale Trophy Club MUD #1 Page 8 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-65030-020-000 Chemicals 10,000.00 10,000.00 18,345.52 183.455 8,345.52- 135-65035-020-000 Small Tools 1,000.00 1,000.00 333.47 33.347 666.53 135-65040-020-000 Safety Equipment 250.00 250.00 452.14 180.856 202.14- 135-65045-020-000 Lab Supplies 10,000.00 10,000.00 6.17 7,591.71 75.917 2,408.29 Subtotal: 32,351.00 32,351.00 21.56 32,717.24 101.132 366.24- 135-69005-020-000 Capital Expenses 241,200.00 241,200.00 42,110.00 446,484.29 185.110 205,284.29- 135-69280-020-000 Capital Repairs 158,000.00 158,000.00 27,960.70 27,960.70 17.697 130,039.30 Subtotal: 399,200.00 399,200.00 70,070.70 474,444.99 118.849 75,244.99- Program number: 1,039,428.00 1,039,428.00 131,429.10 880,760.90 84.735 158,667.10 Department number: Wastewater 1,039,428.00 1,039,428.00 131,429.10 880,760.90 84.735 158,667.10 . glbase_tbam rgonzale Trophy Club MUD #1 Page 9 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-021-000 Salaries & Wages 156,475.00 156,475.00 17,318.67 71,338.65 45.591 85,136.35 135-50010-021-000 Overtime 7,297.00 7,297.00 700.87 5,081.20 69.634 2,215.80 135-50016-021-000 Longevity 3,818.00 3,818.00 3,817.50 99.987 .50 135-50017-021-000 Certification 1,800.00 1,800.00 150.00 850.00 47.222 950.00 135-50020-021-000 Retirement 23,574.00 23,574.00 1,631.63 29,291.75 124.254 5,717.75- 135-50026-021-000 Medical Insurance 20,198.00 20,198.00 2,321.55 12,013.89 59.481 8,184.11 135-50027-021-000 Dental Insurance 1,409.00 1,409.00 159.88 853.08 60.545 555.92 135-50028-021-000 Vision Insurance 357.00 357.00 32.60 186.92 52.359 170.08 135-50029-021-000 Life Insurance & Other 1,008.00 1,008.00 63.86 610.33 60.549 397.67 135-50030-021-000 Social Security Taxes 10,502.00 10,502.00 1,059.10 4,867.73 46.351 5,634.27 135-50035-021-000 Medicare Taxes 2,456.00 2,456.00 247.69 1,138.40 46.352 1,317.60 135-50040-021-000 Unemployment Taxes 567.00 567.00 26.85 241.12 42.526 325.88 135-50045-021-000 Workman's Compensation 3,348.00 3,348.00 7,139.00 213.232 3,791.00- 135-50070-021-000 Employee Relations 250.00 250.00 59.69 23.876 190.31 Subtotal: 233,059.00 233,059.00 23,712.70 137,489.26 58.993 95,569.74 135-55005-021-000 Engineering 1,500.00 1,500.00 1,500.00 135-55080-021-000 Maintenance & Repairs 35,000.00 35,000.00 5,275.52 6,721.45 19.204 28,278.55 135-55090-021-000 Vehicle Maintenance 1,900.00 1,900.00 310.23 16.328 1,589.77 Subtotal: 38,400.00 38,400.00 5,275.52 7,031.68 18.312 31,368.32 135-60010-021-000 Communications/Pagers/Mobiles 3,500.00 3,500.00 217.06 1,145.53 32.729 2,354.47 135-60020-021-000 Electricity 18,705.00 18,705.00 1,232.13 7,910.03 42.288 10,794.97 135-60070-021-000 Dues & Memberships 250.00 250.00 250.00 100.000 135-60080-021-000 Schools & Training 826.00 826.00 830.00 100.484 4.00- 135-60090-021-000 Safety Program 500.00 500.00 500.00 135-60100-021-000 Travel & per diem 450.00 450.00 295.33 65.629 154.67 135-60105-021-000 Rent/Lease Equipment 10,000.00 10,000.00 10,000.00 135-60243-021-000 Prior Year Expense 620.83 620.83 620.83- 135-60245-021-000 Miscellaneous Expenses 100.00 100.00 100.00 Subtotal: 34,331.00 34,331.00 2,070.02 11,051.72 32.192 23,279.28 135-65005-021-000 Fuel & Lube 12,117.00 12,117.00 4,701.64 38.802 7,415.36 135-65010-021-000 Uniforms 2,220.00 2,220.00 934.13 42.078 1,285.87 135-65030-021-000 Chemicals 7,500.00 7,500.00 2,221.00 29.613 5,279.00 135-65035-021-000 Small Tools 1,500.00 1,500.00 70.00 4.667 1,430.00 135-65040-021-000 Safety Equipment 500.00 500.00 120.00 24.000 380.00 Subtotal: 23,837.00 23,837.00 8,046.77 33.757 15,790.23 135-69005-021-000 Capital Expenses 90,000.00 90,000.00 90,000.00 . glbase_tbam rgonzale Trophy Club MUD #1 Page 10 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-69008-021-000 Short Term Debt-Principal 40,260.00 40,260.00 40,260.00 Subtotal: 130,260.00 130,260.00 130,260.00 Program number: 459,887.00 459,887.00 31,058.24 163,619.43 35.578 296,267.57 Department number: Collection 459,887.00 459,887.00 31,058.24 163,619.43 35.578 296,267.57 . glbase_tbam rgonzale Trophy Club MUD #1 Page 11 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-026-000 Salaries & Wages 10,000.00 10,000.00 1,500.00 4,500.00 45.000 5,500.00 135-50030-026-000 Social Security Taxes 620.00 620.00 93.00 279.00 45.000 341.00 135-50035-026-000 Medicare Taxes 145.00 145.00 21.75 65.25 45.000 79.75 135-50040-026-000 Unemployment Taxes 210.00 210.00 2.40 63.30 30.143 146.70 135-50045-026-000 Workman's Compensation 150.00 150.00 15.70 10.467 134.30 Subtotal: 11,125.00 11,125.00 1,617.15 4,923.25 44.254 6,201.75 135-60066-026-000 Publications/Books/Subscripts 150.00 150.00 150.00 135-60070-026-000 Dues & Memberships 2,100.00 2,100.00 42.00 2.000 2,058.00 135-60075-026-000 Meetings 1,200.00 1,200.00 28.00 272.97 22.748 927.03 135-60080-026-000 Schools & Training 4,000.00 4,000.00 925.00 23.125 3,075.00 135-60100-026-000 Travel & per diem 5,000.00 5,000.00 510.28 10.206 4,489.72 135-60243-026-000 Prior Year Expense 107.10 107.10 107.10- 135-60245-026-000 Miscellaneous Expenses 3,000.00 3,000.00 252.44 8.415 2,747.56 Subtotal: 15,450.00 15,450.00 135.10 2,109.79 13.656 13,340.21 Program number: 26,575.00 26,575.00 1,752.25 7,033.04 26.465 19,541.96 Department number: Board of Directors 26,575.00 26,575.00 1,752.25 7,033.04 26.465 19,541.96 . glbase_tbam rgonzale Trophy Club MUD #1 Page 12 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 444,730.00 444,730.00 48,805.35 207,650.81 46.691 237,079.19 135-50010-030-000 Overtime 1,500.00 1,500.00 16.08 173.74 11.583 1,326.26 135-50016-030-000 Longevity 2,193.00 2,193.00 2,317.50 105.677 124.50- 135-50020-030-000 Retirement 60,441.00 60,441.00 4,384.15 69,384.03 114.796 8,943.03- 135-50026-030-000 Medical Insurance 44,066.00 44,066.00 4,388.10 22,720.20 51.559 21,345.80 135-50027-030-000 Dental Insurance 3,379.00 3,379.00 386.34 2,025.18 59.934 1,353.82 135-50028-030-000 Vision Insurance 795.00 795.00 82.53 446.11 56.114 348.89 135-50029-030-000 Life Insurance & Other 2,500.00 2,500.00 171.71 1,550.01 62.000 949.99 135-50030-030-000 Social Security Taxes 27,802.00 27,802.00 2,882.25 12,585.62 45.269 15,216.38 135-50035-030-000 Medicare Taxes 6,502.00 6,502.00 674.08 2,943.42 45.269 3,558.58 135-50040-030-000 Unemployment Taxes 1,537.00 1,537.00 59.98 951.39 61.899 585.61 135-50045-030-000 Workman's Compensation 831.00 831.00 1,539.00 185.199 708.00- 135-50060-030-000 Pre-emp Physicals/Testing 250.00 250.00 39.00 15.600 211.00 135-50070-030-000 Employee Relations 5,000.00 5,000.00 2,621.68 52.434 2,378.32 Subtotal: 601,526.00 601,526.00 61,850.57 326,947.69 54.353 274,578.31 135-55030-030-000 Software & Support 63,555.00 63,555.00 1,574.90 17,884.76 28.141 45,670.24 135-55070-030-000 Independent Labor 2,700.00 2,700.00 187.50 6.944 2,512.50 135-55075-030-000 Records Management 500.00 500.00 500.00 135-55080-030-000 Maintenance & Repairs 810.52 810.52 810.52- 135-55100-030-000 Building Maint & Supplies 5,000.00 5,000.00 379.23 3,241.72 64.834 1,758.28 135-55120-030-000 Cleaning Services 20,200.00 20,200.00 1,678.51 10,518.74 52.073 9,681.26 135-55160-030-000 Professional Outside Services 15,000.00 15,000.00 6,825.00 45.500 8,175.00 135-55161-030-000 Outside Services-Town Semo 85,465.00 85,465.00 85,465.00 100.000 135-55165-030-000 Collection Fees 159.77 159.77- 135-55205-030-000 Utility Billing Contract 11,000.00 11,000.00 556.43 3,515.81 31.962 7,484.19 Subtotal: 203,420.00 203,420.00 4,999.59 128,608.82 63.223 74,811.18 135-60005-030-000 Telephone 9,000.00 9,000.00 998.10 4,528.51 50.317 4,471.49 135-60010-030-000 Communications/Pagers/Mobiles 3,575.00 3,575.00 326.91 1,627.95 45.537 1,947.05 135-60020-030-000 Electricity/Gas 13,019.00 13,019.00 1,195.70 5,747.81 44.149 7,271.19 135-60025-030-000 Water 3,100.00 3,100.00 114.64 451.27 14.557 2,648.73 135-60030-030-000 Rent And/Or Usage 13,182.00 13,182.00 515.18 4,841.07 36.725 8,340.93 135-60035-030-000 Postage 23,000.00 23,000.00 1,512.74 13,301.68 57.833 9,698.32 135-60040-030-000 Service Charges & Fees 18,000.00 18,000.00 1,973.24 14,165.01 78.695 3,834.99 135-60050-030-000 Bad Debt Expense 8,500.00 8,500.00 85.44 1.005 8,414.56 135-60055-030-000 Insurance 35,000.00 35,000.00 50,693.77 144.839 15,693.77- 135-60066-030-000 Publications/Books/Subscripts 750.00 750.00 275.28 833.50 111.133 83.50- 135-60070-030-000 Dues & Memberships 2,400.00 2,400.00 3,891.95 162.165 1,491.95- 135-60075-030-000 Meetings 250.00 250.00 206.74 82.696 43.26 135-60080-030-000 Schools & Training 5,500.00 5,500.00 1,845.00 33.545 3,655.00 135-60100-030-000 Travel & per diem 3,950.00 3,950.00 72.77 819.28 20.741 3,130.72 . glbase_tbam rgonzale Trophy Club MUD #1 Page 13 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60110-030-000 Physicals/Testing 500.00 500.00 500.00 135-60125-030-000 Advertising 4,000.00 4,000.00 4,000.00 135-60235-030-000 Security 1,350.00 1,350.00 1,350.00 135-60243-030-000 Prior Year Expense 1,263.01 1,263.01 1,263.01- 135-60245-030-000 Miscellaneous Expenses 15,000.00 15,000.00 122.70 .818 14,877.30 135-60270-030-000 4th of July Celebration 10,500.00 10,500.00 10,500.00 135-60281-030-000 Park Expenses 3,903.11 24,317.96 24,317.96- 135-60360-030-000 Furniture/Equipment < $5000 2,500.00 2,500.00 2,325.00 93.000 175.00 Subtotal: 173,076.00 173,076.00 12,150.68 131,067.65 75.728 42,008.35 135-65010-030-000 Uniforms 1,635.00 1,635.00 624.12 38.172 1,010.88 135-65055-030-000 Hardware 20,188.00 20,188.00 69.02 10,499.24 52.007 9,688.76 135-65085-030-000 Office Supplies 8,200.00 8,200.00 210.41 3,501.63 42.703 4,698.37 135-65090-030-000 Printer Supplies & Maintenance 5,732.00 5,732.00 1,358.40 23.699 4,373.60 135-65095-030-000 Maintenance Supplies 2,000.00 2,000.00 44.68 1,063.33 53.167 936.67 135-65097-030-000 Vending Machine Supplies 500.00 500.00 500.00 135-65105-030-000 Printing 5,200.00 5,200.00 395.00 7.596 4,805.00 Subtotal: 43,455.00 43,455.00 324.11 17,441.72 40.137 26,013.28 135-69170-030-000 Copier Lease Installments 3,450.00 3,450.00 256.85 1,541.10 44.670 1,908.90 135-69195-030-000 Gasb34/Reserve for Replacement 26,911.00 26,911.00 26,911.00 Subtotal: 30,361.00 30,361.00 256.85 1,541.10 5.076 28,819.90 Program number: 1,051,838.00 1,051,838.00 79,581.80 605,606.98 57.576 446,231.02 Department number: Administration 1,051,838.00 1,051,838.00 79,581.80 605,606.98 57.576 446,231.02 . glbase_tbam rgonzale Trophy Club MUD #1 Page 14 14:59 04/11/13 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-55045-039-000 Legal 70,000.00 70,000.00 14,048.38 110,924.20 158.463 40,924.20- 135-55055-039-000 Auditing 21,200.00 21,200.00 20,700.00 97.642 500.00 135-55060-039-000 Appraisal 15,100.00 15,100.00 1,943.16 6,209.06 41.120 8,890.94 135-55065-039-000 Tax Admin Fees 3,800.00 3,800.00 15.41 2,356.39 62.010 1,443.61 Subtotal: 110,100.00 110,100.00 16,006.95 140,189.65 127.329 30,089.65- 135-60344-039-000 Intergov Trans Out (Fire CIP) 86,726.39 86,726.39- Subtotal: 86,726.39 86,726.39- Program number: 110,100.00 110,100.00 16,006.95 226,916.04 206.100 116,816.04- Department number: Non Departmental 110,100.00 110,100.00 16,006.95 226,916.04 206.100 116,816.04- Expenditures Subtotal ----------- 6,509,258.00 6,509,258.00 295,784.76 2,942,846.79 45.210 3,566,411.21 Fund number: 135 MUD 1 General Fund 120,384.76- 456,163.36 456,163.36- . glpdatb2 rgonzale Trophy Club MUD #1 Page 14 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-40000-000-000 Property Taxes 1198 03/01/2013 Property Taxes/Assessments (98,092.61) (16.65) (98,109.26) GL 1200 03/04/2013 Property Taxes/Assessments (52.37) (98,161.63) GL 1201 03/05/2013 Property Taxes/Assessments (230.80) (98,392.43) GL 1203 03/06/2013 Property Taxes/Assessments (9.28) (98,401.71) GL 1205 03/07/2013 Property Taxes/Assessments (3.38) (98,405.09) GL 1207 03/08/2013 Property Taxes/Assessments (15.38) (98,420.47) GL 1208 03/11/2013 Property Taxes/Assessments (82.46) (98,502.93) GL 1209 03/12/2013 Property Taxes/Assessments (88.15) (98,591.08) GL 1211 03/13/2013 Property Taxes/Assessments (58.03) (98,649.11) GL 1212 03/14/2013 Property Taxes/Assessments (.79) (98,649.90) GL 1213 03/15/2013 Property Taxes/Assessments (84.91) (98,734.81) GL 1216 03/19/2013 Property Taxes/Assessments (18.44) (98,753.25) GL 1217 03/21/2013 Property Taxes/Assessments (14.56) (98,767.81) GL 1219 03/22/2013 Property Taxes/Assessments (19.70) (98,787.51) GL 1220 03/25/2013 Property Taxes/Assessments (20.82) (98,808.33) GL 1220 03/25/2013 Property Taxes/Assessments (43.21) (98,851.54) GL 1221 03/27/2013 Property Taxes/Assessments (42.03) (98,893.57) GL 1222 03/28/2013 Property Taxes/Assessments (39.76) (98,933.33) GL _______________ Account: 135-40000-000-000 Property Taxes Totals: (840.72) (98,933.33) ** (99,884.00) Budgeted (950.67) Remaining 99 % Used Account: 135-40002-000-000 Property Taxes/Delinquent 1198 03/01/2013 Property Taxes/Assessments (605.50) (9.68) (615.18) GL 1213 03/15/2013 Property Taxes/Assessments (14.41) (629.59) GL 1220 03/25/2013 Property Taxes/Assessments 1.16 (628.43) GL 1221 03/27/2013 Property Taxes/Assessments 5.86 (622.57) GL 1222 03/28/2013 Property Taxes/Assessments (1.16) (623.73) GL _______________ Account: 135-40002-000-000 Property Taxes/Delinquent Totals: (18.23) (623.73) ** (500.00) Budgeted 123.73 Remaining 125 % Used Account: 135-40015-000-000 Property Taxes/P & I 1198 03/01/2013 Property Taxes/Assessments (589.56) (2.62) (592.18) GL 1241 03/01/2013 2/27 AV Tax Rendition Penalty (7.72) (599.90) GL 1200 03/04/2013 Property Taxes/Assessments (1.69) (601.59) GL 1201 03/05/2013 Property Taxes/Assessments (17.22) (618.81) GL 1203 03/06/2013 Property Taxes/Assessments (.65) (619.46) GL 1205 03/07/2013 Property Taxes/Assessments (.23) (619.69) GL 1207 03/08/2013 Property Taxes/Assessments (1.38) (621.07) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 15 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1208 03/11/2013 Property Taxes/Assessments (589.56) (4.60) (625.67) GL 1209 03/12/2013 Property Taxes/Assessments (7.39) (633.06) GL 1211 03/13/2013 Property Taxes/Assessments (2.06) (635.12) GL 1212 03/14/2013 Property Taxes/Assessments (.07) (635.19) GL 1212 03/14/2013 Property Taxes/Assessments (1.01) (636.20) GL 1213 03/15/2013 Property Taxes/Assessments (10.95) (647.15) GL 1217 03/21/2013 Property Taxes/Assessments (.09) (647.24) GL 1220 03/25/2013 Property Taxes/Assessments (.78) (648.02) GL 1220 03/25/2013 Property Taxes/Assessments (3.32) (651.34) GL 1221 03/27/2013 Property Taxes/Assessments (2.10) (653.44) GL 1222 03/28/2013 Property Taxes/Assessments (4.36) (657.80) GL _______________ Account: 135-40015-000-000 Property Taxes/P & I Totals: (68.24) (657.80) ** (1,200.00) Budgeted (542.20) Remaining 55 % Used Account: 135-47000-000-000 Water 1160 03/29/2013 UB 3/29/13 Billing UB20130329-20130329 User: (1,079,126.32) (185,736.19) (1,264,862.51) UB 1256 03/31/2013 Recode UB Port Meters (43.10) (1,264,905.61) GL _______________ Account: 135-47000-000-000 Water Totals: (185,779.29) (1,264,905.61) ** (3,545,609.00) Budgeted (2,280,703.39) Remaining 36 % Used Account: 135-47005-000-000 Sewer 1160 03/29/2013 UB 3/29/13 Billing UB20130329-20130329 User: (666,306.59) (132,065.52) (798,372.11) UB _______________ Account: 135-47005-000-000 Sewer Totals: (132,065.52) (798,372.11) ** (1,653,747.00) Budgeted (855,374.89) Remaining 48 % Used Account: 135-47020-000-000 Standby (149.90) .00 (149.90) _______________ Account: 135-47020-000-000 Standby Totals: .00 (149.90) ** (576.00) Budgeted (426.10) Remaining 26 % Used Account: 135-47025-000-000 Penalties 1109 03/21/2013 UB 3/21/13 Penalties UB20130321-20130321 User: (23,095.03) (3,134.38) (26,229.41) UB 1159 03/27/2013 UB 3/27/13 Adjustments-penalty UB20130327-20130327 User: 22.52 (26,206.89) UB 1160 03/29/2013 UB 3/29/13 Billing UB20130329-20130329 User: (65.63) (26,272.52) UB . glpdatb2 rgonzale Trophy Club MUD #1 Page 16 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-47025-000-000 Penalties Totals: (3,177.49) (26,272.52) ** (64,580.00) Budgeted (38,307.48) Remaining 41 % Used Account: 135-47030-000-000 Service Charges 1059 03/13/2013 UB 03/13/2013 Disconnect Fees UB20130313-20130313 User: (5,581.52) (550.00) (6,131.52) UB 1071 03/13/2013 UB 3/13/13 Adjustments UB20130313-20130313 User: (200.00) (6,331.52) UB 1150 03/20/2013 UB 3/20/13 Adjustments UB20130320-20130320 User: (50.00) (6,381.52) UB 1154 03/21/2013 UB 3/21/13 Adjustments UB20130321-20130321 User: (25.00) (6,406.52) UB 1160 03/29/2013 UB 3/29/13 Billing UB20130329-20130329 User: 86.58 (6,319.94) UB _______________ Account: 135-47030-000-000 Service Charges Totals: (738.42) (6,319.94) ** (11,625.00) Budgeted (5,305.06) Remaining 54 % Used Account: 135-47035-000-000 Plumbing Inspections 1184 03/31/2013 Town Invoice 1015 billed AR 20130330-20130331 User: (300.00) (250.00) (550.00) AR _______________ Account: 135-47035-000-000 Plumbing Inspections Totals: (250.00) (550.00) ** (1,800.00) Budgeted (1,250.00) Remaining 31 % Used Account: 135-47045-000-000 Sewer Inspections 1184 03/31/2013 Town Invoice 1015 billed AR 20130330-20130331 User: (1,350.00) (750.00) (2,100.00) AR _______________ Account: 135-47045-000-000 Sewer Inspections Totals: (750.00) (2,100.00) ** (5,200.00) Budgeted (3,100.00) Remaining 40 % Used Account: 135-47070-000-000 TCCC Effluent Charges (12,578.15) .00 (12,578.15) _______________ Account: 135-47070-000-000 TCCC Effluent Charges Totals: .00 (12,578.15) ** (77,575.00) Budgeted (64,996.85) Remaining 16 % Used Account: 135-47400-000-000 Water-Out of Dist/Port Meters 1160 03/29/2013 UB 3/29/13 Billing UB20130329-20130329 User: (27.19) (15.91) (43.10) UB 1256 03/31/2013 Recode UB Port Meters 43.10 .00 GL _______________ Account: 135-47400-000-000 Water-Out of Dist/Port Meters Totals: 27.19 .00 ** .00 Budgeted .00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 17 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-48005-000-000 Utility Fees 1184 03/31/2013 Town Invoice 1015 billed AR 20130330-20130331 User: (142,600.00) (41,400.00) (184,000.00) AR _______________ Account: 135-48005-000-000 Utility Fees Totals: (41,400.00) (184,000.00) ** (644,000.00) Budgeted (460,000.00) Remaining 29 % Used Account: 135-49010-000-000 Interest Income 1197 03/31/2013 March Bank Interest (2,400.82) (38.50) (2,439.32) GL 1197 03/31/2013 March Bank Interest (324.44) (2,763.76) GL _______________ Account: 135-49010-000-000 Interest Income Totals: (362.94) (2,763.76) ** (5,500.00) Budgeted (2,736.24) Remaining 50 % Used Account: 135-49016-000-000 Cell Tower Revenue 968 03/01/2013 AT&T Cell Tower lease (4,489.12) (910.53) (5,399.65) GL _______________ Account: 135-49016-000-000 Cell Tower Revenue Totals: (910.53) (5,399.65) ** (10,164.00) Budgeted (4,764.35) Remaining 53 % Used Account: 135-49018-000-000 Building Rent Income (2,333.32) .00 (2,333.32) _______________ Account: 135-49018-000-000 Building Rent Income Totals: .00 (2,333.32) ** (7,000.00) Budgeted (4,666.68) Remaining 33 % Used Account: 135-49030-000-000 Vending Revenue 975 03/01/2013 Coffee/vending (32.84) (3.50) (36.34) GL _______________ Account: 135-49030-000-000 Vending Revenue Totals: (3.50) (36.34) ** (350.00) Budgeted (313.66) Remaining 10 % Used Account: 135-49035-000-000 Prior Year Reserves .00 .00 _______________ Account: 135-49035-000-000 Prior Year Reserves Totals: .00 .00 ** (305,748.00) Budgeted (305,748.00) Remaining 0 % Used Account: 135-49075-000-000 Oversize Meter Reimbursement . glpdatb2 rgonzale Trophy Club MUD #1 Page 18 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1184 03/31/2013 Town Invoice 1015 billed AR 20130330-20130331 User: (22,383.00) (8,477.69) (30,860.69) AR _______________ Account: 135-49075-000-000 Oversize Meter Reimbursement Totals: (8,477.69) (30,860.69) ** (73,000.00) Budgeted (42,139.31) Remaining 42 % Used Account: 135-49141-000-000 Interfund Trans In (Cap Proj) 1199 03/31/2013 Trans to GF/Screen Rake $ left (49,274.40) (49,274.40) GL 1231 03/31/2013 Trans to GF/Screen Rake $ left 49,274.40 .00 GL 1232 03/31/2013 Trans to GF/Screen Rake $ left (38,101.42) (38,101.42) GL _______________ Account: 135-49141-000-000 Interfund Trans In (Cap Proj) Totals: (38,101.42) (38,101.42) ** .00 Budgeted 38,101.42 Remaining 0 % Used Account: 135-49900-000-000 Miscellaneous Income 1003 03/05/2013 UB 3/5/13 Backflow Testing Fee UB20130305-20130305 User: (8,077.42) (50.00) (8,127.42) UB 1161 03/31/2013 Town Billing Inv 1013, 1014 AR 20130330-20130331 User: (1,037.00) (9,164.42) AR 1242 03/31/2013 Bank Rec correction (48.22) (9,212.64) GL _______________ Account: 135-49900-000-000 Miscellaneous Income Totals: (1,135.22) (9,212.64) ** (1,000.00) Budgeted 8,212.64 Remaining 921 % Used Account: 135-49901-000-000 Records Management Revenue (109.00) .00 (109.00) _______________ Account: 135-49901-000-000 Records Management Revenue Totals: .00 (109.00) ** .00 Budgeted 109.00 Remaining 0 % Used Account: 135-49903-000-000 Recovery of Prior Year Expense 1180 03/31/2013 Reclass Due to/Froms 2011 Christmas hams (2,117.50) (2,117.50) GL _______________ Account: 135-49903-000-000 Recovery of Prior Year Expense Totals: (2,117.50) (2,117.50) ** .00 Budgeted 2,117.50 Remaining 0 % Used Account: 135-49905-000-000 Gas Well Revenue (286.02) .00 (286.02) _______________ Account: 135-49905-000-000 Gas Well Revenue Totals: .00 (286.02) ** (200.00) Budgeted 86.02 Remaining 143 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 19 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Department Totals: ------------------------------------------------------------------------------------------------ (2,486,683.43) ** (6,509,258.00) Budgeted (4,022,574.57) Remaining 38 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 20 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-010-000 Salaries & Wages 939 03/01/2013 3/1/13 Payroll Salaries & Wages 61,129.32 6,515.43 67,644.75 PR 1053 03/15/2013 Payroll 3/15/13 Salaries & Wages 6,515.43 74,160.18 PR 1135 03/28/2013 3/28/13 Payroll Salaries & Wages 6,562.28 80,722.46 PR _______________ Account: 135-50005-010-000 Salaries & Wages Totals: 19,593.14 80,722.46 ** 213,321.00 Budgeted 132,598.54 Remaining 38 % Used Account: 135-50010-010-000 Overtime 939 03/01/2013 3/1/13 Payroll Overtime 6,567.63 273.58 6,841.21 PR 1053 03/15/2013 Payroll 3/15/13 Overtime 278.35 7,119.56 PR 1135 03/28/2013 3/28/13 Payroll Overtime 478.34 7,597.90 PR _______________ Account: 135-50010-010-000 Overtime Totals: 1,030.27 7,597.90 ** 13,250.00 Budgeted 5,652.10 Remaining 57 % Used Account: 135-50016-010-000 Longevity 3,080.00 .00 3,080.00 _______________ Account: 135-50016-010-000 Longevity Totals: .00 3,080.00 ** 3,080.00 Budgeted .00 Remaining 100 % Used Account: 135-50017-010-000 Certification 1053 03/15/2013 Payroll 3/15/13 Certification 1,875.00 375.00 2,250.00 PR _______________ Account: 135-50017-010-000 Certification Totals: 375.00 2,250.00 ** 5,100.00 Budgeted 2,850.00 Remaining 44 % Used Account: 135-50020-010-000 Retirement 939 03/01/2013 3/1/13 Payroll Retirement 34,712.58 609.64 35,322.22 PR 1053 03/15/2013 Payroll 3/15/13 Retirement 643.77 35,965.99 PR 1135 03/28/2013 3/28/13 Payroll Retirement 632.24 36,598.23 PR _______________ Account: 135-50020-010-000 Retirement Totals: 1,885.65 36,598.23 ** 32,725.00 Budgeted (3,873.23) Remaining 112 % Used Account: 135-50026-010-000 Medical Insurance 939 03/01/2013 3/1/13 Payroll Medical Insurance 9,279.68 1,057.00 10,336.68 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 21 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1053 03/15/2013 Payroll 3/15/13 Medical Insurance 9,279.68 1,056.96 11,393.64 PR _______________ Account: 135-50026-010-000 Medical Insurance Totals: 2,113.96 11,393.64 ** 28,920.00 Budgeted 17,526.36 Remaining 39 % Used Account: 135-50027-010-000 Dental Insurance 939 03/01/2013 3/1/13 Payroll Dental Insurance 689.36 72.76 762.12 PR 1053 03/15/2013 Payroll 3/15/13 Dental Insurance 72.75 834.87 PR _______________ Account: 135-50027-010-000 Dental Insurance Totals: 145.51 834.87 ** 2,091.00 Budgeted 1,256.13 Remaining 40 % Used Account: 135-50028-010-000 Vision Insurance 939 03/01/2013 3/1/13 Payroll Vision Insurance 162.98 16.96 179.94 PR 1053 03/15/2013 Payroll 3/15/13 Vision Insurance 16.95 196.89 PR _______________ Account: 135-50028-010-000 Vision Insurance Totals: 33.91 196.89 ** 519.00 Budgeted 322.11 Remaining 38 % Used Account: 135-50029-010-000 Life Insurance & Other 939 03/01/2013 3/1/13 Payroll Life Insurance & Other 677.80 72.70 750.50 PR 1113 03/21/2013 March A/P Mar Admin FSA Monthly 15.75 766.25 Discovery Benefits 32360 AP _______________ Account: 135-50029-010-000 Life Insurance & Other Totals: 88.45 766.25 ** 1,204.00 Budgeted 437.75 Remaining 64 % Used Account: 135-50030-010-000 Social Security Taxes 939 03/01/2013 3/1/13 Payroll Social Security Taxes 4,661.54 411.47 5,073.01 PR 1053 03/15/2013 Payroll 3/15/13 Social Security Taxes 433.61 5,506.62 PR 1135 03/28/2013 3/28/13 Payroll Social Security Taxes 436.52 5,943.14 PR _______________ Account: 135-50030-010-000 Social Security Taxes Totals: 1,281.60 5,943.14 ** 14,555.00 Budgeted 8,611.86 Remaining 41 % Used Account: 135-50035-010-000 Medicare Taxes 939 03/01/2013 3/1/13 Payroll Medicare Taxes 1,090.19 96.25 1,186.44 PR 1053 03/15/2013 Payroll 3/15/13 Medicare Taxes 101.41 1,287.85 PR 1135 03/28/2013 3/28/13 Payroll Medicare Taxes 102.08 1,389.93 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 22 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-010-000 Medicare Taxes Totals: 299.74 1,389.93 ** 3,404.00 Budgeted 2,014.07 Remaining 41 % Used Account: 135-50040-010-000 Unemployment Taxes 1140 03/27/2013 TWC Calculation/1st Qtr Unemployment Taxes 261.16 35.11 296.27 PR _______________ Account: 135-50040-010-000 Unemployment Taxes Totals: 35.11 296.27 ** 945.00 Budgeted 648.73 Remaining 31 % Used Account: 135-50045-010-000 Workman's Compensation 11,444.00 .00 11,444.00 _______________ Account: 135-50045-010-000 Workman's Compensation Totals: .00 11,444.00 ** 6,109.00 Budgeted (5,335.00) Remaining 187 % Used Account: 135-50060-010-000 Pre-emp Physicals/Testing 1113 03/21/2013 March A/P Testing 63.00 63.00 CARENOW CORPORATE 32356 AP _______________ Account: 135-50060-010-000 Pre-emp Physicals/Testing Totals: 63.00 63.00 ** 200.00 Budgeted 137.00 Remaining 32 % Used Account: 135-50070-010-000 Employee Relations 82.65 .00 82.65 _______________ Account: 135-50070-010-000 Employee Relations Totals: .00 82.65 ** 350.00 Budgeted 267.35 Remaining 24 % Used Account: 135-55005-010-000 Engineering .00 .00 _______________ Account: 135-55005-010-000 Engineering Totals: .00 .00 ** 3,000.00 Budgeted 3,000.00 Remaining 0 % Used Account: 135-55080-010-000 Maintenance & Repairs 1113 03/21/2013 March A/P Generator Maintenance/Semi ann 17,572.10 810.52 18,382.62 ENTECH SALES AND SERVICE INC 32362 AP 1113 03/21/2013 March A/P Well parts for valve and gaske 334.28 18,716.90 HD SUPPLY WATERWORKS, LTD. 32366 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 23 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1137 03/26/2013 March A/P Meter tubes, hog pumps 17,572.10 203.88 18,920.78 HD SUPPLY WATERWORKS, LTD. 32398 AP _______________ Account: 135-55080-010-000 Maintenance & Repairs Totals: 1,348.68 18,920.78 ** 50,000.00 Budgeted 31,079.22 Remaining 38 % Used Account: 135-55090-010-000 Vehicle Maintenance 1113 03/21/2013 March A/P Reimburse petty cash 2,311.28 8.00 2,319.28 TROPHY CLUB MUD PETTY CASH 32383 AP 1113 03/21/2013 March A/P Reimburse petty cash 5.28 2,324.56 TROPHY CLUB MUD PETTY CASH 32383 AP _______________ Account: 135-55090-010-000 Vehicle Maintenance Totals: 13.28 2,324.56 ** 3,700.00 Budgeted 1,375.44 Remaining 63 % Used Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader 1,767.04 .00 1,767.04 _______________ Account: 135-55105-010-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,767.04 ** 2,900.00 Budgeted 1,132.96 Remaining 61 % Used Account: 135-55135-010-000 Lab Analysis 1115 03/21/2013 March A/P Bac T Test 2,451.34 240.00 2,691.34 TARRANT CTY PUBLIC HEALTH LAB 32389 AP _______________ Account: 135-55135-010-000 Lab Analysis Totals: 240.00 2,691.34 ** 4,500.00 Budgeted 1,808.66 Remaining 60 % Used Account: 135-60010-010-000 Communications/Pagers/Mobiles 1113 03/21/2013 March A/P Verizon Invoice 527.65 175.53 703.18 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Verizon Invoice (175.53) 527.65 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Verizon Invoice 175.53 703.18 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-60010-010-000 Communications/Pagers/Mobiles Totals: 175.53 703.18 ** 2,000.00 Budgeted 1,296.82 Remaining 35 % Used Account: 135-60020-010-000 Electricity 1113 03/21/2013 March A/P Elec 2/13-3/14 40,271.75 4,429.50 44,701.25 HUDSON ENERGY SERVICES, LLC 32367 AP 1113 03/21/2013 March A/P Elec 2/12-3/13 104.70 44,805.95 HUDSON ENERGY SERVICES, LLC 32367 AP 1113 03/21/2013 March A/P Elec 2/13-3/14 2,616.00 47,421.95 HUDSON ENERGY SERVICES, LLC 32367 AP _______________ Account: 135-60020-010-000 Electricity Totals: 7,150.20 47,421.95 ** 162,410.00 Budgeted 114,988.05 Remaining 29 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 24 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-010-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-010-000 Publications/Books/Subscripts Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60070-010-000 Dues & Memberships 150.00 .00 150.00 _______________ Account: 135-60070-010-000 Dues & Memberships Totals: .00 150.00 ** 150.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-010-000 Schools & Training 351.00 .00 351.00 _______________ Account: 135-60080-010-000 Schools & Training Totals: .00 351.00 ** 1,672.00 Budgeted 1,321.00 Remaining 21 % Used Account: 135-60090-010-000 Safety Program .00 .00 _______________ Account: 135-60090-010-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-010-000 Travel & per diem 551.69 .00 551.69 _______________ Account: 135-60100-010-000 Travel & per diem Totals: .00 551.69 ** 700.00 Budgeted 148.31 Remaining 79 % Used Account: 135-60105-010-000 Rent/Lease Equipment 1113 03/21/2013 March A/P Cylinder rental 6.00 6.00 ALLIED WELDING SUPPLY, INC 32351 AP _______________ Account: 135-60105-010-000 Rent/Lease Equipment Totals: 6.00 6.00 ** 500.00 Budgeted 494.00 Remaining 1 % Used Account: 135-60135-010-000 TCEQ Fees & Permits . glpdatb2 rgonzale Trophy Club MUD #1 Page 25 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 40,524.75 .00 40,524.75 _______________ Account: 135-60135-010-000 TCEQ Fees & Permits Totals: .00 40,524.75 ** 35,800.00 Budgeted (4,724.75) Remaining 113 % Used Account: 135-60150-010-000 Wholesale Water 499,848.97 .00 499,848.97 _______________ Account: 135-60150-010-000 Wholesale Water Totals: .00 499,848.97 ** 2,028,447.00 Budgeted 1,528,598.03 Remaining 25 % Used Account: 135-60243-010-000 Prior Year Expense 1187 03/31/2013 P/Y TWC due Town 756.00 756.00 GL _______________ Account: 135-60243-010-000 Prior Year Expense Totals: 756.00 756.00 ** .00 Budgeted (756.00) Remaining 0 % Used Account: 135-60245-010-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-010-000 Miscellaneous Expenses Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60280-010-000 Property Maintenance 488.95 .00 488.95 _______________ Account: 135-60280-010-000 Property Maintenance Totals: .00 488.95 ** 4,200.00 Budgeted 3,711.05 Remaining 12 % Used Account: 135-60285-010-000 Lawn Equipment & Maintenance .00 .00 _______________ Account: 135-60285-010-000 Lawn Equipment & Maintenance Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60360-010-000 Furniture/Equipment < $5000 38.99 .00 38.99 . glpdatb2 rgonzale Trophy Club MUD #1 Page 26 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60360-010-000 Furniture/Equipment < $5000 Totals: .00 38.99 ** 1,500.00 Budgeted 1,461.01 Remaining 3 % Used Account: 135-65005-010-000 Fuel & Lube 4,726.98 .00 4,726.98 _______________ Account: 135-65005-010-000 Fuel & Lube Totals: .00 4,726.98 ** 17,661.00 Budgeted 12,934.02 Remaining 27 % Used Account: 135-65010-010-000 Uniforms 1,617.82 .00 1,617.82 _______________ Account: 135-65010-010-000 Uniforms Totals: .00 1,617.82 ** 2,680.00 Budgeted 1,062.18 Remaining 60 % Used Account: 135-65030-010-000 Chemicals 1137 03/26/2013 March A/P Chlorine 1,805.57 416.35 2,221.92 DPC INDUSTRIES, INC 32397 AP _______________ Account: 135-65030-010-000 Chemicals Totals: 416.35 2,221.92 ** 6,200.00 Budgeted 3,978.08 Remaining 36 % Used Account: 135-65035-010-000 Small Tools 267.19 .00 267.19 _______________ Account: 135-65035-010-000 Small Tools Totals: .00 267.19 ** 1,500.00 Budgeted 1,232.81 Remaining 18 % Used Account: 135-65040-010-000 Safety Equipment 256.82 .00 256.82 _______________ Account: 135-65040-010-000 Safety Equipment Totals: .00 256.82 ** 2,000.00 Budgeted 1,743.18 Remaining 13 % Used Account: 135-65050-010-000 Meter Expense 97,393.00 .00 97,393.00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 27 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65050-010-000 Meter Expense Totals: .00 97,393.00 ** 143,550.00 Budgeted 46,157.00 Remaining 68 % Used Account: 135-65085-010-000 Office Supplies 109.68 .00 109.68 _______________ Account: 135-65085-010-000 Office Supplies Totals: .00 109.68 ** .00 Budgeted (109.68) Remaining 0 % Used Account: 135-69005-010-000 Capital Expenses 1063 03/13/2013 AP for Final for Roundabout 3-5-13 Final for Round About a 3,145.00 7,919.64 11,064.64 CPS CIVIL, LLC 32348 AP 1091 03/19/2013 Recode Roundabout final pmt (7,919.64) 3,145.00 GL 1092 03/19/2013 Adj Retainage/Roundabout Reduction in Change orders (1,094.96) 2,050.04 GL _______________ Account: 135-69005-010-000 Capital Expenses Totals: (1,094.96) 2,050.04 ** 181,800.00 Budgeted 179,749.96 Remaining 1 % Used Account: 135-69008-010-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-010-000 Short Term Debt-Principal Totals: .00 .00 ** 387,037.00 Budgeted 387,037.00 Remaining 0 % Used Account: 135-69009-010-000 Short Term Debt-Interest 10,376.98 .00 10,376.98 _______________ Account: 135-69009-010-000 Short Term Debt-Interest Totals: .00 10,376.98 ** .00 Budgeted (10,376.98) Remaining 0 % Used Account: 135-69195-010-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-010-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 30,000.00 Budgeted 30,000.00 Remaining 0 % Used Account: 135-69280-010-000 Capital Repairs . glpdatb2 rgonzale Trophy Club MUD #1 Page 28 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 59,869.00 .00 59,869.00 _______________ Account: 135-69280-010-000 Capital Repairs Totals: .00 59,869.00 ** 270,000.00 Budgeted 210,131.00 Remaining 22 % Used Account: 135-69281-010-000 Capital Repair-Ground Storage 100,816.54 .00 100,816.54 _______________ Account: 135-69281-010-000 Capital Repair-Ground Storage Totals: .00 100,816.54 ** 150,000.00 Budgeted 49,183.46 Remaining 67 % Used Department 10 Totals: ------------------------------------------------------------------------------------------------ 1,058,910.40 ** 3,821,430.00 Budgeted 2,762,519.60 Remaining 28 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 29 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-020-000 Salaries & Wages 939 03/01/2013 3/1/13 Payroll Salaries & Wages 67,419.34 7,246.70 74,666.04 PR 1053 03/15/2013 Payroll 3/15/13 Salaries & Wages 7,246.70 81,912.74 PR 1135 03/28/2013 3/28/13 Payroll Salaries & Wages 7,246.70 89,159.44 PR 1163 03/28/2013 Supplemental payroll 3/28/13 Salaries & Wages 2,404.03 91,563.47 PR _______________ Account: 135-50005-020-000 Salaries & Wages Totals: 24,144.13 91,563.47 ** 196,781.00 Budgeted 105,217.53 Remaining 47 % Used Account: 135-50010-020-000 Overtime 939 03/01/2013 3/1/13 Payroll Overtime 5,827.89 512.92 6,340.81 PR 1053 03/15/2013 Payroll 3/15/13 Overtime 526.39 6,867.20 PR 1135 03/28/2013 3/28/13 Payroll Overtime 326.57 7,193.77 PR 1163 03/28/2013 Supplemental payroll 3/28/13 Overtime 80.00 7,273.77 PR _______________ Account: 135-50010-020-000 Overtime Totals: 1,445.88 7,273.77 ** 10,166.00 Budgeted 2,892.23 Remaining 72 % Used Account: 135-50016-020-000 Longevity 2,857.50 .00 2,857.50 _______________ Account: 135-50016-020-000 Longevity Totals: .00 2,857.50 ** 2,858.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-020-000 Certification 1053 03/15/2013 Payroll 3/15/13 Certification 1,750.00 350.00 2,100.00 PR _______________ Account: 135-50017-020-000 Certification Totals: 350.00 2,100.00 ** 4,200.00 Budgeted 2,100.00 Remaining 50 % Used Account: 135-50020-020-000 Retirement 939 03/01/2013 3/1/13 Payroll Retirement 35,296.48 696.82 35,993.30 PR 1053 03/15/2013 Payroll 3/15/13 Retirement 729.44 36,722.74 PR 1135 03/28/2013 3/28/13 Payroll Retirement 680.08 37,402.82 PR 1163 03/28/2013 Supplemental payroll 3/28/13 Retirement 223.07 37,625.89 PR _______________ Account: 135-50020-020-000 Retirement Totals: 2,329.41 37,625.89 ** 29,821.00 Budgeted (7,804.89) Remaining 126 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 30 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50026-020-000 Medical Insurance 939 03/01/2013 3/1/13 Payroll Medical Insurance 13,568.36 1,646.62 15,214.98 PR 1053 03/15/2013 Payroll 3/15/13 Medical Insurance 1,646.61 16,861.59 PR _______________ Account: 135-50026-020-000 Medical Insurance Totals: 3,293.23 16,861.59 ** 29,034.00 Budgeted 12,172.41 Remaining 58 % Used Account: 135-50027-020-000 Dental Insurance 939 03/01/2013 3/1/13 Payroll Dental Insurance 978.94 113.24 1,092.18 PR 1053 03/15/2013 Payroll 3/15/13 Dental Insurance 113.22 1,205.40 PR _______________ Account: 135-50027-020-000 Dental Insurance Totals: 226.46 1,205.40 ** 2,112.00 Budgeted 906.60 Remaining 57 % Used Account: 135-50028-020-000 Vision Insurance 939 03/01/2013 3/1/13 Payroll Vision Insurance 252.56 28.72 281.28 PR 1053 03/15/2013 Payroll 3/15/13 Vision Insurance 28.68 309.96 PR _______________ Account: 135-50028-020-000 Vision Insurance Totals: 57.40 309.96 ** 552.00 Budgeted 242.04 Remaining 56 % Used Account: 135-50029-020-000 Life Insurance & Other 939 03/01/2013 3/1/13 Payroll Life Insurance & Other 743.45 78.29 821.74 PR 1113 03/21/2013 March A/P Mar Admin FSA Monthly 21.00 842.74 Discovery Benefits 32360 AP _______________ Account: 135-50029-020-000 Life Insurance & Other Totals: 99.29 842.74 ** 920.00 Budgeted 77.26 Remaining 92 % Used Account: 135-50030-020-000 Social Security Taxes 939 03/01/2013 3/1/13 Payroll Social Security Taxes 4,320.73 412.06 4,732.79 PR 1053 03/15/2013 Payroll 3/15/13 Social Security Taxes 431.13 5,163.92 PR 1135 03/28/2013 3/28/13 Payroll Social Security Taxes 469.55 5,633.47 PR 1163 03/28/2013 Supplemental payroll 3/28/13 Social Security Taxes 154.01 5,787.48 PR _______________ Account: 135-50030-020-000 Social Security Taxes Totals: 1,466.75 5,787.48 ** 13,268.00 Budgeted 7,480.52 Remaining 44 % Used Account: 135-50035-020-000 Medicare Taxes . glpdatb2 rgonzale Trophy Club MUD #1 Page 31 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 939 03/01/2013 3/1/13 Payroll Medicare Taxes 1,010.48 96.38 1,106.86 PR 1053 03/15/2013 Payroll 3/15/13 Medicare Taxes 100.82 1,207.68 PR 1135 03/28/2013 3/28/13 Payroll Medicare Taxes 109.80 1,317.48 PR 1163 03/28/2013 Supplemental payroll 3/28/13 Medicare Taxes 36.02 1,353.50 PR _______________ Account: 135-50035-020-000 Medicare Taxes Totals: 343.02 1,353.50 ** 3,103.00 Budgeted 1,749.50 Remaining 44 % Used Account: 135-50040-020-000 Unemployment Taxes 1140 03/27/2013 TWC Calculation/1st Qtr Unemployment Taxes 273.05 35.61 308.66 PR 1163 03/28/2013 Supplemental payroll 3/28/13 Unemployment Taxes .39 309.05 PR _______________ Account: 135-50040-020-000 Unemployment Taxes Totals: 36.00 309.05 ** 756.00 Budgeted 446.95 Remaining 41 % Used Account: 135-50045-020-000 Workman's Compensation 7,853.00 .00 7,853.00 _______________ Account: 135-50045-020-000 Workman's Compensation Totals: .00 7,853.00 ** 2,939.00 Budgeted (4,914.00) Remaining 267 % Used Account: 135-50060-020-000 Pre-emp Physicals/Testing 1113 03/21/2013 March A/P Testing 126.00 126.00 CARENOW CORPORATE 32356 AP _______________ Account: 135-50060-020-000 Pre-emp Physicals/Testing Totals: 126.00 126.00 ** 150.00 Budgeted 24.00 Remaining 84 % Used Account: 135-50070-020-000 Employee Relations 62.37 .00 62.37 _______________ Account: 135-50070-020-000 Employee Relations Totals: .00 62.37 ** 350.00 Budgeted 287.63 Remaining 18 % Used Account: 135-55070-020-000 Independent Labor 1113 03/21/2013 March A/P WWTP Study 34,875.00 11,058.00 45,933.00 THE WALLACE GROUP, INC. 32379 AP _______________ Account: 135-55070-020-000 Independent Labor Totals: 11,058.00 45,933.00 ** 1,000.00 Budgeted (44,933.00) Remaining ########## . glpdatb2 rgonzale Trophy Club MUD #1 Page 32 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55080-020-000 Maintenance & Repairs 1113 03/21/2013 March A/P Generator Maintenance/Semi ann 34,893.61 810.52 35,704.13 ENTECH SALES AND SERVICE INC 32362 AP _______________ Account: 135-55080-020-000 Maintenance & Repairs Totals: 810.52 35,704.13 ** 40,000.00 Budgeted 4,295.87 Remaining 89 % Used Account: 135-55090-020-000 Vehicle Maintenance 1191 03/19/2013 GV Ford refund duplicate pmt 3,700.93 (352.29) 3,348.64 GL _______________ Account: 135-55090-020-000 Vehicle Maintenance Totals: (352.29) 3,348.64 ** 2,000.00 Budgeted (1,348.64) Remaining 167 % Used Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader 1,080.96 .00 1,080.96 _______________ Account: 135-55105-020-000 Maintenance-Backhoe/SkidLoader Totals: .00 1,080.96 ** 1,500.00 Budgeted 419.04 Remaining 72 % Used Account: 135-55125-020-000 Dumpster Services 21,536.94 .00 21,536.94 _______________ Account: 135-55125-020-000 Dumpster Services Totals: .00 21,536.94 ** 15,000.00 Budgeted (6,536.94) Remaining 144 % Used Account: 135-55135-020-000 Lab Analysis 1113 03/21/2013 March A/P Ammonia, Carbonaceous BOD 10,608.50 98.00 10,706.50 OXIDOR LABORATORIES LLC 32375 AP 1115 03/21/2013 March A/P Wet Chem Analysis 2,229.00 12,935.50 TALEM, INC 32388 AP 1115 03/21/2013 March A/P Credit for overpmt in February (51.00) 12,884.50 TALEM, INC 32388 AP _______________ Account: 135-55135-020-000 Lab Analysis Totals: 2,276.00 12,884.50 ** 30,000.00 Budgeted 17,115.50 Remaining 43 % Used Account: 135-60010-020-000 Communications/Pagers/Mobiles 1113 03/21/2013 March A/P Verizon Invoice 746.54 262.00 1,008.54 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Verizon Invoice (262.00) 746.54 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Verizon Invoice 262.00 1,008.54 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-60010-020-000 Communications/Pagers/Mobiles Totals: 262.00 1,008.54 ** 2,700.00 Budgeted 1,691.46 Remaining 37 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 33 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60020-020-000 Electricity 1113 03/21/2013 March A/P Elec 2/13-3/14 51,453.88 12,563.45 64,017.33 HUDSON ENERGY SERVICES, LLC 32367 AP _______________ Account: 135-60020-020-000 Electricity Totals: 12,563.45 64,017.33 ** 153,045.00 Budgeted 89,027.67 Remaining 42 % Used Account: 135-60066-020-000 Publications/Books/Subscripts 161.45 .00 161.45 _______________ Account: 135-60066-020-000 Publications/Books/Subscripts Totals: .00 161.45 ** 500.00 Budgeted 338.55 Remaining 32 % Used Account: 135-60080-020-000 Schools & Training 660.66 .00 660.66 _______________ Account: 135-60080-020-000 Schools & Training Totals: .00 660.66 ** 3,272.00 Budgeted 2,611.34 Remaining 20 % Used Account: 135-60090-020-000 Safety Program .00 .00 _______________ Account: 135-60090-020-000 Safety Program Totals: .00 .00 ** 250.00 Budgeted 250.00 Remaining 0 % Used Account: 135-60100-020-000 Travel & per diem 816.27 .00 816.27 _______________ Account: 135-60100-020-000 Travel & per diem Totals: .00 816.27 ** 1,400.00 Budgeted 583.73 Remaining 58 % Used Account: 135-60105-020-000 Rent/Lease Equipment 1,020.00 .00 1,020.00 _______________ Account: 135-60105-020-000 Rent/Lease Equipment Totals: .00 1,020.00 ** 1,500.00 Budgeted 480.00 Remaining 68 % Used Account: 135-60125-020-000 Advertising . glpdatb2 rgonzale Trophy Club MUD #1 Page 34 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 112.50 .00 112.50 _______________ Account: 135-60125-020-000 Advertising Totals: .00 112.50 ** 2,000.00 Budgeted 1,887.50 Remaining 6 % Used Account: 135-60135-020-000 TCEQ Fees & Permits 7,887.19 .00 7,887.19 _______________ Account: 135-60135-020-000 TCEQ Fees & Permits Totals: .00 7,887.19 ** 56,000.00 Budgeted 48,112.81 Remaining 14 % Used Account: 135-60243-020-000 Prior Year Expense 1187 03/31/2013 P/Y TWC due Town 801.59 801.59 GL _______________ Account: 135-60243-020-000 Prior Year Expense Totals: 801.59 801.59 ** .00 Budgeted (801.59) Remaining 0 % Used Account: 135-60245-020-000 Miscellaneous Expenses 148.10 .00 148.10 _______________ Account: 135-60245-020-000 Miscellaneous Expenses Totals: .00 148.10 ** 200.00 Budgeted 51.90 Remaining 74 % Used Account: 135-60285-020-000 Lawn Equipment & Maintenance 345.15 .00 345.15 _______________ Account: 135-60285-020-000 Lawn Equipment & Maintenance Totals: .00 345.15 ** 500.00 Budgeted 154.85 Remaining 69 % Used Account: 135-65005-020-000 Fuel & Lube 1113 03/21/2013 March A/P Fuel purchase 5,205.31 15.39 5,220.70 Karl Schlielig 32370 AP _______________ Account: 135-65005-020-000 Fuel & Lube Totals: 15.39 5,220.70 ** 8,527.00 Budgeted 3,306.30 Remaining 61 % Used Account: 135-65010-020-000 Uniforms 773.70 .00 773.70 . glpdatb2 rgonzale Trophy Club MUD #1 Page 35 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-020-000 Uniforms Totals: .00 773.70 ** 2,574.00 Budgeted 1,800.30 Remaining 30 % Used Account: 135-65030-020-000 Chemicals 18,345.52 .00 18,345.52 _______________ Account: 135-65030-020-000 Chemicals Totals: .00 18,345.52 ** 10,000.00 Budgeted (8,345.52) Remaining 183 % Used Account: 135-65035-020-000 Small Tools 333.47 .00 333.47 _______________ Account: 135-65035-020-000 Small Tools Totals: .00 333.47 ** 1,000.00 Budgeted 666.53 Remaining 33 % Used Account: 135-65040-020-000 Safety Equipment 452.14 .00 452.14 _______________ Account: 135-65040-020-000 Safety Equipment Totals: .00 452.14 ** 250.00 Budgeted (202.14) Remaining 181 % Used Account: 135-65045-020-000 Lab Supplies 1113 03/21/2013 March A/P Water for lab 7,585.54 6.17 7,591.71 OZARKA DIRECT 32376 AP _______________ Account: 135-65045-020-000 Lab Supplies Totals: 6.17 7,591.71 ** 10,000.00 Budgeted 2,408.29 Remaining 76 % Used Account: 135-69005-020-000 Capital Expenses 1113 03/21/2013 March A/P Electrical for new Waste pump 404,374.29 3,040.00 407,414.29 Legacy Contracting, LP 32371 AP 1113 03/21/2013 March A/P 2013 Chev Silverado VIN 8448 19,228.00 426,642.29 CALDWELL COUNTRY CHEVROLET 32355 AP 1113 03/21/2013 March A/P 2013 Chev Silverado VIN 5072 22,882.00 449,524.29 CALDWELL COUNTRY CHEVROLET 32355 AP 1113 03/21/2013 March A/P New Waste Pump 31,310.70 480,834.99 XYLEM WATER SOLUTIONS USA INC 32386 AP 1113 03/21/2013 March A/P New Waste Pump (6,390.00) 474,444.99 XYLEM WATER SOLUTIONS USA INC 32386 AP 1257 03/31/2013 Recode Waste Pump (27,960.70) 446,484.29 GL _______________ Account: 135-69005-020-000 Capital Expenses Totals: 42,110.00 446,484.29 ** 241,200.00 Budgeted (205,284.29) Remaining 185 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 36 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-69280-020-000 Capital Repairs 1257 03/31/2013 Recode Waste Pump 27,960.70 27,960.70 GL _______________ Account: 135-69280-020-000 Capital Repairs Totals: 27,960.70 27,960.70 ** 158,000.00 Budgeted 130,039.30 Remaining 18 % Used Department 20 Totals: ------------------------------------------------------------------------------------------------ 880,760.90 ** 1,039,428.00 Budgeted 158,667.10 Remaining 85 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 37 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-021-000 Salaries & Wages 939 03/01/2013 3/1/13 Payroll Salaries & Wages 54,019.98 5,772.89 59,792.87 PR 1053 03/15/2013 Payroll 3/15/13 Salaries & Wages 5,772.89 65,565.76 PR 1135 03/28/2013 3/28/13 Payroll Salaries & Wages 5,772.89 71,338.65 PR _______________ Account: 135-50005-021-000 Salaries & Wages Totals: 17,318.67 71,338.65 ** 156,475.00 Budgeted 85,136.35 Remaining 46 % Used Account: 135-50010-021-000 Overtime 939 03/01/2013 3/1/13 Payroll Overtime 4,380.33 139.46 4,519.79 PR 1053 03/15/2013 Payroll 3/15/13 Overtime 140.43 4,660.22 PR 1135 03/28/2013 3/28/13 Payroll Overtime 420.98 5,081.20 PR _______________ Account: 135-50010-021-000 Overtime Totals: 700.87 5,081.20 ** 7,297.00 Budgeted 2,215.80 Remaining 70 % Used Account: 135-50016-021-000 Longevity 3,817.50 .00 3,817.50 _______________ Account: 135-50016-021-000 Longevity Totals: .00 3,817.50 ** 3,818.00 Budgeted .50 Remaining 100 % Used Account: 135-50017-021-000 Certification 1053 03/15/2013 Payroll 3/15/13 Certification 700.00 150.00 850.00 PR _______________ Account: 135-50017-021-000 Certification Totals: 150.00 850.00 ** 1,800.00 Budgeted 950.00 Remaining 47 % Used Account: 135-50020-021-000 Retirement 939 03/01/2013 3/1/13 Payroll Retirement 27,660.12 530.93 28,191.05 PR 1053 03/15/2013 Payroll 3/15/13 Retirement 544.49 28,735.54 PR 1135 03/28/2013 3/28/13 Payroll Retirement 556.21 29,291.75 PR _______________ Account: 135-50020-021-000 Retirement Totals: 1,631.63 29,291.75 ** 23,574.00 Budgeted (5,717.75) Remaining 124 % Used Account: 135-50026-021-000 Medical Insurance 939 03/01/2013 3/1/13 Payroll Medical Insurance 9,692.34 1,160.78 10,853.12 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 38 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1053 03/15/2013 Payroll 3/15/13 Medical Insurance 9,692.34 1,160.77 12,013.89 PR _______________ Account: 135-50026-021-000 Medical Insurance Totals: 2,321.55 12,013.89 ** 20,198.00 Budgeted 8,184.11 Remaining 59 % Used Account: 135-50027-021-000 Dental Insurance 939 03/01/2013 3/1/13 Payroll Dental Insurance 693.20 79.95 773.15 PR 1053 03/15/2013 Payroll 3/15/13 Dental Insurance 79.93 853.08 PR _______________ Account: 135-50027-021-000 Dental Insurance Totals: 159.88 853.08 ** 1,409.00 Budgeted 555.92 Remaining 61 % Used Account: 135-50028-021-000 Vision Insurance 939 03/01/2013 3/1/13 Payroll Vision Insurance 154.32 16.31 170.63 PR 1053 03/15/2013 Payroll 3/15/13 Vision Insurance 16.29 186.92 PR _______________ Account: 135-50028-021-000 Vision Insurance Totals: 32.60 186.92 ** 357.00 Budgeted 170.08 Remaining 52 % Used Account: 135-50029-021-000 Life Insurance & Other 939 03/01/2013 3/1/13 Payroll Life Insurance & Other 546.47 58.61 605.08 PR 1113 03/21/2013 March A/P Mar Admin FSA Monthly 5.25 610.33 Discovery Benefits 32360 AP _______________ Account: 135-50029-021-000 Life Insurance & Other Totals: 63.86 610.33 ** 1,008.00 Budgeted 397.67 Remaining 61 % Used Account: 135-50030-021-000 Social Security Taxes 939 03/01/2013 3/1/13 Payroll Social Security Taxes 3,808.63 333.89 4,142.52 PR 1053 03/15/2013 Payroll 3/15/13 Social Security Taxes 341.20 4,483.72 PR 1135 03/28/2013 3/28/13 Payroll Social Security Taxes 384.01 4,867.73 PR _______________ Account: 135-50030-021-000 Social Security Taxes Totals: 1,059.10 4,867.73 ** 10,502.00 Budgeted 5,634.27 Remaining 46 % Used Account: 135-50035-021-000 Medicare Taxes 939 03/01/2013 3/1/13 Payroll Medicare Taxes 890.71 78.09 968.80 PR 1053 03/15/2013 Payroll 3/15/13 Medicare Taxes 79.78 1,048.58 PR 1135 03/28/2013 3/28/13 Payroll Medicare Taxes 89.82 1,138.40 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 39 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50035-021-000 Medicare Taxes Totals: 247.69 1,138.40 ** 2,456.00 Budgeted 1,317.60 Remaining 46 % Used Account: 135-50040-021-000 Unemployment Taxes 1140 03/27/2013 TWC Calculation/1st Qtr Unemployment Taxes 214.27 26.85 241.12 PR _______________ Account: 135-50040-021-000 Unemployment Taxes Totals: 26.85 241.12 ** 567.00 Budgeted 325.88 Remaining 43 % Used Account: 135-50045-021-000 Workman's Compensation 7,139.00 .00 7,139.00 _______________ Account: 135-50045-021-000 Workman's Compensation Totals: .00 7,139.00 ** 3,348.00 Budgeted (3,791.00) Remaining 213 % Used Account: 135-50070-021-000 Employee Relations 59.69 .00 59.69 _______________ Account: 135-50070-021-000 Employee Relations Totals: .00 59.69 ** 250.00 Budgeted 190.31 Remaining 24 % Used Account: 135-55005-021-000 Engineering .00 .00 _______________ Account: 135-55005-021-000 Engineering Totals: .00 .00 ** 1,500.00 Budgeted 1,500.00 Remaining 0 % Used Account: 135-55080-021-000 Maintenance & Repairs 1113 03/21/2013 March A/P Generator Maintenance/Semi ann 1,445.93 810.52 2,256.45 ENTECH SALES AND SERVICE INC 32362 AP 1137 03/26/2013 March A/P Labor for Lift Station #4 moto 355.00 2,611.45 DHS AUTOMATION, INC 32396 AP 1137 03/26/2013 March A/P Disconnect for Generator (Lift 4,110.00 6,721.45 DHS AUTOMATION, INC 32396 AP _______________ Account: 135-55080-021-000 Maintenance & Repairs Totals: 5,275.52 6,721.45 ** 35,000.00 Budgeted 28,278.55 Remaining 19 % Used Account: 135-55090-021-000 Vehicle Maintenance . glpdatb2 rgonzale Trophy Club MUD #1 Page 40 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 310.23 .00 310.23 _______________ Account: 135-55090-021-000 Vehicle Maintenance Totals: .00 310.23 ** 1,900.00 Budgeted 1,589.77 Remaining 16 % Used Account: 135-60010-021-000 Communications/Pagers/Mobiles 1113 03/21/2013 March A/P Verizon Invoice 928.47 217.06 1,145.53 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Verizon Invoice (217.06) 928.47 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Verizon Invoice 217.06 1,145.53 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-60010-021-000 Communications/Pagers/Mobiles Totals: 217.06 1,145.53 ** 3,500.00 Budgeted 2,354.47 Remaining 33 % Used Account: 135-60020-021-000 Electricity 1113 03/21/2013 March A/P Elec 1/29-2/28 6,677.90 257.30 6,935.20 TRI COUNTY ELECTRIC 32381 AP 1113 03/21/2013 March A/P Elec 1/29-2/28 144.23 7,079.43 TRI COUNTY ELECTRIC 32381 AP 1113 03/21/2013 March A/P Elec 1/29-2/28 27.66 7,107.09 TRI COUNTY ELECTRIC 32381 AP 1113 03/21/2013 March A/P Elec 2/13-3/14 1,041.52 8,148.61 HUDSON ENERGY SERVICES, LLC 32367 AP 1161 03/31/2013 Town Billing Inv 1013, 1014 AR 20130330-20130331 User: (238.58) 7,910.03 AR _______________ Account: 135-60020-021-000 Electricity Totals: 1,232.13 7,910.03 ** 18,705.00 Budgeted 10,794.97 Remaining 42 % Used Account: 135-60070-021-000 Dues & Memberships 250.00 .00 250.00 _______________ Account: 135-60070-021-000 Dues & Memberships Totals: .00 250.00 ** 250.00 Budgeted .00 Remaining 100 % Used Account: 135-60080-021-000 Schools & Training 830.00 .00 830.00 _______________ Account: 135-60080-021-000 Schools & Training Totals: .00 830.00 ** 826.00 Budgeted (4.00) Remaining 100 % Used Account: 135-60090-021-000 Safety Program .00 .00 . glpdatb2 rgonzale Trophy Club MUD #1 Page 41 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60090-021-000 Safety Program Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60100-021-000 Travel & per diem 295.33 .00 295.33 _______________ Account: 135-60100-021-000 Travel & per diem Totals: .00 295.33 ** 450.00 Budgeted 154.67 Remaining 66 % Used Account: 135-60105-021-000 Rent/Lease Equipment .00 .00 _______________ Account: 135-60105-021-000 Rent/Lease Equipment Totals: .00 .00 ** 10,000.00 Budgeted 10,000.00 Remaining 0 % Used Account: 135-60243-021-000 Prior Year Expense 1187 03/31/2013 P/Y TWC due Town 567.00 567.00 GL 1188 03/31/2013 PY 7/20 P/R Cert Pay supplemen 53.83 620.83 GL _______________ Account: 135-60243-021-000 Prior Year Expense Totals: 620.83 620.83 ** .00 Budgeted (620.83) Remaining 0 % Used Account: 135-60245-021-000 Miscellaneous Expenses .00 .00 _______________ Account: 135-60245-021-000 Miscellaneous Expenses Totals: .00 .00 ** 100.00 Budgeted 100.00 Remaining 0 % Used Account: 135-65005-021-000 Fuel & Lube 4,701.64 .00 4,701.64 _______________ Account: 135-65005-021-000 Fuel & Lube Totals: .00 4,701.64 ** 12,117.00 Budgeted 7,415.36 Remaining 39 % Used Account: 135-65010-021-000 Uniforms 934.13 .00 934.13 . glpdatb2 rgonzale Trophy Club MUD #1 Page 42 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 21 Collection Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-65010-021-000 Uniforms Totals: .00 934.13 ** 2,220.00 Budgeted 1,285.87 Remaining 42 % Used Account: 135-65030-021-000 Chemicals 2,221.00 .00 2,221.00 _______________ Account: 135-65030-021-000 Chemicals Totals: .00 2,221.00 ** 7,500.00 Budgeted 5,279.00 Remaining 30 % Used Account: 135-65035-021-000 Small Tools 70.00 .00 70.00 _______________ Account: 135-65035-021-000 Small Tools Totals: .00 70.00 ** 1,500.00 Budgeted 1,430.00 Remaining 5 % Used Account: 135-65040-021-000 Safety Equipment 120.00 .00 120.00 _______________ Account: 135-65040-021-000 Safety Equipment Totals: .00 120.00 ** 500.00 Budgeted 380.00 Remaining 24 % Used Account: 135-69005-021-000 Capital Expenses .00 .00 _______________ Account: 135-69005-021-000 Capital Expenses Totals: .00 .00 ** 90,000.00 Budgeted 90,000.00 Remaining 0 % Used Account: 135-69008-021-000 Short Term Debt-Principal .00 .00 _______________ Account: 135-69008-021-000 Short Term Debt-Principal Totals: .00 .00 ** 40,260.00 Budgeted 40,260.00 Remaining 0 % Used Department 21 Totals: ------------------------------------------------------------------------------------------------ 163,619.43 ** 459,887.00 Budgeted 296,267.57 Remaining 36 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 43 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-026-000 Salaries & Wages 939 03/01/2013 3/1/13 Payroll Salaries & Wages 3,000.00 500.00 3,500.00 PR 1135 03/28/2013 3/28/13 Payroll Salaries & Wages 1,000.00 4,500.00 PR _______________ Account: 135-50005-026-000 Salaries & Wages Totals: 1,500.00 4,500.00 ** 10,000.00 Budgeted 5,500.00 Remaining 45 % Used Account: 135-50030-026-000 Social Security Taxes 939 03/01/2013 3/1/13 Payroll Social Security Taxes 186.00 31.00 217.00 PR 1135 03/28/2013 3/28/13 Payroll Social Security Taxes 62.00 279.00 PR _______________ Account: 135-50030-026-000 Social Security Taxes Totals: 93.00 279.00 ** 620.00 Budgeted 341.00 Remaining 45 % Used Account: 135-50035-026-000 Medicare Taxes 939 03/01/2013 3/1/13 Payroll Medicare Taxes 43.50 7.25 50.75 PR 1135 03/28/2013 3/28/13 Payroll Medicare Taxes 14.50 65.25 PR _______________ Account: 135-50035-026-000 Medicare Taxes Totals: 21.75 65.25 ** 145.00 Budgeted 79.75 Remaining 45 % Used Account: 135-50040-026-000 Unemployment Taxes 1140 03/27/2013 TWC Calculation/1st Qtr Unemployment Taxes 60.90 2.40 63.30 PR _______________ Account: 135-50040-026-000 Unemployment Taxes Totals: 2.40 63.30 ** 210.00 Budgeted 146.70 Remaining 30 % Used Account: 135-50045-026-000 Workman's Compensation 15.70 .00 15.70 _______________ Account: 135-50045-026-000 Workman's Compensation Totals: .00 15.70 ** 150.00 Budgeted 134.30 Remaining 10 % Used Account: 135-60066-026-000 Publications/Books/Subscripts .00 .00 _______________ Account: 135-60066-026-000 Publications/Books/Subscripts Totals: .00 .00 ** 150.00 Budgeted 150.00 Remaining 0 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 44 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 26 Board of Directors Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60070-026-000 Dues & Memberships 42.00 .00 42.00 _______________ Account: 135-60070-026-000 Dues & Memberships Totals: .00 42.00 ** 2,100.00 Budgeted 2,058.00 Remaining 2 % Used Account: 135-60075-026-000 Meetings 1113 03/21/2013 March A/P Chamber luncheon/Sanders 244.97 28.00 272.97 NORTHWEST METROPORT CHAMBER 32373 AP _______________ Account: 135-60075-026-000 Meetings Totals: 28.00 272.97 ** 1,200.00 Budgeted 927.03 Remaining 23 % Used Account: 135-60080-026-000 Schools & Training 925.00 .00 925.00 _______________ Account: 135-60080-026-000 Schools & Training Totals: .00 925.00 ** 4,000.00 Budgeted 3,075.00 Remaining 23 % Used Account: 135-60100-026-000 Travel & per diem 510.28 .00 510.28 _______________ Account: 135-60100-026-000 Travel & per diem Totals: .00 510.28 ** 5,000.00 Budgeted 4,489.72 Remaining 10 % Used Account: 135-60243-026-000 Prior Year Expense 1187 03/31/2013 P/Y TWC due Town 107.10 107.10 GL _______________ Account: 135-60243-026-000 Prior Year Expense Totals: 107.10 107.10 ** .00 Budgeted (107.10) Remaining 0 % Used Account: 135-60245-026-000 Miscellaneous Expenses 252.44 .00 252.44 _______________ Account: 135-60245-026-000 Miscellaneous Expenses Totals: .00 252.44 ** 3,000.00 Budgeted 2,747.56 Remaining 8 % Used Department 26 Totals: ------------------------------------------------------------------------------------------------ 7,033.04 ** 26,575.00 Budgeted 19,541.96 Remaining 26 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 45 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-50005-030-000 Salaries & Wages 939 03/01/2013 3/1/13 Payroll Salaries & Wages 158,845.46 16,269.32 175,114.78 PR 1053 03/15/2013 Payroll 3/15/13 Salaries & Wages 16,269.32 191,384.10 PR 1135 03/28/2013 3/28/13 Payroll Salaries & Wages 16,266.71 207,650.81 PR _______________ Account: 135-50005-030-000 Salaries & Wages Totals: 48,805.35 207,650.81 ** 444,730.00 Budgeted 237,079.19 Remaining 47 % Used Account: 135-50010-030-000 Overtime 939 03/01/2013 3/1/13 Payroll Overtime 157.66 3.12 160.78 PR 1053 03/15/2013 Payroll 3/15/13 Overtime 3.12 163.90 PR 1135 03/28/2013 3/28/13 Payroll Overtime 9.84 173.74 PR _______________ Account: 135-50010-030-000 Overtime Totals: 16.08 173.74 ** 1,500.00 Budgeted 1,326.26 Remaining 12 % Used Account: 135-50016-030-000 Longevity 2,317.50 .00 2,317.50 _______________ Account: 135-50016-030-000 Longevity Totals: .00 2,317.50 ** 2,193.00 Budgeted (124.50) Remaining 106 % Used Account: 135-50020-030-000 Retirement 939 03/01/2013 3/1/13 Payroll Retirement 64,999.88 1,461.25 66,461.13 PR 1053 03/15/2013 Payroll 3/15/13 Retirement 1,461.26 67,922.39 PR 1135 03/28/2013 3/28/13 Payroll Retirement 1,461.64 69,384.03 PR _______________ Account: 135-50020-030-000 Retirement Totals: 4,384.15 69,384.03 ** 60,441.00 Budgeted (8,943.03) Remaining 115 % Used Account: 135-50026-030-000 Medical Insurance 939 03/01/2013 3/1/13 Payroll Medical Insurance 18,332.10 2,194.07 20,526.17 PR 1053 03/15/2013 Payroll 3/15/13 Medical Insurance 2,194.03 22,720.20 PR _______________ Account: 135-50026-030-000 Medical Insurance Totals: 4,388.10 22,720.20 ** 44,066.00 Budgeted 21,345.80 Remaining 52 % Used Account: 135-50027-030-000 Dental Insurance . glpdatb2 rgonzale Trophy Club MUD #1 Page 46 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 939 03/01/2013 3/1/13 Payroll Dental Insurance 1,638.84 193.19 1,832.03 PR 1053 03/15/2013 Payroll 3/15/13 Dental Insurance 193.15 2,025.18 PR _______________ Account: 135-50027-030-000 Dental Insurance Totals: 386.34 2,025.18 ** 3,379.00 Budgeted 1,353.82 Remaining 60 % Used Account: 135-50028-030-000 Vision Insurance 939 03/01/2013 3/1/13 Payroll Vision Insurance 363.58 41.29 404.87 PR 1053 03/15/2013 Payroll 3/15/13 Vision Insurance 41.24 446.11 PR _______________ Account: 135-50028-030-000 Vision Insurance Totals: 82.53 446.11 ** 795.00 Budgeted 348.89 Remaining 56 % Used Account: 135-50029-030-000 Life Insurance & Other 939 03/01/2013 3/1/13 Payroll Life Insurance & Other 1,378.30 134.96 1,513.26 PR 1113 03/21/2013 March A/P Mar Admin FSA Monthly 36.75 1,550.01 Discovery Benefits 32360 AP _______________ Account: 135-50029-030-000 Life Insurance & Other Totals: 171.71 1,550.01 ** 2,500.00 Budgeted 949.99 Remaining 62 % Used Account: 135-50030-030-000 Social Security Taxes 939 03/01/2013 3/1/13 Payroll Social Security Taxes 9,703.37 938.80 10,642.17 PR 1053 03/15/2013 Payroll 3/15/13 Social Security Taxes 934.29 11,576.46 PR 1135 03/28/2013 3/28/13 Payroll Social Security Taxes 1,009.16 12,585.62 PR _______________ Account: 135-50030-030-000 Social Security Taxes Totals: 2,882.25 12,585.62 ** 27,802.00 Budgeted 15,216.38 Remaining 45 % Used Account: 135-50035-030-000 Medicare Taxes 939 03/01/2013 3/1/13 Payroll Medicare Taxes 2,269.34 219.57 2,488.91 PR 1053 03/15/2013 Payroll 3/15/13 Medicare Taxes 218.50 2,707.41 PR 1135 03/28/2013 3/28/13 Payroll Medicare Taxes 236.01 2,943.42 PR _______________ Account: 135-50035-030-000 Medicare Taxes Totals: 674.08 2,943.42 ** 6,502.00 Budgeted 3,558.58 Remaining 45 % Used Account: 135-50040-030-000 Unemployment Taxes 1140 03/27/2013 TWC Calculation/1st Qtr Unemployment Taxes 891.41 59.98 951.39 PR . glpdatb2 rgonzale Trophy Club MUD #1 Page 47 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-50040-030-000 Unemployment Taxes Totals: 59.98 951.39 ** 1,537.00 Budgeted 585.61 Remaining 62 % Used Account: 135-50045-030-000 Workman's Compensation 1,539.00 .00 1,539.00 _______________ Account: 135-50045-030-000 Workman's Compensation Totals: .00 1,539.00 ** 831.00 Budgeted (708.00) Remaining 185 % Used Account: 135-50060-030-000 Pre-emp Physicals/Testing 39.00 .00 39.00 _______________ Account: 135-50060-030-000 Pre-emp Physicals/Testing Totals: .00 39.00 ** 250.00 Budgeted 211.00 Remaining 16 % Used Account: 135-50070-030-000 Employee Relations 2,621.68 .00 2,621.68 _______________ Account: 135-50070-030-000 Employee Relations Totals: .00 2,621.68 ** 5,000.00 Budgeted 2,378.32 Remaining 52 % Used Account: 135-55030-030-000 Software & Support 1113 03/21/2013 March A/P 1/28-2/27 PCards/Pastor 16,309.86 450.90 16,760.76 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P 1/28-2/27 PCards/Pastor 35.94 16,796.70 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P 1/28-2/27 PCards/Pastor 25.00 16,821.70 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P 1/28-2/27 PCards/Pastor 399.00 17,220.70 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Feb PCards/Zieverink 53.38 17,274.08 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Feb PCards/Zieverink 65.44 17,339.52 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Fulcrum Group Inv 18599 Annual 96.00 17,435.52 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Monthly ISP charges 449.24 17,884.76 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Entech Inv 2909, Marquee repai 268.25 18,153.01 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC 1/28-2/27 PCards/Pastor (450.90) 17,702.11 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC 1/28-2/27 PCards/Pastor (35.94) 17,666.17 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC 1/28-2/27 PCards/Pastor (25.00) 17,641.17 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC 1/28-2/27 PCards/Pastor (399.00) 17,242.17 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (53.38) 17,188.79 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (65.44) 17,123.35 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Fulcrum Group Inv 18599 Annual (96.00) 17,027.35 TOWN OF TROPHY CLUB 32380 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 48 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1124 03/21/2013 Void AP Ck 32380/Town of TC Monthly ISP charges 16,309.86 (449.24) 16,578.11 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Entech Inv 2909, Marquee repai (268.25) 16,309.86 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P 1/28-2/27 PCards/Pastor 450.90 16,760.76 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P 1/28-2/27 PCards/Pastor 35.94 16,796.70 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P 1/28-2/27 PCards/Pastor 25.00 16,821.70 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Monthly ISP charges 449.24 17,270.94 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P 1/28-2/27 PCards/Pastor 399.00 17,669.94 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 53.38 17,723.32 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 65.44 17,788.76 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Fulcrum Group Inv 18599 Annual 96.00 17,884.76 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-55030-030-000 Software & Support Totals: 1,574.90 17,884.76 ** 63,555.00 Budgeted 45,670.24 Remaining 28 % Used Account: 135-55070-030-000 Independent Labor 187.50 .00 187.50 _______________ Account: 135-55070-030-000 Independent Labor Totals: .00 187.50 ** 2,700.00 Budgeted 2,512.50 Remaining 7 % Used Account: 135-55075-030-000 Records Management .00 .00 _______________ Account: 135-55075-030-000 Records Management Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-55080-030-000 Maintenance & Repairs 1113 03/21/2013 March A/P Generator Maintenance/Semi ann 810.52 810.52 ENTECH SALES AND SERVICE INC 32362 AP _______________ Account: 135-55080-030-000 Maintenance & Repairs Totals: 810.52 810.52 ** .00 Budgeted (810.52) Remaining 0 % Used Account: 135-55100-030-000 Building Maint & Supplies 1113 03/21/2013 March A/P Feb PCards/Zieverink 2,862.49 42.63 2,905.12 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Rug Service 336.60 3,241.72 G & K SERVICES 32365 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (42.63) 3,199.09 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 42.63 3,241.72 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-55100-030-000 Building Maint & Supplies Totals: 379.23 3,241.72 ** 5,000.00 Budgeted 1,758.28 Remaining 65 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 49 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55120-030-000 Cleaning Services 1113 03/21/2013 March A/P Mar Cleaning services 8,840.23 1,678.51 10,518.74 ABM JANITORIAL SERVICES, INC 32349 AP _______________ Account: 135-55120-030-000 Cleaning Services Totals: 1,678.51 10,518.74 ** 20,200.00 Budgeted 9,681.26 Remaining 52 % Used Account: 135-55160-030-000 Professional Outside Services 6,825.00 .00 6,825.00 _______________ Account: 135-55160-030-000 Professional Outside Services Totals: .00 6,825.00 ** 15,000.00 Budgeted 8,175.00 Remaining 46 % Used Account: 135-55161-030-000 Outside Services-Town Semo 85,465.00 .00 85,465.00 _______________ Account: 135-55161-030-000 Outside Services-Town Semo Totals: .00 85,465.00 ** 85,465.00 Budgeted .00 Remaining 100 % Used Account: 135-55165-030-000 Collection Fees 159.77 .00 159.77 _______________ Account: 135-55165-030-000 Collection Fees Totals: .00 159.77 ** .00 Budgeted (159.77) Remaining 0 % Used Account: 135-55205-030-000 Utility Billing Contract 1113 03/21/2013 March A/P Feb bill printing 2,959.38 607.75 3,567.13 DP2 BILLING SOLUTIONS, LLC 32361 AP 1161 03/31/2013 Town Billing Inv 1013, 1014 AR 20130330-20130331 User: (51.32) 3,515.81 AR _______________ Account: 135-55205-030-000 Utility Billing Contract Totals: 556.43 3,515.81 ** 11,000.00 Budgeted 7,484.19 Remaining 32 % Used Account: 135-60005-030-000 Telephone 1113 03/21/2013 March A/P Feb PCards/Zieverink 3,530.41 147.72 3,678.13 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Feb PCards/Zieverink 395.63 4,073.76 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Feb PCards/Zieverink 372.25 4,446.01 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Mercury Communications Inv 269 82.50 4,528.51 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (147.72) 4,380.79 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink (395.63) 3,985.16 TOWN OF TROPHY CLUB 32380 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 50 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb PCards/Zieverink 3,530.41 (372.25) 3,612.91 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Mercury Communications Inv 269 (82.50) 3,530.41 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 147.72 3,678.13 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 395.63 4,073.76 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Feb PCards/Zieverink 372.25 4,446.01 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P Mercury Communications Inv 269 82.50 4,528.51 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-60005-030-000 Telephone Totals: 998.10 4,528.51 ** 9,000.00 Budgeted 4,471.49 Remaining 50 % Used Account: 135-60010-030-000 Communications/Pagers/Mobiles 1053 03/15/2013 Payroll 3/15/13 Communications/Pagers/Mobiles 1,301.04 150.00 1,451.04 PR 1113 03/21/2013 March A/P Verizon Invoice 176.91 1,627.95 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Verizon Invoice (176.91) 1,451.04 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Verizon Invoice 176.91 1,627.95 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-60010-030-000 Communications/Pagers/Mobiles Totals: 326.91 1,627.95 ** 3,575.00 Budgeted 1,947.05 Remaining 46 % Used Account: 135-60020-030-000 Electricity/Gas 1113 03/21/2013 March A/P Elec 12/13-1/14 MUD and PS Bld 4,552.11 1,195.70 5,747.81 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Elec 12/13-1/14 MUD and PS Bld (1,195.70) 4,552.11 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Elec 12/13-1/14 MUD and PS Bld 1,195.70 5,747.81 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-60020-030-000 Electricity/Gas Totals: 1,195.70 5,747.81 ** 13,019.00 Budgeted 7,271.19 Remaining 44 % Used Account: 135-60025-030-000 Water 1113 03/21/2013 March A/P Feb Water 336.63 114.64 451.27 TROPHY CLUB MUD (WATER BILLS) 32382 AP _______________ Account: 135-60025-030-000 Water Totals: 114.64 451.27 ** 3,100.00 Budgeted 2,648.73 Remaining 15 % Used Account: 135-60030-030-000 Rent And/Or Usage 1098 03/07/2013 Inv 1012/Town of Trophy Club AR 20130307-20130307 User: 4,325.89 (583.33) 3,742.56 AR 1113 03/21/2013 March A/P PS Building March rent 1,098.51 4,841.07 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC PS Building March rent (1,098.51) 3,742.56 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P PS Building March rent 1,098.51 4,841.07 TOWN OF TROPHY CLUB 32394 AP . glpdatb2 rgonzale Trophy Club MUD #1 Page 51 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) _______________ Account: 135-60030-030-000 Rent And/Or Usage Totals: 515.18 4,841.07 ** 13,182.00 Budgeted 8,340.93 Remaining 37 % Used Account: 135-60035-030-000 Postage 1113 03/21/2013 March A/P Pitney Bowes Postage meter Qtr 11,788.94 145.50 11,934.44 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P Overnight paperwork 16.61 11,951.05 FEDERAL EXPRESS CORP 32363 AP 1113 03/21/2013 March A/P overnight paperwork 6.17 11,957.22 FEDERAL EXPRESS CORP 32363 AP 1113 03/21/2013 March A/P Overnight paperwork 6.52 11,963.74 FEDERAL EXPRESS CORP 32363 AP 1113 03/21/2013 March A/P Overnight paperwork 10.48 11,974.22 FEDERAL EXPRESS CORP 32363 AP 1113 03/21/2013 March A/P Feb bill printing 1,474.35 13,448.57 DP2 BILLING SOLUTIONS, LLC 32361 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Pitney Bowes Postage meter Qtr (145.50) 13,303.07 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Pitney Bowes Postage meter Qtr 145.50 13,448.57 TOWN OF TROPHY CLUB 32394 AP 1139 03/28/2013 Rev JE289/Nov postage used (397.44) 13,051.13 GL 1146 03/28/2013 Oct Postage meter usage MUD Adm postage used 250.55 13,301.68 GL _______________ Account: 135-60035-030-000 Postage Totals: 1,512.74 13,301.68 ** 23,000.00 Budgeted 9,698.32 Remaining 58 % Used Account: 135-60040-030-000 Service Charges & Fees 1238 03/04/2013 Credit card fees 12,191.77 47.47 12,239.24 GL 1195 03/31/2013 Credit card/Online fees 1,599.07 13,838.31 GL 1195 03/31/2013 Credit card/Online fees 76.70 13,915.01 GL 1196 03/31/2013 FF Monthly Account Analysis 250.00 14,165.01 GL _______________ Account: 135-60040-030-000 Service Charges & Fees Totals: 1,973.24 14,165.01 ** 18,000.00 Budgeted 3,834.99 Remaining 79 % Used Account: 135-60050-030-000 Bad Debt Expense 85.44 .00 85.44 _______________ Account: 135-60050-030-000 Bad Debt Expense Totals: .00 85.44 ** 8,500.00 Budgeted 8,414.56 Remaining 1 % Used Account: 135-60055-030-000 Insurance 50,693.77 .00 50,693.77 _______________ Account: 135-60055-030-000 Insurance Totals: .00 50,693.77 ** 35,000.00 Budgeted (15,693.77) Remaining 145 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 52 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-60066-030-000 Publications/Books/Subscripts 1115 03/21/2013 March A/P Newspaper 558.22 275.28 833.50 STAR-TELEGRAM OPERATING LTD 32387 AP _______________ Account: 135-60066-030-000 Publications/Books/Subscripts Totals: 275.28 833.50 ** 750.00 Budgeted (83.50) Remaining 111 % Used Account: 135-60070-030-000 Dues & Memberships 3,891.95 .00 3,891.95 _______________ Account: 135-60070-030-000 Dues & Memberships Totals: .00 3,891.95 ** 2,400.00 Budgeted (1,491.95) Remaining 162 % Used Account: 135-60075-030-000 Meetings 206.74 .00 206.74 _______________ Account: 135-60075-030-000 Meetings Totals: .00 206.74 ** 250.00 Budgeted 43.26 Remaining 83 % Used Account: 135-60080-030-000 Schools & Training 1,845.00 .00 1,845.00 _______________ Account: 135-60080-030-000 Schools & Training Totals: .00 1,845.00 ** 5,500.00 Budgeted 3,655.00 Remaining 34 % Used Account: 135-60100-030-000 Travel & per diem 1135 03/28/2013 3/28/13 Payroll Travel & per diem 746.51 72.77 819.28 PR _______________ Account: 135-60100-030-000 Travel & per diem Totals: 72.77 819.28 ** 3,950.00 Budgeted 3,130.72 Remaining 21 % Used Account: 135-60110-030-000 Physicals/Testing .00 .00 _______________ Account: 135-60110-030-000 Physicals/Testing Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-60125-030-000 Advertising . glpdatb2 rgonzale Trophy Club MUD #1 Page 53 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) .00 .00 _______________ Account: 135-60125-030-000 Advertising Totals: .00 .00 ** 4,000.00 Budgeted 4,000.00 Remaining 0 % Used Account: 135-60235-030-000 Security .00 .00 _______________ Account: 135-60235-030-000 Security Totals: .00 .00 ** 1,350.00 Budgeted 1,350.00 Remaining 0 % Used Account: 135-60243-030-000 Prior Year Expense 1187 03/31/2013 P/Y TWC due Town 1,263.01 1,263.01 GL _______________ Account: 135-60243-030-000 Prior Year Expense Totals: 1,263.01 1,263.01 ** .00 Budgeted (1,263.01) Remaining 0 % Used Account: 135-60245-030-000 Miscellaneous Expenses 122.70 .00 122.70 _______________ Account: 135-60245-030-000 Miscellaneous Expenses Totals: .00 122.70 ** 15,000.00 Budgeted 14,877.30 Remaining 1 % Used Account: 135-60270-030-000 4th of July Celebration .00 .00 _______________ Account: 135-60270-030-000 4th of July Celebration Totals: .00 .00 ** 10,500.00 Budgeted 10,500.00 Remaining 0 % Used Account: 135-60281-030-000 Park Expenses 1113 03/21/2013 March A/P Feb Harmony Park expenses 20,414.85 3,903.11 24,317.96 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Feb Harmony Park expenses (3,903.11) 20,414.85 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Feb Harmony Park expenses 3,903.11 24,317.96 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-60281-030-000 Park Expenses Totals: 3,903.11 24,317.96 ** .00 Budgeted (24,317.96) Remaining 0 % Used Account: 135-60360-030-000 Furniture/Equipment < $5000 . glpdatb2 rgonzale Trophy Club MUD #1 Page 54 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 2,325.00 .00 2,325.00 _______________ Account: 135-60360-030-000 Furniture/Equipment < $5000 Totals: .00 2,325.00 ** 2,500.00 Budgeted 175.00 Remaining 93 % Used Account: 135-65010-030-000 Uniforms 624.12 .00 624.12 _______________ Account: 135-65010-030-000 Uniforms Totals: .00 624.12 ** 1,635.00 Budgeted 1,010.88 Remaining 38 % Used Account: 135-65055-030-000 Hardware 1113 03/21/2013 March A/P 1/28-2/27 PCards/Pastor 10,430.22 9.05 10,439.27 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P 1/28-2/27 PCards/Pastor 5.98 10,445.25 TOWN OF TROPHY CLUB 32380 AP 1113 03/21/2013 March A/P 1/28-2/27 PCards/Pastor 53.99 10,499.24 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC 1/28-2/27 PCards/Pastor (9.05) 10,490.19 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC 1/28-2/27 PCards/Pastor (5.98) 10,484.21 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC 1/28-2/27 PCards/Pastor (53.99) 10,430.22 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P 1/28-2/27 PCards/Pastor 53.99 10,484.21 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P 1/28-2/27 PCards/Pastor 9.05 10,493.26 TOWN OF TROPHY CLUB 32394 AP 1125 03/22/2013 Mar A/P 1/28-2/27 PCards/Pastor 5.98 10,499.24 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-65055-030-000 Hardware Totals: 69.02 10,499.24 ** 20,188.00 Budgeted 9,688.76 Remaining 52 % Used Account: 135-65085-030-000 Office Supplies 1113 03/21/2013 March A/P Office Supplies 3,291.22 110.15 3,401.37 OFFICE DEPOT, INC 32374 AP 1113 03/21/2013 March A/P Office Supplies 65.09 3,466.46 OFFICE DEPOT, INC 32374 AP 1120 03/22/2013 March A/P PCard reimb 71.29 3,537.75 TOWN OF TROPHY CLUB 32392 AP 1161 03/31/2013 Town Billing Inv 1013, 1014 AR 20130330-20130331 User: (36.12) 3,501.63 AR _______________ Account: 135-65085-030-000 Office Supplies Totals: 210.41 3,501.63 ** 8,200.00 Budgeted 4,698.37 Remaining 43 % Used Account: 135-65090-030-000 Printer Supplies & Maintenance 1,358.40 .00 1,358.40 _______________ Account: 135-65090-030-000 Printer Supplies & Maintenance Totals: .00 1,358.40 ** 5,732.00 Budgeted 4,373.60 Remaining 24 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 55 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-65095-030-000 Maintenance Supplies 1120 03/22/2013 March A/P PCard reimb 1,018.65 44.68 1,063.33 TOWN OF TROPHY CLUB 32392 AP _______________ Account: 135-65095-030-000 Maintenance Supplies Totals: 44.68 1,063.33 ** 2,000.00 Budgeted 936.67 Remaining 53 % Used Account: 135-65097-030-000 Vending Machine Supplies .00 .00 _______________ Account: 135-65097-030-000 Vending Machine Supplies Totals: .00 .00 ** 500.00 Budgeted 500.00 Remaining 0 % Used Account: 135-65105-030-000 Printing 395.00 .00 395.00 _______________ Account: 135-65105-030-000 Printing Totals: .00 395.00 ** 5,200.00 Budgeted 4,805.00 Remaining 8 % Used Account: 135-69170-030-000 Copier Lease Installments 1113 03/21/2013 March A/P Kyocera Inv 58534430 1,284.25 256.85 1,541.10 TOWN OF TROPHY CLUB 32380 AP 1124 03/21/2013 Void AP Ck 32380/Town of TC Kyocera Inv 58534430 (256.85) 1,284.25 TOWN OF TROPHY CLUB 32380 AP 1125 03/22/2013 Mar A/P Kyocera Inv 58534430 256.85 1,541.10 TOWN OF TROPHY CLUB 32394 AP _______________ Account: 135-69170-030-000 Copier Lease Installments Totals: 256.85 1,541.10 ** 3,450.00 Budgeted 1,908.90 Remaining 45 % Used Account: 135-69195-030-000 Gasb34/Reserve for Replacement .00 .00 _______________ Account: 135-69195-030-000 Gasb34/Reserve for Replacement Totals: .00 .00 ** 26,911.00 Budgeted 26,911.00 Remaining 0 % Used Department 30 Totals: ------------------------------------------------------------------------------------------------ 605,606.98 ** 1,051,838.00 Budgeted 446,231.02 Remaining 58 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 56 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 135-55045-039-000 Legal 1113 03/21/2013 March A/P Feb Legal/General 96,875.82 847.20 97,723.02 WHITAKER CHALK SWINDLE 32385 AP 1113 03/21/2013 March A/P Legal/CCN 1,249.95 98,972.97 WHITAKER CHALK SWINDLE 32385 AP 1113 03/21/2013 March A/P Legal/Solana 924.00 99,896.97 WHITAKER CHALK SWINDLE 32385 AP 1113 03/21/2013 March A/P Legal/Town contract 1,663.20 101,560.17 WHITAKER CHALK SWINDLE 32385 AP 1113 03/21/2013 March A/P Legal 2,819.03 104,379.20 BOOTH, AHRENS & WERKENTHIN PC 32354 AP 1113 03/21/2013 March A/P Feb Legal 2,667.50 107,046.70 THE LISTON LAW FIRM, P.C. 32378 AP 1113 03/21/2013 March A/P Legal 3,877.50 110,924.20 FREEMAN & CORBETT 32364 AP _______________ Account: 135-55045-039-000 Legal Totals: 14,048.38 110,924.20 ** 70,000.00 Budgeted (40,924.20) Remaining 158 % Used Account: 135-55055-039-000 Auditing 20,700.00 .00 20,700.00 _______________ Account: 135-55055-039-000 Auditing Totals: .00 20,700.00 ** 21,200.00 Budgeted 500.00 Remaining 98 % Used Account: 135-55060-039-000 Appraisal 1113 03/21/2013 March A/P Second Qtr DCAD 2013 budget 4,265.90 1,943.16 6,209.06 DENTON CENTRAL APPRAISAL DISTR 32357 AP _______________ Account: 135-55060-039-000 Appraisal Totals: 1,943.16 6,209.06 ** 15,100.00 Budgeted 8,890.94 Remaining 41 % Used Account: 135-55065-039-000 Tax Admin Fees 1113 03/21/2013 March A/P 33.11 Tax notices 2,340.98 15.41 2,356.39 DENTON COUNTY TAX OFFICE 32358 AP _______________ Account: 135-55065-039-000 Tax Admin Fees Totals: 15.41 2,356.39 ** 3,800.00 Budgeted 1,443.61 Remaining 62 % Used Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) 86,726.39 .00 86,726.39 _______________ Account: 135-60344-039-000 Intergov Trans Out (Fire CIP) Totals: .00 86,726.39 ** .00 Budgeted (86,726.39) Remaining 0 % Used Department 39 Totals: ------------------------------------------------------------------------------------------------ 226,916.04 ** 110,100.00 Budgeted (116,816.04) Remaining 206 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 57 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 135 MUD 1 General Fund Department: 39 Non Departmental Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Fund 135 Totals: ------------------------------------------------------------------------------------------------------ 456,163.36 .00 Budgeted (456,163.36) Remaining 0 % Used Municipal Utility District No 1 Fire Department O & M Interim Balance Sheet Balance @ 3/31/2013 ASSETS ASSETS CASH IN BANK (71,968)$ * INVESTMENTS 1,148,648 ACCOUNTS RECEIVABLE - ADVALOREM TAXES 33,189 ACCOUNTS RECEIVABLE - PID EMER SERVICES 5,507 OTHER RECEIVABLES 24,656 TOTAL ASSETS 1,140,032$ LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE 38,697$ ACCOUNTS PAYABLE 146,273 TOTAL LIABILITIES 184,970$ FUND BALANCE UNASSIGNED FUND BALANCE 955,062 TOTAL LIABILITIES AND FUND BALANCE 1,140,032$ * Texpool Transfer to cover March Accounts Payable and Payroll not completed until April. March 31, 2013 6/12 Months (50% of Fiscal Year) . glbase_tbam rgonzale Trophy Club MUD #1 Page 16 14:59 04/11/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 Property Taxes 196,940.00- 196,940.00- 1,657.59- 195,065.68- 99.048 1,874.32- 533-40002-000-000 Property Taxes/Delinquent 3,900.00- 3,900.00- 84.77- 2,364.65- 60.632 1,535.35- 533-40015-000-000 Property Taxes/P & I 5,017.00- 5,017.00- 140.41- 1,211.46- 24.147 3,805.54- Subtotal: 205,857.00- 205,857.00- 1,882.77- 198,641.79- 96.495 7,215.21- 533-48005-000-000 Reserve Funds/PID Utility Fees 345,000.00- 345,000.00- 345,000.00- Subtotal: 345,000.00- 345,000.00- 345,000.00- 533-49010-000-000 Interest Income 1,700.00- 1,700.00- 46.43- 164.28- 9.664 1,535.72- 533-49015-000-000 Lease/Rental Income 308,000.00- 308,000.00- 308,000.00- 100.000 Subtotal: 309,700.00- 309,700.00- 46.43- 308,164.28- 99.504 1,535.72- Program number: 860,557.00- 860,557.00- 1,929.20- 506,806.07- 58.893 353,750.93- Department number: Revenues 860,557.00- 860,557.00- 1,929.20- 506,806.07- 58.893 353,750.93- Revenues Subtotal ----------- 860,557.00- 860,557.00- 1,929.20- 506,806.07- 58.893 353,750.93- . glbase_tbam rgonzale Trophy Club MUD #1 Page 17 14:59 04/11/13 Budget Summary with Amendment Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 3/2013 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-70005-051-000 Paying Agent Fee 4,000.00 4,000.00 1,000.00 25.000 3,000.00 533-70025-051-000 Bond Interest Expense 229,033.00 229,033.00 114,516.25 50.000 114,516.75 533-70035-051-000 Bond Principal Payment 605,000.00 605,000.00 605,000.00 Subtotal: 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Program number: 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Department number: Administration 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Expenditures Subtotal ----------- 838,033.00 838,033.00 115,516.25 13.784 722,516.75 Fund number: 533 MUD 1 I&S CONSOLIDATED 22,524.00- 22,524.00- 1,929.20- 391,289.82- 1,737.213 368,765.82 ******* End of Report ********* . glpdatb2 rgonzale Trophy Club MUD #1 Page 59 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-40000-000-000 Property Taxes 1198 03/01/2013 Property Taxes/Assessments (193,408.09) (32.83) (193,440.92) GL 1200 03/04/2013 Property Taxes/Assessments (103.26) (193,544.18) GL 1201 03/05/2013 Property Taxes/Assessments (455.08) (193,999.26) GL 1203 03/06/2013 Property Taxes/Assessments (18.30) (194,017.56) GL 1205 03/07/2013 Property Taxes/Assessments (6.65) (194,024.21) GL 1207 03/08/2013 Property Taxes/Assessments (30.32) (194,054.53) GL 1208 03/11/2013 Property Taxes/Assessments (162.58) (194,217.11) GL 1209 03/12/2013 Property Taxes/Assessments (173.79) (194,390.90) GL 1211 03/13/2013 Property Taxes/Assessments (114.42) (194,505.32) GL 1212 03/14/2013 Property Taxes/Assessments (1.55) (194,506.87) GL 1213 03/15/2013 Property Taxes/Assessments (167.41) (194,674.28) GL 1216 03/19/2013 Property Taxes/Assessments (36.35) (194,710.63) GL 1217 03/21/2013 Property Taxes/Assessments (28.70) (194,739.33) GL 1219 03/22/2013 Property Taxes/Assessments (38.86) (194,778.19) GL 1220 03/25/2013 Property Taxes/Assessments (41.04) (194,819.23) GL 1220 03/25/2013 Property Taxes/Assessments (85.19) (194,904.42) GL 1221 03/27/2013 Property Taxes/Assessments (82.88) (194,987.30) GL 1222 03/28/2013 Property Taxes/Assessments (78.38) (195,065.68) GL _______________ Account: 533-40000-000-000 Property Taxes Totals: (1,657.59) (195,065.68) ** (196,940.00) Budgeted (1,874.32) Remaining 99 % Used Account: 533-40002-000-000 Property Taxes/Delinquent 1198 03/01/2013 Property Taxes/Assessments (2,279.88) (54.70) (2,334.58) GL 1213 03/15/2013 Property Taxes/Assessments (81.38) (2,415.96) GL 1220 03/25/2013 Property Taxes/Assessments 2.93 (2,413.03) GL 1221 03/27/2013 Property Taxes/Assessments 51.31 (2,361.72) GL 1222 03/28/2013 Property Taxes/Assessments (2.93) (2,364.65) GL _______________ Account: 533-40002-000-000 Property Taxes/Delinquent Totals: (84.77) (2,364.65) ** (3,900.00) Budgeted (1,535.35) Remaining 61 % Used Account: 533-40015-000-000 Property Taxes/P & I 1198 03/01/2013 Property Taxes/Assessments (1,071.05) (14.42) (1,085.47) GL 1200 03/04/2013 Property Taxes/Assessments (3.33) (1,088.80) GL 1201 03/05/2013 Property Taxes/Assessments (33.95) (1,122.75) GL 1203 03/06/2013 Property Taxes/Assessments (1.28) (1,124.03) GL 1205 03/07/2013 Property Taxes/Assessments (.47) (1,124.50) GL 1207 03/08/2013 Property Taxes/Assessments (2.73) (1,127.23) GL 1208 03/11/2013 Property Taxes/Assessments (9.07) (1,136.30) GL . glpdatb2 rgonzale Trophy Club MUD #1 Page 60 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: Revenues Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) 1209 03/12/2013 Property Taxes/Assessments (1,071.05) (14.58) (1,150.88) GL 1211 03/13/2013 Property Taxes/Assessments (4.05) (1,154.93) GL 1212 03/14/2013 Property Taxes/Assessments (.14) (1,155.07) GL 1213 03/15/2013 Property Taxes/Assessments (35.38) (1,190.45) GL 1217 03/21/2013 Property Taxes/Assessments (.17) (1,190.62) GL 1220 03/25/2013 Property Taxes/Assessments (1.23) (1,191.85) GL 1220 03/25/2013 Property Taxes/Assessments (6.54) (1,198.39) GL 1221 03/27/2013 Property Taxes/Assessments (4.14) (1,202.53) GL 1222 03/28/2013 Property Taxes/Assessments (8.93) (1,211.46) GL _______________ Account: 533-40015-000-000 Property Taxes/P & I Totals: (140.41) (1,211.46) ** (5,017.00) Budgeted (3,805.54) Remaining 24 % Used Account: 533-48005-000-000 Reserve Funds/PID Utility Fees .00 .00 _______________ Account: 533-48005-000-000 Reserve Funds/PID Utility Fees Totals: .00 .00 ** (345,000.00) Budgeted (345,000.00) Remaining 0 % Used Account: 533-49010-000-000 Interest Income 1197 03/31/2013 March Bank Interest (117.85) (46.43) (164.28) GL _______________ Account: 533-49010-000-000 Interest Income Totals: (46.43) (164.28) ** (1,700.00) Budgeted (1,535.72) Remaining 10 % Used Account: 533-49015-000-000 Lease/Rental Income (308,000.00) .00 (308,000.00) _______________ Account: 533-49015-000-000 Lease/Rental Income Totals: .00 (308,000.00) ** (308,000.00) Budgeted .00 Remaining 100 % Used Department Totals: ------------------------------------------------------------------------------------------------ (506,806.07) ** (860,557.00) Budgeted (353,750.93) Remaining 59 % Used . glpdatb2 rgonzale Trophy Club MUD #1 Page 61 15:00 04/11/13 Detailed Accounting Trial Balance Fund: 533 MUD 1 I&S CONSOLIDATED Department: 51 Administration Program: Period Ending: 3/2013 JE JE JE JE Detail Beginning Transaction Transaction Vendor_Name Check Source Number Date Description Description/Comment Balance Detail Detail Number (SUBTOTAL) Account: 533-70005-051-000 Paying Agent Fee 1,000.00 .00 1,000.00 _______________ Account: 533-70005-051-000 Paying Agent Fee Totals: .00 1,000.00 ** 4,000.00 Budgeted 3,000.00 Remaining 25 % Used Account: 533-70025-051-000 Bond Interest Expense 114,516.25 .00 114,516.25 _______________ Account: 533-70025-051-000 Bond Interest Expense Totals: .00 114,516.25 ** 229,033.00 Budgeted 114,516.75 Remaining 50 % Used Account: 533-70035-051-000 Bond Principal Payment .00 .00 _______________ Account: 533-70035-051-000 Bond Principal Payment Totals: .00 .00 ** 605,000.00 Budgeted 605,000.00 Remaining 0 % Used Department 51 Totals: ------------------------------------------------------------------------------------------------ 115,516.25 ** 838,033.00 Budgeted 722,516.75 Remaining 14 % Used Fund 533 Totals: ------------------------------------------------------------------------------------------------------ (391,289.82) (22,524.00) Budgeted 368,765.82 Remaining ########## Grand Totals: --------------------------------------------------------------------------------------------------------- (501,592.23) **** (22,524.00) Budgeted 479,068.23 Remaining ########## ******* End of Report *********