Strategic Management articles: tips, advice, ideas, strategies & solutions

Subscribe to our Strategic Management Articles Feeds


Feeds

What's this?

Home > Strategic Management

21 Ways to Turn Your Excel Hell Budgeting into a Strategic Weapon

Tweet This
thumb it up gary Patterson
Regardless of your industry or the size of your company, these 21 points can help you strategically improve your business, take advantage of unexpected opportunities or buy time to solve operational or financial problems. Better yet, why not think strategically about the company budget process to plan for unexpected problems that could endanger the growth and survival of your business?

The steps below will show you how to escape Excel Hell and be on your way to a new kind of budget preparation that is heaven sent.

1. Determine the five to seven business driver metrics.
2. Use those metrics in a flash report logic that runs through the budget framework and philosophy.
3. Create a standard Excel input template to reduce Excel Hell.
4. Standardize charts of accounts and reporting formats.
5. Emphasize that budgets are done on a monthly basis, not as a total divided by 12.
6. Meet with departmental heads to help them see the budget as a tool, not as a weapon.
7. Build from the bottom up by department so departmental ownership is created.
8. Present results in a manner understandable to line management and department managers.
9. Involve department heads so they own the process and results.
10. Minimize the use of allocations where possible to increase user confidence in numbers.
11. Move toward some version of flexible quarterly budgeting process.
12. Use software packages that show underlying details so users can research and understand variances form budgets.
13. Use both realistic budget targets and stretch budgets to manage and incorporate with your incentive plans.
14. Integrate with some version of Balanced Scorecard.
15. Provide historical 12 month income statements for users to review for the budget process and then incorporate them in their ongoing review of budget comparisons to identify trends early on.
16. Hold people accountable for their budgets.
17. Create a transition path to move to budgetary software modules which are now becoming much more reasonable in price.
18. Create key inputs on the Executive Dashboard so you can refine what if scenarios.
19. Create at least one scenario that is far in excess of believability on both the upside and downside.
20. Watch out if your board does not understand the business risks the company is taking as identified in the budget.
21. Use the budget to support soft (read: non financial) goals.

Bonus Tip: Pull this list out every six months to see how you can better manage company operations and resultant cash flow. Feel free to add notes or comments and change any words to make it your own. After all, you gain when you internalize information. And in this case, you stand to reap some tangible benefits. Cash.

Put strategy and team work back into your budgeting process. Apply this information to improve your profitability, reengineer business models, and strengthen or gain competitive advantage in the marketplace.
About the Author:
Bottom line? Stop Profit Leaks Now. Apply this information to improve your profitability, reengineer business models, and strengthen or gain competitive advantage in the marketplace. And apply the free Fiscal Test at http://fiscaldoctor.com/fiscaltest.html. From Gary W Patterson Copyright 2008
 

 

No. of Times this article has been viewed : 791
Date Published : Apr 9 2009

Most Recently Published Strategic Management Articles as of

Nov 20 2009    Business Strategy - Conquering a Culture of Indecision

by BMA Editorial Team

The job of the CEO, everyone knows, is to make decisions. And most of them do - countless times in the course of their tenures. But if those decisions are to have an impact, the organization must also, as a whole, decide to carry them out. Companies that don't, suffer from a culture of indecision.

Nov 20 2009    Business Strategy - Decisions Without Blinders

by BMA Editorial Team

This article examines the phenomenon of bounded awareness - when cognitive blinders prevent a person from seeing, seeking, using, or sharing highly relevant, easily accessible, and readily perceivable information during the decision-making process.

Nov 18 2009    Customer Focus Strategy

by Kevin Dwyer

For more than twenty years the mantra in private enterprise and public enterprise has been "customer focus". The phrase appears on mission statements, vision statement and "our values" statements adorning private and public enterprise walls alike.

Nov 18 2009    Positioning For Success: Who Are You and What Are You Trying To Do?

by Ed Newman

Many managers are looking for an easy fix, a silver bullet that will solve all their marketing problems. Usually what we need to do is the hard work of taking the tried and true, thinking it through and applying it to our own specific circumstances.

Nov 18 2009    Implementing Strategy: A Balancing Act

by Kevin Dwyer

Strategies often fail in organisations because they are not successfully converted into actions that employees can understand and employ in their everyday work. The measures used to determine whether a strategy is working or not are usually far remov

Nov 18 2009    Strategic Planning; A Must for all Organisations

by Kevin Dwyer

Strategic planning, the what and the why of planning, is often overlooked by organisations who concentrate on tactical planning, the how of planning. The resultant business plan is overwhelmed by tactical initiatives and pet projects.

Nov 18 2009    Communication Strategy During A Time Of Strategic Planning

by Lee Hopkins

Planning your internal communication is an essential prerequisite to effective and committed implementation of any business strategy. It also goes a long way towards problem minimisation.

Nov 18 2009    How to Recognize Your "True" Sales Performance Competencies

by Jeff Hardesty

A self-professed “poor” golfer with a chronic slice might attempt to correct the problem by adjusting his stance - actually aiming away from the fairway so that the slice hopefully lands the ball in the middle.

Nov 16 2009    Business Strategy - How Clear Decision Roles Enhance Organizational Performance

by BMA Editorial Team

Your organization can become more decisive - and can implement strategy more quickly - if you know where the bottlenecks are and who's empowered to break through them.

Nov 14 2009    Great CEOs Knife the Competion with Killer Strategy

by Joseph Plazo, Ph.D

Have you just been promoted CEO/Director or General Manager? Congratulations and welcome to the world of strategizing! Now you can doze early, wake late, play golf, cancel meetings and go to Bahamas. On company time!

Nov 14 2009    How Not to Plan your Company's Future

by Jeff Mowatt

Describes five of the most common methods used to gather customer opinions along with their drawbacks. Reveals how to avoid these pitfalls when planning your business strategy.

Nov 14 2009    Management Lessons from a Car Wash Guy

by Jeff Mowatt

If you're serious about strengthening customer loyalty, consider this management lesson I learned from an odd source - a car wash attendant. It's an easy customer service concept that may change the course of your business.

Nov 14 2009    Yes, I Mind Waiting - 10 ways to Reduce Lineup Stress for Staff and Customers

by Jeff Mowatt

Reveals ways to manage lineups without making the staff work at full speed.

Nov 14 2009    Are your People Problems Really the Issue? Take this Mini-Quiz

by Jeff Mowatt

Most problems involving attitudes and teamwork are actually just symptoms of flawed infrastructures. Let's see if this could be true in your organization.

Jul 28 2009    Execute Rhythm in Six Steps with an Easy-to-Implement Strategic Planning Process

by James Murphy

In just six steps, you can take your organization from having a loose project timeline to a performance driven framework known as Flawless Execution. Without a disciplined, strategic planning process, tasks are liable to go unfinished and teams are apt to get off track.

12345678910...
Search for ebooks on Management & Business