Re: [GNC] CSV matching produces duplicates?
In my experience, my bank uses the word 'check' to describe every check that clears my bank account and my credit card company describes every purchase at Amazon as 'Amazon'. I could continue, but I certainly do not want all transactions with those descriptions transferring to the same respective accounts. I think very few users of GnuCash would want that. The GnuCash import wizards have been working for many years with Bayesian matching giving varying results attempting to automatically match imported transactions with existing transactions and to assign transfer accounts to unmatched transactions. The imported transactions often have intentionally vague descriptions describing, at best, the method of payment rather than the purpose of the payment. That fact makes the Bayesian matching extremely difficult to accomplish accurately but with sufficient training it eventually starts to work reasonably well. If you really want Gnucash to transfer every 'check' to the same transfer account, you can use Bayesian matching to train it eventually to do that in most cases. With the new Import Map editor you can improve the training to work even more to your liking. I think that would be adequate for most users. On Fri, Mar 26, 2021 at 9:31 PM David Cousens wrote: > > For the transfer account, the second account in a transaction being > imported, GnuCash does in fact work that way, i.e. it imports all > transactions in which the transfer account has not been specified to an > Imbalance account for the currency of the primary account in the > transaction. The presence of transactions in the Imbalance accounts is > intended to trigger users that the transaction description is incomplete > and > that the correct account should be selected to replace the Imbalance > account > for the transaction. In the majority of cases the transfer account is > going > to be an Income or Expense account. Where a transfer account is specified > though, the label has to have been previously mapped onto an internal > account or a new internal account created and specified for it to be > imported. The transaction record to be imported must specify a primary > account label which is usually an asset or liability account and that label > has to be mapped to an internal asset/liability account otherwise it does > not know where to import it to. > > You could have an option whereby if a matching account label does not exist > for the primary account for a transaction, GnuCash creates an account with > the name. In the majority of cases for imported transactions, the primary > account is going to be an asset or liability account. However, account > structures in accounting have a structure which reflects how the business > (even where it is simply personal accounting) operates and is financed and > the asset and liability account structures are fairly strictly defined by > the assets and liabilities you actually have. I would not want to have > myaccounting program randomly creating new accounts in these categories > every time it came across a label which had not been assigned to an > existing > internal account and I suspect that after experiencing it you may not > either. > > A first time user new to accounting is always going to have trouble working > out what goes where and why which is why the GnuCash guide has a very > brief > introduction to accounting basics but nothing really replaces making > mistakes. Unfortunately most of us don't consult the documentation until > we > strike a problem, me included. The beauty of GnuCash is that if you do > stuff > it up you can at least correct it once your knowledge has built up. > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@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 ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] CSV matching produces duplicates?
For the transfer account, the second account in a transaction being imported, GnuCash does in fact work that way, i.e. it imports all transactions in which the transfer account has not been specified to an Imbalance account for the currency of the primary account in the transaction. The presence of transactions in the Imbalance accounts is intended to trigger users that the transaction description is incomplete and that the correct account should be selected to replace the Imbalance account for the transaction. In the majority of cases the transfer account is going to be an Income or Expense account. Where a transfer account is specified though, the label has to have been previously mapped onto an internal account or a new internal account created and specified for it to be imported. The transaction record to be imported must specify a primary account label which is usually an asset or liability account and that label has to be mapped to an internal asset/liability account otherwise it does not know where to import it to. You could have an option whereby if a matching account label does not exist for the primary account for a transaction, GnuCash creates an account with the name. In the majority of cases for imported transactions, the primary account is going to be an asset or liability account. However, account structures in accounting have a structure which reflects how the business (even where it is simply personal accounting) operates and is financed and the asset and liability account structures are fairly strictly defined by the assets and liabilities you actually have. I would not want to have myaccounting program randomly creating new accounts in these categories every time it came across a label which had not been assigned to an existing internal account and I suspect that after experiencing it you may not either. A first time user new to accounting is always going to have trouble working out what goes where and why which is why the GnuCash guide has a very brief introduction to accounting basics but nothing really replaces making mistakes. Unfortunately most of us don't consult the documentation until we strike a problem, me included. The beauty of GnuCash is that if you do stuff it up you can at least correct it once your knowledge has built up. - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] CSV matching produces duplicates?
David, your response doesn't change: > For csv transactions GnuCash pretty well prompts with the correct account > each time, so [provide a setting] to accept all prompts. 1) From my experience it's unreasonable to assume user can assign accounts when they don't understand the transactions. So, it IS easier to fix later. 2) Worst case, matcher wouldn't work which isn't an issue if it's not being used to assign accounts. Elsewhere there's a suggestion to allow matcher to be retrained on current data meaning it would work, and better. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Report Printing
I save as html and then print with Word. With you date problem there is somewhere in settings to change year start and end, I can't check it for you at the moment as I am in Hospital. On 26 Mar 2021 19:09, Jack Frillman via gnucash-user wrote: I use GNUCash on Mac OSX 10.14 and I print by saving to a PDF file and then send the PDF to the printer. On 3/26/21 3:05 PM, Tommy Trussell wrote: > On Fri, Mar 26, 2021 at 1:23 PM ZPBear wrote: > >> Hello,My wife Jennifer has been using GnuCash for several years.Printing >> reports has never worked.I installed 4.4 today and still no good.The title >> shows 2020 (for the current tax year).When I choose Report / Account >> Summary the report opens with zero values and a 2019 title.Please explain >> why this is happening. > > I never use that report myself, but I just opened it on this computer and > it looks like the default is for it to show transactions to the date you > have defined for the accounting period. I don't know why it would have 2019 > as any sort of option, but you CAN use the report options to change the > date (look for Options on the toolbar, or Edit --> Report Options). > > You also said "Printing reports has never worked" and that's a separate > issue. I don't know the current state of Windows versions of GnuCash, but > it could be that you will need to copy the report elsewhere, or print a PDF > version of the report first and print from there. On linux, whenever I go > to print I get to choose Print to File or Print to LPR (for the Flatpak > version of GnuCash). I don't think the LPR printer definition works, but I > haven't tried; since switching to Flatpak I always print to PDF first. > > Please let us know (by copying the list) whether any of these comments are > helpful. > > >> - >> 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://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fl ists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C0 1%7C%7Ceff836d11cc14836d9c008d8f08ad267%7C84df9e7fe9f640afb435aa aa%7C1%7C0%7C637523826312278926%7CUnknown%7CTWFpbGZsb3d8eyJWIjoi MC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000 p;sdata=NZ1KlpPYclFwa4ewjvMwY5FMp%2FJ4gpl0RaaDjV57dno%3Dreserve d=0 > If you are using Nabble or Gmane, please see https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fw iki.gnucash.org%2Fwiki%2FMailing_Listsdata=04%7C01%7C%7Ceff836d 11cc14836d9c008d8f08ad267%7C84df9e7fe9f640afb435%7C1%7C0 %7C637523826312288917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLC JQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=Ce4P7R X%2FVhkHTvHp4seSRVLZGj4fs3aHMcHcsnhxVfo%3Dreserved=0 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. -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fl ists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=04%7C0 1%7C%7Ceff836d11cc14836d9c008d8f08ad267%7C84df9e7fe9f640afb435aa aa%7C1%7C0%7C637523826312288917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoi MC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000 p;sdata=bvGTnIhigD7g%2BJk4e2JOnAm6EGRCgMGSDaNCXUV%2BFpI%3Dreser ved=0 If you are using Nabble or Gmane, please see https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fw iki.gnucash.org%2Fwiki%2FMailing_Listsdata=04%7C01%7C%7Ceff836d 11cc14836d9c008d8f08ad267%7C84df9e7fe9f640afb435%7C1%7C0 %7C637523826312288917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLC JQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000sdata=Ce4P7R X%2FVhkHTvHp4seSRVLZGj4fs3aHMcHcsnhxVfo%3Dreserved=0 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are
Re: [GNC] Report Printing
I use GNUCash on Mac OSX 10.14 and I print by saving to a PDF file and then send the PDF to the printer. On 3/26/21 3:05 PM, Tommy Trussell wrote: On Fri, Mar 26, 2021 at 1:23 PM ZPBear wrote: Hello,My wife Jennifer has been using GnuCash for several years.Printing reports has never worked.I installed 4.4 today and still no good.The title shows 2020 (for the current tax year).When I choose Report / Account Summary the report opens with zero values and a 2019 title.Please explain why this is happening. I never use that report myself, but I just opened it on this computer and it looks like the default is for it to show transactions to the date you have defined for the accounting period. I don't know why it would have 2019 as any sort of option, but you CAN use the report options to change the date (look for Options on the toolbar, or Edit --> Report Options). You also said "Printing reports has never worked" and that's a separate issue. I don't know the current state of Windows versions of GnuCash, but it could be that you will need to copy the report elsewhere, or print a PDF version of the report first and print from there. On linux, whenever I go to print I get to choose Print to File or Print to LPR (for the Flatpak version of GnuCash). I don't think the LPR printer definition works, but I haven't tried; since switching to Flatpak I always print to PDF first. Please let us know (by copying the list) whether any of these comments are helpful. - 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 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. -- Old Unix programmers never die, they just mv to /dev/null - Anonymous ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Report Printing
On Fri, Mar 26, 2021 at 1:23 PM ZPBear wrote: > Hello,My wife Jennifer has been using GnuCash for several years.Printing > reports has never worked.I installed 4.4 today and still no good.The title > shows 2020 (for the current tax year).When I choose Report / Account > Summary the report opens with zero values and a 2019 title.Please explain > why this is happening. I never use that report myself, but I just opened it on this computer and it looks like the default is for it to show transactions to the date you have defined for the accounting period. I don't know why it would have 2019 as any sort of option, but you CAN use the report options to change the date (look for Options on the toolbar, or Edit --> Report Options). You also said "Printing reports has never worked" and that's a separate issue. I don't know the current state of Windows versions of GnuCash, but it could be that you will need to copy the report elsewhere, or print a PDF version of the report first and print from there. On linux, whenever I go to print I get to choose Print to File or Print to LPR (for the Flatpak version of GnuCash). I don't think the LPR printer definition works, but I haven't tried; since switching to Flatpak I always print to PDF first. Please let us know (by copying the list) whether any of these comments are helpful. > - > 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 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.
[GNC] Report Printing
Hello,My wife Jennifer has been using GnuCash for several years.Printing reports has never worked.I installed 4.4 today and still no good.The title shows 2020 (for the current tax year).When I choose Report / Account Summary the report opens with zero values and a 2019 title.Please explain why this is happening.Thank youGeffSent from my smarter than me smartphone. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] FW: Problem booting software
I just had exactly the same issue! John Ralls and Alan Holmes provided me with answers. Essentially it is because your installation doesn't seem to have 'cleaned' the path when it installed the version you are using, afaics. I was using an earlier version of GnuCash for quite a while before it happened. In the end I made sure I had a 'good' backup of the data and then uninstalled GC, using, in my case, an uninstall app., not the MS version, which removed all the entrails. I then made sure the backup was still there and installed the latest version of GC. I only seemed to have lost a few entries. It worked for me, I don't understand why the issues arose after I had been using GC for months. Barry On 26/03/2021 04:50, Tom wrote: -Original Message- From: Tom [mailto:pen...@iinet.net.au] Sent: Friday, 26 March 2021 11:03 AM To: 'mailto:gnucash-user-ow...@gnucash.org' Subject: Problem booting software When I try to launch gnucash I receive the attached error message. I am running: Gnucash v 4.4 however the problem started after I downloaded v4.3 Windows 10.0.1 Build 19041. If I repeatable press OK the program eventually boots and operates well. Any suggestions of how to fix this annoyance? Tom Hoffman -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+pentom=iinet.net...@gnucash.org] On Behalf Of gnucash-user-ow...@gnucash.org Sent: Thursday, 25 March 2021 6:59 PM To: pen...@iinet.net.au Subject: Request to mailing list gnucash-user rejected Your request to the gnucash-user mailing list Posting of your message titled "Help" has been rejected by the list moderator. The moderator gave the following reason for rejecting your request: "Write something more useful, because you are going to have to provide a lot more information before you can get an answer. Something more descriptive than "help" as the title, because it looks like spam. Then tell us what OS you are using and what the error actually says, because there is no image with this email." Any questions or comments should be directed to the list administrator at: gnucash-user-ow...@gnucash.org ___ gnucash-user mailing list gnucash-user@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@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.
[GNC] FW: Problem booting software
-Original Message- From: Tom [mailto:pen...@iinet.net.au] Sent: Friday, 26 March 2021 11:03 AM To: 'mailto:gnucash-user-ow...@gnucash.org' Subject: Problem booting software When I try to launch gnucash I receive the attached error message. I am running: Gnucash v 4.4 however the problem started after I downloaded v4.3 Windows 10.0.1 Build 19041. If I repeatable press OK the program eventually boots and operates well. Any suggestions of how to fix this annoyance? Tom Hoffman -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+pentom=iinet.net...@gnucash.org] On Behalf Of gnucash-user-ow...@gnucash.org Sent: Thursday, 25 March 2021 6:59 PM To: pen...@iinet.net.au Subject: Request to mailing list gnucash-user rejected Your request to the gnucash-user mailing list Posting of your message titled "Help" has been rejected by the list moderator. The moderator gave the following reason for rejecting your request: "Write something more useful, because you are going to have to provide a lot more information before you can get an answer. Something more descriptive than "help" as the title, because it looks like spam. Then tell us what OS you are using and what the error actually says, because there is no image with this email." Any questions or comments should be directed to the list administrator at: gnucash-user-ow...@gnucash.org -- This email has been checked for viruses by AVG. https://www.avg.com ___ gnucash-user mailing list gnucash-user@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.