When you are finished with this video you will have a whole new (or any) understanding of how inventory works in QuickBooks!
3 hours on Managing and Tracking Your Inventory with QuickBooks
Learn how to use your inventory information to maximize your profits, return on investments, and return on assets!
Bonus section at the end gives you some powerful instruction on MS Excel on cleaning up and manipulating exported inventory data
Here is what you are going to learn
Find out the 3 main goals you must achieve when it comes to managing and tracking your inventory in QuickBooks.
Item setup: Best practices in planning and naming for styles, colors, and sizes and how to control the impact on the financial statements.
See behind the scenes – how an invoice transaction posts on the Balance Sheet and Profit and Loss.
Which reports I rely on when working with my clients and insights into how I analyze these reports to look for ways to increase profits and returns.
How to run the Inventory Valuation Summary and export it to Excel.
How to record a simple macro in MS Excel to help clean up the export quickly and prepare it for the 2012 Inventory Tracking template.
How to use the 2012 inventory tracking template to gather your physical inventory counts.
How to prepare your inventory tracking template for super fast inventory adjustment posting in QuickBooks.
Download the QuickBooks File from the screen cast so you can see exactly how this was set up in QuickBooks
This is the worksheet that you see demonstrated in my video on YouTube called
QuickBooks For Storage Warriors – Calculating Storage Unit Inventory Cost.
The download includes the Excel sheet as well as the QuickBooks (for PC) file created in QuickBooks 2012
THIS JUST IN!..
and get access to the entire sales commission course, the template, and the videos all for one fixed monthly price. This will also give you access to everything else I offer as I add things in! Visit Nerd’s School Of Business
My # 1 video on YouTube to this day was one in which I offer this template for free. You are still welcome to
e-mail me for a free copy of this template and I will still honor that by e-mailing it, however it does take me a while to get to these requests so if you want the template immediately then you can download it here for $10
Full 20 minutes (approximate) tutorial on how so set up your inventory parts to be used in the creation of the Inventory Assembly Items (finished product)
Step by step set up of the items in the item list
Step by step walk through of the Inventory Assembly Item Setup
Step by step walk through of the Build Inventory Assembly Item
The Excel file used in the screen cast
The QuickBooks File used in the screen cast (QuickBooks Pro or Premier 2011 for PC Compatible
Here’s the free version of this video:
Click “Add To Cart” right now!