Skip to main content

Star-knowledge

Customer story

Portfolio Management System Reconciliation

The client needed an automated system to reconcile daily portfolio updates for thousands of accounts — including equity market changes and investment adjustments — ensuring accurate and timely updates in their existing portfolio management system (PMS). We built a custom automation combining Power Automate Desktop, Python, and Power Automate cloud flows that extracts, reconciles, and updates records for roughly 4,000 accounts every day, with reconciled files stored securely in AWS S3. 

Engagement facts

Client

US IT service provider, 30+ years

Industry

context implies financial/wealth management

Region

California, New York, Illinois

Service

Cloud migration & infrastructure

Stack

Azure

Site Recovery

Entra ID

Azure DNS

~ 0

accounts reconciled automatically every day 

3

data sources unified — Excel reports, bank APIs, and market feeds 

5

solution capabilities delivered, from extraction to reporting 

4

business outcomes delivered, from time savings to scalability 

Portfolio Management System

The client

An organization managing daily reconciliation across thousands of portfolio accounts

The client is not named in the source article. What is stated is that the client operates an existing portfolio management system (PMS) and needed daily reconciliation across approximately 4,000 accounts, incorporating equity market changes and investment adjustments. 

The need

One automated system to reconcile daily portfolio updates for thousands of accounts

The client needed an automated system to reconcile daily portfolio updates for thousands of accounts, including equity market changes and investment adjustments, ensuring accurate and timely updates in their existing portfolio management system. 

The challenge

Manual reconciliation across multiple data sources was slow and error-prone

  • Manual reconciliation of approximately 4,000 accounts daily was time-consuming and prone to errors. 
  • Data came from multiple sources, including Excel reports, bank APIs, and market feeds. 
  • Ensuring accurate updates in the existing PMS system required precision and consistency. 
  • Generating reconciled records and storing them for reporting posed operational challenges. 

The solution

A combined Power Automate Desktop, Python, and cloud-flow automation

Star Knowledge developed a custom automation solution combining Power Automate Desktop, Python scripts, and Power Automate cloud flows. The workflow automated extraction, reconciliation, and updating processes, while approvals and validations were integrated where necessary. Data was processed, reconciled, and securely stored in AWS S3 buckets for future reference. 

01

Automated data extraction

Automated data extraction from Excel reports, bank APIs, and equity market feeds. 

02

Python-based reconciliation workflow

Built a reconciliation workflow using Python scripts integrated with Power Automate Desktop. 

03

Daily PMS updates

Delivered daily updates to the client’s PMS system for all accounts. 

04

Secure AWS S3 storage

Stored reconciled files securely in AWS S3 buckets. 

05

Notifications & reporting

Delivered notifications and reporting for reconciled records. 

Benefits

What changed for the client

Time savings

Eliminated manual reconciliation for 4,000 accounts every day. 

Data accuracy

Automation reduced errors and ensured reliable updates. 

Operational efficiency

Streamlined daily PMS updates with minimal human intervention. 

Scalability

Solution easily accommodated increasing portfolio accounts and data volume. 

Technology

What we used

Reading this because your team is still reconciling portfolio accounts by hand?

See how our automation team scopes a reconciliation workflow build. 

Your reconciliation

Looking to get a similar solution?

Feel free to contact our expert team — we will help you get your project done. 

More migration work

Related case studies