Versions Compared

Key

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

Description

Excerpt
nameFP-Purpose-Based

Fiscal Panther Purpose-based is a tools tool for reviewing and managing 02/04/06/09 accounts with non-zero purpose codes. Spending, revenue, and projections can be tracked.

Key Business Questions

This dashboard allows tracking of 02/04/06/09 accounts with non-zero purpose codes. Spending, revenue, and projections from PBCS Operating Funds Forecasting are included. Spend and revenue can be viewed by RC, department, and purpose code. Trends for the past 5 years can be viewed. Individual transaction data can be viewed as well, including Panther Express Purchase Order data, credit card purchases, and Concur travel expenses.

Excerpt
nameFP-Purpose-Based?
  • What is the actual spend on an account by Subcode?

  • What SPAR distributions are on an account?

  • What are the invoice, check, PO or Concur details of a transaction?

  • What transactions have hit an account, and which are projected to hit?

  • Which purchase orders have an encumbrance?

  • How does my spending or revenue this year compare to previous years?

  • Which employees' salaries come from the account I manage?

...

Usage Guide

There are 5 tabs in this dashboard that can be navigated to directly:
Department Landing | Historical Expense & Revenue | Labor Distribution | SPAR and TEAM | Query Page

Table of Contents
minLevel3
maxLevel4
outlinefalse
typeflat
separatorpipe
printablefalse

Transaction Details can only be reached by first navigating to Query Page, then clicking on a transaction for more details.

Selection made for the RC, Entity, Department, Purpose, Donor Restricted, and Projections filters are carried across each tab.

Info icons ( i ) can be seen throughout the dashboard. Hovering over these the info icons (info) will provide more details.

Many parts of this dashboard have an export button that allow you export the list of data shown can be exported to an .xlsx file by using the green Export buttons.

Department Landing

The Department Landing is a summary for the entity/department/purpose combinations you have selected. This page will default to show all departments in the RC selected that you have access for, but filter selections can be used to select one or more departments.

...

At the bottom right is a viz that compares monthly spend for the past 5 years.

...

Historical Expense & Revenue

This dashboard slices historical spend and revenue in a few ways. You can choose to show the data year-to-date or year-over-year. You can also display the amounts in dollars or percentages. The last 5 years of data are shown.

...

The right visualization shows how the total expense and revenues for each year are broken into different categories.

...

Labor Distribution

This tab shows Labor Distribution for the selected department(s). The categories/bars on the left visualization can be clicked to filter the rest of the dashboard. No projections are shown on this page.

...

SPAR and TEAM

This page displays a list of SPAR distributions and TEAM rates and tasks, depending on the selection. Projected salary information is displayed here. If you want to click on an export button, the data you want to export must be displayed. Otherwise, you will download an empty file.

...

...

Transaction Review

Please be aware that there are a lot of data behind this page. It may take some time to load and some time to apply filter selections.

This tab is for searching and viewing a list of transactions for the selected account(s). All transactions are shown by default, but you can choose to see encumbrances only by selecting the ‘Show Open ENCUBRANCES’ PEX Encumbrances’ button.

Clicking on a Supplier or Expense Category on the left will filter the rest of the data. Clicking on ‘Click for Details’ will navigate to the Transaction Details page.

...

Drilldown

This page will be empty unless the Query Page is used to navigate to it. This tab When selecting 'Click for Details, ' this page shows transaction details including General Ledger, invoice, check, and transaction-specific data (Concur, credit card, PO).

...

What is the source of this information?

There are many sources of data for this dashboard:

...

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.

How do I get access?

You will automatically have access to this dashboard if you have GL Mart Access. You will see all purpose-based account strings you have access to.

...