How to Create Cashflow Forecasts in Real-Time
In these uncertain times, managing cashflow and liquidity in a changing environment is paramount for businesses seeking to survive and strive
About this event
In these uncertain times, managing cashflow and liquidity in a changing environment is paramount for businesses seeking to survive and strive. Where accounting reports were previously prepared on a monthly or quarterly basis, are now required to be prepared on a daily or weekly basis. This means that Finance departments will need to constantly update cashflow forecasts in the light of new information and a changing environment to assist business owners and entrepreneurs make better decisions for their organisations.We will discuss the capabilities of Xero and Microsoft Power BI to provide solutions for businesses seeking to report cashflow forecasts in real-time.
What will I Learn?
- Introduction to Xero
- How Xero accounts for cash and accrued based transactions differently
- How to run cash reports from Xero
- How Power BI integrates with Xero
- Introduction of Power BI
- How to enter forecast data into Power BI efficiently
- How to create Cashflow forecast dashboard templates
- How to connect multiple data sources into Power BI
- Q&A with experts
About the Speakers
Rayhan Aleem (Founder and Managing Partner, Alpha Pro Partners)
Rayhan has previously managed finance departments of several large financial services firms in the City of London and is passionate about accounting and reporting automation for small and medium sized businesses.
Bharat Makhijani (Principal Consultant for Data & Analytics, Citrus consulting)
Bharat is a Visual Analytics Professional with around 8 years of rich experience in Data and Analytics technologies. He has hands-on expertise in designing dashboards, defining business objectives and extracting business insights from a plethora of data across business verticals for multiple Fortune 500 clients across APAC, North America and EMEA region.