credit card qif import
Michael DeBusk
michael at nlphilia.com
Wed Jun 4 19:12:35 EDT 2008
Quoting Charles Day <cedayiv at gmail.com>:
> One way to get "05-16-08 OUTBACK #xyz mytown NJ auth# 123456" into the
> register's Description field is to simply delete the "PPURCHASE" line.
If I were in his shoes, that would be less than satisfactory. I'd have
to add each payee by hand in gnucash. If I'm going to do that much, I
may as well not import the qif in the first place.
> It doesn't seem like "PURCHASE" is a useful piece of information to
> bring into
> GnuCash anyway.
True. Makes me wonder what (or if) the credit card company is thinking.
> Another option is to simply switch "P" and "M", giving you "P05-16-08
> OUTBACK #xyz mytown NJ auth# 123456" and "MPURCHASE". This would
> put the OUTBACK stuff in Description, and "PURCHASE" in Notes (which is
> viewable only in double-line mode).
I'd combine your two suggestions: Delete the payee line and convert
the memo line to a payee line. A decent text editor should be able to
do that, as should sed if the OP has it available.
I download my Citibank info in qif format when I have a little
downtime at work and open it in a text editor. I like to convert
uppercase to mixed case for readability, add an "L" (category/class)
line to each transaction, and delete the memo line (which always says
"MStandard Purch"). One of these days I may automate the process with
a script.
More information about the gnucash-user
mailing list