Supplier Turnover Report

The Supplier Turnover report provides detailed information on the following financial documents issued to suppliers: vouchers, refunds, and STK. The report also presents information on payment requisitions issued to suppliers who work on a cash basis (the payment requisition acts like a voucher). Each row in the report represents a single financial document that was issued to a supplier. The report does not include cancelled documents.

The Supplier Turnover report has two modes: Summary Mode and Print Mode.

Purpose

The purpose of this report is as follows:

To display the supplier's sales turnover
To display detailed information on vouchers, such as commission, airport tax, and the supplier's turnover
To display the supplier's sales turnover, including ATC vouchers
To display detailed information on the vouchers in the supplier currency

Output

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 Supplier Turnover (Summary Mode) report has the following parameters which are shown on the left and enable you to filter the report output:

Parameter	Description
Display Currency	Choose between document, system and travel file currency.
Branch	Choose the branch of the travel agency where this document was issued.
Issue Date	Choose the date range in which the document was issued.
Value Date	Choose the date range of the document due date.
Supplier Paid	Choose the supplier paid.
Res. Supp.	Choose the reserving supplier.
Prov. Supp.	Choose the supplier providing the service.
T. File User	Choose the travel file user.
Issuing User	Choose the user issuing the invoice.
Service Type	Choose the service type.
Supp. Inv. Issue Date	Choose the date range in which the supplier invoice was issued.
Supp. Inv. Value Date	Choose the date range of the invoice due date.
Payment Date	Choose the date range of the actual payment.
Status (Paid/UnPaid)	Choose between paid and unpaid invoices.
Price Level	Choose the price level.

The Supplier Turnover (Print Mode) report has the following parameters which are shown on the left and enable you to filter the report output:

Parameter	Description
Display Currency	Choose between document, system and travel file currency.
Branch	Choose the branch of the travel agency where this document was issued.
Issue Date	Choose the date range in which the document was issued.
Value Date	Choose the date range of the document due date.
Supplier Paid	Choose the supplier paid.
T. File User	Choose the travel file user.
Issuing User	Choose the user issuing the invoice.
Service Type	Choose the service type.
Supp. Inv. Issue Date	Choose the date range in which the supplier invoice was issued.
Supp. Inv. Value Date	Choose the date range of the invoice due date.
Payment Date	Choose the date range of the actual payment.
Price Level	Choose the price level.

Example

The generated Supplier Turnover (Summary Mode) report displays information on the following financial documents issued to suppliers: vouchers, refunds, and STK.

The report also presents information on payment requisitions issued to suppliers who work on a cash basis (the payment requisition acts like a voucher). Each row in the report represents a single financial document that was issued to a supplier.

The following fields are displayed in the generated report:

Parameter	Description
Group By	This field shows the grouping of the document.
Currency	This field shows the currency chosen in the filter.
Amount	This field shows the total supplier turnover amount.
Amount	This field shows the net amount of the invoice.
Comm. w/o Vat	This field shows the commission amount received from the supplier, before VAT.
Vat on Comm.	This field shows the VAT amount on the commission received from the supplier.
Comm. (%)	This field shows the commission percentage (commission divided by (supplier price + amount paid by customer directly to supplier).
Mark Up	This field shows the mark up amount on the supplier price, including VAT.
Mark Up w/o Vat	This field shows the mark up amount on the supplier price, before VAT.
Mark Up Vat	This field shows the VAT amount on the mark up on the supplier price.
Tax	This field shows the tax amount on the invoice.
Credit Supp.	This field shows the amount paid by the customer directly to the supplier.
Total to Supp.	This field shows the total amount to be paid to the supplier, including the amount paid by the customer directly to the supplier (supplier price + tax + amount paid by customer directly to supplier)
Selling Price	This field shows the selling price.
Total Incl. Cred Supp. (No Tax)	This field shows the total amount paid to the supplier including the amount paid by the customer directly to the supplier.
Total Sys. Curr.	This field shows the total amount to be paid to the supplier, in system currency.

The generated Supplier Turnover (Print Mode) report displays detailed information on the following financial documents issued to suppliers: vouchers, refunds, and STK.

The following fields are displayed in the generated report:

Field	Description
Group By	This field shows the grouping of the document.
Currency	This field shows the currency chosen in the filter.
Supplier Paid	This field shows the supplier paid.
Service Type	This field shows the service type (for example, hotel).
Branch	This field shows the branch of the travel agency where this document was issued.
Issuing User	This field shows the issuer issuing this document.
T. File No.	This field shows the travel file number.
Issue Date	This field shows the date when the supplier invoice was issued.
Value Date	This field shows the due date of the supplier invoice.
Payment Date	This field shows the payment date of the supplier invoice.
Type	This field shows the type of payment (for example VCH for voucher or PRQ for payment requisition).
Doc No.	This field shows the document number.
Amount	This field shows the net amount of the invoice.
Comm. w/o Vat	This field shows the commission amount received from the supplier, before VAT.
Comm. (%)	This field shows the commission percentage (commission divided by (supplier price + amount paid by customer directly to supplier).
Mark Up	This field shows the mark up amount on the supplier price, including VAT.
Tax	This field shows the tax amount on the invoice.
Credit Supp.	This field shows the amount paid by the customer directly to the supplier.
Total to Supp.	This field shows the total amount to be paid to the supplier, including the amount paid by the customer directly to the supplier (supplier price + tax + amount paid by customer directly to supplier)
Selling Price	This field shows the selling price.
Total	This field shows the total amount paid to the supplier including the amount paid by the customer directly to the supplier (Cred. Supp), but without tax.