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@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 _______________________________________________ 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.
