Hello
The march reconciliation is completed. And everything is in balance , GL, Bank Book etc. but when I try to post the reconciliation following message appears. I know that there is a 300 dollar receipt that was recored as receipt on march 31st, but actually it was deposited on April 14. I try to reverse the receipt on march 31st and re enter on April 14 but still it didn’t fix the problem.
Not sure what I am missing here.
Hi Muhammad Mughal if the Receipt has a Document and Posting Date of March but a Deposit date of April, then reversing it is only going to make it worse because when you reverse both dates are made the same meaning either the Deposit or Posting date is going to go further out. Your only options are to enter an opposing transaction that is identical in regards to dates then enter a new correct one (however being 12 months ago I assume these periods are closed to new transactions) so....what I would do in your situation is not reconcile at the end of March but do a one off out-of-pattern reconciliation at April 14 2023 when you cleanly balance everything to zero. After you post the Bank Rec at April 14, print out the Reconciliation Posting Journal and manually mark up a file note for auditors that the reconciliation had to take place 14 April instead of March 31 due to a processing error, and have your manager or CFO sign off on it. Honestly I've done this dance trying to fix these reconciliations and you may never get it spot on making a mess in the process. Again I would just recommend doing the March 31 reconciliation at April 14 so everything can be reconciled then do your next Bank Rec at April 30 as usual. Make sure you enter the April 14 closing balance as the statement balance and don't reconcile any transactions after April 14 in the April 14 Bank Rec. Post it. Then start on April 30. Someone else here may have better advice but that's the best I can offer
