Skip to main content

Sales Reports

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

Sales Reports

From the menu bar, select Reports, click on Sales to open the sub menu and select from:

mceclip0.png

  • Commissions and Profitability
    • This report displays current Trip balance, discounts and commission with a percentage profit figure.
  • Sales Reports
    • This report provides a large amount of Supplier information. It includes GST, CCCF and Other Taxes but does NOT include commission.
  • Purchase Reports
    • The data displayed in this report includes a Nett figure, Supplier cancellation fees and commission.
  • Agency Sales Report
    • This report provides a list of sales itemised by sales code and service type. The filter Grand Total Only provides a quick view of how the agency is deriving their business.
  • Override
    • This report displays any override figures entered in the ticket and cheque requisitions.

Sales reports are based on information entered in Cheque and Ticket Requisitions, and all reports include total value.

Notes

The Commission and Profitability, Sales, Purchase and Agency Sales Report, have a section at the bottom of the report called Report Notes. It is important to read these notes to get a clear picture of the inclusions and exclusions of the report.

Trip Adjustment and Commission Report, Other Override Type transactions are not included in any of the Sales report figures.

 

Skip To:

Commissions & Profitability Report

This report provides detail about sales. It includes items such as Agents Cancellation Fees, Credit card expenses (Merchant Fees), and GST on Source Commission, as well as profit related figures and the Current Balance.

Select Commission and Profitability from the sub menu to produce this report.

Complete the following fields as required:

  • Sort Report By
    • Select the way your report is to be compiled and displayed from the following options:
      • Departure Date
      • Trip Code
      • Primary Destination
      • Consultant (default)
      • Client
      • Debtor
  • Report Type
    • Choose Detail or Summary.
  • Primary Destination
    • Enter the IATA city code or make a selection from the list displayed when double clicking in this field.
  • Trip
    • Enter a Trip code if reporting on a particular file. Double click in this field to make a selection from the Search dialogue box.
  • Consultant
    • Enter a consultant ID to report on specific consultant.
  • Departure date from/to
    • Enter the date range required. If left blank all past and future departure dates are included.
  • Tranx Date from/to
    • Enter the date range required. If left blank all past transactions are included.
  • Client Code from/to
    • Enter a Client Code range or double click this field to make a selection from the Search dialogue box.
  • Debtor Code from/to
    • Enter a Debtor Code range or double click this field to make a selection from the Search dialogue box.
    • To report on one Debtor, enter the code in the From field only.

mceclip1.png

Click the Retrieve button to display the report data. Click on the Print, Preview or Save As buttons if required.

Notes:

The Fare Value does not include amounts entered as taxes and/or non-commissionable fees. The Percentage Profit column includes credit card expenses.

Use the Agency Sales Report to see this figure without credit card expenses.

This report does not include:

  • Trip Adjustments to the following accounts:
    • Sales
    • Commission Adjustments
    • Cost of Sales
    • Credit card Expenses
    • Discount Expense
  • Adjustments or other transactions involving the above accounts and any other module.

 

Saving of Commission and Profitability report in Excel format

A create Excel button is available for the Commission and Profitability Report which generates the report to a pre-formatted style.

When the Create button is selected,

mceclip2.png

the File save screen opens. The default file naming convention is:

Commissions and Profitability Report-<report type>_MMDDYYYY_HHMM

e.g. Commissions and Profitability Report -Detailed_03092012_1400

mceclip3.png

 

Sales Reports

The Sales Report provides filters which help extract information about Supplier sales; however the retrieved data does NOT include commission.

mceclip4.png

Select Sales Reports from the sub menu to produce this report. Transaction dates must be entered to be able to retrieve this report.

Complete the following fields as required:

  • Report Type
    • Choose Detail or Summary.
  • Report By
    • Select the way the report is compiled and displayed from the following categories.
      • Consultant (default)
      • Sales Code
      • Creditor
      • Departure Date
      • Service Type
      • Supplier Code
      • Trip Code
  • Sales Code
    • Enter the Sales Code to be reported on (optional).
  • Trip
    • Enter a Trip to report on a specific file. Double click this field to make a selection from the Search dialogue box.
  • Consultant
    • Enter a consultant ID to report on a specific consultant.
  • Creditor
    • Enter a Creditor code, or double click this field to make a selection from the Search dialogue box.
  • Service Type
    • This field is only available when Supplier Code has been selected in the Report By field. Select the service required from the drop down list. This field defaults to ALL service types.
  • Supplier Code
    • This field is only available when Service Type has been selected. Enter a Supplier Code range or double click this field to make a selection from the Search Dialogue box. To report on one Supplier only, enter the same code in both fields.
  • Departure Date From/to
    • Enter the date range required.
  • Tranx Date From/to
    • Enter the date range required. The default From date is the first of the current month and the To date will default to today’s date.
  • Destination
    • Enter the IATA city code or double click this field to make a selection.

