Skip to main content
July 28, 2022
Question

Invoice Layout on QB Online

  • July 28, 2022
  • 1 reply
  • 0 views

Good morning,

 

I own a distribution company and I am trying to setup the invoices to allow discounts per line item.

What I am looking for is to show:

Product code, description, quantity, RRP, customer discount from RRP, what the customer pays (net Price) - basically a typical product invoice

 

Currently my QB Online just shows:

Product code, description, quantity, RRP, 20% for VAT, Price including Inc VAT.

It then "calculates" the discount for all products and shows a sum for the whole order. 

 

How can I edit so that the invoice shows product discount per line item?

 

1 reply

MariaSoledadG
July 28, 2022

I'll show you how you can add a discount per line item, Marinetrade.

 

QuickBooks Online (QBO) gives you the flexibility when adding discounts on sub-total or per line item on your invoice. To do this, you can create a discount item on the Product and Services page by following the steps below:

 

  1. Select the Gear or Settings ⚙ icon and then Products and Services.
  2. Select New.
  3. Select Service for the type.
  4. Enter the name “Discount” in the Name field. If you want to create multiple discount items, give each discount a unique name so they're easy to tell apart.
  5. In the Sales price/rate field, enter the discount as a negative amount. Keep in mind, that must be a whole amount and not a percentage.
  6. From the Income account ▼dropdown menu, select the Discounts given account that QuickBooks created when you turn on the discount setting.
  7. Select an appropriate tax rate so that the discount is nontaxable.
  8. When you’re done, select Save and close.
     

Then, delete the invoice. To do so, follow the steps below:

  1. Go to the Sales menu. Then go to the Invoices tab.
  2. Select the invoice that you want to de delete. 
  3. Go to the Action column, then click on the drop-down arrow and choose Delete.
  4. Click Yes to confirm the process.

 

After that, recreate a new invoice so you can add the discount item to your sales form. Here's how:

  1. Select + New.
  2. Select Invoice, Estimate, or Sales receipt.
  3. Add your products or services in the Product/Service column.
  4. Then, add the discount item you just created in the Product/Service column. You can adjust the discount if you need to, just make sure it's a negative amount.
  5. Fill out the rest of the form.
  6. When you’re ready, select Save and send or Save and close.
     

This procedure certainly lets you enter discounts per line item in your invoice. Additionally, QuickBooks lets you record sales transactions in two ways. You can create a sales receipt if your customer pays you at the time of sale. But if they pay you in the future, you'll have to record the payment in QuickBooks. For more information on how this works, this article will show you the complete details: Record Invoice Payments In QuickBooks Online.

 

Please get back to us if you have any concerns with discounts. We're here to further assist you if you need us.