Re: [GNC] Setting currency on share accounts

2022-04-27 Thread David Carlson
Securities (stocks) are held in brokerage accounts which reside under assets. The brokerage account determines the currency for it's securities and transactions. GnuCash assumes that a given brokerage account deals in only one currency, so another brokerage account is needed for an additional

Re: [GNC] Account setup for reports

2022-04-27 Thread David T. via gnucash-user
That's an interesting idea. I can't imagine it would involve too much-- swapping the slash with a line feed and the appropriate account strings. I don't recall the QIF format that exactly, though, to be sure. David On April 27, 2022 9:56:29 PM EDT, Fred Tydeman wrote: >Has someone written a

Re: [GNC] Why does an Equity account have to be of Currency type?

2022-04-27 Thread ??
Use one of the??dummy??currencies for them. In this workaround, you use one of the dummy currencies to track the loyalty points. These currencies are??XTS (Code for testing purposes)??and??XXX (No currency)??. If you use one of these for your LoyaltyPoints account, you can enter transactions

[GNC] Setting currency on share accounts

2022-04-27 Thread Phillip Duff
Hi, I cannot see where you set the currency for a stock account. I have stocks in multiple currencies, but the currency/secuity field seems dual purpose, therefore assumes the stock is in base currency, which is not always the case. Anyone know how to do it? Also, I can’t fund in the

Re: [GNC] Account setup for reports

2022-04-27 Thread Fred Tydeman
Has someone written a program to transform a *.QIF file into another *.QIF file with the Quicken class data (the text after the '/' in the Cat field) into dummy split transactions with the class data as the account on dummy split? Since a gnucash transaction can have multiple splits, that is a way

Re: [GNC] Account setup for reports

2022-04-27 Thread Fred Tydeman
Thank you. Comment 6 with the dummy accounts added as $0 splits seems good enough for my needs. On Wed, Apr 27, 2022 at 2:44 PM flywire wrote: > https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html > is part of a discussion on classes. >

Re: [GNC] Account Summary report - cannot use CTRL to select accounts one by one.

2022-04-27 Thread David H
Elmar, Works on ubuntu 21.10 although it seems you have to click once and then click again to remove accounts from selection. Does this help? Cheers David H. On Thu, 28 Apr 2022 at 09:26, Elmar wrote: > Update - it works on my windows 10 installation though (dual boot > system), just not the

Re: [GNC] Account Summary report - cannot use CTRL to select accounts one by one.

2022-04-27 Thread Elmar
Update - it works on my windows 10 installation though (dual boot system), just not the linux one.  Ideas? On 4/27/2022 12:07 PM, Elmar wrote: Using GC Version: 4.10 Build ID: 4.10+(2022-03-26) (flatpak on Linux Mint 20.3) - I am trying to select/de-select individual accounts in the options

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread brad
On 4/27/22 02:13, Chris Green wrote: On Tue, Apr 26, 2022 at 07:49:02PM -0600, brad wrote: On 4/26/22 09:25, Chris Green wrote: I have several gnucash accounts files (sqlite databases in my case) spread around my system. When I go to a specific directory and run GnuCash I just want it to

[GNC] Account setup for reports

2022-04-27 Thread flywire
https://lists.gnucash.org/pipermail/gnucash-user/2022-February/099807.html is part of a discussion on classes. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Why does an Equity account have to be of Currency type?

2022-04-27 Thread David Long
Hi, I would just add to my previous comments that if equity accounts are set up for contributions to equity that are in assets other than in the base currency of the entity, this would have to be a currency account as it has to be translated into the base reporting currency of the entity using

Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7

2022-04-27 Thread parag puranik via gnucash-user
Thanks John  and Frank for your valuable research on the topic.I am so much thankful to the members who devote immense time and energy in replying to and helping the newbies. Sent from Yahoo Mail on Android On Wed, 27 Apr 2022 at 4:23 AM, Frank H. Ellenberger wrote: Hi, Am 26.04.22 um

Re: [GNC] Why does an Equity account have to be of Currency type?

