cancel
Showing results for 
Search instead for 
Did you mean: 
cirrusmarketing
Level 2

Customize Invoice Template Default - NOT WORKING!

Hello -

 

After many years of using QB, I need to start utilizing the SKU field.

 

So I created a "customized" template, made it the "default" and cannot get it to apply going forward.  I have tried everything, read everything and call tech support and nothing.

 

Please help as this is an important feature I need to start using but cannot.

 

Anyone else with this issue, feedback is appreciated!

6 Comments 6
AlverMarkT
QuickBooks Team

Customize Invoice Template Default - NOT WORKING!

Hi, @cirrusmarketing

 

You're on the right track in setting a customized template as default to show the SKU of a product or service. I'm here to further assist you on this.

 

When you create a customized template for your printed invoice, you can choose which fields to include, such as the SKU field. If you have set your default template to show the SKU for a product or service, don't worry, as it will still appear on the printed form, even if it is not visible on the invoice sheet. Furthermore, if you use the old layout when creating invoices, there is an additional step to display the SKU field.

 

  1. In your invoice sheet, go to the Gear icon.
  2. Scroll down to Optional Columns.
  3. Put a checkmark on the SKU under Product/Service.

 

Please refer to the image below:

 

 

To check if the SKU will be applied to your printed invoice, you can click on Print preview. Also, if you need assistance changing SKU for a product or service, you can do so when editing a product or service.

 

I have included an article on adding custom fields to your transaction sheets to help you track important information: Create and edit custom fields in QuickBooks Online Advanced.

 

Let me know if you need further assistance customizing your invoice through the reply button. I'd be glad to assist. Take care.

cirrusmarketing
Level 2

Customize Invoice Template Default - NOT WORKING!

So I need to clarify further -- the reason for using the "SKU" field is when I initiate an invoice for our services each line on the invoice must also have a specific "ID Code". I cannot use the "Description" field because I need that for something else! 

 

My end goal is to be able to export to Excel so I can match the "ID Code" (or SKU) to something within our workflow process.

 

BUT I don't see the SKU on the invoice.  If you have a better idea of how to handle it, let me know!!  Or need further clarification

MarkAngeloG
QuickBooks Team

Customize Invoice Template Default - NOT WORKING!

I understand the importance of showing the SKU to your invoice forms, @cirrusmarketing. Rest assured, I'm here to guide you to show this and achieve your goal.

 

You'll need to set up an SKU on each product on the Products and Services page for it to show in an invoice.

 

Here's how:

 

  1. Go to Sales, then select Products & Services.
  2. Find a product and click Edit on the Action column.
  3. Fill in the ID Code you want in the SKU textbox field.
  4. Hit Save.

 

Repeat the steps for each product or service to which you want to add SKU. Create an invoice and fill in each line item with your products. It will automatically show in the SKU column if you have enabled it from the settings as my colleague, @AlverMarkT, has provided.

 

If the ID code still doesn't show in the SKU column, we'll need to clear your browser's cached data to ensure your browser is running in the best condition for QuickBooks Online.

 

For Google Chrome browser, here's how:

 

  1. Press Ctrl+Shift+Delete while on your browser.
  2. Select only the Cached images and files.
  3. Set the time range to All time.
  4. Click Clear Data.

 

If you're using a browser other than Chrome, refer to this link as it shows the steps for each browser: Clear cache and cookies to fix issues when using QuickBooks Online.

 

I'd be glad to help you with any concerns besides the SKU not showing on your invoices. Let us know by commenting below.

cirrusmarketing
Level 2

Customize Invoice Template Default - NOT WORKING!

Thanks for the suggestions, but now I am realizing the SKU field is not going to work. 

 

Everything we do has a specific "ID Number" and will never be duplicated.  So clearly using the SKU field will not accommodate my issue.

 

Is there not a way to add a custom field so we have a unique way of identifying each line of service we are invoicing for?

Kurt_M
QuickBooks Team

Customize Invoice Template Default - NOT WORKING!

Hi there, @cirrusmarketing.

 

There isn't a way to add a custom field to identify each line service added inside your invoice in QuickBooks Online (QBO). We appreciate your idea, and it would be great if it's available inside the program. We'd recommend sending a feature suggestion to our Product Development Team so they can evaluate the idea and consider it for future updates. We'll write down the steps to get you going:

 

  1. Access your QuickBooks Online company.
  2. On the top right-corner, click the Gear icon.
  3. Select Feedback and then enter your comments or product suggestions.
  4. Once ready, click Next to submit feedback.

 

In addition, you can check these articles to help you manage customers' payments and monitor every transaction's status inside QBO:

 

 

We look forward to having you in the Community space if you have additional questions or need assistance managing invoices inside QuickBooks. Keep safe.

cirrusmarketing
Level 2

Customize Invoice Template Default - NOT WORKING!

I think I've figured out how to handle this!

 

I've decided to change how I've been using the "Product/Service" field on the invoice and use "Description" to identifying on that line of service what our internal ID Code is for that line of service.

 

It's going to take some work to clean up what we have in Product/Services but I think this is the ideal solution since QB does not support adding another field for each line of service.

 

Let me know your thoughts on this!   

Need to get in touch?

Contact us