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.
- 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.
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.
- 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.
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.
- 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.
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.
- 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.
Example 5 - Preceding Payment Date
On 17 May 2021, the accrued rent of 0046 is EUR 52 841,40.
- 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.
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.
- 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.
- The interest amount for that period has been manually updated, from EUR 120,54 to EUR 300.
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.
- 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.
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.
- 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.
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.
- 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.
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.
- 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.
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.
- 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.