Reconcile Unsettled Positions
Introduction
Reluna Platform helps you to track Position(s) in Portfolios. With this guide, you can check which Positions are unsettled and require final settlement in the platform.
Key Terminologies
Term (A-Z) | Definition |
Quantity | Quantity of positions based on transactions that were created automatically based on order or were received from the bank, displays total amount of the asset(s). |
Settled Quantity | Quantity of positions based on transactions that were received from the bank and were settled (value date has come or confirmation from the bank was received). |
Unsettled Quantity | Unsettled quantity of positions represent transactions that have been completed but are awaiting final settlement. |
đ New to some terms? Check our full Platform Glossary for quick definitions.
How to Find Unsettled Positions
Go to Portfolios > Click on Positions tab.
Click on Filters option.
The following window opens with Filter Manager. Add Field by choosing drop-down as âQtySettledâ and then, choose operator ââ Does Not Equalâ in Value.
The platform displays the found All Positions for Unsettled Quantity.
Or, you can add other Groups, Filters or Columns to optimize better search results.
Now, on Positions tab > Find Columns button > Apply 'Unsettled Qty' filter.
The following list will show the Unsettled Qty for the Portfolio selected.
On Positions tab inside Portfolios and apply Group By âBank Account IDâ.
The list appears showing all the positions that have unsettled quantity and are grouped by Bank Account(s).
Unsettled Positions are related with Transactions on the platform.
Go to Transactions tab of portfolio and apply Filter transactions by 'Bank Account Name' (where you can detect unsettled position).
On Transactions tab > Click on Filters button.
Filter Manager > Find âSettledâ field > In the Value, choose âDoes not Equalâ and tick Yes on the checkbox.
The following list displays wherein:
The status reason is Order that can be manually matched qty for the particular date.
If value date is achieved and transaction lacks attribute settled= true . You can input it manually.
Disabled transactions for the particular date that are showing Error/Not Matched qty.
If transactions has incorrect Value date > You change it, manually > then, the platform will recalculate the positions data (including unsettled field).
What Causes Unsettled Positions
Transaction value date is not achieved
When transaction has status=active and status reason= Order.
ĐĄhild transactions are not settled
Every transaction has attribute âSettledâ.
Troubleshooting Steps
Transaction value date is not achieved
Example:
Todayâs Date: October 23rd
Transaction Value Date: October 24th or later
If the selected value date is greater than todayâs date (in this case, greater than October 23rd), the transaction remains unsettled. Since the value date hasn't arrived, the platform expects the transaction to settle on or after the set value date.
Troubleshooting Steps:
Create a Transaction
Value Date: Set the value date of the transaction to October 23rd, then 25th (as part of testing), ensuring it's beyond todayâs date.
Confirm Order
Proceed with confirming the order. The transaction will be marked as unsettled in the platform.
Wait for the Value Date
Check back on the value date to ensure the transaction status updates to âSettled.â
Transactions remain unsettled until the assigned value date arrives, at which point they should automatically settle as per platform configuration.
When transaction has status=active and status reason= Order
You can match the transaction with the bank data or confirm it if there is no bank integration or reflection.
Create a Transaction > The following list will appear with Status Reason = Not Matched
Then, click on Match icon. The following Status Reason changes to Confirmed.
Now, go to Positions tab. The quantity becomes settled.
ĐĄhild transactions are not settled
If child order = not confirmed. You need to create child transaction and match with order.
Use Case Scenario: Before settling child transactions
from Bank Account #1
from Bank Account #3
Use Case Scenario: After settling child transactions
from Bank Account #1
from Bank Account #3
When to Address the Issue to Support
If everything is checked, you can address issue to Support.
Go to Positions > Find Columns button and search for the following.
Instrument Name
Date
Portfolio ID
Simply, copy the text/name from the screen itself.
Finally, share these details with Support for further assistance.