Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Balance Sheet Out of Balance from Dec to Jan of new year.

(0) ShareShare
ReportReport
Posted on by 10

In researching some balances, I discovered that our TB as of 12/31 in a year did not match the opening balances on 1/1 of the next year.  The variances isnt really material, but it is annoying me and it shouldn't be there.

We don't use any modules other than Fianncials.  Is there a way to manually adjust an account balance without a J/E?  A journal entry would just put somethign else out of whack.

  • USAgent Profile Picture
    USAgent 10 on at
    RE: Balance Sheet Out of Balance from Dec to Jan of new year.

    Thanks for all your help.

  • USAgent Profile Picture
    USAgent 10 on at
    RE: Balance Sheet Out of Balance from Dec to Jan of new year.

    Everything balances except for this amount from Dec 2012 to the beginning of 2013.  The opening balance in this account for 2013 doesn't match.  I've verified every other account on our balance sheet.  But I adjused the beginning balance of 2013 but it only changed that year.  Each year after still has the variance.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Balance Sheet Out of Balance from Dec to Jan of new year.

    I was just going from your example and assumed that this began between 2020 and 2021. If it did begin earlier, then once you adjust the earliest occurrence, it should make the adjustments all the way up to the current year automatically.

  • USAgent Profile Picture
    USAgent 10 on at
    RE: Balance Sheet Out of Balance from Dec to Jan of new year.

    I guess I should just do it in the current year.  It appears like I'd have to adjust the beginning balance of every year from the error until the current one anyway.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Balance Sheet Out of Balance from Dec to Jan of new year.

    Assuming that the Trial Balance is balanced at the end of 2020, I would make the correction in the Beginning Balance for 2021. But your question brings up another: do the Beginning Balances for 2021 balance (i.e., do Debits = Credits?) If so, you're looking for two changes to make.

  • USAgent Profile Picture
    USAgent 10 on at
    RE: Balance Sheet Out of Balance from Dec to Jan of new year.

    I do know the account.  It's just a really weird error.  Do you think I'm better off making the adjustment in the current year, or at the end of 12/31/2020, or going back to when it happened and making it?  And you're just talking about changing the beginning balance, right?  That field?  Thanks.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Balance Sheet Out of Balance from Dec to Jan of new year.

    If you know which account/subaccount is the issue, you can make adjustments in the Account History screen while in Initialize Mode. Be very careful and get back out of Init Mode as soon as you're done. Otherwise, you risk making other unbalanced transactions.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans