Installment Configuration Examples
DE Ratenzahlung
FR versements échelonnés
This document provides detailed examples for installment configurations, illustrating different payment plan scenarios and their behavior.
Quick Navigation
Fixed Payment Plans: Equal amounts | Custom rates | Fixed first payment
Variable Dates: Irregular intervals | Custom date anchors
Service Periods: Monthly | Quarterly
Special Cases: Prepayments | Title overrides
Equal Monthly Payments
Four Equally Distributed Monthly Installments
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2017-12-05 |
| Installment Type | Four by Month |
Installment custom setting
| Field | Value |
|---|---|
| Name | Four by Month |
| Period | 1m(4) |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2017-12-05 |
25,00 |
|
Installment 2 |
2018-01-05 |
25,00 |
|
Installment 3 |
2018-02-05 |
25,00 |
|
Installment 4 |
2018-03-05 |
25,00 |
Custom Installment Titles
Five Monthly Installments with Custom Titles
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2017-12-31 |
| Installment Type | Five by Month |
Installment custom setting
| Field | Value |
|---|---|
| Name | Five by Month |
| Period | 1m(5) |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
| Title1__c | First Rate |
| TitleLast__c | Last Rate |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
First Rate |
2017-12-31 |
20,00 |
|
Installment 1 |
2018-01-31 |
20,00 |
|
Installment 2 |
2018-02-28 |
20,00 |
|
Installment 3 |
2018-03-31 |
20,00 |
|
Last Rate |
2018-04-30 |
20,00 |
Rate-Based Payments
Three Installments with Custom Rates
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2017-12-05 |
| Installment Type | Three by Two Months |
Installment custom setting
| Field | Value |
|---|---|
| Name | Three by Two Months |
| Period | 2m(3) |
| Rate | 20,30,50 |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2017-12-05 |
20,00 |
20 |
Installment 2 |
2018-02-05 |
30,00 |
30 |
Installment 3 |
2018-04-05 |
50,00 |
50 |
Irregular Payment Dates
Irregular Date Logic
Since the first installment is bound to the payment due date, the first date definition in Period determines the date of the second installment, the second definition determines the third installment date, etc. Use 0d as the final definition to complete the number of installments.
Three Installments with Irregular Intervals
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2018-03-15 |
| Invoice Date | 2018-03-01 |
| Payment Due | 14 (days) |
| Installment Type | Three Irregular |
Installment custom setting
| Field | Value |
|---|---|
| Name | Three Irregular |
| Period | 17d,103d,0d |
| Rate | 20,30,50 |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2018-03-15 |
20,00 |
20 |
Installment 2 |
2018-04-01 |
30,00 |
30 |
Installment 3 |
2018-07-13 |
50,00 |
50 |
Custom Date Anchors
Four Installments with Custom Date Anchor
Invoice
| Field | Value |
|---|---|
| Grand Total | 1000,00 |
| Payment Due Date | 2021-07-15 |
| Invoice Date | 2021-07-01 |
| Date1__c | 2021-07-30 |
| Installment Type | Four Irregular |
Installment custom setting
| Field | Value |
|---|---|
| Name | Four Irregular |
| Period | 30d,90d,180d,0d |
| Date Reference | Date1__c(4) |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2021-07-30 |
250,00 |
|
Installment 2 |
2021-08-29 |
250,00 |
|
Installment 3 |
2021-11-27 |
250,00 |
|
Installment 4 |
2022-05-26 |
250,00 |
Four Installments with Multiple Custom Dates
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2017-12-05 |
| Date1__c | 2018-02-03 |
| Date2__c | 2018-05-07 |
| Date3__c | 2018-11-13 |
| Date4__c | 2019-05-19 |
| Installment Type | Four custom dates |
Installment custom setting
| Field | Value |
|---|---|
| Name | Four custom dates |
| Period | 0m(4) orfix,fix,fix,fix |
| Date Reference | Date1__c,Date2__c,Date3__c,Date4__c |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2018-02-03 |
25,00 |
|
Installment 2 |
2018-05-07 |
25,00 |
|
Installment 3 |
2018-11-13 |
25,00 |
|
Installment 4 |
2019-05-19 |
25,00 |
Mixed Date References
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2018-03-01 |
| Date1__c | 2018-02-03 |
| Installment Type | One custom date |
Installment custom setting
| Field | Value |
|---|---|
| Name | One custom date |
| Period | fix,15d(3) |
| Date Reference | Date1__c |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2018-02-03 |
25,00 |
|
Installment 2 |
2018-03-01 |
25,00 |
|
Installment 3 |
2018-03-16 |
25,00 |
|
Installment 4 |
2018-03-31 |
25,00 |
Fixed Deposit Payments
Three Installments with Fixed First Amount
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2017-12-05 |
| Installment Type | 30 Deposit |
Installment custom setting
| Field | Value |
|---|---|
| Name | 30 Deposit |
| Period | 20d(3) |
| Rate | |
| Amount | 30 |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2017-12-05 |
30,00 |
|
Installment 2 |
2017-12-25 |
35,00 |
|
Installment 3 |
2018-01-14 |
35,00 |
Existing Prepayments
Installments with Existing Prepayment Balance
Invoice with prepaid balance
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Date | 2018-06-01 |
| Payment Due Date | 2018-07-31 |
| Prepayment | -40,00 |
| Installment Type | Four by Month |
Installment custom setting
| Field | Value |
|---|---|
| Name | Four by Month |
| Period | 1m(4) |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Open Payment Amount | Rate |
|---|---|---|---|---|
Installment 1 |
2018-07-31 |
25,00 |
0,00 |
|
Installment 2 |
2018-08-31 |
25,00 |
10,00 |
|
Installment 3 |
2018-09-30 |
25,00 |
25,00 |
|
Installment 4 |
2018-10-31 |
25,00 |
25,00 |
Advanced Date Configurations
Four Installments with Different Anchor
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2017-12-05 |
| Date1__c | 2018-02-01 |
| Installment Type | Different Anchor |
Installment custom setting
| Field | Value |
|---|---|
| Name | Different Anchor |
| Period | 1m(4) |
| Date Reference | Date1__c(4) |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2018-02-01 |
25,00 |
|
Installment 2 |
2018-03-01 |
25,00 |
|
Installment 3 |
2018-04-01 |
25,00 |
|
Installment 4 |
2018-05-01 |
25,00 |
Mixed Date References with Rates
Invoice
| Field | Value |
|---|---|
| Grand Total | 100,00 |
| Payment Due Date | 2018-03-01 |
| Date1__c | 2019-12-31 |
| Installment Type | Last custom date |
Installment custom setting
| Field | Value |
|---|---|
| Name | Last custom date |
| Period | 1m(3),fix |
| Date Reference | PaymentDueDate__c(3),Date1__c |
| Rate | 20(3) |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan
| Title | Date | Amount | Rate |
|---|---|---|---|
Installment 1 |
2018-03-01 |
20,00 |
|
Installment 2 |
2018-04-01 |
20,00 |
|
Installment 3 |
2018-05-01 |
20,00 |
|
Installment 4 |
2019-12-31 |
40,00 |
Service Period
Service Period Display
To display the service period in the installment table on the invoice PDF, specify the following configuration in the Installment Columns Template field: Title__c;ServicePeriodStart__c;ServicePeriodEnd__c;Date__c;Amount__c.
Installments per Service Month
Assume an invoice (with a payment due of 10) created for a recurring item with a billing factor of 12.
| # | Quantity | Unit Price | Billing Factor | Service Period Start | Service Period End | Tax Rate | Pos Total (net) | |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 100,00 | 12 | 2019-04-15 | 2020-04-14 | 19% | 1200,00 | |
| Subtotal Net | 1200,00 | |||||||
| Tax | 228,00 | |||||||
| Grand Total | 1428,00 |
Service Period Requirements
For service month-based installments to work with one-time items, the billing factor and the billing unit must be empty.
Installment custom setting
| Field | Value |
|---|---|
| Period | Service Month |
| Rate | |
| Amount | |
| Title | Installment [PosNo] |
Resulting payment plan (installment date = ServicePeriodStart + PaymentDue)
| Title | Service Period Start | Service Period End | Date | Amount |
|---|---|---|---|---|
| Installment 1 | 2019-04-15 | 2019-05-14 | 2019-04-25 | 119,00 |
| Installment 2 | 2019-05-15 | 2019-06-14 | 2019-05-25 | 119,00 |
| Installment 3 | 2019-06-15 | 2019-07-14 | 2019-06-25 | 119,00 |
| ... | ||||
| Installment 12 | 2020-03-15 | 2020-04-14 | 2020-03-25 | 119,00 |
Installments per Service Quarter (JSON Configuration)
Invoice
| Field | Value |
|---|---|
| Grand Total | 166,00 |
| Installment Type | Custom |
| CustomInstallment__c | {"period":"Service Quarter","titles":{"default":{"default":"Installment [PosNo]"}}} |
Invoice line items
| # | Quantity | Price | Service Period Start | Service Period End |
|---|---|---|---|---|
| 1 | 1 | 120,00 | 2019-04-01 | 2019-09-31 |
| 2 | 1 | 46,00 | 2019-04-01 | 2019-05-31 |
The service period of the first invoice line item spans two quarters, so the price of 120,00 will be distributed over two installments of 60,00 each. The service period of the second invoice line item is within the first quarter, so the complete price of 46,00 is added to the first installment, which results in 106,00:
| Title | Service Period Start | Service Period End | Amount |
|---|---|---|---|
| Installment 1 | 2019-04-01 | 2019-06-30 | 106,00 |
| Installment 2 | 2019-07-01 | 2019-09-31 | 60,00 |