In this article

Credit Note for Deferrals: Examples

Review the following credit note examples to better understand how a deferral schedule changes when credit notes are applied.

Note icon. Note: These examples demonstrate the functionality of the credit note functionality. The values might not be exact due to rounding.

Basic - No Discount

A sales invoice for 1,200.00 is posted on January 1, 2017. This amount is deferred over 12 months with Equal per Period option selected on the deferral schedule. The following deferral schedule is created.  The first five months (January - May) of the deferral schedule are recognized or stubbed.

Sequence Deferral Start Date Deferral End Date Amount Recognized General Journal Ref.
1 January 01, 2017 January 31, 2017 100.00 X Stubbed
2 February 01, 2017 February 28, 2017 100.00 X Stubbed
3 March 01, 2017 March 31, 2017 100.00 X GL01
4 April 01, 2017 April 30, 2017 100.00 X GL02
5 May 01, 2017 May 31, 2017 100.00 X GL03
6 June 01, 2017 June 30, 2017 100.00    
... ... ... ... ... ...
12 December 01, 2017 December 31, 2017 100.00    

The following examples demonstrate what happens when credit notes are applied.

Example 1: Credit note applied for 250.00, recalculation date is June 1 and end date is October 31.

  • Amount per period = (1,200.00 – 250.00 – 500.00) / 5 = 90.00

    • *note that only 5 months are left June – October

  January February March April May June July August September October November December
Amount 100.00 100.00 100.00 100.00 100.00 90.00 90.00 90.00 90.00 90.00    
Recognized X X X X X              

Example 2: Credit note applied for 250.00, recalculation date is January 1 and end date is October 31.

  • Amount per period = (1,200.00 – 250.00) / 10 = 95.00
  • True-up amount = (95.00 – 100.00) * 5 = -25.00
  • True-up line = 95.00 – 25.00 = 70.00

    • *note that only 10 months are left January – October

  January February March April May June July August September October November December
Amount 100.00 100.00 100.00 100.00 100.00 70.00 95.00 95.00 95.00 95.00    
Recognized X X X X X              

Example 3: Credit note applied for 600.00, recalculation date is June 1 and end date is October 31.

  • Amount per period = (1,200.00 – 600.00 – 500.00) / 5 = 20.00
  January February March April May June July August September October November December
Amount 100.00 100.00 100.00 100.00 100.00 20.00 20.00 20.00 20.00 20.00    
Recognized X X X X X              

Example 4: Credit note applied for 600.00, recalculation date is January 1 and end date is October 31.

  • Amount per period = (1,200.00 – 600.00) / 10 = 60.00
  • True-up amount = (60.00 – 100.00) * 5 = , 200.00
  • True-up line = 60.00 – 200.00 = -140.00
  January February March April May June July August September October November December
Amount 100.00 100.00 100.00 100.00 100.00 -140.00 60.00 60.00 60.00 60.00    
Recognized X X X X X              

Example 5: Credit note applied for 600.00, recalculation date is March 1 and end date is October 31.

  • Amount per period = (1,200.00 – 600.00 – 200.00) / 8 = 50.00

    • *note that the 8 is because the first two lines are not affected by the adjustment

  • True-up amount = (50.00 – 100.00) * 3 = -150.0
  • True-up line = 50.00 – 150.00 = -100.00
  January February March April May June July August September October November December
Amount 100.00 100.00 100.00 100.00 100.00 -100.00 50.00 50.00 50.00 50.00    
Recognized X X X X X              

Back to top ▲

Event Based

A sales invoice of 9,500.00 for an event-based item has the following deferral schedule: 

Event Description Expiry Date Event Amount
Training March 30, 2018 2,500.00
Implementation   5,000.00
Maintenance   2,000.00

A credit note for 950.00 is created on June 15. The deferral schedule is updated as follows: 

Event Description Expiry Date Event Amount
Training March 30, 2018 2,500.00
Implementation   5,000.00
Maintenance   2,000.00
Credit   -950.00

When credit notes are applied, a line with a negative amount for the credit note is added to the deferral schedule.

Back to top ▲

Integration with ARCB

A sales invoice is created in ARCB with the following billing schedule: 

  • Billing schedule amount: 3,600.00
  • Dates: 2017-January 01 to 2019-December 31
  • Frequency: Annually
  • Fiscal periods (deferral frequency): Monthly
Billing Start Date Billing End date Deferral Start Date Deferral End Date Qty Unit Price Net Amount Billed Deferral Schedule
January 01, 2017 December 31, 2017 January 01, 2017 December 31, 2017 1 1,200.00 1,200.00 X ARED-1
January 01, 2018 December 31, 2018 January 01, 2018 December 31, 2018 1 1,200.00 1,200.00 X ARED-2
January 01, 2019 December 31, 2019 January 01, 2019 December 31, 2019 1 1,200.00 1,200.00 X ARED-3
  • Example A: The billing schedule is terminated on March 15, 2018 with the following settings: 
    • Deferral adjustment method: Unrecognized periods OR Entire schedule
    • Prorate daily: No
    • New schedule amount: 1200.00 - 900.00 = 300.00.
  • Deferral Schedule ARED-1: The schedule ends before the termination date. The deferral schedule is not changed.
  • Deferral Schedule ARED-2: The deferral schedule is changed based on the credit note that is applied. Review updated deferral schedule.
  • Deferral Schedule ARED-3: The schedule starts after the termination date. The credit note is applied to the full amount (1,200.00) of the deferral schedule. All lines are removed, and the status of the deferral schedule is changed to completed.
  January February March April May June July August September October November December
