Reader small image

You're reading from  Mastering QuickBooks 2024 - Fifth Edition

Product typeBook
Published inDec 2023
PublisherPackt
ISBN-139781835469958
Edition5th 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

Business analytics with Excel

Business analytics with Excel, also known as Spreadsheet Sync, can be used to track business performance by using Excel to create custom charts and graphs with your QuickBooks data. You can use pre-made templates to build consolidated reports for multiple companies or for a single entity. With Business analytics with Excel, you will be able to access KPIs that will enable you to make informed business decisions using real-time information.

Follow the steps below to access Business analytics with Excel, also known as Spreadsheet Sync:

  1. Click on the gear icon and select Spreadsheet Sync, as shown in Figure 17.58:
Graphical user interface, application  Description automatically generated

Figure 17.58: Selecting Spreadsheet Sync from TOOLS

  1. The following window is displayed:
    A screenshot of a computer

    Figure 17.59: Startup tips for Spreadsheet Sync

    In Figure 17.59, there are three steps that you need to take to start using Spreadsheet Sync. You select Open Link, Trust this add-in, and Sign in to Spreadsheet...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Mastering QuickBooks 2024 - Fifth Edition
Published in: Dec 2023Publisher: PacktISBN-13: 9781835469958

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