Related Links

WISER User Reference

Page Updated: December 7th, 2018

WISER is replacing WISDM as the new web-based reporting system. Data in WISER comes from the Shared Financial System (SFS), and the Human Resource System (HRS). This system contains transaction as well as demographic data on projects and grants and allows exporting of data into multiple formats for review and analysis.

Highlights of WISER Projects for Grants Management

Manage Tiles and Groups
1. When logging into WISER, if no tiles or groups have yet been added, this is the screen that will be visible to users:
Welcome to WISER
2. To search for available items for Projects; click on Main Menu, then on Projects.
WISER - Main Menu - Projects
3. Available paths under projects are now viewable, and each includes an option to Pin to Dashboard. In the example below, this is clicked under the “Find Award/Projects” tile.
WISER - Find Awards/Projects
4. You will be prompted for a tile group and a name for that group. In this example, there are no existing groups, so we are creating a new group and titling it “Grants and Contracts”. Then, click on the blue “Pin” button. A pop-up message will appear indicating that the Tile has been pinned and that the Tile Group has been created.
WISER - Pin Tile to Dashboard WISER - Pin Tile to Dashboard with Group Name WISER - Pin Tile to Dashboard - Success
5. Now when you click on the Home icon - - you will see your group as a tab and your tile pinned within that group.
WISER - Group as Tab
6. Create groups and add tiles as needed.
WISER - Groups and Tiles
7. Tiles can be deleted (unpinned) by hovering over the tile until the X appears and then clicking on that X.
WISER - Removing Tiles
8. Groups can be renamed or deleted by clicking on the tab for that group, and then clicking on the blue gear dropdown for option selections.
WISER - Renaming/Deleting Groups
Award and Project Information
Find Awards/Projects Search
1. Use the Find Awards/Projects tile to search for awards and projects using an array of criteria. In the example below, the user has entered the Award ID. Searches can be run to find all awards for a particular department, a specific PI, etc. or a combination of a number of criteria.
WISER - Find Awards/Projects
2. In the example search, MSN214394 is entered, and results of the search are below:
WISER - Example Search Results

Options from this page:

  1. The data view can be changed using the "Balance Type" and "Financials as of" dropdowns.
  2. The data displayed can be reordered by clicking on the column headings.
  3. Projects can be added by individually checking the "In My Projects" check boxes, or all projects can be added by clicking on the "Add all to My Projects" button.
  4. The search results can be pinned using the "Pin to Dashboard" option.
  5. The search results can be exported to excel.
  6. Clicking on Investigator name runs a search for all awards for that investigator.
  7. Clicking on Dept ID runs a search for all awards for that department.
  8. To view Award level data, click on MSN number of award.
  9. To view project level data, click on project number.
