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/

Scott Rose

You can give Apple feedback about this sorely-needed functionality here:
https://www.apple.com/feedback/apple-pay.html

Chris_QPW

@Scott Rose  Have you seen this:
https://community.quicken.com/discussion/comment/20097799

It isn't Direct Connect or Express Web Connect, but they do now support Web Connect.

Scott Rose

What is web connect? That article doesn’t mention anything about web connect — it just says that they support exporting statements in .qfx format, which isn’t very helpful and doesn’t do much for us. Direct Connect is what we really need.

Chris_QPW

Web Connect is downloading a QFX file from the financial institution's website and importing it into Quicken.

Scott Rose

Ah, thank you! This actually could be somewhat useful to us, if Quicken auto-matches the imported transactions to previously-entered transactions in our register. Do you happen to know if Quicken does that?

Chris_QPW

@Scott Rose  Yes Web Connect will do the same processing as Direct Connect/Express Web Connect when importing the transactions into the register.  It is just not as convenient as the other two because you have to fetch it manually.  It isn't perfect, but at least it is better than manual entry.

People should keep lobbying for Apple to get Direct Connect (much better than Express Web Connect), most credit cards have it.

For anyone wanting to know the details here is a lower level break down of the three methods.

Direct Connect -> Quicken talks directly to the financial institution's OFX server to request the transactions.  OFX is a standardized protocol for this purpose.  Note that Intuit put in a slight change to the OFX standard and called it QFX.

Web Connect -> The QFX file is actually "results" of what Quicken would have got from the Direct Connect request for transactions.  So it is just reading the results from a file instead of from a network connection.

Express Web Connect  -> is called that because of how it started.  The idea was that Intuit servers would log in to the financial institution's website as you and try to download the QFX file and import it.  Over time that evolved to getting different formats of data that the financial institution and Intuit agreed on, and convert it to QFX format and send that to Quicken.

Scott Rose

Ah, thank you so much for typing all of this up and for explaining all of this to me, @Chris_QPW!  

This makes a lot of sense, and this is fantastic news! It's great to hear that there's not much of a functional difference between "Web Connect" and "Express Web Connect", except for the fact that we have to manually provide the QFX file for "Web Connect".

Also, I didn't realize that I was posting in the Windows forum (because I'm using Quicken for Mac), but it seems like "Express Web Connect" is called "Quicken Connect" on the Mac. And "Quicken Connect" (aka "Express Web Connect") is what I'm already using for all of my bank accounts, so using "Web Connect" won't be too much of a difference for me — except that I'll only be importing my transactions once per month and I'll be doing it manually.

Thanks so much for explaining all of this!

Chris_QPW

Yes your very welcome.  Why they choose to call it Quicken Connect on the Mac is beyond me, but yes it is the same as Express Web Connect.  There are a few of those terms like One Step Update is another, that you have wonder why that changed the terms between the two.  I just guess it is to confuse people.  

Scott Rose

Ha, I originally preferred the term "Quicken Connect" because it sounded less daunting & less technical than "Express Web Connect". However, when it comes to understanding the differences between "Web Connect", "Express Web Connect", and "Direct Connect", those 3 terms together actually make much more sense. I'm so glad that I accidentally ended up in the Windows forum, because this has enlightened me greatly!  

On the Mac, "One Step Update" is called "Update All Online Accounts", which I kind of prefer better because it makes more sense to me about what's going to happen.

Chris_QPW

Scott Rose said:

On the Mac, "One Step Update" is called "Update All Online Accounts", which I kind of prefer better because it makes more sense to me about what's going to happen.

Well as Quicken Mac expands its features One Step Update might make more sense since for Quicken Windows that update can be Download transactions, get bill presentment, send bill pay information, get security quotes, update credit score, sync with Quicken cloud, update the online portfolio, check Quicken program updates, ...
And I'm probably missing something here or there.