Income sub category appears in Spending reports

markisgold
markisgold Member ✭✭✭

I have a transaction split into various subcategories (photos attached).

It is a deposit from social security. One of the splits is Income (Gross social security amount). The other splits are Expenses (various deductions that are taken for Medicare insurance etc.).

The individual splits are correctly defined as Income or Expense but spending reports all show the net of the transaction as an expense when each split should be treated separately.

Tagged:

Best Answer

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited October 2023 Answer ✓

    I can replicate this issue in the Spending tab report….but it does not show up in the Spending graph in the Spending tab. So the graph is working as it should be since it shows spending only.

    And the Total column appears to be calculating the Total amount correctly based upon the sum of the expense category splits.

    This is not just an issue with SSA deposit transactions. It also occurs with my IRA distribution transactions where I have split the category to list both the taxable distribution amount and also an expense for Fed income tax withheld.

    So, I think this is not a report calculation problem so much as it is a report display problem. The report is displaying the net deposit amount of the transactions but it should instead be displaying the individual expense split categories of the transaction. (Heck, it should not be displaying anything in the Deposit column as far as I'm concerned.)

    Other than this display issue it seems to be working correctly.

    Looks like we have a bug here. I have reported this to see if a Moderator would confirm this.

    Quicken Classic Premier (US) Subscription: R60.15 on Windows 11 Home

Answers

  • markisgold
    markisgold Member ✭✭✭

    The problem occurs in the Spending TAB as evidenced in the photo (and in the mobile app). The standard reports are actually OK.

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited October 2023 Answer ✓

    I can replicate this issue in the Spending tab report….but it does not show up in the Spending graph in the Spending tab. So the graph is working as it should be since it shows spending only.

    And the Total column appears to be calculating the Total amount correctly based upon the sum of the expense category splits.

    This is not just an issue with SSA deposit transactions. It also occurs with my IRA distribution transactions where I have split the category to list both the taxable distribution amount and also an expense for Fed income tax withheld.

    So, I think this is not a report calculation problem so much as it is a report display problem. The report is displaying the net deposit amount of the transactions but it should instead be displaying the individual expense split categories of the transaction. (Heck, it should not be displaying anything in the Deposit column as far as I'm concerned.)

    Other than this display issue it seems to be working correctly.

    Looks like we have a bug here. I have reported this to see if a Moderator would confirm this.

    Quicken Classic Premier (US) Subscription: R60.15 on Windows 11 Home

  • markisgold
    markisgold Member ✭✭✭

    Thank-you Boatnmaniac.

    I understand your answer and it clearly shows me what I needed, thanks!

    Especially your sentence “And the Total column appears to be calculating the Total amount correctly based upon the sum of the expense category splits” clearly shows that the total is totaling the relevant splits and not the net number that is displayed.


    Thanks for your help!

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭

    @markisgold - Exactly. BTW, a Moderator has gotten back to me and is reviewing this thread. She said she would provide response here after she looks into the matter.

    Quicken Classic Premier (US) Subscription: R60.15 on Windows 11 Home

  • Quicken Jasmine
    Quicken Jasmine Quicken Mac Subscription Moderator mod

    Hello @markisgold and @Boatnmaniac,

    I have forwarded this issue to the proper channels to have this further investigated. In the meantime, it is requested that you please navigate to Help > Report a problem and submit a problem report with log files, a sanitized data file, and screenshots (if possible) attached in order to contribute to the investigation.

    While you will not receive a response through this submission, these reports will help our teams further investigate the issue. The more problem reports we receive, the better.

    I apologize for any inconvenience! Thank you.

    -Quicken Jasmine

    Make sure to sign up for the email digest to see a round-up of your top posts.

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭

    @Quicken Jasmine - Were you able to duplicate the issue?

    Quicken Classic Premier (US) Subscription: R60.15 on Windows 11 Home

  • Quicken Jasmine
    Quicken Jasmine Quicken Mac Subscription Moderator mod

    Hello @Boatnmaniac,

    I was unable to replicate the issue, however, this could be due to the fact that I had to manually create the accounts and transactions as I do not have an IRA, SSA, etc.

    I do plan on sending this over to my team for further investigation once I receive the logs from both of you.

    Thanks!

    -Quicken Jasmine

    Make sure to sign up for the email digest to see a round-up of your top posts.

  • markisgold
    markisgold Member ✭✭✭

    Hi Quicken Jasmine,


    I think you can send to your team the question as I presented it. It’s fairly self-explanatory and the response was even more crystal clear.


    I’m sorry but I don’t know how to create log files or a sanitized data file.


    Thanks, Mark

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭

    @Quicken Jasmine - I submitted the report, logs and sanitized data file as requested.

    One thing I did not mention above is that I've observed this issue not only in my main data file but also in 3 unique test data files. I also referenced this thread in the report submitted.

    I'm actually kind of surprised that more people have not reported this bug. I'm thinking that might be because many people might not opt to display the Deposit and Total columns in that report. If one displays only the Amount column it would not be readily apparent that there is this display problem.

    @markisgold - To submit a report and upload the log files and sanitized file go to Help > Report a problem. If you want you can include a snapshot of the screen you looking at when you click on Report a problem although I think the pictures you posted above are a pretty good representation of the problem. If you don't want to send the screenshot make sure you uncheck the box for that (it is checked by default).

    All of the log files are checked by default so leave those checked.

    You will need to check the box for uploading the Sanitized data file. The process (per Quicken Help) "…creates a sanitized copy of the data file to protect your privacy. The process involves removing all your personal information, including credentials and passwords and other personal details from your accounts and transactions."

    I'm not sure how much the log files will be of help in this matter because this appears to be a Quicken software bug that is independent of any download or financial institution issue. The Sanitized data file could be helpful in identifying the cause of the issue. But I suspect that once the engineers start looking at this in their own systems they will quickly see what the problem is.

    Quicken Classic Premier (US) Subscription: R60.15 on Windows 11 Home

This discussion has been closed.