Home Quicken for Mac Product Ideas - Quicken for Mac Manage Accounts and Transactions (Mac)
Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Add Ability to Match One Downloaded Trans to Multiple Trans in Quicken Mac (23 Legacy/Merged Votes)

smayer97smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
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. 
Have Questions? Check out these FAQs:COMPLETE list of Product Ideas - Quicken for Mac to VOTE on

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 user since '92, STILL using QM2007)


2
2 votes

No Status · Last Updated

Comments

  • smayer97smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited August 2018
    This IDEA has been added to the List of Requests for Downloading Data into Quicken.
    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.)
    Have Questions? Check out these FAQs:COMPLETE list of Product Ideas - Quicken for Mac to VOTE on

    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 user since '92, STILL using QM2007)


  • smayer97smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited August 2018
    This IDEA has been added to the List of Requests for Downloading Data into Quicken.
    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.)
    Have Questions? Check out these FAQs:COMPLETE list of Product Ideas - Quicken for Mac to VOTE on

    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 user since '92, STILL using QM2007)


  • John KeatingJohn Keating Member ✭✭
    I receive monthly rent from three different people sharing the same housing unit. Each appears as a separate transaction in my bank register. Since they really comprise a single rent payment for the unit, I'd like to be able to select all three of them and merge them into a single split transaction that shares the same Payee and whose amount is the total of the three.

    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.
  • jacobsjacobs SuperUser, Mac Beta Beta
    @John Keating I understand what you're wanting to do, but I'm not sure how Quicken would be able to know which of three deposits to your bank account to combine into one transaction. And what if one pays late or early; how could Quicken know which monthly transaction to merge it into?

    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.
    Quicken Mac Subscription • Quicken user since 1993
  • NotACPANotACPA SuperUser, Windows Beta Beta
    OR, you could create an "Undeposited Checks" account ... and direct the rental checks into that account instead of your checking account.  THEN, make a transfer from the "Undeposited Checks" account into your bank account.
    This preserves: the single deposit into your bank, which individuals paid, and when they paid.
    Q user since DOS version 5
    Now running Quicken Windows Subscription,  Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • jacobsjacobs SuperUser, Mac Beta Beta
    @NotACPA But John describes three deposits into his bank, not one. If there were just one deposit, it would be a single transaction in his Quicken register, in need of splitting; he describes having three transactions downloaded into his Quicken register which he wanted to combine. That's why I suggested what I did above: keeping the Quicken register in parallel with the bank account transactions.
    Quicken Mac Subscription • Quicken user since 1993
  • John KeatingJohn Keating Member ✭✭
    It's nice to see such an active community of people who are engaged with helping to improve the product. Thanks for the feedback and the good points made. Here are some more ideas on the feature:

    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. 
  • jacobsjacobs SuperUser, Mac Beta Beta
    edited February 2019
    @John Keating I get the picture of what you're asking for. I'd guess that very few Quicken users would want to have Quicken automatically merge two or more deposits on the same day into a single transaction. Imagine if someone deposits a paycheck, a reimbursement check and a gift check at an ATM on the same day, and Quicken merged them into one transaction -- that could be a mess. Most people would want to have each transaction that appears in their bank statement (printed or online) match a transaction in their Quicken register.

    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.
    Quicken Mac Subscription • Quicken user since 1993
  • smayer97smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited February 2019
    Doesn't QWin had the functionality that can either match multiple downloaded transactions to one entry in Quicken or one downloaded transaction to multiple Quicken entries, or both? 

    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.
    Have Questions? Check out these FAQs:COMPLETE list of Product Ideas - Quicken for Mac to VOTE on

    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 user since '92, STILL using QM2007)


  • John KeatingJohn Keating Member ✭✭
    Yeah I thought I'd heard of this as a QWin feature. I believe the questions of how to implement are solvable and I suspect it would be useful to others as a way to combine related transactions into a single transaction, as is my case. That's really the whole point of splits as far as I'm concerned, so this is a quick way to construct a split when the transactions have been downloaded or created in advance.
Sign In or Register to comment.