Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
Liftco
Level 3

Average Cost

Can I set up a Customer to use "Average Cost" on an item when invoicing?  For Example:

 

I sell items to different divisions within our company.  Accountant says I have to charge them the "average cost" of the item.

 

Is there a way to set up the customer to automatically use "average cost" instead of me having to look item up each time?

1 Comment 1
JessT
Moderator

Average Cost

Hi there, Liftco.

 

Thank you for taking the time to get help with setting a selling price for the items you sell within your company. I've got information about this.

 

The option that you're looking for is not available. QuickBooks will always use the Sales Price when selling an item instead of the Average Cost. You can, however, create a Price Rule for a specific customer representing the divisions and for the items you sell in those divisions.

 

First, go to your list of items and list all the items you sell within your company, and get the average cost.

 

Second, create a price rule for those items:

 

  1. From the Lists menu, select Price Rule List.
  2. Right-click within the table and choose New.
  3. Enter the name and the description of the price rule.
  4. Click the + icon to assign a customer.
  5. Set the date range.
  6. Click Price Overrides to assign a custom price to the items.
  7. Select OK.

    price rule.PNG

 

You can create a sales transaction after creating a price rule. Here's an article for your additional reference: Set up and Use Advanced Pricing.

 

Let me know if you need help as you go through the steps. Take care and have a great weekend!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us