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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up