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

On 3/19/23 8:46 PM, Alex Aycinena wrote:
> Jeff,
>
> What is the type of the account that this particular out-of-date-range 
> transaction is listed for (i.e., Income, Expense, Asset, or Liability)?
>
> It would help me to know in order to try to reproduce the problem. Is 
> it an Asset or Liability?
>
> From memory, for Asset or Liability accounts, the report is supposed 
> to show: the beginning balance, all transactions for the year, and the 
> ending balance. The beginning balance for the TXF code, that the 
> account is reported under, should correspond to the reported amount on 
> last year's return, the listed transactions allow you to verify that 
> the change for this year is correct, and the ending balance is the 
> amount to report for this year, once the verification process is complete.
>
> Thanks,
>
> Alex
>
> On Fri, Mar 17, 2023 at 2:21 AM Jeff <[email protected]> wrote:
>
>     On 3/16/23 5:39 PM, Alex Aycinena wrote:
>>
>>
>>
>>         ---------- Forwarded message ----------
>>         From: Jeff <[email protected]>
>>         To: gnucash-devel <[email protected]>
>>         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.
>
It is set for type Bank.  At the time I created the account I was not 
sure whether to treat it as an asset or a liability, as it could have 
gone either way. The funds came in from a government source, but the 
paperwork stated that it may or may not have to be paid back, "wait for 
future mailings".  That seemed the best choice at the time.

-- 
--JEffrey Black M.B.A.
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel