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

 

Select the file containing the transactions data to import.

 

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

 

clip117

 

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 OK, you are asked to specify an allocation account for each transaction.

 

clip118

 

 

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.

 

 

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