| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 164 |
| Technical Name |
os_accounting_import |
| License | LGPL-3 |
Accounting Journal Entries Import
Streamline your accounting workflow by importing journal entries directly from Excel (.xlsx) or CSV files. This module helps you migrate data or batch-process large volumes of entries with ease.
Grouping Logic: Lines are grouped into single Journal Entries based on the combination of Date, Journal, and Name.
Expected File Template
Ensure your file contains the following column headers exactly as shown below:
| Column Name | Description | Required |
|---|---|---|
date |
Entry date (YYYY-MM-DD format) | Optional |
journal_id |
Journal Code (e.g., MISC) or Name | Yes |
name |
Entry label/identifier (used for grouping) | Yes |
ref |
Reference/Memo field | Optional |
line_ids/account_id |
Account Code (e.g., 101000) | Yes |
line_ids/name |
Individual line label | Optional |
line_ids/debit |
Debit amount | Optional |
line_ids/credit |
Credit amount | Optional |
Step-by-Step Instructions
- Navigate to Accounting > Configuration > Import Journal Entries.
- Prepare your file according to the template above.
- Upload the file and select the appropriate Import Type (Excel or CSV).
- Click Import. The system will validate your data and create the entries.
Please log in to comment on this module