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) / GP2010 Bank Rec: Chec...
Microsoft Dynamics GP (Archived)

GP2010 Bank Rec: Checkbook Balance as of Cutoff is not the same as the checkbook balance per the Checkbook Balance Inquiry window as of the cutoff date

(0) ShareShare
ReportReport
Posted on by Community Member

Hi there,

I'm trying to complete a bank reconciliation.  My Bank Statement Ending Date and Cut-off Date is the same...4/30/2012.  My bank statement ending balance agrees with my GL balance as of 4/30/12 and the balance in the Checkbook balance inquiry as of 4/30/12...Let's say $1,000.

However, when I am in the Select Bank Transactions>Reconcile Balances window, my Checkbook Balance as of Cutoff is showing a balance of $1,500, when it shoud say $1,000.  Therefore, I have a $500 difference that I can't seem to get rid of.

I ran checkinks and reconcile on the financial series.  Any other suggestions?

Thank you so much for any assistance.

*This post is locked for comments

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

    Move the cut off date on the bank reconciliation window well into the future. There could be a transaction which was mis-dated.

    Ian.

  • Community Member Profile Picture
    Community Member on at

    Hi Ian,  Thanks for the quick response.  However, although I set the date to a year of 9999, I'm still off the same $500.  All the transactions have the correct dates on them.  Any other ideas?  Do you know if the table used for the Checkbook Balance displayed in the Reconcile Balances view is looking at the same table used to calculate the value in the Checkbook Balance Inquiry window?  I'm combing through the SDK documents for Bank Rec now to see if I can find thtat answer.

  • Community Member Profile Picture
    Community Member on at

    OK, I figured it out.  The period we were trying to reconcile was previously reconciled as well as the subsequent month.  The checkbook balance in the Reconcile Balances window is displaying the reconciled balance as of the last bank rec that was completed, not the specific period that I had entered in the cut-off date.  I didn't realize that my customer was trying to reconcile a period that was previously reconciled until I started digging into the CM20400 table.

  • Community Member Profile Picture
    Community Member on at

    Hi Mink,

    I'm actually having the same problem with a customer of mine.  What data in the CM20400 table made you believe that the period was already reconciled?  I see an entry with a reference of 'Reconcile Bank Statement' with a GL data of 10/31/2012, however the checkbook in question shows a Last Reconciled Date of 9/30/2012 in checkbook maintenance.  

  • Community Member Profile Picture
    Community Member on at

    Good morning,

    Sorry for the delayed response.  I made a typing error in the table name above.  It was the CM20500, not the CM20400 table.  That table contains the StmntDate which indicates when the checkbook was reconciled.  You'll see one row for every bank reconciliation completed in each CHEKBKID.  

  • alya Profile Picture
    alya 5 on at

    Hello, Mink

    I just ran into the same problem, where Reconciliation has been done and the following month as well, but another  bank rec was done on that 1st month again, so that eventually trew off my checkbook balance.  How do we fix the checkbook balance to reflect the correct amount?  can this be done in that very first month or only current?

    Appreciate any direction you can give me on this

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
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans