Full Sail Partners Blog (61)

From the treehouse, to the garage, to the conference room, and now to the web, we’ve been doing group collaboration all of our lives. We’ve done it so much that we rarely, if ever, think about the finer details that really make the difference between a pleasant journey and a treacherous adventure.  

Over the years, I’ve managed or participated in dozens hundreds of projects. I am great with communicating with people, a whiz at technology, and even pretty savvy with interpreting human behavior. Doing all three, while trying to get something done, is a challenge. I’ve learned a few things about group collaboration and the lessons are equally applicable across tools and platforms. 

Be Captain Obvious.

Be careful not to assume that everyone knows why they are assembled and what the objective is. Often, team members find themselves gathered without a complete understanding of the purpose, goal, or constraints. Too often, leaders assume that all group members have (or remember) all the details they need. The first activity using your tool of choice is to lay the groundwork. Create an accessible communication that defines:  

• The final objective and it’s priority relative to other objectives in the organization
• The team members and their roles, including the leader
• The stakeholders
• The due date

Revisit the communication frequently and highlight changes to the originally stated information. 

Even anarchists use sign-up sheets for potlucks.

No group can function devoid of guidelines on structure and communication. Guiding the team’s administrative characteristics does not quash the creative spirit. Providing structure saves time and minimizes confusion, thus encouraging the collaboration. If you don’t want to appear as dictatorial, address the appropriate considerations during the first meeting and let the masses decide. 

• Define acceptable means of communication
• Explain how documents and collateral are to be managed
• Detail how activities outside of the group collaboration tool will be memorialized inside of the tool
• Choose a process for moving seemingly off-topic elements to the appropriate venue 

When members lose their way, communicate the guidelines again. AND be willing to change previously defined processes that don’t work. 

Hammers are used to hit nails, not fingers.

“It’s really uncomfortable telling people what to do. Peer pressure goes a really long way. Can’t the software produce a list for everyone to see?” 

Really?!  Seriously?! 

Frequently, we use tools to get us out of doing the things we don’t want to do. Group collaboration tools are meant to encourage the flow of ideas and communication. No collaboration tool creator has ever recommended that you use the tool to publicly shame non-performing members. Like alarm clocks, annoying reminders can be shut off (or even thrown across the room.). The alarm clock does nothing to get us out of bed, but the boss sure does. 

• Communicate tasks and due dates clearly
• Ensure that the responsible party understands the dependencies
• Follow-up on at-risk tasks appropriately (read: personal phone call) 

Let the tool serve in its capacity and you serve in yours.  

If it quacks like a duck, it’s probably a frog.

When the group collaboration tool is not yielding the success you expect, don’t blame the tool. When we find ourselves ready to throw up our hands and go back to another tool or no tool at all, it’s best to investigate for root causes and make adjustments.

• Audit the participation of team members.  Spend one-on-one time with those who are not engaged by reviewing the project while using the tool.
• Review how the tool has been laid out for use in the project. It is possible that features have been overlooked or are being used improperly.
• Solicit suggestions on improving the use of the group collaboration tool.  If someone speaks up, the ensuing discussion will uncover misunderstandings or create opportunities to collaborate on finding a solution.  Either way, collaboration has taken place and a connection made. Win-win.

None of us are new to working in groups. Each of us brings the baggage we’ve accumulated from previous collaborations to our newest venture. The best thing we can do is to zero the scales, define, communicate, and revise. Group collaboration only works if the group is spending its time collaborating and moving easily from task, to topic, to task. Take the guesswork out of how to function within the group and use the group collaboration platform to propel the group.

Almost everyone has heard Thomas Edison’s famous quotation about genius being “one percent inspiration and ninety-nine percent perspiration.” Far fewer people stop to wonder exactly what Edison was sweating about. 

The answer is, Edison was not only working on the various inventions for which he’s well-known, but also on the emerging discipline of R&D itself. Even as he and his team were cranking out one technological marvel after another, one of Edison’s ongoing areas of interest was in improving collaboration in the workplace. 

