Quickbooks Manufacturing Desktop, creating estimates for customers using inventory assembly items

Anonymous · ‎July 11, 2024

I am working on setting up inventory in our Quickbooks desktop (manuafacturing & wholesale). We manufacture and sell wholesale products. As I am setting the inventory parts and assemblies, I enter the cost for each "part" for the assembly item. I then enter the "sales price", which is retail. Each of our customer has a specifc "price level" discount off retail pricing.

When I go to create an estimate to email to my customer, the estimate shows the cost of the item along with a "markup" instead of their discount. It is showing the cost to manufacture with a percentage increase to get the customers cost (specific percentage off retail).

Example: Customer A is ordering Product A. Suggested retail for Product A is $575. Customer A's discount is 60% off retail pricing. Customer A's cost is $230. Quickbooks estimate is showing the cost to manfucure Product A is $75, with a 206.6% markup, to get the total $230.

I cannot figure out how to do the reverse of the above and dont understand why there is a "markup" instead of "discount" when this is a Manufacturing and Wholesale product. I dont want our customers to see an increase in pricing. I need it to show Retail price, their discount, and their cost on the product.

I have tried many ways to work around including turning on advanced inventory, but nothing I try seems to help. Any insite will be very helpful.

Thank you,

Cade

LouiseG · ‎July 11, 2024

I appreciate your detailed information and the provided screenshot, Cade. Let me further explain the markup showing on the estimate instead of the discount in QuickBooks Manufacturing and Wholesale, Cade.

The percentage in the Markup column indicates the increase in the customer price compared to the manufacturing cost. If an item has a 60% discount, the customer's final price ($230) is 206.66667% higher than the manufacturing cost ($75).

Considering that you can select a discount price level from the Markup dropdown list, you'll want to utilize the Customize Data Layout in the estimate to manually add a field for the price level discount and hide the Markup column when printing the estimate.

I've added a screenshot below for visual reference.

Alternatively, to add the discount as a line item. See the outlined steps below.

Go to the Lists menu and select Item list.
Click on the Item button below, then select New.
Choose Discount from the type dropdown and fill out the necessary information. You can set a discount percentage or a specified dollar amount. Also, specify the account to be used to track your discounts.
When you're ready, select OK.

For more detailed instructions, you can refer to this article: Use discount and subtotal items on an Invoice.

Don't hesitate to add a reply below if you have any other questions or concerns about managing your estimates. I'll be glad to help.

Topics

Training

Community

Resources

Quickbooks Manufacturing Desktop, creating estimates for customers using inventory assembly items

Quickbooks Manufacturing Desktop, creating estimates for customers using inventory assembly items

Need to get in touch?