Cash Trial Balance versus Bank Register Balance

Cara Lajewski

We have two cash accounts that have been reconciled where the bank register balance does not match the ledger balance in the trial balance as of 6/30. I am trying to determine the cause of this and wondered if anyone had any experience with this. I have checked the one-sided error corrections that have been made, voided payments and items marked as “Do Not Post”. I have not been able to find a consistent solution for both of the accounts. I am hoping someone out there has some insight!?!

Blake Paradise

@Cara Lajewski Hi Cara! This is most likely a date filter issue – maybe a reversal or something for the transactions posted in a different period than the original transactions or something along those lines? I can't be certain, but we have a great KB article to help with troubleshooting steps here - https://kb.blackbaud.com/knowledgebase/articles/Article/50289

If you can locate the source transaction(s) cause the out of balance, then support can help with correcting it.