Fiscal Panther: Transaction Review (NEW!)
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 allows review of multiple entities and departments, with filtering options for PI and Billing PI. Balance sheet subcodes (subcodes > 4000) are viewable through a button option. Budget transactions are available is a separate tab.
*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 given the large amount of data now available at the individual transaction level. Multiple custom views can be created to allow for ease of navigation.
The dashboard has three main views:
Account Review
Billing Review
Budget Review
The Transaction Detail view is displayed when selecting an single transaction line within these views
Key Business Questions
Fiscal Panther Transaction Review allows for answering questions such as:
Were 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?
Has the budget been updated (BMR - budget modification request)?
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.
Account Review & Billing Review
These two tabs within the dashboard can be used to review and reconcile transactions by mutiple search criteria such as account segments, PI, date and supplier filters.
The Account Review will show all account segments within your security setup. Subtotals for Revenue, Expense and Total (revenue and expense) will be displayed. These totals adjust based on the filters selected.
Click the View by Balance Sheet button to review transactions on asset and liability subcodes (subcodes > 4000). Click the same button to return to the Account/Billing Review for expense and revenue subcodes.
The left side will display summary Top Supplier and Subcode Category information. The subcode category is defined by the Parent subcode.
The Billing Review will allow you to search for Billing IDs within your security setup and will display all of the associated subaccounts. Subtotals for Revenue, Expense and Total (revenue and expense) will be displayed. These totals adjust based on the filters selected.
Click the View by Balance Sheet button to review transactions on asset and liability subcodes (subcodes > 4000). Click the same button to return to the Account/Billing Review for expense and revenue subcodes.
The left side will display summary Top Supplier and Subcode Category information. The subcode category is defined by the Parent subcode.
Drilldown
Click on any of the transaction text fields to display the ‘Go To Transaction Detail’ option. Click this link to display additional information about the transaction selected, including GL batch, invoice, check, and transaction-specific data (Concur, credit card, PO).
When finished reviewing additional details, click the respective Return to Account Review or Return to Billing Review buttons to return to the transactions list.
Open PO Encumbrances
Click the “Show PEX Encumbrances' button to display open encumbrances from PantherExpress purchase orders. Encumbrance calculation began in April 2019. Encumbrances are calculated as follows:
(Quantity Ordered - Quantity Billed - Quantity Cancelled) * Unit Price
Encumbrances are automatically relieved based on the invoicing process within the PantherExpress and PRISM systems. The period filter in the main options is not applicable as encumbrances are active until the PO is fully invoices, closed or canceled. There is a Period Filter within this view to search by the month the PO was created.
If there are open quantities that are no longer needed/will not be billed, the PO will need closed and the revision finalized in PantherExpress in order to relieve the encumbrance. For more information on managing encumbrance please visit Managing Purchase Order Changes & Encumbrances Document.
Budget Review
This view shows all posted budget transaction entries, using the same filters in the Account & Billing Review sheets. Budgets are typically used in 02, 03 and 05 accounts.
As a reminder, for 02/03 accounts the primary budget load happens in October and is loaded to the JUL period for the Fiscal Year. For 05 accounts, the budget is posted as part of the RPA activation process. Throughout the year, budget modification requests (BMRs) can be processed to adjust the budgets for all these entities.
What is the source of this information?
There are many sources of data for this dashboard:
General Ledger Mart
PantherExpress
Concur
Data is updated overnight with the previous day’s posted activity. The dashboard refresh is typically completed by 8:00am each day.
How do I get access?
You will automatically have access to this dashboard if you have GL Mart Access.
GL Mart access is granted through the Federated Authorization form. More information can be found here: Federated Authorization Community.
Status | In BETA |
|---|