[GNC] Fwd: [Bug 113772] Add categories for more reporting flexibility
-- Forwarded message - From: David Carlson Date: Thu, May 14, 2020, 12:34 AM Subject: Re: [Bug 113772] Add categories for more reporting flexibility To: I don't have access to bugzilla on this device so I cannot comment there right now. I use the "action" field for comments or flags and I would not want them usurped for some other use. Also, other users may have other data in that field. David Carlson On Wed, May 13, 2020, 10:17 PM wrote: > https://bugs.gnucash.org/show_bug.cgi?id=113772 > > --- Comment #44 from flywire --- > Simple tweak -> solved. > > The Single field functionality is already there - the Action field on every > split is fairly useless. It's an internal table so it would require a > recompile > (or Hex edit) to change but shouldn't take much to move the table to the > database. > > -- > You are receiving this mail because: > You are on the CC list for the bug. ___ 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] Backup to encrypted 7zip file
Simply put: - I'm not the one using it - it's to prevent casually or accidentally displaying the data - considering the external value of personal cashbook data this very accessible process kindly provided by a community member seems fit-for-purpose - GnuPG may well offer better security but it's not as turnkey - if your employer is using a key-stroke logger then leave > ___ 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] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)
Hi John. I did go into aqbanking and needed to reassociate the username with the accounts -- for some reason that part was not migrated properly. All I did was go into each account and choose the username to associate and it worked after the upgrade to the new release. I had backed up previous settings in case I needed to recreate from scratch, but hadn't needed to. On Wednesday, May 13, 2020 12:59:13 PM CDT John Haiducek wrote: > Didn't work for me. I installed the updated aqbanking package and still get > the error. Anthony, did you have to go into aqbanking and recreate the > accounts in order for download transactions to work? > > On Sun, May 10, 2020 at 5:03 PM Anthony Joseph Messina > wrote: > On Monday, May 4, 2020 4:10:45 PM CDT John Ralls wrote: > > > On May 4, 2020, at 1:07 PM, Daffy Duck wrote: > > > > > > Hello, > > > > > > I'd been using online banking forever, but since upgrading to Fedora 32 > > > last week, I now get this error when I try to fetch transactions: > > > > > > error on executing job. status: enqueued (1) > > > > > > It shows in a popup. > > > > > > If I go into online banking setup and try to retrieve accounts, it just > > > crashes. > > > > > > gnucash-3.10-1.fc32.x86_64 > > > > > > aqbanking-6.0.1-2.fc32.x86_64 > > > > > > gwenhywfar-5.1.2-2.fc32.x86_64 > > > > > > Any ideas? > > > > Yes, AQBanking between 5.99.0 and 6.1.4 doesn't work with OFX > > DirectConnect. https://bugzilla.redhat.com/show_bug.cgi?id=1830609 > > > > Regards, > > John Ralls > > I can confirm the update in bodhi resolves the issue: > https://bodhi.fedoraproject.org/updates/FEDORA-2020-24e4addb7e signature.asc Description: This is a digitally signed message part. ___ 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
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 > On May 13, 2020 w20d134, at 9:15 AM, Art Chimes wrote: > > Sorry Adrien, I should have sent a personal copy to you, too. Thanks > for your help on this. > > -- Forwarded message - > From: Art Chimes > Date: Wed, May 13, 2020 at 10:13 AM > Subject: Re: Report seems to pull wrong amount from transaction > To: Gnucash Users , D. > > > 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 ___ 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] Backup to encrypted 7zip file
Encryption is very personal and also very hard to get right. 1. Personal. You might prefer a commercial product (PGP) while I prefer open source (GnuPG). 2. Hard. Simply XOR and many short-bit keys are now easily breakable. Even those who create methods (two-fish, RSA, etc) make mistakes that leave loop-holes open to be exploited. (See commentary by Bruce Schneier -- https://www.schneier.com/) So, 'tis better to use a tool built for encryption to do that work than to expect all other tools to implement (poorly) same. Pick the right tool for the job rather than expecting a screw-driver to drive a nail (or clamp two boards together). While at it, remember that if you are not on your own box, simply having your key available means that your data is compromised. Any key-stroke logger on the company machine could capture the key as you type it in (from memory). So, why are you putting your personal data on a company supplied machine? Your data is already compromised even with attempting to encrypt it. On 5/13/20 12:36 AM, flywire wrote: > Er ... no encryption. > > https://wiki.gnucash.org/wiki/FAQ#Q:_Can_you_please_add_a_password_feature.3F > ...[No] > > The actual problem is access to personal data on a work supplied computer. > An optional program based backup is more appropriate. GnuCash won't install > but thankfully there is a portable version > https://bugs.gnucash.org/show_bug.cgi?id=797740 > > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)
Didn't work for me. I installed the updated aqbanking package and still get the error. Anthony, did you have to go into aqbanking and recreate the accounts in order for download transactions to work? On Sun, May 10, 2020 at 5:03 PM Anthony Joseph Messina < amess...@messinet.com> wrote: > On Monday, May 4, 2020 4:10:45 PM CDT John Ralls wrote: > > > On May 4, 2020, at 1:07 PM, Daffy Duck > wrote: > > > > > > Hello, > > > > > > I'd been using online banking forever, but since upgrading to Fedora 32 > > > last week, I now get this error when I try to fetch transactions: > > > > > > error on executing job. status: enqueued (1) > > > > > > It shows in a popup. > > > > > > If I go into online banking setup and try to retrieve accounts, it just > > > crashes. > > > > > > gnucash-3.10-1.fc32.x86_64 > > > > > > aqbanking-6.0.1-2.fc32.x86_64 > > > > > > gwenhywfar-5.1.2-2.fc32.x86_64 > > > > > > Any ideas? > > > > Yes, AQBanking between 5.99.0 and 6.1.4 doesn't work with OFX > DirectConnect. > > https://bugzilla.redhat.com/show_bug.cgi?id=1830609 > > > > Regards, > > John Ralls > > I can confirm the update in bodhi resolves the issue: > https://bodhi.fedoraproject.org/updates/FEDORA-2020-24e4addb7e > > Thank you. -A > > -- > Anthony - https://messinet.com > F9B6 560E 68EA 037D 8C3D D1C9 FF31 3BDB D9D8 99B6 > ___ > 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] Managing Profit Centers, Enterprises, Projects
> On May 13, 2020 w20d134, at 5:10 AM, flywire wrote: > >> There is also a Jobs structure which can be used with specific projects > and >> allows invoices/bills to be grouped for a specific job for a single >> customer/vendor. It is discussed in the help manual > > I've reviewed that but I understand (??) it's not applicable. I'm a big fan > of the Tutorial and Concepts Guide where the examples teach you what the > terminology means and how to apply it. The ‘Jobs’ feature as I understand it is a bit misnamed. It is more like a ‘purchase order’. (there’s a filed RFE on renaming it) There is the limitation that a Job can only have *one* customer, or *one* vendor. And while a Customer Job and a Vendor Job can have the same name, they won’t be the same Job. Additionally a bill or invoice can have only one Job. see: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079310.html (Derek wrote the feature, he’s explaining it to me in that thread) It is not really a means to track revenue and expenses for a ‘project’ or client except within those very limiting circumstances. (I have a client that issues POs to Vendors but they always cover multiple orders for customers as well as for their own stock, so they can’t use the feature.) It also doesn’t help for anything outside of issuing bills and invoices. There’s no way to manually associate transactions with Jobs as best I can tell. > > Back to the camel farm. Just say you sell a sheep in Oz. If you have a road > train full ( > https://img.izismile.com/img/img3/20100721/640/road_trains_640_26.jpg ) > then no worries, but if it's one you had better eat it because the proceeds > wouldn't cover the bookkeeping cost. With fees, levies, industry funds, > different tax treatments, various parties - there's 20 splits for that > transaction (could be more if it has a lamb) so when you multiply it by the > subaccounts, well, it's a suicide risk. > > https://bugs.gnucash.org/show_bug.cgi?id=113772#c6 Yes, sub-accounts (or separate trees even) can get very unwieldy very quickly even with the simplest cases. A Category/Tag feature is really the only solution that covers most if not all cases. (that legitimately belong in one book) I’m not sure how much work it would be, but I suggested in Comment 22 on that bug to first expand the filtering option to all cells for every report. (and add the option where it doesn’t yet exist for a report, making it standard) This way, without even adding another table or tables, users can tag in any manner they wish, with as many tags as they like for even the same transaction (multi-dimensions) and be able to run reports to analyze their activity. Since this type of accounting is really about crafting reports, I figured that’s probably where the focus should be. And since Regex is already built in to the option, that is quite powerful indeed. Later, when GnuCash becomes a proper database app, table or tables can be added to allow the user to name those other dimensions they need, and maybe even name the dimension itself and use that name in the UI where appropriate. (So that one could have a list of ‘projects’, ‘jobs’, ‘properties’, ‘relatives’, etc.) 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: > > This seems
Re: [GNC] Open two files at once
The command suggested by Robert Kesterson works very well for me. I have been using it in Terminal to keep two sets of books open while I found the time to create an automator script to add to my startup routine. Thank you for that, Robert. However, there is one small problem. Appending the ampersand to the command does indeed launch GnuCash in the background, but it does not completely relinquish the foreground. When I run this command in Terminal, the prompt does not come back until I press return. In contrast, when I run other commands with the ampersand, the prompt returns immediately. I believe this is important because when i enter the command through Automator or and AppleScript with do shell script "/Applications/Gnucash2.app/Contents/MacOS/Gnucash /Users/john/Dropbox/Finances/Finances.gnucash &” the script does not return until I quit out of GnuCash. That means that I cannot use this command to launch GnuCash as part of my startup routine. So, how do I get the command line to come back without any user input? Thanks, John On 24 Apr 2020, at 3:35pm Robert Kesterson wrote: > OK try this instead. In your shell do: > > /Applications/GnuCash/Contents/MacOS/GnuCash > path_to_your_data_file_here.gnucash > > That should still work for multiple instances too. I just opened up my > Alfred scripts and realized that’s actually how I’m doing it now too > (I’m on Mojave as well). That will hold your terminal open while it > runs, btw. If you want to detach it from the terminal, just end it with > an ampersand. Like so: > > /Applications/GnuCash/Contents/MacOS/GnuCash > path_to_your_data_file_here.gnucash & > > That will detach the Gnucash process and give the command prompt back > right away. ___ 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] Money Manager Ex for Android
Dear All, I previously attempted to use GNUCash for Android. It did not end well and was exceptionally painful and time consuming to resolve all the issues. I am very comfortable and happy with the desk top version. I have come across Money Manager Ex for Android. I wondered if anyone had experience of using this in conjunction with GNU Cash whether it was successful. Further is it easy to import the chart of account from GNUCash into Money Manager Ex -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Managing Profit Centers, Enterprises, Projects
As always, thanks for your considered advice David. It's a single entity where everything is shared except for specific income and expenses. Separate books are not-on. I'm understanding you are suggesting a separate subaccount for each Enterprise/Project under the existing CoAs (eg Expenses:Maintenance:Camel farm). Every report would be customised for each Enterprise/Project. > What you are required to do... I'm not an accountant so in Oz I assume it's: ... provide evidence for amounts in any tax returns if requested (ie give them the shoebox). > There is also a Jobs structure which can be used with specific projects and > allows invoices/bills to be grouped for a specific job for a single > customer/vendor. It is discussed in the help manual I've reviewed that but I understand (??) it's not applicable. I'm a big fan of the Tutorial and Concepts Guide where the examples teach you what the terminology means and how to apply it. Back to the camel farm. Just say you sell a sheep in Oz. If you have a road train full ( https://img.izismile.com/img/img3/20100721/640/road_trains_640_26.jpg ) then no worries, but if it's one you had better eat it because the proceeds wouldn't cover the bookkeeping cost. With fees, levies, industry funds, different tax treatments, various parties - there's 20 splits for that transaction (could be more if it has a lamb) so when you multiply it by the subaccounts, well, it's a suicide risk. https://bugs.gnucash.org/show_bug.cgi?id=113772#c6 > ___ 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
Hmm.. Not sure why I had Transaction Report in my head. If the report in question is the TXF then indeed that price source option exists and selecting ‘Nearest Transaction Date’ *should* produce the correct results. Regards, Adrien > On May 12, 2020 w20d133, at 10:47 PM, Christopher Lam > wrote: > > The Transaction Report will convert a split amount to the nearest price if > required. > > I think the OP is reporting issues with the TXF report. > > On Wed, 13 May 2020 at 03:44, Adrien Monteleone > wrote: > The Transaction Report doesn’t offer this option. (not sure when it was > removed or if it was never there) > > But I too suspect this is the case. > > Regards, > Adrien > > > On May 12, 2020 w20d133, at 9:44 PM, D. wrote: > > > > 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Tracking Currency Transaction Gains
As of mid 2020, Stefan's option 2 is still the only way to go. It achieves what is required by the OP, and given where gnucash is right now, is probably the only way to go for a foreseeable future. Just a note to developers who have done an absolutely amazing job pulling together this project. Your efforts are fantastic, you just need somebody who business advisory services to indicate which options and interfaces are industry standard at present. Accounting for FX is one problematic area where an industry partnership would be very beneficial to the development team. Right now it feels a bit too raw despite 10+ years of development. It's not to blame the developers, but rather a major improvement point for those who drive the roadmap and interface with the accounting profession. Peter Selinger is a good starting point, but he's not an accountant and hence he does not understand UI choices which are out there in the business world. You really need industry experience. In any case, after spending a few days playing around with the system here's my 2c on the current shape of gnucash: - absolutely fine for keeping personal income/expenditure books - fine (although slightly cumbersome) for basic investment portfolio management - lacking for more sophisticated financial instrument including FX, futures, options etc (I spent a serious effort hacking it as required functionality is not present out of the box). - inappropriate for any institutional investments management. It is simply too cumbersome, too limited or non existing options for complex instruments, no productivity/interfacing considerations for an investment business - lacking but doable for small businesses as long as there's no FX or other complex accounting entries - inappropriate for either SME with FX or complex accounting entries, or anything with more than 1 person at the helm. Alternatives: - proprietary investment portfolio applications (cost may be justified if your focus is productivity + reporting functions) - proprietary accounting software such as Sage (but stay away from cloud implementations (MYOB, Xero etc as you will not own data) - open source ERM systems such as Tryton (but still very raw and I would personally not recommend touching it directly unless you have a dev team) My personal choice: - gnucash is fine for keeping track of my investments (although I wasted a lot of effort hacking it) - Sage as a SME platform (my time is the most dear resource and I'm happy supporting a commercial solution which delivers on productivity and support) - running it under a Windows VM. Again thank you for a fantastic open-source personal finance management solution! Happy hacking! Although not strictly foreseen by the documentation, it is in fact possible to have the realized gain/loss transaction separate. The method to create that transaction is in fact very similar to the above: Start entering a new transaction for the realized gain/loss, choose the Income:Gain or Expense:Loss account. Then in *expanded* (transaction journal) mode enter the gain/loss in the income/expense split (*). The Edit Exchange Rate dialog comes up, choose "To Amount" = 0. Enter. Gnucash will automatically create the transaction into the trading account and the result is exactly what Peter Selinger recommends for this purpose. (*) Note: It is important not to enter the amount in the collapsed (single-line) view, as that would be interpreted as foreign currency (EUR) amount, but we want this part to be empty in the end: The final transaction shall have an empty row for the foreign currency (EUR) account - this is good since it makes the transaction show up in the EUR account (together with the corresponding 'sell' txn). If this behavior is not wanted, just remove the empty EUR account split line from the transaction, then the gain/loss is visible only in the corresponding Income/Expense account. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Backup to encrypted 7zip file
Er ... no encryption. https://wiki.gnucash.org/wiki/FAQ#Q:_Can_you_please_add_a_password_feature.3F ...[No] The actual problem is access to personal data on a work supplied computer. An optional program based backup is more appropriate. GnuCash won't install but thankfully there is a portable version https://bugs.gnucash.org/show_bug.cgi?id=797740 > ___ 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.
