Re: [GNC] CSV matching for credit cards?
Elmar, As David suggested, you can assign values to either increase or decrease then they will either import correctly or opposite. Then choose whatever works correctly. Most months you will have one transaction that transfers from a bank account and most of the rest will be identified by whatever your credit card calls them. On Thu, Apr 1, 2021, 6:33 PM Elmar wrote: > Sorry - the csv is comma separated. To post this I dumped it into > libreoffice, the copy/pasted into a text file, which of course removes > the commas. The original is like so: > > Tran Date,Post Date,Description,Ref Number,Amount > 3/20/2021,3/21/2021,[redacted],019918,74.99 > ... > 3/3/2021,3/3/2021,PAYMENT - THANK YOU,,-792.66 > > Sorry for the confusion. This is then in theimporter specification > (obviously skip first line) date, none, description, number, and here I > stumble. The liability account has headers that say Increase, and > Decrease. Now is that a deposit in the importer or a withdrawal? It's > the switches in terminology that confuse me: "amount" in the csv vs. > deposit/withdrawal in the importer vs. increase/decrease in the > liability account. What is which? Is my "amount" a "deposit" that will > translate into an "increase" if a positive value? > > And finally, the matching question is also unresolved. Thanks for the > reply, and apologies for my denseness. - Elmar > > On 4/1/21 6:07 PM, David Cousens wrote: > > Elmar, > > The example you listed is not comma separated... > > > 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 > > > > ___ > 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. > ___ 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.
Re: [GNC] CSV matching for credit cards?
Sorry - the csv is comma separated. To post this I dumped it into libreoffice, the copy/pasted into a text file, which of course removes the commas. The original is like so: Tran Date,Post Date,Description,Ref Number,Amount 3/20/2021,3/21/2021,[redacted],019918,74.99 ... 3/3/2021,3/3/2021,PAYMENT - THANK YOU,,-792.66 Sorry for the confusion. This is then in theimporter specification (obviously skip first line) date, none, description, number, and here I stumble. The liability account has headers that say Increase, and Decrease. Now is that a deposit in the importer or a withdrawal? It's the switches in terminology that confuse me: "amount" in the csv vs. deposit/withdrawal in the importer vs. increase/decrease in the liability account. What is which? Is my "amount" a "deposit" that will translate into an "increase" if a positive value? And finally, the matching question is also unresolved. Thanks for the reply, and apologies for my denseness. - Elmar On 4/1/21 6:07 PM, David Cousens wrote: Elmar, > > The example you listed is not comma separated... > > 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 > > ___ 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.
Re: [GNC] CSV matching for credit cards?
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 DatePost DateDescriptionRef NumberAmount > 3/20/20213/21/2021[redacted] 1991874.99 > [lots more lines like the above] > 3/3/20213/3/2021PAYMENT - 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.
[GNC] CSV matching for credit cards?
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.