Matching NSF payments

To import NSF payments, Infor Public Sector must match each payment in the import file to a payment in the database.

If the NSF import file includes payment keys, then the payment keys can be used to identify the correct payments.

If the import file does not include payment keys, then Infor Public Sector will attempt to locate the correct payments based on the account number, the payment amount, and the payment date.

  • If one payment is found matching the amount and the payment date of a payment in the import file, Infor Public Sector will reverse that payment.
  • If more than one payment is found matching the amount and payment date, then Infor Public Sector will also check the time of the payment in the import file. If one of the matching payments in the database also matches the payment time, then Infor Public Sector will reverse that payment. Otherwise Infor Public Sector will reverse the payment with the latest time.

    For example, suppose the import file includes a payment of $50.00 dated April 27 at 3 PM. If the database includes a payment of $50.00 dated April 27 at 2 PM, and another payment of $50.00 dated April 27 at 4 PM, then Infor Public Sector will reverse the payment with a time of 4 PM.

  • If no payment is found matching the amount and payment date, Infor Public Sector will load the most recent posted and unreversed payment for the account. If the amount of this payment matches the amount of the payment in the import file, then Infor Public Sector will reverse the payment. Otherwise Infor Public Sector will return an exception.

In other cases the NSF import file may not include payment dates, just account numbers and payment amounts. If so, Infor Public Sector will attempt to match each payment in the import file by looking up the most recent posted an unreversed payment for the account. If the amount of this payment matches the amount of the payment in the import file, then Infor Public Sector will reverse the payment. Otherwise Infor Public Sector will return an exception.