Aged Debts Report

The Aged Debts report provides detailed information on all invoices and statements that fulfill the following 2 conditions:

The value date has passed in relation to the date defined under Date to Relate.
The invoices and statements are not fully covered.

Purpose

This report can be used as follows:

To display the total balance of all travel files with debt opened for travel agents/corporate clients, according to specific filters
To filter the travel files with aged debt opened for travel agents/corporate clients, according to age groups
To display total amounts

Output

The report has two system templates:

Aged Debt: Detailed breakdown of information on the travel agent/corporate client and the amount of debt.
Aged Debt Summary: The amounts left to pay per travel agent/corporate client in the system currency and the travel file currency.

This report has the following layouts:

CSV
DOCX
PDF
Text
XLSX

In addition, there is a Print option.

How to generate a report - see Reports.

Filters

The report has the following parameters which are shown on the left and enable you to filter the report output:

Parameter	Description
Date to Relate	Choose between Issue Date and Value Date.
Display Currency	Choose between System and T. File (Travel File) Currency.
Branch	Choose the branch where the document was issued.
Agent/C. Client	Choose the travel agent/corporate client the document was issued for. If the document was issued for direct sale, select Direct Sale.
Issue Date	Choose the date range in which the document was issued.
Value Date	Choose the date range of the document due date.
T. File Start Date	Choose the date range in which the travel file starts (the date of the earliest service in the travel file).
T. File Open Date	Choose the date range in which the travel file was opened.
T. File Attribute	Choose the attribute of the travel file.
T. File Market	Choose the market of the travel file.
Inv Type	Choose the invoice type (cash or credit).
Min. Debt Amount	Choose the minimum debt amount, greater than (enter in field).

Example

The generated Aged Debt report displays four pie charts (more on the pie charts – see below) and a table with invoice and statement document records that match the defined parameters.

Each row in the table of the Aged Debt report represents an invoice.

The Aged Debt report is generated together with four charts:

- Debt Age per Curr.: This chart shows the debt according to currency as well as the amount left to pay in the original currency.

- Total Left to pay: This chart shows the total amount left to pay in the system currency.

- Top 10 Agent/ C. Client by Debt Age: This chart shows the top 10 agents / corporate clients organized by debt amount, in system currency, and by debt age (color of rows).

- Total Left to Pay: This chart shows the total left to pay amounts in system currency, as well as the debt age (color of columns).

The following fields are displayed in the generated report:

Field	Description
Agent/C. Client	This field shows the travel agent/corporate client the document was issued for, or Direct Sale if the document was issued for a direct sale.
Currency	This field shows the currency of the travel file in which the document was issued.
Debt Age	This field shows the debt age.
T. File No.	This field shows the reference number of the travel file in which the document was issued.
T. File Start Date	This field shows the start date of the travel file in which the document was issued.
Branch	This field shows the branch associated with the clerk issuing the document.
User	This field shows the user issuing the document.
Document No.	This field shows the document reference number.
Issue date	This field shows the document issue date.
Value Date	This field shows the document due date.
For Details	This field shows the person the invoice is generated for.
The values in the following columns are displayed in the Document Currency
Amount Doc. Curr.	This field shows the amount in the document currency.
Agent Comm./C. Client Reduction	This field shows the travel agent commission/corporate client reduction amount included in the invoice.
Covered Amount Doc. Currency	This field shows the amount covered by other issued documents, such as TRC, or RCT.
Left to Pay Orig. Currency	This field shows the amount not yet covered by other issued documents, and is still left to pay, in the original currency.
Doc. Curr	This field shows the document currency.
The values in the following columns are displayed in the Travel File Currency
Amount	This field shows the invoice total amount.
Reduction/Comm.	This field shows the travel agent commission/corporate client reduction amount included in the invoice.
Amount Paid	This field shows the amount covered by other issued documents, such as TRC, or RCT.
Left to Pay	This field shows the amount not yet covered by other issued documents, and is still left to pay.
Curr	This field shows the travel file currency.

Example

The Aged Debts Summary report displays a total row for each debt age. These rows can be expanded to include the total for each currency, and then the individual invoices issued for direct sales and each travel agent/corporate client.

The following fields are displayed in the generated report:

Field	Description
Currency	This field shows the currency of the travel file in which the document was issued.
Debt Age	The debt age is defined as the number of days that pass between the document value date and the date defined under Date to Relate. The debt age range can be one of the following: 0-30, 30-60, 60-90, 90-120 and 120+ (days)
Amount	This field shows the amount of the debt.
Reduction/Comm.	This field shows the reduction or commission for agent/c. client.
Amount paid	This field shows the amount of the debt already paid.
Left to Pay	This field shows the amount not yet covered by other issued documents, and is still left to pay.