[NEW FEATURE] Open Banking Consolidated Data View

Review consolidated Other Income and Expenses

• View the combined Other Income (non-employment) and Expenses calculated from all applicants’ Open Banking data.
• Figures are calculated using a common summary period, ensuring data is aligned across applicants.
• Monthly averages are shown to support fact-finding and verification.

Understand the summary period

The Summary Period shows:

• The Open Banking transaction period applicable to each applicant. This period is driven by the transaction period requested at the time of invite or data refresh ("Update data").
• The common period used to calculate the consolidated Other Income and Expenses is the overlapping transaction period available across all applicants (eg. Screenshot-1).
• If the applicants’ data is more than 15 days out of alignment, you will see a prompt suggesting you update Open Banking data to improve accuracy (eg. Screenshot-2).

Screenshot-1

Screenshot-2

Include or exclude accounts

In the Accounts included section, you can control which linked bank accounts are used in the Open Banking Consolidated Data view.

• All accounts are included/selected by default.
• You can deselect accounts that should not be considered (for example, business accounts or inactive accounts).
• When you select or deselect an account:
  • Consolidated Other Income and Expense figures update immediately.
  • Monthly averages are recalculated in real time.
• Your account selections are saved automatically and remain in place when you return to the Open Banking Consolidated Data view.

Review Other Income and Expenses by category

Other Income and Expenses are grouped into categories to make review easier.

• Each category shows the monthly average for the last 3 months (ie. transactions , and/or last 6 months (where more than 6 months of data is available).
• Select a category to expand it and review the underlying transactions.
• Transactions are displayed in descending date order, with the most recent first.

Other Income sample:

Expenses sample:

Recategorise Expense transactions

If an expense transaction appears in the wrong category or is uncategorised, you can correct it.

• Select the category link on the expense transaction.
• The edit category panel opens.
• Search for and select the appropriate expense category.

Important to note:

• Only expense transactions can be recategorised.
• Changes are saved automatically as you make them.
• If you select another expense transaction while the edit panel is open:
  • Your previous change is saved.
  • The panel updates to show the newly selected transaction.
• Changes remain saved even if you navigate away or close your browser.
• *NB: Category updates are currently exclusive to the Open Banking Consolidated Data view. 
  Data can be manually copied into your CRM or ApplyOnline for assessment and loan preparation. 
  Exported documents, such as Insights PDFs and spreadsheets, will continue to show the original categorisation.

When you close the edit panel:

• Expense category totals and monthly averages are recalculated.
• The Open Banking Consolidated Data view updates immediately.

Click category hyperlink:

Review available categories:

Select the appropriate category to recategorise the transaction to:

Close the recategorisation modal and review the updated Consolidated Data view:

Updating Open Banking data

To get the most accurate Open Banking Consolidated Data view, it’s best to update applicants’ Open Banking data before reviewing or adjusting expense categories. 
This helps align summary periods across applicants and ensures you’re working with the most up-to-date information.

If you update Open Banking data after making manual expense category changes, some of those changes may be replaced.