Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Invoice Trending Report page presents a list of all accounts in scope for the client, showing account related information as well as a spend Pending Dashboard is a powerful interactive report that provides you the ability to monitor invoice activity, immediately locate accounts that need updated credentials, and see the status of late or missing invoices - plus you can see a cost trend of the last six months for the account, based on the current month.

The invoice expectancy legend identifies the status of the expected invoices.

...

  • The green check mark indicates OK.

  • The amber check mark indicates Soon.

  • The red triangle indicates Pending.

In each column, there is information or a link that displays different views of the spend.

...

.

...

How to access the Invoice Pending Dashboard

  1. Go to the Expense Management module.

  2. Click on Reports.

  3. Expand the category Operational Reports.

  4. Click on Invoice Pending Dashboard.

...

Navigating the dashboard

There are two tabs at the top of the dashboard that allow you to toggle between two views:

Reviewing the By Validation Type tab

What type validation was triggered for the invoice? You can quickly see the data points for each category. Each of these categories correlates with the report detail tabs below.

...

Validation Type

What it means…

Drop Account

The account is no longer on the portal - it appears to have been dropped.

User & Password

The portal credentials are not working as expected.

Pending Email

Asignet is waiting for the invoice to arrive via email.

Pending in Portal

Asignet is waiting for the invoice to be posted to the vendor’s portal.

Manual Invoice Pending

Asignet is expecting manual data entry processes to complete for paper invoices.

In Process

The number of invoices activity in-process of being retrieved and loaded.

Lack of Configuration

There are portal configuration items that are preventing a successful invoice retrieval.

Unclassified

An invoice did not fall into one of the above categories.

Reviewing the By Access Type tab

This summarizes the total number of invoices pending actions and then by the invoices' the primary receipt method. You can quickly see the data points for each category. Each of these categories correlates with the report detail tabs below.

...

Access Type

What it means…

Total Pending

The total number of pending invoices, regardless of receipt method.

Portal

The number of invoices expected via the vendor’s portal.

Email

The number of invoices expected via email.

Manual

The number of invoices expected via manual processing by Asignet.

Navigating the report detail for By Validation Type

When you are interacting with the dashboard on the By Validation Type view, the detailed reports below give you the list of accounts that meet the specific validation criteria. Select the appropriate report tab to refresh the account results.

...

Navigating the report detail for By Access Type

When you are interacting with the dashboard on the By Access Type view, the detailed reports below give you the list of accounts that meet the specific invoice receipt method. Select the appropriate report tab to refresh the account results.

...

Columns available for the detailed reports

...

Column Name

Description

Provider

Displays the provider or

The vendor of the invoice.

Account

Displays the account number for the invoice. Click

Click on the account number to

show the account information.

End Date

Displays the last bill date for the invoice

see the account record. You can edit account fields in this pop-up window, such as description, vendor ID, remit ID, and GL definition.

Image Added

Account Description

The client provided description for this account. You can click on the Account Number to modify the description, if needed.

Access

Displays the method of getting the invoice.

Received by
  • The envelope icon indicates receipt via email.

Downloaded
  • The link icon indicates the invoice was downloaded automatically by portal.

Entered
  • The hand icon indicates the invoice was entered manually. For example, a scanned image that is not an original PDF and cannot be parsed.

User Login

Displays the login ID for the invoice.

Expected Invoice Status

Shows the expectancy for the invoice. Hover over the icon to display the day of the month the invoice is expected.

  • The green check mark indicates OK.

  • The amber check mark indicates Soon.

  • The red triangle indicates Pending.

Days in Red

How many days has the invoice been considered “missing”?

Expected Date

Displays the day of the month the invoice is expected.

Max Day

Displays the max day.

Justification

Displays the justification.

Q Invoices

Displays

This is the number of invoices processed for

that

the account. Click the number to display a list of all invoices processed

for the account

in a

new

pop-up window.

Account Payment Method

Displays the payment method for the account, if provided by the client. This could be a check or electronic funds transfer (EFT).

Account Payment Group

Displays the payment group for the account, if provided by the client.

AP Match

Shows if the account matches the accounts payable (AP) accounts provided by the client during implementation. Hover over the icon to display the account number for the invoice.

Monthly Trend

Displays the monthly trend of invoice spend. This can be adjusted using the filter capability.

Invoice in Error

Displays a warning indicating an invoice has problems matching the Header and Details information. Click the warning to show the issue details.

Last AW

Displays the date that the Asignet robot last checked for an invoice (if it is accessed by portal).

Rate Run

Displays the average run rate of the invoice for the period in the trend.

Comments USA

Click the text to view any comments related to the invoice.

Last Comment

Click the text to view last comment related to the invoice.

Comment History

Click the magnifying glass icon to search the comment history.

Filter Trending Reports List

The information can be filtered by:

  • From: Select the specific start month from drop-down list.

  • To: Select the specific end month from drop-down list.

  • Country: Select the specific country from drop-down list.

  • Vendor: Select the specific vendor from drop-down list.

  • AP: Select the specific AP match from drop-down list.

  • Expected Invoice: Select the specific expected invoice status from drop-down list.

  • Access: Select the specific access method from drop-down list.

  • Account Status: Select the specific account status from drop-down list.

The list can be exported to a spreadsheet by clicking the XLS icon.

New Account

Click New Account to open a new window to add an account.

Perform the following steps:

  1. Select the specific provider from drop-down list.

  2. Enter the account number.

  3. Enter any relevant comments.

  4. Click Submit to apply changes or click Cancel to abort the operation.

Account/AP Tracking

Click Account/AP Tracking to access the Accounts/AP page, which provides a view that identifies the accounts for each vendor.

Export

Click Export to open a new window to export a list of vendor invoices.

Image Added

Image

The robot will take a picture of the portal, if an error is encountered during invoice retrieval.

ATD - Status

What is the status of the invoice? Typically reflects the validation type (i.e. lack of configuration).

ATD - Modified User

The last user to modify the record.

ATD - Modified Date

The last date the record was updated.

ADT - Comment

Comments made by the Asignet user modifying the record.

Monthly Trend - 6 Months

Shows the invoice amount for the last six (6) months.