Can't match transactions

I'm trying to match transactions between a manual import and existing, reconciled transactions. At first, for the particular credit card in question, I did not have the account linked so was inputting and reconciling transactions manually. Now I linked it because I ended up using it a lot more than planned, and imported everything from the account. There are very obvious transactions that match, but even after changing the payees to be identical and the categories to be identical (the expense was already identical), the match option is still grayed out when I go to select it. Help!

Is it because one of the two charges has already been reconciled? I'm not sure what to do.

44replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi folks! Our Bugs team asked me to update this thread. Currently, all matching bugs have been resolved, so I wanted to include more details about matching transactions.

    An imported transaction will automatically match up with an entered transaction if:

    • The amount is exactly the same & dates are within 10 days
    • The entered transaction was present before it's match imported

    And a few important points:

    • File-Based Importing and Direct Import are both considered imported
    • One entered transaction can be matched with one imported transaction
    • You can also manually match an imported transaction with one you entered

    A common reason you may not be able to match is that a duplicate transaction imported from your bank. The original will match, and the second will not. If that's the case, you can report a Bank Importing Issue here.

    We have more information about matching on web and mobile in our HelpDocs too. If you have questions, let us know!

    Like
  • Hi Dustyn Roberts !

    Thanks for reaching out! It sounds like you might have run into a bug. Would you mind filling out our Bug Reporting Form? Someone from our bug squashing team will get back to you via email, so we can troubleshoot and get things working again.

    We're on our holiday break, so most of the team is away spending time with their families. It may take a few days, but we’ll follow-up as soon as possible!

    Like
    • Nicole at YNAB Submitted!

      Like 1
  • I have the same issue.

    Like 1
      • BajaChica
      • Purple_Memory.1
      • 1 yr ago
      • Reported - view

      Me too!!Purple Drill 

      Like
    • Hi BajaChica !

      When you have a moment, can you submit a Bug Report? That form lets our Bug Team know something is wrong with your account and they'll take a closer look at what's going on! :)

      Like
  • Just delete the downloaded transaction. If you've already entered, cleared, and reconciled it, there's no need to match it.

    Like
    • mamster  if both transactions came from a provider, and I delete one of the transaction, will that transaction come back?

      Like
      • DnA
      • IT manager, husband, father, YNAB podcast listener
      • Navy_Blue_Cup.2
      • 1 yr ago
      • 1
      • Reported - view

      Purple Drill Having a transaction reappear after I've deleted it has not been my experience.  

      Like 1
    • Purple Drill YNAB will not re-download deleted transactions. If you manually entered the transaction, you can safely delete the imported one - but it should automatically match. If you submit a Bug Report one of our bug squashing experts can take a look at what's going on. :)

      Like
  • I’m having the same issue. 

    I manually entered a deposited check on Feb 5th. For some reason the linked account didn’t update until today. Now I have a new transaction that isn’t matched and I cannot manually match the two either. 

    Like
      • WordTenor
      • I have the honor to be your obedient servant
      • WordTenor
      • 1 yr ago
      • Reported - view

      Slate Blue Saxophone If the original transaction is already cleared, it can’t match. Is that your situation?

      Like
    • WordTenor Yes, but if I unclear my manual entry or if I unclear both, I am still not allowed to match them. 

      Like 1
    • Slate Blue Saxophone That is my observation, as well. Even if uncleared, many won't match. My most common experience is that matching works but it's not unusual for me when it won't.

      Like 1
    • Slate Blue Saxophone Would you mind entering a Bug Report so our development team can take a look at what's going on in your budget? 

      Like
  • +1

    I understand I can just go through and manually delete the duplicates but it's annoying that I now HAVE to, especially since the problem is inconsistent and it was functioning fine a couple weeks ago. Some match automatically, some don't, and I can't match manually. So I literally have to go through and figure out which is a duplicate (they're not always adjacent as in the screenshot below), which is a scheduled transaction, etc... And all this to say nothing of the fact that it's now marking ALL directly imported transactions as cleared immediately.

    Is there anything worse than an inconsistent problem? Lol. I'm better off turning off direct import for now and going back to manually adding.

    A bug report has been submitted, just posting this here in case the community  has any other solutions.

    For what it's worth YNAB Support, you guys are doing a great job. I understand how complex this system/software and community are so there's no way you're going to please everyone or get everything right every time. Keep squashing bugs and I'll keep supporting ya!

    Like 1
    • Hi ajaygee !

      Thank you so much for submitting a Bug Report! I see that Elena, one of our bug squashing experts  🐛 has already reached out with more information. She will help you get this sorted! 

      Like
  • I experience all the symptoms described, when it works it is great but regularly it does not match automatically within the 10 day window and sometimes will not provide the match function to support my manually selecting the two transactions to be matched. I submitted a bug report formally since this is a pretty major time drain during budgeting and at times results in a false budget availability since transactions can be duplicates if I do not catch them. Hope you can help.

    Like 3
    • Hi Silver Case ! Thank you so much for filling out that Bug Report. I see that Sarah reached out, asking for a little more information—so we can continue the investigation. 😄

      Like
  • My scheduled transactions rarely match my imported transactions, and often it won't let me manually match them. I typically have to delete the scheduled one. Something definitely seems off. I've sent an email about it today, so I'm glad to see it's not just me.

    Like
    • Hi Alice Blue Mermaid ! I'm sorry to hear that you're having trouble matching the scheduled transactions to import ones! Thanks for reaching out via email. We'll be in touch! 😀

      Like
  • Same thing has just happened to me with 88 transactions. It's frustrating. I've submitted a bug report after reading this thread. 

    Like
    • Hi CrochetShay !

      I commented on your other thread as well, but I believe you're seeing a different issue. It looks like duplicates imported into your account and duplicates can't be matched (because the original should have already been matched). This issue should be resolved so you don't see more duplicates import, but let us know if you have any questions!

      Like
      • CrochetShay
      • Entrepreneur, Pet Luvr
      • Blue_Song.5
      • 1 yr ago
      • 1
      • Reported - view

      Faness Thank you! That makes sense now. I'll delete as needed then. 

      Like 1
  • Just ran into this.  My manual entry can't be matched with a newly downloaded entry from the bank....'match' is grayed out.

    Sounds like a few bug reports have already been submitted.  At the risk of y'all having to 'match' bug reports, I'll just ask if there's an ETA on fix?

    Thx!

    Like 1
    • Hi Matt ! Thanks for reaching out! If you're seeing odd behavior there, go ahead and submit a Bug Report. Our bug squashing team can help narrow things down! The situations can vary a bit, so it's best for them to take look. 🙂

      Like
  • I'm seeing the same behavior

    Like
    • Hi Magenta Piranha !

      When you have a moment, can you submit a Bug Report? That way, our Bug Team can take a look at your account and see what's going on. As long as one of the transactions was manually entered and the other was imported, you should be able to match them.

      Like
  • I would like to support this with a bug report however outside of just describing this I would prefer if someone could actually see the condition in the budget itself. However how can I share this with someone ion a secure way? Is there a tutorial to reference as to how to demonstrate a bug real time with a YNAB associate? This would get to the heart of the issue real fast..

    Like
    • Hi Silver Case ! We appreciate you being willing to help out. When you fill out the Bug Report, a member of our bug squashing team will reach out, with more details. If they need to collect more information, they'll let you know how. The situation can vary on a case by case basis, so we like to address it one on one! 🙂

      Like
  • Ultimately, users should be able to match on 2+ transactions no matter how they got into YNAB.

    This is feature enhancement, but one that I think would solve a lot of issues for determining when matching is available. The answer to "when is matching available?" is always.  

    Like
    • Hi Purple Drill !

      The way matching is intended to work is with a manually entered transaction and an imported transaction (via File Based Importing or Direct Import). If trying to match a manually entered transaction to multiple imported transactions (meaning duplicates), we'd want to investigate what's causing those duplicates. If trying to import one imported transaction to multiple manually entered transactions, the manually entered transactions should be adjusted so they aren't accidentally repeated or scheduled. Unlimited matches for transactions could cause trouble, so it isn't an option but we want to address any issues that arise to help keep transaction entry streamlined!

      If you have any questions, please don't hesitate to ask! If you're seeing any behavior that seems out of the norm, please submit a Bug Report so our team can investigate! :)

      Like
    • Faness This is useful to know, and while reasonable, still leaves me in a very frustrating situation every month:

      My bank (HSBC UK) provides credit card statements on about the 24th of every month. My partner and I like to do budgeting on the 1st (just after I get paid), which means there's always about a week of transactions missing from the CC. That gap isn't a hassle, as I can download both full statements and "recent transactions" to fill it in – but this is where the "don't match imported to imported" behaviour becomes an issue for me. I'm *always* uploading those recent transactions twice (as OFX/QIF files, no direct import in the UK) which means every single month I've got to figure out what are the duplicates to get rid of them. Even worse, the "recent transactions" and the actual statements have transaction dates on different days (presumably because of something in the bank's systems), plus we have 3 to 6 transactions every day, so it can be a real pain to figure out!

      I don't really have a specific feature request here, because this is obviously not an easy thing to solve, but I figured describing my use-case might be useful/interesting to the team.

      p.s. we pay for all of our daily expenses on the CC and pay it off in full every month via direct debit, to earn rewards and maintain a good credit score, we're not living on debt :)

      p.p.s. YNAB is awesome!

      Like 2
      • jenmas
      • jenmas
      • 1 yr ago
      • Reported - view

      Violet Mixer - What does when you budget have to do with when you enter transactions and matching imports?

      Like
    • jenmas we do monthly recon and budget review together at the beginning of the month

      Like
    • Violet Mixer This is an odd scenario, because once a transaction is imported, if you use File-Based Importing to import the same transaction again, it should be skipped. To prevent duplicates, like what you described, transactions are given an Entity ID - it's a unique ID for a specific transaction. Once that Entity ID is imported, all future imports with a transaction matching that Entity ID should be skipped. However, since you're getting the transactions from two separate files - the "Recent Transactions" and the "Full Statements" - the same transactions listed in both are given multiple Entity IDs.

      How far back does the "Recent Transactions" file go? Would it be possible to only use the Recent Transactions option to keep the account up to date?

      We love hearing you love YNAB, but I'm hoping with a few more details we can make this experience easier for you! :)

      Like
    • Faness thanks for the detailed info, really useful to understand what was actually happening. This month I tried CSV for everything (to see if it behaved better), and that has completely resolved the problem!

      Like 1
  • I'm seeing the same thing: the match option is grayed out when I select two transactions to match (one entered manually and the other automatically imported). I submitted a bug report. :(

    Like
    • Khaki Moose Thank you for submitting that bug report - you're in good hands! :)

      Like
  • None of my transactions with American Express are matching (directly or manually) when I direct import. I attempted to submit a bug report - but it only allowed me to click that it was a direct import issue. I couldn't figure out a way to leave specifics. Coult this be an issue with the fact that AMEX recently changed how they deal with .QFX files?

    Like
    • Gray Nomad I'm sending you an email now—happy to take a look!

      Like
  • I have a semi-related question. I placed a large order on Amazon and manually entered it as a single transaction. Amazon split the order into multiple smaller ones, so I have 6 separate transactions imported from my bank. Is there a way to match all of them or am I better off just deleting the imported ones if I want to keep it all together under one transaction in the record?

    Like
    • Hot Pink Cobra That is annoying, isn't it?

      I definitely wouldn't delete the imported transactions, because it's import for your YNAB register to faithfully reflect what happened. Instead, delete the original transaction.

      There's a good forum thread about ways to handle the "Amazon Shuffle"—my favorite lately is to just buy a gift card and then spend it right away. That way, even if Amazon breaks up the purchase, it will still clear as a single transaction on my credit card. (Hat tip to dakinemaui for the idea, I think?)

      Like 1
      • dakinemaui
      • dakinemaui
      • 7 mths ago
      • Reported - view

      Gift card approach described here:

      https://support.youneedabudget.com/t/k9vcv8

      Takes about 10 seconds once you have the process down pat.

      Like
Like4 Follow
  • 4 Likes
  • 7 mths agoLast active
  • 44Replies
  • 1510Views
  • 24 Following