Export cash flow analytics

The Dashboard offers two export options for utilizing Ocrolus cash flow analytics. The Lender Analytics (Excel) export contains account summaries, transaction details, and transaction tags, providing a comprehensive overview for lenders. The Bank Statement Income Calculator (Excel) generates income calculation outputs specifically tailored for mortgage lenders.

To export this data, select the Book you wish to export from, then click on the EXPORT dropdown menu and choose the desired export option.

Lender analytics

To download Lender Analytics, click on the EXPORT button and select the XLSX link in line with the Lender Analytics option from the dropdown menu.

The first tab of the file provides cash flow metrics at the aggregated Book level, which includes data from all submitted bank accounts and periods combined. You can review the metrics or search for specific ones, such as average daily balance or NSF, and view the values associated with each month in the Book. Most categories also include calculations for both inflows and outflows for each metric. To learn more about the definitions of certain cash flow metrics, view the Ocrolus analytics data dictionary.

The following tab(s) will be named by bank account and contain account-specific data and account-specific cash flow metrics. There will be one tab for every bank account in the Book. Key cash metrics, such as average daily balance and NSF count are summarized by month and displayed at the top for convenience. Additional cash flow metrics are displayed below by month.

The last tab of the file will be named Enriched Transactions. This will aggregate and display all transactions in the Book with dates (column B), descriptions (column C), and amounts (column D). Associated transaction tags are also available as well in the columns following column D. The transaction tags are presented in alphabetical order.

To view all transactions associated with a certain tag, use the filter function and sort by “true” in the desired transaction tag column.

Bank statement income calculator

To download Bank Statement Income Calculator, click on the EXPORT button and select the XLSX link inline with the Bank Statement Income option from the dropdown menu.

For information on the bank statement income calculator, see the Bank statement income calculator page.