ARED-1 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
ARED-2 100.00 100.00 100.00 100.00 100.00 100.00 100.00 -400 Deleted Deleted Deleted Deleted
Recognized X X X X X X X          
ARED-3 Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted
  • Example B: The billing schedule is terminated on March 15, 2018 with the following settings: 
    • Deferral adjustment method: Unrecognized periods OR Entire schedule
    • Prorate daily: Yes
    New schedule amount: 1200.00 - 956.71 = 243.29
  • Deferral Schedule ARED-1: The schedule ends before the termination date. The deferral schedule is not changed.
  • Deferral Schedule ARED-2: The deferral schedule is changed based on the credit note that is applied. Review updated deferral schedule.
  • Deferral Schedule ARED-3: The schedule starts after the termination date. The credit note is applied to the full amount (1,200.00) of the deferral schedule. All lines are removed, and the status of the deferral schedule is changed to completed.
  January February March April May June July August September October November December
ARED-1 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
ARED-2 100.00 100.00 100.00 100.00 100.00 100.00 100.00 -456.71 Deleted Deleted Deleted Deleted
Recognized X X X X X X X          
ARED-3 Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted
  • Example C: The billing schedule is terminated on October 22, 2018, with the following settings: 
    • Deferral adjustment method: Unrecognized periods
    • Prorate daily: No
    New schedule amount: 1200.00 - 200.00 = 1000.00
  • Deferral Schedule ARED-1: The schedule ends before the termination date. The deferral schedule is not changed.
  • Deferral Schedule ARED-2: The deferral schedule is changed based on the credit note that is applied. Review updated deferral schedule.
  • Deferral Schedule ARED-3: The schedule starts after the termination date. The credit note is applied to the full amount (1,200.00) of the deferral schedule. All lines are removed, and the status of the deferral schedule is changed to completed.
  January February March April May June July August September October November December
ARED-1 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
ARED-2 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 Deleted Deleted
Recognized X X X X X X X          
ARED-3 Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted
  • Example D: The billing schedule is terminated on October 22, 2018, with the following settings: 
    • Deferral adjustment method: Unrecognized periods
    • Prorate daily: Yes
    New schedule amount: 1200 - 230.14 = 969.86
    Number periods (for EPP calculation) = 2 + (22/31) = 2.7097
    Amount per period = (969.86 - 700) / 2.7097 = 99.59
    Last line = 99.59 * 0.7097 = 70.68
  • Deferral Schedule ARED-1: The schedule ends before the termination date. The deferral schedule is not changed.
  • Deferral Schedule ARED-2: The deferral schedule is changed based on the credit note that is applied. Review updated deferral schedule.
  • Deferral Schedule ARED-3: The schedule starts after the termination date. The credit note is applied to the full amount (1,200.00) of the deferral schedule. All lines are removed, and the status of the deferral schedule is changed to completed.
  January February March April May June July August September October November December
ARED-1 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
ARED-2 100.00 100.00 100.00 100.00 100.00 100.00 100.00 99.59 99.59

70.68

End = 10/22

 Deleted Deleted
Recognized X X X X X X X          
ARED-3 Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted
  • Example E: The billing schedule is terminated on October 22, 2018, with the following settings: 
    • Deferral adjustment method: Entire schedule
    • Prorate daily: Yes

    New schedule amount: 1200 - 230.14 = 969.86
    Number periods (for EPP calculation) = 9 + (22/31) = 9.7097 ; Note icon. Note: If not using EPP, the calculation is based on days.
    Amount per period = 969.86 / 9.7097 = 99.89
    True up line = 99.89 - (100 - 99.89)*7 = 99.12

  • Deferral Schedule ARED-1: The schedule ends before the termination date. The deferral schedule is not changed.
  • Deferral Schedule ARED-2: The deferral schedule is changed based on the credit note that is applied. Review updated deferral schedule.
  • Deferral Schedule ARED-3: The schedule starts after the termination date. The credit note is applied to the full amount (1,200.00) of the deferral schedule. All lines are removed, and the status of the deferral schedule is changed to completed.
  January February March April May June July August September October November December
ARED-1 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
ARED-2 100.00 100.00 100.00 100.00 100.00 100.00 100.00 99.12 99.89

70.85

End = 10/22

 Deleted Deleted
Recognized X X X X X X X          
ARED-3 Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted Deleted

Back to top ▲