Set Balance in Cash Management Subledger

Christopher Hafer

Hello all,

Does anyone know how to set a cash subledger account balance in the Cash Management module? We are looking into improving our processes and reconciling bank accounts within Financial Edge rather than outside of Financial Edge. We have over 85K items in the “outstanding” status in our operating account for example.

We have some smaller bank accounts though, some that that no longer exist, that have a $0.00 bank balance and TB balance, but in a way that can only be described as somehow, the subledger balance is not zero and doesn't match the TB balance.

What we're trying to accomplish and see if we can do is, can we set all items from 6/30/2023 and earlier to “cleared” (since they were truly cleared), then set the subledger to our 7/1/2023 balance and begin reconciling moving forward? Maybe there's a way to perform a subledger entry with a “do not post” status?

Thank you