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 / Microsoft Dynamics GP (Archived) / Reconcile to GL
Microsoft Dynamics GP (Archived)

Reconcile to GL

(0) ShareShare
ReportReport
Posted on by Rosemary 10

Good day all and Happy New Year!

Just a couple of questions, I am doing the Reconcile to GL, Receivables Management, and I am not too clear on a couple of things. For the month of December

Total ending RM Bal - 19,892,979.72

Total ending GL Bal - 19,809,204.28

There is a difference as you can see, the TB though is saying 19,809,204.28, is this normal?

Regards 

Rosemary

*This post is locked for comments

I have the same question (0)
  • twelvestrikes Profile Picture
    twelvestrikes 3,657 on at

    Hi Rosemary

    Happy new year to you as well.

    If everything is correct your GL control account balance should equal the subledger balance.

    When you open the spreadsheet, are there any transactions in the unmatched section or the potentially match transaction section?  If yes that is where you start to figure out what is missing in the GL.  Make sure that there are no open batches in the GL that pertain to your December AR transactions.

    Also, don't forget to include all AR control accounts in the reconcile to GL window to ensure that you are getting all the information.

    If all of the above is fine,  and since you are looking at December, is your November subledger balance equal to your GL control account(s)?  If not, what I suggest is you go back to the last period where the balances were equal and then go forward month by month and reconcile that way. It will be easier to reconcile on a month to month basis rather than several months at once.

  • Rosemary Profile Picture
    Rosemary 10 on at

    Thanks Jeffrey for your response, I will give this a try again with the report.

    Regards 

    Rosemary

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

    Hi,

    I've also seen this happen when discounts are being tracked in a different GL account and that account wasn't included in the reconcile.

    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

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 April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans