Skip to content
English
  • There are no suggestions because the search field is empty.

The Debtor Report explained

This article explains how to read and use the debtor report in order to view outstanding balances for a specific property. Follow the steps below to access and export the information.

The Debtor report can be found from the main menu under Reports :

 

The debtor report table displays all customers or guests (Debtor Name) with outstanding balances. The tabs indicate how long each debt has been open for:

 

  • Click the eye icon at the end of a row to view detailed information for a specific debtor:




  1. Due date - The date by which the invoice should have been paid.
  2. Check-out date - The reservation's check out date.
  3. Booking number - The reservations check-in date.
  4. Invoice number - The invoice unique Id-number.
  5. Total amount - The total amount of the invoice.
  6. Paid amount- The portion of the invoice that has already been settled.
  7. Total unpaid amount - The portion of the invoice that still has to be settled.

To refine the debtor list, click the Filter button located in the top right corner of the screen.

  1. Debtor type - Filter on one specific debtor type 
  2. Payer name - Filters the documents with an open balance by a single payer
  3. Sign - Choose the mathematical symbol to determine the amount to be filtered :

     = Equal to the entered amount in criteria 4 (balance) 

    < Less than the entered amount in criteria 4 (balance) 

    > Greater than the entered amount in criteria 4 (balance) 

    Equal to and less than the entered amount in criteria 4 (balance) 
    Equal to and greater than the entered amount in criteria 4 (balance) 
    Not equal to the entered amount in criteria 4 (balance) 
  4. Currency - If multiple currencies are available, select the desired one here.
  5. Balance - The sign and amount you enter set the filter criteria and will show you the outstanding balances.
  6. Only due toggle - Displays outstanding amounts due on the dates you select in criteria 7.
  7. Date - Enter the due date after toggling on the 'Only due' criteria in 6
  8. Check Out - Filters on the reservation check out date.

 

To export the debtor report, click the Export button in the top right corner of the screen. This will generate an Excel file containing the debtor list, ready for sharing or printing as needed: