Appearance

Last day adjustment ​

For monthly recurring charges, Billingbooth utilises a methodology of billing from day X to day X-1 of the following month. If a monthly recurring charge starts on the 10th of a month, each billing period will include an invoice line item with a date range of 10th of the month to the 9th of the following month.

Where a charge starts on the 29th, 30th or 31st of a month, and due to the nature of different calendar months having different numbers of days, the last day of the billing period may not always align with the last day of the month. On an on-going charge, this may end up causing a distortion in the date ranges produced each month.

Billing PeriodStart DateEnd DateAmount
January 202531/01/202527/02/202524.99
February 202528/02/202527/03/202524.99
March 202528/03/202527/04/202524.99
April 202528/04/202527/05/202524.99
May 202528/05/202527/06/202524.99
June 202528/06/202527/07/202524.99
July 202528/07/202527/08/202524.99
August 202528/08/202527/09/202524.99
September 202528/09/202527/10/202524.99
October 202528/10/202527/11/202524.99
November 202528/11/202527/12/202524.99
December 202528/12/202527/01/202624.99

Modifying behaviour ​

To resolve this problem Billingbooth has a configuration option under Settings > General called Last Day Adjustment. Enabling this option will modify the behaviour of Billingbooth to adjust the last day of the end dates for any charges beginning with 29/30/31.

With Last Day Adjustment enabled, a similar charge to the first example table will end up looking like this:

Billing PeriodStart DateEnd DateAmount
January 202531/01/202527/02/202524.99
February 202528/02/202530/03/202524.99
March 202531/03/202529/04/202524.99
April 202530/04/202530/05/202524.99
May 202531/05/202529/06/202524.99
June 202530/06/202530/07/202524.99
July 202531/07/202530/08/202524.99
August 202531/08/202529/09/202524.99
September 202530/09/202530/10/202524.99
October 202531/10/202529/11/202524.99
November 202530/11/202530/12/202524.99
December 202531/12/202530/01/202624.99

Changing between methodologies ​

Accounts who have previously issued charges starting on the 29th, 30th or 31st of a month who wish to swap methodologies can do so simply by ticking the Last Day Adjustment option in the Settings > General menu. It should be noted that whilst the charge will seamlessly switch with no monetary changes, there will be a small gap where it will appear as though a few days are missing - this is simply the result of changing methodology.

Below is an example of what would happen to a charge that started in January without using Last Day Adjustment, but switched Last Day Adjustment on in May.

Billing PeriodStart DateEnd DateAmount
January 202531/01/202527/02/202524.99
February 202528/02/202527/03/202524.99
March 202528/03/202527/04/202524.99
April 202528/04/202527/05/202524.99
May 202531/05/202529/06/202524.99
June 202530/06/202530/07/202524.99
July 202531/07/202530/08/202524.99
August 202531/08/202529/09/202524.99
September 202530/09/202530/10/202524.99
October 202531/10/202529/11/202524.99
November 202530/11/202530/12/202524.99
December 202531/12/202530/01/202624.99

Service files ​

Enabling Last Day Adjustment will also modify the handling of dates from charges that come from service files. This may have an effect on whether charges on service files which have a 29th, 30th or 31st start date will align correctly once billed in Billingbooth.

WARNING

We have made the decision to roll this functionality out but leaving it turned off by default on all existing accounts to ensure customers who use service files are not adversely affected by the change.

If you bill service charges mainly via service files, it's unlikely you will want to turn this option on since it may not align with your upstream carrier's own date range mechanisms.