Cash Application Worksheet

Customer payments should be processed on a daily basis. In preparation for entering and applying the payments to the Customer Accounts, print the Cash Application Worksheet.
The worksheet lists all outstanding invoices for the customers selected, with the dates and divisions and can be used to help determine how best to proceed, before entering the payment into the Customer's account.

Note: The security by division feature as determined by Divisional Restricted Views does NOT apply to this Cash Application Worksheet utility.

Enter the list of customers to print as follows:

SEQ

The software keeps track of the number of entries made.

CUST #

Enter the desired customer number or lookup the customer in the Accounting Customer Search window.

NAME

The Customer's name will display.

ACCOUNT

Window to view the account details for the customer as outlined in View Customer's Current Account.

BALANCE

The Customer's current Account Balance displays.

Finished ?

When all customers from whom a payment has been received for that day have been listed, click the ACCEPT button twice (once for the current line and once for the entire selection) to print the list.

PRINT WORKSHEET

CUT-OFF DATE

This date determines the ending point for printing invoices for the selected accounts.
Accept today's date for the cut-off date or over-type it with a preferred date.

AGE AS OF Month End

Aging refers to the classification of the unpaid invoices according to Current, 31-60, 61-90 and Over 90 days.

Check this box to age the accounts using the last day of the month of the Cut-Off Date selected.
Example: If the current month end was February 28th, an invoice issued January 31st would be aged as 31-60 Days (with the rest of January invoices).

Uncheck this box to age the invoices according to invoice date.
Example: If the current month end was February 28th, an invoice issued January 31st would be aged as Current.

Finished?

Click ACCEPT to proceed with the list, or CANCEL to abort.

Clear Worksheet:

After the worksheet has been generated, the option to clear the worksheet is provided.

Click YES to clear the selection queue to begin fresh next time.
Click NO to save the list and retain the ability to reprint the same selection.

Note: Only unpaid invoices, finance charges and unapplied payments appear on this report.
The report format is similar to Aged A/R Report Detail, but this program has the advantage of easy single customer selection.