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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Is there a report that...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Is there a report that will show the transactions that are used to calculate the adjusted book balance?

(1) ShareShare
ReportReport
Posted on by RonHc213 5

I am having difficulties reconciling the bank statement to the adjusted book balance. I have entered the bank statement ending balance and checked off every transaction on the statement in the reconciliation module, but I cannot get the adjusted bank balance to match the adjusted book balance. Is there a way I can see the transactions that are used to calculate the adjusted book balance since last months reconciliation?

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick Microsoft Employee on at

    Hi RonHc213,

    Please read KB 854081 on how the Adjusted book balance is calculated.  Basically it starts with the checkbook balance AS OF TODAY and add/subtracts all the transactions in the CM20200 table out back to the cut off date you entered.    So if you are reconciling a prior month such as May, be aware that ANY posting interruptions on transaction between the last time you reconciled and TODAY (JULY) could affect the adjusted book balance.   So I often ask the users if they recognize the amount, even if from last week or yesterday, as if there were any posting interruptions, this would affect any prior recons since the calculation starts with TODAY's checkbook balance.  (Many times users don't say anything because they don't think something from June or July would affect the May recon, but it does by the way that balance is calculated backwards in time).   Refer to the troubleshooting section in this KB, as I often query the CM20200 table for that amount, and half the amount (in case a record duplicated) and also ask the users if they recognize the amount from ANY month.   (If you absolutely cannot find it, you may be forced to key an adjustment in order to balance in that month (ex. May), and then when you get to the month with the posting interruption (July, let's say), you should be off the other way and then need to back out your adjustment.)

    http://support.microsoft.com/help/854081

    Typically, it is due to a posting interruption between the last time you reconciled and TODAY, so if the user's recognize the amount in ANY month, it's worth looking into. Typically it is due to recent posting interruption that affects the balance, and happened in a later month than you are reconciling, so you dismiss it, but anything up until TODAY can affect that balance. 

    Hope that helps!

    Cheryl Waswick
    Microsoft Dynamics GP support

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 733

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 278 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans