Dogcows Code - chaz/homebank/blob - doc/misc-csvformat.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>CSV file format</title>
   8   <link rel="stylesheet" href="help.css" type="text/css">
   9 </head>
  10
  11 <body id="top">
  12   <div class="dochead">
  13     HomeBank User manual
  14   </div>
  15
  16   <div class="title">
  17     <h1>CSV file format</h1>
  18
  19     <p>With HomeBank you can import/export some of the internal data's in
  20     the most common file format that is CSV.</p>
  21
  22     <p>Notice: meanwhile csv should uses comma as separator, HomeBank uses
  23     semi-colon as separator (this is most common than comma)</p>
  24
  25     <p>The format used for the different files is specific to HomeBank, so
  26     don't expect to import files your bank should offers you directly, you
  27     will need to arrange it a little in a spreadsheet like Gnumeric
  28     before.</p>
  29
  30     <p>Below is a description with example of the CSV format that HomeBank
  31     uses.</p><!-- separator -->
  32
  33     <ul class="toc">
  34       <li><a href="#txn">Transaction</a></li>
  35
  36       <li><a href="#bud">Budget</a></li>
  37
  38       <li><a href="#cat">Category</a></li>
  39
  40       <li><a href="#pay">Payee</a></li>
  41     </ul>
  42   </div>
  43
  44   <div class="rounded content">
  45     <h2><a name="txn" id="txn"></a>Transaction</h2>
  46
  47
  48
  49     <table class="widgetinfo">
  50
  51
  52       <tr>
  53         <th>date</th>
  54
  55         <td>format should be DD-MM-YY</td>
  56       </tr>
  57
  58       <tr>
  59         <th>paymode</th>
  60
  61         <td>from 0=none to 10=FI fee</td>
  62       </tr>
  63
  64       <tr>
  65         <th>info</th>
  66
  67         <td>a string</td>
  68       </tr>
  69
  70       <tr>
  71         <th>payee</th>
  72
  73         <td>a payee name</td>
  74       </tr>
  75
  76       <tr>
  77         <th>memo</th>
  78
  79         <td>a string</td>
  80       </tr>
  81
  82       <tr>
  83         <th>amount</th>
  84
  85         <td>a number with a '.' or ',' as decimal separator, ex: -24.12 or
  86         36,75</td>
  87       </tr>
  88
  89       <tr>
  90         <th>category</th>
  91
  92         <td>a full category name (category, or category:subcategory)</td>
  93       </tr>
  94
  95       <tr>
  96         <th>tags</th>
  97
  98         <td>tags separated by space<br>
  99                 tag is mandatory since v4.5</td>
 100       </tr>
 101
 102     </table>
 103
 104     <p>Example:</p>
 105     <pre class="csvexample">
 106 15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1
 107 15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2
 108 ...
 109 </pre>
 110     <p class="top"><a href="#top">[top]</a></p>
 111
 112   </div>
 113
 114   <!-- separator -->
 115
 116
 117
 118   <div class="rounded content">
 119     <h2><a name="bud" id="bud"></a>Budget</h2>
 120
 121     <table class="widgetinfo">
 122
 123        <tr>
 124         <th>type</th>
 125
 126         <td>* = monthly<br>
 127         <em>blank</em> = month value</td>
 128       </tr>
 129
 130       <tr>
 131         <th>category</th>
 132
 133         <td>the category name</td>
 134       </tr>
 135
 136       <tr>
 137         <th>value(s)</th>
 138
 139         <td>1 amount : if the type is monthly<br>
 140         12 amounts, separated by ';' : if type month value</td>
 141       </tr>
 142
 143     </table>
 144
 145     <p>Example:</p>
 146 <pre class="csvexample">
 147 *;Fuel;45.00
 148  ;Domestic animals;1.00;2.00;3.00;4.00;...
 149 *;Food;17.00
 150 ...
 151 </pre>
 152     <p class="top"><a href="#top">[top]</a></p>
 153
 154   </div><!-- separator -->
 155
 156   <div class="rounded content">
 157     <h2><a name="cat" id="cat"></a>Category</h2>
 158
 159     <table class="widgetinfo">
 160
 161        <tr>
 162         <th>level</th>
 163
 164         <td>1 = category <br>
 165         2 = subcategory</td>
 166       </tr>
 167
 168        <tr>
 169         <th>type</th>
 170
 171         <td>- = expense <br>
 172         + = income</td>
 173       </tr>
 174
 175        <tr>
 176         <th>category name</th>
 177
 178         <td>the category name</td>
 179       </tr>
 180
 181      </table>
 182
 183     <p>Example:</p>
 184     <pre class="csvexample">
 185 1;-;Food
 186 2; ;Grocer
 187 2; ;Restaurant
 188 1;+;Wage
 189 ...
 190 </pre>
 191     <p class="top"><a href="#top">[top]</a></p>
 192
 193   </div>
 194
 195     <div class="rounded content">
 196     <h2><a name="pay" id="pay"></a>Payee</h2>
 197
 198     <table class="widgetinfo">
 199
 200        <tr>
 201         <th>payee name</th>
 202
 203         <td>the name of the payee</td>
 204       </tr>
 205     </table>
 206
 207     <p>Example:</p>
 208 <pre class="csvexample">
 209 payee_name1
 210 payee_name2
 211 ...
 212 </pre>
 213     <p class="top"><a href="#top">[top]</a></p>
 214
 215   </div><!-- separator -->
 216
 217 </body>
 218 </html>