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 | the date format can be:
year can be 2 or 4 digits |
---|---|
payment |
![]() from 0=none to 10=FI fee (in the same order of the list) |
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 |
category | a full category name (category, or category:subcategory) |
tags | tags separated by space |
Starting
v5.2.5 : you can change the separator for transaction import into preferences.
v4.5 : tag column is mandatory
Example:
15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1 tag2 15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2 my-tag3 ...
The format exported has more columns which are:
date ; paymode ; info ; payee ; memo ; amount ; c ; category ; tags
c | is the status of the transaction: R = Reconciled C = Cleared |
---|
Starting
v5.4.3 : you can optionally export every split line
v5.4 : the c column was added to the export
Example:
15-02-04;0;;;Some cash;-40,00;R;Bill:Withdrawal of cash;tag1 tag2 15-02-04;1;;;Internet DSL;-45,00;C;Inline service/Internet;tag2 my-tag3 ...
level | 1 = category 2 = subcategory |
type | * = monthly blank = month value |
---|---|
category | if < 5.4 the category name if >= 5.4 the FULL category name |
value(s) | 1 amount : if the type is monthly 12 amounts, separated by ';' : if type month value |
Example:
1;*;Fuel;45.00 2; ;Domestic animals;1.00;2.00;3.00;4.00;... 1:*;Food;17.00 2:*;Phone:Bill;25.00 2:*;Water:Bill;50.00 ...
level | 1 = category 2 = subcategory |
---|---|
type | - = expense + = income |
category name | the category name |
Example:
1;-;Food 2; ;Grocer 2; ;Restaurant 1;+;Wage ...