Bug 475221

Summary: 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'
Product: [Applications] kmymoney Reporter: Dawid Wróbel <me>
Component: importerAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: REPORTED ---    
Severity: normal    
Priority: NOR    
Version: git (master)   
Target Milestone: ---   
Platform: Other   
OS: Other   
Latest Commit: Version Fixed In:
Sentry Crash Report:

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.