When is it time to move away from Excel for the budgeting process?

Hyoun Park

Microsoft Excel is a fantastic self-service discovery tool for ad-hoc data. However, its key weakness is that there are currently few safeguards for data governance, data processing or data quality. This makes Excel a poor tool for organizations that need to share data or conduct complex analysis where errors can easily be entered through a single point of failure. 

Hyoun Park

There are typically three key reasons to move away from Excel:

  1. The need for multiple stakeholders to directly manage the budgeting process. To maintain a log of changes and ensure that there is governance in the budgeting process, companies should move away from Excel.
  2. The need for complex budgeting processes. For instance, if budgeting involves algorithmic or statistical risk factors, companies should move to a more robust budgeting tool that has integrated business intelligence or predictive analytic capabilities.
  3. Budgeting requires significant nonfinancial explanation or analysis. If budgeting requires a high level of documentation from either a governance or compliance perspective, it may be time to move to a budgeting system that has more strategic management or GRC (governance, risk management and compliance) support to manage text and other backing information that will clarify the budget above and beyond Excel's capabilities.

About the author:
Hyoun Park is principal analyst at Nucleus Research Inc., overseeing primary investigative research on analytics, big data, business analytics, social software and enterprise mobility. Follow him on Twitter
@hyounpark and read his research at www.nucleusresearch.com.

More on budgeting, planning and forecasting tools:

Read about the benefits of implementing rolling forecasts

Learn why one BP&F software implementation went sour

Discover budgeting and forecasting system implementation tips

 

View the next item in this Essential Guide: Four tips for faster financial consolidation or view the full guide: Ultimate Excel finance guide

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Expert Discussion

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest