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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bank Reconciliation - ...
Microsoft Dynamics GP (Archived)

Bank Reconciliation - Incorrect data at implementation

(0) ShareShare
ReportReport
Posted on by ematheson419

We went live with GP in July 2015, we have just recently decided to use the bank rec feature in GP instead of on a spreadsheet.  After many hours of research I can confirm that our beginning balances have been incorrect from day one.  My question is, where do we go from here?  I've read a few suggestions, including create another checkbook entry and map it to our current cash account and update the vendors/employees/customers to be mapped to the newly created checkbook.  

Can anyone provide some input or suggest a support team?

Thank you!!!

*This post is locked for comments

I have the same question (0)
  • ematheson419 Profile Picture
    ematheson419 on at
    RE: Bank Reconciliation - Incorrect data at implementation

    Thank you!!!

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Bank Reconciliation - Incorrect data at implementation

    There are few ways you can go about this:

    1) Assuming you don't want to have to deal with reconciling a whole bunch of documents that you never looked at to begin with, outside of the spreadsheet you currently have, you can do a blind reconciliation, this is, you mark off all documents as of the last date you completed on the spreadsheet, where and adjust to your last reconciled balance. You can adjust to your cash account to create an in/out to the same account. The assumption here is your cash account reflects the correct balance as of today, so you don't want to affect that balance.

    2) Go nuclear and remove all records from the CM20200 for records with a GL Posting Date under your last bank reconciliation date. You will also need to remove the documents in the CM20100 table and CM20201 (deposits) as presumably you don't need these if you have reconciled them.

    In any case, this is doable. I have used both methods in the past, and perhaps, even a combination of both.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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