• ERP Solutions

How TR Capital Turned WhatsApp Queries Into Tracked Tickets on One CRM

Published On: 8 January 2025.By .
CRM & AI Automation: Case Study
TR Capital CRM and AI case study cover showing a WhatsApp customer message moving through an AI chatbot to a ticket on the customer record in the CRM
Financial
Services
Industry
Hisar
Haryana, India
Multi
Product
Equity, IPO, Insurance, Mutual Funds
Frappe
CRM and Ticketing Platform
WhatsApp
AI First Response Channel
OpenAI
Conversational Layer
01: The Challenge

Customer Conversations Were Moving Faster Than the System Could Record Them

TR Capital's advisory and business development teams were running a multi-product relationship business on a platform built for record keeping, not for relationship management. Customer context, lead ownership and incoming queries all lived with individual people rather than in the system.
01
No Single Customer View
Customer details, account information, product holdings, product interest and brokerage terms sat in separate places. An advisor rebuilt the picture from memory and personal files before every conversation.
02
Reporting Compiled by Hand
The platform could not report across customers, products or advisors. Management reviewed pipeline and coverage from sheets compiled by the same teams being reviewed.
03
Queries Ended in an Inbox
Enquiries and service requests arrived over calls and WhatsApp and were handled personally. Nothing recorded who owned a request, what stage it was at, or whether it had been closed.
04
Follow-Ups Tied to One Person
Leads were tracked by whoever sourced them, so follow-ups slipped when that person was travelling, on another call, or moved to a different account.
05
Documents Chased Twice
Document collection ran over informal chat with no record of what had already been received, so advisors asked customers for the same document more than once.
06
No Room to Add Products
New products and new process rules could not be absorbed without workarounds, which put a ceiling on how the business could grow.
02: The Core Idea

Put the Customer Record at the Centre, Then Let Every Channel Write to It

A financial services firm does not have a CRM problem, a ticketing problem and a chatbot problem separately. It has one problem: the relationship is spread across people and channels, and none of it lands somewhere the business can see. The approach was to build one customer record on the Frappe Framework, define lead and request handling on top of that same record, and then treat WhatsApp as an input channel that writes into it rather than a parallel conversation sitting outside it. Each layer was built so the next one had somewhere to write.

03: The Solution

Three Layers, One Customer Record

A CRM, a lead and ticket platform, and an AI chatbot were built on the Frappe Framework and connected to the same customer record, so the request a customer sends and the ticket an advisor works on are the same event.
01
Customer Relationships and Reporting
A single TR Capital customer can hold equity, an insurance policy and a mutual fund position at the same time, each under different brokerage terms. Advisors were reconstructing that picture before every conversation. The CRM holds the whole relationship in one record.
  • Customer details, account information and product holdings sit on one record instead of across separate lists.
  • Product interest is mapped against the customer, so an advisor sees what is already held and what has been asked about.
  • Brokerage details are stored against the relationship rather than kept as a side note held by the advisor.
  • Custom reports run across customers, products and advisors, so management reviews coverage from the system rather than from compiled sheets.
TR Capital CRM built on the Frappe Framework showing customer details, product holdings, product interest and brokerage terms on one record
One customer record: holdings, product interest, brokerage terms and open requests in a single view.
02
Lead and Request Handling
The business development team was carrying leads personally, so follow-up quality depended on individual discipline rather than a defined stage. Enquiries and service requests were handled the same way, with no record of ownership or status. A lead and ticketing platform was built on the same customer record.
  • Every lead is created as a tracked record with an owner, so a follow-up does not depend on who sourced it.
  • Leads move through defined stages, which makes a stalled case visible instead of quietly ageing in someone's notes.
  • Enquiries and service requests are raised as tickets against the customer record, so history stays attached to the relationship.
  • Managers review open leads and open tickets in one place instead of asking each team member for a status.
Ticketing and lead management platform for TR Capital showing lead stages, ticket ownership and progress tracking for the business development team
Leads and service requests carry an owner and a stage, so progress is a system view rather than a personal memory.
03
First Response on WhatsApp
Customers were already using WhatsApp to ask about products, request information and send documents. Those messages reached an advisor's phone and stopped there. An AI chatbot built with OpenAI and Python was connected to the CRM so the channel customers already use becomes a system input.
  • The chatbot holds a natural conversation to work out what the customer is asking for, rather than pushing them through a fixed menu.
  • Once the request is clear, a ticket is created in the CRM automatically, with the conversation attached.
  • Customers upload documents inside the same WhatsApp thread, and those files are processed and attached to the resulting ticket.
  • Advisors pick up a structured ticket with the request and documents already on it, instead of scrolling back through a chat.
