1. Objective

1.1. Objective of this Operation

Run MtM for maturing deals:

In order to trigger the reversal of the previously posted MtM entries at maturity, a reversal needs to be generated and posted by running the MtM at maturity date

Run CCY translations for maturing deals:

In order to calculate the realized result of the FX deals (except for NDFs) at maturity, the Currency translation process has to be run. This process will calculate / post the result in base/functional currency using a standard Quantum process.

Run MtM Realized Split for maturing FX deals:

Similarly to the spot/fwd points split for unrealized MtM, a split is required for the Realized result at maturity 

2. Tasks description

2.1. I confirm that rates are correct in the system

2.1.1. Check if the ticket of Fixing has arrived

Usually Treasury Tools & BAM Team send an email or case around 15:00 p.m. Lisbon time informing that the fixing is performed:

We should wait until 16:00 p.m. Lisbon time to start the TMS daily procedure.

2.1.2. Check if rates were correctly updated in TMS

Go to ZRATE in SAP

Select the date and the currency

Check for several currencies

(i.e. For the currencies of the deals settled for the day.)

2.1.3. Check if rates were correctly updated in TMS - Analytics module

Go to Quantum.

We have to check the "Foreign Exchange Fixing" and "Foreign Exchange Fixing Spot"

1. Select the currency

2. Select the pair and confirm that the date was updated to the day

2.1.4. Return to the Default module

Select Default module

Compare with Quantum - TMS

2.2. I update the deals

2.2.1. Check If there are deals with settlement date for the day

Go to Reporting → Transaction by Deal

Select the view

• As At Date: Today's date
• Deal Date: Empty
• Maturity Date: Today's date and change to "equal to"
• Run query

This list is to be used as a comparison for the next steps hence save it or keep it on the screen to be able to compare.

If we have NDF deals in the report, the process for NDF deals need to be executed on the settlement date of the deal and not on the fixing date.

To check rate fix date of the NDF deals, go to: Reporting → Transaction by Action

Select an interval and Rate Fix and see the NDF with the settlement date for today's date.

• As At Date: Today's date
• Reporting Period: Previous week (for instance) until today
• Action Type: RATE FIX
• Settlement date: Tomorrow

This list is to be used as a comparison for the next steps hence save it or keep it on the screen to be able to compare.

2.2.2. Deal Update (Spot , Swap, Forward) - Position

The system will identify deals that have maturity date of the day and will reverse the mark-to-market previously recorded during the closing process (reversal of the unrealized balance sheet outstanding positions).

If there are Spot, Swap, Forward deals  (NDFs excluded) with settlement date for the day, follow the steps:

Accounting → Position → View FX EOD → Preview

In the report it will appear 2 lines for each deal.

Check if the deals of the day are included.

After select:  

The following message will appear and confirm with the UPDATE:

2.2.3. Deal Posting (Spot , Swap, Forward) - Currency Translation

This step is to calculate the realized result of spot, forward and swap contracts and to post it:

• for SPOT to P&L
• for FORWARD and SWAP contracts to a transit account that will be cleared by the step 2.4.1 due to the fact that forward and swap contracts need to be split in P&L into spot to spot FX result and forward points.

Accounting → Currency Translation → IHB

Select "Allow posting to suspense accounts" and Preview:

Check if the FX Deals are the same of the deals with maturity date for the day.

Only for Spots, Swaps and Forwards.

Ignore the deals with the Transaction Type Money Market.

Confirm if there are no suspense accounts involved, we should not perform any posting on these accounts.

If necessary, exclude the deals that are using suspense accounts to perform currency translation and analyze it later:

After confirm the number of the deals perform the 

2.3. I check the Accrual Process

2.3.1. Check Accrual Process

Accounting → Accruals

Preview

2.4. I generate MVI FX Update (Real) - Swaps, Forward

2.4.1. Generate MVI FX Update (Real) - Swaps, Forward

