# data[].attributes.body
What did not work well

Quality and accuracy of reconciliation and tolerance check comments

Files with 1 or 2 policies under investigation unnecessary delayed for upload

# data[].attributes.body
What worked well

Teamwork and collaboration

Number of reports have improved, this has improved our reconciliation process

What to improve

ccs response got a bit slow this Q

Holding recs with many policies just for a query on one policy

Collection account checks

Analysis of discrepancies

# data[].attributes.body
What worked well:

Team and the preparation work.

Team communication and transfers.

The new SFTP connections.

What did not:

No issues to report.

# data[].attributes.body
What worked well:

Team work.

MM tolerances decision.

What did not:

Some custodians slow to send PDF statement for new policies.

What to improve:

Push for CCS team to populate correct details in Abacus for NPs.

# data[].attributes.body
What worked well:

Communication around change of banks

Davy on time with datafeed

Market Movement tolerances (10-13%)

What didn't work well:

Citibank - First quarter with CIC E's - forwards all blank in holdings file

Lincoln Private Investments - SFTP set up, 30.06 file not dropped (IT issue on Lincoln's side- issue ongoing)

# data[].attributes.body
What worked well:

Overall, the quarter went decent from my side with the full reassignment. Great teamwork, and 4eye support.

Room for improvement:

Derivative position reporting - banco Inversis

JPM Lux - 9 Accounts to be added in portal - too much time for Manual PDF Statement.

# data[].attributes.body
Rollback review and analysis, particularly for assets repricing (to discuss with Reporting Team)

Quarterly tool not flagging Franco’s user (NA)

Large files 4eye checks in the tool to review (Andres Perez)

Change of business partner not communicated by Nicola.

Praxis review in Abacus (Luca, Seb)

Team action

Before Q2, reach out to custodian to make sure there are contacts available in summer season.

Access review (send request to Nello)

Don’t hold a rec for a missing policy

# data[].attributes.body
Worked well:

Preparation

Team Work

CDR

Change of bank

Fideuram Update

Didn't work well:

Change of version Quarterly tool, ran twice Fideuram

Collection account check and reconciliation

Rampart data feed delayed

Wtax payments right before the Quarter

# data[].attributes.body
What worked well:

Overall, the quarter went well from my side. Great teamwork, as always.

Room for improvement:

Possible idea: Add a new line in the Check for Errors tab of the tool to automatically flag any ISINs that are listed in the Level 3 file.

# data[].attributes.body
What worked well:

Zoltan leaving comments in CC when 4eyes are done for multiple versions and tagging me in the emails and chats about reimports,

leaving the custodians with history of rollbacks to be imported last,

transfer between my custodians done perfectly,

less rollbacks comparison with Q1,

N/A fixed in Quarterly tool,

archiving not relevant files.

What did not work well:

collection account checks,

Schroders Online Portal issues,

issue with dates on the tool when Holdings file done manually causing issues on imports

# data[].attributes.body
What worked well:

Prep. Larger amount of MM compared to previous quarters, some of which with a large discrepancy

Change of Banks investigation

Day one. Despite the time consuming re-investigation/update of MM files

What did not work well:

Collection A/C Banca Aletti

Azimut file received late and in the wrong format

# data[].attributes.body
What worked well

Prep work more then ever, large number of MM investigated to avoid incorrect classifications,

All data feeds were delivered on time

Strong collaboration within the team

What to improve

It would be helpful to receive the L3 file a few days before quarter-end to allow more time for review and analysis

Communication from UBP regarding price investigations was sometimes slower than expected

# data[].attributes.body
What worked well:

Usual quarter preparation ( DV file, practice recs)

Solo Direct investments file on time;

Custodian communication

What did not work well:

IT not getting back to me on time and Lombard Odier not activating our SFTP connection, the issue has been going on for months. This led to a significant delay in processing the file and creating the Holdings has been a challenge too.

Room for improvement:

Communication between department

# data[].attributes.body
What worked well

Prep work thanks to team

What to improve (from myside)

Smooth communication with custodian

Understand the whole process from the broader prospect

Update bank summary

# data[].attributes.body
Worked well:

Change of Banks

Collaboration

Didn't work well:

Tool 29.7 vs 29.6

Tool overwrites V1

Prioritising the reconciliation being done, over quality: duplicated assets, error in the tool, not updating 0 values.

Collection account checks

TBC account update

Room for improvement:

weak comment: "0 value reported", "Date OK", "NB/Surrender inline with Abacus"

V1, V2... reporting and keeping folder clean

# data[].attributes.body
What worked well:

The decision around Market Movement

Nello's new tool for Ale Dam - saved hours - excited to test it on other big custodians. Will be even more useful with L3 functionality.

Simplifying the approach to DI summaries where the changes do not lead to TSII change.

Usual - prep, team support, etc.

What to improve :

Rollbacks -

Why do we get emails about repricing in the same file so many times? E.g. I have been in the middle of rolling back file and receiving more emails about that same file - At this point why don't we wait until the whole file / all the ISINs are checked.

So much unnecessary movements.

I know reporting check prices by ISINs rather than portfolios - but maybe there is an additional check they can implement for the affected portfolios, as to not send out emails before custodian is fully checked.

Also, if there are assets that are being repriced every Q - or at least are under the risk - Why don't Pricing team provide us on Day 1 with the prices we should use. (Like Zoltan's re-pricing email - but from Pricing and with actual prices.)

