Printing HMRC reports

 Note

Alto enables you to produce and print both quarterly and yearly NRL tax reports for overseas Landlords, as well as the Schedule 23 report as required by HMRC
For more information on Overseas tax/NRL - process tax quarterly, click here

This article includes: 

Quarterly NRL reports

Once the NRL tax has been processed, the steps below will allow you to view or print the reports.

  1. Click Accounts on the main toolbar
  2. On the side menu, within the Bank Transactions section, click Process NRL Tax
  3. Click the Timeline top tab
  4. Click View next to the NRL report that relates to the quarter you wish to view or print
  5. The report opens in a new tab on your browser. You can now print it, however, the way you print the report will depend on the browser you are using 

Yearly NRL reports

  1. Click Accounts on the main toolbar
  2. On the side menu, within the Bank Transactions section, click Process NRL Tax
  3. Click the NRL Reports top tab
  4. Report Type - In the dropdown menu, click NRLY Annual Information Return
  5. Year End - In the dropdown menu, click the relevant year end that you want to produce the report for
  6. Group by Client Account - Tick, if required
  7. Click View
  8. The report opens in a new tab on your browser. You can now print it, however, the way you print the report will depend on the browser you are using

The report displays the rental income, expenses, and tax for each landlord. It also displays the amount of tax that should have been paid over to the HMRC, for each quarter.

Producing the Schedule 23 report

The HMRC will also request a completed Schedule 23 report.

  1. Click Reporting on the main toolbar
  2. Click Property Management Financials in the side menu under Reporting Groups 
  3. Click Schedule 23 Report under Property Management Financials Reports
  4. In the Report Options section:
    1. The Period will default to Last Tax Year
    2. The From and To dates will reflect the Last Tax Year
    3. You can use the Overseas dropdown menu to either Include or Exclude Overseas Landlords
  5. The Branch Filtering section can be used to select an individual branch, or multiple branches, for the report
  6. Whilst you can click Create Report to generate a one off report, it's advised you click Export CSV
  7. The report will appear as a Page icon next to your login name on the main toolbar. Hover over the icon and click Open next to the report

Exporting the Schedule 23 report

You now have the file saved as a .csv. HMRC like the file submitted on their ROPL-01 submission template which can be found online if they haven't sent it to you. We recommend opening up the .csv saved on your computer, then copying and pasting the information in to the HMRC ROPL-01 submission template.

  1. Open the .csv file
  2. Highlight just the cells containing data from line 2. Right click and select Copy

    hmrc_report.png

  3. On the HMRC template, right click into the first cell on line 3 and click Paste Special
  4. Select Values (or Text if unavailable) and click OK. This will paste the information into the spreadsheet

    HMRC_report_sheet.png

  5. Save the file as an .xls or .xlsx file using Save As, and save it with the filename requested by HMRC in the notice

     Note

    The HMRC ROPL-01 submission template contains a number of validation rules for each column and will highlight any issues with your data in red, that doesn't comply with HMRC’s requirements

Your return is now ready for submission as directed within the notice you have received.

Was this article helpful?
1 out of 1 found this helpful