1 <!DOCTYPE html PUBLIC
"-//W3C//DTD HTML 4.01//EN">
5 <meta http-equiv=
"CONTENT-TYPE" content=
"text/html; charset=utf-8">
7 <title>CSV file format
</title>
8 <link rel=
"stylesheet" href=
"help.css" type=
"text/css">
17 <h1>CSV file format
</h1>
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>
22 <p>Notice: meanwhile csv should uses comma as separator, HomeBank uses
23 semi-colon as separator (this is most common than comma)
</p>
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
30 <p>Below is a description with example of the CSV format that HomeBank
31 uses.
</p><!-- separator -->
34 <li><a href=
"#txn">Transaction
</a></li>
36 <li><a href=
"#bud">Budget
</a></li>
38 <li><a href=
"#cat">Category
</a></li>
40 <li><a href=
"#pay">Payee
</a></li>
44 <div class=
"rounded content">
45 <h2><a name=
"txn" id=
"txn"></a>Transaction
</h2>
49 <table class=
"widgetinfo">
55 <td>format should be DD-MM-YY
</td>
61 <td>from
0=none to
10=FI fee
</td>
85 <td>a number with a '.' or ',' as decimal separator, ex: -
24.12 or
92 <td>a full category name (category, or category:subcategory)
</td>
98 <td>tags separated by space
<br>
99 tag is mandatory since v4.5
</td>
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
110 <p class=
"top"><a href=
"#top">[top]
</a></p>
118 <div class=
"rounded content">
119 <h2><a name=
"bud" id=
"bud"></a>Budget
</h2>
121 <table class=
"widgetinfo">
127 <em>blank
</em> = month value
</td>
133 <td>the category name
</td>
139 <td>1 amount : if the type is monthly
<br>
140 12 amounts, separated by ';' : if type month value
</td>
146 <pre class=
"csvexample">
148 ;Domestic animals;
1.00;
2.00;
3.00;
4.00;...
152 <p class=
"top"><a href=
"#top">[top]
</a></p>
154 </div><!-- separator -->
156 <div class=
"rounded content">
157 <h2><a name=
"cat" id=
"cat"></a>Category
</h2>
159 <table class=
"widgetinfo">
164 <td>1 = category
<br>
176 <th>category name
</th>
178 <td>the category name
</td>
184 <pre class=
"csvexample">
191 <p class=
"top"><a href=
"#top">[top]
</a></p>
195 <div class=
"rounded content">
196 <h2><a name=
"pay" id=
"pay"></a>Payee
</h2>
198 <table class=
"widgetinfo">
203 <td>the name of the payee
</td>
208 <pre class=
"csvexample">
213 <p class=
"top"><a href=
"#top">[top]
</a></p>
215 </div><!-- separator -->