Reports you get with Sage 100 Evolution Intelligence Reporting

With Sage 100 Evolution Intelligence Reporting you get a number of ready-to-use reports that give you immediate insight into and across your business. Delivered in the familiar environment of Microsoft Excel, the reports are fully customizable, and flexible with drill-down capabilities. You can access them at any time or have them delivered, real-time, from Intelligence Reporting software to Excel, in the format of your choice. It’s as simple as that!

In addition to the ready-to-use reports you get with Intelligence Reporting, we provide you with a library of templates that you can use to create custom reports that meet your specific needs. Each template, which is designed based on your feedback, provides a framework that you can populate with the information you need. Take a look at the templates.

Open all Close All

Open Close
All Financial Reports
  • This Financial Report template offers a number of different report layouts to generate comparative balance sheets and/or income statements for any specified financial year, period, quarter, and budget.
  • The layouts are automatically generated, grouped, and subtotaled by account group. 
  • It is possible to drill down to the GL Transaction details for any of these accounts.
Open Close
Financial Report Designer report
  • The Report Designer report enables users to create financial layouts based on their Sage 100 data using net changes and balance (YTD) per General Ledger Account number per financial period for the financial years selected as parameters when running the report. 
  • The revamped report designer includes a Task Pane and enhanced Layout Generator, both utilizing a powerful in-memory engine, empowering users to take control of all design aspects of their reporting layouts. Income Statement and Balance Sheet layouts may be automatically generated once the user defined rows have been configured
Open Close
Income Statement - Actual vs. Budget

Displays balances per General Ledger account number per financial period for the current financial year, displaying actual, budget and prior year, plus YTD.

Open Close
Income Statement – Actual vs. Prior

Displays balances per General Ledger account number per financial period for the current financial year, including actual and prior financial year displayed monthly and the YTD comparison.

Open Close
Income Statement - Current vs. YTD

Displays balances per General Ledger account number for the current period vs. YTD vs. Prior Year.

Open Close
Balance Sheet – Actual & Prior YTD

Displays balances per General Ledger account number per financial period for the current financial year and previous financial year.

Open Close
Sales Analysis
  • Displays pertinent sales information including average selling unit, freight amount, sales tax, total costs, total sales and gross profits by customer and line description. 
  • Displays Gross Profit $ Amount and Gross Margin % grouped by Customer and Line Description with an option to select a month and year at run-time. 
Open Close
Purchase Analysis
  • Displays Quantity purchased, Purchase Amount grouped by Vendor per Product/Item ID for a selected date range. 
  • Lists relevant purchase cost information by supplier and item number for any given date range and can be filtered by Item ID, Line Description, Vendor ID, Vendor Name and Transaction Type.
Open Close
Dashboard Analysis
  • The Dashboard Analysis report template displays summarized Financials and Customer Sales, Product Sales for the current month and YTD. 
  • Showing Top Customers and Items and Bottom Items. It contains both text and graphics to help with daily and long-term planning. 
  • In addition, comparative Profit and Loss figures are displayed for both the current month and year-to-date figures. 
  • This report allows you to easily drill-down to get further insights into the summarized data.

Get Intelligence Reporting

Sage Intelligence Reporting is available for Sage 100 Evolution. To purchase Intelligence Reporting, get in touch with our sales team.