How to create a GL journal import File for Odoo 13

How to create a GL journal import File for Odoo 13

The following fields are a must for a successful import of GL transaction within a journal:

1. Date
2. Partner
3. Reference
4. Journal Items/Label
5. Journal Items
6. Journal Items/Credit
7. Journal Items/Debit

From Accounting> Journal Entries, click on the IMPORT file icon then LOAD FILE.

Once, the load file screen identifies the location of the template and Load it.

TEST to make sure there is no matching error and IMPORT.

It is very important to leave the highlighted box as below:

Here the result:

When opening the journal:

The Excel template: 

I hope this will help you!!!