This Budget Submission Spreadsheet to be used for all FRS Accounts with a first digit of 3 or 4, excluding Office for Sponsored Programs Administered Accounts. (See FRS Screen 6 – Grant/Contract field. If this field equals a G, C, or S, the account is Office for Sponsored Programs Administered.) Each School/College/Unit’s operating budget should balance on an annual basis. Any spending plan that relies on substantial use of prior year fund balance will be subject to review.

1. Login using your TAS (timecard) ID and Password.

2 .Click on Spreadsheet View.

3. Click on New Excel Import.

4. Right click the Spreadsheet link, choose Save Target As . . . and save the file to your computer. Open it and choose Enable Macros if prompted.

5. Data enter or copy and paste your budget submission information into the template. You will need to enter each frsacct/subcode in a different row.

IMPORTANT - DO NOT LEAVE ANY BLANK ROWS BETWEEN THE HEADER AND THE END OF YOUR DATA.

REVENUES – Please do not include prior year fund balance or anticipated fund balance transfers, as revenue sources.

EXPENDITURES – Include all expenditures that will occur during the fiscal year, using inflationary guidelines for collective bargaining increases and fringes cost estimates:

a. Include expenditures related to encumbrances that will be carried forward from the prior year.
b. Include all expenditure projections for Personal Services, providing line item budgets for temp labor (1030), student labor (1040), overtime (1070), and grad assistants (1150). All permanent, continuing personal services will draw from the 1000 pool. Include expenditure projections for Fringe Benefits and Workers’ Compensation corresponding to all Personal Services, as these will be encumbered in FRS at the start of the fiscal year.

7. Once the file is complete and validated, resave the file to your computer.

8. Then choose the Browse button. Find the file you just saved and click Open.

9. Click Import into BSF. This submits your file to the Budget Office.

10. To view your submissions, click Expand All.

11. You will be able to track your entry by clicking on the appropriate view, (Submitted, Approved, or Exported). The data will not be entered into FRS until the first day of next fiscal year.


If you have questions concerning the preparation of this spreadsheet, please contact Heather Postler at 486-2556 or EMail