Award Level Information
1. Clicking on the MSN number will open summary information at the award level. From this page, you can pin the award to your dashboard, add the award to your My Awards collection, or export the data.
WISER - Award Level Information
Project Inclusion
1. By default, this view will include data for all of the projects under that award. In this example, the award includes 5 projects. Clicking on “All 5 Selected” will allow the user to change the selection of projects included in the award view (see below). The project in the darkest font (AAC8911) is the primary project for the award. Those in lighter gray font (AAC8914) are projects that are no longer in open status. In the example below, the project status for AAC8914 is “Closed – Adjustments only”.
WISER - Project Inclusion 1
2. Users can also utilize Period selectors to view data within a specified period. In the example, we are viewing all data since the inception of the award through July 2018.
WISER - Project Inclusion 2
Financials
Summary View
1. The Financials tab displays award level information for the projects and period selected. There are three major views available; the default view is Summary, which displays combined financial data for all projects on the award. The columns include the total cumulative budget for the award, the Month-to-Date (MTD) expenses, the total posted expenses (Actuals), any encumbrances and the balance.
2. From here all dollar values in blue are hyperlinks, which allow the user to drill into more details on those amounts.
WISER - Dollar Amount Hyperlinks
3. By default, the data is displayed with the "Budget Category" setting, but this can be changed to exclude encumbrances or to show direct dollar amounts only.
WISER - Default Data View - Budget Category
4. To see financial information displayed with more detail in the summary, move the detail slider to the right.
WISER - Detail Slider
5. This will display information summarized by account code within each category.
WISER - Summarized by Account Code
Transaction Detail
1. All dollar values in blue are hyperlinks, which allow the user to drill into more details on those amounts.
WISER - Transaction Details
2. In the example above, the $1,103.95 hyperlink is clicked to reveal the details of that amount (below).
WISER - Transaction Details of Amount
3. In the upper right of the drill, Transaction Detail Window Functions, enables Minimize, Maximize and Close of the detail window. The Transaction Detail Gear Menu menu allows the user to:
3a. Export the data to excel
WISER - Export to Excel
3b. Customize the columns shown in the detail view
WISER - Customize Shown Columns
3c. Change the number of records showing on the page and Toggle the Payroll Detail Display
WISER - Changing Number of Records Shown
4. The drop down options to the right of the Transaction Detail Gear Menu menu include data view options of Standard, AP and Salary/Fringe which modifies the columns in the view.
WISER - Table View Options
5. Within the transaction lines themselves, there may be additional links that can lead to more information. In this example, the JRNL ID JRT0240268 is a hyperlink which leads to the related accounting journal.
WISER - Transaction Line Details WISER - Accounting Journal
Cost Transfer Initiation
1. Cost transfers can now be initiated right from the transactions line in WISER. When clicking on the WISER - Transaction Line Magnifying Glass icon in the last column of the desired transaction line, a message box will appear:
WISER - Cost Transfer Tool
2. To initiate a cost transfer for that transaction line, click on the Cost Transfer Tool box, and the Cost Transfer Tool will open with that transfer in the basket.
WISER - Cost Transfer Tool - Basket
Calculator Feature
1. Clicking on the calculator button on the upper right, offers an option to run a total from the amounts in the summary. In the example below, the calculator has been enabled, and the academic salary account codes are included. The amounts are included in a sum, and are averaged.
WISER - Calculator Feature
Projects View
1. The default view under the Financials tab is the Summary view, but the view can be changed to Projects by clicking on that option within the Financials tab. This view is helpful to see all projects separately instead of combined into the award summary. The same Budget Category selections are available for the user at the Projects view.
WISER - Projects View
Period Summary
1. The Period Summary option combines activity by month for the award (selected projects). Again, all dollar values in blue are hyperlinks, which allow the user to drill into more details on those amounts. Additionally, the calculator option is available for any on-page calculations.
WISER - Period Summary
AR
1. The AR tab contains accounts receivable information for the award. Users can limit search results using the check boxes to view only open AR, only closed AR, or leave both checked to view all AR created for that award.
WISER - Accounts Receivable
Personnel
1. The Personnel tab lists all salary/stipend information paid from the award. At the award level, information is included for all projects under that award. The example below is from the award level view, because we can see lines for two different projects. At the project level view, only information specific to that project would be included.
WISER - Personnel
Award Modifications
1. The Award Modifications tab lists changes that have been made to the award, such as funding increases or decreases, no-cost extensions, or future funding entries. The example below includes a funding change, and a future funding entry.
WISER - Award Modifications
Requirements
1. The Requirements tab lists selected Terms and Conditions for the award, and any Certifications (if applicable). Terms and Conditions may include Equipment Title designation (with UW or with Sponsor), or may highlight that there are special invoice instructions.
WISER - Requirements
Cost Share
1. The Cost Share tab displays he payroll cost share schedule for a project and related calculated cost share expenditures.
WISER - Cost Share
Documents
1. The Documents tab lists available .pdf documents for that award/project. The top section includes invoices that have been generated for the award, but this will not apply for all sponsors.
WISER - Documents
WISPER
1. The WISPER tab lists any WISPER records that were created and connected to the award.
WISER - WISPER
Project Level Information
Navigation
1. Following a Find Awards/Projects search, data will be displayed as shown below for awards with multiple projects:
WISER - Find Awards/Projects Search Results
2. For awards with only one project (in the example below, MSN208339), the search opens the main award summary page. In these cases, click on the Projects button, and then the project hyperlink, to open the same project summary view.
WISER - Find Awards/Projects Search Results
Financials

