Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo
Workplace Software and Skills

12.1 Basic Accounting

Workplace Software and Skills12.1 Basic Accounting

Table of contents
  1. Preface
  2. 1 Technology in Everyday Life and Business
    1. Chapter Scenario
    2. 1.1 Computing from Inception to Today
    3. 1.2 Computer Hardware and Networks
    4. 1.3 The Internet, Cloud Computing, and the Internet of Things
    5. 1.4 Safety, Security, Privacy, and the Ethical Use of Technology
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  3. 2 Essentials of Software Applications for Business
    1. Chapter Scenario
    2. 2.1 Software Basics
    3. 2.2 Files and Folders
    4. 2.3 Communication and Calendar Applications
    5. 2.4 Essentials of Microsoft 365
    6. 2.5 Essentials of Google Workspace
    7. 2.6 Collaboration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  4. 3 Creating and Working in Documents
    1. Chapter Scenario
    2. 3.1 Navigating Microsoft Word
    3. 3.2 Formatting Document Layout in Microsoft Word
    4. 3.3 Formatting Document Content in Microsoft Word
    5. 3.4 Collaborative Editing and Reviewing in Microsoft Word
    6. 3.5 Document Design
    7. 3.6 Navigating Google Docs
    8. 3.7 Formatting Layout and Content in Google Docs
    9. 3.8 Collaborative Editing and Reviewing in Google Docs
    10. 3.9 Versions and Version History
    11. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  5. 4 Document Preparation
    1. Chapter Scenario
    2. 4.1 Microsoft Word: Advanced Formatting Features
    3. 4.2 Working with Graphics and Text Tools in Microsoft Word
    4. 4.3 Managing Long Documents in Microsoft Word
    5. 4.4 Google Docs: Enhanced Formatting Features
    6. 4.5 Working with Graphics and Text Tools in Google Docs
    7. 4.6 Managing Long Documents in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  6. 5 Advanced Document Preparation
    1. Chapter Scenario
    2. 5.1 Creating Different Document Types in Microsoft Word
    3. 5.2 Mail Merge in Microsoft Word
    4. 5.3 Creating Forms in Microsoft Word
    5. 5.4 Creating Different Document Types in Google Docs
    6. 5.5 Creating Forms in Google Docs
    7. 5.6 Advanced Collaboration in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  7. 6 Preparing Presentations
    1. Chapter Scenario
    2. 6.1 Presentation and Design Essentials
    3. 6.2 Designing a Presentation in Microsoft PowerPoint
    4. 6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
    5. 6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
    6. 6.5 Designing a Presentation in Google Slides
    7. 6.6 Creating Google Slides: Layout and Text
    8. 6.7 Adding Visuals and Features to Google Slides
    9. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  8. 7 Advanced Presentation Skills
    1. Chapter Scenario
    2. 7.1 Effective Presentation Skills
    3. 7.2 Finalizing a Slide Collection
    4. 7.3 Preparing a Microsoft PowerPoint Collection for Presentation
    5. 7.4 Preparing a Google Slides Collection for Presentation
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  9. 8 Content Management Systems and Social Media in Business
    1. Chapter Scenario
    2. 8.1 What Are Content Management Systems?
    3. 8.2 Common Content Management Systems
    4. 8.3 Creating Content with a Content Management System
    5. 8.4 Search Engine Optimization
    6. 8.5 Social Media in Business
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  10. 9 Working with Spreadsheets
    1. Chapter Scenario
    2. 9.1 Microsoft Excel Basics
    3. 9.2 Text and Numbers in Microsoft Excel
    4. 9.3 Calculations and Basic Formulas in Microsoft Excel
    5. 9.4 Formatting and Templates in Microsoft Excel
    6. 9.5 Google Sheets Basics
    7. 9.6 Text and Numbers in Google Sheets
    8. 9.7 Calculations and Basic Formulas in Google Sheets
    9. 9.8 Formatting and Templates in Google Sheets
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  11. 10 Advanced Excel Formulas, Functions, and Techniques
    1. Chapter Scenario
    2. 10.1 Data Tables and Ranges
    3. 10.2 More About Formulas
    4. 10.3 Using Arithmetic, Statistical, and Logical Functions
    5. 10.4 PivotTables
    6. 10.5 Auditing Formulas and Fixing Errors
    7. 10.6 Advanced Formatting Techniques
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  12. 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
    1. Chapter Scenario
    2. 11.1 Understanding Data, Data Validation, and Data Tables
    3. 11.2 Statistical Functions
    4. 11.3 What-If Analysis
    5. 11.4 PivotTables/Charts
    6. 11.5 Data Analysis Charts
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  13. 12 Using Excel in Accounting and Financial Reporting
    1. Chapter Scenario
    2. 12.1 Basic Accounting
    3. 12.2 Financial Functions in Microsoft Excel
    4. 12.3 Integrating Microsoft Excel and Accounting Programs
    5. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  14. 13 Understanding and Using Databases
    1. Chapter Scenario
    2. 13.1 What Is a Database?
    3. 13.2 Microsoft Access: Main Features and Navigation
    4. 13.3 Querying a Database
    5. 13.4 Maintaining Records in a Database
    6. 13.5 Creating Reports in Microsoft Access
    7. 13.6 Creating Forms in Microsoft Access
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  15. 14 Advanced Database Use
    1. Chapter Scenario
    2. 14.1 Advanced Queries in Microsoft Access
    3. 14.2 Multiple Table Forms
    4. 14.3 Customizing Forms
    5. 14.4 Customizing Reports
    6. 14.5 Using Macros
    7. 14.6 Data Analysis and Integration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  16. 15 Integrating Applications
    1. Chapter Scenario
    2. 15.1 Microsoft 365: Collaboration and Integration
    3. 15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
    4. 15.3 Microsoft Word and Microsoft PowerPoint Integration
    5. 15.4 Microsoft Excel and Microsoft PowerPoint Integration
    6. 15.5 Microsoft Excel and Microsoft Access Integration
    7. 15.6 Integrating Data from Other Programs into Google Workspace
    8. 15.7 New Developments: The Role of Artificial Intelligence
    9. 15.8 Mastering Workplace Software Skills: A Project
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
  17. Index

