Dogcows Code - chaz/homebank/blob - doc/use-import.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN">
   2
   3 <html>
   4 <head>
   5   <meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
   6
   7   <title>Using the import external files feature</title>
   8   <link rel="stylesheet" href="help.css" type="text/css">
   9
  10 </head>
  11
  12 <body id="top">
  13   <div class="dochead">
  14     HomeBank User manual
  15   </div>
  16
  17   <div class="title">
  18
  19   <h1>Using the Import external files feature</h1>
  20
  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>
  24
  25
  26  <ul class="toc">
  27     <li>Step 1: <a href="#step1">Open the import assistant dialog</a></li>
  28
  29     <li>Step 2: <a href="#step2">Select a file to import</a></li>
  30
  31     <li>Step 3: <a href="#step3">File analysis result</a></li>
  32
  33     <li>Step 4: <a href="#step4">Adjust what to import</a></li>
  34
  35     <li>Step 5: <a href="#step5">Update your accounts</a></li>
  36   </ul>
  37 </div>
  38
  39   <div class="rounded content">
  40   <h3 id="step1">Step 1: Open the import assistant dialog</h3>
  41
  42   <p>From the <em>main window</em>:</p>
  43
  44   <ul>
  45     <li>Select the File/Import... menu</li>
  46
  47     <li>The import assistant will open and will then guide you through the different steps
  48   for importing a file</li>
  49   </ul>
  50
  51   <div class="clear"></div>
  52
  53  </div>
  54
  55   <div class="rounded content">
  56
  57   <h3 name="step2">Step 2: Select a file to import</h3>
  58
  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>
  61
  62
  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>
  65
  66   <p>When the file is supported:<br>
  67   <img class="gtkshot" src="images/use-import2b.png"></p>
  68
  69  </div>
  70
  71   <div class="rounded content">
  72
  73   <h3 id="step3">Step 3: File analysis result</h3>
  74
  75         <img class="gtkshot left" src="images/use-import3.png">
  76
  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>
  79
  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>
  82
  83
  84
  85   <div class="clear"></div>
  86
  87  </div>
  88
  89
  90   <div class="rounded content">
  91   <h3 id="step4">Step 4: Adjust what to import</h3>
  92
  93
  94   <h4>Account to import</h4>
  95   <img class="gtkshot left" src="images/use-import4a.png">
  96
  97   <p>In this section, you control the accounts to be imported.</p>
  98
  99   <p>Depending the file format, HomeBank will try to match the account by its number or its name.</p>
 100
 101   <p>For QIF: the match will be done by the account name</p>
 102
 103   <p>For OFX: by account number, HomeBank try to find the OFX number as a substring of an account number.</p>
 104
 105   <p>For CSV: a default account will be created, change this manually if required.</p>
 106
 107
 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>
 110
 111   <div class="clear"></div>
 112
 113   <h4>Transactions to import</h4>
 114
 115   <img class="gtkshot left" src="images/use-import4b.png">
 116
 117   <p>In this section, you control the transactions to be imported.</p>
 118
 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>
 122
 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>
 125
 126   <p>Once you unfold this section, you can also change some detection parameters and refresh.</p>
 127
 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>
 130
 131   <div class="clear"></div>
 132  </div>
 133
 134   <div class="rounded content">
 135
 136   <h3 id="step5">Step 5: Update your accounts</h3>
 137
 138 <p><img class="gtkshot left" src="images/use-import5.png"></p>
 139
 140   <p>This last step will show the synthesis of what is to be imported.</p>
 141
 142   <p>The number of accounts to update / create.</p>
 143
 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>
 146
 147
 148   <div class="clear"></div>
 149
 150 </div>
 151
 152
 153
 154   <div class="rounded content">
 155   <h3 id="format">Supported file formats</h3>
 156
 157   <ul>
 158     <li>QIF - Quicken Interchange Format</li>
 159
 160     <li>QFX - Quicken Financial Exchange</li>
 161
 162     <li>OFX - Open Financial Exchange</li>
 163
 164     <li>CSV - Comma-Separated Value - (specific format rules, <a href=
 165     "misc-csvformat.html">detailed here</a>)</li>
 166   </ul>
 167
 168
 169    </div>
 170 </body>
 171 </html>