X-Git-Url: https://git.brokenzipper.com/gitweb?a=blobdiff_plain;ds=sidebyside;f=doc%2Fmisc-csvformat.html;h=3bbeda0eacd601396478b315a0254611d10af193;hb=996fa4ab9f6b836001f8ad0eecbfd3821687fea7;hp=83f7859cffd3ac09f29b673d4491f3084e99b55f;hpb=27f6e3b112df235c8e9afc9911b1f6bce208a001;p=chaz%2Fhomebank diff --git a/doc/misc-csvformat.html b/doc/misc-csvformat.html index 83f7859..3bbeda0 100644 --- a/doc/misc-csvformat.html +++ b/doc/misc-csvformat.html @@ -1,185 +1,118 @@ - - +
- - + +With HomeBank you can import/export some of the internal data's in - the most common file format that is CSV.
- -Notice: meanwhile csv should uses comma as separator, HomeBank uses - semi-colon as separator (this is most common than comma)
- -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.
- -Below is a description with example of the CSV format that HomeBank - uses.
- +With HomeBank you can import/export some of the internal data's in the most common file format that is CSV.
+Notice: meanwhile CSV should uses comma as separator, HomeBank uses semi-colon as separator (this is most common than comma)
+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.
+Below is a description with example of the CSV format that HomeBank uses.
date | - -format should be DD-MM-YY | +format must be DD-MM-YY |
---|---|---|
paymode | - +payment | from 0=none to 10=FI fee |
info | -a string | |
payee | -a payee name | |
memo | -a string | |
amount | - -a number with a '.' or ',' as decimal separator, ex: -24.12 or - 36,75 | +a number with a '.' or ',' as decimal separator, ex: -24.12 or 36,75 |
category | -a full category name (category, or category:subcategory) | |
tags | -tags separated by space - tag is mandatory since v4.5 |
+ tag is mandatory since v4.5
Example:
15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1 15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2 ...- - -
type | -* = monthly blank = month value |
---|---|
category | -the category name |
value(s) | -1 amount : if the type is monthly 12 amounts, separated by ';' : if type month value |
Example:
-+*;Fuel;45.00 ;Domestic animals;1.00;2.00;3.00;4.00;... *;Food;17.00 ...- - +
level | - -1 = category + | 1 = category 2 = subcategory |
---|---|---|
type | - -- = expense + | - = expense + = income |
category name | -the category name |
Example:
1;-;Food @@ -188,31 +121,23 @@ 1;+;Wage ...- - +