We may earn an affiliate commission when you visit our partners.
Robert (Bob) Steele

QuickBooks Online bookkeeping business designed for small business clients or small businesses who want a simple cash basis format for entering data. 

This course is designed for bookkeepers and is also useful for small business owners who want a simple system for entering financial data into QuickBooks for financial planning and year-end tax preparation.

The bookkeeping system we discuss will also describe the relationship between the bookkeeper, the business, and the year-end tax and financial statement preparers.

Read more

QuickBooks Online bookkeeping business designed for small business clients or small businesses who want a simple cash basis format for entering data. 

This course is designed for bookkeepers and is also useful for small business owners who want a simple system for entering financial data into QuickBooks for financial planning and year-end tax preparation.

The bookkeeping system we discuss will also describe the relationship between the bookkeeper, the business, and the year-end tax and financial statement preparers.

We will outline a cash basis bookkeeping system using QuickBooks, a system that will enter most transactions directly into the check register.

The course will discuss the responsibilities of a bookkeeper and the responsibilities of the business when a bookkeeping engagement in entered into. 

We will work through a sample bookkeeping project in QuickBooks including the setting up of a new QuickBooks company file.

The course will practice entering data into the QuickBooks register directly from a bank statement. We will provide practice bank statements to use with the project as well as step by step instructional videos.

As we enter data directly into the check register from the bank statement, we will compare and contrast the cash basis system we are using to a full accounting cycle system. We will also review the financial statements periodically to see how QuickBooks is using the data to make reports.

After entering data into the QuickBooks check register from the bank statement, we will perform bank reconciliations. As we perform bank reconciliations, we will discuss what a bank reconciliation is and the benefits a bank reconciliation provides.

The course will then discuss options for entering specific accounting data into QuickBooks including payroll, equipment, loan payments, insurance, credit card payments, and invoices. We will provide practice QuickBooks files for different options related to the items listed above and explore the pros and cons of each option. The bookkeeping options will help tailor our system to our specific bookkeeping needs.

As we enter accounting data into the system we will discuss common questions we will have when entering the first few months of data and how to write down these questions, move forward with data input, and organize the financial data so that we can quickly go back to it once our client questions are answered.

This course will discuss, print, and export month end and year end reports, reports a bookkeeper may provide to clients monthly and reports the business will need at year-end for tax preparation.

We will discuss year-end adjusting entries. The bookkeeping system we propose will depend on an outside accounting firm, tax preparer, or CPA firm to help with the year-end adjusting entries. As bookkeepers we want to be aware of the adjusting entry process so we can work with any year-end accounting firm, tax preparer, or CPA firm. We will enter common adjusting entries into an adjusting entry Excel worksheet and into Quickbooks.

Finally, we will discuss whether or not to enter the year-end adjusting entries into our QuickBooks bookkeeping system and different options to do so.

In addition to the instructional videos, this course will include downloadable  

•    Excel practice files

•    Downloadable PDF Files  

Excel practice files will be preformatted and will generally have at least two tabs, one tab with the completed work and a second tab with a preformatted worksheet we can fill in as we watch the instructional videos.   

Who will we be learning from?  

Enroll now

What's inside

Learning objectives

  • How to outline a simple bookkeeping system for a small business using quickbooks online
  • How to network between the bookkeeper, business owner, and year-end tax accounting firm, cpa firm or tax preparer
  • How to set up a simple bookkeeping company file in quickbooks online and store it on a computer
  • How to use an easy method to enter financial data into quickbooks online from the bank statement
  • How to identify common problems when entering financial data and strategies for overcoming them
  • How to reconcile the bank accounts in quickbooks online
  • How to analyses payroll options including the options to work with a third-party payroll company or to enter payroll into quickbooks
  • The basics of entering payroll into quickbooks online
  • How to enter equipment purchases into quickbooks online
  • How to enter loan payments into quickbooks online
  • How to enter insurance payments into quickbooks online
  • How to enter credit card charges into quickbooks online
  • How to format month-end and year-end reports using quickbooks online
  • How to enter adjusting entries into quickbooks online or prior year and work with accounting firms, cpa firms, or tax preparer to help with them
  • Show more
  • Show less

