NOT IN USE - Computerized Accounting with QuickBooks Online 2019 (Santa Monica College)

ISBN: | Copyright 2019

Tabs
Expand/Collapse All
Computerized Accounting with QuickBooks Online - 2019 Update (pg. 1.iii)
About the Authors (pg. 1.iii)
Preface (pg. 1.iv)
Brief Table of Contents (pg. 1.xiii)
Contents (pg. 1.xiv)
Section One Introduction (pg. 1.1-1)
Section Overview (pg. 1.1-2)
Chapter 1 Introduction to QuickBooks Online (QBO) (pg. 1.1-3)
A Little Background (pg. 1.1-4)
Quickbooks Online (pg. 1.1-5)
Before We Go Any Further (pg. 1.1-6)
Where To Go For Help (pg. 1.1-6)
Practice (pg. 1.1-6)
Accessing the Test Drive Company (pg. 1.1-7)
Moving Around in Quickbooks Online (pg. 1.1-8)
Accessing Tools (pg. 1.1-8)
Forms (pg. 1.1-13)
Finding Transactions (pg. 1.1-16)
Organization of Quickbooks Online (pg. 1.1-19)
The Importance of “Lists” (pg. 1.1-19)
Adding, Editing, or Deleting Accounts (pg. 1.1-20)
Other Lists in QuickBooks Online (pg. 1.1-24)
Editing a Product or Service Item (pg. 1.1-24)
Transactions in Quickbooks Online (pg. 1.1-26)
Reporting (pg. 1.1-27)
Customizing Reports (pg. 1.1-29)
Printing Reports (pg. 1.1-35)
Chapter Shortcuts (pg. 1.1-37)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.1-37)
Assignment (pg. 1.1-38)
Chapter 2 Setting Up Company Files (pg. 1.2-1)
Introduction (pg. 1.2-2)
Setting Up Company Files in QBO (pg. 1.2-3)
Setting Up Brand New Companies in QBO (pg. 1.2-3)
Converting Existing Companies to QBO (pg. 1.2-5)
Customizing QuickBooks Online (pg. 1.2-5)
Editing Settings In a Company File (pg. 1.2-5)
Setting Up Your Company File (pg. 1.2-9)
STEP 1-Decide on the email account you want to use. (pg. 1.2-10)
STEP 2-Read the background information for the homework company assigned by your instructor included (pg. 1.2-10)
STEP 3-Activate your subscription. (pg. 1.2-10)
STEP 4-Answer the informational questions that appear in the next set of screens. (pg. 1.2-11)
STEP 5-Change the settings. (pg. 1.2-14)
STEP 6-Purge the chart of accounts. (pg. 1.2-17)
STEP 7-Import a new chart of accounts. (pg. 1.2-19)
STEP 8-Import the products and services list. (This process will be similar to the import of the cha (pg. 1.2-21)
STEP 9-Import customers. (This process will be similar to the import of products and services.) (pg. 1.2-23)
STEP 10-Import vendors. (This process will be similar to the import of customers.) (pg. 1.2-25)
STEP 11-Check your balances. (pg. 1.2-26)
Chapter Shortcuts (pg. 1.2-27)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.2-28)
Assignments (pg. 1.2-29)
Appendix 2A Setting Up Your Google Gmail Account (pg. 1.2-46)
If This Is Your First Gmail Account (pg. 1.2-46)
If You Already Have a Gmail Account (pg. 1.2-47)
Chapter 3 Sales Activity (Service Company) (pg. 1.3-5)
What is the Sales Cycle in a Service Company? (pg. 1.3-6)
Setting Up Standard Sales Settings (pg. 1.3-6)
Managing Customers (pg. 1.3-8)
Customer Center Display (pg. 1.3-8)
Adding a Customer (pg. 1.3-10)
Viewing Customer Information (pg. 1.3-12)
Changing Customer Information (pg. 1.3-12)
Inactivating a Customer (pg. 1.3-13)
Managing Service Items (pg. 1.3-16)
Organizing Products and Services (pg. 1.3-16)
Adding a Service Item (pg. 1.3-18)
Editing Products and Services (pg. 1.3-20)
Setting Up Credit Terms (pg. 1.3-23)
Recording Sales Revenue (pg. 1.3-26)
Recording Sales on Account (pg. 1.3-27)
Recording Cash Sales (pg. 1.3-29)
Recording Payments from Customers (pg. 1.3-32)
Payments on Account (pg. 1.3-32)
Making Deposits (pg. 1.3-36)
Recording Customer Credits and Refunds (pg. 1.3-39)
Creating Credit Memos with Automatic Application Set as the Preference (pg. 1.3-40)
Creating Credit Memos with Manual Application (Automatic Application Preference Turned Off) (pg. 1.3-42)
Issuing Refunds to Customers (pg. 1.3-43)
Sales and Customer Reports (pg. 1.3-47)
Sales Cycle Summary (pg. 1.3-50)
Chapter Shortcuts (pg. 1.3-51)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.3-51)
Assignments (pg. 1.3-53)
Chapter 4 Purchasing Activity (Service Company) (pg. 1.4-1)
What is the Purchase Cycle in a Service Company? (pg. 1.4-2)
Managing Vendors (pg. 1.4-2)
Vendor Center Display (pg. 1.4-3)
Adding a Vendor (pg. 1.4-4)
Viewing Vendor Information (pg. 1.4-6)
Editing Vendor Information (pg. 1.4-6)
Inactivating a Vendor (pg. 1.4-7)
Recording Purchases (pg. 1.4-9)
Automation in QBO (pg. 1.4-9)
Purchasing on Account (pg. 1.4-11)
Purchasing with Cash or Check (pg. 1.4-14)
Voiding Checks (pg. 1.4-16)
Purchasing with a Credit Card (pg. 1.4-19)
Paying Vendor Balances (pg. 1.4-22)
Paying Multiple Vendor Bills (pg. 1.4-22)
Paying One or More Bills from a Single Vendor (pg. 1.4-24)
Purchases Cycle Summary (pg. 1.4-25)
Vendor Reports (pg. 1.4-26)
Chapter Shortcuts (pg. 1.4-27)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.4-27)
Assignments (pg. 1.4-28)
Appendix 4A Reporting 1099 Vendor Activity (pg. 1.4-36)
Chapter 5 End-of-Period Activity (Service Company) (pg. 1.5-1)
Before Issuing Financial Statements (pg. 1.5-2)
Reconciling Bank and Credit Card Accounts (pg. 1.5-3)
Bank Reconciliations (pg. 1.5-3)
Credit Card Reconciliations (pg. 1.5-8)
Making Adjusting Journal Entries (pg. 1.5-12)
Preparing Financial Statements (pg. 1.5-14)
Closing a Period (pg. 1.5-18)
Closing an Accounting Period (pg. 1.5-18)
Year-end Closing (pg. 1.5-20)
Chapter Shortcuts (pg. 1.5-21)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.5-22)
Assignments (pg. 1.5-23)
Appendix 5A Getting It Right (pg. 1.5-29)
Appendix 5B Understanding The Reconciliation Report (pg. 1.5-30)
Appendix 5C Fixing Reconciliation Errors (pg. 1.5-33)
Section Three Merchandising Companies (pg. 1.6-1)
Controls in QuickBooks Online (pg. 1.6-1)
Managing Users (pg. 1.6-1)
Adding Users (pg. 1.6-2)
Adding Standard Users With Limited Access (pg. 1.6-4)
Adding Accountant Users (pg. 1.6-7)
Editing, Monitoring, and Deleting Users (pg. 1.6-7)
Reporting on Transaction History (pg. 1.6-8)
Section Overview (pg. 1.6-8)
Chapter 6 Sales Activity (Merchandising Company) (pg. 1.6-9)
What is the Sales Cycle in a Merchandising Company? (pg. 1.6-10)
Managing Customers (pg. 1.6-10)
Setting Up Sub-Customers (pg. 1.6-10)
Customers and Sales Tax (pg. 1.6-11)
Setting Up Sales Taxes (pg. 1.6-12)
Managing the Tax Status of Customers (pg. 1.6-16)
Shipping Addresses (pg. 1.6-18)
Managing Items (Merchandising Company) (pg. 1.6-19)
Setting Up Inventory Items (pg. 1.6-19)
Recording Sales Revenue (pg. 1.6-25)
Customer Discounts (pg. 1.6-25)
Delayed Charges and Delayed Credits (pg. 1.6-29)
Recording Uncollectible Accounts (pg. 1.6-33)
Recording Payments From Customers (pg. 1.6-37)
Customer Payments by Credit Card (pg. 1.6-37)
Early Payment Discounts (pg. 1.6-40)
Customer Checks Returned by Bank Due to Insufficient Funds (NSF Checks) (pg. 1.6-43)
Customer Reports (pg. 1.6-46)
Customer Statements (pg. 1.6-48)
Chapter Shortcuts (pg. 1.6-50)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.6-50)
Assignments (pg. 1.6-51)
Chapter 7 Purchasing Activity (Merchandising Company) (pg. 1.7-1)
What is the Purchase Cycle in a Merchandising Company? (pg. 1.7-2)
Purchasing Inventory (pg. 1.7-2)
Paying at Time of Purchase (pg. 1.7-3)
Ordering Inventory (pg. 1.7-5)
Managing Purchase Orders (pg. 1.7-17)
Ordering Inventory Without Using the Purchase Order System (pg. 1.7-19)
Vendor Credits (pg. 1.7-19)
Entering Credits from Vendors (pg. 1.7-19)
Applying Credits from Vendors (pg. 1.7-20)
Special Considerations for Returns of Inventory (pg. 1.7-22)
Paying Vendor Balances (pg. 1.7-24)
Early Payment Discounts (pg. 1.7-24)
Vendor Reports (pg. 1.7-28)
Chapter Shortcuts (pg. 1.7-29)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.7-29)
Assignments (pg. 1.7-30)
Chapter 8 End-of-Period and Other Activity (Merchandising Company) (pg. 1.8-1)
Adjusting Inventory (pg. 1.8-2)
Managing Sales Taxes (pg. 1.8-6)
Remitting Sales Tax Liabilities (pg. 1.8-8)
Adjusting Sales Tax Liabilities (pg. 1.8-11)
Deleting Sales Tax Payments (pg. 1.8-13)
Entering Cash Receipts from Non-Customers (pg. 1.8-15)
Recording Bank Transfers (pg. 1.8-17)
Inactivating and merging general ledger accounts (pg. 1.8-18)
Inactivating an Account (pg. 1.8-18)
Merging Accounts (pg. 1.8-20)
Adding Notes to Reports (pg. 1.8-21)
Chapter Shortcuts (pg. 1.8-24)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.8-25)
Assignments (pg. 1.8-26)
Appendix 8A Downloading Bank Transactions Into QBO (pg. 1.8-34)
Setting Banking Rules (pg. 1.8-37)
Section Four Beyond the Basics (pg. 1.9-1)
Chapter 9 Project Tracking and Billing for Time and Expenses (pg. 1.9-3)
Before We Begin (pg. 1.9-4)
Setting Up Projects (pg. 1.9-4)
Setting Up Independent Contractors (pg. 1.9-9)
Using Timesheets To Track Hours (pg. 1.9-11)
Setting Up Time Tracking (pg. 1.9-12)
Entering Timesheet Data (pg. 1.9-12)
Tracking Costs Other Than Labor By Project (pg. 1.9-16)
Turning on Features for Tracking and Billing Direct Expenses (pg. 1.9-16)
Accounting for Direct Costs Billed to Customers (pg. 1.9-17)
Identifying Costs as Billable (pg. 1.9-20)
Billing for Time and Costs (pg. 1.9-22)
Preparing Project Reports (pg. 1.9-26)
Chapter Shortcuts (pg. 1.9-27)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.9-27)
Assignments (pg. 1.9-28)
Appendix 9A Working with Estimates (pg. 1.9-43)
Creating Estimates (pg. 1.9-43)
Creating Invoices from Estimates (pg. 1.9-45)
Copying Estimates (pg. 1.9-47)
Creating Purchase Orders from Estimates (pg. 1.9-48)
Chapter 10 Management Tools (pg. 1.10-1)
Tracking by Class and Location (pg. 1.10-2)
Turning on Class Tracking (pg. 1.10-3)
Turning on Location Tracking (pg. 1.10-5)
Setting Up Classes and Locations (pg. 1.10-6)
Adding Class and Location to Transactions (pg. 1.10-11)
Reporting by Class or Location (pg. 1.10-14)
Creating and Using Budgets (pg. 1.10-16)
Creating Budgets (pg. 1.10-17)
Creating Budget Reports (pg. 1.10-21)
Chapter Shortcuts (pg. 1.10-21)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.10-22)
Assignments (pg. 1.10-23)
Chapter 11 Additional Tools (pg. 1.11-1)
Reversing Entries (pg. 1.11-2)
Recurring Transactions (pg. 1.11-4)
Saving Customized Reports (pg. 1.11-9)
Creating Management Reports (pg. 1.11-12)
Creating Custom Fields (pg. 1.11-18)
Customizing Forms (pg. 1.11-20)
Using Customized Forms (pg. 1.11-24)
Exporting Reports to Excel (pg. 1.11-24)
Uploading and Managing Attachments (pg. 1.11-26)
Adding Attachments to Customer or Vendor Records (pg. 1.11-26)
Adding Attachments to Transactions (pg. 1.11-27)
Adding Attachments Directly to the Attachment Lists (pg. 1.11-28)
Chapter Shortcuts (pg. 1.11-31)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.11-31)
Assignments (pg. 1.11-32)
Section Five Paying Employees (pg. 1.12-1)
Before We Move Forward (pg. 1.12-1)
Compensation (pg. 1.12-1)
Payroll Taxes (pg. 1.12-2)
Benefits (pg. 1.12-2)
Chapter 12 Payroll Activity (pg. 1.12-3)
What is the Payroll Cycle? (pg. 1.12-4)
Payroll Plans Available In QBO (pg. 1.12-4)
Before We Start (pg. 1.12-4)
Turning On Payroll (pg. 1.12-5)
Managing Payroll Settings (pg. 1.12-8)
Setting Pay Policies (pg. 1.12-9)
Setting Up Other Deductions and Company Contributions for Payroll (pg. 1.12-12)
Setting Up Taxes (pg. 1.12-14)
Setting Accounting Preferences for Payroll (pg. 1.12-16)
Other Payroll Settings (pg. 1.12-19)
Changing Payroll Settings (pg. 1.12-19)
Managing Employees (pg. 1.12-21)
Setting Up the First Employee (pg. 1.12-22)
Setting Up Additional Employees (pg. 1.12-26)
Editing and Deleting Employees (pg. 1.12-29)
Processing Payroll (pg. 1.12-30)
Editing, Voiding, or Deleting Paychecks (pg. 1.12-35)
Processing and Reporting Payroll Taxes (pg. 1.12-38)
Remitting (Depositing) Payroll Taxes (pg. 1.12-38)
Editing Payroll Tax Liabilities (pg. 1.12-41)
Preparing Payroll Tax Forms (pg. 1.12-41)
Preparing Payroll Reports (pg. 1.12-41)
Chapter Shortcuts (pg. 1.12-42)
Chapter Review (Answers available on the publisher’s website.) (pg. 1.12-43)
Assignment (pg. 1.12-44)
Appendix A Is Computerized Accounting Really the Same as Manual Accounting? (pg. 1.A-1)
Accrual and Cash Basis Accounting in Quickbooks Online (pg. 1.A-3)
Comparison of Computerized and Manual Accounting Systems (pg. 1.A-4)
Journal Entries (pg. 1.A-5)
Journals (pg. 1.A-6)
General Ledger and T-Accounts (pg. 1.A-8)
Trial Balances (pg. 1.A-8)
Appendix B Account Types and Common Transaction Types used in QBO (pg. 1.B-1)
Appendix C Common Options Available on Various Forms (pg. 1.C-1)
Glossary (pg. 1.G-1)
Index (pg. 1.I-1)
Computerized Accounting with QuickBooks Online - 2019 Update (Williams, Johnson)
Errata
Last Updated: Jan 17 2020

Corrections to identified errors in the the text.

QBO 2019-2020 Software Updates
Last Updated: Jan 23 2020

Includes updates to Chapters 2, 5-7, and 12.

Getting Started Instructions & Videos for Students
Last Updated: Jan 23 2020

The Getting Started download includes an overview of how to get started using QBO and instruction on how a student can request their free QBO license as well as a video from Intuit Education on how to request a student license.  The files included are as follows:

*Getting Started with QBO - An overview of all the different tools and data needed to get started using and practicing with QuickBooks Online.

*Intuit Student Code Process - Instructions on how to request your free 1-year QuickBooks Online license code from Intuit Education.

*Nuts and Bolts - Student Sign-up Process Video - A short video from Intuit Education covering the sign-up process.

Math Revealed Excel Setup Files
Last Updated: Oct 14 2019

Here are the Excel setup files for Math Revealed.

Salish Software Excel Setup Files
Last Updated: Oct 14 2019

Here are the Excel setup files for Salish Software.

Certiport Mapping (Student)
Last Updated: Oct 14 2019

This document maps the objectives of QuickBooks Online Certified User exam, administered by Certiport, to their locations and coverage in the textbook.