HomeBank User manual

# Using the Import external files feature

HomeBank is able to import files downloaded from your bank institution, and also files exported from some various other personal accounting software, like Money, Quicken, GnuCash, via the supported file format

### Step 1: Open the import assistant dialog

From the main window:

- Select the File/Import... menu
- The import assistant will open and will then guide you through the different steps for importing a file

### Step 2: Select a file to import

In this page, you will select a single file to import. As default, HomeBank will filter the file on every known formats, you can filter on a precise format if you want.

When you have not selected a file, or the file is not supported:

When the file is supported:

### Step 3: File analysis result

In this page, you will see a summary of the file currently in the import process with a count of accounts, transactions, payees and categories.

When you import a QIF/CSV file, you will be able to change the default date order here if the load failed on this. he default date order can be configured into the preferences dialog.

### Step 4: Adjust what to import

#### Account to import

In this section, you control the accounts to be imported.

Depending the file format, HomeBank will try to match the account by its number or its name.

For QIF: the match will be done by the account name

For OFX: by account number, HomeBank try to find the OFX number as a substring of an account number.

For CSV: a default account will be created, change this manually if required.

However, for some QIF files, or any CSV files, there is no information that will permit to identify the account to import, so you will to manage this manually.

#### Transactions to import

In this section, you control the transactions to be imported.

HomeBank will detect if a transaction you currently want to import already exists, and if so will not check the import box for that transaction and you also have a warning icon.

If some transaction are suspected to have duplicates, you will be able to view the duplicates in the "Detail of duplicate transaction" for each transaction you select.

Once you unfold this section, you can also change some detection parameters and refresh.

The detection is done in the following order: account, amount, and date according to the defined tolerance (default is 0 days).

### Step 5: Update your accounts

This last step will show the synthesis of what is to be imported.

The number of accounts to update / create.

The number of transaction to be imported, rejected and the one for which automatic assignment was done for payee and/or category.

### Supported file formats

- QIF - Quicken Interchange Format
- QFX - Quicken Financial Exchange
- OFX - Open Financial Exchange
- CSV - Comma-Separated Value - (specific format rules, detailed here)