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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Setting up the Bank Re...
Microsoft Dynamics GP (Archived)

Setting up the Bank Reconciliation Feature in Great Plains 2015

(0) ShareShare
ReportReport
Posted on by Community Member

Hi -

I am working on getting the Bank Reconciliation feature set-up in Great Plains 2015.  The issue is that the company has been running GP15 for about 15-16 years and have not used the Bank Rec feature.

There are thousands of entries - maybe millions - that have accumulated over the past 15+ years.  My concern is that if I open the Bank Rec and start letting GPs populate that, we'll end up with an unmanageable amount of data.

Has anyone had to deal with this that could offer some advice on how to get started?

Thank you,

Tammy Bourakis

*This post is locked for comments

I have the same question (0)
  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at

    I personally would still do it from the front end.  It is a one-time thing - maybe just time it so that it is not a heavy processing time.

    Enter the last bank balance on the front reconciliation screen.

    Let the transactions load into the screen.  Do a mark all and process an adjustment for the balance.  Code the adjustment to the Bank GL control account so at a GL level it is a zero.

    If you have any unpresented items, you can either unmark those before doing the adjustment or then process them as opening transactions into the bank reconciliation.

    Before you start, you could check the number of lines using this script:

    SELECT * FROM CM20502

    See what quantity you are dealing with first.

    I suppose in theory, you could delete these transactions from this table directly.  I have never tried it.  You would probably have to update the checkbook balances.  If you choose to go down that track, do it in test first.  Delete the transactions and see what happens.  As part of the testing, also run check links on the CM tables after the deletions to make sure they don't come back.

    Cheers

    Heather

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

    Hi,

    I'm with Heather with just a slight modification. Since you've not been using bank rec, the bank account is normally needing an increase adjustment (because no deposits have been made). I'd approach it this way:

    1. I'd need to get rid of all of the entries needing to be deposited by doing a deposit entry 'Clear unused receipts' to clear the deposit window (no GL or other transactions are made).

    2. Start the Bank Reconciliation with the most recent bank statement. Mark all transactions as cleared EXCEPT the entries that were still outstanding as of the date you entered for the bank statement date. This will give you the out of balance amount. Exit the bank rec window and SAVE your uncompleted rec.

    3. Using the number discovered in step 2 create a Bank Deposit as a 'Deposit without Receipts' to increase the balance in the checking account while not touching the GL.

    Kind regards,

    Leslie

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans