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

[Jeff]

On 3/16/23 5:39 PM, Alex Aycinena wrote:
>
>
>
>     ---------- 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

The TXF code for that account is '000'.  This particular account was 
required on a prior years return (actually the number of payments was 
required, not the sum total) but; there is no corresponding tax 
form/line number for it, hence the reason for selecting "Tax Report Only 
- No TXF Export".  The only reason I caught it in the report, is that it 
was for Covid related income, and I knew that there was none in 2022.

The 'Income Tax Identity' is set for 'Individual, Joint, etc. - Files US 
form 1040'.

Just as an experiment I added a transaction for $1 into that account for 
'03/17/2021' and it summed it to the total as well in the report for 
2022. If I remove the account from the tax related entries it disappears.

So far, this one account is the only trouble maker that I have discovered.

As for the TXF code, 521 for 'Federal estimated tax, qrtrly', I have not 
had to use it in years.  Now I remember why the need for special date 
processing (thanks for the refresher).

Ah-ha.  I see what it is doing, just not how to get rid of it in the 
report, short of adding a t account to zero it.  Most of the accounts 
that I have set for "Tax Report Only - No TXF Export" have transactions 
posted in 2022 and behave as I expected.  I just noticed that I have not 
manually entered the depreciation in some specialty accounts for 2022 so 
I end up with the last balance that the account had (irregardless of the 
date of the last entry), not $0.00 if no entries for 2022.  That is why 
the Covid payment is showing up, there have been no entries since it was 
posted so it gives me the current amount still in that account.  Thus, 
any of the deprecation accounts that have no entries for 2022 are 
showing me misleading values for 2022 if they have never been updated or 
brought to a balance of $0.00.  I will have to manually go through every 
account of type "Tax Report Only - No TXF Export" and enter the 
balancing transactions that I missed.

-- 
--JEffrey Black M.B.A.