Finance - Import to Opening Balance Journal Enhancement
Modules > Finance > Journals > Opening Balance Journal Import
Finance users can now import Opening Balance Journal Lines directly from an Excel file, simplifying the process of transferring closing balances from previous finance systems into Bromcom. This feature reduces manual entry errors and saves time when creating opening balance journals, especially for larger schools with extensive data.
Key Features:
The Import button is now available in the Opening Balance Journal, located between the "Add Lines" and "View/Edit Selected" options. Users can upload Excel files to populate journal lines automatically. The import template can be generated by exporting the Opening Balance Journal grid as a CSV file using the grid actions on the Journal Lines .
The following fields are required for the import:
- Ledger Code, Fund Code, and Cost Centre must match existing, valid entries for the current financial year.
- Ledger Description and Cost Centre Description are free text fields with no validation.
- Remarks allow up to 50 alphanumeric characters, including special characters.
- Debit and Credit fields accept number values with up to two decimal places.
Validation ensures users cannot post to non-balance sheet accounts (e.g., IN, EX, or ES ledger codes). Invalid rows are skipped, and a summary of imported and ignored rows is displayed after the upload.
This update also introduces a thousand separator for the Balance field, enhancing readability.
These enhancements streamline journal entry creation, improving accuracy and efficiency for Finance users.