Re: [GNC] Linux. Mysql and Gnucash 4.1
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. When I click file, open there > > > is no option for mysql. This is under Fedora 35Sent from my Galaxy > > > > I don't believe GnuCash works with mysql (or the equivalent mariadb), > > the only database storage option that I'm aware of is sqlite. > > > > It offers 4 backends: > > XML (default) > SQLite > MySQL/MariaDB > PostgreSQL > > You have to install the desired backend libs in most cases to be offered the > option of using it. > > The default requires no special effort. > > Many Linux distros also come with SQLite support by default, so mileage > varies. > > MySQL/Maria & Postgres almost always require intentional lib installation > and if I'm not mistaken, specific build flags. > > Check the wiki for more specific and up to date info. > Yes, absolutely right, my 'sqlite only' view was simply because, on most Linux distributions sqlite is already there. Thus GnuCash offers both XML and sqlite 'out of the box' as it were. -- Chris Green ___ 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 manage multiple accounts (as in separate gnucash databases)?
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 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. -- Chris Green ___ 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 manage multiple accounts (as in separate gnucash databases)?
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 when you shorten "book of accounts" to > "accounts" instead of "books" << we usually refer to the financial records > of an entity as "its books" --- in days of yore when the records were kept > pen and ink on paper the "journal" and "ledgers" WERE books (bound volumes > of accounting paper) >> > Yes, I never quite know what to call a GnuCash data file. As you say 'account' is confusing because GnuCash has multiple 'accounts' within one file/database. > Why is remembering in what directory the records for an entity are kept > easier than remembering the name of the entity? Because it makes a whole lot more sense (for me anyway) to keep everything to do with one set of books in one place. So, for my church accounts for one particular year I have a directory:- ~/pcc/2022 This is very simple to remember and find. (PCC is Parochial Church Council). I have the GnuCash accounts files there, and copies of letters I have sent, and copies of incoming cheques and records for GiftAid plus anything else relevant. -- Chris Green ___ 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 manage multiple accounts (as in separate gnucash databases)?
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 that directory. > > > > Is there a way I can tell gnucash to forget about all previous files > > it has opened? As it is I get presented with a 'memory' of other > > accounts which can be very confusing unless I'm very careful with file > > naming. > > > > The --nofile option tells gnucash not to open the last accounts > > database, it helps a little, but I really want it to forget more! > > > I'm not clear on what the problem is (unless you're on a Mac). > On my system (linux), In the file manager, navigate to the folder, find the > file you want to open, and double click it. It only opens that database. > What's confusing? > I don't use GUI file manager (well, very rarely), I tend to 'cd' in a terminal window to the directory where the files I want to use are and then run the various programs I need to do things to those files. The GnuCash file is just one of those files. -- Chris Green ___ 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 with GnuCash's 'help'
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 find specific topics and info. > OK, thanks, so at least I'm not missing anything. :-) -- Chris Green ___ 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 manage multiple accounts (as in separate gnucash databases)?
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 Cousens On Wed, 2022-04-27 at 09:13 +0100, 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 see only the database[s] in that directory. > > > > > > Is there a way I can tell gnucash to forget about all previous files > > > it has opened? As it is I get presented with a 'memory' of other > > > accounts which can be very confusing unless I'm very careful with file > > > naming. > > > > > > The --nofile option tells gnucash not to open the last accounts > > > database, it helps a little, but I really want it to forget more! > > > > > I'm not clear on what the problem is (unless you're on a Mac). > > On my system (linux), In the file manager, navigate to the folder, find the > > file you want to open, and double click it. It only opens that database. > > What's confusing? > > > I don't use GUI file manager (well, very rarely), I tend to 'cd' in a > terminal window to the directory where the files I want to use are and > then run the various programs I need to do things to those files. The > GnuCash file is just one of those files. > ___ 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 manage multiple accounts (as in separate gnucash databases)?
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 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 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. > >-- >Chris Green >___ >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] How to manage multiple accounts (as in separate gnucash databases)?
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 launch the scipts from either > the > Ubuntu menu or from desktop launchers. > Yes, I do have quite a few 'wrapper' bash scripts (and functions) to handle this sort of thing. I don't want to have a different script for each year's accounts though. I have a prototype script for GnuCash now that I run when I'm in the appropriate directory to open the GnuCash file there. It's still a bit 'messy' with all the log files that GnuCash leaves there, I'm working on that as well! :-) -- Chris Green ___ 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 manage multiple accounts (as in separate gnucash databases)?
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 and nothing to do with money. I still want to keep them in the same place. -- Chris Green ___ 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 manage multiple accounts (as in separate gnucash? databases)?
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, Music,
Downloads, and a few others and the various desktop apps default to storing /
finding files in one of these folders. Some of us (old school UNIX users?)
find this file space organization silly / strange / counter-useful.
Instead we have top-level directories ("folder" is a strange term) that
represent specific jobs or projects or something like that and then gather all
of the various *different* files that relate to that job, project, etc.
togther. So instead of the documents living under Documents and the pictures
living under Pictures, etc. the documents (eg letters) and pictures, and so on
for a partitular job, project, or whatever, would all be collected together in
a directory for the job, project, or whatever.
At Wed, 27 Apr 2022 09:10:49 +0100 Chris Green wrote:
>
> 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 when you shorten "book of accounts" to
> > "accounts" instead of "books" << we usually refer to the financial records
> > of an entity as "its books" --- in days of yore when the records were kept
> > pen and ink on paper the "journal" and "ledgers" WERE books (bound volumes
> > of accounting paper) >>
> >
> Yes, I never quite know what to call a GnuCash data file. As you say
> 'account' is confusing because GnuCash has multiple 'accounts' within
> one file/database.
>
>
> > Why is remembering in what directory the records for an entity are kept
> > easier than remembering the name of the entity?
>
> Because it makes a whole lot more sense (for me anyway) to keep
> everything to do with one set of books in one place. So, for my
> church accounts for one particular year I have a directory:-
>
> ~/pcc/2022
>
> This is very simple to remember and find. (PCC is Parochial Church
> Council). I have the GnuCash accounts files there, and copies of
> letters I have sent, and copies of incoming cheques and records for
> GiftAid plus anything else relevant.
>
--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/ -- Linux Administration Services
hel...@deepsoft.com -- Webhosting Services
___
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 manage multiple accounts (as in separate gnucash databases)?
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 started the word processor you would want to search the "current directory" (we'd need to come back to discuss what THAT might mean) and: if there was only one file in that directory which the application COULD open open that one, else if more than one present a selection list? How about if there didn't happen to be any? Yes of course, --nofile means just that, don't open any (the application simply starts at a place allowing you to open the file of your choice. I believe what you want (should perhaps request) if that is the case, is a DIFFERENT runtime parameter that causes the behavior " open the file name supplied instead of the last one opened. POSSIBLY this could be as simple as the behavior "if a file name is supplied as parameter, open that instead of last one open" 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.
Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?
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 not actually relevant to the discussion (except that you have some sense of "current directory"). Indeed, in my case there would be lots in the directory devoted to the organization for which the books being kept, the exported reports, their finished versions, Gov't filings etc. In other words, there would actually be sub directories devoted to some of these things << and ONE of these would have the books file and associated log files making it easier to maintain how many kept >> But that has NOTHING to do with how I open gnucash. I open the application (nofile) and select which I am working with today. The ones I work with frequently will be on the MRU list, the others not << but this is actually SEASONAL -- thus an organization which has little financial activity 10 months of the year and then a lot when putting on an annual event might for two month of the year be on the MRU list but then drop off it. I do not usually open files (we aren't talking just about gnucash) by "click on object". That is because with my decades in the cypher mines, I don't think of objects that way (as things that can be opened by only one application). For example, my "hex editor" can open ANYTHING. Therefore I usually open an application and tell it what I want it to open. Please note, "click on object" only works for objects that have an "extension" associated with an application. It doesn't work when you have several applications which COULD (usefully) open the object so that part of the process is selecting which. Objects (like a gnucash data file) represent a special case of "only one application COULD be usefully used to open". I don't know about what's on your computers, but on mine, the number of "objects" that could be usefully opened by more than one application on my computer outnumbers the ones like gnucash files that cannot hundreds or thousands to one. OK, I do tend to have favorites for these file types and set the associations that way (let's me open by clicking) BUT I often have to check/test (before sending off) that other folks will be able to use the file on their computer with their favorites. 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.
Re: [GNC] FlatPak question
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 counting, > ain't cattle farming great during calving season!]. (I have no idea how > some professional utility and medical staff can handle 48 hour day > shifts frequently, multiple days in a row). > > As the version numbers increase on GNC, will desktop links to specific > sets of books still work as you upgrade via FlatPak or will they need to > be edited? Running Ubuntu 20.04LTS right now, and intend to keep the > most recent stable version of GNC and Ubuntu LTS up and telling me I > screwed up an entry. > > Without the userlist I never would have got the 4.10 desktop icons to work. ___ 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] Account setup for reports
[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 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] Account setup for reports
[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 Expense:meals/20210215 Expense:hotel/20210215 using both Categories (what) and Classes (which trip, if any). I understand the Classes are not currently supported in gnucash. In gnucash, I can see two ways to do the setup: Expense:meals:home Expense:meals:20210112 Expense:hotel:20210112 Expense:meals:20210215 Expense:hotel:20210215 Or Expense:home:meals Expense:20210112:meals Expense:20210112:hotel Expense:20210215:meals Expense:20210215:hotel But, there might be a better way. Suggestions? If I do either of those two setups, will I be able to produce all the reports I want? ___ 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] Account setup for reports
[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 Expense:hotel/20210112 Expense:meals/20210215 Expense:hotel/20210215 using both Categories (what) and Classes (which trip, if any). I understand the Classes are not currently supported in gnucash. In gnucash, I can see two ways to do the setup: Expense:meals:home Expense:meals:20210112 Expense:hotel:20210112 Expense:meals:20210215 Expense:hotel:20210215 Or Expense:home:meals Expense:20210112:meals Expense:20210112:hotel Expense:20210215:meals Expense:20210215:hotel But, there might be a better way. Suggestions? If I do either of those two setups, will I be able to produce all the reports I want? --- Fred J. TydemanTydeman Consulting tyde...@tybor.com Testing, numerics, programming +1 (702) 608-6093 Vice-chair of PL22.11 (ANSI "C") Sample C99+FPCE tests: http://www.tybor.com Savers sleep well, investors eat well, spenders work forever. ___ 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] Account Summary report - cannot use CTRL to select accounts one by one.
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 highlight from the selected set. What happened? This used to work. - elmar ___ 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] Why does an Equity account have to be of Currency type?
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 started in the 70s), the business has to decide in which currency it is going to report in, normally the country of its residence but not always. This could indeed be in yards of lumber, or whatever the Robinson Crusoe Island decides. It would then produce a profit and loss account with a net income in X yards of lumber, and a balance sheet where debit equals credits in yards or lumber, or in other words ,where Assets in yards of lumber = Liabilities in yards of lumber plus Equity in yards of lumber. If an equity holder were to contribute to his equity account in bananas, you could indeed open an equity account in the books of account in bananas. If one yard of lumber was equal to a hundred bananas at the time of the transaction,and he contributed a thousand bananas then his equity account would be denominated in yards of lumber and its value would be 10. (yards of lumber). If you were hoping to have an equity account showing one thousand bananas, this could never work. It has to be denominated in the entities reporting currency, not bananas. This would be the only way of having a balance sheet and P&L account in the reporting currency of yards of lumber which adds up. That would be the case in any financial accounting system. This can of course be done in GnuCash as Michael suggests by using the $ symbol for yards of lumber or whatever. You would have to keep a separate memo reporting outside of the financial reporting system to record that your banana equity account of 10 is represented by 1000 bananas. To take a more mundane example, if you take a US company reporting in USD, and a foreign investor buys some stock with Euros, that purchase will always be translated into USD and they will have X USD denominated stock (maybe 1USD $ nominal value) and will have to keep their own record of how many euros they paid. Hope this helps David Your message to Michael below: Hi Michael, I agree - I could change the definition of $ for the purposes of the Robinson Crusoe case. But let me ask the question a different way: It seems that when trying to create an account of type Asset, Bank, Cash, Credit Card, Liability, A/Receivable, A/Payable, Equity selecting the denominated "Security/currency" only allows the user to select a Currency Type. For account types Stock and Mutual Fund the "Security/currency" is only allowed to be of a Non-Currency Type. Why is that restriction necessary? Why can't you have a Bank account that is denominated in silver taels*? Or a cash account denominated in "Disney Dollars"? Or contribute Equity to a business in the form of yards of lumber? Perhaps the answer is to simply use a "Stock" account type for my asset examples? But there is no workaround for the equity example. And it seems like an artificial limitation within the software - unless I am missing the reason this should not be permitted (either from an software implementation or accounting perspective). Thanks, Ken On Wed, Apr 27, 2022 at 12:01 AM wrote: > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > >1. Linux. Mysql and Gnucash 4.1 (grant) >2. Re: Linux. Mysql and Gnucash 4.1 (Chris Green) >3. Re: Linux. Mysql and Gnucash 4.1 (grant) >4. Re: Why does an Equity account have to be of Currency type? > (Frank H. Ellenberger) >5. Re: Flathub does not install Gnucash ver. 4.10 flatpak, but > only installs lower ver. 3.7 (parag puranik) >6. Re: Flathub does not install Gnucash ver. 4.10 flatpak, but > only installs lower ver. 3.7 (Frank H. Ellenberger) >7. Re: Flathub does not install Gnucash ver. 4.10 flatpak, but > only installs lower ver. 3.7 (parag puranik) >8. Re: Why does an Equity account have to be of Currency type? > (km22) >9. How to manage multiple accounts (as in separate gnucash > databases)? (Chris Green) > 10. Help with GnuCash's 'help' (Chris Green) > > > -- > > Message: 1 > Date: Tue, 26 Apr 2022 18:36:30 +1200 > From: grant > To: gnucash-user@gnucash.org > Subject: [GNC] Linux. Mysql and Gnucash 4.1 > Message-ID: > Content-Type: text/plain; charset=utf-8 >
Re: [GNC] Flathub does not install Gnucash ver. 4.10 flatpak, but only installs lower ver. 3.7
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 14:13 schrieb parag puranik: > There is no output of both the commands, The screen of terminal looks like > ::~$ flatpak remotes -d >fp-state > :~$ flatpak search gnucash >>fp-state > :~$ Right, it is in the file fp-state in your working directory. I had expected you would attach that file to your email. As John found the reason of your problem, you can now remove that file. Regards Frank ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Why does an Equity account have to be of Currency type?
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 the exchange rate conversion tools of GnuCash. David On Thu, Apr 28, 2022 at 12:19 AM David Long wrote: > > 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 started in the 70s), the business has > to decide in which currency it is going to report in, normally the country > of its residence but not always. This could indeed be in yards of lumber, > or whatever the Robinson Crusoe Island decides. > > It would then produce a profit and loss account with a net income in X > yards of lumber, and a balance sheet where debit equals credits in yards or > lumber, or in other words ,where Assets in yards of lumber = Liabilities > in yards of lumber plus Equity in yards of lumber. > > If an equity holder were to contribute to his equity account in bananas, > you could indeed open an equity account in the books of account in bananas. > If one yard of lumber was equal to a hundred bananas at the time of the > transaction,and he contributed a thousand bananas then his equity account > would be denominated in yards of lumber and its value would be 10. (yards > of lumber). If you were hoping to have an equity account showing one > thousand bananas, this could never work. It has to be denominated in the > entities reporting currency, not bananas. This would be the only way of > having a balance sheet and P&L account in the reporting currency of yards > of lumber which adds up. That would be the case in any financial accounting > system. This can of course be done in GnuCash as Michael suggests by using > the $ symbol for yards of lumber or whatever. > > You would have to keep a separate memo reporting outside of the financial > reporting system to record that your banana equity account of 10 is > represented by 1000 bananas. > > To take a more mundane example, if you take a US company reporting in USD, > and a foreign investor buys some stock with Euros, that purchase will > always be translated into USD and they will have X USD denominated stock > (maybe 1USD $ nominal value) and will have to keep their own record of how > many euros they paid. > > > > Hope this helps > David > > Your message to Michael below: > > > Hi Michael, > > I agree - I could change the definition of $ for the purposes of the > Robinson Crusoe case. But let me ask the question a different way: > > It seems that when trying to create an account of type Asset, Bank, Cash, > Credit Card, Liability, A/Receivable, A/Payable, Equity selecting the > denominated "Security/currency" only allows the user to select a Currency > Type. > For account types Stock and Mutual Fund the "Security/currency" is only > allowed to be of a Non-Currency Type. > > Why is that restriction necessary? Why can't you have a Bank account that > is denominated in silver taels*? Or a cash account denominated in > "Disney Dollars"? Or contribute Equity to a business in the form of yards > of lumber? > > Perhaps the answer is to simply use a "Stock" account type for my asset > examples? But there is no workaround for the equity example. And it seems > like an artificial limitation within the software - unless I am missing the > reason this should not be permitted (either from an software implementation > or accounting perspective). > > Thanks, > Ken > > On Wed, Apr 27, 2022 at 12:01 AM wrote: > >> Send gnucash-user mailing list submissions to >> gnucash-user@gnucash.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> or, via email, send a message with subject or body 'help' to >> gnucash-user-requ...@gnucash.org >> >> You can reach the person managing the list at >> gnucash-user-ow...@gnucash.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of gnucash-user digest..." >> >> >> Today's Topics: >> >>1. Linux. Mysql and Gnucash 4.1 (grant) >>2. Re: Linux. Mysql and Gnucash 4.1 (Chris Green) >>3. Re: Linux. Mysql and Gnucash 4.1 (grant) >>4. Re: Why does an Equity account have to be of Currency type? >> (Frank H. Ellenberger) >>5. Re: Flathub does not install Gnucash ver. 4.10 flatpak, but >> only installs lower ver. 3.7 (parag puranik) >>6. Re: Flathub does not install Gnucash ver. 4.10 flatpak, but >> only installs lower ver. 3.7 (Frank H. Ellenberger) >>7. Re: Flathub does not install Gnucash ver. 4.10 flatpak, but >>
[GNC] Account setup for reports
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: 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 manage multiple accounts (as in separate gnucash databases)?
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 see only the database[s] in that directory. Is there a way I can tell gnucash to forget about all previous files it has opened? As it is I get presented with a 'memory' of other accounts which can be very confusing unless I'm very careful with file naming. The --nofile option tells gnucash not to open the last accounts database, it helps a little, but I really want it to forget more! I'm not clear on what the problem is (unless you're on a Mac). On my system (linux), In the file manager, navigate to the folder, find the file you want to open, and double click it. It only opens that database. What's confusing? I don't use GUI file manager (well, very rarely), I tend to 'cd' in a terminal window to the directory where the files I want to use are and then run the various programs I need to do things to those files. The GnuCash file is just one of those files. Then just run 'gnucash filename' , filename is the one you want to open? ___ 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] Account Summary report - cannot use CTRL to select accounts one by one.
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 of the included account summary report. I can select sequential accounts with shift-click, but ctrl-click no longer adds or removes the highlight from the selected set. What happened? This used to work. - elmar ___ 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] Account Summary report - cannot use CTRL to select accounts one by one.
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 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 of the included account summary report. I can select > > sequential accounts with shift-click, but ctrl-click no longer adds or > > removes the highlight from the selected set. What happened? This used > > to work. - elmar > ___ > 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] Account setup for reports
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. > ___ 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] Account setup for reports
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 to tag a transaction with many tags/classes. And, since the tag/class data is gnucash accounts, they can be a hierarchy. On Wed, Apr 27, 2022 at 5:09 PM Fred Tydeman wrote: > 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. >> > ___ 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] Setting currency on share accounts
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 documentation whether the system uses the latest price/currency in the price database or does it require the price to exist for the day on which it is being calculated. Example: If the latest price I have in the price database is on 14-MAr will the system use this price to calculate value on the 31-Mar Cheers Phil ___ 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] Why does an Equity account have to be of Currency type?
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 into the account without having to enter share prices for every transaction. And, you can keep using the same two dummy currencies to track all sorts of amounts??vacation dollars earned and used so far this year, vacation hours earned and used, health insurance benefits allowance used and remaining, and so on. The drawback with this workaround is that you cannot define exchange rates for the dummy currencies to convert them to ISO currencies. If you want to do that, you really should use the first workaround. ___ 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] Account setup for reports
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 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 to tag >a transaction with many tags/classes. >And, since the tag/class data is gnucash accounts, they can be a hierarchy. > >On Wed, Apr 27, 2022 at 5:09 PM Fred Tydeman wrote: > >> 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. >>> >> >___ >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] Setting currency on share accounts
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 currency. The same security can be held in multiple brokerage accounts. See the help and tutorials for examples of accounts and transactions. Prices get entered into the price data by several means including actual prices from transactions, prices downloaded from the Internet or imported from a file, or even manually entered into the database. Reports can pick prices out of the price data by different algorithms depending on your choice. If there is no price for a given report date GnuCash will use the method you choose to pick or calculate a price for the report. I am deliberately not being detailed because there is a huge universe of choices depending on your needs. If you have specific questions ask them here to get specific answers. On Wed, Apr 27, 2022 at 10:12 PM Phillip Duff wrote: > 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 documentation whether the system uses the latest > price/currency in the price database or does it require the price to exist > for the day on which it is being calculated. Example: If the latest price I > have in the price database is on 14-MAr will the system use this price to > calculate value on the 31-Mar > > Cheers Phil > ___ > 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. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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.