2022-04-27 Thread David Long
Hi Ken, Re your reply to Michael below, I can help with the accounting, because this has to be understood before how to use any financial accounting system , like GnuCash, can be used. In any set of financial accounts, including those where the system is based on handwritten ledgers (how I

[GNC] Account Summary report - cannot use CTRL to select accounts one by one.

2022-04-27 Thread Elmar
Using GC Version: 4.10 Build ID: 4.10+(2022-03-26) (flatpak on Linux Mint 20.3) - I am trying to select/de-select individual accounts in the options of the included account summary report.  I can select sequential accounts with shift-click, but ctrl-click no longer adds or removes the

[GNC] Account setup for reports

2022-04-27 Thread Fred J. Tydeman
[Sorry for the bad posts, but I was having issues with the other email program] I would like to produce reports that show: money spent on meals, hotels, ... money spend on various trips In Quicken, the transactions were coded as: Expense:meals/home Expense:meals/20210112

[GNC] Account setup for reports

2022-04-27 Thread Fred Tydeman
[Sorry for the bad posts, had problems with email program] I would like to produce reports that show: money spent on meals, hotels, ... money spend on various trips In Quicken, the transactions were coded as: Expense:meals/home Expense:meals/20210112 Expense:hotel/20210112

[GNC] Account setup for reports

2022-04-27 Thread Fred Tydeman
[It appeared in my email program that the previous post has a Subject line] ___ 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

Re: [GNC] FlatPak question

2022-04-27 Thread Geert Janssens
Hi Jeff, If you have set up your desktop links properly once to work with flatpak you should not need to do that again when you update the gnucash flatpak. Regards, Geert Op zondag 24 april 2022 08:40:32 CEST schreef Jeff: > Just a curious, do to too long of a day question [36 hours and

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread Michael or Penny Novack
I have lots of other information associated with the GnuCash data which I keep in the same directory. E.g. there are copies of cheques deposited and GiftAid records. So my way of working is to go (in a terminal window) to that directory and then run programs as needed from there. That is

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread Michael or Penny Novack
My ideal would be for GnuCash to look for account files in the current directory, if there is only one then open that one, if there are more then offer me a list to choose from. Are you serious? Assume this was a different application, say a "word processor". You are saying that when you

Re: [GNC] How to manage multiple accounts (as in separate gnucash? databases)?

2022-04-27 Thread Robert Heller
There is a MacOS / MS-Windows -centric concept of organizing a user's file space by file *types* (I don't know for sure if Steve Jobs or some brainiac at M$ came up with this notion). So most (all?) GUI desktops initialize a user's file space with a set of "folders": Documents, Pictures, Movies,

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread Chris Green
On Wed, Apr 27, 2022 at 06:35:50AM -0400, David T. wrote: >You could always link those files to transactions in GnuCash, and >they'd be accessible from within gnucash... > They don't necessarily have any connection with a transaction, letters for example may just be about church business

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread Chris Green
On Wed, Apr 27, 2022 at 07:11:58PM +1000, davidcousen...@gmail.com wrote: > Chris, > > If you start multiple programs from the directory a set of bash scripts which > change to the appropriate directory and run the set of programs for each set > of > books you work on might be useful. You could

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread David T. via gnucash-user
You could always link those files to transactions in GnuCash, and they'd be accessible from within gnucash... On April 27, 2022 4:02:24 AM EDT, Chris Green wrote: >On Tue, Apr 26, 2022 at 03:58:06PM -0600, Bruce Irving wrote: >> I have 3 separate gnucash data files. I never open gnucash rather

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread davidcousens49
Chris, If you start multiple programs from the directory a set of bash scripts which change to the appropriate directory and run the set of programs for each set of books you work on might be useful. You could launch the scipts from either the Ubuntu menu or from desktop launchers. David

Re: [GNC] Help with GnuCash's 'help'

2022-04-27 Thread Chris Green
On Wed, Apr 27, 2022 at 08:01:01AM +1000, davidcousen...@gmail.com wrote: > Chris > > The online version of Help and the Tutorial and Concepts Guide are not really > searchable in any meaningful sense from within the HTML page. Other versions > may > be I have more luck using Google directly to

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread Chris Green
On Tue, Apr 26, 2022 at 07:49:02PM -0600, brad wrote: > > On 4/26/22 09:25, Chris Green wrote: > > I have several gnucash accounts files (sqlite databases in my case) > > spread around my system. When I go to a specific directory and run > > GnuCash I just want it to see only the database[s] in

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread Chris Green
On Tue, Apr 26, 2022 at 06:10:21PM -0400, Michael or Penny Novack wrote: > On 4/26/2022 11:25 AM, Chris Green wrote: > > The --nofile option tells gnucash not to open the last accounts > > database, it helps a little, but I really want it to forget more! > > > It may be confusing things slightly

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

2022-04-27 Thread Chris Green
On Tue, Apr 26, 2022 at 03:58:06PM -0600, Bruce Irving wrote: > I have 3 separate gnucash data files. I never open gnucash rather I click > on (or have link/shortcut to the data file. That way, I can have the data > file links where they are easy to get to. > I have lots of other information

Re: [GNC] Linux. Mysql and Gnucash 4.1

2022-04-27 Thread Chris Green
On Tue, Apr 26, 2022 at 08:47:04PM -0500, Adrien Monteleone wrote: > On 4/26/22 3:28 AM, Chris Green wrote: > > On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote: > > > So I have rebuilt my laptop, recovered my databases and installed Gnucash > > > 4.1 but I cannot connect to mysql databases.