25
I erroneously entered and posted a bank transaction dated June 27th but should have been July 27th. I immediately saw the error and completed a journal entry reversing the previous entry. Now, the item shows up on my July bank reconciliation as an open transaction to be cleared, even though I see the reversing entry on the account detail report. If I select it on my July bank reconciliation, it shows there is a difference. How do I remove it from my bank reconciliation?
You should be able to VOID the original transaction. Then re-enter it on July 27th. This keeps everything synchronized. Just make sure your VOID date and posting date are the same.
If the reversing JE was made directly in GL, it is not updating the Adjusted Book Balance To correct the Jul Bank rec, another work around is to make a correction entry in the Reconcile Bank Adjustment window as part of your July Bank Reconciliation.
Hello,
If you don't want to see the entry populate any longer you can use SQL to remove it from the CM20200 table at your discretion.
However, please note that this may change the Book Balance value in the reconcile as this balance starts with the Current Balance of the checkbook plus/minus the unreconciled entries in the CM20200 accordingly.
As such, if the reconcile does not complete you may need to produce an additional increase/decrease transaction in the Bank Transaction window so the Current Balance is adjusted and the ending book/bank balances tie out to complete the reconcile when the adjusting entry is included accordingly.
Please note that when you create such an entry you can use the same Cash account tied to the checkbook for the debit/credit amounts so a 'wash' transaction is created if ever posted to the GL that will not update the cash account.
Best Regards,
Jeff Grant
Microsoft Dynamics GP Support
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
