# Automatic Billing Cycle

**URL:** https://community.glideapps.com/t/automatic-billing-cycle/59511
**Category:** Ask for Help
**Created:** [March 22, 2023, 7:05am UTC](https://community.glideapps.com/t/automatic-billing-cycle/59511 "2023-03-22T07:05:52Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)
#### Post date: [March 22, 2023, 7:05am UTC](https://community.glideapps.com/t/automatic-billing-cycle/59511/1 "2023-03-22T07:05:52Z")

</div>

Hello,I have one sheet which i have Rental Details of the Machine.  
Start Date | End Date | Client | Machine ID | Rental Type | Rental Rate etc.

And also, I have another one sheet for Account.

Inv Date | Client | Machine ID | Amount to be Inv

Let say,

Example 1:  
In Machine Sheet  
Start Date | End Date | Client | Machine ID | Rental Type | Rental Rate etc.  
1/1/2023 | 31/3/2023 | ABC SDN BHD | Machine 1 | Monthly | 5000

Example 2:  
Start Date | End Date | Client | Machine ID | Rental Type | Rental Rate etc.  
3/1/2023 | 20/4/2023 | DEF SDN BHD | Machine 2 | Monthly | 4000

and i am using Apps Script that run every day which will come out for each 1st date of each month (in this case) in the Account sheet.

Example 1:  
Inv Date | Client | Machine ID | Amount to be Inv | Invoiced ?

1. 1/1/2023 | ABC SDN BHD | Machine 1 | 5000 | TRUE
2. 1/2/2023 | ABC SDN BHD | Machine 1 | 5000 | FALSE
3. 1/3/2023 | ABC SDN BHD | Machine 1 | 5000 | FALSE

Example 2:  
Inv Date | Client | Machine ID | Amount to be Inv

1. 3/1/2023 | DEF SDN BHD | Machine 2 | 4000 | TRUE
2. 3/2/2023 | DEF SDN BHD | Machine 2 | 4000 | TRUE
3. 3/3/2023 | DEF SDN BHD | Machine 2 | 4000 | FALSE
4. 3/4/2023 | DEF SDN BHD | Machine 2 | 2266 (will calculate prorated) | FALSE

because we need to notify the accountant the invoice.

Is there any ways to do in Glide ?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 23, 2023, 12:31am UTC](https://community.glideapps.com/t/automatic-billing-cycle/59511/2 "2023-03-23T00:31:45Z")

</div>

Not for now, because you can’t have time-based triggers to add rows every day, but it might become available later this year.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [April 14, 2023, 7:06am UTC](https://community.glideapps.com/t/automatic-billing-cycle/59511/3 "2023-04-14T07:06:23Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.