Download of Apple Credit Card transactions
edited November 2019 in Manage Accounts and Transactions (Windows)
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.
Totally agree! The transactions should not have to be manually entered.0
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.0
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 VP0
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:
Add a header into B2:
NGS Apple Card
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.0
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.
This Idea is being marked as "Not Planned" as this isn't something that can be established by Quicken.
Thanks for the solutions. I heard that Apple is working on a solution.0
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.
You can give Apple feedback about this sorely-needed functionality here:
@Scott Rose Have you seen this:
It isn't Direct Connect or Express Web Connect, but they do now support Web Connect.0
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.0
Web Connect is downloading a QFX file from the financial institution's website and importing it into Quicken.0
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?0
@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.0
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!1
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.0
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.
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.0
The solution has arrived. Use your search engine (browser) to find "Download or export your Apple Card statements and transactions" (Sorry, Quicken Community won't let me share the actual URL. The instructions are clear. As "Quicken Web Connect" is not an option, I clicked on the "QFX" option and it worked fine. Only extra hoop is that. you have to email or message the QFX file to yourself from your Apple Wallet.0