Syllabus

Introduction
Bookkeeping Project Outline and Plan Using QuickBooks
2 Bookkeeping Project Outline and Plan
Data Files and Answer Keys
Read more
PDF - 20 Outline Of Standard Client
20 Outline Of Standard Client Or Business
PDF - 22 Outline Of Service We Provide
22 Outline Of Bookkeeping Process
PDF - 23 Network With Other Professionals
23 Network With Other Professionals
PDF - 24 Bank Feeds
PDF - 24 Bank Feeds Option
Accounting Comic Break
Engagement Letter and Questionnaire
3 Engagement Letter and Questionnaire
PDF - 26 Engagement Letter
26 Engagement Letter
PDF - 28 New Client Engagement Questionnaire
28 New Client Engagement Questionnaire
Create New Company File & QuickBooks File Using QuickBooks
4 Create New Company File & QuickBooks File
PDF - 30 Outline Sample Engagement
30 Outline Sample Engagement
60 Organize Documents Download Bank Statement
70 New Company File
Enter Data From Bank Statement for Month One Into QuickBooks
5 Enter Data From Bank Statement for Month One Into QuickBooks
80 Bank Statement Overview
85 Enter Deposits From Bank Statement First Month
87 Entering Cash Outflows Strategy
88 Entering Cash Outflows Part 1
89 Entering Cash Outflows Part 2
90 Review Reports After Data Entry For First Month
Bank Reconciliation For Month One In QuickBooks
6 Bank Reconciliation For Month One In QuickBooks
92 Bank Reconciliation Overview
94 Bank Reconciliation First Month
Enter Data From Bank Statement for Month Two In QuickBooks
7 Enter Data From Bank Statement for Month Two In QuickBooks
100 Enter Transactions Second Month Setup Process
102 Enter Deposits From Bank Statement Second Month
104 Enter Cash Outflows From Bank Statement Second Month Part 1
106 Enter Cash Outflows From Bank Statement Second Month Part 2
108 Review Reports After Entering Data From Bank Statement For Second Month
Bank Reconciliation For Month Two In QuickBooks
8 Bank Reconciliation For Month Two In QuickBooks
110 Bank Reconciliation First Second
Payroll Options and Data Entry Using QuickBooks
9 Payroll Options and Entry Using QuickBooks
PDF - 120 Payroll Options
120 Payroll Options
122 Categorize Payroll Payments
123 QuickBooks Desktop Version Payroll Example
125 Add Employees
127 Process Payroll
127.2 Process Payroll Plain Payroll
127.4 Payroll Tax Forms & Payment Set Up
127.6 Payroll Forms After Plain Payroll Financials & 941
128 QuickBooks Online Process Paid Payroll Example
Equipment and Financing Options and Data Entry Using QuickBooks
10 Equipment and Financing Options and Entry Using QuickBooks
PDF - 130 Equipment Financed Options
130 Equipment Financed Options
132 Equipment Financed Record Amount Paid
136 Equipment Financed Record Loan
Loan Payments Options and Data Entry Using QuickBooks
11 Loan Payments Options and Data Entry Using QuickBooks
PDF - 140 Loan Payment Options
140 Loan Payment Options
142 Enter Loan Balance Record Payments as Reduction To Loan Balance
143 Loan Amortization Interest vs Principal
146 Enter Loan Balance & Break Out Interest & Principal Portion Of Loan Paymen
Insurance Payments Options and Data Entry Using QuickBooks
12 Insurance Payments Options and Data Entry Using QuickBooks
PDF - 150 Insurance Options
150 Insurance Options
152 Enter All Insurance Payments As Insurance Expense & Let Accountant Adjust I
154 Enter All Insurance Payments As Prepaid Insurance & Let Accountant Make Ye
Credit Card Options and Data Entry Using QuickBooks
13 Credit Card Options and Data Entry Using QuickBooks
PDF - 160 Credit Card Options
160 Credit Card Options
162 Enter Credit Card Payments The Easy Method
164 Enter Credit Card Payments As They Clear Bank & Assign Expense Accounts Ba
166 Enter Credit Card Liability & Apply Payments To The Liability Account
Invoice and Accounts Receivable Options and Data Entry Using QuickBooks
14 Invoice and Accounts Receivable Options and Data Entry Using
PDF - 170 Invoicing and AR Options

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Focuses on a cash basis system, which is a practical approach for many small businesses using QuickBooks Online
Covers the responsibilities of both the bookkeeper and the business, fostering a clear understanding of roles in a bookkeeping engagement
Includes downloadable Excel practice files with preformatted worksheets, offering hands-on experience and reinforcing learning
Explores various options for handling payroll, equipment, loans, insurance, and credit card payments, allowing for customization based on specific needs
Discusses the importance of networking with tax professionals for year-end adjusting entries, highlighting the collaborative nature of bookkeeping
Requires learners to have QuickBooks Online, which may pose a barrier to entry for some students who do not already have a subscription

Save this course

Save QuickBooks Online-Bookkeeping Business-Easy Way to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in QuickBooks Online-Bookkeeping Business-Easy Way with these activities:
Review Basic Accounting Principles
Reinforce your understanding of fundamental accounting concepts to better grasp the nuances of QuickBooks Online's bookkeeping system.
Show steps
  • Review the definitions of assets, liabilities, and equity.
  • Study the difference between cash and accrual accounting.
  • Practice journal entries for common business transactions.
Read 'Bookkeeping for Dummies'
Gain a broader understanding of bookkeeping principles to complement the QuickBooks Online-specific knowledge taught in the course.
Show steps
  • Read the chapters on setting up a chart of accounts.
  • Study the sections on recording transactions and preparing financial statements.
  • Take notes on key concepts and definitions.
Set up a sample company file in QuickBooks Online
Practice setting up a new company file in QuickBooks Online to familiarize yourself with the initial configuration process.
Show steps
  • Create a new QuickBooks Online account (trial version is sufficient).
  • Configure the company settings, including industry and business type.
  • Set up a basic chart of accounts relevant to a small business.
  • Customize the dashboard to display key financial information.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Reconcile bank statements in QuickBooks Online
Master the bank reconciliation process in QuickBooks Online to ensure accurate financial records.
Show steps
  • Download sample bank statements from online resources.
  • Enter transactions from the bank statement into QuickBooks Online.
  • Perform the bank reconciliation process, identifying and resolving discrepancies.
  • Review the reconciliation report to ensure accuracy.
Create a cheat sheet for common QuickBooks Online shortcuts
Compile a list of useful QuickBooks Online shortcuts to improve efficiency and speed up data entry.
Show steps
  • Research common QuickBooks Online shortcuts.
  • Organize the shortcuts by category (e.g., navigation, data entry, reporting).
  • Create a visually appealing cheat sheet using a word processor or graphic design tool.
  • Share the cheat sheet with other students in the course.
Explore 'QuickBooks Online for Dummies'
Deepen your understanding of QuickBooks Online's features and functionalities beyond the specific bookkeeping system taught in the course.
Show steps
  • Read the chapters on advanced features, such as inventory management and payroll.
  • Explore the sections on troubleshooting common issues and errors.
  • Experiment with different features and settings in QuickBooks Online.
Develop a month-end reporting package for a sample client
Create a professional-looking month-end reporting package to showcase your bookkeeping skills to potential clients.
Show steps
  • Select a sample client and gather relevant financial data.
  • Generate key financial reports in QuickBooks Online, such as the income statement and balance sheet.
  • Analyze the reports and identify key trends and insights.
  • Create a summary report highlighting the key findings and recommendations.
  • Package the reports and summary into a professional-looking document.

Career center

