Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI 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.
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:
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!
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.
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!
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.
Hope it helps.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here