Reader small image

You're reading from  Mastering Quickbooks® 2023, Fourth Edition - Fourth Edition

Product typeBook
Published inNov 2022
PublisherPackt
ISBN-139781803243634
Edition4th Edition
Right arrow
Author (1)
Crystalynn Shelton
Crystalynn Shelton
author image
Crystalynn Shelton

Crystalynn Shelton is a licensed CPA and small business advisor specializing in financial accounting software training, coaching, and consulting. She has written two Amazon Bestsellers, Mastering QuickBooks 2020 and Mastering QuickBooks 2021. In addition to having experience as a small business owner, she has more than 20 years' experience in providing accountancy consultancy in the entertainment, oil and gas, education, and computer technology fields. Crystalynn is an Advanced Certified QuickBooks ProAdvisor and has taught accounting, bookkeeping, and QuickBooks courses for the last 12 years at the University of California at Los Angeles Extension. When she is not in the classroom, Crystalynn enjoys trying new restaurants and curling up with a good book!
Read more about Crystalynn Shelton

Right arrow

Preface

Intuit QuickBooks is an accounting software package that helps small business owners manage all their bookkeeping tasks. Its complete range of accounting capabilities, such as tracking income and expenses, managing payroll, simplifying taxes, and accepting online payments, makes QuickBooks software a must-have for business owners and aspiring bookkeepers.

The goal of this book is to teach small business owners, bookkeepers, and aspiring accountants how to properly use QuickBooks Online. Using a fictitious company, we will demonstrate how to create a QuickBooks Online account; customize key settings for a business; manage customers, vendors, and products and services; enter transactions; generate reports; and close books at the end of the period. QuickBooks records debits and credits for you so that you don’t have to know accounting. However, we will show you what’s happening behind the scenes in QuickBooks so that you can understand how your actions in QuickBooks impact financial statements. We will also provide you with tips, shortcuts, and best practices to help you save time and become a QuickBooks pro.

The US edition of QBO was used to create this book. If you are using a version that is outside of the United States, results may differ.

Who this book is for

If you’re a small business owner, bookkeeper, or accounting student who wants to learn how to make the most of QuickBooks Online, this book is for you. Business analysts, data analysts, managers, professionals working in bookkeeping, and QuickBooks accountants will also find this guide useful. If you are planning to take the QuickBooks Certified User (QBCU) exam, this book is an excellent study guide. No experience with QuickBooks Online is required to get started; however, some bookkeeping knowledge would be helpful.

What this book covers

Section 1: Setting Up Your Company File

Chapter 1, Getting Started with QuickBooks Online, starts off with a brief description of QuickBooks Online, then it outlines the key features in all four editions of the software. We also explain how to choose the right edition for your business. There are step-by-step instructions on how to create a QBO account and how to navigate the software. Finally, we provide you with some basic bookkeeping knowledge to help you understand what’s going on behind the scenes in QuickBooks.

Chapter 2, Company File Setup, shows you how to customize the QuickBooks Online account created in Chapter 1 to meet your business needs. First, we explain the documents and key information you will need to have handy for the setup. Next, we walk you through all of the available preferences in QBO and explain the purpose and benefit of utilizing the various options available.

Chapter 3, Migrating to QuickBooks Online, gives you all the information required to migrate to QuickBooks Online from platforms such as Excel, QuickBooks Desktop, or another accounting/bookkeeping software.

Chapter 4, Customizing QuickBooks for Your Business, introduces customization for the chart of accounts and then dives into the different ways of connecting bank accounts and credit cards to your QuickBooks Online account, followed by granting users access to your QuickBooks data.

Chapter 5, Managing Customer, Vendor, and Products and Services Lists, gives you a detailed insight into how to manage your customers, vendors, products, and services. This includes importing customer, vendor, and product and services data from an Excel spreadsheet and manually entering it into the software.

Section 2: Recording Transactions in QuickBooks Online

Chapter 6, Managing Sales Tax, covers how to set up sales tax for the various tax jurisdictions you are required to collect sales tax for, how to create an invoice with sales tax, and what reports will help you to report and pay the appropriate sales tax amount when it becomes due.

Chapter 7, Recording Sales Transactions in QuickBooks Online, starts by giving detailed information on different forms of sales, followed by information on how the customer can record payments using different methods, and finally teaches you how to initiate refunds for your customers.

Chapter 8, Recording Expenses in QuickBooks Online, teaches you how to enter and pay bills for your QuickBooks Online account. Then, we’ll start exploring how to manage recurring expenses, followed by writing and printing checks.

Chapter 9, Reconciling Uploaded Bank and Credit Card Transactions, gives you a brief overview of the Banking Center in QuickBooks Online and gives you a deep understanding of how the bank rules work, followed by how to edit QuickBooks Online transactions, and finally how to reconcile bank accounts.

Section 3: Generating Reports in QuickBooks Online

Chapter 10, Report Center Overview, takes you through the Report Center, followed by the different reports available, how to customize and export reports, and finally how to send reports via email.

Chapter 11, Business Overview Reports, discusses the three primary reports that provide a good overview of your business: the profit and loss statement, balance sheet report, and statement of cash flows. It also covers the cash flow planner and the audit log.

Chapter 12, Customer Sales Reports in QuickBooks Online, focuses on reports that will give you insight into your customers and sales. We will discuss what information you will find on each report, how to customize the reports, and how to generate each report.

