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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

How to set up and enter balances in the COA for the first time in NAV

(0) ShareShare
ReportReport
Posted on by 35

I am a new user and need to transfer data from our local Trial Balance into NAV's Trial Balance.  Please help!! 

*This post is locked for comments

I have the same question (0)
  • Rocco Cutri Profile Picture
    265 on at

    Hi Carmelito,

    To enter information into the NAV Trial Balance, you need to post a G/L Journal. You would need to decide whether you want to bring over just the Balance Sheet at a point in time, or whether you want to bring over the Balance Sheet + Movements in the Profit & Loss Period by Period.

    When you have decided this you can import the G/L Journals from Excel or CSV, check them and then post.

    Also recall that you can use a Source Code (such as "OPBAL") when you post a G/L Journal.

    Thanks, Rocco

  • Community Member Profile Picture
    on at

    Most companies bring closing balances from their existing system. You can import data using dataport into the General Journal line please make sure all the necessary information is properly created in the .csv format before import. You can import the subledger data (for e,g, Customer, Vendor, Fixed Asset and Bank) after import of general ledger data.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans