Draft of Summary Report Format for GPR funds

ACCOUNTING SUMMARY
FUND XXX ORGANIZATION XXXXXX
DRAFT
UNIVERSITY OF WISCONSIN - MADISON
MONTHLY ACCOUNTING SUMMARY
DIVISION - DEPARTMENT
YEAR TO DATE AS OF
 (COL 1) (COL 2) (COL 3) (COL 4) (COL 5) (COL 6) (COL 7)
PAYMENTS UNEXPENDED OPEN UNCOMMITTED PAYMENTS
 BUDGETS TO DATE BUDGET BALANCE ENCUMBRANCES BUDGET BALANCE THIS MONTH
(COL 1 - COL 2) (COL 3 - COL 4)
SALARIES
Academic Staff - Annual 1051 80,495.80 16,099.20 0.00
Unclassified Salary Budget SALUCL                 96,595.00 0.00 0.00
TOTAL UNCLASSIFIED SALARY                 96,595.00                 80,495.80 16,099.20                 16,099.20 0.00 0.00
Classified - Hourly 1531 1,466,560.18 62,000.00 61,541.25
Classified - Lump Sum 1532 1,626.55 150.00 68.20
Classified Project - Hourly 1533 146,932.83 8,000.00 7,676.88
Classified - 5th Week Vacation 1537 6,569.08 2,500.00 0.00
Classified - Overtime 1541 15,470.34 0.00 410.16
Classified Project - Overtime 1542 547.83 0.00 0.00
Classified - Differential 1543 591.86 0.00 25.36
Classified Salary Budget SALCLA            1,720,000.00 0.00 0.00
TOTAL CLASSIFIED SALARY 1,720,000.00 1,638,298.67 81,701.33 72,650.00 9,051.33 69,721.85
LTE - Hourly 1601 96,582.20 5,000.00 3,954.45
LTE - Overtime 1603 786.90 0.00 119.30
Student - Hourly 1771 77,617.40 0.00 3,584.65
Student - Overtime 1773 37.13 0.00 0.00
Work Study - Hourly 1781 66.88 0.00 0.00
LTE & Student Salaries Budget LTESTU               100,000.00 0.00 0.00 0.00
TOTAL LTE AND STUDENT SALARIES 100,000.00 175,090.51 (75,090.51) 5,000.00 (80,090.51) 7,658.40
Salary Permanent Budget SALPR 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL SALARIES            1,916,595.00            1,893,884.98 22,710.02                 93,749.20 (71,039.18)                      77,380.25
SERVICES & SUPPLIES
Travel-Employe-In State Bus 2100 13,459.68 0.00 1,761.70
Travel-Employe-In State-Conf 2115 8,618.36 0.00 1,375.00
Travel-Employe-Out State-Bus 2120 967.57 0.00 0.00
Travel-Employe-Out State-Conf 2130 14,000.76 0.00 525.00
Travel-Fleet Charges-Vehicles 2140 655.99 0.00 0.00
Telecomm Services-Centrex 2201 15,677.67 0.00 0.00
Telephone Service-NonSTS Tolls 2210 62.75 0.00 0.72
Telephone Service-Install, etc 2230 191.25 0.00 0.00
Telephone Service-STS 2240 1,419.34 0.00 164.97
Communication-Miscellaneous 2260 3,534.55 0.00 365.50
Lease of Equipment 2370 4,512.00 0.00 0.00
Maintenance & Repair-Other 2480 2,019.47 256.34 0.00
Services - Professional 2620 661.64 4,338.36 515.69
Services - Miscellaneous 2623 1,283.83 1,576.79 0.00
Services - Internal 2650 3,506.47 0.00 36.00
Printing & Duplicating-State 2670 3,217.52 4,207.84 550.70
Printing & Duplicating-NonStat 2675 2,581.85 0.00 0.00
Supplies 3100 35,166.25 0.00 2,401.46
Equipment & Furniture <$5,000 3195 2,564.08 0.00 0.00
Postage 3700 61,518.74 0.00 5,522.91
Freight 3710 243.18 0.00 9.98
Conference/Workshop Expenses 3780 979.75 325.00 48.75
Interest Expense-Prompt Pay 3805 710.48 0.00 0.00
Supplies & Expense Budget SPEXP               185,691.00 0.00 0.00 0.00
TOTAL SVCS & SUPPLIES               185,691.00 177,553.18 8,137.82 10,704.33 (2,566.51) 13,278.38
SALES CREDITS
Sales Credits-Internal 9050 (257.25) 0.00 0.00
Sales Credits-External 9051 (1,874.00) 0.00 (828.00)
TOTAL SALES CREDITS                            -   (2,131.25) 2,131.25 0.00 2,131.25 (828.00)
CAPITAL EXPENSES
Bldg. & attached 4520 40,000.00 0.00 0.00
Computer Equipment 4620 15,000.00 0.00 0.00
Capital Expense Budget CAPEX1                 60,000.00 0.00 0.00 0.00
TOTAL CAPITAL EXPENSES                 60,000.00 55,000.00 5,000.00 0.00 5,000.00 0.00
DEPARTMENT TOTAL            2,162,286.00 2,124,306.91 37,979.09 104,453.53 (66,474.44) 0.00 89,830.63
NON-BUDGETED EXPENDITURES
Fringe Benefits 715,951.26 15,914.77
Classified - Length of Service 1535 209.60 2,500.00 0.00

SFS Home

Updated June 5, 2002 by SFS Webmaster