Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Mastering Quickbooks® 2023, Fourth Edition - Fourth Edition

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

Product type Book
Published in Nov 2022
Publisher Packt
ISBN-13 9781803243634
Pages 546 pages
Edition 4th Edition
Languages
Author (1):
Crystalynn Shelton Crystalynn Shelton
Profile icon Crystalynn Shelton

Table of Contents (28) Chapters

Preface 1. Section I: Setting Up Your Company File
2. Getting Started with QuickBooks Online 3. Company File Setup 4. Migrating to QuickBooks Online 5. Customizing QuickBooks for Your Business 6. Managing Customer, Vendor, and Products and Services Lists 7. Section II: Recording Transactions in QuickBooks Online
8. Managing Sales Tax 9. Recording Sales Transactions in QuickBooks Online 10. Recording Expenses in QuickBooks Online 11. Reconciling Uploaded Bank and Credit Card Transactions 12. Section III: Generating Reports in QuickBooks Online
13. Report Center Overview 14. Business Overview Reports 15. Customer Sales Reports in QuickBooks Online 16. Vendor and Expenses Reports 17. Section IV: Managing Employees and Contractors
18. Managing Employees and 1099 Contractors in QuickBooks Online 19. Section V: Closing the Books and Handling Special Transactions
20. Closing the Books in QuickBooks Online 21. Finding Apps and Handling Special Transactions in QuickBooks Online 22. QuickBooks Online Advanced 23. Shortcuts and Test Drive 24. QuickBooks Certified User Exam Objectives
25. Other Books You May Enjoy
26. Index
Appendix

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

Navigating the Report Center

In this section, we will cover how the Report Center is organized so that you can easily locate a report. The Report Center includes several pre-built reports that can give you summaries or detailed information about various aspects of your business. It is organized into three main sections: Standard, Custom reports, and Management reports. The majority of the reports are located in the Standard reports section.

To access the Report Center, follow the steps below:

  1. Click on Reports located on the left menu bar as indicated here:

Figure 10.2: Navigating to the Report Center

  1. Click on the Standard tab as indicated below:

Figure 10.3: Selecting Standard reports

  1. Standard reports are categorized into the following nine reporting groups:
    • Favorites: You can mark your most frequently used reports as favorites and they will be listed in the Favorites group. To add a report to your Favorites...

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 2022 Publisher: Packt ISBN-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.
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}