Customer Payment History Analysis Report ranges and options

Ranges

See Report ranges.

Options

Print If Hist Balance Incr by XXX Percent

An increase/decrease percentage is included for the last 11 payment history transactions. A payment history transaction is created each time the Customer Entry Roll Balances Report is run. The most recent, not current, payment history is always displayed on Line 1 and all other payment history is rolled down a line. If you roll balances once a month, each payment history line should correspond to one month.

The increase/decrease percentage is calculated by subtracting the balance of the month you are interested in (for example, Month 2) from the previous month (for example, Month 3) and dividing by the previous month (for example, Month 3). This gives you your percentage increase or decrease over the previous month.

[(Month 3 Balance – Month 2 Balance) / Month 3 Balance] x 100 = Increase/Decrease %

You can limit the report to only those customers who have at least one increase/decrease over the percentage you specify. For example, you may only want to review those customers whose payment history increased by 30% or more. To review customers with a decrease in their payment history, you must specify the value as a negative, no greater than 99%. Note that this also includes all customers with an increase of zero and above.

Print If Hist Bal Incr Over XX Periods

You can include only those customers whose payment history has continually increased over a specified number of months (periods).

For example, if you specify 4, customers whose payment history has increased four months in a row are included on the report. This applies to any four months of the last 12 periods.

Print If Hist Past Due Incr By XXX Perc

The past due and balance amounts are included for each customer. An increase/decrease percentage is included for the last 11 past due payment history transactions. A payment history transaction is created and past due amount and balance updated each time the Customer Entry Roll Balances Report is run. The most recent, not current, payment history is always displayed on Line 1 and all other payment history is rolled down a line. If you roll balances once a month, each payment history line should correspond to one month.

The increase/decrease percentage is calculated by subtracting the past due amount for the month you are interested in (for example, Month 2) from the past due amount in the previous month (for example, Month 3) and dividing by the previous month (for example, Month 3). This gives you your past due percentage increase or decrease over the previous month.

[(Month 3 Past Due Amount – Month 2 Past Due Amount) / Month 3 Past Due Amount] x 100 = Increase/Decrease %

You can limit the report to only those customers who have at least one past due increase/decrease percentage over the percentage you specify. For example, you may only want to review those customers whose past due payment history increased by 30% or more.

Print If Cust Is Past Due By XXX Percent

The current balance, current past due amount, and current past due percentage are included for each customer as well as the balances and past due amounts for the past 12 payment history transactions. If the current past due percentage is equal to or greater than the percentage you specify, the customer is included on the report.

Print Balances Starting At Period (1-5)

Use this option to limit the number of customers that qualify to be included on the report. If you accept the default of zero, customers without a balance and those with balances in Periods 1-5 are included.

If you specify 1, all customers who have a balance in at least one of the five periods are included. All customers who have no period balances (but may have a service charge, miscellaneous credit, or unapplied cash balance) are excluded from the report, unless you are rolling service charges, miscellaneous credit, or unapplied cash balances into period balances in the Customer Entry Roll Balances Report.

To review those customers with overdue balances, specify 2, 3, 4, or 5.

For example, if you specify 2, the customer must have a balance in Periods 2-5. If you specify 3, the customer must have a balance in Periods 3-5.

The balance included on the report represents Periods 1 through 5 + Future Invoices + Service Charges - Miscellaneous Credits - Unapplied Cash. The past due balance represents period balances, which depend on options in the Special Transactions section in SA Administrator Options-Customers-Balances.

  • If you do not select any of the Special Transaction options, the past due balance is equal to Periods 2-5 minus Misc. Credits and Unapplied Cash plus Service Charges.
  • If you select Age Service Charges (Service Charges included in period balances), the past due balance is equal to Periods 2-5, minus Misc. Credits and Unapplied Cash.
  • If you select Age Miscellaneous Credits (Miscellaneous Credits and Unapplied Cash included in period balances), the past due balance is equal to Periods 2-5, plus Service Charges.
  • If you select Age Service Charges and Age Miscellaneous Credits, the past due balance is equal to Periods 2-5.

If the past due amount is a negative amount after deducting Misc. Credits and Unapplied Cash or totaling period balances that are negative, a zero is displayed instead of a negative amount.

Print If Over Credit Limit By XXX

You can limit the number of customers on the report by only including those who are over their credit limit by a specific amount. Their current balance (Periods 1 5 + Future Invoices + Service Charges - Miscellaneous Credits - Unapplied Cash) is compared to the credit limit to determine the difference. If you leave this field blank, all customers under and over their credit limit are included.

Print Only Customers On Hold?

Select Yes to include only those customer on credit hold.

The customer may be on hold for these reasons:

  • A hold period exists on the Customer Setup record and the period balances from that period through Period 5 are greater than the miscellaneous credit and unapplied cash amounts.
  • The total balance is greater than the credit limit.
  • In Customer Setup-Credit, the Sales Order Status field is No; the Sales Order Status field is Hold Until and the hold or open date is greater than the report date; or the Sales Order Status field is Open Until and the hold or open date is less than the equal date of the report.
Print History Detail?

History detail refers to the 12 payment history transactions that are included on the report.

Select Yes to include the balance, increase/decrease percentage, past due amount, percentage of balance, and past due increase/decrease percentage for each transaction.

Select No to exclude the payment history transactions. Only the static customer information, current balance, current past due amount, and current past due percentage is included on the report.

Print Credit References?

Select Yes to include the two credit references on the Customer Setup record.