How can I set discounts for customers on items that have a variable costs?
How can I set discounts for customers on items that have a variable costs? Ideally I'd like the ability to set for example, a 35% discount that automatically populates when I input the quantity & cost in the invoice for a certain customer . I sell paint so every color and quantity and they have a wide range of costs (full list price) , for example color PR3 to customer A ( more loyal) should receive a 35% discount and customer B ( that barely visits) should only receive a 5% discount. Price rule lists won't work simply because , my costs vary widely as well so its impossible to set a base price from which to discount.
Assigning discounts to customers is currently unavailable in QuickBooks Desktop. A discount item is a percentage or a fixed amount reduction, and is added as a line item to a sales form.
To go about this, you can set discount items with different rates for each customer, then assign it whenever you create a sale.
Go to the Lists menu then select Item List.
Right-click anywhere and select New.
Choose Discount from the list and enter the Item Name/Number. You can use the customer's name if you want to track the discount per client.
In the Amount or % field, enter the rate for a specific customer. You can also use a 0.00% rate if you want to use only one item for all clients. That way, you can manually change the rate on the sales form.
Hit OK when done.
When you create invoices or any sales form, add the discount as a separate line item. Here's how: