Bank Reconciliation - wrong check reconciled, how to correct?

Bank Activity:

Item 1: Customer 1 4/2/2018 Wire Transfer $500.00

Item 2: Customer 2 4/26/2018 Check 1234 $500.00

Item 3: Customer 1 4/30/2018 Wire Transfer $500.00

The person who reconciled the bank cleared Item number 1 and 2, instead of Item 1 and 3.

Check 1234 is still outstanding but needs to be reissued as it was lost in the mail.

I am unable to void the check, but need to reissue a new check.

How would I go about correcting the wrong cleared item, clearing the correct item and voiding and reissuing the check?

Thanks.

Barb

  • 0

    Once a reconciliation has been posted it is in stone and you can no longer reverse the checks. If it is a matter of moving balances around you can post an AR adjustment to the customers AR invoice in order to open it back up to receive payment. This will update AR and the GL but not the bank so you will also need to post a bank entry bank withdrawal that uses the same GL account as the bank.

  • 0

    You can change the status from Reconciled to Open by doing the following:

    go to Cash Management

    Tasks:  Edit Register

    Find the transaction and click on the three dots with arrow (towards the right of the screen)

    Chang the status from "R" to "O"

    Once you change the statuses to Open, you can fix your errors. Afterwards, you can go back to the Reconciliation and use the month of April again to clear the correct transactions.

  • 0 in reply to Restore

    Sage 300cloud (AKA Accpac) doesn't have a Cash Management module.  You may be referring to the other Sage 300 product.