HomeBank

QIF import of check numbers and reconciled data

Asked by jsl4067

Greetings,
I am migrating to Homebank 4.0.4 from KMyMoney. When I import the QIF data into Homebank, check numbers and cleared/reconciled status do not seem to transfer. Here is a sample entry from the QIF I am importing:

D05.02.2008
CR
T-46.97
N133
PAT&T Mobility
LUtilities:Telephone
^
How do I get the Check number (133) to import into the "Info" column in Homebank, as well as, import the Validated/Reconciled (CR) status of each transaction?

Question information

Language:
English Edit question
Status:
Solved
For:
HomeBank Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Maxime DOYEN (mdoyen) said : 		#1

I have filled a bug, because I must check this.

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

oh, I forgot, can you list other values you have in line beginning by a 'C' ?

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

oh, I forgot, can you list other values you have in line beginning by a 'C' ?

Revision history for this message
jsl4067 (jsl4067) said : 		#4

I have been experimenting by manually editing the QIF file before I import it. Originally, I had "CX". I have also tried "CR" (as in the above example), and just "C". None of these seem to activate the "reconciled" check box when the QIF file is imported into Homebank.

Revision history for this message
jsl4067 (jsl4067) said : 		#5

Also, I have just discovered more information. If I create a new transaction in Homebank, and the mark it as "validated", and then "Export to QIF format" in Homebank; the resulting QIF file contains no information that would indicate that the transaction was "reconciled" or "validated".
It would appear that Homebank does not make use of the "C" field in QIF transaction data. In other words, it would seem that Homebank disregards the "C" (reconciled) field of the QIF data file when both importing and exporting the data.
My quess is that this may also be true of the "N" (Check Number) field.

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

I have fixed this for v4.1

Revision history for this message
jsl4067 (jsl4067) said : 		#7

Wow! that was fast. I look forward to v4.1. Thanks so much for all your time and work.