Reports database

Reports database

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

Report nameFilter optionsOutput
Booking AnalysisService status, flight status, ticketed bookings, periodPivot table of flight numbers vs flight dates
SalesUser, periodList of bookings with PAX QTY and amount
DeferredSingle dateA list of invoices which their first service date is after the selected date
InvoicesAccounting code, agenices and customers, periodList of invoices
Credit MemosAgencies, direct clients, periodList of all credit memos
ReceiptsReceipt type, periodList of receipts
RefundsAgecnies, periodList of refunds
Batch invoiceAgencies, date type (first service date, service date, inovice date), Invoice type, periodBatch printout of invoices for the selected period and filter settings
Agents turnoverSorting option and date type by service date or invoice dates, periodTotal QTY of passengers, total amount per agency
Agents statementAgencies, Date types (invoice issue, service dates, dates of bookings), periodList of invoices or credit memos for the given period with total paid for booking
CashierUsers, station, periodList of receipts per the selected period, in the printout version, an extra table is added with the total with breakdown of currency
Invoices and ReceiptsPeriodList of invoices and their related receipts
Unbalanced PNRsUnbalanced types, periodDifferent types of unbalanced PNRs which gives you a list of bookings which are unbalanced from various reasons
Open Services - by selling dateType, supplier, status, periodList of open services by the selling date
DiscountsPeriodA list of given discounts and their PNR ref
Open Services - by service dateType, supplier, status, periodList of open services by the service date
ProductsPeriodList of products sold with their booking reference and service data and fares
Products - by selling datePeriodList of products sold with their booking reference and service data and fares
Products including pax namesPeriodList of products sold with their booking reference and service data and fares and passenger names
WorkSheetProduct type selection, name of product, periodList of products booked with fare data, services names, agencies, service date etc.
Routes summaryTicketed status, detailed report, agencies and customers, period type, income code, break down by class, detailed pricing, break down by agencyList 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
ServicesTicket status, service active, date period type (service, created or modified), agencies, service type, service status, periodList of services with fare data
Batch Invoice by numberAgencies, number of invoicesBatch printout of invoices from-to the list of numbered invoices
Routes breakdownTicketed status, detailed report, agencies and customersList 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, periodList of bookings with pax qty, pax name, and fare information
TTL PNRsPeriodList of bookings which is about to breach TTL
Cashier DailyUsers, station, the abilty to add a note, selected dateList 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
DeferredSingle dateA list of invoices which their first service date is after the selected date
Unbalanced ServicesNo filtersList 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 periodPeriodA list of invoices which were issued in the selected period but their first service date is out of the selected period.
Daily flights informationSingle dateA list of bookings with all the passengers listed and paid amounts with routes for a selected date
Agents booking typesPeriodQTY of bookings according to a given date period with a breakdown of CRS and WEB booking per agency
ChartersPNR status, periodList of all charters with routes, PAX QTY, A/C and fare
Charter aircraft analysisPNR status, periodSummary of charters grouped by a selected filter, A/C type, customer etc.
Charter paymentsPayment type, payment supplier, status, country, periodList of all charter expenses recorded on the charter system
Passengers informationAgenices, check-in status, flight number, income code, service status, period type selection, routing, periodList of passengers with full service information and fare data
Passengers check-in reportStatus, periodList of passengers with their check-in information
Hotels bookingsHotels, PeriodList of bookings with hotels in them, service dates and room type
Crew hoursCrew member, periodSummary or a detailed report of each crew member hours on a given A/C type
Advanced Daily SalesFlight date and PNR date (date type)List of bookings with user data, first passengers, total sales, TAX and VAT
Flight Checked-in RevenuePeriodList of flights, seats QTY and checked in revnue total and No-show revenue total
Frequent Flyer movementsFF number, periodList of movements of a FF record (in and out)
Meet and Greet for productsProduct type selection, name of product, periodBatch printout of handout signs for meet and greet for products sold with their respective agency name and logo.
Batch bookingTemplate selection, single dateBatch printout of bookings for a selected date according to the date selected
Routes summary by day of the weekTicketed status, agencies, summary type (revenue / pax)List of routes with QTY of PAX OR revenue per day of the week
Hotel nightsPeriodList of hotel bookings and number of nights booked within this period
ManifestFlight number, manifest template, routing, periodBatch prinout of manifests for a given flight number for a period with the ability to filter specific routing
CancellationsDate type according to cancellation date / service date, periodList of services cancelled with all cancelled service pricing information
Class break down per routeTicketed bookings, breakdown per day,summary type, periodSummary of routes with class sale breakdown
Single/Return breakdown per routeTicket status, periodList of routes with single / return indication
Top agents per routeTicket status, periodList of routes and 20 top agents per route according to booked QTY
Load factor and revenue per flightTicketed bookings, Data type, income codes, agencies and customers, periodList 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 statementAgenices, Customers, periodA list of deposit transactions in/out with total
Pay at check-inPeriodList of bookings still open in "Pay at checkin"
Passengers report for agencyAgency, Date type, periodList of passengers with flight details for specific agency
Flight passenger information (Simple)Flight number, income code, periodList 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, periodList of passengers with full service information
Agents detailed pricing breakdownAgencies, ticketed bookings and flight / PNR date periodList services and their commissions with the QTY of passengers
Nationality breakdownPeriodList of nations and the QTY of passengers from them
DevelopmentsNoneReport will show a list of all issues / development requests made by the company (from all users) and their status at AeroCRS development department
Accounting transactionsDates‚ agencies‚ report date type‚ by PNR or by Record dateBalance of all invoices and receipts and deposits‚ sorted according to the selected date type‚ this report will help you balance the bookings.
Currency exchange logDatesExchange currency changes with user and date stamp
Deferred by servicePeriodA list of PNR's that contain services from different months within the period.
Invoice Aging agenices‚ branch and non paid invoiceThe amount of all invoices by periods‚ per agency/user
VouchersAgent‚ voucher sum‚ PNR statusPrints out a list of vouchers along with their PNR's‚ with agent and voucher details
Routes summary by dateTicketed status‚ agencies‚ summary type (revenue / pax)List of routes with QTY of PAX OR revenue per date
Invoices itemsThe list of invoice items (breakdown of the invoices)List of invoice items


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