Keep tabs on your most important customers!

Many small businesses rely on sales from just a handful of customers and in some cases rely on sales from just one or two customers. 

Having a high customer concentration puts your business at risk. If you lose your top customer, your business is at risk.  

CashFlowTool can help you to avoid this scenario and see the impact of losing your top customer.  In this article, I am going to show you a few ways to use CashFlowTool to keep track of your most important customers and understand the impact of losing them as a customer.

First, we are going to create a dashboard to highlight a few customer metrics. 

  1. Log into CashFlowTool.com
  2. Select your business
  3. Select the Dashboard tab
  4. Create a new Dashboard called Top Customers
  5. Add the following three cards
    • Largest payments received by customer
    • Largest sales by customer
    • New customers found

New Top Customer Dashboard

 

Your new Top Customer dashboard will now show you.

  • Top customer payments received
  • Top sales by customer from the last closed month and the previous month
  • Number of new customers discovered since the last you linked

Customer Dashboard

 

Now at a glance you can keep track of your top customers from a single dashboard. 

CashFlowTool makes it easy to see the impact of either gaining or losing a major customer. 

Now let’s look at what would happen if you lost one of your top customers.

Switch to the Cash Flow Calendar view (look at the last day of the month and look at your cash balance).  Here you will see your forecasted cash on hand for the next 90 days.

Forecast before turning off customer

  1. Select Customers from the top menu options
  2. In the search box, type the name of your top customer. The list of customers will be filtered based on your search.
  3. Uncheck the checkbox next to the customer’s name (click Save)

turn off customer

 

Now switch back to the calendar view and look at the last day of the month again and you will immediately see the impact of not including this customer into your forecast.   Switch back to the customers lists and uncheck a few more customers to see the full impact.

Forecast after turning off customer

 

 

You can also easily model the impact of earning a new customer too.  From the Customers view, select the Add cash in button.

Cash in

Enter the name of the customer, amount and recurrence pattern.  For example, the first Monday of every month.

cash in customer

 Switch back to your calendar to see the impact of adding your new customer. 

 

CashFlowTool makes it easy to see the impact of gaining or losing major customers and who your business is dependent on.  You can also share this newly created dashboard and updated calendar with your team members so they are aware of this impact as well.   Watch our getting started video on how to add team members and set permissions.

 

Share this post

About CashFlowTool.com

CashFlowTool is a product developed by Finagraph. We're a technology company that's passionate about helping small business owners, accountants, and lenders deeply understand the financial health of companies. Finagraph’s trusted technology helps power services provided by companies including Moody’s Analytics, Jack Henry & Associates and leading banks. Learn more


(206) 922-4502

15500 SE 30th Pl #101, Bellevue, WA 98007

© 2019 Finagraph All Rights Reserved.