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:

  1. 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.

  1. Select a Batch type and click on the Open button. The Batch entry transaction screen for the selected Batch type will be displayed.
  2. Click on the F9:Process icon. The "Process the batch" options screen is displayed:  

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

  1. Select valid "Comma Delimited Batches" (default) file from the folders on your system
  2. 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. 

  1. 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. 

  1. 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.

  1. 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: -

  1. Change the Alias (Batch name).
  2. Balance the batch.
  3. List the batch.
  4. Post the batch.