# Trouble Importing Bank Statement (accounting for ebay fee)

**URL:** <https://forum.manager.io/t/trouble-importing-bank-statement-accounting-for-ebay-fee/48761>\
**Category:** Uncategorized\
**Created:** [September 3, 2023, 10:07pm UTC](https://forum.manager.io/t/trouble-importing-bank-statement-accounting-for-ebay-fee/48761 "2023-09-03T22:07:22Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [October 15, 2023, 1:25am UTC](https://forum.manager.io/t/trouble-importing-bank-statement-accounting-for-ebay-fee/48761/10 "2023-10-15T01:25:44Z")

</div>

@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).

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/6/26fa47bc7c2fbd4daaa6d76a2997845d1e8044a7.png)

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.

---

_[View the full topic](https://forum.manager.io/t/trouble-importing-bank-statement-accounting-for-ebay-fee/48761)._