The header at the top displays the following totals for all PIs selected in the filter:

• Projects:  total number of projects with an Active status

• Total Budget:  total current budget period

• Total Actuals:  total dollars posted to the general ledger*

• Total Encumbrances:  total calculated encumbrances*

• Balance Remaining:  total calculates dollars remaining in the current budget period

  • Budget – Actual – Encumbrances = Balance Remaining*

There is a unique line for each PI, displaying the following

• Total Budget:  total current budget period

• Actual Spend:  total dollars posted to the general ledger*

• Encumbrances:  total calculated encumbrances

• Total Balance Remaining: total calculates dollars remaining in the current budget period*

• Health Indicator icon:  green for funds remaining, red for deficits

Within the investigator line, the Total Budget, Actual Spend, Encumbrances and Total Balance Remaining dollars are reported, along with a health indicator (green for funds remaining, red for deficits).

*These items will include projection data based on the selection in the ‘Include Grants Forecasting Projections’ drop-down menu.

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).

The SPAR details include the following:

• Subcode/Reference

• Employee Name/Number

• Start Date:  start date within the period for the percentage amount

• End Date:  end date within the period for the percentage amount

• Award End Date: end date defined in RPA

• Pay Year Type:  pay frequency, i.e., 12/12 – works 12 months, paid 12 months

• Salary Amount:  from HR salary field, does not include summer salary, stipends or supplemental payments

• Percent Effort: percent effort is not forecasted; only actual distributions

• Actual Percent: actual percentage distributed to the project

• Encumbered Salary:  based on Include filter (PBCS Forecasted amounts)

Each column heading can be sorted by clicking on the icon to the right of the column name.

• Transaction details for most transactions are from JUL-14 (FY15) forward. 

• Concur data is from JUL-19 (FY20) forward.  The Step/Employee Assigned to Step fields are the approval history of the transaction within Concur in descending order.

• Purchasing details are for those invoices that have been matched to the PO within PRISM.  The PantherExpress import of purchase order data began in April 2019 and thus invoices for PantherExpress orders created before that data would not be displayed or calculated. 

• There are multiple sections for Invoice, Check, PCard, Purchasing, Concur data to allow for a user-friendly consolidated view, however not all sections apply to GL transaction details and thus some sections may be blank.  For example, when looking at details for Po Encumbrance detail, sections for GL Detail, Invoice and Check will be blank and you will need to scroll to the PO Details section. 

• In check details, when the vendor is an employee and the check number is 10 characters and begins with a 1, the payment was via a direct deposit to the employee’s designated payroll bank account.

• A PO based transaction can have multiple invoices and thus all will be displayed to give a consolidated view of the current and past activity on one purchase order.

• The PO encumbrance is calculated from the quantity and unit price.