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, agenices 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 Agecnies, period List of refunds
Batch invoice Agencies, date type (first service date, service date, inovice 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
Unbalanced PNRs Unbalanced types, period Different types of unbalanced PNRs which gives you a list of bookings which are unbalanced from various reasons
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 gouping 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 abilty 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 unbalnaced 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, 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 Agenices, 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 revnue 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 prinout 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, revenu per hour (a calculation of if the flight flown for one hour, what was the revenue for it), revenue per PAX
Deposit statement Agenices, 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) Agenices, check-in status, flight number, income code, service status, period type selection, routing, 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 A 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



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