Function #49: Manage varying installment payments using Zoho Books

.

Hello everyone, and welcome back to our series!

Last week, we discussed automating the collection of fixed installment payments in Zoho Books. But what if your payment structure involves charging varying percentages of the invoice total as installments? We've got you covered with a solution—a Custom Button that simplifies the process.

Let's consider an example where Mr. John Hector is availing the services of Zylker Designs to build a website for his new business. The total project cost is $5,000 and is divided into the following milestones:

Initial Discussion: 10%

Design Phase: 30%

Development Phase: 40%

Final Delivery and Testing: 20%

Let's see how this payment structure can be handled in Zoho Books using a Custom Button.

First, Zylker Designs should create a sale invoice of $5,000 in their Zoho Books organization. When it's time to bill for a milestone, they can click the Custom Button and input the percentage of the invoice total to be charged. Then, a retainer invoice is automatically created and sent to the client. Once the payment for this installment is recorded, another custom function will apply it to the sale invoice, reducing the balance accordingly. This process can be repeated for each milestone until the invoice is fully paid.

But wait, there's more!

In addition to the Custom Button, we are also sharing a Related List script. This script displays information about the installment payments, such as the associated Retainer Invoice number, amounts paid, and the invoice balance both in amount and percentage.

Prerequisites: 

1. Create a Connection named "zbooks" to successfully execute the scheduler. You can watch the GIF attached below to know how to create the connection.

2. Create a Decimal-type custom field called "Installments" for the Invoices. This field will dynamically reflect the percentage of the invoice total that has been billed. 

3. Create a new Retainer Invoice template with the document title "Installment Payment". Then, copy the template ID (You can get the ID from the URL of the webpage) and substitute it in line 19 of the custom button script. This ensures that all the retainers sent for collecting installment amounts are correctly labeled.



(1) Custom Button to create Retainer Invoices:

Go to Settings -> Sales -> Invoices -> Custom Buttons -> Click +New -> Populate the details as mentioned below:

1. Name - Give a suitable name (e.g., Send Installment Invoices).

2. Visibility - Select the option that aligns with your preference for granting users access to the custom button.

3. Location - Choose "Details Page Menu".

Once done, add the script from this GitHub link -> Click "Edit Arguments" > Input the Param name as "Percentage" and Param type as "String" -> Save. 

Note: Input only "Percentage" as the Param name. 

(2) Custom Function to apply installment payments to the sale invoice:

Navigate to Settings -> Automation -> Workflow Actions -> Custom Functions -> +New Custom Function- > Module -> Select Retainer Invoice -> Add the function code from this GitHub Link -> Save. 

(3) Workflow Rule to apply instalment payments:

Go to Settings -> Automation -> Workflow Rules -> +New Workflow Rule and set up the workflow rule as shown below:-

In the final step of this workflow rule, associate the custom function you created and then hit Save.

(4) Related List:

Navigate to Settings -> Sales -> Invoices -> Related Lists -> +New Related List. Provide a suitable name, select view preferences, and then paste the script from this GitHub link. Save the changes.

Here's how to access the Custom button:

Go to Sales -> Invoices -> Click on the invoice for which you need to generate installment invoices -> Click the custom button "Send Installment invoices" -> Input the percentage to be charged -> Execute. 

Do give this a try and let us know how you liked it. If you need any help with setting up this automation, feel free to contact our support team at support[at]zohobooks[dot]com. We're here to assist you every step of the way.

Regards,

Shireen Farhana

Zoho Books

• Topic Participants

• Shireen Farhana

  

• Agustin Gomez

• Steven Kelty

• Recent Topics

• Zoho Mail POP & IMAP Server Details

  Hello all! We have been receiving a number of requests regarding the errors while configuring or using Zoho Mail account in POP/ IMAP clients. The server details vary based on your account type and the Datacenter in which your account is setup. Ensure

• Ever since the new Android App udpates notifications are not working

  notifications are not working for the app is its closed I followed the tutuorial to the notificaction fixed and everythig seems to be right but notifications are not workig

• Zoho Analytics & Zoho Desk - but not all desks

  I have several desks in our company and one of those is used by our HR department. I want to bring through the data to the shared Zoho Analytics workspace - except for the HR desk. Can this be excluded at data import stage ?

• Incoming Emails Not Showing Up in Zoho Inbox

  Hi - I have my Zoho email account set up to forward a copy of all incoming emails to a secondary Gmail address, whilst retaining the original email in the Zoho inbox. However, all my incoming emails are currently not showing up in my Zoho inbox, so I'm

