cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to add a item as a percentage instead of $ amount

I would like to add a fee as a percentage of the items already on the invoice. Ex. add a 10% commission of all items of the invoice.
Solved
Best answer 03-31-2019

Accepted Solutions
Established Community Backer ***

Re: How to add a item as a percentage instead of $ amount

Unlike desktop, there is no percentage line item in QBO

 

There is a work around though

create a service item named discount and link it to a sales income discount account, set the rate to a negative %, -10%, when you click out of the rate box QBO will change that to -0.1 (or you can just enter a negative decimal number = to the percent of discount)

 

use that item on the invoice or sales receipt, enter the amount to be discounted as the qty

the resulting math will be a negative 10% of the amount.

 

3 Comments
Established Community Backer ***

Re: How to add a item as a percentage instead of $ amount

Unlike desktop, there is no percentage line item in QBO

 

There is a work around though

create a service item named discount and link it to a sales income discount account, set the rate to a negative %, -10%, when you click out of the rate box QBO will change that to -0.1 (or you can just enter a negative decimal number = to the percent of discount)

 

use that item on the invoice or sales receipt, enter the amount to be discounted as the qty

the resulting math will be a negative 10% of the amount.

 

Not applicable

Re: How to add a item as a percentage instead of $ amount

This worked. I've seen this workaround before in the forums but couldn't make it work because it wasn't clear how the workaround worked. Now I understand what it's doing.

For anyone else who wants to use a percentage as a line item:

Basically, you want to trick QBO into doing the % calculation for you. 

As an example, if you want to discount 20% from the subtotal of $1000.00. You would create the discount item as @Rustler illustrates. So you create the item and enter -20% or -.20 in the rate field. When you go to add this discount item to an invoice you want to enter the subtotal amount you want to apply the discount to into the quantity field. In our example, you would enter $1000.

 

QBO calculates:

Quantity ($1000.00) x Rate (-.20) =  -$200

 

On the reverse side, you can use this method to add/charge a fee/commission/tax as a percentage. You would simply change the negative decimal number into a positive one in the rate field. 

 

For anyone wondering why not just use the default discount field in the invoice. It's because using the default % option would apply the discount to the entire invoice and you might just want to apply a discount to part of an invoice. 

 

Hopefully, this helps others and clears things up. This should really be a built-in feature in QBO.

Not applicable

Re: How to add a item as a percentage instead of $ amount

This worked. I've seen this workaround before in the forums but couldn't make it work because it wasn't clear how the workaround worked. Now I understand what it's doing.

For anyone else who wants to use a percentage as a line item:

Basically, you want to trick QBO into doing the % calculation for you. 

As an example, if you want to discount 20% from the subtotal of $1000.00. You would create the discount item as @Rustler illustrates. So you create the item and enter -20% or -.20 in the rate field. When you go to add this discount item to an invoice you want to enter the subtotal amount you want to apply the discount to into the quantity field. In our example, you would enter $1000.

 

QBO calculates:

Quantity ($1000.00) x Rate (-.20) =  -$200

 

On the reverse side, you can use this method to add/charge a fee/commission/tax as a percentage. You would simply change the negative decimal number into a positive one in the rate field. 

 

For anyone wondering why not just use the default discount field in the invoice. It's because using the default % option would apply the discount to the entire invoice and you might just want to apply a discount to part of an invoice. 

 

Hopefully, this helps others and clears things up. This should really be a built-in feature in QBO.

Need to get in touch?

Contact us