Timed EFT_ withdrawl from same utility_ auto categorize?

Conversation Helpful Tips
1

Hello All-

I have EFT/ACH debits that go out of my bank account from the same utitlity co. (IE gas/power/garbage co.) that its difficult for the sheet to categorize. Is there a way to auto cat by the withdraw timing? (I.E. power bill for business A is first withdrawal each month. Power bill for business B is 2nd and so on)

Was wondering any tips for categorizing/recognition to the sheets.

Thanks again

Mike

2

I don’t know of a way to utilize timing for auto cat. Does the garbage standard monthly amount? You could use that to base an auto cat. I am thinking that maybe the gas and power would be too similar in amounts to use a min/max for that. Are the debits all exactly the same description, it sounds like they might be? If they aren’t you could use the portion that is unique to each.This might be a case where manual categorization is needed. Unless someone else knows of a way to make it work.

3

Autocat can identify transactions by minimum and/or maximum amounts. Is there a pattern of values in your debits that applies here?

4

Thanks for the feedback! Unfortunately the values are all some similar that (each of the 4 locations gets a withdrawl of around $60-80 per month. I currently go in an manually code it each month based off when the withdrawl occurs, looks like thats needed until they can autocat based on timing

5

check out this post regarding dates hopefully it has what you need: