...
| Excerpt |
|---|
Fiscal Panther Grants is a tools tool for reviewing and managing grant funding, spending, and projections for active grants. It pulls together data across PRISM, PBCS, and PERIS to provide account administrators a unified view of their budgets vs. actual spend and encumbrances at the RC, Department, and individual project level. |
Key Business Questions
This dashboard allows tracking of 05 grant account balances, spending, and projections from PBCS Grants Forecasting. Balances and spend can be view by department, grant, master account, and Primary Investigator. Individual transaction data can be viewed as well, including Panther Express Purchase Order data, credit card purchases, and Concur travel expenses. Answer questions like:
What is the current remaining balance on a PI’s grant? What is the remaining balance after PBCS projections?
Does my department have any projects that are over balance, or projected to be over balance?
What is the budget and actual spend on a grant by Subcode?
What SPAR distributions are on a grant?
How many awarded and proposed grants does a department or PI have?
What is the actual and projected spend of all Subawards in a project?
What are the invoice, check, PO or Concur details of a transaction?
What transactions have hit a grant, and which are projected to hit?
Which purchase orders have an encumbrance?
...
This dashboard has three tabs that can act as a starting point: Department Overview, Investigator Overview, or Master Account Profile. The other Other tabs will show no data until unless you navigate to it using one of the three mentioned tabs are used for navigation. Navigation between tabs occurs by clicking different items, and will be , as described in more detail below. Navigation actions will be denoted with a ▶️ icon.
| Info |
|---|
Every tab has a filter to allow for PBCS Forecasting Projections to be incorporated. |
Many some areas of this dashboard have export buttons, which will allow you to export the data to Excel.
...
This tab will show all departments you have access to, and summary Budget, Actual, Encumbrance, and Balance information. This can be used for a quick overview of departmental grant spending. You can select one or more departments from the filter to limit the data displayed. Clicking
▶️ Click on a department row will to navigate to the Department Profile tab.
...
Investigator Overview
This tab will show all PIs in your department, and summary Budget, Actual, Encumbrance, and Balance information. This can be used for a quick overview to see the status of PI grant spending. You can select one or more PIs from the filter to limit the data displayed. Clicking
▶️ Click on an investigator row will to navigate to the Investigator Profile tab.
...
This tab will show all master accounts in your departments, or all master accounts your departments' subaccounts are tied to. The top half shows all master and subaccount account balances and spending aggregated. Clicking Click on an account in the top half will populate the bottom half of the screen with data from the individual subaccounts. Clicking
▶️ Click on one of these account in the bottom half will take you to the accounts under the All Projects heading to open the Project Profile tab.
...
Department Profile
...
After navigating to this page from the Investigator Overview, you will see data on the PI’s active awarded projects on the top half of the screen, and data on proposals at the bottom half of the screen. There are some additional filters for the proposals: Proposal Status, and Award Status. Clicking
▶️ Click on a project in the Awarded portion of this tab will navigate to the Project Profile.
There is no navigation from the Proposal portion of this tab.
...
After navigating to this page from either the Master Account Profile, the Department Profile, or the Investigator Overview, you will see data on selected project.
▶️ Clicking on the ‘Click Click here for SPAR Details’ will Details button to navigate to the SPAR Details tab. Clicking
▶️ Click on a Subcode row on the bottom viz will navigate to in the Expenses by Type and Subcode section to open the Transactions tab.
...
SPAR Details
...
What is the source of this information?
There are many sources of data for this dashboard:
General Ledger Mart
Panther Express
Concur
PBCS Grants Forecasting
PRISM
All data are updated in the early morning with the previous day’s data. The dashboard refresh is usually completed by 9:30am each day.The data sources include:
PRISM (Pitt’s Real-time Integrated Solution for Management), which comprises:
General Ledger
Accounts Payable (invoice and payment information)
RPA (research accounting project information)
PCard (purchasing card transactions)
SPAR (labor distributions for salaried staff)
Purchasing (includes PantherExpress orders)
PittWorx: Employee roster and TEAM
Oracle Planning and Budgeting Cloud Solution (PBCS) Grants Forecasting data includes encumbrance forecasts for compensation and non-compensation expenses. PBCS is also known as Enterprise Performance Management (EPM)
PERIS™ My Funding (Pitt Electronic Research Information System)
Concur, which captures travel & business expense reports
The data is refreshed with posted general ledger transaction information everyday around 9:30 am, such that changes made in the system today will not appear until the next business day. Many views contain current actual account balances, projected account balances and remaining amounts based on the budget period of the grant. There are drill-down capabilities for multiple transaction types from the various sources.
NOTE: Monthly payroll dollars are costed as part of the month end closing process and thus are not available until the beginning of the next month.
How do I get access?
You will automatically have access to this dashboard if you have GL Mart Access. You will see all departments that contain an 05 grant account that you have access to.
...