GL and Bank Register off balance

Ashley Meneley

We have had an issue since 2021 and our CPA's fix isn't a fix. In August 2021 we had three deposits, those three deposits hit the bank register and were cleared but the deposits were never posted and never show up to be posted. Our CPA's fix was to clear the GL by adding it in there, which would then reverse it out of the bank register for that month (she would do this after the bank reconciliation was done so that the bank reconciliation would balance) and then she would immediately reverse that transaction in the next month so that the next bank reconciliation would work. She did that the rest of her time with us and since then we have ignored it and deal with the out of balance error every time we reconcile bank.

We need to do a correction and get that deposit in the GL but we don't want that deposit to hit the bank register. Is there any way to hit that GL without it hitting the bank register? We still can't post those deposits and we don't want to delete and redo them, it would affect the payment applications and then deleting it will result in them hitting the bank register again which would make the register out of balance.

I know we had this same sort of issue years ago but I can't remember the details around to find the data on how we resolved it.

Dan Hout-Reilly

@Ashley Meneley Hi Ashley, I have this happen for one reason or another ocassionally (that the GL and bank register get out of sync). There is a business rule setting that allows a post to the cash GL that won't post to the bank register. I turn this on, make my GL entry, then turn it off. You can turn it on at General Ledger, Settings, Business Rules, Journal Entry: “Allow journal entries to cash accounts withouth adjusting the bank register”.

When the business rule is on, the “Create bank adjustments” check box on the GL batch screen will be unchecked. Sometimes it can take a few minutes for the system to update for this to take effect (BB reports it can take up to 24 hours). You'll also want to make sure that the “Create bank adjustments” check box is unchecked in the batch after validating the batch before posting it.

Again, once the the batch is posted, remember to turn off the business rule selection.

Angelina Burton

@Ashley Meneley, here's a few links that customer support sent me, when I had an issue with my GL and bank being out-of-balance -

https://www.screencast.com/t/vkAT1dvSGpv

https://kb.blackbaud.com/knowledgebase/articles/Article/72364

https://community.blackbaud.com/blogs/3/240/

Kevin Brazell

@Angelina Burton
Nice links. @Ashley Meneley , take a look at the community Link Angelina provided. It shows what can cause this, ways to find the out of balance, but last if you can't find it, the steps to make a forcing entry on the GL that will not affect the bank register. That should be used as little as possible, but can be used to force a balance.