Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO
Fix Schedule B report so it handles split transactions that include dividends correctly

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.
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.
-- Jim QWin Premier subscription
Tagged:
7
Comments