
▲ 11 r/quicken
Apple Card transaction import util
Quicken can't import transactions from the Apple Card automatically and Apple Card can't export Quicken format data files until the end of the statement period. The Apple Card lets you export transactions to CSV and Quicken lets you import from CSV but Quicken is very picky about the column naming and order.
I wrote a Python script that takes an Apple Card CSV export, renames and reorders the columns and generates a CSV import that Quicken accepts.
I run Quicken on a Windows VM because last I checked Quicken for Mac didn't support RSUs. So I scheduled a Windows task such that when the CSV appears in a folder, the python script fires and the import-ready CSV appears in another folder. You don't need that but it's included.
u/spoink74 — 13 days ago