Kaizen 224 - Quote-driven Deal Reconciliation Using Zoho CRM Functions and Automation

Hello everyone!

Welcome back to another instalment in the Kaizen series.

This post covers quote-driven deal reconciliation, emphasizing Functions and Automation to address practical sales challenges.

Business Challenge

Sales organizations often mark deals as Closed Won before commercial transactions fully conclude. Quotes generate promptly upon closure, yet businesses typically provide a brief window such as one week for renegotiation or payment. During this period, currency fluctuations, payment delays, and risk thresholds can significantly alter the final deal value.

This Kaizen demonstrates how Zoho CRM Functions and Automation work together to reconcile deal financials with quote activity over time. Sales, finance, and operations teams can thus access accurate, policy-compliant values.

Here is a typical sequence:

1. Deal closes with Closed Won status
   
2. Quote generates immediately
   
3. Customer receives grace period (e.g., one week) for payment or adjustments
   

Key factors during this window:

1. Exchange rates fluctuate
   
2. Payments may succeed or fail
   
3. Business absorbs limited losses(up to 10%, for example)
   
4. Major variances trigger renegotiation
   

CRM must reflect actual outcomes rather than initial closure assumptions. Quotes serve as the authoritative commercial record, with final deal values depending on execution timing. This approach captures intermediate and final financial states to enable automated decisions and audits.

Key business scenarios covered

Scenario 1: Payment is made during the grace period

1. Quote is generated on day 0
   
2. Customer completes payment on day 7
   
3. Exchange rate has changed since quote generation
   

Business Requirement

The business wants to calculate the actual payable amount using the exchange rate on the payment day and store it explicitly in CRM.

Outcome

The realized value is captured and stored, ensuring that reports and downstream systems reflect the true commercial result.

Scenario 2: Acceptable loss threshold (10%)

1. Exchange rate movement results in a loss
   
2. The business is willing to absorb losses up to 10%
   
3. Loss exceeds the acceptable threshold
   

Business requirement

If the loss exceeds the defined tolerance, the quote should move to renegotiation instead of being accepted automatically.

Outcome

CRM enforces pricing policy consistently, without manual intervention or subjective judgment.

Scenario 3: Significant currency fluctuations

1. Exchange rate volatility is unusually high
   
2. Even if loss is within limits, risk exposure is significant
   

Business requirement

Large fluctuations should trigger renegotiation, regardless of absolute loss percentage.

Outcome

Financial risk is handled proactively based on measurable criteria.

Scenario 4: No payment after the grace period

1. Customer does not pay within the allowed window
   
2. Updated exchange rate is favorable to the business
   

Business Requirement

If the updated rate is profitable, the quote can be revised and reissued with the new amount.

Outcome

CRM reflects market-aligned pricing while maintaining transparency around why the amount changed.

Why Zoho CRM Functions is the best fit?

This reconciliation pattern requires the following capabilities beyond static configuration.

1. Reading and reconciling data across Deals and Quotes
   
2. Applying time-based and threshold-based business rules
   
3. Writing calculated values into dedicated fields
   
4. Supporting multiple decision paths(accept, renegotiate, revise)
   
5. Running logic at specific business moments
   

Zoho CRM Functions provide the flexibility and control required to implement this logic cleanly, while automation ensures it runs consistently and reliably.

Custom fields used in this post

Deals

1. Final Accepted Amount - Currency - Amount finally agreed and accepted
   
2. FX Impact Percentage - Percent - Gain or loss due to exchange movement
   
3. Reconciliation Status - Picklist - Accepted or Renegotiate
   
4. Reconciled On - DateTime- Timestamp of final reconciliation
   

Quotes

1. Quote Reference Amount - Currency - Amount at quote generation
   
2. Quote Exchange Rate - Decimal - Exchange rate used in quote
   
3. Payment Due Date - Date - End of grace period
   
4. Potential Payable Amount - Currency - Recalculated amount at evaluation time
   
5. FX Variance Percentage - Decimal - Difference vs quoted amount
   
6. FX Evaluation Status - Picklist - Pending or Evaluated
   
7. Recalculate FX - Checkbox - Explicit recalculation trigger
   

These fields capture commercial intent and outcome, not just static numbers.

High level automation flow

1. Deal is marked Closed Won
   
1. Workflow triggers a function to generate a Quote
   
2. Business updates evaluation inputs when needed
   
