Unapplied Payments Report

If a customer sends a payment, but does not indicate clearly which invoices are to be paid, the payment may be left unapplied on the account.
An unapplied payment is a payment that has been entered and accepted, but has not been applied to pay off any invoices on the customer's account.
An unapplied payment is indicated as having an open balance, and it will continue to show on the customer's account until it is fully used up against invoices.

At least once a month, print this Unapplied Payments Report to identify all payments needing to be cleared.
Contact the customer and determine which invoices should be paid. Then follow the instructions in Customer Payments on how to call up the unapplied payment.

The prompts are:

CUT-OFF DATE

Accept today's date or enter a cut-off date.

AGE AS OF ...month end...

Check this box to age the accounts as of month end.
Uncheck this box to age the accounts according to invoice date.

STARTING NAME

Leave this field blank for all customers or type in the first name or look up the customer in the Accounting Customer Search window.

ENDING NAME

Leave this field blank for all customers or enter the ending name.

CUSTOMER TYPE

Check this box for all customer types.

Uncheck this box to print the report for a single specific type of customer.

TYPE

Enter the specific customer type or select it from the drop-down list as setup in Customer Types.

ALL CURRENCIES

Check this box to include customers for all currencies.

Uncheck this box to print the report for a single currency.

CURRENCY

Enter the specific currency code or select it from the drop-down list.

DIVISION, "ALL" OR "SEL"

Select one of the following Division filters:

• Type ALL to include all divisions in the resulting list.
• To generate the list of customers or documents from a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type SEL to select several specific divisions or divisions by accounting region to include in the list, as outlined in Division Select By Region.

DIVISION SOURCE

Choose the division source as follows:

• Select Customer to filter the unapplied payments on the output by the division assigned to each customer in Customer Information.
  
• Select Document to filter the unapplied payments on the output by the division assigned on the document regardless of the customer's division.

Both divisions are printed on the PDF and the spreadsheet output.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.
Click ACCEPT to generate the report, or CANCEL to abort.

Report Output:
The report output to PDF includes the Customer#, Name, Customer Division, Contact Name and Telephone#.
The details for each customer include the Check#, Check Date, Original Amount, Amount already Applied, Discount Amount Given, the Unapplied Balance, and the Document Divisions.

Spreadsheet Export:
The Excel output to a spreadsheet also includes the Customer#, Name, Contact Name and Telephone#.
The details for each customer include the Check#, Check Date, Original Amount, Amount already Applied, Discount Amount Given, Unapplied Balance, the Customer and the Document Divisions, and for outstanding balances entered in the Counter Customer Payments the auto-assigned Receipt# and optional Comment are printed.