Skip to main content
January 13, 2020
Solved

Automatically Calculate Selling Fee / Commission

  • January 13, 2020
  • 1 reply
  • 0 views

Hello,

Is it possible to have line items on a sales invoice such as selling fee and commission that is based on the subtotal of items sold and not based just on the last item entered. As per the image attached, I would like fees and commissions based on $510.00 and not the last item entered ($210.00).

 

Thank you.

JR

Best answer by JessT

Yes, it's possible, JR. I'll guide you on how to do it.

 

You can add a subtotal item after Lladro-1415, so the calculation for the fee and the commission will be based on the sub-total amount. To do this, just add a new item from the Invoice page, select the Subtotal type and name it as Subtotal.

 

 

The outcome will look like this:

 

If you want to check the total commission for a certain period, you can go to your chart of accounts. Then, run a quick report of the account that is associated with your commission item.

 

Feel free to reach back out if you have other questions about your transaction.

1 reply

JessT
JessTAnswer
January 13, 2020

Yes, it's possible, JR. I'll guide you on how to do it.

 

You can add a subtotal item after Lladro-1415, so the calculation for the fee and the commission will be based on the sub-total amount. To do this, just add a new item from the Invoice page, select the Subtotal type and name it as Subtotal.

 

 

The outcome will look like this:

 

If you want to check the total commission for a certain period, you can go to your chart of accounts. Then, run a quick report of the account that is associated with your commission item.

 

Feel free to reach back out if you have other questions about your transaction.

DCBUSAuthor
January 14, 2020

Hello,

That worked perfect. Thank you very much.

Michael K
January 14, 2020

Hey there, @DCBUS.

 

Glad to hear everything is in order and you're back to business! 

 

The Community will always have your back. Wishing you and your business continued success in all that you do.