Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T
Tammys2
October 15, 2021
Question

Cost column

  • October 15, 2021
  • 1 reply
  • 3 views

I am looking at adding the cost column to my invoice template.  I can enter the cost of $50 and the sell price of $100.

 

I am doing journal entries for the reduction of inventory to Cogs.  What report will I find the info I enter in the cost column?

1 reply

C
Catherine_B
Level 9
October 15, 2021

Hello there, Tammys2.

 

Let me share some info about customizing your invoice templates and running reports.

 

You can add the Cost and Price (Rate) column to your invoice template, and you can see it when you create an invoice. However, the option to display it when your print the invoice is unavailable. To customize it, here's how: 

 

  1. Click the Lists menu and select Templates.
  2. Double-click on the Invoice template you use for the invoice.
  3. Click Additional Customization.
  4. Go to the Columns tab and select Cost and Rate (Selling Price).
  5. Click OK and then OK to close the windows.

When you create an invoice, just make sure that the customized template is selected for you to see the options you added. 

 

For the reports, if you're referring to the costs entered in your transactions, the option to add this column is unavailable. You'll have to open each transaction to know the cost entered. However, if you want to just see all of your item's Prices and Costs, you can pull up the Item Price List report. 

 

Here's how: 

 

  1. Go to Reports and choose Customers & Receivables.
  2. Select Item Price LIst.
  3. By default, you can see the Price column. Just click the Customize Report option to add the Cost.
  4. Under the Columns tab, search for Cost.
  5. Select it and then OK.

I've got you these articles as your guide in customizing and exporting your reports to excel from QuickBooks Desktop: 

 

Let me know if you need further assistance while working in QuickBooks. I’ll be right here ready to help. Enjoy the rest of the day.

    T
    Tammys2Author
    October 22, 2021

    I was able to add the cost column.  However I can't manually enter a cost in the column.

     

    If I use an inventory item from the list it will auto populate the cost and sell price.  If I enter a list item titled non-stock - enter the description it won't allow me to enter a cost.

     

    Any suggestions?

    AlcaeusF
    AlcaeusF
    Level 14
    October 22, 2021

    Hello @Tammys2,

     

    I appreciate you for getting back to us here in the Community. I have some information about QuickBooks Desktop's capability.

     

    Currently, the option to enter the cost amount directly on an invoice is unavailable. You'll need to go to the Item list and update the product or service information.

     

    Here's how:

     

    1. Click the Lists tab at the top menu.
    2. Select Item List.
    3. Double-click the item.
    4. Update the cost amount.
    5. Hit OK. 

     

    For additional reference, you can use the following article if you want to create an invoice from a sales order or estimate: Create an invoice in QuickBooks Desktop.

     

    Fill me in if you have additional questions about entering sales transactions in QuickBooks. I'm always here to help. Take care always.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement