Re: [GNC] Report seems to pull wrong amount from transaction
Adrien Monteleone writes: > Originally I was thinking of the setting for GC to determine price by > ‘Most Recent’ or ‘Nearest In Time’, and such, but I see the > Transaction Report doesn’t have it. As indeed it shouldn't. A transaction has a fixed exchange rate, and that's the exchange rate that should be used for that transaction in the transaction report. The only arguable place where an "other" exchange rate should come in during a transaction report is if you have a transaction between X and Y but you're trying to display a report in currency Z. Then the question is, if the transaction from X to Y happens at date D, and you're running the report on date E, what exchange rate should you use for the transaction? Note that I don't think there is one right answer for this question. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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
> On May 12, 2020 w20d133, at 3:27 PM, Art Chimes wrote: > > > 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. Originally I was thinking of the setting for GC to determine price by ‘Most Recent’ or ‘Nearest In Time’, and such, but I see the Transaction Report doesn’t have it. Since you are dealing with a Fund, maybe turn on Options > Display > Shares & Options > Display > Price and see if that info provides any clues. (and if it matches the transaction info) If everything checks out, but January still shows $146, you may have a bug in the report. > > > 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. By ‘fixed it’ do you mean just that the links are to the specific transactions, or that *also* the report is showing $150 for all three transactions? I’d also open the Fund register and run an Account Report for a time period that covers the transactions to see if that report also shows $146 for January in error or if it lists them all correctly. Maybe even expand the date range on both reports to see if there are any other transaction errors as they might have something in common to lend a clue. Also, do the prices for the fund in the Price db match what should be there for the transaction? You should see entries dated the same as the various transactions with ’transaction’ noted in the ’type’ column. Finally, if those entries in the Price db are correct, do you have any intervening prices between January and February (or any other recent period for the date of the report) that might calculate to $146? The Transaction Report doesn’t have the option to choose commodity price calculation, it may be errantly taking the wrong one. (the right one would be the ’transaction’ price rather than a ‘recent’ ‘average’ or ’nearest in time’ scenario, though even that last one should match the transaction.) If there are intervening prices near those dates, maybe temporarily deleting them (and manually re-entering later if you need them) and running the report, might get you the correct figures and expose the bug. 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
Art, Art Chimes writes: > 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 Within a transaction, GnuCash stores the # shares and the total value of those shares. The "share price" is a computed value. Having said that, GnuCash also stores a "PriceDB", which contains the various share prices and exchange rates at various points in time. Using this, you can see exactly how much you spent on the purchase of the shares, and then multiplying by the PriceDB entry you can see the current value of those shares. > 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? My guess is the PriceDB. Or your "Price Source" selection in the report options. The "Weighted Average" is almost always the incorrect choice. [snip] > 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. There you go. :) > 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. It is certainly reasonable to flag a report where the pricedb entries are off by more than a few days. > Thanks all who chipped in to help solve this mystery Great community here! > > Art > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report seems to pull wrong amount from transaction
The report started out as a blank transaction report (from the Reports>Transaction Report menu pulldown), which I then modified as required. Does that qualify as a "custom report"? I never heard of trading accounts, but from what I just read in the wiki, it seems to relate to multi-currency books, and all I have is USD transactions, so that feature is not turned on. The Price Database has picked up some price points from transactions, but seems to be hit-or-miss, and it may depend on the security. If it's important I can analyze this a bit more. Art Adrien Monteleone adrien.monteleone at lusfiber.net Wed May 13 14:49:51 EDT 2020 Art, you’re welcome and I’m fine with just list messages. I’m glad you got it resolved. (just curious, is this a custom report?) The price db *should* get a ’transaction’ type entry for every such buy/sell transaction. You might need to have trading accounts turned on for that, I’m not certain. If you already do, then, you might have a bug. I track some metal holdings and while I don’t do trades often, I have transaction type entries in my price db. I haven’t done any transactions since probably v3.5 or so. Maybe there is a code regression since then. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report seems to pull wrong amount from transaction
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] Report seems to pull wrong amount from transaction
I think D. wins this round. Not exactly the right answer, but close enough that it pointed me to the explanation. I hope you'll forgive the longish explanation that follows. My report apparently uses the number of shares x the price per share to compute the dollar amount. Possibly the dollar value of the transaction is not stored in the user's data file but rather is computed on the fly? The incorrect dollar figure in the report was the product of the correct number of shares times an incorrect share price. But the share price in the account register is correct. So where is the incorrect share price coming from? The account from which the withdrawal was made is not a publicly traded fund but is a pension plan, so there is no way (that I know if) to retrieve the share price automagically. By force of habit, from my Quicken days, I enter each week's closing share prices into the Price Database. So Jan. 24 and 31, Fridays, are in there, but not the day of this transaction (Wednesday, Jan 29). That's a bit of a puzzle. I though that if I entered a transaction into an account register, it would appear in the Price Database. Maybe because I didn't enter the price manually and it was computed from the dollar value and number of shares that I did enter? Anyway, there was no entry for for Jan. 29. Anyway, I quickly determined that the incorrect dollar amount entered was the result of multiplying the number of shares times the share price on Jan 31 — the closest date in the Price Database. I manually added the correct share price for Jan. 29. And now the report has the correct dollar amounts. Problem solved. But I wonder if I should file an enhancement request that reports using a calculated value based on a close but not exact share price should be flagged (with an asterisk and footnote?) as questionable. Thanks all who chipped in to help solve this mystery Great community here! Art -- Forwarded message -- From: "D." To: Art Chimes Cc: gnucash-user@gnucash.org, Adrien Monteleone Bcc: Date: Wed, 13 May 2020 08:14:40 +0530 Subject: Re: [GNC] Report seems to pull wrong amount from transaction I'd look at the price source used in the report (on the report options). It sounds to me like the report is converting the January shares sold at the February/March price. Original Message From: Art Chimes Sent: Wed May 13 01:57:24 GMT+05:30 2020 To: Gnucash Users , Adrien Monteleone Subject: Re: [GNC] Report seems to pull wrong amount from transaction Adrien's quick reply is below (edited) with my responses. = My first inklings would be to ask: 1. Do these transactions involve other currencies? ===No, all in USD 2. Are they part of a bill/invoice that has a tax applied to a line item using the business tax tables? ===No, strictly personal account. 3. Do the specific transactions (when showing all splits) show the amount for that account as exactly $150 or $146? If the latter, what split(s) appear to balance out the $4 difference? ===That was the first think I looked at. All three transactions in my register are structured identically, but the January split is different than the two others, which are the same. (I made up the numbers, so I hope everything balances. It does in my actual account.) January transaction Assets:Checking buy 118.66 [net deposited in my checking account] Expense:Withholding tax buy 31.34 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Jan. shows on the Report as 146, NOT consistent with register))) February and March transaction Assets:Checking buy 107.45 [net deposited in my checking account] Expense:Withholding tax buy 42.55 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Both Feb. and Mar. show on the Report as 150, consistent with register))) 4. Is your account selection in the Report Options limited to that one account? Are you reporting on the account for the financial institution, where the funds come from, or from the target account where the funds land? ===Account selection in Report Options is limited to one account, the one from which the funds are taken. All three transactions involved the same dollar value (though the number of shares of the mutual fund were different). The full amount was paid out of the account (no fee charged) and received into my checking account after tax withholding was deducted. One other thing of possible relevance. I mentioned that the linked amounts in the report took me to the right account but not to the specific transaction. Now, the links go right to the corresponding transaction. I changed up a couple of things in the report (currency options), then went back to the previous options, and somehow that fixed it. Thanks for your efforts to troubleshoot this puzzling (to me) behavior! Art On Tue, May 12, 2020 at 12:29 PM Art Chimes wrote: >
Re: [GNC] Report seems to pull wrong amount from transaction
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] Report seems to pull wrong amount from transaction
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 < adrien.montele...@lusfiber.net> 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. > ___ 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 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] 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 like a bug to me, but maybe I'm missing something. > > I have an account from which I have a regular, automatic withdrawal > scheduled with the financial institution. The amount is the same every > month, let's say $150. > > My YTD report shows this year's three withdrawals to date (plus > another transaction, unrelated to the automatic ones). However, the > January withdrawal on the report shows an incorrect amount, a few > dollars less, $146. > > All three accounts were subject to tax withholding. The January > withholding was different than the later withdrawals, but otherwise > the amount withdrawn from the account was the same in all monthly > withdrawals, i.e. $150. > > A possible clue: When I click on the hyperlinked amount in the report, > it links to the correct account but not to the specific transactions. > (In other reports I spot-checked, it takes me directly to the > transaction.) > > I could not reproduce this error in a few other random reports I generated. > > Can you help? Thanks. > > Art -- Art Chimes 1117-B N. Stuart St. Arlington, Va. 22201 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ 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
Adrien's quick reply is below (edited) with my responses. = My first inklings would be to ask: 1. Do these transactions involve other currencies? ===No, all in USD 2. Are they part of a bill/invoice that has a tax applied to a line item using the business tax tables? ===No, strictly personal account. 3. Do the specific transactions (when showing all splits) show the amount for that account as exactly $150 or $146? If the latter, what split(s) appear to balance out the $4 difference? ===That was the first think I looked at. All three transactions in my register are structured identically, but the January split is different than the two others, which are the same. (I made up the numbers, so I hope everything balances. It does in my actual account.) January transaction Assets:Checking buy 118.66 [net deposited in my checking account] Expense:Withholding tax buy 31.34 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Jan. shows on the Report as 146, NOT consistent with register))) February and March transaction Assets:Checking buy 107.45 [net deposited in my checking account] Expense:Withholding tax buy 42.55 [sent to the IRS] Assets:Fund ABCDX [source of withdrawal] sell 150 [withdrawn from financial institution] (((Both Feb. and Mar. show on the Report as 150, consistent with register))) 4. Is your account selection in the Report Options limited to that one account? Are you reporting on the account for the financial institution, where the funds come from, or from the target account where the funds land? ===Account selection in Report Options is limited to one account, the one from which the funds are taken. All three transactions involved the same dollar value (though the number of shares of the mutual fund were different). The full amount was paid out of the account (no fee charged) and received into my checking account after tax withholding was deducted. One other thing of possible relevance. I mentioned that the linked amounts in the report took me to the right account but not to the specific transaction. Now, the links go right to the corresponding transaction. I changed up a couple of things in the report (currency options), then went back to the previous options, and somehow that fixed it. Thanks for your efforts to troubleshoot this puzzling (to me) behavior! Art On Tue, May 12, 2020 at 12:29 PM Art Chimes wrote: > > This seems like a bug to me, but maybe I'm missing something. > > I have an account from which I have a regular, automatic withdrawal > scheduled with the financial institution. The amount is the same every > month, let's say $150. > > My YTD report shows this year's three withdrawals to date (plus > another transaction, unrelated to the automatic ones). However, the > January withdrawal on the report shows an incorrect amount, a few > dollars less, $146. > > All three accounts were subject to tax withholding. The January > withholding was different than the later withdrawals, but otherwise > the amount withdrawn from the account was the same in all monthly > withdrawals, i.e. $150. > > A possible clue: When I click on the hyperlinked amount in the report, > it links to the correct account but not to the specific transactions. > (In other reports I spot-checked, it takes me directly to the > transaction.) > > I could not reproduce this error in a few other random reports I generated. > > Can you help? Thanks. > > Art -- Art Chimes 1117-B N. Stuart St. Arlington, Va. 22201 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report seems to pull wrong amount from transaction (errata #2)
Make that GnuCash **3.10** on Windows 10. Sorry: lousy typist worse proofreader ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Report seems to pull wrong amount from transaction
Addendum, Sorry I didn’t see the version info first. In that case, my first recommendation, before investigating any of my other questions, would be to update to 3.10 unless you really can’t for some reason. Many, many bugs have been fixed since 3.1. Regards, Adrien > On May 12, 2020 w20d133, at 1:19 PM, Adrien Monteleone > wrote: > > My first inklings would be to ask: > > 1. Do these transactions involve other currencies? > > Perhaps something is amiss with the FX rate, or the report option for > commodity pricing needs some tweaking. > > > 2. Are they part of a bill/invoice that has a tax applied to a line item > using the business tax tables? > > Something may be incorrect with the tax table, as it may be set to inclusive > rather than exclusive. If this is a VAT situation, some tinkering may be in > order. > > > > 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? > > Since you only have three transactions, viewing that account register > directly should be able to show if the amount is really $146 or $150. Make > sure to either click the Splits button or use Auto-Split or Transaction > Journal View. > > > > 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? > > If the total withdrawal was $150 but $146 of that went to say, ‘Cash’ and $4 > went to ‘Fees’ then selecting ‘Cash’ in the report options would not generate > the full $150 amount, but selecting ‘BankABC’ would. > > > Please forgive if I’m misunderstanding the issue. > > Regards, > Adrien > > > > > >> On May 12, 2020 w20d133, at 11:29 AM, Art Chimes >> wrote: >> >> This seems like a bug to me, but maybe I'm missing something. >> >> I have an account from which I have a regular, automatic withdrawal >> scheduled with the financial institution. The amount is the same every >> month, let's say $150. >> >> My YTD report shows this year's three withdrawals to date (plus >> another transaction, unrelated to the automatic ones). However, the >> January withdrawal on the report shows an incorrect amount, a few >> dollars less, $146. >> >> All three accounts were subject to tax withholding. The January >> withholding was different than the later withdrawals, but otherwise >> the amount withdrawn from the account was the same in all monthly >> withdrawals, i.e. $150. >> >> A possible clue: When I click on the hyperlinked amount in the report, >> it links to the correct account but not to the specific transactions. >> (In other reports I spot-checked, it takes me directly to the >> transaction.) >> >> I could not reproduce this error in a few other random reports I generated. >> >> Can you help? Thanks. >> >> Art ___ 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
My first inklings would be to ask: 1. Do these transactions involve other currencies? Perhaps something is amiss with the FX rate, or the report option for commodity pricing needs some tweaking. 2. Are they part of a bill/invoice that has a tax applied to a line item using the business tax tables? Something may be incorrect with the tax table, as it may be set to inclusive rather than exclusive. If this is a VAT situation, some tinkering may be in order. 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? Since you only have three transactions, viewing that account register directly should be able to show if the amount is really $146 or $150. Make sure to either click the Splits button or use Auto-Split or Transaction Journal View. 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? If the total withdrawal was $150 but $146 of that went to say, ‘Cash’ and $4 went to ‘Fees’ then selecting ‘Cash’ in the report options would not generate the full $150 amount, but selecting ‘BankABC’ would. Please forgive if I’m misunderstanding the issue. Regards, Adrien > On May 12, 2020 w20d133, at 11:29 AM, Art Chimes wrote: > > This seems like a bug to me, but maybe I'm missing something. > > I have an account from which I have a regular, automatic withdrawal > scheduled with the financial institution. The amount is the same every > month, let's say $150. > > My YTD report shows this year's three withdrawals to date (plus > another transaction, unrelated to the automatic ones). However, the > January withdrawal on the report shows an incorrect amount, a few > dollars less, $146. > > All three accounts were subject to tax withholding. The January > withholding was different than the later withdrawals, but otherwise > the amount withdrawn from the account was the same in all monthly > withdrawals, i.e. $150. > > A possible clue: When I click on the hyperlinked amount in the report, > it links to the correct account but not to the specific transactions. > (In other reports I spot-checked, it takes me directly to the > transaction.) > > I could not reproduce this error in a few other random reports I generated. > > Can you help? Thanks. > > Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report seems to pull wrong amount from transaction (errata)
I'm using GnuCash 3.1 on Windows 10. Sorry for my violation of a cardinal rule of posting here. Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Report seems to pull wrong amount from transaction
This seems like a bug to me, but maybe I'm missing something. I have an account from which I have a regular, automatic withdrawal scheduled with the financial institution. The amount is the same every month, let's say $150. My YTD report shows this year's three withdrawals to date (plus another transaction, unrelated to the automatic ones). However, the January withdrawal on the report shows an incorrect amount, a few dollars less, $146. All three accounts were subject to tax withholding. The January withholding was different than the later withdrawals, but otherwise the amount withdrawn from the account was the same in all monthly withdrawals, i.e. $150. A possible clue: When I click on the hyperlinked amount in the report, it links to the correct account but not to the specific transactions. (In other reports I spot-checked, it takes me directly to the transaction.) I could not reproduce this error in a few other random reports I generated. Can you help? Thanks. Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
