X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fhomebank;a=blobdiff_plain;f=doc%2Fmisc-csvformat.html;fp=doc%2Fmisc-csvformat.html;h=3bbeda0eacd601396478b315a0254611d10af193;hp=83f7859cffd3ac09f29b673d4491f3084e99b55f;hb=996fa4ab9f6b836001f8ad0eecbfd3821687fea7;hpb=27f6e3b112df235c8e9afc9911b1f6bce208a001 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 @@ - - + - - + + CSV file format - + -
HomeBank User manual
-

CSV file format

- -

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.

-
-

Transaction

- - - +

Transaction

- - - - + - - - + - - - - - - - - - + - - - - + tag is mandatory since v4.5 -
dateformat should be DD-MM-YYformat must be DD-MM-YY
paymodepayment from 0=none to 10=FI fee
infoa string
payeea payee name
memoa string
amounta number with a '.' or ',' as decimal separator, ex: -24.12 or - 36,75a number with a '.' or ',' as decimal separator, ex: -24.12 or 36,75
categorya full category name (category, or category:subcategory)
tagstags separated by space
- 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
 ...
-

[top]

- -
- - - - - +

↑ Back to Top

+
-

Budget

- +

Budget

- - + - - - - - -
type* = monthly
blank = month value
categorythe 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
 ... 
 

-    
[top]

-
+    
↑ Back to Top
-
-

Category

- +

Category

- - + - - - - + - - - - + - - -
level1 = category
+ 		1 = category
2 = subcategory
type- = expense
+ 		- = expense
+ = income
category namethe category name
- +

Example:

 1;-;Food
@@ -188,31 +121,23 @@
 1;+;Wage
 ...
-

[top]

- +

↑ Back to Top

- -
-

Payee

- +
+

Payee

- - + -
payee namethe name of the payee
-

Example:

-
+    
 payee_name1
 payee_name2
 ... 
 

-    
[top]

-
+    
↑ Back to Top
- - + \ No newline at end of file