Download of Apple Credit Card transactions

Smiller35570

Apple currently does not allow download to any third party. I would like Quicken to lobby Apple to set up their card through Goldman Sachs to allow download. I will not use their card if it will not download.

danddmiller

Totally agree! The transactions should not have to be manually entered.

dbcsr

Meanwhile...
Although this temporary solution does not apply specifically to Quicken, it will, I believe get you there. If you're capable of importing into Quicken CSV or tab-separated values, then this will work for you.

First get your Apple Card statement over to your Mac:
1. Open your Wallet app and select your Apple Card.
2. Click on the Total Balance.
3. Choose the month for which you want a statement, and just click on it.
4. Click on Download PDF Statement and wait for the statement to appear.
5. Click on the little "Send" icon in the upper right corner.
6. Select Mail and email the PDF statement to yourself.
7. Open your email on your Mac, and open the attachment that you sent to yourself.
That's how you start. Your Apple Card statement is now there on your Mac, but as a PDF file.

Second, go to AppleCardStatementExport.com (a site that I myself created, and posted just today) and follow the directions. This will get you a tab-separated file in MS Word, and the equivalent in Excel. Quicken should be able to import either one.

NotACPA

Ain't gonna happen. If Apple card wants to provide download into Q, they will need to sign the contract with Q to make it happen.

YOU, the Apple card holders, need to harass Apple into making this happen.

fuchsfr

I have the same problem so I hacked this together.

Using Howard Roark's method : https://community.quicken.com/discussion/7150750/faq-how-to-import-qif-files-into-non-cash-accounts-post-q2004

I created a spreadsheet formula to extract transactional and format them as a QIF file.

Copy the transactions from your GS statement and past them into cell A3

Paste this into cell B3 this:

=("D"&LEFT((LEFT(A3,10)),5))&"'"&RIGHT((LEFT(A3,10)),2)&
CHAR(10)&("U-"&(RIGHT(A3,((LEN(A3))-(FIND("$",A3,(FIND("%",A3))+7)))))&CHAR(10)&"T-"&(RIGHT(A3,((LEN(A3))-(FIND("$",A3,(FIND("%",A3))+7))))))&
CHAR(10)&("P"&(MID(A3,12,(FIND("%",A3))-14)))&
CHAR(10)&"^"&CHAR(10)

Add a header into B2:

!Account
NGS Apple Card
TCCard
^
!Type:Ccard

Finally I use Notepad++ (freeware) to find all quoutation marks " and replace them with nothing.

Save your file and import it using Howard's method.

Quicken_Tyka

Hello all,

Thank you for taking the time to visit the Community to provide your feedback on this Idea.

If a financial institution is unsupported, the only option to contact the financial institution directly, and tell them you'd like to download your accounts into Quicken.

https://www.quicken.com/support/what-do-if-my-bank-not-listed-quicken-or-if-my-bank-was-recently-added-quicken

This Idea is being marked as "Not Planned" as this isn't something that can be established by Quicken.

Thank you,
-Quicken Tyka

Smiller35570

Thanks for the solutions. I heard that Apple is working on a solution.

dlee67018

I use the following tool ac2ofx as a quick work-around:

* Generate an OFX file from the Apple Card monthly PDF statement.
* Then import the OFX file into Quicken.

https://ac2ofx.github.io/ac2ofx/