qif file
Derek Atkins
warlord at MIT.EDU
Thu Oct 30 10:09:22 EDT 2014
(forwarding back to the list).
Glad you figured it out!
-derek
Simon Bond <shug0131 at gmail.com> writes:
> Thanks for your thoughts. I did check and found a dubious date of 0/0/0000 for
> a transaction saying that zero interest was charged. Deleting that transaction
> sorted out the problem
>
> Simon
>
> On Sat, Oct 25, 2014 at 6:04 PM, Derek Atkins <derek at ihtfp.com> wrote:
>
> Hi,
>
> On Sat, October 25, 2014 12:55 pm, Simon Bond wrote:
> > Hi
> >
> > I'm trying to import a qif file I downloaded into gnucash. It says
> there's
> > an error with the date format, but when I look at it with a basic text
> > editor, no apparent problem. There does appear to be extra lines
> starting
> > with "M". Is this the real problem ? I've copied in a few lines from
> the
> > head of the file.
>
> What is the exact error you get?
>
> You should look through the WHOLE file and check every line that begins
> with a "D". Most likely you have one in there that is bogus.
>
> How was this QIF created?
>
> -derek
>
> PS: There is nothing wrong with the few transactions you copied here.
>
> > Thanks Simon
> >
> > !Type:CCard
> > D14/08/2014
> > T-3612.10
> > PINITIAL BALANCE
> > M
> > ^
> > D14/08/2014
> > T0.77
> > PBONUS CASHBACK
> > M
> > ^
> > D14/08/2014
> > T3.82
> > P1PC CASHBACK
> > M
> > ^
> > D14/08/2014
> > T0.16
> > P2PC CASHBACK
> > M
> > ^
> > D14/08/2014
> > T9.00
> > P3PC CASHBACK
> > M
> > ^
> > D13/08/2014
> > T-39.95
> > PPURCHASE - DOMESTIC, CAMBRIDGE, S150-BLACKWELLS
> > M** 8411
> > ^
> > D13/08/2014
> > T-4.40
> > PPURCHASE - DOMESTIC, 7600, GREATER ANGLIA
> > M** 8411
> > ^
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
> --
> Derek Atkins 617-623-3745
> derek at ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>
--
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