Export Apple Cash transactions to CSV/Excel for import into Quicken

Question

Level 1

5 points

Export Apple Cash transactions to CSV/Excel for import into Quicken

I recently got the Apple Card and love the Apple Cash rewards. But I obsessively track my finances in Quicken, and was frustrated by the lack of export options. From what I can tell, all you can get is an on-demand PDF statement.

I wrote an Excel spreadsheet that uses Power Query to import the PDF into a CSV that Quicken can import. See the process here:

***

If you’d rather skip me droning on for 10 minutes, here are the files on GitHub:

https://github.com/carruthe/AppleCashImport

[Link Edited by Moderator]

Posted on Feb 12, 2023 4:46 PM

Reply

Answer 1

muguy

Level 10

91,172 points

Feb 13, 2023 4:03 AM in response to Carruthe

Why not just download the Quicken compatible file format in the wallet? Download or export your Apple Card statements and transactions - Apple Support

Reply

Answer 2

Carruthe Author

Level 1

5 points

Feb 13, 2023 4:13 AM in response to muguy

Thank you! That works for the Apple Card transactions, but those QFX files don’t include (to my knowledge) the Apple Cash debit/credit transactions. The only way to get those currently is to request a PDF that Apple then emails to you.

Reply

Export Apple Cash transactions to CSV/Excel for import into Quicken

Similar questions