Notifications
Announcements
No record found.
We issued a check in November 2020 and was voided in January 2021. Now it's showing as a negative in Bank Rec. How do i clear that or can i just leave it as is?
Thank you so much,
The negative check means the voided check was previously reconciled (or possibly voided at the bank transaction level.) You'll need to research why a voided check has been reconciled. (Did the wrong check get voided? Did the wrong check get previously reconciled?)Either of these scenarios should be able to be resolved by reconciling the negative check and the correct check to have a $0 impact on the reconciliation.If there is something else causing the negative check, you may need to enter an offsetting bank transaction so you can clear the negative check without impacting the reconciliation.Leaving the negative check out there only works if there is a future dated document that is going to show up to offset it.
Hello,
Bank Rec will handle the voided check differently depending on whether the check had been 'reconciled' or not back in November.
• UNRECONCILED – it will simply mark the VOIDED & RECOND columns in the CM20200 Bank Rec Trx table, and the check will simply drop off the bank reconciliation window.
• RECONCILED – If you void a ‘reconciled’ check, then the system will create another record for the void in the CM20200 Bank Rec Trx table with a negative amount. This is to show the user that this is a problem, as you can’t both cash a check (and reconcile it) and void it. It’s either one or the other. So it creates a negative check to let the user know there is a problem with this check and so they will need to fix it. (The check can also be marked as 'cleared' in a currently saved recon. Since it's marked as cleared, the system creates a negative check, and if you refresh, the positive and negative records should show up to clear against each other.)
Ultimately, it is up to you on whether you need to mark this as reconciled or not based on what your checkbook balance and GL balance are in GP compared to your Bank Statement.
I hope this helps!
Isaac Olson
Microsoft Support
Thank you so much Lisa, greatly appreciated!
Thank you so much Olson, greatly appreciated!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
