$ 15.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 423 |
| Technical Name |
uac_account_journal_entry_import |
| License | LGPL-3 |
| Website | https://www.youtube.com/@evangelista-odoo |
| Versions | 15.0 16.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 423 |
| Technical Name |
uac_account_journal_entry_import |
| License | LGPL-3 |
| Website | https://www.youtube.com/@evangelista-odoo |
| Versions | 15.0 16.0 |
Journal Items Import
Import journal entries from Excel files with validation and automatic posting
Description
Streamline your accounting workflow with this powerful Excel import tool. This module allows you to quickly import journal entries from Excel files with comprehensive validation, ensuring data accuracy before posting to your accounting system.
Perfect for businesses that receive accounting data in Excel format from external sources, bookkeepers, or legacy systems. Save hours of manual data entry while maintaining full control over what gets imported into your Odoo accounting system.
Key benefits: Reduce manual errors, speed up data entry, validate accounts automatically, and maintain complete audit trails of imported transactions.
Key Features
Excel File Support
Import directly from .xls and .xlsx files with automatic format detection
Pre-validation
Preview and validate all data before committing to your accounting system
Selective Import
Choose exactly which lines to import with intuitive checkboxes
Auto-Balancing
Automatic verification that debits equal credits before posting
Account Validation
Verify all account codes exist in your chart of accounts
User Security
Dedicated user group to control access to import functionality
Screenshots
Import Wizard
User-friendly wizard interface guides you through the import process step by step
Data Preview
Review all imported data with validation status before final confirmation
Configuration
Set journal, accounting date, and reference information for your import batch
How It Works
Upload Excel File
Select your Excel file (.xls/.xlsx) containing journal entry data with Account, Description, Debit, and Credit columns
Configure Import Settings
Choose the target journal, set accounting date, and optionally add a reference for the import batch
Preview & Validate
Review imported data, validate account codes, and check that debits equal credits
Select Lines
Choose which specific lines to import using checkboxes, edit descriptions if needed
Confirm & Post
Confirm the import to automatically create and post the journal entry in your accounting system
Technical Information
Odoo Version
16.0
Dependencies
- base
- account
- xlrd (Python library)
Supported File Types
- Microsoft Excel (.xls)
- Microsoft Excel (.xlsx)
Required Excel Columns
- Account (Column A)
- Description (Column B)
- Debit (Column C)
- Credit (Column D)
Installation & Setup
Install Module
Install from Odoo Apps store or upload manually to your addons directory
Configure User Access
Assign users to the "Journal Items Import" group in Settings → Users & Companies → Groups
Start Importing
Access the import wizard from Accounting → Journal Entries → Journal Items Import
Please log in to comment on this module