How to use Sage 100 Business Insights Dashboard for better reporting visibility 

Organizations often have the information they need inside their ERP system but struggle to present it in a format that supports quick, informed decisions. Employees may rely on printed reports, spreadsheet exports, or multiple screens to understand receivables, payables, sales, cash flow, and financial performance. 

Sage 100 Business Insights Dashboard provides a more visual way to access this information. The dashboard displays charts, tables, financial summaries, and operational metrics directly within the Sage 100 Information Center. Instead of running a report every time they need an update, users can review selected performance indicators when they enter the system. 

The dashboard does not replace every reporting tool available for Sage 100. However, it can provide executives, accounting teams, sales managers, and operational users with a useful starting point for monitoring business performance. By configuring the dashboard for different roles, organizations can make relevant information easier to find while limiting unnecessary data and screen clutter. 

Table of contents

• What is the Sage 100 Business Insights Dashboard?
• How to activate the Business Insights Dashboard
• Configuring dashboards for different users
• Using dashboard drill-down capabilities
• Managing dashboard data and refreshes
• When the built-in dashboard is the right reporting tool
• Other Sage 100 reporting options to consider
• Choosing the right Sage 100 reporting approach
• How Trim-Tex improved reporting and visibility with Sage 100
• Improve Sage 100 reporting with experienced guidance
• Frequently asked questions about Sage 100 Business Insights Dashboard

What is the Sage 100 Business Insights Dashboard? 

The Business Insights Dashboard is a native Sage 100 reporting feature that presents selected ERP information through charts, tables, summaries, and analytical views. It appears within the Sage 100 Information Center and can be configured to display different information for different users. 

The available dashboard elements are preconfigured by Sage and draw information from the organization’s Sage 100 database. Depending on the modules and data being used, the dashboard can display information related to accounts receivable, accounts payable, purchasing, sales, cash flow, budgeting, and financial statements. 

Common dashboard components include: 

• Accounts receivable aging analysis 
• Accounts payable aging analysis 
• Cash requirements 
• Top customers and vendors 
• Sales by division or product line 
• Balance sheet summaries 
• Income statement summaries 
• Budget comparisons 
• Financial and solvency ratios 
• Cash flow projections 

These components give users a high-level picture of current activity. The dashboard is particularly useful when someone needs a quick overview rather than a highly formatted or deeply customized report. 

Because the dashboard is available within Sage 100, users can review the information without moving to a separate reporting environment. This can help make reporting more accessible to employees who may not regularly build reports or work directly with database queries. 

How to activate the Business Insights Dashboard

Before the dashboard can be configured for individual users, Business Insights must be activated for the applicable Sage 100 company. 

Activation is completed through Company Maintenance. Users who do not have permission to access Company Maintenance will need assistance from a system administrator or another authorized user. 

The general activation process includes: 

1. Open the Business Insights section from the Sage 100 module menu. 
2. Select the Dashboard option. 
3. Follow the prompt indicating that Business Insights has not yet been activated. 
4. Open Company Maintenance. 
5. Select the option to activate Business Insights. 
6. Confirm the activation and return to the dashboard setup. 

Once the feature has been activated, the dashboard setup wizard can be used to configure company-level settings. These settings may include the company name shown on the dashboard, an organization logo, the number of segments displayed in pie charts, and the number of detail lines displayed in tables. 

Administrators can also determine how dashboard data should be refreshed. For example, Sage 100 can prompt users to update the dashboard, automatically generate updates when the page is opened, or refresh information according to an established interval. 

Organizations should consider how often the underlying information changes when selecting a refresh approach. A dashboard that is used to monitor collections or daily sales may need to be updated more frequently than one used primarily for periodic financial review. 

Configuring dashboards for different users

One of the most practical features of Sage 100 Business Insights Dashboard is the ability to configure what each user sees. A single dashboard design is unlikely to be relevant to every department, so role-based configuration can make the feature more useful. 

An accounts receivable employee, for example, may need immediate access to customer balances, aging information, and top customer activity. A controller may be more interested in cash flow, balance sheet information, income statement summaries, and budget comparisons. 

When configuring the dashboard, administrators can select the appropriate Sage 100 user and determine which dashboard elements should be displayed. They can also control the order in which those elements appear. 

Potential role-based configurations include: 

• Accounts receivable: Receivables aging, top customers, customer balances, and sales activity 
• Accounts payable: Payables aging, cash requirements, top vendors, and purchasing information 
• Sales management: Sales by division, sales by product line, top customers, and revenue trends 
• Financial management: Balance sheet summaries, income statement details, budget comparisons, financial ratios, and cash flow 
• Executives: A combination of high-level financial, sales, and operational indicators 

Administrators can also decide whether users are allowed to modify their own dashboard layout. When this option is enabled, users can rearrange, minimize, or hide dashboard components based on their preferences. 

