Topics Map > Accounting > Service Activities

System Government Costing - SERFS Combined: Populating the Service Activity Rate Template

Guide to populating the service activity rate template using the SERFS Combined financial report.

To complete the tabs in the Service Activity Rate Calculation Template, you will need to either run individual financial reports for the last completed fiscal year, or use the SERFS Combined report to pull your fund data in a single Excel workbook. See the System Government Costing - SERFS Combined Running the Webi Report job aid for detailed instructions on pulling the financial data.

Note: You will need to run the Equipment Depreciation report provided by SGC (System Government Costing) in addition to the SERFS Combined report to complete all tabs of a rate calculation workbook. Equipment Depreciation data is recorded in the university financial systems at the organization level rather than the fund level, therefore it does not pull as part of the relevant fund's SERFS report. Job aids for running the Equipment Depreciation webi and populating the Equipment Depreciation tabs of the Service Activity Rate Calculation Template are available from SGC.

To populate the Service Activity Rate Calculation Template with data from the SERFS Combined report, follow these steps:

  1. Locate and Open your saved excel file with fund data from the SERFS Combined Webi report.
  2. Note that there are 10 tabs in this workbook, most of which have similar names to the tabs in the Service Activity Rate Calculation Template.
  3. The following tabs are helpful for analysis and reference purposes; however, they do not generally contain the data you'll need to paste into the Service Activity Rate Calculation Template.
    1. SERFS Summary - Provides fund number, code, name, etc... as well as summary financial information.
    2. Fund Balance History - Provides a historic year end snapshot of the fund's balance, total expenditures and total revenue.
    3. Revenue Detail - Provides transaction level detail for revenue related transactions (based on account code) for the fiscal year.
    4. Spon Proj Summary - A summary of charges to all and 4A specific sponsored projects during the fiscal year.
  4. The remaining tabs all correspond directly to the data that was pulled using individual Webi reports for Expenditures, Salaries and Wages, and the Fund Balance.To populate the Service Activity Rate Calculation Template with data from these tabs, reference the detailed job aids for the corresponding tabs.
    1. Expenditures Detail and Expenditures Summary tabs - See System Government Costing - Expenditures and Transfers: Populating the Service Activity Rate Template
    2. Salaries Detail and Salaries Summary by UIN tabs - See System Government Costing - Salaries and Wages: Populating the Service Activity Rate Template
    3. Fund Balance tab - See System Government Costing - Fund Balance: Populating the Service Activity Rate Template
  5. When you have finished adding data to the Service Activity Rate Calculation template, click the Save button, or rename using Save As.
  6. You have now populated the template with financial data and are ready to start the rate calculation process.
  7. SGC offers extensive training for performing the actual rate calculation process. See "Training Available for Service Centers" on the Service Activities Resource page.


KeywordsGovernment Costing, Service Activities, Rate Calculation, 3E, Self Supporting   Doc ID134975
OwnerFred K.GroupUI Training and Development Resources
Created2024-01-23 15:07:56Updated2024-01-24 14:48:11
SitesUniversity of Illinois Training and Development Resources
Feedback  0   0