22-25 April 2026 
PBI Financial Modelling Masterclass – Part 2 AP/AR
50+50 minute session for SQLBits 2026Thursday - 23 Apr 2026 - 10:00 - 10:50 Room 2CTL; 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
PBI Financial Modelling Masterclass - Part 1 PL/BS - 2026