Excluding Items from Search Bar

Hi,

Does anyone know how to exclude items from the search bar? For example, my credit card has two cardholders. I have reconciled the transactions for Cardholder 2 (as they're all in the "Cardholder 2" category) but now I want to reconcile everything from Cardholder 1. In order to do that, I would need to select everything that is NOT in the "Cardholder 2" category (Cardholder 1's transactions are all itemised so I can't tick "Cardholder 1" each time, unfortunately). Does anyone know if this is possible and if so, how do I do it? I've been struggling with this for a few months now so it would be great if someone could help!

Thanks

8replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Pink Banjo !

    You can enter all of the categories you Do want to see (leaving out the one category you don't want to see), and specify the account.

    Your search bar would look something like: "Account: Credit card, Category: Immediate Obligations, Category: True Expenses, Category: Movies" etc.

    Reply Like
      • bevocat
      • Sometimes, It Just Sucks to Be You
      • bevocat
      • 5 mths ago
      • Reported - view

      Faness I have 143 categories. This is madness.

      Reply Like
      • Pink Banjo
      • Pink_Banjo.1
      • 5 mths ago
      • Reported - view

      bevocat I've figured out three potential solutions below, you may find one of them useful :) The Excel formula shouldn't be too difficult, all you'd have to do is conjoin "New Identifier" and the old cell. I'm happy to post the formula/further detail if you're not that tech-y with it (one of the benefits of using it daily in work, you get to know a lot of the intricacies!)

      Reply Like
      • bevocat
      • Sometimes, It Just Sucks to Be You
      • bevocat
      • 5 mths ago
      • Reported - view

      Pink Banjo Please, lay it on me! I'm plenty techy, but more on the server side of things. I suppose I could export to CSV and concatenate what I want every single time, but it's silly that there's no "AND NOT condition"!

      Reply Like
  • I was really hoping that wouldn't be the answer as I've got about twenty categories I've now got to "include" rather than excluding just one. Is there any chance that this functionality will be added in future upgrades to the system?

    Reply Like
      • monkeyhanger
      • No animals were harmed
      • monkeyhanger.1
      • 5 mths ago
      • 1
      • Reported - view

      Pink Banjo Not the cleanest answer but if you marked each cardholder 1 transaction with a flag at the data entry stage (assuming you manual input), you can then search by flag colour. 

      PS I agree there should be a better way. And I'm really glad we don't have any shared credit cards if that's how they work.

      Reply Like 1
      • Pink Banjo
      • Pink_Banjo.1
      • 5 mths ago
      • 1
      • Reported - view

      monkeyhanger I like this idea, but unfortunately I have a year's worth of data to track. So I now see three potential solutions thanks to yourself :)

      1. Pull out cardmember 2's activity into their own "account" which may make reconciliation a little more difficult but cancel out my issue completely.
      2. Export the account's activity to Excel, use Excel wizardry to speed up the process of adding an identifier to each Memo line and then re-import the whole lot and use the same identifier going forward.
      3. Instead of marking each individual transaction (> 1K rows), I could mark each non-cardmember 2 category with C1 (or similar). This will then mark the historic transactions although it will make some of the categories look quite funny, e.g. Dining Out (C1) 

      Option 1 is more hassle and honestly, will be a nightmare when I'm inputting items as I'll have to flick between the two accounts. Option 3 is definitely the one that's best to eliminate human error but Option 2 is the cleanest. I imagine I'll end up doing some form of hybrid of Options 2 and 3! Thank you very much!

       

      With regards to shared credit cards, I have two at the moment.  One company sees the two cards as part of the same account (there's no difference) so when it comes time to figuring out who spent what, it's a bit of a nightmare. Thankfully, we don't use that card much. The second (day to day card) is fantastic. It splits out the spending by cardholder so you can see who spent what. The main cardholder (me) sees everything, the secondary card holder gets their own (separate) login and sees only their spend. 

      Reply Like 1
      • Patzer
      • Retired at age 60. Thank you, YNAB!
      • Patzer
      • 5 mths ago
      • 1
      • Reported - view

      Pink Banjo I have thought of a workaround for you.

      First, install Toolkit if you don't already have it.  Activate the feature that lets you change multiple flags in one transation.

      Second, clear all filters in the account.  Then select all transactions, and set the flag to an arbitrary color, say Blue.

      Third, filter to select Cardholder 2.  Select all transactions, and set the flag to a different arbitrary color, say Red.

      Fourth, clear the filter by category, and filter for Blue flags.

      The only weakness I can think of is that the Toolkit function for mass setting flags doesn't let me mass clear them.  So you're stuck with flags of one color or another when you get done, unless you painstakingly clear the flags one transaction at a time.

      I'm still waiting for YNAB to replicate the YNAB 4 ability to set and clear all flags of selected transactions in a single operation into nYNAB; but in the meantime, Toolkit helps.

      Reply Like 1
Like Follow
  • 5 mths agoLast active
  • 8Replies
  • 104Views
  • 5 Following