Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We don't use QB to track our inventory/sales, we use a completely different software system for that. We still need a place to enter inventory totals in QB though as it affects bookkeeping reports.
When we pay for inventory/products that we will be selling, that expense goes under COGS when reconciling our bank account in QB. However, I don't see anywhere to actually LOG or enter in our inventory at the beginning/end of the year?
So my question is, how/where do I enter in year end/beginning inventory in QB online ESSENTIALS.
If there is nowhere to do this without QB plus, then what is the solution?
The problem becomes that reports become inaccurate, because we'll have, for example, $1,000 expense of COGS for the year, off of supposedly zero inventory. Will this raise an IRS flag? I do enter the inventory amount into turbo tax, but it seems odd that there is nowhere in QB to enter it?
Thank you for checking in with us, Wisdom Ways.
Let me provide you with some insights about tracking inventory in QuickBooks Online Essentials.
QuickBooks Online Essentials is best for small businesses that not only need to track income and expenses and manage accounts receivable, but that also need to track the money owed to suppliers (accounts payable).
Tracking inventory is not included with Quickbooks Online Essentials, however, it is offered in Quickbooks Online Plus. QBO Plus makes tracking the purchase and sale of the product a piece of cake.
You may find this article helpful: How to set up Inventory tracking.
If you need additional help, feel free to reach out to our QuickBooks Online Support. Our contact details can be found here along with our opening hours.
Let me know if any questions may arise while working in QuickBooks Online.
@Wisdom Ways wrote:
We don't use QB to track our inventory/sales, we use a completely different software system for that. We still need a place to enter inventory totals in QB though as it affects bookkeeping reports.
When we pay for inventory/products that we will be selling, that expense goes under COGS when reconciling our bank account in QB. However, I don't see anywhere to actually LOG or enter in our inventory at the beginning/end of the year?
So my question is, how/where do I enter in year end/beginning inventory
create a Journal Entry dated 12/31: debit Inventory asset, credit COGS. Next year post the change.
Awesome! So, just to be sure that I understand you correctly, (I really have no accounting/bookkeeping knowledge of the whole credit/debit journal entry thing) I'm going to give an generic example and see if I've got it right.
Let's say at the end of 12/31/18 that we have $1,000 in inventory value (i.e. what we PAID for our existing product inventory that we haven't sold yet). I would make a journal entry of 1k as a debit for inventory asset and in the SAME journal entry, in the credit field under COGS, I'd also put 1k? Honestly, I really have no idea what purpose this serves, but then that's pretty much the name of the game for me with bookkeeping. :-/
If I'm correct about my example above, I have one more question: If I'm adding lost/stolen/expired inventory into QB, (let's pretend someone stole $500 of product in 2018), how would I do that journal entry?
Was this the correct answer?
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