Duplicate Transactions After Download (Q Mac)
I reported a similar issue a while ago but I am noticing it again and it seems to be more prevelent. This only seems to happen on transfer transactions and where it seems to happen is when a transaction downloads for a prior date in one account and for a later date in another.
Example: Credit card transaction paid online at credit card company website
Posts to Credit card on 7/23/2024
Withdrawn from bank account on 7/24/2024
When I download transactions on 7/24 the 7/23 credit card transaction matches up and I mark as Reviewed.
When I download transactions on 7/25 for 7/24 the bank account transactions match up and can be marked as reviewed, but there is often a second transaction that now appears with an orange pencil. I know this isn't the original transaction that I entered manually because I always input the confirmation number when I input a transaction. The transaction that downloaded and matched has a blue pencil with the confirmatoin number. The second transaction shows it is a transfer, but there isn't a matching transaction in the credit card account.
This also happened with a paycheck where I have it split to go into several accounts. After the download, the paycheck transaction matched correctly, but then there were duplicated transfer transactions that are the same as transfers that are entered as splits on the paycheck deposit. these duplicate transfer transactions don't have a matching transaction in the target transfer account. They only exist in the bank account where the paycheck is being entered. Next time this happens I will follow up with a screen shot.
Comments
-
Hello @dioxide45,
To help troubleshoot this issue, please provide additional information. Since you mention this is specifically happening with transfers where there is a delay between when it posts to one account and when it posts to the other account, is Quicken creating a manual transaction to represent the other half of the transfer when the first part downloads? If it is, then what is happening when the other half of that transfer downloads? Is it failing to recognize that it's the other half of the earlier transfer and adding a manual transaction into the other account (where it had already downloaded earlier)? Typically, if a transaction is manual or automatically generated by Quicken (without yet being matched to a downloaded transaction), you'll see an orange pencil icon next to that transaction.
I look forward to your response!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
I am not even sure it is a delay now between the date on the transaction in the register vs. when it posted to the account. I had three transfer transactions from a checking account manually entered with a date of yesterday (July 29). Today (July 30th) when I downloaded them, they all matched (blue pencil), but Quicken also created two manual transactions (orange pencil) for two of those transactions. I know the two manual transactions are bogus because they don't have the confirmation numbers in the Memo column. Which I've blurred out on the correctly matched transactions. These orange pencil transactions don't have a matching transaction in the linked transfer account. If I delete the orange pencil transactions, everything is good.
This only seems to be happening in the account that is the source of the funds in the transfer. I don't see the
0 -
For best results I always manually enter transfer transactions into my registers BEFORE I download transactions from the bank which contain the transfer confirmations. For recurring transfers I use scheduled reminders and enter them a day or two before the due date.
This results in correctly linked transfer transactions appearing in both account registers. When the transfer confirmations arrive in a download from the various banks, Quicken can match the downloaded transaction to the already existing register transaction and will usually not create any problems.For Mac users, if Quicken does not auto-match the transaction, it will create what appears to be a duplicate transaction in your register. Simply click and drag this apparent duplicate over the already existing, correctly categorized transfer transaction. This makes it disappear, together with the apparent balance difference.
0 -
That is exactly what I did and always do. I even set these up as scheduled transactions and enter them as I pay them.
As I mentioned in my post, the transactions with the blue pencil were manually entered into the register BEFORE I downloaded transactions. When I downloaded them they correctly matched, thus the blue pencil. It isn't an issue of them not auto-matching. If they didn't auto-match there would be a blue dot instead. The problem is that when these transactions are auto-matching they are somehow also creating a duplicate transaction, the orange pencil. That orange pencil transaction does not have a matching transaction in the target transfer account that shows on the transaciton.
1 -
Having the same issue as dioxide45. For me it started happening about 4 months ago. Duplicate transactions started showing up in all my accounts and they would carry a different date, generally a day later than the matched transaction in my register. One difference is that it occurs for me on transactions with or without a split. The original transaction is always in my register prior to One Step Update and the update process finds the matching transaction and matches it but then generates a second transaction for the same amount with the different date and the orange pencil. Since the dates change, they are not always next to each other in the register and it is easy to miss the extra transaction at the time. Throws off the balance and since it is occurring across accounts, it is turning out to be very impactful to figure out correct balances.
0 -
I am still seeing this. Always seems to happen in the source account of the transfer. Both for split and non split transactions but always on transfers.
0 -
Thank you for your replies,
To troubleshoot this issue further, please add the Transfer column to the account register(s) you are seeing this issue in. To do that, click the columns button near the lower right and select Transfer.
Adding the Transfer column will allow you to see what account it sees the transfer going to, and it can also indicate if Quicken sees a problem with the transfer.
Thank you!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
I've added the Transfer column to the registers. Once I do my next transaction download (tomorrow) I will post a screen shot of what it looks like.
1 -
I've been having the same issue with duplicate transactions. I've discovered that the problem occurs when the Category and Transfer are not the same thing.
So if I enter Payee = Credit Card Company, Category = [Credit Card Account] and nothing else, the transaction will not duplicate.
If I enter Payee = Credit Card, Category = Transfer:Credit Card Payment, and Transfer = Credit Card Account, I will get two near-duplicate transactions when the transactions are downloaded. I have a feeling that the issue is somewhere in how the transaction from my bank account and credit card account is done.
The result near duplicates are:
One transaction that exactly matches the Payee, Category, and Transfer that I had entered. This transaction retains the status of Manually Entered (orange pencil).
One transaction that replaces the Category with [Credit Card Account]. This transaction is given the status of Matched (blue pencil).
I will need to delete one of the two transaction.
I hope this information helps.
1 -
Years ago, the product manager for Quicken Mac said they would be removing the ability to enter a category on a transfer transaction. (Transfers of funds cannot, in proper accounting, be categorized as income or expense.) For some reason, that change was never implemented, which unfortunately has caused users a number of problems with incorrect data in certain reports. If what @EK118 reports above is correct, then this is another unintentional byproduct of some functionality from long ago. (Quicken Essentials, the feature-limited predecessor to the current Quicken Mac, allowed Transfer transactions to have Categories as well because that program had no way to include transfer in reports or budgets.)
Simple advice for everyone using Quicken Mac: if the transaction is a transfer, do not enter a category as well. (It's fine to enter the transfer in the Category field, using the "Transfer:[account name]" syntax; just don't use the generic "Transfer" or "Transfer:Credit Card Payment" or any other category.)
Quicken Mac Subscription • Quicken user since 19930 -
When I enter a transaction, I don't even select or enter anything in the Transfer column. It was never even a column I added to my register since it is always the same as the Category. When I pick "Transfer:Checking" in the Category column, the Transfer column just contains "Checking". My Transfer column is always the same as the Category column except that Category always contains the "Transfer:" before the account name.
I will note that my Payee name is almost always different as it contains the bank name that the payment is being sent to.
0 -
I spoke too soon. I removed the "Credit Card Payment" category. My most recent payment still duplicated. The difficulty with this bug is that you have to wait for payments to process to see if your latest troubleshooting attempt worked.
I have one that has a blue pencil, with [Payment Account] as the Category and Payment Account as the Transfer.
I have another transaction with an orange pencil with [Payment Account] as the Category and Payment Account as the transfer. There is a red arrow on the right side of the Transfer field.
One more potential idea as to a cause. Both the pay from account and the Pay To account are tracked in Quicken, but when you download the Pay To account, all of the transactions are delayed by one day (they process overnight) while the Pay From account is pretty much instantaneous. So the payment downloads from the Pay From account on day 1 (and I get the blue pencil, no duplication) and the payment downloads from the Pay To account on Day 2 - which is when I see the duplicate.
0 -
I'm not 100% convinced it is with the two day process for payments. I do have this happen with credit card payments/transfers. but I have also had it happen with paycheck deposits. My paycheck gets broken up to deposit into multiple accounts. All of which happen on the same day. I get the duplication of transfers in the pay from account. The paycheck transaction posts and gets the blue pencil, but then I also notice the faux transfers with the orange pencil that match up to the amounts of some of the splits in my paycheck deposit that are transfers to the other bank accounts.
0 -
Hello All,
Thank you for taking the time to visit the Community to report this issue, though we apologize that you are experiencing this.
We have forwarded this issue to the proper channels to have this further investigated. In the meantime, we request that you please navigate to Help > Report a problem and submit a problem report with log files attached and (if you are willing) a sanitized copy of your data file in order to contribute to the investigation.
While you will not receive a response through this submission, these reports will help our teams in further investigating the issue. The more problem reports we receive, the better!
We apologize for any inconvenience!
Thank you.
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
I've done this and provided a link to this discussion in the notes.
1
