X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fhomebank;a=blobdiff_plain;f=doc%2Fuse-import.html;fp=doc%2Fuse-import.html;h=6c9759cba641abafb55da97de215dca62ce69dde;hp=2aaa9e210917ac0939fa90f250885191f68e0dbe;hb=a6c6b0df5492c2160ed97e3a376bdb2fe7c5ebc4;hpb=cd13d9691c46c2b2d6d459e9e6a76bed1c21b7a6 diff --git a/doc/use-import.html b/doc/use-import.html index 2aaa9e2..6c9759c 100644 --- a/doc/use-import.html +++ b/doc/use-import.html @@ -12,62 +12,85 @@

Using the Import files feature

-

HomeBank is able to import files downloaded from your Bank institution, and also files coming from various personal accounting software, like Money, Quicken, GnuCash, in the supported file format.

+

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.

Step 1: Open the import assistant dialog

From the main window:

+

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

-

Step 2: Select a file to import

-

Here you select a single file to import. HomeBank will position the filter to the format you just chosen from the menu.

- - - - - - -
-

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

-
-

When the file is supported:
-

-
+

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

-

The following steps will only be displayed when you need to validate or confirm an action or a configuration.

-

File properties

-

This step is never showed, until you use the back button, as HomeBank will go to the step you need to change or check things

-

A summary of the file currently in the import process is showed with a count of accounts, transactions, payees and categories.

-

When you import a QIF/CSV file, HomeBank will try to import date with the format order configured into the preferences, and it will try to detect it otherwise. If something went wrong with the date, please adjust the preferences settings to match the file date format order you usually import.

-
-

Account to import

-

Here you will control the accounts and how to import it.

-

Depending on 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.

-

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 need to manage this manually.

-
-

Transactions to import

-

Here you will control the transactions to be imported.

-

HomeBank will detect if a transaction in the current import file already exists into the target account, and if so will disable it for import and show a warning icon.

-

Detail of existing transaction section will show the transaction suspected to already exists and them let you choose what to do.

-

You can also change the detection parameters and refresh that list.

-

The detection of existing transaction is done in the following order, according to the date tolerance (default is 0 days).

+

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

+

+

+

+ +

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

+

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.

+ +

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

Step 4: Confirmation

-

-

At last show the synthesis of what is to be imported and requires a last confirmation.

-

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.

+

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

+

-
-

Supported file formats

- -
- \ No newline at end of file +