Overview

The Universal Payment Report has been built to produce transactional payment data in a format that can be easily read by accounting software. The report pulls payment information from your Agreements, including IFRS Component and Non IFRS Component Payments. You can run the report using a preset, using the default set up that loads when you open the report, or you can customise it to fit your existing accounting needs. This will produce a customised output which you can use as part of your regular accounts payable and / or receivable processes.

This article will go through:

• how to find the Universal Payment Report
• how to run and export the report
• how to make basic customisations
• how to save the report as a preset

For information on more advanced features of the report, including filtering, removing wash-up payments, identifying holdover Agreements, incrementing outputs, and viewing taxation details, please check out this article. 

Navigation

Basic Steps

To run the Universal Payment Report, follow these steps:

1. Navigate to the Reporting page of OneLease (Beta).
2. Click on the Universal Payment Report.
3. Select which Agreements you want to see represented in the Report.
4. Set a Reporting Period.
5. If you’d like to make customisations in the Mapping and Column Builder sections, you can do so at your own discretion. Otherwise, click Run Report.

If the report is taking a while to run, you can use the “Email Me” button to receive an email notification once the report has generated. This email will provide a link to open a tab in your browser containing the generated report.

Agreement Filtering

To run the report for all Agreements, simply leave the Agreement field at the top of the page set as “All Agreements”.

To run the report for select Agreements:

1. Choose the “Selected Agreements” option.
2. Choose the relevant Agreements from the drop-down menu.
3. Select the Agreements you want to include by clicking them.
4. If need be, you can remove Agreements from the filter selection by clicking the X button next to the Agreement name.

For information on using the "Filter Groups" option to alter which Agreements are included in the report, check out this article. 

Reporting Period

To run the report for a specific period:

1. Enter the Start Date using the calendar tool or by typing in the date.
2. Enter the End Date using the calendar tool or by typing in the date.

Alternatively, use the Relevant Date Picker:

1. To the right of the start and end date fields, click the drop-down menu.
2. Choose from the existing period options.

Column Builder

The vast majority of inputs for the Universal Payment Report are in the Column Builder section. The section allows for data to be pulled from Agreement, Entity, Property, and Payment-related fields, including Custom Data Fields added to the former three. You can add new columns, remove columns, and edit existing columns.

To add a new column:

1. In the Column Name field, enter the title of the column.
2. In the Value field, enter the information required to produce your desired output. This information could include data fields, functions, numbers, operators, and plain text.
3. Once you are happy with the information in the Value field, click Add.

Typing a forward slash (/) into the Value field will bring up a long list of usable data fields. This list includes multiple fields that are hard-coded into the report, pulling information from the standard fields available during the Agreement creation process. These tend to follow the example format of agreement.fieldName, payment.fieldName, entity.fieldName, and property.fieldName. If your Organisation has Custom Data Fields set up, these will also appear in the data field list. 

• For Agreement custom fields, these appear using the format of agreement.custom.ExampleField. 
• For Entity and Property custom fields, these appear using the format entity.ExampleField and property.ExampleField respectively. 

To remove a column, click the bin icon for the relevant column: 

To edit an existing column, simply make the required changes in the Column Name and/or Value fields. The changes will be saved, and you can run the report.

Error Logs

Remember to check your report's Logs once you have run the Report. The Logs will show which of your Agreements have not successfully pulled through to the Report you've generated, and an error message noting the reason why. 

To view the Error Logs:

1. Run your Report.
2. Click the Logs button. To return to the Report view, simply click the Report button.

The Error Logs will display the Agreement ID, Agreement Name, and the relevant error message. You can then search for the ID or Name in the current version of Nomos One to find the Agreement and resolve the error. 

Exporting

Once you have generated the report, click the “Download” button in the top right corner of the page to download a CSV file of the report. 

If you have columns that are included in the report that you do not need included in the exported file, open the Column Builder section and uncheck the “In Export” box for the relevant columns. 

Preset Options

Saving a Preset

Once you are happy with the customisations you have made, and have run the report, you can save it as a Preset. To do so:

1. Click the “Save Preset” button next to the “Download” button.

2. Give the Preset a name.

1. Click “Create Preset”.

Your Preset will now be saved in the “Saved Presets” tab of the Reporting page. 

Using a Preset

To run the Universal Payment Report using a Preset:

1. Navigate to the Reporting page of OneLease (Beta).
2. Click on “Saved Presets”.
3. Click the Preset you want to use to run the Report.

4. Make any additional changes if needed.
5. Click “Run Report”.

Preset Options

When you run the Universal Payment Report using a Preset, you'll see three buttons left of the Download button. 

• The first button, "Save preset changes", allows you to save any changes made to an existing Preset. 
• The second button, “Copy preset”, allows you to duplicate the Preset you are currently using. 
• The third button, “Delete preset”, allows you to delete the Preset you are currently using. Note that deleting a Preset will delete it across the whole Organisation, so other users will also be unable to use the Preset once it has been deleted. 

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.