Increase Sales With QuickBooks & Excel #1

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?

Many small businesses under-invest in this golden opportunity, preferring instead to focus almost exclusively on acquiring new customers.

Yet repeat business is very profitable because it costs less to generate a sale from an existing customer, and theres less risk of dissatisfaction, delivery problems, and non-payment.

In this video, I show you how to pull a QuickBooks report that can help you cultivate repeat business from your existing customer base.

Youll learn how to:

• Create a user-friendly Sales by Customer Summary Report

• Choose the appropriate time interval for analysis (year, quarter, month)

• Look for 3 repeat business opportunities: drift, gaps, and new customers

• Use Excel to make your repeat business analysis easier

• Be on the alert for opportunities to offer customers existing, repackaged, or new products & services.

This is a low-tech way (no additional CRM software needed) to engage more deeply with your customers along a path to higher profits.

Bookkeepers: youll learn a way to offer more valuable services to your employers/clients.

Business owners: you can use this technique to increase sales, and to improve the quality of the reporting and analysis you get from your bookkeeper/controller.

We assume a basic knowledge of sales, QuickBooks 2009 Accountants Edition, and Microsoft Excel 2009.

----------------------------------------------------
Copyright 2010 David Stern CFO. All rights reserved.

Category:

Education

Tags:

• small
• business
• financial
• quickbooks
• excel
• cash
• flow
• profitability
• rent-a-CFO
• consultant

[GreatAmericanMoneyTV]

This is a reeeeally cool video. Why can't I find you on Excelville? With skills like that, you should be getting paid!