Void previous year cheque and remove from bank reconciliation

SOLVED

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.

  • 0

    H Dennis - If this invoice was posted as a Pay Later and then payment posted as a separate entry then the following is the best way to do this.

    In Payment module enter the supplier name and select the icon at top (yellow sheet) that shows 'include fully paid invoices/prepayment', this will pull up all the payments that were made. Then scroll to invoice(s) that was paid with lost chq and re-enter the amount(s) as a negative number. For Chq number use the same chq nbr that was lost but enter VOID in front of it. Use date that you will be replacing with new chq and post.

    Then go back into the payment module again and select the supplier name and unselect the 'include fully paid invoices/prepayment' icon. Now only the outstanding invoices will show and you can select the same invoices again to be paid with the new chq nbr and date.

    In the Bank Rec you will be able to select the old chq nbr and the VOID(ChqNbr) to clear those 2 entries out. When the new chq goes thru the bank you will be able to just select that chq to clear from Bank Rec.

    Heather

  • 0 in reply to Smith and Co

    Hi Heather,

    The invoice in question was entered through the "Invoices" module and not the payments module.  I can see the payment in the payment module but it does not let me make any changes to it.  Is there a different solution for payments made directly through the Invoices module?  Worst case scenario would be to simply write a new cheque and not post it at all.  Then when the new cheque is cashed, I can simply check off the 2021 cheque.  This is not the ideal solution obviously, but at least it would then clear my old cheque from the bank rec.

  • +1 in reply to Dennis Cartier
    verified 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

  • 0 in reply to Smith and Co

    Thank you very much Heather. That fixed my problem perfectly.