A check was cleared in error during the bank reconciliation process. How do we "unclear' the check so that we can now void it in the AP module?
*This post is locked for comments
Announcements
A check was cleared in error during the bank reconciliation process. How do we "unclear' the check so that we can now void it in the AP module?
*This post is locked for comments
Hi Janet,
That's good news. If you have any other questions, just let me know.
Hi Carolyn,
I wanted to give you an update. It turns out that we had already attempted to void this check but it was hung up in an unreleased void check batch. Now that the batch has been released the void now appears in the vendor file. I hope this doesn't come back to haunt me when I do my bank rec but for now I'll hope for the best. If it doesn't work out, I'll be back in touch.
Thanks again for your help.
Janet
Thanks Carolyn. I'm not familiar with SQL Server Management Studio but someone on our staff may be. At this time, this isn't a pressing issue so if it takes more research to arrive at a solution, then I'm willing to wait.
Thanks for your prompt replies.
Janet
Hi Janet,
Unfortunately the Bank Reconciliation module isn't very forgiving and it seems like you can't unclear a check. I cleared a check in the Reconciliation screen and noticed that in the APdoc table the status went from O to C. Then I uncleared it and the status in AP stayed at C. So unclearing the check in the BR module won't do any good. It seems like a bug to me so I'll need to research.
You could unclear the check using a SQL statement, but I don't know what that would do to your reconciliation. Are you familiar with SQL Server Management Studio?
Carolyn,
Thanks for your reply. I am using the Bank Reconciliation module and I have already closed the period of reconciliation. The reason that I stayed in balance when I reconciled that period was because I cleared this check against an uncleared deposit for another voided check of the same amount. Of course, the second check is still on my outstanding check list even though it was voided because I cleared it's corresponding deposit against the first check.
Janet
Hi Janet,
Are you using Cash Manager? If so, you can just go into the Reconcile Checks screen from the Bank Reconciliation screen and unclear the check and save the reconciliation. You would need to unreconcile the Bank Reconciliation to do this if you already checked the Reconcile check box.
If you are using the Bank Reconciliation module and you haven't yet closed the period of the reconciliation, you can just uncheck the Cleared box and save.
Let me know if this works for you.
Community Member
136
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
REUser
8