Book Image

Mastering QuickBooks 2022 - Third Edition

By : Crystalynn Shelton
Book Image

Mastering QuickBooks 2022 - Third Edition

By: Crystalynn Shelton

Overview of this book

Whether you have bookkeeping experience or not, handling the financial side of your growing business requires expertise. With Mastering QuickBooks® 2022, Third Edition, you’ll learn how to use QuickBooks® to build the perfect budget, simplify tax return preparation, manage inventory, track job costs, generate income statements and financial reports, and perform all accounting-related tasks with ease. Throughout the book, you’ll be guided by an experienced Certified Public Accountant and Advanced Certified QuickBooks ProAdvisor – from setup to core features and beyond. This new edition has every chapter revised to cover a range of new features and updates available, including smart invoicing and cash flow projections. You'll learn how to create multilingual invoices, track mileage, work with a cash flow dashboard that helps you with cash forecasting and planning reports, and upload batches of bills and checks. This book will also teach you how to manage sales tax, including how to set up, collect, track, pay, and report sales tax payments. In addition to this, you’ll explore how to export reports to Google Sheets, use the custom chart builder, import budgets, and perform smart reporting. By the end of this book, you'll be well-versed with QuickBooks and have the confidence to manage all your bookkeeping tasks with ease.
Table of Contents (27 chapters)
Free Chapter
1
Section 1: Setting Up Your Company File
8
Section 2: Recording Transactions in QuickBooks Online
13
Section 3: Generating Reports in QuickBooks Online
18
Section 4: Managing Employees and Contractors
21
Section 5: Closing the Books and Handling Special Transactions
24
Other Books You May Enjoy
25
Index

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, QuickBooks Online Advanced, includes 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, how to add custom fields, how to manage customized user permissions, what workflow automation is and how to use it, how to import invoices and budgets, and much more.

Chapter 3, 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 4, 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 5, 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 6, 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 7, 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 8, 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 9, 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 10, Reconciling Downloaded 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 11, 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 12, 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 13, 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 14, 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 15, Managing Payroll in QuickBooks Online, shows you how to set up your payroll system, how to generate payroll, and how to fill payroll tax forms and payments.

Chapter 16, Managing 1099 Contractors in QuickBooks Online, talks about how to set up 1099 contractors, tracking and paying 1099 contractors, and how to generate the 1099 year-end report.

Section 5: Closing the Books and Handling Special Transactions

Chapter 17, 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 18, Handling Special Transactions in QuickBooks Online, starts by showing you how to use apps in QuickBooks Online. Apps are a great way to help you streamline day-to-day business tasks that can be time-consuming. It also covers how to record credit card payments from customers, keep track of petty cash, and record delayed charges.

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.