Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
mtruffa1
Level 1

Simple accounting for ecommerce with over 2000 sku's

I currently run a ecommerce business in which I sell on various marketplaces. I have over 2000 sku at any one time. I buy from liquidation companies and resell the items. I have software that tracks my inventory over the marketplaces so I do not need to trace inventory for individual items in QBO. I import my sales from the market places and the payments. What is the best way to set up items, cogs and inventory to make it simple. All I need to do is have figures at the end of the year for taxes but don't have the time to add the 1000's of sku's from every invoice from my vendors or track each product. 

 

Any help would be great.

4 Comments 4
Catherine_B
QuickBooks Team

Simple accounting for ecommerce with over 2000 sku's

We can create a general item for each detailed product, mtruffa1. 

 

We'll not enter an item per SKU but we can enter them as a general item. For example, if you sell and purchase different kinds of t-shirt with the size and color, we can set it up in QBO as a t-shirt alone. Then, map the item to the correct expense (COGS) and income account. 

 

Let me show you how:

  1. Go to the Sales menu and select Product and Services
  2. At the upper-right, click New
  3. Select Inventory
  4. Enter a general item Name
  5. Select the correct Income account and Expense account.
  6. Enter the rest of the item details.
  7. Click Save and close

You can now enter sales and expense transactions after. They'll directly flow to the accounts of these items. Here are few article that will give more information about inventory in QuickBooks:

Set up and track your inventory

Impacts of inventory tracking on balance sheet and profit & loss reports

 

Let me know if you need anything else. I'll be here to help!

mtruffa1
Level 1

Simple accounting for ecommerce with over 2000 sku's

Thank you for the help. I mainly sell cosmetics and clothing. So I can set those up. Another question I have is how is COGS determined then when I purchase items at different costs. IE I might buy some cosmetics for .75 ea and some at .50 ea. If I do not put a cost for the item in inventory will it mess things up.

Adrian_A
Moderator

Simple accounting for ecommerce with over 2000 sku's

The Cost of Good Sold (COGS) is determined using the FIFO (First In First Out) concept, mtruffa1.

 

If you enter .75 ea as the first unit purchased, all items under that cost have to be sold before the COGS will adjust to .50 ea.

 

Also, not entering a cost for your inventory will result in an incorrect value in the inventory asset account.

 

You can browse this article to know how FIFO works: What is FIFO and how is it used for inventory cost accounting?.

 

I'm just around if you still need help!

Fiat Lux - ASIA
Level 15

Simple accounting for ecommerce with over 2000 sku's

@mtruffa1 

It seems your inventory management app does not support QBO yet. You may migrate the data by an importer tool into QBO.

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Then to complement your QBO, explore this AST Reporting & Filling app to integrate with your marketplace account.

https://taxjar.grsm.io/mytax

 

Hope it helps.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us