credit card qif import

Charles Day cedayiv at gmail.com
Wed Jun 4 20:52:49 EDT 2008


On Wed, Jun 4, 2008 at 4:12 PM, Michael DeBusk <michael at nlphilia.com> wrote:

> 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.
>

I probably should have explained, because this is not really advertised: If
there is no "P" line at all, then the QIF importer puts the "M" line content
into the "Description" field. The Notes will be empty. I assume that's what
he's aiming for.


> > 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.
>

Just deleting the "P" line alone should do the same thing (see above).

-Charles


> 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