Questions? We have answers.

Troubleshooting tools: Smart Splitter and custom running total

  • Updated


The Smart Splitter can help you reduce the size of large, grouped transactions, which is useful when your data contains transactions comprised of a large number of related entries. These large, grouped transactions can limit MindBridge's ability to accurately assess and score risk at a transactional level because unrelated entries are grouped. The Smart Splitter analyzes the data and uses your input to create transactional groupings with unique transaction IDs.

Learn more about transaction ID selection in MindBridge, and the different ways you can group transactions.

Go to the Data page

  1. Select the logo in the MindBridge sidebar.
    You will go to the Organizations page.
  2. Select View in line with the desired organization, or click anywhere in the organization row.
    You will go to the Engagements page.
  3. Select View in line with the desired engagement, or click anywhere in the engagement row.
    You will go to the Data page for that particular engagement.

Tip: If you are already in an analysis, simply use the sidebar ( Sidebar_open-close_icon.svg ) to go to the Data ( Data_page_icon.svg ) page.

Configuration details

You must have begun the import process of any file.


How does the Smart Splitter work?

When applied, the Smart Splitter will use all of the transactions in your imported dataset to create groups. It identifies double-entry transactions within large batched transactions by looking at commonalities in the defined Transaction ID column data in addition to matching debit and credit amounts.

As illustrated below, each transaction identified as a double-entry is extracted from the batched transaction and assigned a unique transaction ID. Any remaining entries left unmatched within the batched transaction are grouped to form a separate transaction with a unique transaction ID assigned to it.


Each transaction ID will have a dash ("-") and number appended to the original transaction ID. In the example above, transaction 442AB was split into 2 transactions by the Smart Splitter:

  • 442AB-1
  • 442AB-2

If the above transaction was not split by Smart Splitter, the new transaction ID for all 4 transactions in 442AB would be "442AB-1".

Note: If you are familiar with the data and expect to see some large transactions, using the Smart Splitter can compromise the integrity of the data. There is a risk of unrelated entries being matched to create new transactions if there are repeated debit, credit, and transaction ID column data values throughout a large batch transaction.

How to use the Smart Splitter

The Smart Splitter can be applied during the Review Data step of the import process.

  1. Open the Select transaction identifier menu.
  2. Determine how you want MindBridge to identify and group the data.
    MindBridge will recommend a transaction ID based on your data, but you can select your own combination.
    Screenshot highlighting the Smart Splitter.png
  3. When you are satisfied, select Run Smart Splitter to start the process.
    The graph on the right container will update to reflect the changes made with the Smart Splitter.

How to tell if Smart Splitter was applied in your analysis

  1. Find the file you want to look into on the Data page.
  2. Open the more actions menu (3 dot icon) in line with the desired file.
  3. Select View details.
  4. In the General Information tab, the transaction ID will say "Smart Splitter Applied" if it has been used in the analysis.
    GIF showing how to check whether the smart splitter was applied to a dataset.gif

Export a Smart Splitter file

When the Smart Splitter is run on a file, MindBridge creates a virtual copy that you can export from the Data page. 

  1. Open the more actions menu ( More_actions_menu_icon.svg ) in line with the desired file.
  2. Select Export Smart Splitter file from the list.
    The file will appear in your default download location.

Screenshot highlighting the selection to export a smart split file.png

Note: The original file is not altered in any way when Smart Splitter is run, and can also be exported from the same menu.

Custom running total

Some data may lack a unique transaction ID to link account entries, but restructuring the data may help MindBridge recognize transactions by the order in which entries are recorded.

A custom running total involves sorting the data in the order that would place like-entries next to each other. For example, successive reference numbers may have been assigned to each new entry recorded in the general ledger, with related entries being recorded sequentially.

When a custom running total by reference number is applied as a transaction ID, the data is sorted by increasing the reference number. MindBridge will calculate the running total on the sorted entry amounts and assign unique transaction IDs to groups of entries that sum to zero, as illustrated below.


To select a custom running total transaction ID, use the Select transaction identifier menu. You can then select the columns you want to sort your data on.

GIF showing how to use a custom running total with the Smart Splitter.gif

If the custom running total on the selected data columns is a suitable grouping for determining transaction IDs, you will see improvements in the transaction graph, and more of your data integrity checks will pass.

Learn more about the transaction graph and data integrity checks.

Anything else on your mind? Chat with us or submit a request for further assistance.

Related articles

Was this article helpful?