• Unable to Create Zoho Booking via the Book Appointment API

  Its giving the below error {     "response": {         "errormessage": "Error setting value for the variable:customer_details\n null",         "status": "Error"     } } Request: POST Url: https://www.zohoapis.in/bookings/v1/json/appointment attached Zoho-oauthtoken

• SHEET - Send email when a cell changes

  I would like to create a custom function for Zoho Sheet that triggers when a paticular cell changes to a specific value. This would result in sending an email to a recipient (this would be an address that remains the same and included in the script). Example: = IF(N4= "Drafted", <>EmailFunction) 1)     Cell N4 changes to "Drafted" 2)    Email is sent to recipient            or alternatively 3)    Post to chat channel I have found the Custom function editor in Sheet. I am not bad at scripting, but

• Apply transaction rules to multiple banks

  Is there any way to make transaction rules for one bank apply to other banks? It seems cumbersome to have to re-enter the same date for every account.

• 【開催報告】 福岡 ユーザー交流会 2025/8/8（金）

  皆さま、こんにちは。コミュニティチームの中野です。 8/8（金）に、福岡 ユーザー交流会を開催しました。 本投稿では、その様子をお届けします。当日の登壇資料などもこちらに共有しますので、参加できなかった皆さまもご参照ください。 今年初の開催となる福岡 ユーザー交流会では、CreativeStudio樂合同会社 前田さんによるZoho CRM / Sign / Survey の事例セッションのほか、 Zoho社員セッションでは、Zoho Forms の活用法を解説。 さらに、「見込み客・顧客データの管理/活用方法」をテーマに参加者同士でZoho

• no me llegan los correos a Zoho mail

  No puedo recibir correos pero sí enviarlos, ya hice la modificación de MX y la verificación de teléfonos, qué es lo que ocurre? gracias

• Error: Invalid login: 535 Authentication Failed

  I have used zoho with nodemailer. const transporter = nodemailer.createTransport({ host: 'smtp.zoho.com', port: 465, secure: true, auth: { user: 'example@example.com', pass: 'password' } }); While sending the mail, it shows the following error: Error:

• Zoho Renewal

  Hello, If I am not going for zoho email renewal. will i get back my free zoho account? and if yes then is it possible to get back my all free user. how many user get back 10 or 25?

• Not reciving emails

  Apparently i cannot recive emails on my adress contact@sportperformance.ro I can send, but do not recive. The mail i'm trying to send from mybother adress gets sent and doesn't bounce back... but still doesn't get in my inbox. Please advise

• Not receiving MailChimp verification e-mail

  It seems that their verification e-mails are blocked. I can receive their other e-mails, but not their verification of domain ownership e-mail. I've checked and double checked how I typed the e-mail, using different e-mails (my personal e-mail can receive it), white listing the domain and all that is left is for the IP's to be white listed, but I don't have that power.  If a staff member could take a look at this -> http://mailchimp.com/about/ips/ And perhaps white list them for me, that would be

• Creating my 2nd email account

  After creating my first email address, I decided to get another email address. I would like to use this new address as the primary address too. I don't know how to set it up there doesn't seem to be an option for that

• Cannot - create more email account - Unusual activity detected from this IP. Please try again after some time

  Hello, I come across the error message in Control Panel. Unusual activity detected from this IP. Please try again after some time and i cannot create any more users We are an IT company and we provide service for another company Please unlock us.

• "Unable to send message;Reason:553 Relaying disallowed. Invalid Domain"

  Good day. When I try to send mail through ZOHO mail I get the following error : "Unable to send message;Reason:553 Relaying disallowed. Invalid Domain" I need help with this. My zohomail is : @eclipseweb.site Thank you,

