[GNC] Import Transactions: Withdrawals vs Deposits, and Account

[Geert Janssens]

That's one solution. The other would have been (although non-obvious) to set both accounts 
as "Deposit". That's allowed in the csv importer. Deposit and Withdrawal come from the 
early days of the importer and don't cover all use cases very well.

"Deposit" here really means, use the number unchanged (positive numbers will be imported 
as positive numbers, negative numbers as negative ones) while "Withdrawal" means reverse 
the sign of these numbers before importing them. So if your column already had negative 
numbers where you wanted these, "Deposit" is the number type that does what you want. In 
GnuCash 5.x these names have been changed in an attempt to make them more generic, to 
"Amount" and "Amount (negated)", but even that requires some interpretation due to the 
many possible ways csv data can be structured.

Regards,

Geert

Op zondag 3 september 2023 15:48:43 CEST schreef Tom Balazs:
> Problem solved: the withdrawal columns were all negative numbers. I changed
> them to positive and it worked correctly.
> 
> On Sun, Sep 3, 2023 at 9:20 AM Tom Balazs <tom123online at gmail.com> wrote:
> > I'm importing transactions into a checking account. Why do all transaction
> > amounts go into the deposits column?
> > 
> > I'm trying to import transactions one month at a time for a checking
> > account.
> > I have a CSV file with one month of transactions. I went through the
> > Transaction Import Assistant / Import Preview. I set "Import Account" to
> > the checking account. I use the column headings map Date column,
> > Description column, Withdrawals, and Deposits. Many
> > withdrawal transactions, few deposit transactions. I import. And then I
> > view the ledger for that checking account and all the transactions are put
> > in the Deposits column. How do I fix this problem?
> 
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.