Analytics & Exports
Generate detailed reports and export data from across Musket for analysis, compliance, and operational insights.
1 What's on this page
The Analytics & Exports page is your central hub for generating reports across all Musket modules. Whether you need flight hours analysis, crew duty tracking, maintenance forecasts, safety audit summaries, or financial reports, this page provides access to over 30 specialised report types with advanced filtering capabilities.
What you see here
- Report library: A searchable table listing all available report types across different operational sections
- Search and filter: Quick search by report name, description, or section to find the report you need
- Section organisation: Reports grouped by operational areas like Flight Operations, Staff Management, Maintenance Hub, and QSS
- Generate window: A full-screen report generation interface with filters, preview, and export options
Key concepts
- Report type: A pre-defined data extraction and analysis template designed for specific operational needs
- Report section: The operational area or module the report relates to (e.g., Scheduling, Auditing & Reporting)
- Filter criteria: Parameters you select to narrow the data included in your report (dates, aircraft, staff, etc.)
- Preview: A browser-based view of the generated report before downloading
- Export: Download the report as an Excel file or PDF for offline use and distribution
Who can access: Administrators with the Analytics & Exports: Full permission can view and generate all available reports. Users without this permission see an access notification.
Data sensitivity: Some reports contain sensitive operational or personal data. Handle and share reports in accordance with your organisation's data protection policies.
2 Finding and opening reports
The Analytics & Exports page displays all available reports in a central table. Use search and filtering tools to quickly locate the report type you need.
2.1 Search for reports
The search box (top-left of the table) helps you find reports by typing keywords:
- Search by name: Type part of the report name (e.g., "aircraft hours", "staff recency")
- Search by description: Type keywords from the report's description (e.g., "FDP", "maintenance", "invoice")
- Search by section: Type section names like "Flight Operations", "Scheduling", "Maintenance Hub"
An information icon next to the search box shows which fields are searchable. Search results update as you type, and the table displays "There are no reports that match the provided search terms" if no matches are found.
2.2 Filter by report section
Use the Report Section dropdown to filter reports by operational area:
- All Reports (default): Shows all available reports across all sections
- Flight Operations: Aircraft utilisation, passenger routes, client flights, post-flight actuals
- Scheduling: Flight schedules, long-term assignments, payroll reports
- Staff Management: Crew FDP hours, recency tracking, staff details exports, timesheets
- Maintenance Hub: Maintenance forecasts, tracking sheets, job cards, defers & defects, inventory
- Auditing & Reporting: Audit status reports, corrective actions, submitted report details
- Quotations: Quote reports, invoice reports, proforma invoice reports, credit note reports, receipts reports
- Aircraft Management: Aircraft documents, fleet exports
- Administration: Staff details exports (comprehensive), user access and policies
- Organisation: Tools & equipment reports
If you filter to Maintenance Hub but your organisation is not subscribed to Maintenance Hub features, an alert will notify you to contact support. Selecting a section filters the table immediately.
2.3 Understanding the reports table
The reports table displays four columns:
| Column | Meaning | Notes |
|---|---|---|
| Open | Button to open the report generation window | Click the spreadsheet icon to start generating the report |
| Name | The report type name | Sortable column; includes an icon representing the report category |
| Description | A detailed explanation of what the report contains | Describes the data included and typical use cases |
| Section | The operational section(s) this report belongs to | Sortable column; some reports appear in multiple sections |
Click column headers (Name or Section) to sort the table alphabetically. A small arrow icon indicates the current sort direction.
2.4 Open a report
To generate a report:
- Locate the report type you need in the table (use search or section filters if helpful)
- Click the blue Open button (spreadsheet icon) in the leftmost column of the report row
- The report generation window opens in full-screen mode with the report name in the header
3 Generating reports
After opening a report type, the report generation window guides you through selecting filters, generating the report, previewing the results, and exporting to Excel or PDF. Each report type has its own filter options tailored to the data it contains.
3.1 Select filter criteria
The top section of the generation window displays filter controls specific to the selected report type. Filter options vary by report but commonly include:
Common filter types
- Date range: Period selection for time-based data (e.g., last 30 days, custom date range)
- Aircraft: Filter by specific aircraft or aircraft types
- Staff members: Filter by individual staff, roles, or crew positions
- Clients: Filter by client for financial and flight reports
- Locations: Filter by airports, bases, or countries
- Status filters: Filter by active/inactive, completed/pending, or other status indicators
- Custom fields: Some reports offer additional specialised filters
Filter tips
- Leave filters blank to include all data (where allowed by the report)
- Multiple selections work like an "OR" filter (e.g., select 3 aircraft to include data for any of the 3)
- Some filters are required (e.g., aircraft selection for single-aircraft reports)
- Date ranges use UTC time by default; some reports offer local time options
- The window displays a loading spinner while filter options load
After selecting your filters, the system loads the relevant data for the report. For some complex reports (like FDP reports), this data loading happens in the background and may take a few seconds.
3.2 Generate and preview the report
Once filters are selected and data is loaded, click the Generate and Preview Report button:
- The button shows a loading indicator with text "Generating report..."
- Musket generates the report in the background (this may take 10-30 seconds for large datasets)
- The preview area displays the generated report in the window
- Additional export buttons appear above the preview once generation completes
The preview displays either an Excel file preview or a PDF preview, depending on the report type. Most reports generate both Excel and PDF versions simultaneously.
Data sensitivity notes: Aircraft Documents Report and Staff Recency reports may contain links to sensitive documents. An orange warning appears below the generate button reminding you to handle these reports according to your organisation's data protection policies.
Report-specific requirements
Some reports have special requirements:
- Single-aircraft reports: Reports like Maintenance Tracking Sheet require aircraft selection before you can generate
- Crew member selection: Reports like Flight Experience Summary require selecting a specific crew member
- Time limits: Timesheet reports load a maximum of 4 months of data for performance reasons
3.3 Export the report
After the report generates, you have multiple options for downloading and sharing:
Export from the preview area
Above the preview, you'll see export buttons:
- Excel icon: Download the report as an Excel file (.xlsx)
- PDF icon: Download the report as a PDF file (.pdf)
Click either icon to download. The file name automatically includes the report name and generation timestamp (e.g., "Aircraft Hours Landings 08 Jan 2026 1430.xlsx").
Export from the bottom controls
At the bottom-right of the window, the same export buttons appear for convenience:
- Use these buttons to export without scrolling back to the preview area
- The file name follows the same automatic naming convention
- For crew-specific reports (like Flight Experience Summary), the file name includes the crew member's name
File format notes: Excel files are best for further analysis and manipulation. PDF files are ideal for printing, archiving, and sharing as read-only documents. Most reports generate both formats simultaneously.
3.4 Regenerate with different filters
To generate the same report type with different criteria:
- Change your filter selections at the top of the window
- Click Generate and Preview Report again
- The system replaces the previous preview with the new report
- Export the new version using the export buttons
You can regenerate as many times as needed during your session. Each generation creates a new report file with the current timestamp.
4 Featured report types
Musket offers over 30 specialised report types. Here are some of the most commonly used reports across different operational areas:
4.1 Flight Operations reports
Aircraft Hours & Landings
Purpose: Insights into aircraft hours, landings, and usage within a period, based on post-flight actuals.
Key filters: Date range, aircraft selection, flight types
Passenger Route Report
Purpose: Breakdown of passenger figures & statistics, grouped by client, route, and aircraft type. Includes trend analysis.
Key filters: Date range, aircraft types, clients, countries
Flight Schedule Export
Purpose: Export all scheduled flight details with crew, aircraft, route, and timing information.
Key filters: Date range, aircraft, crew, airports, clients, custom fields
Post-Flight Actuals Export
Purpose: Export all post-flight actual details including block times, fuel, crew hours, and actuals data.
Key filters: Date range, aircraft, crew, airports, clients, custom fields
Clients Flights Report
Purpose: Export post-flight actuals, with flights grouped by client, aircraft and flight type.
Key filters: Date range, clients, aircraft, flight types
4.2 Staff Management reports
Staff Cumulative FDP
Purpose: Crew Flight Duty Period hours, and flight times, for a single reference date & time. Shows cumulative totals.
Key filters: Reference date/time, staff members, roles, positions
Staff Recency
Purpose: Track crew documents, training certificates, and expiry dates. Shows valid, expiring soon, and expired items.
Key filters: Staff members, roles, positions, countries
Staff Daily Flight & Duty
Purpose: Crew FDP hours, flight hours, and duty hours, shown per day over a date range.
Key filters: Date range, staff members, roles, positions, aircraft operated
Note: Filter selections affect which staff members are shown. All duty hours for filtered staff within the period are displayed.
Timesheets FDP Report
Purpose: Export duty periods, sign-on/off details, and FDP details for duty periods.
Key filters: Date range (max 4 months), staff members, roles, positions, aircraft operated
Staff Details All Export
Purpose: Export all staff details, including personal information, contact details, employment details, all custom fields and more.
Key filters: Staff members, roles, positions, employment status
Staff Recency Settings Report
Purpose: Export staff recency settings and parameters.
Key filters: Staff roles, positions
Flight Experience Summary
Purpose: Export crew members' flight experience summary, including hours and flights for each aircraft type or class.
Key filters: Crew member selection (required), date range, aircraft types
Crew Operational Recency Report
Purpose: Export crew operational recency details, including general flight recency, night recency, and IFR recency.
Key filters: Date range, staff members, roles, positions
4.3 Administration reports
User Access And Policies Report
Purpose: Export user access policies and permissions, showing which users and roles have access to which Musket sections and their permission levels.
Key filters: Sections (multiselect), staff members, roles. If no filters selected, exports all sections, all active non-system users, and all roles.
Report access shortcuts: The User Access And Policies Report can also be accessed directly from the User Management page (in the Active Users tab) and from the Role Management page (in the Manage Roles grid header). This provides quick access when reviewing user or role configurations.
Understanding the User Access And Policies Report
This report displays access permissions in a matrix format, with users/roles as rows and Musket sections/features as columns. Each cell is color-coded to indicate the permission level:
Full/Edit Access
Cell background is green when the user has Full or Edit access. The cell shows which role grants this access (e.g., "Full (Administration)") or "(Direct)" if assigned directly to the user.
View Access
Cell background is blue when the user has View-only access. The cell indicates the granting role or direct assignment.
No Access
Cell background is white (blank) when the user has no access to that section or feature.
When a user has access through multiple roles, the report lists all granting roles in the same cell. For example: "Full (Operations Manager), Edit (Crew Lead)" indicates the user has Full access from the Operations Manager role and Edit access from the Crew Lead role. The effective permission is Full, which is the highest level granted.
4.4 Maintenance Hub reports
Feature subscription required: Maintenance Hub reports require an active Maintenance Hub subscription. If you see a message "You are currently not subscribed for Maintenance Hub features", contact support@musket-fms.com to enable these reports.
Routine Maintenance Forecast
Purpose: Forecast of routine maintenance schedules and tasks for all aircraft or specific types.
Key filters: Aircraft, aircraft types, operators
Maintenance Tracking Sheet
Purpose: Detailed maintenance tracking sheet for a single aircraft showing all tracked items and statuses.
Key filters: Single aircraft selection (required)
Defers & Defects Export
Purpose: Export MEL & non-MEL defects and defers with status, category, and action details.
Key filters: Date range, status filters
Job Cards Report
Purpose: Export history of all job cards raised with maintenance actions and completion details.
Key filters: Date range, aircraft, operators
Aircraft Utilisation Report
Purpose: Aircraft engine and propeller details including hours and cycles for a specified period.
Key filters: Date range, aircraft selection
Scheduled Maintenance Action Settings Report
Purpose: Export the list of scheduled maintenance action types from settings, with their initial and recurrent intervals, for airframes, engines, propellers, and their related parts.
Key filters: Aircraft types, maintenance action categories
MEL Defer Extension Requests Report
Purpose: Export MEL defect extension requests including their relevant details.
Key filters: Date range, aircraft, extension status
Inventory Report
Purpose: Export inventory and parts details.
Key filters: Part categories, stock levels, locations
Tools & Equipment Items Report
Purpose: Export tools & equipment items.
Key filters: Equipment types, categories, calibration status
4.5 Auditing & Reporting reports
Audit Status Report
Purpose: Export overview of audits and their statuses (draft, in progress, completed) with key details.
Key filters: Date range, audit types
Corrective Actions Report
Purpose: Details on corrective action requests, findings, and corrective action plans with status tracking.
Key filters: Request date range, audits, reports, requested by, responsible person
Submitted Reports Export
Purpose: Export all submitted report details with categories, status, and investigation information.
Key filters: Date range, reportee, team members, entities, categories
Risk Hazard Register Report
Purpose: Export risk and hazard register with risk assessments, controls, and mitigation strategies.
Key filters: Hazards, bases, entities, audits, reports, MoCs
4.6 Financial & Quotations reports
Aircraft Charter Invoice Report
Purpose: Generate detailed aircraft charter invoices with flight details, charges, and totals.
Key filters: Date range, aircraft, aircraft types, clients, invoice status
Client Account Statement
Purpose: Generate client account statements showing transactions, invoices, payments, and balances.
Key filters: Date range, single client selection (required)
Quote Report
Purpose: Export quotations report including all quote-related information, pricing, and flight details.
Key filters: Date range, aircraft types, aircraft, countries, clients, last updated by
Proforma Invoice Report
Purpose: Export proforma invoice report including all proforma invoice-related information, pricing, and client details.
Key filters: Date range, aircraft types, aircraft, countries, clients, last updated by
Credit Note Report
Purpose: Export credit note report including all credit note-related information and financial details.
Key filters: Date range, aircraft types, aircraft, countries, clients, last updated by
Receipts Report
Purpose: Export receipts report including all receipt-related information and payment details.
Key filters: Date range, aircraft types, aircraft, countries, clients, last updated by
Long-Term Assignments Report
Purpose: Report on long-term assignments of staff members including locations, dates, and assignment types.
Key filters: Date range, roles, staff, positions, airports, countries
5 Troubleshooting and tips
Report generation fails or shows an error
Common solutions
- Required filters missing: Some reports require specific filters (e.g., aircraft selection). Check for disabled generate buttons with popover messages.
- No data for filters: The report may display "The report is empty" if your filter selections return no data. Try widening your date range or removing some filters.
- Timeout on large datasets: Very large reports (e.g., all staff timesheets for 4 months) may take 30+ seconds. Be patient and don't close the window.
- Permission issues: Ensure you have the "Analytics & Exports: Full" permission. Contact your administrator if you see an access notification.
Report preview doesn't display
If the preview area stays blank after generation:
- Check your browser's popup blocker settings (some browsers block embedded previews)
- Try the export buttons to download the file directly—the download will work even if preview fails
- Refresh the page and try generating again
Filter options don't load
If filter dropdowns stay empty or show loading spinners indefinitely:
- Check your network connection
- Close the window and open the report again
- Refresh the entire page if the issue persists
Tips for efficient reporting
Best practices
- Start with narrow filter criteria and widen if needed (faster generation)
- Use section filters to quickly find reports in your operational area
- Generate reports regularly for trending and compliance monitoring
- Export to Excel when you need to manipulate or analyse data further
- Export to PDF for archiving, printing, and read-only distribution
Performance tips
- Avoid generating the same report multiple times—save your exports for reuse
- Use shorter date ranges for very large datasets (e.g., timesheets)
- Close the generation window when done to free browser resources
- Generate reports during off-peak hours if your organisation has heavy system usage