This step aims to create the GL entries that will post the realized results of forwards and swaps to P&L by splitting the Spot to Spot FX result and the forward points.

PNL Against a transit account that was populated by the currency translation process.

Analytics → Queries →MVI

Select the Date for Today.

Confirm if the Filters are ok and select Configure

Check the company, must be all the companies that have Swaps and Forwards in the reporting (for example: 2232L, 7728L)

After, Save the parameters

It will appear a list with the Swap and/or Forward deals with the maturity date of the day

After confirmation, save the variant and proceed to the next step.

2.4.2. Generate Position Job

Accounting  → MTM Split Realized

Select position date → Today

and       the screen with the deals for today will appears

Select the   and wall the deals are selected.

It is possible to select one by one.

After select  and the posting will be done in Quantum.

This message will appear

If there is any error is need to investigate the reason.

If run the query again no information appear

2.5. I Update NDFs Deals

2.5.1. Deal Update NDFs - Position

Go to Accounting →  Position

Change query to FX EOD - NDFs

• As at date: today's date
• Position date: according to fix rate in the reporting details
• Maturity date: equal to settlement date in the reporting details (Today)

Preview first and if the deals are in line with the report you can update

Print needs to be updated As at date = Maturity date. process should be done at the maturity date

Reporting →  Transaction by action, as described above

Then go to Analytics → Queries → MVI → MVI FX NDF (Real)

If there are different dates in the report, repeat the process for each position date/maturity date

Confirm if the Filters are ok select the Configure

Check the company, must be 2232 or blank.

After, Save the parameters

Run Query

It will appear a list with NDFs for that position date

2.5.2. Generate Position Job for NDFs deals

Select Accounting → MtM Split NDF realized

Select Position date → Fix rate

and       the screen with the deals for today will appears

Select the   and wall the deals are selected.

It is possible to select one by one.

After select  and the posting will be done in Quantum.

This message will appear

If there is any error is need to investigate the reason.

If run the query again no information appear

2.6. I Check the interface from Quantum to SAP

2.6.1. I confirm that the postings were correctly performed

At 18:00 an automatic job run and do the interface of the data into the SAP.

In the following day check if the account are balanced until the value date of day before.

Please use the following Query:

     Query: Errors Companies

     End date:  Previous day 

Use the transaction Z8Y_AI_LIST_POSTINGS to verify if the postings were performed:

Company code: 2232

Keep the selected document types

Posting date: Yesterday

If the report is empty like the screen below, it indicated that the upload was not executed properly.

2.6.2. I upload the information from Quantum to SAP (in case of not done automatically)

If the interface did not occurred, please follow the steps below:

Select Accounting → GL Interface

Click on the view ALL COMPANIES and select the last report generated by automatic user SVC, usually executed 12 or 13 hours ago.

With this selection the system will show the report that should have being entered in SAP. 

DO NOT CLICK IN UPDATE, ON THIS STEP YOU JUST NEED TO DOWNLOAD THE EXCEL FILE

When the report is generated, click in the export button (Excel) 

In SAP use transaction Z8Y_AI_MAIN to upload the file. First execute in test to identify if there is any errors messages:

If all is ok, run the transaction again without the test.

After the file is uploaded, go to the transaction ZZF_FLYPOST_OUT_TRAN and select variant QT AI BATCH.

Keep the selection of the variant and execute the transaction. This will generate the postings in PI2 and in the other systems

2.6.3. I create a new interface file (to be done only in case of need)

The steps above are to retrieve the file regarding the automatic upload, if for some reason you need to create a new interface file, follow the steps below.

Select Accounting - GL Interface

Select the view ALL COMPANIES and select the period, usually we start with 'The Beginning' and finish with the previous day:

Click in Preview first to generate the report.

After the file is generated, click un Update in order to clear the tables and generate the Unique identifier number.

Once the file is updated, follow the same steps described above for download and SAP upload.

End of document.