22-25 April 2026 
PBI Financial Modelling Masterclass – Part 2 AP/AR
Proposed session for SQLBits 2026TL; DR
Build AR and AP models that work across any ERP. Learn how to handle ageing, reconciliation, FX exceptions, and as-of balances—plus get a ready-to-use PBIX.
Session Details
If you have to build scalable models and reports for Accounts Receivable and Payable then this session is for you.
We will take you a standard way to model AP and AR that works for every single ERP system and deal with common issues such as:
- Dynamic Aged Analysis
- Reconciling Invoices and Payments
- Dealing with exceptions like FX differences, rounding and bad debt.
- Calculating Balancing
- Introducing an “As Of” Date to show balances at any point in time
Included with this session is a fully downloadable PBIX that you can use to reproduce and learn concepts from.
We will take you a standard way to model AP and AR that works for every single ERP system and deal with common issues such as:
- Dynamic Aged Analysis
- Reconciling Invoices and Payments
- Dealing with exceptions like FX differences, rounding and bad debt.
- Calculating Balancing
- Introducing an “As Of” Date to show balances at any point in time
Included with this session is a fully downloadable PBIX that you can use to reproduce and learn concepts from.
3 things you'll get out of this session
- Learn AP Modelling in PowerBI
Speakers
Bob Duffy's other proposed sessions for 2026
Automating Star Schemas in Fabric DW - 2026
Diving Into Graph API with Fabric Notebooks - 2026
PBI Financial Modelling Masterclass - Part 1 PL/BS - 2026
RAG + Fabric + Eventhouse: An End-to-End Pattern for Automated Contract Compliance - 2026
Replacing ADF with Notebooks in Fabric - 2026