HomeBank

correct way to handle "internal transfers" when importing from CSV

Asked by sebastian-s

Hi all,

I was wondering how to import "internal transactions" correct by CSV?

I know I have to assign mode=5 but when I do that the account ends up having 2 transactions listed per imported transaction.
I have a "normal" account and a savings. there are many transactions from the normal account to the savings account.

When I input a internal transaction by hand I can select the account the transfer is going to. In my case I would need to select the account the transfer is coming from.

I have CSV from by bank for both accounts and thought I will import both, but when I understand it correct I should only import the account where the internal transactions where transfered from?

so for transfers from normal to savings I will import the normal transfer and HomeBank should make the entry in the savings account and vice versa. From what I know this does not work by now when importing

Maybe someone can shed some light onto this?

thanks very much, seb

PS:I have added the CSV struckture to the answer https://answers.launchpad.net/homebank/+question/7492

The answer https://answers.launchpad.net/homebank/+question/20332 explained the general mechanism for internal transactions to me

Question information

Language:
English Edit question
Status:
Solved
For:
HomeBank Edit question
Assignee:
No assignee Edit question
Solved by:
sebastian-s
Solved:
Last query:
Last reply:
Revision history for this message
sebastian-s (sebastian-s) said : 		#1

I have added the CSV struckture to the answer https://answers.launchpad.net/homebank/+question/7492

The answer https://answers.launchpad.net/homebank/+question/20332 explained the general mechanism for internal transactions to me

Revision history for this message
Maxime DOYEN (mdoyen) said : 		#2

Ok, the correct way is as follow.

The transaction import from a csv file is one file = one account.
So setting the mode to 5 has ... no effect. Thus that you cannot provide the destination account into the csv file, as you probably noticed no field is devoted to that.

This is something I really never tested, so maybe you can test importing the 2 csv file.
That mean I am not sure (in fact I am quite) that if you alter the source (normal), the destination (savings) will not be found by HB.
The reason is that when you import from csv, normal trans will not provide the target account and reciprocally.
So while you do not modify any of the twin transaction it will work fine that way, otherwie you will be forced to apply your manual change on both transactions.
But all still work fine in every case.

I hope this is clear, as it is a little complicated to understand with no source code under the eyes. If not let me know.

Max.

Revision history for this message
sebastian-s (sebastian-s) said : 		#3

Hi Max,

quote "So setting the mode to 5 has ... no effect"

It has a effect: you will end up with both transfer transactions in the same account making the sum of both nill. You can't edit the transaction as it is a internal one.

Am I correct that internal transactions don't appear in the stats? I say yes because that was the reason I wanted to import them as internal transfers.
I imported them as transfer and then I converted them all to internal transfers. I created new transactions using the inherit function and changed date and transfer mode. After that I deleted the normal transfer entry.

At least I am sure now that there is no way to import internal transfers correctly.

thanks seb