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 21

Automating QuickBooks Analysis with Power Query

IN THIS CHAPTER

Bullet Becoming acquainted with Power Query

Bullet Understanding the differences between enhanced and classic reports

Bullet Manipulating Power Query results

Bullet Keeping Power Query reports fresh

In Chapter 20, I explain how you can export QuickBooks reports for analysis in Microsoft Excel. I also explain how you can manually create a PivotTable report from your data. In this chapter, I show you how to automate the steps by using Power Query to create set-and-forget connections to reports. You still need to export reports to Excel from QuickBooks, but if you save over an exported report that’s linked to Power Query, the rest of the linking and transformation process is mostly automated. If you read to the end of the chapter, you can find out how to make the process completely automated.

You can use Power Query to automate all sorts of report clean-up steps, such as unpivoting data, or transposing reports from columns into rows. This makes wide reports much easier to work with and unlocks capabilities such as PivotTables and filtering ...

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