cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
JLN1977
Level 1

Commodity Codes (HS Codes)

I am currently moving my accounts to QB Online from Sage and have found work arounds for most things. However, I cant find much on commodity codes for products.

My business exports products around the world and for outside of the EU we often need to include the commodity codes on the invoice. 

In Sage we have the relevant code tagged to the relevant product and are then able to print on the invoice where necessary. I cant see how QBO handles this

HELP!

Solved
Best answer October 17, 2019

Accepted Solutions
MJoy_D
Moderator

Commodity Codes (HS Codes)

It's our pleasure to help, @JLN1977.

 

Yes, the item/service code is for the specific product or service. Once you've added a code, it will automatically be attached to the invoice that you'll be creating. The alternative would be to use the description box or use a custom field box(both of these you would need to manually enter the Commodity codes each time)

 

Just make sure to activate the item/service code column when creating an invoice as well as on your invoicing template as mentioned by @John C

 

Here’s how to add the item/service column to your invoices:

  1. Go to your Sales menu and then Invoices.
  2. Hit the New invoice button to create an invoice.
  3. Click the Gear icon at the top to choose what you see on this page.item1.JPG
  4. On the Optional columns part, click box beside the Product/Service and Item/Service. item2.JPG
  5. Tap the X mark at the top to save.

To add it on the invoice template that’ll be sent to your customers, check the following steps:

  1. Go to the Gear icon and choose Custom Form Styles.
  2. Select the template that you’re using from the list.
  3. Hit the Content tab and tap the middle part of the greyed out invoice.
  4. Click the Item Code.
  5. Choose Done to save the changes. item3.JPG

Check this article for more information: Create an invoice

 

For other concerns and follow-up questions, feel free to let me know by leaving a comment below. I'm always here to assist. Have a wonderful day!

View solution in original post

16 REPLIES 16
John C
QuickBooks Team

Commodity Codes (HS Codes)

Hi JLN1977

 

When you create the product you can enter a code in the Item/Service code section. You will then also have to enure that the Show item/Service Code column is activated within the product and services, this is located in account and settings > sales.

You will also have to activate the item code within the custom form styles section, account and settings > custom form styles > edit > content > select the middle greyed out section > select item code.

When you create an invoice/sales receipt and select print and preview you will be able to see the item code on the invoice that is sent to your customer.

JLN1977
Level 1

Commodity Codes (HS Codes)

Thanks for the reply John.

This item code is for our internal Product / Item identifier code isn't it?

These commodity codes are internationally recognised codes for import duty allocation at destination port so the customs officials know how much duty to charge basically. 

MJoy_D
Moderator

Commodity Codes (HS Codes)

It's our pleasure to help, @JLN1977.

 

Yes, the item/service code is for the specific product or service. Once you've added a code, it will automatically be attached to the invoice that you'll be creating. The alternative would be to use the description box or use a custom field box(both of these you would need to manually enter the Commodity codes each time)

 

Just make sure to activate the item/service code column when creating an invoice as well as on your invoicing template as mentioned by @John C

 

Here’s how to add the item/service column to your invoices:

  1. Go to your Sales menu and then Invoices.
  2. Hit the New invoice button to create an invoice.
  3. Click the Gear icon at the top to choose what you see on this page.item1.JPG
  4. On the Optional columns part, click box beside the Product/Service and Item/Service. item2.JPG
  5. Tap the X mark at the top to save.

To add it on the invoice template that’ll be sent to your customers, check the following steps:

  1. Go to the Gear icon and choose Custom Form Styles.
  2. Select the template that you’re using from the list.
  3. Hit the Content tab and tap the middle part of the greyed out invoice.
  4. Click the Item Code.
  5. Choose Done to save the changes. item3.JPG

Check this article for more information: Create an invoice

 

For other concerns and follow-up questions, feel free to let me know by leaving a comment below. I'm always here to assist. Have a wonderful day!

Westmark
Level 1

Commodity Codes (HS Codes)

Dear JLN1977,

 

Have you ever found a solution for adding commodity codes to QuickBooks? We have recently started with QB and missing the option.

 

Kind regards,

 

Jop

MJoy_D
Moderator

Commodity Codes (HS Codes)

I can help you add those codes into your account, Jop.

 

To add commodity codes in QuickBooks Online, you’ll just have to turn it on from your Account and Settings

 

Here’s how:

  1. Go to the Gear icon and select Account and Settings
  2. Click the Sales tab and click the pencil/edit icon beside the Products and services
  3. Tick the checkbox for Show Item/Service Code column.
  4. Click on Save and then Done.

From here, you can follow the steps provided by me above on how to add the item/service column to your invoices.

 

Here’s more information on how to create and send invoices in QuickBooks Online.

 

Let me know if there’s anything that I can help. I’m always here to assist. Have a wonderful day!

Westmark
Level 1

Commodity Codes (HS Codes)

Dear MaryJoy,

 

Thank you for your reply. It does not seem to work. I do not see the option in accpunt settings-sales Show Item/Service I only see Show Product/ Service which is switched on (see attachment). Also I do not see Optional Collumns Item/Service code in the invoice (see attachment). Can you help?

 

Furthermore. Do you know what commodity codes (HS codes) are? These are internationally used codes to let customs determine the sort of goods.  What we need is a way to enter it in the product itself and then  it must come on the invoice automatically (maybe this is what you are trying to do, however I am not sure as it is not working)

 

Thanks again.

 

Regards,

 

