Questions? We have answers.

Troubleshooting tools: Smart Splitter and custom running total

Article author
Jonathon Plowman-Samson
  • Updated

Summary

Learn more about tools within MindBridge to help with transaction ID selection. 


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 to go to the Data page.


Configuration details

You must have begun the import process for a file.


Overview

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 transactions can limit MindBridge's ability to accurately assess and score risk at a transactional level because unrelated entries are grouped.

Learn more about which control points trigger at a transactional level in our knowledge base.


How does the Smart Splitter work?

When you use the Smart Splitter, it is automatically applied to all transactions in an imported ledger. 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.

Screen_Shot_2021-01-08_at_1.38.49_PM.png

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. Use the Select transaction identifier menu to select the transaction ID you want to split. MindBridge will recommend a transaction ID based on your data, but you can select your own combination if desired.
    mceclip0.png
  2. When you are satisfied, select Yes, run Smart Splitter to start the process.
    The graph on the right container will update to reflect the changes made with the Smart Splitter.
    transaction-id-graph.gif
 

How to tell if Smart Splitter was used in your analysis

  1. Select View details in line with the general ledger file you want to check.
  2. In the General Information tab, you will see that the transaction ID will say "Smart Splitter Applied" if it has been used in the analysis.
    GL View Details.gif


Export a Smart Splitter file

  1. Open the Actions menu in line with the files you want to export.
  2. Select Export Smart Splitter file from the list.
    The file will appear in your default download location.

image__14_.png

 


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.Screen_Shot_2021-01-08_at_1.40.58_PM.png

 

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

custom-running-total.gif

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

Learn more about the transaction graph and data integrity checks in our knowledge base.

 


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Related Articles

Share this article on

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.