[GNC] Apple Card csv

Stephen M. Butler kg7je at arrl.net
Mon Feb 3 14:17:05 EST 2020


On 2/3/20 8:44 AM, Keith Bellairs wrote:
> 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


Not Apple's but I do have experience with CSV and Citi.  Under 3.7 I was
able to define the layouts (what fields went where and the date format)
and save that for future use.  Also defined the "home" account (in my
case, Liabilities:CreditCard:Citi).

My only problem is that they also changed the sign of the payment AND
put it in the other column.  So the load routine dutifully turned it
into a charge instead of a payment.  I think options were added to 3.8
to allow you to override this.  Perhaps load both fields to the same
"column" in the account.

I finally located where Citi hid their OFX download and switched back to
that to cure having to fix the payment sign each download.


--Steve

-- 
Stephen M Butler, PMP, PSM
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8




More information about the gnucash-user mailing list