[GNC] Closing out QB Pro?!

[Derek Atkins]

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%20Intuit's%20proprietary,financial%20information%20over%20the%20internet.&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.