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.