According to Sarah Miller Caldicott (who happens to be Edison’s great grandniece), the world’s most prolific inventor developed a methodical approach to nurturing teamwork and innovation among his workers. In her book on the subject, Midnight Lunch: The Four Phases of Team Collaboration Success From Thomas Edison’s Lab, she describes the little-known, behind-the-scenes processes that Edison pioneered to create and sustain high-performing teams. 

Caldicott does a great job of finding insights into Edison’s approach that have relevance for businesses today, so I highly recommend checking out her book. In case you don’t have time to read it yourself, I’ve synthesized some of Caldicott’s key observations with current best practices in collaboration. For starters, I’ve identified three major areas where organizations often make mistakes that prevent them from improving collaboration in the workplace. 

Mistake # 1: Keep doing business the old way.

It’s natural to keep using the same tools and processes that have worked for you in the past. However, your competition is probably hard at work trying to figure out a faster, cheaper way to put you out of business. So “sticking to what works” may put your organization in an increasingly vulnerable position. Fortunately, there’s a constantly expanding variety of tools that can help you maximize your ability to collaborate. 

One of Edison’s interesting approaches to fostering collaboration was the “midnight lunch.” These were regularly scheduled but informal get-togethers where his engineers got to know and trust one another better, increasing their ability to communicate and work as a team. In today’s business environment, technologies like Kona and Skype may make it easier for teams to exchange ideas, but many people who write about collaboration still point to the effectiveness of starting with face-to-face meetings and then evolving to virtual collaboration as time progresses. 

In Edison’s day, the products of collaboration were obviously analog — although many of their ideas existed only in their heads, a great deal existed on paper as well. If a team member left, much of their work and insights could literally be passed out among team members. In today’s world, we are meeting the need by creating central repositories of files and communication — so if a team member leaves, all their intellectual property doesn’t leave with them. 

Mistake # 2: Assemble the wrong type of team.

The ideal size team for collaboration depends on a variety of factors — including the complexity of the work, the products the group is expected to generate (and the timeframe for doing so), and how often, if ever, the team needs to convene in person. 

For what it’s worth, Edison preferred smaller, more cohesive teams of between two and eight members, according to Caldicott. In addition to hosting the “midnight lunches” mentioned above, Edison also tried to ensure a mix of disciplines and areas of expertise on each of his teams; Edison’s light bulb team, for example, included chemists, mathematicians, and glassblowers. To put it another way, Edison and his colleagues were focusing on diversity decades before the term was ever used in a business management context! 

Mistake # 3: Take your eye off the ball.

One other lesson to be learned from Edison is to take the long view on collaboration. Real impact is not a short-term gain or achievement, but rather an investment of energy and resources that will eventually bear fruit. 

Taking this perspective, it’s easier to realize that mistakes can be just as instructive as successes. When Edison was only 22, he had his first flop:  An electronic vote recorder that legislators declined to adopt. Following that experience, Edison changed his focus to the consumer instead, and never regretted the decision. 

Another lesson Edison teaches us is to keep an eye on the market, and be ready to make adjustments as necessary. For example, he and his team ushered in the era of electricity, and then continued to invent new applications that used the increasingly available power source; other inventors ignored electricity at their peril. (For a more recent example of how not to do things, look no further than Kodak, which failed to adapt to market changes and is playing catch-up with hundreds of more innovative, nimbler companies.) 

Has the light bulb over your head turned on yet?

Most companies would consider themselves to be phenomenally successful to have even one innovation on the level of the light bulb, the motion picture, the phonograph, or any of the hundreds of other inventions and patents credited to the Wizard of Menlo Park. But by making the most of the collaborative tools and strategies for improving collaboration in the workplace mentioned above, your company can at least maximize the chance that your teams will do their very best work. 

It is a new year; everyone is feeling pumped and ready to tackle their goals! As a professional services manager nothing makes you more excited than seeing your team excited. Enthusiasm is not something we can reproduce, nor is it something we can bottle up. What we can do however is help sustain this enthusiasm and better help our staff in continuing working together as a team in 2014! 