3. User explicitly triggers FX recalculation
   
4. Function
   
1. Calculates financial impact
   
2. Updates quote and deal
   
3. Applies business decisions
   
5. CRM reflects finalized commercial reality
   

Function 1: Generate a Quote from the Deal

This function creates a Quote automatically when a Deal is closed, ensuring downstream processes start immediately and consistently.

void automation.generateQuoteFromDeal(int dealId) { deal = zoho.crm.getRecordById("Deals", dealId); if(deal == null) return; amount = deal.get("Amount"); exchangeRate = deal.get("Exchange_Rate"); account = deal.get("Account_Name"); productItem = Map(); productItem.put("product", {"id":"<PRODUCT_ID>"}); productItem.put("quantity", 1); productItem.put("list_price", amount); productList = List(); productList.add(productItem); quoteMap = Map(); quoteMap.put("Subject", "Quote for Deal"); quoteMap.put("Deal_Name", dealId); quoteMap.put("Account_Name", account.get("id")); quoteMap.put("Product_Details", productList); quoteMap.put("Quote_Stage", "Draft"); quoteMap.put("Valid_Till", zoho.currentdate.addDay(7)); quoteMap.put("Quote_Reference_Amount", amount); quoteMap.put("Quote_Exchange_Rate", exchangeRate); zoho.crm.createRecord("Quotes", quoteMap); }

Function 2: Reconcile Deal from Quote

This function calculates payable values, evaluates financial impact, and updates the Deal with finalized financial information.

