12/10/2023 0 Comments Reconciling a sweep bank account![]() The date must be in an open or future-enterable Payables or Receivables period. The default date for all General Ledger journal entries generated by AutoReconciliation. Statement Date To: the closing day of the bank statement period. Statement Date From: the opening day of the bank statement period. Statement Number To: the ending statement number in the range. Statement Number From: the beginning statement number in the range of statements to be reconciled. In the following fields, enter a statement number or select one from the list of values: ![]() If you do not enter a bank account number, you reconcile statements for the entire bank branch. This field is required.Įnter the Bank Account Number for the statement that you want to reconcile. Note: Alternatively, you may submit the request directly from the Reconcile Bank Statements or Bank Statement Interface windows by selecting AutoReconciliation from the Oracle Applications Tools menu.Įnter the Bank Branch for the statements that you want to reconcile. See: Using AutoLockbox, Oracle Receivables User Guide and Running AutoLockbox, Oracle Receivables User Guide. Note: If you do not use Oracle Receivables AutoLockbox, and your bank statement includes direct deposits or bank transfers, you must create the related receipts manually in Receivables before you can reconcile them automatically in Cash Management. See: About Bank Reconciliation and System Parameters. To reconcile a bank statement automatically:ĭefine your Reconciliation options. If you use Oracle General Ledger, you can reconcile you General Ledger cash account balance to your bank account balance by running the GL Reconciliation Report. Once you have reviewed your reconciliation results, you can transfer the accounting entries to your general ledger from Oracle Payables, Oracle Receivables, and Oracle Cash Management. ![]() Update the bank statement and rerun the AutoReconciliation program. You can also review reconciliation errors online.Īfter you automatically reconcile a bank statement and correct any reconciliation errors, you can run the Bank Statement Detail Report or use the View Bank Statements window to review reconciled and unreconciled statement lines. This report is produced automatically, or you can run it whenever needed. See: Loading the Bank Statement Open Interface TablesĪfter you run the program, you can review the AutoReconciliation Execution Report to identify any reconciliation errors that need to be corrected. You can also import and automatically reconcile a bank statement from the Bank Statement Loader program, by using the option of Load, Import and AutoReconciliation. You can run these programs from the Submit Request window, the Reconcile Bank Statements window, or the Bank Statement Interface window. See: Importing Bank Statements.īank Statement Import and AutoReconciliation: Use this program to import and reconcile a bank statement in the same run. There are three versions of the program:ĪutoReconciliation: Use this program to reconcile any bank statement that has already been entered in Cash Management.īank Statement Import: Use this program to import an electronic bank statement after loading the bank statement file into the Bank Statement Open Interface tables. You can use the AutoReconciliation program to automatically reconcile any bank statement in Oracle Cash Management. Reconciling Bank Statements Automatically
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |