Accounting Payments Report
This template is supported by the BVAccountingPayment Business View. It is a 3-page report that reflects AP Clearing entries in transactional, functional, and reporting currency with a breakdown into principal, interest, and variable portions. Data items associated with a lease's accounting payments are also included, as well as a parameters page.
Unlike the Operational Payment Report, which shows contractual payments by fiscal month, this report depends on the ledger date of the AP Clearing entry. Therefore, backdated activity represented by adjusting entries is reported in the fiscal month in which the entry is recorded rather than the month the entry covers.
The report reflects payment-related entries as they appear in the Ledger Export (Journal Entries Report). As such, non-monthly payments for Capitalized-Operating schedules will include the Contractual Payment in the fiscal payment month, while the associated Interest and Principal entries are reported for each month (including gap months) individually.
As this report reconciles to other accounting reports, it includes an AsAt date. Where possible, non-accounting values are based on the AsAt date; however, some non-accounting data is only available as of the system date of report generation.
Note: Review AsAt parameter information below to obtain the desired output.
For more information regarding the individual data elements included in the business view, refer to the Data Dictionary.
When using fields with multiple values, they will be comma-separated with the exception of the GL segment representing the account code. If this field is added to the report, ##ACCOUNT## will appear since multiple account types are utilized in the generation of the report.
This report is located under the Design Studio tile in the Reporting workspace.
Below is an example of the parameters included in the Accounting Payments Report:
Report Parameter Definitions – Accounting Payments Report
Parameter |
Definition |
|---|---|
As At Date |
Fiscal month-end date for which AP Clearing entries are effective. Activities recorded with the ledger date on or before this date will be included. Activities recorded with effective ledger date after this date will not be included. (REQUIRED FIELD)
|
Starting Fiscal Period |
First fiscal month-end date of which the report will provide payment values.(REQUIRED FIELD) Note: Since each fiscal month equates to 4 columns on the Summary tab, wide date ranges may exceed the maximum number of columns available in Excel. |
| Ending Fiscal Period |
Final fiscal month-end date of which the report will provide payment values.(REQUIRED FIELD) Note: Since each fiscal month equates to 4 columns on the Summary tab, wide date ranges may exceed the maximum number of columns available in Excel. |
Ledger |
Filter of client configured ledgers via a drop-down menu. Only one ledger can be selected at a time. (REQUIRED FIELD) |
Show Evergreen Payments |
Yes/No option with No as the default.
(REQUIRED FIELD) |
Schedule |
Available filtering on a single or multiple specific schedule(s). The wildcard character (*) can be used to isolate a specific group of schedules. |
Entity |
Available filter of client-defined Entities via drop-down menu. Only one Entity can be selected at a time. |
Business Unit |
Available filter of client-defined Business Units via drop-down menu. Only one Business Unit can be selected at a time. |
Results contain three separate pages: Summary, Detail and Parameters. You can switch between the pages by using the Go To option in the menu bar.
Summary - Presents accounting payments with principal, interest, and variable breakdown by schedule and fiscal month based on the months included in the parameters. The summary operates as a crosstab of the Detail tab information. Default is Transactional Currency. Functional and Reporting Currency options are available from the Business View.
Detail – Sorted by fiscal month. Includes accounting payments split into principal, interest, and variable components. Default is Transactional Currency. Functional and Reporting Currency options are available from the Business View.
Parameters – Snapshot of the parameters used, along with the login name of the requestor and the time and date of report generation.