Get Full Access to Every Course

This is the second part of the course QuickBooks Desktop vs Excel 2022 # 1 Navigation, Forms, & Reports. This course will compare the process of creating an accounting system in both 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 The following section will discuss what the Excel components of the course will cover. In this course 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 and 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. The following section will discuss what the QuickBooks Desktop component of the course will cover. This course will cover the fundamentals of QuickBooks desktop, the things you need to know to get up and running. We will first talk about how to get access to QuickBooks Desktop, possibly with the 30-day free trial often offered by QuickBooks, the 30-day free trial being a perfect tool for a course like this. Using the sample company file provided 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.