[GNC] QFX vs OXR/QXF

David Carlson david.carlson.417 at gmail.com
Thu May 16 07:44:29 EDT 2019


To David T's comment I would add that QIF format is best broken down before
the export rather than after, as there are a few headers at the beginning
that help to define which accounts are included in each file.  It is best
to let Quicken build the smaller files.

David Carlson

On Thu, May 16, 2019 at 4:18 AM David T. via gnucash-user <
gnucash-user at gnucash.org> wrote:

> The most common issue that crops up with importing QIF data seems to be
> date formatting, such as a date that is in dd-mm-yyyy format (when the rest
> of the file is mm-dd-yyyy format).
>
> Unfortunately, there really isn't any easy way to locate such errors,
> short of scanning through the source file for the errors (remember that QIF
> is a text file). Some have had success by breaking the file into pieces to
> narrow down the error.
>
> David
>
>
>
>   On Thu, May 16, 2019 at 14:15, Richard<rpink01 at gmail.com> wrote:
>  Thanks so much for the assistance, Derek. If I understand correctly, my
> Quicken 2016 exports to a proprietary file format - QXF.  GnuCash
> imports the more open/robust file format - QFX. These formats are not
> compatible. However, my bank does download to QFX so that should work
> with GnuCash. (I misspoke in my original statement saying that my
> Quicken exports to QFX - this stuff gets a bit confusing)
>
> The trick now is to get my historical data from Quicken into GnuCash
> since my Quicken export QXF can not be imported by GnuCash QFX format.
>
> I've exported from Quicken using the QIF format and that appears to work
> fine. However, when I try to import the QIF file into GnuCash, all seems
> to go fine through the first 14 steps but at step 15 (QIF Import -
> Start), it ends with the message "failed". At step 19 - QIF Import
> Summary, I get the message "There was a problem with the import" No
> additional information follows. See below.
>
> Any ideas?
>
> Thanks,
>
> Richard
>
>
> On 5/15/2019 9:27 AM, Derek Atkins wrote:
> > Hi,
> >
> > Richard <rpink01 at gmail.com> writes:
> >
> >> Both my Quicken 2016 and my bank institutions export to QFX files. But
> >> GnuCash only offers import from OXF/QXF files. Is this a GnuCssh typo
> >> or bug, i.e., misplacement of the "X" in the file extension?
> > It is not a typo.  There is a difference between
> > OFX/QFX and QXF.
> >
> > OFX/QFX is the Open Financial eXchange (and a quicken variant).  GnuCash
> > can import this.
> >
> > However, QXF is the Quicken eXchange Format, which is their new,
> > proprietary storage format.  GnuCash cannot import QXF.
> >
> > Are you sure your bank is exporting QFX and not QXF?  Also, could you
> > get quicken to export QIF?
> >
> > Hope this helps,
> >
> >> 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
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson


More information about the gnucash-user mailing list