Learning Objectives

By the end of this section, you will be able to:

  • Define accounting
  • Distinguish between financial and managerial accounting
  • Understand how accounting information is created and used by internal and external stakeholders of a business

Financial accounting information is mostly historical in nature—that is, accountants prepare financial reports that summarize what has already occurred in an organization. A business can use this financial accounting information as a predictive tool, but with limitations. Business involves a large amount of uncertainty, and accountants cannot predict how the organization will perform in the future. However, by observing historical financial information, users of the information can detect patterns or trends that may be useful for estimating the company’s future financial performance. Collecting and analyzing a series of historical financial data can provide important information to both internal and external users. Microsoft Excel is a useful tool for this purpose.

What Is Accounting?

The process of organizing, analyzing, and communicating financial information that is used for decision making is accounting. Financial information is typically prepared by accountants—those trained in the specific techniques and practices of the profession. However, a solid understanding of how financial information is prepared and used can serve as a useful resource for many people in their workplace.

A traditional adage states that “accounting is the language of business.” While that is true, you can also say that “accounting is the language of life” because, at some point, most people will make a decision that relies on accounting information. For example, you may have to decide whether it is better to lease or buy a vehicle. Likewise, a college graduate may have to decide whether it is better to take a higher-paying job in a big city with a high cost of living or a job in a smaller community where both the pay and cost of living may be lower.

In a professional setting like WorldCorp, an executive may want to know if the most recent product release was profitable. Similarly, a department head may want to know whether it is worthwhile to pay an employee to be “on call” for emergencies during off-hours and weekends. Whether personal or professional, accounting information plays a vital role in decisions like these.

Spotlight on Ethics

Financial Regulations

Individuals performing financial services such as accounting must ascribe to a set of rules and regulations prescribed by the government and other financial regulatory agencies. Various laws and regulations are passed on a regular basis, and it is important for accountants and other money handlers to keep up with changes and ensure they are compliant. Additionally, accountants must also ascribe to a strict set of ethical guidelines, such as ensuring confidentiality and completing a certain number of hours in professional development every year. Companies that fail to comply with these various rules and guidelines are at risk of heavy penalties, and even incarceration. Notable high-profile cases have contributed to the need for these rules, including Enron and Bernie Madoff. The Enron scandal, wherein Enron was found guilty of a number of fraudulent and otherwise questionable business and accounting practices leading to their demise in 2001, led to the Sarbanes-Oxley Act, which ushered in reforms in a number of business financial practices. Bernie Madoff, once the chair of NASDAQ, was sentenced to jail for running the biggest Ponzi scheme in the history of the United States, stealing over $64 billion from unsuspecting individuals, including several celebrities. His arrest led to a number of reforms put in place to protect individuals from fraud. Hence, it is the responsibility of those holding these positions to remain current and uphold the strictest of ethical and just business and accounting practices.

Financial and Managerial Accounting

Accounting is divided into two main areas: financial and managerial. In essence, financial accounting measures the financial performance of an organization using standard conventions to prepare and distribute financial reports. Financial accounting is used to generate information for stakeholders outside of an organization, such as investors, loan officers, and governmental entities, such as the Internal Revenue Service (IRS).

Financial accounting is also a foundation for understanding managerial accounting, which uses both financial and nonfinancial information as a basis for making decisions within an organization. The purpose is to equip decision makers with the information they need to set and evaluate business goals and to make other decisions for the business. Managerial accounting information tends to be used internally. Internal users include managers and other employees who use financial information to confirm past results and help make adjustments for future activities for such purposes as budgeting, pricing, and determining production costs.

