Quicken For Mac 2016

  1. Quicken For Mac 2016 Budgeting
  2. Quicken Alternatives For Mac 2016
  3. Quicken 2016 Mac Mortgage
Home›Quicken for Mac›Errors and Troubleshooting (Mac)
edited August 2018 in Errors and Troubleshooting (Mac)
I'm using Quicken for Mac 2016. I attempted to set up categories for reducing the outstanding loan amount each month and then an interest expense category. I believe I have 'totally screwed up' the loan account I originally set up by messing with categories including a transfer category. Can anyone point me to a video and/or other help that will show and explain categories and transfers.as it relates to mortgage loans.. how they look in the split display? Thanks in advance.

Quicken For Mac 2016 Budgeting

Quicken For Mac 2016
  1. If you’ve finally had it with the Mac version of Quicken, we’ve taken a closer look at the best Quicken alternatives for Mac of 2019. Quicken for Mac has lagged behind the Windows version for years and even though Quicken 2019 was an improvement, the decision to make it subscription only was the final straw for many faithful users.
  2. See how Quicken for Mac 2016 makes it easy to plan and stay on a budget. Plan your spending to achieve the goals important to you. Now customize your budget with.

These are some help guides I prepared for users new to Quicken for Mac 2015.

Quicken For Mac 2016

