[GNC] Closing out QB Pro?!
David Cousens
davidcousens49 at gmail.com
Sun Nov 17 15:48:02 EST 2024
Thnks Derek
My bad
David
On Sun, 2024-11-17 at 15:14 -0500, Derek Atkins wrote:
>
>
>
> David,
>
> QFX != QBX
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
>
>
> On November 17, 2024 15:03:26 David Cousens
> <davidcousens49 at gmail.com> wrote:
>
> > David,
> >
> > There is a wikipedia entry on the QFX file format which states that
> > it
> > is a standard OFX file with the inclusion of additional fields to
> > support a licensing fee paid by institutions to Intuit. It means
> > that
> > Quicken software will only import data where the providing
> > institution
> > has paid a fee to Intuit. see
> > (
> > https://en.wikipedia.org/wiki/QFX_(file_format)#:~:text=QFX%20is%20I
> > ntuit's%20proprietary,financial%20information%20over%20the%20intern
> > et.&text=A%20QFX%20file%20is%20a,with%20a%203%20year%20expiration
> > .)
> >
> > If that is the case, it may be possible to edit the file to remove
> > the
> > fields involved to make into a standard OFX file. My guess is that
> > these fields will be in the OFX header
> >
> > To be able to check this out would require some one to generate and
> > supply a dummy file with a few typical dummay entries to work out
> > if
> > this is feasible or not and to design a script/program to do the
> > conversion. It may even be possible to get the developers of libofx
> > to
> > simply skip over such fields in QFX files if they have not already
> > incorporated this.
> >
> > David Cousens
> >
> >
> > On Sun, 2024-11-17 at 10:16 +0300, sunfish62 at yahoo.com wrote:
> > > This comes up with regularity on the lists as people look to
> > > abandon
> > > QuickBooks and come to GnuCash.
> > >
> > > There is an entry in the FAQ on the wiki
> > > (
> > > https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_
> > > Qu
> > > ickbooks.28TM.29.3F) that explains that QB uses a proprietary
> > > format
> > > that no one has put in time to decipher, rendering it non trivial
> > > for
> > > a user to migrate. I'm reasonably sure that this information is
> > > still
> > > accurate, with regards to GnuCash capabilities in late 2024.
> > >
> > > I will also note that while there is information online about
> > > Quicken's *other* formats, there is nothing about how a QBX file
> > > is
> > > structured. This suggests that OP will not find any help with
> > > converting into a GnuCash friendly format.
> > >
> > > Further, previous discussions on this topic (Google search:
> > > "quickbooks site:lists.gnucash.org") have revealed that QB
> > > doesn't
> > > offer its users the kind of export that GnuCash advisors here
> > > suggest
> > > (QIF, QFX, and OFX are the usual list recs).
> > >
> > > The past threads that I scanned in the archives came to the same
> > > conclusion: close out your QB books, change over to GnuCash as of
> > > a
> > > certain date, and start fresh. Optional: continue using QB for a
> > > period of time, either in parallel, or for reference.
> > >
> > > David T.
> > > On Nov 17, 2024, at 4:29 AM, David Cousens
> > > <davidcousens49 at gmail.com>
> > > wrote:
> > > > John,
> > > >
> > > > I would try importing the .qbx export file as an OFX file if
> > > > you
> > > > can
> > > > open it with a text editor. There is a good chance that it is
> > > > just
> > > > a
> > > > proprietary version of the OFX standard format since it is
> > > > intended
> > > > for
> > > > export of Quickbooks data to accountants who may or may not be
> > > > using
> > > > Quickbooks and Quickbooks has given it a non-standard extension
> > > > to
> > > > confuse everyone. You can find details of the OFX file format
> > > > at
> > > > https://docs.fileformat.com/finance/ofx/
> > > > ,
> > > > https://www.financialdataexchange.org/FDX/FDX/About/OFX-Work-Group
> > > > .
> > > > aspx?a315d1c24e44=2
> > > > to compare the .qbx file with to check whether it is in an OFX
> > > > format.
> > > >
> > > > David Cousens
> > > >
> > > > On Fri, 2024-11-15 at 23:04 -0500, john at aronetics.com wrote:
> > > > > Hey y'all,
> > > > >
> > > > > Thank you for building GNUCash.
> > > > >
> > > > > From Quickbooks to GNUCash, what is the file transfer setup
> > > > > from
> > > > > one
> > > > > to the
> > > > > other?
> > > > > Is GNUCash stable in 2024+? I don't intend to step on any
> > > > > foots,
> > > > > I've
> > > > > been
> > > > > with Linux since late 1994.
> > > > >
> > > > > Is it better on hardware or a VM, does anyone build it on a
> > > > > docker
> > > > > container
> > > > > with its own database?
> > > > >
> > > > > Thank you everyone,
> > > > >
> > > > > Best,
> > > > > John
> > > > >
> > > > > 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
> > > > > -----
> > > > > 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
> > > > -----
> > > > 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
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
More information about the gnucash-user
mailing list