Bob Duffy: PBI Financial Modelling Masterclass – Part 2 AP/AR

Important Details
This event will be ONLINE using Teams. not in person!

Topic Summary
f 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.