Fix Schedule B report so it handles split transactions that include dividends correctly

Jim_Harman
Jim_Harman SuperUser ✭✭✭✭✭
In QWin US Premier 2019 R18.16 the Schedule B tax report produces incorrect results when a banking account has a split deposit transaction that includes dividend income. This was first reported here:
https://community.quicken.com/discussion/7853783/schedule-b-report-summary-amount-doesnt-match-the-sum-of-the-transactions-how-to-fix-issue#latest

I experimented with 3 Categories and varied the order of the split lines 
-- Div is dividend income
-- Int is interest income
-- Gift has no tax line. 

The order of the categories below is the order of the lines in the split transaction.

Div & Gift - OK
Gift & Div - Div amount shows as interest in the report

Int & Gift - OK
Gift & Int - OK

Div & Int - Total amount shows as dividend in the report
Int & Div - Total amount shows as interest in the report.

Here is a screenshot from a test file that illustrates the last test case. The transaction shows $3.33 of interest and $6.66 of dividends but the report shows the total amount as interest.


You can avoid these problems by recording the income as individual transactions rather than as a split, but it would certainly be good if the report worked correctly.
QWin Premier subscription
Tagged:
9
9 votes

Implemented · Last Updated

This has been implemented in the R35 release

Comments

  • Ray
    Ray Member ✭✭✭
    The problem occurs in the May 2019 R19.34 version too.
  • Ray
    Ray Member ✭✭✭
    The problem occurs in the R19.44 version too.
  • Quicken Anja
    Quicken Anja Moderator mod
    Hello All,

    The Community Support team regularly reviews long-standing posts and Ideas for relevancy and current interest. This Idea seems to have stalled and we would like to gauge the current interest in this request. 

    If you would like to see this idea implemented, please add your vote and a comment explaining how this idea would be beneficial for you. More information, including steps to vote and how to submit your own Ideas for future product features/improvements, is also available here.

    Thank you,

    Quicken Community Support Team
    -Quicken Anja
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    This is still broken as far as I know...
    QWin Premier subscription
  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    edited May 2021
    This, really, isn't a "product idea", but rather a report of a bug that needs fixing.
    SURELY, no one intended that with a split transaction the entire amount in the transaction would be assigned, in the Sched B report to the tax category of the 1st  line of the split.
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    I certainly agree that this should be treated as a bug if it is not already on the list. It is very repeatable and clearly documented here but it has been 2 years...
    QWin Premier subscription
  • Ray
    Ray Member ✭✭✭
    I agree with Jim - it is a bug that needs to be fixed. Please don't dismiss it. When I found the issue, he did extensive checking that he listed here. His example should help the programmers fix the problem.
  • Quicken Sarah
    Quicken Sarah Alumni ✭✭✭✭
    Hello All,

    Thank you for taking the time to report this issue to the Community, although I apologize for any frustration or inconvenience experienced.

    We have reported this behavior as a bug to our development teams for further investigation and resolution and in the meantime will be changing the status of this Idea to "Under Consideration" temporarily.

    Once an update is received on the ticket, the status will be updated to reflect the current situation.

    Thank you again for raising awareness to this issue!

    Sarah

    (CTP-2158)
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Thanks Sarah, if you need any help understanding or duplicating this problem, please get in touch.
    QWin Premier subscription
  • Quicken Sarah
    Quicken Sarah Alumni ✭✭✭✭
    Will do @Jim_Harman thanks! :)