Improvements to File Import, from YNAB Product Manager Michelle
Hey, folks! We have an update for you on several improvements to File Import. And, for the first time, it’s not coming from me (BenB), but from one of our lovely product managers. So I’ll pass this over to Michelle!
Hi! 👋🏽 I’m Michelle, a product manager here at YNAB. My team’s main focus is on the ways that transactions get into YNAB. That’s a pretty specific thing to care about, but gosh do I care about it a lot. For instance, I’m eagerly following the saga of open banking coming to Canada (oh, just me?). That will have to be a post for another time, because today I am here to talk to you about everyone's favourite stepchild, File Import.
When we took a look under the hood we found that File Import code was older than all of our bodies. Seriously! 🧓🏽 Your cells refresh roughly every 8 to 10 years, and that code hadn't been touched in about as long…
…until now! We want File Import to feel like a viable, helpful option for anyone who wants to use it, not a second choice. So here are some recent improvements we’ve made:
# Built-In CSV Mapping
Up until recently, if you had the misfortune to work with CSV, we pretty much left you to your own devices. And it was a bit of a pain, to be honest. CSVs have no standard formatting structure, so you had to first open the file in another app and adjust the columns to make them match YNAB.
Now, you can do all of that *within* YNAB! Which means goodbye external conversion websites and goodbye “let me just mess with this in Excel/Sheets for a second.”
You’ll only have to teach YNAB your file format once for each account. After that? We’ll remember it for you because YNAB is ✨very✨ smart.
# Payee Cleansing
Making files easier to upload only gets you so far, though. It can be a really disheartening experience when you import your bank file and a bunch of mess lands in your account.
It can be exhausting to try to decode `#1748Ottawa725CanadianTireABC132RandomOtherStringsOfNumbersAndLetters` when really it should just say Canadian Tire.
I don't want to be Nicholas Cage in National Treasure deciphering ancient texts and hieroglyphs. So YNAB is going to help you make sense of the payees using the same logic Direct Import has used for over a year now.
# Better Categorization
And once we can tell you it's Canadian Tire, we should be able to go one step further. If I have categorized Canadian Tire to my DIY Nightmares 🔨 category 45 times, why can't YNAB be smart enough to tell me that's probably what this is? Well, now it can even if you import from a file.
Improving auto-categorization for File Import matters especially, because these files are often *very* long. Categorizing four or five transactions is one thing, but 45? Oof, that’s a lot to handle without help. So we’re bringing the upgraded auto-categorization logic to File Import, making the process [much less tedious](https://www.reddit.com/r/ynab/comments/1vrt3ac/update_were_adjusting_how_autocategorization_works/).
# File Import’s Mobile Future
Coming up next, we want to bring File Import to the mobile apps! Your bank app is on your phone, so why shouldn’t you also be able to upload the file there as well? Now that we’re happy with File Import on the web app, we want to finally bring it to mobile next.
So, we hope you look forward to that! And if you haven’t used File Import in awhile, give it another try. It’s our goal to make transaction entry easy, regardless of the method you use. We’re so glad we got the chance to give File Import the attention it deserves.
