WINGS Navigation for Grants. Business and Fiscal Officers Meeting February 15, 2011 Presented by: Danielle Booth and Elaine Davis Research and Sponsored Programs. How to read your grant in WINGS Express. How to navigate within WINGS Express.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Business and Fiscal Officers Meeting
February 15, 2011
Danielle Booth and Elaine Davis
Research and Sponsored Programs
How to navigate within WINGS Express.
How to see the grant attributes and what this means.
What should be displayed to properly read your budget.
What do the columns represent.
How to determine what the true available balance is.
How to determine how much was spent during a particular period.
How to see expense details.
How to correctly write a JV.
My grant is overspent, now what?
This detail provides information about the award such as the F&A that is assessing, the start date and end date, if there is cost share required, the default org, program code for FOP, the grants accountant to contact and more.
$3,840,959.73- $2,887,826.38- $549,108.18= $404,025.17
This calculation is helpful when there are budgeted capital that is not spent exactly as planned or are spent without a budget; (the F&A encumbrance will distort the available balance of directs). However, please note that this formula will not work when there are expenses that have not yet posted. F&A encumbrance is a CATS calculation since Banner was unable to provide WSU with this feature. CATS simply wrote the script to take : Budget F&A – Year to Date F&A = Encumbrance for F&A. Please contact RSP for confirmation of the available balance.
Facilities and Administrative (F&A) Cost Rates
How to ensure the F&A calculated is correct.
This grant is assessing 45% on modified total direct costs (MTDC).
In the month of October this grant spent $83,987.35
The training will include how to setup this query.
A max of 100 rows will be displayed in each window, select ‘Next 100’ to display more of the transactions.
‘Download’ the detail into Excel for sorting.
Results show the fund, org and program code needed.
The ‘Query Results’ adds the column to the left of the ‘Account’. If there is a fund assigned under the grant this is where you will see it. If there is no fund assigned the ‘Fund’ column will remain the same number as the grant.
Can anyone tell me what these charges are for?
How do these expenses benefit the grant?
If you can’t, no one can.
ESPECIALLY the auditors (they are the eyes and ears of the grantor).
Reconciling the grant each month will reduce the lengthy JV’s needed and will keep WSU cash flow current, as well as the grantor’s.
Sponsors are looking more and more at the consistency of expenses throughout the life of the grant.
Auditors are starting to compare progress reports with expenses to see if there is a disconnect.
Check the expenses that posted in the ‘Year to Date’.
See if there are any charges that do not belong to this grant. Ex: Credit card transaction that posted is really for a different grant.
Payroll posted but not for within the grant period? Ex: Grant ended 9/30/10 but payroll for 10/31/10 posted. A salary redistribution is needed to fix this.
Check transaction detail by selecting the periods that are after the grant end date to the current date, i.e. if the grant ended 9/30/10 and the current date is 11/18/10, select period 04 and period 05 and then download to sort. Expenses purchased after the end date of the grant are not permitted.
Do not be confused with encumbrance column, especially with payroll encumbrances. These are removed after the payroll run (usually once a month), if all reallocations/corrections are processed.