How Import GL Journal Works in iDempiere
The Import GL Journal window in iDempiere is used to bring external accounting journal data into the ERP in a controlled and auditable way. It acts as a staging area, where journal lines are validated, corrected if needed, and then converted into standard GL Journal documents.
This feature is commonly used during data migration, integration with external systems, or bulk journal uploads.
Import GL Journal Purpose
Import GL Journal eliminates manual entry of large journal volumes, ensures accounting structure compliance before posting, and validates data against master records (accounts, organizations, periods). Imported data undergoes validation and conversion first never posted directly.
GL Journal Data Entry
Journal data is usually loaded into the import table via:
- CSV / flat file import
- External integration tools
- Database-level data load
Each record includes key fields: Account, Debit/Credit, amount, Organization, Accounting date, and Description. At this stage, data remains unprocessed—not yet a real journal.
GL Journal Validation Process
Before journals are created:
- iDempiere checks whether accounts exist
- Verifies accounting schema compatibility
- Confirms the period is open
- Ensures debit and credit rules are valid
Invalid rows remain in the import window with error messages, allowing correction before processing.
GL Journal Creation Process
Once data is validated, the Import GL Journal process converts valid records into standard GL Journal and Journal Lines. Import records are then marked as processed. Created journals function identically to manually entered GL journals.
GL Journal Posting Process
After import, GL Journals follow standard approval rules, generate accounting facts upon posting, and support reversal/reporting normally. Importing accelerates data entry without bypassing accounting controls.
Import GL Journal provides a safe and structured way to bring external accounting data into iDempiere. It separates data loading, validation, journal creation, and posting, ensuring accounting integrity while reducing manual effort.