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 <artsonl...@gmail.com> Sent: Wed May 13 01:57:24 GMT+05:30 2020 To: Gnucash Users <gnucash-user@gnucash.org>, Adrien Monteleone <adrien.montele...@lusfiber.net> 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 <artsonl...@gmail.com> 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.