Differentiate between two incomes from the same source (Q Mac)
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
-
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 Sonoma 14.7.1
0 -
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.
0
Answers
-
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 Sonoma 14.7.1
0 -
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.
0 -
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.
2