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. 


Navigation

This task is performed during the data ingestion process, so you will need to navigate to an engagement's Data page and begin importing a file.

 


Smart Splitter

Smart Splitter can help you to 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 being grouped together.

Learn more about which control points trigger at a transactional level in our Knowledge Base.

How does it work?

When Smart Splitter is used, it is automatically applied to all your transactions. The Smart Splitter 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. Each double-entry transaction identified is extracted from the large batched transaction and assigned a new unique transaction ID, as illustrated below. Any remaining entries left unmatched within the large batched transaction are grouped together 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 above example, the 442AB transaction was split into 2 transactions by the Smart Splitter: 442AB-1 and 442AB-2.  If the above transaction was not split by Smart Splitter, the new Transaction ID for all 4 transactions in 442AB will just 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 stage of the data ingestion process.

Use the Select transaction identifier drop-down menu to select the transaction ID to split. MindBridge will recommend a transaction ID based on your data, but you can select your own combination if desired.

mceclip0.png

When satisfied, run the Smart Splitter using the Yes, run Smart Splitter button.

mceclip0.png

 

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

If Smart Splitter was used in your analysis, in the "Snapshot of your data" of your General Ledger in the General Information tab, you will notice that your Transaction ID will say "Smart Splitter Applied". 

GL View Details.gif

If you would like an export of the smart splitter transactions, export it from the data page as illustrated below. 

image__14_.png

 


Custom Running Total

The data may lack a unique transaction ID to link account entries, but restructuring the data may help 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 every 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 will be 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:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.