Import bank transactions

Top  Previous  Next

Select the bank account (double-click it or select it, with a single click or by moving the cursor with the display keys, then press Enter key).

 

The following dialog is displayed, listing preset banks accounts.

 

clip152

 

This allows you to select preset bank accounts stored in the file banks.dat saved in the same folder as the program.

 

You can download the latest updated banks.dat file containing preset bank accounts from the website.

 

To remove a country from the drop down list, select the country and click the X besides the field.

 

To remove a bank from the drop down list, select the bank and click the X besides the field.

 

 

If the bank account from which you downloaded the bank transactions is not within the list of preset bank accounts, you will be able to add it with the 'Add bank' button of the next form.

 

Until then, select 'Other country' or 'Other bank' and click OK.

 

 

Select the file containing the transactions data to import.

 

NOTE:  the csv file must not be opened in another application.

 

 

The Import transactions dialog is displayed, showing the contents of the transactions file in a window.

 

clip151

 

Select a transaction line from the list in the window. The fields (columns) are identified by a letter and the content of each field (column) is displayed.

 

Specify the letter for the fields (a transaction must include at least a date and an amount):

 
Date
Entry number
Description
deposit amount
cheque/payment amount
 
Note: during the process you can select a different transaction line to determine the deposit and cheque/payment field (column) letter. If deposit and cheque/payment are in the same field(column), specify the same letter.

 

 

Clicking 'Add bank', the following form is displayed

 

clip153

 

Type the country.

 

Type the bank.

 

 

 

Clicking OK, you are asked to specify an allocation account for each transaction.

 

clip154

 

 

Clicking the Account field, the following dialog is displayed.

 

clip119

 

Select the allocation account from the list displayed (double-click it or select it, with a single click or by moving the cursor with the

display keys, then press Enter key)

or

type the account number and press, Enter key to move to the next transaction or click the the Account field of the next transaction.

 

Note: For transactions with the same description as the description of a recorded transaction, the Allocation Account Title column is prefilled with the account number and account title, and the account is pre-selected in the list of accounts, so you can press Enter key to select the allocation account and move to the next transaction.

 

 

Automatically allocate pre-selected accounts

 

The pre-selected accounts can be automatically allocate to the transactions by checking the checkbox at the bottom left. Unchecking the checkbox will undo the allocation.

 

 

 

Closing the form

 

The bank transactions are automatically organized and recorded as Deposit or Cheque.

 

 

If there are transactions without an allocation account, the following message is prompted

 

clip155

 

Clicking OK, you can select an account from the list of accounts.

 

 

If no account is selected, the following message is prompted

 

clip156