Showing results for 
Search instead for 
Did you mean: 
Level 3

Invoice to price by the square Meter



In my company we are making office wood partitions. We purchase woods and make office partitions. I am facing problem to make invoice in quickbooks. Kindly find attached excel file to see my invoice format or below.


QuantityPrice per
Square meter
Unit PriceTotal Price
Full Wood Partition1.81.51205454
Full Wood Partition2.51.422070140


How i can prepare this invoice in quickbooks.


Thanks and Regards,


QuickBooks Team

Invoice to price by the square Meter

Hello there, @talk2khurram


Thanks for visiting the Community. You can use the Price rules option to set up a different selling price for each item with units of measure. 


To do this, let's make sure first that you're subscribed to the Advanced Pricing feature so QuickBooks can automatically change the price on sales forms according to the rules you create. Then, activate Advanced Pricing. Here's how:


  1. Go to the Edit menu, then select Preferences.
  2. Select Sales & Customers, then go to the Company Preferences tab.
  3. In the Custom Pricing section, select Enable Advanced Pricing.
  4. Select OK.


Once done, create a price rule and set conditions for your items. I'll show you how:


  1. Go top the Lists menu, then select Price Rule List.
  2. Select the Price Rule drop-down button, then select New.
  3. Enter a name for the price rule in the Price Rule Name field.
  4. Create conditions by clicking the Plus icon.
  5. Set the date range in the From and To dates.
  6. Set the price
  7. Select the Exclusive Rule checkbox to make the price exclusive.
  8. Click the Price Overrides button to set the custom price for particular items.
  9. Select OK.


You can now create an invoice and select the price rule by clicking the Square icon under the Rate field. Should you need to edit, delete, and inactivate a price rule, here's an article that'll guide you through: Use Advanced Pricing.


Let me know if there's anything else I can help you with. I'm just around to give you a hand. Stay safe. 

Level 3

Invoice to price by the square Meter



Dear Thanks for your reply.


Can i do this any other way because i do not have Advanced Pricing feature.


Thanks and regards,


QuickBooks Team

Invoice to price by the square Meter

Thanks for the reply, @talk2khurram.


Using Unit of Measure (U/M) is another method you could use for your items besides Advanced Pricing. This allows you to show quantities, prices, rates, and costs for an item. There are two ways to assign a U/M in QuickBooks: Single U/M or Multiple U/M. A Single U/M allows you to assign only one U/M for each item while Multiple U/M lets you purchase items in one unit and then sell. This means that you need to purchase and sell the item using the same U/M.


Here's a Community Article that explains more about how the U/M works in QuickBooks Desktop and how to set it up with ease: Use single and multiple units of measure for items.


Let me know if this works for you! I'll be here if you need further assistance or have additional questions. Have a beautiful day.

Need to get in touch?

Contact us