Differentiate between two incomes from the same source (Q Mac)

Nibblemac
Nibblemac Quicken Mac Subscription Member

I would like to differentiate two separate incomes from the same source (ie. Social Security or people who worked for the same company.) When downloading incomes I'm always having to reenter the taxes and deductions for each income. I would like to find a way to not have to continuously update the downloaded transactions. I've tried quick fill transactions but then have to delete the downloaded transaction. Can the downloaded transactions be differentiated by the amount rather than the Payee?

Best Answers

  • MontanaKarl
    MontanaKarl Quicken Mac Subscription Member, SuperUser, Mac Beta Beta
    Answer ✓

    AFAIK, the amount cannot be used to distinguish quick fill rules. I distinguish my wife's vs my social security by having them as scheduled monthly transactions. The download then matches the payee/amount.

    You don't need to delete the downloaded transaction. By dragging it on top of the manually created/edited transaction it will be seen as a 'match'. If the manual transaction is entered before the download date (as in my schedule social security example), it will simply match automatically upon download.

    Quicken user since 1990, MacBook Pro M2 Max on Sequoia 15.1.1

  • UKR
    UKR Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓

    As mentioned by @MontanaKarl above, Scheduled Reminder Transactions, recorded BEFORE the download arrives, would help in your situation.
    You need one each for each separate Income transaction. When setting up these scheduled transactions …
    Use distinct Payee Names, e.g., "Soc Sec - Self", "Soc Sec - Spouse"
    For income and deductions set up and use appropriate categories, assigned to the correct Tax Line Items, e.g.,

    • for your Soc Sec Income use a category with tax line item "Form 1040: Soc Sec Income, self"
    • for your spouse's Soc Sec Income use a separate category with "Form 1040: Soc Sec Income, spouse"

    This will help keep your separate incomes in separate categories, ready for tax reporting.

Answers

  • MontanaKarl
    MontanaKarl Quicken Mac Subscription Member, SuperUser, Mac Beta Beta
    Answer ✓

    AFAIK, the amount cannot be used to distinguish quick fill rules. I distinguish my wife's vs my social security by having them as scheduled monthly transactions. The download then matches the payee/amount.

    You don't need to delete the downloaded transaction. By dragging it on top of the manually created/edited transaction it will be seen as a 'match'. If the manual transaction is entered before the download date (as in my schedule social security example), it will simply match automatically upon download.

    Quicken user since 1990, MacBook Pro M2 Max on Sequoia 15.1.1

  • UKR
    UKR Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓

    As mentioned by @MontanaKarl above, Scheduled Reminder Transactions, recorded BEFORE the download arrives, would help in your situation.
    You need one each for each separate Income transaction. When setting up these scheduled transactions …
    Use distinct Payee Names, e.g., "Soc Sec - Self", "Soc Sec - Spouse"
    For income and deductions set up and use appropriate categories, assigned to the correct Tax Line Items, e.g.,

    • for your Soc Sec Income use a category with tax line item "Form 1040: Soc Sec Income, self"
    • for your spouse's Soc Sec Income use a separate category with "Form 1040: Soc Sec Income, spouse"

    This will help keep your separate incomes in separate categories, ready for tax reporting.

  • Nibblemac
    Nibblemac Quicken Mac Subscription Member

    Thank you all for your solutions. I am very pleased with all the information provided. It was all very helpful and resolved the issue completely.

This discussion has been closed.