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‚ agent‚ flight status‚ ticketed bookings‚ booked seats or load factor‚ flight number‚ include infants‚ include charter flight‚ 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
InvoicesShow credit memos, Accounting code, date pick (Invoice date, First/Last service date, Invoice vale date and Invoice due date), Include passengers name, show only valid invoices, agencies and customers, periodList of invoices
Credit MemosAgencies, direct clients, periodList of all credit memos
ReceiptsReceipt type, Agents, periodList of receipts
RefundsAgencies, periodList of refunds
Batch invoiceInvoice Type, date selection (first service date, service date, inovice date, invoice value date, invoice due date),show only valid invoices,Agencies, Branch, periodBatch printout of invoices for the selected period and filter settings
Agents turnoverSorting option (by agent or sales) and date type (by service date or invoice dates, valid invoice date), Bank code, show all or only ticketed, periodTotal QTY of passengers, total amount per agency
Agents statementAgencies, Group, Include passenger names, Show only non paid, Date selection (invoice issue, service dates, dates of bookings, due date, value date and first ticket date), Show only valid invoices, Show invoice age, Show PNR name, Show GDS RLOC, Service date to show (first or last), Branch, periodList of invoices or credit memos for the given period with total paid for booking
CashierSort by (Date, Type, Total, Cashier, Station, Receipt number), Service date (first or last), Include passenger names, 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 ReceiptsInclude Credit memos, PeriodList 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, user, user who (created PNR, created service), periodList of open services by the selling date
DiscountsType, PeriodA list of given discounts and their PNR ref
Open Services - by service dateType, supplier, status, user, user who (created PNR, created service), 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, Flight status (active or inactive), detailed report, date goes by (service date, booked date and active ticket date), Income code, break down by class, detailed pricing, break down by agents, agent, branch, periodList 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)‚ agent‚ flight number‚ From‚ To‚ user‚ service type‚ service status‚ periodList of services with fare data (up to 2000 services)
Batch Invoice by numberAgencies, number of the invoicesBatch printout of invoices from-to the list of numbered invoices
Routes breakdownTicketed status, detailed report, agent, periodList of routes with QTY of PAX broken down to pax type (single booking, return bookings and multi service bookings)
Sales per day (detailed report)Agent, user, show bookings by (all payment types, paid by deposit, voucher within PNR), Show first service remarks, show first service day, show last service day, branch, periodList of bookings with pax qty, pax name, and fare information
TTL PNRsPeriodList of bookings which is about to breach TTL
Cashier DailyAs 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
Booking listAgent, flight number, periodWill show the list of passengers according to reflected criteria
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, Charter Status, periodList of all charters with routes, PAX QTY, A/C and fare
Charter aircraft analysisGroup by (Customer and A/C type, A/C type and A/C registration), PNR 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 (Add-ons)
Passengers informationAgent‚ check-in status‚ flight number‚ income code‚ customer ID‚ service status (booked‚ ticketed‚ cancelled)‚ dates by (flight date‚ booked date‚ ticketed date)‚ 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, detailed information, periodSummary or a detailed report of each crew member hours on a given A/C type
Advanced Daily SalesDate goes (flight date, PNR date, PNR date with total PNR fare), From, To, User, periodList of bookings with user data, first passengers, total sales, TAX and VAT
Flight Checked-in RevenueCheck in status, Class group, periodList 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, Show sum by (passengers, revenue), Agencies, periodList 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, status periodBatch prinout of manifests for a given flight number for a period with the ability to filter specific routing
CancellationsAgents, Date type according to cancellation date / service date, From, To, periodList of services cancelled with all cancelled service pricing information
Class break down per routeTicketed bookings, breakdown per day,summary type (passengers, revenue), 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 flightTicket status, Show routing, Data type (fare, actual revenue), income codes, Agencies, Agency group, 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 statementCustomer/Agencies, Currency, Split action, Branch, periodA list of deposit transactions in/out with total
Pay at check-inPeriodList of bookings still open in "Pay at checkin"
Passengers report for agencyAgencies, Date goes by (flight date, PNR date), brach, periodList of passengers with flight details for specific agency
Flight passenger information (Simple)Agent, Flight number, income code, From, To, periodList of passengers, with routing data and flight numbers
Passengers information report (short)PeriodList of passengers with full service information
Agents detailed pricing breakdownAgencies, ticketed status, date goes by (flight date, PNR date, PNR date with total PNR fare), branch, periodList services and their commissions with the QTY of passengers
CargoShow ticketed bookings, Agent, route, filter by (date, type, supplier, route, NOP), cargo type, user, periodList of all the cargo booked
Nationality breakdownPeriodList of nations and the QTY of passengers from them
Actual flight timingsPeriodList of flights with their Actual Flight Data (ETD, ETA, Delays, etc) and crew information
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 transactionsAgent, Date filter by (PNR date, Record date), Show (all records, total and not balanced), branch, periodBalance of all invoices and receipts and deposits‚ sorted according to the selected date type‚ this report will help you balance the bookings.
Currency exchange logPeriodExchange currency changes with user and date stamp
Deferred by servicePeriodList of PNRs that contain services from different months within the period.
Invoice AgingAgencies‚ show only non paid, branchThe amount of all invoices by periods‚ per agency/user
VouchersTotal, Sort by (voucher date, voucher sum, agent name), Agent, ticket status, PNR status, periodPrints out a list of vouchers along with their PNRs‚ with agent and voucher details
Routes summary by dateTicketed status‚ show sum by (passengers, revenue), agencies‚ periodList of routes with QTY of PAX OR revenue per date
Invoices itemsShow credit memos, ACC code, Date pick by (Invoice date, Invoice value date or Invoice due date), show only valid invoices, Agencies, Branch, Show pax names and QTY, periodList of invoice items
Class allocationsGDS status, periodList of classes per flight and their allocations
Load factor and revenue per flight numberShow ticketed bookings, Data by (fare, actual revenue), income code agencies, periodList 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
Passengers fare infoAgent, status, flight number, incomer code, customer ID, ticket status, dates by (flight date, booking date and ticketed date), route, user, branch, periodList of passengers in bookings with their services information
Daily flight reportDateInformation about flights on specific day
Log by dayUser, screen, for dateSummary of the log records for all actions made on the selected day
Flight routingPeriodPrints out information about flights routing
Flight dataFlight status, periodPrints out information about flights‚ service load‚ routing and segments
Agencies deposit balance by currenciesActive or inactive agencies, As dateCurrent deposit balance for all agencies and currencies
Complete route analysisPeriodComplete route analysis per booking. will group together similar complete routes within bookings
AncillarydateAll ancillary records in a time period‚ including breakdown and summation.
Website Contactsdate‚ subjectAll the contact records made via the website between specific dates
Batch invoice V2Agencies‚ date type (first service date‚ service date‚ inovice date)‚ Invoice type‚ periodBatch printout of invoices for the selected period and filter settings
Batch Invoice by number V2Agencies‚ number of invoicesBatch printout of invoices from-to the list of numbered invoices
Invoice items statisticsThe list of invoice items (breakdown of the invoices)Statistics per invoice item type
Class availabilityGDS statusList of classes per flight and their availability cache
Class booking analysisShow ticketed bookings, Show Class groups, periodList of classes per flight and their booked numbers
PNR AccountingDates‚ Ticketed bookings‚ Agency‚ Customer e-mailSupples full PNR information‚ routing‚ accounting‚ passenger names‚ receipts‚ vouchers and due data.
Class YieldClass code, flight number, yield value, route, periodList of flights according which is have less free seats than the yield value
Get Flown DataFlight Number‚ Departure airport‚ destination airportFlown data information for AVI & VAT Collect
New and Scheduled FlightsFlight Number‚ Departure airport‚ destination airportActive‚ new and cancelled flights for selected dates
SMS ReportFlight number, FF number, PNR, status, periodTracking of SMS sent from the system
Booking TransfersDates,Users,Flight numberList of all booking transfers made
SSR ReportFlight number, SSR, periodTracking of SSR by flight
Tax headcountInterval, periodHeadcount list according to routes
Connecting PNRDateList of all connecting INVs in the same PNR
E-tickets ReportFlight number, status, periodList of E-tickets (GDS) and passengers
Fares simulation per dateSingle dateFares report according to date of selling
Routing load reportAs dateShows the loads of the flights according to allocated airplanes in manifest editing options
Accommodation reportPeriodList of accommodations
Flight Summary BreakdownPeriodBreakdown of flights by classes and chargetypes per route
Services special exportPeriodSpecial export of services
Receipts / Refunds ExtendedPeriodExtended receipts report
AeroCRS Network SalesPeriodSales which originated from AeroCRS Network
Customers deposit balance by currenciesDatesDeposit balance
AeroCRS Network OTA commissionsPeriodSales which originated from AeroCRS Network
AeroCRS Network paymentsPeriodSales which originated from AeroCRS Network
Classes per agencyAgency nameAgency GroupAccount code (ACC code)CountryList of agents and relevant classes
Free Service PricingAgents, userFree SRV pricing changes
Services SimpleLike servicesService payment information
Accounting Report (special)dates: from and toAccounting report from-to dates
SITA character ReportPeriodBreakdown of total messages‚ character count and message type by month
Invoice items (simple) Show credit memos‚ ACC code‚ Date pick by (Invoice date‚ Invoice value date or Invoice due date)‚ show only valid invoices‚ Agencies‚ Branch‚ period List of invoice items
Sales Per CustomerPNR created date‚ customer email List of PNRs with customer details
Direct API UsagePeriodUsage of API in actual bookings‚ only API Agreement type
Connection FaresDates: from-to‚ show on web‚ show to agentsConnection fares summary
Open PNRsDate‚ Date Type
Invoices - Accounting ReportDate‚ Date Type
Flown DataFlight Number‚ Departure airport‚ destination airport
Coupons Change logPeriod
No-Show PassengersPeriodNo Show passengers. Applicable only for passengers affected by No Show Policy.
AmendmentsAgents‚ Date type according to cancellation date / service date‚ From‚ To‚ periodList of services amended with all amended service pricing information
Cashier PaymentsSort by (Date‚ Type‚ Total‚ Cashier‚ Station‚ Receipt number)‚ Service date (first or last)‚ Include passenger names‚ period List of receipts per the selected period‚ in the printout version‚ an extra table is added with the total with breakdown of currency
Split PNRsSort by DateSplit PNRs data and links‚ dates go by the split date


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