Apple Card statements can now be exported for importing to third party financial apps.

I use a converter called ac2ofx to generate a QFX file from the monthly PDF statement. Worked perfectly. Took me 5 minutes to complete. Before that I typically had to spent 30-45 minutes to manually re-enter the transactions into Quicken.

Apple allows the download in the standard Open Financial eXchange format (OFX), unfortunately Quicken has their own version of OFX called QFX (Quicken File eXchange) which only works with their software.

QFX is basically a proprietary version of OFX which must be licensed by a financial institution to be imported into Quicken. Apple would have to pay a fee to Quicken to license the Apple Card to be selectable as a bank in the Quicken software as well as creating a file in QFS format. The conversion programs available mimic a valid Quicken bank to allow the import, unfortunately I am not sure how long before Quicken decides to block these software conversions.

It would be much better if Quicken could allow the import of the OFX format for their customers. Alternatively, Apple could license the Apple Card as a bank in Quicken and produce the QFX format.

In any case, we the customers suffer as the battle (negotiations) goes on.

OK, i have created a simple work around using Excel, and a text editor. I am not an expert by any stretch, so I cannot warranty this but it has worked for me so far. Use at your own risk.

I created an excel file where I reserved the first 7 columns (A-G) for the exported data, I skipped column H, then the next 4 columns (I-M) created the following formulas to transform the exported data to the input field format Quicken expects, and then in the last column, N, I created formula to combine the fields with new line character codes. When the result in the last column is copied and pasted into a file in the text editor, it line breaks into the correct format. That file can then be named anything ending with .QIF which can be then imported into the specific account in Quicken.

EXCEL WORK:

Create a blank file

Column A-G is where I paste the CSV data which is in this order: Transaction Date Clearing Date Description Merchant Category Type Amount (USD)

Column H Blank (Skipped for visual spacing only)

Here are the formulas...

Column I ="D"&TEXT(A10,"mm/dd/yyyy")

Column J ="T"&TEXT(-G10,"0.00") the minus flips the sign of the bank's perspective to quicken's perspective.

Column K ="P"&PROPER(D10)

Column L ="M"&PROPER(C10)

Column M =I10&CHAR(10)&J10&CHAR(10)&K10&CHAR(10)&L10&CHAR(10)&"^"&CHAR(10)

Char(10) is a the new line and Quicken used the Carrot "^" as the end of record.

Now, open the CSV file in a different excel window, copy and paste to columns A-6 and fill the formulas down the other columns, then select the results in column M, and Copy.

Next, open a new file in a text editor (on my mac i use the OS's TextEdit app). Put !Type:vCard as the first line and press enter. Paste what was copied. If you text editor adds quotation marks (mine did), deleted them or remove with a Find/Replace.

and save the file as NameHere.QIF

In Quicken, click the FILE menu, then IMPORT, then QIF FILE.

Browse to your file, DO NOT SELECT ALL ACCOUNTS, instead, select your apple card account.

Uncheck everything except TRANSACTIONS

Does anyone know if apple is working on a solution. So that there card works with quicken.