Zoho-Powered Portfolio Accounting System for a PMS Firm

New client and account details are captured in Zoho CRM, so the relationship team and the operations team work from the same client information.

Master lists of clients, accounts and securities, including support for multiple client sub-accounts managed under one broker account.

Client onboarding forms through Zoho Forms.

The operations team uploads the day's trade file directly into the system, replacing the old practice of sending files to an outside provider.

Every file is checked before it is accepted, and staff are told exactly what to fix, so bad data never enters client records.

The firm's trades are matched against the custodian's records for both resident and non-resident (NRE/NRO) clients. Nothing is posted until every difference is resolved.

Every uploaded file is saved and can be downloaded again, giving compliance and auditors a clear history of what was received and when.

Daily stock exchange prices are uploaded so every portfolio is valued at the current market price.

Bank statements and client money in and out — new investments, top-ups and withdrawals — are uploaded and matched automatically, with unmatched items flagged for review.

Each client's holdings, average cost, market value and profit or loss stay accurate after every trade.

Holdings can be viewed as of any past date, which makes audits, client queries and month-end reviews simple.

Stock splits, bonus shares, dividends, mergers and demergers are applied to every affected client automatically.

Staff preview exactly which clients a corporate action will affect before confirming it, which prevents costly mistakes across many accounts.

A passbook-style cash balance for every client, updated automatically as trades are recorded.

Daily portfolio value (NAV), double-entry accounting, trial balance, profit and loss, and balance sheet in Zoho Books, plus TDS and short-term and long-term capital gains classification.

Client returns calculated using industry-standard methods (TWRR and XIRR) and compared against market benchmarks such as the BSE 500.

Processing was made faster and more dependable so large client books update on time, and staff are always told if a task did not complete.

Management, custody, audit, account opening and performance fees (on a high-watermark basis) calculated in-house, verified against third-party figures, and invoiced to clients through Zoho Books.

A quick view of overall activity, holdings and recent trades, with drill-down into any client's portfolio and trade history.

Zoho Analytics dashboards give leadership a view of assets under management, strategies, accounts, and money coming in and going out.

One-click reports for client holdings, transactions, cash statements, client lists and corporate actions, with alerts when each report is ready.

32 ready-made report types (portfolio, performance, capital, financial statements, tax and compliance) and 17 on-request data pulls, delivered as Excel or by email.

Audited statements are digitally signed through Zoho Sign and stored in a searchable document library in Zoho WorkDrive.

Daily end-of-day and cash reports, SEBI reports, monthly and quarterly profit and loss and balance sheets, and annual reports are sent automatically by email through Zoho ZeptoMail.

Zoho Flow connects the Zoho apps, and Zoho Cliq alerts the operations team when daily processing finishes or needs attention.

Client questions and report requests handled through Zoho Desk, linked to each client's CRM record.