Social Security (again)

I am looking for some guidance as to how to categorize a social security check.

Have read where the "net" is entered as the payee, but I see no way to categorize.
that net. Therefore my report needs to include both categories (where the deductions went) and payee (to see the net amount)

Ideally I am looking to enter my check so a SS category report will display something like:
SS Gross
SS Medicare
SS Fed Tax
SS IRMAA
SS Net

Also search has found this link "how-to-catagorize-medicare-and-tax-withholding-taken-out-of-social-security-check-and-also-net-pay" BUT I get a permission denied when selecting.

Thanks for any help

(Quicken for Mac Deluxe)

Answers

  • Quicken_Tyka
    Quicken_Tyka Alumni ✭✭✭✭
    Hello @NJF9

    Thank you for taking the time to visit the Community to post your question, although I apologize that you have not received a response.

    I have gone ahead and unarchived the previous discussion so that you can view the previous post, I would keep in mind that the post is for the Windows version which differs from the Mac.

    What you are needing to enter is a Split transaction, you can learn more about creating a split at the link below.

    https://www.quicken.com/support/split-transactions-quicken-mac

    You will enter the net amount for the amount and enter a split for each of the categories that you would like.

    Please let us know how it goes or if you encounter any issues.

    -Quicken Tyka

    ~~~***~~~
  • volvogirl
    volvogirl SuperUser ✭✭✭✭✭
    First of all you don't enter "net" for the payee. I entered Social Security for the payee description.   I don't know Mac but in my Windows I made a deposit for Social Security net amount  and split it out like this......


    I'm staying on Quicken 2013 Premier for Windows.

  • NJF9
    NJF9 Member ✭✭
    Thank you Quicken Tyka, appreciate your efforts!
    I have proceeded as suggested.

    While perhaps I am misunderstanding, when I do this, I am able to
    categorize the Gross, Insurance, and Tax amounts. However the
    "net", while arithmetically correct is unable to be categorized.

    SO, in order to see my SS activity over the year, I have to do a
    category report (for the deductions) and a payee report (for the net)

    I would like to be able to have one report that lists the "history"
    of my SS that includes gross, deductions, and net. Is that possible?

    Thanks for any further help
  • volvogirl
    volvogirl SuperUser ✭✭✭✭✭
    You don't categorize the NET.  It is just the amount deposited in your bank account.  It is a combination of all the categories listed for gross and deductions.  Maybe a Mac user will reply with how to get a report for it.  

    I'm staying on Quicken 2013 Premier for Windows.

  • volvogirl
    volvogirl SuperUser ✭✭✭✭✭
    @jacobs Can you help?

    I'm staying on Quicken 2013 Premier for Windows.

  • NJF9
    NJF9 Member ✭✭
    Thanks @volvogirl, I understand your point.

    However, as I have other income (pension check),
    I was looking for a consolidated view of my gross,
    deductions, and net amounts.

    As an example:

    SS Gross - 100
    SS Ins - 80
    SS Net - 20

    Pension Gross - 100
    Pension Ins - 80
    Pension Net - 20

    Total Gross - 200
    Total Ins - 160
    Total Net - 40

    Now I CAN get that info, BUT I have to run a category report
    for Gross and Ins and then a payee report for the net. Payee
    in this case being a check deposit.

    Am I in the weeds here :-)
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    I can't think of a way to show gross pay and net pay in the same summary report. As you wrote, a Payee report will let you see your net pay, and a Category report will let you see your gross pay (and deductions, if you wish).

    Hmm, wait… If you create a Category report and select just the categories for gross pay and deductions, the grand total of that report will be your net pay. Assuming you use a different Payee name for the deposits from your different sources of income (your work and your pension), you can also set the Payee to just be one or the other to get the complete view of the gross, deductions, and net for that source of income. Won't that do it?
    Quicken Mac Subscription • Quicken user since 1993
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    edited January 2021
    You would only have to run the category report.  A payee report wouldn't be needed.


    Edit note, yes this is a Windows report since I'm a Windows user, but it would definitely be the same in the Mac report.
    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    edited January 2021
    BTW there is a way to get the net amount shown in a category, but it messes up the accounting.

    SS Gross 100
    SS Net 20
    SS Offset Don't include -20
    SS Ins - 80

    But this will do it, but it will also mean that you have to be aware of the fact you are double counting things, and also know when to include or exclude a given category to not get what you don't expect.

    Also if Quicken Mac ever gets an "Paycheck" selection for their budgets, this will most likely mess that up.

    All and all this isn't the way to go.  The proper accounting is a math calculation with the net being the result.
    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Chris_QPW said:
    You would only have to run the category report.  A payee report wouldn't be needed.

    @Chris_QPW  No, you're assuming there is only one source of income. In my case, I have my wife's income and mine; in NJF9's case, there is work income and pension income. A Category report will lump all that together, so you'll see your total net, but not the net for one income source, which is what NJF9 was looking for

    But as I wrote, as long as you have different Payees for each income source (e.g. multiple sources of income aren't entered as  "Direct Deposit"), the Category report can be constrained to one Payee at a time. So it would take multiple Category reports for multiple sources of income, but it would work. 
    Quicken Mac Subscription • Quicken user since 1993
  • RandyB
    RandyB Member ✭✭
    In past years, entering the Social Security, gross, subtracting Medicare premium, you would get the correct net. But not this year. Now you have to add a new category, which I call the Government skimming tax, because the net is reduced by a rounding down to even dollar amt. Which might be $0.70. In past years the government would skim it off the top line, but not this year.
This discussion has been closed.