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) / Adj bank balance, Adj ...
Microsoft Dynamics GP (Archived)

Adj bank balance, Adj book balance....not tying to GL

(0) ShareShare
ReportReport
Posted on by jmorgan 250

We use the Bank Reconciliation module to do our bank recs.  Essentially we can never get the adjusted book balance to tie to the GL.  This has been an ongoing problem for sometime.  For the past 18 months or so I have been comparing the trial balance for our cash account to the checkbook balance inquiry....checking every single transaction!  Sometimes I can figure out what transaction is causing the problem.  Sometimes I can't.  Sometimes both reports match and there is still a difference!  This month I was able to check off EVERY transaction on both reports and the adj book balance was still off by $40.17!

 Any thoughts?  B/c this is driving me insane!  Not to mention the auditors who are none to pleased with this bank rec system.  I know some of the ways that can cause this issue, but, thought some of you could enlighten me.  Or, should I be happy that we're off by such small amounts?  I'm hoping its not the latter b/c that doesn't create warm fuzzies for this accountant!!! 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Adj bank balance, Adj book balance....not tying to GL

    Sanjay - our add-on for Dynamics GP, The Closer, will reconcile your GL and your Cash Sub-Ledger.  It was designed to specifically for finding the difference after you have done your Bank Recs...please visit www.reporting-central.com - this is one of our most popular modules and it will find the errors in less 30 seconds so that you do not have to spend any more time looking for them...

  • sueconrod Profile Picture
    sueconrod 335 on at
    RE: Adj bank balance, Adj book balance....not tying to GL

    I thought this was taken care of in GP2013, the same way you can do a reconciliation on AP and AR by adding the accounts, there is supposed to be a reconcile for the Cash Accounts.  Tools>>Routines>>Financial>>Reconcile to GL.

    Anyone want to chime in,

  • sanjayparab Profile Picture
    sanjayparab 15 on at
    RE: Adj bank balance, Adj book balance....not tying to GL

    We have done Bank Reconcilation and after bank Reconciliation we noticed that there is difference in Adjusted Bank Balance and Adjusted Book Balance to Actual GL Account Balance. My GL Account Balance is 2233140.20 but my Adjusted Bank Balance and Adjusted Book Balance is 2935544.17. I dont know how to adjust this 702403.97. If I add any deposit or payment again I have to made an adjustment entry for same amount as my Difference is Zero. We have to close our books and I cant get a proper solution for the same. Please help on it.

  • Brian Wick Profile Picture
    Brian Wick on at
    Re: Re: Re: Adj bank balance, Adj book balance....not tying to GL

    Hi jmorgan,

    It looks like you received some great responses from the community.  Please post back if you have further questions.

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Adj bank balance, Adj book balance....not tying to GL

    My question is Why wait or Spend so much time on it?  The Closer can solve this in seconds. The Cash Module can be purchased for $1,500.00 with a 30 Day money back guarantee!  We can solve this tomorrow!

  • jmorgan Profile Picture
    jmorgan 250 on at
    Re: Re: Adj bank balance, Adj book balance....not tying to GL

    Thanks for your help Ian!

     I totally agree that I shouldn't be happy being off by one cent!

    I do know for certain that no "non bank transactions" are hitting the GL.  When I get through my audit I will go and try your Smartlist suggestions.  I'm pretty much fed up with the bank recon module.  I'm not impressed right now.  I will probably do manual bank recs alongside the GP one for the next fiscal year.

  • Community Member Profile Picture
    Community Member on at
    Re: Adj bank balance, Adj book balance....not tying to GL

    You shouldn't be happy being out by one cent. It should tie in exactly. There are however valid reasons why this might nt be the case. Are any non bank transactions hitting your GL Bank Account? Any transaction that does no go through the Bank...but hits the GL Bank Account will obviously cause and issue. Smartlist all of the transactions in your GL Bank Account and include the Transaction Type info...if you see a SOP, POP, IVTRX etc...then these are clearly not bank related and shouldn't be here. Also make sure that all of the GL Journas are posted. If you are getting issues every month and sorting them...then you should be ale to put in controls to stop these issues repeating. Also look for undeposited receipts that will have updated your GL...but not your bank module. There is also the possibility that someone has inadvertently deleted a GL journal that resulted froom a posted bnk receipt / payment.

  • Community Member Profile Picture
    Community Member on at
    Re: Adj bank balance, Adj book balance....not tying to GL

    How about a Solution! The Closer now includes CASH making Great Plains Better!

    The Closer eliminates the need to "Tic & Tie" by finding all of the transaction that are causing you to be out of balance. Not only does The Closer find them, it groups them by error code explaining what is wrong. Current sub-ledgers supported include: AP, AR, INV, SOP, COGS, Accrued PO and now, CASH!

    In your case, The Closer will look at the control account in the GL and compare it to the Checkbook ID. Any transaction that are not matched to the penny, will be displayed and grouped by error code. Fix them and run the process again to have "proof" that your books balance to the penny!

    Customers run The Closer in some cases everyday for inventory (takes less than 30 seconds to open the program and see the results - some cases involving millions of transactions, may take 2 minutes). Others use The Closer to perform the Month-End close making the process a snap!. Close the books in minutes instead of hours or days. Results can be generated for a day, last week, a month or even last year.

    For more information: www.reporting-central.com or contact me: cpatterson@reporting-central.com 978-878-9584 x1

    Clark

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans