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, sunfis...@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 <davidcousen...@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, j...@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@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@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@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.
