6 2.6: Computerized Accounting Systems
2.6: Computerized Accounting Systems
Learning Objectives
- Understand how accounting systems can help organizations.
Question: Many companies today are growing out of their accounting systems. In the old days, accounting systems were designed primarily to track daily transactions and provide reports to external users on a monthly, quarterly, or annual basis. But times have changed, and companies now need more information internally to make good decisions. Accounting systems are currently used for both external reporting (financial accounting) and internal reporting ( managerial accounting). Even relatively small accounting packages, such as QuickBooks and Peachtree, provide features that are important for managerial accounting. However, most agree that no single accounting system will meet the needs of every organization and that two important factors must be considered when choosing a system. What are the two factors that must be considered when deciding on an accounting system?
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?
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?
Figure 2.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?
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.
Key Takeaway
Throughout this text, you will learn about different methods of recording, sorting, analyzing, and reporting financial information for internal users. Before deciding to implement one of these methods, ask yourself the following question: Will the benefits derived from a new system, such as an ERP system, exceed the costs of putting the system in place? If the answer is “yes,” then go for it! If the answer is “no,” consider other alternatives.
Review problem 2.5
Assume you are the CFO for an electronics consulting firm with annual revenues of $30,000,000 and annual profit of $5,000,000. The current accounting system is used for basic functions, such as issuing checks, creating invoices, and processing payroll. The company is considering upgrading its accounting system by purchasing an ERP system. Describe the factors to be considered by the company in making this decision.
Definitions
- A system designed to record and share information across functional and geographical areas to meet the needs of internal and external users.
