Aviation / Flight Control / Maintenance
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 TABS Aviation system will provide management with extensive revenue, profit and statistical reporting on all aspects of the airline operation. All accountable documents are tightly controlled enabling current status reports to be generated at any time. 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 barcode scanning technology to ensure document processing is efficient and accurate
- Provide online/direct links to other TABS accounting and Aviation modules (single input entry)
TABS Aviation software library covers the following:
- 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
- Excess Baggage Vouchers.
- Agent Sales Returns.
- Flight Records.
- 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.
- 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.
- 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).
- This document is used to record all sales made of Airlink Tickets, through Airlink Sales Offices.
- 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.
- A Flight Record is created for each Airlink flight. Flights may be RPT, charter, or non-revenue flights (is training, engineering, etc).
- 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:
- 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.
- 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.
- This is the reverse process to the Inter-Airline invoicing (identified earlier).
- 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
- 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 (i.e. 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 (i.e. daily if possible).
- Ticket Status Report.
- Daily Flight Report.
- Inter-Airline Ticket Report.
- RPT Statistical Summary.
- 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.