On 3/16/23 5:39 PM, Alex Aycinena wrote:
---------- Forwarded message ----------
From: Jeff <beastmaster...@hotmail.com>
To: gnucash-devel <gnucash-devel@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.
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
