header7

Customer Prepayments

Customer Prepayment Audit Report

 

Customer Prepayment Audit Report is a reconciliation tool used to reconcile the Customer Prepay Deposits General Ledger account. The audit shows the open customer prepays by order. Any closed prepay on this list should be removed by using a Journal Entry. Select a printer, or print to the screen, and answer the prompt Print Prepayment Audit? (Y/N). The system will then prompt Choose Report Type: C=Cash/Check/Credit G=G/L F4=End.  To print all customer prepayments, two separate reports will need to be printed as the system cannot print both together.

 

At the end of the report, the system will also print the total of the On Accounts that presently reside in the Customer Prepay Deposits account.  The addition of the On Accounts balance and the balance of the customer prepayments should equal the Customer Prepay Deposits G/L balance.

 

It is suggested that this report be printed at least monthly as part of the end of the month reconciliation of the General Ledger.

 

Customer Prepayment Audit Report - ARM 4

DPU514

RECORD USED AND FILE NAME

AVAILABLE CRITERIA

INFO DISPLAYED (IN  COLUMN SEQUENCE)

SORTS BY

Open Order Header - UD01

Print Prepayment Audit? (Y/N)

Check/CC Number

Check/Credit Card Number

Order Header History - UD91

 

Customer Number

 

Customer Prepayments - UD07

 

Customer Name

 

 

 

Order Number

 

 

 

Total Order Price

 

 

 

Amount Applied

 

 

 

Remaining in G/L

 

 

 

Report Totals

 

 

 

Cash On Account in A/R (Total OAs, added to Report Total to give Total G/L balance)

 

 

 

Report Type (Cash/Check/Credit or G/L)