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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

How to post opening balances for G/L accounts in Business Central

(1) ShareShare
ReportReport
Posted on by 7

We are new to Business Central and we need to figure how to post opening balances of all G/L accounts in our Business central setup. Here are the details about our query-

We are migrating all accounting data from QuickBooks to Business central. So, migrated all G/L account categories, created COA and also created required posting groups along with existing contact, vendors and customers data of QuickBooks to Business Central.

Now, since going forward we will be using Business central for financial transactions so as per the requirement we need an opening balance for the G/L accounts in Business Central based on the last year's transaction from QuickBooks. 

So, is their any way we can directly post the opening balance in Business Central for these G/L accounts or we must need to import all the transactions for last financial year of QuickBooks to Business Central to create the opening balance in Business Central. 

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    Hi,

    You can follow the below link to answer you question

    community.dynamics.com/.../how-to-upload-opening-balances-for-gl-ar-ap-and-inventory

    usedynamics.com/.../

  • Verified answer
    YUN ZHU Profile Picture
    102,516 Super User 2026 Season 1 on at

    Hi, I think it depends on the needs of each company, the easiest way to do this is to use the function below.

    pastedimage1679964175933v1.png

    pastedimage1679964188407v2.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Shamsher Singh Profile Picture
    7 on at

    Thanks yzhums it help me a lot to solve my issues. Thanks again!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 677 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 521 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 306 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans