Presented by David H. Ringstrom, CPA
 
In this presentation, author and Excel expert David H. Ringstrom, CPA, will introduce participants to creating financial statements with Power BI on an introductory level. David will use trial balance and chart of accounts reports from QuickBooks Online as sample materials for concepts that can be applied to any accounting software. He'll discuss common stumbling blocks that accounting reports can cause, as well as how to create self-updating financial statements by connecting Power BI to a folder of reports. You'll see how to transform trial balance reports into the basis for creating an income statement with a Power BI matrix. Additionally, David will demonstrate the Power BI matrix drill down/drill up feature, providing valuable insights into data analysis and visualization. Don't miss this opportunity to enhance your analytical skills and improve your financial reporting capabilities.

David is the author of “Exploring Microsoft Excel's Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features”. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the desktop app for Power BI. The handouts include the Excel workbooks that he will use during his demonstrations.

Topics Covered:

• Transforming trial balance reports into analysis-ready formats.

• Exporting the Chart of Accounts report from QuickBooks Online.

• Exporting a monthly trial balance report from QuickBooks Online.

• Drilling down and drilling up in a Power BI matrix (equivalent to a PivotTable in Excel).

• Understanding simple stumbling blocks that can cause Power Query to ignore numeric values within financial reports.

• Connecting Power BI to a folder so that you can add new monthly reports to for automatic import.

• Streamlining the filtering of lists using the Slicer feature with tables.

Learning Objectives:

• State which Power BI task pane enables you to add features to a report.

• State what the equivalent of a PivotTable in Microsoft Excel is within Power BI.

• State which Power BI task pane enables you to add features to a report.