What's new on Bromcom

Latest changes, new features and improvements

.all regions
mat finance
v5.2024.2
February 19, 2024

MAT Finance - Journal Import from Excel, CSV and Txt

Finance > New Entry > Journal

Users can now Import journal details from saved CSV, Excel, and Txt files into the Journal page (except for Cashbook Journals).

Image #1

Clicking on Import will launch the Import Journal popup where users can select one of the following options:

  • Select the File Type followed by Template to download a template example. 
Image #2

Example of a blank Excel template format:

Image #3
  • Select the File Type followed by Choose File to import a single file. The file must be in the same format as the File Type. The video shows an example of importing blank Debit Value and Credit Value cells, and an example of importing a file with a credit value.
Note: Debit Value and Credit Value must be a positive value to avoid errors. 
Image #4

Note: If errors are found in the imported file (empty cells, Cost Centre or Ledger Code not recognised, Cost Centre and Ledger Code not linked, negative Debit or Credit Values):

      • The system will leave these fields blank.
      • If a Ledger Code and Cost Centre are imported that are not linked - the Cost Centre will be added but the Ledger Code will be blank. User will need to correct the Cost Centre Ledger Link before proceeding.
      • Where blank cells are found:
        • The blank cell will be highlighted red.
        • The user can edit the row and manually amend the cells.
        • Users will not be able to "Save Draft" or "Post" the document without removing all the errors.
    • Importing a Journal will always overwrite existing information in the Journal lines.