Course curriculum

  • 04
    Create New Company File & QuickBooks File
    Show Content
    • 4 Create New Company File & QuickBooks File
    • PDF - 30 Outline Sample Engagement
    • 30 Outline Sample Engagement
    • 60 New Company File
    • 70 New Company File
    • Accounting Comic Break
  • 05
    Enter Data From Bank Statement for Month One
    Show Content
    • 5 Enter Data From Bank Statement for Month One
    • 80 Bank Statement Overview
    • 82 Enter Deposits Plan
    • 85 Enter Deposits From Bank Statement First Month
    • 87 Entering Cash Outflows Strategy
    • 88 Entering Cash Outflows Strategy Part 1
    • 88 Entering Cash Outflows Part 2
    • 90 Review Reports After Data Entry For First Month
    • Accounting Comic Break
  • 06
    Bank Reconciliation For Month One
    Show Content
    • 6 Bank Reconciliation For Month One
    • 92 Bank Reconciliation Overview
    • 94 Bank Reconciliation First Month
    • Accounting Comic Break
  • 07
    Enter Data From Bank Statement for Month Two
    Show Content
    • 7 Enter Data From Bank Statement for Month Two
    • 100 Enter Deposits Second Month Setup Process
    • 102 Enter Deposits From Bank Statement Second Month
    • 104 Enter Cash Outflows From Bank Statement Second Month Part 1
    • 104 Enter Cash Outflows From Bank Statement Second Month Part 2
    • 108 Review Reports After Entering Data From Bank Statement For Second Month
    • Accounting Comic Break
  • 08
    Bank Reconciliation For Month Two
    Show Content
    • 8 Bank Reconciliation For Month Two
    • 110 Bank Reconciliation First Second
    • Accounting Comic Break
  • 09
    Outline Bookkeeping Options and Questions
    Show Content
    • 9 Outline Bookkeeping Options and Questions
    • 117 Adjust Open Items and Common Problems
    • 115 Back Up QuickBooks File Copy QuickBooks File
    • 116 Restore Backup File
    • Accounting Comic Break
  • 10
    Payroll Options and Entry
    Show Content
    • 10 Payroll Options and Entry
    • PDF - 120 Payroll Options
    • 120 Payroll Options
    • 122 Categorize Payroll Payments
    • 123 Turn On Manual Payroll
    • 125 Add Employees
    • 127 Process Payroll
    • Accounting Comic Break
  • 11
    Equipment and Financing Options and Entry
    Show Content
    • 11 Equipment and Financing Options and Entry
    • PDF - 130 Equipment Financed Options
    • 130 Equipment Financed Options
    • 132 Equipment Financed Record Amount Paid
    • 136 Equipment Financed Record Loan
    • Accounting Comic Break
  • 12
    Loan Payments Options and Entry
    Show Content
    • 12 Loan Payments Options and Entry
    • 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 Payments
    • Accounting Comic Break
  • 13
    Insurance Payments Options and Entry
    Show Content
    • 13 Insurance Payments Options and Entry
    • PDF - 150 Insurance Options
    • 150 Insurance Options
    • 152 Enter All Insurance Payments As Insurance Expense & Let Accountant Adjust If Needed
    • 154 Enter All Insurance Payments As Prepaid Insurance & Let Accountant Make Year End Adjustment
    • Accounting Comic Break
  • 14
    Credit Card Options and Entry
    Show Content
    • 14 Credit Card Options and Entry
    • PDF - 160 Credit Card Options
    • 160 Credit Card Options
    • 162 Enter Credit Card Payments To Credit Card Expense Account & Break Out Categories Expense Outs
    • 164 Enter Credit Card Payments As They Clear Bank & Assign Expense Accounts Based On Credit Card
    • 166 Enter Credit Card Liability & Apply Payments To The Liability Account
    • Accounting Comic Break
  • 15
    Invoice and Accounts Receivable Options and Entry
    Show Content
    • 15 Invoice and Accounts Receivable Options and Entry
    • PDF - 170 Invoicing and AR Options
    • 170 Invoice & Accounts Receivable Options
    • 172 Invoice Outside QuickBooks & Track Payments Manually Or In Excel
    • 176 Enter Invoices Into The System & Track Accounts Receivable
    • Accounting Comic Break
  • 16
    Adjust Remaining Outstanding Items / Data Entry Questions
    Show Content
    • 16 Adjust Remaining Outstanding Items Data Entry Questions
    • PDF - 180 Adjust Open Items
    • 181 Adjust Open Items Simple Method
    • 182 Adjust Open Items More Complex File
    • 183 Net Income Reconciliation Between Method
    • Accounting Comic Break
  • 17
    Creating & Formatting Month End Reports
    Show Content
    • 17 Creating & Formatting Month End Reports
    • PDF - 185 Month End Documents
    • 185 Month End Documentation
    • 187 Create Customer Backup File
    • 187 Formatting Month End Documents PDF & Excel
    • 188 Formatting, Presenting, & Delivering Reports to Clients
    • Accounting Comic Break
  • 18
    Creating & Formatting Year End Reports
    Show Content
    • 18 Creating & Formatting Year End Reports
    • PDF - 190 Year End Documents
    • 190 Year End Documentations
    • 192 Year End Documentations
    • Accounting Comic Break
  • 19
    Describing and Entering Adjusting Entries
    Show Content
    • 19 Describing and Entering Adjusting Entries
    • PDF - 210 Adjusting Entry Options
    • 210 Adjusting Entries Options
    • 211 Adjusting Entries Worksheet
    • 212 Payroll Adjusting Entries Simple Method
    • 213 Payroll Adjusting Entries More Complex Method Q2
    • 214 Equipment Adjusting Entries Simple Method
    • 215 Equipment Adjusting Entries More Complex Method
    • 217 Loan Payment Adjusting Entries Simple Method Q1
    • 219 Insurance Adjusting Entries Simple Method Q1
    • 220 Insurance Adjusting Entries More Complex Method Q3
    • 221 Credit Card Adjusting Entries Simple Method Q1
    • 223 Compare Completed Trial Balance Under Both Methods
    • Accounting Comic Break
  • 20
    Options for Recording Adjusting Entries in QuickBooks
    Show Content
    • 20 Options for Recording Adjusting Entries in QuickBooks
    • PDF - 240 Adjusting Entry Options
    • 240 Options For Entering Adjusting Entries To QuickBooks
    • Accounting Comic Break

Course Description

QuickBooks bookkeeping business designed for bookkeepers focusing on small busness clients.

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.

The course will then compare and contrast our different bookkeeping methods and show how those different bookkeeping decisions reconcile to the same numbers after the adjusting entry process.

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  

•    QuickBooks Backup files

•    Excel practice files

•    Downloadable PDF Files  

The QuickBooks backup files are a great tool that allows us to jump ahead in the material or to rework material if we choose.

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 is the target audience?
  • Bookkeepers who want do design a bookkeeping business using QuickBooks
  • Small business owners who want a simple system to enter data into QuickBooks to help year-end tax preparation & regulatory needs
  • Small business owners who want to learn how best to work with a bookkeeper and or year-end accounting firm and tax preparer
  • Students who want to understand bookkeeping from a practical perspective

Robert (Bob) Steele CPA CGMA CPI MStax

Instructor

Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).

Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.

In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele’s teaching philosophy is to make content applicable, understandable, and accessible.

Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.

Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.

Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.

Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.

The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.

Mr. Steele makes learning accounting accessible by making use of technology and partnering with teaching platforms that have a vision of spreading knowledge.