Re: [GNC-dev] Tax schedule report outputting entries outside of selected date range
> > > > -- Forwarded message -- > From: Jeff > To: gnucash-devel > 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 ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] Performance regression loading account
Bug created, https://bugs.gnucash.org/show_bug.cgi?id=798788 with test file. Regards, Bob On Thu, 16 Mar 2023 at 03:38, john wrote: > Bob, > > Please open a bug report and attach your sample test file. > > Regards, > John Ralls > > On Mar 15, 2023, at 4:02 AM, Robert Fewell <14ubo...@gmail.com> wrote: > > I wanted to get some numbers on this as my test file seemed OK. > I used Calc to create a CSV transaction import file with 8402 rows and > some description columns with 16, 64 and 128 character random strings. > Used this to import several times to a new empty gnucash xml file and > added some timing for the account open command in 4.903 and 4.13 with > results below... > > With 4.903 > Description 16 Characters and 16804 unique transactions / descriptions, > 0.93, second time 0.73 > Description 64 Characters and 16804 unique transactions / descriptions, > 2.39, second time 1.67 > Description 128 Characters and 16804 unique transactions / descriptions, > 4.08, second time 2.90 > > With 4.13 > Description 16 Characters and 16804 unique transactions / descriptions, > 0.49, second time 0.35 > Description 16 Characters and 16804 unique transactions / descriptions, > 1.22, second time 0.61 > Description 16 Characters and 16804 unique transactions / descriptions, > 1.91, second time 0.93 > > Regards, > Bob > > On Tue, 14 Mar 2023 at 18:54, Maarten Bosmans wrote: > >> Op ma 13 mrt 2023 om 04:44 schreef john : >> > My first guess is that it's from creating a cache of quickfill entries >> to populate a drop-down list of possible entries similar to the way the >> transfer account field has worked for a couple of years. >> >> Yes, I've isolated it to the commit "Change the Register description >> layout cell type", Bob in CC. >> That branch adds the combobox and quickfill to the description field >> of the register. In my case those are fairly long (~100 chars) and all >> unique strings, as they come frome downloaded bank statements and >> include a timestamp, account holder, actual description, etc. So for >> my use case having a combo box to easy filling out new items is not >> that useful anyway. May be we can think of a way to adapt the >> behaviour to be useful in Bob's case (I suppose manual entry of a >> short and often reused description text), but not slow down my case? >> >> > An obvious optimization is to get a collation key with >> g_utf8_collate_key for each string and use that for doing the actual >> sorting/ordered inserting. It's still a char-by-char comparison but it >> saves having to validate and normalize the strings on every compare. >> I will have a look into storing the collated string in the QuickFill. >> That probably doubles the memory usage, but should not be too bad. >> >> Maarten >> > > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
[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. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
