cancel
Showing results for 
Search instead for 
Did you mean: 
jbutler-lifefuels
Level 1

COGS account mapping

I am not sure if this is the right place or not but I was looking for some help. I am not in accounting, I am more on the tech side and have been brought in to try and a problem. Our setup is that we sync order from Shopify to QB desktop with Connex.

 

We sell sku A that is bundled with 3 skus (B, C, D) and I could purchase skus B, C and/or D separately if I wanted. In QB, sku A has one COGS account while skus B, C, D have another COGS account. Is it possible for skus B, C, D to be mapped to one COGS account when they are bundled with sku A and another COGS account when they are not a part of the bundle?

 

Any input is appreciated.

Solved
Best answer September 30, 2020

Best Answers
LieraMarie_A
QuickBooks Team

COGS account mapping

This is just the place to get the answers you're looking for, @jbutler-lifefuels!

 

Yes, you can map a separate COGS account for SKUs B, C, and D that you've set up as a single item and as a bundle. All you have to do is choose the appropriate COGS account for each setup. I'll guide you how.

 

  1. Go to Lists and select Item List.
  2. Right-click on the item name and choose Edit Item.
  3. Select the appropriate COGS account from the COGS Account drop-down. Refer to these screenshots.
    • For the Inventory Part item type:
       Capture.JPG
    • For the Inventory Assembly (bundle) item type:
       Capture.JPG
  4. Click OK.


Let me also add these articles to learn more about managing your items and cost of good sold in QuickBooks Desktop:

I'm always here if you have other questions. Have a wonderful day!

View solution in original post

3 Comments 3
LieraMarie_A
QuickBooks Team

COGS account mapping

This is just the place to get the answers you're looking for, @jbutler-lifefuels!

 

Yes, you can map a separate COGS account for SKUs B, C, and D that you've set up as a single item and as a bundle. All you have to do is choose the appropriate COGS account for each setup. I'll guide you how.

 

  1. Go to Lists and select Item List.
  2. Right-click on the item name and choose Edit Item.
  3. Select the appropriate COGS account from the COGS Account drop-down. Refer to these screenshots.
    • For the Inventory Part item type:
       Capture.JPG
    • For the Inventory Assembly (bundle) item type:
       Capture.JPG
  4. Click OK.


Let me also add these articles to learn more about managing your items and cost of good sold in QuickBooks Desktop:

I'm always here if you have other questions. Have a wonderful day!

jbutler-lifefuels
Level 1

COGS account mapping

Thank you, this was very helpful.

 

jbutler-lifefuels
Level 1

COGS account mapping

Thank you, this was very helpful.

Need to get in touch?

Contact us