Amalgamate Transactions

Introduction

Amalgamate is a smart function that lets you combine multiple individual transactions under a single parent transaction. Think of it as a way to group several similar entries into one, making your data cleaner and easier to manage. The platform calculates key values such as:

✅ Total Quantity
✅ Gross Amount
✅ Net Amount
✅ Accrued Amount
✅ Total Value
✅ Average Price

This is especially helpful when:

You have multiple BUY or SELL bank transactions that need to be matched with a single order transaction, or
You need to review or show a client a single aggregated transaction instead of thousands of individual ones.

And with the new bulk feature, you can select or unselect all transactions in one click, making it even easier to work with large datasets. Instead of handling each transaction one by one, you can now quickly select them all and amalgamate them into a single parent transaction.

Key Terminologies

Term (A-Z)	Definition
Amalgamate	Combines several transactions into one parent transaction with total quantity and average price.
Child Transactions	The original individual transactions that now belong to the parent.
Multileg	A transaction that already has child links (not allowed in amalgamation).
Parent Transaction	The new transaction created after amalgamation, summarizing all selected transactions.

👉 New to some terms? Check out our full Platform Glossary for more.

Where to Find Amalgamate Function?

You can access the Amalgamate Data action in two main places:

Within Portfolios:
Go to Portfolios > Select Portfolio > Transactions tab, select your transactions.

All Transactions View:
Go to Transactions > Transactions tab, and choose the entries you want to combine.

Which Transactions can be Amalgamated?

Before completing the amalgamation, the platform checks if the following parameters match across the selected transactions:

Which Transactions Can Be Amalgamated

Checkpoint	Condition
Type	All must be either BUY or SELL types of Transactions. The platform amalgamates transactions only with the same type.
Status	Only transactions with the following statuses can be amalgamated: Not_matched, Not_allocated, Pending_confirmation or Order. Error transaction cannot be amalgamated.
Parent	Only transactions without parent can be amalgamated. Where to check: In the Transactions List, add the Parent ID column to see if a transaction is already linked to a parent. You can also open the transaction and check the "Parent-Transaction Number" field.
Multileg	Only transactions without link to child transactions can be amalgamated. Where to Check: In the Transactions List, add the Multileg column. You can also open the transaction and go to Related Records tab > Check for Parent & Child Structure tab > find Multileg Column.
Bank Account	Must be the same for selected transactions
Instrument	Must be the same for selected transactions
Trade Date	Same date (time is ignored) for selected transactions
Value Date	Must be the same for selected transactions
Currency	Must be the same for selected transactions

If any selected transactions do not meet the above criteria, the platform will display an error message highlighting the mismatched fields.

If a transaction is amalgamated incorrectly, please contact Support to reverse the amalgamation.

Once generated, the platform will:

Create a parent transaction

Automatically calculate total quantity and average price.

To review the result, Group transactions by Parent to see how they are linked.

How to Amalgamate Transactions

Go to the Transactions tab (either within a Portfolio or via All Transactions).
Select the transactions you want to combine.
- Filter by Type (e.g., BUY), Instrument Name or Transaction Number, etc to narrow down relevant entries.
- Use the Select All or Unselect All bulk action, if needed.

How to Use Bulk Select or Unselect Transactions

To Bulk Select Transactions:

Go to Portfolios > Transactions tab or All Transactions > Transactions tab.
Click the checkbox at the top of the table
- This is usually in the header row, right above the individual transaction checkboxes.

All visible transactions on the page will now be automatically selected.

If your table has filters applied, only the filtered transactions will be selected.

To Bulk Unselect Transactions:

If all or multiple transactions are selected, click the same top checkbox again.
This will deselect all currently selected transactions in one click.

Once you have selected your transactions, click Amalgamate Data to combine them into a single parent transaction.

Click Amalgamate Data in the toolbar.

The following window opens.
- Click Edit to make changes or change the status from Actions button.

Click Save to complete the process or Close to discard the changes.