Publish journal lines and documents from Excel

This topic 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 Microsoft Dynamics 365 for Finance and Operations, Enterprise edition.

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.