I'm glad to help track the inventory for your restaurant, accounting-manda.
Before we start, you need to know that setting up the first inventory item will automatically create the Inventory Asset (Other Current Asset) and Cost of Goods Sold accounts. Feel free to read through this page for more insights: Understand inventory assets and cost of goods sold tracking.
Also, QuickBooks uses the First In, First Out (FIFO) concept whenever sales of inventory items are entered. You can refer to this link for more details: How to calculate and record Cost of goods sold.
To start tracking your items, you need to turn on the inventory tracking feature. Let me show you how:
Check out this article for instructions and detailed steps: Set up and track your inventory in QuickBooks Online.
Stay in touch with me if you have follow-up questions about recording your inventory in QuickBooks. I'll be around to help you.
QB inventory does not do it that way, in QB each item is an inventory item, with qty on hand and cost, then as you sell the item it reduces the total of inventory and the cost of what was sold is posted to COGS - this is called perpetual inventory.
What you are asking about is periodic inventory.
Do not use the special account called inventory asset
create an asset account called Purchases or On-hand (you may want one per area, food, wine, etc)
Post all purchases to that account
Each month, take the amount that is reported to you, subtract it from the account balance and do a journal entry
debit COGS, credit the asset account
do that for each area, food wine etc
Hi @accounting-manda did you solve your issue with tracking inventory for the restaurant? I also want to start tracking inventory for the restaurant. Any insights would be much appreciated. Thank you
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