1. The Financials tab for the project level is similar to the information displayed at the award level, but is limited to the selected project.

2. The project can be pinned to the dashboard, added to a My Projects collection, or the data can be exported, using the links in the upper right.

3. The Award Level data can be viewed by clicking on the WISER - View Award Level Information Button icon. To open the Award Summary page, click on the Award ID hyperlink.

WISER - Project Level Financial Information
Account Codes Highlight Feature
1. WISER offers an easier way to identify F&A exclusions at the project level. To view all account codes that are omitted from F&A calculations, move the Detail slider all the way to the right to see account codes on the summary. Click on WISER - Icon View Options to verify that "F&A Exclusions" is checked.
WISER - Detail Slider WISER - F&A Exclusions checked
2. In this example, reviewing data at the regular category level, we see Equipment and Tuition and Fees are highlighted.
WISER - Category Level View
3. When the slider is moved to the highest level of detail, you can now see that some excluded amounts exist under the Other Expenditures category also. This would not be clear if we only viewed data at the category level.
WISER - View Other Expenditures
Personnel
1. At the projects level, the Personnel tab lists all salary/stipend information paid from the selected project only. At the award level, information is included for all projects under that award.
WISER - Personnel
Award Modifications
1. The Award Modifications tab lists changes that have been made to the award, such as funding increases or decreases, no-cost extensions, or future funding entries. The example below includes a funding change, and a future funding entry.
WISER - Award Modification Tab
Requirements
1. The Requirements tab lists selected Terms and Conditions for the award, and any Certifications (if applicable). Terms and Conditions may include Equipment Title designation (with UW or with Sponsor), or may highlight that there are special invoice instructions.
WISER - Project Level Requirements
Edits
1. The Edits tab displays the valid chart fields (fund, department, and program) for a project. This information is needed when using the project to purchase supplies, create purchase orders, set up salary payments, etc.
2. In almost all cases, a project will have one valid fund, but it could have a number of valid departments and/or valid programs.
3. In the 144 project example below, only department 481500 and program 4 are valid.
WISER - Example Search Results
Cost Share
1. If Cost Share is associated with a project, the schedule and calculated expenditures can be found under the Cost Share tab.
WISER - Project - Cost Share
Documents
1. The Documents tab lists available PDF documents for that award/project. The top section includes invoices that have been generated for the award, but this will not apply for all sponsors.
2. The lower section, "Other Documents" may include award notices received from the sponsor, modifications, budgets, subaward information, etc.
WISER - Project - Documents
RAMP/WISPER
1. The WISPER tab lists any WISER records that were created and connected to the award.
WISER - Project - WISPER
Building a My Projects or My Awards Collection
1. When monitoring a specific set of projects or awards, users may find value in creating a My Projects or My Awards collection in WISER. To search for projects and awards of interest, click on Main Menu then on Find Award/Projects.
WISER - My Awards - Find
1a. Use the Find Awards/Projects page to search for awards and projects using an array of criteria. In this example, the user is searching for all projects with Fund 133 for the Department ID 481500, with a Project Status of 1-Open.
WISER - My Awards - Search Criteria
1b. The search results page offers two ways to add the results to My Projects.
  • To select individual projects, click in the check box to the right of the project under the "In My Projects" column.
  • To add all of the search results to My Projects, the user can click on the "Add all to My Projects" button.
