Accessing Grant Information

 

Contents:

Current Balance and Overall Grant Financial Information
Details on Monthly Transactions
"Expired Grant Funds," "Grant Fund Balances," & "Terminated Grants" Reports
Cost Share Reports
Grant Closeout Reminder

Current Balance and Overall Grant Financial Information:

 

  1. Log on to Wings Express using your User ID and PIN.

 

  1. At the Main Menu, select Finance.

 

  1. At the Finance menu, select Query Budget.

 

  1. On the next screen, under ‘Budget Status by Account’ select Create Query.

 

  1. On the next screen, check ‘Adjusted Budget,’ ‘Year to Date,’ ‘Encumbrances,’ ‘Reservations,’ and ‘Available Balance,’ then select Continue.

 

  1. On the next screen, make sure the Fiscal Year field shows the current fiscal year (where, for example, any date within the period 7/1/2006-6/30/2007 would be fiscal year 2007) and that the Fiscal Period field shows the current month (where July = 1).  Comparison field should both say ‘None,’ and Chart of Accounts field should be ‘W.’ 
    • For awards with one grant/fund number:
      Type in your '66' grant number in the Grant field. All other fields should be blank. Always make sure that the "include revenue" button is unchecked, otherwise you will not see a balance available in the balance available column on the grant total line. Select Submit Query.
    • For awards with one grant number and multiple fund numbers (e.g., a grant that has been split into two expenditure pools to accommodate on-campus and off-campus portions; or a Research Challenge award where the prime grant from the Regents has a grant number and each individual sub-award has its own fund number):
      Type in the '66' grant number in the Grant field and your '66' fund number in the Fund field. All other fields should be blank. Always make sure that the "include revenue" button is unchecked, otherwise you will not see a balance available in the balance available column on the grant total line. Select Submit Query.

    Note: If you're not sure where to enter your '66' number, put it in the Index field and select Submit Query. This should fill in the correct fields. It might also fill in the Program field, so to be on the safe side you should delete any entry in this field. Select Submit Query again. The only problem with this method is that it will only show you fiscal-year-to-date information rather than grant-to-date information.

 

On this screen you should be able to “drill down” on any of the numbers except the ones in the 'Adjusted Budget' and ‘Available Balance’ columns.  You can drill down on any numbers that are green to obtain more information about what makes up the amount in green. You can drill down to the document for all transactions submitted electronically in Banner Finance. You can also download a query or a subset of a query to Excel, where it can be sorted and manipulated as needed.

 

  1. The next screen should show you your current balance. ALERT! Banner may not show a true balance available for your grant because of anomalies in the encumbering of salaries, fringe benefits, and overhead costs (F&A, account 799000). To get true balances available for salaries and fringe benefits, you will have to download the numbers into Excel, manually subtract the year-to-date expenditures in each salary/fringe line from the adjusted budget number in that line, and then subtract whatever salaries/fringes you expect to spend for the rest of the year. Then replace these balances in the Available Balance column for each salary/fringe line. Finally, to get a true balance available overall, manually add a negative F&A balance to, or subtract a positive F&A balance from, the total grant balance.

 

Banner provides no navigation buttons to go forward and back between screens—you just have to use the relevant buttons on your browser.

 

If you don't see any data when you query a grant, it could mean one of at least three things. One, there is no activity recorded on the grant. Two, you don't have access to the default orgn that has been assigned or used with respect to the transactions that have hit the grant. Three, you have entered a fund-only number in the grant field. Contact your college business manager for assistance.

 

Details on Monthly Transactions:

 

  1. At the bottom of any Banner screen, select WSU Finance Extensions.

 

  1. On the next screen, select Transaction Detail.

 

  1. Uncheck Adopted Budget and Budget Adjustment; select Continue.

 

  1. Enter/review the fiscal year, period, and grant number as above, step 6; select Submit Query.

 

  1. Beg Fiscal Year and End Fiscal Year fields should both be the current fiscal year.  Beg Fiscal Period and End Fiscal Period should be the month(s) that you want to report on (again, July = 1).  All other fields can be left alone.  Select Submit Query.

 

In the chart that comes up, expenditures (in the 3rd to last column) will show arranged by month (2nd column).  Any commitments will show up in the last and 2nd to last columns.  You can only “drill down” on the document code (3rd column) and doing this may or may not give you further useful information.  And you can download the data for manipulation in an Excel spreadsheet.

 

"Expired Grant Funds," "Grant Fund Balances," and "Terminated Grants" Reports [of interest to Business Managers]:

 

  1. Download Excel spreadsheet. The report has three tabs: one showing expired grant funds, one showing current grant fund balances, one showing terminated grants.

 

Cost Share Reports [of interest to Business Managers]:

 

  1. Fall 2013.
  2. Summer 2013.
  3. Spring 2013.
  4. Fall 2012.
  5. Summer 2012.


Return to I Got Funded! Page