[GNC] Apple Silicon binaries
Is anyone distributing an Apple Silicon (or fat) binary for Gnucash 5.4.2 on Mac yet, or is building from source my only option? (I know Intel will work in emulation.) -p ___ 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] SQLLite + OFX Import + Bayes = Massive network traffic
Good point. Mac OS X, Gnucash 4.11. On Wed, Apr 5, 2023 at 6:00 PM David Carlson wrote: > I am not sure which OS TCPDump runs in, but it would still be very helpful > to list which version of GnuCash you are running and which OS. > > On Wed, Apr 5, 2023 at 2:45 PM peterb wrote: > >> Also, despite my error in the Subject: line of this post, I did >> actually meant MySQL, and *not* SQLite. >> >> >> On Wed, Apr 5, 2023 at 2:35 PM peterb wrote: >> >> > I've been maintaining a GnuCash database in a MySQL database for several >> > years. Lately, I've noticed various stages of OFX import (including >> > changing accounts, but also hitting the "OK" button to finish the >> import) >> > taking more and more time. When on the same LAN as the database it's >> bad, >> > perhaps 10 seconds, but when SSH tunnelling from a remote location the >> > delay becomes truly ridiculous, on the order of 10 to 20 minutes. >> > >> > Peeking at what's going on with tcpdump, it looks like for an import of >> > around 50 items clicking the ok button triggers thousands coupon >> thousand >> > of SQL inserts, the vast majority of which are somehow related to >> updating >> > the bayesian inference database. >> > >> > My questions are: >> > >> > (1) Anyone else seeing this? I feel like I must have hit some sort of >> > quadratic threshold because as I said I've been using this for literally >> > years and only recently has it gotten noticeably worse. >> > (2) Workarounds: Is there some reasonable way to prevent OFX import from >> > doing these updates at all? Failing that, is there some way to safely >> nuke >> > *just* the bayesian inference DB and start over (short of starting a >> > completely new GnuCash db?). This isn't my ideal solution but it might >> buy >> > me some time. >> > (3) Clearly "accessing an SQL DB, remotely, across the internet" is not >> a >> > core use case compared to updating a local GnuCash file. But might be a >> > good performance work issue for some interested person who wants to >> > contribute to an open source project to poke at. >> > >> > Thanks! >> > -Peter >> > >> ___ >> 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] SQLLite + OFX Import + Bayes = Massive network traffic
Also, despite my error in the Subject: line of this post, I did actually meant MySQL, and *not* SQLite. On Wed, Apr 5, 2023 at 2:35 PM peterb wrote: > I've been maintaining a GnuCash database in a MySQL database for several > years. Lately, I've noticed various stages of OFX import (including > changing accounts, but also hitting the "OK" button to finish the import) > taking more and more time. When on the same LAN as the database it's bad, > perhaps 10 seconds, but when SSH tunnelling from a remote location the > delay becomes truly ridiculous, on the order of 10 to 20 minutes. > > Peeking at what's going on with tcpdump, it looks like for an import of > around 50 items clicking the ok button triggers thousands coupon thousand > of SQL inserts, the vast majority of which are somehow related to updating > the bayesian inference database. > > My questions are: > > (1) Anyone else seeing this? I feel like I must have hit some sort of > quadratic threshold because as I said I've been using this for literally > years and only recently has it gotten noticeably worse. > (2) Workarounds: Is there some reasonable way to prevent OFX import from > doing these updates at all? Failing that, is there some way to safely nuke > *just* the bayesian inference DB and start over (short of starting a > completely new GnuCash db?). This isn't my ideal solution but it might buy > me some time. > (3) Clearly "accessing an SQL DB, remotely, across the internet" is not a > core use case compared to updating a local GnuCash file. But might be a > good performance work issue for some interested person who wants to > contribute to an open source project to poke at. > > Thanks! > -Peter > ___ 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] SQLLite + OFX Import + Bayes = Massive network traffic
I've been maintaining a GnuCash database in a MySQL database for several years. Lately, I've noticed various stages of OFX import (including changing accounts, but also hitting the "OK" button to finish the import) taking more and more time. When on the same LAN as the database it's bad, perhaps 10 seconds, but when SSH tunnelling from a remote location the delay becomes truly ridiculous, on the order of 10 to 20 minutes. Peeking at what's going on with tcpdump, it looks like for an import of around 50 items clicking the ok button triggers thousands coupon thousand of SQL inserts, the vast majority of which are somehow related to updating the bayesian inference database. My questions are: (1) Anyone else seeing this? I feel like I must have hit some sort of quadratic threshold because as I said I've been using this for literally years and only recently has it gotten noticeably worse. (2) Workarounds: Is there some reasonable way to prevent OFX import from doing these updates at all? Failing that, is there some way to safely nuke *just* the bayesian inference DB and start over (short of starting a completely new GnuCash db?). This isn't my ideal solution but it might buy me some time. (3) Clearly "accessing an SQL DB, remotely, across the internet" is not a core use case compared to updating a local GnuCash file. But might be a good performance work issue for some interested person who wants to contribute to an open source project to poke at. Thanks! -Peter ___ 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] Register column sizing
I have been using Gnucash for many years and I still never know exactly what's going to happen when I try to resize a column. It is 120% infuriating - at least to me! - so I'm in favor of trying to make the behavior more sensible. It feels fundamentally weird to me to privilege the description column that way, because it means I constantly end up in situations where space is being added to the description column, which in the common case has plenty of room, and in the meantime my debit and credit columns are cutting off half the numbers in them. -Peter On Thu, Jan 5, 2023 at 10:42 PM john wrote: > Users, > > There have been occasional complaints for many years about column width > sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588. > Most users seem to eventually get used to it, but I wonder if anybody > really likes it. > > The problem boils down to the auto-sizing behavior of the Description > column, which causes that column to grow or shrink when you adjust the > window's width, and to make a horizontal scrollbar appear when you widen > another column. Occasionally someone will complain about the normally > hidden price column because it's possible to catch its handle and widen it > when you mean to widen the balance column. > > It would be really easy to turn off autosizing on the Description field > and only a little work to figure out another way to handle the price and > ditch that column. Would anyone miss it? > > Regards, > John Ralls > > ___ > 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] Credit Card Rewards Refund
In the US, credit card rebates are best treated as a contra-expense account for rebates. In other jurisdictions, this might differ. -p On Fri, Oct 15, 2021 at 12:47 PM R. Victor Klassen wrote: > The OLD day? We still have a couple of vendors like that. Happily for us > accrual accounting is their problem. > > Sent from my iPhone > > > On Oct 15, 2021, at 12:17 PM, Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > > Perhaps historical perspective might help, especially with businesses, > because might want to treat the same way as when invoices typically were > like this, except conditional on when paid. > > > > I have no idea how accrual treats this (would have treated this) when in > the old days a vendor might send an invoice like this: > > > > Immediate, 2% discount, 30 days net, else 1% per month. > > > > I am old enough to remember those days. Assuming the accrual system > treated the "30 days net" as normal, what was done if paid immediately? > That closely resembles the situation of credit card rebates on purchases. > As to the argument wanting to distribute to reduce all expenses paid > during that billing period, is that also being done in reverse with > interest charges (if any -- often a business credit card is not intended as > a source of credit and balance paid each month -- and SOME people ca manage > that with their personal credit cards too) > > > > > > Michael D Novack > > > > > > ___ > > 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. > ___ 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] Fwd: Transaction Entry Confirmation
While I'm not personally in great need of audio confirmations, it does seem to me they might be useful from an accessibility standpoint. On Tue, Aug 31, 2021 at 4:49 PM Dale Alspach wrote: > If the register is set to future transactions after the blank transaction > and the cursor is on the bottom future transaction, the transaction can be > committed but the cursor does not move off the line. I submitted an RFE > about this a few weeks ago. > Dale > > -- Forwarded message - > From: Derek Atkins > Date: Tue, Aug 31, 2021 at 3:16 PM > Subject: Re: [GNC] Transaction Entry Confirmation > To: Jack Frillman > Cc: > > > NB: If the cursor is still in the current transaction, then it was not > committed. If the cursor moves to a different transaction, it has been > committed. In either case, GnuCash will not let you close the register > window if you have non-committed changes. > > -derek > > PS: If you want the feature, patches are always welcome! :) > > On Tue, August 31, 2021 4:02 pm, Jack Frillman wrote: > > It's not a big deal I was just looking for one and wasn't able to find > > an option like that. > > > > If you want to know how my brain is working. > > If I mash ENTER in an open split transaction it moves down to the next > > split transaction. What does that mean? Does that mean the whole > > transaction was entered or just the split was entered? I'm never sure so > > I was looking for an audio confirmation when the entire transaction was > > committed like in the program I used before switching to GNU Cash. Now > > to be absolutely sure I close the split and mash ENTER again. > > > > On 8/31/21 3:41 PM, Derek Atkins wrote: > >> Jack, > >> > >> On Tue, August 31, 2021 3:30 pm, Jack Frillman via gnucash-user wrote: > >>> What's yhere to understand. I was looking for an audio confirmation > >>> like > >>> a little tiny beep. > >> I think Will's point was questioning why you specifically want an audio > >> confirmation when there is clearly a visual confirmation (by the cursor > >> moving to the next line or new transaction). > >> > >> -derek > >> > >>> On 8/31/21 11:30 AM, William Prescott wrote: > I don't understand. > > When I type the Enter key, it moves from one line of a transaction to > the next line. After the last line, it enters the transaction and > moves > to the first line of the next transaction. > > This is with GnuCash 4.6-1 running on MacOS 11.5.2. > > Will > > On 2021 Aug 31, at 08-31 10:06:10, Jack Frillman via gnucash-user > wrote: > > > Is there any way to have GNU Cash make an audio confirmation when a > manual transaction has been entered? > > When I manually enter a transaction by mashing ENTER there is no > feedback that the transaction was entered and I keep hitting ENTER to > be > sure I didn't fat finger it. > Just a little beep would suffice. > > >>> -- > >>> 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. > >>> > >> > > > > -- > > Old Unix programmers never die, they just mv to /dev/null > > - Anonymous > > > > > > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > ___ > 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. > ___ 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
Re: [GNC] Import Format
On a related note, I wish Gnucash supported export formats besides CSV. -p On Thu, May 27, 2021 at 9:39 PM DaveC49 wrote: > The CBA in Australia offers CSV, OFX and QIF (2 variants) downloads from > the > bank website. They only offer direct connect OFX downloads via MYOB or > Quicken where these companies have a software deal/agreement with the bank > about security. i have approached them about direct connect access but > received a blanket no for open access software. Not sure about other > Australian banks and what they offer. > > > > -- > 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. > ___ 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] Proposed: "Realized Gain/Loss" transactions considered harmful
On Tue, May 25, 2021 at 4:38 AM Geoff wrote: > I personally found the current process quite confusing for a long long > time until one day it finally "clicked" and now I am used to using the > Lots functionality for tracking capital gains & losses. > Hi, Geoff! I'm in the same boat. I'm used to it as well, but I spend a lot of time looking at how other systems model these transactions and that's what has me concerned; this is first and foremost a correctness issue, but it's also a data portability issue. I do want to distinguish between "using the lots feature to calculate capital gain" and "how the calculated gains are journaled." I'm focused entirely on how the capital gains are reflected in the journal entries - we should be able to keep the exact same view lots UI even if we change how the lots UI journals things. It seems to me that your proposal, in essence, involves including the > capital gain as one of the splits of the sale transaction, whereas the > current Gnucash functionality requires you to "transfer" the gain out of > the stock account and into the income account as a separate transaction > to the sale itself. And the Lots functionality can do this for you, > either by you choosing the individual lots, or automatically on a first > in, first out basis. > This is a fair description, although I think of the transfer as coming out of the income account, not into. The existing functionality works because stock accounts are not dollar-denominated, so the dollars (or whatever currency) you debit into it in your 0-share transaction evaporate upon contact. This brings up a related point that I didn't touch, which is that it's arguably better (though certainly not required) for the gain calculation to be part of the sale transaction - if you've ever made a sale which touches 10 lots, the current method creates 10 consecutive "Realized Gain/Loss" transactions which have no obvious ordering or connection to the lots sold - if you need to go back for any reason, you have to do detective work to figure out which is which. > Have you considered generalising your proposal to cover other stock > related capital gain scenarios, for example: > * The sale includes brokerage, taxes, or other charges > * The sale of several lots that were bought at different prices > These two should be treated just as they are now (GnuCash probably can't take a strong stance on them because of differing local tax laws.) > * A share split or consolidation with partial return of capital > * Takeover > * Liquidation > I haven't thought deeply about these scenarios yet, but they should be conceptually similar. > The biggest drawback I see with your proposal is that the selling price > is no longer recorded in the price column, but is only held in the split > description? You seem to be recording the original buying price as the > price on the sell transaction, which is confusing at first glance and, > in a sale of multiple lots scenario, would require the entry of many > such splits? > I want to be clear that what I was trying to get at in my proposal is a *simulation* of what we might want, and as such you can imagine UI changes that accomplish the same thing in a better way; I'm using the 'price' field here so I can show how I think it should be modeled, not because I'm literally saying we should actually use the price field like this. The crux of the issue to me is that the "price" field in the stock ledger is doing two things, and *those two things are actually unrelated*: (1) It is used as part of the calculation of the debit or credit of the account on buy or sell transaction (and GnuCash is so ambivalent about its role here that we need to throw a sheet to ask the user for their intent almost any time it changes - the "Do you want to recalculate value, price, or number of shares?" question) (2) It is used to populate the Price Database for the security for that date, which is in turn used to calculate unrealized gains/losses. I've got no problem with using the market price for (2), and if we wanted to keep it in the register for that purpose but also have a cost column I think that would be fine (although probably confusing in a different way). It's (1) that is the real problem here. In practice, the "price" for this transaction is always going to be a constructed or inferred value (even if the user types it in!) in the face of the two objective facts that drive the transaction: the change in the number of shares owned, and the amount of currency spent or received for those shares. Without getting too bogged down in what the UI should look like, I'm saying how this is journaled should be driven by a third objective fact: the cost basis of the shares being sold. I definitely think other UI choices are possible that could get you to the same correct outcome. I think the desire driving the current way of doing things is that we want to have our cake (treat stock sales as just another journal entry just like
Re: [GNC] Mystery per-security Opening Balances accounts appearing
It looks like this issue was also raised (by someone other than me) on the GnuCash reddit: https://www.reddit.com/r/GnuCash/comments/m5fgk1/confused_about_opening_balance_still/ On Wed, Mar 17, 2021 at 1:00 PM peterb wrote: > I've been using Gnucash for well over a year and a half. Sometime within > the past few months, I have seen a number of completely empty Opening > Balances equity accounts opening themselves for certain securities that I > own. They are always denominated in the currency of the security; so for > example I have one right now: > [image: Screen Shot 2021-03-17 at 12.58.13 PM.png] > These accounts have no balance, no transactions in them, and *to the best > of my knowledge* have never had a transaction in them. > I have asset accounts for about 75 securities, but only see this for > around 10 of my securities. Most of them were acquired after starting to > use GnuCash, so the top-level Equity:Opening-Balances account would not > have been involved at all. > > (1) Has anyone else seen this? > (2) What gives? > > Thanks! > > Peter > ___ 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] Mystery per-security Opening Balances accounts appearing
I've been using Gnucash for well over a year and a half. Sometime within the past few months, I have seen a number of completely empty Opening Balances equity accounts opening themselves for certain securities that I own. They are always denominated in the currency of the security; so for example I have one right now: [image: Screen Shot 2021-03-17 at 12.58.13 PM.png] These accounts have no balance, no transactions in them, and *to the best of my knowledge* have never had a transaction in them. I have asset accounts for about 75 securities, but only see this for around 10 of my securities. Most of them were acquired after starting to use GnuCash, so the top-level Equity:Opening-Balances account would not have been involved at all. (1) Has anyone else seen this? (2) What gives? Thanks! Peter ___ 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] GnuCash Forum
There's also a Reddit for gnucash that sees at least some use: reddit.com/r/GnuCash On Wed, Jan 6, 2021 at 11:12 AM r0bis wrote: > Thanks David, > > Jumped in after a long time, in fact I was posting here for the first time > and I did not register the post date; sorry for this very belated reply. > You are right - common solutions do belong together in documentation and > howtos. I really like the readability of StackExchange, probably users > should also be encouraged to ask questions there, tagging them with > gnucash. > > https://money.stackexchange.com/questions/tagged/gnucash > > Best wishes, > > Robert > > > > -- > 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. > ___ 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] Linked document indicator not appearing.
OK, never mind - this was user error. I did not realize that "double line" was a separate item in the View menu, and as soon as I turned that on, I see the 'f' as expected. Thank you! On Wed, Jan 6, 2021 at 11:00 AM peterb wrote: > I'm on 10.15.2. > > Could I trouble someone for a screen shot of what this *should* look like? > Maybe I have arranged my columns in such a way that this isn't visible. > > And by "double-line view" you mean what the View menu calls the > "Transaction Journal", right? > > -Peter > > On Tue, Jan 5, 2021 at 11:47 AM John Ralls wrote: > >> >> >> > On Jan 5, 2021, at 6:24 AM, peterb wrote: >> > >> > I just linked a file to a transaction for the first time. The link is >> there >> > and seems to work mostly correctly (I can open it, and so on), but >> unlike >> > what the manual describes in Section 6.3, I see no "A" indicator in the >> > reconciliation cell. I am in the double-entry transaction journal view, >> as >> > required. Anyone else seeing this? >> > >> > I'm running GnuCash 4.2 (build 4.2+(2020-09-26), and have the register >> font >> > set to 24 pt arian narrow. >> >> It's not in the reconciliation cell, it's in the cell *under* the >> reconciliation cell in double-line view. >> >> Regards, >> John Ralls >> >> ___ 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] Linked document indicator not appearing.
I'm on 10.15.2. Could I trouble someone for a screen shot of what this *should* look like? Maybe I have arranged my columns in such a way that this isn't visible. And by "double-line view" you mean what the View menu calls the "Transaction Journal", right? -Peter On Tue, Jan 5, 2021 at 11:47 AM John Ralls wrote: > > > > On Jan 5, 2021, at 6:24 AM, peterb wrote: > > > > I just linked a file to a transaction for the first time. The link is > there > > and seems to work mostly correctly (I can open it, and so on), but unlike > > what the manual describes in Section 6.3, I see no "A" indicator in the > > reconciliation cell. I am in the double-entry transaction journal view, > as > > required. Anyone else seeing this? > > > > I'm running GnuCash 4.2 (build 4.2+(2020-09-26), and have the register > font > > set to 24 pt arian narrow. > > It's not in the reconciliation cell, it's in the cell *under* the > reconciliation cell in double-line view. > > Regards, > John Ralls > > ___ 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] Linked document indicator not appearing.
I just linked a file to a transaction for the first time. The link is there and seems to work mostly correctly (I can open it, and so on), but unlike what the manual describes in Section 6.3, I see no "A" indicator in the reconciliation cell. I am in the double-entry transaction journal view, as required. Anyone else seeing this? I'm running GnuCash 4.2 (build 4.2+(2020-09-26), and have the register font set to 24 pt arian narrow. Thanks, Peter ___ 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] Capital Gain Calculations on Split Stocks
My experience is that the View Lots cap gain method is tractable right up to the point where you have partial lots, and is not really usable (or, at least, I don't find it usable) afterwards. When I have a partial sale of a lot, I don't even try to use it. Just add a gain/loss transaction by hand with the numbers that you know are correct (since these numbers are coming from your broker and will be *what is reported to your tax authority, *they're the best source of truth; if your trial balance is off after that, double-check that your cost basis in GnuCash agrees with your broker's records). On Mon, Aug 24, 2020 at 9:41 PM David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi, > > In the last couple of days, I have learned TONS about how to manage > capital gains with assorted lots in the GnuCash realm. The financial > institution I use has algorithms that adjust my accounts to minimize tax > implications. This results in sales against specific lots within > GnuCash, and I've been able to match sales with specific lots and > achieve numbers in GnuCash which match the institution's calculations. > All good! > > However, I have one account with a single purchase, followed by a two > for one split, followed by a partial sale. Using the lots in this case, > however, yields wildly variant and incorrect results. In the attached > image, you can see the full transaction history, along with the lots > window indicating the assignment of the February sale to Lot 0 with a > loss of $169.96. > > This happens because 7*53.29 (the original share price) = $373.03, and > 203.07 - 373.03 = -169.96 > > If I choose to use Lot 2 for the match, the result is $203.07 gain > (7*0=$0 cost). This also is wrong. > > The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is > what the institution is reporting. I am hesitant to adjust the gain > value to match this amount, as I suspect that GnuCash will then report > the account as out of balance. I have seen in the past that incorrect > gains calculations can throw off the balance sheet, with painful > remedies and memories. My questions here are: > > 1) Is there a way to have GnuCash properly track cost basis in an > account with a stock split? > > 2) If I arbitrarily change the gains transaction, will subsequent > balance sheet numbers be in balance? > > 3) What is the proper way to handle a stock split? > > TIA, > > David T. > > ___ > 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.
Re: [GNC] Tracking cash flows with balanced transactions
Oh, I like that a lot, that's much more elegant than what I was experimenting with. Somehow it didn't occur to me that a zero-value split would still show up in the register...even though I've seen that happen when I've included one by accident. Thank you! -Peter On Thu, Aug 20, 2020 at 3:40 AM Geoff wrote: > Peter, this is the way that I do it, and it doesn't require double entry > of the transactions. > > Simply "tag" all dividend payments when they arrive in the bank account > with the relevant stock account - you do this by entering a third (zero > value) split. > > The dividend will then automatically show up in the stock's register. > > The "Advanced Portfolio" report will also automatically include the > dividend income as part of its return calculations. > > Hope this helps - please see the attached screenshot. > > Regards > > Geoff > = > P.S. This is mentioned in Chapter 9.8: > https://code.gnucash.org/docs/C/gnucash-guide/invest-dividends1.html > > On 20/08/2020 2:01 pm, peterb wrote: > > Let's say I have a security - could be a stock, or a bond - which > > periodically yields some dividend or interest. Often it's convenient to > be > > able to see those dividends in a single register. > > > > The vanilla way to account for dividends or interest doesn't quite make > > this easy: the obvious way to do it will appear in your brokerage > register, > > but not in the register for the stock. And that makes perfect sense - > the > > money isn't going in to your stock account! > > > > Description Account Debit Credit > > Dividend BIGCO Assets:Brokerage 50 > > Income:Dividend 50 > > > > If you're disciplined about your descriptions you can of course search > for > > these, but it feels potentially error prone when looking for them. > > > > I'm on record as not liking the way GnuCash handles realized income/loss > > from sales in stock accounts (putting "zero share" dollar values in the > > share-denominated register instead of explicitly treating stock sales as > > return-of-capital plus gain/loss) but it occurs to me that you can do > > something similar for dividends and interest: > > > > Description Account Debit Credit > > Dividend BIGCO Assets:Brokerage:BIGCO 50 > > Assets:Brokerage 50 > > Income:Dividend 50 > > Assets:Brokerage:BIGCO50 > > > > The idea here being: the income flows into the BIGCO-denominated account, > > but immediately flows out again into the cash-denominated account; if one > > looks at the BIGCO register, all of the dividend events will be clearly > > visible. > > > > Does anyone have either a more elegant way of accomplishing the goal of > > "all cash flows from a stock are visible on the stock's register", or a > > good reason *not* to do what I'm giving an example of here? > > (Alternatively, if this is in fact what everyone does as described in > > chapter 7853.633 of the user guide, and I just missed it, please let me > > know!) > > > > Thanks! > > > > -Peter > > ___ > > 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] Tracking cash flows with balanced transactions
Let's say I have a security - could be a stock, or a bond - which periodically yields some dividend or interest. Often it's convenient to be able to see those dividends in a single register. The vanilla way to account for dividends or interest doesn't quite make this easy: the obvious way to do it will appear in your brokerage register, but not in the register for the stock. And that makes perfect sense - the money isn't going in to your stock account! Description Account Debit Credit Dividend BIGCO Assets:Brokerage 50 Income:Dividend 50 If you're disciplined about your descriptions you can of course search for these, but it feels potentially error prone when looking for them. I'm on record as not liking the way GnuCash handles realized income/loss from sales in stock accounts (putting "zero share" dollar values in the share-denominated register instead of explicitly treating stock sales as return-of-capital plus gain/loss) but it occurs to me that you can do something similar for dividends and interest: Description Account Debit Credit Dividend BIGCO Assets:Brokerage:BIGCO 50 Assets:Brokerage 50 Income:Dividend 50 Assets:Brokerage:BIGCO50 The idea here being: the income flows into the BIGCO-denominated account, but immediately flows out again into the cash-denominated account; if one looks at the BIGCO register, all of the dividend events will be clearly visible. Does anyone have either a more elegant way of accomplishing the goal of "all cash flows from a stock are visible on the stock's register", or a good reason *not* to do what I'm giving an example of here? (Alternatively, if this is in fact what everyone does as described in chapter 7853.633 of the user guide, and I just missed it, please let me know!) Thanks! -Peter ___ 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] help increasing size of font in GnuCash?
I'm one of the people who doesn't have a problem modifying the font and font size by editing the GTK config file, but for what it's worth I agree that adding a menu pref for this would be a high-value item for most users. -Peter On Sat, Aug 15, 2020 at 8:47 AM Marilyn Graves Kimple via gnucash-user < gnucash-user@gnucash.org> wrote: > Amen. I appreciate all the help, and at one time I might have been able to > tackle it but at this point I give it a shot and then give up and recognize > that it is beyond me.**I agree that the best option > is to ask the developers nicely to include this feature in future releases. > Americans with Disabilities Act etc., and we thank you. > Best regards,Marilyn Graves Kimple -- > > > On Sat, 15 Aug 2020 nor wrote: > It is too complicated to modify gtk file for an accountant. I had > postedearlier on this subject as below,quote,At time register is to small > to view.Now that ver 4 series is developed, asetting in a menu to change > the fontswill be of great help for the peoplewith poor eye sight. Standard > Zoomin/out with control key +or- does notwork either.Appreciate > youradvise,Regards,norUnquote.Regards, > > ___ > 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.
Re: [GNC] Request for help with GnuCash 4.1
> On Fri, Aug 7, 2020 at 7:04 AM Fred Bone wrote: > On 04 August 2020 at 20:43, David Jaggar said: > > > Hello to Whom this concerns: > > > > I'm not quite sure if I am sending this request to the correct place. > > Anyway, I am wanting help with updating to the latest version 4.1 or even > > 4.0 since the problem shows up there also. When I down load the software > > on my computer using the very latest Windows 10 with upgrades, I get this > > error message: "Blocked because program could have harmed your device" or > > something to that effect. So I'm completely unable to upgrade Gnucash, > > seemingly because it is a problem with the software itself. > > > > Would you be willing to please advise, > > I believe the best solution is to upgrade to Linux (or buy a Mac). > This is really unhelpful. Can we not do this to people seeking assistance in good faith? David, in order to not trigger those warnings, the GnuCash project would presumably need to sign their binaries (I'm not familiar with Win10 signing, but I assume it's at least possible). A lot of open source projects don't do this. What GnuCash does do is release the SHA-256 hashes of the executable in the release notes (see, for example, this page: https://www.gnucash.org/news.phtml) If you're worried, you could calculate the hashes yourself using a downloadable problem on Windows or (what I'd do) use a service like onlinemd5.com (see here for instructions provided by a different project: https://www.openoffice.org/download/checksums.html). If the checksums match, then you have assurance that the file you got is the same as the one that the GnuCash project says they're providing, and then the only remaining question is "Do you trust them?" (Clearly, I do.) Hope that helps. -Peter ___ 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] $0 total balances wrongly appearing on Balance Sheet.
This theory makes intuitive sense to me, but wouldn't explain why the behavior would change based on the "levels of subaccounts" control on the report. Is there any reasonable way for me to determine if there is some fractional quantity left? (I'm still seeing '0' even after decreasing the fraction size to its smallest size.) On Mon, Jul 27, 2020 at 2:12 PM John Ralls wrote: > I'd go for the second. Account balances are on amounts (i.e. shares if > that's what the account commodity is) and AFAIK nothing in the account code > looks at split values. > > Regards, > John Ralls > > > > On Jul 27, 2020, at 10:24 AM, David Carlson > wrote: > > > > I am curious. Is it possible for this behavior to occur if > > > > 1) a commodity account has a balance of zero shares but a residual value > > because it has a unrealized gain or loss. > > > > 2) a commodity account actually has a tiny share balance or residual > value > > below the threshold visible at the account display resolution, likely due > > to rounding errors in transactions. > > > > David Carlson > > > > On Mon, Jul 27, 2020 at 12:12 PM Adrien Monteleone < > > adrien.montele...@lusfiber.net> wrote: > > > >> Sorry, the report appears to be working correctly for me on MacOS > >> (10.15.6) using GnuCash 4.1. > >> > >> The 1st option should be the only one you need to toggle the zero > >> balanced accounts from appearing. > >> > >> The 2nd option will remove just the zero figure but retain the account > >> name if the 1st option is checked. > >> > >> Let's use an example where 'Cash' has a 0.00 balance, > >> > >> > >> If you uncheck both options you'll see: > >> > >>Cash 0.00 > >> > >> If 1st option is unchecked, second option checked, you'll see: > >> > >>Cash > >> > >> If 1st option is checked, the second option is now irrelevant, and > >> you'll see nothing about 'Cash' at all. > >> > >> Or at least that is the way I think it is supposed to work. > >> > >> Regards, > >> Adrien > >> > >> On 7/27/20 11:01 AM, peterb wrote: > >>> I've encountered a bit of a Scooby Doo mystery, and I'm hoping someone > >> can > >>> help me figure it out. > >>> > >>> My Balance Sheet report consistently includes commodity accounts with 0 > >>> balance figures for me, even when I've unchecked "Include accounts with > >>> zero total balances." Trying to reproduce this with a brand-new book > for > >>> demo purposes doesn't show this behavior, so I'm left assuming there's > >>> something about my file that is odd. > >>> > >>> Specifically, there are two options under "Display" for Balance sheet, > to > >>> wit: > >>> > >>> • Include accounts with zero total balances > >>> • Omit zero balance figures > >>> > >>> I would expect that having the first option UN-checked and the second > >>> option checked would result in my stock accounts with 0 shares in them > >>> appearing; sadly, they're all over the report. > >>> > >>> In contrast, the "Balance Sheet using eguile-gnc" report has an option > >>> (under "Accounts", not "Display" this time) of "Exclude accounts with > >> zero > >>> total balances". Checking this option achieves what I'd consider the > >> right > >>> result - no zero balance values are shown. > >>> > >>> After further experimentation, there seems to be an interaction with > the > >>> "Levels of Subaccounts" control on the Accounts tab of the report > >> options. > >>> If I increase the levels of subaccounts accordingly, or flatten the > list > >> to > >>> the depth limit, the 0 balance figures don't appear - again, only (so > >> far) > >>> in this one file. > >>> > >>> So I have two workarounds to the problem (either using the eguile > report, > >>> or adjusting the depth limit/flattening options), but I am still > >> concerned > >>> that I don't understand why the behavior is happening in the first > place. > >>> > >>> My questions are: > >>> (1) Has anyone else seen this behavior? > >>> (2) If so, do you understand what's triggering it? >
[GNC] $0 total balances wrongly appearing on Balance Sheet.
I've encountered a bit of a Scooby Doo mystery, and I'm hoping someone can help me figure it out. My Balance Sheet report consistently includes commodity accounts with 0 balance figures for me, even when I've unchecked "Include accounts with zero total balances." Trying to reproduce this with a brand-new book for demo purposes doesn't show this behavior, so I'm left assuming there's something about my file that is odd. Specifically, there are two options under "Display" for Balance sheet, to wit: • Include accounts with zero total balances • Omit zero balance figures I would expect that having the first option UN-checked and the second option checked would result in my stock accounts with 0 shares in them appearing; sadly, they're all over the report. In contrast, the "Balance Sheet using eguile-gnc" report has an option (under "Accounts", not "Display" this time) of "Exclude accounts with zero total balances". Checking this option achieves what I'd consider the right result - no zero balance values are shown. After further experimentation, there seems to be an interaction with the "Levels of Subaccounts" control on the Accounts tab of the report options. If I increase the levels of subaccounts accordingly, or flatten the list to the depth limit, the 0 balance figures don't appear - again, only (so far) in this one file. So I have two workarounds to the problem (either using the eguile report, or adjusting the depth limit/flattening options), but I am still concerned that I don't understand why the behavior is happening in the first place. My questions are: (1) Has anyone else seen this behavior? (2) If so, do you understand what's triggering it? Thanks, Peter ___ 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] OFX setup
Hmmm, with respect, this doesn't seem like a helpful reply - I looked at the documents you referenced, and the questions Fleur is asking are not, in fact, answered in them. It could be that you're misunderstanding her questions, or it could be that both she and I are misreading the documentation. To take just one example, the question "Is BIC SWIFT the routing number for my US account?" isn't answered - the "Setting up OFX Connect" document is completely silent on that. The glossary has some things to say about BIC routing numbers, but even after reading it I'm completely unable to tell you whether that's the same routing number I see on my checks. And of course the fact that the debugging options seems to have produced no output is also concerning - if we on the mailing list are telling people asking for help "Generate a debug log" but the documentation about how to do that is incorrect, that's a failure on the part of the documentation. I do appreciate that you're trying to help, and clearly SOME people have had success getting OFX set up correctly, while others have not. Maybe the best way to cut this Gordian knot would be to create a documented example of creating the accounts by hand that jralls referenced in an earlier message, and get that put on the wiki. Thoughts? I don't know how to create those accounts by hand, since i've never done it, but I'm willing to be a guinea pig to try to follow instructions on doing it. -Peter On Mon, Jul 6, 2020 at 8:26 AM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Hi, > > IMHO most of your questions are answered in > https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect and > https://wiki.gnucash.org/wiki/Glossary > > HTH > Frank > > Am 06.07.20 um 13:33 schrieb Fleur Dragan: > > > > First I set: > > > > export GWEN_LOGLEVEL=debug > > export AQBANKING_LOGLEVEL=debug > > export AQOFX_LOG_COMM=1 > > export AQOFXCONNECT_LOGLEVEL=debug > > > > > > Then I ran, just to be safe: > > > > rm -rf ~/.aqbanking/ > > > > > > Then I ran: > > > > /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug 2>&1 | tee > gnc.out > > > > > > Once GnuCash started up, I tried to set up a user, which was > successful. Then I tried to retrieve accounts, which was also successful, > but no accounts were created in the aqbanking window. I tried to create an > account, but it's not clear what information each field wants, especially > since it's designed to be country agnostic. Is BIC SWIFT the routing > number for my US account? Is country "US" or "United States" or something > else? Bank Name? The one in www.ofxhome.com? The one on their > website? Can't get much more ambiguous than bank name. The look up bank > code doesn't appear to do anything, so I have no idea if the bank code is > the OFX FI, the routing number, or something else. There are enough > ambiguous fields, trying various combinations is prohibitive. If there is > documentation, in English (google translate will not understand subtleties > of BIC/IBAN/SWIFT/routing number), for setting up OFX accounts, I will > happily try again. > > > > There were no errors in /tmp/ofx.log. > > > > There don't seem to be any errors in the output, and nothing was in the > trace file, so I guess I read how to turn that on wrong. I've attached the > stdout/stderr output. Will the trace be helpful? If so, I'll go back and > to that. What else have I missed? > > > > > > > > thanks, > > fleur > > -- > > Fleur Dragan / fl...@obscure.org > > > > > > > > > >> On Jul 5, 2020, at 1:14 AM, Frank H. Ellenberger < > frank.h.ellenber...@gmail.com> wrote: > >> > >> Hi, > >> > >> Am 05.07.20 um 00:51 schrieb peterb: > >>> Fleur Dragan said: > >>> > >>>> So when I try to set up OFX connectivity, the user is created > >>>> successfully. Then I try to retrieve accounts, which do show up in > the log > >>>> window, and the log window says I may now close, but when I do, > nothing > >>>> happens. This was the same behavior I saw with aqbanking 6.1.4. > >>>> > >>> > >>> This was the exact same behavior I saw in 3.10. I haven't tried it > with > >>> 4.0 yet. The overall user impression was "Your login has succeeded! > >>> Nothing happens." > >>> > >>> -P > >> > >> just in case the one or other wants to dig deeper: > >> * https://wiki.gnucash.org/wiki/AqBanking#Debugging > >> * https://
Re: [GNC] OFX setup
Fleur Dragan said: > So when I try to set up OFX connectivity, the user is created > successfully. Then I try to retrieve accounts, which do show up in the log > window, and the log window says I may now close, but when I do, nothing > happens. This was the same behavior I saw with aqbanking 6.1.4. > This was the exact same behavior I saw in 3.10. I haven't tried it with 4.0 yet. The overall user impression was "Your login has succeeded! Nothing happens." -P On Sat, Jul 4, 2020 at 8:49 AM Fleur Dragan wrote: > Ah! My mistake! I had 3.10 and was checking against that. > > I just tried to set up an OFX account with 4.0, which is as you said > 6.2.1, but still am having no luck. > > So when I try to set up OFX connectivity, the user is created > successfully. Then I try to retrieve accounts, which do show up in the log > window, and the log window says I may now close, but when I do, nothing > happens. This was the same behavior I saw with aqbanking 6.1.4. > > The web page implies that aqbanking should be setting up the accounts it > finds for me when it retrieves them. Is that correct, or do I have to do > it myself? There aren't instructions for that that I have found. > > > thanks, > fleur > -- > Fleur Dragan / fl...@obscure.org > > > > > > On Jul 4, 2020, at 1:20 PM, Frank H. Ellenberger < > frank.h.ellenber...@gmail.com> wrote: > > > > Hello Fleur, > > > > Am 04.07.20 um 14:01 schrieb Fleur Dragan: > >> > >> Hey all, > >> > >> On https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect where it > says > >> > >>> AqBanking between 5.99.0 and 6.1.4 doesn't work with OFX DirectConnect. > >> > >> are those version numbers inclusive? > >> > >> If so, are there any plans to upgrade the version packaged with the > MacOS release (which is at 6.1.4)? > > > > no, 3.11 and 4.0 contain AqBanking 6.2.1 > > > >> thanks, > >> fleur > >> -- > >> Fleur Dragan / fl...@obscure.org > > > > Regards > > Frank > > > > ___ > 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.
Re: [GNC] Gnucash 4.0 doesn't launch on MacOS X 10.15.4
Agreed, it absolutely should. Alton's theory was that something about having both installed was confusing something. All I know if it didn't work until I deleted my old installation. On Mon, Jun 29, 2020 at 5:08 PM David H wrote: > Normally works for me just doing steps 4, 5, 6 :-) > > Cheers David H. > > > On Tue, 30 Jun 2020 at 06:42, peterb wrote: > >> I got this working thanks to some out-of-band advice from Alton Brantley >> (thanks!). We might consider documenting this if it happens to more >> people >> on Catalina besides him and me. >> >> (1) Save copy of file in 3.10. >> (2) Delete old copy of Gnucash from hard drive. >> (3) I deleted ~/Library/Application Support/GnuCash (probably unnecessary, >> but I was being paranoid). >> (4) Copy GnuCash 4.0 from disk image to /Applications >> (5) Double-click GnuCash 4.0 in /Applications. Choose "Open" when the OS >> asks you if you're sure you want to open. >> >> At that point, the app still doesn't seem to launch, though it should. >> However subsequent launches work as expected, so: >> >> (6) Double-click GnuCash 4.0 in /Applications again. >> >> At that point 4.0 launched and ran for me. >> >> -Peter >> >> >> On Mon, Jun 29, 2020 at 1:18 PM John Ralls wrote: >> >> > That's unfortunately a pretty common user experience on Mac. I haven't >> > been able to figure out where is the disconnect between Launch Services >> and >> > GnuCash after Gatekeeper verification is complete. Gatekeeper also >> fails to >> > remove the com.apple.quarantine xattr from the app bundle and that >> caused a >> > complete failure for one user last week, though it doesn't seem to >> affect >> > most users. >> > >> > Regards, >> > John Ralls >> > >> > >> > > On Jun 29, 2020, at 9:56 AM, w...@theprescotts.com wrote: >> > > >> > > Ditto on Mac OS 10.15.5. Opened without issues. >> > > The first time it asked for the standard permission to open since it >> > didn't come from the App Store. >> > > But it didn't open. >> > > Then I opened it again and it was fine. >> > > >> > > Will >> > > >> > > On 2020 Jun 29, at 06-29 11:08:57, Jean Laroche >> > wrote: >> > > >> > > I'm on 10.13.4 (High Sierra) and it launches without any problem. >> > > J >> > > >> > > On 6/29/20 7:58 AM, peterb wrote: >> > >> ...or at least, not on my instance of it. No particular user-visible >> > error >> > >> message, no splash screen visible, lots of stuff in the console. >> Happy >> > to >> > >> file a bug or share whatever data might help. >> > >> Is anyone else seeing this, or am I unique? >> > >> -P >> > >> ___ >> > >> 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. >> > > >> > > ___ >> > > 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 y
Re: [GNC] Gnucash 4.0 doesn't launch on MacOS X 10.15.4
I got this working thanks to some out-of-band advice from Alton Brantley (thanks!). We might consider documenting this if it happens to more people on Catalina besides him and me. (1) Save copy of file in 3.10. (2) Delete old copy of Gnucash from hard drive. (3) I deleted ~/Library/Application Support/GnuCash (probably unnecessary, but I was being paranoid). (4) Copy GnuCash 4.0 from disk image to /Applications (5) Double-click GnuCash 4.0 in /Applications. Choose "Open" when the OS asks you if you're sure you want to open. At that point, the app still doesn't seem to launch, though it should. However subsequent launches work as expected, so: (6) Double-click GnuCash 4.0 in /Applications again. At that point 4.0 launched and ran for me. -Peter On Mon, Jun 29, 2020 at 1:18 PM John Ralls wrote: > That's unfortunately a pretty common user experience on Mac. I haven't > been able to figure out where is the disconnect between Launch Services and > GnuCash after Gatekeeper verification is complete. Gatekeeper also fails to > remove the com.apple.quarantine xattr from the app bundle and that caused a > complete failure for one user last week, though it doesn't seem to affect > most users. > > Regards, > John Ralls > > > > On Jun 29, 2020, at 9:56 AM, w...@theprescotts.com wrote: > > > > Ditto on Mac OS 10.15.5. Opened without issues. > > The first time it asked for the standard permission to open since it > didn't come from the App Store. > > But it didn't open. > > Then I opened it again and it was fine. > > > > Will > > > > On 2020 Jun 29, at 06-29 11:08:57, Jean Laroche > wrote: > > > > I'm on 10.13.4 (High Sierra) and it launches without any problem. > > J > > > > On 6/29/20 7:58 AM, peterb wrote: > >> ...or at least, not on my instance of it. No particular user-visible > error > >> message, no splash screen visible, lots of stuff in the console. Happy > to > >> file a bug or share whatever data might help. > >> Is anyone else seeing this, or am I unique? > >> -P > >> ___ > >> 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. > > > > ___ > > 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. > ___ 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] Gnucash 4.0 doesn't launch on MacOS X 10.15.4
...or at least, not on my instance of it. No particular user-visible error message, no splash screen visible, lots of stuff in the console. Happy to file a bug or share whatever data might help. Is anyone else seeing this, or am I unique? -P ___ 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] Can Finance::Quote look up bond prices by CUSIP?
Closing the loop (and making this my last comment on the thread, since it's firmly not-gnucash), It looks like the closest thing that ever existed to an off-the-shelf solution for this is the fidelityfixed module for F::Q, which was intended to look up US bond prices (there's discussion of it on finance-quote-devel); sadly, as near as I can tell, Fidelity has since stopped providing the endpoint for this to the general public. I'll look into whether there's a reasonable way to get F::Q to log in to a Fidelity account to retrieve it, but that's clearly beyond the scope of this thread. Thanks for the suggestions, everyone! -p On Mon, Jun 8, 2020 at 5:35 PM John Ralls wrote: > After searching for a bit the only site I found that offers free bond > lookup by cusp at all is the empirasign.com that you found. > > On Jun 8, 2020, at 11:40 AM, peterb wrote: > > > > Following up on this: I definitely am unable to look up any bonds by > CUSIP > > at Alphavantage. I've spot-checked a number of the other sources listed > > via gnc-fq-dump and so far have had no luck, so I'd love it if someone > > knows what source to use. > > > > To give a specific example: 34540TWD0 is the cusip for a Ford Motor > Credit > > bond maturing in 2025 (you can look that up here: > > https://www.empirasign.com/findabond/34540TWD0/). But none of the > > Finance::Quote sources I've looked at so far can resolve that. Anyone > have > > any ideas? > > > > (This is clearly an issue with Finance::Quote and not GnuCash proper, but > > I'm hoping someone else has had this issue and found a solution!) > > > > -Peter > > > > On Thu, Jun 4, 2020 at 5:43 AM Chris Good wrote: > > > >> Message: 7 > >> Date: Wed, 3 Jun 2020 10:52:18 -0400 > >> From: peterb > >> To: gnucash-user@gnucash.org > >> Subject: [GNC] Can Finance::Quote look up bond prices by CUSIP? > >> Message-ID: > >>< > >> camvdbj7dlfyus+fjyz0n-9hygrr-zpsabptqnggybjzmbst...@mail.gmail.com> > >> Content-Type: text/plain; charset="UTF-8" > >> > >> Can Finance::Quote be used to look up bond prices? If so, how can I > >> configure the security in GnuCash to get this done? > >> > >> A related question is how can I use it to fetch currency prices. > >> > >> Thanks! > >> > >> -Peter > >> > >> Hi Peter, > >> > >> Yes to CUSIP. > >> Please see > >> > >> > https://wiki.gnucash.org/wiki/Online_Quotes#Finding_the_right_Source_and_Sym > >> bol > >> > >> If you have stocks in different currencies (I think this works by > checking > >> the currency of the parent account as stocks have their own > >> commodity/currency being the stock symbol usually), when you do 'Get > >> Quotes' > >> in the Price Database, GnuCash will also get any currency conversions > >> necessary, and they are visible in the Price Database window. > >> > >> See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts for > >> gnc-fq-dump commands for getting currency conversion rates. > >> > >> They is plenty of other info in the FAQ, see > >> https://wiki.gnucash.org/wiki/FAQ > >> > >> If you cannot get the prices or currency conversion rates you want, > please > >> tell us in this mailing list which specific stocks or currencies you are > >> after. > >> > >> Regards, Chris Good > >> > >> > > ___ > > 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.
Re: [GNC] Can Finance::Quote look up bond prices by CUSIP?
Following up on this: I definitely am unable to look up any bonds by CUSIP at Alphavantage. I've spot-checked a number of the other sources listed via gnc-fq-dump and so far have had no luck, so I'd love it if someone knows what source to use. To give a specific example: 34540TWD0 is the cusip for a Ford Motor Credit bond maturing in 2025 (you can look that up here: https://www.empirasign.com/findabond/34540TWD0/). But none of the Finance::Quote sources I've looked at so far can resolve that. Anyone have any ideas? (This is clearly an issue with Finance::Quote and not GnuCash proper, but I'm hoping someone else has had this issue and found a solution!) -Peter On Thu, Jun 4, 2020 at 5:43 AM Chris Good wrote: > Message: 7 > Date: Wed, 3 Jun 2020 10:52:18 -0400 > From: peterb > To: gnucash-user@gnucash.org > Subject: [GNC] Can Finance::Quote look up bond prices by CUSIP? > Message-ID: > < > camvdbj7dlfyus+fjyz0n-9hygrr-zpsabptqnggybjzmbst...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Can Finance::Quote be used to look up bond prices? If so, how can I > configure the security in GnuCash to get this done? > > A related question is how can I use it to fetch currency prices. > > Thanks! > > -Peter > > Hi Peter, > > Yes to CUSIP. > Please see > > https://wiki.gnucash.org/wiki/Online_Quotes#Finding_the_right_Source_and_Sym > bol > > If you have stocks in different currencies (I think this works by checking > the currency of the parent account as stocks have their own > commodity/currency being the stock symbol usually), when you do 'Get > Quotes' > in the Price Database, GnuCash will also get any currency conversions > necessary, and they are visible in the Price Database window. > > See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts for > gnc-fq-dump commands for getting currency conversion rates. > > They is plenty of other info in the FAQ, see > https://wiki.gnucash.org/wiki/FAQ > > If you cannot get the prices or currency conversion rates you want, please > tell us in this mailing list which specific stocks or currencies you are > after. > > Regards, Chris Good > > ___ 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] Can Finance::Quote look up bond prices by CUSIP?
Can Finance::Quote be used to look up bond prices? If so, how can I configure the security in GnuCash to get this done? A related question is how can I use it to fetch currency prices. Thanks! -Peter ___ 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] Reordering splits in a transaction
> > On 15 May 2020 at 9:03, peterb said: > > > * I have a recurring transaction with a very complicated split. At some *> > * point, the splits in the recurring transaction seem to have organized *> > * themselves in a confusing way - seemingly not related to the order in *> > * which I entered them. *> > > > * Is there any way to reorder splits within a transaction short of "Type * > > > * everything over again from top to bottom?" Is the (seeming) > self-ordering *> > * of the splits themselves inevitable, and if so, is there some underlying > *> > * principle by which they are arranging themselves? *> > > > * -P * I also have a recurring SX with multiple splits and messy > calculations (5 > parameters, 8 splits). The splits mostly show up in the same order > (modulo debits-before-credits) but not always. It seems the sort order is > nondeterminate. I don't regard it as important. Understood. The reason it matters to me is that my recurring transaction is _almost_ identical, but not exactly - several values tend to fluctuate by a few pennies every month. This means that I end up having to play hunt-the-split, whereas if the order was preserved I could use that to quickly zero in on the changed value. But it sounds like this is just the way the cards have been dealt, so maybe I'll file an enhancement request on the bug tracker and go on with my life. Thanks! ___ 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] Reordering splits in a transaction
I have a recurring transaction with a very complicated split. At some point, the splits in the recurring transaction seem to have organized themselves in a confusing way - seemingly not related to the order in which I entered them. Is there any way to reorder splits within a transaction short of "Type everything over again from top to bottom?" Is the (seeming) self-ordering of the splits themselves inevitable, and if so, is there some underlying principle by which they are arranging themselves? -P ___ 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.