Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Importing Opening Bala...
Business Central forum
Answered

Importing Opening Balances

(1) ShareShare
ReportReport
Posted on by JE-29041340-0 385
Hi:

When creating and reviewing Excel spreadsheet templates to be imported into Business Central for processing opening G/L balances, what data should reside within those templates?
 
What sort of things come to mind and should be done for importing opening balances?
 
Thanks!
 
John
Categories:
Other
Data Migrations
Financial Management
  • Verified answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    Importing Opening Balances
    G/L balances can be imported for a specific date at cutover or many times we want to bring in some monthly amounts, so the posting date is important.
     
    Your starting balances should always just be the balance sheet account balances. Import fields
     
    Journal Template
    Batch Name
    Line No. - unique for each line
    Document No.
    Account  Type
    Account No.
    Description - if desired
    Amount
     
    And that's really all you need.
     
    Open AR and Open AP are a different story by a couple of fields.
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 9,472 Most Valuable Professional on at
    Importing Opening Balances
    Hi
    I could recommend using it "configuration package" to import the initial balances of accounting accounts, banks, accounts payable, receivable, fixed assets, valued inventory.
     
    Here some information
    best regards
    Gerardo

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

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans