Skip to main content

Arrears - Creating a rent arrears report

This guide describes how to generate a rent arrears report by exporting property balance data. The report is produced as a CSV file, which can be opened and analysed in Microsoft Excel.

Overview

A rent arrears report provides a snapshot of outstanding tenant balances as of a specified date. The report is generated from the property balances section and reflects data up to the most recent bank line import.

Step-by-step instructions

  1. Navigate to Lettings properties > Property balances

  2. From the left sidebar, click on the Set end date option

  3. Select the day on which bank lines were last imported for

  4. Click Submit

  5. To export this page as a CSV file, click on Export

The export will be downloaded to your computer where it can be opened in Microsoft Excel.

Note: Please ensure that bank lines are up to date and that your system balance matches your bank balance before generating. This ensures the accuracy of the rent report.

Did this answer your question?