Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering QuickBooks 2021

You're reading from   Mastering QuickBooks 2021 The ultimate guide to bookkeeping and QuickBooks Online

Arrow left icon
Product type Paperback
Published in Jan 2021
Publisher Packt
ISBN-13 9781800204041
Length 414 pages
Edition 2nd Edition
Arrow right icon
Author (1):
Arrow left icon
Crystalynn Shelton Crystalynn Shelton
Author Profile Icon Crystalynn Shelton
Crystalynn Shelton
Arrow right icon
View More author details
Toc

Table of Contents (26) Chapters Close

Preface 1. Section 1: Setting Up Your Company File
2. Getting Started with QuickBooks Online FREE CHAPTER 3. QuickBooks Online Advanced 4. Company File Setup 5. Migrating to QuickBooks Online 6. Customizing QuickBooks for Your Business 7. Managing Customers, Vendors, Products, and Services 8. Section 2: Recording Transactions in QuickBooks Online
9. Managing Sales Tax 10. Recording Sales Transactions in QuickBooks Online 11. Recording Expenses in QuickBooks Online 12. Reconciling Downloaded Bank and Credit Card Transactions 13. Section 3: Generating Reports in QuickBooks Online
14. Report Center Overview 15. Business Overview Reports 16. Customer Sales Reports in QuickBooks Online 17. Vendor and Expenses Reports 18. Section 4: Managing Employees and Contractors
19. Managing Payroll in QuickBooks Online 20. Managing 1099 Contractors in QuickBooks Online 21. Section 5: Closing the Books and Handling Special Transactions
22. Closing the Books in QuickBooks Online 23. Handling Special Transactions in QuickBooks Online 24. Shortcuts and Test Drive 25. Other Books You May Enjoy

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...
lock icon The rest of the chapter is locked
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 $19.99/month. Cancel anytime
Banner background image