Audience: Accounting Manager and Payment Authorizer
Summary: Reviews MineralTree's Analytics platform.
In this article:
- Analytics Overview
- Access & Navigation
- Invoices Dashboard
- Payments Dashboard
- Vendor Dashboard
- Efficiency Dashboard
Analytics Overview
MineralTree Analytics will give Accounting Managers and Payment Authorizers a different look into Accounts Payable. Analytics opens the door for users to gain powerful insights about their AP function, and set better goals to monitor throughout the year. Analytics enables finance leaders to maintain visibility & control over the AP process in order to make timely, effective decisions that are aligned to strategic priorities and business obligations.
Access & Navigation
Accounting Managers and Payment Authorizers will have access to Analytics, when enabled, from the Reports Tab by clicking on the Analytics button.
This will open up a new tab, and land the user on the first dashboard (Invoices).
This presents you with useful widgets along with detailed data in a tabular format for easy export.
Filter Data
Data can be filtered by using the drop-downs at the top of the dashboard.
You can also hover over any segment of the graph to get more detailed information on that segment.
Group Data
You can also group data in various ways in your graphs by clicking on the grouping options under each widget.
Expand & Export
To expand a graph to full screen, hover over the graph widget and select the expand icon.
To export a graph hover over any widget and click the three dots followed by Download and then select your format. If you are unable to export and would like to, please contact Customer Success to upgrade.
Invoices Dashboard
The Invoices Dashboard has six widgets, and an Invoices Report Table.
|
Widget Name |
What it means |
|---|---|
|
Payables Aging and Forecast |
An overview of what the business owes to suppliers. Payables aged reveals how much money is owed and for how long, whereas Payables forecasted displays invoices that are coming due in a certain time period. To optimize cash flow, business owners can run an AP aging report and pay bills at regular intervals. |
|
Number of Invoices (Workflow Status) |
Shows the split of the invoice workflow status by month. This allows AP managers to see the number of invoices that have not been processed yet. |
|
Number of Invoices (Approval Status) |
Shows the split of the invoice approval status by month and where the approval process slows down. |
|
Number of Invoices (Posting Status) |
Shows the split of posted and not posted invoices by month. |
|
Invoices Amount (Payment Terms) |
This widget shows the invoice amount by month, split by the payment terms of the Invoice. Useful for seeing how payment terms can impact the cashflow. |
|
Invoice Amount (Payment Status) |
Shows the total amount on invoices by month in the simplest form of “Paid” or “Unpaid." This shows the total amount of invoices over time, making it easy to understand when the increased spend seasons are. It also allows the user to see how much of a certain month’s invoices are still unpaid. |
|
Invoice Details |
This is a table of the invoices displayed in the widgets above, including all the statuses. |
Payments Dashboard
The Payments Dashboard has four payment-based widgets, two invoice-based widgets, and a Payment and Invoice table.
|
Widget Name |
What it means |
|---|---|
|
Payment Type Mix |
Shows the split of payment types by month. Allows you to view the amount of payments made by each payment type and learn how payment types impact the cost and time to pay suppliers. |
|
Number of Payments |
Shows the number of payments made and scheduled by month. |
|
SilverPay Rebate Amount |
Shows the amount of rebate the user should expect for SilverPay payments made in the given month. This is just an estimate based on the average cash back people receive per dollar and your official amount may vary. |
|
Discount Taken |
Shows the shows the impact of discounts over each month by displaying the amount of discounts taken. |
|
Payment Details |
This is a table of the payments displayed in the widgets above, including all the statuses. |
|
Unpaid Invoice Amount |
Displays the cash value of invoices overdue or not overdue by month based on the invoice date and due date. Only unpaid invoices will display on this widget. |
|
Number of Paid Invoices |
Shows the number of invoices overdue or not overdue by month. This is based on the invoice date and due date. Only paid invoices will display on this widget. |
|
Invoice Details |
This is a table of the invoices displayed in the widgets above, including all the statuses. |
Vendor Dashboard
The Payments Dashboard has a few widgets and tables of aggregate information.
|
Widget Name |
What it means |
|---|---|
|
Top Vendors: By Spend |
This graph and table shows how much you pay your top vendors throughout a year. The graph shows a visual representation of the table, which shows the amount of spend per month for the given vendor. |
|
Top Vendors: By Number of Payments |
This graph and table shows how many payments you pay your top vendors throughout a year. The graph shows a visual representation of the table, which shows the number of payments per month for the given vendor. |
|
Vendor Utilization, Vendors with Payments in Last 30 Days, Active Vendors |
This first set of widgets displays the percentage of vendors that have been paid in the last 30 days / the amount of active vendors as of today. This is a good indicator of how many vendors you use actively throughout the year. |
Efficiency Dashboard
The Efficiency Dashboard has a few widgets and tables of aggregate information. It contains the following widgets:
-
Paid Invoices Skipping Approval
-
Average Payment Cycle Time
-
Invoice Table