the seven-step plan for marketing by spreadsheet

using excel spreadsheets, with a bunch of numbers, adding in some deadlines, and creating a very organized process, is just how we accountants like things.

by sandi leyva
the complete guide to marketing for tax & accounting firms

it’s quite common for accounting firms – even the regionals – to have no marketing plan in place.

more: five things clients have taught me | beyond compliance: what more you can provide | the biggest seo secret of all: google business listings | five ways to get better clients | how clients get underserved and accountants get underpaid
goprocpa.comexclusively for pro members. log in here or 2022世界杯足球排名 today.

the marketing plan might very well be, “get as many referrals as we can.”

or it might be a number for each partner – which is not a marketing plan.

or it might be, “if it’s not busy season, i’ll go to my networking group.”

none of these are plans. they are individual marketing tasks and components.

the number of companies that do not have fully functioning marketing plans is certainly not surprising because marketing by cpas was illegal – and considered quite sleazy – in most u.s. states until about the 1970s. so we are a profession that has always been behind on our marketing skills.

now that most of us need to market, the relief is we can do it on our terms, using excel spreadsheets, with a bunch of numbers, adding in some deadlines, and creating a very organized process, just how we accountants like things.

so here are seven components of the kind of marketing plans i like to create. we start with an excel spreadsheet.

1. revenue history and forecast by service or industry or both

assuming you’ve been in business for at least a year, you can start from the momentum you’ve gained to date in your business. what repeat revenue can you count on in 2013, and which services will it come from?

the forecast is where you get to dream. what revenue number do you want to make, and which services will deliver? of course, the bigger the gap in last year’s vs. this year’s numbers, the more you will have to work (and the more you will have to do something different from the way you did it last year). but at least you are in control, and you are calling the shots.

2. pricing

do you need to make any pricing changes from last year? do you have new services that need to be priced?

3. positioning

how do you want to position yourself? alas, this is the part where we need to part from our spreadsheet and do some thinking about what type of clients we can best serve. we also need to answer how clients will be able to use our services. are we meeting their needs or do we need to reposition?

4. marketing channels

as long as you need more clients, lead generation will need to be part of your marketing plan. here we need to list the places where we can find qualified prospects who need the services we offer.

a few examples of marketing channels include social media, a newsletter, direct mail and referrals. luckily, we can go back to our spreadsheet to complete this.

5. marketing budget

how much do we need to spend to get the additional revenue we need? more number-crunching.

we can also take a peek at last year’s if we don’t want to start from scratch.

6. metrics

how will we measure our success at marketing? we’ll need to create a set of marketing metrics to help us measure our return on investment.

7. action items

from here, we can create a solid list of tasks we need to do to implement our plan.

i know this sounds simple, and you can make a plan that’s far more complicated (and a lot of consultants do). but in our industry, there’s really no reason to.

one response to “the seven-step plan for marketing by spreadsheet”

  1. joe lutz

    sandy

    love your marketing book, have read about 1/3 of it. the book has already changed me and our firm to attempt to improve our firm marketing by 500%!!

    thank you so much,

    joe