What you'll learn

How to outline a simple bookkeeping system for a small business using QuickBooks
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 and store it on a computer
How to use an easy method to enter financial data into QuickBooks 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
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
How to enter equipment purchases into QuickBooks
How to enter loan payments into QuickBooks
How to enter insurance payments into QuickBooks
How to enter credit card charges into QuickBooks
How to format month-end and year-end reports
How to enter adjusting entries into QuickBooks and work with accounting firms, CPA firms, or tax preparer to help with them

Requirements

We should be familiar with QuickBooks and or accounting.

Description

QuickBooks bookkeeping business designed for small business 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 will we be learning from?

You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together curriculum.

You will be learning from somebody who is a:

• CPA – Certified Public Accountant

• CGMA – Chartered Global Management Accountant

• Master of Science in Taxation

• CPS – Certifies Post-Secondary Instructor

• Curriculum Development Export

As a practicing CPA the instructor has worked with many technical accounting issues and helped work through them and discuss them with clients of all levels.

As a CPA and professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.

The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also benefit in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro.

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

Download Part 01
Download Part 02
Download Part 03
Download Part 04