Publish journal lines and documents from Excel

This article explains how to enter and publish lines for general journals from Microsoft Excel. It includes information about the various templates that you can use, depending on the type of transactions that you're entering.

Users can enter and publish lines for financial journals from Microsoft Excel. After a user creates a journal, the Open lines in Excel button displays the templates that are available. Templates are designed to support specific scenarios, however not every combination of account type is supported in the journal. The following table shows the templates that are available and the account types which they support.

Template	Supported account types	How to access the template
Ledger journal lines	Account: Ledger, Customer, Vendor, Bank Offset account: Ledger, Customer, Vendor, Bank Intercompany is supported.	General journal
Invoice register	Account: Vendor Offset account: Ledger Intercompany isn't supported.	AP invoice register
Invoice journal	Accounts: Vendor Offset account: Ledger Intercompany is supported.	AP invoice journal
Vendor invoice		Vendor invoice
Customer invoice journal	Account: Customer Offset account: Ledger Intercompany is supported.	General journal
Free text invoice		On the Free text invoice page, click Open in Excel (the Microsoft Office icon).
Fixed assets journal	Asset to ledger, bank, customer, or vendor. Intercompany isn't supported.	Fixed asset journal
Vendor payment journal	Account: Vendor Offset account: Ledger, Bank Intercompany is supported.	Vendor payment journal
Customer payment journal	Account: Customer Offset account: Ledger, Bank Intercompany is supported.	Customer payment journal
Project expense journal	Account: Project, Ledger, Customer, Vendor Offset account: Project, Ledger, Customer, Vendor Intercompany is supported.	General journal Expense (under Project management and accounting)

When the lines are published, they are validated to make sure that they comply with the rules that are set up in the financial journals. After the lines are published, users can edit or post the vouchers from Dynamics 365 Finance.

To add financial dimensions to a template, additional changes are required. For additional information, see Add dimensions to the Microsoft Excel template. After dimensions are added to the entity, they are available in the Excel designer and can be added to the template.