1 <!DOCTYPE html PUBLIC
"-//W3C//DTD HTML 4.01//EN">
5 <meta http-equiv=
"CONTENT-TYPE" content=
"text/html; charset=utf-8">
7 <title>Using the import external files feature
</title>
8 <link rel=
"stylesheet" href=
"help.css" type=
"text/css">
19 <h1>Using the Import external files feature
</h1>
21 <p>HomeBank is able to import files downloaded from your bank institution,
22 and also files exported from some various other personal accounting
23 software, like Money, Quicken, GnuCash, via the
<a href=
"#format">supported file format
</a></p>
27 <li>Step
1:
<a href=
"#step1">Open the import assistant dialog
</a></li>
29 <li>Step
2:
<a href=
"#step2">Select a file to import
</a></li>
31 <li>Step
3:
<a href=
"#step3">File analysis result
</a></li>
33 <li>Step
4:
<a href=
"#step4">Adjust what to import
</a></li>
35 <li>Step
5:
<a href=
"#step5">Update your accounts
</a></li>
39 <div class=
"rounded content">
40 <h3 id=
"step1">Step
1: Open the import assistant dialog
</h3>
42 <p>From the
<em>main window
</em>:
</p>
45 <li>Select the File/Import... menu
</li>
47 <li>The import assistant will open and will then guide you through the different steps
48 for importing a file
</li>
51 <div class=
"clear"></div>
55 <div class=
"rounded content">
57 <h3 name=
"step2">Step
2: Select a file to import
</h3>
59 <p>In this page, you will select a single file to import. As default, HomeBank will filter the file on every known formats,
60 you can filter on a precise format if you want.
</p>
63 <p>When you have not selected a file, or the file is not supported:
<br>
64 <img class=
"gtkshot" src=
"images/use-import2a.png"></p>
66 <p>When the file is supported:
<br>
67 <img class=
"gtkshot" src=
"images/use-import2b.png"></p>
71 <div class=
"rounded content">
73 <h3 id=
"step3">Step
3: File analysis result
</h3>
75 <img class=
"gtkshot left" src=
"images/use-import3.png">
77 <p>In this page, you will see a summary of the file currently in the import process
78 with a count of accounts, transactions, payees and categories.
</p>
80 <p>When you import a QIF/CSV file, you will be able to change the default date order here
81 if the load failed on this. he default date order can be configured into the preferences dialog.
</p>
85 <div class=
"clear"></div>
90 <div class=
"rounded content">
91 <h3 id=
"step4">Step
4: Adjust what to import
</h3>
94 <h4>Account to import
</h4>
95 <img class=
"gtkshot left" src=
"images/use-import4a.png">
97 <p>In this section, you control the accounts to be imported.
</p>
99 <p>Depending the file format, HomeBank will try to match the account by its number or its name.
</p>
101 <p>For QIF: the match will be done by the account name
</p>
103 <p>For OFX: by account number, HomeBank try to find the OFX number as a substring of an account number.
</p>
105 <p>For CSV: a default account will be created, change this manually if required.
</p>
108 <P>However, for some QIF files, or any CSV files, there is no information that will permit to identify the
109 account to import, so you will to manage this manually.
</p>
111 <div class=
"clear"></div>
113 <h4>Transactions to import
</h4>
115 <img class=
"gtkshot left" src=
"images/use-import4b.png">
117 <p>In this section, you control the transactions to be imported.
</p>
119 <p>HomeBank will detect if a transaction you currently want to import
120 already exists, and if so will not check the import box for that transaction
121 and you also have a warning icon.
</p>
123 <p>If some transaction are suspected to have duplicates, you will be able to view the
124 duplicates in the "Detail of duplicate transaction" for each transaction you select.
</p>
126 <p>Once you unfold this section, you can also change some detection parameters and refresh.
</p>
128 <p> The detection is done in the following order: account, amount, and date
129 according to the defined tolerance (default is
0 days).
</p>
131 <div class=
"clear"></div>
134 <div class=
"rounded content">
136 <h3 id=
"step5">Step
5: Update your accounts
</h3>
138 <p><img class=
"gtkshot left" src=
"images/use-import5.png"></p>
140 <p>This last step will show the synthesis of what is to be imported.
</p>
142 <p>The number of accounts to update / create.
</p>
144 <p>The number of transaction to be imported, rejected and the one for which
145 automatic assignment was done for payee and/or category.
</p>
148 <div class=
"clear"></div>
154 <div class=
"rounded content">
155 <h3 id=
"format">Supported file formats
</h3>
158 <li>QIF - Quicken Interchange Format
</li>
160 <li>QFX - Quicken Financial Exchange
</li>
162 <li>OFX - Open Financial Exchange
</li>
164 <li>CSV - Comma-Separated Value - (specific format rules,
<a href=
165 "misc-csvformat.html">detailed here
</a>)
</li>