Comments

  • edited August 2018
    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited March 2017
    HQ, let me use some round numbers to illustrate. Let's say your mortgage balance is $150,000, and your monthly mortgage payment is $1,000. You pay your mortgage out of your checking account. You've created a Liability account called 'XYZ Mortgage Co.' with an opening balance of $150,000. (If you have questions on how to do any of that, write back.)
    Now, in your checking account, you're going to enter your mortgage payment. You enter a payment to XYZ Mortgage Co. for $1,000. Click on the Split icon. Your first split line is going to be the amount of principle paid off for this month, and the second spit line is going to be the interest paid for this month. You'll need either your mortgage statement or an amortization spreadsheet to know what those values are each month. Let's say the first month is $400 principle and $600 interest. So here are your split lines:
    Split line 1
    Category is Transfer
    Transfer is XYZ Mortgage Co.
    Amount is -400.00
    Split line 2
    Category is Home:Mortgage Interest
    Amount is -600.00
    That's it. After entering this transaction in your checking account, your checking account is reduced $1,000, your loan balance is reduced $400, and you have $600 in interest expense.
    You can set up this transaction in your checking account as a recurring monthly transaction by clicking the Schedule button in the bottom toolbar. Then, each month, you'll have to take a few seconds to edit the transaction for the correct split between principle and interest.
    If part of your monthly payment goes to an escrow account for real estate taxes, that's pretty easy to add to the equation. Create a new Asset account called Escrow, and enter the current balance in your escrow account. Then add a third split line to your monthly transaction for the amount paid to your escrow account: Category=Transfer, Transfer=Escrow Account. Then when you get a tax bill that is paid from your escrow account, you'd make an entry in the escrow account with the Payee='My School District' and the Category=Taxes:Property Tax.
    Write back if any of that doesn't make sense!
    QMac 2007 & QMac Subscription • Quicken user since 1993
  • edited November 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    My 8 year old grandson loved it and surprisingly my son and daughter in law liked it as well My husband also likes it. Macaroni and cheese with crumb topping.

    Thanks for your response. First, I should add my mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly created a category for the monthly principal.
    Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to.
  • edited December 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you have a statement that shows the actual principle from each payment, then the balance is either escrow, fees, or interest. If you have no escrow or fee amounts, then the full amount left over is interest and can be added to the interest line of the split transaction.
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited March 2017
    Thanks for your detailed explanation. It all makes sense.
    I'm still ground up trying to figure out how to reverse my mistakes.
    I'll just add my update to the other Super User in terms of where I am. Feel like I'm in a Quicken maze that I created and can't find my way out! ;-)
    My mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly create a category for the monthly principal and messed up the transfer that resulted from my download from the mortgage company.
    Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to.
    Thanks again.
  • edited December 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    Forgot to say:
    the principle portion is what gets placed in the transfer line of the split transaction to your loan account.
    So bottom line is, you should go to the bank account side of the transcation and adjust each one to be a split transaction; one line of the principle, which will be a transfer to your loan account, the second line is for the interest (add more lines for the escrow and fees as applicable).
    Now on the mortgage loan side, you probably will end up with duplicates: one created from the downloaded data from the FI/bank, the other created from the transfer from the bank account entries you are editing. You will need to delete the transactions in the mortgage loan account downloaded from the bank.
    Then you should reconcile the mortgage loan account with the remaining transactions against your mortgage statement.

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited December 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    Once you get through that, you will need to make sure all is set up correctly for future transactions.
    Since you already have the loan account created, you will need to make sure you have the loan payment created as scheduled transaction to your bank account. Then every payment, you will apply the payment and modify the principle and interest lines as needed.
    After all is set up, I would recommend one of 2 choices:
    • Only download your data for the bank account FIRST. This will allow you to match the download to your scheduled transaction and apply it to your bank account, with the edits you need to make to the split lines. Then you can download you mortgage loan account data, which should then match your newly applied entry into your bank and mortgage account, via the transfer line of the split transaction
    • OR FIRST apply the loan payment to your bank account BEFORE you download ANY data, again applying any edits to each split line. THEN you can download the data for your bank account and your mortgage loan account. In this case, the order does NOT matter.
    Once your data are downloaded, then you will be able to reconcile the bank account with its statement and the mortgage loan account with the mortgage loan statement.
    HTH.

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited December 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    ONE CORRECTION re: 'You will need to delete the transactions in the mortgage loan account downloaded from the bank.'
    You may not need to perform this step. Instead..you may be able to match the duplicates by dragging one over the other. This should allow Quicken to learn the matching criteria and improve the matching for future downloads of your mortgage loan data.

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited November 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    Wow. Do appreciate all this help! Now, I'll have to digest and execute. Needless to say, it's clear why you're designated a super user. A future version of Quicken for Mac automating some of this will be greatly appreciated.
  • edited December 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    You can now VOTE for the feature for Loan Amortization, here:
    https://getsatisfaction.com/quickencommunity/topics/loan-amortization-in-quicken-for-mac-2016
    Be sure to click on the link above to go there, then click VOTE at the top or THAT page to increase the count and therefore its visibility to the developers.
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited November 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    Thanks again for your help!! Got it all straightened out . Quicken Mortgage Loan account is spot on..principal and interest amounts all square with the Mortgage Company balance. Made my weekend work with Quicken for Mac and I learned a lot!
  • edited December 2016

    I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
    Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
    Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
    (it mentions Quicken Essentials but it equally applies to QM2016).
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    Good going!

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited December 2016

    Thanks for your detailed explanation. It all makes sense.
    I'm still ground up trying to figure out how to reverse my mistakes.
    I'll just add my update to the other Super User in terms of where I am. Feel like I'm in a Quicken maze that I created and can't find my way out! ;-)
    My mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly create a category for the monthly principal and messed up the transfer that resulted from my download from the mortgage company.
    Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to.
    Thanks again.

    HQ, we can work this through and get you fixed up!
    First, I wanted to clarify what you are downloading. Is it *just* transactions from your checking account bank, or are you also downloading something from Quicken Loans? Here's why I'm asking.. If it's just your checking account, then the split you create will transfer the portion of the payment that is principle to transfer to -- and reduce the balance of -- your loan account. But if you are also downloading transactions from Quicken Loans then you already have a transaction reducing your principle, and the approach in Quicken would be different.
    I think I know what's happening, but before I go off on a wrong tangent, could you fill in a few details by saying what is one of the transactions is currently. Just use round dummy numbers, but tell me the total amount of the transaction, and then what the existing split lines are (category, transfer, amount).
    QMac 2007 & QMac Subscription • Quicken user since 1993
  • edited November 2016

    Thanks for your detailed explanation. It all makes sense.
    I'm still ground up trying to figure out how to reverse my mistakes.
    I'll just add my update to the other Super User in terms of where I am. Feel like I'm in a Quicken maze that I created and can't find my way out! ;-)
    My mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly create a category for the monthly principal and messed up the transfer that resulted from my download from the mortgage company.
    Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to.
    Thanks again.

    Thanks for your follow-up! Fortunately, I was able to clear up the issue by relinking the downloaded mortgage payments to the loan account. Everything is balanced now. Do appreciate your help!!
  • edited August 2018
    I am disappointed that you are/have not included loan amortization. You had it in previous editions and if I had known that I would have used a different product. Now I am committed to use 15 until the end of this year. January will be another decision point.
  • edited December 2016

    I am disappointed that you are/have not included loan amortization. You had it in previous editions and if I had known that I would have used a different product. Now I am committed to use 15 until the end of this year. January will be another decision point.

    Apparently, Quicken is working on this feature, though no mention as to when it will be available. Meanwhile, to have your say, please add your vote to this feature request as noted above : https://getsatisfaction.com/quickencommunity/topics/using-quicken-for-mac-2016-for-mortgage-loan?top..
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list

Quicken Alternatives For Mac 2016

Home›Quicken for Mac›Errors and Troubleshooting (Mac)
edited August 2018 in Errors and Troubleshooting (Mac)
How do I find the renaming rules in Quicken 2016 for Mac?

Comments

Quicken 2016 Mac Mortgage

  • edited August 2018
    To my knowledge, these are not user accessible. However, as you change payee names for downloaded transactions, Quicken should learn the new names and make those substitutions for you.
    If you are not happy with how payees are being renamed, one thing you can try, is to change the setting of 'Clean up payees' under menu Quicken > Preferences > Connected Services.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • edited August 2018
    You may want to add your VOTE to Have Local Rules for Renaming Payees.

    You may also want to add your VOTE for the Ability to LOCK a payee and categorization.

    First    , click on each underlined link     above to go there, then click VOTE at the top of THAT page, so your vote will count for THIS feature and increase its visibility to the developers.
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited August 2018
    I also highly recommend that you browse through the IDEAS section of this forum and VOTE for the request of each of the missing features to be added back into Quicken for Mac..to help direct the priorities of the developers.
    To do that click on this underlined link, following the instructions then VOTE to your heart's content:
    Categorized List of IDEAS of Feature Requests and Enhancements to Vote On

    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited August 2018
    My problem is that Quicken is automatically changing entries and I want to delete a specific 'rename' rule.
  • edited December 2016

    My problem is that Quicken is automatically changing entries and I want to delete a specific 'rename' rule.

    At the moment, there is little control over this; it is an all or nothing. All you can do is turn off the 'Clean up payees' as mentioned above.
    That is why having local renaming rules would help. Be sure to add your vote for this item..
    BTW, the link above is broken (I will have it fixed). Meanwhile, here is the correct link:
    Have Local Rules for Renaming Payees

    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited April 2018

    To my knowledge, these are not user accessible. However, as you change payee names for downloaded transactions, Quicken should learn the new names and make those substitutions for you.
    If you are not happy with how payees are being renamed, one thing you can try, is to change the setting of 'Clean up payees' under menu Quicken > Preferences > Connected Services.

    Lync for mac. If you're using another language, please add both of these, and pivot between these two, with reboots in between. Sometimes the reboot isn't required, but in my case it was. A couple of things to tryOSx Yosemite now differentiates between English and English U.S.

    My renaming rules are a mess. Not sure how they got that way. Unchecking (disabling) the 'Clean up payees' feature has not prevented Quicken 2017 for Mac from continuing to rename my downloaded transactions. Even going in and manually putting the names back to what they should be has not helped. I've looked extensively at the Quicken Support pages and while Quicken for Windows offers the ability to edit the rules, Quicken for Mac does not. Why add half of a feature?
  • edited October 2017

    My problem is that Quicken is automatically changing entries and I want to delete a specific 'rename' rule.

    That is annoying. I accidentally renamed The Home Depot to another payee's name and I'd like to separate them.
  • edited October 2017

    My problem is that Quicken is automatically changing entries and I want to delete a specific 'rename' rule.

    If you just did it and you have not quit Quicken you can UNDO the changes. If you have already quit, you either have to make the changes manually or revert back to a previous copy of your data file.
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited October 2017

    My problem is that Quicken is automatically changing entries and I want to delete a specific 'rename' rule.

    Thanks for responding. I didn't notice it was happening until it was way past the point of undoing. Ugh.
  • edited October 2017

    To my knowledge, these are not user accessible. However, as you change payee names for downloaded transactions, Quicken should learn the new names and make those substitutions for you.
    If you are not happy with how payees are being renamed, one thing you can try, is to change the setting of 'Clean up payees' under menu Quicken > Preferences > Connected Services.

    Does anyone know of Quicken for Mac 2018 resolves this issue?
  • edited December 2017

    You may want to add your VOTE to Have Local Rules for Renaming Payees.

    You may also want to add your VOTE for the Ability to LOCK a payee and categorization.

    First    , click on each underlined link     above to go there, then click VOTE at the top of THAT page, so your vote will count for THIS feature and increase its visibility to the developers.
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    So I did upvote your suggestion. Is there any evidence that Quicken Corp pays any attention to these reports, suggestions, or bug reports?
  • edited October 2017

    To my knowledge, these are not user accessible. However, as you change payee names for downloaded transactions, Quicken should learn the new names and make those substitutions for you.
    If you are not happy with how payees are being renamed, one thing you can try, is to change the setting of 'Clean up payees' under menu Quicken > Preferences > Connected Services.

    There are no documented changes in this area.

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited October 2017

    You may want to add your VOTE to Have Local Rules for Renaming Payees.

    You may also want to add your VOTE for the Ability to LOCK a payee and categorization.

    First    , click on each underlined link     above to go there, then click VOTE at the top of THAT page, so your vote will count for THIS feature and increase its visibility to the developers.
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    Yes they do..we just do not get a lot of feedback, though I have received quite a few privately from the product manager acknowledging that they pay attention.
    A very public case is when an uproar occurred over Quicken's original plan to make ALL versions make your data read-only if your subscription expired, starting with QW2017 for Canada (see this thread). They backed off of that, with the exception of the Starter version. So yes, your VOTES do matter!
    (If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)

    If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.

    (Canadian user since '92, STILL using QM2007)
    Have Questions? Check out these FAQs:
    • Quicken Windows FAQ list
  • edited August 2018
    Obviously no end user should have to resort to this, but If you're comfortable with a little SQL, you can fix this yourself. This worked fine for me, but standard disclaimers apply: warranty voided, back your file up, etc. Close Quicken before doing this.
    DO THIS AT YOUR OWN RISK
    Find your data file (~/Library/Application Support/Quicken/Documents/YOURFILE.quicken/data). This is a sqlite3 datafile. You can open it with sqlite3 (or any other sqlite UI).
    Locate the database id of the vendor that things are getting aliased to. In this example, I’m using “Home Depot” as the erroneous alias. (Sqlite isn't case-sensitive).
    select Z_PK, ZNAME from ZUSERPAYEE where ZNAME like ‘%Home Depot%’

    Take note of the Z_PK value. This is used to alias payees in a different table. For this example, I’ll use the value 153.
    * Note if you see more than one primary key, you’ll need to figure out which you’re getting aliased to. You can query the ZFIPAYEE table for the incorrectly-aliased payee todo that.
    Now get the list of payees that are aliased to the one you just located:
    select Z_PK, ZALIAS, ZNAME from ZFIPAYEE where ZALIAS = 153

    You should see one or more payees. For example:
    5 153 Withdrawal Date Instacart
    46 153 Some Company
    128 153 Withdrawal Date Donut Shop
    254 153 Withdrawal Credit/Debit Card..
    For each that you want to fix, get the correct alias id:
    select Z_PK, ZNAME from ZUSERPAYEE where ZNAME like ‘%instacart%’
    That returned Z_PK = 368 for me.
    Finally, update the ZFIPAYEE table with the correct alias. Use the Z_PK from the ZFIPAYEE table.
    update ZFIPAYEE set ZALIAS=368 where Z_PK = 5
    Repeat for each incorrectly aliased payee.
  • edited August 2018

    Obviously no end user should have to resort to this, but If you're comfortable with a little SQL, you can fix this yourself. This worked fine for me, but standard disclaimers apply: warranty voided, back your file up, etc. Close Quicken before doing this.
    DO THIS AT YOUR OWN RISK
    Find your data file (~/Library/Application Support/Quicken/Documents/YOURFILE.quicken/data). This is a sqlite3 datafile. You can open it with sqlite3 (or any other sqlite UI).
    Locate the database id of the vendor that things are getting aliased to. In this example, I’m using “Home Depot” as the erroneous alias. (Sqlite isn't case-sensitive).

    select Z_PK, ZNAME from ZUSERPAYEE where ZNAME like ‘%Home Depot%’

    Take note of the Z_PK value. This is used to alias payees in a different table. For this example, I’ll use the value 153.
    * Note if you see more than one primary key, you’ll need to figure out which you’re getting aliased to. You can query the ZFIPAYEE table for the incorrectly-aliased payee todo that.
    Now get the list of payees that are aliased to the one you just located:
    select Z_PK, ZALIAS, ZNAME from ZFIPAYEE where ZALIAS = 153

    You should see one or more payees. For example:
    5 153 Withdrawal Date Instacart
    46 153 Some Company
    128 153 Withdrawal Date Donut Shop
    254 153 Withdrawal Credit/Debit Card..
    For each that you want to fix, get the correct alias id:
    select Z_PK, ZNAME from ZUSERPAYEE where ZNAME like ‘%instacart%’
    That returned Z_PK = 368 for me.
    Finally, update the ZFIPAYEE table with the correct alias. Use the Z_PK from the ZFIPAYEE table.
    update ZFIPAYEE set ZALIAS=368 where Z_PK = 5
    Repeat for each incorrectly aliased payee.
    Sounded good, until I see that I have no QUICKEN folder under APPLICATION SUPPORT..
  • edited August 2018
    You can't see the path from FINDER, but you can using TERMINAL.
  • edited August 2018
    I never did figure out how to see the file from within SQLite Manager. I could open it from Finder with the 'OPENWITH' command, but that did not show any tables.
  • edited August 2018

    I never did figure out how to see the file from within SQLite Manager. I could open it from Finder with the 'OPENWITH' command, but that did not show any tables.

    You need to right click on the Quicken file in the Finder and choose Show Package Contents. Then within the Contents folder, the file named 'data' is the one you can open with an SQLite app.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • edited August 2018

    I never did figure out how to see the file from within SQLite Manager. I could open it from Finder with the 'OPENWITH' command, but that did not show any tables.

    Thanks that worked.