Importing CSV files

Derek Atkins warlord at MIT.EDU
Tue Jul 17 10:00:30 EDT 2012


Hi,

Richard Thomas <richdthomas at gmail.com> writes:

> Hi Derek,
>
> Thanks for getting back to me.
>
> Here's a sample of the QIF file that my bank provides, I've deleted all but
> the top transaction:
>
> !Type:Bank
> D13/07/2012
> PSTARBUCKS CARD REL CD ****
> T-10.00
> ^
>
> So, would I need to change the "T-10.00" to "C-10.00" and then add an "N" line
> for my "num" field?

No, and Yes.  Yes, add an N line to specify the Num field.  But you also
need to add a C line to specify the Cleared Flag.  Do NOT change the T
(total) line.

> Thanks,
>
> Richard.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list