Analytics Reporting

Follow

Audience: Accounting Manager and Payment Authorizer

Summary: Reviews MineralTree's Analytics platform.

In this article:

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.

There are two subscriptions to Analytics. Basic (which is available to all customers) and Premium. Basic access gives you access to most dashboards while Premium access gives you access to the efficiency dashboard and the ability to export graphs.

Access & Navigation

Accounting Managers and Payment Authorizers will have access to Analytics, when enabled, from the Reports Tab by clicking on the Analytics button. 

Screen_Shot_2021-06-09_at_9.37.42_AM.png

This will open up a new tab, and land the user on the first dashboard (Invoices).

Screen_Shot_2021-06-09_at_9.46.22_AM.png

This presents you with useful widgets along with detailed data in a tabular format for easy export (for premium subscribers).

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

You can also hover over any segment of the graph to get more detailed information on that segment.

Screen_Shot_2021-06-09_at_10.09.32_AM.png

Group Data

You can also group data in various ways in your graphs by clicking on the grouping options 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 a graph (premium subscribers) hover over any widget and click the three dots followed by Download and then select your format.

Screen_Shot_2021-06-09_at_10.10.54_AM.png

Invoices Dashboard

Available to Basic and Premium customers, 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

Available to Basic and Premium customers, 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

Available to Basic and Premium customers, 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

Available to Basic and Premium customers, the Payments 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

Screen_Shot_2021-06-09_at_11.05.20_AM.png

 

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.