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

   1 <!DOCTYPE html>
   2 <html>
   3 <head>
   4   <meta content="text/html; charset=utf-8" http-equiv="CONTENT-TYPE">
   5   <meta content="noindex" name="robots">
   6   <title>Using the import files feature</title>
   7   <link href="help.css" rel="stylesheet" type="text/css">
   8 </head>
   9 <body id="top">
  10   <div class="dochead">
  11     HomeBank User manual
  12   </div>
  13   <div class="title">
  14     <h1>Using the Import files feature</h1>
  15     <p>HomeBank is able to import one or several downloaded statements from your bank or credit card,
  16     or maybe exported from some other programs, in the following formats:</p>
  17
  18     <p class="padleft">
  19     <b>Recommended:</b> .OFX or .QFX<br>
  20     <i>(Sometimes named Money™ or Quicken™)</i><br>
  21     <b>Supported:</b> .QIF<br>
  22     <i>(Common Quicken™ file)</i><br>
  23     <b>Advanced users only:</b> .CSV<br>
  24     <i>(format is specific to HomeBank, <a href="misc-csvformat.html#txn">see the documentation</a>)</i><br>
  25     </p>
  26
  27     <ul class="toc">
  28       <li>Step 1: <a href="#step1">Open the import assistant dialog</a></li>
  29       <li>Step 2: <a href="#step2">Select file(s) to import</a></li>
  30       <li>Step 3: <a href="#step3">Adjust what to import for each account</a></li>
  31       <li>Step 4: <a href="#step4">Confirmation</a></li>
  32     </ul>
  33     <p><img src="images/d-warn.png">&nbsp;<span class="warning">Starting v5.2, the assigments occurs when you validate the import.</span></p>
  34   </div>
  35   <div class="rounded content">
  36     <h3 id="step1">Step 1: Open the import assistant dialog</h3>
  37     <p>From the <em>main window</em>:</p>
  38     <ul>
  39       <li>Select the File/Import... menu<br>
  40       The import assistant will open, with an empty file list</li>
  41       <br>
  42       <li>By dropping one or several file to import<br>
  43       The import assistant will open, with the file dropped already into the file list</li>
  44     </ul>
  45     <p>then you will be guided you through the different steps for importing the files</p>
  46     <div class="clear"></div>
  47   </div>
  48   <div class="rounded content">
  49     <h3>Step 2: Select file(s) to import</h3>
  50     <p>You can again drop some files here, or use the +/- button to pick up some files to import.</p>
  51           <img class="gtkshot left" src="images/use-import2.png"></p>
  52   <div class="clear"></div>
  53   </div>
  54   <div class="rounded content">
  55     <h3 id="step3">Step 3: Adjust what to import for each account</h3>
  56     <p>For each account, you will be able to select what to import with several option, depending on the format.</p>
  57
  58     <h4>Import xxxxxx into</h4><img class="gtkshot right" src="images/use-import3a.png">
  59     <p>where xxxxxx will be <b>this file</b> or <b>this account</b>. If you put the mouse over it, you will get
  60     some information on a tooltip: Name, Number, File, Encoding.</p>
  61
  62     <h4>Target account</h4>
  63     <p>
  64       <ul>
  65         <li>&lt;New account (global)&gt; : is a global account to merge several file/account</li>
  66         <li>&lt;New account&gt; : import in a separate account<br>
  67         <li>... all your existing account ...</li>
  68         <li>&lt;Skip this account&gt; : to completely skip the account</li>
  69       </ul>
  70     </p>
  71
  72     <h4>Automated account target</h4>
  73     <p>Except for .CSV, HomeBank will try to match the account by its number at first, then by its name.</p>
  74     <p>For this to work, of course the number (for OFX) or name (for OFX/QIF) into HomeBank must be a substring
  75     or exact string of what it is into the file to import. For example:<br>
  76       if your account number is <i>1234</i> and the number into the file is 1111 666 <i>1234</i> 77 it should match and preset
  77       the target account for you.</p>
  78
  79     <p>If the file do not contains any reliable account information, you will get a <img src="images/d-warn.png"> icon right to the target account dropdown.</p>
  80
  81     <h4>Import options</h4>
  82     <p>Depending on the format, you will have several option, similar to the one you have configured into the preferences.</p>
  83
  84
  85     <h4>Transactions to import</h4><img class="gtkshot right" src="images/use-import3b.png">
  86     <p>Here you will select the transactions to be imported, with the tick column, or select all, none, invert option.</p>
  87     <p>By default, HomeBank will detect exact duplicate (within the current import), and depending on the target account, the
  88     similar transaction into the target account and mark them with a <img src="images/hb-ope-similar.png"> icon.</p>
  89
  90     <h4>Similar transaction in target account</h4>
  91     <p>This section will be showed for transaction suspected to already
  92     exists. You can also change the date gap here. The similar detection refresh when you change the target account or the date gap.</p>
  93     <p>The detection of similar transaction is done in the following order, according to the date gap (default is 0 days = exact).</p>
  94     <ul>
  95       <li>same account</li>
  96       <li>same amount</li>
  97       <li>same date (with the configured tolerance)</li>
  98     </ul>
  99     <div class="clear"></div>
 100   </div>
 101   <div class="rounded content">
 102     <h3 id="step4">Step 4: Confirmation</h3>
 103     <p>At last, the synthesis of what is to be imported, for each account.</p>
 104     <p><img class="gtkshot" src="images/use-import4.png"></p>
 105     <div class="clear"></div>
 106   </div>
 107 </body>
 108 </html>