Increase Sales With QuickBooks & Excel #2

> > > Best resolution: preview ACTUAL SIZE or click 100% after starting video < < < When clients tell me they want to increase sales, the first thing I ask them is, “What are you doing to cultivate repeat business from your existing customers?” Why do I ask this? Because compared to acquiring new customers, selling to your existing customers tends to be easier, more profitable, and less risky. How good a job does your company do at engaging with customers to encourage repeat business? It’s easy to find out. In this video you'll learn how to analyze in Excel the QuickBooks Sales by Customer Summary report to identify three important customer metrics: 1. Customer count 2. Retention rate 3. Drop rate. It's a great way to step back from the day-to-day fray and get quantitative evidence about your customer relationships, including customer loyalty. The numbers in your QuickBooks, exported to and crunched in Excel like this, will tell you a story. And that story is a path to higher profits. * Grow your customer count * Retain your good customers * Lower your drop rate. Bookkeepers: learn a valuable service you can offer to the business owner(s) you work for. Business owners: use this technique to increase sales, deepen customer relationships, and get more out of your finance department. This video extends what we cover in our other sales-building video, "Generate repeat business from QuickBooks", so we assume you understand the concepts there. We also assume a basic level knowledge of sales, QuickBooks 2009 Accountants’ Edition and Microsoft Excel 2009. ---------------------------------------------------- Copyright 2009 David Stern CFO. All rights reserved.

Channel: iTunes Video Length: 0s Date Found: Thu, Jan 07 2010 2:51 AM Category: Educational Date Produced: Thu, Dec 17 2009 8:07 PM View Count: 0