Cost column

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: 

• Customize reports in QuickBooks Desktop
• Export reports as Excel workbooks in 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.

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?

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.

I've followed the steps listed to add a "cost" column to my invoice template but the cost is not a preloaded option. I have used "other 1" and titled it cost but once saved, it does not populate the field when I add items with a cost.

Using Premier Plus Manufacturing and Wholesale Edition 2022

Hello @TracTuffRob,

Thank you for reaching out to us here in the Community. I can provide some clarification about the Cost column when creating invoices in QuickBooks Desktop. 

Currently, the option to add the preloaded Cost column is available in the Enterprise version only. Since you're using Premiere, I recommend entering the amount manually from the "Other 1" custom column (see screenshot below).

Additionally, I recommend visiting the following article to learn how to fix error messages when customizing templates in QuickBooks: Fix common issues when you use and customize templates.

Feel free to hit that Reply button if you have additional questions about the sales forms or the columns on an invoice. Have a great day ahead.