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

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 : 744
Date Published : Apr 9 2009

Most Recently Published Strategic Management Articles as of

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.

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

by gary Patterson

When Cash is King, it really is King. Do away with painful Excel based budgeting marathons and turn your budget into a strategic tool to improve the bottom line. The author presents a framework that uses the budget process to help companies manage risk while reaping the rewards...

Mar 2 2009    Does Your Nonprofit have a Grant Winning Strategy?

by Kirby Rooks

Here are five grant writing strategies that will give your nonprofit organization an edge in being awarded more grants during times of economic turmoil.

Feb 9 2009    How To Start Your Own Business Today?

by Ranju Kumar

In a world wherever you turn there are some expert's telling you how to do this,etc., you might find yourself in a daze on where to go or start.

Feb 5 2009    Regular Employee Training Ensures Results

by Chris Kennelly

As a trainer or business owner you may be well aware of the need for employee training, yet at times it feels or seems like the training efforts are misdirected or perhaps unappreciated by the attending employees.

Feb 3 2009    Why Strategic Facilities Management Should Be Integral To Any Business

by Dominic Donaldson

An article explaining how a business can improve its performance and save money by looking at the way it manages its buildings and physical assets.

Jan 29 2009    What's An Optimal Business Plan Layout?

by Uchenna Ani-Okoye

A business plan is a written definition of, and an operational plan for achieving your goal.

Jan 28 2009    Competing on Price in a Down Market

by Harlan Goerger

How to take your competition out of the picture and sell more at a higher margin.

Jan 28 2009    Discovering How to Innovate Strategies for Your Music Business

by Kavit Haria

You might as well have read or have heard a lot of various strategies that talk about you being able to succeed into whatever business venture that you would like to put your resources and devote your time with. Do you know that in designing or innovating certain strategies you have to focus on...

Jan 28 2009    Herd Mentality: Is Human Behaviour Accounted for in your Strategy?

by Jonathan Andrews

The way that many businesses and marketers strategize is perhaps counterintuitive. One important variable is frequently overlooked.

Jan 28 2009    How Human Behaviour Shapes Successful Business Strategies

by Jonathan Andrews

People are fundamentally sheep - isn't that what we're always told?

Jan 20 2009    Develop A Process For Continuing Business Model Innovation

by Donald Mitchell

It's tough to build a business if your innovations are one-hit wonders. What will you do for an encore? What process can help you?

Jan 20 2009    Business Model Innovator: Increase Value Without Raising Prices Or Costs

by Donald Mitchell

Many leaders look to add more value . . . so they can charge more. A more helpful approach to business model innovation is to raise value and keep prices and costs the same . . . or lower them. This article contains a case history.

Jan 9 2009    Achieving Success in 2009

by Steven Rosen

The start of a New Year is a time to reflect and make resolutions for the future. Of course, most “New Year's” resolutions are forgotten after only a few weeks. The day to day demands of business, emails, meetings and phone calls gets the best of us.

Jan 6 2009    How Mergers Could Be The Answer To The Recession Problem

by Dominic Donaldson

An article highlighting how companies are looking at potential mergers as a way to avoid going into administration and explaining exactly what a merger is.

12345678910...
Search for ebooks on Management & Business