[GNC] Importing QFX
I just upgraded to 5.0 and now can no longer find the QFX choice under Import. Where did it go? ___ 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] mortgage calculator
Thanks to you all especially Derek's nice explanation. What I have been doing is no real burden, and I suppose I'll just press on until someone solves the problem. On 2/18/2022 12:42 PM, Alan Schold via gnucash-user wrote: Is there a way to get the mortgage repayment module to account for regular extra monthly payments? Now the calculations proceed as if I'm just paying the basic mortgage amount, and I have to recalculate the principal balance each month. The calculator is only right once! ___ 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] mortgage calculator
Is there a way to get the mortgage repayment module to account for regular extra monthly payments? Now the calculations proceed as if I'm just paying the basic mortgage amount, and I have to recalculate the principal balance each month. The calculator is only right once! ___ 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] importing account info
David, thanks for all the analysis; I'm working through the information. I solved the problem by uninstalling 3.8 and installing 3.7; the info I needed flowed right in. It's most likely my machine, but I wonder if there's a bug. On 2/9/2020 2:32 PM, David Cousens wrote: Alan, As the message says, the imported record is in a currency/security that does not match the that of the account that GnuCash has assigned to it. This could mean either the commodity data in the input record is incorrect or the matcher already has stored map information which is assigning it an account which is in the wrong currency. It is unlikely the data from your broker may be incorrect unless the name of the security registeredon the exchange has been changed. Just to be sure I would check at least for the first record that the input OFX file has the commodity that is assigned to the account you expect the transactions's second split to be assigned to. "Invesco Preferred ETF" is not the name of an account but should be the name of the commodity/security specified in the input data. The GnuCash assigned account has a commodity name "iShares Russell 2000" which is the same as the account name, also wierd. I would think that the "iShares Russell 2000" account would likely have a USD ( or whatever is appropriate to your locale) currency. If it is not a n account of type stock that may be causing the confusion Did you manually choose the account "iShares Russel 2000" or did GnuCash supply that as a match? If it was the latter then somehow the account matching data may have been screwed up. I had some wierd account assignments when I first transition to V3 but haven't had that on the later v3 minor version transitions. If you choose Yes in the popup, you should get the account assignment dialog where you can assign the correct account then at least that record is correct. I would check the commodity of the account you wish to assign and make sure it matches the commodity identified in the qfx input data file first (in the Accounts tab, highlight the account, right click and select Edit Account from the pop up menu. The security/currency box should match the code in the input data). If assigning the correct transfer accounts allows that record to be imported and then repeats the same error on the next record, my guess is that the matcher data is screwed up. There are two approaches from here. Either manually correct each record by pressing Yes and assigning the correct account. A pain if you have a lot of records but if you complete the import process, the new data will be imported into the matching data for an account. The second approach is to use the Tools->Import Map Editor to edit the information that the account assignment is based on. This post http://gnucash.1415818.n4.nabble.com/GNC-import-map-editor-td4699101.html may contain some useful information. Section 6.15.8 in the help manual has a little information. It is pretty generic (I wrote it) as my understanding of this part of the code is still very limited. The matcher works by tokenizing information in the descrition field (not sure about the memo fields) and matching that to a list of tokens associated with transactions which have been imported in the past and matched to a specific account. Gnucash calculates a score for the number of matching tokens in the description and each account to which assignments of transaction splits weighted by the count of the frequency of each tokens appearance in transactions which have been assigned in past imports and assigns the highest scoring account. This is my current understanding of the account matching operation and it is only from a fairly cursory exploration of the code at this stage and a little but not much experimentation. I have intended to get back and explore it in more detail but life catches up with me sometimes. if you examine the token strings for the account Gnucash is incorrectly assigning and the tokens associated withthe account you want to be assigned along with the input record description you may be able to identify why the wrong account is being assigned and delete the appropriate tokens from the account. This has a high risk of stuffing up future account assignments. I would play with it on a copy of your data file and a small import data subset until you can get it to work if you take this route. The account matching data is stored in the XML data file so any work done on the copy will not automatically transfer back to your main datafile. If the datafile contains a lot of incorrect matching information as it is a Bayesian system continuing to fix the assigned accounts and completing the import will eventually fix things as it will change the weightings on tokens in the files. Maybe importing in smaller batches, fixing each batch up as you go may be the safest way to approach this. I would like to see a feature which would allow the existing transactions in selected accounts to be used in
Re: [GNC] importing account info
Not sure why you couldn't see my screenshot. My program showed the attachment to be 70.8 KB. Anyway, I saved it as a .png; maybe that will help. On 2/5/2020 3:04 PM, David Cousens wrote: Alan, Your screenshot is not attaching correctly, it is only 2 bytes. If you can attach it as a jpg or png file it may come through. >From what version of GnuCash did you upgrade to V3.8 ? The importer was completely rewritten in the upgrade from 2.6.x to V3. I had to completely retrain the Bayesian matching in the import matcher after the transition. I don't fully understand why as the information is stored in the xml datafile. Geert maybe able to explain what caused this. I think there may have been some changes to the parsing of tokens and maybe storage, but I am not sure of this. If the import matcher is incorrectly assigning an account, it is important that it is corrected in the import matcher and not later in the account register after importing as only assignments made during the import process are used in defining the import matcher database of tokenized information from the description field. That information is only stored when you complete the import process after assigning any unassigned transfer accounts and correcting any mistakes the automatic process made. At present no use is made of the information in existing transactions unless they have passed through the importer. I don't import QFX files but I do import OFX files where the structre is similar. After the initial problem going from 2.6.19 to 3.0 and retraining the matcher by importing data a month at a time and checking the account assignments carefully before completing the import, my original account assignments have largely been restored. Double clicking on a transaction in the import matcher window will bring up the account asiignment dialog. It is also possible to edit the information used for the matching process. If incorrect information has been stored there it can take some time and several imports to the same account to correct the information. Tools->Import Map Editor. You may need to exercise a great deal of caution and have a good idea of how the bayesian matching process works to successfully edit the data. So far I have looke at it but have not tried it. It usues combinations of the tokenized information to produce the overall weighting for a specific transfer account to be assigned. If it is only a single account that is causing a problem it should be possible to find the data which is causing the wrong assignment and delete it. AFAIK the Import Map Editor has not been documented yet. I have been upgrading some of the import process documentation but haven't got to this as yet and I am not at all familiar with the code in this area. I can't see what screen it is that is coming up but whether the account picker dialog or a list of the possible matches is displayed depends upon the state of the checkboxes labelle"A", "U" and "R" and it sounds like it was the latter nad not the former. If the A checkbox is checked, the transaction has been identified as not matching an existing transaction and flagged for import. It may have either a grren or gold background color. If green the matcher has assigned a transfer account and you will need to check it has made a correct choice. If gold it has not been able to match a transfer account and you will need to assign a transfer account to it. By default it is assigned to an Imbalance account if you do not assign an account before completing the import. IDouble clicking the transaction will bring up the account picker dialog. It is important for the training of the Bayesian match picker that the transfer account be assigned at this point. The dialog allows you to create new accounts if this should be necessary If the R checkbox is checked it has matched an existing transaction with the transaction to be imported and flagged it not to be imported and it will usually have a green background. The bar code displayed will give some idea of the quality of the match. Here double clicking will display the data for the imported transaction and the best matched transaction and any other close matches. You can select another of the close matches if it is the correct transaction to match. At this point you might decide that the import matcher has got it wrong in this case and the transaction needs to be imported as it isn't a match to any existing transaction. Cancel out of the display of matching transactions and click on the A checkbox to flag it for import. GnuCash will then attempt to assign a transfer account and the background will change to either green or gold. Again you can now accept or reject the assigned account or change it as above If the U checkbox is checked.it usually means any attempt at a match to any existing transaction had some limited success but not enough to mark the transaction as a match. It will have a red/pink background to indicate that the transaction requires
Re: [GNC] importing account info
Thanks, David, I'll get started on your suggestions. I updated from v 3.4 On 2/5/2020 3:04 PM, David Cousens wrote: Alan, Your screenshot is not attaching correctly, it is only 2 bytes. If you can attach it as a jpg or png file it may come through. >From what version of GnuCash did you upgrade to V3.8 ? The importer was completely rewritten in the upgrade from 2.6.x to V3. I had to completely retrain the Bayesian matching in the import matcher after the transition. I don't fully understand why as the information is stored in the xml datafile. Geert maybe able to explain what caused this. I think there may have been some changes to the parsing of tokens and maybe storage, but I am not sure of this. If the import matcher is incorrectly assigning an account, it is important that it is corrected in the import matcher and not later in the account register after importing as only assignments made during the import process are used in defining the import matcher database of tokenized information from the description field. That information is only stored when you complete the import process after assigning any unassigned transfer accounts and correcting any mistakes the automatic process made. At present no use is made of the information in existing transactions unless they have passed through the importer. I don't import QFX files but I do import OFX files where the structre is similar. After the initial problem going from 2.6.19 to 3.0 and retraining the matcher by importing data a month at a time and checking the account assignments carefully before completing the import, my original account assignments have largely been restored. Double clicking on a transaction in the import matcher window will bring up the account asiignment dialog. It is also possible to edit the information used for the matching process. If incorrect information has been stored there it can take some time and several imports to the same account to correct the information. Tools->Import Map Editor. You may need to exercise a great deal of caution and have a good idea of how the bayesian matching process works to successfully edit the data. So far I have looke at it but have not tried it. It usues combinations of the tokenized information to produce the overall weighting for a specific transfer account to be assigned. If it is only a single account that is causing a problem it should be possible to find the data which is causing the wrong assignment and delete it. AFAIK the Import Map Editor has not been documented yet. I have been upgrading some of the import process documentation but haven't got to this as yet and I am not at all familiar with the code in this area. I can't see what screen it is that is coming up but whether the account picker dialog or a list of the possible matches is displayed depends upon the state of the checkboxes labelle"A", "U" and "R" and it sounds like it was the latter nad not the former. If the A checkbox is checked, the transaction has been identified as not matching an existing transaction and flagged for import. It may have either a grren or gold background color. If green the matcher has assigned a transfer account and you will need to check it has made a correct choice. If gold it has not been able to match a transfer account and you will need to assign a transfer account to it. By default it is assigned to an Imbalance account if you do not assign an account before completing the import. IDouble clicking the transaction will bring up the account picker dialog. It is important for the training of the Bayesian match picker that the transfer account be assigned at this point. The dialog allows you to create new accounts if this should be necessary If the R checkbox is checked it has matched an existing transaction with the transaction to be imported and flagged it not to be imported and it will usually have a green background. The bar code displayed will give some idea of the quality of the match. Here double clicking will display the data for the imported transaction and the best matched transaction and any other close matches. You can select another of the close matches if it is the correct transaction to match. At this point you might decide that the import matcher has got it wrong in this case and the transaction needs to be imported as it isn't a match to any existing transaction. Cancel out of the display of matching transactions and click on the A checkbox to flag it for import. GnuCash will then attempt to assign a transfer account and the background will change to either green or gold. Again you can now accept or reject the assigned account or change it as above If the U checkbox is checked.it usually means any attempt at a match to any existing transaction had some limited success but not enough to mark the transaction as a match. It will have a red/pink background to indicate that the transaction requires some manual decision. A double click will bring up the dialog displaying
[GNC] importing account info
I see several importing questions, but none speak to this problem. I hope this explanation is not too wordy. I download activity weekly from several trading accounts. I save them temporarily as .qfx files which I then import into the same accounts in GnuCash. This has worked perfectly until recently when I upgraded to 3.8. Since then GnuCash sees each import as belonging to some unrelated issue in my wife’s account. For each account I get the screen which I attached. Neither of the accounts referenced are the from/to account. If I choose “yes”, the same screen returns. If I choose “no”, one transaction is listed. This repeats for each transaction. I cannot get out of the process until all transactions are listed; then I can cancel (because the information will be saved to the wrong account & it is incomplete). I have tried deleting the incorrect account, but the program just finds another one. I can’t think of anything else I’ve done differently. ___ 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] mortage calc
Thanks. I did not realize there had been updates (do we get some sort of notification?), but now I have Version 3.8 Build ID: 3.8b+(2019-12-29). As you postulated, it now works as it should. On 1/28/2020 5:37 PM, Adrien Monteleone wrote: Is there a reason not to use the latest v3.8? I’d try that and see if you still get a crash. If so, check the wiki about obtaining the necessary logs on the Windows platform for reporting a crash on Bugzilla. Regards, Adrien On Jan 28, 2020 w5d28, at 5:02 PM, Alan Schold wrote: I am trying to enter data for a refi. I go to Actions>Scheduled Transactions>Mortgage and Loan Repayment Setup. After a short "Not Responding" message I fill in Loan Details then go to the Loan Repayment Oprion screen. Since I don't us Escrow I leave it blank. When I push Next, after a short pause, the entire GnuCash program shuts down, but the "lock" program is still present. I have tried adding something to the escrow screen, but the result is the same. I;m using version 3.4 build 3.4+ (2018-12-30). I have Windows 10 with the newest upgrade. ___ 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] mortage calc
I am trying to enter data for a refi. I go to Actions>Scheduled Transactions>Mortgage and Loan Repayment Setup. After a short "Not Responding" message I fill in Loan Details then go to the Loan Repayment Oprion screen. Since I don't us Escrow I leave it blank. When I push Next, after a short pause, the entire GnuCash program shuts down, but the "lock" program is still present. I have tried adding something to the escrow screen, but the result is the same. I;m using version 3.4 build 3.4+ (2018-12-30). I have Windows 10 with the newest upgrade. ___ 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] Version 3
One addendum to my last post. I notice there are no gnucash.trace entries between April 12 and 17. I'm very sure I updated to version 3.0 on the 13th and returned to 2.6.xx on the 15th or 16th On 4/15/2018 7:34 AM, John Ralls wrote: On Apr 15, 2018, at 6:17 AM, Alan Schold <asch...@q.com <mailto:asch...@q.com>> wrote: Tried a few simple things without success to noavail. I reinstalled 2.6.21, and everything works fine. Interesting tho, every time I tried to run the 3.0 version there was a lock on the data even tho I had never been able to open any data. Id' love to be able to use 3.0 but not yet On 4/14/2018 8:35 AM, Alan Schold wrote: I download and ran the new, stable version 3.0. When I click on the desktop icon I first get a notice that my Gnucash data file is locked. Since I properly closed the file before I upgraded I click on "open anyway". After some delay a box appears named Microsoft C++ Visual Runtime Library. It says /Runtime Error!/ /Program: C:\Program Files (x86)\gnucash\bin\gnucash.exe/ /This application has requested the Runtime to terminate it in an unusual way./ /Please contact the application's support team for more information. OK/ After that there is no more activity. I cannot get to the program at all What’s in the trace file (https://wiki.gnucash.org/wiki/Tracefile)? Regards, John Ralls <http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> ___ 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] Version 3
Tried a few simple things without success to noavail. I reinstalled 2.6.21, and everything works fine. Interesting tho, every time I tried to run the 3.0 version there was a lock on the data even tho I had never been able to open any data. Id' love to be able to use 3.0 but not yet On 4/14/2018 8:35 AM, Alan Schold wrote: I download and ran the new, stable version 3.0. When I click on the desktop icon I first get a notice that my Gnucash data file is locked. Since I properly closed the file before I upgraded I click on "open anyway". After some delay a box appears named Microsoft C++ Visual Runtime Library. It says /Runtime Error!/ /Program: C:\Program Files (x86)\gnucash\bin\gnucash.exe/ /This application has requested the Runtime to terminate it in an unusual way./ /Please contact the application's support team for more information. OK/ After that there is no more activity. I cannot get to the program at 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. --- This email has been checked for viruses by AVG. http://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.
[GNC] Version 3
I download and ran the new, stable version 3.0. When I click on the desktop icon I first get a notice that my Gnucash data file is locked. Since I properly closed the file before I upgraded I click on "open anyway". After some delay a box appears named Microsoft C++ Visual Runtime Library. It says /Runtime Error!/ /Program: C:\Program Files (x86)\gnucash\bin\gnucash.exe/ /This application has requested the Runtime to terminate it in an unusual way./ /Please contact the application's support team for more information. OK/ After that there is no more activity. I cannot get to the program at 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.
Tax tables
Wll the tax template in Reports be updated in light of the new US tax law? ___ 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: Finance-Quote 1.47 released!
I believe I have 1.47 installed and am trying to add the Alphaadvantage key as described in the FAQ. I navigate to _C:\Program Files (x86)\gnucash/etc/gnucash/environment_, and I'm not sure what to do next. Opening /environment/ brings up an explanation of the file, but I don't see anywhere to add the variable. I know I'm missing something simple. On 11/12/2017 5:21 PM, Erik Colson wrote: Cam Ellisonwrites: On 12/11/17 08:27 AM, Erik Colson wrote: New version 1.47 of Finance-Quote is available with the following changes: * Use AlphaVantage for currency quotes instead of Yahoo (Mike Alexander) FYI: USD->CAD now works, but not GBP->CAD. it does here: ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl GBP CAD GBP->CAD = 1.66540274 ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl CAD GBP CAD->GBP = 0.60045536 -- erik colson ___ gnucash-user mailing list gnucash-user@gnucash.org 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. --- This email has been checked for viruses by AVG. http://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Price retrieval
I usually update prices on the weekend, but this past weekend suddenly the process would not happen. I attempted ro reinstall the perl from the GnuCash section of Windows 10 and got an error message. Attached is the screenshot of the installation process. Any ideas? ___ gnucash-user mailing list gnucash-user@gnucash.org 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.