Tip: It’s recommended to reconcile Cash Management (CM) to the General Ledger (GL) monthly. Use the CM Transactions Report for reconciliation, not the CM Account Statement, as it may not match the GL Trial Balance.
Steps to Reconcile
Run the CM Transactions Report:
Select the CM Account to reconcile.
Set Beginning Month and Ending Month to the same month.
Sort by T (Transaction).
Run the GL Trial Balance Report:
Enter the GL Account for the CM Account.
Set Detail = D.
Set Beginning Month and Ending Month to the same month.
Compare Totals:
Check that the total on the CM Transactions Report matches the sum of Total Debits and Credits on the GL Trial Balance.
It should also match the difference between the Beginning and Ending Balance of the account.
Locating Discrepancies
Look for GL transactions with sources other than AP, AR, CM, or PR—these won’t appear in CM. Reverse and repost to the correct account.
Check if any GL Journal Entries should have gone to CM—if so, reverse and re-enter them in CM.
Run reports for individual sub-ledgers (AP, AR, CM, PR) to isolate variances.
Compare transactions one by one to find entries posted to only CM or only GL.
Correcting Errors
Wrong GL Account: Undo or offset the transaction in the original module.
Transaction in GL but not CM: Check if the CM interface flag was off. Undo or offset, then recreate with the flag on.
Transaction in CM but not GL: Check if the GL interface flag in CM Company Parameters was off. Delete and recreate with the flag on, or post a GL Journal Entry to correct it.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article