by sandi smith
here’s a great spreadsheet exercise you can do to identify what i call “low-hanging fruit,” which means added revenue that will not take too much time or money to go after.
more: why your social media is a flop | the biggest seo secret of all: google business listings | beyond bookkeeping: five value-add service areas | beyond quickbooks: wowing your clients | five ways to get better clients
exclusively for pro members. log in here or 2022世界杯足球排名 today.
open excel, and start a worksheet from the sales numbers in your accounting system.
- in the rows of the spreadsheet, list the name of each currently active client you have.
- across the top, make columns for each service you offer. for example, if you offer tax, bookkeeping, and quickbooks consulting, you will have three columns.
step two is the fun part.
goose egg = golden
where do you have zeroes in the cells? for example, if client clark had money on his row in the bookkeeping column and the quickbooks column but not the payroll column, then you’ll want to color that empty cell or highlight it somehow.
for each empty highlighted cell in your spreadsheet, ask yourself why it’s empty. why are you not doing clark’s payroll? is there a revenue opportunity there?
make a list of all the possible opportunities you have, and sort them in order of most likely or most profitable.
increasing your revenue per client
approach each client and let them know you offer the missing service. they may not even know! (this happens far too often.) you might be surprised at how receptive they will be. after all, they already trust you, and you can reduce their complexity of working with multiple vendors by doing more for them.
doing marketing via spreadsheets is not only easy and fun, but it can be profitable too. i hope you have a good list of easy cross-sell opportunities to pursue.