Overview
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 subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.
Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates.
Areas Covered
· Exporting a monthly trial balance report from QuickBooks Online.
· Connecting Power BI to a folder so that you can add new monthly reports to for automatic import.
· Exporting the Chart of Accounts report from QuickBooks Online.
· Transforming trial balance reports into analysis-ready formats.
· 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.
· State what the equivalent of a PivotTable in Microsoft Excel is within Power BI.
· Name the natural language tool in Power BI that enables you to create visualizations by way of written questions or search terms.
· State which Power BI task pane enables you to add features to a report.
