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     <table class="widgetinfo">
  29       <tr>
  30         <th>date</th>
  31         <td>format must be DD-MM-YY</td>
  32       </tr>
  33       <tr>
  34         <th>payment</th>
  35         <td>from 0=none to 10=FI fee</td>
  36       </tr>
  37       <tr>
  38         <th>info</th>
  39         <td>a string</td>
  40       </tr>
  41       <tr>
  42         <th>payee</th>
  43         <td>a payee name</td>
  44       </tr>
  45       <tr>
  46         <th>memo</th>
  47         <td>a string</td>
  48       </tr>
  49       <tr>
  50         <th>amount</th>
  51         <td>a number with a '.' or ',' as decimal separator, ex: -24.12 or 36,75</td>
  52       </tr>
  53       <tr>
  54         <th>category</th>
  55         <td>a full category name (category, or category:subcategory)</td>
  56       </tr>
  57       <tr>
  58         <th>tags</th>
  59         <td>tags separated by space<br>
  60         tag is mandatory since v4.5</td>
  61       </tr>
  62     </table>
  63     <p>Example:</p>
  64     <pre class="csvexample">
  65 15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1
  66 15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2
  67 ...
  68 </pre>
  69     <p class="top"><a href="#top">↑ Back to Top</a></p>
  70   </div><!-- separator -->
  71   <div class="rounded content">
  72     <h2><a id="bud" name="bud"></a>Budget</h2>
  73     <table class="widgetinfo">
  74       <tr>
  75         <th>type</th>
  76         <td>* = monthly<br>
  77         <em>blank</em> = month value</td>
  78       </tr>
  79       <tr>
  80         <th>category</th>
  81         <td>the category name</td>
  82       </tr>
  83       <tr>
  84         <th>value(s)</th>
  85         <td>1 amount : if the type is monthly<br>
  86         12 amounts, separated by ';' : if type month value</td>
  87       </tr>
  88     </table>
  89     <p>Example:</p>
  90     <pre class="csvexample">
  91 *;Fuel;45.00
  92  ;Domestic animals;1.00;2.00;3.00;4.00;...
  93 *;Food;17.00
  94 ...
  95 </pre>
  96     <p class="top"><a href="#top">↑ Back to Top</a></p>
  97   </div><!-- separator -->
  98   <div class="rounded content">
  99     <h2><a id="cat" name="cat"></a>Category</h2>
 100     <table class="widgetinfo">
 101       <tr>
 102         <th>level</th>
 103         <td>1 = category<br>
 104         2 = subcategory</td>
 105       </tr>
 106       <tr>
 107         <th>type</th>
 108         <td>- = expense<br>
 109         + = income</td>
 110       </tr>
 111       <tr>
 112         <th>category name</th>
 113         <td>the category name</td>
 114       </tr>
 115     </table>
 116     <p>Example:</p>
 117     <pre class="csvexample">
 118 1;-;Food
 119 2; ;Grocer
 120 2; ;Restaurant
 121 1;+;Wage
 122 ...
 123 </pre>
 124     <p class="top"><a href="#top">↑ Back to Top</a></p>
 125   </div>
 126   <div class="rounded content">
 127     <h2><a id="pay" name="pay"></a>Payee</h2>
 128     <table class="widgetinfo">
 129       <tr>
 130         <th>payee name</th>
 131         <td>the name of the payee</td>
 132       </tr>
 133       <tr>
 134         <th>full category name</th>
 135         <td>optional: since 5.1.3<br>the full name of the category</td>
 136       </tr>
 137     </table>
 138     <p>Example:</p>
 139     <pre class="csvexample">
 140 payee_name1;cat1:subcat1
 141 payee_name2;
 142 ...
 143 </pre>
 144     <p class="top"><a href="#top">↑ Back to Top</a></p>
 145   </div><!-- separator -->
 146 </body>
 147 </html>