Bug 475221 - When importing CSV, it should be possible to designate more than one column for amount, just in case there's additional column for a 'fee'
Summary: When importing CSV, it should be possible to designate more than one column f...
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: importer (show other bugs)
Version: git (master)
Platform: Other Other
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-10-04 20:21 UTC by Dawid Wróbel
Modified: 2023-10-04 20:21 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dawid Wróbel 2023-10-04 20:21:20 UTC
SUMMARY
I am importing a Revolut CSV statement which has a separate Fee column. This is mostly unused, unless an international transaction was registered, in which case their exchange fee is shown in Fee column. A sum of both Amount and Fee column actually constitute the full Amount in such case, however, CSV importer currently only allows to choose a single Amount column.

An example of CSV:

Type	        Product	Started Date	Completed Date	Description	        Amount	Fee	Currency	State	        Balance
EXCHANGE	Current	8/6/23 12:36	8/6/23 12:36	        Exchanged to USD	-45.5	0.46	EUR	        COMPLETED	38.24

STEPS TO REPRODUCE
1. Import a CSV with extra Fee column

OBSERVED RESULT
1. Notice it isn't possible to select additional column for Amount

EXPECTED RESULT
It should be either possible to select multiple Amount columns, just like it is doable with Memo column. Alternatively, there should an additional dedicated  column for a Fee. However, I can imagine other scenarios where a statement can have multiple fee-like columns, in which case a single Fee column would still impose a limitation.