web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How to re-do a prior bank reconciliation

(0) ShareShare
ReportReport
Posted on by

Hello,

We are wanting to know how/if we can re-do a previous day bank reconciliation.  We have a duplicate check item posted to the checkbook by mistake.  One item is correct in that it is in the checkbook and posted thru to the GL.  However, the other is incorrect because it is only in the checkbook and did not post all the way thru to the GL.  We see this happen sometimes with our integrated items from using eConnect.  So the checkbook is incorrect with two entries, while the GL is fine since it just has the one.  We were not aware of the incorrect item and that it should have been voided out of the checkbook (only) when we went to do our daily bank rec.  We mistakenly marked off the incorrect check item when doing our prior day's bank rec and the rec was completed.  Therefore, it is after the fact that we are looking to void the incorrect entry and want to re-do our prior day's bank rec so it will be in balance with our GL.  

How do we re-do the prior day's bank rec at this point?  When we put in all of the information on the bank rec screen, it takes us to the screen where you mark/unmark items, however, it doesn't give us the opportunity to unmark that incorrect item since it is now considered a cleared item because of what we did above.    

If we cannot re-do the bank rec, I believe I know what the work around would be - we would enter an IAJ entry and block the posting thru to the GL.  This will adjust our checkbook balance to the proper balance, and have no affect on the GL which is what we want.  Then on our next bank rec, we simply mark off this IAJ entry and the correct check entry which we should have marked in the first place.  Our next rec still will not balance to the GL, but it will be off the same amount we were on the prior day's rec and that difference will be in the opposite direction.  So on the third day of our bank recs, we will be back to balancing between the GL and checkbook.

Please let me know if I missed anything.  

Thank you.

Val

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,627 Moderator on at

    Val, door #2 is your best option.  You can't 'unreconcile' an item without making changes directly in the tables - never the best option.  I update data in tables regularly and it makes me nervous every time I do it.

  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Hi Val,

    Increasing your checkbook balance without impacting general ledger is simpler than an IAJ. Simply do a deposit without receipts in the deposit entry screen.

    The method you suggest would be much better than changing the SQL table values to 'unclear' the check.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at

    From the support standpoint, Leslie has the best answer here if you are resigned to having the occasional corrupted data in Bank Rec.  

    Unfortunately, as I have no eConnect experience, I cannot speak as to the overall cause of your issue beyond recommending that you open up a support case with the eConnect team or create a post with eConnect in the topic to see if someone on that team can help with the problem.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,627 Moderator on at

    I agree, Leslie's is the best option.  I didn't even think of that.

  • Abby Profile Picture
    100 on at

    This helped me as well! Thanks. Wondered what Without Receipt meant!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans