Skip to main content

Debtor Reports

www.trestechnologies.com
© Tres Technologies. All Rights Reserved.

Debtor Reports

  • Updated

It is possible to access a pre-defined Debtor report via the menu bar, or design one from the MyCCT Menu.

Click Reports on the menu bar. Select Debtor from the drop down menu and then the report required from the sub-menu.

mceclip0.png

 

Creating a Debtor Report from MyCCT

Click on Reports in the MyCCT Menu and select Debtor. Click on the Design Debtor Report filter to display a fill-in screen.

mceclip1.png

For further information on designing a report, see “MyCCT Reports” in Module 9: Reports.

Some reports, when retrieved, display the number of report pages in the bottom left corner of the screen, e.g. 1 of 40. Please note that this represents the number of pages at the current screen size, a lesser number of pages will actually print. To find out the true number of printed pages, select the Preview button.

 

Trial Balance Report

The Trial Balance report gives the user the option to produce either an Aged Trial Balance or a Trial Balance Report. This is done by selecting from the Report Type box once the report screen has opened.

  • Trial Balance (default)
    • This report produces a list of Debtors with current account balances presented as a single item. If this report is required for a specific Debtor, enter their code in the Debtor ID field
  • Aged Trial Balance
    • This report provides details of Invoices and Credit Notes and how long they have been outstanding by ageing periods. The report is grouped by Debtor unless a specific Debtor ID was entered in the Debtor ID field

When any Debtor has a zero balance the option to suppress or display these Debtors is available.

 

Producing a Trial Balance Report

  • Open the Trial Balance report from the sub menu.

mceclip2.png

  • If the Debtor ID field is left blank, a list of all Debtors is displayed. If a specific Debtor report is required, type in the Debtor ID or double click and select from the list.
  • Complete the Date to field for the Trial Balance report.
  • Click the Retrieve button to display the report.

Once the report is displayed select the required output option: Print Preview, Create PDF, Print or Save As.

 

Unallocated Debtor Credits Report

The Unallocated Debtor Credits report lists all Receipts and Credit Notes to be allocated against outstanding invoices.

  1. Select the Unallocated Debtor Credits report from the sub menu
  2. If the Debtor Id field is left blank, a report for all Debtors is retrieved. If a specific Debtor report is required, type in the Debtor Id or double click and select from the list
  3. Click the Retrieve button to display the report
  4. Once the report is displayed select the required output option: Print Preview, Create PDF, Print or Save As.

mceclip3.png

 

Supplier Sales Analysis

The Supplier Sales Analysis report shows all sales by suppliers grouped by Debtors. The report is based on Invoices and Credit Notes using the fare, discounts and amounts.

  • To produce a Supplier Sales Analysis report, select this option from the sub menu
  • Complete the following fields as required, or leave at the default settings to report on all transactions for all Debtors:
    • Sort
      Choose to sort and display data in order of Debtor, Sales Code, Service Type, or Supplier.
    • Debtor Id
      Select a code to report only on the specified Debtor account.
    • Supplier Code
      Select a code to report only on the specified Supplier. This option is only available after the Service Type has been selected.
    • Tranx Date
      Input a date or date range to report only on transactions processed during the specified period.
    • Service Type
      Select a code to report only on the specified Service type (e.g. Car, Flight).
    • Sales Code
      Select a code to report only on the specified Sales type (e.g. Domestic, Sundry, International).
    • Associated Debtor
      Enter the code of any Associated Debtors.

mceclip4.png

  • Click the Retrieve button to display the report.
  • Once the report is displayed select the required output option: Print Preview, Create PDF, Print or Save As.

 

Subvention Report

The Subvention report provides agents with a detailed analysis of the financial transactions for a Debtor's preferred airline supplier.

  • To produce a Subvention report, select this option from the sub menu.
  • Complete the following fields as required:
    • Tranx Date
      • Input a date or date range to report only on transactions processed during the specified period.
    • Debtor
      • Enter a code to report only on the specified Debtor account.
    • Supplier Code
      • Enter a code to report only on the specified Supplier.
    • Associated Debtor Group
      • Enter the code of any Associated Debtors
  • Click the Retrieve button to display the report
  • Once the report is displayed select the required output option: Print Preview, Create PDF, Print or Save As.

mceclip5.png

 

Related articles