--- title: "Settling cash to the portfolio currency at a different FX rate" slug: "settling-cash-at-a-different-fx-rate-to-the-portfolio-currency" updated: 2026-06-08T08:02:53Z published: 2026-06-08T08:02:53Z canonical: "support.lusid.com/settling-cash-at-a-different-fx-rate-to-the-portfolio-currency" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.lusid.com/llms.txt > Use this file to discover all available pages before exploring further. # Settling cash to the portfolio currency at a different FX rate When you book a transaction in a different currency to that of the portfolio you have the option to specify an exchange rate, either [directly on the transaction](/v1/docs/transactions-and-exchange-rates#hardcoding-an-exchange-rate-between-transaction-and-portfolio-currencies) itself or by asking LUSID to [look up a rate](/v1/docs/transactions-and-exchange-rates#looking-up-exchange-rates-dynamically-using-a-recipe) for the trade date in the Quote Store. When you load a settlement instruction (SI) for a cash movement generated by that transaction you can choose to override this trade date FX rate. LUSID can then calculate FX gain/loss between the trade and settlement dates. For example, imagine we have a standard `Buy` transaction for 100 units of BP @ £5 per share in a USD portfolio with the `Transaction/default/TradeToPortfolioRate` property set to `1.3`, yielding an estimated portfolio cost for the temporary cash commitment holding of -£500 × 1.3 = -$650: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-2ZK2P39M.png?sv=2026-02-06&spr=https&st=2026-11-09T07%3A24%3A15Z&se=2026-11-09T08%3A24%3A15Z&sr=c&sp=r&sig=qlj9t2qubZS5CjRar4oFHNH9QQmxBJwoW4b%2B4EZxvwk%3D) To settle the cash at a different FX rate: 1. Enable LUSID to calculate FX gain/loss between trade and settlement dates. See below. 2. Either: Note if you do both then a) prevails. 1. Specify a FX rate directly on the SI. [See how to do this](/v1/docs/settling-cash-at-a-different-fx-rate-to-the-portfolio-currency#specifying-a-fx-rate-directly-on-a-settlement-instruction). 2. Ask LUSID to look up a rate for the settlement date in the Quote Store. [See how to do this](/v1/docs/settling-cash-at-a-different-fx-rate-to-the-portfolio-currency#asking-lusid-to-look-up-a-fx-rate-for-the-settlement-date). ## Enabling LUSID to calculate FX gain/loss between trade and settlement dates LUSID APILUSID web app To configure an existing portfolio, call the [PatchPortfolioDetails](https://www.lusid.com/docs/api/lusid/endpoints/transaction-portfolios/PatchPortfolioDetails/) API and re-specify the entire `settlementConfiguration` object to include `calculateTradeDateToSettlementFxPnL` set to `true`, for example: ```json curl -X POST "https://.lusid.com/api/api/transactionportfolios/Equities/UK-Growth/details"  -H "Authorization: Bearer "  -H "Content-Type: application/json-patch+json"  -d '[  {    "path": "/settlementConfiguration",    "op": "add",    "value": {      "stockSettlement": {"method": "Automatic"},      "cashSettlement": {        "method": "Instructed",        "calculateTradeDateToSettlementFxPnL": true      },      "deferredCashReceipt": {"method": "Instructed"}    },  } ]' ``` *This feature is coming soon.* ## Specifying a FX rate directly on a settlement instruction LUSID web appLUSID API Call the [UpsertSettlementInstructions](https://www.lusid.com/docs/api/lusid/endpoints/transaction-portfolios/UpsertSettlementInstructions) API and, for a SI with a `settlementCategory` of `CashSettlement` or `DeferredCashReceipt`, specify`instructionToPortfolioRate`: ```json curl -X POST "https://.lusid.com/api/api/transactionportfolios/Equities/UK-Growth/settlementinstructions"  -H "Authorization: Bearer "  -H "Content-Type: application/json-patch+json"  -d '[  {    "settlementInstructionId": "Settle-Txn01-10-Sep-2025",    "transactionId": "Txn01",    "settlementCategory": "CashSettlement",    "instrumentIdentifiers": {"Instrument/default/LusidInstrumentId": "CCY_GBP"},    "actualSettlementDate": "2025-09-10T00:00:00.0000000+00:00",    "units": -500,    "instructionToPortfolioRate": 1.4  } ]' ``` Follow the instructions for [creating a settlement instruction](/v1/docs/loading-settlement-instructions) and, in the **Create cash settlement** dialog, specify a **Settlement to portfolio rate**: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-3XXJFOG1.png?sv=2026-02-06&spr=https&st=2026-11-09T07%3A24%3A15Z&se=2026-11-09T08%3A24%3A15Z&sr=c&sp=r&sig=qlj9t2qubZS5CjRar4oFHNH9QQmxBJwoW4b%2B4EZxvwk%3D) In this example, overriding the trade date GBP/USD rate of 1.3 with a settlement date rate of 1.4 changes the portfolio cost of the now-settled cash balance holding to -£500 × 1.4 = -$700: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-59O2N8KP.png?sv=2026-02-06&spr=https&st=2026-11-09T07%3A24%3A15Z&se=2026-11-09T08%3A24%3A15Z&sr=c&sp=r&sig=qlj9t2qubZS5CjRar4oFHNH9QQmxBJwoW4b%2B4EZxvwk%3D) You can [audit the FX gain/loss](/v1/docs/how-does-lusid-calculate-realised-gainloss#auditing-the-realised-gainloss-calculation-for-a-transaction) between trade and settlement dates by examining the output transactions: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-4TQOF9RO.png?sv=2026-02-06&spr=https&st=2026-11-09T07%3A24%3A15Z&se=2026-11-09T08%3A24%3A15Z&sr=c&sp=r&sig=qlj9t2qubZS5CjRar4oFHNH9QQmxBJwoW4b%2B4EZxvwk%3D) ## Asking LUSID to look up a FX rate for the settlement date You must first: 1. Configure the original transaction type to use the `Txn:TradeToPortfolioRate` calculation. 2. Create a recipe with a market data rule for the currency pair, for example GBP/USD. 3. Register this recipe with the portfolio. 4. Load a FX rate valid for the actual settlement date into the Quote Store. [See how to perform these steps](/v1/docs/transactions-and-exchange-rates#looking-up-exchange-rates-dynamically-using-a-recipe). You must then configure the portfolio to enable look up for cash, deferred cash, or both: LUSID web appLUSID API To configure an existing portfolio, call the [PatchPortfolioDetails](https://www.lusid.com/docs/api/lusid/endpoints/transaction-portfolios/PatchPortfolioDetails/) API and re-specify the entire `settlementConfiguration` object to include `calculateInstructionToPortfolioRate` set to `true`, for example: ```json curl -X POST "https://.lusid.com/api/api/transactionportfolios/Equities/UK-Growth/details"  -H "Authorization: Bearer "  -H "Content-Type: application/json-patch+json"  -d '[  {    "path": "/settlementConfiguration",    "op": "add",    "value": {      "stockSettlement": {"method": "Automatic"},      "cashSettlement": {        "method": "Instructed",        "calculateTradeDateToSettlementFxPnL": true,        "calculateInstructionToPortfolioRate": true      },      "deferredCashReceipt": {"method": "Instructed"}    },  } ]' ``` Navigate to the **Data Management > Portfolios** dashboard, locate the portfolio to edit and, on the **Details** tab, enable **Settlement to portfolio rate** for cash and/or deferred cash: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-T1DWYLZR.png?sv=2026-02-06&spr=https&st=2026-11-09T07%3A24%3A15Z&se=2026-11-09T08%3A24%3A15Z&sr=c&sp=r&sig=qlj9t2qubZS5CjRar4oFHNH9QQmxBJwoW4b%2B4EZxvwk%3D)