Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

G/L Opening Balance

Posted on by 60

Hello,

We are moving from QuickBooks to Business Central and for some reason i'm not really sure what are the G/L accounts to include for GL opening balance.

Appreciate your help.

Thanks,

Mohammad

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 69,639 Super User 2024 Season 2 on at
    RE: G/L Opening Balance

    Hi, Personally, I think that depending on the user and local policies, the imported results are also different.

    If you're looking for a standard solution, you can use the standard function below.

    pastedimage1669940075810v1.png

    pastedimage1669940085885v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: G/L Opening Balance

    So the best way that I can explain is with examples.

    Example 1 -Let's say you want all of 2022 monthly activity and you're going live 12/1/22. Start with the balance sheet ONLY at 12/31/21 (the day before the monthly data that you will bring in), then for each month of 2022 bring in the net change for ALL accounts.

    Example 2 - You are going live 12/1/22 and don't care about any monthly data before hand. Bring in entire chart of account values 11/30/22 (this assumes that QB only has 2022 in the income statement accounts) and begin processing 12/1/22 data.

  • Mohammad Altran Profile Picture
    Mohammad Altran 60 on at
    RE: G/L Opening Balance

    Thank you but i needed to understand what categories/accounts to include like do we include all the chart of account for opening balance or sales, liabilities and expenses. I hope this add further clarification to my inquiry.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,217 Moderator on at
    RE: G/L Opening Balance

    hi

    look this

    www.youtube.com/watch

    DAniele

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans