Payment Algorithms FAQ

Question: What are payment algorithms and how are they used?

Answer: Payment algorithms are used as a productivity tool to automatically apply a customer deposit based on expected payment logic used consistently by customers. They are typically used in conjunction with bank lockboxes, where the bank is supplying the payment ID, payment amount and the payment’s ABA routing number and bank account number (which is cross-referenced to a customer in Customer Bank Account Maintenance).

Note Payment algorithm use is recommended only for customers that have a relatively small number of open accounts receivable transactions at any time (e.g., less than 100), and have predictable payment patterns. It is highly recommended that you avoid using these on high-volume accounts receivable transaction accounts, such as mass merchants.

The first step is to decide which payment algorithms will be eligible to be used in Accounts Receivable Control Maintenance. Then, in Group Payment Rule Maintenance or Customer Payment Rule Maintenance, decide which payment algorithms will be used for which groups of customers, or specific customers.

Note You must select payment algorithms in the exact order that you want them to be processed. If you want the Single algorithm to be processed first, it must be selected first.

Payment Algorithm

Description

Single

Single accounts receivable transaction. This compares the deposit amount with any single accounts receivable transaction by expected pay date, taking into consideration eligible cash discount. The software searches by expected date.

Cumulative Balance - All

The cumulative balance of all transaction reference types. This compares the deposit amount with the cumulative accounts receivable balance of all reference types by expected pay date, taking into consideration eligible cash discount.

Cumulative Balance - Invoice

The cumulative balance of invoice reference types. This compares the deposit amount with the cumulative accounts receivable balance of invoice reference types by expected pay date, taking into consideration eligible cash discount.

Cumulative Balance - Invoice and Credit

The cumulative balance of invoice and credit memo reference types. This compares the deposit amount with the cumulative accounts receivable balance of invoice and credit memo reference types by expected pay date, taking into consideration eligible cash discount.

Note Payment algorithms ignore absorption business rules. For a payment algorithm to apply, it must find exact amounts.

The following table displays an example of payment algorithm calculations:

 

 

 

 

 

 

Algorithm Values

Reference Number

Reference Type

Expected Pay Date

Open Amount

Eligible Cash Discount

Net Open Amount

Single

Cumulative Balance - All

Cumulative Balance - Invoice

Cumulative Balance - Invoice and Credit

NJ.1

Invoice

12/25/2020

100

-2

98

98

98

98

98

NJ.2

Credit Memo

12/26/2020

-40

 

-40

n/a

58

98

58

CB.1

Chargeback

12/27/2020

60

 

60

60

118

98

58

NS.1

Non-Sufficient Funds

12/28/2020

60

 

60

n/a CB.1 same amt

178

98

58

CB.2

Chargeback

12/29/2020

20

 

20

20

198

98

58

NJ.3

Invoice

12/30/2020

200

-4

196

196

394

294

254

NJ.4

Credit Memo

12/31/2020

-40

 

-40

n/a

354

294

214

NJ.5

Invoice

01/01/2021

150

 

150

150

504

444

364

FC.1

Finance Charge

01/02/2021

25

 

25

25

529

444

364

OA.1

On Account

01/03/2021

-75

 

-75

n/a

454

444

364

NJ.6

Invoice

01/04/2021

220

-3

217

217

671

661

581

The following table provides several payment examples for the above algorithm calculations:

Deposit Amount

Payment Algorithm Is Applied To

$60.00

CB.1 (first Single it found)

$198.00

NJ.1, NJ.2, CB.1, NS.1, CB.2 (first Cumulative Balance - All it found)

$444.00

NJ.1, NJ.3, NJ.5 (first Cumulative Balance - Invoice it found)