System Reporting on Early Payment Incentives

Early Payment Incentives are taken into account for all system reporting, and values in Dashboard charts and in the Invoices table are dynamically updated to reflect when discounts are active and when they expire.

 

The following two Dashboard charts update to take incentives into account:

The Invoices table, on the manage invoices tab, uses the Amount, Incentive/Penalty and Balance columns to clearly indicate how incentives are currently applied to any individual invoice.

invoices_table_with_incentive.jpg

The following logic is used to determine incentive values in the Invoices table:

For example, if an invoice for $90 is due on December 27, and has a $9 incentive for payment more than 10 days early, the Invoices table will display as follows:

noate.gif 

REPORTING ON INCENTIVES PROVIDED


As you evaluate whether to continue offering early payment incentives, or whether to increase or decrease the discount, you’ll likely need to know how much the incentives are costing you. Follow the steps below to determine the total amount of Early Payment Discounts provided over any given time period.

  • Filter the Invoices table for the time period you want to cover. (See Filter by Date Range.)

  • Set the Invoices table Status filter to display only Paid invoices. (See Filter by Invoice Status.)

  • Export the Invoices table. (See Exporting Invoice History.)

  • Open the export file in Excel (it will be a csv file), and locate the Early Payment Discount column. (Values in this column indicate the exact dollar amount of the discount applied to the invoice, whether the incentive was programmed as a flat rate or as a percentage.)

  • Sum the Early Payment Discount column. This value is the total in discounts you provided for early payments in the selected time period.

Next >