Note that both columns could be tagged as "Deposit" as is the case with Citi CC. The column containing charges to the card are Positive but the payments column is negative. <<sigh>>.
I presume that someone has a case where both should be tagged as "Withdrawl". --Steve On 9/12/20 7:21 AM, Geert Janssens wrote: > Greg, > > The terms "Deposit" and "Withdrawal" in the csv importer can be a bit > confusing unfortunately. > The terms map well for bank statements using two columns to display amounts, > where both > columns list positive numbers. It maps less well for credit card statements > (interpretation would > be inversed) or two-column representations were the withdrawal column lists > negative numbers. > > As a sidenote, a more general labeling could have been "Amount (unchanged)" > and "Amount > (sign reversed)", because that's what the labeling actually makes gnucash do > internally. > However that also requires user interpretation of the data and understanding > of how gnucash > works internally. > > For your bank statements, if your amounts are all in one column the deposits > are presumably > positive numbers and withdrawals presumably negative numbers. In that case > label this single > column "Deposit". > > If you have separate columns for your deposits and withdrawals, the labels to > use depend on > the signs of the numbers in your csv. > > If the deposit column has positive numbers, label the column as "Deposit". If > the deposit column > has negative numbers, label the column as "Withdrawal". > > For the withdrawal column it's exactly the opposite. > > If the withdrawal column has positive numbers, label the column as > "Withdrawal". If the > withdrawal column has negative numbers, label the column as "Deposit". > > Regards, > > Geert > > Op dinsdag 8 september 2020 05:08:05 CEST schreef David Carlson: >> Greg, >> Usually, when your bank or credit card company creates a CSV file for you, >> either deposits are positive and withdrawals are negative, or vice versa. >> Whichever you see, you then call the amounts deposits or withdrawals when >> performing the import, and GnuCash assigns the value to the Debit or credit >> column as appropriate. >> The key is to correctly tag the value column as deposit or withdrawal when >> importing the file. >> >> >> >> On Mon, Sep 7, 2020 at 8:23 PM Greg Carroll <gregory.a.carr...@gmail.com> >> >> wrote: >>> Hello, >>> >>> I'm new to Gnucash. I have it set up as a checkbook. I imported a csv >>> file, >>> but it put all of the amounts of the deposits and withdrawals only in the >>> deposit column. I can't figure out how get it to recognize deposit amounts >>> separately from withdrawal amounts. I even made separate csv files >>> containing only deposits and one for only withdrawals and upon importing >>> it, gnucash still puts all of the amounts in the deposits column. >>> >>> -- >>> Regards, >>> >>> Greg >>> _______________________________________________ >>> 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 ------------------------------------------- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 _______________________________________________ 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.
