Calculating Actual Day Proration

When using the Use Actual Days in Billing Period proration calculation, the proportion invoiced for the partial period is based on the exact number of days used out of the full charge period.

The formula used to calculate the prorated value for the partial period is:

Sales Price * (x/y)

where:

  • x is the number of days that the contract has been in use, including start and end days, during the partial period
  • y is the number of days in the full period

The following examples show how prorated values are calculated when using the Actual Days calculation method.

Example 1

In this example, the charge term WB starts on Monday.

Line Start Date

Line End Date

Charge Term

Line Sales Price

First Charge Period

Final Charge Period

Sat, Aug 12, 2017 Tue, Aug 22, 2017 WB + 3d $70

Aug 12 to Aug 16 = 5 days

Aug 16 - charge term (WB+3d) = Aug 10

Aug 10 to Aug 16 = 7 days

$70 * (5/7) = $50

Aug 17 to Aug 22 = 6 days

Aug 17 + charge term (WB+3d) = Aug 23

Aug 17 to Aug 23 = 7 days

$70 * (6/7) = $60

Illustration

Example 2

Line Start Date

Line End Date

Charge Term

Line Sales Price

First Charge Period

Final Charge Period

Wed, Aug 2, 2017 Sat, Sept 9, 2017 ME - 6d $930

Aug 2 to Aug 24 = 23 days

Aug 24 - charge term (ME-6d) = July 25

July 25 to Aug 24 = 31 days

$930 * (23/31) = $690

Aug 25 to Sept 9 = 16 days

Aug 25 + charge term (ME-6d) = Sept 24

Aug 25 to Sept 24 = 31 days

$930 * (16/31) = $480

Illustration

Example 3

Line Start Date

Line End Date

Charge Term

Line Sales Price

First Charge Period

Final Charge Period

Tues, Aug 8, 2017 Tues, Oct 31, 2017 MB + 4d $930

Aug 8 to Sept 4 = 28 days

Sept 4 - charge term (MB + 4d) = Aug 5

Aug 5 to Sept 4 = 31 days

$930 * (28/31) = $840

Oct 5 to Oct 31 = 27 days

Oct 5 + charge term (MB + 4d) = 4 Nov

Oct 5 to Nov 4 = 31 days

$930 * (27/31) = $810

Illustration