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 files downloaded from your Bank institution, and also files coming from various personal accounting software, like Money, Quicken, GnuCash, in the <a href="#format">supported file format</a>.</p>
  16     <ul class="toc">
  17       <li>Step 1: <a href="#step1">Open the import assistant dialog</a></li>
  18       <li>Step 2: <a href="#step2">Select a file to import</a></li>
  19       <li>Step 3: <a href="#step3">Adjust what to import</a></li>
  20       <li>Step 4: <a href="#step4">Confirmation</a></li>
  21     </ul>
  22   </div>
  23   <div class="rounded content">
  24     <h3 id="step1">Step 1: Open the import assistant dialog</h3>
  25     <p>From the <em>main window</em>:</p>
  26     <ul>
  27       <li>Select the File/Import... menu</li>
  28       <li>The import assistant will open and then will guide you through the different steps for importing a file</li>
  29     </ul>
  30     <div class="clear"></div>
  31   </div>
  32   <div class="rounded content">
  33     <h3>Step 2: Select a file to import</h3>
  34     <p>Here you select a single file to import. HomeBank will position the filter to the format you just chosen from the menu.</p>
  35     <table>
  36       <tr>
  37         <td>
  38           <p>When you have not selected a file, or the file is not supported:<br>
  39           <img class="gtkshot" src="images/use-import2a.png"></p>
  40         </td>
  41         <td></td>
  42         <td>
  43           <p>When the file is supported:<br>
  44           <img class="gtkshot" src="images/use-import2b.png"></p>
  45         </td>
  46       </tr>
  47     </table>
  48   </div>
  49   <div class="rounded content">
  50     <h3 id="step3">Step 3: Adjust what to import</h3>
  51     <p>The following steps will only be displayed when you need to validate or confirm an action or a configuration.</p>
  52     <h4>File properties</h4>
  53     <p>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</p><img class="gtkshot left" src="images/use-import3.png">
  54     <p>A summary of the file currently in the import process is showed with a count of accounts, transactions, payees and categories.</p>
  55     <p>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.</p>
  56     <div class="clear"></div>
  57     <h4>Account to import</h4><img class="gtkshot left" src="images/use-import4.png">
  58     <p>Here you will control the accounts and how to import it.</p>
  59     <p>Depending on the file format, HomeBank will try to match the account by its number or its name.</p>
  60     <p>For QIF: the match will be done by the account name</p>
  61     <p>For OFX: by account number, HomeBank try to find the OFX number as a substring of an account number.</p>
  62     <p>For CSV: a default account will be created.</p>
  63     <p>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.</p>
  64     <div class="clear"></div>
  65     <h4>Transactions to import</h4><img class="gtkshot left" src="images/use-import5.png">
  66     <p>Here you will control the transactions to be imported.</p>
  67     <p>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.</p>
  68     <p><strong>Detail of existing transaction</strong> section will show the transaction suspected to already exists and them let you choose what to do.</p>
  69     <p>You can also change the detection parameters and refresh that list.</p>
  70     <p>The detection of existing transaction is done in the following order, according to the date tolerance (default is 0 days).</p>
  71     <ul>
  72       <li>same account</li>
  73       <li>same amount</li>
  74       <li>same date (with the configured tolerance)</li>
  75     </ul>
  76     <div class="clear"></div>
  77   </div>
  78   <div class="rounded content">
  79     <h3 id="step4">Step 4: Confirmation</h3>
  80     <p><img class="gtkshot left" src="images/use-import6.png"></p>
  81     <p>At last show the synthesis of what is to be imported and requires a last confirmation.</p>
  82     <p>The number of accounts to update / create.</p>
  83     <p>The number of transaction to be imported, rejected and the one for which automatic assignment was done for payee and/or category.</p>
  84     <div class="clear"></div>
  85   </div>
  86   <div class="rounded content">
  87     <h3 id="format">Supported file formats</h3>
  88     <ul>
  89       <li>QIF - Quicken Interchange Format</li>
  90       <li>QFX - Quicken Financial Exchange</li>
  91       <li>OFX - Open Financial Exchange</li>
  92       <li>CSV - Comma-Separated Value - (specific format rules, <a href="misc-csvformat.html">detailed here</a>)</li>
  93     </ul>
  94   </div>
  95 </body>
  96 </html>