[GNC] Apple Card csv

[Alton Brantley]

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 <keith at bellairs.org <mailto:keith at bellairs.org>>
> To: gnucash-user email group <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>>
> Subject: [GNC] Apple Card csv
> Message-ID:
> 	<CAALV8s==P+QtdFHSj+J2_9MuKhjQFW4iLgm8bua_r5ySiipzbQ at mail.gmail.com <mailto:CAALV8s==P+QtdFHSj+J2_9MuKhjQFW4iLgm8bua_r5ySiipzbQ at 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