Analytics Reporting


Audience: Accounting Manager and Payment Authorizer

Summary: Reviews MineralTree's Analytics platform.

In this article:

 

Analytics Overview

MineralTree Analytics gives Accounting Managers and Payment Authorizers a new way to view Accounts Payable data. It helps users discover trends, track performance, and make informed financial decisions.

With Analytics, finance teams can see the full picture of their AP process, what’s owed, what’s paid, and how long it takes to move money. These insights help improve visibility, control cash flow, and align day-to-day actions with company goals.

Access & Navigation

Accounting Managers and Payment Authorizers can access Analytics from the Reports tab by clicking the Analytics button.

Screen_Shot_2021-06-09_at_9.37.42_AM.png

 

Analytics opens in a new browser tab and starts on the Invoices Dashboard. 

Screen_Shot_2021-06-09_at_9.46.22_AM.png

 

Each dashboard includes visual widgets and detailed data tables that can be easily exported for reporting.

Screen_Shot_2021-06-09_at_9.56.29_AM.png

Filter Data

Data can be filtered by using the drop-downs at the top of the dashboard. 

Screen_Shot_2021-06-09_at_9.46.22_AM.png

 

Hover over any part of a graph to see more details about that data point. This helps you explore specific metrics without leaving the page.

Screen_Shot_2021-06-09_at_10.09.32_AM.png

Group Data

You can organize or group data in different ways by selecting Group Options located under each widget.

Screen_Shot_2021-06-09_at_10.11.02_AM.png

Expand & Export

To expand a graph to full screen, hover over the graph widget and select the expand icon. 

Screen_Shot_2021-06-09_at_10.17.33_AM.png

To export data, hover over the widget, click the three dots, choose Download, and select your preferred file format.

If you don’t have access to export features, contact Customer Success to request an upgrade.

Screen_Shot_2021-06-09_at_10.10.54_AM.png

Invoices Dashboard

 The Invoices Dashboard has six widgets, and an Invoices Report Table.

image-20210503-161705.pngimage-20210503-165639.png

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.

Screen_Shot_2021-06-01_at_9.06.20_AM.png

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.

image-20210601-135015.png

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

Screen_Shot_2021-06-09_at_11.05.20_AM.png

Widget Name

What it means

Paid Invoices Skipping Approval

This widget shows the number of invoices that were paid without going through an invoice approval process

Average Payment Cycle Time

This graph shows the difference between invoice create date and the payment date. 

For example, if a bill is created on 5/3, paid on 5/7, and has an invoice date of 4/25, the payment cycle time is 4 days. This represents the time from creation to payment, and the invoice is included in April’s Average Payment Cycle Time since it is considered an April bill.

Invoice Details

This is a table of the data displayed in the widgets above, including all the statuses.

Was this article helpful?
0 out of 0 found this helpful