Transactions section

The Transactions page offers an in-depth view of a borrower's cash flow and financial health and shows all transactions within the Book along with their respective transaction tags. Here you can search for specific transactions or keywords, filter and sort transactions, and configure transaction tags to suit your analysis needs. Additionally, you can view captured data, include or exclude transactions from revenue calculations, and add comments to individual transactions for more detailed record-keeping and analysis.

The table below outlines the available fields in the Transactions table, along with their corresponding descriptions:

Each column on the Transactions page is also filterable by clicking on All underneath the column headers and selecting your desired values.

Certain columns are sortable by clicking on the “^” next to the column header. Columns that are currently sortable are Date and Amount.

Searching, filtering, and sorting transactions

The Transactions page allows you to search for transactions or keywords using the search bar, with results filtering automatically as you type. Additionally, you can filter by date, tags, or specific column values, and sort by date or amount for a more refined view.

Searching transactions

You can search for transactions or keywords using the search bar at the top of the Transactions page. As you type, the table will automatically filter and auto-suggest the transactions to match the entered text.

Applying date range

You can use the DATE filters next to the search bar to include transactions based on the specific date range.

To apply the date range, perform the following steps:

1. Click on the DATE option.

   

2. Choose the appropriate Operator from the dropdown list. Depending on the selected Operator, the subsequent options will change. The available Operators include:

   • Between: Select this option to include transactions that occurred within a specific date range. When selected, the Select Start Date and Select End Date fields will appear. Enter the start and end dates, and the system will calculate only the transactions that fall within the specified range.

     

   • Equals: Select this option to include transactions that occurred on a specific date. When selected, enter the desired date.

     

3. Click on the APPLY button.

Applying tags

You can use the TAGS to include and exclude certain types of transactions.

To add/remove tags, perform the following steps:

1. Click on the TAGS option.

2. Choose the appropriate option from the dropdown list. The available options include:

   • Match all: Select the required tag(s). The system will include a transaction only if it meets all the selected criteria.

     

   • Match any: Select the required tag(s). The system will include a transaction if it meets at least one of the selected criteria. This means that if a transaction satisfies any of the conditions, it will be included.

     

3. Click on the APPLY button.

Viewing transaction details

You can click on a specific transaction to view detailed information about that transaction in the Capture Details panel that appears on the right side of the screen. This panel provides key information, including the transaction description, editable transaction tags, and editable revenue calculation status.

Additionally, it displays capture details and an image of the original document where the transaction occurred, with the transaction highlighted in yellow.

Updating transaction details

Ocrolus’ proprietary transaction tagging algorithm is designed specifically for lenders and is based on a vast number of data points received daily. However, there may be instances where you want to adjust how a transaction is tagged. In such cases, you can modify the tags by:

• Using the Tags column to select or deselect the desired tags

  

• Making changes in the Capture Details panel as described earlier

  

• Utilizing the Bulk Action feature to update multiple tags at once

  

Updating transactions in bulk

To update multiple transactions at once, select the transactions by clicking the box on the left side of the Transactions screen. After selecting, the following actions will appear at the top of the page:

• Add tag: Adds tags to all selected transactions.
• Remove tag: Removes tags from all selected transactions.
• Include in revenue: Includes the selected transactions in income/revenue calculations. Updates made here will be reflected on the Accounts page and in any exported data.
• Exclude in revenue: Excludes the selected transactions from income/revenue calculations. Updates made here will be reflected on the Accounts page and in any exported data.
• Export Selected: Exports details of the selected transactions in .xlsx format.

Create transaction tags

This feature allows you to enhance transaction tagging by creating and applying tags based on specific criteria, including exact include/exclude terms and optional amount thresholds. It offers flexibility, with immediate updates reflected in transactions and analytics.

To create or update transaction tagging, perform the following steps:

1. Upon login to the Ocrolus Dashboard, click on the profile icon and select Tag Management from the dropdown list.

   

2. On the Tag Management page, all the existing custom tags are listed.

   📘

   Note:

   To manage existing custom tags, click on the vertical ellipsis icon and edit or delete the intended created custom tags.

   

3. Click on the ADD TAG button to create the new custom tag.

   

4. On the Add custom tag tag pop-up page, enter the following details:

   • Tag label: Enter a name for the custom tag.

   • Description: Optionally, add a description for better context.

   • Color: Choose a color to distinguish the tag visually.

   • Exact Include Terms (Required): Specify terms for precise tag application.

   • Exact Exclude Terms: If applicable, define terms for exclusion.

   • With amounts: Set the amount or amount range thresholds, if needed.

   • With recurrence: Set the recurrence frequency as desired.

     

5. Click on the ADD TAG button.

6. Once a custom tag is created, it will automatically be applied to all relevant transactions. You can view these tagged transactions on the Transactions page.

Modify system transaction tags

Ocrolus also includes ready-to-use System Tag categories specifically designed for lending scenarios.

To use the system tags, perform the following steps:

1. Upon login to the Ocrolus Dashboard, navigate to the profile icon and select Tag Management from the dropdown list.

   

2. On the Tag Management page, select the System Tag that you want to customize and then click Edit.

   

3. On the Edit System Tag pop-up page, enter the following details:

   • Exact include terms: Terms for precise tag application. This is a mandatory field.
   • Exact exclude terms: The terms that need to be excluded. This is an optional step.
   • With amounts: Set the amount or amount range thresholds, if needed.
   • With recurrence: Set the recurrence frequency as desired.
   

4. Click on the UPDATE TAG button.

5. Once a system tag is updated, it will automatically be applied to all relevant transactions. You can view these tagged transactions on the Transactions page.