Advanced Excel Techniques for Effective Cash Flow Management

Accurate forecasting of accounts payable plays a critical role in active cash flow management. Powerful software can help. Unfortunately, it usually requires heavy investment, ongoing maintenance, significant customization, training and access granted to a limited number of users.

That’s why so many AP professionals continue to turn to Excel as their go-to tool. In this engaging 60-minute webinar, a Microsoft MVP with expertise in financial modeling will help you discover remarkably clean, yet powerful, Excel techniques that you have never seen before. You’ll explore how to get AP amounts and timing right to elevate confidence in your working capital management and cash flow forecasts. And you’ll learn how to quickly and easily implement these methods into your own processes.

Learning Objectives: 

1. Streamline the AP-to-Cash Management Process – Recognize how delayed or mismanaged A/P data can distort cash flow forecasts and working capital decisions.
2. Leverage Excel for AP Efficiency – Learn powerful, yet clean, Excel techniques to automate the AP aging, track payment schedules, execute early-pay discounts, and improve cash flow visibility.
3. Build a Repeatable Process – Implement a structured approach to managing A/P that minimizes errors, enhances accuracy, and saves time each month.

Carl Seidman
Founder, Seidman Financial

Carl Seidman is a trusted business advisor specializing in financial planning & analysis (FP&A), business strategy, and finance transformation. He advises Fortune 500 corporations and middle-market companies, helping establish effective FP&A practices, processes, and teams. At the same time, he supports financial professionals, positioning them for greater control over their careers by helping build their competence and confidence while eliminating time-wasting activities and mistakes.

Carl is 1 of 35 U.S.-based Microsoft MVPs in Excel. His Excel and FP&A development methodologies and curriculums have been implemented by leading organizations as part of their financial leadership development programs (FLDPs) for top talent and emerging leaders. More than 13,000 corporate finance professionals globally have attended his training programs, workshops, and seminars.

Carl serves as an adjunct professor in data analytics at Rice University and as an FP&A advisor, fractional CFO, and management consultant to entrepreneurial businesses throughout North America and Europe, assisting them with strategic financial planning, value enhancement, and revitalization.

Carl is a Certified Public Accountant (CPA); has earned other professional credentials including the CIRA, CFF, CFE, CGMA, AM (Accredited Member in Business Valuation), CSP (Certified Speaking Professional), Certified Anaplan Model Builder; and was a National Association of Certified Valuators and Analysts (NACVA) 40 Under Forty honoree. He holds a BA in finance and economics and an MS in managerial accounting.

Carl lives in metro Chicago with his wife and twin sons.

Grace Chlosta
Content Manager, IOFM

Grace Chlosta joined the Institute of Finance & Management (IOFM) in 2022 in a new role for the team as the Content Manager. She is responsible for the planning, organization, development, and implementation of all the content for IOFM’s digital products and (virtual and in-person) events. Grace is committed to ensuring that IOFM’s content stays timely, relevant, and actionable for all financial operations professionals, and works closely with a team of content developers, industry leaders, and subject matter experts to guarantee this happens.