Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

Excerpt
nameFP-Grants Admin

Fiscal Panther Grants Grant Administration is a 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.

...

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:

Excerpt
nameFP-Grants Admin?
  • 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?

...

Usage Guide
Anchor
basic_usage
basic_usage

To start using this dashboard, open one of the following three tabs: Department Overview, Investigator Overview, or Master Account Profile. Data on other tabs are populated based on selections made on one of these tabs. Those other tabs will show no data unless you navigate to it using one of the first three mentioned tabs. Navigation actions will be denoted with a ▶️ icon.

...

The Project Profile will show a project overview based on the project selected from the Master Account Profile, the Department Profile, or the Investigator Overview. This view is split into three two parts: general information about the project is at the top ; the dials in the middle show financial health of the project; and the table at the bottom displays the totals by subcode and reference, along with a health indicator to show funds remaining or deficits.

...

▶️ Click on a Subcode row in the Expenses by Type and Subcode section to open the Transactions tab.

...

To show graphs of project health click the Click Here for Summary Balances button.

image-20240916-214748.pngImage Added

Expand
titleAdditional Details and Definitions

The Project Overview header displays the following:

  • Project Number

  • Project Title

  • Principal Investigator

  • Award ID (defined by entry in MyFunding or by SPA entry at time of creation)

  • Project Period (total date range of the project)

  • Award Period (current budget period)

  • Funding Agency (funding sponsor)

  • Indirect Cost Method (1, 3, 5, 0) & Indirect Cost Rate (rate as defined in award letter)

  • Account Relationship (Independent, Master, Subaward)


Project financial health visualizations are available by subcode category, click on the colored sections to display the various dollar amounts.

  • Total: (subcodes 5xxx-9xxx)

  • Compensation:  subcodes 5xxx-5999

  • Non-Compensation:  subcodes 6xxx-9xxx (excluding indirect subcodes)

  • Indirect:  subcodes 8350, 8351

  • Calculated Directs Available:  total balance divided by 1 + indirect cost rate


The bottom section, Expenses by Type and Subcode, displays the totals by subcode and reference for Budget, Actualand Encumbrances, along with a funds remaining health indicator (green for funds remaining, red for deficits).

Back to Top

SPAR Details
Anchor
SPAR_details
SPAR_details

...