# Autocat Working for Some Transactions But Not Others **URL:** \ **Category:** Google Sheets\ **Tags:** autocat\ **Created:** [August 25, 2021, 12:00am UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555 "2021-08-25T00:00:08Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![phooph](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/phooph/32/6414_2.png) [@phooph](https://community.tiller.com/u/phooph)\ **Post date:** [August 25, 2021, 12:00am UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/1 "2021-08-25T00:00:08Z")
After categorizing transactions, new imports are not categorizing repeating transactions. For instance, Trader Joe’s transactions do not categorize as groceries. This is true for other grocery stores I have categorized. Also, some recurring income sources. I receive regular checks from some clients that are not automatically categorized although my Social Security auto deposit shows up correctly. The checks are deposited with a note of who they are from which shows up in the spreadsheet import but without a category. Am I expecting to much of Autocat? ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [August 25, 2021, 12:24pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/2 "2021-08-25T12:24:12Z")
@phooph, Do you have the Auto Run on Update setting toggled on under Tiller Money Feeds \> AutoCat \> AutoCat Run Settings? > **[How to Use AutoCat for Tiller Money Feeds sheets](https://help.tillerhq.com/en/articles/3792984-how-to-use-autocat-for-tiller-money-feeds-sheets#how-to-run-autocat-automatically)** > > Learn how to use AutoCat for Google Sheets powered by the Tiller Money Feeds add-on. ---
**Author:** ![phooph](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/phooph/32/6414_2.png) [@phooph](https://community.tiller.com/u/phooph)\ **Post date:** [August 28, 2021, 7:37pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/3 "2021-08-28T19:37:01Z")
Yes, the Auto. Run on Update is on. ---
**Author:** ![phooph](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/phooph/32/6414_2.png) [@phooph](https://community.tiller.com/u/phooph)\ **Post date:** [August 28, 2021, 11:28pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/4 "2021-08-28T23:28:04Z")
I refreshed my sheet and redid auto cat rules, but when I run Autocat it is still is not working for most transactions. ---
**Author:** ![caryupnorth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/caryupnorth/32/5719_2.png) [@caryupnorth](https://community.tiller.com/u/caryupnorth)\ **Post date:** [September 5, 2021, 1:23am UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/5 "2021-09-05T01:23:26Z")
I am having a similar issue as well. I’m trying to rename confusing/overly-long descriptions with Autocat, but most of the time Autocat doesn’t work. Sometimes it will sporadically work, but rarely. Did you find a solution to your problem? ---
**Author:** ![caryupnorth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/caryupnorth/32/5719_2.png) [@caryupnorth](https://community.tiller.com/u/caryupnorth)\ **Post date:** [September 6, 2021, 1:35am UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/6 "2021-09-06T01:35:51Z")
And now it’s not working on categories either … ---
**Author:** ![phooph](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/phooph/32/6414_2.png) [@phooph](https://community.tiller.com/u/phooph)\ **Post date:** [September 6, 2021, 11:33pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/7 "2021-09-06T23:33:44Z")
I saw someone else had posted on this issue in the past and got no answer. I suspect this is a challenging function. No word on if it is being worked on. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [September 7, 2021, 5:22pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/8 "2021-09-07T17:22:34Z")
A couple things to keep an eye on, @caryupnorth & @phooph… - Keep in mind that Autocat rules are processed top to bottom until a match is found, so a match found higher up could preempt a match further down. - Autocat can be configured to “Run AutoCat Rules On” on “Only Uncategorized Transactions” or “All Transactions”. Be sure to modify this setting or delete existing categories if you want Autocat to recategorize something. ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/9/951912abb43c843cb4829eb0852fdc846ccfeabd.png) - Special characters— e.g. “smart” versus `"`dumb`"` quotes and extra whitespace characters— can be a real sticking point in matches. You mentioned a Trader Joe’s charge and the apostrophe immediately set off alarm bells in my head. I just checked the crash logs and there don’t seem to be many issues with Autocat right now. My guess is that the problem is with your rules. If you aren’t able to resolve it quickly, I recommend opening a case with the Customer Success team. They do great work. ---
**Author:** ![caryupnorth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/caryupnorth/32/5719_2.png) [@caryupnorth](https://community.tiller.com/u/caryupnorth)\ **Post date:** [September 8, 2021, 4:02pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/9 "2021-09-08T16:02:22Z")
Thank you for the very thorough reply, Randy. You were exactly right about two of my problems: the smart vs dumb quotes, and the Autocat moving from top to bottom. I went through my Autocat and found some accidental duplicates that were no doubt creating problems. For future reference, which does Autocat want: smart or dumb quotes? Also, should I avoid apostrophes altogether, or is there also a way to use them that won’t trigger an issue? Thanks for your help! ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [September 8, 2021, 4:21pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/10 "2021-09-08T16:21:34Z")
Glad to hear those ideas helped. Autocat doesn’t want [either smart or dumb quotes](https://community.tiller.com/t/understanding-smart-versus-dumb-quotes/9696). You, as the user, want whichever matches the text from your data provider. There are probably ways to create an overcomplicated Regex Autocat rule which will accept either, but the easiest solution is just to match the data coming in from your feeds (it probably won’t change). ---
**Author:** ![caryupnorth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/caryupnorth/32/5719_2.png) [@caryupnorth](https://community.tiller.com/u/caryupnorth)\ **Post date:** [September 8, 2021, 4:24pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/11 "2021-09-08T16:24:49Z")
Oh okay. So for that, I should just copy the description directly and paste it with values only into my Autocat, correct? Also, I saw a Tiller YouTube video that said you could use quotes to add multiple descriptions into one Autocat rule (for example, rename description of “kohls”,“Kohl’s xxx089” to just “Kohl’s.” But whenever I try to do multiple renames using quotes with a comma between them and no space, Autocat doesn’t like it. ---
**Author:** ![RachelB](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/rachelb/32/2175_2.png) [@RachelB](https://community.tiller.com/u/RachelB)\ **Post date:** [September 8, 2021, 5:17pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/12 "2021-09-08T17:17:19Z")
Have you tried selecting a transaction and having Autocat create the rule for you? There’s an option to create a Rule from Selection so I usually start with that and adjust to fit my recurring expenses. ---
**Author:** ![phooph](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/phooph/32/6414_2.png) [@phooph](https://community.tiller.com/u/phooph)\ **Post date:** [September 8, 2021, 8:20pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/13 "2021-09-08T20:20:44Z")
I saw those settings. It did not seem to matter. It seems to work ok on subscriptions and my social security deposits and finally started working on PayPal which I categorized as Misc because I will have to hand sort those anyway. Is autocat really disabled by an apostrophe? That seems unfortunate. Besides Trader Joe’s, I also shop at Oliver’s and Friedman’s. It also does not categorize CVS, Costco or Target. I don’t see any extra white spaces or quotes. Also, I found others with similar complaints. Did not see any answers. Thanks for your response. I will see what the Customer Success team can do. Ruth ---
**Author:** ![phooph](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/phooph/32/6414_2.png) [@phooph](https://community.tiller.com/u/phooph)\ **Post date:** [September 8, 2021, 8:28pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/14 "2021-09-08T20:28:34Z")
Where does one find the Customer Success team? I see it nowhere and it does not show up in a search. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [September 8, 2021, 8:47pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/15 "2021-09-08T20:47:51Z")
I wouldn’t say that “autocat really disabled by an apostrophe”, @phooph. It simply won’t match on a smart apostrophe if the value in your feeds is a dumb apostrophe— because, to a computer, they are two different characters. Autocat works fine with apostrophes, you just need to build your match criteria around the type of apostrophe you are matching to. Make sense? The easiest way to get in touch with the Customer Success team is to click the circular Intercom icon in the bottom right of the main Tiller Money Feeds sidebar. They should be able to get things straightened out. Good luck. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [September 8, 2021, 9:35pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/16 "2021-09-08T21:35:44Z")
Copying and pasting exact text may be the best approach… or you can use the Rules Builder as @RachelB suggest. As for multi-match… maybe you are using smart quotes in the multi-match criteria, @caryupnorth? I use this in my personal Autocat rules sheet in the `Description Contains` column and it works fine: `"Lyft","Uber"` Randy ---
**Author:** ![phooph](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/phooph/32/6414_2.png) [@phooph](https://community.tiller.com/u/phooph)\ **Post date:** [September 8, 2021, 10:39pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/17 "2021-09-08T22:39:10Z")
When I make a rule I select the cell with the transaction name and choose Make rule from selection. Is there something else I should do? ---
**Author:** ![caryupnorth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/caryupnorth/32/5719_2.png) [@caryupnorth](https://community.tiller.com/u/caryupnorth)\ **Post date:** [September 10, 2021, 1:26pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/19 "2021-09-10T13:26:51Z")
The quotes are working in Autocat now – I went through and checked that they’re all dumb quotes. I also now copy and paste when working with apostrophes in Autocat. Everything is up and running smoothly. Thanks! ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [September 10, 2021, 4:34pm UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/20 "2021-09-10T16:34:47Z")
That’s great news, @caryupnorth. If it is any help, I added [a new topic about why & how smart quotes can be problematic](https://community.tiller.com/t/understanding-smart-versus-dumb-quotes/9696). ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [September 11, 2021, 1:00am UTC](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555/21 "2021-09-11T01:00:26Z")
Yes, @phooph, clicking “Rule from Selection” will only recommend the rule. To actually create the rule, you need to subsequently click either “Create Rule” or “Create & Run”. I recommend reviewing and possibly editing the rule beforehand too. Good luck. ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/0/00a3d1a84d23961569cf5f6855d33d62990d238d.png) [Next page](https://community.tiller.com/t/autocat-working-for-some-transactions-but-not-others/9555.md?page=2)