Dogcows Code - chaz/homebank/blob - doc/misc-csvformat.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>CSV file format</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>CSV file format</h1>
  15     <p>With HomeBank you can import/export some of the internal data's in the most common file format that is CSV.</p>
  16     <p>Notice: meanwhile CSV should uses comma as separator, HomeBank uses semi-colon as separator (this is most common than comma)</p>
  17     <p>The format used for the different files is specific to HomeBank, so don't expect to import files your bank should offers you directly, you will need to arrange it a little in a spreadsheet like Gnumeric before.</p>
  18     <p>Below is a description with example of the CSV format that HomeBank uses.</p><!-- separator -->
  19     <ul class="toc">
  20       <li><a href="#txn">Transaction</a></li>
  21       <li><a href="#bud">Budget</a></li>
  22       <li><a href="#cat">Category</a></li>
  23       <li><a href="#pay">Payee</a></li>
  24     </ul>
  25   </div>
  26   <div class="rounded content">
  27     <h2><a id="txn" name="txn"></a>Transaction</h2>
  28     <p><img src="images/d-info.png" width="16" height="16" />&nbsp;Starting v5.2.5 you can change the separator for transaction import <a href="dlg-pref.html#tab5">into preferences</a>.</p>
  29     <table class="widgetinfo">
  30       <tr>
  31         <th>date</th>
  32         <td>the date format can be:
  33           <ul>
  34             <li>y-m-d
  35             <li>m-d-y
  36             <li>d-m-y
  37           </ul>
  38           <p>year can be 2 or 4 digits<br>
  39           separators can be / . or -</td>
  40       </tr>
  41       <tr>
  42         <th>payment</th>
  43         <td>
  44           <img src="images/d-warn.png">&nbsp;<span class="warning">You cannot import transaction with payment type=5 (internal xfer)</span><br>
  45           from 0=none to 10=FI fee (in the same order of the list)<br>
  46         </td>
  47       </tr>
  48       <tr>
  49         <th>info</th>
  50         <td>a string</td>
  51       </tr>
  52       <tr>
  53         <th>payee</th>
  54         <td>a payee name</td>
  55       </tr>
  56       <tr>
  57         <th>memo</th>
  58         <td>a string</td>
  59       </tr>
  60       <tr>
  61         <th>amount</th>
  62         <td>a number with a '.' or ',' as decimal separator, ex: -24.12 or 36,75</td>
  63       </tr>
  64       <tr>
  65         <th>category</th>
  66         <td>a full category name (category, or category:subcategory)</td>
  67       </tr>
  68       <tr>
  69         <th>tags</th>
  70         <td>tags separated by space<br>
  71         tag is mandatory since v4.5</td>
  72       </tr>
  73     </table>
  74     <p>Example:</p>
  75     <pre class="csvexample">
  76 15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1 tag2
  77 15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2 my-tag3
  78 ...
  79 </pre>
  80     <p class="top"><a href="#top">↑ Back to Top</a></p>
  81   </div><!-- separator -->
  82   <div class="rounded content">
  83     <h2><a id="bud" name="bud"></a>Budget</h2>
  84     <table class="widgetinfo">
  85       <tr>
  86         <th>type</th>
  87         <td>* = monthly<br>
  88         <em>blank</em> = month value</td>
  89       </tr>
  90       <tr>
  91         <th>category</th>
  92         <td>the category name</td>
  93       </tr>
  94       <tr>
  95         <th>value(s)</th>
  96         <td>1 amount : if the type is monthly<br>
  97         12 amounts, separated by ';' : if type month value</td>
  98       </tr>
  99     </table>
 100     <p>Example:</p>
 101     <pre class="csvexample">
 102 *;Fuel;45.00
 103  ;Domestic animals;1.00;2.00;3.00;4.00;...
 104 *;Food;17.00
 105 ...
 106 </pre>
 107     <p class="top"><a href="#top">↑ Back to Top</a></p>
 108   </div><!-- separator -->
 109   <div class="rounded content">
 110     <h2><a id="cat" name="cat"></a>Category</h2>
 111     <table class="widgetinfo">
 112       <tr>
 113         <th>level</th>
 114         <td>1 = category<br>
 115         2 = subcategory</td>
 116       </tr>
 117       <tr>
 118         <th>type</th>
 119         <td>- = expense<br>
 120         + = income</td>
 121       </tr>
 122       <tr>
 123         <th>category name</th>
 124         <td>the category name</td>
 125       </tr>
 126     </table>
 127     <p>Example:</p>
 128     <pre class="csvexample">
 129 1;-;Food
 130 2; ;Grocer
 131 2; ;Restaurant
 132 1;+;Wage
 133 ...
 134 </pre>
 135     <p class="top"><a href="#top">↑ Back to Top</a></p>
 136   </div>
 137   <div class="rounded content">
 138     <h2><a id="pay" name="pay"></a>Payee</h2>
 139     <table class="widgetinfo">
 140       <tr>
 141         <th>payee name</th>
 142         <td>the name of the payee</td>
 143       </tr>
 144       <tr>
 145         <th>full category name</th>
 146         <td>optional: since 5.1.3<br>the full name of the category</td>
 147       </tr>
 148     </table>
 149     <p>Example:</p>
 150     <pre class="csvexample">
 151 payee_name1;cat1:subcat1
 152 payee_name2;
 153 ...
 154 </pre>
 155     <p class="top"><a href="#top">↑ Back to Top</a></p>
 156   </div><!-- separator -->
 157 </body>
 158 </html>