A check that originally issued August 2022 was lost. In May 2023 I voided the payment and re-issued a new check. Now my bank reconciliation and general ledger are off that same amount each month. How do I correct this?
When you voided the payment, did you mark "Use original accounting date" or did you enter a May date? Did you restore the invoice to "open"?
I used the may of 2023 and yes I restored the invoice to open.
If you run the report in Cash Management - "CM Balance to GL" is there a difference there, too? If so, you may need to post in GL.
I think what you're seeing is normal. I think Sage is acknowledging in the following article that it's a report issue. It is difficult because the voided check has changed in CM to zero. You should run the report in CM - Reports - Reconciliation - Change in Void Date and put that with your reconciliation. It explains the difference. Sage Knowledgebase has the following: https://support1.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=95218&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=14205&cmd=displayKC&dialogID=598715&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true
You wouldn't do any of the fixes in the article unless it was an electronic payment.
We use a work around which you could use next time. That would be just to hand type a replacement check and note that it replaces original check #xxxx on the face. Make a copy for your records. When the replacement check clears, clear the original check.
*Community Hub is the new name for Sage City