Skip to main content
Business Central forum
Answered

Importing Opening Balances

editSubscribe (1) ShareShare
ReportReport
Posted on by 314
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
  • Verified answer
    Dallefeld Profile Picture
    Dallefeld 11,415 UG 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 2,655 Super User on at

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans