QuickBooks and MS Excel - Analyzing your product lines which product is making you the most money

www.theqbw.com for more QuickBooks Help http for more Excel Help View The Web Cast | nerdenterprises.acrobat.com A few months back on April 15, 2009 we recorded a web cast on how to track, manage, and update your inventory in QuickBooks using a template I created in Microsoft Excel. Once your inventory is updated and adjusted properly such that you have accurate balances in your inventory accounts and as long as you know you have updated your books to reflect all purchases and sales to date then it is time to analyze your inventory to see which products are generating the most profit. If something is selling well and your gross profit % is low then you are not getting the most out of your product. You may also find that you have a product with a high profit margin that isnt selling as well as it could. This is all valuable information that can and should be used to manage your business well and make it as profitable as possible while also maintaining balance with customer satisfaction. In other words making s

quickbooks Inventory, inventory analysis, product analysis, gross profit analysis, profit margin analysis

Video Category: Howto