TABS - PROVEN COMPUTER SOFTWARE >> AVIATION SYSTEM

Product Overview

TABS Computer Systems was first involved in developing software for the Aviation Industry in 1981. In subsequent years, we have built a solid and reliable General Aviation package.

The system will:

	Control the issue, sale and eventual use of all Tickets/Connotes/Excess Baggage Vouchers and MCO's
	Record details (operational and financial) for every flight undertaken
	Facilitate the prompt follow-up and invoicing where other airline tickets are used/exchanged
	Provide both summary and detailed reporting on all aspect of the aviation operation
	Utilise bar-code scanning technology to ensure document processing is efficient and accurate
	Provide on-line/direct links to other TABS accounting and Aviation modules (single input entry)

Application Features

TABS Aviation software library covers the following:

INTEGRATION

TABS AVIATION SYSTEM - INTEGRATION - Software Features TABS General Ledger TABS Debtors Ledger (sales office/inter-airline invoicing) TABS Creditors Ledger (other airline invoices) TABS Cashbook (cash refunds) TABS Pilot Records (flight time variations) TABS Aircraft Maintenance (flight time variations)

DOCUMENT TYPES CONTROLLED

TABS AVIATION SYSTEM - DOCUMENT TYPES CONTROLLED - Software Features Tickets Connotes MCO's Excess Baggage Vouchers Agent Sales Returns Flight Records

SALES PROCESSES

TABS AVIATION SYSTEM - SALES PROCESSES - Software Features Ticket Documents are Issued to Agents (physically and on the computer system). Agents Sell Tickets to customers (cash/account) and complete a SALES RETURNS. Money is Banked by Agents and SALES RETURNS are sent to Airlink Admin. Airlink Admin. Staff enter SALES RETURNS to invoice customers. Ticket sales information is recorded on the computer system.

UPLIFT PROCESSES

TABS AVIATION SYSTEM - UPLIFT PROCESSES - Software Features Airlink Flight scheduled. Tickets/Connotes (flight coupons) are taken from the customers (both Airlink and Inter-Airline). Flight documentation is completed, and sent to Airlink Admin. with all of the flight coupons. Airlink Admin staff enter each Flight Record together with each flight coupon. Ticket usage information is updated.

INVOICING STREAMS

TABS AVIATION SYSTEM - INVOICING STREAMS - Software Features Airlink Tickets/Connotes - entered on a SALES RETURN   Net Cash Sales (Agent banking)   Accounts Sales (Invoice) Inter-Airline Tickets - used for Exchange (SALES RETURN) Inter-Airline Flight Coupons used on Airlink Flights (FLIGHT RECORD)

SALES RETURNS

This document is used to record all sales made of Airlink Tickets, through Airlink Sales Offices.

TABS AVIATION SYSTEM - SALES RETURNS- Software Features Each Sales Return is allocated a unique number. SALES - (Cash or Account) - Airlink Tickets REFUNDS - (Cash Only) - Airlink Tickets TICKET EXCHANGE - Inter Airline Tickets exchanged for an Airlink Ticket. AGENTS EXPENSES - used to record sales office expenses. SUMMARY - Cash Banking, Accounts Invoicing, Commissions, Expenses, Unders/Overs. An invoice is raised for every account sale. The invoice number will be the ticket number. A single invoice is raised for the net amount owing by the Agent (Cash Sales, less Refunds, less Expenses). Inter Airline flight Coupons used in exchange for Airlink tickets are recorded for Inter-Airline Invoicing. All money collect is held in trust on the balance sheet until the Ticket flight coupon is used or the Inter-airline ticket is invoiced back to the other airline. No VAT is payable at this stage. Airlink Tickets will be marked as being "SOLD". Both Domestic and International Sales may be made through this process. Domestic Sales are recorded in local currency in accordance with the current fare structure. International Sales may be recorded in either NUC (which are converted to local currency using a daily exchange rate) or local currency. Barcode scanning (of Airlink sales audit coupons and inter-airline flight coupons used in exchange) will streamline the entry procedure.

TRIP ENTRY

A Flight Record is created for each Airlink flight. Flights may be RPT, charter, or non-revenue flights (is training, engineering, etc)

