All projects Project 01

Streamlining Portfolio Accounting & Reporting

I transformed a 17-day, error-prone, manual process into a 7-day, automated, secure workflow—delivering real-time, error-free portfolio dashboard for faster, more informed investment decisions.

10
Days saved monthly
90%
Error reduction
12 weeks
Time to completion

01 Context

An investment firm managed multiple family portfolios using accounting software which required data onboarding each month for tracking transactional activity, generating performance reports, filing taxes and investment decision making. The process took roughly 17 days to complete.

02 Problem

  • Manual reconciliation caused data duplication, errors and delays.
  • No filing or email system led to slow data retrieval and multiple follow-ups with service providers.
  • Absence of backups and encryption risked data loss and confidentiality breaches.
  • No real time updates of transaction activity led to delayed decision making.

03 Solutions

Email Tagging

Developed an automated email tagging and notification system to isolate fund and transaction updates.

Secure Filing

Built a structured OneDrive filing hierarchy by family/member with daily backups, encryption and access controls.

Excel Reconciliation

Created Excel-based reconciliation methods to auto-match funds, bank accounts and transactional activities.

Automated Retrieval

Enabled automated data retrieval for transaction statements which removed manual intervention.

04 Outcomes

  • Cycle time halved from 15 to 7 days, saving time for research and portfolio work.
  • Real-time portfolio updates enabled faster and more informed decision making.
  • Standardised reports saved time and efforts of the stakeholders.

05 Reflection

This project showcased how automating manual workflows and centralizing data systems can drastically boost efficiency with faster portfolio reviews and greater stakeholder confidence. Collaboration tools integration like Trello and Monday.com could have closed feedback loops faster and created an efficient reconciliation system and a repository of documents.

06 Skills Acquired

Problem SolvingSystems ThinkingProcess Automation