How can I tell if Cash Management and General Ledger are in balance?
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]

  1. Reconcile Cash Management Totals
    See Reconciling the Cash Management Bank Reconciliation Report and General Ledger, for steps to reconcile the totals in Cash Management based on the bank statement you receive from your bank.
  2. Verify there are no unposted transactions:
    1. In Cash Management, from the Inquiry menu, select Entries, Unposted Transactions by Bank.
    2. Select the Register file then click OK.
    3. Double-click on the bank account.
      Note: You can click on the printer icon (to the left of the Conditions blue funnel button) to preview a report that includes the total of the unposted transactions.
    4. If the transactions have an Application of origin as CM, you can use Tasks, Post Entries in Cash Management to post them.
    5. If application of origin is not CM go to the Application of Origin to post the transactions. See Related resources for details.
    6. Post entries in General Ledger. See How do I post entries in General Ledger (GL)?
  3. Verify the current Cash Management and General Ledger totals are in balance:
    1. From the Cash Management Inquiry menu, select Bank Register.
    2. Note the Register Balance for your bank.
    3. From the General Ledger Inquiry menu, select Account.
    4. Note the Future Balance for the cash account.
    5. If the totals are in balance, then Cash Management and General Ledger are in balance.
  4. Verify balance by Period End and Statement End date:
    1. Open Cash Management
      1. Go to Reports, select Reconciliation, Bank Reconciliation.
      2. Select only the CM Register (Register) file and click OK.
      3. Enter the Statement Date of the period.
      4. Click Ranges, select the bank account and click OK.
      5. Click Start or Print Preview and review the report.
      6. Note the Register Balance as of Statement Date
    2. Open General Ledger
      1. Go to Reports, Select Year-to-Date Ledger.
      2. Check the box Modify Date Range.
      3. Enter the Start date and End date for the period.
      4. Click Ranges, and elect the banks Cash Account(s).
      5. Click Start or Print Preview and review the report.
      6. Note the Ending Balance on the Cash Account(s).
    3. Compare the Bank Reconcilation report Register balance as of Statement date for each bank, to the Year-to-Date Ledger report Ending Balance for the Cash Account(s).

[BCB:156:Chat 300 CRE US:ECB]
Steps to duplicate
Related Solutions

How do I reconcile Cash Management transactions to General Ledger transactions?
Reconciling Cash Management to Cash Management
How do I Post Checks in Payroll?