Won't save from all the rollbacks but would decrease the number.

Collection Accounts Checks - not sure what went differently this Q on banking side - but if that's how it's going to be going forward, we might need a training or a person who can do that for the whole team.

Communication with CCS/NB regarding Abacus Set Up - In my case it was till day before the Q that I tried to get them to implement the changes that should have been there from the start.

# data[].attributes.body
What worked well:

Custodians data delivery

Team Work and prep

What did not worked well:

Too many Rollbacks

# data[].attributes.body
What worked well:

No issues with CC tracker

Datafeeds all received on time/ahead of schedule

What didn't work well:

Multiple roll-backs of same file (REYL)

Davy >:(

# data[].attributes.body
What worked well:

Preparation, Teamwork

What did not worked well:

small mispricing rollback

# data[].attributes.body
What worked well:

Teamwork and good communication regarding transfers.

No issues with trackers

CDR team

What did not:

Some calculation issues with L3 file(Accrued interest missing)

Missing policies from RBC portal

CCS not populating account number in Abacus.

# data[].attributes.body
What worked well:

Prep work

Team collaboration

What we could improve:

Collection accounts check

What did not work well:

Late files deliver from GHC

Custodian Westminster did not provide correct file for quarter, we had to work around, and SFTP now is in place.

# data[].attributes.body
What worked well:

Prep

Custodians providing files on time

Change of banks

What didn't work well:

Pictet rollback due to policy split

Some assets being repriced

# data[].attributes.body
What worked well

Prep work

All data feed were delivered on time

Collaboration within the team was excellent

What to improve

CMB: re-establish the SFTP connection and practice with the new file

data vision comments for the policy missing

# data[].attributes.body
No issues from my side. Everything worked well.

What can be improved:

- Rollbacks due to Repricing

# data[].attributes.body
What worked well:

-          Data feeds received on time and the timing of the tasks spread out nicely over the 5 days

-          Less market movements than expected

What did not worked well:

-          The number of pendings was larger then expected but the issue was identified and we manage to work it out

-          BNP Paribas (Suisse) SA- The SFTP connection was not open in time, and the holdings file was done manually

# data[].attributes.body
What worked well:

Preparation, Teamwork

What did not worked well:

Praxis rollback

Change Entity Name UBS for CC

Caixa Portal

Level 3 file

# data[].attributes.body
Worked well:

change of banks

collaboration

Didn't work well:

UBS vs Credit Suisse Abacus set up

Large files 4eye check time

No communication from Nicola: ex 2xUBS, certain report updates

Mediobanca file delivery time

Roll-backs

Room for improvement:

comment quality

large files held back due to 1 policy investigation

Collection account checks

MT setup: Organisation ID

# data[].attributes.body
What worked well:

• Preparation, testing Python scripts before group investment

• DV file from Zoltan and Francesco

• Luca Quarterly tool for discrepancies and report from Tomi Apache

• I was able to test most of my custodians in advance to avoid surprises during recs

What did not work well:

• Few roll back for price discrepancies ( eg: BJB providing price for 30th of March instead of 31st)

• Rec tool- when correcting mistakes and going back to original tab, still flagging errors and then formula crashing when hyperlinks were re-run

• Access not showing pop-ups and improvements made in the past

What to improve:

• Communication regarding prices • Source data accounts to be consistent with Holdings

# data[].attributes.body
What worked well:

Evelyn, best data feed quality we ever had with them and reported on day 2,

ID confirmation in Quarterly tool,

Zoltan flagging to me reimports in Abacus.

What did not worked well:

rollbacks,

few missing policies not imported because the file was archived in folders.

What to improve:

Q2 will be summer holidays season so we should make sure to have multiple contacts able to report data feeds to avoid delays,

Quarterly tool still not flagging N/A for Franco's user,

please archive files not related to final reconciliations.

# data[].attributes.body
What we can improve:

- review file format and access before the quarter.

review the delivery date of the file and the format and methond received. try to ask for an SFTP.

# data[].attributes.body
What worked well:

Prep tool.

Good communication from everyone.

Zoltan helping with MT and tolerances.

Niello helping with access and valuations.

What didn't work well:

Delay with Ifigest not providing missing accounts until day 6.

Brooks providing file from August.

Credit Suisse reporting duplicates of gold and platinum on source file.

Fusion Wealth not including a sub account in there valuation.

Some accounts having to be remapped in access.

What to improve:

Request custodians to correct source files issues.

# data[].attributes.body
What worked well:

Good communication within team.

CDR team

What did not:

UBP file not received on time and new format so mapping required

Banca Patrimoni and RBC not adding new accounts to portals.

Account number not populated in Abacus by NB

Level 3 file not accurate and data had to be double checked.

To Improve:

Push for NB team to populate account number when adding new policies on Abacus.

# data[].attributes.body
What worked well:

Communication regarding account transfers

Prep work identified tolerance checks in advance

Didn't work well/could be improved:

Unexpected changes in SFTP file format (Novia)

NB Account numbers in Abacus not populated

Davy :(

# data[].attributes.body
What worked well:

Prep work/discrepancies checked before Q4 2025.

Team communication.

What to improve/Didn’t work well:

Policies transfer on Apache not updated, 7IM to Pershing and 7IM to M&G.

Policies on Abacus backdated, one or two days after Quarter/Corner Banca/Interactive Brokers.

Abacus not updated with new accounts creating discrepancies with MTDV, 5 new accounts from Artorius.

# data[].attributes.body
Went well

Communication and work within the team.

EFG Prep

Communications from Zoltan re: new policies / accounts

Email with IDs that have caused rollbacks in prior Qs

Could have been better

Level 3 File inconsistent & difficult communications with CA team re L3/distressed pricing

Quarter Tool Run-time >30min for EFG AG

To work on

Improving procedures for EFG AG and DI

Clarifying certain thresholds for DI Intervention

Moving more custodians to automatic file delivery and/or better communication channels

# data[].attributes.body
What worked well:

Prep work.

CDR Team.

What didn't work well and can be improved:

Atrium changed the contact responsible for providing the data feed, which caused a delay. As a result, we received the file after our Day‑5 deadline.

Complex Asset Team.

# data[].attributes.body
What Works well:

Prep work

Team Work

Recs completed by day 5

What do not work well:

NB EDR with Unauthorised top up

Intesa Sanpaolo Wealth Management SA data feed

Transfer M&G 7IM

Data in Level 3 file inconsistent

What we can improve:

Transfer process for Ex Athora/Aviva policies (Add new account in apache)

# data[].attributes.body
What worked well:

Prep work

Team work

Rec completed by day 5

What did not work well:

NB With EDR Europe with Unauthorised top up.

Transfer M&G to 7IM

Quality data Intesa Sanpaolo Wealth Management SA

What can be improved:

Transfer process to be discussed with team of Ex Athora/Aviva Policies

# data[].attributes.body
What worked well:

Prep work

All data feeds were received on time

Transfers

Improved data feed and delivery timing with Trinity bridge

What did not work well and can be improved

The implementation of an SFTP with Brown Advisory was unsuccessful

GS active account management on Abacus. Possible solution suggested by Andres

# data[].attributes.body
What Worked Well

Change of Banks were handled much better than last quarter. Going forward, once communication is completed, saving the actual email (not a Teams screenshot) to the quarterly folder would make everyone’s life easier, as your investigation could be already done before the start of the quarter.

Team communication was excellent

Areas for Improvement

Tool Performance: Large files become slow after exporting the 4‑eye report.
Examples: 60005 Brewin takes 7 minutes, EFG takes 10+ minutes. Therefore large files needed to be force closed and dropped DV upload file separately.

Tool: In the Rec file, under the Holding tab, the formula picks up a location path that needs to be removed before the 4‑eye check (I noticed this with all of Darragh’s files).

4‑Eye Checks: We need to establish a defined set of steps to include in our checks and improve the process so errors are caught immediately.
(I will take ownership of creating a guide for this.)

V2 Files – Missing Policy: We should agree on a consistent approach, as some people update the MT with zeros while others don’t, and comments are inconsistent.
Suggested approach: leave values blank and only update the comment field.

# data[].attributes.body
Worked well:

Prep work

Team was very helpful

Didn't work well:

Slow response times from custodians (Holiday season)

Late transfers that were still in progress/unconfirmed

A small amount of manual intervention for Direct investment (Procedures)

What to improve:

Better relations with custodians

Direct Investment procedures updates might be

needed

Keeping summaries up to date

# data[].attributes.body
What worked well:

had 6 transfers and all done perfectly,

What did not work well:

Evelyn sending files from 2023/24,

What to improve:

V2, when having several versions to upload please leave a comment of what is outstanding in CC and I will delete it when imported and confirm with you,

archive files please, all of the extra files part from last version of the rec uploaded, archive,

confirm ID in the rec tool,

only Franco has issues with N/A for the exUI in the quarterly tool,

remember to check collection accounts

# data[].attributes.body
What worked well:

Coordinated well with colleagues to resolve issues quickly;

When challenges came up, people stepped in to support each other;

Reconciliation process built in past months was overall successful;

Spotted recurring issues early and escalated them appropriately;

Documented gaps or inefficiencies that will help improve next month’s close.

Managed to finish within day 5 all my custodians except for one who had not sent PDF evaluations clarifying transfers.

What did not work well:

Working across internal systems based abroad created delays and urgency once back in the office.

Unable to delegate a task to colleagues in the office as felt guilty of burdening the team with something that was supposed to be only mine.

Custodians introduced new templates at the last minute, which disrupted established processes and caused system inconsistencies;

Communication from custodians was often unclear or incomplete, leading to confusion about where certain funds were allocated ( this issue was raised in November);

Unexpected lockouts from portals and unannounced password changes;

A manual holding had to be completed on the last day of recs due to missing or inaccessible information;

Poor communication from custodians and inconsistent information flow contributed to delays and rework.

What can be improved:

How information is being received (SFTP,mails exc.);

A better relationship with our custodians to improve overall communication;

Written processes to be constantly reviewed and updated accordingly to what has been added or removed.

# data[].attributes.body
What Worked Well

Teamwork and Team communication

Zoltan's checks

What did not worked well

UBP new sftp connection and communication

Some custodians had issues providing the data

What we can Improve

Engagement with custodians to avoid missing accounts on day 1

Direct Investment overall process

# data[].attributes.body
All Team Members:

Add more details in the comments about market developments (e.g., when reviewing discrepancies in a PDF or conducting more thorough research with the custodian, etc.).

Clean up quarterly folders (leave only the maintenance and reconciliation tool; the rest of the files should be saved in the archive folder).

Investigate transfers between custodians and reloads on policies with more than one custodian. Save the relevant investigation and communicate with your colleague.

For new Ex UI policies, add the application reference (same policy number).

Review custodians to set up SFTP: send an email to Nello to check if an SFTP exists.

Managers & Team Leaders:

Define Roll Back process and clarify when the status of the custodian can be changed in the CC).

Update Direct Investment and Group scripts.

Add Tomi to the ICT Reporting Team (Teams group).

Review Enate process for internal tickets (Andres & Mari)

Review CGM file in Access (Nello).

Review multi prices in Morgan Stanley reconciliation tool.

Review Barker Poland (7IM) in the CC.

Training on Complex Assets file (Capital Calls and distributions).

Tomi:

Test the Abacus valuation load without removing the Ex UI policies.

Zoltan:

Coordinate training for Apache – EMC positions and transactions.

Developers:

Review the Quarterly tool:

4eye for files with internal derivatives.

It is not flagging Ex UI policies (mainly related to FV initials).

It would be helpful to contact the team during the quarter to use the ICT.Reporting team mailbox.

Determinate a criterion for High Discrepancy Price report. Could the Quarterly tool flag large price discrepancies for review?

# data[].attributes.body
What worked well

Great work from the Team.

CDR Dream Team

What can be improved

Communication regarding transfers and top ups into multi account Policies.

# data[].attributes.body
What Works well:

Quarterly prep tool and CC Tracker.

Team morale.

What do not work well:

Account number section in Abacus not being populated by CCS when creating new policy.

RBC Channel Island not updating portal with new polices.

What we can improve:

Multi prices – Can tolerance be reduced on Rec file as some custodians have slight differences.

List of team members required for the roll back emails not clear.

# data[].attributes.body
What worked well:

Quarterly prep tool.

Having tolerance comments ready.

Teamwork regarding new assignments.

What didn't work well:

Delays in custodians responding or files being received.

CC changes not saving.

# data[].attributes.body
What Works well:

Quarterly prep tool and CC Tracker.

Team morale.

What do not work well:

Account number section in Abacus not being populated by CCS when creating new policy.

RBC Channel Island not updating portal with new polices.

What we can improve:

Multi prices – Can tolerance be reduced on Rec file as some custodians have slight differences.

List of team members required for the roll back emails not clear.

# data[].attributes.body
What Works well:
- Usual Team Work

- Quarterly prep. tool

- General stats for the Q were on target

- CC worked better this quarter

# data[].attributes.body
What works well:

New quarterly preparation tool.

Tracking of transfers during quarterly prep.

Strong teamwork.

What did not work well:

7IM source file was delivered on Day 6, custodian did not respond to emails or answer phone calls.

# data[].attributes.body
Worked well:

CC worked much better compared to previous quarter

Quarterly prep saving a substantial amount of time during reconciliation

Didn't work well:

Rollback miscommunication. Not all relevant team members were included in key email threads, which led to confusion and delays. (People need to be include: Andres Perez, Ray Chen, Jihoon Lee, Tomi, Seb, Nello, Zoltan)

Change of bank cases were not investigated properly since mid-July, and not everybody was informed(Aug recs)

Room of improvement:

Market movement investigation files should be saved always into the investigation folder.

Rollback-triggering assets could potentially be integrated into the prep tool to enable proactive handling rather than reactive fixes

Question:

What is the reason when you re-run the rec it takes 2-3x longer than the initial run?

Could we support Tomi with the Abacus upload process? For example:

Create a V2 of the Rec file for fee upload by excluding Apache policies or even drop the Abacus upload file?

Would it be possible to arrange a brief training session on Apache? It seems our current understanding of the system is quite limited, and there may be functionalities we’re not using simply because we’re unaware of them

# data[].attributes.body
What Worked Well

Preparation is very helpful

Quarter Prep Tool is great

Team have been very helpful.

What did not work well

Very slow communication from custodians (Itau Intl, EFG PB)

Level 3 assets having no prices because 'not reported anymore' - Despite actually being reported.

What I should improve

Add new ISINs to Bloomberg Lookup File when looked up.

# data[].attributes.body
What worked well:

Clear communication around transfers

Q Prep tool

Day 3 files received on day 2

What didn't work well:

Changing status in CC for v2 files

Confusion between 7IM & Barker Poland for transfers

What we can improve:

Citibank new account process

Davy >:(

# data[].attributes.body
What Works well

- Prep Work was very useful

- Transfers/withdrawal/new business notes ready at hand saved a lot of time

- Team was very helpful and quick to help and explain things

- The coffee machine to fuel the rush:)

What did not work well:

- Custodian response times for separate files (WITH, PIGAE, Missing Policies etc)

CCS front office Response times

New custodian files/formats unexpected changes (last minute)

What we can improve:

- keeping bank process summaries up to date

# data[].attributes.body
What worked well:

prep,

Change of bank,

New prep tool,

rollback emails.

What did not work well:

Quarterly tool not flagging exUI polices (mainly related to FV initials)

What to improve:

adding additional contacts of people involved in DV upload process on the rollback emails,

confirm ID number on the Quarterly Tool,

leave a comment about V2 in the CC,

in case of multiple versions of MM investigations and rec tools, archive ones that are not relevant

# data[].attributes.body
What Works well:

Quarter preparation + New preparation tool

All uploaded by day 5 - No Rollbacks

CC crash only once and automatic backup every 10 min

What do not work well:

What we can improve:

# data[].attributes.body
What we can improve:

once you have a discrepancy and it's confirmed from a pdf will be useful mentioned in the comments so this can avoid further questions and in the case an offical pdf confirmed the value and the movment should be saved in the Rec folder for the custodian

# data[].attributes.body
What Works well:

New prep Tool.

All filed delivered in within the expected date.

CC

Markets

What do not work well:

What we can improve:

CGM. Only 2 Russian assets (Lev III) to report.

I still used Q_Prep Monthly tool to practice in order to flag possible FX market movements.

# data[].attributes.body
What Works well:

- New quarterly prep tool

- Accrued interest checks before enrichments

What do not work well:

-4eye due to Internal derivatives

- For new version of the files due to missing policies or changes, do not update the valuation issuer status in the CC.

What we can improve:

- Reporting Team - ICT.Reporting email

- Update scripts for DI and Group reporting

# data[].attributes.body
All Team Members:

Review the expected delivery date in the CC for all your custodians.

For comments on new business, add a comparison with Abacus or Apache.

Review your custodians to set up SFTP: send an email to Nello to check if an SFTP exists.

Improve your custodians' procedures and save them in the main folder.

Delete personal files from the Bloomberg Lookup folder.

Rachel

Level 3 solution for Q3.

Review Collection accounts in CC.

Developers

Tool for quarterly practice.

Review of the pricing process and accrued interest to avoid roll back.

Add CC to Datavision.

Managers & Team Leaders:

Reassignment of custodians to rebalance teams.

Roll back process.

Training on collection accounts.

# data[].attributes.body
What Works well:

Team work

What do not work well:

Morgan Stanley not adding new accounts to daily feed.

What we can improve:

# data[].attributes.body
All went smoothly on my side, no issues at all. I think every quarter we’re getting better, even if it’s just small improvements in the details. It really shows in how the process runs more efficiently each time. Great job from the whole team!

Let’s keep focusing on improving the small details, especially around prep work and communication with the custodian. We’re making good progress as a team, and the tools and processes are helping us get better each quarter.

Special thanks to Luca for his excellent work on the CS to UBS transfers. Everything went smoothly, and we reported on time with top data quality. Much appreciated.

# data[].attributes.body
Not big issues this Q.

Thank you everybody for the help.

# data[].attributes.body
What we can improve:

For the quarterly MT:

a few policies were opened in DV without any application reference.

Run additional account checks with Franco on Day 1

Seb to remember to send out pricing email on day 1 before quarter-end.

Roll-backs due to large pricing discrepancies. Process to be reviewed with the pricing team.

For day 1 large AUM file we should be able to run the files in preparation for quarter-end so that most of the valuation discrepancies or data issues are explained.

# data[].attributes.body
What worked well:

Prep work - most discrepancies discovered before day 1

Most custodians very responsive to queries

Some custodians provided file 1 day early

What did not work well:

CC tracker

Some source files (DAVY) changed format without notice.

REYL file unclean, holdings file requires a lot of changes

What can be improved:

Market movement tool can give incorrect values, often doesn't help explain discrepancies if done after usual checks ("possible top-up"/"possible surrender")

# data[].attributes.body
Worked well:

Support, team work.

Some of the new custodians provided file earlier than expected

Need improvement:

Quality of procedures

Quality of MT comments

Quality of monthly recs

Mediobanca data feed time/responsiveness.

# data[].attributes.body
What worked well:

Good communication between the team in relation to change of banks

What didn't work well:

L3 file- missing info

CC tracker crashing

What we can improve:

CC tracker

# data[].attributes.body
What Worked well:

Prep and team work

Source files provided on time

Communication with custodians was quick

What do not work well:

CC gets locked many times a day

What we can improve:

High acc. interest checks

# data[].attributes.body
What works well:

Quarterly prep.

Team work.

Email large re-pricing, avoiding roll back.

What do not work well:

No issues with custodians

What we can improve:

CC tracker

# data[].attributes.body
Clari

What worked well

-Team collaboration & support

-Quarter prep

What did not work well

-ATL 12 sent file at end of day 5

-Confusing ATL 12 file's dates causing roll back

-Banca Ifigest being chased for the evaluation of one account

-Transact Platform's process to recover password within quarter

What can be improved

-Bank summaries

-Communication with custodians

# data[].attributes.body
What did work well:

Prep work

Teamwork

CS UK to UBS UK Merge

Backup CC save file

What did not work well:

Rampart sent file on day 6

What we can improve:

Clear process with collection account checks

# data[].attributes.body
What worked well:

Prep. Considering the median in the prep helped predicting almost all the discrepancies. Very few surprises and Market Movements were already investigated. Just needed to be updated

All data feeds received on time this quarter

Antonio's Goldman Sachs Merging Tool

What did not work well

Tracker crashing

Goldman Sachs Home Banking divides accounts in too many groups/sections. Retrieving info is time consuming. Prep work mitigated the problem quite a bit but still improvements can be made.

Azimut Quarterly data feed (TSII value) was incorrect for two ISINs and needed to be integrated with daily feed as well as BNP portal. Flagged to the custodian.

# data[].attributes.body
What did work well:

prep work was more challenging this quarter with big mergers,

all of the change of banks processed with no issues.

Barclays SFTP.

What did not work well:

Rathbones not providing file on time,

Evelyn not providing file on time.

What we can improve:

try to get data feed reported through SFTP,

Rollback process,

In specie transfer procedure.

# data[].attributes.body
What we can improve:

4eyes: Comments for new business needs to contain confirmation that the value of the policy is in line with value in Abacus

Review Market movement tool - agent is losing a lot of time and getting the majority of the time wrong answers

# data[].attributes.body
What Works well:
- Team work

What do not work well:

- Level 3 assets

What we can improve:

- Delivery date in CC

- Collection account check in CC

- Use only 1 tool for Q practice

- Rebalance of custodians complexity and other tasks

- Bloomberg lookup folder

# data[].attributes.body
All Team Members:

Save investigations and transfers in the custodian folder.

Ensure all policies are updated in the MT before sending the file for 4-eye review.

Update CC: passwords, users, and contacts.

Discuss with custodians to increase the frequency of valuation reports.

Nello:

Discuss with developers a new solution for the quarterly reconciliation practice.

Share the script for automatic saving of CC with the team.

# data[].attributes.body
What Works Well

Teamwork

Quarter Prep

CDR process was very smooth

What can we improve:

# data[].attributes.body
What worked well:

Prep work

Transfer communication between team.

Things that did not work well:

New user (Claudio) set up for CA Indo Swiss portal - Delay in getting valuations

Issue with SG Kleinwort format - Resolved by Jokin

Things to improve:

Review of CC tracker - Crashing

# data[].attributes.body
What worked well:

Prep work

Transfer communication between team.

Things that did not work well:

New user (Claudio) set up for Morgan Stanley portal - Delay in getting valuations

Things to improve:

Review of CC tracker - Crashing

# data[].attributes.body
What works well:

The usual prep work

Automatic save for CC tracker

Transfer checker tool

What didn't work well:

CC tracker crashing

A lot of missing policies this quarter

What can we improve:

CC tracker

# data[].attributes.body
What worked well:

-Refresh session very helpful

-Better preparation than previous quarters.

-Better communication around transfers.

-Citibank Lux finally gave personal access to portal (and included all policies in SFTP)

What didn't work well:

-Q Prep & Monthly prep using same tool can be confusing

# data[].attributes.body
What work well:

Team work

Preparation for Q

What do not work well:

For all the EFG files, we are getting some incorrect prices at end of the month, more specific USD accounts.

What we can improve:

It was a really good Q

# data[].attributes.body
What work well:

Team work

What do not work well:

Complex Assets communication

What we can improve:

Communication with Complex assets

# data[].attributes.body
What worked well

Prep and Teamwork

Custodians replied quickly

What did not worked well

Bank Vontobel changed the report file from first day of the Q.

Custodian completeness

# data[].attributes.body
What Works well:
Quarter prep

What we can improve:

Unique tool for quarter preparation

# data[].attributes.body
What works well

Preparation work

Team work

What did not work well

Had more trouble than usual in receiving data feeds (Banca dello Stato, Close Asset)

Sempione SIM, custodian did not receive email from Enate as usual. At a first glance seems to be a problem with Mimecast.

Axion. Median was affected by extreme values (Market Movements on a few accounts). Small discrepancies (around -1%) were flagged by the tool.

# data[].attributes.body
What works well:

Teamwork and Prep work

Quarterly Rec refreshing session

Quarterly vs Monthly Tracker

Transfers communication with agents

# data[].attributes.body
What works well:

Teamwork

Transfers communication within the Team

CDR Team

Repricing

Quarterly Tool

What we can improve:

Communication with Complex Asset

# data[].attributes.body
What worked well:

usual preparation,

Evelyn SFTP,

Transfers communication,

custodians replying fast on the queries.

What did not work well:

Rathbones late with report,

Barclays late with report and report was sent to IOM, we were not notified of delivery being changed.

What to improve:

Enate, unusual number of irrelevant emails coming through our inbox and the solution from Enate team is to investigate and create linked ticket to team responsible for the query?

# data[].attributes.body
What Works well:

- Team requested prices

What do not work well:

- All policies should be up to date in the MT before sending the file to 4EYE.

- Run pre- check and confirm Custodian ID is mandatory before 4eye

- UPE_POL_ACC formula

- Isin_checker formula in 4eye

- Application reference for Apache policies

What we can improve:

- Save investigation on the Q folder

- Use only 1 tool for Q practice

# data[].attributes.body
All team members:

Keep Bloomberg lookup file clean, without internal numbers and ISINs ‘No found’. Also, use attached file as reference to search for a Mini CIC.

Better prepare for the next quarter by following the procedures and using the monthly and quarterly tool.

Review ex UI files to see if there are any receivables or assets that should not be reported.

Use Enate for external communications.

Keep CC up to date with correct date and comments.

Keep investigations in an Archive folder.

Request changes in Access if the LEI code is not correct.

Keep policy – account update in Datavision.

CDR Team:

Create a standardised email to request information on internally numbered assets from custodians or portfolio managers.

Custodian Completeness

Create automatic save for CC - Nello

Remove links in the CC - Rachel

Check if it is possible to use CC in the Cloud – Nello and Anto

Discuss using a Datavision table – Nello, Seb, Francisco

Nello and Mari

Automate Abacus – MT check.

Nello:

Add the median in the tolerance control for the quarterly preparation.

Mari:

Update the price discrepancy file with Q4 information.

Ask developers for changes to the MM tool and prepare a training - with Andres Paredes

Transfer Checker training.

# data[].attributes.body
What we can improve:

Monthly reconciliation investigation

Prep work on daily files to identify discrepancies and change of bank before quarter-end

The file I share for large prices discrepancies

CC tracker

# data[].attributes.body
What works well:

Teamwork and Prep work,

Quarterly Rec refreshing session,

Quarterly vs Monthly Tracker,

Communication sent to custodians before holidays, all files received in time.

What do not work well:

Custodian Completeness file went down many times.

What we can improve:

Change of banks/transfers communication.

# data[].attributes.body
What Works Well:

Great Team work. I received a lot of help from my team.

What we can improve:

CC. Lots of unwanted changes in the file.

Same prep work for shorter custodian than for larger ones from my side

UBS Luxembourg will be sorted faster in next Quarter. I had some issues due to missing assets in the source file.

# data[].attributes.body
What works well:

Team work

What do not work well:

EFG reported two incorrect prices, and we had to roll back their files.

CC was corrupted

Delay in responses from the custodians due to the dates.

What we can improve:

Due to the Christmas holidays, I could have better prepared my custodians for this Q4.

# data[].attributes.body
What work well:

Team work

What do not work well:

Miss information from CCS

Alteration of status in CC

CC broken more than the usual

New Itau Portal

What we can improve:

Communication between departments

Start conversations with Itau international for SFTP

# data[].attributes.body
What works well:

Team work

Quick response from the custodians

What do not work well:

Bank Safra Sarasin Gibraltar has changed the reporting format to SFTP, and some currencies are being reported differently from what is applied.

Banca Ifigest still reporting some Accrued Interest wrong.

What we can improve:

Continue working together with the custodian to improve the quality of the Source files.

# data[].attributes.body
What worked well

Prep work

Custodians responded quickly

Information in Abacus was updated

What did not worked well

Custodian Completeness tracker went down many times

To improve

Bloomberg "Not found" comment is bringing the "N" letter to the tool.

BBG changed the way securities appeared, causing some CIC's to be wrong and creating some discrepancies.

# data[].attributes.body
What works well:

Team Work

Preparation instruments available to practice

What do not work well:

Close Asset changes of data feed where not in line with expectations. Manual work was needed.

Azimut file was received a day after and clarifications were needed for 2 policies

What we can improve:

I did not use fully the lesson learned file from last quarter. Banor roll back could have been avoided

Close Asset data feed needs Accrued Interest