void automation.reconcileDealFromQuote(Int quoteId) { info "Starting FX reconciliation for Quote ID: " + quoteId; // ------------------------------------------------- // Fetch Quote // ------------------------------------------------- quote = zoho.crm.getRecordById("Quotes", quoteId); if(quote == null) { info "Quote not found"; return; } dealInfo = quote.get("Deal_Name"); if(dealInfo == null) { info "Quote not linked to Deal"; return; } dealId = dealInfo.get("id"); deal = zoho.crm.getRecordById("Deals", dealId); if(deal == null) { info "Deal not found"; return; } // ------------------------------------------------- // Mark FX Evaluation as PENDING // ------------------------------------------------- zoho.crm.updateRecord( "Quotes", quoteId, {"FX_Evaluation_Status" : "Pending"} ); // ------------------------------------------------- // Read required FX inputs // ------------------------------------------------- quotedAmount = quote.get("Quote_Reference_Amount"); quoteRate = quote.get("Quote_Exchange_Rate"); evaluationRate = quote.get("Evaluation_Exchange_Rate"); info "Quoted Amount: " + quotedAmount; info "Quote Rate: " + quoteRate; info "Evaluation Rate: " + evaluationRate; if(quotedAmount == null || quoteRate == null || evaluationRate == null) { info "Missing required FX inputs"; return; } // ------------------------------------------------- // FX Calculations(rounded) // ------------------------------------------------- payableAmount = (quotedAmount * evaluationRate / quoteRate).round(2); fxVariance = (((payableAmount - quotedAmount) / quotedAmount) * 100).round(2); info "Payable Amount: " + payableAmount; info "FX Variance %: " + fxVariance; // ------------------------------------------------- // Decide Quote Stage(Business decision here) // ------------------------------------------------- quoteStage = ""; reconciliationStatus = ""; if(fxVariance <= 10) { quoteStage = "Acceptable FX Impact"; reconciliationStatus = "Accepted"; } else { quoteStage = "FX Impact Exceeds Threshold"; reconciliationStatus = "Renegotiate"; } // ------------------------------------------------- // Update Quote(Final state) // ------------------------------------------------- quoteUpdate = Map(); quoteUpdate.put("Potential_Payable_Amount", payableAmount); quoteUpdate.put("FX_Variance_Percentage", fxVariance); quoteUpdate.put("FX_Evaluation_Status", "Evaluated"); quoteUpdate.put("Quote_Stage", quoteStage); quoteUpdate.put("Recalculate_FX", false); quoteResp = zoho.crm.updateRecord("Quotes", quoteId, quoteUpdate); info "Quote update response:"; info quoteResp; // ------------------------------------------------- // Update Deal // ------------------------------------------------- dealUpdate = Map(); dealUpdate.put("Final_Accepted_Amount", payableAmount); dealUpdate.put("FX_Impact_Percentage", fxVariance); dealUpdate.put("Reconciliation_Status", reconciliationStatus); dealUpdate.put( "Reconciled_On", zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssXXX") ); dealResp = zoho.crm.updateRecord("Deals", dealId, dealUpdate); info "Deal update response:"; info dealResp; info "FX reconciliation completed successfully"; }

Workflow

Module: Quotes

Trigger: On create or edit

Condition: Recalculate FX = true

Action: Execute reconcileDealFromQuote

Argument: quoteId -> ${Quotes.id}

All decision logic lives inside the function.

Business Outcome

After implementing this pattern,

1. Deals and quotes stay aligned with real-world behavior
   
2. FX risk is measurable and auditable
   
3. Renegotiation is policy-driven
   
4. Reports reflect finalized values, not assumptions
   
5. Sales and finance operate on the same truth.
   

Summary

Zoho CRM extends beyond static closures by reconciling deals against quote behavior. Functions plus Automation enforce pricing, limit exposure, and capture true outcomes reliably at scale.

The true value of this implementation is not the calculation itself, but the fact that it produces stable, auditable financial states that can be reused across reporting, approvals, integrations, and policy enforcement.

Further extensions

Executive reporting and dashboards

You can build Dashboards that answer questions like

1. Total revenue before vs after FX reconciliation
   
2. Total FX gain or loss by
   
1. Region
   
2. Currency
   
3. Quarter
   
3. Sales owner
   
4. Percentage of deals renegotiated due to FX risk
   

Without the function,

1. FX impact is implicit
   
2. Numbers keep changing
   
3. Finance does not trust reports
   

With the function,

1. Final Accepted Amount is stable
   
2. FX Impact % is explicit
   
3. Reconciled On gives a time anchor
   

Policy enforcement and compliance

Examples

1. Automatically flag deals where FX loss > 10% but status = Accepted
   
2. Audit trail for
   
1. Who recalculated FX
   
2. When renegotiation was triggered
   
3. SLA checks when Deals are not reconciled within 'X' days of quote creation
   

For many companies, FX policy violations are discovered at a later point in time, but you now enforce them at the moment of decision.

Sales coaching and deal hygiene

Unlock insights such as

1. Which sales reps close deals with high FX volatility or frequently trigger renegotiation?
   
2. Which regions or currencies produce unstable deals?
   
3. Which deals are consistently over-optimistic at closure?
   

Other scenarios

1. Approval and exception workflows
   
2. Integration with ERP or accounting systems
   
3. Predictive insights to forecast FX risk
   
4. Historical snapshots for audit and analytics
   

We hope you found this post useful. Let us know your feedback in the comments or write to us at support@zohocrm.com.

Thanks!

=============================================================================

See Also

1. Functions in Zoho CRM
   
2. Deluge Integration Tasks for CRM
3. Previous Kaizen: 223 - File Manager in CRM Widget Using ZRC Methods
4. Kaizen Directory

• Topic Participants

• Shylaja S

  

• Sticky Posts

• Kaizen #198: Using Client Script for Custom Validation in Blueprint

  Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.

• Kaizen #226: Using ZRC in Client Script

  Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this

• Kaizen #222 - Client Script Support for Notes Related List

  Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore how

• Kaizen #217 - Actions APIs : Tasks

  Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.

• Kaizen #216 - Actions APIs : Email Notifications

  Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are

• Recent Topics

• Translation from Chinese (Simplified) to Chinese (Traditional) is not working. It randomly translated. Google Translate accurately but zoho translate is not working at all

  Hi friends, The newly added language for translation. https://www.zoho.com/deluge/help/ai-tasks/translate.html "zh" - Chinese "zh-CN" - Chinese (Simplified) "zh-TW" - Chinese (Traditional) my original text: 郑这钻 (and it is zh-CN) translated traditional

• The Social Playbook - January edition: Getting started with content creation

  Social media isn’t just about posting some random content. It’s about why certain content works, how brands stand out, and what makes people pause mid-scroll. The Social Playbook is a monthly community series where we break all of that down. Through real

• Support for Custom Fonts in Zoho Recruit Career Site and Candidate Portal

  Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While these

• Adding bank details to the contact through API

  How to add bank-related information to the contact while creating it using API? The account number needs to be encrypted before sending it through API but not sure how to encrypt and get those values. Please guide me in this.

• Font breakage in Zoho Mail Desktop Lite application for Mac

  Dear Zoho Mail and Workplace Community, With the latest update of macOS Sequoia and macOS Tahoe, there has been font breakages in the email preview of Zoho Mail Desktop Lite application for Mac. This breakage is due to the corruption of the System fonts

• Feature request - image resizing on sales orders

  I need to be able to show the items on the sales orders, currently the item image shows really small and no way to resize it, need the ability to make the image larger to showcase the product on the pdfs

• Nueva edición de "Ask The Expert" en Español Zoho Community

  ¡Hola Comunidad! ¿Te gustaría obtener respuestas en directo sobre Zoho CRM, Zoho Desk u otra solución dentro de nuestro paquete de CX (Experiencia del Cliente? Uno de nuestros expertos estará disponible para responder a todas tus preguntas durante nuestra

• Automation Series: Auto-Notify External Users on Issue Closure

  Hello Folks! In Zoho Projects, you can notify external issue reporters via email when an issue is marked as Closed. This helps the users avoid manual follow-ups and keeps the reporter updated. In this post, we’ll walk through a simple setup using a Web

• Turn chat conversations into real action with Integration Blocks in Guided Conversations

  When a Guided Conversation fails, it's usually not because the logic is wrong. They fail because the conversation stops moving. A customer starts a chat with a clear goal: report an issue, check a status, or confirm something. At first, the flow does

• Basic Mass Update deluge schedule not working

  I'm trying to create a schedule that will 'reset' a single field to 0 every morning - so that another schedule can repopulate with the day's calculation. I thought this would be fairly simple but I can't work out why this is failing : 1) I'm based in

• click to call feature

  I've Zoho CRM and in that i want click to call feature.

• Can the Product Image on the Quote Template be enlarged

  Hello, I am editing the Quote Template and added ${Products.Product Image} to the line item and the image comes up but it is very tiny. Is there anyway that you can resize this to be larger? Any help would be great! Thanks

• Creating Parent Child relationship in Accounts

  We have customers with multiple locations, I setup the HQ as an account, then I setup the different sites marking the HQ as the parent to that location. If I then do a Deal for one of the locations, is there a way to show by looking at the parent account

• Learner transcript Challenges.

  Currently i am working on a Learner Transcript app for my employer using Zoho Creator. The app is expected to accept assessment inputs from tutors, go through an approval process and upon call up, displays all assessments associated with a learner in

• Client and Vendor Portal

  Some clients like keeping tabs on the developments and hence would like to be notified of the progress. Continuous updates can be tedious and time-consuming. Zoho Sprints has now introduced a Client and Vendor Portal where you can add client users and

• need a packing list feature

  In our business, goods listed on an invoice are packed in separate boxes and shipped off. for e.g. an invoice may have 10 items. each item could then be packed in different boxes depending on qty of each item. this packing list is as important as the invoice for purposes of shipping documents.  Request you to add this feature asap.

• Recording the deducted TDS on advance received from Customer (Zoho Books India)

  Hi, How can we record the tds that has been deducted by my customer for the advance that he has paid to me. 1) My customer has paid Rs 10000 to me as advance (Rs 9800 as cash and deducted Rs 200 as TDS). I am not able to record the tds that has been deducted

• #7 Tip of the week: Delegating approvals in Zoho People

  With Zoho People, absences need not keep employees waiting with their approval requests. When you are not available at work, you can delegate approvals that come your way to your fellow workmate and let them take care of your approvals temporarily. Learn more!

• Admin Tip: Manage sub-domain emails using sub-domain stripping

  As an admin, you may need separate domains for different departments such as sales, support, and marketing. While this approach offers flexibility, creating and managing multiple domains can quickly become overwhelming, especially since each domain requires

• Quick Copy Column Name

  Please add the ability to quickly copy the name of a column in a Table or Query View. When you right-click the column there should be an option to copy the name, or if you left-click the column and use the Ctrl+C keyboard shortcut it should copy the

• Ability to Edit YouTube Video Title, Description & Thumbnail After Publishing

  Hi Zoho Social Team, How are you? We would like to request an enhancement to Zoho Social that enables users to edit YouTube video details after the video has already been published. Your team confirmed that while Zoho Social currently allows editing the

• How do I remove a data source from Zoho Analytics?

  I am unable to find a delte option on a datasource that i put in the system as an error. On teh web it refers to a setup icon but I do not see that on my interface?

• Add Employee Availability Functionality to Zoho People Shift Module

  Hello Zoho People Product Team, Greetings and hope you are doing well. We would like to submit a feature request to enhance the Zoho People Shift module by adding employee availability management, similar to the functionality available in Zoho Shifts.

• Bigin, more powerful than ever on iOS 26, iPadOS 26, macOS Tahoe, and watchOS 26.

  Hot on the heels of Apple’s latest OS updates, we’ve rolled out several enhancements and features designed to help you get the most from your Apple devices. Enjoy a refined user experience with smoother navigation and a more content-focused Liquid Glass

• Is Desk Down?

  Across department - always an error. [Status Mode] - error [Table View and the rest] - working

• How do I change the wording of the tile of SignForm?

  When my user opens a SignForm url, the title that is presented is always "SignForm signer Information" and a form is displayed asking for the username and email address. This can be confusing to the end user. How can I change the title at least (Or at

• How to link tickets to a Vendor/Vendor Contact (not Customer) for Accounting Department?

  Hi all, We’re configuring our Accounting department to handle tickets from both customers and vendors (our independent contractors). Right now, ticket association seems to be built around linking a ticket to a Customer / Customer Contact, but for vendor-originated

• Automatic Matching from Bank Statements / Feeds

  Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these

• Unify Overlapping Functionalities Across Zoho Products

  Hi Zoho One Team, We would like to raise a concern about the current overlap of core functionalities across various Zoho applications. While Zoho offers a rich suite of tools, many applications include similar or identical features—such as shift management,

• Automation #7 - Auto-update Email Content to a Ticket

  This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Email is one of the most commonly

• Ticket to article and Ticket to template

  Hello! I would like to know if it is possible (and how) to do the following actions: 1. To generate an article from a ticket (reply + original message) 2. Easy convert an answer to an email template

• Is there API Doc for Zoho Survey?

  Hi everyone, Is there API doc for Zoho Survey? Currently evaluating a solution - use case to automate survey administration especially for internal use. But after a brief search, I couldn't find API doc for this. So I thought I should ask here. Than

• Kaizen #225 - Making Query-based Custom Related Lists Actionable with Lookups and Links

  Hello everyone! Welcome back to another post in the Kaizen series! This week, we will discuss an exciting enhancement in Queries in Zoho CRM. In Kaizen #190, we discussed how Queries bridge gaps where native related lists fall short and power custom related

• WebDAV / FTP / SFTP protocols for syncing

  I believe the Zoho for Desktop app is built using a proprietary protocol. For the growing number of people using services such as odrive to sync multiple accounts from various providers (Google, Dropbox, Box, OneDrive, etc.) it would be really helpful

• Change the "from" field

  Hello, I used some random word to create the account ID to later host the domain based emails. That username shows up in the "from" field on test emails. How do I change that to a custom one, like first name/last name or business name? I tried to create second user and "named" it the way I want and it worked to a degree, although the "from" field shows all lower case letters, while original had some capital letters. So the "all-low-case" is another issue I am having... Thank you

• [Free Webinar] Learning Table Series - AI-Enhanced Logistics Management in Zoho Creator

  Hello Everyone! We’re excited to invite you to another edition of Learning Table Series, where we showcase how Zoho Creator empowers industries with innovative and automated solutions. About Learning Table Series Learning Table Series is a free, 45-60

• How to use Rollup Summary in a Formula Field?

  I created a Rollup Summary (Decimal) field in my module, and it shows values correctly. When I try to reference it in a Formula Field (e.g. ${Deals.Partners_Requested} - ${Deals.Partners_Paid}), I get the error that the field can’t be found. Is it possible

• Zoho Creator to Zoho CRM Images

  Right now, I am trying to setup a Notes form within Zoho Creator. This Notes will note the Note section under Accounts > Selected Account. Right now, I use Zoho Flow to push the notes and it works just fine, with text only. Images do not get sent (there

• Error Logs / Failure logs for Client Scripts Functions

  Hi Team, While we are implementing client scripts for the automation, it is working fine in few accounts but not working for others. So, it would be great if we can have error Logs for client scripts also just like custom functions. Is there any way that

• Zoho Books blocks invoicing without VeriFactu even though it is not mandatory until 2027

  I would like to highlight a very serious issue in Zoho Books for Spain. 1. The Spanish government has postponed the mandatory start of VeriFactu to January 1st, 2027. This means that during all of 2026 businesses are NOT required to transmit invoices

• Next Page