The Summary Sales Period report is a summary of all documents issued within a single sales period by cash, credit, refund, and adjustment totals, for the agent making the request. Adjustment totals are only shown in specific markets.
The system will give you a report from the current sales period, in the default currency defined in your office profile. This report is not an accounting tool, but may provide useful figures and totals for office accounting purposes and sales returns to ticketing authorities such as BSP and ARC.
In the Summary Sales Period report all non-canceled sales and refunds are summarized in three sections: the cash, credit, and the total section. The split between credit and cash payment types shows the relative proportions for the sales period.
Section Four of the report reflects all sales, refunds, and balance amounts by individual form-of-payment type. Section Five shows the document volume. It lists the number of documents issued, canceled, and sold, and the total document amounts sold by document type.
Note (US only): If you enter the value of the document that you take in exchange when you reissue a document, and it results in a refund, then although the transaction has a sale type transaction code, it is processed as a refund type and accumulated under the appropriate cash or credit refund section of the report.
1. In the Sales Reports tab in the Ticket and Documents module, select Summary Sales Period Report (TJS) from the drop-down list.
2. Fill in the search criteria and click on Display Report.
Refer to Working with Sales Reports on page 45 if you need more information on the search criteria.
Report Explanation
Table: Explanation of the Summary Report
Item Explanation
PAYMENTS X
DOCUM The form-of-payment type per document column.
SALES The sales amount column.
REFUNDS The refund amount column.
BALANCE The balance amounts column. The balance amounts equal the sales minus the refund amounts.
FARE
AMOUNT Reflects the published fare total of all sales and refunds during the sales period. In the first section of the report this is reflected for cash payment (CA) and in the second section for credit payment (CC). In
Item Explanation
TAX AMOUNT Reflects the accumulated total tax value of each document and transaction type during the sales period.
In the first section of the report this is reflected for cash payment (CA) and in the second section for credit payment (CC). In the third section the cash and credit payment amounts are accumulated (TOT).
If a document is paid for in cash and credit, the total tax value is shown in the cash section of the report.
DOC AMOUNT Document amount.
Equals the sum of the fare amount and tax amount row for each column (sales, refunds, and balance) of the report.
In the first section of the report this is reflected for cash payment (CA) and in the second section for credit payment (CC). In the third section the cash and credit payment amounts are accumulated (TOT).
COMM
AMOUNT Commission amount.
The sum of the fixed commission amounts and the commission amounts calculated by the commission rate.
In the first section of the report this is reflected for cash payment (CA) and in the second section for credit payment (CC). In the third section the cash and credit payment amounts are accumulated (TOT).
For net remit documents, when the amount entered by the agent is greater than zero, the commission amount is the difference between the selling level and the net level plus the commission level (net remit methods 2A/E).
REMIT
AMOUNT Remittance amount.
The approximate amount the agency may expect to appear in a BSP agent billing analysis as the amount owed by the agent. The
remittance amount is the sum of the document amount plus the commission amount for each document/transaction type.
For net remit transactions (except for method 2A/E), any
supplementary commission due to the agent cannot be calculated.
The supplementary commission is usually calculated by the BSP.
For credit transactions only the commission amount is used in the calculation in accordance with BSP billing methods.
In the first section of the report the remittance amount is reflected for cash payment (CA) and in the second section for credit payment (CC). In the third section the cash and credit payment amounts are accumulated (TOT).
FORM OF
PAYMENTS The form of payment. This section reflects the total of all sales and refunds by form-of-payment type (CASH, NONREF, CCAX, CCVI, etc.). The sales minus the refunds equal the balance.
DOCUMENT
VOLUME The document type. The document volume section is only displayed if documents were issued or canceled.
ISSUED The number of all documents issued during the sales period listed by document type.
CANCELLED The number of all documents canceled during the sales period listed by document type.
SOLD The difference between the issued and canceled documents listed by document type.
AMT DOC SOLD
The total document amount (DOC AMOUNT TOT) of all sales and refunds listed by individual document type.
The Item Sales period report provides a list of all documents issued within a sales period with the cash and credit totals against each item. The report is split into two main sections: sales and refunds.
Note: In markets reporting to ARC, the system creates a weekly ARC report instead of the Item Sales Period report.
Displaying an Item Sales Period Report
1. In the Sales Reports tab in the Ticket and Documents module, select Item Sales Period Report (TJI) from the drop-down list.
2. Fill in the search criteria and click on Display Report.
Refer to Working with Sales Reports on page 45 if you need more information on the search criteria.
Report Explanation
Table: Explanation of the Item Sales Period Report
Item Explanation
DOCNUM Column displaying the 10-digit document number.
PAYMENT Column displaying the applicable form of payment (cash, check or credit card).
If it is a reissue, the document number taken in exchange is shown and the form of payment for any additional collection.
CREDIT The amount collected by credit card, including tax.
CASH The amount collected by cash or check, including tax.
TAX The tax amount collected for each item (both cash and credit).
COMM The commission amount for each item (both cash and credit).
SALES The sales section information.
This section is created from all items with a TKTA, TKTB, TKTT, TKTM, PTAM, MCOM, XSBM, MD10, and MD50 transaction type code. The items are listed by document number.
SALES TOTALS The total amounts of each column in the sales section.
REFUNDS The refunds section information.
This section is created from all items with a RFND and RENM transaction type code. The items are listed by document number.
REFUNDS
TOTALS The totals of each column in the refund section.
REPORT TOTALS
The report totals are calculated from the previous section's totals according to the formula: sales minus refunds.
NON ISSUED
DOCUMENTS This section is built from all items with transaction type codes CANX and VSCN. The items are listed by document number.
ALL REPORT TOTALS
If the All Offices option is used to display the TJI report, this section indicates the sum of all Item Sales Period report totals (report totals) for each individual office sharing the same agency IATA number.
Follow-up Actions
• Display the Transaction Details Report (TJT) Select a transaction line and click on See Details.
The Transaction Detail report appears in a pop-up window. See Transaction Report (TJT) on page 54 for details.
The cross-reference report is only available in markets that print (OP)ATB tickets, or in markets printing invoices and having the ticket invoice cross-referencing field (CRF) set to Yes in the Office profile.
The Cross-reference report cross-refers ticket numbers with stock control numbers and invoice numbers, and vice versa. The system only cross-refers ticket and invoice numbers if you combine the ticket print and the invoice print entries. It searches for tickets with transaction codes TKTB (ATB) and TKTT (electronic tickets).
By default, the system searches for data created by all agents in an office and for the current date.
Displaying a Cross-reference Report
1. In the Sales Reports tab in the Ticket and Documents module, select Cross-Reference Report (TJX) from the drop-down list.
2. Fill in the search criteria and click on Display Report.
Refer to Working with Sales Reports on page 45 if you need more information on the search criteria.
Report Explanation
Table: Explanation of the Cross Reference Report
Column Explanation
DOC NUM The 10-digit document number.
The invoice, PNR record locator and the amount columns are left blank in the case of a conjunction ticket.
The 'E' after the document number indicates an electronic ticket.
INVOICE The invoice number.
This column is left blank in the case of a conjunction ticket.
PNR REC LOC The PNR record locator. NOPNR is displayed for tickets issued in Temporary Ticketing Mode.
This column is left blank in the case of a conjunction ticket.