Accrued Rent

Spot Reports

Accrued Rent (in advance)

Aggregated amount of rents to pay on the report date, based on the actual payment date, in the currency applied to the report:

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

Note: The Accrued Rent (in advance) indicator only applies to leases in advance.

 

Example 1 - Unadjusted Payment Date - Different Report Date

On 10 May 2021, the accrued rent of 0041 is EUR 83 972,07.

Rent_Accrued_Advance_EN.png

  • The report date is 10 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 120,54.
  • The period lasts 31 days.
  • There are 26 days between the report date on 10 May 2021 and the end date of the schedule period on 5 June 2021.

0041_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 120,54 / 31 * 26

= 83 972,07

 

Example 2 - Unadjusted Payment Date - Same Report Date

On 5 May 2021, the accrued rent of 0041 is EUR 100 120,54.

Rent_Accrued_Advance_2_EN.png

  • The report date is 5 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 120,54.
  • The period lasts 31 days.
  • There are 31 days between the report date on 5 May 2021 and the end date of the schedule period on 5 June 2021.

0041_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 120,54 / 31 * 31

= 100 120,54

 

Example 3 - Following Payment Date

On 3 May 2021, the accrued rent of 0042 is EUR 8 010,66.

Rent_Accrued_Advance_3_EN.png

  • The report date is 3 May 2021, corresponding to the 5 April - 5 May 2021 period of the transaction.
  • The payment amount for the 5 April - 5 May 2021 period is EUR 100 133,31.
  • The payment date of the 5 April - 5 May 2021 period is 10 April 2021, reducing the 5 April - 5 May 2021 period to a 10 April - 5 May 2021 period.
  • The 10 April - 5 May 2021 period lasts 25 days.
  • There are 2 days between the report date on 3 May 2021 and the end date of the schedule period on 5 May 2021.

0042_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 133,31 / 25 * 2

= 8 010,66

 

Example 4 - Following Payment Date

On 5 May 2021, the accrued rent of 0042 is EUR 0.

Rent_Accrued_Advance_4_EN.png

  • The report date is 5 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment date of the 5 May - 5 June 2021 period is 10 May 2021, reducing the 5 May - 5 June 2021 period to a 10 May - 5 June 2021 period.
  • 5, 6, 7, 8, and 9 May 2021 do not belong to any period, the accrued rent is therefore 0.

0042_EN.png

 

Example 5 - Preceding Payment Date

On 17 May 2021, the accrued rent of 0046 is EUR 52 841,40.

Rent_Accrued_Advance_5.png

  • The report date is 17 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for the 5 May - 5 June 2021 period is EUR 100 120,54.
  • The payment date of the 5 May - 5 June 2021 period is 30 April 2021, increasing the 5 May - 5 June 2021 period to a 30 April - 5 June 2021 period.
  • The 30 April - 5 June 2021 period lasts 36 days.
  • There are 19 days between the report date on 17 May 2021 and the end date of the schedule period on 5 June 2021.

0046_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period

= 100 120,54 / 36 * 19

= 52 841,40

 

Example 6 - Interest Manually Updated

On 17 May 2021, the accrued rent of 0047 is EUR 61 294,73.

Rent_Accrued_Advance_6_EN.png

  • The report date is 17 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 300.
  • The period lasts 31 days.
  • There are 19 days between the report date on 17 May 2021 and the end date of the schedule period on 5 June 2021.

0047_EN.png

  • The interest amount for that period has been manually updated, from EUR 120,54 to EUR 300.

0047_Audit_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the report date to the end date of the schedule period - (current interest amount of the schedule period - initial interest amount of the schedule period)

= 100 300 / 31 * 19 - (300 - 120,54)

= 61 294,73

 

Accrued Rent (in arrears)

Aggregated amount of rents to pay on the report date, based on the actual payment date, in the currency applied to the report:

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

Note: The Accrued Rent (in arrears) indicator only applies to leases in arrears.

 

Example 1 - Unadjusted Payment Date - Different Report Date

On 10 May 2021, the accrued rent of 0043 is EUR 16 151,25.

Rent_Accrued_Arrears_EN.png

  • The report date is 10 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 137,78.
  • The period lasts 31 days.
  • There are 5 days between the start date of the schedule period on 5 May 2021 and the report date on 10 May 2021.

0043_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 5

= 16 151,25

 

Example 2 - Unadjusted Payment Date - Same Report Date

On 5 May 2021, the accrued rent of 0043 is EUR 0.

Rent_Accrued_Arrears_2_EN.png

  • The report date is 5 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 137,78.
  • The period lasts 31 days.
  • There are 0 days between the start date of the schedule period on 5 May 2021 and the report date on 5 May 2021.

0043_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 0

= 0

 

Example 3 - Following Payment Date

On 7 May 2021, the accrued rent of 0044 is EUR 106 610,50.

Rent_Accrued_Arrears_3_EN.png

  • The report date is 7 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for the 5 May - 5 June 2021 period is EUR 100 137,78.
  • The 5 May - 5 June 2021 period lasts 31 days.
  • There are 2 days between the start date of the schedule period on 5 May 2021 and the report date on 7 May 2021.
  • The next payment date is 10 May 2021, belonging to the 5 April - 5 May 2021 period of the transaction.
  • The payment amount for the 5 April - 5 May 2021 period is EUR 100 150.
  • The 5 April - 5 May 2021 period lasts 30 days.
  • There are 30 days between the start date of the schedule period on 5 April 2021 and the report date on 5 May 2021.

0044_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 2 + 100 150 / 30 * 30

= 106 610,50

 

Example 4 - Preceding Payment Date

On 17 May 2021, the accrued rent of 0045 is EUR 38 763,01.

Rent_Accrued_Arrears_4.png

  • The report date is 17 May 2021, corresponding to the 5 May - 5 June 2021 period of the transaction.
  • The payment amount for that period is EUR 100 137,78.
  • The period lasts 31 days.
  • There are 12 days between the start date of the schedule period on 5 May 2021 and the report date on 17 May 2021.

0045_EN.png

Payment amount of the transaction / Count of days in the schedule period * Count of days from the start date of the schedule period to the report date

= 100 137,78 / 31 * 12

= 38 763,01

 

Example 5 - Preceding Payment Date

On 2 May 2021, the accrued rent of 0045 is EUR 0.

Rent_Accrued_Arrears_4_EN.png

  • The report date is 2 May 2021, corresponding to the 5 April - 5 May 2021 period.
  • The payment date of the 5 April - 5 May 2021 period is 30 April 2021, reducing the 5 April - 5 May 2021 period to a 5 April - 30 April 2021 period.
  • 30 April, and 1, 2, 3, and 4 May 2021 do not belong to any period, the accrued rent is therefore 0.

0045_EN.png

 

Was this article helpful?
0 out of 0 found this helpful