[GNC-dev] Tax schedule report outputting entries outside of selected date range

[Alex Aycinena]

>
>
>
> ---------- Forwarded message ----------
> From: Jeff <beastmaster126 at hotmail.com>
> To: gnucash-devel <gnucash-devel at gnucash.org>
> Cc:
> Bcc:
> Date: Thu, 16 Mar 2023 01:18:08 -0500
> Subject: [GNC-dev] [GNC] Tax schedule report outputting entries outside of
> selected date range
> I'm trying to generate a tax report (federal 1040) for entry into my tax
> software, as I do every year and have never ran into this issue.
>
> Not sure of the version of GNC I'm running on Windows 10.  Running Version
> 4.13 Build ID: Flathub 4.13 Finance Quote: 1.5301 under Ubuntu 20.04 LTS.
>
> Both versions are including a transaction from 07/02/2020 when the date
> range for the report is 01/01/2022 to 12/31/2022. The transaction of
> concern is listed as "Tax Report Only - No TXF Export".
>
> I have limited internet access right now so I can not confirm that this is
> a known bug.  My concern is that the report may also be skipping
> transactions from 2022.  I have exported the report as a pdf file with no
> options selected other than the time frame, and the transaction shows up
> there as well.  If I edit the options to suppress $0, no printing of full
> account names/action:memo data/transaction detail, and print TXF export
> parameters, the errant transaction shows up.
>
> Any ideas why?
>
> --
> --JEffrey Black M.B.A.
>
>
What is the TXF code on the report for the errant transaction? '000' or '
N000'? That is the only TXF code that has that description (Tax Report Only
- No TXF Export).

If you go to the account that the report has that transaction listed under
in the Edit->Tax Report Options panel, is the account set as 'Tax Related'?
If so, should it be? And if it should be, should it have another
Form/Schedule item selected? If changes to this account are warranted and
made, does the errant transaction still appear or go away?

Before entry into your tax software, you can get comfortable that the other
Income Tax Report totals are correct by comparing the account totals to
totals for the year of other reports. If there are unexpected differences
(there shouldn't be), the transaction detail in the Tax Report can help you
figure out what it is.

There is a TXF code, 521 for 'Federal estimated tax, qrtrly' which has
special date processing for calendar date ranges, as explained in the
description for that code, to catch the Jan 15 payment made the next year.
Other than that, all splits selected to generate the report should be in
the date range.

In any case, I don't understand why a 07/02/2020 transaction should appear
in the report if the specified date range is 01/01/2022 to 12/31/2022. I
will try to replicate the error with test data and look at the code to see
if I can figure it out.

Look forward to your response to my questions above.

Alex