Book Image

Mastering QuickBooks 2021 - Second Edition

By : Crystalynn Shelton
Book Image

Mastering QuickBooks 2021 - Second Edition

By: Crystalynn Shelton

Overview of this book

Intuit QuickBooks is an accounting software package that helps small business owners to manage all their bookkeeping tasks independently. This latest edition of Mastering QuickBooks takes you through the range of new features and updates available in QuickBooks Online (QBO). Creating multilingual invoices, tracking mileage, working with a cash flow dashboard that helps you with cash forecasting and planning reports, and uploading a batch of bills and checks are just a few of the new features covered in this edition. As you progress, you’ll learn how to manage sales tax, including how to set up, collect, track, pay, and report sales tax payments. Dedicated sections will also take you through new content focused on the latest features in the QBO line-up, while also showing you the different types of businesses that can benefit from QBO Advanced. In addition to this, you’ll explore how to export reports to Google Sheets, use the custom chart builder, import budgets, perform smart reporting with Fathom, and much more. By the end of this QuickBooks book, you'll be well-versed with the features of QuickBooks and have the confidence to manage all your bookkeeping tasks with ease.
Table of Contents (26 chapters)
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

Exporting reports to Excel

As discussed in the previous section, if you need the ability to manipulate the data on a report or add additional columns and rows, you can export reports to Excel.

Follow these steps to export a report to Excel:

  1. Navigate to the reports center by clicking on Reports on the left menu bar, as follows:

  1. Select the reporting group that includes the report you wish to run, as follows:

  1. Choose the report you wish to run, as follows:

  1. The report will be displayed on your screen:

  1. Click on the icon that resembles a sheet of paper with an arrow going through it, as shown in the following:

  1. Choose Export to Excel, as follows:

  1. Your report should display in Excel, as follows:

At this point, you can save the report to your computer and make any necessary changes. 

If the report does not immediately display on your screen, look at the very bottom of the screen and there should be an Excel icon. Click on it to display the report in Excel...