Details column is empty - Auto assignment does not work

Asked by Matt Richardson

When I import the .QIF file from my bank there is no data in the Description column. I don't know if this is my banks fault or the way HomeBank imports the file, but because the auto assignment functionality only searches this description field and then assigns the given payee or category, I am unable to auto-assign the categories. So I want to know if it is possible to assign a category based on a payee? i.e search the payee field (rather than the Description field) and assign a category based on it.

Question information

Language:
English Edit question
Status:
Answered
For:
HomeBank Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Ton (profiler1234) said :
#1

Standard QIF format contains [P]Payee field, which by default combines Payee and Description information.
Some banks use this and ignore separate description field.
But Homebank only links [M]Memo field directly to Description.

To overcome this there are 3 ways as far as I can see:
1_ if possible, change at Bank-export side, QIF-settings for separate Payee and Description info
      into [P]Payee and [M]Memo
2_ or, edit QIF-file, copy every [P]Payee info to added [M]Memo field
3_ or, if available other bank-export file type e.g. OFX.

Homebank can only auto-assign with description-field as source.

Revision history for this message
nick ramsdale (nickrammcfc) said :
#2

Exactly same problem here. I'm importing QIF file from Commonwealth Bank of Australia. Any ideas?

Revision history for this message
Alex (perrinal) said :
#3

Hi,
you can write a little perl script that will take all your qif file and copy the P field in a new M field.

Here is the code

#!/usr/bin/perl
# copy the Payee field and add a Memo Field.

@files=glob("*.qif");

foreach $qif (@files)
{
open(FILE, $qif) || die "failed opening $qif\n";

while (<FILE>)
{
  chomp;
  print "$_\n";
 if ($_ =~ /P(.*)/)
 {
  print "M".$1."\n";
 }
}
close (FILE);
}

If more details needed i can add some.

Revision history for this message
Vadim Peretokin (vperetokin) said :
#4

The ofx from Commonwealth Bank of Australia puts the descriptions into the 'Info' field, not the 'Memo' field. HomeBank should give you the ability to search either fields for classification...

Revision history for this message
Vadim Peretokin (vperetokin) said :
#5

Actually looking at the ofx file, it does say: <MEMO>description here. It is HomeBank that incorrectly categorizes the field and then does not let you search it.

Can you help with this problem?

Provide an answer of your own, or ask Matt Richardson for more information if necessary.

To post a message you must log in.