From the menu bar, select Reports and Creditors, then select from the sub menu attached.
Select the report required.
Cheque Reports
Displays a list of Cheque and/or Ticket requisitions that have been paid to Creditors, or a list of Cheque and Ticket requisitions awaiting payment.
BSP Report
Provides a listing of BSP transactions, including ticket issues, net remit transactions, refunds, ACMs and ADMs for a requested BSP Billing period.
Trial Balance Reports
Provides a financial balance report for your Creditor accounts. Choosing an Aged Trial Balance shows how long amounts have been outstanding, whereas a Trial Balance simply provides a list of account balances.
When any Creditor has a zero balance the option to suppress or display these Creditors is available.
When the user checks “Suppress Zeros” checkbox, the Creditor or Debtor with a zero balance transaction is not displayed.
Sales Return Report
Produces a Sales Return for the specified Creditor showing gross value, commission taken, and the nett payable to the Creditor.
This report would be used for insurance policy sales, coach tickets etc. The system will automatically generate 2 copies of the report, one to accompany payment to the Creditor, the other being an office copy.
GST Return
Provides a listing of all sales and the amount of GST collected and is used for the remittance of GST to the government taxation office.
NZ GST Report
Currently to run the NZ GST report the user inputs a ”From Date‘ and a ”To Date‘. If both the entered dates are before 1 Oct 2010 the report will run as usual.
If either of the dates entered is later than 1 Oct 2010 then a message will appear ”The GST Report in CCTE is currently not available. The report will be redesigned when it is released by NZ Revenue department‘.
Cheque Reports
- From the sub menu, select Cheque Reports.
- Select the report type required from the drop down menu:
- ChequePaid
Report on Cheque/Ticket requisitions paid to Creditors. - Cheques to Pay
Report on Cheque/Ticket requisitions awaiting payment to Creditors.
- ChequePaid
- The following fields are optional and may be completed to obtain specific information. However, if left blank all data will be retrieved.
- Cheque from/to
Complete these fields to report on a specific range of used Cheque numbers. - Transaction date from/to
Enter a date range to report only on transactions within the specified period. - Consultant
Input a code to obtain a report on a specific consultant. - Ticket Type
Select the Ticket/Cheque requisition type required from the drop down list. - Creditor
Enter the Creditor's code to obtain a report for a specific Creditor. - Trip Code
Input a code to obtain a report for a specific Trip file. Double click in this field to choose from a list of files.
- Cheque from/to
- Click on Retrieve button to display the report. If required, select the Print button to print the report.
BSP Report
This report provides a listing of your office BSP transactions including ticket issues, net remit tickets, refunds, ACM's, and ADM's for the selected billing period. See "BSP Processing" in Module 5: Creditor File.
Producing a BSP Report
- From the sub-menu, select BSP Report.
- From the drop down selection list, choose the BSP Billing Period for which the report is required (mandatory). Choose either:
- Full Report
Includes both standard BSP ticket issues plus nett remit transactions. - BSP Return
Includes only standard BSP ticket issues, refunds, etc. - BSP Net Remit Supplement
Includes only nett remit ticket transactions.
- Full Report
- Click the Retrieve button to display the report data. Click the Print button if required
- Once the report has been produced, check it against the audit coupons of tickets. Make any adjustments required through the respective Trip files. Once the BSP report is correct, go to the Approval screen and approve the appropriate tickets for payment. Proceed to the payment screen and complete the transaction
Trial Balance Report
This report produces a financial balance report for your Creditor accounts. Choose an Aged Trial Balance or a Trial Balance.
From the sub-menu, select Trial Balance Reports.
How to Produce a Trial Balance Report
- Complete the following fields as required:
- CreditorId
Use F12 to select a Creditor Id code if a report on a specific Creditor is required, or leave the field blank to report on all Creditors. - Report Type
The Report Type field provides a drop down list box. Select the type of Trip report required. - Aged Trial Balance (Default)
Provides a report for each Creditor showing outstanding debts and how long the amounts have been outstanding. - Trial Balance
Provides a single report showing all Creditors and their debit or credit account balance. - Date To
Tailor the Trial Balance report by completing the Date To field.
- CreditorId
- Click the Retrieve button to display the report data. Once displayed, select Save As or Print button as required
Sales Return Report
This report produces a Sales Return for the specified Creditor, showing gross value, commission and the nett payable to the creditor. It would be used for insurance policy sales, coach tickets, etc. A copy should accompany payment to the Creditor. This is the only menu bar report which lists the passenger names in relation to sales.
In addition, the Sales Return Report screen also produces a Commission Invoice by selection from the Report Type field. The Commission Invoice is used for GST purposes, to claim commission from Creditors.
How to produce a Sales Return Report
From the sub-menu, select Sales Return Report.
- Complete the following fields as required:
- Report Type
Select from:
Sales Return
Commission Invoice
Commission Invoice Summary - Creditor
Input a code to report on a specific Creditor, or leave the field blank to report on all Creditors. - Accounting Period
Select a specific accounting period, if applicable. - Billing Period
Double click this field to display a drop down list, and select the required period. - Service Type
Select the service type required. - Supplier
If required, select the Supplier code. - Paid/Unpaid/Both
Select the status of the items to be included. - Payment Id
When Paid has been selected, the Payment ID field becomes available. Select Payment Id from the drop down list to display details of that payment. - Transaction Date
If applicable, input the sales period dates to be included in the report. - Transaction ID
If applicable, input a transaction ID range to be included in the report. - Ticket date
If applicable, enter a ticketed date range.
- Report Type
- Select the Retrieve button to display the report. Select Print to print the report. The system automatically generates 2 copies.
Sales Returns – Commission Invoice
After the Sales Return report has been produced, check the report against the audit coupons of the tickets.
Make any adjustments through the respective Trip files. When the Sales Return report is correct, display the Approval screen and approve the appropriate tickets for payment.
Proceed to the payment screen, input the Cheque number and complete the transaction.
Commission Invoice
The Commission Invoice allows the production of a Commission Tax Invoice by either Creditor or Supplier. An invoice can also be produced for any specified period or for a particular transaction.
Change the report type to Commission Invoice Summary and complete any other fields required.
GST Return Report
The GST Reports give all the data required to transfer to your BAS return. See "Australian GST" in Module 1: Getting Started.
How to produce a GST Return report
- From the sub-menu, select GST Return.
- Complete the following fields as required:
- Report Type
Select from:
Total Turnover
Commission Basis-Suppliers
Commission Basis-Acquisitions - Transaction Date
Enter a transaction date range. - Select a Detailed or Summary report type.
- Bank Account
Choose the bank account on which the report is to be based from the drop down list. If no account is selected, all will be accessed for this report.
- Report Type