WISER - Add to My Projects - Individual
2. When a user selects or deselects a project, a small informational window highlights the change. Once all projects of interest have been added to My Projects, the user can click on My Projects button to view the list, or navigate from Main Menu and then My Projects.
WISER - Selecting/Deselecting Projects
3. Projects are listed individually and are grouped and summed by fund. To find more projects, users can click on Search for Projects button from this screen, or clear out the My Projects collection by clicking on "Remove all from My Projects". To rearrange or remove individual projects, the user can hover on a project line to access options.
WISER - Viewing My Projects Collection
4. To build a My Awards collection, users would start similarly, with the Find Awards/Projects Search.
WISER - Find Awards/Projects
4a. From the search results page, users can click on the Award ID for the item of interest to open the Award Summary page.
WISER - Find Awards/Projects - Results
4b. Once on the Award Summary page, the option Add to My Awards button is available.
WISER - Award Summary
4. To build a My Awards collection, users would start similarly, with the Find Awards/Projects Search.
WISER - Find Awards/Projects
5. To view the My Awards collection, click on Main Menu, then on My Awards. Items are listed by award, without the project detail, grouped and summed by fund.
6. To find more projects or awards, users can click on Search for Awards button from this screen, or clear out the My Awards collection by clicking on "Remove all from My Awards". To rearrange or remove individual awards, the user can hover on an award line to access options.
WISER - My Awards Collection
Award Modifications Search
1. To run an award modification search, select the option from Main Menu Projects Award Modifications Search.
WISER - Award Modifications Search
2. Enter search parameters for the search. In the example below, the search is limited to the Funding Action Type of Funding Change for the department ID starting with 4815, with Funding Action Issue Dates between 1/1/2018 and 8/31/2018 for the PI Randall Goldsmith. Click on the Search button.
WISER - Award Modifications Search Criteria
3. Search results can be sorted by any of the column headings.
WISER - Award Modifications Search Results
4. Clicking on the ID in the first column will open the award summary connected to the corresponding award modification.
WISER - Award Summary
RAMP/WISPER Search
1. To run RAMP/WISPER search, select this option from Main Menu Projects RAMP/WISPER Search.
WISER - WISPER Search
2. Enter search parameters for the search. In the example below, the search is limited to RAMP/WISPER submissions after 6/1/2018 for the department ID starting with 4185, for the PI Robert Hamers. Click on the Search button.
WISER - WISPER Search Criteria
3. Search results can be sorted by any of the column headings.
WISER - WISPER Search Results
4. If the Record ID is a blue hyperlink, clicking this will open the award summary connected to that RAMP/WISPER record.
WISER - WISPER Search - Award Summary
Accounts Receivable Search
1. To run an Accounts Receivable search, select this option from Main Menu Projects AR Search.
WISER - AR Search
2. Enter parameters for the search. Users can use the Status filter to limit search to only Open AR items, only Closed AR items, or leave it blank to search for both statuses.
WISER - AR Search Criteria
3. Search results can be sorted by any of the column headings.
WISER - AR Search Results
4. If the Invoice ID is a blue hyperlink, clicking this will open more detail on that item below.
WISER - AR Search Results - More Detail
5. Users can also click on the Entry Amount hyperlink to drill into more information.
WISER - AR Search Results - Amount - More Detail
Accessing Award Documents in WISER
Summary:
All new documents can be found by clicking the Award ID hyperlink on the Documents tab in WISER. Older documents are available under the "Other Documents" section of both the WISDM and WISER Documents tab.
1. Current documents are available in WISER by clicking the Award ID link.
WISER - Document Link
2. If current documents are available, a list of documents will appear in a separate tab or window.
WISER - Document Display
3. If no current documents are available, a separate tab or window will appear.
WISER - No Documents Available Alert
4. See the troubleshooting steps if you receive an error message similar to the following:
WISER - Error Notification Dialog
Troubleshooting:

If you are unable to access award documents by using the instructions above, please review the following:

  1. Make sure you've connected to VPN if you're working off campus.
  2. Try accessing the documents in a different browser.
  3. Restart your computer.
  4. If you still can't access the documents, send an email to: era@rsp.wisc.edu