How do I reconcile Cash Management to General Ledger? (By Transaction or Batch)
Description


Cause
Resolution
  1. Reconcile Cash Management Totals:
  2. Verify balances Cash Management and General Ledger balances:
    • To Verify the balances in Cash Management to General Ledger, see How can I tell if Cash Management and General Ledger are in balance?. If Cash Managements Balance doesn’t agree run the reports rolling back the period until you locate the last period where the balance agrees. Reconcile the transactions in the period immediately following that period to locate the variances using the directions below.
  3. Print and compare reconciliation reports to find differences between Cash Management transactions and General Ledger transactions:
    1. Verify General Ledger and Cash Management has all entries posted.
      1. From the General Ledger Tasks menu, select Post Entries.
      2. Click Start and review the GL Post Entries Journal for any rejections.
      3. From the Cash Management Inquiry menu, select Entries, Unposted Transactions by Bank.
      4. Select the bank account and correct any unposted entries.
    2. In Cash Management, from the Reports menu select Reconciliation, Cash Detail to GL.
    3. Enter the beginning and ending date of the period you are reconciling.
    4. If you have multiple bank accounts, condition the report for the bank you need to reconcile:
      1. Click Conditions, then Add.
      2. From the Field list, select Bank Account.
      3. For the Operator, select Equal to.
      4. In the Value area, type the Bank account ID (from Setup, Bank Accounts, Bank account).
      5. Click OK twice.
    5. Print the report.
    6. In General Ledger, from Reports, select Entries, Totals By Batch.
    7. Click Conditions and enter the following conditions:
      1. Accounting Date greater than or equal to the from date used on Cash Detail to GL Report
        AND
      2. Accounting Date less than or equal to the through date used on Cash Detail to GL Report
        AND
      3. Account equal to your GL Cash Account number
    8. Print the report.
    9. Compare the batch totals from each report.
  4. After finding the batch that is causing the difference, print the report to help determine error correction:
    1. In General Ledger, from Reports, select Entries, Entries by Batch.
    2. Click Ranges and select the application of origin and batch.
    3. Compare the batch to the entries on the Cash Detail to GL report.
    4. If you find discrepancies, review the batch details on the Cash Detail to GL report and compare them to the GL Entries by Batch report for the same batch.
    5. Record correcting entries in General Ledger or Cash Management to balance. Work with your accountant to determine or Consultant to determine the entries to make.

[BCB:156:Chat 300 CRE US:ECB]

Steps to duplicate
Related Solutions

Reconciling Cash Management to Cash Management
What could cause the Cash Management and the General Ledger to be out of balance?