Skip to Main Content
QuickBooks Online For Dummies, 2024 Edition
book

QuickBooks Online For Dummies, 2024 Edition

by David H. Ringstrom
November 2023
Beginner content levelBeginner
464 pages
10h 41m
English
For Dummies
Content preview from QuickBooks Online For Dummies, 2024 Edition

Chapter 16

Spreadsheet Sync

IN THIS CHAPTER

Bullet Introducing Spreadsheet Sync

Bullet Initiating self-updating reports in Excel

Bullet Adding and updating list records in Excel

Bullet Initiating and/or editing transactions in Excel

Bullet Working with consolidated budgets

The Spreadsheet Sync feature serves as a conduit between QuickBooks Online companies and Microsoft Excel. As you’ll see in this chapter, once you install an add-in, you can create refreshable reports in Excel that are directly connected to your QuickBooks companies. Most Spreadsheet Sync features require an Advanced subscription, but you can create consolidated reports that combine results from Simple Start, Essentials, Plus, and Advanced companies if the consolidated report includes at least one company that has an Advanced subscription. You can also use Spreadsheet Sync to add and edit list records and transactions as well as create or edit company-level budgets.

I discuss the QuickBooks App Store in Chapter 7, where you can find apps that allow ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

QuickBooks Online For Dummies, 2025 Edition, 10th Edition

QuickBooks Online For Dummies, 2025 Edition, 10th Edition

David H. Ringstrom
QuickBooks 2024 All-in-One For Dummies

QuickBooks 2024 All-in-One For Dummies

Stephen L. Nelson, Christian Block

Publisher Resources

ISBN: 9781394206513Purchase Link