Who this course is for:

• Accountants
• Bookkeepers
• Business owners

What you’ll learn: 

• The process of creating an accounting system using QuickBooks Desktop, QuickBooks Online, and Excel
• The core financial statement reports, the balance sheet, and the income statement or Profit and Loss

Requirements: 

• No prior knowledge is required to take this course

Software version used in the course:

• QuickBooks Desktop 2022

This course will compare the process of creating an accounting system using QuickBooks Desktop and Excel. Because Excel is a much more transparent tool, it will provide us a much better understanding of the workings of QuickBooks

Excel components of the course 

In the Excel sections, we will build an accounting system starting with a blank Excel worksheet, creating a general journal, a general ledger, a trial balance, subledgers, and financial statements.

For each new step in the process, you will have access to a downloadable Excel Workbook, containing at least two tabs, one with the answer, the new steps having been completed, the other starting out where the prior presentation left off.

Once we have created our accounting system worksheet, we will use it to record common transactions, entering the journal entries into the general journal, posting to the general ledger, creating the trial balance, adjusting the subsidiary ledgers, and constructing the financial statements.

As we enter each transaction, we will consider the data input often used in accounting software like QuickBooks. Accounting software will use data input forms like bills, invoices, credit memos, checks, sales receipts, and more, to simplify the data input process, allowing users with little accounting experience to learn data input.

Accountants are generally more valuable when they understand both the accounting theory, the impact on financial statements of each transaction, as well as how an accounting database program like QuickBooks works, including the data input forms used to enter normal financial transactions.

Because spreadsheets are so transparent, they are the perfect tool to gain an understanding of both accounting theory and accounting software.

Conversely, building an accounting system in Excel is a great way, one of the best ways, to improve your Excel skills.

QuickBooks Desktop components of the course

These sections will cover the fundamentals of QuickBooks, the things you need to know to get up and running.

We will first talk about how to get access to QuickBooks, possibly with the 30-day free trial often offered by QuickBooks.

We will practice navigating the software, locating the settings, the general ledger and other core lists, the reports, and the primary forms used to enter financial transactions.

We will break the accounting process down into accounting cycles, including the revenue or accounts receivable cycle, the purchases or expense or accounts payable cycle, and the payroll or employee cycle.

Thinking about the accounting process by cycle is much easier to visualize, the data input forms falling into place, the order and linking of many data input forms becoming much clearer.

This course will demonstrate the core financial statement reports, the balance sheet, and the income statement or profit and loss. We will then look at many other reports, considering how most will expand on, and provide more information to line items on the primary financial statement reports, the balance sheet, and income statement, or profit and loss.

Our Promise to You

By the end of this course, you will have learned how to create an accounting system. 

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

 Get started today!