So what exactly can we do to help sustain this new found enthusiasm? Ultimately it boils down to transitioning your staff from ‘coworkers’ to ‘teammates’. I like to refer back to the common TEAM acronym, Together Everyone Accomplishes More. By breaking down each part of the acronym, we can brainstorm on ways to improve your staff cohesion, and get them working together as a team in no time! 

Together:  One of the most important things you can do to get your staff working together as a team is to get everyone working on the same system. Often, individual departments are working on their own specialty software, which in the grand scheme of things keeps everyone stuck in their own box. This lack of overall perspective does not bode well for fostering a team atmosphere. 

However, some firms are in situations where it is not feasible to migrate the entire firm in to a singular system. In this case, I would recommend looking at other ways to collaborate and share data, such as setting up a Kona space or DropBox folder for projects. For more information regarding collaboration tools, read our recent blog on the 5 best collaboration tools. 

For professional services firms that are in a situation to leverage a fully integrated system, I encourage you to check out Deltek Vision, the leading ERP software providing professional services firms with a fully integrated system. We have countless resources explaining the benefits of Deltek Vision on our website – if your professional services firm is not currently leveraging the power of Vision, we encourage you to spend a few minutes learning more. 

Everyone:  In order to be successful as an organization, and as a team, you will need to have buy-in on everyone’s part. Your firm can invest in the world’s best software, and top of the line infrastructure, and none of it will mean anything if your staff does not buy-in. Every effort you lead should have a champion. Think of this person as a team captain for the project. This person will act as a resource, and will help keep assigned efforts on task. Without a champion, your effort is sure to lack overall direction and decrease in effectiveness. 

Accomplishes:  We have all heard the saying ‘keep your eye on the prize.’ So ask yourself, are you giving your team the ability to keep their eye on the prize? An important aspect of being a member of a team, is the ability to know that you are doing your part. To accomplish this, team members need goals, and they need ways of tracking these goals. By developing a set of core growth strategies and metrics your firm will be able to position itself to consistently surpass your competition. Additionally, you cannot understate the value of the sense of accomplishment your team gains from attaining small ‘wins’ along the way to the main goal. 

More:  To keep your staff enthusiastic, you need to be willing to challenge them. By expecting a level of professional growth out of each team member, you create an environment of development. Human beings by nature want to be challenged and engaged. 

We have all heard the saying ‘there is no me’ in team. This saying could not be any more true in the business place. While at times it may feel easier to do things in a vacuum, often times this is not the best strategy for the overall company.  You will often find that this team environment will foster new creative ideas, an increased industry perspective, and most importantly a continuing enthusiasm that can quickly spread to the rest of your staff. 

Pave the way to future growth and higher profitability by encouraging your co-workers to work together as a team. To encourage this behavior, consider how your firm can leverage integrating critical business processes. You will find that by doing so your firm can increase productivity, help control costs, and enable firm success. 

Hopefully by following the above advice your firm will operate more efficiently as a TEAM, and continue that new found enthusiasm. Respond in the comments section and let us know how your firm as transitioned from ‘coworkers’ to ‘teammates’ – we would love to hear your story!

Not all business buzzwords are created equal. For example, “collaboration” is red-hot among buzzwords today — but unlike other momentarily popular topics, the concept has been around a long time, but is now being addressed via technology designed to leverage the Internet. Collaboration apps and platforms typically take advantage of the Internet to enable the sharing of documents, ideas, calendars and more with colleagues. In fact, the more one embraces collaboration, the more implications one can find for teamwork, innovation and growth.

Here’s a quick look at the 5 best collaboration tools available today.

Kona

Kona is a cloud-based social collaboration/productivity platform for individuals and groups that enables file sharing, task/event management, and comments and conversations via Skype and instant messaging. It also integrates easily with other collaboration platforms and products, including Dropbox, iCloud, Google Docs and even SharePoint (if that’s your collaborative bag). 

In addition, Kona includes templates to expedite repeatable projects and processes, and can function as a company’s Private Social Network and shared calendar. Even better, Kona’s mobile app compliments its desktop functionalities, letting users track work from anywhere. Take it for a test drive by checking out the free trial version.

join.me

