This template creates an interactive, weekly cashflow based on unpaid invoices and bills - including any in draft or that are repeating - for your Xero-connected bank accounts.
The model takes a realistic/pessimistic view of when payments may fall. For existing customers or suppliers, it uses historic payment behaviour to predict when the payments will be made or received. This means that if you have a customer that is persistently late paying invoices, it will model future receipts from this customer that are late and if you have a customer that pays early, it will model them paying early in future too.
If you record a planned payment date on an invoice in Xero, the forecast will use this date, unless it is in the past, in which case it will forecast a date.
You can drill into each week to see the detail of what invoices or bills make up the payments that are forecast.
Test drive this template
You can click on the screenshots below to test drive the template with Demo Company data in Microsoft Power BI online.
Download the template
Click the button below to download the template.
Once downloaded, open the template in Microsoft Power BI Desktop and connect to your Connectorly database.
Key Tables
This template makes use of Bank Transactions.
Why use this template?
With Connectorly's 90-day Cashflow Forecast Template, you can better understand your cash flow situation for the next 90 days.
Improved Visibility:
A 90-day forecast provides a clear picture of your short-term cash flow needs. You can see upcoming inflows (sales receipts) and outflows (expenses, bills) over the next three months.
This visibility helps you anticipate potential cash shortages or periods of excess cash.
Proactive Decision Making:
With a forecast in hand, you can make informed financial decisions. If you see a potential cash crunch coming, you can take steps to mitigate it, such as delaying non-essential purchases, negotiating better payment terms with vendors, or considering short-term financing options.
Conversely, if you see a period of surplus cash, you can plan strategically for its use, such as investing in growth initiatives, paying down debt, or rewarding employees.
Improved Financial Stability:
By proactively managing your cash flow, you can avoid situations where you don't have enough cash to cover your bills. This can prevent late payments, damaged relationships with vendors, and potential disruptions to your operations.
A stable cash flow also fosters trust with investors and lenders.
Enhanced Budgeting & Planning:
A 90-day forecast serves as a foundation for your ongoing budget and financial planning. You can use the forecast to set realistic sales and expense targets, ensuring your budget aligns with your short-term cash flow reality.
This ongoing cycle of forecasting, budgeting, and monitoring helps you stay on track with your financial goals and avoid surprises.
Benefits Beyond Short-Term:
While the focus is on the next 90 days, the process of forecasting encourages you to think about trends and potential future events that might impact your cash flow.
This forward-thinking approach can help you identify long-term financial risks and opportunities, allowing you to make strategic decisions for the future of your business.