• Transfert de domaine pour création des comptes emails

  Bonjour , je ne parviens point à créer des mails avec le domaine 'raeses.org' suite à la souscription du domaine auprès d'un autre hébergeur, dont j'ai fait la demande du code de transfert qui est le suivant : J2[U8-l0]p8[ En somme, attente de l'activation

• Help! Unable to send message;Reason:554 5.1.8 Email Outgoing Blocked.

  Kindly help me resolved this issue that i am facing here.

• How are people handling estimates with Zoho inventory?

  We are often using Zoho Books for estimates that then get converted to invoices within Books. We would like the sales team to migrate entirely to Zoho Inventory and no longer need to use Zoho Books so that they are only on one system. How are people managing

• Relative Date Searches

  Currently in the search options, it has "date", "from date" and "to date". I think it would be great if there were options like "date greater than x days ago" and "date less than x days ago". I realise that as a once off you can just use the existing

• Performance is degrading

  We have used Mail and Cliq for about three years now. I used to use both on the browser. Both have, over the past 6 months, had a severe degradation in performance. I switched to desktop email, which appeared to improve things somewhat, although initial

• Ask the Experts 23: Customize, utilize, and personalize with Zoho Desk

  Hello everyone! It's time for the next round of Ask the Experts (ATE). This month is all about giving Zoho Desk a complete makeover and making it truly yours. Rebrand Zoho Desk with your organization’s details, customize ticket settings based on your

• Dear Zoho CEO: Business Growth is about how you prioritise!

  All of us in business know that when you get your priorities right, your business grows. Zoho CRM and Zoho Books are excellent products, but sadly, Zoho Inventory continues to lag behind. Just this morning, I received yet another one-sided email about

• Payroll In Canada

  Hi, When can we expect to have payroll in Canada with books 

• Please review and re-enable outgoing emails for my domain

  Hello Zoho Support, I have recently purchased a new domain and set up email hosting with Zoho. However, my account shows "Outgoing Email Blocked". I am a genuine user and not sending bulk/spam emails. Please review and re-enable outgoing emails for my

• Payroll without tax integrations (i.e. payroll for international)

  It seems as though Zoho waits to develop integrations with local tax authorities before offering Zoho Payroll to Zoho customers in a country. Please reconsider this approach. We are happy Zoho Books customers, but unhappy that we have to run payroll in

• goingout e mail block

  info@ozanrade.com.tr

• Incoming mails blocked

  Zoho User ID : 60005368884 My mail Id is marketing#axisformingtechnology.com .I am getting following message "Your Incoming has been blocked and the emails will not be fetched in your Zoho account and POP Accounts. Click here to get unblocked." Please

• Assistance Needed: Ticket Status Not Updating and Sorting by Last Customer Reply in Zoho Desk

  Hello, I’m facing two issues in Zoho Desk that I’d like your guidance on: Ticket Status Not Updating: When a customer replies to a ticket, the status does not change to Reopened. Instead, it remains in Waiting on Customer, even after the customer’s response

• Configuring Email Notifications with Tautulli for Plex

  Hi I'm new to Zoho. I am from Canada and I have a I use a web based application called Tautulli for Plex that monitors my Plex media server. It also sends a newsletter to my followers. To set this up they require a "From" email address., a smtp server

• Is there a way to automatically add Secondary Contacts (CCs) when creating a new ticket for specific customers?

  Some of our customers want multiple contacts to receive all notifications from our support team. Is there a way to automatically add secondary contacts to a ticket when our support team opens a new ticket and associates it with an account? This would

• How to Set Up Zoho Mail Without Cloudflare on My Website

  I'm having some trouble with Cloudflare here in Pakistan. I want to configure Zoho Mail for my domain, but I'm not sure how to set it up without going through Cloudflare. My website, https://getcrunchyrollapk.com/ , is currently using CF, but I'd like

• Spam is Being Forwarded

  I am filtering a certain sender directly to the Trash folder. Those messages are still being forwarded. Is this supposed to happen?

• IMAP Block

  My two accounts have been blocked and I am not able to unblocked them myself. Please respond to email, I am traveling and this is urgent.

• "DKIM not configured"

  Hello. I have been attempting get the DKIM verified but Toolkit keeps sending the message that it is not configured, but both Namecheap and Zoho show it as configured properly. What am I missing?

• Zoho mail with custom domain not receiving email

  i registered zoho mail with my own domain. I can login and access the mail app. I tried to send email from an outlook email account and an icloud email account. Both emails were not received. My plan is free. I also tried to send email from this zoho

• Set connection link name from variable in invokeurl

  Hi, guys. How to set in parameter "connection" a variable, instead of a string. connectionLinkName = manager.get('connectionLinkName').toString(); response = invokeurl [ url :"https://www.googleapis.com/calendar/v3/freeBusy" type :POST parameters:requestParams.toString()

• Waterfall Chart

  Hello, I would like to create a waterfall chart on Zoho analytics which shows the movement in changes of budget throughout a few months, on a weekly basis. Should look something like the picture below. Does anyone know how to?

• Help Center and SEO: Any Benefit to My Domain-Mapped Website Ranking?

  First of, I love the Help Center which I've just decided to integrate into my website to replace its old-fashioned FAQs. So much more to achieve there now! Lots of new benefits to the site visitors and to me in terms of organizing and delivering all the

• Issue with Importing Notes against Leads

  Hi, I am attempting to import some Notes into Zoho CRM which need to be assigned to various Leads. I have created a csv file which I am testing that contains just one record. This csv file contains the following columns: Note Id Parent Id       (I have

• Next Page