New Apple Card

chris_hardin's Avatar

chris_hardin

14 Nov, 2019 01:27 AM

OK - so I already know the answer to this question / comment, but wanted to at least throw it out there for the developers to consider for the future. I'm a long-term Apple/Macintosh user, so it just made sense to try out the new Apple credit card. It's nicely integrated with the iPhone Wallet app, but there is one significant down-side: there is no online access to the account. All I can do is see a list of transactions on my phone, and once a month, Apple will send me a PDF with a listing of all the transactions.

In the long-run, I'd like to be able to import these credit card transactions into MoneyDance just like for any other card. If you see or hear anything from Goldman Sachs (the card issuer) about the potential for online access, please let us know. Right now I'm stuck entering card transactions one at a time. If I get real ambitious, maybe I'll write something to parse the PDF file and convert to a CSV, which can then be uploaded. Who knows.

  1. Support Staff 1 Posted by Maddy on 14 Nov, 2019 02:19 PM

    Maddy's Avatar

    Hi Chris,
    Thank you for contacting Moneydance support.

    As unfortunately, Apple Card does not support third party integration services, at this time, it's not possible to download transactions.
    If they begin to support third party integration services, at any point, we'd be happy to make it happen.

    Please let me know if you have further questions or need any assistance.

    --
    Maddy, Infinite Kind Support

  2. 2 Posted by hleofxquotes on 16 Nov, 2019 06:06 PM

    hleofxquotes's Avatar

    @chris_hardin

    Can you contact me at hleofxquotes at gmail dot com?

    I have a small tool/code that I am using that I can share. If others are interested, please send email.

    The tool/code is not ready for general use yet. I can parse/read payments, transactions but not interest. I don't have sample of how the "Interest Charged" table look like. So if you have a statement with "Interest Charged" and are willing to share (just that page), will be appreciated.

    Best,

  3. 3 Posted by hleofxquotes on 01 Dec, 2019 06:33 PM

    hleofxquotes's Avatar

    I've released ac2ofx, a tool to generate OFX file for Apple Card transactions. That will make it possible to import Apple Card transactions into Moneydance.

    For more information, please see: https://ac2ofx.github.io/ac2ofx/

  4. Support Staff 4 Posted by Sean Reilly on 02 Dec, 2019 02:02 PM

    Sean Reilly's Avatar

    Hi Chris,

    I should mention that hleofxquotes' program is not affiliated with Moneydance so we can't be responsible for it, but it does seem to be the only way (currently) to pull transaction data out of Apple Card statements.

    Thanks,
    Sean

    --
    Sean Reilly
    Developer, The Infinite Kind
    https://infinitekind.com

  5. 5 Posted by chris_hardin on 03 Dec, 2019 01:45 AM

    chris_hardin's Avatar

    Noted Sean - but I am curious if you guys have at least tried it out?

    In particular, since I would expect you guys have much more expertise at this question than me - do you agree it generates a valid OFX file that MoneyDance should handle without problems when I import it? I've reviewed the text of the file and compared it to other OFX files I have locally, and everything looked reasonable. But as I said, I'm no expert on the underlying standards for creating those files.

    Thanks,

    Chris

    (Let me know if you want/need official PDF's from Apple for testing.)

  6. 6 Posted by derekkent23 on 03 Dec, 2019 08:07 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Chris.

    I have used a number of extensions created by hleofxquotes and always found them reliable. I don’t have an Apple card to test, but a suggestion.

    Do a EXPORT BACKUP and then RESTORE FROM BACKUP and test the extension. If things don’t work out you can revert to your original data set.

    Hope this helps.

  7. Support Staff 7 Posted by Sean Reilly on 03 Dec, 2019 09:23 AM

    Sean Reilly's Avatar

    Hi Chris,

    I haven't tried it out, but I do believe that hleofxquotes is a very capable developer and I would think that the OFX would be valid. I also try to make Moneydance be as lenient as possible, because even some of the biggest banks produce some really awful OFX. I'd guess that hleofxquotes' output is probably better than most :)

    I personally avoid installing outside code as much as possbile because if we do end up adding the same or similar capability in Moneydance then our work should be done completely independently.

    Thanks,
    Sean

  8. 8 Posted by Dan Sandberg on 27 Jan, 2020 02:31 AM

    Dan Sandberg's Avatar

    You can also export a csv file from Apple. Don't know if that will help anyone. I have had little but some luck just importing that file, but its tough.

  9. 9 Posted by dwg on 27 Jan, 2020 02:48 AM

    dwg's Avatar

    I'm a fellow user.

    Stan's CSV importer is arguably the best and most flexible CSV importer that is available for Moneydance

    https://github.com/stant/mdcsvimporter2015/releases/tag/v22

  10. 10 Posted by Dan Sandberg on 27 Jan, 2020 02:55 AM

    Dan Sandberg's Avatar

    So I did a little work, the best way to do this, although not automatic is the following:

    1) export the data each month from your wallet to a csv file. I email the file to me.
    2) import the file into your applecart account in Moneydance.
    3) leave all the menu items in the first dialogue box as the file is csc
    4) In the fields buttons, make them read as follows:
         Date
         Ignore
         Ignore
         Description
         Category
         Ignore
         Debit Amount

    Click next and then everything should be entered in fine.

    One note, in August 2019, Apple did not yet remove all commas from some of the fields and that really screws up the csv file. So either go into that file and clean up the extra commas in the fields or manually enter the data. For months after August, no stray commas in the fields.

    Hope that works for everyone. Not that much of a hassle.

  11. 11 Posted by Bill on 04 Feb, 2020 01:03 PM

    Bill's Avatar

    Has anyone figured out how to get MoneyDance to declare as "unconfirmed" all the AppleCard transactions imported from a CSV file? I can import these CSV files, and it saves typing everything in manually, but there are no blue dots in the imported data.

  12. 12 Posted by dwg on 04 Feb, 2020 08:25 PM

    dwg's Avatar

    I'm a fellow user.

    Look at using Stan's CSV importer as mentioned in post #9, it is my understanding that this supports the confirmation process.

  13. Support Staff 13 Posted by Sean Reilly on 04 Feb, 2020 10:36 PM

    Sean Reilly's Avatar

    Moneydance 2019.2 (or maybe .3) and newer will import transactions from csv files in "downloaded" mode, which means they should be marked with the blue dots and be available for confirmation. Just make sure you use the built-in CSV importing and not the older text-import extension.

    Thanks,
    Sean

  14. 14 Posted by Dan Sandberg on 05 Feb, 2020 02:49 AM

    Dan Sandberg's Avatar

    Sean,
    When using the csv import, is there any way to save the field designation (that I note above in item 10 of this post). Instead of having to designate the fields each time I import the same csv file format from Apple, or do I have have to each time designate the fields? This would be a good add / improvement to the import csv function. Thanks.

  15. 15 Posted by Bill Sloan on 05 Feb, 2020 01:52 PM

    Bill Sloan's Avatar

    Sean, when I tried using File->Import in MoneyDance 2019.3 and selecting an AppleCard CSV transaction file, I had no chance to identify columns or anything else. I just got the following error message:

    There was an error importing the file 'Apple Card Transactions - January 2020.csv': java.lang.NumberFormatException: For input string: “62021800698463710018"

    I checked the CSV file in TextEdit on my Mac, and no such number appears in the file.

    - Bill

  16. 16 Posted by Barnabas on 13 Feb, 2020 04:58 PM

    Barnabas's Avatar

    The Apple Card now has an option to download the statement as an OFX file. However, when trying to manually import the file into the proper account within MoneyDance, the file is not importing. In MD, I created an Apple Card Account. I highlight it, then choose File -> Import, select the file and then click on Open. And nothing happens. According to your documentation, I should get a window where I can choose the MD account, but MD does nothing. No error message, no import, it just ignores the commands. What am I doing incorrectly? Thanks for you help.

  17. 17 Posted by derekkent23 on 13 Feb, 2020 06:36 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Barnabas

    Two thing you could try assuming you are already running Moneydance 2019.
    1. In Moneydance select your apple account in the side bar to show the apple register. Drag and drop the OFX file into the side bar, not into the register.
    2. If you are not already, try the latest preview build from https://infinitekind.com/preview

    Hope this helps

  18. 18 Posted by Barnabas on 13 Feb, 2020 08:00 PM

    Barnabas's Avatar

    Hi derekkent23,

    Thank you for the prompt response. I was running MD 2019.3 and tried the drag and drop into the register in addition to the menu commands. No success. I also downloaded MD preview 2019.4 and tried again with both methods and also no success. MD looks as if it is simply ignoring the commands. Any other thoughts?

  19. 19 Posted by hleofxquotes on 13 Feb, 2020 08:16 PM

    hleofxquotes's Avatar

    Short answer is that the OFX as exported by Apple is bad (very badly formatted, just dead-on-arrival).

    It seems the feature was rushed (or whoever implemented does not know OFX very well). I can't see how it got past QA. A simple import to Quicken, MD, MS Money ... would have failed immediately.

  20. 20 Posted by Jim Sizemore on 13 Feb, 2020 08:19 PM

    Jim Sizemore's Avatar

    Thank you - that confirms my suspicion. I’ll report the difficulty to Apple/Goldman directly.

  21. 21 Posted by -Kevin N. on 02 Mar, 2020 01:44 PM

    -Kevin N.'s Avatar

    Hi Dan Sandberg,

    When using the csv import, is there any way to save the field designation...

    Stan's CSV Importer allows you to save any number of card configurations.

    Forum member dwg provided the link to Stan's Importer in post # 9 of this thread. There is a 'How to' document at the bottom of the linked site.

    If you need a hand setting it up, post back and I'll try to lend a hand.

    -Kevin N. (not a member of MD support)

  22. 22 Posted by jimmplsmn on 02 Mar, 2020 09:06 PM

    jimmplsmn's Avatar

    Just to add to dwg's and Kevin's excellent suggestions - when you install Stan's CSV importer extension, if you are using a recent build of MD, you may see a red banner at the top of the summary page saying "The extension CSV Importer is not verified and should be considered unsafe" and an "Uninstall" button on the right, which to the uninitiated may cause heartburn. Never fear, Stan's importer has been a long-time stable extension for MD but it has not been officially "signed" as acceptable. I have used this extension for several years and it has never caused any issues.
    - Jim (also not a member of MD support)

  23. 23 Posted by sth on 15 Mar, 2020 04:40 PM

    sth's Avatar

    Just a note, Apple seems to have fixed their corrupt file issue and the February data imported just fine for me.
    (not IK support)

  24. Support Staff 24 Posted by Maddy on 16 Mar, 2020 01:03 PM

    Maddy's Avatar

    That's excellent news!

    Thank you for sharing, Scott!

    --
    Maddy, Infinite Kind Support

  25. 25 Posted by Andy Geisse on 16 Apr, 2020 02:04 AM

    Andy Geisse's Avatar

    Where is the option on Apple to download OFX? I went to the apple wallet on my Mac and see no option to export OFX transactions. Or does it only work after a bill?

  26. 26 Posted by sth on 16 Apr, 2020 01:00 PM

    sth's Avatar

    Yes, it is at the same place you can download a PDF of your bill. But that only comes out at the end of each month. You can save the bill to "Files" on the phone and then pick it up in iCloud.

    I assume the same thing for Apple Wallet on the Mac version but have not updated to Mac OS Cat for a bunch of reasons.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac