Reports database

Reports database

The following list is AeroCRS reports database with filtering options and description of the output for each report:

Report Name Filter Options Output
Accounting Transactions Filter by dates‚ agencies‚ report date type‚ by PNR or by the Record date Balance of all invoices, receipts and deposits‚ sorted according to the selected date type‚ this report will help you balance the bookings.
Actual Flight Timings Filter by period List of flights with their Actual Flight Data (ETD, ETA, Delays, etc) and crew information
Advanced Daily Sales Flight date and PNR date (date type) List of bookings with user data, first passengers, total sales, TAX, and VAT
AeroCRS Network Sales Filter by API, period List of sales made from API
Agencies Deposit Balance by Currencies Filter by a date List of current deposit balance for all agencies per currencies
Agents Booking Types Filter by period List of a number of bookings according to a given date period with a breakdown of CRS and WEB bookings per agency
Agents Detailed Pricing Breakdown Filter by agencies, ticketed bookings and flight / PNR date period List of services and their commissions with the number of passengers 
Agents Statement Filter by agencies, Date types (invoice issue, service dates, dates of bookings), period List of invoices or credit memos for the given period with a total amount paid for a booking 
Agents Turnover Filter by sorting option and date type by service date or invoice dates, period List of the total amount of passengers per agency 
Ancillaries Data   All the ancillaries which are active in the system with their sub-items 
Batch Booking Filter by template selection, a single date Batch printout of bookings for a selected date according to the date selected 
Batch Invoice Filter by agencies, date type (first service date, service date, invoice date), Invoice type, period Batch printout of invoices for the selected period and filter settings 
Booking Analysis Filter by service status, flight status, ticketed bookings, period Pivot table of flight numbers vs flight dates 
Booking Certificates Filter by agent, date type, status, period List of booking certificates used/not used per agency 
Booking Transfer Filter by flight number, user List of all the transfer bookings made 
Cancellations Filter by date type according to cancellation date/service date, period List of services canceled with all canceled service pricing information 
Cargo Filter by agent, route, cargo type, user List of all the cargo booked 
Cashier Filter by users, station, period List of receipts per selected period, in the printout version, an extra table is added with the total and the breakdown of the currency 
Cashier Daily Filter by 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 and a breakdown of currency, with a note area which is kept in the system DB 
Charter Aircraft Analysis Filter by PNR status, period Summary of charters grouped by a selected filter, A/C type, customer, etc. 
Charter Payments Filter by payment type, payment supplier, status, country, period  List of all charter expenses recorded on the charter system 
Charters Filter by PNR status, Charter status, period  List of all charters with routes, PAX QTY, A/C and fare 
Class Allocation Filter by GDS status List of classes per flight and their allocations 
Class Availability Filter by GDS status List of classes per flight and their availability cache 
Class Booking Analysis Filter by class groups List of classes per flight and their booked numbers 
Class Breakdown per Route Filter by ticketed bookings, breakdown per day, summary type, period  Summary of routes with class sale breakdown 
Class Yield Filter by class code, flight number, yield value, route  List of flights according to which has less free seats than the yield value 
Complete Route Analysis Filter by period  Complete route analysis per booking. Will group together similar complete routes within bookings 
Connecting PNR Filter by date  List of all connecting INVs in the same PNR 
Credit Memos Filter by agencies, direct clients, period  List of all credit memos issued. 
Crew Hours Filter by a crew member, period  Summary of a detailed report of each crew member hours on a given A/C type 
Currency Exchange Log Filter by dates  List of exchange currency changes with user and date stamp 
Customers Deposit Balance by Currencies Filter by active/inactive customers and date  List of active/inactive customers with a deposit balance, per currency 
Daily Flight Information Filter by a single date  A list of bookings with all the passengers listed and paid amounts with routes for a selected date 
Deferred Filter by a single date  A list of invoices which their first service date is after the selected date 
Deferred by Period Filter by period  A list of invoices that were issued in the selected period but their first service date is out of the selected period. 
Deposit Statement Filter by agencies, Customers, period  A list of deposit transactions in/out with total 
Developments None  The report will show a list of all issues/development requests made by the company (from all users) and their status at AeroCRS development department 
Discounts Filter by period  A list of given discounts and their PNR ref.
E-Tickets Report Filter by flight number, status  List of E-tickets (GDS) and passengers 
Fare Simulation per Date Filter by a date  Fares report according to date of selling 
Flight Data Filter by status  Prints out information about flights‚ service load‚ routing and segments 
Flight passenger information (Simple)  Filter by flight number, income code, period List of passengers, with routing data and flight numbers 
Flight Routing Filter by period List with information about flights routing 
Flight Summary Breakdown Filter by period  List of flights per passengers, classes, charge type, passenger type (ADL, CHL, INF) 
Free Service Pricing Filter by a user, period  List of price modifications made per user 
Frequent Flyer Movements Filter by FF number, period  List of movements of a FF record (in and out)
Invoice Aging  Filter by agencies‚ branch and non-paid invoice  The amount of all invoices by periods‚ per agency/user 
Invoices Filter by credit memos, ACC code, a date by, account info, include passenger name, show valid invoices, by agent, by branch, period  List of invoices issued
Invoices and Receipts Filter by period  List of invoices and their related receipts 
Invoices Items  Filter by the list of invoice items (the breakdown of the invoices)  List of invoice items 
Load Factor and Revenue per Flight  Filter by 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 flew for one hour, what was the revenue for it), revenue per PAX 
Load Factor and Revenue per Flight Number Filter by data by, income code, agent  List of flights with their load factors‚ fares‚ tax‚ revenue per hour (a calculation of if the flight flew for one hour‚ what was the revenue for it)‚ revenue per PAX 
Manifest  Filter by 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 
Nationality Breakdown  Filter by period  List of nationalities and the number of passengers from those nationalities 
Open Services - by Selling Date  Filter by type, supplier, status, period  List of open services by the selling date 
Open Services - by Service Date  Filter by type, supplier, status, period  List of open services by the service date 
Passengers Check-in Report Filter by status, period  List of passengers with their check-in information 
Passengers Fare Info Filter by agent, status, flight number, incomer code, customer ID, ticket status, route, user, branch  List of passengers in bookings with their services information 
Passengers Information Filter by 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 Information Report (Short) Filter by period  List of passengers with full-service information 
Passengers Report for Agency Filter by agency, Date type, period  List of passengers with flight details for a specific agency 
Pay at Check-In Filter by period  List of bookings still open in "Pay at check-in" status
PNR Accounting  Filter by only ticketed bookings, by agent, customer e-mail, period  List of PNR's with PNR creation method, pricing, invoices, receipts, the amount left/due for payment 
Receipts Filter by receipt type, period List of receipts 
Refunds  Filter by agencies, period  List of refunds 
Routes Breakdown  Filter by ticketed status, detailed report, agencies, and customers  List of routes with a number of PAX with a breakdown of pax type (single booking, return bookings and multi-service bookings) 
Routes Summary  Filter by 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 a number of PAX and fare information with the option of a breakdown by class or agency to show a detailed grouping of the data 
Routes Summary by Date Filter by ticketed status‚ agencies‚ summary type (revenue / pax)  List of routes with a number of PAX or revenue per date 
Routes Summary by Day of the Week  Filter by ticketed status, agencies, summary type (revenue/pax)  List of routes with a number of PAX or revenue per day of the week 
Routing Load Report  Filter by a date  List of loads per flights according to allocated airplanes in manifest and editing options 
Sales  Filter by a user, period  List of bookings with PAX QTY and amount 
Sales per Day (Detailed Report)  Filter by user, agency, period  List of bookings with PAX amount, PAX name, and fare information 
Services  Filter by ticket status, service active, date period type (service, created or modified), agencies, service type, service status, period  List of services with fare data 
Services Simple  Filter by ticket status, service active, a date by, by agent, flight number, from-to, by a user, service type, status, period  List of services, breakdown per service 
Single/Return Breakdown per Route  Filter by ticket status, period  List of routes with single / return indication 
SMS Report  Filter by flight number, FF number, PNR, status  List of SMS tracking sent from the system 
SSIM Report  Filter by flight number, IATA code, status, period  SSIM report creation per date
SSR Report  Filter by flight number, SSR  List of tracking SSR by flight 
Tax Headcounts  Filter by Interval, period  Headcount list according to routes 
Top Agents per Route  Filter by ticket status, period  List of routes and 20 top agents per route according to booked amount 
TTL PNR's  Filter by period  List of bookings which is about to breach TTL 
Unbalanced Services  No filters List of bookings that 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. 
Vouchers Filter by agent‚ voucher sum‚ PNR status  Prints out a list of vouchers along with their PNR's‚ with agent and voucher details 

 

Please note that all reports can be scheduled and sent automatically from the system (not sure how scheduling a report works? Learn more).

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