[GNC] Check & Repair
Original Poster here. Running Gnucash Version: 5.6 / Build ID: 5.6+(2024-03-30) Windows 10.0.19045, Apologies for not including that info in earlier post. As has been noted, in the lower-right corner by the progress bar there is a vanishingly quick display of a message that flies by in a small fraction of a second and appears to display in a very small font. In other words, not terribly useful. I wonder if the fleeting message is retained in a log file. -Art- ___ 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] Check & Repair
I don't know whether the observed behavior (no feedback to user) is a bug or that the Check and Repair function is supposed to operate silently. I am hoping someone can clarify that. If I'm supposed to be getting some kind of report but I didn't get feedback, then it would seem to be a bug that I could report. In my opinion — and I am not a coder or designer of user experience — if the interface leaves the user scratching their head, it could be improved. But I understand if that is not a high-priority item on what I'm sure is a very long to-do list. Thank you. -Art- On Sun, Jul 21, 2024 at 8:39 PM flywire wrote: > Report a bug eg https://bugs.gnucash.org/show_bug.cgi?id=797711 > -- Art Chimes | Arlington, Virginia | 703·407·2306 | Google Voice 202·643·9638 ___ 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] Check & Repair
I've been having some reconciliation issues and thought the "check & repair" function might identify any possible problems. When I called that function from the "Actions" menu, nothing happened. Or at least, there was no indication visible onscreen that the account's transactions were being checked in any way. Maybe the checking happens behind the scenes, and the results are flagged only if there are any problems. Alternatively, maybe I'm not using this function correctly. Or maybe the fact that I pulled an older backup datafile to experiment with? Thanks in advance for any clarification. -Art- ___ 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] Selling security using specified (arbitrary) lots
I've searched and searched over the past couple of days, looking for some assistance in how to record a transaction in GnuCash. I hope I can find some answers here. Over a period of many years I acquired a significant number of shares in a company I'll call TechCo. I'm selling off some of the shares to avoid having an uncomfortable concentration of assets in that corporation. For (U.S.) tax purposes I specified to my broker specific lots to sell so as to minimize the capital gains hit. Most investors apparently use other conventions: FIFO (first in, first out), LIFO (last in ...) average basis. All are permissible. FIFO is apparently the GnuCash preference, since it seems to be the only one that will auto-generate a capital gains calculation. I have searched GC's documentation and the mailing list and, for good measure, Reddit and YouTube. However, I have not found an example or a clear description of how to get my transaction into the program. Thanks for any help you can offer. ___ 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] Ledger-CLI
Just today I first read about ledger-cli, a program that is apparently a full-featured, command-line based, double-entry system that has the added ability to read gnucash data files to create text-only reports, among other tricks. I was looking for an alternative to gnucash's ability to export data in csv format. I don't know that ledger would be a better choice for my occasional reports, in addition to those gnucash can generate natively, but it seemed worth investigating on a rainy day like today. Unfortunately, the current ledger-cli version no longer has the ability to read gnucash data files, and I could not find a usable binary for ledger v. 2.x, the last to support gnucash. (I think the source code is posted somewhere, but I've never built a binary from source and I'm kinda squeamish about doing so.) This leaves me with the following questions: 1. Where can a curious user find a Ledger 2.x binary, Windows or Linux (Ubuntu/Mint)? 2. Does anyone who has used Ledger, with or without Gnucash files, have anything to say about Ledger and whether they think it's worth looking into. Thanks and regards, Art ___ 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] Navigation through chart of accounts: shortcuts or bookmarks?
I've never numbered my accounts. This seems like a useful workaround for me. I'll try it. Thanks! On Fri, Dec 1, 2023 at 8:58 PM David Carlson wrote: > > I have assigned account numbers to the commonly used accounts so I can sort > by number and find the one I want quickly. > > On Fri, Dec 1, 2023, 7:15 PM R Losey wrote: >> >> On Fri, Dec 1, 2023 at 5:08 PM Art Chimes wrote: >> >> > I have a pretty large number of accounts, and there is name >> > duplication. For example, I might have a S 500 index fund in my >> > brokerage account and another one in a traditional IRA and maybe yet >> > another one in a trust account. My usual strategy is to open up the >> > Accounts tab and type <500>. That brings me to the first account with >> > "500" in its name. As far as I know, however, there is no magic way to >> > advance to the NEXT account with "500" in its name. Is there a way to >> > do that? >> > >> > Or are there a better ways (tips and tricks?) to quickly and >> > efficiently access an account that might be at the bottom of the list? >> > >> > Thanks for any helpful hints, and thanks also to the geniuses who keep >> > working on GnuCash! >> > >> > Art Chimes >> > GnuCash user since ~2019 >> > >> >> I don't know of a way to do this, but I give the accounts different names; >> using your situation above, I call the brokerage account that holds S 500 >> Index shares "BRK-S 500", and the IRA entry would be "IRA-S". I >> don't know if this helps on the account page or not. I never really use the >> account page in that way. A Roth fund with S 500 shares would be >> "Roth-S 500", to continue the examples. I don't know if this will help or >> not, but I provide it for what it's worth. >> >> >> _ >> Richard Losey >> rlo...@gmail.com >> Micah 6:8 >> ___ >> 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] Navigation through chart of accounts: shortcuts or bookmarks?
I have a pretty large number of accounts, and there is name duplication. For example, I might have a S 500 index fund in my brokerage account and another one in a traditional IRA and maybe yet another one in a trust account. My usual strategy is to open up the Accounts tab and type <500>. That brings me to the first account with "500" in its name. As far as I know, however, there is no magic way to advance to the NEXT account with "500" in its name. Is there a way to do that? Or are there a better ways (tips and tricks?) to quickly and efficiently access an account that might be at the bottom of the list? Thanks for any helpful hints, and thanks also to the geniuses who keep working on GnuCash! Art Chimes GnuCash user since ~2019 ___ 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] importing prices from csv
I well remember agonizing over this when I first set up price imports. There's a bit of a learning curve here. "Namespace" can be FUND (if it's a mutual fund), NYSE or NASDAQ or AMEX if it's a stock on the New York Stock Exchange, NASDAQ, or the American Stock Exchange, respectively. Most exchange-traded funds, or EFTs, are traded on AMEX, but there are exceptions. For example, there's an EFT (QQQM) that tracks the NASDAQ 100, and Gnucash wants the FUND namespace on that one. Good luck, and please post any further questions. Art ___ 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] Mutual Fund Class Conversion
In the past I've treated that as a stock split, adding or subtracting the number of shares that brings you to the new total. In the U.S. I believe a mutual fund conversion like this normally has no tax consequence. (Note: I'm not an expert, just a guy.) On Tue, Feb 15, 2022 at 7:19 PM Jack Frillman via gnucash-user wrote: > > How should I handle a "Mutual Fund Share Class Conversion". > > In my case I had the following transaction, see summary below, show up > in my broker account: > > (410.20900) shares of DF DENT MID CAP GROWTH FUND INSTL CL N/L (DFMGX) > converting to > 410.08500 shares of DF DENT MID CAP GROWTH FUND INSTL PLUS CL N/L (DFMLX) > > No price or $ amount is associated with this transaction. > The only things that changed are 1) ticker symbol, 2) name of Mutual > Fund, 3) number of shares. > > Not sure what to do. > > Any suggestion will be greatly appreciated. > Thanks. > Jack ___ 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] Possible to display two account registers on
I don't understand the "with Page" phrase. What does that mean? The suggestion of changing the default behavior to ALWAYS open a new window would seem to result in quite a bit of desktop clutter, at least for me. In nearly all cases in the three years I've been using Gnucash, having all accounts open in one window is definitely preferable, but good to know it's an option for those who need/want it. On Fri, Feb 4, 2022 at 4:26 PM Ken Pyzik wrote: > > Using windows 11 (and probably 10) ver. 4.9, in the top menu there is an menu > called WINDOWS. If you click on that menu and click the New Window with page > option -- you will get two windows for the same account. This will get you > the desired results I believe you want. > > Cheers! -- Ken > > -Original Message- > From: gnucash-user On > Behalf Of Stan Brown > Sent: Friday, February 4, 2022 12:18 PM > To: 'gnucash-user' > Cc: Kalpesh Patel > Subject: Re: [GNC] Possible to display two account registers on > > > On 2022-02-04 10:29, Kalpesh Patel wrote: > > In Windows 10 (and probably all other host OSes?), if you double click > > on any account in the Accounts Page window (windows that opens when > > GNC is launched) then it will open a new floating window for that > > specific account > > That may have been added in a later GC version, but for me when I > double-click on an account in the Accounts page that account's register opens > in a new tab in the same window as the Accounts page. I don't find any > selection for that behavior in Preferences. > > Yes, I'm running GC in Windows 10. > > -- > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ > 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] Possible to display two account registers on screen?
Thanks to Stan, Dan, and Liz for the suggestions. I'm going to play around with these tomorrow, but I have to say that I always like to find "lesser-known features," so I'll probably try Stan's first. I failed to specify my OS (Window 10) and GnuCash version (4.9), for which I apologize. I'm assuming that Liz is suggesting that I open the *.gnucash file (open with > gnucash) to get the second instance of the program running. Let me know if that's not right. Thanks again, Art On Thu, Feb 3, 2022 at 5:23 PM Stan Brown wrote: > > On 2022-02-03 14:02, Art Chimes wrote: > > I'm trying to clean up some issues with an import-gone-bad which left > > me with two accounts for the same mutual fund. There are, I think, > > some duplicate transactions and others that appear in only one of the > > two accounts, and I want to consolidate this. It will simplify matters > > and speed up the process if I can see both accounts side by side. I > > know I can print up a transaction report, and use that as a reference, > > but is it possible to display the two accounts — GnuFund GNUFX and > > GnuFund GNUCX — on screen? > > > > If not, is it a feature GnuCash should have or is it just me? > > Hi, Art! > > One of GnuCash's lesser-known features makes it easy to do what you > want. And you don't have to open the data file twice. > > Bring up one of the two registers, then click Window » New Window with > Page. That register will be moved to a "floating" window separate from > the main GC window. Then you can bring up the other register in the main > GC window. > > You can edit either register, but don't try to edit one register while > there's an incomplete transaction in the other register. > > -- > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > --- Art Chimes 1117-B North Stuart St Arlington, Va. 22201 703-407-2306 (c) ___ 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] Possible to display two account registers on screen?
I'm trying to clean up some issues with an import-gone-bad which left me with two accounts for the same mutual fund. There are, I think, some duplicate transactions and others that appear in only one of the two accounts, and I want to consolidate this. It will simplify matters and speed up the process if I can see both accounts side by side. I know I can print up a transaction report, and use that as a reference, but is it possible to display the two accounts — GnuFund GNUFX and GnuFund GNUCX — on screen? If not, is it a feature GnuCash should have or is it just me? Thank you ___ 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] Short-Term Capital Gains question - Entering Mutual Fund or EFT Distribution
Most of my mutual funds and exchange-traded funds distribute earnings in three categories — dividends, short-term capital gains, and long-term capital gains. In the U.S., LTCG are profits from the sale of securities one year or more after purchase, and they are taxed at a favorable rate. STCG are profits from securities held for a shorter period of time, and they are taxed (usually? always?) at the higher ordinary income rate — same as salary or dividends. Statements from brokers and mutual fund companies carefully assign distributions to one of these three categories. This confuses many people because for tax purposes the STCG amounts are lumped in with dividends on Schedule B, as opposed to Schedule D, where LTCG (frequently referred to as just plain "capital gains") are reported. There may be exceptions; I don't know. Since STCG are combined with dividends at tax-reporting time, is there any need to use a STCG-only Income account in Gnucash, or can one safely put dividends and short-term capital gains in the same "dividend" income account? I suppose it might be considered poor accounting practice, but I'm asking as a non-professional who just uses this software to keep track of my personal finances and help me at tax time, which is fast-approaching. If there is a reason to maintain a separate STCG income accounts, please enlighten me as to why and when it would be helpful. If it matters, I use GnuCash 4.9 on Windows 10 Home. Thanks to all in the GnuCash community ~Art~ ___ 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 Flatpak on GalliumOS Linux
Geert. It has persisted so far. Thanks again, Art On Tue, Aug 25, 2020 at 8:59 AM Geert Janssens wrote: > > It should be a persistent setting. > > Regards, > > Geert -- Art Chimes 1117-B N. Stuart St. Arlington, Va. 22201 ___ 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 Flatpak on GalliumOS Linux
Thanks, Frank. This — sudo flatpak override org.gnucash.GnuCash --filesystem= — worked like a charm. The embarrassing thing is that, in searching for a solution, I actually looked at that page, but it didn't register that the flatpak sandboxing was my problem. Duh! Do I have to rerun that override command each time I start GnuCash? After a reboot? Or is it a persistent setting? On Mon, Aug 24, 2020 at 3:07 PM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Art, > did you see > https://wiki.gnucash.org/wiki/Flatpak#Granting_Access_to_Other_Resources > HTH > Frank > > Am 24.08.20 um 19:46 schrieb Art Chimes: > > Anyone have any experience with GnuCash installed via Flatpak on > > GalliumOS? (It's a niche distro designed to turn a Chromebook into a > > Linux machine.) > > > > I installed GC 4.1 and it runs fine ... except that it doesn't > > recognize the USB drive where I my data file lives. The USB drive and > > the data file, which I copied over from a working GnuCash installation > > on a Windows machine, show up fine in Thunar (Linux) file manager and > > via terminal CLI. The "open file" dialog format looks like GnuCash's, > > not like something I've seen on my Gallium machine. > > > > If I copy the data file to a location that shows up in the open-file > > dialog (e.g. Desktop) it loads fine. > > > > Any ideas how I can remove the USB drive's cloak of invisibility from > > the open-file dialog? > > > > Thanks, Art > > > > PS - I also posted my query in the GalliumOS subreddit, in case > > someone there has a solution. > > ___ 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 Flatpak on GalliumOS Linux
Anyone have any experience with GnuCash installed via Flatpak on GalliumOS? (It's a niche distro designed to turn a Chromebook into a Linux machine.) I installed GC 4.1 and it runs fine ... except that it doesn't recognize the USB drive where I my data file lives. The USB drive and the data file, which I copied over from a working GnuCash installation on a Windows machine, show up fine in Thunar (Linux) file manager and via terminal CLI. The "open file" dialog format looks like GnuCash's, not like something I've seen on my Gallium machine. If I copy the data file to a location that shows up in the open-file dialog (e.g. Desktop) it loads fine. Any ideas how I can remove the USB drive's cloak of invisibility from the open-file dialog? Thanks, Art PS - I also posted my query in the GalliumOS subreddit, in case someone there has a solution. ___ 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] Latest Update
Greg Feneis wrote (Date: Tue, 4 Aug 2020 06:50:30 -0700) ... "I'm still on 2.6.21 "I had trouble updating to 3.x, so I gave up. I think the big reasons users should keep updated is to clear up a bug they're facing, or if they have a question about how to do something, it's handy to be asking for help with a recent version. "So far, I've been pretty lucky with the end of the 2.6 series." == I upgraded in recent weeks from 3.x to 4.0 and then to 4.1. I had zero problems installing the new versions (although the upgrade seems to have lost my saved filter (or whatever it's called) in a csv price import). I did get a Windows Defender warming during the install process. I ignored it, and that was that. There's no way of knowing (that I know of) how many users upgrade without issue, but I'm confident that the vast majority of upgraders do so successfully. -Art- ___ 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] Mising CSV price import saved setting
Every Friday I download from Yahoo the closing prices of my mutual funds, etc., from Yahoo. I have been doing this for more than 16 years, going back to my days using Quicken to keep track of securities. (For purposes of this query I won't mention who 2000 Quicken Basic stacks up against GnuCash in tracking stock/fund lots. Maybe later.) Anyway, the export CSV needs a little massaging but it only takes a minute, and then I uploaded it to Gnucash. Until this week, after I upgraded to ver. 4.1. As of today the "File > Import > Import Prices from a CSV file" widget has forgotten the settings I had saved and used to streamline the import process. Is this a bug? Am I committing the dreaded user error? None of the above? Thanks in advance, Art in pandemic-stricken, leaderless America ___ 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] Reconcile also opens Interest Payment box?
I have a scheduled transaction set up for autopay on my credit card accounts; all I have to do is fill in the amount, so I don't need the annoying (albeit not life-threatening) popup. And I pay my credit card bills in full every month; I don't know when I last paid interest, so that popup is also superfluous, at least for me. Decades ago, my mother — a one-time bookkeeper, back in the days of paper ledgers and Bic Accountant extra-fine point pens (or maybe even the fountain pen equivalent) — stressed the importance of reconciling my checkbook, and I do so religiously, if not always with immediate success, still. I even occasionally reconcile my brokerage account to make sure my GnuCash has the same number of shares as they do. So please, do not get rid of reconciliation. I would probably have to go back to Quicken. Thanks, Art ___ 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 - user: Google result
For What It's Worth Dept: Although I use "google" as a verb all the time, in fact my default search tool is the more privacy-centered DuckDuckGo (https://duckduckgo.com). My search for gnucash forums (just the two words, no quotes) came up with rather different results. Here are the top five https://wiki.gnucash.org/wiki/Getting_Help https://gnucash.org https://www.accountantforums.com/threads/gnucash.38936/ https://lists.gnucash.org/mailman/listinfo/gnucash-user https://ubuntuforums.org/showthread.php?t=1750837 I scrolled down several screens and encountered more links to gnucash.org and other reasonably legit sites, but no hits at all on nabble, though it possibly showed up farther down the list. Art in Arlington, Virginia ___ 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] Keyboard shortcut (or icon) to jump to COA
I usually have a dozen or more accounts open, and I frequently need to get back to the Chart of Accounts tab. It would be convenient to have an icon above the tabs — what is that row of icons called? — that I could just click on or a keyboard shortcut to get me instantly to the COA tab. In other words, I am looking for the same result as right-clicking an open tab and selecting "Accounts" at the top of the list, just a little easier, for me anyway. I searched without success for a solution. I did look at the accelerator-map file but couldn't find a solution there. (There may be one, but I don't know which line to edit, let alone how to do so.) Thanks, Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report seems to pull wrong amount from transaction
The report started out as a blank transaction report (from the Reports>Transaction Report menu pulldown), which I then modified as required. Does that qualify as a "custom report"? I never heard of trading accounts, but from what I just read in the wiki, it seems to relate to multi-currency books, and all I have is USD transactions, so that feature is not turned on. The Price Database has picked up some price points from transactions, but seems to be hit-or-miss, and it may depend on the security. If it's important I can analyze this a bit more. Art Adrien Monteleone adrien.monteleone at lusfiber.net Wed May 13 14:49:51 EDT 2020 Art, you’re welcome and I’m fine with just list messages. I’m glad you got it resolved. (just curious, is this a custom report?) The price db *should* get a ’transaction’ type entry for every such buy/sell transaction. You might need to have trading accounts turned on for that, I’m not certain. If you already do, then, you might have a bug. I track some metal holdings and while I don’t do trades often, I have transaction type entries in my price db. I haven’t done any transactions since probably v3.5 or so. Maybe there is a code regression since then. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report seems to pull wrong amount from transaction
I think D. wins this round. Not exactly the right answer, but close enough that it pointed me to the explanation. I hope you'll forgive the longish explanation that follows. My report apparently uses the number of shares x the price per share to compute the dollar amount. Possibly the dollar value of the transaction is not stored in the user's data file but rather is computed on the fly? The incorrect dollar figure in the report was the product of the correct number of shares times an incorrect share price. But the share price in the account register is correct. So where is the incorrect share price coming from? The account from which the withdrawal was made is not a publicly traded fund but is a pension plan, so there is no way (that I know if) to retrieve the share price automagically. By force of habit, from my Quicken days, I enter each week's closing share prices into the Price Database. So Jan. 24 and 31, Fridays, are in there, but not the day of this transaction (Wednesday, Jan 29). That's a bit of a puzzle. I though that if I entered a transaction into an account register, it would appear in the Price Database. Maybe because I didn't enter the price manually and it was computed from the dollar value and number of shares that I did enter? Anyway, there was no entry for for Jan. 29. Anyway, I quickly determined that the incorrect dollar amount entered was the result of multiplying the number of shares times the share price on Jan 31 — the closest date in the Price Database. I manually added the correct share price for Jan. 29. And now the report has the correct dollar amounts. Problem solved. But I wonder if I should file an enhancement request that reports using a calculated value based on a close but not exact share price should be flagged (with an asterisk and footnote?) as questionable. Thanks all who chipped in to help solve this mystery Great community here! Art -- Forwarded message -- From: "D." To: Art Chimes Cc: gnucash-user@gnucash.org, Adrien Monteleone Bcc: Date: Wed, 13 May 2020 08:14:40 +0530 Subject: Re: [GNC] Report seems to pull wrong amount from transaction I'd look at the price source used in the report (on the report options). It sounds to me like the report is converting the January shares sold at the February/March price. Original Message ---- From: Art Chimes Sent: Wed May 13 01:57:24 GMT+05:30 2020 To: Gnucash Users , Adrien Monteleone Subject: Re: [GNC] Report seems to pull wrong amount from transaction Adrien's quick reply is below (edited) with my responses. = My first inklings would be to ask: 1. Do these transactions involve other currencies? ===No, all in USD 2. Are they part of a bill/invoice that has a tax applied to a line item using the business tax tables? ===No, strictly personal account. 3. Do the specific transactions (when showing all splits) show the amount for that account as exactly $150 or $146? If the latter, what split(s) appear to balance out the $4 difference? ===That was the first think I looked at. All three transactions in my register are structured identically, but the January split is different than the two others, which are the same. (I made up the numbers, so I hope everything balances. It does in my actual account.) January transaction Assets:Checking buy 118.66 [net deposited in my checking account] Expense:Withholding tax buy 31.34 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Jan. shows on the Report as 146, NOT consistent with register))) February and March transaction Assets:Checking buy 107.45 [net deposited in my checking account] Expense:Withholding tax buy 42.55 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Both Feb. and Mar. show on the Report as 150, consistent with register))) 4. Is your account selection in the Report Options limited to that one account? Are you reporting on the account for the financial institution, where the funds come from, or from the target account where the funds land? ===Account selection in Report Options is limited to one account, the one from which the funds are taken. All three transactions involved the same dollar value (though the number of shares of the mutual fund were different). The full amount was paid out of the account (no fee charged) and received into my checking account after tax withholding was deducted. One other thing of possible relevance. I mentioned that the linked amounts in the report took me to the right account but not to the specific transaction. Now, the links go right to the corresponding transaction. I changed up a couple of things in the report (currency options), then went back to the previous options, and somehow that fixed it. Thanks for your efforts to troubleshoot this puzzling (to me) behavior! Art On Tue, May 12, 2020 at 12:29 PM Art Chimes wrote: >
Re: [GNC] Report seems to pull wrong amount from transaction
Adrien's quick reply is below (edited) with my responses. = My first inklings would be to ask: 1. Do these transactions involve other currencies? ===No, all in USD 2. Are they part of a bill/invoice that has a tax applied to a line item using the business tax tables? ===No, strictly personal account. 3. Do the specific transactions (when showing all splits) show the amount for that account as exactly $150 or $146? If the latter, what split(s) appear to balance out the $4 difference? ===That was the first think I looked at. All three transactions in my register are structured identically, but the January split is different than the two others, which are the same. (I made up the numbers, so I hope everything balances. It does in my actual account.) January transaction Assets:Checking buy 118.66 [net deposited in my checking account] Expense:Withholding tax buy 31.34 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Jan. shows on the Report as 146, NOT consistent with register))) February and March transaction Assets:Checking buy 107.45 [net deposited in my checking account] Expense:Withholding tax buy 42.55 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Both Feb. and Mar. show on the Report as 150, consistent with register))) 4. Is your account selection in the Report Options limited to that one account? Are you reporting on the account for the financial institution, where the funds come from, or from the target account where the funds land? ===Account selection in Report Options is limited to one account, the one from which the funds are taken. All three transactions involved the same dollar value (though the number of shares of the mutual fund were different). The full amount was paid out of the account (no fee charged) and received into my checking account after tax withholding was deducted. One other thing of possible relevance. I mentioned that the linked amounts in the report took me to the right account but not to the specific transaction. Now, the links go right to the corresponding transaction. I changed up a couple of things in the report (currency options), then went back to the previous options, and somehow that fixed it. Thanks for your efforts to troubleshoot this puzzling (to me) behavior! Art On Tue, May 12, 2020 at 12:29 PM Art Chimes wrote: > > This seems like a bug to me, but maybe I'm missing something. > > I have an account from which I have a regular, automatic withdrawal > scheduled with the financial institution. The amount is the same every > month, let's say $150. > > My YTD report shows this year's three withdrawals to date (plus > another transaction, unrelated to the automatic ones). However, the > January withdrawal on the report shows an incorrect amount, a few > dollars less, $146. > > All three accounts were subject to tax withholding. The January > withholding was different than the later withdrawals, but otherwise > the amount withdrawn from the account was the same in all monthly > withdrawals, i.e. $150. > > A possible clue: When I click on the hyperlinked amount in the report, > it links to the correct account but not to the specific transactions. > (In other reports I spot-checked, it takes me directly to the > transaction.) > > I could not reproduce this error in a few other random reports I generated. > > Can you help? Thanks. > > Art -- Art Chimes 1117-B N. Stuart St. Arlington, Va. 22201 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report seems to pull wrong amount from transaction (errata #2)
Make that GnuCash **3.10** on Windows 10. Sorry: lousy typist worse proofreader ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report seems to pull wrong amount from transaction (errata)
I'm using GnuCash 3.1 on Windows 10. Sorry for my violation of a cardinal rule of posting here. Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report seems to pull wrong amount from transaction
This seems like a bug to me, but maybe I'm missing something. I have an account from which I have a regular, automatic withdrawal scheduled with the financial institution. The amount is the same every month, let's say $150. My YTD report shows this year's three withdrawals to date (plus another transaction, unrelated to the automatic ones). However, the January withdrawal on the report shows an incorrect amount, a few dollars less, $146. All three accounts were subject to tax withholding. The January withholding was different than the later withdrawals, but otherwise the amount withdrawn from the account was the same in all monthly withdrawals, i.e. $150. A possible clue: When I click on the hyperlinked amount in the report, it links to the correct account but not to the specific transactions. (In other reports I spot-checked, it takes me directly to the transaction.) I could not reproduce this error in a few other random reports I generated. Can you help? Thanks. Art ___ 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] Strange reconciliation behavior
Strange to me, anyway. I have a long-closed U.S. mutual fund account (call it ABCDX) that was never reconciled since I started using GnuCash a year ago. Now I want to reconcile it, and I'm tackling it year-by-year. I reconciled the first year closing balance, 5,898.936 shares, without issue. Problems arose when I tried to reconcile the second year. I entered the statement date and the number of shares shown on the statement as of that date. The "Reconcile Information" box correctly shows the Starting Balance as 5,898.936 ABCDX shares. I clicked OK and the reconciliation window popped up. To my surprise, the info box in the lower right corner now shows the Starting Balance as 0 shares ABCDX, as if the first year's transactions were never reconciled. As a result I cannot reconcile this account. I am using GC 3.9 on Windows 10. I searched unsuccessfully in the usual places for an answer; my apologies if I missed it. Thank you all. Art ___ 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] How to change MANY Deposits to Withdrawals? (Import error)
Or perhaps next time do a test run of a handful of the transactions to be imported before running the whole batch? -Art- From: Michael or Penny Novack To: gnucash-user@gnucash.org Cc: Bcc: Date: Sun, 16 Feb 2020 14:31:01 -0500 Subject: Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error) On 2/16/2020 11:28 AM, Fran_3 via gnucash-user wrote: > I imported a big bunch of checking transactions and guess I got the Deposit & > Withdrawal columns labeled wrong during the import process. > Is there any way to select a bunch of checking transactions and change > Deposits to Withdrawals? > Thanks for any help. Horse and barn doors, but this is worth pointing out. Take checkpoints. In other words, before doing a large import of data, make a backup copy of the file. Then, as in a case like this, you can easily back out the faulty import. 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.
[GNC] Non-cash charity contributions
In the US at least, many donations of stuff — other than money — to charities is tax-deductible. This includes furniture to the Salvation Army, canned goods to a food pantry, books to your public library's annual sale, plumbing supplies to Habitat for Humanity, etc. There are various limitations, but let's assume we're talking about qualified donations. My question is, how best to record these in Gnucash. I have an expense account called "charity:non-cash contributions" where I record these (potentally tax-deductible) donations, but I don't know how best to record the other side of the transaction. As a placeholder, I am using "Orphan-USD" as the source. Is there a better way. Note: I do not want to be tracking the purchase cost of every item I donate, and don't want to muck about in the pond of depreciation either. But I can't imagine I'm the only person who has wondered about this. Thanks, Art ___ 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] How to enter a corporate acquision?
A few years ago I bought shares in a small bank ("LocalBank"). A couple of years later, it was bought by a big bank ("MegaBank"). My original shares in LocalBank were traded in for a smaller number of shares in MegaBank, plus a few dollars cash in lieu of. The closest I found in the documentation is the Stock Split tool, which is supposed to also handle mergers but that latter function is scarcely documented. (The documentation shows you how to reduce the number of shares of the original holding but not how to establish the position in the new holding, at least as far as I understand. Entering a negative number of shares for a "merger" seems to result in a "reverse split," when the share price is increased as the number of share outstanding, or in a given investor's portfolio, is decreased proportionally. I'm using US terminology, and maybe in the Commonwealth or elsewhere the term "merger" is correct. https://www.gnucash.org/viewdoc.phtml?rev=3=C=help) In any event, my use case is a corporate acquision more than a merger, though I think the principle would be the same. I could kluge something together, but I'd rather not reinvent the wheel. And anyway, there must actually be a right way to handle this sort of acquisition? These days on Wall Street it can't be a very unusual occurrence. Art ___ 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] Last month's transactions included in Reconciliation Report
Thanks for the responses. Adrien asks, "why are you wanting this report?" Partly it's about having another piece of a paper trail, but mainly because it's what I've been doing in Quicken for a couple of decades. To be clear, this is just about my personal finances: checking account, credit cards, and so on. Nothing that will be audited, nor likely requested by an accountant. What I am used to seeing in a reconciliation report is (a) a list of cleared transactions for the period covered by the current statement, the one I have just reconciled; and (b) a list of transactions that remain uncleared after the reconciliation process; and (c) various totals and summaries. Item (b) would ideally consist of transactions since the statement closed, an uncashed check I wrote two months ago, etc. When I specify a date range, Gnucash wants to look at both the transaction date AND the reconciliation date. So I am getting two months' transactions in the report, one of which is just clutter and will duplicate the prior month's reconciliation report. If my latest statement includes 15 transactions between July 1 and July 31, when it closes, that time period will include the day (e.g. July 3) that I reconcile the June statement. But the June transactions are history; they have no business in the July reconciliation report. I'm not an accountant for sure, but if there is a reason for including in the report the June transactions *reconciled* in July along with the actual July transactions, I don't see it. The suggestion that I filter for a date range (e.g. July 1-31) and for reconciled transactions, then generate an Account Report would give me a list of current reconciled transactions, but not the unreconciled ones. (Yes, I could generate a separate report with a filter, but that is an inelegant workaround, in my opinion.) Regarding Christopher's reference to "standard accounting practice," I want to emphasize that I don't know what is standard, just what seems logical, familiar, and useful to me. Nevertheless, I am going to follow his suggestion and file a bug report suggesting an Enhancement to the reconciliation report dialog. Thanks, Art ___ 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] Last month's transactions included in Reconciliation Report
I want to produce a Reconciliation Report for a credit card account. I set the date range to correspond to the period covered by the statement. What I get, however, is a report that includes all of last month's transactions. This is apparently because those transactions were *reconciled* within the selected date range. Maybe this is standard accounting practice. I'm just a migrating Quicken user, so I'm pretty sure my knowledge of such things is quite limited. But it does seem illogical and distracting to have all these irrelevant (to me) transactions on screen/paper. Is there an option I'm missing? (The old transactions appear even though I did not check the box to display reconciliation date.) Should I report this as a bug? (This may be related to Bug 796614, which has supposedly been addressed.) Thanks in advance, Art ___ 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] Import Price from CSV Bug? (Robin Chattopadhyay)
I have a similar experience since moving to ver. 3.6 on Windows 10. In the past I have had no issues importing, unchanged, a csv file downloaded from Yahoo Finance. There are columns for "Symbol,Current Price,Date" plus some other unneeded ones for High,Low,Volume, etc. It takes just moments to assign those columns in the price import tool, and add USD as my currency. Done. (Even quicker if I save the configuration, which I did just in time for the new Namespace requirement to undo my time-saving efforts.) No Namespace info was requested or needed. The example on the opening screen of the import tool suggests that "Namespace" refers to the type of security: FUND (mutual fund), NYSE (stock traded on the New York exchange), etc. I did some trial-and-error and also AMEX is the Namespace for ETF securities. These entries seem to be case-sensitive, and the Namespace for a given symbol seemingly must match the "Type" entered when you first created the security, or edited it. (Confusingly, the same information — FUND, NASDAQ, etc — is called "Type" in the security record but is called "Namespace" in the price-import tool, at least in 3.6 on Win 10.) Why is this change necessary? Was there an issue for some users? I had no problems before Namespace was introduced? Will the program remember my Namespace selection, or will have have to manually edit the csv file each week, when I update my prices? Can anyone find where the procedure is documented? Thank you, Art > -- Forwarded message -- > From: Robin Chattopadhyay > To: gnucash-user@gnucash.org > Cc: > Bcc: > Date: Thu, 4 Jul 2019 12:52:21 -0500 > Subject: [GNC] Import Price from CSV Bug? > Hi all- > > I have been using the Import Price from CSV function successfully up > through and including v3.5 (both Ubuntu 18.04 and Linux Mint 19). > > I have set my input file/mapping to: > >- CUSIP --> Commodity From >- Shares --> None >- Market Value --> None >- Price --> Amount >- Date --> Date >- Commodity From --> {blank} >- Currency To --> USD > > After upgrading to 3.6, the saved mapping looks like this: > >- CUSIP --> None >- Shares --> None >- Market Value --> Amount >- Price --> Date >- Date --> None >- Commodity From --> {blank} >- Currency To --> USD > > In addition, after re-setting the mapping, I am still left with an error > message: "Please select a 'From Namespace' column or set a Commodity in the > 'Commodity From' field." > > I didn't see anything in the Release Notes that jumped out as being > relevant, so I'm not sure how to proceed here. I can update the CSV as I am > creating it using a bash script to extract from the OFX file from my > financial institution, but - again - not sure what to update it to. > > I really value the CSV price import because none of the assets in this file > are publicly available. > > Thanks, > Robin ___ 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] Need better documentation - and maybe more robust functionality - on using Lots
I'm sort-of hijacking an old subject line rather than its thread, but here's what I've been perusing the past hour or so: https://lists.gnucash.org/pipermail/gnucash-user/2015-September/061855.html I started buying shares of a company (let's say GE) 20+ years ago, at first in their DRIP plan, which was the only way I could do dollar-cost averaging purchases ($200 a month) and also reinvesting quarterly dividends. The downside is that over time, you end up with a lot of transactions and significant bookkeeping overhead. But that's what computers are for, right? At one point I sold 300 shares. To reduce the capital gains tax on this transaction, I specified to my broker the shares to be sold. Specifically, the ones with the highest basis, to minimize the taxable gain. For U.S. taxpayers, that's one of several ways you can calculate gain when selling only part of an asset like shares of stock or mutual fund. (I think FIFO is the default, and there are others.) I have been spending the past six months trying to migrate from Quicken (2000 Basic edition) to Gnucash for a variety of reasons, but mainly because its use of double-entry, support of multiple currencies, the open source model, multi-platform, etc. -- generally it seems a more grown-up program. There is a steep learning curve, however, and with about two decades of financial records to import, it has not been a trivial task. Today, I started tackling the sale of those 300 GE shares in 2012, distributed among 27 individual lots purchased between 1996 and 2004. I thought I was making good progress, using the "View Lots" function. As has been noted before, the documentation is not very comprehensive. There may be a circular reason for this: it's a complex corner of the program that most users will never need. And if you do need to use it, the documentation at the nitty-gritty level probably isn't particularly useful, so instead maybe you boot up LibreOffice Calc and keep track of your lots that way. I think I have figured out how to put 26 of the 27 purchase lots that I sold into that 2012 sales lot -- I don't know that those are the official terms, but I think you understand what I mean -- but the 27th lot consists of only *some* of the shares bought in that particular transaction. (You can't usually sell fractional shares, so I needed a whole number of shares, not 300.072.) I could find nothing in the documentation, of course, about how to do this. Maybe I could take that 27th purchase and arbitrarily divide it into two transactions: the purchase of the fraction that I would sell in 2012, and the rest. The other problem, which I didn't pursue enough to figure out if it really is a problem, has to do with the company's two-for-1 stock split in the middle of all this. Most of the shares being sold were purchased before the split; others came after the split. As far as I can tell, the "View Lots" module can't adjust for splits. Right now, I have 26 of the 27 lots adding up to 149.813 shares, almost all of which represent one-half of the shares actually sold, because of the 2:1 split. I'm writing this long post to find out if (1) I'm missing something and (2) if I should add an enhancement suggestion to Bugzilla. I wish I could code, in which case I might see what I could contribute. Unfortunately, I'm not a programmer. By the way, there's probably a lot of programming mojo behind the scenes, but for the user, Quicken -- even my ancient edition -- handles this sort of transaction surprisingly smoothly. I create a transaction to sell 300 shares. A pop-up asks if I want to take the average cost or specify lots. I choose the Lot Identification button, and another pop-up presents a list of existing purchase lots (including purchase date, price, number of shares) and a place for me to enter how many of those shares I wish to sell. There are also buttons to automatically select FIFO and LIFO shares, or a selection to result in either the minimum or maximum gain. (One area where it sometime fails, if I remember correctly, is that sometimes it stumbles over a rounding error.) Even if Gnucash isn't perfect, I am still in awe of the very smart people who have taken the product this far. Thank you all. Art ___ 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] Selling specified lots of stock/mutual funds
I have been struggling to migrate from my ancient (2000) edition of Quicken to Gnucash. The learning curve, for me, has been discouragingly steep. I think I've got a grasp on the cash accounts -- bank accounts, credit cards. But investments, such as a brokerage account, are more challenging. My current stumbling block is selling specified shares of a mutual fund or stock. To sell shares in Quicken -- even my dusty old version -- the program asks me to choose between average cost basis and lot identification. When I click the "select lots" button, a pop-up box lists all open lots of the security with date and price. I can manually choose which lots (or parts thereof) to sell in this transaction. Or just press a button to automatically select oldest or newest shares, or the ones that will give me minimum or maximum gain. (There is a Help button, but the screen is really self-explanatory.) By contrast, I see no parallel function in Gnucash. I can "View Lots" from the Actions menu, and I can manually aggregate one or more purchases into a named lot. But then what? And the pop-up lots window does not provide crucial per-share cost data that I could potentially sort on to minimize taxable gain. The scrub function, if I read the documentation correction, automates the process only for FIFO accounting. I don't see a way to manually identify the shares I want to sell and have Gnucash calculate the gain or loss, and then mark those lots as no longer available for sale. Neither Section 9.7 of the Gnucash docs, or the wiki nor a search of the mailing list archives seem to have answered my question: Am I missing something? I'm not an active trader, and I may need this function only a couple of times a year, but it would be very disappointing if I have to do something like this manually. (The examples of lots seem to involve a maximum of four transactions, but in an account with years of dollar-cost-averaging purchases and reinvested dividends, over a decade or two the number of transactions can climb into triple digits.) I'm using 3.4 on Windows 10. Thank you, Art ___ 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] Decimal share quantity displayed inconsistently
In my Asset ledgers for stocks and mutual funds, the dollar quantities consistently display to two decimal places. The share price consistently displays to three or four decimal places, per my preference. But the number of shares displays up to three decimal places, dropping all zeros at the end. Examples: 3.217 shares or 5.94 shares or 100 shares display just as I've written, rather than 3.217, 5.940, and 100.000, so they line up properly. Is there any way to have the share price display a consistent number of digits to the right of the decimal point? I don't see anything in the documentation except a reference to the Preferences dialog, but the setting for Decimal Places (General -> Numbers) doesn't seem to affect this column. I'm using GnuCash 3.4 (2018-12-30) on Windows 10. This is an annoyance not a functional issue, but I can't believe a column of shares should properly have an inconsistent number of decimal places when currencies don't. Is there a solution? Thank you. Art ___ 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] Column Width
Another date tip: You can increment/decrement your date using the plus and minus keys. > Message: 1 > Date: Wed, 17 Apr 2019 12:29:11 +0100 > From: Michael Hendry > To: Justin Mathew > Cc: Derek Atkins , "gnucash-user@gnucash.org" > > Subject: Re: [GNC] Column Width > > > On 17 Apr 2019, at 11:48, Justin Mathew via gnucash-user > > wrote: > > > > Is there any way to enter dates from keyboard? Eg, if you have to enter a > > record for past dates, you have to choose the dates from the drop down > > calendar. Any format that I can type to get the dates? > > Just type it, in the form DD/MM/YY > > If you type only DD then to the next field, it will assume the current > month and year. > > If you type DD/MM and you?ll get the current year. > > Michael ___ 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 lost data file
I have a general suggestion to the problem for Windows users. The must frequently-used, helpful, can't-do-without utility I have on my system is called Everything. In the blink of an eye it displays every file matching your specified filename search criterion. Type <*.gnucash> in the search box (without the brackets) and you'll get every file on your system ending in .gnucash with the usual directory information: size, date modified, path, etc. Everything is not only my go-to tool to find a file when I don't remember — or failed to notice — what directory it was saved in. It's also valuable for navigating to a file when you know the location since I can usually type the file name (or enough of it) faster than I can click through the directory tree. Example: I'm looking for last month's MegaCharge credit card statement. I type "2019 Mega" and with no perceptible delay it will show me all the files on my computer that have "2019" and "Mega" in their name. (Everything indexes filename only. Content and some limited metadata searching, e.g. id3 tags, but it's not indexed and can be very slow.) Freeware at https://www.voidtools.com/ (Information provided to assist fellow GnuCash users who have misplaced their data or other files. I have no connection with Everything or Void Tools except as a happy user.) Art ___ 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] QIF Import Fails
David, In the course of numerous import activities I reassigned many transactions from the defaults suggested by the import tool. However, I am 99.5 percent certain I never assigned a transaction to "Retained Earnings," and I found dozens of transactions incorrectly assigned to that account. I am also very (but somewhat less) confident that none of the proposed matches was presented by default as "Retained Earnings." I know very little about accounting -- what constitutes "retained earnings" is still a mystery -- and even less about coding, but it seems to me that, with all respect to those who contributed to the code, the import function is at least quirky. Again, thanks to you and the rest of the GnuCash community for your help, Art (a noobie making baby GnuSteps...) On Fri, Apr 5, 2019 at 10:04 AM David Carlson wrote: > > Art, > > You have the opportunity during the import process to review the proposed > "category" assignments and make corrections at the match transactions step. > This is where you fix those incorrect imports. > > If you start with a select few small imports the Bayesian matching feature > will get a chance to make most of those corrections for you. It is not > perfect, so you need to monitor it carefully. > > Good luck > > David Carlson > > > On Fri, Apr 5, 2019, 2:57 AM Art Chimes wrote: >> >> Thanks for the troubleshooting suggestions. Adrien pointed out the >> ability to filter register displays, for which I am thankful. As a new >> user, I hadn't discovered that tool yet. >> >> He also suggested searching to see if the transaction ended up >> imported into some other account. Which is exactly what happened. >> Instead of going into the checking account where it was supposed to >> go, this transaction -- and many others I thought I had failed to >> import -- ended up in "Equity:Retained Earnings." I suspect "retained >> earnings" has some specific accounting definition, but I don't know >> what it is or what transactions actually belong in that account. I do >> know that it was not my intention to put those transactions in that >> account, and I am pretty sure I did not assign any transactions to >> that account in the import process. >> >> In 2009, a user filed a bug report in Bugzilla on just this behavior. >> (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user >> replied to the bug report, "The importer is assuming these are opening >> balance transactions. Could you explain why this type of transaction >> is legitimate for some other purpose?" My transaction involved a bank >> account interest payment. (In Quicken there is no separate income >> account so the bank account has an interest payment that appears as if >> by magic; it can be credited to the account or transferred to another >> account.) >> >> I can manually move these transactions, one-by-one, to where they >> should be. But going forward, do I just have to resign myself to a lot >> of QIF editing? Since I imagine that a lot of QIF importer users are >> migrating from Quicken, perhaps some Quicken-specific warnings or >> something could be considered? >> >> Thanks again, >> Art >> >> > -- >> > >> > Message: 1 >> > Date: Thu, 4 Apr 2019 11:25:00 -0500 >> > From: Adrien Monteleone >> > To: Gnucash Users >> > Subject: Re: [GNC] QIF Import Fails >> > Message-ID: >> > Content-Type: text/plain; charset=utf-8 >> > >> > Any time I?m in a pickle and can?t see a transaction that should be there, >> > I check that the register is not set to a filtered view. The transaction >> > might be hidden for some reason. I also check one of the registers for the >> > other accounts involved in the transaction. >> > >> > There is also a very powerful Find feature that you can even use regex >> > with to find it. >> > >> > Regards, >> > Adrien >> > >> > > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: >> > > >> > > !Type:Bank >> > > D7/ 1/97 >> > > U5.32 >> > > T5.32 >> > > CX >> > > PInterest Earned >> > > L_IntInc >> > > ^ >> > > >> > > Above is an example of a transaction that is failing to import. The >> > > QIF export is from Quicken 2000 via Windows. >> > > >> > > I've had problems with imports before, but eventually figured out the >> >
Re: [GNC] QIF Import Fails
Thanks for the troubleshooting suggestions. Adrien pointed out the ability to filter register displays, for which I am thankful. As a new user, I hadn't discovered that tool yet. He also suggested searching to see if the transaction ended up imported into some other account. Which is exactly what happened. Instead of going into the checking account where it was supposed to go, this transaction -- and many others I thought I had failed to import -- ended up in "Equity:Retained Earnings." I suspect "retained earnings" has some specific accounting definition, but I don't know what it is or what transactions actually belong in that account. I do know that it was not my intention to put those transactions in that account, and I am pretty sure I did not assign any transactions to that account in the import process. In 2009, a user filed a bug report in Bugzilla on just this behavior. (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user replied to the bug report, "The importer is assuming these are opening balance transactions. Could you explain why this type of transaction is legitimate for some other purpose?" My transaction involved a bank account interest payment. (In Quicken there is no separate income account so the bank account has an interest payment that appears as if by magic; it can be credited to the account or transferred to another account.) I can manually move these transactions, one-by-one, to where they should be. But going forward, do I just have to resign myself to a lot of QIF editing? Since I imagine that a lot of QIF importer users are migrating from Quicken, perhaps some Quicken-specific warnings or something could be considered? Thanks again, Art > -- > > Message: 1 > Date: Thu, 4 Apr 2019 11:25:00 -0500 > From: Adrien Monteleone > To: Gnucash Users > Subject: Re: [GNC] QIF Import Fails > Message-ID: > Content-Type: text/plain; charset=utf-8 > > Any time I?m in a pickle and can?t see a transaction that should be there, I > check that the register is not set to a filtered view. The transaction might > be hidden for some reason. I also check one of the registers for the other > accounts involved in the transaction. > > There is also a very powerful Find feature that you can even use regex with > to find it. > > Regards, > Adrien > > > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: > > > > !Type:Bank > > D7/ 1/97 > > U5.32 > > T5.32 > > CX > > PInterest Earned > > L_IntInc > > ^ > > > > Above is an example of a transaction that is failing to import. The > > QIF export is from Quicken 2000 via Windows. > > > > I've had problems with imports before, but eventually figured out the > > problem. This one has me stymied. I successfully imported > > transactions from 1998-present, but the older ones aren't cooperating. > > > > The importer process seems to work ok, concluding with the encouraging > > notice, "QIF Import Completed" However, the transaction does not > > appear in the account register. > > > > One possible clue: I get a screen that asks me to match this > > transaction with one of two others that have the same > > date/amount/payee, even though the transaction doesn't appear in the > > account. > > > > This is actually one of numerous exports from the same Quicken file. > > Some work; others don't, and my troubleshooting hasn't gotten me > > anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ > > (2018-12-30) > > > > Thanks to the community for your help! > > > > Art ___ 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] QIF Import Fails
!Type:Bank D7/ 1/97 U5.32 T5.32 CX PInterest Earned L_IntInc ^ Above is an example of a transaction that is failing to import. The QIF export is from Quicken 2000 via Windows. I've had problems with imports before, but eventually figured out the problem. This one has me stymied. I successfully imported transactions from 1998-present, but the older ones aren't cooperating. The importer process seems to work ok, concluding with the encouraging notice, "QIF Import Completed" However, the transaction does not appear in the account register. One possible clue: I get a screen that asks me to match this transaction with one of two others that have the same date/amount/payee, even though the transaction doesn't appear in the account. This is actually one of numerous exports from the same Quicken file. Some work; others don't, and my troubleshooting hasn't gotten me anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ (2018-12-30) Thanks to the community for your help! Art ___ 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] Hitting ESC key wipes out work in QIF import
I was nearly through importing many years of credit card transactions (350kb) -- re-assigning Quicken categories to GnuCash accounts -- when I accidentally hit the ESC key. I'm not sure what I was doing, but probably I wanted to undo something and after decades of working on Windows machines, the instinctive thing to do is hit ESC. As I was nearing the end of two screens worth of incorrect accounts, I hit ESC and the import window closed. POOF! I'm pretty sure all my work is gone, but can someone confirm that? Also, I'm pretty sure there is no way to disable this unfortunate result of hitting ESC, but again, can someone confirm that? I know nothing about coding, but would this be something that I could propose as a fix ... say, a confirmation dialog? Still slogging up the lower slopes of the GnuCash learning curve so (1) I appreciate your help, and (2) please be gentle! Thanks, Art Chimes in Arlington, Virginia ___ 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] How-to question: CD Interest payments deposited in a different account
Thanks all who replied, and so quickly, too. I think Dale pretty much nailed it, about over-thinking the problem. Or perhaps more accurately, failing to think about it in a new (gnu?) way. Since the interest payments originated with the asset (the CD), I assumed that the payments should first appear in, or go through, the asset account holding the CD (analogous to what I am used to in Quicken). But it is definitely easier just to start with the income account and having the money then transfer to the checking account. I can use the Description field to note the source of the money. Which brings me to another point. Since I can do that, it seems to me that ALL interest payments — other CDs, savings accounts, etc — can use the same Income:Interest account, yes? I don't see that I need to separate them, as long as they are tagged with the source. Unless I'm missing something, which is more than entirely possible. Art ___ 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] How-to question: CD Interest payments deposited in a different account
I have been trying to learn GnuCash for several months now, and I am apparently dumber than I thought. I am pretty good at keeping my checking account, but I find more complex actions more challenging. For example, I bought a CD (cert. of deposit) last year, and it resides in my brokerage account. Each month it pays me a small amount of interest, which is automatically deposited in my checking account. When the CD matures I will get my original money back. As I learn GnuCash I am still using Quicken (Q 2000!) and in that program it is a simple matter there to record the interest+transfer event as an IntIncX (interest income transfer) transaction. But I am stymied in an effort to correctly record this kind of transaction in GnuCash. I have searched GnuCash resources extensively but I keep getting sent back to an unhelpful example in which the earnings accrue to the CD, to be paid out at the end of the term. (e.g. https://www.gnucash.org/docs/v3/C/gnucash-guide/invest_int1.html) Do I create a split transaction that shows the interest income increasing the value of the CD's asset account and simultaneously being transferred to the checking account? I tried this without success, but I am still pretty rocky with splits. I imagine the procedure is analogous to handling period bond interest payments, or mutual fund dividends, etc., but again I am apparently not smart enough to find resources that I can use. (It seems the documentation — like in Quicken — is not very robust for fixed-income investments. I really want to move away from Quicken, but right now I am maintaining parallel sets of books as I try to get comfortable with GnuCash. Thank you for any help you can provide. Art PS - I'm a noobie ... please be gentle! ___ 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.