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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Bank Reconciliation Problem - Help!

(0) ShareShare
ReportReport
Posted on by 235

Hello!  I am new to GP but have already made what seems to be a big mistake.  Until recently, the bank account was reconcilied in Excel.  However, we now want to use GP.  As such, I am going back through 2008 to reconcile accounts in GP using the Excel reconciliations.  Unfortuntely, I didn't realize one of the Excel reconciliations had the wrong bank balances.  After entering in the wrong bank balance, there were obviously differences between the adjusted bank balance and adjusted book balance.  As all the transactions were correct, I simply made an adjustment for the difference and reconciled the account.  BIG MISTAKE!  I didn't realize the problems this would cause.  Is there any way to "undo" the reconciliation and start over? 

If anyone could help I would appreciate it so much!

Thank you.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    I am not quite sure what the big problem is - the resolution to this issue would be to ensure tht your adjustment affects only the checkbook.

    What you should do is to enter the difference through Bank Transactions, either as an increase or Decrease adjustment, and make sure that you debit and credit the same default bank account. In the Reconcile Bank window, mark off the ite as reconciled. This will not affect your GL, but will adjust the checkbook adjusted balance.

    If you are not quite comfortable, do it in the training company first, to satisfy yourself, that you have done the correct adjustment.

    Good Luck!

    Deesom.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans