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) |
|