Function #4: Schedule Customer Statements

Function #4: Schedule Customer Statements

Regularly sending statements to customers is an imperative part of many business processes as it helps foster strong customer relationships and provides timely guidance on payments. While you can generate the statement of accounts and have it sent over whenever you want, Zoho Books also helps you automate this process through a custom function and workflow. 

We've written for you the function that automatically sends statements to your customers on a regular basis. 


To get this function running, you need to create a Date type custom field for the Customers module in the name "Statement Date". This is where you must input the date from which you want to start sending the statement to each customer. If you plan to select the same date for all customers, you can choose the appropriate custom date or relative date as the Default value when creating the custom field. For existing customers, you can utilize the Bulk Update option in the Customers module to update the field's value. 

Now it's time to set up the custom function and workflow. 

Custom Function:

To create the custom function, go to Settings -> Automation -> Custom Functions -> +New Custom Function, and set it up as shown below. 

The script for the function can be obtained from this GitHub link. Do ensure that you also configure the Connection by the name "zbooks". Refer to the following GIF for a visual guide on creating the connection. 

Workflow Rule: 

Next, a workflow rule needs to be set up to activate this function. Navigate to Settings -> Automation -> Workflow Rules -> +New Workflow Rule, and configure the workflow this way: 

For the workflow's Execution Time, you can enter a suitable time of your choice. Finally, select the custom function you created before saving the workflow. 

There you have it! Your customers will now receive their statement of accounts on time, eliminating the need for your manual involvement. If you think this workflow saved you some valuable time and helped prevent mishaps, do leave a comment to let us know your story. We'd love to hear it from you.  

In case you encounter any errors or need additional customization for the function, feel free to contact us at We'll be happy to provide assistance. 

Divya R
Zoho Books

                            Zoho Desk Resources

                            • Desk Community Learning Series

                            • Digest

                            • Functions

                            • Meetups

                            • Kbase

                            • Resources

                            • Glossary

                            • Desk Marketplace

                            • MVP Corner

                            • Word of the Day

                                Zoho Marketing Automation

                                        Manage your brands on social media

                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources

                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources

                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources

                                                            Zoho Sprints Resources

                                                              Qntrl Resources

                                                                Zoho Creator Resources

                                                                  Zoho WorkDrive Resources

                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series

                                                                      • Tips


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Digest


                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now