Chapter 13, Vendor and Expenses Reports, dives into what information you can expect to find in each report, how to customize the report, and how to generate it. This chapter also discusses ways that you can use the report to help you manage your expenses and cash flow.

Section 4: Managing Employees and Contractors

Chapter 14, Managing Employees and 1099 Contractors in QuickBooks Online, shows you how to set up your payroll system, generate payroll, and fill payroll tax forms and payments. This chapter also covers how to set up 1099 contractors and make payments to them.

Section 5: Closing the Books and Handling Special Transactions

Chapter 15, Closing the Books in QuickBooks Online, covers the steps needed to close your books each month or for the year; including but not limited to reconciling all bank and credit card accounts, making year-end accrual adjustments (if applicable), recording fixed asset purchases made throughout the year, recording depreciation, taking a physical inventory, adjusting retained earnings, and preparing financial statements.

Chapter 16, Finding Apps and Handling Special Transactions in QuickBooks Online, starts by showing you how to discover and install apps in QuickBooks Online. Apps are a great way to help you streamline day-to-day business tasks that can otherwise be time-consuming. It also covers how to record credit card payments from customers, keep track of petty cash, and record delayed charges.

Chapter 17, QuickBooks Online Advanced, takes a deep dive into the features included in this top-tier QuickBooks Online subscription. We show you how to access the QuickBooks Online Advanced test drive account, add custom fields, manage customized user permissions, what workflow automation is and how to use it, how to import invoices and budgets, and much more.

Appendix

At the end of the book, there is a brief section called Shortcuts and Test Drive, which summarizes the keyboard shortcuts you can use in QuickBooks Online to save time, and also provides links to the QBO test drive account as well as a QBO discount code. This is followed by the QuickBooks Certified User Exam Objectives, where you’ll find the full list of things you need to know to pass the QBCU exam, along with references to where the relevant content appears in the book – a handy reference for revision.

To get the most out of this book

This book is ideal for anyone who has accounting/bookkeeping knowledge as well as those that don’t. Each chapter builds on the knowledge and information presented in the previous chapters. If you don’t have any experience of using QuickBooks Online, we recommend you start with Chapter 1, Getting Started with QuickBooks Online, and complete the chapters in the order they are presented. If you have experience of using QuickBooks Online, feel free to advance to the chapters that cover the topics you need to brush up on.

Download additional files

The code bundle for the book is hosted on GitHub at https://packt.link/MQ23GitHub. We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!

Download the color images

We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here: https://packt.link/BjR3m.

Conventions used

Bold: Indicates a new term, an important word, or words that you see on screen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: “Click on the Accounting tab located in the left menu bar and select Chart of Accounts.”

CodeInText: Indicates text that the user should type into a field or search bar. For example: “The email address in our example is George_Jetson@thejetsons.com.”

Warnings or important notes appear like this.

Tips and tricks appear like this.

Get in touch

Feedback from our readers is always welcome. To join the Discord community for this book – where you can share feedback, ask questions to the author, and learn about new releases – follow the QR code below:

https://packt.link/businesscenter

Errata: Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you have found a mistake in this book we would be grateful if you would report this to us. Please visit http://www.packtpub.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details.

Piracy: If you come across any illegal copies of our works in any form on the Internet, we would be grateful if you would provide us with the location address or website name. Please contact us at copyright@packtpub.com with a link to the material.

If you are interested in becoming an author: If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, please visit http://authors.packtpub.com.

Download a free PDF copy of this book

Thanks for purchasing this book!

If you’d like to read on the go, or your eBook purchase is not compatible with your device, you can now get a DRM-free PDF version with any Packt book at no extra cost.

To do so, follow these simple steps:

  1. Scan the QR code or visit the link below

    https://packt.link/free-ebook/9781803243634

  2. Submit your proof of purchase
  3. That’s it! We’ll send your free PDF and other benefits to your email directly

Share your thoughts

If this book is helping you improve your skills, we’d strongly suggest leaving a review on Amazon.com. This helps us know if you like our work and if the chapter content has been valued, and also helps the buyers on Amazon know if the book is right for them.

So, everyone else benefits from your review - we wouldn’t want you to miss out. You can now reach out to review@packt.com with a screenshot of your review and the book URL, and we’ll send you a $5 voucher for your next Packt purchase. Thank you in advance for engaging with us, we are excited to see your review!

Learn more on Discord

To join the Discord community for this book – where you can share feedback, ask questions to the author, and learn about new releases – follow the QR code below:

https://packt.link/businesscenter

lock icon
The rest of the chapter is locked
You have been reading a chapter from
Mastering Quickbooks® 2023, Fourth Edition - Fourth Edition
Published in: Nov 2022Publisher: PacktISBN-13: 9781803243634
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
undefined
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime

Author (1)

author image
Crystalynn Shelton

Crystalynn Shelton is a licensed CPA and small business advisor specializing in financial accounting software training, coaching, and consulting. She has written two Amazon Bestsellers, Mastering QuickBooks 2020 and Mastering QuickBooks 2021. In addition to having experience as a small business owner, she has more than 20 years' experience in providing accountancy consultancy in the entertainment, oil and gas, education, and computer technology fields. Crystalynn is an Advanced Certified QuickBooks ProAdvisor and has taught accounting, bookkeeping, and QuickBooks courses for the last 12 years at the University of California at Los Angeles Extension. When she is not in the classroom, Crystalynn enjoys trying new restaurants and curling up with a good book!
Read more about Crystalynn Shelton