Learners who complete QuickBooks Online-Bookkeeping Business-Easy Way will develop knowledge and skills that may be useful to these careers:
Bookkeeper
A bookkeeper is responsible for recording financial transactions, and this course directly prepares you for the role. This course teaches a simplified cash basis bookkeeping system using QuickBooks Online, which is especially useful for small businesses. A bookkeeper often works with a business owner and a tax professional, and this course explicitly addresses those relationships. The course provides practice entering data directly from bank statements for multiple months, performing bank reconciliations, and handling payroll, equipment, loan payments, insurance, credit cards, and invoices all within QuickBooks. These are all critical skills for a bookkeeper. Also, the course discusses generating month-end and year-end reports for clients and tax preparation.
Small Business Owner
This course is valuable for a small business owner, who often handles their own finances. The course teaches the essentials of using QuickBooks Online to manage finances, from recording transactions to generating financial statements. A small business owner will find the modules on setting up a company file, entering data from bank statements, and performing bank reconciliations especially practical. Training in handling payroll, equipment, loans, insurance, and credit card payments will also be quite useful. The course prepares a small business owner to understand all the financial reports a business might need, including those for tax preparation.
Data Entry Clerk
A data entry clerk is responsible for entering data into accounting systems, and this course provides an introduction to this function. This course focuses on cash basis accounting using QuickBooks Online, making it immediately relevant for a data entry clerk. The course directly addresses entering data from bank statements, including deposits and outflows. The course also covers entering transactions such as payroll, equipment purchases, loans, and credit cards. A data entry clerk may use the skills in this course to improve accuracy and speed.
Accounting Assistant
An accounting assistant provides support to accounting departments and this course offers valuable training for the role. This course includes practical training in QuickBooks Online with a focus on the cash basis system. An accounting assistant may find this beneficial, as many companies utilize QuickBooks for managing their finances. The course covers entering data, performing reconciliations, and generating reports, all typical tasks expected of an accounting assistant. The discussion of different types of transactions, such as payroll, loans, and credit card charges, will help someone be more confident in performing their daily duties. This course will give an accounting assistant a more thorough view of their work.
Accounting Clerk
An accounting clerk assists with recording financial transactions, and this course offers a solid foundation in QuickBooks that can help someone enter this field. The course focus on entering data directly from bank statements, using a cash basis bookkeeping approach, which is a common task for an accounting clerk. The course provides hands on practice with bank reconciliations, handling various transactions such as payroll, equipment purchases, loan payments, insurance, and credit card charges. All of these are relevant to an accounting clerk's daily tasks. Also, this course covers generating reports, which is a key component of the accounting process. Learning how to use QuickBooks is a significant asset.
Payroll Administrator
A payroll administrator is responsible for processing payroll, and this course provides essential insights into managing payroll within QuickBooks. This course covers various payroll options, including working with a third party payroll company and processing payroll directly in QuickBooks. It provides the basics of payroll data entry, which helps a payroll administrator understand where the data goes. The course also discusses how to categorize payroll payments, helping with the initial setup of payroll accounting. Knowledge of QuickBooks Online is beneficial for a payroll administrator.
Office Manager
An office manager often handles various administrative and financial tasks for a small business, and this course can help build relevant skills. Learning the bookkeeping system in QuickBooks, as emphasized in this course, can enhance the office manager's ability to handle basic financial transactions. The skills taught will help with tasks such as entering data from bank statements, bank reconciliations, and generating reports. An office manager may also find the modules on payroll, equipment, loans, insurance, and credit card payments quite helpful. This foundational knowledge of accounting is a valuable asset to an office manager.
Staff Accountant
A staff accountant handles daily accounting tasks, and this course may help with the use of QuickBooks. This course provides practical training working with QuickBooks to manage financial data. The course provides hands-on practice with entering data, reconciling bank accounts, and generating reports. It also covers various kinds of transactions such as insurance, loans, and credit cards. The training in generating and understanding reports, as taught in this course, will help a staff accountant be more effective in their role. While a staff accountant typically requires a bachelor's degree, this course may be useful toward gaining practical skills.
Tax Preparer Assistant
A tax preparer assistant helps with tax preparation, and this course may help them understand the preliminary steps in the tax filing process. A tax preparer assistant often works with client financial records, and this course teaches them how those records are created in QuickBooks. The course covers entering financial data, reconciling bank accounts, and generating month-end and year-end reports, all of which are crucial for tax preparation. The course also touches on adjusting entries, which gives insight into the year-end accounting process. Understanding how the data is organized in Quickbooks may help a tax preparer assistant do their work more efficiently and effectively.
Administrative Assistant
An administrative assistant performs various clerical tasks, and this course may be helpful for some of the work they do. Many administrative assistants handle basic financial tasks, and this course provides a foundation in QuickBooks Online. The course focuses on the cash basis method, which is common for small businesses. This course covers data entry, reconciling accounts, and generating basic reports all within the QuickBooks platform. This course also provides a basic understanding of payroll, loans, insurance, and credit card transactions. The skills learned here can enhance an administrative assistant's capacity.
Financial Data Analyst
A financial data analyst works with financial information to find trends, and this course may be useful in building a foundation for data collection. While this course focuses on bookkeeping, the skills learned here can help a financial data analyst understand the sources of financial data. Using QuickBooks to enter transactions, generate reports, and work with financial statements provides a picture of how financial data is created and used. The focus on bank reconciliations and handling various transactions will help someone better understand the data they may later need to analyze. This understanding may help a financial data analyst refine their research inquiries.
Financial Analyst
A financial analyst interprets financial data to provide insights, and this course may help them understand the nature of the data they will work with. This course emphasizes how financial data is organized within QuickBooks, from entering transactions to generating reports. While not directly related to analysis, the skill of understanding data organization is valuable. This course covers bank reconciliations and various transaction types giving a financial analyst a clearer picture of how data is collected in practice. A basic understanding of financial processes can help a financial analyst refine their questions and work more efficiently.
Business Operations Specialist
A business operations specialist works to improve business efficiency, and this course may help with a business's financial processes. This course demonstrates a simple accounting system using the cash basis within QuickBooks. This system might be implemented by a business operations specialist looking to streamline finances for a small business. The course covers key topics like data entry, bank reconciliations, and report generation. It also discusses handling entries for payroll, equipment, loans, and credit cards. A business operations specialist may use this course to understand and improve financial processes.
Project Manager
A project manager oversees projects and budgets, and this course may help with project budget tracking. The course teaches how to use QuickBooks to track financial transactions, which include revenues and expenses, for a project, which will allow for a project manager to better understand a project's overall financial situation. This course covers entering various kinds of transactions, generating reports, and reconciling bank accounts. The course also discusses month end and year end accounting reports and their uses. All these are important to ensure a project completes on time and within budget.
Business Consultant
A business consultant advises businesses on best practices, and this course may be useful for analyzing data. By learning how financial data is input and managed in QuickBooks, a business consultant may better understand the systems used by small businesses. An understanding of the bookkeeping process taught in this course may help a business consultant make more informed recommendations. The course teaches how the data is used to generate reports and the relationship between bookkeeping and year-end taxes. A business consultant who possesses financial literacy will be more effective.

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in QuickBooks Online-Bookkeeping Business-Easy Way.
Serves as a comprehensive guide to using QuickBooks Online, covering a wide range of features and functionalities. It provides step-by-step instructions and practical examples to help users navigate the software effectively. While the course provides a specific bookkeeping system, this book offers a broader perspective on QuickBooks Online's capabilities. It is particularly useful for exploring advanced features and troubleshooting common issues.
Provides a comprehensive overview of bookkeeping principles, making it an excellent resource for beginners. It covers essential topics such as setting up a chart of accounts, recording transactions, and preparing financial statements. While the course focuses on QuickBooks Online, this book offers valuable background knowledge and context. It is particularly helpful for those who are new to bookkeeping and need a solid foundation before diving into the software.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser