Import Data Templates

27 May 2024

The app Import Data Templates is designed to facilitate easy importation of documents and journals into Microsoft Dynamics Business Central through powerful, configurable templates.

Users can quickly import data in its original format without the need for complex data transformations or customizations.

Common use cases for imports include:

  • Vendor purchase invoices.
  • Customer sales invoices.
  • Allocation journals.
  • Payroll journals.

and so on..


  1. The import process can be initiated directly from the specific journal or document page.

  2. ExcelCSV and fixed-length files are supported.

  3. The most common types of Business Central entries are covered:

  • Documents: Sales Quotes, Sales Orders, Sales Return Orders, Sales Invoices, Sales Credit Memos, Purchase Quotes, Purchase Orders, Purchase Return Orders, Purchase Invoices, Purchase Credit Memos, Transfer Orders, Assembly Orders and more.
  • Journals: General Journals, Payment Journal, Cashs, Cash Receipts Journals, Sales Journals, Purchase Journals, Job Journals, Job G/L Journals, Fixed Asset Journals, Fixed Asset G/L Journals, Resource Journals, Item Journals, Item Reclassification Journals and more.
  1. Import single files or multiple files within a ZIP archive.

  2. Use mapping rules to map external data to Business Central entities.

  3. Providing specific **parameters during the import process for variable data, such as selecting the posting date.

  4. Automatically apply processing actions to the imported data, such as releasing documents or posting journals.


  1. The list of imported files can be saved, also preventing duplicate imports.
  2. Templates can be made available only to specific users.
  3. Importexport and copy existing templates.
  4. Create templates based on example files or export the template structure to be filled with data.


  1. API integration is available to automate the import process from external systems or through Power Automate.