JoinMe is an elegantly simple (at least, simple to the end user) solution that allows you to share screens with anyone anywhere over an Internet connection. JoinMe can accommodate up to 10 meeting participants, and allows the meeting initiator to choose which items to share with whom, and enables chatting with one participant at a time or all at once. Keep in mind that these features are all in the free version — a fact that helped it land on our list of the 5 best collaboration tools.

Doodle

Doodle is a handy meeting scheduling/tracking tool for Android device users. Designed to integrate seamlessly with Google Calendar, Doodle makes it easy to find the right date and time for a group of people to meet. You can use the basic service for free at doodle.com, without the need to register or install software. With easy-to-use polling capabilities and real-time commenting tools, it’s also available as a low cost app for Android devices.

Dropbox

Currently in use by over 200 million people, Dropbox is a cloud-based platform for file sharing and accessing. Users designate a special folder on their computer that Dropbox synchronizes with similar folders the user creates on their other computers and devices. Any files that the user places in the Dropbox folder also are accessible through a website and mobile phone applications. Available for Windows, Macintosh and Linux desktop operating systems, Dropbox also offers apps for iPhone, iPad, Android, and BlackBerry devices. Options range from a free version to DropBox for Business ($15/user/month).

Skype

Skype enables free video and voice calling to anyone else using Skype, as well as instant messaging and file sharing. Alternatively, a modestly-priced version of Skype includes low rates on calls to mobile devices and landlines worldwide, text messaging and group video calls for up to 10 people. Users can take part in Skype calls using a wide variety of devices, from desktop computers and mobile devices to home phones, certain TVs, and even devices you might not think of as collaboration tools, such as PlayStations Vitas and iPod Touches.

Join the collaborative world

As you can see from the 5 best collaboration tools mentioned above, the world of collaboration choices and tools is exploding. But before you jump in and start rubbing virtual elbows with colleagues on the other side of the world, keep in mind two bits of advice:

1. As attractive as their price tags may be, the free versions of all of these apps and platforms have limitations. For example, you may be limited in the number of participants you can accommodate and the amount of data you can share — and you may have to endure the occasional advertisement as well.
2. Remember that integration with your existing apps (especially your calendar) as well as other collaboration apps is critical. Some of these apps, such as Kona, play well with almost all of the apps mentioned above; others, not so much. The more seamless the integration between your various collaboration apps, the bigger the impact on productivity and ease of use.

Despite those caveats, each of these tools can truly transform aspects of the way you work with colleagues. The result could be better ideas, more effective teams, and possibly even a better quality of life. Just imagine how nice it would be to cut down the time you spend setting up, going to and from, and sitting in meetings — not to mention, take part in them from the comfort of your own home, cubicle, or coffee shop! 

As the New Year begins, most businesses, including ours, look for ways to drive even greater success than last year. If you are like most professional services firms, you evaluate project performance based largely on the efficiency with which the project is completed.  Unfortunately for most firms, they only look at half of the equation.

Evaluate Client Feedback for the Full Picture

Client feedback should focus on helping clients achieve the long-term success they desire by measuring all the metrics important to project performance. As the title suggests, this includes measuring both financial metrics and client metrics. Client metrics measure how well your process is meeting your client’s expectations at each stage of the project. If your team is not asking whether their client’s expectations are being met, they are making three dangerous assumptions:

1. An existing project delivery process will meet a new client's expectations (or a new project manager will meet an existing client’s expectation)
2. A client’s expectations of the project manager they have worked with before is not influenced by external factors
3. You and the client have the same understanding of project communication, deliverables, etc.

Benefits of Client Feedback

When your firm uses real-time, project-based feedback, you give your clients the opportunity to share their changing preferences and priorities with you throughout the project. You eliminate the assumptions that can result in poor project performance and unmet expectations. You strengthen your relationships with your clients as they realize that you really care about their goals. Ultimately, because the feedback you request is designed to benefit your client, you also give them the ability to help you help them achieve the success they desire.

Some of the benefits of improving your project performance and creating success for your firm include:

• Establishing a reputation as experts, elite players with a premium brand.
• Reducing or eliminating re-work and scope creep
• Becoming the ‘go-to’ firm
• Impacting the bottom line by providing a steady stream of profitable work

As 2014 gets underway, let’s challenge ourselves. Instead of measuring the same things you have in the past and expecting different results, take the strategic step of tracking the metrics that matter. Just like, Peter Drucker says, “what is measured improves”.  So the question to ask yourself is: Are you measuring the metrics needed to create the success you desire? Click below to learn more about measuring client metrics to create firm success. 

Are you ready? Year-end is upon us. We thought we would highlight some resources to assist firms with year-end processing.

Don't Forget Your Deltek Vision Year End Processes

As we come into the holiday season many of us in accounting face the coming season, not only with the joy of family and friends coming together, but with a sense of impending dread – YEAR-END and TAX SEASON are looming – ugh - have another drink.

W-2s - 1099s - journal entries - checking and double checking each number!  Auditors - shareholder meetings - endless explanations’ of what the results mean (even though you have been saying for the past 6 months) - Oh the joy of the season!

As we go through the year-end process there are mistakes we (and others) make that are easy to recover from like entering the 15 page depreciation journal entry “backwards” at midnight sitting in your semi dark office chugging your 15th pot of coffee.  Some are more difficult – like removing all the lower levels of your work break-down structure (did that once – glad our backups worked). So outside of deleting the database, what are some of the items in Vision year end processing that are hard to recover from?

>> Learn more

Is Your Deltek Vision System Year End Process Stress Free?

Year-end is always a stressful time of year, but it doesn’t have to be.  As with everything else in the world of Accounting, planning and preparation is the key to a successful and stress-free year end. Check out this article talk provides a few tips to make your year-end close just a little easier.

>> Prepare more

Webinar: Stress Free Year-End Process - Yes You Can!

Join our on-demand webinar to see how you can make your year-end stress free.  Our panel will provide insight into best practices, tips to close your books with ease, and focus on those “gotchas” on year-end processes. See what our panel says about the following year-end items:

1. How to make your process efficient
2. Avoid disruption to production
3. Communication topics to provide your staff and management
4. Saving money by evading closing obstacles

>> View more

Deltek’s Year End Resources

Deltek Customer Care is working to assist you with year-end activities. You can now take advantage of year-end resources:

• Year-End Forums

• Phone Menu Guidance

• Year-End Info Center

• Quick Chat Guidance

• Year-End Guides & Videos

>> Know more

When it comes to proving the value of marketing efforts, often professional services marketers have to prove their worth to the financial department through a language that they understand – Marketing Metrics! This often means a series of pre-determined metrics for measuring marketing ROI (return on investment). 

Marketers are often challenged with measuring marketing ROI. Many times it’s because we are don’t have access to the right type of data or in some cases it’s because we don’t know what to measure. This is where having a good relationship with finance can help you be a better marketer. To better develop the relationship and expectations between marketing and finance, we suggest fostering a relationship of understanding and sharing. 

Having the financial department on your side is one of the greatest feats any marketer can accomplish – If finance buys in, you can be assured that it is only a matter of time until everyone else falls in place! 

No matter how copasetic our relationship is with our financial department, we have to be ready to report on marketing ROI at a moment’s notice so here are some steps to take to gain a better relationship. 

Talking the Talk 

If you are looking at building a better relationship with accounting, in my experience the first bridge to cross is to put yourself in their shoes. When you think about what functions accounting is responsible for, you can easily understand their hesitancy to buy in to the marketing plan without cold hard data to evaluate. Instead of running from this hurdle, attack it straight on! Schedule a kick-off meeting with finance to address the plan, and allow them to voice any concerns. 

The goal during the kick-off session is to ease accounting’s anxiety.  Allow the finance department a chance to express their suggestions and concerns. Continue to reassure the finance team that through the marketing metrics established by your firm, you will be consistently measuring marketing ROI throughout the year to ensure that the marketing team’s plans and efforts stay on track.

Walking the Walk 

The quickest way to gain buy in is to lead by example. You know your job better than finance knows your job. Identify areas that your marketing efforts affect that might not be easily identified.  One way a Marketer can begin to do this on their own is to think about the data that you need to do their job better. Come to the kick off meeting ready to show your finance team that you understand their concerns, by identifying previously overlooked metrics for measuring marketing ROI. This will demonstrate to finance that you are looking at metrics that can help impact the growth of the company and further prove your value to the firm. 

If you are interested in learning more, review this blog article that discusses evaluating your business growth plan with metrics. This introduction can be applied to developing marketing metrics that help identify how your efforts are helping the firm grow. 

Here are important questions marketers can ask accounting to start the conversation on how the firm can start measuring marketing ROI:

1. Retaining & Gaining Clients: I’m looking to understand our total customer growth. Do we have a way to determine by percentage and revenue the amount of our work we’ve received is new vs. existing clients throughout the year?
2. Pursuing the Right Client: I’m been looking at how we can be more strategic in our pursuit of clients. Would it be beneficial to advise you when I see we are pursuing more work with clients that we are having AR issues with?
3. Forecasting and Backlog: Can you help me understand what our break-even is and do we have a way to see what our current backlog is? I’d like to help make sure we have enough business coming in the pipeline for each market or division.
4. Effectiveness: Can you help me better understand how I affect the bottom line? Developing metrics that help you understand the financials behind your results can help you fine tune your approach. 

Often times your finance team is not questioning the value of the marketing team -- they are however questioning the tactics (and results!) being used. Often times as marketers we can get lost down in the weeds and lose sight of the overall firm goals. By proving efforts through metrics and marketing ROI, we start speaking a language that our financial team can understand. 

As professional services marketers, start showing your finance team that you care by measuring marketing ROI, and building better relationships between marketing and finance to demonstrate the value of promotional efforts.

For more information, view the below webinar: 

We all love this this time of year when EVERYONE (in management at least) is coming at you to peer into the crystal ball to see what the upcoming year will bring -- everyone else is simply wondering if they will get a holiday bonus. With all of the tasks ahead for year-end, you may feel as though you will be lucky enough to make it to the New Year, let alone forecast what is going to happen!

Budget, budget, toil and fudge it (not as well-known as bubble, bubble, toil and trouble, but more appropriate). 

Most often you are expected to reach out to everyone in the firm to pull together a web of disparate “visions” for the various divisions of the firm, get buy in from everyone, set pay rates and bill rates, set annual goals for every person in the firm and publish your findings so that everyone can have proper “visibility”.  Just when you have it all together and about ready to go, someone transfers or quits or gets hired and everyone wants to you to “simply update the budget”. Fun times – just before the holidays. Unfortunately, if you are attempting to manage the undertaking of forecasting in Excel, you are causing yourself unneeded stress in an already stressful situation!

What are some of the hazards to be aware of when forecasting in Excel?

Multiple Spreadsheets – Typically when creating a budget in Excel you end up with multiple workbooks, at a minimum one for every department that will then roll up into a firm-wide budget.  And in each of these workbooks you can have multiple spreadsheets to total up the workbook (maybe a spreadsheet for each service type or for each employee).  As you move these workbooks, you run the risk of breaking links within each individual spreadsheet.

Changing Dynamics – When you create your budget workbooks, you usually create them to “map” the way the firm currently does business.  For example, at an AEC firm, the Survey Department staff only works for the survey department and the Water Recourses staff only works for the Water Resources department.  The issue is that the department heads might have hatched a plan to share resources to maximize efficiency. But if you have all your workbooks mapped out and they come back with their scheme you will need to “revamp” all your work.

Oops, I Forgot – When you created your workbooks you simply forgot a chart of account numbers or forgot that management wanted to add an employee in the corporate office.  Once you have everything mapped, if you have to add something, you run the risk of breaking links (bad) or creating incongruent links (worse).  An incongruent link would be adding a row in the Survey Department called “Survey Supplies” but forgetting to map to the row in the summarized data called “Interest Expense” because the Survey Supplies is only in the survey department and Interest expense is only in the corporate department.

It Doesn’t Add Up – So you have everything set-up and summarized and you have an acceptable profit.  However, when you pay closer attention, you realize that in January, the sum of your departments properly add up.  Somewhere, something is broken.

