Learn more about tools within MindBridge to help with transaction ID selection.
- Smart Splitter
- Custom Running Total
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 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.
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"
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.
When satisfied, run the Smart Splitter using the Yes, run Smart Splitter button.
The graph on the right container will update to reflect the changes made with the Smart Splitter.
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".
If you would like an export of the smart splitter transactions, export it from the data page as illustrated below.
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.
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.
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?