Description

Key Business Questions

This dashboard allows tracking of 02/0304/06/09 accounts with 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.

• 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?

Basic Usage

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

...

Many parts of this dashboard have an export button that allow you export the list of data shown to an .xlsx file.

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.

...

Query Page

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.

...

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

...