Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI recently switched from QBW desktop to QBO.
First of all, the transition has been a nightmare.
We have for the past 15 years used the Assembly of creating finished goods which are sold as a single item so that each time a product is sold each part of the finished good is subtracted from inventory. ex: A cleanser has a fill, a bottle, a pump, etc.
Now, with QBO is seems as though the assembly finished good does not hit the COGS with the cost of the parts. Am I doing something wrong or is QBO not capable of hitting all of the parts to COGS account?
All assembly parts BTW live in a program called SOS Inventory.
Hi DEVITA,
Normally, the Assembly items will turn into Bundle items in QuickBooks Online. This type of item doesn't have COGS since this is just similar to Group items in QuickBooks Desktop. However, the COGS account will remain in the inventory items, so they are still reported to COGS when you record sales for them.
The SOS Inventory you mean, I think that's the Inventory asset account assigned to your items. You can check that out by going to the Gear icon, choosing Products and Services, and hitting Edit on one of the inventory items in a bundle.
By the way, the Assembly is one of the limitations in QBO. You may want to check others here.
We're just right here if you need additional help, so please feel free to keep on posting questions.
Is the add expense account only available for higher tier memberships? I don't see it aval in the starter subscription
I don't see add expense account to a product. I only have add income account. Is this only available to higher tier subscriptions?
Yes, it is, Ethan.
The add expense account is visible when creating an inventory item in QuickBooks Online (QBO).
The inventory feature is only available in QBO Plus and Advanced. You'll want to check your account subscription and verify your QBO version. I'll show you how.
If you're using a lower version of QBO (Simple Start and Essentials), I recommend upgrading your plan to avail of the feature.
Once you've upgraded your QBO, you can use this link for reference in managing your inventories: Add inventory products in QuickBooks Online.
In case you're already using the Plus or Advanced plan, you'll want to ensure you've turned on the inventory tracking so you can add your inventory items.
Additionally, you can also import your products in QBO. This way, you can easily add them to your account. You can read through this article for the detailed steps: Import products and services into QuickBooks Online.
I'll be around if you need more help with your inventories and QBO account. Please don't hesitate to leave a response. I'm always here to back you up!
I just started my business and currently don’t have the funds right now for the $80 month subscription plan, great. I can only afford the simple start plan currently.
Do you have a work around for buying inventory (like calendars for example) and linking it to a sale?
Do I assign the expense to buy the calendars to an inventory asset, and every time I make a sale, make a journal entry to adjust the asset/cogs values? Just trying to figure out where QB pulls the non-inventory numbers from and can I assign the calendar purchase to that account? I hope that makes sense. I’m just trying to make this work to get my business off the ground.
Thanks for coming back to the Community, ethanhoh.
I appreciate your letting us know that you’re using the Simple Start version. The information shared will guide us on how to resolve your inventory concern.
We’ll have to manually track the items in QuickBooks Online (QBO). This way, you can monitor the value of your inventory assets.
Let’s add the Current assets and Cost of Goods Sold accounts and link them to the items. I’ll help make sure you can do this in just a few clicks.
To set up the Cost of Goods Sold:
If you purchase an inventory item, use checks, bills, or expenses. Then utilize the asset account created to record its value in the Account field. The process will move the money into the asset account. Thus, increasing the value of your inventory.
When you sell the calendar, create a journal to decrease the value of your inventory. This indicates that you have less and increases your Cost of Goods Sold.
Here’s an article that provides detailed information on the account to use for the Debit and Credit columns: Can I track inventory manually in QuickBooks Online? Then proceed directly to the When you sell inventory section.
To learn more of the features included in the Simple Start version, check the following link: QBO comparison. This reference contains a link to our online tutorials. These videos will visually guide you on how to perform each task in your account.
Keep me posted if you need further assistance with managing your inventory. I’ll get back to help and get this taken care of for you.
Thank you so much for the reply and clarification! That helps a lot. And to verify, the journal entry that decreases inventory and increases COGS is in addition to an invoice or sales receipt for the sale of that said item, correct?
Thank you for your prompt response, @ethanhoh. I'd like to share some points about the journal entry in QuickBooks Online.
You got it right! When you enter a journal entry, make sure the price isn't included since it's indicated on the invoice and sales receipts.
Here's how:
This journal entry lowers the value of your inventory (showing that you have less) while also raising your cost of goods sold.
Also, you can contact an accountant to pull up the exact accounts to use within your books.
Furthermore, if you'll make changes to your adjusted inventory you can check this article for you reference.
I want to make sure everything is working well. Drop your comments below for any more clarifications.
Everything you mentioned, worked great! Thanks for all of the help thus far. It is greatly appreciated! I have one final question that kind of ties all of the above together...
I would like to make an entry of a donation of inventory to a charity within QBO Simple Start. I was a photography vendor at an art market and donated 50% of the sales to the charity. They collected the sales and issued me a check for 50% of the total sales. Also worth noting, I have the products in an inventory asset account within QBO currently and have a transaction in my bank account linked in QBO for the income deposit for 50% of the sales.
How would I go about entering this to incorporate the 50% donation, income, inventory deduction and cogs also with the 50%? I hope that makes sense.
I hope that isn't too complicated.
Everything you mentioned, worked great! Thanks for all of the help thus far. It is greatly appreciated! I have one final question that kind of ties all of the above together...
I would like to make an entry of a donation of inventory to a charity within QBO Simple Start. I was a photography vendor at an art market and donated 50% of the sales to the charity. They collected the sales and eventually issued me a check for 50% of the total sales. Also worth noting, I have the products in an inventory asset account within QBO currently and have a transaction in my bank account linked in QBO for the income deposit for 50% of the sales.
How would I go about entering this to incorporate the 50% donation, income, inventory deduction and cogs also with the 50%? I hope that makes sense.
Does anyone have any insight on donation question? I have found 2 ways to record through QBO simple start but they differ slightly from one another. which is correct? Please help..
Option 1:
To record a product and services donation, you'll need to follow these steps in this order, which we'll walk you through below:
The following sections can help guide you through this process.
To begin to record a donation, you must create an invoice for the product or service so that you can record the income.
Don't skip this step or your balances will be off after you perform the other steps in the process.
To create an account to use to record charitable contributions:
Once you have created this account, the next step is to create a product/service item for donations.
To create a product/service item for charitable contributions:
Now that you have created an account and a product/service item, the next step is to issue a credit memo for the value of your donation
To issue a credit memo for the value of the products or services you're donating:
The credit memo reflects the amount of your donation. The next step is to verify that it has been applied to the invoice you created.
The final step in the process is to verify that the credit memo you created has been applied to the invoice you created for the donated items.
To verify that the credit memo has been properly applied:
Option 2:
To start with, we can create a sales receipt to track the inventory that you've donated. Then, create a journal entry to associate the donations that you've made to your Charitable Donations Expense account. Here's how:
You can use the first option as to how to record donations in QuickBooks Online, @ethanhoh.
Recording a cash donation is different from recording a donation of products or services that you normally sell. To donate cash, you can record it as a check or a bill and payment.
If it's the donation of products or services you usually sell, you can follow the first option. Otherwise, open this article for additional info: How to record donations or charitable contributions.
Additionally, check out this resource to help keep track of fund donations you receive via credit card, bank transfer, or as cash in QuickBooks Online.
Keep me posted if you have other questions about recording donations in QuickBooks. I'll be happy to lend a helping hand. Have a pleasant day!
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.