TABS AVIATION SYSTEM - TRIP ENTRY - Software Features Each Flight Record is assigned a unique document number (JLM reference). The Date, Aircraft, Pilot and Co-Pilot details are recorded and entered. Actual Flight Sectors are recorded together with the Sector times (in minutes). Flight Coupons (Tickets/Connotes) are entered. Mail carried on the Flight is entered (if applicable). Flight Summary is presented.

Following the input of the Flight Record the following updating will occur:

TABS AVIATION SYSTEM - TRIP ENTRY - Software Features Revenue for the flight is acknowledged Airlink Flight Coupons are marked as "USED" Inter-Airline flight coupons are recorded (for future invoicing) Statistical information is recorded for the flight VAT collected on the flight coupons becomes payable

Barcode scanning of flight coupons (both Airlink and Inter-Airline) will streamline the entry procedure.

INTER-AIRLINE INVOICING

TABS AVIATION SYSTEM - INTER-AIRLINE INVOICING - Software Features This procedure will collate all inter-airline flight coupons for invoicing. This flight coupons are collected either:   Sales Return - used in exchange for an Airlink Ticket   Flight Uplift - used on an Airlink Flight On a weekly basis, all of the above flight coupons are collated for each airline concerned. The computer system records are checked for accuracy and completeness. An invoice is then produced automatically, listing all Inter-Airline flight coupons. A commission is deducted to arrive at a final invoice total. The money recorded on each inter-airline flight coupon entered through the Sales Return and Flight Uplift processes will be posed to an Inter-Airline Ticket Clearing account in the GL. The inter-airline invoicing process will clear this account. A debtors enquiry into any inter-airline account will display the value of un-invoiced flight coupons.

OTHER-AIRLINE INVOICING

This is the reverse process to the Inter-Airline invoicing (identified earlier).

TABS AVIATION SYSTEM - OTHER-AIRLINE INVOICING - Software Features Where Airlink flight coupons (sold by an Airlink Sales Office) are used on another airline (carrier), an invoice is prepared by the other airline for Airlink to reimburse them for the travel. Airlink Flight Coupons are entered to ensure their claim is correct. The system will check to ensure the flight coupon has not be used or refunded previously. Commissions are calculated and deducted from the total of all flight coupons to reconcile with the invoice total. This total is posted to the Airline's creditors account. Airlink flight coupons will be marked as being "USED".

CASH/CHARGE REFUND ENTRY

TABS AVIATION SYSTEM - CASH/CHARGE REFUND ENTRY - Software Features The entry process will enable one or more flight coupons to be refunded. Refunds will update the flight coupon and facilitate the payment/credit to the customer. "No show" penalties may be applied thereby reducing the amount refunded. Airlink flight coupons will be marked as "REFUNDED" through this process.

Standard Reporting Available

TICKET STATUS REPORT

One of the main controlling report for the Aviation system is the Ticket Status Report.

This report will identify the current status of every ticket. Computer tracking of the ticket will commence when it is issued to the Sales Office, and finishes when the total sales value agrees with the total of all flight coupons. Airlink Ticket sales can only occur through an Airlink Sales Office via a Sales Return.

The flight coupons attached to each ticket may be used in the following ways:

An Airlink Flight (Trip Entry)

Another Airline Flight (Other Airline Invoicing)

Refunded (Sales Return, Cash/Charge Refund Entry)

The current status of each ticket may be classified as follows:

Tickets un-issued by Agents

Tickets Sold and Used (fully accounted for)

Tickets Sold but not Used

Tickets Not on a Sales Return

Tickets Partly Used (multi-sector tickets)

Tickets Used for Excess Value

Regular audits of Sales Agents should be conducted to ensure:

Airlink Ticket Sales procedures are followed

Issued ticket stocks are correct and accountable (ie those issued to the agent but not yet sold)

Sales Return documents are completed correctly, money is banked and all sales documents are returned to Madang on a regular basis (ie daily if possible)

OPERATIONAL REPORTS

Ticket Status Report	Daily Flight Report
Inter-Airline Ticket Report	RPT Statistical Summary

MANAGEMENT REPORTS

Monthly Flight Summary	RPT/Aircraft Profitability
JLM Comparison Report	Uplift Sales Analysis Report
Flight Time Variations	Fare Analysis Report
Flight Analysis Report	Agent Analysis Report
Flight Summary Report

General Ledger I Debtors Ledger I Creditors Ledger I Cashbook I Payroll/Personnel
Stock Control/POS I Aviation I Time & Material/Job I Asset Management