Intermediate QuickBooks 2017
This comprehensive online course introduces additional features that will help you get the most out of your QuickBooks 2017 software. You will learn how to manage multiple company files, export and import list data from one file to another, and make journal entries. If your business handles inventory, you will learn how to enter price levels and track discounts and credits. You will even learn how to track mileage on vehicles you use in your business.
This course also covers many other common topics that small business owners encounter, including creating customer statements, assessing finance charges on overdue balances, using QuickBooks' batch invoicing features to create multiple invoices, and writing off past due balances when the customer won't pay.
This course is designed for those who already have a good grasp on the basics of this program or have successfully completed the Introduction to QuickBooks course. Whether you're a small-business owner, or bookkeeper or accountant needing a QuickBooks refresher, this course will make you more confident and secure in accounting for your business.
What you will learn
- Learn to manage multiple company files, export and import list data from one file to another, and make journal entries
- Find out how to enter price levels and track discounts and credits
- Learn how to track mileage on vehicles you use in your business
- Understand how to create customer statements, assess finance charges on overdue balances, create multiple invoices, and write off past due balances
- Learn how to enter common owner transactions
- Understand how to track loans and use the budgeting feature
How you will benefit
- Become more confident and secure in accounting for your business
- Open the door to additional career opportunities as you accurately learn how to use all the features of QuickBooks
- Master the use of QuickBooks for your personal business
How the course is taught
- Instructor-led or self-paced online course
- 6 Weeks or 3 Months access
- 24 course hours
One of the more challenging aspects of QuickBooks is learning how to manage company files. This lesson introduces some great features that allow you to easily work with not just one, but multiple company files. You will even learn how to export and import list information from other files into a brand-new file.
Taking steps to secure your company files is one of the easiest and most effective ways to make sure your file doesn't get mishandled or corrupted in some way. In this lesson, you will learn how to set a closing date in your file so that no one can enter a transaction in the wrong period.
Lists form the backbone of QuickBooks. In this lesson, you will learn how to add and edit multiple list items. You will also learn how to create class items to further categorize transactions. Finally, you will discover how to enter inventory part items and how to combine these items into inventory assemblies.
Tracking inventory in QuickBooks is a multi-step process. This lesson introduces entering and using Sales Orders to keep track of customer orders. And to help you keep track of it all, you will learn how to use the Inventory Center in QuickBooks to view transactions, edit items, and produce reports.
If you work with the same vendors over and over again, you may receive discounts and earn credits. In this lesson, you will learn how to record these discounts. You will also learn how to enter and manage vendor credits when they arise.
Not all customers are created equal. Many businesses charge different prices to different customers for a number of reasons. In this lesson, you will learn how to create price levels either on a fixed percentage or on an item basis that you can assign to a particular customer.
If you ever have to travel by car to a job site or project, you may want to track the vehicle mileage so that you can later deduct it on your tax return. In this lesson, you will learn how to enter this mileage and the rate the IRS allows for a deduction.
Sometimes you may need to bill a customer without needing to create a full-blown invoice. In this lesson, you will learn how to create a statement and charge directly to a customer's account. You will also learn how to change the price of multiple sales items using QuickBooks' Chanage Item Prices feature.
This lesson introduces QuickBooks' batch invoicing features to create multiple invoices at the same time to send to any of your customers. You will also learn how to modify a letter template and then create a form letter that you can send to your customers or vendors.
Most small businesses carry a small amount of cash on hand to pay for odds and ends. In this lesson, you will learn how you can use QuickBooks to track petty cash amounts. You will also become proficient in making entries to record when a customer redeems one of these gift cards or certificates.
In this lesson, you will learn how to record an owner's infusion of capital into the business. You will also learn how to record transactions where the owner withdraws money from the company's bank account.
In this lesson, you will learn how to enter a long-term loan in which you use the proceeds of the loan to purchase an asset in your business. You will then learn how to track this loan using the Loan Manager feature to split apart the principal and interest portions of the loan payment.
Scott Paxton is a Certified Public Accountant and holds master's degrees in business administration and accounting. His background includes experience as a public accountant, a manager in the banking industry, an entrepreneur and a college business instructor. Paxton has also spent much of his career helping small business owners successfully implement and troubleshoot QuickBooks.
- This course must be taken on a PC. It is not suitable for Macs.
- Windows 8 or newer.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- The desktop version of QuickBooks Premier Edition 2017 is recommended for this course (not included in enrollment). QuickBooks Pro 2017 can be used, but please be aware that there are some features discussed in the course that are not available in the Pro edition. However, the course lessons have been modified to accommodate Pro version users. The Enterprise version of the software can also be used.
- Note that while this course is based on the U.S. version of QuickBooks, users of the Canadian and Australian versions will be supported in the Discussion Areas to the extent possible.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
- Email capabilities and access to a personal email account.
This course is designed for those QuickBooks users that already feel that they have a good grasp on the basics or have successfully completed Introduction to QuickBooks.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Instructor-Led: A new session of each course begins each month. Please refer to the session start dates for scheduling.
Self-Paced: You can start this course at any time your schedule permits.
Instructor-Led: Once a course session starts, two lessons will be released each week for the 6 week duration of your course. You will have access to all previously released lessons until the course ends.
Self-Paced: You have 3 month access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period.
Instructor-Led: The interactive discussion area for each lesson automatically closes two weeks after each lesson is released, so you're encouraged to complete each lesson within two weeks of its release.
Self-Paced: There is no time limit to complete each lesson, other than completing all lessons within the allotted access period.
Instructor-Led: The final exam will be released on the same day as the last lesson. Once the final exam has been released, you will have two weeks plus 10 days (24 days total) to complete the final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.
Self-Paced: Because this course is self-paced, no extensions will be granted after the start of your enrollment.
QuickBooks is the top selling accounting software for small and medium businesses in the United States. There are nearly 29 million businesses that use QuickBooks today. It is a software that can be used to keep track of the financial documents in companies across any industry, and you can be sure that learning to effectively and efficiently use the QuickBooks software will open up doors to new jobs as a professional bookkeeper or allow you to manage the finances of your own small business. You can also use QuickBooks to keep track of your finances at home.
Yes, QuickBooks can be used to keep track of your finances and produce reports of your financial documents. You can also use QuickBooks to do payroll, track PTO, calculate tax payments, create budgets, print invoices and receipts, forecast revenue, and report on the overall profitability of your company. Understanding this valuable software will help you save time in completing financial records, and free you to focus on other important areas like product, sales, or customer service.
According to the Bureau of Labor Statistics, there is a lot of need for bookkeepers, and the job outlook is expected to remain relatively constant through 2026. Understanding how to efficiently use bookkeeping software like QuickBooks will help you as more and more businesses turn to technology to perform basic accounting tasks.
Not exactly. There are five major parts to the accounting process and they include: recording, interpreting, classifying, analyzing, and reporting financial information. Bookkeeping is the first, foundational part of the accounting process — recording financial transactions.
You'll gain the skills you need to create and stick to a budget within this powerful software. You'll learn to record income and expenses including all of your banking transactions. You can even set up reports that will show you where the majority of your money is being spent.