# Bank fees - entering as a % (manually but ideally automatically)

**URL:** <https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713>\
**Category:** Uncategorized\
**Created:** [July 19, 2017, 2:30am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713 "2017-07-19T02:30:01Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![CoastalHobbies](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@CoastalHobbies](https://forum.manager.io/u/CoastalHobbies)\
**Post date:** [July 19, 2017, 2:30am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/1 "2017-07-19T02:30:01Z")

</div>

When entering the receipt of a customer payment by credit card, I need to account for the providers fee of 2.2%

I can enter the payment and then choose add line and enter the bank charge as a negative value and this works.  
My problem is that I can’t work out how to do it without manually calculating what the fee is.

It would be a good feature in the software to either automatically add in the 2.2% fee each time I enter the payment or, if I enter the payment and then add an additional line for the fee, just enter the % figure and the software calculate the $ value based on the line above it.

Can you please consider adding this feature as I’m sure many others would like it too?

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [July 19, 2017, 3:08am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/2 "2017-07-19T03:08:06Z")

</div>

Your workflow is not correct because the receipt is from the customer and is income. The bank fee goes to the financial institution and is an expense. They have to be separate transactions. The reduced amount will not properly clear a customer’s _Accounts receivable_ balance (if they are paying off a sales invoice) nor provide a correct cash receipt.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 19, 2017, 5:00am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/3 "2017-07-19T05:00:01Z")

</div>

> [@CoastalHobbies](#):
>
> I need to account for the providers fee of 2.2%

Is the providers fee (a) deducted from the customers payment so you receive a nett amount (sale less fee, such as via PayPal) or is the providers fee (b) charged to you separately (apart) from the customers payment ?

---

<div class="post-metadata">

**Author:** ![CoastalHobbies](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@CoastalHobbies](https://forum.manager.io/u/CoastalHobbies)\
**Post date:** [July 19, 2017, 6:47am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/4 "2017-07-19T06:47:24Z")

</div>

E.G.

I receive a payment of $400 from a customer by credit card

$400 is applied to customers invoice but the transaction into the cash account is $400 less the bank charge of 2.2% ($8.80), which is applied as a bank fee

- Invoice of $400 is paid off
- $391.20 added into cash account
- $8.80 added to bank fee ledger

---

<div class="post-metadata">

**Author:** ![CoastalHobbies](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@CoastalHobbies](https://forum.manager.io/u/CoastalHobbies)\
**Post date:** [July 19, 2017, 6:50am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/5 "2017-07-19T06:50:22Z")

</div>

I can do this manually but when the amounts are odd (which is often) I need to pull out a calculator each time to calculate the value to enter. It becomes time consuming.

Ideally, a setting could be added to apply a fixed % as the bank fee for each payment of the particular type but as a minimum, be able to split the line and just enter the % and the software calculates the value.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 19, 2017, 7:31am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/6 "2017-07-19T07:31:20Z")

</div>

Sorry but you have confused me - “I received a payment of $400 from a customer by credit card”

Did you receive 400 or 391.20 as the “deposit” amount into your **bank account**?  
Not your transaction into the Cash Account.

---

<div class="post-metadata">

**Author:** ![CoastalHobbies](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@CoastalHobbies](https://forum.manager.io/u/CoastalHobbies)\
**Post date:** [July 19, 2017, 10:47am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/7 "2017-07-19T10:47:59Z")

</div>

Exactly as I stated!

The customer paid $400 by credit card, I receive the full payment less 2.2% into my account, which is $391.20.  
I don’t think it’s that hard to understand.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 19, 2017, 11:54am UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/8 "2017-07-19T11:54:01Z")

</div>

> [@CoastalHobbies](#):
>
> I receive the full payment

You can’t “ **receive** the full payment” if a fee has been deducted before you **receive** the payment.  
Therefore, the customer paid 400 in which you **received** 391.20 after the deduction of the fee.

---

<div class="post-metadata">

**Author:** ![CoastalHobbies](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@CoastalHobbies](https://forum.manager.io/u/CoastalHobbies)\
**Post date:** [July 20, 2017, 12:08pm UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/9 "2017-07-20T12:08:43Z")

</div>

Exactly as I said " I receive the full payment less 2.2% into my account, which is $391.20"  
I never said I received the full payment.

---

<div class="post-metadata">

**Author:** ![CoastalHobbies](https://avatars.discourse-cdn.com/v4/letter/c/977dab/32.png) [@CoastalHobbies](https://forum.manager.io/u/CoastalHobbies)\
**Post date:** [July 20, 2017, 12:14pm UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/10 "2017-07-20T12:14:30Z")

</div>

Tut,  
The way I have been doing it is to receipt the total actual payment figure and then add a line for the bank charge and enter the calculated fee as a negative value.

I may be wrong, but from what I have read I believe that this is the way to do it.

All I’m asking is for the program to automatically calculate the fee and enter the extra line when the payment is done or, have the facility to enter a % figure and the program calculate what the fee is based on the % figure entered against the above line.

I have used software where both or at least one of these methods are available so am just suggesting it be considered as an added feature in the future if it can’t already be done.

Thanks for your help, Hope I have explained myself adequately.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [July 20, 2017, 12:16pm UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/11 "2017-07-20T12:16:44Z")

</div>

> [@CoastalHobbies](#):
>
> I may be wrong, but from what I have read I believe that this is the way to do it.

That is the correct method (now that you have clarified what you actually receive)

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [July 20, 2017, 1:57pm UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/12 "2017-07-20T13:57:36Z")

</div>

> [@CoastalHobbies](#):
>
> The way I have been doing it is to receipt the total actual payment figure and then add a line for the bank charge and enter the calculated fee as a negative value.

This is correct. I’m not sure why, but I was also confused as to what you are doing. Rereading the entire thread with hindsight, it all seems clear from the beginning. But for some reason is wasn’t so the first time around. Apologies for my denseness.

> [@CoastalHobbies](#):
>
> All I’m asking is for the program to automatically…enter the extra line…or…calculate what the fee is based on the …above line.

There is the problem with implementing your idea. The basic structure of Manager uses independent line items. The program has no knowledge of any relationships between them and never creates line items on its own. It takes context for every line item from the form it is on and relates it to customers or suppliers, as necessary But it does not have the capability to look to other line items for information or calculation. It just isn’t structured that way. The only time any transaction is entered automatically is when customer or supplier credits are applied to invoice balances or late fees are calculated. But those events involve totals and balances, not line items.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:25pm UTC](https://forum.manager.io/t/bank-fees-entering-as-a-manually-but-ideally-automatically/10713/13 "2023-01-18T15:25:36Z")

</div>

Closed on January 18, 2023, 3:25pm UTC


