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

Report Center Overview

Now that you know how to enter income and expenses into QuickBooks, it’s time to learn how to generate reports to gain insight into the overall health of your business. In this chapter, we will show you how to navigate through the Report Center and give you an overview of the reports available. In addition, we’ll show you how to customize reports to meet your business needs. We will also cover how to share reports with your accountant and business stakeholders.

Understanding how to run reports will help you to gain insight into all aspects of your business. Having access to your income, expenses, and other key performance indicators will help you to make good business decisions.

The following topics will be covered in this chapter:

  • Navigating the Report Center
  • Reports available in the Report Center
  • Customizing reports
  • Exporting reports
  • Sending reports via email

By the end of this chapter, you...

Reports available in the Report Center

In Chapter 1, Getting Started with QuickBooks Online, we discussed the four subscription levels you can purchase for QBO: Simple Start, Essentials, Plus, and Advanced. Depending on the subscription level you have purchased, you could have access to anywhere between 20 and 100 or more reports. Simple Start includes more than 20 reports, Essentials includes more than 40 reports, Plus includes more than 65 reports, and Advanced includes more than 100 reports.

The following is a breakdown of some of the reports you will find in each QBO subscription.

QBO Simple Start includes more than 20 reports, some of which are listed here:

Profit & Loss

Sales by Customer

Balance Sheet

Sales by Product/Services

Statement of Cash Flows

...

Customizing reports

As discussed, you don’t have to create a report from scratch in QuickBooks Online; you can customize an existing report to get the data that you need. You can save any changes you make to a report so you don’t have to recreate it each time.

The following are the steps we need to follow to customize a report:

  1. Click on Reports on the left menu bar to navigate to the Report Center, as indicated here:

Figure 10.6: Navigating to the Report Center

  1. Select the report you want to customize. In this case, we will customize the Profit and Loss report, as indicated:

Figure 10.7: Running the Profit and Loss report

  1. Click the Customize button located in the upper-right corner:

Figure 10.8: Customizing a report

  1. The following customization window will appear:

Figure 10.9: Options available to customize the report

As indicated in the preceding screenshot, there...

Exporting reports

In this section, we will cover how to export reports to Excel and PDF. In the next section, we will show you the step-by-step process of emailing reports directly from QuickBooks.

When you run a report in QuickBooks, the export data menu will automatically appear in the upper-right corner, as indicated here:

Figure 10.17: Multiple ways to export a report from QBO

The following is a brief explanation of each icon:

  • Envelope: Click on the envelope icon if you want to email a report directly from QuickBooks.
  • Printer: The printer icon is used if you would like to print a hard copy of a report.
  • Paper: The icon that resembles a sheet of paper with an arrow going through it is used to export reports to Excel or PDF.

We will discuss exporting reports to Excel first.

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...

Sending reports via email

Sending reports via email involves the same steps required to export reports to Excel and PDF format:

  1. Click on Reports on the left menu bar, make sure you have selected the right reporting group, and choose the report you wish to send.
  2. Once the report has appeared, click on the icon that resembles an envelope, as follows:

Figure 10.28: Clicking the Email report icon

  1. Click on the Email option, as follows:

Figure 10.29: Selecting the Email report option

  1. The following window will appear:

    Figure 10.30: Completing the required fields to email the report directly from QBO

    The following is a brief description of the fields that need to be completed:

    • To: Enter the email address of each recipient in this field. You can enter multiple email addresses by putting a comma in-between each one.
    • CC: Enter the email address for each recipient that needs to receive a carbon copy...

Summary

We have introduced you to the Report Center and covered all of the different types of reports available at your fingertips. You have learned how to run reports, edit the data on reports, and save your changes. We have shown you how to share your data by printing a hard copy, exporting the information to Excel, saving to PDF format, and emailing directly from QuickBooks. This will help you to safely and securely share information on a need-to-know basis instead of giving access to your company data.

In the next chapter, we will dive deeper into business overview reports. As discussed at the beginning of this chapter, business overview reports provide insight into the overall health of your business. The profit and loss statement, balance sheet report, statement of cash flows, and budgeting/forecasting tools available are included in business overview reports.

Learn more on Discord

To join the Discord community for this book – where you can share feedback...

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