RE: Cash Manager Balance is out of balance per Bank Reconciliation!
Hi Mike, as you may already know and as I should've expressed in my original reply, the Cash Manager uses Transaction Date (and not Period To Post) for the Bank Rec. So, at the end of March, if you have a cash transaction posted to March but dated in April, it will not be shown on the March bank rec to be cleared. Without seeing your specific data, I can't advise on what you should do, but here's some very good generic info on Cash Manager:
If you wish to correct the March bank rec, then you can use the "OD" and "OM" transaction entry types to increase/decrease the Cash Mgr Balance as needed, but keep in mind that you will almost always need to enter a reversing "OM" or "OD" transaction in the future.
For example, if I entered an AP Check dated 4/8/16, but post to March (period 03), that check will appear on the APRIL Bank Rec. If I want it on the MARCH Bank Rec, I would need to enter the following:
1) An "OM" transaction to decrease the Cash Mgr balance as of 3/31/16
2) An "OD" transaction to offset the original check, dated 4/8/16
No matter what you do with the OM & OD transactions, your first step should be to ensure the GL balance is correct. If it is, then you can go and enter OM/OD entries as needed to get your Cash Mgr Balance where it needs to be.
Share
Report
All responses (
Answers (
1,040
