Now that Apple Card transactions can be exported as spreadsheets, is there a manual way to import them into YNAB?
I've been seeing a number of articles lately about a new feature Apple is finally offering with Apple Card: the ability to export transactions in spreadsheet format directly from the iOS Wallet app. While it looks like transaction export happens on a statement by statement basis (no ability yet to define specific time ranges) my thought is that there surely must be a way to import these sheets into YNAB? I've never actually done a manual import of CSV into YNAB, so am not sure how difficult the process is -- has anyone tried importing the new Apple Card export sheets? If so, did you have to do a lot of reformatting to match whatever YNAB expects for the import?
Importing a .csv file into YNAB can be done but, depending on what information is on the .csv, there will need to be reformatting done. YNAB only likes imports with the Date, Payee, Category, Memo, and Inflow/Outflow. Note, too, that you must choose either Inflow or Outflow... YNAB will not take two columns for this from an import.
If you are good with basic Excel or Google Sheet formulas, you can create a spreadsheet that will do the work for you.
That said, I agree that it is easier (and better) to manually enter transactions.
We were interested in this announcement, too, but so far it looks like you'll only be able to download a monthly statement's worth of transactions. This might help you catch a missed transaction but obviously won't work for keeping your budget up to date.
If anyone's been able to try it, though, please let me know—I don't have an Apple Card and could be wrong about this!
In the Wallet app, you tap your balance and then Export Transactions. You can get CSV or OFX (YNAB prefers OFX).
Again it’s at the statement level like mentioned so still not quite as convenient as most cards, but if you’re mostly on top of it and then just use the import to reconcile at the end of the month it could be good.
The ironic thing is that you can only get the file on your phone, and you can only import the file in YNAB on your computer haha.