In this guide, we show How to Import CSV, Excel, and TXT Files into All Journals, except for Cashbook Journals, in the MAT Finance Module.
Note: It is not possible to import files into Cashbook Journals
Access: The minimum permissions required to Import Journal Details are found in the Finance Module section of Config > Setup > Roles & Permissions.
To begin, from the left Menu, go to Finance > New Entry > Journal.
Click on the Import button, which launches the Import Journal pop up.
In the Import Journal pop up, select one of the following options:
1. Download a template:
- Select the File Type you want to download
- Select Template to download
Example of a blank Excel template format:
2. Import a saved file:
- Select the File Type you are importing
- Select Choose File to import a single file
- Select the saved file and click Open
Note: The file must be in the same format as the File Type.
A Success message is displayed, which details the number of rows that have been imported with valid and also invalid data, and the number of rows that have been skipped.
This is an example of a successful import for one row with valid data.
Note: Importing a Journal always overwrites existing information in the Journal row.
If the import contains Invalid Data, or a blank Description, Debit, or Credit, the table leaves these cells blank and highlights them with a red border. These cells can be edited in the table. Users are not able to Save Draft or Post the Journal without removing all of the invalid data or filling in blank cells.
Examples of Invalid Data:
- Negative Debit or Credit values
- Blank Cost Centre, or Ledger Code
- Cost Centre or Ledger Code not recognised
- Cost Centre or Ledger Code not linked
This is an example of a successful import but with a blank Ledger Code.
