Add Ability to Match One Downloaded Trans to Multiple Trans in Quicken Mac (23 Legacy/Merged Votes)
smayer97
SuperUser ✭✭✭✭✭
As per the description in this post: https://getsatisfaction.com/quickencommunity/topics/how-to-match-one-downloaded-bank-transaction-to-...
BUT don't stop at the way if works in QWin...instead take it to the next level as it is done in MS Money, as described in the follow-on comment here: https://getsatisfaction.com/quickencommunity/topics/how-to-match-one-downloaded-bank-transaction-to-... so as to preserve the original Payee info in the registers.
If implemented like MS Money, this would be a boon and save time, e.g., instead of doing multiple individual deposits at the bank, like rent checks, it would be possible to perform a single deposit. If not done this way, it would be of little value if Payee info is lost from the Payee field and only stored in the memo field.
Also see the related IDEA here: Restore Transactions Downloading Acceptance and Matching workflow
If you find this feature helpful, please be sure to click "VOTE" above to increase the count of this post and therefore its visibility to other users and to the developers.
If you do not click VOTE at the top of the page, your vote will NOT be counted! Your VOTE matters!
Click "Follow" at the top if you want to receive notifications of any updates to this thread.
BUT don't stop at the way if works in QWin...instead take it to the next level as it is done in MS Money, as described in the follow-on comment here: https://getsatisfaction.com/quickencommunity/topics/how-to-match-one-downloaded-bank-transaction-to-... so as to preserve the original Payee info in the registers.
If implemented like MS Money, this would be a boon and save time, e.g., instead of doing multiple individual deposits at the bank, like rent checks, it would be possible to perform a single deposit. If not done this way, it would be of little value if Payee info is lost from the Payee field and only stored in the memo field.
Also see the related IDEA here: Restore Transactions Downloading Acceptance and Matching workflow
If you find this feature helpful, please be sure to click "VOTE" above to increase the count of this post and therefore its visibility to other users and to the developers.
If you do not click VOTE at the top of the page, your vote will NOT be counted! Your VOTE matters!
Click "Follow" at the top if you want to receive notifications of any updates to this thread.
Have Questions? Check out these FAQs:
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian Q user since '92, STILL using QM2007)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
Object to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian Q user since '92, STILL using QM2007)
2

Comments
You may want to click on the underlined link to add your vote to more related ideas. Your VOTE matters!
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian Q user since '92, STILL using QM2007)
You may want to click on the underlined link to add your vote to more related ideas. Your VOTE matters!
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian Q user since '92, STILL using QM2007)
Additionally, I'd like to be able to set this process up as a scheduled transaction so that that when the three transactions are downloaded, they match to the single split transaction so I don't have to do it manually each time.
But programming logic aside, I'd suggest that doing what you propose wouldn't be wise from an accounting standpoint. You want Quicken to mirror your financial accounts in real life. If there are three deposits in your bank account, you really want to have three transactions in Quicken to match them up against. If they were somehow combined into one deposit, it would be very difficult to reconcile Quicken against your bank account. (For instance, what if two of the three payments comes in before your bank account statement date, and one comes in after.)
Here's an alternative, if you're looking for help organizing and keeping track of the rent payments: keep the deposit transactions separate, but use Tags to allow you to track/report on your rent activity. You could use a different tag for each renter, so you could get a report on each individually as well as the aggregate. Or you could use the same tag on each of the three payments, if that would be useful. Or you could use a tag for each month, so each payment for March rent would get the March tag, to enable you to spot if any of the payments is missing. You can use multiple tags on a transaction as well, if you wanted to combine any of those ideas -- the point is tags give you some flexibility for searches or reports.
Now running Quicken Windows Subscription, Home & Business
Retired "Certified Information Systems Auditor" & Bank Audit VP
Jacob - in my case, all three transactions always appear (as ACH deposits) from the same payee and on the same day, so I never have any that are offset in time. I'd think that Quicken's existing matching algorithm, which seems to use payee and amount as the primary criteria, would be able to match/merge them into one. It seems reasonable to require all merge-able transactions to exist at the time the merging takes place, otherwise they'd just remain separate.
I'm not sure I'm understanding your point about reconciling however. I manually merge the separate transactions into a single split now and since the totals represent the sum of the individual transactions, the math adds up. I always reconcile with the electronic balance (not statements), but either way, the matching could merge as many as exist at the time, and any late ones would remain separate. Perhaps I'm not understanding the case you're describing though.
I already use tags extensively to differentiate rental properties, but the purpose of this new feature wouldn't be for reporting or tracking, but for simplifying/compacting the register by taking advantage of splits (despite our inability to mass edit splits; but that's a different feature request!).
NotACPA - I don't believe the separate account idea would work since I run all my properties through a single bank account and use the download feature to keep the single register in sync with the bank.
I realize that the scheduled part of this feature request is more complex and might require additional UI steps (like choosing what payee name and memo to use on the merged transaction, or specifying how to handle missing transactions), so the basic request is really just the ability to manually combine multiple transactions into a single, split transaction.
The best I could envision is if Quicken were to add a function where you could manually click on two or more transactions and have it merge them into a single transaction with multiple split lines, as you suggested. Even that could be tricky, though: if the Payees are not the same, which Payee should survive? If the transactions area day apart, can they be merged, and if so, on which day?
My guess is that this is a feature that few users need, and therefore might fall pretty far down the developers' roadmap. But you can certainly submit it as a feature idea. Unfortunately, message threads in this Category ("Errors and Troubleshooting") don't support user voting, so you'll need to re-post the request in the "Product Ideas - Quicken for Mac" category.
I also believe there already is a QMac IDEA along these lines. Not much time now but when I come across it, I will update info here.
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian Q user since '92, STILL using QM2007)