Giving users this flexibility may improve adoption, particularly when employees want to prioritize the information they review most often. However, organizations may choose to maintain tighter administrative control when dashboard visibility is connected to internal reporting standards or data-access policies. 

The goal should be to provide enough information to support the user’s responsibilities without filling the screen with reports that are not relevant to their role. 

Using dashboard drill-down capabilities

A dashboard is most valuable when it helps users move from a summary to the underlying information. Sage 100 Business Insights Dashboard supports this by allowing users to drill into certain records and reports directly from the dashboard. 

For example, a user reviewing the top customers section can select a customer and open the related customer record. This allows the employee to move from a visual summary into more detailed information without manually searching for the account. 

Drill-down capabilities can help users: 

• Investigate a customer balance or aging concern 
• Review activity associated with a top customer 
• Open supporting customer or vendor records 
• Move from summarized financial information to additional detail 
• Research exceptions identified through a chart or table 

This connection between the summary and the underlying Sage 100 records makes the dashboard more than a static display. It can become an entry point for reviewing business activity and following up on items that require attention. 

Organizations should still validate how individual dashboard elements behave in their environment. The available drill-down options may depend on the dashboard component, user permissions, configured modules, and the underlying data. 

Managing dashboard data and refreshes

A dashboard is only helpful when users understand how current the displayed information is. Sage 100 provides several options for generating and refreshing dashboard pages, but organizations should establish a consistent approach. 

Administrators can configure the system to prompt users for dashboard updates, generate information when the dashboard is opened, or manage updates manually. Users may also be able to start an update directly from the dashboard. 

The right approach depends on factors such as: 

• How frequently transactions are entered 
• How quickly managers need updated information 
• The size of the Sage 100 database 
• The number and complexity of dashboard components 
• The reporting responsibilities of each user 

A finance leader reviewing monthly results may not need continuous refreshes. In contrast, an accounts receivable team monitoring collections may need more frequent updates throughout the day. 

Users should also understand that some dashboard components require additional setup. Cash flow projections, for instance, depend on the appropriate general ledger accounts being identified for cash flow analysis. If the chart of accounts is not configured correctly, the cash flow section may not populate as expected. 

Before relying on a dashboard for operational or financial decisions, organizations should confirm that the relevant source data, account mappings, permissions, and update settings have been properly configured. 

When the built-in dashboard is the right reporting tool

Sage 100 Business Insights Dashboard works well for users who need immediate, visual access to common business metrics. It is relatively straightforward to configure and does not require the organization to deploy a separate business intelligence platform. 

The dashboard may be appropriate when an organization needs: 

• A quick snapshot of receivables, payables, sales, or financial information 
• Role-specific reporting views for Sage 100 users 
• Charts and tables displayed inside the Sage 100 Information Center 
• Basic drill-down access to supporting records 
• A reporting option that can be implemented without extensive development 
• A visual supplement to existing operational reports 

The dashboard is especially useful for employees who want a consistent overview each time they open Sage 100. It can reduce the need to repeatedly navigate through menus or run the same reports for routine monitoring. 

However, the built-in dashboard may not support every analytical, visualization, or data-combination requirement. Organizations with more complex needs may need to use it alongside other Sage 100 reporting tools.

Other Sage 100 reporting options to consider 

Sage 100 supports several reporting tools beyond Business Insights Dashboard. The appropriate option depends on whether the organization needs operational lists, financial statements, customized forms, advanced analytics, or information from multiple systems. 

For a broader overview of these capabilities, explore the ultimate guide to Sage 100 reporting and analytics.

Crystal Reports 

Crystal Reports is used for many standard Sage 100 reports and forms. Organizations can modify existing reports or build reports using Sage 100 tables. 

It is suitable for formatted reports, invoices, forms, operational documents, and reporting requirements that need precise control over layout and presentation. More complex reports may require knowledge of the Sage 100 database structure and Crystal Reports development. Users can also export standard or Crystal Reports from Sage 100 to Excel when they need to further analyze, format, or share report data.

Business Insights Explorer 

Business Insights Explorer provides customizable views of Sage 100 information. Users can filter, sort, group, and reorganize data based on their needs.

Explorer views are helpful for users who want to analyze detailed records or export information to Excel. They often provide more flexibility for transaction-level analysis than a high-level dashboard.

Advanced Lookup Engine 

The Advanced Lookup Engine allows users to customize lookup lists and create more useful record searches. Although it is not a full business intelligence platform, it can improve how users find, filter, and export information from Sage 100. 

Sage Intelligence Reporting 

Sage Intelligence Reporting uses Excel as the reporting interface and is commonly used for financial reporting. Organizations can create reusable templates, update reports with current Sage 100 data, distribute reports, and provide access through viewer licenses.

It is often appropriate when finance teams want to continue working in Excel while reducing manual data extraction and report preparation.

