Create single-year invoice schedules on new subscriptions with the same odd term

Create single-year invoice schedules for new subscriptions with odd terms, such as 10 months, and generate invoices on self-defined dates.

With the Billing Schedule feature, you can create invoice schedules on new subscriptions with an odd term like 11 months or 13 months, and how invoices are generated for the subscriptions.

In this use case, four subscriptions are created with the same term of 10 months, and a single-year invoice schedule is created on this subscription. Invoices are generated on self-defined dates through the processing of three invoice schedule items contained in the invoice schedule.

As shown in the following table, four subscriptions are created by creating an order , with a total amount of $58,500.00 and the same term of 10 months.


Subscription number	Charge start date	Term (Month)	Charge number	Charge end date	Selling price	List price base	Billing period
S1	01/01/2022	10	C1	10/31/2022	$30,750.00	Per Year	Annual
S2	01/01/2022	10	C2	10/31/2022	$17,916.6666	Per Year	Annual
S3	01/01/2022	10	C3	10/31/2022	$9,166.6666	Per Year	Annual
S4	01/01/2022	10	C4	10/31/2022	$666.6666	Per Year	Annual

You expect to create a custom invoice schedule to generate three invoices on different dates for the four subscriptions.

The first invoice is expected to be generated on 5 February 2022 with the amount of $40,000.00, the second invoice on 30 August 2022 with the amount of $10,000.00, and the third invoice on 14 September 2022 with the amount of $8,500.00.

To create such a custom invoice schedule and generate invoices as expected, perform the following steps:

Activate the Annual List Price settings .
Create four recurring product rate plan charges with the Flat Fee Pricing charge model.

Create and activate an order with four subscriptions to the four charges, with the total amount of $58,500.00 and the same term of 10 months.


Subscription number	Charge number	Amount	List price base	Billing period
S1	C1	$30,750.00	Per Year	Annual
S2	C2	$17,916.6666	Per Year	Annual
S3	C3	$9,166.6666	Per Year	Annual
S4	C4	$666.6666	Per Year	Annual

On the order details page, create an invoice schedule with three invoice schedule items,
1. Invoice schedule item 1: Set the invoice date to 02/05/2022 in the On field and billing amount to 40000 in the Bill field.
2. Invoice schedule item 2: Set the invoice date to 08/30/2022 in the On field and billing amount to 10000 in the Bill field.
3. Invoice schedule item 3: Set the invoice date to 09/14/2022 in the On field and billing amount to 8500 in the Bill field.

After the invoice schedule is created, the first invoice with invoice number INV001 is automatically generated on 5 February 2022 with a total amount of $40,000.00. The following table lists the amount that is proportionally distributed to each subscription, and the service period of each invoice item.


Invoice item	Subscription number	Charge number	Service start date	Service end date	Amount	Total Amount
Invoice item 1	S1	C1	01/01/2022	07/26/2022	$21,025.64	$40,000.00
Invoice item 2	S2	C2	01/01/2022	07/26/2022	$12,250.71
Invoice item 3	S3	C3	01/01/2022	07/26/2022	$6,267.81
Invoice item 4	S4	C4	01/01/2022	07/26/2022	$455.84

The amount displayed in the Amount column for each invoice item is calculated based on the following formula:

(Billed invoice amount ÷ Total invoice amount) × Selling price

For example, the amount for the first charge line item in the first generated invoice is $21,025.64, which is calculated based on the formula of (40000÷58500)×30750 and rounded based on the default rounding rule specified for the corresponding account.

The service period of each invoice item is determined by the charge amount that is billed in the invoice, calculated based on the following formula:

(Invoice item amount ÷ Selling price) × Billing period

For example, the proportion of months for the first charge line item in the first generated invoice is calculated based on the formula of (21025.64÷30750)×10 months. The calculation result is 6.838 months, indicating 6 months plus 25.98 days. A portion of the day 26 July 2022 is consumed by the first invoice. Therefore, the service end date is 26 July 2022 for the first charge line item and other items in the same invoice.

On 30 August 2022, the second invoice with invoice number INV002 is generated with the total amount of $10,000.00. The following table lists the amount that is proportionally distributed to each subscription, and the service period of each invoice item.


Invoice item	Subscription number	Charge number	Service start date	Service end date	Amount	Total Amount
Invoice item 1	S1	C1	07/27/2022	09/17/2022	$5,256.41	$10,000.00
Invoice item 2	S2	C2	07/27/2022	09/17/2022	$3,062.68
Invoice item 3	S3	C3	07/27/2022	09/17/2022	$1,566.95
Invoice item 4	S4	C4	07/27/2022	09/17/2022	$113.96

On 14 September 2022, the third invoice with invoice number INV003 is generated with the total amount of $8,500.00. The following table lists the amount that is proportionally distributed to each subscription, and the service period of each invoice item.


Invoice item	Subscription number	Charge number	Service start date	Service end date	Amount	Total Amount
Invoice item 1	S1	C1	09/18/2022	10/31/2022	$4,467.95	$8,500.00
Invoice item 2	S2	C2	09/18/2022	10/31/2022	$2,603.28
Invoice item 3	S3	C3	09/18/2022	10/31/2022	$1,331.91
Invoice item 4	S4	C4	09/18/2022	10/31/2022	$96.86

Welcome to Zuora Product Documentation

Explore our rich library of product information

Create single-year invoice schedules on new subscriptions with the same odd term

zuora-footer