[GNC] CSV matching for credit cards?

[David Cousens]

Elmar,

The example you listed is not comma separated but  blank and/or tab separated so
the comma as a separator has no effect. If you have a blank selected as the
separator in the import dialog, it will treat the blanks in the description as
separators and put each word in a different field so amount column for the
second record won't line up. If the description in the first record shown also
has blanks then it will be treated similarly and the columns won't line up as
you expect. CSV means comma separated variables. If your data contains commas,
e.g. some European currencies use it as the main currency separator, then you
can select any other character as a separator as long as it doesn't appear in
your data. If your bank is supplying it as blank separated with blanks in the
description field they need to think again, it won't work. If they don't fix it
you can edit the file to replace blanks which are not in description fields with
another character  e.g. "%" or "&"  etc that is not used in the data in your
file.

Once you have that sorted, you can assign either the Deposit or Withdrawal
header to the Amount column of your data file. One will assign Debit to +ve
amounts and Credit to negative amounts and the other will reverse these. Idon't
know which way round it is though. It will likely be opposite to the assignment
you used to import asset account data


On Thu, 2021-04-01 at 17:20 -0400, Elmar wrote:
> Good evening - I have managed to figure out how to do the csv matches 
> for normal asset accounts, since the labels actually line up with what I 
> expect them to mean.  But I am having problems with credit cards.  My 
> csv looks like this:
> 
> Tran Date    Post Date    Description    Ref Number    Amount
> 3/20/2021    3/21/2021    [redacted]         19918    74.99
> [lots more lines like the above]
> 3/3/2021    3/3/2021    PAYMENT - THANK YOU        -792.66
> 
> How does this line up with deposit?  Withdrawal? And in the gnucash file 
> the columns for liability accounts are increase and decrease, which does 
> match either the csv, or the importer.
> 
> Further, I can't get some matches that are obviously matches to match - 
> date, amount all both identical, but it says "no match". Why?
> 
> - Elmar
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed