Configuration and workflow:

1. How do we get the Excel template for the import?

1.1 Open the accounting application -> Configuration -> Settings.

Click on import in the accounting import section.

1.2 Choose the third import journal item for the template.

2. The following is an explanation of the excel file and how it impacts the import.

2.1 The top two lines represent one journal entry. So the journal, x_move_id, date, partner share the same value. The value of 11750 is the same for the two journal items. One is in debit, another is in credit.

2.2 x_move_id column means journal entry.

2.3 Account_id column:

441000 is an income type of account.

121000 is the account receivable

101401 is the bank account.

2.4 While importing the invoices in the invoice journal, one journal item is restricted to the receivable type of account, and another account is not restricted to the income type of account. In the import example, we use 441000 income types of accounts for demonstration purposes.

3. While importing the file, follow steps 1.1 and 1.2. Choose ‘import tab’ instead of template in step 1.2.

4. Click on upload the file and choose the Excel file from your computer.

5. Select the field in the Odoo field column if it is not automatically populated.

6. Based on the Excel file in step 2, the journal item is as below, with the matching # column showing I98 on both 121000 accounts receivable in the account column.

7. Based on the Excel file in step 2, there are two journal entries with a value of $11750 in the ‘draft’ stage. One journal entry is in INV journal (customer invoice) while another entry is in BNK1 journal (bank).

8. After import, the journal name is changed.

The customer invoice journal becomes INV. The bank journal becomes BNK1.

We can manually change the journal name if needed.