15
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,
Thank you so much Olson, greatly appreciated!
Thank you so much Lisa, greatly appreciated!
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (