[CM] Reconciling Cash Management to the General Ledger

Tip: Reconcile CM to GL monthly using the CM Transactions Report, not the CM Account Statement, which may not match the Trial Balance.

Steps to Reconcile

1. Run CM Transactions Report:

   • Enter the CM Account to reconcile.

   • Set Beginning Month and Ending Month (usually the same).

   • Sort By: T (Transaction).

2. Run GL Trial Balance Report:

   • Enter Beginning Account for the GL account linked to the CM Account.

   • Set Detail = D, and Beginning/Ending Month same as CM report.

3. Compare Totals:

   • On the last page, CM total should match GL total debits and credits.

   • It should also match the difference between beginning and ending balances of the account.

Troubleshooting Variances

1. Check Transaction Sources:

   • Transactions in GL from sources not AP, AR, CM, or PR will not appear in CM. Reverse or repost them to the correct account.

   • Journal entries intended for CM must be recreated in CM using CM Outstanding Entry if posted directly to GL.

2. Check Sub-Ledgers:

   • Run reports for AP, AR, CM, PR individually to locate discrepancies.

   • Compare transactions line by line to see what was posted only to CM or GL.

Resolving Issues

• Wrong GL Account: Undo or offset in the module where it was created.

• Transaction in GL but not CM:

  • Check if the CM interface flag in the module’s company parameters is off.

  • Undo or offset with the flag off, then repost with the flag on.

• Transaction in CM but not GL:

  • Check if the GL interface flag in CM Company Parameters is off.

  • Delete and recreate the transaction with the flag on, or post a GL Journal Entry to correct balances.