AI enabled WhatsApp chatbot for TR Capital reading a customer request, collecting documents and creating a ticket in the CRM automatically
The WhatsApp thread and the CRM ticket are the same event, not two records to reconcile.
04: What Was Built

Named Capabilities

CRM built on the Frappe Framework
Unified customer and account record
Product interest mapping against the customer
Brokerage details held on the relationship
Custom reporting and analytics views
Lead management with defined stages and ownership
Ticketing platform for enquiries and service requests
AI chatbot on WhatsApp using OpenAI and Python
Automated ticket creation from chatbot conversations
Document collection and upload workflow over WhatsApp
05: Technology Stack

Built on the Frappe Framework with an AI Layer

Layer Technology Role
PlatformFrappe FrameworkCRM and ticketing platform, customer record model and workflow engine
BackendPythonBusiness logic, lead and ticket rules, chatbot integration services
AIOpenAIConversational understanding of customer requests on WhatsApp
ChannelWhatsAppCustomer-facing first response and document upload thread
ReportingFrappe reports and dashboardsViews across customers, products, advisors, leads and open tickets
EngagementAuriga IT, Frappe Official PartnerBuild, customisation, integration and support delivered by one team
06: Business Impact

What TR Capital Can Now See and Do

Full Relationship in One View
An advisor opens one record and sees what the customer holds, what they have asked about, what brokerage applies and what is currently open against them.
Every Query Becomes a Ticket
A WhatsApp query becomes a ticket with an owner and a status, so a request no longer ends when the advisor closes the chat window.
Response Without Waiting
Customers get a response on WhatsApp without waiting for an advisor to be free, and send documents in the same thread instead of a separate email.
Reporting From the System
Management reviews pipeline, product interest and open requests from reports the platform produces, rather than from sheets compiled by the teams being reviewed.
Stalled Leads Are Visible
A lead that has not moved shows as a stage that has not changed, which turns follow-up discipline into a management view instead of a memory problem.
Room to Add Products
New products and process rules are added as configuration and customisation inside the same platform, so growth does not wait on another platform replacement.
Why This Case Matters
Industry Context

If Your Customer Conversations Live in Chat, This Is the Same Problem

Most mid-size financial services firms share the same shape of problem. Products are sold by people, relationships are held by people, and customers reach those people on WhatsApp. The record system was designed for accounts rather than conversations, so the business only sees what someone remembers to enter. The answer is not a larger CRM licence. It is a customer record the business owns, request handling defined on top of it, and the channel customers already use writing into it automatically.

What This Proves

The AI Layer Works Because the System Underneath It Is Defined

A multi-product financial services business can move from an ageing internal platform to a customer record it controls, without forcing customers off the channel they already use. The chatbot is valuable here because there is a CRM and a ticket structure for it to create records in, not because it holds a conversation. Any firm where enquiries, follow-ups and documents currently live in individual inboxes can be structured the same way.

07: Frequently Asked Questions

Common Questions About This Project

Why build a CRM on the Frappe Framework instead of buying a standard CRM?

+

TR Capital needed product holdings, product interest and brokerage terms held on the same customer record, with lead and ticket handling defined around how their advisory teams actually work. The Frappe Framework allows those objects and rules to be defined inside the platform rather than worked around it, and there is no per user licence fee as advisor headcount grows.

How does the WhatsApp chatbot avoid creating duplicate or junk tickets?

+

The chatbot creates a ticket only once the request is understood, and it creates it against the customer record rather than as a standalone item. An advisor reviews the ticket before acting, so the automation handles capture while a person handles judgement.

What happens to documents customers send over WhatsApp?

+

Documents uploaded inside the WhatsApp thread are processed and attached to the resulting ticket in the CRM, so they land in the system of record instead of staying on an advisor's phone. Access to those records is controlled inside the platform.

Does the chatbot replace the advisory team?

+

No. It handles the first response, works out what the customer is asking for and collects supporting documents. The advisor still owns the relationship and the decision, and starts from a structured ticket instead of a chat transcript.

How does the CRM handle a customer who holds more than one product?

+

Equity, IPO, insurance and mutual fund holdings sit on one customer record along with product interest and brokerage terms, so an advisor sees the full relationship in a single view rather than reconstructing it across separate lists before every conversation.

Can this be extended to more products or more teams later?

+

Yes. New product types, stages, fields, reports and workflows are added as configuration and customisation within the same platform, which was the main reason for moving off the previous internal system.

More Related Work

Related Case Studies

Related content

Stay Close to What We’re Building

Get insights on product engineering, AI, and real-world technology decisions shaping modern businesses.

Go to Top