Re: [GNC] Closing out QB Pro?!
The same wikipedia article has a link to a QFX file viewer and converter to OFX format. The viewer/converter runs on Windows however it may be possible to run it under WINE on linux systemshttp://www.whiterocksoftware.com/2021/01/qfx-file-viewer-and-converters-to.html 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 > 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.
[GNC] journal report is missing balance totals
Hello, Gnu-cash 5.5 on a m1 Mac mini running Sonoma 14.6.1. I have lost my 2024 profit/loss information after quite a long time avoiding use of gnucash over the past year. It seems to be something stupid I did in getting the system running after about 11 months of neglect. My general journal report has debits and credits but no balance entries. As well, I can't get a proper year to date report for 2024 when I have good ones for 2021-2023. The general ledger file is fine. The only one off is the general journal report. Any advice? Thanks. Rick ___ 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.
Re: [GNC] 1099's
Fair enough. I just chuckled at the term. David T. On Nov 17, 2024, 10:22 AM, at 10:22 AM, Liz wrote: >On Sun, 17 Nov 2024 09:49:00 +0300 >sunfish62--- via gnucash-user wrote: > >> "Wiki-editing-team" !!! >> >> It's a wiki. We (and you) are the team. >> >> David T. > >I think I have write permissions on the wiki, but would rather stick to >my long term job as moderator, and assess all the spam directed to >Gnucash lists ;) >___ >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.
Re: [GNC] 1099's
Here is the IRS's blather about 1099 forms: https://www.irs.gov/businesses/small-businesses-self-employed/am-i-required-to-file-a-form-1099-or-other-information-return At Sat, 16 Nov 2024 09:31:28 -0500 (EST) Robert Heller wrote: > > At Sat, 16 Nov 2024 14:00:24 + "Maf. King" wrote: > > > > > On Saturday, 16 November 2024 13:20:59 GMT halatch1008 via gnucash-user > > wrote: > > > I still can Not find answer on how to select my Vendors to print a list of > > > my Vendors who I need to send 1099's to. > > > > > Thanks,Heidi LatchSent from my > > > Verizon, Samsung Galaxy smartphone > > > > > > > > Whats a 1099? is this something specific in the rules for the USA? > > Yes. It is a way for the IRS to track income > $999.99 that is not regular > wages (which are tracked with W2s). Eg as a contractor I would invoice a > client for jobs and if the invoices sum to $1,000.00 or more, the client would > file a 1099 with the IRS (basically stating that they paid me $x for contract > work) and send me a copy of the 1099. Also 1099's are used by banks when > paying intrest > $999.99, and also pension funds (1099r), Same for stocks and > bonds dividends/interest. A 1099 form is a form stating that money was paid as > reportable income to a taxpayer. > > > > > Maf. > > > > > > ___ > > 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. > > > > > > > > > -- Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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.
Re: [GNC] Closing out QB Pro?!
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. Please ... watch the distinction between "Quicken" and "QuickBooks". Although both by "Intuit", the issues doing from one of these to gnucash are not the same. Also, advising folks "use a text editor" (manual editing process) is OS dependent. Those using a 'nix OS should be aiming for a script (shell language program) to do the editing in-line. Any of the 'nix shell languages (we each have our favorite) plus the library of standard 'nix utilities constitutes a complete language (fundamental data type "string", and a powerful one at that*) Michael D Novack * and why today nobody uses the computer language SNOBOL (50'S-60'S). When I returned to IT (~1979) it was in the IBM mainframe environment (CPU's actually Crays). So the first shell language I learned was CLIST. At that time, I devised a little "case problem" to convince myself I understood. The problem: Prompt for entry of a string; determine if a palindrome by TEXT palindrome rules (arithmetic palindrome rules trivially easy); report answer and prompt for another string (or "goodby") My CLIST solution was more than a hundred lines. Following that, I used the same case problem with each new shell language or even regular computer language I was learning. To give you a sense of the power of a 'nix shell + library, my solution using bash + library was the order of a hundred CHARACTERS (on five lines for clarity) ___ 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.
Re: [GNC] Closing out QB Pro?!
I misused Quicken; clearly I intended to say Intuit. As in, there is still no documentation about Intuit's qbx format, while its other formats (qfx, etc.) are well documented. I'm reasonably certain that I made no mention of text editors. In fact, I'm reasonably sure I suggested that OP cut over to GnuCash without attempting to get their data migrated. What part of my message led you to believe that I was suggesting they use a text editor? David T. On Nov 17, 2024, 6:03 PM, at 6:03 PM, Michael or Penny Novack via gnucash-user wrote: > >> >> 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. > >Please ... watch the distinction between "Quicken" and "QuickBooks". >Although both by "Intuit", the issues doing from one of these to >gnucash >are not the same. > >Also, advising folks "use a text editor" (manual editing process) is OS > >dependent. Those using a 'nix OS should be aiming for a script (shell >language program) to do the editing in-line. Any of the 'nix shell >languages (we each have our favorite) plus the library of standard 'nix > >utilities constitutes a complete language (fundamental data type >"string", and a powerful one at that*) > >Michael D Novack > >* and why today nobody uses the computer language SNOBOL (50'S-60'S). >When I returned to IT (~1979) it was in the IBM mainframe environment >(CPU's actually Crays). So the first shell language I learned was >CLIST. >At that time, I devised a little "case problem" to convince myself I >understood. The problem: > > Prompt for entry of a string; determine if a palindrome by TEXT >palindrome rules (arithmetic palindrome rules trivially easy); report >answer and prompt for another string (or "goodby") > >My CLIST solution was more than a hundred lines. Following that, I used > >the same case problem with each new shell language or even regular >computer language I was learning. To give you a sense of the power of a > >'nix shell + library, my solution using bash + library was the order of > >a hundred CHARACTERS (on five lines for clarity) > >___ >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.
Re: [GNC] Closing out QB Pro?!
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 > 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.
Re: [GNC] Closing out QB Pro?!
David, QFX != QBX -derek Sent using my mobile device. Please excuse any typos. On November 17, 2024 15:03:26 David Cousens 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, 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 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. ___ 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