What can you do to avoid or mitigate these hazards?

Meet Early – Before you even get started down this long road of forecasting in excel, try to meet with the department heads to get an idea of changes they may have planned or discussed.  If you have suggestions for them to be more efficient (for example work share), get it out there for discussion and resolution before you get too far down the usual primrose path you find yourself following year after year.

Share Information – First figure out if there is truly a place where you can put your workbooks, create the links, and share with the appropriate staff.  This could simply be a shared drive in your network.  If you need to limit access for the workbooks (for example the San Francisco Engineering department head can only see the San Francisco workbook), this can be achieved via the “password protection” in Excel (found in File/Protect Workbook/Encrypt with Password).  Be sure to make a list of passwords for each workbook because if you lose them, you have completely lost your ability to use the workbook.

If you can’t create a shared drive, use your personal drive to save your workbooks until complete. Then you’ll want to only print final data. 

Having links break when you move your workbook is frustrating.  If you do have to move workbooks or update tab names, you can use the Update Links in Excel (Data/Edit Links/Update source) to get the correct mapping.

Be Consistent in Your Workbooks – Use the exact same chart of accounts and structure for each workbook – even if the information doesn’t apply to your department.  If you are consistent in your account listing and your workbook structure you do not have to worry about incongruent data.  If you realize you have to add an account number, make sure to add the account in the same row in every workbook and you can update your summary easily.  If you have utilization in your engineering department, have it in Corporate –even though it doesn’t apply – makes it easier to simply copy and paste formulas throughout the entire summary workbook.

Create Summary Rows/Columns – In your summary workbook, when you have subtotals in rows or your grand total column, use the column/row formulas to calculate these; DO NOT use the sum from the individual workbooks.  However, after your Total Column, add a column that adds the total columns from the individual workbooks to compare your results.  This will allow you to see if there is a mistake in any of the individual cells.  Also, at the bottom of your summary workbook, add a section that shows the profit from each department.  This should add to the total in your summary. If it doesn’t, then you may have to do some research into what is causing the issue.

We hope that the above tips help you avoid some of the most common hazards encountered when accounting and forecasting in Excel. With year-end approaching quickly, best of luck getting your accounting and forecasting in order, so that your firm can ‘excel’ in 2014!

If you are interested in taking your accounting and forecasting functions to the next level, check out Deltek Vision, the industry leading Enterprise Resource Planning (ERP) software for A/E and Professional Services Firms!

As a project manager you have more to do in any given day than you can possibly get done. Sound about right? And, as if you don’t have enough to do, you sit through team meetings, office meetings, and visits from the top leadership where they remind you how important it is to ensure your clients are your top priority while also achieving strong profits. Okay. Now for the big question – how do you balance both priorities?

Do you remember the EASY button? Well I think Staples© was really onto something with that. I can’t tell you how many times I’ve wished I had one of those to handle tasks that I knew were important but that I struggled to get completed. Have you ever wished you had one to measure how things were going with your clients? Wouldn’t it be great to have a one button solution when your supervisor asks you how things are going with your clients?

Well, now you do. The answer – send your clients project surveys!

Client Feedback Tool grew out of an architectural firm so I definitely get it! As strongly as I believe that getting feedback from your clients is essential to building strong and lasting relationships, I am well aware that time is the one thing project managers in the A&E industry have in limited supply!

So you may be wondering, he just acknowledged that project managers have no time for extra steps in the project management process and yet he is suggesting that we send project surveys to our clients? Fair enough. The truth is that it takes less than 2 minutes to send your clients a survey. And, the information you get will save you so much time!

Every time one of our clients sends a survey, their clients’ responses are logged onto a scatter plot like the one in this figure. One of several reporting options, the scatter plot analyzes how well client expectations are being met. It takes less than a minute to run and you can schedule it as a weekly or monthly recurring report. Our clients see a snapshot of what their clients are saying. Are you starting to see how this will give you the information you need?

