Void previous year cheque and remove from bank reconciliation

Question

I have one cheque that was written in 2021 but lost. I need to VOID this cheque and reissue in 2022. I can reverse the original payment with a JE so the new cheque will zero out the 2022 expense. This will ensure that my expense stays in 2021 and does not show up in 2022. I can then check both the reversal and the new 2022 cheque in my bank reconciliation but, how do I remove the old cheque from the bank reconciliation? 
 Some American sites say to simply highlight the transaction in the bank reconciliation and press delete but this does not seem to work in Sage 50 Premium Accounting Canadian version.

Smith and Co · Accepted Answer

Hi - did you select the icon up top that looks like a yellow sheet of paper? 
 
 You need to do in order to see all of the 'invoices' - not the payments - that were posted to that vendor. The paid invoices are showing as 0.00 amount owing. See snipping below. 
 
 Now select the invoices that were paid by the lost chq and re-enter as a negative amount along with the lost chq number and VOID in front of it using date of new chq that will be issued. See snipping below. 
 
 Post that and then go back into the payment module and unselect the yellow sheet icon so that only the outstanding invoices are showing. Create a new cheque to pay those invoices that you just 'unpaid' with new chq nbr and date. 
 Doing it this way leaves the previous year's transactions unchanged. Voiding old chq and entering new chq transactions are both dated for the current year. 
 Now when pulling up the bank rec you will see the lost chq number and the VOIDChqNbr - both can be cleared out in order to remove from bank rec. The new chq will show as outstanding in the bank rec until it shows going thru your bank account. 
 H

Sage 50 Canada

Void previous year cheque and remove from bank reconciliation

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING