Payment Adjustment Report - Product Advisory
November 2021
Business Summary
The Payment Adjustment Report is designed to provide a list of all payment adjustments recorded in a given time frame by type and amount along with audit-trailing of who made the adjustments and when.
The Payment Adjustment Report shows an audit trail of all payment adjustments recorded by any user. The report is generated by specifying a date range corresponding to the SYSTEM DATE, in other words, the date when the payment adjustments were recorded.
Generating the Report
To locate this report, select Reporting from the Left NavBar. Then click on the Accounting tile. The Payment Adjustment Report can be found on the Right NavBar.
Report Parameter Definitions
Parameter |
Description |
|---|---|
Date Recorded Range |
This represents the date range the report will cover. The selected date range refers to the System Date (the date when the payment adjustments were recorded) – not the Effective Date of a payment adjustment. Once a month is selected, additional fields for day and year appear along with the calendar widget. This is a required field. |
As At Date |
This setting works the same way as the As At Date parameter on the Ledger Export. It defaults to the current system date. |
Schedule Number |
Available filtering on a single or multiple schedule(s). The wildcard character (*) can be used to isolate a specific group of schedules. For example, Fin* would select all schedules that begin with “Fin”. |
Show deals denominated in: |
Filter used to specify a single transactional currency at deal level. |
Entity |
Available filter for customer-defined Entities via drop-down menu. |
Lessee |
Available filter for customer-defined Lessees via drop-down menu. |
Business Unit |
Available filter for customer-defined Business Units via drop-down menu. |
Person who Recorded the Adjustment: |
User ID of the user that recorded the payment adjustment. |
Set of Books |
Filters customer ledgers via drop-down menu. This is a required field. |
Once the parameters have been selected, click on the Export button to generate the Excel (XLSX format) report.
The Schedule this Report feature is enabled for the Payment Adjustment Report. More information regarding report scheduling can be found in the “Overview of Reports” training in Ask Alex.
Report Output
The report shows the same data used when recording the payment adjustment from the UI or Payment Adjustment tab of PIW:
Report Output Definitions
Column Header |
Description |
|---|---|
Schedule# |
Schedule/Deal number of the lease to which change occurred. |
Deal ID |
System generated deal identifier. |
Business Unit (BU) |
BU assigned as a deal-level participant on the associated Schedule Number |
Entity |
Entity assigned as a deal-level participant on the associated Schedule Number. |
Lessee |
Lessee assigned as a deal-level participant on the associated Schedule Number. |
Accounting Classification |
Accounting classification assigned to the Schedule based on the combination of AsAt date and selected accounting standard. |
Payment Frequency |
Payment frequency of the affected Schedule. |
Transactional Currency |
Currency the Schedule is transacted in. |
Status |
Status of the Schedule as of the selected As At date. |
Recurring - Y/N |
Output determines whether the recorded payment adjustment is as recurring or one-time. |
Payment Adjustment Type |
Type of payment adjustment recorded. Options include Underlying Index Rate Changed, Contingent Rent Resolved, and Other. |
Remeasuring Effective/Posting Date |
The effective date of the payment adjustment. This is the Ledger Date in which the accounting will be reflected in the Ledger Export. |
Change Payment Amount Starting |
The first payment date in which the payment adjustment will occur. This could be >=< the above effective date. This payment date coincides with the payment date on the payment schedule in Deal Summary reflecting the payment adjustment. |
Payment Amount Prior to Adjustment |
Payment amount in transactional currency absent the new recorded payment adjustment. This amount represents what the payment would have been if no payment adjustment was recorded. |
Current Adjustment Amount |
Difference between “New Payment Amount (Transactional)” and “Payment Amount Prior to Adjustment” columns. |
New Payment Amt (Transactional) |
The adjusted payment amount in transactional currency based on the payment schedule in the Deal Summary (after adjustment). |
Recorded By |
UserID of the user that recorded the payment adjustment. |
System Date of Record |
System date and timestamp of when the payment adjustment was recorded |
A sample of the Payment Adjustment Report output is below: