How to pull a list of invoices that were past due when paid?


There is currently no straightforward way to pull this data since the Invoice Status changes to Paid after the payment is made, and there is not an option to pull Invoice Status from a past time period.

If you need to obtain this data, here is what you can do:

  1. Pull the Invoices - Summary export (Select - Invoice Status: Paid, Export On: Modified) These filters will show when the invoice was paid and the status changes, so pick a time range accordingly.
  2. Once downloaded, you would use the recovery_reason column to determine how the payment was recovered if the initial transaction failed but a subsequent one succeeded. If the field is not populated, this means that the initial transaction did NOT fail. If the field is populated, then you can look up the recovery reason here: