Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    Untitled

    Uploaded by

    Vinoth Kumar K
    This document provides instructions for automatically reconciling bank statements in Oracle Cash Management in 3 steps: 1) Define reconciliation options and submit an auto-reconciliation request, 2) Review the reconciliation report and address any errors, 3) Transfer transactions to the general ledger and review the GL reconciliation report. It describes how to import bank statements, automatically match transactions, handle exceptions, and clear reconciled items. The full reconciliation process involves setting preferences, running the auto-reconciliation program, correcting errors, and ensuring accurate general ledger records.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Untitled

    Uploaded by

    Vinoth Kumar K
    22 views2 pages
    This document provides instructions for automatically reconciling bank statements in Oracle Cash Management in 3 steps: 1) Define reconciliation options and submit an auto-reconciliation request, 2) Review the reconciliation report and address any errors, 3) Transfer transactions to the general ledger and review the GL reconciliation report. It describes how to import bank statements, automatically match transactions, handle exceptions, and clear reconciled items. The full reconciliation process involves setting preferences, running the auto-reconciliation program, correcting errors, and ensuring accurate general ledger records.

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for automatically reconciling bank statements in Oracle Cash Management in 3 steps: 1) Define reconciliation options and submit an auto-reconciliation request, 2) Review the reconciliation report and address any errors, 3) Transfer transactions to the general ledger and review the GL reconciliation report. It describes how to import bank statements, automatically match transactions, handle exceptions, and clear reconciled items. The full reconciliation process involves setting preferences, running the auto-reconciliation program, correcting errors, and ensuring accurate general ledger records.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    22 views2 pages

    Untitled

    Uploaded by

    Vinoth Kumar K
    This document provides instructions for automatically reconciling bank statements in Oracle Cash Management in 3 steps: 1) Define reconciliation options and submit an auto-reconciliation request, 2) Review the reconciliation report and address any errors, 3) Transfer transactions to the general ledger and review the GL reconciliation report. It describes how to import bank statements, automatically match transactions, handle exceptions, and clear reconciled items. The full reconciliation process involves setting preferences, running the auto-reconciliation program, correcting errors, and ensuring accurate general ledger records.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 2

    Reconciliation Setup

    This chapter covers the following topics:


    • Reconciling Bank Statements Automatically
    • Reconciling Bank Statements Manually
    • Creating Payments and Receipts Transactions
    • Creating Miscellaneous Transactions
    • Recording Exceptions
    • Entering Reversals
    • Reconciling Corrections and Adjustments to Bank Errors
    • Manually Clearing and Unclearing
    • Marking a Bank Statement as Complete
    • Transferring Bank Reconciliation Transactions to Your General Ledger
    • How Using Cash Management Affects Your Closing Process
    • Archiving and Purging Imported Bank Statements
    Reconciling Bank Statements Automatically
    You can use the AutoReconciliation program to automatically reconcile any bank
    statement in Oracle Cash Management. There are three versions of the program:
    • AutoReconciliation: Use this program to reconcile any bank statement that has
    already been entered in Cash Management.
    • Bank Statement Import: Use this program to import an electronic bank statement
    after loading the bank statement file into the Bank Statement Open Interface
    tables.
    See: Importing Bank Statements, page 4-16.
    • Bank Statement Import and AutoReconciliation: Use this program to import and
    5-2 Oracle Cash Management User Guide
    reconcile a bank statement in the same run.
    You can run these programs from the Submit Request window, the Reconcile Bank
    Statements window, or the Bank Statement Interface window. 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. See: Loading the Bank
    Statement Open Interface Tables, page 4-1
    After you run the program, you can review the AutoReconciliation Execution Report
    to
    identify any reconciliation errors that need to be corrected. This report is
    produced
    automatically, or you can run it whenever needed. You can also review
    reconciliation
    errors online.
    After 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. If lines remained
    unreconciled, you can:
    • Update the bank statement and rerun the AutoReconciliation program.
    • Reconcile the statement lines manually.
    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. 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.
    To reconcile a bank statement automatically:
    1. Define your Reconciliation options. See: About Bank Reconciliation, page 1-2 and
    System Parameters, page 2-14.
    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: Using
    AutoLockbox, Oracle Receivables User Guide and Running
    AutoLockbox, Oracle Receivables User Guide.
    2. Navigate to the Submit Request window.
    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.
    Reconciliation Setup 5-3
    3. Select the AutoReconciliation program.
    4. Enter the Bank Branch for the statements that you want to reconcile. This field
    is
    required.
    5. Enter the Bank Account Number for the statement that you want to reconcile. If
    you
    do not enter a bank account number, you reconcile statements for the entire bank
    branch.
    6. In the following fields, enter a statement number or select one from the list of
    values:
    • Statement Number From: the beginning statement number in the range of
    statements to be reconciled.
    • Statement Number To: the ending statement number in the range.
    7. Enter dates in the following fields:
    • Statement Date From: the opening day of the bank statement period.
    • Statement Date To: the closing day of the bank statement period.
    • GL Date: (Required). The default date for all General Ledger journal entries
    generated by AutoReconciliation.
    8. Select an Organization or leave blank to reconcile transactions from all
    organizations.
    9. Select a Receivable Activity and Payment Method to create Miscellaneous Receipts
    for differences that AutoReconciliation encounters when matching remittance
    batches or NSF transactions within tolerances.
    10. Specify how to handle any NSF or rejected receipts that are in your bank
    statement.
    Choose one of the following actions:
    • No Action to resubmit the check or request for transfer later.
    • Reverse to reopen the invoice.
    • Debit Memo Reverse to create a debit memo that replaces the item closed by
    the original receipt.
    11. Submit your request.
    12. When the concurrent request is finished, review the AutoReconciliation
    Execution
    Report for reconciliation errors. Also review the Bank Statement Detail Report,
    which shows reconciled and unreconciled statement lines.
    5-4 Oracle Cash Management User Guide
    13. If any statement lines remained unreconciled, or you need to correct a
    reconciled
    line, use the Reconcile Bank Statement Lines window to manually reconcile those
    lines.
    14. Transfer the accounting transactions you created during reconciliation for
    Payables
    and Receivables to your General Ledger.
    15. Review the GL Reconciliation Report.

    You might also like