Application / Invoices Page

Invoices Page

Use the Invoices page to look at all the invoices currently open in YayPay. 

This page lists each open invoice in relation to the Customer it belongs to. The term "open invoices" covers:

  • Invoices that have not yet gone past their Invoice Due Date (i.e. still Current)
  • Invoices that have gone past their Invoice Due Date (i.e. Overdue)
  • Invoices that are not paid yet or have been partially paid (i.e. still Current, with a leftover balance amount to be cleared)


Delete

Info on closed invoices

  • All fully paid Invoices (i.e. closed invoices) are not shown. You can use the Transaction Report in YayPay to generate an Excel Report covering various Transaction Types (e.g. Payments, Adjustments, Credits, etc including open and closed invoices) over a selected period
  • If you know the specific Customer tied to the closed Invoice, use the Statement Page to look it up (the fully paid invoice will be displayed under the CLOSED INVOICES tab)


There are such components on the page: 

  • Header: Search, Filter, Totals
  • Aging Pipeline
  • Invoices grid with "Export to Excel" option

See the detailed description of each component below.

Invoices page - Header

Search option - ability to find invoices by

  • Customer name
  • Invoice number

Filter option - ability to apply filters to the list, which allows you more flexible reporting and convenient work with the invoices. 

Some of the most commonly used filters that you can use include:

  • Invoices belonging to Customers currently Assigned to or Not Assigned to a Workflow
  • Invoices belonging to Customers currently Assigned to or Not Assigned to an AR Rep
  • Invoices belonging to Customers currently Assigned to or Not Assigned to a Sales Specialist or a Customer Success Specialist
  • Invoices with no Invoice level Billing contacts
  • Aging Buckets Filter Option
  • Invoices that have Open Promises to Pay
  • Invoices that have Open Disputes 
  • Invoices belonging to Customers where the Customer Balance has exceeded the assigned/allowed Credit Limit
  • Invoices where the Email Reminders Bounced
  • Customer Level Custom Fields (setup under Settings > ERP Custom Fields is needed)
  • Invoice Level Custom Fields (setup under Settings > ERP Custom Fields is needed)
  • Invoice Status

Within the Header, you will also find an overall count of open invoices, companies having open invoices in the systemand the sum total of all open invoice amounts that YayPay has - this is a snapshot and likely to change by the next day as invoices are paid/closed.  


Delete

Note

  • The totals in the header are affected by the search, filters, and pipeline filters applied
  • The total due amount to the right is the same as what is displayed in the Aging Report - this figure may not be the same as the sum total of all invoice amounts due to other open documents like credits, adjustments, etc.


Invoices page - Aging Pipeline

Aging Pipeline provides the ability to filter the invoices by their status. Click VIEW to see the required invoices in the grid.

Click CLOSE to clear the filter

Delete

Note

The filtered data is saved when the page is refreshed or the user logs out. 



Invoices page - Grid

Configure the columns to be included in the grid using the column-picker:


Columns Displayed by Default 

The following columns are displayed in the grid by default:

  • Invoice # (clickable, upon click, invoice view is displayed in another tab)
  • Indicators (opened dispute, attachments, "excluded from workflow" indicator, etc.)
  • Date (invoice creation date)
  • Customer (clickable, Statement page opens in another tab)
  • Billing Contacts (upon clicking on the billing contact icon, the invoice billing contact info is shown)

  • Currency
  • Balance
  • Amount
  • Invoice Status
  • Due Date
  • Age
  • Probability (if configured in Business Settings, also refer to Enable Payment Prediction)

Columns Enabled from Column-Picker

To display additional columns in the grid, click the Select Columns icon to view a list of all the available columns. Click on the columns that you want to add to the grid.


  • Last Invoice Note
  • Last Invoice Note Date
  • Invoice CRM/ERP Custom Fields  
  • Invoice System Custom Fields  
  • Discount - To make this column available for selection in the column-picker, you must enable the Allow/enable terms and discounts for payments setting in Settings | Business.
  • Discount Date - Shows the date until which the discount is valid. To make this column available for selection in the column-picker, you must enable the Allow/enable terms and discounts for payments setting in Settings | Business.
  • Dispute Code
  • Disputed Amount
  • Dispute Open Date
  • APT
  • DSO
  • Expected Payment Date - To learn how YayPay determines the displayed date, see the Determing Expected Payment Date‍ section.
  • Business Currency
  • Balance in Business Currency
  • Amount in Business Currency
  • Last Customer Note
  • Last Customer Note Date
  • Billing Contact Email
  • Assigned AR
  • Assigned Sales
  • Assigned CS
  • Customer ERP/CRM Custom Field 
  • Customer System Custom Field 
  • Credit Score 
    This functionality is available for Advanced Credit users only. To obtain access to this feature, contact your YayPay account manager.
  • ERP ID
  • Parent Company
  • Credit Limit
  • Workflow
  • Invoice Delivery Status Date - Shows the date when the invoice status was last updated.
  • Delivery Method - Shows the delivery method that was used to send the given invoice to the customer. By default, it is empty until the invoice is sent. For example, the following methods might be displayed:
    • Email - Indicates the given invoice was sent by email (e.g. using the Send Reminder action).
    • Mail - Indicates the given invoice was sent by mail (e.g. using the Send Mail action).
  • Invoice Format - Shows the format in which the given invoice was sent to the customer. By default, it is empty until the invoice is sent. For example, the following formats might be displayed:
    • PDF - When the invoice is delivered via email (e.g. using the Send Reminder action).
    • Paper - When the invoice is delivered via mail (e.g. using the Send Mail action).
  • Invoice Delivery Status - Shows the status of the invoice after it was sent to the customer. By default, it is empty until the invoice is sent. The following statuses might be displayed:
    • For mail - Sent, Error, Processing, Given to Post, Printed, Enveloped, Delivered, Undelivered, etc.
    • For email - Sent, Error, Viewed, Replied, etc.
  • Original/Duplicate Invoice
  • Upload Date
  • Payment Score
  • Invoice Payment Pending Amount
  • Scheduled Payment Date

Delete

Additional info

For the detailed flow of setting up the System Custom Fields and ERP/CRM Custom fields, see

System Custom Fields (Editable Custom Fields)

and

How to Configure ERP/CRM Custom Fields in YayPay

After selecting the columns click Apply Changes.

To bring the grid to its default view, click Reset Columns to Default.

Grid Filters

Almost all columns have filters incorporated to select data based on the information in the particulate column. 

  • Date and Due Date columns: for the results to be shown only for the chosen period of time, select the date range (minimum one day), and click FILTER. Note: both past and future dates can be applied.

To remove the filter click the filter icon and the CLEAR button.


  • Columns with numeric filters: Balance, Amount, Age, Disputed Amount, Balance in Business Currency, Amount in Business Currency, Credit Limit.

  • Other columns with filtering functionality: Customer, Billing Contact Email, Parent Company, Currency, Workflow, Custom Status, all custom field columns (ERP/CRM custom fields and System custom fields, customer-level and invoice-level)

  • Custom Status column: you can set the custom status directly from the grid cell and subsequently filter the invoices by their custom status.


Delete

Note

Grid filters are not saved in case you reload the page or log out!


To clear all grid filters, use the Clear Filters button. Note, that upon clicking on it, the filters set up from the Header will also be removed.


Determining Expected Payment Date

The Expected Payment Date column displays a date determined by YayPay based on the priority listed below:

  1. Promise to Pay - If a promise to pay with a future date is available for an invoice, YayPay displays it.
  2. Cash Prediction - If no promise to pay with a future date is available, YayPay displays a future prediction date calculated by its machine learning algorithms.
    To learn how to enable payment prediction and how it works, see the Payment Projections & Cash Forecasting‍ article.
  3. Average Payment Time (APT)- If the previous methods do not apply, YayPay does the following to determine the expected payment date:
    1. Calculates the APT for the given customer.
      For YayPay to be able to calculate APT, there must be at least one invoice for the given customer closed within the past year (i.e. not exceeding 365 days from the current date).
    2. Adds the APT to the date a given invoice was issued to determine its expected payment date.
  4. Invoice Due Date - If all else fails, YayPay displays the invoice due date.
Delete

Warning

If you include the Expected Payment Date column (from the Invoice Data Source) in your reports in the BI module, and if the data displayed is based on the Average Payment Time (APT) calculation (as described in point number 3 above), then the value of this column will be recalculated and updated once a day only. This is in contrast to values of other columns in your reports that update whenever you display or refresh them.


Actions with Invoices

The actions bar is found above the invoices grid.

Note: some actions are unavailable for multiple invoices selection.

Download Invoice - a single invoice is downloaded as a PDF file, and multiple invoices are downloaded in one ZIP file.

Send Reminder - Sends a manual email reminder related to the given document.
For invoices, the default recipient is the customer's billing contact and the invoice is attached as a PDF file. Optionally, you can also attach other files using the Attach Files drop-down menu or by using drag-and-drop functionality.
The activity of sending manual reminders is logged on the ACTIVITY tab located at the bottom of the Statement page.
For more details, see Manual reminders in the invoice section.

Send Mail (provided the Outsourced Mail feature is enabled) - configure a physical mail sending.

Add Note - ability to create a note on the invoice level (created notes can be found on the Invoice View page). Along with the action, there is an ability to create a Task on the invoice level. 

Open Dispute - Opens a dispute for the invoice.
In the dialog that opens, you can set the disputed amount, specify dispute code or add a comment.
You can also request and access the advanced disputes functionality, which offers a dedicated Disputes page along with a range of additional features such as editing the Disputed Amountmanaging dispute assignees,attaching documents, etc
By default, opening a dispute (for example from the Statement page or Customer Portal) also automatically creates a task. To prevent YayPay from doing so, go to Settings| Business and check Do not create task when dispute is opened.

Manage Dispute - Manages an opened dispute for the selected invoice.
In the dialog that opens, you can edit or resolve the dispute.
You can also request and access the advanced disputes functionality, which offers a dedicated Disputes page along with a range of additional features such as editing the Disputed Amountmanaging dispute assignees,attaching documents, etc.

Exclude invoice from Workflow and Global Rules - Excludes the selected invoice from the current customer's workflow and global rules (manually).
Opens the Exclude from Workflows and Global Rules dialog where you can choose whether to exclude the invoice from both workflows and global rules, or only workflows.
To keep the invoice included in global rules only, check the Keep invoices included in global rules check box and click PROCEED.

Delete

Tip

To always keep the invoices included in Global Rules, check Exclude Invoices - Keep invoices included in global rules by default in Settings | Business.


Include to Workflow - ability to include the invoice from the current customer's workflow manually

Add Promise to Pay - ability to create a Promise to pay condition for the invoice (one per invoice) 

Manage Promise to Pay - ability to edit and delete a Promise to Pay. You can modify the promise date, description text, and the amount (only for a single invoice selected). Also, there is an option to delete the existing Promise to Pay.

Upload Supplemental Document - Selects or drag and drops a supplemental document on the invoice level. Once uploaded, the attached documents can be found on the Invoice View page.

Delete

Note

You can attach the same file to multiple invoices by selecting the invoices and clicking the Upload Supplemental Document action.

You can attach a maximum of 10 files to one invoice.

Download Documents - download the documents attached to the invoice (if any).

System Custom Fields - add the value of the system custom field for the chosen invoices. It will be displayed in the grid under the respective custom field title:

 


Other actions:

Expand Grid

Use the Expand Grid option to be able to view and manage more invoices via a single view.

Export to Excel

Export the current outline of the grid to be able to manage invoices in Excel.

The name of the downloaded is "Invoices_report_Month_DD_YYYY".

Note: The content of the exported file is influenced by the grid and header filters, pipeline, search, and sorting.

Delete

Email Report

For different reasons (e.g. connection problems), report downloading can be delayed. For such cases, there is a setting 

Email Aging/Invoices/Statement Excel report to user provided in the system.

To have your report sent to your mailbox when it is ready, go to Settings > Business and enable this setting: 

Note, that this option applies only to delayed reports. If your report is generated without any delays, it will be downloaded in the usual way.



Can't find what you need?

Contact our support team support@yaypay.com for help.