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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Beginning Balance do not match ending balance

(0) ShareShare
ReportReport
Posted on by 1,958

I ran a year end close the yesterday.

I noticed that some of our retained earnings account (we use divisional close)  the ending balance of 2008 does not equal the beg bal of 2009. The 2008 ending balance is correct but the 2009 beg bal is not.

If run the trial balance, everything is balance though.

Any idea how I can resolve this issue.

Thanks

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Mariano Gomez Profile Picture
    26,225 on at
    Re: Re: Re: Re: Re: Re: Beginning Balance do not match ending balance

    I agree with Sandip. It sounds your summaries are off. To fix this you will need to run a reconcile. Go to MSDGP >> Tools >> Utilities >> Financial >> Reconcile and select the year in question.

  • Sandip Chudha Profile Picture
    175 on at
    Re: Re: Re: Re: Re: Beginning Balance do not match ending balance

    Sunil,

    If you are sure all the posting types on the accounts were setup correctly, then I'd run reconcile on "Open" year this is via Uitilities > Financial > Reconcile click on "Year" & Select "Open" select year in question and run reconcile. I'd also take a backup before running this just incase.

    Regards, Sandip

  • Sunil Chhabra Profile Picture
    1,958 on at
    Re: Re: Re: Re: Beginning Balance do not match ending balance

    Ian,

    Yes, the beginning trial balance is in balance. Although some of the retained earnings accounts are off - the total is in balance - which is really strange.

    Because the difference between the ending balance and beginning balance is about 1million.

    We have about 100 Retained Earnings account and 17 of them have the problem.

    All other balance sheet accounts including retained earnings account (except 17) have a correct begginning balance. All P and L accounts have a Zero beginning balance.

    If run a balance as of 1/1/2009 it is in balance.

    Thanks

    Sunil

  • Community Member Profile Picture
    on at
    Re: Re: Re: Beginning Balance do not match ending balance

    Hi, are the amounts on the Trial Balance report incorrect but balancing?

    Where do you see the error, or how did you firt find it? In the Trial Balance report?

    Best regards,

  • Sunil Chhabra Profile Picture
    1,958 on at
    Re: Re: Beginning Balance do not match ending balance

    Frank,

    All the accounts have proper type setup. Every thing closed properly to retained earnings account. If run a Balance sheet at 12/31/2008, the retained earnings accounts are fine.

    Also, I ran a beginning trial balance for 2009 and all the revenue and exp accounts do show a Zero beginning balance.

    Any other suggestions.

     

    Thanks

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,615 Super User 2025 Season 2 on at
    Re: Beginning Balance do not match ending balance

    Check to see if you have accounts with the incorrect Posting Type.  You may have some P&L accounts setup as Balance Sheet or vice versa.  If that's the case, the P&L accounts would not close to Retained Earnings.  The best way to check is to use the Accounts SmartList and add the Posting Type field to it.

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans