You’re offline. This is a read only version of the page.
195
Every month when I reconcile our operating account, the bank rec sum/detail summary will show the Cash Manager Balance as balanced, but the GL Balance is always out of balance by several hundred dollars and usually not the same amount. Can anyone help with this?
*This post is locked for comments
The Bank Rec and the GL Acct. History balance are the same. I have also confirmed the box was checked in the Cash Acct Maintenenace to bring the GL entries over to Cash Manager ( I even unchecked it, saved it, then checked again and saved). The GL Balance is still out of balance for the 7/2014 Bank Rec. Should I wait until August is reconciled to see if any of this has helped since I have already closed out July?
Hello,
Is this the Cash Manager module? (other option is the Bank Rec module (not screen))
Verify that the GL balance you are seeing in Cash Manager>Bank Rec is the same ytd balance you see in GL>Acct History. If not, then do this.
1. Go into Initialization mode
2. Open GL>Acct History screen
3. Change the Beginning balance at the bottom left by a small amt. Save. Change it back and save again. In a single currency database, this updates the Curyacct table which is where the GL balance is pulled from in Cash Manager>Bank Rec.
If the balance in GL matches the batch in Cash Manager>Bank Rec, then there was likely a posting to the cash acct that did not update Cash Manager.
This can happen, for instance, if you post to the cash acct on an invoice our voucher. Or, you can make a GL entry that doesn't update cash manager. There is a box to select in Cash Acct Maintenance that says to bring GL entries over to Cash Manager.
Share
Report
All responses (
Answers (
