How Big Is Your Company?

Accounting software is designed to serve different-sized companies. The size of a company is commonly measured in sales revenue. Experts express varying opinions on what constitutes a small, midsized, or large company. Some believe that small companies have sales up to $10,000,000, midsized companies have sales up to $100,000,000, and large companies have sales greater than $100,000,000. Others prefer different amounts. Regardless of the number used, the goal is to find an accounting system that best meets the needs of the organization, and the size of the organization plays a big part in finding the best-fitting system.

What Information Is Needed?

Before selecting an accounting system, an organization must determine its accounting needs. Some organizations simply need the equivalent of a check register, which provides easy tracking of expense codes as checks are issued and makes bank reconciliations a snap. Other organizations require more than a check register; they may demand a system that can create invoices, process payroll, and track inventory. More complex organizations will want the ability to perform more advanced functions. Such organizations might need to customize reports (e.g., create an income statement by division or customer), modify input screens, send financial reports via e-mail, export reports to spreadsheet software such as Excel, and create reports with graphics (e.g., tables, pie charts, and line charts).

Enterprise Resource Planning System

Question: Clearly the size and information needs of a company will drive the selection of an accounting system for the company. As the need for accounting data has become more complex, accounting systems have been developed that perform a wide variety of tasks. These systems are called enterprise resource planning systems. What is an enterprise resource planning system, and how does this system help companies utilize accounting data?

Answer: Enterprise resource planning (ERP)A system designed to record and share information across functional and geographical areas to meet the needs of internal and external users. systems are designed to record and share information across functional areas (e.g., accounting, marketing, human resources, and shipping) and across geographical areas (e.g., from a sales office in California to headquarters in Hong Kong). ERP systems continually update information to provide real-time data to all users, and the data can be organized in different formats to meet the needs of internal and external users. For example, in his book Onward, Howard Schultz describes how as CEO of Starbucks he reviews comparative financial data for Starbucks stores daily. This information comes from the ERP system at Starbucks.

The idea behind ERP software, and a central theme in managerial accounting, is that accurate and up-to-date financial information will help organizations make better decisions. Better decisions typically lead to improvements in profitability, efficiency, and customer satisfaction.

ERP systems are expensive. Annual costs for large organizations can easily exceed $10,000,000. However, smaller systems for midsized companies are available at a much lower cost. Most ERP software is offered in modules for functional accounting areas, such as accounts receivable, accounts payable, payroll, inventory, and job costing. The more modules included, the higher the cost will be. Popular makers of ERP systems include Microsoft, Oracle, and SAP Corporation.

In deciding whether to upgrade to an ERP system, organizations must be sure that the benefits of using the data from a new system outweigh the costs of implementing the system. If management does not intend to use the information to improve planning and decision making, then going with a less sophisticated accounting system may be the better approach.

Using Spreadsheet Software

Question: ERP systems commonly provide a means to download data to spreadsheets for further analysis. How can spreadsheet software help us to analyze financial information?

Answer: Since managers make extensive use of spreadsheets to organize and analyze data, most computerized accounting systems are designed to export data to spreadsheet software programs such as Excel. For example, Figure 1.3 "Excel Spreadsheet for Southwest Airlines" shows how a spreadsheet was used to import data directly from Southwest Airlines’ 2010 annual report. This allows the user to analyze the data more easily. Notice that in Figure 1.3 "Excel Spreadsheet for Southwest Airlines" the total operating revenue increased over the three years shown. We could use Excel to quickly determine the exact percentage increase from 2008 to 2009 and from 2009 to 2010.

Figure 1.3 Excel Spreadsheet for Southwest Airlines

Question: Let’s assume you are asked to prepare an income statement showing revenue and expense projections for next year. How might you use Excel to prepare your projections?

Answer: You could start by exporting this year’s results from the accounting system to an Excel spreadsheet. Then you could set up a new column to show estimates for next year. You would likely discuss different aspects of the income statement with various personnel in the organization—making changes as you go—before finalizing your projections.

Imagine the work involved if you did not use a computer but instead had to write the information down by hand. If there were any changes to the information, you would have to make time-consuming calculations, and once the data were finalized, you would be faced with the manual preparation of formal reports. With the relatively recent advances in business technology, the days of preparing information manually are over. Most organizations require their accounting and finance personnel to have advanced computer spreadsheet skills. Our goal is to provide you with an opportunity to use spreadsheets in a way that mirrors the real world.