HomeQuicken for MacBank Accounts, Downloading, and Categorizing (Mac)

Mac

Dec 21, 2016  And regardless, you can use the version forever and download transactions from banks that connect directly or import a downloaded data file for transactions that don’t connect directlywithout added charge or a drop dead termination date. See Finance 2 will do the same as Quicken Macfor about $30.

in Bank Accounts, Downloading, and Categorizing (Mac)
I am unable to drag one transaction on top of another to eliminate the duplicates in my bank transactions after a Quicken for Mac download. For example, I have a certain amount automatically deposited in my checking account every month. I enter it manually and when I download the transactions from my bank I now have two deposits. I thought I was supposed to be able to drag the bank version on top of my manually entered version (or vice versa) and the two would merge. I thought this is how Quicken for Mac 'learned' the transaction. This happens every month and I have to delete the downloaded bank transaction. This behavior throws my balances off. This is just one example. It is a frequent occurrence with the bank checking and savings accounts. My bank is Wells Fargo and I am running Quicken for Mac 5.11.0 on Mojave 10.14.4.

Best Answer

  • Accepted Answer
    In that case, I'd contact WF support. Since it's Direct Connect, the server connection is directly to the bank and it would appear that they are sending duplicate transactions. You could also try Quicken support, but I think I'd start with WF first.
    Quicken Mac Subscription; Quicken Mac user since the early 90s

Answers

  • Yes, dragging and dropping is the correct way to match a manually entered transaction to a downloaded one.
    Transactions, however, can only be matched once-you can't match more than once. I do. I don't know if that is your situation, but it could be.
    Also, make sure you have the manually entered transaction in the correct account. If you are looking at a global account view with multiple accounts intermixed, then you might not notice that the manually entered transaction is in the wrong account.
  • I am in the correct account. Here is the situation - I have entered the manual transaction and when I download I notice that the bank has also downloaded a transaction. It has a different name (the bank has named it) but the same amount. In addition, my manual transaction and the bank transaction are checked blue (matched). So I am under the impression the bank has recognized a transaction. I try to drag one transaction over another but it does not merge (or learn). Do you think I should uncheck them both and then try to drag? Also, what exactly do you mean by it “can only be matched once?” Thank you so much for responding.
  • edited April 12
    The blue check does not mean matched. It means cleared. It will probably help you to turn on the Matched Status column to see what's going on. Click menu View > Columns and enable Matched Status.
    It sounds like there may have been two transactions downloaded. One matched to an existing transaction and one came in as new. If a downloaded transaction auto-matched to the wrong one, you can unmatched them by right-clicking on the transaction and choose Reject Automatic Transaction Match.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • Ok. Former Windows Quicken user here . #learningcurve. I’ll turn on that column. Could be a couple of days before I see another transaction. Thank you.
  • So, it happened today. Yesterday I entered a manual transaction for something I purchased from my checking account. Today the bank download matched (matched (auto)) the manual transaction and also downloaded a transaction. I cannot drag one over the other to keep the one I want. The only choice I have to get rid of the transaction marked 'Downloaded' is to delete it. I do have a box checked in Preferences, Connected Services to 'Automatically improve the quality of downloaded payee names and categories' if that makes any difference. I want the manual transaction not the downloaded one. It happens frequently enough to be annoying. I Here is a screen shot:
  • edited April 13
    Ok, I did discover something, but it is still a two step process and does not always work. If I go in and reject the automatic transaction match I can then drag and drop. But in the case of the screen shot above it got even more complicated. The downloaded transaction was from PayPal. When I rejected the automatic transaction match I ended up with two dowloaded transactions as you an see from the following screen shot. I think until I can figure this out I'll just delete the downloaded transaction and keep my manual one.
  • This confirms what I suspected. Two copies of the transaction are downloading. One of them is matching and the other isn't (because only one download is allowed to match to a manual transaction). The problem, therefore, is not the matching, but is instead the duplicate downloaded transaction.
    Please let us know what bank this is with and what connection method (Quicken Connect or Direct Connect). That may help lead to an answer.
    In any case, I think you should contact support and report that you're getting duplicate transactions downloaded. To really figure out what's going on will probably require digging into the log files, which is not something we can really help with easily here on the forum.
    To contact support, click the Help link at the top of this page and scroll down to the blue banner.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • edited April 13
    Wells Fargo (no surprise here I do not believe WF is not very respectful of Quicken . I know I was using Direct Connect when I was on the Windows version. We get charged $3/month. How do I find what kind of connection in the Mac version? (I did try searching and couldn't find an answer.)
  • Open the account settings (menu Accounts > Settings...) and you'll see the connection type on the 3rd line from the top.
    If it's Quicken Connect, you may want to consider using Direct Connect instead (even though as you say, WF charges monthly for this). For me personally, I won't do business with a bank that doesn't provide D/C for free. As Clark Howard says, I'm not a fan of the big monster mega banks.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • 0
  • Accepted Answer
    In that case, I'd contact WF support. Since it's Direct Connect, the server connection is directly to the bank and it would appear that they are sending duplicate transactions. You could also try Quicken support, but I think I'd start with WF first.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • 0

John M,
Here's a suggestion that I have posted several times for Quicken for Windows users depositing invoice or rent payment checks. You can use a similar approach in Q Mac. This will allow you to match a single downloaded deposit transaction to a single checking account register deposit entry yet maintain individual transactions with detailed information for each check received.

Match

Intermediate deposit account for H&B or RPM:

Quicken 17 For Mac Manual Match Downloaded Transactions Free

When you receive
multiple payments by check per day but only make one summary deposit to your
bank ...

Quicken 17 For Mac Manual Match Downloaded Transactions 2016

- Create a cash (or
manual checking [*]) account, named something like 'Checks to
Deposit' with an Opening Balance of $0.00


- When filling out
the New Customer Payment form, deposit the check to 'Checks to
Deposit' instead of your regular bank checking account.

Quicken 17 For Mac Manual Match Downloaded Transactions


- At the end of the
day, tally up all checks on your deposit slip. In Quicken, in the 'Checks
to Deposit' account make a transfer transaction 'Daily Deposits'
in the amount of your deposit slip. Put the amount into the Payment column. As
category choose your checking account, surrounded by [square brackets], e.g.
[ABC Bank Checking]. Verify that this reduces the balance in the 'Checks
to Deposit' account back to zero (or you have made a mistake somewhere
along the way).
[*] During the Add Account dialog, choose a checking account and, on the next
screen, click on the words 'Advanced Setup' then finally choose
'I want to enter transactions manually'.

Quicken 17 For Mac Manual Match Downloaded Transactions 2017


Quicken 17 For Mac Manual Match Downloaded Transactions Online