[GNC] CVS Deposit Issue

[Chris Ledbetter]

Thanks for taking the time to fully explain this.  Very helpful.

> On Apr 26, 2023, at 5:02 AM, Geert Janssens <geert.gnucash at kobaltwit.be> wrote:
> 
> Hi Chris,
> 
> The names "Deposit" and "Withdrawal" are a bit misleading. In 5.0 they have been renamed to "Amount" and "Amount (negated)" in the hopes this will slightly improve the situation.
> 
> Internally, gnucash stores only one single amount per transaction(split). So that's what eventually has to be derived from the CSV data. Which columns to select depends on the initial structure of your CSV data.
> 
> I'll give a few examples to illustrate (I have added spaces in the examples to have a nicer alignment - they should not be in the CSV data):
> 
> Example 1:
> Date,       Description,   Amount
> 23/04/2024, Sell Widget A, 100.00
> 23/04/2024, Buy Groceries, -56.00
> 
> This is an example of a CSV file in which all the amounts are in a single column. Incoming money is represented with a positive amount, money going out is represented with a negative amount.
> 
> To import this you'd set the Amount column to "Deposit" (or "Amount" in 5.0), which gnucash interprets as "use these amounts as they are, no changes required".
> 
> Example 2:
> Date,       Description,   Debit,  Credit
> 23/04/2024, Sell Widget A, 100.00,   0.00
> 23/04/2024, Buy Groceries, 0.00,    56.00
> 
> This is an example of a CSV file in which incoming money is represented as a positive number in the Debit column and money going as a positive number in the Credit column.
> 
> To import this you'd set the Debit column to "Deposit" (or "Amount" in 5.0) and the Credit column to "Withdrawal" ("Amount (negated)" in 5.0). That way you instruct GnuCash to use the Debit numbers unchanged and negate the Credit numbers.
> 
> 
> Example 3:
> Date,       Description,   Deposit, Withdrawal
> 23/04/2024, Sell Widget A, 100.00,  -100.00
> 23/04/2024, Buy Groceries, -56.00,    56.00
> 
> This example is similar to your demo. It has both a deposit and a withdrawal column which essentially hold the same information, albeit one is negated version of the other.
> 
> GnuCash only needs this information once, so in this case you choose only one column in the importer. You can either set the "Deposit" column to "Deposit" (or "Amount" in 5.0) or set the "Withdrawal column to "Withdrawal" (or "Amount (negated)" in 5.0), but not both. If you set both, GnuCash will assume you meant to combine both columns in to a single one (like the previous example) and will perform the calculation
> amount = deposit - withdrawal
> for each row. And that would indeed result in doubling all amounts while importing for this kind of CSV file.
> 
> Hopefully this will clear it up for you.
> 
> Regards,
> 
> Geert
> 
> Op woensdag 26 april 2023 01:13:51 CEST schreef Chris Ledbetter via gnucash-user:
> > I am importing Transactions via CSV.  When the importing is finished the
> > Deposit is being doubled upon import.  I am using 4.12 and have not updated
> > yet since I am doing a lot of input and would rather not mess with this
> > until later.  I use a MacBook Pro M1 Ventura 13.3.1.  Here is a demo import
> > CSV file that Deposits $15 via import but should be $7.50.  I have been
> > going in and dividing transactions in the register by 2 to get the correct
> > values.  I just tried dividing the cells by 2 before exporting to CSV but
> > when the system doubles the amount at import, there is often a penny
> > difference.  If there is an easy work around that will be fine.  I can get
> > by doing the math in the register but I’d rather not.  Here is a screenshot
> > of my sample numbers file that I export to CSV before I import.  Thanks
> 
>