Download of Apple Credit Card transactions

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.
2
2 votes

Not Planned · Last Updated

Comments

  • danddmillerdanddmiller Member
    Totally agree! The transactions should not have to be manually entered.
  • dbcsrdbcsr Unconfirmed, Member
    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.
  • NotACPANotACPA SuperUser ✭✭✭✭✭
    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.
    Q user since DOS version 5
    Now running Quicken Windows Subscription,  Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • fuchsfrfuchsfr Member
    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_TykaQuicken_Tyka Moderator ✭✭✭✭
    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
    -Quicken Tyka
  • Thanks for the solutions. I heard that Apple is working on a solution.
  • dlee67018dlee67018 Member
    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/
Sign In or Register to comment.