Insight Software - Jet Analytics
- Home
- >
- Our Solutions
- >
- Insight Software – Jet Analytics
Jet Reports: Excel-Based Reporting for Microsoft Business Central
Jet Reports, owned by Insightsoftware, delivers fast, accurate business reporting and advanced analytics directly inside of Excel. It integrates seamlessly with Microsoft Dynamics Business Central, allowing you to create high-impact financial and operational reports without the need for programming expertise.
Benefits of Jet Reports for Retailers and Businesses
Jet Reports is a powerful business intelligence tool that offers several advantages for retailers and businesses.
Automated Reporting
Jet Reports automates the reporting process, saving time and reducing the risk of human error. This allows businesses to generate timely and accurate reports with minimal effort.
Integration with Microsoft Dynamics
Jet Reports seamlessly integrates with Microsoft Dynamics 365 Business Central, providing real-time data insights and enhancing decision-making processes.
User-Friendly Interface
The user-friendly interface allows users to create and customise reports without extensive technical knowledge. This makes it accessible to a wide range of users within the organisation.
Advanced Data Visualisation
Jet Reports offers advanced data visualisation tools, including dashboards and charts, to help businesses quickly identify trends, spot anomalies, and make data-driven decisions.
Self-Service BI
Users can perform self-service analytics and reporting, allowing them to explore data freely and create the reports they need without relying on IT or data analysts.
Flexible Report Creation
Jet Reports allows for flexible report creation directly in Excel, making it easy to generate reports in the format that works best for your business.
Streamlined Data Processes
By streamlining data processes, Jet Reports helps businesses gain visibility into their operations and improve overall efficiency.
Cost-Effective
Jet Reports offers a cost-effective solution for business intelligence, providing valuable insights without the need for expensive, overinflated tools.
Why Choose Jet Reports?
Real-time data access
Directly query your database for real-time reporting.
Excel Integration
Utilise the full power of Excel for formatting and calculations.
Automated Reporting
Schedule reports to run and distribute automatically.
Accurate Data
Ensure data integrity with a solution seamlessly integrated with Microsoft Dynamics Business Central.
Dynamics ERP Integrations That Work in Real-Time
Connect directly to your Dynamics environment and work with live data in Excel. Jet Reports supports GP, NAV, and D365 Business Central with native integration.
Reports Center
Your centralised reporting command centre, delivering cloud automation and collaboration. Schedule reports to run and distribute automatically to stakeholders. Build Power BI dashboards from Business Central data and view them natively—no switching systems required.
The Next Evolution of Jet Reports — Intelligent Reporting
Companies running on Microsoft Dynamics 365 Business Central Cloud can experience the next evolution of Jet Reports. Reporting Intelligence adds live KPI monitoring, threshold-based alerts, and AI-generated insights — so your team spends less time building reports and more time acting on them.
Report Directly from Microsoft Fabric with Live Data
Pull live OneLake data into Excel reports effortlessly. Microsoft Fabric integration enables real-time decision-making without complex data warehouse setup or IT support.
Quickly Find Your Answers.
What is Jet Reports?
Jet Reports is a reporting tool from Insightsoftware that connects directly to Microsoft Dynamics 365 Business Central, pulling live ERP data into Excel so finance and operations teams can build accurate reports without manual exports.
Can Jet Reports build dashboards, or is it just spreadsheets?
Both. Reports are built in Excel using familiar formulas, but Jet Reports also includes a Reports Center for building and sharing dashboards, without needing a separate BI tool for straightforward reporting needs.
Does Jet Reports work across multiple companies or entities?
Yes. Businesses running more than one company file in Business Central, common for groups operating across Singapore and Malaysia, can consolidate data across entities into a single report rather than compiling each one separately.
Is Jet Reports a separate app, or does it work inside Excel?
It runs as an add-in inside Excel itself, accessed through a ribbon, rather than as a standalone application. Reports pull live data directly from Business Central using standard Excel functions.
How do I get Jet Reports set up with Business Central?
Cactoz handles the full setup: installing the add-in, connecting it to your Business Central environment, and configuring report templates around your existing chart of accounts and reporting structure.