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 372
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,417 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 5,292 Super User 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans