Based on what I’ve read, here’s what I think to be true about bringing in Apple Card transactions:
- It isn’t automatic
- You can add a manual account and transactions using the foundational template.
- Alternatively, you can use some community tools to import a CSV export of the data - IFF you are using google sheets.
Manually adding transactions is not realistic for me and I’m using Excel. I don’t want to use Google Sheets.
I have downloaded my Apple Card transactions from the ios App for October. The schema is simple.
If I match the schema from the Tiller transactions sheet, can I just insert/copy over the values to the end of the data? I noticed that there are 2 hidden columns - transaction id and account id.
I have done 1 manual transaction so I know the account id, but do I need to generate a unique id for the transaction (column J)?
What else am I missing?
Is there a better / simpler way?
So many questions!