GnuCash
Contact   Instructions
Bug 795155 - CSV import does not distinguish between deposit and withdrawal
Summary: CSV import does not distinguish between deposit and withdrawal
Status: RESOLVED FIXED
Alias: None
Product: GnuCash
Classification: Unclassified
Component: Import - CSV (show other bugs)
Version: 3.0
Hardware: Other Mac OS
: Normal major
Target Milestone: future
Assignee: import
QA Contact: import
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-11 08:34 EDT by Christoph Rohland
Modified: 2018-04-14 17:08 EDT (History)
5 users (show)

See Also:


Attachments
test csv file (56 bytes, text/csv)
2018-04-11 08:34 EDT, Christoph Rohland
no flags Details

Description Christoph Rohland 2018-04-11 08:34:48 EDT
Created attachment 370788 [details]
test csv file

The new csv transaction importer treats withdrawal and deposit columns the same.

When importing the attached file it will use it as deposits in a bank account independent if I tag the third column deposit or withdrawal. Negative numbers will be withdrawals though.
Comment 1 Geert Janssens 2018-04-11 13:40:06 EDT
Are you sure? If you tag the third column it should revert the meaning of the numbers.

If the column is tagged "Deposit", positive numbers will be true deposits, negative numbers will be true withdrawals.

If the column is tagged "Withdrawal", positive numbers will be true withdrawals, negative numbers will be true deposits.

Is this not happening for you ?
Comment 2 Christoph Rohland 2018-04-11 15:42:24 EDT
Yes, I am sure. Stumbled over this in my real file with a credit card account and had the same in my test file in a bank account. Tried multiple times. All the same...
Comment 3 Tae Won Ha 2018-04-14 05:46:42 EDT
This also happens to me:

macOS 10.13.4
Gnucash 3.0

If I import the following line

2018-01-01; some description; 10; 20

with the column setting "Date; Description; Deposit; Withdrawl", Gnucash treats both Deposit and Withdrawl columns as Deposit.
Comment 4 Geert Janssens 2018-04-14 06:44:39 EDT
I can confirm now that I actually have time to run gnucash myself.

The fix was trivial and will appear in gnucash 3.1 (still to be released).

Thanks for your report!
Comment 5 Tae Won Ha 2018-04-14 14:02:17 EDT
I don't know how many people use the CSV import feature, but would it be possible to release a bugfix version earlier than 2018-05-13 for 3.1?
Comment 6 John Ralls 2018-04-14 17:08:02 EDT
Depends on how much progress we make on the other bugs.

Note You need to log in before you can comment on or make changes to this bug.