Importing Dynamics NAV journals into Excel error-free

Automatically import your Excel worksheet into Microsoft Dynamics NAV

This seamless integration is great for payroll, fixed assets, and more

Versions: Microsoft Dynamics NAV 4.0, 5.0, 2009, 2013, 2015, 2016, 2017, 2018 | Languages: English, German | Countries: Any


Excel Journal Import Overview

Short introduction ( 1 Min 6 Sec )


  • Create, save, and manipulate journals using the great features of Excel
  • Import any Excel worksheet into any Microsoft Dynamics NAV journal with just a click of a button
  • Use smart logic to match up fields—fields in Excel can be in any order!
  • Import any and all dimensions
  • Optionally create dimensions on the fly (no more doing it over and over!)
  • Auto-create document numbers just like normal journal functionality
  • Import .csv or .txt files as well

Create a journal in Excel and automatically upload it to your Microsoft Dynamics NAV system with just the click of a button.

Lots of smart logic overcomes all the headaches of doing it manually; the system auto-maps your fields, creates document numbers, adds new dimensions, and finds/fixes data errors without starting over.

Common uses are cash receipts, payroll, fixed assets, recurring entries, and imports from external systems. Almost any standard type of file can be imported.

A real must-have for any accounting department.

Related products