Importing transactions from a CSV file

Select File, Import data, and then Import ledger transactions to import comma-delimited or tab-delimited file of transactions.

You'll have to set up the link between the accounts in the other package and accounts you use in Ledger Assistant. If the account link for the client hasn't been created, Ledger Assistant will suggest you set up this link prior to importing the file.

Ledger Assistant will display the columns of the selected import file where you'll have to select the column type for each of the columns you wish to use. The following columns are mandatory: Date, Account number, Amount (or Debit and Credit).Once the columns have been selected and accepted by selecting the green tickmark, Ledger Assistant will display the Import Transactions form which will show all transactions from the selected file.

Next you'll want to select the account for every transaction in the import file. When you select one match, Ledger Assistant will scan all the transactions and assign the same match for other transactions with the same account number. Header accounts can be indicated by using the account number "-1". Transactions with the account number "-1" will not be imported.When importing transactions from the Internet banking system, the account numbers won't be present. Then you can use rules to help you allocate the account number to each of the transactions.

When all the transactions have been linked to the appropriate accounts, the file can be imported by select Transfer.