Function #60: Automatically generate invoices for unbilled timesheets at regular intervals

Hello everyone, and welcome back to our series!

In the Time Tracking section of Zoho Books, you can set up projects to track services provided to your clients and log timesheets to record the time spent completing them. These timesheets can be billed to your clients, helping you recognize revenue from the services. Today’s function aims to automate the billing process using a daily Scheduler that checks for any unbilled timesheets and generates invoices automatically. 

There's an option called "Associate Projects Hours" for Recurring Invoices. If you select this option, any unbilled timesheets up to the date of the child invoice will be included in that invoice. This is a way to automate the billing of timesheets at specific intervals. However, when creating Recurring Invoices, it's mandatory to select an item. If you prefer to skip this and only want to include timesheets in the invoices, then today's function is ideal for you.

Here's how it works:

Let’s take the example of Mr. John Hector, who provides corporate training services through both short workshops and long-term programs. He charges his clients based on the type of program, with billing done on a daily, weekly, or monthly basis. For instance, one of his clients is participating in his "Corporate Communication Skills" program, and John has arranged to bill them at the end of each month for the total hours of training provided.

To handle this in Zoho Books, John would normally create a time-based project, log the training hours using timesheets, and at the end of the month, manually review the unbilled hours to generate an invoice.

However, with today's scheduler, the billing process can be automated. By specifying key billing details—such as the Billing Date, Cycle, and Frequency—in the project’s custom fields, the scheduler will automatically generate invoices for any unbilled timesheets on the specified billing date. It will continue to raise invoices for each billing cycle, eliminating the need for John to manually consolidate timesheets and raise invoices. 

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 Dropdown-type custom field called "Billing Cycle" for projects. This field should include the options: Daily, Weekly, and Monthly. The selected option will determine how often invoices are generated.



3. Create a Number-type custom field called "Billing Frequency" for projects. If you want to bill timesheets every 2 weeks, select "Weekly" in the "Billing Cycle" field and enter 2 here. If the "Billing Cycle" is set to "Daily," enter 1 in this field.



4. Create a Date-type custom field called "Billing Date" for projects. This field allows you to select the date on which invoices should be generated for each billing frequency. 

5. Create a Checkbox-type custom field called "Automate Billing?" for projects. The scheduler will run only for those projects where the field is ticked. If a project has ended and you no longer want to generate invoices, simply edit the project and uncheck the box.

Note: If "Automate Billing?" is ticked without specifying the billing cycle, frequency, or date, the system will automatically generate invoices daily for the projects.

Setting up the Scheduler:

Navigate to Settings -> Automation -> Schedules -> +New Schedule -> Set up the schedule as shown in the screenshot -> Add the code from this GitHub link -> Save. 

Give this scheduler a try and let us know what you think! If you need assistance with implementation, feel free to contact our Support team at support[at]zohobooks[dot]com. We are happy to help.

Regards,

Shireen Farhana

Zoho Books

• Topic Participants

• Shireen Farhana

  

• Sellers

• Recent Topics

• Add Lookup Field in Tasks Module

  Hello, I have a need to add a Lookup field in addition to the ones that are already there in the Tasks module. I've seen this thread and so understand that the reason lookup fields may not be part of it is that there are already links to the tables (

• Create New Tasks Layout in CRM

  I am able to do this in Leads, Contacts, Meetings, Calls - every other module, but cannot create a new layout in tasks. I have the appropriate access but it's simply not appearing as an option. Only "Standard" option shows. Please help!

• Whatsapp Connection Status still "Pending" after migration

  Hello, I migrated my WhatsApp API to Zoho from another provider a day ago. So far the connection status is still “Pending”. There is a problem? How long does it usually take?

• Using IMAP configuration for shared email inboxes

  Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configure

• Auto-sync field of lookup value

  This feature has been requested many times in the discussion Field of Lookup Announcement and this post aims to track it separately. At the moment the value of a 'field of lookup' is a snapshot but once the parent lookup field is updated the values diverge.

• Zoho Recruit Subscription

  Hello Zoho Recruit Team, Good day! I would like to inquire about your recruitment subscription plans and would also like to verify the current subscription our company is enrolled in under Zoho Recruit. Thank you, and I look forward to your response.

• Keyboard shortcut M key

  I'm trying to customize my keyboard shortcuts and assign the "m" key. But it says the key is already assigned. I've looked through all my shortcuts and can't see any assigned "m". When I select an email and press the M key, nothing happens. What is the

• Is it possible to create a meeting in Zoho Crm which automatically creates a Google Meet link?

  We are using Google's own "Zoho CRM for Google" integration and also Zoho's "Google Apps Sync" tools, but none of them provide us with the ability to create a meeting in Zoho CRM that then adds a Google Meet link into the meeting. Is this something that

• Ensure Consistent Service Delivery with Comprehensive Job Sheets

  We are elated to announce that one of the most requested features is now live: Job Sheets. They are customizable, reusable forms that serve as a checklist for the services that technicians need to carry out and as a tool for data collection. While on

• Automatic Portal invite

  We have numerous customers we move through a blueprint in deals, when they get to a certain point we need to give them portal access, how can this be done through deluge or a workflow? Latest Update (December 2025): The option to automate portal invitations

• Marketer's Space: Why mobile optimization deserves a place in your email strategy

  Hello Marketers, Welcome back to Marketer's Space! Today, we'll talk about the importance of creating mobile-friendly email designs. While mobile phones were once used only to make phone calls, today they're used for almost everything, including texting,

• Enhancements in Canvas

  Dear All, Greetings! Canvas lets you design the record details page to suit your brand or business preferences. We are glad to introduce the following enhancements to uplift your design experience. Reusable Components Style Presets Let's go! Reusable

• Introducing Dark Mode / Light Mode : A New Look For Your CRM

  Hello Users, We are excited to announce a highly anticipated feature - the launch of Day, Night and Auto Mode implementation in Zoho CRM's NextGen user interface! This feature is designed to provide a visually appealing and comfortable experience for

• ABN with Legal Entity Name

  Hi, How can I execute this? The ABN number is entered in Accounts Module and ideally, it should display or suggest the correct Legal Entity Name based on the ABN lookup. ex. Account Name: JPG Resources ABN Number: 65 067 761 871 Legal Entity Name: (auto

• Zoho Cliq not working on airplanes

  Hi, My team and I have been having this constant issue of cliq not working when connected to an airplane's wifi. Is there a reason for this? We have tried on different Airlines and it doesn't work on any of them. We need assistance here since we are constantly

• 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,

• Detailed Account Reports - Add Running Balance

  When one clicks into an account from a report (say P/L or Balance Sheet), the default reports have the Debit, Credit, and then the Amount. The Amount column (last one) is duplicate information. It would be far better and fit more peoples' use cases if

• Issue: Ticket Export Does Not Include Ticket Threads

  Dear Zoho Desk Support Team, I hope you’re doing well. I wanted to bring to your attention that the current ticket export feature in Zoho Desk does not seem to include the ticket threads or conversation history. When exporting tickets, only the summary

• Pushover Notification Module

  Hello, it would be good if there would be a "Pushover" (https://pushover.net/) module besides the standard SMS module. Pushover is now very well known, especially in IT, and is becoming more and more popular. The biggest advantage are the customizable

• Forward - no Ticket Number

  Hello, when I send an email to Zoho Desk via Reply or Reply All, the ticket number is in the subject line. But if I use forward then not. Is there an option to change this? We often forward e-mails and a reply to this will of course create a new ticket

• Checkout: Adding Images

  Hello everyone, I’m trying to add a small GoGreen logo in the shipping section of the checkout to promote our sustainable shipping. While I can insert text without any issues, it seems that adding images is not supported in this area. Is there currently

• Sortie de Zoho TABLE ??

  Bonjour, Depuis bientôt 2 ans l'application zoho table est sortie en dehors de l'UE ? Depuis un an elle est annoncée en Europe Mais en vrai, c'est pour quand exactement ??

• [solved] #original_sender trick not working for us

  Hello community ! We really like DESK.. it's working like a charm for us but I have a request. Some users are sending emails personnaly to me (instead of using the support adress).. and I saw there was a possibilty to use : #original_sender {mail@mail.com}

• SalesIQ Chat Notifications

  I am the admin of our salesIQ implementation. About two weeks ago, I started hearing/seeing notification for ALL chats messages from monitored agents/chat participants. I don't need to see these, we have a manager who deals with this. I can't stop the

• Correlated subqueries not supported in Zoho Analytics. This creates huge limitations

  Running into a major limitation in Zoho Analytics: correlated subqueries simply don’t work, even in completely standard SQL patterns inside a JOIN. Example: LEFT JOIN "Bills" b ON d."Id" = b."Deal ID" AND EXISTS ( SELECT 1 FROM "Bill

• Unknown table or alias 'A1'

  I would like to create a subquery but i am getting the following error: Unknown table or alias 'A1' used in select query. This is the sql statement:  SELECT A1.active_paying_customers, A1.active_trial_customers, A1.new_paying_signup, date(A1.date_active_customers), 

• Batch Emails in CRM Plus without using a template?

  Hi guys. Is it possible to send the same email to multiple people at the same time within CRM Plus without using an email template? At the moment we create a custom view in Contacts to display the people that we need. We then click the boxes on the left, and click 'Send Mail', but always need to select a template. Sometimes its better to write a quick one off message, without needing to set up a template first. Thanks.

• bank charge

  a charge to my account was made that I did not authorize, of $16.46, for something that looks like "computer maintenance or something to that matter". please refund.

• [Free Webinar] Product Updates: Quick Catch-Up Session - Part II - Creator Tech Connect

  Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar featuring deep-dive technical sessions designed for developers, administrators, and app builders.

• Introducing Liquid Glass UI on the Zoho Mail iOS app

  Hello everyone! We're excited to announce that the Zoho Mail app is now fully optimised for iOS 26's Liquid Glass design on both iPhone and iPad! The updated interface features transparent layers, smooth animations, and refined visual elements that enhance

• Plan change from Zoho One to Zoho Workplace

  Hello Zoho, Following the recent pricing update for Zoho One, we are interested in transitioning to Zoho Workplace products. Please inform us about the necessary steps for this process so we can proceed promptly. Kind regards,

• Partner with HDFC And Sbi Bank.

  Hdfc and sbi both are very popular bank if zoho books become partner with this banks then many of the zoho books users will benefit premium features of partnered banks.

• Links in Instagram

  Hi there, I have been using Later for a while now but keen to come back to Zoho Social as Later doesn't offer tagging of pages on Facebook but they offer something Zoho doesn't. You can add a link to your bio which opens up your profile feed where images

• Spotlight #7 - Automatic Transitions in Blueprint

  Previously, records could not be moved from one state to another without user intervention. With automatic transitions, move records from one state to another automatically, when it elapses its pre-defined time. This Spotlight discusses how automatic

• Sub Folders

  It would be great if there could be sub-folders in reports. We have a ton of individual reports and folders that would be easier to navigate this way 

• Zoho CRM Community Digest - November 2025 | Part 2

  Hello Everyone! Second half of November brought several exciting updates, especially around Zia, making AI assistance smarter, faster, and more context-aware. We also feature engaging community snippets highlighting members who went the extra mile to

• Zoho CRM - Writing Assistant Tone

  Hi Zoho CRM Team, Text in my emails often gets underlined in yellow because I tend to use a more informal tone with my client's, like using "I'm" instead of "I am". Is there some way for me to tell the system that this is my preferred writing tone, so

• Hide Contact Number for Field Users & Agents

  Is it possible to hide the contact number in both the Service Appointment and Work Order modules for field users and agents? The agents are using the Zoho FSM mobile app, and we want to restrict them from viewing the contact number.

• Zoho Flow Credits

  Hi , I would like to ask the reason why every time I added plus credit but few days later I will return back to default? (as below I add credit to 3000 but today It change back to 1000) Most important is, when the credit fully used, not any reminder to

• Form Submission Emails

  Is there a current delay with submission emails being sent? We've had 10-20 forms completed today but only a handful of emails.

• Next Page