Understanding financial and managerial accounting is valuable across a business. Management of WorldCorp’s LCD screen manufacturing division, for example, would use both financial and managerial accounting information to help improve the business. Managers in the screen manufacturing division may want to know how much scrap is generated from a particular step in the manufacturing process. While identifying and improving the manufacturing process (i.e., reducing scrap) helps the company financially, it may also help other areas of the production process that are indirectly related, such as quality control and shipping efficiencies.

External users also use the historical pattern of an organization’s financial performance as a predictive tool. For example, when deciding whether to loan money to an organization, a bank may require a certain number of years of financial statements and other financial information from the organization. An Excel spreadsheet can be used to analyze this data in greater detail. The bank will assess the historical performance in order to make an informed decision about the organization’s ability to repay the loan and interest (the cost of borrowing money). Similarly, a potential investor may look at a business’s past financial performance in order to assess whether or not to invest money in the company. In this scenario, the investor wants to know if the organization will provide a sufficient and consistent return on the investment.

How Accounting Information Is Created and Used

Organizations measure financial performance in monetary terms. In the United States, the dollar is used as the standard measurement basis. Measuring financial performance in monetary terms allows managers to compare the organization’s performance to previous periods, to expectations, and to other organizations or industry standards. Accounting information is created by an accounting system and can be downloaded into Excel for further analysis.

Several financial calculations are standardized and used to make many business decisions such as forecasting sales or establishing sales goals. These include functions such as calculating interest rates, payments due, and asset depreciation, which is when something the company owns loses value over time because of the wear and tear of regular use. Financial Functions in Microsoft Excel will cover the most common financial equations used in Excel.

A company’s financial information is generally gathered and kept in standard bookkeeping software rather than in Excel. The larger-scale financial data that is captured through the software helps to determine a company’s current financial status and predict future financial health. That type of financial information is primarily communicated through financial statements. These financial statements ensure the information is consistent from one time period to another and generally comparable between organizations. Details about the statements are beyond the scope of this text, but you can find more information in a standard accounting textbook. The information contained in the statements can be downloaded into Excel for further examination and analysis.

Real-World Application

Your Personal Accounting Equation

The accounting equation is a basic principle used in accounting that states that a company’s assets (what they own and the predicted value of the manufacturing, sales, or service they provide) are equal to its liabilities (debt) and equity (net worth of the company):

Assets = Liabilities + Equity

This concept is not just for business. It can be used to understand your personal finances as well. Try this exercise.

On a sheet of paper, use three columns to create your own accounting equation. In the first column, list all of the things you own (assets). In the second column, list any amounts owed (liabilities) for each asset. In the third column, using the accounting equation, calculate the net amount of the asset (equity) by subtracting the liability from the value of the asset. When you’ve finished with each asset, total the columns to determine your net worth. You can also do the calculations without determining the equity of each asset. To do this, you only need two columns, one for assets and one for liabilities. Add up each column and then subtract the sum of all of your liabilities from the sum of all of your assets. This gives you your total equity.

Here is something else to consider: Is it possible to have negative equity? It sure is . . . ask any college student who has taken out loans. At first glance, there is no asset directly associated with the amount of the loan. But is that, in fact, the case? You might ask yourself why make an investment in a college education—what is the benefit (asset) of going to college? The answer lies in the difference in lifetime earnings with a college degree versus without a college degree. This is influenced by many things, including the supply and demand of jobs and employees. It is also influenced by the earnings for the type of college degree pursued. (Where do you think accounting ranks?)

Accountants often use computerized accounting systems to record and summarize the financial reports, which offer many benefits. The primary benefit of a computerized accounting system is the efficiency by which transactions can be recorded and summarized, and financial reports prepared. In addition, computerized accounting systems store data, which allows organizations to easily extract historical financial information to import into Excel for further analysis or sharing with other stakeholders.

Common computerized accounting systems include QuickBooks, which is designed for small organizations, and SAP (Systems, Applications, and Products) enterprise resource planning software, which is designed for large and/or multinational organizations. QuickBooks is popular with smaller, less complex entities, and you will learn more about it in Integrating Microsoft Excel and Accounting Programs. It is less expensive than more sophisticated software packages, such as Oracle or SAP, and incorporates many user-friendly features that can reduce both training time and costs spent on acclimating new employees to an employer’s software system. While QuickBooks has many advantages, once a company’s operations reach a certain level of complexity—such as with the global corporation WorldCorp—it will need a more robust software package or platform, such as Oracle or SAP, which is then customized to meet the unique informational needs of the entity. Some advanced capabilities include automation of invoicing and receiving payments, payroll services, and tracking and paying sales taxes.

Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.