Re: [GNC] OFX Import Mappings
Did you delete the parent account mapping as well? Assumption here is that you are tracking individual mutual funds along with Money Market fund under the parent account. You must also delete the parent account mapping as well as individual mutual fund mappings that are in that account in the 'Online" side of the 'Import Map Editor'. This has worked fine for me in the past so there might be some strange and/or odd interaction here that might be the culprit in that case. Read the 'Match String' carefully to find the account you want to remove the mapping for. Might be worth to undo the placeholder and unhide to see if they show up in the 'Online' side of the 'Import Map Editor'. Income side of the mapping for the Money Market fund is likely to be in the 'Bayesian' side of the 'Import Map Editor'. That is where it shows up in mine. I am uncertain if the account is disabled or not matters in any way for the import. -Original Message- From: Rob LaRose Sent: Friday, October 06, 2023 1:57 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] OFX Import Mappings I've already searched all the tabs for any occurence of the disabled account...there were none. I'm pretty sure that I've previously deleted all my Vanguard online mappings to get a clean slate, but still ended up with GC importing transactions to the placeholder account. I'll try deleting the online mapping again to make sure that I really have tried that approach to see if it will reset, FYI... GC has behaved this way for quite a while now, but frequently I just manually enter if there are just a few transactions. I only think about it when I do an import (like for an end-of-quarter) On Sun, Oct 1, 2023 at 8:04 PM Kalpesh Patel wrote: > Rob - It is Import Map Editor. What you want to select is the 'Online' > at the top where you will see three total choices - Bayesian (selected > by default), Non-Bayesian and Online. Unfortunately you can only > delete entries here in the Import Map Editor so find the one that is > errant as mentioned below and delete it. Next time you import it, GNC > will ask you to map the account which is the opportunity you want to > take to wire it up correctly. > > Hope this helps. > > -Original Message- > From: Rob LaRose > Sent: Saturday, September 30, 2023 11:54 AM > To: gnucash-user@gnucash.org > Subject: [GNC] OFX Import Mappings > > Sometime ago, Vanguard replaced one of their Money Market funds with a > new Money Market fund. > In GC, I created a new fund account to handle the change. > Once all the transfer transactions for the old fund account were > complete, > I: > - Renamed the account: to move it to the bottom of any acct list as > well as identify it as an inactive account > - Set the account as a placeholder: to prevent accidentally creating > transactions > - Hid the account: so that I wouldn't have to look at it all the time. > > However, now when I import an OFX file from Vanguard, income > transactions for the new fund account are entered as being sourced > from the renamed, placeholder account instead of the appropriate > income account for the new fund. > > I figured this had something to do with the Import Map Editor. I > searched for the renamed account that GC was using and found no matches. > I even deleted all the mappings figuring I would just rebuild the > account matches but for some reason, it keeps using the old account. > > There must be some other location where GC has stored this association. > How do I resolve the mapping issue so that transactions get associated > to the correct income account? > > GnuCash: Flatpak v5.4.1 > OS: Ubuntu 23.04 > > Thanks > Rob > > > ___ 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] conceptual errors and approximate numbers [was: Re: GnuCash_user: rounding errors and significant digits]
Bruce: On 2023-10-07 18:06, Bruce McCoy via gnucash-user wrote: ...What I do not yet understand is if GnuCash considers a price per share of 10.89 to be a precise figure, why GnuCash does not calculate 1,377.41 * 10.89 = 15,000.00 for Jeff. If GnuCash doesn’t, would we consider making a change to GnuCash to allow it? ... I believe that your first conceptual error is in your premise, "if GnuCash considers". You are missing the preceding step: Why does Bruce McCoy assert what he asserts? When Bruce McCoy reads a broker statement that a trade was "1,377.41 shares, price 10.89, amount $15,000.00", why does Bruce consider the price per share of 10.89 to be a _precise_ figure, rather than an approximation? Why does Bruce McCoy not engage with the arithmetic truth that the quantity "1,377.41 * 10.89" is not equal to the quantity "15,000.00"? The two quantities are approximately equal, but not exactly equal. Why does Bruce interpret this trade as: "1,377.41 * 10.89 = 15,000.00" instead of "1,377.41 * 10.89 ≆ 15,000.00" (where "≆" means "approximately equal to but not equal to"? Many people have told you, Bruce, that the practical way[*] to read this broker statement is as: "_exactly_ 1,377.41 shares, price _approximately_ 10.89, amount _exactly_ $15,000.00" Then when entering the transaction to GnuCash, enter exactly 1,377.41 as the number of shares, exactly 15,000.00 as the amount of the transaction, and leave the price blank. GnuCash fills in a price of 1500/137741, and stores that internally. GnuCash might display the price as either 10 + 5/137741 or $10.8900, depending on the currency and the user preferences, but remember that display and internal exact value need not be the same thing. (As indeed it probably is not, in the case of the broker's statement of price.) For example, from this thread: On 2023-10-07 13:06, john wrote: ...Jeff did it wrong. Jeff should enter the number of shares and the amount paid and let GnuCash calculate the price, because the price per share he paid wasn't 10.89, it was 137741/150. 137741 is the product of two primes, 181 and 761, so 137741/150*cannot* be exactly represented as a decimal. It's simpler to enter the amount and value than to enter an exact price or, On 2023-10-07 20:07, David Carlson wrote: ...What you do not understand is that John Ralls and GnuCash recommend entering the total amount and the total number of shares and letting GnuCash calculate the price. THEN there is no error in the account running balance. This is not going to change So, Bruce, you titled this thread "rounding errors and significant digits". But the error I see revealed by this thread is not a rounding error by GnuCash, it is a conceptual error by you, in interpreting a logically inconsistent broker transaction report, and errors which follow from that interpretation. I also see an error in failing to use GnuCash in the way which best fits the provided information, to record the transaction. I have put a lot of effort into this thread. I am happy to help people get answers to questions about GnuCash by contributing to this list. However, I don't think this thread is about GnuCash any more. It is about your conceptual interpretation of logically inconsistent broker transaction reports. That is not a topic which I find valuable for the limited time I want to invest in this email list. Thus, I suspect I will lose interest in this thread going forward. Best regards, —Jim DeLaHunt [*] by "practical way", I mean in part that you can determine from the broker's other information that the values they give for the quantity of shares and the amount of the transaction are exact. For instance, if they say that a transaction puts $15,000.00 into your account, and if they reject your attempt to withdraw $15,000.01 due to insufficient funds, and if they tell you after withdrawing $14,999.99 that you have $0.01 left over, and if they tell you after withdrawing $15,000.00 that you have a zero cash balance, and if they don't allow cash transactions for partial cents, then you can be pretty sure that the $15,000.00 amount they told you was an exact rather than approximate number. ___ 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] Securities transactions, not Trial Balance [was: Re: GnuCash_user: rounding errors and significant digits]
I fear that Bruce McCoy pushed this thread astray by introducing the phrase "books… out of balance". This moved the topic from GnuCash handling of securities transactions to GnuCash handling of the Trial Balance. On 2023-10-06 09:39, Bruce McCoy via gnucash-user wrote: ... What are the plans to help our users whose books are out of balance by a cent or so? ... Then John Ralls, and others, headed off in that direction: On 2023-10-06 10:02, John Ralls wrote: GnuCash's rounding isn't likely to put books out of balance because GnuCash forces transactions to be balance in the transaction currency. Book out of balance, meaning that the trial balance report doesn't balance with the Average Cost price source, nearly always results from not computing capital gains/losses correctly. That led to discussion of cost of goods sold, and GnuCash not having support for cost accounting, and so on. The digression does not strike me as helping Bruce understand what many on this list are trying to explain to him. ___ 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] OFX Import Mappings
Per Kalpesh's suggestion, I deleted the online mapping for the fund that has been importing incorrectly. I removed the incorrect transaction to make GC think that this transaction was new again and re-imported the QFX file that had caused the incorrectly mapped transaction to be created. As expected, GC did ask for the target account for this 'new' transaction, but did not ask for the income account. The result was a transaction in the desired account but with the income source still being the inactive, placeholder account. So my questions are: How does GC map the income account to the asset account? How do I change or delete the mapping so that I can map it to the proper location? It's also interesting that GC allowed the entry into the placeholder account, but the new transaction didn't have an effect on the account balance. On Fri, Oct 6, 2023 at 1:56 PM Rob LaRose wrote: > I've already searched all the tabs for any occurence of the disabled > account...there were none. > I'm pretty sure that I've previously deleted all my Vanguard online > mappings to get a clean slate, but still ended up with GC importing > transactions to the placeholder account. > I'll try deleting the online mapping again to make sure that I really have > tried that approach to see if it will reset, > > FYI... GC has behaved this way for quite a while now, but frequently I > just manually enter if there are just a few transactions. > I only think about it when I do an import (like for an end-of-quarter) > > On Sun, Oct 1, 2023 at 8:04 PM Kalpesh Patel > wrote: > >> Rob - It is Import Map Editor. What you want to select is the 'Online' at >> the top where you will see three total choices - Bayesian (selected by >> default), Non-Bayesian and Online. Unfortunately you can only delete >> entries here in the Import Map Editor so find the one that is errant as >> mentioned below and delete it. Next time you import it, GNC will ask you to >> map the account which is the opportunity you want to take to wire it up >> correctly. >> >> Hope this helps. >> >> -Original Message- >> From: Rob LaRose >> Sent: Saturday, September 30, 2023 11:54 AM >> To: gnucash-user@gnucash.org >> Subject: [GNC] OFX Import Mappings >> >> Sometime ago, Vanguard replaced one of their Money Market funds with a >> new Money Market fund. >> In GC, I created a new fund account to handle the change. >> Once all the transfer transactions for the old fund account were complete, >> I: >> - Renamed the account: to move it to the bottom of any acct list as well >> as identify it as an inactive account >> - Set the account as a placeholder: to prevent accidentally creating >> transactions >> - Hid the account: so that I wouldn't have to look at it all the time. >> >> However, now when I import an OFX file from Vanguard, income transactions >> for the new fund account are entered as being sourced from the renamed, >> placeholder account instead of the appropriate income account for the new >> fund. >> >> I figured this had something to do with the Import Map Editor. I >> searched for the renamed account that GC was using and found no matches. >> I even deleted all the mappings figuring I would just rebuild the account >> matches but for some reason, it keeps using the old account. >> >> There must be some other location where GC has stored this association. >> How do I resolve the mapping issue so that transactions get associated to >> the correct income account? >> >> GnuCash: Flatpak v5.4.1 >> OS: Ubuntu 23.04 >> >> Thanks >> Rob >> >> >> ___ 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] GnuCash_user: rounding errors and significant digits
Perhaps the broker overcharged his client. On Sun, Oct 8, 2023 at 4:44 AM Fred Bone wrote: > On 08 October 2023 at 4:13, David Carlson said: > > > Because the broker charged 15,000.00 for 1,377.41 shares? > > Then the effective price paid per share wasn't the stated 10.89 but > slightly more (approx 10.890003702601258884) > > > ___ > 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. > -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash_user: rounding errors and significant digits
On 08 October 2023 at 4:13, David Carlson said: > Because the broker charged 15,000.00 for 1,377.41 shares? Then the effective price paid per share wasn't the stated 10.89 but slightly more (approx 10.890003702601258884) ___ 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] Arranging column sizes
Basically double click each header in turn to autosize the column width. I find it best to work from right to left most column and leave the Description to last as it auto-sizes to fill the remaining width which can be confusing for newbies, Ctrl + H- Gnucash Tutorial & Concepts Guide has the following section on it Transactions Setting Column Widths As with most spreadsheet-like displays the columns in the register can be resized by left-clicking and dragging the dividers in the header. The divider to the *right* of the column header controls the width of that column. In GnuCash the Description and Memo columns autosize to fit the register into the window so dragging those columns' dividers to the left will shrink the column but it will snap back when you release it. Dragging them to the right will widen the display and put a scrollbar at the bottom of the window, but that will persist only while the register is open. If you close it and reopen it or quit GnuCash the register will again fill the space exactly. Note Many new users have trouble resizing the Balance column, in particular making it larger. Just drag its right-hand border out of the window to grow it. Be careful, though, as there's another column called rate whose width is set to 1 pixel to hide it (it's for internal use). Approach the divider from the left side and click as soon as the cursor changes to a double-headed arrow (<-|->). Important When in split mode there are different column markers in the header for split rows and transaction rows depending on which type of row is active. In order to adjust split column widths one must first make a split row active; to adjust transaction line column widths a transaction row must be active. Column width settings except for the Description column are saved in the user's book state file and will be restored when the register is closed and reopened. On Sun, 8 Oct 2023 at 17:51, Veli Izzet wrote: > Hi, > > I am using 5.4-1 on W11. > > I am trying to arrange column sizes with no success. Checked the help but > could not find a solution. > > Thanks for any help > > -- > Veli İzzet Çığırgan > ___ > 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] Columns
On Friday, 6 October 2023 18:34:54 BST Jose Fuenzalida wrote: > Hi , my name is Jose and I stared using Gnucash about a month ago and I have > a question : is there any way to add more columns to the Account page? I > mean it has only 3 columns : Account name, Description and total. I > understand that if it is possible it may affect others part of the program > as for example giving totals ,etc. but I only want to add just sort of > inert info nothing to affect everything else so it would only be visible on > the Accounts page . > > HI Jose, Welcome to Gnucash and the list. There are a load of other columns you can display on the Chart of Accounts page. If you look at the very right hand end of the columns titles row, there should be a downward pointing arrow. Click on it! HTH, 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.
Re: [GNC] GnuCash_user: rounding errors and significant digits
FWIW, Jeff reported his problem in 2014, and was happy when Derek advised him to enter the number of shares and the total dollar amount of the transaction, leaving the price to be calculated. I'm not sure whose problem is being solved by this drawn out discussion. David T. On Oct 8, 2023, 12:15 PM, at 12:15 PM, David Carlson wrote: >Because the broker charged 15,000.00 for 1,377.41 shares? > >On Sun, Oct 8, 2023, 2:32 AM Fred Bone wrote: > >> On 08 October 2023 at 1:06, Bruce McCoy said: >> >> [...] >> >> > What I do not yet understand is if GnuCash considers a price per >share of >> > 10.89 to be a precise figure, why GnuCash does not calculate >1,377.41 * >> > 10.89 = 15,000.00 for Jeff. If GnuCash doesn’t, would we consider >making >> > a change to GnuCash to allow it? >> >> There is no good reason to think that 1377.41 * 10.89 = 15000, so why >> would anyone want Gnucash to say it? >> >> ___ >> 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] Arranging column sizes
Hi, You don't quite say what exactly you're doing that isn't working, but does this help? https://www.gnucash.org/docs/v5/C/gnucash-guide/basics-running-gnucash.html#basics-register2 David T. On Oct 8, 2023, 10:52 AM, at 10:52 AM, Veli Izzet wrote: >Hi, > >I am using 5.4-1 on W11. > >I am trying to arrange column sizes with no success. Checked the help >but >could not find a solution. > >Thanks for any help > >-- >Veli İzzet Çığırgan >___ >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] Columns
Hi, Welcome to GnuCash! You can add columns to the Chart of Accounts by clicking the triangle at the upper right corner of the accounts page. David T. On Oct 8, 2023, 10:41 AM, at 10:41 AM, Jose Fuenzalida wrote: >Hi , my name is Jose and I stared using Gnucash about a month ago and I >have >a question : is there any way to add more columns to the Account page? >I >mean it has only 3 columns : Account name, Description and total. I >understand that if it is possible it may affect others part of the >program >as for example giving totals ,etc. but I only want to add just sort of >inert >info nothing to affect everything else so it would only be visible on >the >Accounts page . > > > >Thank you for your help > >___ >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] GnuCash_user: rounding errors and significant digits
Because the broker charged 15,000.00 for 1,377.41 shares? On Sun, Oct 8, 2023, 2:32 AM Fred Bone wrote: > On 08 October 2023 at 1:06, Bruce McCoy said: > > [...] > > > What I do not yet understand is if GnuCash considers a price per share of > > 10.89 to be a precise figure, why GnuCash does not calculate 1,377.41 * > > 10.89 = 15,000.00 for Jeff. If GnuCash doesn’t, would we consider making > > a change to GnuCash to allow it? > > There is no good reason to think that 1377.41 * 10.89 = 15000, so why > would anyone want Gnucash to say it? > > ___ > 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] Arranging column sizes
Hi, I am using 5.4-1 on W11. I am trying to arrange column sizes with no success. Checked the help but could not find a solution. Thanks for any help -- Veli İzzet Çığırgan ___ 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] Columns
Hi , my name is Jose and I stared using Gnucash about a month ago and I have a question : is there any way to add more columns to the Account page? I mean it has only 3 columns : Account name, Description and total. I understand that if it is possible it may affect others part of the program as for example giving totals ,etc. but I only want to add just sort of inert info nothing to affect everything else so it would only be visible on the Accounts page . Thank you for your help ___ 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] GnuCash_user: rounding errors and significant digits
On 08 October 2023 at 1:06, Bruce McCoy said: [...] > What I do not yet understand is if GnuCash considers a price per share of > 10.89 to be a precise figure, why GnuCash does not calculate 1,377.41 * > 10.89 = 15,000.00 for Jeff. If GnuCash doesn’t, would we consider making > a change to GnuCash to allow it? There is no good reason to think that 1377.41 * 10.89 = 15000, so why would anyone want Gnucash to say it? ___ 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.