Reports database

Reports database

The following is AeroCRS reports database with filter options, description of the output of the report:

Report name Filter options Output
Booking Analysis Service status, flight status, ticketed bookings, period Pivot table of flight numbers vs flight dates
Sales User, period List of bookings with PAX QTY and amount
Deferred Single date A list of invoices which their first service date is after the selected date
Invoices Accounting code, agencies and customers, period List of invoices
Credit Memos Agencies, direct clients, period List of all credit memos
Receipts Receipt type, period List of receipts
Refunds Agencies, period List of refunds
Batch invoice Agencies, date type (first service date, service date, invoice date), Invoice type, period Batch printout of invoices for the selected period and filter settings
Agents turnover Sorting option and date type by service date or invoice dates, period Total QTY of passengers, total amount per agency
Agents statement Agencies, Date types (invoice issue, service dates, dates of bookings), period List of invoices or credit memos for the given period with total paid for booking
Cashier Users, station, period List of receipts per the selected period, in the printout version, an extra table is added with the total with breakdown of currency
Invoices and Receipts Period List of invoices and their related receipts
Open Services - by selling date Type, supplier, status, period List of open services by the selling date
Discounts Period A list of given discounts and their PNR ref
Open Services - by service date Type, supplier, status, period List of open services by the service date
Products Period List of products sold with their booking reference and service data and fares
Products - by selling date Period List of products sold with their booking reference and service data and fares
Products including pax names Period List of products sold with their booking reference and service data and fares and passenger names
WorkSheet Product type selection, name of product, period List of products booked with fare data, services names, agencies, service date etc.
Routes summary Ticketed status, detailed report, agencies and customers, period type, income code, break down by class, detailed pricing, break down by agency List of routes with QTY of PAX and fare information with the option to break down by class or agency to show a detailed grouping of the data
Services Ticket status, service active, date period type (service, created or modified), agencies, service type, service status, period List of services with fare data
Batch Invoice by number Agencies, number of invoices Batch printout of invoices from-to the list of numbered invoices
Routes breakdown Ticketed status, detailed report, agencies and customers List of routes with QTY of PAX broken down to pax type (single booking, return bookings and multi service bookings)
Sales per day (detailed report) User, agency, period List of bookings with pax qty, pax name, and fare information
TTL PNRs Period List of bookings which is about to breach TTL
Cashier Daily Users, station, the ability to add a note, selected date List of receipts per the selected period, in the printout version, an extra table is added with the total with breakdown of currency, with a note area which is kept in the system DB
Deferred Single date A list of invoices which their first service date is after the selected date
Unbalanced Services No filters List of bookings which have unbalanced services in them, an unbalanced service is a service which was booked and then re-booked on another entity, normal operations should not have this type of result.
Deferred for period Period A list of invoices which were issued in the selected period but their first service date is out of the selected period.
Daily flights information Single date A list of bookings with all the passengers listed and paid amounts with routes for a selected date
Agents booking types Period QTY of bookings according to a given date period with a breakdown of CRS and WEB booking per agency
Charters PNR status, Charter status,  period List of all charters with routes, PAX QTY, A/C and fare
Charter aircraft analysis PNR status, period Summary of charters grouped by a selected filter, A/C type, customer etc.
Charter payments Payment type, payment supplier, status, country, period List of all charter expenses recorded on the charter system
Passengers information Agencies, check-in status, flight number, income code, service status, period type selection, routing, period List of passengers with full service information and fare data
Passengers check-in report Status, period List of passengers with their check-in information
Hotels bookings Hotels, Period List of bookings with hotels in them, service dates and room type
Crew hours Crew member, period Summary or a detailed report of each crew member hours on a given A/C type
Advanced Daily Sales Flight date and PNR date (date type) List of bookings with user data, first passengers, total sales, TAX and VAT
Flight Checked-in Revenue Period List of flights, seats QTY and checked in revenue total and No-show revenue total
Frequent Flyer movements FF number, period List of movements of a FF record (in and out)
Meet and Greet for products Product type selection, name of product, period Batch printout of handout signs for meet and greet for products sold with their respective agency name and logo.
Batch booking Template selection, single date Batch printout of bookings for a selected date according to the date selected
Routes summary by day of the week Ticketed status, agencies, summary type (revenue / pax) List of routes with QTY of PAX OR revenue per day of the week
Hotel nights Period List of hotel bookings and number of nights booked within this period
Manifest Flight number, manifest template, routing, period Batch printout of manifests for a given flight number for a period with the ability to filter specific routing
Cancellations Date type according to cancellation date / service date, period List of services cancelled with all cancelled service pricing information
Class break down per route Ticketed bookings, breakdown per day,summary type, period Summary of routes with class sale breakdown
Single/Return breakdown per route Ticket status, period List of routes with single / return indication
Top agents per route Ticket status, period List of routes and 20 top agents per route according to booked QTY
Load factor and revenue per flight Ticketed bookings, Data type, income codes, agencies and customers, period List of flights with their load factors, fares, tax, revenue per hour (a calculation of if the flight flown for one hour, what was the revenue for it), revenue per PAX
Deposit statement Agencies, Customers, period A list of deposit transactions in/out with total
Pay at check-in Period List of bookings still open in "Pay at checkin"
Passengers report for agency Agency, Date type, period List of passengers with flight details for specific agency
Flight passenger information (Simple) Flight number, income code, period List of passengers, with routing data and flight numbers
Passengers information report (short) Period List of passengers with full service information
Agents detailed pricing breakdown Agencies, ticketed bookings and flight / PNR date period List services and their commissions with the QTY of passengers
Nationality breakdown Period List of nations and the QTY of passengers from them
Developments None Report will show a list of all issues / development requests made by the company (from all users) and their status at AeroCRS development department
Accounting transactions Dates‚ agencies‚ report date type‚ by PNR or by Record date Balance of all invoices and receipts and deposits‚ sorted according to the selected date type‚ this report will help you balance the bookings.
Currency exchange log Dates Exchange currency changes with user and date stamp
Deferred by service Period List of PNR's that contain services from different months within the period.
Invoice Aging agencies‚ branch and non paid invoice The amount of all invoices by periods‚ per agency/user
Vouchers Agent‚ voucher sum‚ PNR status Prints out a list of vouchers along with their PNR's‚ with agent and voucher details
Routes summary by date Ticketed status‚ agencies‚ summary type (revenue / pax) List of routes with QTY of PAX OR revenue per date
Invoices items The list of invoice items (breakdown of the invoices) List of invoice items
SMS report Flight number, FF number, PNR, status Tracking of SMS sent from the system
SSR report Flight number, SSR  Tracking of SSR by flight
Bookings Transfer Flight number, user List of all the transfer bookings made
Actual flight timings Period List of flights with their Actual Flight Data (ETD, ETA, Delays, etc) and crew information
Agencies deposit balance by currencies As date Current deposit balance for all agencies and currencies
Ancillaries Data   All the ancillaries which are active in the system with their sub-items
Booking List Agent, flight number Will show the list of passengers according to reflected criteria
Booking Transfer Flight number, user List of all booking transfers made
Cargo Agent, route, cargo type, user List of all the cargo booked
Class allocations GDS status List of classes per flight and their allocations
Class availability GDS status List of classes per flight and their availability cache
Class booking analysis Class groups List of classes per flight and their booked numbers
Class Yield Class code, flight number, yield value, route List of flights according which is have less free seats than the yield value
Complete route analysis Period Complete route analysis per booking. will group together similar complete routes within bookings
Connecting PNR Date List of all connecting INVs in the same PNR
Daily flight report For date Information about flights on specific day
E-tickets Report Flight number, status List of E-tickets (GDS) and passengers
Fare Simulation per date As date Fares report according to date of selling
Flight data Status Prints out information about flights‚ service load‚ routing and segments
Flight routing Period Prints out information about flights routing
Load factor and revenue per flight number Data by, income code, agent List of flights with their load factors‚ fares‚ tax‚ revenue per hour (a calculation of if the flight flown for one hour‚ what was the revenue for it)‚ revenue per PAX
Log by day User, screen Summary of the log records for all actions made on the selected day
Passenger Check-in report Status List of passengers with their check-in information
Passengers fare info Agent, status, flight number, incomer code, customer ID, ticket status, route, user, branch List of passengers in bookings with their services information
Routing Load Report As date Shows the loads of the flights according to allocated airplanes in manifest editing options
Tax Headcount Interval, period Headcount list according to routes



NOTE: You might not have permissions to see the report for user login, please ask your administrator if you encounter a need for a report.
Have more questions? Submit a request

Comments

Powered by Zendesk