Home / Report Templates / Cash Flow Reports for MYOB in Power BI
The Cash Flow Reports for MYOB in Excel is a simple dashboard that provides a series of reports to analyse your Cash Flow statement in Excel. For a Power BI version of this report, see the Cash Flow Reports for MYOB in Power BI.
The dashboard includes:
- Monthly Cash Flow Statement
Not only this, but it can also consolidate data from multiple MYOB companies (data files) when using the Consolidation OData Feed.
While this is a fully working and standalone dashboard, it can also be used as a starting point that can be further customised or modified as required to fit whatever business rules you need. It is not locked in any way. Because of this, it can also be used to learn how to create power queries, how to create DAX formulas, etc.
Reports Included
Monthly Cash Flow Statement
The Monthly Cash Flow Statement is a simple report that displays Accounts down the page and Months across the page and includes opening balance of your bank accounts, movement for your different accounts and a closing balance of your bank accounts.
Requirements
To use the report, you will need to:
- Have an OdataLink Subscription or Trial Account.
- Connect OdataLink to your MYOB company.
- Configure a Model that includes the following endpoints:
- Accounts
- AccountsClassifications
- AccountsTotals
- BalanceSheetSummaryReportMultiPeriodTable
- DataFiles
- DatesByMonth
- ProfitAndLossSummaryReportMultiPeriodTable
Download and Setup
You can download the Power BI templates from the following links:
There is also a Company Financial Reports template that combines Profit and Loss, Balance Sheet and Cash Flow all in one.
Once downloaded, you can connect it to your own data using this article.
How to Refresh the reports
To refresh the reports, follow these steps.
- Go to the Inputs sheet to enter the Parameters driving this report.
- Enter the Date Start and Date End for the months you wish to report on.
This can be any date range but the larger it is, the longer the refresh will take to run.
Find an issue with the template?
Let us know of any issues you find with the template. We built it to use the least amount of data possible but this might not suit everyone.