The Agreement Balances Report in OneLease is designed to give a breakdown of the Right of Use Asset (ROUA) and Lease Liability accounts, by Agreement, and the movements through these accounts for a given period. This report can be used to review the detail of the numbers which make up your financial statements, as well as to sense check any adjustments that have been made to Agreements during the period. For a breakdown of the report output, including what each column means, check out this article. 

The Agreement Balances Report is an adaptation of the Agreements (All Asset - All Liability) Report on the Legacy Engine. In this new Report, we've:

• Expanded our Filters. Make sure you review our Filter guidance when generating your report.
• Incorporated a greater level of detail into the account movements across your portfolio to allow greater visibility as to what Agreements have changed over the reporting period to help with review.
• Made downloading your report more flexible - you'll be able to select whether you export in CSV or Excel formats as well as customise how different Currencies are exported.
• Added saving report template functionality with the Relevant Date Picker and Save Preset Reports features. You can now create reporting configurations with real time dates to make your reporting more efficient .

Generating your Agreement Balances Report in OneLease (Beta)

To generate your Agreement Balances Report:

1. Select whether you want to report on All Agreements, or filter your Report using Selected Agreements or Filter Groups.
2. Record the Start of Report Period and End of Report Period using the Calendar tool or by using the Relevant Date Picker for quick Period select.
3. Select the Rollup for the Report.
   

   Read more about the Rollup below.

    
4. Click Run Report.

Rollup

The Rollup feature in the Agreement Balances Report allows you to view the report broken down by month.

By default, None will be selected in the Rollup. This means the report will show one line per Agreement, covering the total of the Reporting period. 

If Monthly has been selected, information for each Agreement will be broken down into separate lines for each calendar month entered in the Reporting Period. The Period column will display the date that the Opening Balance for each calendar month has been calculated. 

For Example:

This Report has been run for the period 15 January 2024 to 31 March 2024, using the Monthly rollup. As there are 2 calendar months and a part month in that timeframe (15 January - 14 February, 15 February - 14 March and 15 March - 31 March), we can see these separated into the 3 separate lines for each Agreement. 

 

Column Builder

You can use the Column Builder feature to customise the output of your report. 

If you are running the report using the default input, the column builder will show 0 columns added. However, the output will include 28 columns by default. These default columns cannot be removed. If you do not add any extra columns, the column builder will always say “0 columns selected”.

What columns can be added?

There are 8 columns that you can add, as well as any Agreement custom fields that have been created in your Organisation. They are:

• Agreement ID
• Asset Class
• Currency
• GL Template Name
• Known As
• Payment Period
• Payment Mode
• Transition Method

Some of the column builder options are already default columns in the report output - Known As, Agreement ID, and Currency. As such, you do not need to add them when configuring the report. 

How to add a column

1. Click on 0 columns selected. This will open up the Column Label text box and Column Value drop down menu.

2. Select the Column Value that you would like to use. Then, type the desired column name into the Column Label field and click Add. 

3. You can combine multiple columns together by selecting more than one Column Value. You can also add custom text before, in between, or after a selected Column Value to customise how these data fields will appear on your report once generated.

4. Once reviewed, you can re-arrange the added columns by using the drag handle. 

5. Lastly, click Run Report to see the new columns in your output. They will appear after all of the default columns. 

How to delete a column

To remove a column, simply click on the bin icon. You can re-add any deleted columns if need be. 

Breaking down the Agreement Balances Report

The Agreement Balances Report shows you key information for each Agreement, including: 

• Basic reporting information (allowing you to identify the Agreement and time period)
• Right of Use Asset balances and movements
• Lease Liability balances and movements
• Make Good balances and movements

For a breakdown on each individual column, check out this article on understanding the Agreement Balances Report. 

Checking the Reporting Logs

Remember to check your Report's Logs. The Logs will show you if there are any errors which may be preventing any of your Agreements from displaying in the Report you've generated.

To learn more about the Logs and what particular errors mean, you can check out the OneLease (Beta) Report Logs article.

Downloading your Agreement Balances Report

1. Click Download at the top of your Report.

2. Select the Format you would like to download the report into, either CSV or Excel (.xlsx).

3. Click Download CSV or Download Excel (depending on the Format you've selected in step 2).

Your downloaded Report will be ready to open!

Saving a Preset of your Agreement Balances Report

If you would like to save a particular configuration you've created for your Agreement Balances Report, you can do this by saving a Preset of your report. Check out how to do this here.

Nomos One does not provide or purport to provide any accounting, financial, tax, legal or any professional advice, nor does Nomos One purport to offer a financial product or service. Nomos One is not responsible or liable for any claim, loss, damage, costs or expenses resulting from your use of or reliance on these resource materials. It is your responsibility to obtain accounting, financial, legal and taxation advice to ensure your use of the Nomos One system meets your individual requirements.