I successfully download the Applecard CSV through the iPhone, transfer it over to my mac with AirDrop, and import it into my account on Mac Catalina with Gnucash 3.8.
Getting CSV import set up can take a bit of fiddling, but once you get it all configured so it goes through, and you save the configuration, it’s virtually painless. Fiddling involves setting starting lines to skip, character set, selecting the correct columns (remember that positive amounts are withdrawals, so your payment will show as a negative, and selecting the appropriate account for them to be loaded. BE AWARE, transaction matching can really mess up, so I recommend not using it. It would be great if it only sought to match from the last closing date to the present…. Also, It would be nice if the accounts pull-down menu matched the order of accounts in your file, but they appear to be in balance sheet order (assets, liabilitys, income, an expense), so you may have to look through the whole list to find your account. Finally, the process is, for a reason unknown to me, terribly slow, so it seems like nothing is happening, even for a very small import. For a very active account, it can seem like the program has hung. Go get a cup of coffee or take a bathroom break! -Alton Brantley > Date: Mon, 3 Feb 2020 11:44:01 -0500 > From: Keith Bellairs <ke...@bellairs.org <mailto:ke...@bellairs.org>> > To: gnucash-user email group <gnucash-user@gnucash.org > <mailto:gnucash-user@gnucash.org>> > Subject: [GNC] Apple Card csv > Message-ID: > <CAALV8s==p+qtdfhsj+j2_9mukhjqfw4ilgm8bua_r5ysiip...@mail.gmail.com > <mailto:CAALV8s==p+qtdfhsj+j2_9mukhjqfw4ilgm8bua_r5ysiip...@mail.gmail.com>> > Content-Type: text/plain; charset="UTF-8" > I have been using GNC for a long, long time. So I have an account for each > of my credit cards. I can update the accounts with ofx/qfx downloads. I see > that Apple only allows csv downloads from that card. I have never used the > csv upload to GNC. Does anyone have experience with Apple's csv files? If > they don't upload cleanly that's a deal breaker for me. > Keith _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
