User:
Printed: 03/18/2025 - 3:46PM
IWhippy
Summary Trial Balance
General Ledger
Period: 01 to 07, 2025
Include: Revenue and Expense
Account From: 520
Account To: 522
Account Number Description Budget Amount Beginning Balance Debit This Period Credit This Period Ending Balance Fund 520 Facilities Maint & Repair
REVENUE
520-0000-3498 Allocation - Int Serv Fund 288,547.72 0.00 0.00 0.00 0.00 520-0000-3611 Interest Earned 5,000.00 0.00 0.00 0.00 0.00 520-0000-3998 Misc Revenues 0.00 0.00 0.00 0.00 0.00
Dept 7999
520-7999-7999 Transfer from Other Funds 0.00 0.00 0.00 0.00 0.00 520-7999 REVENUE Totals: 0.00 0.00 0.00 0.00 0.00
REVENUE Totals: 293,547.72 0.00 0.00 0.00 0.00
EXPENSE
Dept 4393 Maint & Repair
520-4393-0319 Professional Services 32,007.67 0.00 5,387.50 5,387.53 -0.03 520-4393-0353 Facilities Maint & Repair 22,967.50 0.00 27,792.76 13,025.00 14,767.76 520-4393-0399 Admin Allocation 0.00 0.00 0.00 0.00 0.00 520-4393-0499 Depreciation-Facilities 0.00 0.00 0.00 0.00 0.00 520-4393-0801 Salary/Benefit Allocation 105,998.47 0.00 0.00 0.00 0.00 520-4393 EXPENSE Totals: 160,973.64 0.00 33,180.26 18,412.53 14,767.73 Dept 7999
520-7999-0799 Transfers to Other Funds 0.00 0.00 0.00 0.00 0.00 520-7999 EXPENSE Totals: 0.00 0.00 0.00 0.00 0.00
EXPENSE Totals: 160,973.64 0.00 33,180.26 18,412.53 14,767.73 GL-Summary Trial Balance (3/18/2025 - 3:46 PM) Page 1
Account Number Description Budget Amount Beginning Balance Debit This Period Credit This Period Ending Balance Fund 520 Totals:
132,574.08 0.00 33,180.26 18,412.53 14,767.73
Fund 521 Technology Maint & Repair
REVENUE
521-0000-3498 Allocation - Int Serv Fund 831,371.00 0.00 0.00 0.00 0.00 521-0000-3998 Misc Revenue 0.00 0.00 0.00 0.00 0.00
Dept 7999
521-7999-7999 Transfer from Other Funds 0.00 0.00 0.00 0.00 0.00 521-7999 REVENUE Totals: 0.00 0.00 0.00 0.00 0.00
REVENUE Totals: 831,371.00 0.00 0.00 0.00 0.00
EXPENSE
Dept 4390
521-4390-0623 PEG Operating Costs 0.00 0.00 0.00 0.00 0.00 521-4390-0741 Machinery & Equipment 0.00 0.00 0.00 0.00 0.00 521-4390 EXPENSE Totals: 0.00 0.00 0.00 0.00 0.00
Dept 4394 Maint & Replacement
521-4394-0101 Salaries & Wages, Regular 189,275.99 0.00 118,364.86 468.80 117,896.06 521-4394-0102 Overtime 1,985.52 0.00 0.00 0.00 0.00
521-4394-0103 Comp Time Payout 1,500.00 0.00 2,433.31 0.00 2,433.31 521-4394-0104 Vacation Payout 0.00 0.00 0.00 0.00 0.00
521-4394-0105 Sick Leave Payout 0.00 0.00 0.00 0.00 0.00 521-4394-0109 Other Wages 400.00 0.00 1,080.78 0.00 1,080.78 521-4394-0210 Misc Insurance Premiums & Fees 500.00 0.00 351.15 0.00 351.15 521-4394-0211 Medical Premium Contribution 20,678.84 0.00 12,232.73 0.00 12,232.73 521-4394-0213 Dental Premiums 1,364.16 0.00 646.11 0.00 646.11 521-4394-0214 Vision Care 436.80 0.00 258.03 0.00 258.03 521-4394-0220 Pers 15,031.69 0.00 8,935.99 38.35 8,897.64 521-4394-0221 Education Reimbursement 0.00 0.00 0.00 0.00 0.00 521-4394-0231 Workers' Comp Premium 3,773.13 0.00 7,881.94 0.00 7,881.94 521-4394-0252 FICA/Medicare 14,017.98 0.00 9,104.73 34.82 9,069.91 521-4394-0319 Professional Services 10,000.00 0.00 0.00 0.00 0.00 521-4394-0351 Equipment Repair & Maint 4,450.00 0.00 1,812.50 0.00 1,812.50 521-4394-0366 Training/Travel Reimbursement 9,760.00 0.00 5,444.00 0.00 5,444.00 521-4394-0381 Small Tools & Equipment 7,000.00 0.00 7,671.16 0.00 7,671.16 GL-Summary Trial Balance (3/18/2025 - 3:46 PM) Page 2
Account Number Description Budget Amount Beginning Balance Debit This Period Credit This Period Ending Balance 521-4394-0382 Hardware Exp 129,562.46 0.00 53,773.07 28.28 53,744.79 521-4394-0383 Software Exp 39,500.00 0.00 2,744.00 0.00 2,744.00 521-4394-0384 Licensing, Software & Maint 341,957.88 0.00 184,088.19 14.14 184,074.05 521-4394-0399 Admin Cost Allocation 0.00 0.00 0.00 0.00 0.00 521-4394-0499 Depreciation 0.00 0.00 0.00 0.00 0.00
521-4394-0619 Miscellaneous Exp 0.00 0.00 180.45 0.00 180.45 521-4394-0741 Machinery & Equipment 0.00 0.00 0.00 0.00 0.00 521-4394-0801 Salary/Benefit Allocation 7,992.05 0.00 0.00 0.00 0.00 521-4394 EXPENSE Totals: 799,186.50 0.00 417,003.00 584.39 416,418.61 Dept 7999
521-7999-0799 Transfer to Other Funds 0.00 0.00 0.00 0.00 0.00 521-7999 EXPENSE Totals: 0.00 0.00 0.00 0.00 0.00
EXPENSE Totals: 799,186.50 0.00 417,003.00 584.39 416,418.61 Fund 521 Totals:
32,184.50 0.00 417,003.00 584.39 416,418.61
Fund 522 Fleet Services
REVENUE
522-0000-3498 Allocation - Int Serv Fund 773,541.00 0.00 0.00 0.00 0.00 522-0000-3998 Misc Revenue 500.00 0.00 0.00 0.00 0.00
Dept 7999
522-7999-7999 Transfer from Other Funds 0.00 0.00 0.00 0.00 0.00 522-7999 REVENUE Totals: 0.00 0.00 0.00 0.00 0.00
REVENUE Totals: 774,041.00 0.00 0.00 0.00 0.00
EXPENSE
Dept 4550 Fleet Services
522-4550-0101 Salaries & Wages, Regular 69,023.58 0.00 37,948.16 163.49 37,784.67 522-4550-0102 Overtime 2,969.74 0.00 743.08 0.00 743.08 522-4550-0103 Comp Time 995.53 0.00 0.00 0.00 0.00
522-4550-0104 Vacation Payout 0.00 0.00 0.00 0.00 0.00
522-4550-0105 Sick Leave Payout 0.00 0.00 0.00 0.00 0.00 522-4550-0109 Other Pay 0.00 0.00 0.00 0.00 0.00
GL-Summary Trial Balance (3/18/2025 - 3:46 PM) Page 3
Account Number Description Budget Amount Beginning Balance Debit This Period Credit This Period Ending Balance 522-4550-0210 Misc Insurance Premiums & Fees 164.90 0.00 153.77 0.00 153.77 522-4550-0211 Medical Premium Contribution 21,660.43 0.00 12,611.20 0.00 12,611.20 522-4550-0212 Uniforms 0.00 0.00 0.00 0.00 0.00
522-4550-0213 Dental Premiums 1,154.40 0.00 538.72 0.00 538.72 522-4550-0214 Vision Care 218.40 0.00 127.40 0.00 127.40 522-4550-0220 Pers 5,818.57 0.00 3,115.81 13.37 3,102.44 522-4550-0231 Workers' Comp Premium 1,452.70 0.00 14,515.76 0.00 14,515.76 522-4550-0232 Worker's Comp Deductible 0.00 0.00 0.00 0.00 0.00 522-4550-0252 FICA/Medicare 5,356.46 0.00 2,647.18 10.95 2,636.23 522-4550-0319 Professional Services 500.00 0.00 1,550.37 150.00 1,400.37 522-4550-0351 Equipment Repair & Maint 12,000.00 0.00 13,589.39 0.00 13,589.39 522-4550-0352 Vehicle Repair & Maint 75,000.00 0.00 14,829.52 823.50 14,006.02 522-4550-0366 Travel/Training Reimbursement 5,000.00 0.00 0.00 0.00 0.00 522-4550-0375 General Supplies 2,000.00 0.00 7,840.60 0.00 7,840.60 522-4550-0381 Small Tools & Equipment 1,000.00 0.00 174.76 0.00 174.76 522-4550-0382 Fuel & Lubricants 104,000.00 0.00 40,041.61 658.36 39,383.25 522-4550-0383 Electric Charges 6,000.00 0.00 969.52 0.00 969.52 522-4550-0399 Admin Cost Allocation 0.00 0.00 0.00 0.00 0.00 522-4550-0499 Depreciation Exp 0.00 0.00 0.00 0.00 0.00 522-4550-0619 Mis Expenditures 0.00 0.00 0.00 0.00 0.00 522-4550-0741 Machinery & Equipment 0.00 0.00 0.00 0.00 0.00 522-4550-0742 Vehicles 361,675.75 0.00 51,471.25 0.00 51,471.25 522-4550-0801 Salary/Benefit Allocation 16,226.21 0.00 0.00 0.00 0.00 522-4550 EXPENSE Totals: 692,216.67 0.00 202,868.10 1,819.67 201,048.43 Dept 7999
522-7999-0799 Transfer to Other Funds 0.00 0.00 0.00 0.00 0.00 522-7999 EXPENSE Totals: 0.00 0.00 0.00 0.00 0.00
EXPENSE Totals: 692,216.67 0.00 202,868.10 1,819.67 201,048.43 Fund 522 Totals:
81,824.33 0.00 202,868.10 1,819.67 201,048.43
Report Totals: 246,582.91 0.00 653,051.36 20,816.59 632,234.77 GL-Summary Trial Balance (3/18/2025 - 3:46 PM) Page 4