Sage Data and Analytics 

Sage Data and Analytics is a web-based analytics option that can provide more configurable dashboards, charts, and reporting capabilities. Data is synchronized from Sage 100 into an analytics environment where users can review and present information through predefined or customized views. 

This option may be useful for organizations that require broader analytical capabilities than the native dashboard provides. 

Choosing the right Sage 100 reporting approach

Selecting a reporting tool should begin with the business questions users need to answer. Starting with the technology can lead to reports that look polished but do not support meaningful decisions.

Organizations should evaluate who needs the information, how often it must be refreshed, how much detail is required, and whether the report needs to combine data from multiple sources.

The native Business Insights Dashboard may be sufficient when users primarily need a quick visual overview. Business Insights Explorer or the Advanced Lookup Engine may be more appropriate for detailed list analysis. Sage Intelligence can support Excel-based financial reporting, while Sage Data and Analytics may be better suited to more advanced dashboards and cross-functional analytics.

In many organizations, these tools are used together. The dashboard provides the initial snapshot, Explorer views help users investigate detailed activity, and financial or analytics platforms support more structured reporting.

A reporting assessment can help identify gaps, eliminate redundant reports, and match each requirement with the appropriate Sage 100 tool.

How Trim-Tex improved reporting and visibility with Sage 100

Trim-Tex Drywall Solutions, an Illinois-based manufacturer of drywall products and accessories, had used Sage 100 for more than 25 years. As the company expanded into a 220,000-square-foot facility, its reporting processes and disconnected departmental systems were no longer keeping pace with its growth.

Production, maintenance, and front-office teams often worked in separate systems and processes. This made reporting time-consuming, reduced visibility across departments, and made it more difficult for employees to collaborate using consistent information.

Trim-Tex partnered with Rand Group to expand its use of Sage 100 and align its business applications more closely with its operational needs. The project included implementing and configuring several integrated Sage solutions:

• Sage Intelligence to improve budgeting, financial reporting, and company-wide visibility
• Sage CRM to provide additional support for the sales team
• Sage Production Management to improve cost tracking and provide more timely inventory and production data

By connecting these tools with Sage 100, Trim-Tex created a more centralized reporting environment and reduced the information silos that had developed across the organization. Teams gained improved access to operational and financial information, supporting better communication and more informed decision-making.

The project helped Trim-Tex reduce manual work, optimize inventory reporting, save hundreds of thousands of dollars in accounting fees, and support fivefold company growth. Sage 100 became a central point of access for reporting across the organization rather than a system used primarily for basic accounting tasks.

As Trim-Tex Controller Martha Kinzel explained, “Sage today is an integral part of our business.”

The Trim-Tex experience shows how Sage 100 reporting can extend beyond a single dashboard. By combining reporting, production management, CRM, and other connected tools, organizations can improve visibility across departments and support continued growth.

Read the full Trim-Tex Sage 100 case study to learn how the company improved reporting, inventory visibility, and collaboration while supporting continued growth.

Improve Sage 100 reporting with experienced guidance

Sage 100 reporting works most effectively when the technology is aligned with the way employees manage financial, operational, and customer information. Simply enabling a dashboard does not ensure that users will see the right metrics, understand the data, or trust the results.

Through its Sage ERP consulting services, Rand Group helps organizations evaluate how information is captured, structured, and reported across Sage 100. Our consultants can configure Business Insights Dashboard for different roles, review user permissions, improve refresh processes, and help determine which dashboard components are most relevant to each department.

When built-in dashboard reporting does not fully meet an organization’s requirements, Rand Group can help extend the reporting environment through Business Insights Explorer, Crystal Reports, Sage Intelligence Reporting, Sage Data and Analytics, and other Sage-compatible reporting tools. This allows organizations to choose the appropriate tool for each reporting need instead of forcing every requirement into a single solution.

Rand Group’s Sage team also brings practical experience in Sage 100 consulting, development, support, and process improvement. That broader perspective is important because reporting challenges are often connected to data quality, account configuration, inconsistent processes, or system design—not just the report itself.

By reviewing both the reporting requirement and the underlying business process, Rand Group can help organizations build a more reliable reporting environment that supports day-to-day decisions and longer-term planning.

Frequently asked questions about Sage 100 Business Insights Dashboard

Next steps 

Effective Sage 100 dashboard reporting begins with understanding which information each user needs, how current that information must be, and whether the built-in dashboard can support the organization’s reporting requirements.

Review your current dashboards, permissions, refresh settings, data quality, and reporting processes to identify gaps or unnecessary manual work. This assessment can help determine whether the native dashboard is sufficient or should be supported by additional Sage 100 reporting tools.

Contact Rand Group to schedule a Sage 100 reporting consultation. Our team can help evaluate your current environment and recommend a practical reporting approach aligned with your users, processes, and business goals.