Reporting on Fees

There are several reports available through Alto that can report on agency fees that have been charged and/or paid, and each will produce slightly different results.  Your accountant will be able to advise which report(s) they would like you to use.

To locate these reports:

1. Click Reports on the main toolbar
2. Click Property Management Financials in the side menu under Reporting Groups 

The two main reports are Processed Fee Analysis and Invoice Fee Analysis.

This article includes:

• Processed Fee Analysis
• Invoice Fee Analysis report
• Other reports

Processed Fee Analysis

This report contains information on all fees updated (i.e. paid) on Process Agency Fees. For most users, this is the main report used.

1. Click Processed Fee Analysis under Property Management Financials Reports
2. You can select from several Report Options under Your Report to filter by:
   1. Period
   2. From and To dates
   3. Order
   4. Direction
   5. Group
3. The report can be further filtered using the additional tabs under Your Report, such as by branch or any of the Report Columns
4. Click Create Report to generate a one off report
   1. You can also Export the report into a .pdf, Excel or .csv document if you prefer to view it in an alternative format
5. The report will automatically open in a new browser tab once created
   1. It'll also be available within your Report requests, allowing you to open it later should you wish. Click Open to open the report or Clear to remove it

If you export it in Excel format, you can then sort/filter in Excel by the Charge Item column if you then want to report by charge item under different nominals in your business accounts software.
If you have charges that do not have an invoice number yet, this is because the invoice has been paid, but the invoice has not yet been produced (usually because the landlord statement has not yet been generated) – however a user would be expected to do this within 30 days.

This is better suited towards cash accounting entries for your fees in your business accounts software. This report will match what has been paid on on Process Agency Fees.

Invoice Fee Analysis report

This report contains information on all fees raised, irrespective of whether they have been updated/paid on Process Agency Fees or not.

1. Click Invoice Fee Analysis under Property Management Financials Reports
2. You can select from several Report Options under Your Report to filter by:
   1. Period
   2. From and To dates
   3. Order
   4. Direction
   5. Group
3. The report can be further filtered using the additional tabs under Your Report, such as by branch or any of the Report Columns
4. Click Create Report to generate a one off report
   1. You can also Export the report into a .pdf, Excel or .csv document if you prefer to view it in an alternative format
5. The report will automatically open in a new browser tab once created
   1. It'll also be available within your Report requests, allowing you to open it later should you wish. Click Open to open the report or Clear to remove it

If you export it in Excel format, you can sort/filter in Excel in to various categories such as the Charge Item.

This is better suited to accruals accounting entries for your fees in your business accounts software. This will not match what has been paid on Process Agency Fees. This also contains a Property/Tenancy code column.

Other reports

There are two other reports you may find useful such as:

• VAT Fee Analysis (Accrual) – Includes all management fee charge/credit transactions
• VAT Fee Analysis (Cash) – Includes all fees processed/paid in full or part paid via Process Agency Fees

When producing the reports, you can choose your own date range and can also choose the order or grouping. However, you might find it easier to export to Excel or .csv to enable you to sort and group via a spreadsheet.

Within Reports, Property Management, Landlord Property Tenancy Tenant List, you can filter for the management type of the property and then export to Excel etc.

Within Reports, Property Management Financials, Processed Fee Analysis, you can export to Excel and report on the fees paid.

If you want to be able to export your fees in order to import them into your business accounting software for Making Tax Digital, you will need either of the following reports:

• Fee Export (Accrual)
• Fee Export (Cash)

For more information on the Making Tax Digital - User Guide, click here

Related articles:

Running reports

Setting up a scheduled report

Exporting reports

Report tokens