How to Import Orders into the Platform

Introduction

There are times when orders are created or executed outside the platform, maybe by a custodian, a third-party broker or manually managed by your team. With the Order Import feature, you can easily bring these external orders into the platform to maintain a complete and auditable history.

This guide walks you through how to use the Order Import feature, the permissions you need and what each step means, from uploading or creating records to successfully posting them to the Orders tab.

Key Terminologies

Term (A-Z)	Definition
Import File	A CSV or XLSX file containing order details that you upload to the platform.
Missing BA From/To	Indicates that either the source or destination bank account is missing.
Missing Initiator	The person or entity who initiated the order is not specified.
Missing Instrument	Indicates that the instrument (asset) field is missing or unmatched.
Post Records	The action that moves successful draft records into the Orders tab.
Successful Record	A record that has passed all validations and is ready to be posted.
With Other Errors	Captures validation errors that do not fall into a predefined category.

Permissions Required

To access and use the Order Import functionality, you must have the following permissions:

Permission	Needed For
MANUAL IMPORT ORDER CREATE	To create or upload new orders using import options
MANUAL IMPORT RDER VIEW	To view the Order Import screen and existing records
MANUAL IMPORT ORDER MODIFY	To edit draft records and fix validation errors

Where to Find It

You can access the Order Import feature in two ways:

From the Transactions Module
- Go to Transactions > Orders tab
- Click the Import button on the top-right corner

You'll be redirected to the Import tab and then click Import File (as shown below).

From the Dashboard
- Click on Import in the main dashboard
- Switch to the Orders tab
- Click Import File

Step-by-Step Guide for Creating Orders

The new stepper-based flow breaks down order creation into clear steps:

Step 1: Select Type of Creation

You have two ways to begin the import process:

1. Download Template and Upload File

Click Download Template
Fill out the order details in the provided .xlsx or .csv file
Click Upload File to import the data into the platform

Once the file is loaded, you'll move to Step 2.

2. Create Records Manually

Choose this if you want to input data one record at a time
Click Add Record and manually fill out all order fields

On its click, you'll directly move to Step 2.

Step 2: See or Edit Records

Here, you'll see all imported or created records categorized into validation blocks.

You cannot fix errors directly in the table view. You must click into each validation block to fix records individually.

Here’s what each section means:

Blocks	What It Shows
All Records	Every uploaded or manually created draft order.
Successful Records	Drafts that have passed all validations and are ready to be posted.
Missing Instrument	Orders missing or mismatching an Instrument (Asset).
Missing BA From	Orders without a defined source Bank Account.
Missing BA To	Orders without a defined destination Bank Account.
Missing Initiator	Orders where the person or entity initiating the order is not provided.
Missing Counterparty	Orders where the counterparty (if required) is not set.
With Other Errors	Drafts with other missing fields that don’t fall under the above types.

Table Field Reference:

Platform Field	Template Field	Description	Editable on which Blocks?	Mandatory	Reprocess Available If Missing?
Type	Type	The main type of transaction.	All blocks	Yes	No
Transaction Sub Type	Transaction Sub Type	Specific subcategory of the transaction.	All blocks	Conditional	No
Instrument	Instrument Identifier	Identifier for the instrument involved, such as currency code.	Missing Instrument	Yes	Yes
Quantity	Quantity	Number of units in the transaction.	All blocks	Yes	No
Currency	Ccy	Currency in which the transaction is denominated.	All blocks	Yes	No
Execution Currency	Executive Ccy	Currency used to execute the transaction.	All blocks	Yes	No
Order Type	Order Type	The type of order (e.g., Market, Limit).	All blocks	Yes	No
Limit Price	Limit Price	Limit price for the order.	All blocks	Conditional	No
Execution Price	Executive Price	Actual execution price.	All blocks	No	No
Commission	Commission	Fees charged on the transaction.	All blocks	No	No
Bank Account From	Bank Account From	Source bank account.	Missing BA From	Yes	Yes
Bank Account To	Bank Account To	Destination bank account.	Missing BA To	Conditional	Yes
Counterparty Name	Counterparty Name	Counterparty involved.	Missing Counterparty	Conditional	Yes
Order Sent By	Order Sent By	How the order was submitted.	All blocks	No	No
Initiator	Order Initiator	The manager or client who initiated the transaction.	Missing Initiator	No	Yes
Initiator First Name	Initiator First Name	First name of the initiator.	–	No	Yes
Initiator Last Name	Initiator Last Name	Last name of the initiator.	–	No	Yes

Default Buttons in All Record Blocks

Depending on the validation outcome of your uploaded file, different categories of draft records may appear. Each category offers a specific set of buttons to help you act on the records efficiently:

Details here:

Button	Availability	Description
Export This File	Available in all blocks	Downloads the records shown in that block (e.g., all records with missing fields) in CSV format. Useful for external review or corrections.
Import New File	Available in all blocks	Allows you to upload a new file. This action will add up to the existing/current draft records.
+ Process The Missed	Only shown in blocks with missing fields (e.g., Missing Instrument, Missing BA From/To, Missing Initiator)	Opens a window to manually complete the missing information and save the corrected record. Enables you to fix and process only the error entries.

Make sure all issues are resolved so that Successful Records = All Records.

Once all records are marked successful:
- The Post Records button will be enabled
- Click it to push all records to the Orders module

Step 3: See Results

Once records are validated and posted, they’ll appear in the table.

Click on any row to review the full order details.

After posting, two confirmation tabs will appear:

Successfully Posted

Not Posted

If any record couldn’t be posted, it will appear under the Not Posted tab for further action.

If any records fail to post, you can:

Export as CSV – to download failed records and fix them.
Start New Import – to re-import corrected records.

Final Step: View in Orders

Now that your records are posted:

Go to Transactions > Orders tab
- Use filters if needed and locate your imported orders

Their status will typically appear as Filled, meaning they're ready for review, execution or further actions.