Each of our surveys consists of about 6 – 8 questions asking how well client expectations in different categories are being met. The blue dots represent individual pieces of feedback from one of those surveys. With a 4.0 indicating that the client’s expectations are being met, this one chart can be your very own EASY button!

With one quick glance you can see that overall you and your team are meeting, or exceeding, your clients’ expectations. But there’s more.

When you click on any of the blue dots, you immediately see:

• What project that piece of feedback is associated with
• What question was being asked
• Who answered the question
• Any specific comments by the respondent

It’s important to note that using project surveys does not replace the ongoing conversations you have with your clients.  However, with a strong feedback process you can, in about 5 minutes a day, get the details you need and get back to managing your projects. If there are ever any challenging responses, a simple click on the blue dot gives you the information you need to begin finding a resolution before their concerns become problems.

In addition to seeing the results for the clients you manage overall, you will have the ability to see a scatter plot for each individual client as well. Now, with your very own EASY button, the next time you are asked ‘how are things going’, you will have the information at your fingertips!

Interested in learning more about using project surveys?

Business leaders have any number of sophisticated computer programs and models to help them predict future business results. Despite these resources, however, in its essence financial forecasting is still a guessing game. 

That being said, there are several fundamental strategies that can improve one’s chances of making accurate forecasts.

1. Understand how and where you’ve succeeded.

The first strategy is to look at historical data to gain insight into exactly where past successes and challenges have come from. This inquiry includes reviewing the various sources of your leads, how your sales team manages them, and where you tend to have the greatest success. For example, you might try to determine:

• Whether your sales most often result from calling into existing clients to find additional work, from cold calling to purchased lists, or alternate sources.
• The extent to which your success has depended on the person doing the calling, the script used for the call, the number of contacts made, or other factors.
• The lasting impact of sales — i.e., which sales turned into continuing relationships and additional work. Of course, there are many factors that affect this statistic, but it can still provide useful insight for your financial forecasting. 

The key is investing the time and energy needed to gain fact-based insights into what has worked — and not worked — in the past.

2. Take a cold, hard look around you.

A second essential strategy of financial forecasting is to look closely at your current operating environment, and conduct a brutally honest analysis of your strengths, weaknesses, threats and opportunities (SWOT). 

Your SWOT analysis should begin with a realistic exploration of the many factors that could increase, or decrease, the likelihood of your success. Some questions you might want to answer:

• What is your reputation in the marketplace — what are you known for doing well, and where should you try to improve?
• Is the local or regional economy growing, stagnant, or shrinking? More specifically, what is the condition of the economy as it affects your clients?
• Are there factors that could encourage your clients to maintain or even expand the services they are buying from you? Are there conditions that might threaten projects that they have planned with you but not yet started, or that could prevent them from engaging with you in the future?
• What is your competition doing to take advantage of the current market? Where are they weak, and how can you exploit that weakness? 

The underlying strategy in doing your SWOT analysis is to be totally honest and realistic about where you excel and where you come up short — and determine what you can realistically achieve in your competitive environment. 

3. Test your assumptions and adjust as necessary. 

A third essential strategy in effective financial forecasting is to track and monitor your results. There is a range of ways to do so, but based on our experience working with professional services firms, one of the best is to invest in a purpose-built ERP such as Deltek Vision. This solution can provide a firm with up-to-the minute, comprehensive visibility into all of the assumptions and results related to its financial forecasting. Just as importantly, it connects and organizes data from both the front office (i.e., project) function as well as the back office (accounting), and automates a wide variety of essentially manual processes — including Customer Relationship Management (CRM), business development and more. Not only will the insight you gain help you tweak your assumptions to improve future forecasting efforts, but more importantly, you can make midcourse corrections to keep your firm on course. 

Keep your eye on the prize.

Whether you use one-off spreadsheets, software programs for specific functions, or a comprehensive solution like Deltek Vision, the key is to collect metrics that matter to you on an ongoing basis, measure results against your financial forecast, and make adjustments as necessary. 

You’ll never be able to see a completely accurate view of your company’s future. However, through financial forecasting, you will gain enough of a realistic sense of what’s coming that you’ll be able to stick to a plan and outmaneuver the competition.