Supplier debt report

Owned by Fiona Wilson, created
Last updated: Feb 14, 2023
2 min read

This guide has been reviewed against our global client base and classed as relevant to all regions

The Query Transactions function allows a supplier debt report can be generated, providing a view of the live balance of outstanding invoices which are yet to be paid

1. Accessing the report

From Lettings/Rentals on the main menu:

  • Select Reporting and Analysis

  • Click Query Transactions

 

2. Enter criteria

To view a live balance of outstanding invoices which are yet to be paid, enter the following criteria:

  • Unallocated: enter an end figure (e.g. £1m)

  • Ledger: select Supplier

  • Click Report

3. Viewing the report

The Unallocated column shows how much is outstanding on the invoice
This is inclusive of partially paid & fully unpaid invoices

The report results are shown in a grid, which allows you to:

  • Click any column heading to sort in ascending/descending order

  • Click to the right of a column heading for filter options

  • Right-click and add further columns and/or export to Excel