Description
This is the new and improved version of the Transaction Review dashboard currently running in parallel. This version is reconfigured with the new data sources based on our customer feedback. The view now allows review or multiple entities and departments and includes new totals for Revenue and expense. Balance sheet subcodes are excluded (subcodes > 4000). A new view will be created for viewing those subcodes, as well as a new sheet for viewing details by Billing ID (both to be made available by the end of FY25).This new view by default, will not display account information. A user must setup a default custom view for their account information. This is meant to improve performance give the large amount of data now available at the individual transaction level. Multiple custom views can be created to allow for ease of navigation.
Key Business Questions
Fiscal Panther Transaction Review allows for answering questions such as:
Where the transactions posted valid business expenses?
What transactions have occurred on an account in a given period or fiscal year?
What are the invoice, check, PO or Concur details of a transaction?
Which purchase orders have open encumbrances?
How much has been spent with a supplier?
How much as been spent on supplies, travel, etc?
Usage Guide
Please be aware that given the vast amount of data for transactions in the last 10 fiscal years. It may take some time to load. Users must create at least one default view to allow for better performance.
Create a Custom View
When opening for the first time, you must select filter options to display data.
Select the appropriate options.
Click the View option on the toolbar. The first text of the option is “View: <current view>” If no custom view as been established, the text will be View: Original.
The Custom View window will open. Enter/select the following:
Name the view - this name will appear as the view name and option
Select the “Make it my default option” - this will then make these filters automatically select/display when this dashboard is opened
Click Save
Multiple views can be created and saved, only one can be the default. At the bottom, all available views will be displayed and available for selection.
Once saved, the view name will appear in the toolbar. Click the View option to switch to other saved views.
Transaction Review
This view is for searching and viewing a list of transactions for the selected account(s). You will need to select a valid Entity/Department combination you have access to. All transactions are shown by default, but you can choose to see encumbrances only by selecting the ‘Show PEX Encumbrances’ button.
Clicking on ‘Click for Details’ will navigate to the Transaction Details page.
Drilldown
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:
General Ledger Mart
PantherExpress
Concur
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 account strings you have access to.
You can request GL Mart access through the Federated Authorization form. More information can be found here: Federated Authorization Community.