85 Account Reconciliation Processing Options

This chapter contains these topics:

Section 85.1, "Refresh Reconciliation File (P09130),"
Section 85.2, "Bank Statement Match (P09131),"
Section 85.3, "Manual Reconsolidation by Debits & Credits (P09131D),"
Section 85.4, "Your Custom Reformat Program (P09501),"
Section 85.5, "Match Tape File to Reconciliation File (P09510),"
Section 85.6, "Automatic DR/CR Reconciliation (P09531)."

85.1 Refresh Reconciliation File (P09130)

Processing Option	Processing Options Requiring Further Description
BEGINNING AND ENDING DATE RANGE:
1. Enter the date you want to use as a Beginning date for the build of the reconciliation file.
2. Enter the date you want to use as an Ending date for the build of the reconciliation file.
RECONCILED STATUS:
3. Enter a '1' to see both reconciled and unreconciled records. Default of blank will include unreconciled only.
LEDGER TYPE FILTER:
4. Enter a valid ledger type to see F0911 transactions in only that ledger type. If left blank and the following multi-currency option is blank, all ledger types will be used. - OR - If doing multi-currency processing, enter a '1' to select all 'CA' ledger type transactions, and domestic only 'AA' ledger type transactions (where the transaction currency is the same as the company currency)
DOCUMENT TYPE FILTER:
5. Enter a '1' to include 'AE' document type transactions. If left blank (the default) 'AE' document type transactions will not be written to the file
MULTIPLE MEMBERS:
6. Enter a '1' to create or refresh a specific member of file F0911R. The name of the member will be the version ID. Leave blank to use a single member only (F0911R). The version ID must start with an alpha character and can be a maximum of ten characters.

85.2 Bank Statement Match (P09131)

Processing Option	Processing Options Requiring Further Description
VIDEO CONSOLIDATION OPTION:
1. Enter a '1' to consolidate transactions with the same Account ID and Reference 1 value in the Manual Reconciliation video. Note: If a '1' is entered, DREAM Writer Data must be sequenced by Account ID, Reference 1.
BANK STATEMENT FILE INFORMATION:
2. Enter a '1' to require that G/L transactions have a corresponding set of Bank Statement transactions before any reconciliation occurs. Note: If a '1' is entered, DREAM Writer Data must be sequenced by Account ID, Reference 1.
MULTIPLE MEMBERS:
3. If using multi-member processing of F0911R, enter the version name of the Refresh Reconciliation File program (P09130) to be used for reconciliation.
ASSIGN RECONCILED NUMBER:
4. Enter a '1' to automatically assign a reconciliation number. This number can be overridden at the time of reconciliation. The number will be written to the Reference 3 field. If left blank, Reference 3 will not be used.

85.3 Manual Reconsolidation by Debits & Credits (P09131D)

Processing Option	Processing Options Requiring Further Description
MATCHING DEBITS AND CREDITS:
1. Enter a '1' to require Total Debits and Total Credits to balance for selected records.
2. If matching debits and credits, enter a tolerance limit. If left blank, the tolerance is zero. Note: Enter this amount as a whole number with no decimals.
ABSOLUTE VALUE SORT:
3. Enter a '2' to sort transactions by absolute value. Transaction amounts will be sorted regardless of their positive/negative sign. If left blank, all transactions will be sorted by G/L Date.
MULTIPLE MEMBERS:
4. If using multi-member processing of F0911R, enter the version name of the Refresh Reconciliation File program (P09130) to be used for reconciliation.
ASSIGN RECONCILED NUMBER:
5. Enter a '1' to automatically assign a reconciliation number. This number can be overridden at the time of reconciliation. The number will be written to the Reference 3 field. If left blank, Reference 3 will not be used.

85.4 Your Custom Reformat Program (P09501)

Processing Option	Processing Options Requiring Further Description
Enter the short account number of the bank account for the payments being reconciled. (This is the 8-digit number. You must enter leading zeros.)

85.5 Match Tape File to Reconciliation File (P09510)

Processing Option	Processing Options Requiring Further Description
Enter the 8 digit account ID for the bank account of the payments that you are reconciling.

85.6 Automatic DR/CR Reconciliation (P09531)

Processing Option	Processing Options Requiring Further Description
PROOF OR FINAL MODE:
1. Enter a '1' to Reconcile in Final mode. If left blank, the Reconciliations will be processed in Proof mode, and no file updates will occur.
RECONCILIATION FILE MEMBER:
2. If using multi-member processing of the F0911R file, enter the version name of the Refresh Reconciliation File program (P09130) to be used for reconciliation.
RECONCILIATION THRU DATE:
3. Select the date to reconcile transactions thru: '0' - Today's date (default) '1' - Last day of the current period - OR - Enter a specific date to reconcile transactions thru. Note: The current period refers to the financial reporting period.
AUTOMATIC WRITE-OFF OPTIONS:
4. Enter a version number to override standard journal entry processing (DREAM Writer XT0911Z1, version ZJDE0001).
5. Enter the version of the Post Program if you wish to automatically post the write-off journal entries. If left blank, the write-off entries will remain unposted.
6. If not using the GLRXxx AAI, enter the G/L account to be used as the offset for the write-off entry. Business Unit (optional) Object Subsidiary
7. If not using the GLRXxx AAI, enter a value to be used as the tolerance threshold for creating an automatic write-off. If the value is a percentage, include the percent (%) symbol after the value.
AUTOMATIC WRITE-OFF OPTIONS CONT'D:
8. Select the date to be used as the journal entry date: '0' - Today's date (default) '1' - Last day of the current period - OR - Enter a specific date to be the journal entry date. Note: The current period refers to the financial reporting period.
AUTOMATIC WRITE-OFF OPTIONS CONT'D:
9. Enter the document type to be used when creating write-off entries. If left blank 'JE' will be used. Note: If a value is entered it will be validated against User Defined Code table 00/DT, and will use the Reconciliation next numbers (system 09, 6th entry). If 'JE' is used Journal Entries next numbers will be used.
ASSIGN RECONCILED NUMBER:
10. Enter a '1' to automatically assign a reconciliation number. This number will be assigned from Reconciliations next numbers (system 09, 6th entry), and will be written to the Reference 3 field. If left blank nothing will be written to the Reference 3 field.
11. If assigning a reconciliation number, enter a number up to 8 digits to override the number assigned from Reconciliations next numbers.
RECONCILIATION CODE:
12. Enter a code to be used to flag records in the F0911 and F0911R files as reconciled. If left blank 'R' will be used as the reconciliation code. The value entered will be validated against UDC table 09/RC.
REPORT CONTROL:
13. Enter a '1' to disable the print of selected reports. Unreconciled Items Created Journal Entries Open Items