Starting v5.2, the assigments occurs when you validate the import.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
- - -From the main window:
- -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)
+
Starting v5.2, the assigments occurs when you validate the 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:
- 
From the main window:
+then you will be guided you through the different steps for importing the files
+ +
-
- 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.
- - - +You can again drop some files here, or use the +/- button to pick up some files 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.
- - - -
-
- 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.
+For each account, you will be able to select what to import with several option, depending on the format.
-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).
- - -
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.
- - - - -
+ 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.
+ ++
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.
Depending on the format, you will have several option, similar to the one you have configured into the preferences.
+ + +
+ Here you will select the transactions to be imported, with the tick column, or select all, none, invert option.
+By default, HomeBank will detect exact duplicate (within the current import), and depending on the target account, the
+ similar transaction into the target account and mark them with a 
icon.
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).
+At last, the synthesis of what is to be imported, for each account.
+