Download of Apple Credit Card transactions
Smiller35570
Member ✭
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.
Tagged:
3
Comments
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.
Now running Quicken Windows Subscription, Home & Business
Retired "Certified Information Systems Auditor" & Bank Audit VP
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.
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
* Generate an OFX file from the Apple Card monthly PDF statement.
* Then import the OFX file into Quicken.
https://ac2ofx.github.io/ac2ofx/
https://www.apple.com/feedback/apple-pay.html
https://community.quicken.com/discussion/comment/20097799
It isn't Direct Connect or Express Web Connect, but they do now support Web Connect.
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.
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!
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.