Delimited file import
The Delimited file import batch processing option allows you to import transactions in a batch from valid Comma Separated Batch (*.csv) file format.
To import delimited files in a batch, you need to select a valid file format (created with the Write delimited file option).
To import a delimited file into a batch:
- On the Default ribbon, select Batch entry (F2).
|
|
You may right-click on the selected batch (journal) on the Batch type selection screen, and select the Delimited file import option on the context menu. |
- Select a Batch type and click on the Open button. The Batch entry transaction screen for the selected Batch type will be displayed.
- Click on the F9:Process icon. The "Process the batch" options screen is displayed:

- Select the Delimited file import option, and click on the OK button.
- The "Open" screen is displayed:

- Select valid "Comma Delimited Batches" (default) file from the folders on your system
- Click on the Open button. All the transactions in the selected, posted batch will be imported into the selected batch.

|
|
Should the processing icons on the "Batch entry" screen is inactive during this process, you may need to close and reopen the batch. |
- All the transactions included in the Exported file saved using the "Write delimited file" option, will be imported into the batch.
|
|
If Balancing entries (transactions indicated with ******** (8 asterisks) in the "Reference" column) were included in the delimited file selected to import, the balancing entries must be deleted.
|
- Edit the transactions as necessary. In this example the Debtors account is "T-Empty". You may need to select the account,, or delete the transaction, if you do not wish to import that transaction.
|
|
It is important to check and edit the transactions imported in the batch, before you proceed to balance and post the batch. |

- Press F5: Balance to generate balancing entries for the batch. The balancing entries, as per this example, should be as follows:

|
|
Once you have finished entering / editing the transactions in the batch you need to: - |



