HomeBank User manual

# Using the Import files feature

HomeBank is able to import one or several downloaded statements from your bank or credit card, or maybe exported from some other programs, in the following formats:

Recommended: .OFX or .QFX
(Sometimes named Money™ or Quicken™)
Supported: .QIF
(Common Quicken™ file)
Advanced users only: .CSV
(format is specific to HomeBank, see the documentation)

There is a UI limitation on the number of account you can import here, as there is no scrollbar on GtkAssistant, so you may need to split your import file.

### Step 1: Open the import assistant dialog

From the main window:

- Select the File/Import... menu
  The import assistant will open, with an empty file list
- By dropping one or several file to import
  The import assistant will open, with the file dropped already into the file list

then you will be guided you through the different steps for importing the files

### Step 2: Select file(s) to import

You can again drop some files here, or use the +/- button to pick up some files to import.

### Step 3: Adjust what to import for each account

For each account, you will be able to select what to import with several option, depending on the format.

#### Import xxxxxx into

where xxxxxx will be this file or this account. If you put the mouse over it, you will get some information on a tooltip: Name, Number, File, Encoding.

#### Target account

- <New account (global)> : is a global account to merge several file/account
- <New account> : import in a separate account
- ... all your existing account ...
- <Skip this account> : to completely skip the account

#### Automated account target

Except for .CSV, HomeBank will try to match the account by its number at first, then by its name.

For this to work, of course the number (for OFX) or name (for OFX/QIF) into HomeBank must be a substring or exact string of what it is into the file to import. For example:
if your account number is 1234 and the number into the file is 1111 666 1234 77 it should match and preset the target account for you.

If the file do not contains any reliable account information, you will get a icon right to the target account dropdown.

#### Import options

Depending on the format, you will have several option, similar to the one you have configured into the preferences.

#### Transactions to import

Into this listview will be displayed all the transaction for the current file/account. You can check/uncheck each transaction one by one or select all, none, invert option, and valid to uncheck again possible duplicate.

By default, HomeBank will detect exact duplicate (within the current import), and depending on the target account, the similar transaction into the target account, uncheck them for import and mark them with a icon.

Possible duplicate note:
If the file is an OFX/QFX file, the FITID will be used, identical FITID means a duplicate (since 5.5.1).
Otherwise a simple comparison of value: date, amount, memo, number, payee and category identical means a duplicate.

#### Similar transaction in target account

This section will be showed for transaction suspected to already exists. You can also change the date gap here. The similar detection refresh when you change the target account or the date gap.

The detection of similar transaction is done in the following order, according to the date gap (default is 0 days = exact).

- same account
- same amount
- same date (with the configured tolerance)

### Step 4: Confirmation

At last, the synthesis of what is to be imported, for each account.

#### Option

This option is to import transaction as pending status

#### Run automation

1) Enrich with payee default
this option will use the fill option you have set into each payee

2) Run automatic assignment rules
this option will run the assignment rules