Accessing the All Payments Page

This page lives underneath the "Payments" page in the navigation bar, if you hover over it you will see the "All Payments" page. Clicking on this will take you to this page. It contains a grid that details all payments that are currently in our system.

The UI

When you access this page, it looks something like this:

This grid in the UI displays our demo data and each column represents a different piece of data that's sent to our system in your transaction file. The table below explains the information displayed and the corresponding header item in the data you provide to us.

Exporting the Data

Export Button

It is possible to export this data in different formats, including XML, CSV, Excel and JSON. This is particularly useful if you're wanting to have a local copy of the information we provide to look over and review. Clicking the "Export" button in the top left of the grid, opens a dialog that looks something like this:

To export the data in the format you'd prefer, you select the appropriate option from the dropdown list and click the download button. This will download the data from the grid in that format to your local pc.

Export Payment Lines Button

This button is used to export all of the individual payment lines from our system. Clicking this button will bring up a dialog that looks something like this:

To export the data in the format you'd prefer, you select the appropriate option from the dropdown list and click the download button. This will download the data from the grid in that format to your local pc.

Filtering the Data

You may notice that some of the columns of the grid allow filtering, below is a brief explanation of the filters and how they can be used.

Client Name Filter

To filter this column, you click the filter icon in this column header, doing so will bring up a filter dialog that looks something like this:

Typically there is only one client company per portal, however, if there are more than one you can filter the data by selecting the company name you're interested in and clicking the "Filter" button. Once confirmed, the grid will no longer display any data that doesn't fit the filter criteria.

Client State Filter

To filter this column, you click the filter icon in this column header, doing so will bring up a filter dialog that looks something like this:

Here, there is a list of the most common states that transactions in our system sit in, you can filter this column based on multiple criteria. If you're interested in "Eligible" and "Approved" payments for example, you'd select these states and click the "Filter" button to confirm. Once confirmed, the grid will no longer display any data that doesn't fit the filter criteria.

Supplier Name Filter

To filter this column, you click the filter icon in this column header, doing so will bring up a filter dialog that looks something like this:

Here there is a full list of the supplier companies in the system. From this list you can select the companies which you're interested in to view their data and click the "Filter" button to confirm. Once confirmed, the grid will no longer display any data that doesn't fit the filter criteria.

Supplier State Filter

This filter works in the same way as the Client State filter which is described further up the page. 

Payment Reference Filter

To filter by this column, you click the filter icon in this column header, doing so will bring up a filter dialog that looks something like this:

In the top dropdown in this dialog, there are four option which are explained in the table below:

This dialog accepts two conditions, where you can filter in the case where both conditions are met by using the "And" or you can filter based on one or the other being met by setting it to "Or". Once you have input the values you want to filter by in the boxes, click "Filter" to confirm. Once confirmed, the grid will be filtered based on the criteria you set in the filter dialog.

Value Filter

To filter by this column, you click the filter icon in this column header, doing so will bring up a filter dialog that looks something like this:

In the top dropdown in this dialog, there are four option which are explained in the table below:

This dialog accepts two conditions, where you can filter in the case where both conditions are met by using the "And" or you can filter based on one or the other being met by setting it to "Or". Once you have input the values you want to filter by in the boxes, click "Filter" to confirm. Once confirmed, the grid will only show the payments that fit the filter criteria.

Currency Filter

To filter by this column, you click the filter icon in this column header, doing so will bring up a filter dialog that looks something like this:

Due Date Filter

To filter by this column, you click the filter icon in this column header, doing so will bring up a filter dialog that looks something like this:

You can select the dates you want to filter by by clicking the calendar icon on the left-hand-side of the text box. This will bring up a dialog that looks something like this:

To select the date you wish to filter by you select it in this dialog. You can navigate through the months using the arrows and quickly select the current date by clicking the text at the bottom of the dialog. You can specify date ranges to filter the data by, this is explained below.

Filtering by Date Ranges

The dropdown has a selection of "From" which will filter out dates that come before the one specified, you can also select "To" in this dialog, which will filter out any dates that come after the one specified. Using this "From" and "To" you can specify an exact date range. This is particularly useful if you want to find the payments with the document dates within a particular month.

To filter out any payments from the 1st of May 2024 to the 12th of June 2024 in the grid, you would need to specify this in the filter dialog:

Clicking the "Filter" button will confirm the filter conditions. Once confirmed this will then filter out any payments with due dates that do not fall in between the two dates specified from the grid.

Buyer Payment Date Filter

This is the same as the due date filter defined above, please see this section to understand how to filter this column if you are unsure.