Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

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 March 31, 2019

Best Answers
Level 15

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.

 

View solution in original post

17 Comments
Level 15

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.

 

View solution in original post

Level 2

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.

Level 2

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.

Level 2

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

The only bummer is how it shows the dollar amount as the quantity.  In the online version, the quantity column would be blank, rate/price 25% and Total the reduction (in our case).  It made for a very clean looking invoice.  Now it'll have 12,225 in the qty which looks very silly against the actual quantities of the products (1, 3, 2...) and -0.25.   It would be preferred to go back to the original format.

QuickBooks Team

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

Hi there, @info44.

 

Quantity should be defaulted to 1 when adding an item to a transaction unless you manually changed it. To get it back to the original format, let's perform some troubleshooting steps.

 

There are times that the browser is full of frequently-accessed page resources, thus causing websites, like QuickBooks Online (QBO), to act weirdly. Try logging into your QBO account using a private browser.  

 

To use a private browser, here's how:    

 

  • Google Chrome: Ctrl + Shift + N
  • Internet Explorer: Ctrl + Shift + P
  • Mozilla Firefox: Ctrl + Shift + P
  • Safari: Command + Option + P

Once logged in, go back and try to add the discount item again to double-check. For your reference, you can read this article for more guidance: Add a Discount to an Invoice or Sales Receipt.

 

If this works, it means that you need to clear your browser's cache so the system can start fresh.  

 

If you get the same result while using a private browser, I recommend switching to a different browser. 

 

Also, in case you might want to customize your invoices and sales receipts forms in the future, you can check out this article for more details: Customize your Invoices, Estimates, and Sales Receipts in QuickBooks Online.

 

Just hit the Reply button if you have additional questions. I'll be right here to help.

Level 2

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

Using the discount field at the bottom of the invoice is one thing.  Creating a line item that takes a discount is different.  The original post was about doing the latter.  We can't use the discount field b/c not every line item on our invoices always gets a discount and I don't see any way to code my items to be applicable for discount or not.

 

In desktop version, and the work around for this one, we enter the discount as a line item underneath the item it applies to.  For the discount line item to auto calculate I have to make the quantity the dollar of the item.  It's already set to % off so then the total is the amount to come off.

 

I'm open to other ideas tho.

QuickBooks Team

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

Hi info44,

 

At this time, you can only apply discount per line item with the exact amount set up on the Products & Services page. As a workaround, you can manually calculate the amount so you can enter discount in your invoice.

 

I'll pass this along to our product team to let them know of your business needs. 

 

I have included this article in case you have other questions about QuickBooks Online (QBO): Sales And Customers.

 

Keep me posted if you have other concerns. I'll be here to help.

Level 1

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

Hi, I'm looking at moving from Desktop to online. This would be a deal breaker. Has it been fixed?

 

QuickBooks Team

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

Hello there, @waynehowell.

 

You can set up and use the percentage in QuickBooks Online.  

 

Here's how to set up an item:

  1. Go to Sales.
  2. Select Products and Services.
  3. Click on New.
  4. Choose the Service item.
  5. Enter the item information.
  6. In the amount field, enter the negative amount (if it's a discount) and enter the positive.
  7. Click on Save and Close

Once done, when creating a transaction add this item.

 

In case you need to view an article about applying discounts, here it is: Apply a discount on an invoice or sales receipt

 

Please let me know if you have any other questions or concerns. I'll only be a post away.

Level 1

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

I tried setting up the discount percentage as an item but it just shows $.03 as the amount instead of 3%?  What am I doing wrong?  If you could take some screenshots on how you setup the item, that would be great.  Thank you!

Level 1

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

Thank you!!!!!

Level 1

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

Like the previous poster, I do not see how to add a percentage, and it tell me a negative number is not permissible.

QuickBooks Team

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

Thanks for joining this thread, PATinCO,

 

I'm here to help you set up an item as a percentage in QuickBooks Online.

 

Before we start, I'd like to ask for a screenshot of the message you're getting when entering a negative amount. It helps me check what needs to be done.

 

To create an item, you'll want to select the service type. Then, enter the name like "5% Discount" and enter "-0.05" in the Sales price/rate field.  Don't forget to select an account to track the discount item. See the attached screenshot below for your visual guide.
addadiscountitem.PNG

Check out the Adding Products and Services, Customers, and Vendors to Lists page for instructions, detailed steps, screenshots to guide you.

 

There's also a feature in QuickBooks where you can discount invoices and sales receipts.

 

Stay in touch with me on how everything turns out by commenting below. I'm always right here to help.

Level 1

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

In your screenshot below, the 5% discount is not coming off the invoice, 5 cents is coming off the invoice. A 5 percent discount on $1,000 is $50, not 5 cents.

QuickBooks Team

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

Yes, you're correct, @PATinCO.

 

Five percent of 1000 is equivalent to 50. However, the screenshot that was provided above is just an example of how to set up a discount as a service item. 

 

However, I'll provide you another workaround on how you can add a percentage discount to your customer's invoice. 

 

First, let's turn on the discount feature. 

 

  1. Go to the Gear icon and select Account and Settings.
  2. Click the Sales tab on the menu.
  3. In the Sales form content section, select the pencil ✏ icon to edit it.
  4. Click the Discount checkbox to turn it on.
  5. Select Save and click Done.

 

This adds the discount field to your invoices and sales receipts. QuickBooks also creates a discount given an account to track everything on your chart of accounts. 

 

Once done, you can now apply a discount to your invoice. Here's how:

 

  1. Click the + New icon and select Invoice.
  2. Add products and services. Then, fill out the rest of the form.
  3. Select Discount percentage to enter the discount as a percentage.
  4. Enter the amount you want to discount in the discount field. For example, enter 5 if you wanted to get a 5% discount out of 1000. 
  5. If you want to discount the total before you calculate sales tax, select the arrow icon next to the discount field.
  6. When you're finished, Save and close.

 

In addition, you can run the Invoices and Received Payments report in QuickBooks Online (QBO). This will show you the payments that you’ve received from your customers and the invoices that go with them. Just go to Reports and look for the Invoices and Received Payments report.

 

I'm always here to help if you have any other concerns or questions. Just tag my name in the comment section and I'll get back to you as soon as I can.

Level 1

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

Hi, 

 

I have gone rounds and rounds with support and no one can get my late fee to calculate correctly.

 

Can you please let me know if anyone is able to get a 1.5% per month late fee to work?  If so, can you screen shot your set up of it I would greatly appreciate it.  When I try to enter a percentage to the Service it converts it to a dollar amount and I do not want to manually calculate late fees on every single invoice we have.

 

Thank you in advance for the help!


@MaryLandT wrote:

Thanks for joining this thread, PATinCO,

 

I'm here to help you set up an item as a percentage in QuickBooks Online.

 

Before we start, I'd like to ask for a screenshot of the message you're getting when entering a negative amount. It helps me check what needs to be done.

 

To create an item, you'll want to select the service type. Then, enter the name like "5% Discount" and enter "-0.05" in the Sales price/rate field.  Don't forget to select an account to track the discount item. See the attached screenshot below for your visual guide.
addadiscountitem.PNG

Check out the Adding Products and Services, Customers, and Vendors to Lists page for instructions, detailed steps, screenshots to guide you.

 

There's also a feature in QuickBooks where you can discount invoices and sales receipts.

 

Stay in touch with me on how everything turns out by commenting below. I'm always right here to help.


 

 

Moderator

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

Welcome to the thread, GJanisch.

 

Let me get the help you need concerning late fees. 

 

In QuickBooks Online (QBO), you have the option to set up and add late fees to overdue invoices in which you can have the system apply automatically.

 

To set up, here's how:

  1. Login to QuickBooks Online as the Master Administrator or Company Administrator. 
  2. Go to the Gear icon at the top.
  3. Choose Account and settings.
  4. In the left menu, click Sales
  5. Go to the Lates fees section and check the box to turn on late fees. 
  6. Specify the fee type, amount, grace period, and how it will show up on the invoice.
  7. Hit Save, then Done.

To set late fees to a customer, see below steps:

  1. In the left menu, click Sales
  2. Go to the Customers tab.
  3. Click the name of the customer you want to apply late fees. 
  4. In the Late fees tab, toggle Enabled
  5. Select Use default or Customize
  6. Hit Save.

Once done, the system will automatically calculate late fees beginning at 12 am PST. Then, the late fee should be applied sometime before 7 am PST.

 

If you'd like to add surcharges and service fees to invoice manually, here's a resource you can visit for a guide: Add product and service items to QuickBooks Online.

 

For more details, see this article: Set up and apply automatic late fees to invoices.

 

If you have other questions or need help with anything about QuickBooks, leave a comment below. I'll be glad to get back and provide further assistance. Have a great day.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us