Click the Retrieve button to display the report data. Click Print, Preview or Save As buttons if required.

Notes:

Commission is NOT included in this report. The total column includes taxes and Non Commissionable fees.

The Canx Fee figure includes Supplier and Agent fees.

 

Purchase Reports

This report provides a way to analyse the agency’s product usage through a variety of filters.

Select Purchase Reports from the sub menu to produce this report.

Complete the following fields:

  • Purchase Report By
    • Select the way the report is compiled and displayed from the following categories:
      • Consultant (default)
      • Creditor
      • Departure Date
      • Sales Code
      • Service Type
      • Supplier Code
  • Supplier Code/to
    • Enter a Supplier code range, or double click this field to make a selection from the Search dialogue box. To report on one Supplier only, enter the same code in both fields.
  • Departure Date/to
    • Enter the date range required. If this field is left blank, all past and future departure dates are included.
  • Tranx Date/to
    • Enter the date range required. If this field is left blank all past transactions are included.
  • Service Type
    • Select the service type required from the drop down list. This field defaults to show ALL service types.
  • Consultant
    • Enter a consultant ID to report on a specific consultant.
  • Creditor
    • Enter a Creditor code, or double click this field, to make a selection from the Search dialogue box.

mceclip5.png

Click the Retrieve button to display the report data. Click Print, Preview or Save As if required. The total column includes Non Commissionable fees.

 

Agency Sales Reports

This report provides a listing of sales itemised by Sales Code and by Service Type. It is the only report that has the option to view Grand Totals Only. There is also the option in this report to view branch-specific totals in multi-branch offices.

Select Agency Sales Reports from the Sales sub menu.

mceclip6.png

Complete the following fields:

  • Report Type
    • Choose Detailed, Summary or Grand Total Only
  • Sort Report By
    • Select the way the report is compiled and displayed from the following categories:
      • Supplier
      • Tranx Consultant (default)
      • Creditor
      • Trip Consultant
      • Client
      • Debtor
  • Service Type
    • This field is only available when Supplier has been selected in the Sort Report By field. Select the service type required from the drop down list. This field defaults to show All service types.
  • Consultant
    • This field is only available after Tranx or Trip Consultant has been selected in the Sort Report By field.Enter a Consultant ID to report on a specific consultant.
  • Creditor
    • This field is only available when Creditor has been selected in the Sort Report By field. Enter a Creditor Code, or double click this field to make a selection from the Search Dialogue box.
  • Supplier
    • This field is only available when Supplier has been selected in the Sort Report By field and a Service Type has been entered. Enter a Supplier Code range, or double click this field to make a selection from the Search Dialogue box.
  • Tranx Date From/to
    • Enter the date range required. If this field is left blank all past transactions are included.
  • Debtor from/to
    • This field is only available when Debtor has been selected in the Sort Report By field. Enter a Debtor Code, or double click this field to make a selection from the Search Dialogue box.
  • Client from/to
    • This field is only available when Creditor has been selected in the Sort Report By field. Enter a Client Code, or double click this field to make a selection from the Search dialogue box.
  • Departure Date from/to
    • Enter the date range required. If this field is left blank, all past and future departure dates are included.
  • Tranx Agency
    • Select the Agency where transactions were carried out.
  • Trip Agency
    • Select the Agency the Trip files where created in.

Click the Retrieve button to display the report data. Click Print, Preview or Save As if required.

Note:  Branch Totals button is only accessible if Multi Branching is set up for the agency.

mceclip7.png

Notes:

The Percentage Profit figures are calculated excluding credit card expenses.

Agency Cancellation Fees are included in the Net Commission.

This report does not include:

  • Trip Adjustments to the following accounts:
    • Commission Adjustment
    • Discount Expenses
    • Agent Cancellation fees
    • Sales
  • Adjustments or other transactions involving the above accounts and any other module.

 

Override Reports

This report will give a list of override amounts entered on ticket or cheque requisitions.

The Override report will list all override amounts entered on ticket and cheque requisitions. Depending on your selection it can be run by all suppliers or by an individual supplier. This report will give an estimated amount owed to the agency in Overrides.

The report data is displayed by:

Departure Date, Date Issued, Supplier, Ticket number, Sales Code, Fare, Commission amount, Override Amount.

mceclip8.png

 

Commission Received Reports

This report will show Commission Receipts, either Open Item or Other.

mceclip9.png

Related articles