Help:AR1-Reconcile VL Statement
This option will reconcile the Van Line Statement Download which was prepared by the Van Line Statement Download module. If you do not have this module, then call our Sales office to see which Van Lines have an automated statement download available. Before you use this option, you must have first prepared the Van Line Statement Download file by using the Van Line Statement Download module.
This program will automatically bring up each item on the Statement File, apply the cash to the matching Billing Detail Lines, and even make the preliminary adjustments for you. It can greatly speed up your statement reconciliation process.
As soon as you enter this program option, it will find the Statement File, calculate its remaining unapplied balance and ask you to select the A/R Clearing Account entry for this Statement. It will then display the following result fields in this window:
Van Line Statement File ¾ Statement Total, To Be Applied, Items Applied, Items Remaining: These fields display the total amount on the statement, the dollar amount remaining to be applied, the total number of items applied and the total number of items remaining to be applied.
A/R Clearing Account File ¾ Bank Number, Deposit, Deposit Date, Unapplied Amount: These fields display the information contained in the A/R Clearing Account entry for the receipt of this Statement. Normally the Unapplied Amount of this file will equal the To Be Applied amount on the Van Line Statement File.
Statement *: Enter the Statement Number for this statement. The Access Number from the A/R Clearing Account selection will be placed in this field for you. This is a required field.
Posting Month/Year *: This is taken from the Deposit Date; however, you can override this data. This is the Calendar Month/Year in which the various transactions generated during this reconciliation process will be posted to the General Ledger. This is a required field.
[Ö] Adjust Revenue Automatically: Check this box if you wish the program to automatically adjust the entries as the cash is applied. This is recommended, since it is less work for you to remove the adjustment after it has been automatically made than to make the adjustments yourself. Please be sure to verify each of the system's automatic adjustments for accuracy before you record each transaction.
[ Begin ] Press this button to begin the process. The entire statement can be reconciled in one sitting or in multiple sittings. A new Batch number will be assigned for each sitting, but a report on the statement can be obtained from the A/R Cash Receipts Journal as long as a Statement Number has been assigned.
Each item on the statement will be displayed, the A/R Master File displayed, and finally the billing items with the amounts applied. If the entry in the Statement File is not related to an A/R File, then the Journal Entry window will be automatically displayed. Each item will be displayed until all have been fully reconciled.
[ Next ] Press this button to continue with the next entry on this statement.
[ Close ] Press this button to end the Statement Reconciliation process for now. It will automatically pick up just where you left off the next time that you select this option.
[ Help ] Press this button (if available) or the F1 key to view the Help text for this window.
