@Aliuk100 when you import CSV file above in the latest version, Manager will see Net
column only. It will ignore Gross
and Fee
columns.
The reason for this behaviour is so when you import transactions, you can then use bank rules to automatically categorize them.
You have basically two options:
You can create bank rules that will calculate fee. For example, if the fee represents 18.7% of the net amount, then… your receipt rule could look like this (yes - you can use negative percentage in receipt rules).
Or you can add up all the fees to get total fee amount and then make a journal entry where you Credit
sales account and Debit
bank charges.