Re: [GNC] Transaction imports
Christian, The import data matching information is stored in the individual data file. Not sure about import configuraion information. See the following for more info. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html David Cousens On Tue, 2022-07-05 at 14:52 +0200, Christian Lynbech wrote: > Where is the information related to transaction imports saved? I am on a Mac. > > I have my books stored under revision control but when I wanted to do an > CSV import on a another machine, I did not see the import I have defined > when running Gnucash on my main computer. I am guessing/fearing that > this also applies to the learned matching of transactions to accounts. > > How would I replicate such information between computers? > >/Christian > ___ > 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] Transaction imports
Thanks. /Christian --- On Tue, Jul 05 2022, john wrote: On Jul 5, 2022, at 5:52 AM, Christian Lynbech wrote: Where is the information related to transaction imports saved? I am on a Mac. I have my books stored under revision control but when I wanted to do an CSV import on a another machine, I did not see the import I have defined when running Gnucash on my main computer. I am guessing/fearing that this also applies to the learned matching of transactions to accounts. How would I replicate such information between computers? The transaction matching tokens are kept in "slots" records belonging to the account into which you were importing the transactions. This is part of the book (i.e. .gnucash) file so you need only copy or share it between machines. Saved report and CSV configurations are kept in the DOT-GNUCASH folder, which on macOS is ~ /Library/Application Support/gnucash. See https://wiki.gnucash.org/wiki/Backup for more about where GnuCash keeps data and how to make thorough backups or share books between machines. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to do a couple of less common searches
It is also possible to enter a 'reference transaction' for documentation purposes if you don't enter a value. So you'll only have one split for the same account as the open register. Find > Value > Has Debits or Credits > Equal to > 0.00 worked for me. I suppose you could also add a criteria for Account > Matches no Accounts > (select all accounts) At least for me, adding that criteria did not change my results. Note, I did this Find from a particular register. Mileage may vary. Regards, Adrien On 7/5/22 12:00 AM, David Carlson wrote: TY Geoff, Your answer to 1. works nicely. That is a nice reference for 2. As for 3, GnuCash now allows imports without a transfer account if the value is zero, which I don't like, so I try to catch them on the way in, but I may miss some. ___ 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] Terminology for Non-profits
Did you try changing the name of the Equity account to 'Net Assets'? Regards, Adrien On 7/4/22 6:33 PM, Paul Kroitor wrote: Most of the entities we use GnuCash for are non-profits, and here (at least) non-profits don't have "Equity". They have "Net Assets", which is the same thing but doesn't imply there are owners behind the internal value to the operation. The upshot is that every report we produce that shows Equity must be printed to a file, massaged to replace Equity with Net Assets, and printed again. This is a longshot, but is there any way to have all the reports tweaked to do this once and for all? Ideally, something in the Book options (ie Properties menu) as not all the sets of books here are non-profits. ___ 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] Terminology for Non-profits
As somebody who has done the books for several non-profits, I don't think Paul was talking about the report title,. but instead the "column titles" for the Balance Sheet of a non-profit. But Paul, I have seen other things used for that header title (besides "net assets"). You need to keep in mind that non-profits often have two kinds of liabilities, the ordinary sort, and "donor restricted funds" (and other sorts of restricted funds) I don't really understand your problem with "exporting and then editing" because in my experience going to want to do that anyway. The SAME report (in the logical sense) will often be wanted for presentation in different formats, different levels of detail, etc. That's easiest to do by exporting the "raw" report from gnucash and then from that producing the final product(s). Thus take the "Statement of Revenues and Expenses (title for what you for profit folks call "profit and loss"). As treasurer I would need to know levels of detail down to things like how much paid each person as "compensation" << they might also have received mileage reimbursement >> so knowing if over $600 and I'll need to do a 1099-MISC for that person. The Board might just want to see how much each intern paid in total, and the annual report for members just the total paid to all of them. So doing the annual, I would run in gnucash with all the gory detail (for me) and then edit one version for the Board and one to give out to membership at annual meeting.Events are similar, since as treasurer you want the "printing and postage" component of the expense separate (line item on 990/990EZ) but the board wants to see all expenses of an event as a total. When you use a full feature editor to put the reports into final form you can do all sorts of things (annotate, pretty print, add organization logo and fixed text, etc.) Michael D Novack On 7/5/2022 10:40 AM, Stan Brown wrote: On 2022-07-04 16:33, Paul Kroitor wrote: Most of the entities we use GnuCash for are non-profits, and here (at least) non-profits don't have "Equity". They have "Net Assets", which is the same thing but doesn't imply there are owners behind the internal value to the operation. The upshot is that every report we produce that shows Equity must be printed to a file, massaged to replace Equity with Net Assets, and printed again. This is a longshot, but is there any way to have all the reports tweaked to do this once and for all? Ideally, something in the Book options (ie Properties menu) as not all the sets of books here are non-profits. 1. Bring up your Balance Sheet report. 2. Click Options (or Edit » Report Options). 3. Select the General tab. 4. Change Report Title to Net Assets. This is the one that appears in the report. 5. Change Report name to anything you wish, though Net Assets is probably easiest. 6. Look at all the tabs and change any other options you wish. 7. Click OK. 8. Click Save Report Configuration. A window will open showing the Report name from step 5. Click Close to save this report configuration. In future, click Reports » Saved Report Configurations and then click the green dot to the right of your Net Assets report. 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. -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ 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] Transaction imports
> On Jul 5, 2022, at 5:52 AM, Christian Lynbech wrote: > > Where is the information related to transaction imports saved? I am on a Mac. > > I have my books stored under revision control but when I wanted to do an > CSV import on a another machine, I did not see the import I have defined > when running Gnucash on my main computer. I am guessing/fearing that > this also applies to the learned matching of transactions to accounts. > > How would I replicate such information between computers? The transaction matching tokens are kept in "slots" records belonging to the account into which you were importing the transactions. This is part of the book (i.e. .gnucash) file so you need only copy or share it between machines. Saved report and CSV configurations are kept in the DOT-GNUCASH folder, which on macOS is ~/Library/Application Support/gnucash. See https://wiki.gnucash.org/wiki/Backup for more about where GnuCash keeps data and how to make thorough backups or share books between machines. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] Questions about Import Map Data
> On Jul 4, 2022, at 11:07 PM, Lincoln A Baxter wrote: > > Hi, > > It's been a very long time since I asked a question on this list serve, > and a very long time since I last did a "cleanup" of my GC file (with > perl scripts back then). > > I started keeping my accounting data in GC back in March of 2005. Now > I'm looking to reorganize my chart of expense accounts (again) to > simplify things... when I do that, I'll want to remove the obsolete > Bayes data (again). > > I have a general idea of how the Bayesian import mapper works... Years > ago I wrote some perl scripts to prune it out of the uncompressed XML > file, so I could start it over. But, I'm now looking at the Tools -> > Import Map Editor which I will (belatedly say) is a huge improvement > over mucking about with the xml slot data -- which now looks to be > simplified), especially if all one wants to do, is zero it out. But, > this has lead me to some questions: > > Most of the Bayes data is space tokenized transaction description data. > I get that part. My understanding is that it is scores in this data > that the matcher uses to map transactions to a balancing account. But > I see data, that could not of come from transaction descriptions. Why > are days of the week (Monday, Tuesday, etc) in the Bayes data? Where > does this data come from? How does this help the transaction mapper? > > It looks like the Non-Bayesian data consist of a full (non-tokenized) > transaction descriptions... at least a few of them (nowhere near all of > them... not even close). Given how few I've got (and how old they > appear to be), I don't under stand why this data is here. It is almost > like this was an early attempt to create transaction matching data, > that might have existed since before the bayesian matcher "matured." > So: > > Why does gnucash have these records (and how did they get created)? > Are these records used in transaction mapping? (anymore)... or does > this display exist simply for the purpose of allowing one to nuke them? The day of the week of the transaction posted date is one of the tokens, as are the "words" of the description and of each split's memo. The logic is coded in TransactionGetTokens, https://github.com/Gnucash/gnucash/blob/e9df8d41d2fc838046bc02aed0b05bde53ca9dcd/gnucash/import-export/import-backend.c#L442 and isn't significantly changed from the original contribution in GnuCash 1.9.1, see https://github.com/Gnucash/gnucash/commit/b2ccbf62cf04adddbf3464875c6521582b353964. You're correct that the non-Bayesian matching is just the transaction description. You might have those in your book because at some point you disabled Bayes matching in Preferences, but more likely you imported a QIF file or a CSV file before Geert re-wrote the CSV importer for GnuCash 3.0. The QIF importer doesn't support Bayesian matching so if you import a QIF file those match records are what the importer will use. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Terminology for Non-profits
On 2022-07-04 16:33, Paul Kroitor wrote: > Most of the entities we use GnuCash for are non-profits, and here (at least) > non-profits don't have "Equity". They have "Net Assets", which is the same > thing but doesn't imply there are owners behind the internal value to the > operation. > > The upshot is that every report we produce that shows Equity must be printed > to a file, massaged to replace Equity with Net Assets, and printed again. > > This is a longshot, but is there any way to have all the reports tweaked to > do this once and for all? Ideally, something in the Book options (ie > Properties menu) as not all the sets of books here are non-profits. 1. Bring up your Balance Sheet report. 2. Click Options (or Edit » Report Options). 3. Select the General tab. 4. Change Report Title to Net Assets. This is the one that appears in the report. 5. Change Report name to anything you wish, though Net Assets is probably easiest. 6. Look at all the tabs and change any other options you wish. 7. Click OK. 8. Click Save Report Configuration. A window will open showing the Report name from step 5. Click Close to save this report configuration. In future, click Reports » Saved Report Configurations and then click the green dot to the right of your Net Assets report. 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.
Re: [GNC] Uneven line spacing in Accounts list since 4.11
No, not limited to securities accounts. There might be more than one cause, but it also happens for any account with a notes content that spans more than one line. There's already a working bug report on it. Regards, Adrien On 7/2/22 7:18 AM, John Layman wrote: Note that double spacing occurs only on accounts related to securities, which at the rightmost end of the line include the Display Symbol from the Security Editor. I found that editing the Display Symbol for affected lines corrected the spacing. It would appear that hidden characters in that field cause double spacing. ___ 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] Uneven line spacing in Accounts list since 4.11
While I concur that it is showing only accounts related to securities, I am doubtful that it has to do with security symbol. My right most column is 'Total (Period)' in which it does display symbol in accounts, and those symbols are the same ones that are used to download quotes using yahoo_json source. I went as far as removing 'Display Symbol' field but the uneven line spacing remained. And it is also not consistent in that I have uneven spacing in accounts for which I download OFX file format for transactions or the one that is manually maintained. Next trial I am going to do is remove the dark theme to see if it makes any difference. -- Message: 3 Date: Sat, 2 Jul 2022 08:18:20 -0400 From: "John Layman" To: ,"'Gnucash Users'" Subject: Re: [GNC] Uneven line spacing in Accounts list since 4.11 Message-ID: <01d88e0d$d1f3e250$75dba6f0$@laymanandlayman.com> Content-Type: text/plain; charset="us-ascii" Note that double spacing occurs only on accounts related to securities, which at the rightmost end of the line include the Display Symbol from the Security Editor. I found that editing the Display Symbol for affected lines corrected the spacing. It would appear that hidden characters in that field cause double spacing. -Original Message- From: gnucash-user On Behalf Of dull...@gmail.com Sent: Thursday, June 30, 2022 8:00 PM To: 'Gnucash Users' Subject: [GNC] Uneven line spacing in Accounts list since 4.11 I think since 4.11 (am using Windows 11 and a dark theme), I notice very odd random line spacing in Account list window (the default window when I open Gnucash) I see the lines for each sub-accounts are not evenly distributed - spacing seems completely random (some have space above and below, others do not) I have attached a partial screenshot showing this uneven spacing for the subaccounts (if the mailing list supports attachments?) Regards, Bill -- ___ 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] Transaction imports
Where is the information related to transaction imports saved? I am on a Mac. I have my books stored under revision control but when I wanted to do an CSV import on a another machine, I did not see the import I have defined when running Gnucash on my main computer. I am guessing/fearing that this also applies to the learned matching of transactions to accounts. How would I replicate such information between computers? /Christian ___ 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.