Jop

Ashleigh1
QuickBooks Team

Commodity Codes (HS Codes)

Hello Westmark, 

 

Thanks for coming back to us and sending the screenshot, 

 

Can you turn on the setting that says show SKU column in the main cog wheel>account and settings>sales>product and service. 

 

Once this is turned on you should then see the column appear for you to use. 

 

If you have any other quires please reach back out to us. 

Westmark
Level 1

Commodity Codes (HS Codes)

Dear Ashleigh,

 

This is working, thank you, we can use SKU for our HS codes/tariff numbers.

 

However the final thing is how do we change the actual name "SKU" which now appears on the invoice (see attachment) to either HS code or Tariff number or something else? Is this possible and how?

 

Kind regards,

 

Jop

GeorgiaC
QuickBooks Team

Commodity Codes (HS Codes)

Hi Jop, 


Thanks for getting back to us on this thread, I'm pleased those steps provided by my colleague helped you out :thumbs_up:

 

You can edit how this heading appears on the form by going to the Cog wheel > Custom form style > Select edit against the template > Content > Click into the middle body of the invoice > Select 'Edit labels and widths' and re-name the column and click 'Done' to save.

 

Get back to us below if you have any other Q's! :smiling_face_with_smiling_eyes:

Westmark
Level 1

Commodity Codes (HS Codes)

Pefect, thanks!

EmmaM
QuickBooks Team

Commodity Codes (HS Codes)

Hello Westmark:waving_hand:, You're welcome. Anything else please feel free to reach out to us on the Community!:grinning_face:

nicola15
Level 1

Commodity Codes (HS Codes)

Hello,

 

What if we need to provide the item code (SKU) AND HS Code on the invoice?

Is there no way to add an extra column to to invoices?

 

Thank you

jamespaul
Moderator

Commodity Codes (HS Codes)

Hello, Nicola. 

 

I'll give you a hand in adding the item and the HS codes on your invoices. 

 

Only the item code or SKU column can be added to the invoice. One way to include the HS code is to use the item's description. 

 

First, you'll want to edit the item's settings and add the HS code in the Description box. Here's how to do it: 

 

  1. Go to the Gear icon, then select Products and services
  2. Find the item, then click on Edit
  3. Add the HS Code under the Description box.
  4. Click Save and close

 

 

itemcode2.PNG

 

Next, ensure the Product Description is checked and visible on your invoice template:

 

  1. Go to the Gear icon, then select Custom form style.
  2. Find your template, then click on Edit
  3. Go to the Content tab, then click the middle section on the preview image.
  4. Ensure the Description box is checked (and the SKU or item code box). 
  5. Click Done

 

itemcode1.PNG

 

 

Then, you can start adding the item on your invoices. The item code will show under the SKU column and the HS Code with show under Description.

 

itemcode3.PNG

 

Also, more invoice customisation settings might be added in the future updates. For now, I suggest checking our Product Updates page from time to time for the release notes. 

 

Looking to run reports to see how much you've made from your sales? Check out the guides in our Financial reports topic page

 

I'm happy to show you around in the program again if you need help with QuickBooks Online. Just reply here or create a new thread. 

nicola15
Level 1

Commodity Codes (HS Codes)

Thank you for the reply, but that does not solve the issue unfortunately as it is only replacing the name of the column by another.

 

My problem is that I need to add columns to the invoice as there aren't enough to display the information needed.

I need a column for:

Supplier SKU

Vendor SKU

HS code

Product name

Product description

HS Code

Country of origin

QTY

Unit price

Total price

Sales Tax

 

Right now, all solutions provided in this thread were to replace the names of the columns not add one.

Yet there have been a few threads for this already.

Can we not add this feature?

 

Thank you.

 

KlentB
Moderator

Commodity Codes (HS Codes)

Hi there, nicola15.

 

I understand that you need to display additional columns in your invoices. Please know that your ideas and suggestions will really help us identify the features our customers want, expect, and need. That said, I encourage sending feedback to our Product Development Team. We'd like to take this opportunity to improve your QuickBooks experience.

 

When you're ready, here's how to submit feedback:

 

  1. Sign in to your QuickBooks account.
  2. Click the Gear icon at the top.
  3. Under the Profile section, select Feedback.
  4. Enter the features you'd like us to add in the description box, then click Next to complete the process.

You can visit our blog from time to time to stay current with all our news and product updates.

 

In addition, I've included an article that will you design and personalize your other sales forms in QuickBooks Online: Customize invoices, estimates, and sales receipts.

 

I'll be right here to keep helping if you have any other concerns or further questions about invoices. Assistance is just a post away.

Craig Bromley
Level 1

Commodity Codes (HS Codes)

100% Agree, I've asked Quickbooks several times about this, there are not enough displayable fields.

 

I can't use the description box for HS Codes as I need that for the description, we need right now:

1) Dedicated HS Codes column displayable on the invoie

2) The ability to add NET Weight of the product, and then print a summary of net weight BY HS CODE or a summary on the invoice as this is a mandatory requirement for shipping now

3) There should also be signature block at the bottom with the option for an electronic signature as this is also manditory for shipping now, having to do more manual work signing and scanning documents to meet this requirement

4) There should also be an option for COLLECTION ADDRESS as that needs to be on the invoice now too

5) It would also be usual to have a column on the invoice for Country of Origin

 

I'm sick of doing so much manual work on an automated platform, Quickbooks sort this out!

Need to get in touch?

Contact us