Importing CSV files

Richard Thomas richdthomas at gmail.com
Fri Jul 13 18:09:06 EDT 2012


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?

Thanks,

Richard.




On 13 July 2012 22:16, Derek Atkins <derek at ihtfp.com> wrote:

> Hi,
>
> On Fri, July 13, 2012 4:34 pm, Richard Thomas wrote:
> >>> My bank gives the option of CSV or QIF file formats.
> >>>
> >>> I had tried the QIF file format and the GNUCash GUI had lots of
> >>> clicks and selections to do the importing I need.
> >>
> >>However, it remembers those settings, so you import all the stuff
> >>slowly once and then speedily afterwards.
> >
> > Hi,
> >
> > I gave the QIF format import a go and had a few hickups.
> >
> >
> > The imported transactions appeard in GNUCash as "n" and not "c"
> >
> > Is there a way to make GNUCash import the transactions as cleared?
>
> Is the QIF Txn marked as cleared in the QIF?  "C"
>
> >
> > Also, my bank does not populate the  Transaction Type field, which I want
> > to appear in GNUCash as "num"
> >
> > Does the QIF format support a field that GNUCash would import into the
> > "num" field.
>
> Yes, of course it does.  "N"
>
> >
> >
> > Thanks,
> >
> > Richard.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        Derek Atkins                 617-623-3745
>        derek at ihtfp.com             www.ihtfp.com
>        Computer and Internet Security Consultant
>
>


More information about the gnucash-user mailing list