Brokerage Statement Download

Posted under case studies on November 27 , 2019 by Nikita Prashar

Problem Statement:
The process for downloading brokerage statement involves CAMS sending a link to download account statement which is valid only for 15 days. If distributor forgets to download the report within the expiry date, then distributor reaches out to the Relationship Manager to get the account statement by forwarding their request to CAMS. Relationship manager then reaches out to CAMS for the link against the specific distributor. CAMS take a turnaround time of around 4 days to mail the file to the broker.

Distributors very often miss the expiry deadline of the link and this issue is very common in the industry and affects around 40,000 distributors associated with more than 350 branches and call centres for our client.

problem statement

Solution designed by SheetKraft:
CAMS send the link to distributors; this is copied to a generic email id and SheetKraft picks up these emails and downloads the pdfs from the links and stores them in the client’s data warehouse.

Now in a case where the distributor forgets downloading the statement within the expiration of the link and requests the relationship manager for the account statement; The relationship manager inputs the distributor details in the SheetKraft UI, SheetKraft processes the data and automatically emails the requested report to the distributor, This turnaround time once the distributor details are entered in the SheetKraft UI is around 4seconds.


TAGGED:BrokerageMutual FundsCAMSFinance

Recent Posts

Passive Breach Risk

June 02, 2020 byRohan Jangid

Definition: In Mutual Funds, investments are done by Fund Managers. Their job is to invest the…

Continue Reading

AMFI Reports Download

May 29, 2020 byAniket Mahadik

Definition: The Association of Mutual Funds in India (AMFI) is dedicated to developing the Indian…

Continue Reading

Branch Performance Report

May 08, 2020 byNitesh Singh

Branch Performance Report demonstrates the efficiency & productivity of retail bank branches to…

Continue Reading

Purchase Order Invoice Reconciliation

May 06, 2020 byDheeraj Sangore

Introduction: Reconciliation allows any entity to juxtapose their records against the records of…

Continue Reading

Let's talk


7th floor, Unit No. 701, C Wing,
Kailas Business Park, S. Veer Savarkar Marg,
Park Site, Vikhroli (W), Mumbai-400079.



+91 22 62362043


For General Queries & Technical Support


For Sale and Demos