Valid Information Is Power

Small companies need to control accounting data and standards throughout the company.
This story appears in the June 2005 issue of BizTech Magazine.
Harry J. Harczak Jr., EVP, Small Business Sales, Former CFO

The owner of a growing business thinks about return on investment much differently than owners of slow-moving companies. When a business is positioned for growth, you want accurate answers about how the business earns and spends money as well as where to invest resources for the best return.

For instance, how do you determine the age of your inventory and when it begins to depreciate? Do you know when your customers are likely to buy more or less product? Can you pinpoint which factors are driving the results of seasonal sales or pricing promotions?

After sales wins a new piece of business, can you scale up quickly because you know intimately what your operating costs are, when inventory turns and what margin you need to maintain a profit?

Many businesses think they have that information at their fingertips only to discover that the operating margin calculations done by finance do not mesh with those done by sales or the IT group. How can each group have a different view of what the costs and profit margin should look like? The answer and the problem are often the same: spreadsheets.

One lesson that many publicly traded corporations have learned from the Sarbanes-Oxley Act is that information is powerful—but only when that information is valid. Few small businesses rely on an outside auditor to validate their management accounting procedures and take time to ensure that each group within the company uses the same formula to calculate results.

Solid financial controls ensure that a single stream of accounting data and one version of the truth permeate the entire company. At one time, only big business could afford the high price tag of sophisticated applications that standardized processes across the organization. Small business was on the outside looking in.

Luckily, a number of software providers have begun to scale their packages to fit the needs and budgets of small business. Through these packages, small businesses can more effectively control financial reporting processes and quickly generate accurate information. As a result, small business management is better equipped to guide strategy based on this reporting.

Still, these applications are not for every business. If spreadsheets continue to meet your needs, here are some suggestions for ensuring that you generate one version of the truth.

1. Password Protection: All the major productivity applications offer passwords. They are great for limiting access to critical spreadsheet formulas and ensuring that no one makes unauthorized additions.

2. Control: Eliminate numerous data streams and control sources of data into spreadsheets.

3. Change Management: Creativity is a valuable quality for just about every department except finance. Knowing which individuals are authorized to change the spreadsheet provides accountability.

4. Formula Documentation: Maintaining documented formulas (and preventing individuals from altering them) increases the validity of your data.

5. Backup: Wherever you decide to house your critical financial data, make sure that drive stays secure and backed up on a regular, defined basis.

Sign up for our e-newsletter


Heartbleed: What Should Your... |
One of the biggest security vulnerabilities has almost every user and every industry...
Why Businesses Need a Next-G... |
Devices investigate patterns that could indicate malicious activity.
Review: HP TippingPoint S105... |
Next-generation firewall can easily replace a stand-alone intrusion prevention system....


The New Backup Utility Proce... |
Just getting used to the Windows 8 workflow? Prepare for a change.
How to Perform Traditional W... |
With previous versions going unused, Microsoft radically reimagined the backup utility in...
5 Easy Ways to Build a Bette... |
While large enterprises have the resources of an entire IT department behind them, these...

Infrastructure Optimization

Businesses Must Step Careful... |
Slow and steady wins the race as businesses migrate IT operations to service providers,...
Why Cloud Security Is More E... |
Cloud protection services enable companies to keep up with security threats while...
Ensure Uptime Is in Your Dat... |
Power and cooling solutions support disaster recovery and create cost savings and...


Securing the Internet of Thi... |
As excitement around the connected-device future grows, technology vendors seek ways to...
How to Maximize WAN Bandwidt... |
Understand six common problems that plague wide area networks — and how to address them.
Linksys Makes a Comeback in... |
The networking vendor introduced several new Smart Switch products at Interop this week.

Mobile & Wireless

Mobility: A Foundational Pie... |
Other technologies rely on mobile computing, which has the power to change lives, Lextech...
Now that Office for iPad Is... |
After waiting awhile for Microsoft’s productivity suite to arrive, professionals who use...
Visualization Can Help Busin... |
Companies need to put their data in formats that make it consumable anytime, anywhere.

Hardware & Software

Review: HP TippingPoint S105... |
Next-generation firewall can easily replace a stand-alone intrusion prevention system....
New Challenges in Software M... |
IT trends such as cloud, virtualization and BYOD pose serious hurdles for software...
Visualization Can Help Busin... |
Companies need to put their data in formats that make it consumable anytime, anywhere.