Frequently Asked Questions About Reporting
Download a PDF version of the guide.
Question |
Answer |
|---|---|
What report(s) should I run for my footnote disclosure? |
Maturity Analysis Report (MAR)/Quantitative Analysis Report (QAR) |
What report(s) should I run that includes my imputed interest amounts for each outward year? |
MAR |
What report should I run if I am looking for consolidated YTD totals for the P&L accounts? |
Schedule Account Balance Trend |
If I’m looking for a simple report that lists all leases in the database, and shows the closing lease liability balance at the end of a given month, in transactional currency, which reports are best? |
If you have a consolidated ledger or just one ledger, then the Schedule Account Balance Trend, Portfolio Trial Balance,and Schedule Trial Balance would all provide that information. The v2 versions of these reports can be run for all transactional or functional currencies at the same time. |
What’s the best report to run that would show ROU asset and Liability balance as of the end of a period by each individual lease? |
You may use the Design Studio Account Balance Trend, Portfolio Trial Balance v2, Account Balance Trend v2, or Schedule Trial Balance v2. |
If I am looking for a report that shows the depreciation of an asset from a Finance lease, what report should I look at first? |
If you are looking at it for the life of the lease, then start with the Accounting Workbook or Deal Analysis Report. If you are looking for depreciation over a period of time, then run the QAR. The Schedule Account Activity Trend will give you activity for all your accounts and you can drill down to depreciation. |
What report should I run if I am looking for all of our weighted average remaining term and weighted average discount rate? |
QAR |
Is there a report I can run if I want to see all lease classifications across all standards? |
Currently you would have to look at the Accounting Classification Analysis PDF available in the Documents tile of Deal History for a specific deal. The Lease Classification Report only provides initial classification. |
Is there a report that shows the Reasonably Certain EOT Option? |
Not currently |
Which report would show balances for all leases in transactional currency? |
Portfolio Trial Balance v2, Schedule Trial Balance v2, and Schedule Balance Trend v2 |
Which report would show all activity for all leases in transactional currency? |
Schedule Activity Trend v2 |
Is there a report that I can run that tells me the RCHP for each lease? |
You may use the Design Studio Account Activity Trend or Account Balance Trend and add a field for RCHP when in Interactive View. Alternatively, the MAR and QAR both include the Commencement Date and RC End Date so a simple formula in excel could help you to the RCHP. |
Which report would show my YTD Depreciation Expense? |
This can be found on any balance report including the Schedule Account Balance Trend, Portfolio Trial Balance, and the Schedule Trial Balance by Account for a single month only. |
What report shows life of lease journal entries? |
Ledger Export |
What report shows my debits and credits? |
Ledger Export |
What report should I run if I am looking for roll forward of balances from one period to another? |
Accounting Rollforward FX |
Which report shows future payments? |
MAR and Payment Report |
Which report shows remaining liability as at a specific date? |
MAR/QAR |
Which report should I run if I want to see my current lease classification? |
MAR/QAR |
Which report should I run if I want to see the current IBR being used for a lease? |
MAR/QAR |
What report shows payments for leases commencing in the future? |
MAR |
If I am trying to validate the amounts that I am seeing on my disclosure reports (MAR/QAR), what report do I need to use? |
Ledger Export |
Which report should I run if I want to see what payment adjustments were entered? |
Payment Adjustment Report |
Which report should I run if I want to see by whom and when payment adjustments were entered? |
Payment Adjustment Report |
Which report should I run if I want to see what type of payment adjustments were entered? |
Payment Adjustment Report |
Which report would show me journal entries in functional currency? |
Functional Currency Ledger Export |
Which report would show me journal entries in reporting currency? |
Currently there is not a journal entry report in reporting currency. The Accounting Rollforward FX does provide entry level conversions to reporting currency for the period selected. |
Which report is the closest to a balance sheet? |
Schedule Balance Trendand Schedule Balance Trend v2. Disregard the income statement accounts. |
Which report is the closes to an income statement? |
Schedule Account Activity Trendand Schedule Activity Trend v2. Disregard the balance sheet accounts. |
Is there a report that will give lease payments, amortization, and interest expense for select period of time? |
Schedule Account Activity Trendand Schedule Activity Trend v2. This will provide payments (aka Accounts Payable Clearing), amortization (aka Accumulated Depreciation), and Interest (either interest expense or lease rental expense depending on classification) by month, for the chosen range of months. |
Is there a report that would give me the amount of amortization expected to occur related to my lease portfolio for a future year? |
The Schedule Account Activity Trendand Schedule Activity Trend v2 may be run for a future year and would show all expected activity, including the amortization for that year. |
Which report would show my chart of accounts? |
Ledger Configuration Validation Report |
Which report should I run if I am looking for asset IDs? |
BU Asset or BYOR for Portfolio, selecting the Asset ID data element from the Asset data source list. |
Which report should I run if I want to see all the companies, addresses, and/or people that are configured in the system, regardless if they are assigned to a lease schedule or asset? |
Participant Validation Report |
Which report should I run if I want to find my Facility Codes? |
Participant Validation Report and look on Addresses tab for the attribute type of ShipToKey. |
Which report would tell me what users have been logging into the system on a certain day or over a certain time period? |
BYOR for User Administration will show last successful login and successful login count. User Activity Log will show specific activity for a user within a certain time window. |
Which report will tell me the functional currency of a lease? |
Booked Schedules List |
Is there a report that will give me my GL Segment information but without the debits and credits? |
Booked Schedules List |
Is there a report that would show me my configured IBRs as of a specific date? |
Lessee Default Rates Report |
Is there a report that would show me all my Equity rates? |
Lessee Default Rates Report |
Is there a report that would show me all my Debt rates? |
Lessee Default Rates Report |
Is there a report that would show me all my Tax rates? |
Lessee Default Rates Report |
Is there a report that will tell me what Exchange Rate is effective today? |
Exchange Rate Current State |
Is there a report that shows any changes made to Companies, Addresses, and People? |
Contact Change Management |
Is there a report that would tell me a user’s scope of access as at a given date? |
Scope of Access – Current |
Is there a report that would tell me what a user’s scope was before and after a change? |
Scope of Access - Change |
Is there a report that would tell me if any changes to my master data have occurred during a certain time period? |
Audit History Report |
What report would I run if I wanted to see what leases were coming to term in the next three months? |
EOT Pipeline |
What report would I run if I wanted to see all end of term events that have happened in a month? |
EOT Activity |
Is there a report I can run to get a list of all my Cost Centers? |
You can export a list of all Cost Centers from the Cost Center tile within the Configuration Settings workspace. |
Why am I not able to generate a Ledger Export for my full portfolio for the life of all my leases? |
The Ledger Export will only go out for 50 years and you are likely exceeding the Excel row limitation of one million rows. Try using the parameters to narrow your report output. |
When I try to generate any report, the As At drop-down seems unavailable or doesn’t have any options. Why does this happen? |
This is typically due to some FX Rates issue. The most common cause is that you do not have a lease with Transactional and Functional currency that matches your Reporting Currency. You can run the Booked Schedules List to verify that you have at least one lease that meets this criterion. Additionally, you should ensure that you have FX Rates for all relevant currencies so that the system can go from Transactional to Functional and Functional to Reporting currency. |
What is the best practice when generating any BI report when it comes to the As At date? |
It is the best practice to leave the As At date populated with what the system has defaulted to, which is the current or system date. |
If I have a standard Gregorian fiscal calendar and I want to run a QAR for Q1 of 2024, what should my Prior Period Reporting As At be? |
Since the QAR is a year over year report, you should put your Prior Period Reporting As At to be the Q1 end date from the prior year, in this example that would be 3/31/2023. |
I have tried to change the header names on my Journal Entries report but am unable to. Why? |
You must be in Interactive View and double click on the existing segment name to type the new name. |
I am trying to generate a Ledger Export for a modification I just did, but I keep getting a report that says Schedule Doesn’t Exist. Why? |
You did not complete the modification process. You must classify and book the modified deal and then generate your Ledger Export. |