About Sage 100 Contractor Intelligence Reporting

Sage 100 Contractor integrates with Sage Intelligence Reporting, a Microsoft Excel-based business intelligence reporting tool designed to help you to make timely, informed decisions for your business, while reducing spreadsheet chaos.

You use Sage Intelligence Reporting to create financial reports and analyze Sage 100 Contractor data using the familiar Microsoft Excel application. It includes the following modules:

  • Report Manager. Use this module to create and edit reports using Sage 100 Contractor data containers, and to run reports.

  • Report Designer. Use this module to create new financial reports. You can easily:

    • "Drag and drop" columns and predefined calculations.
    • Create additional calculated fields using the Formula Builder.
    • Change amounts dynamically when forecasting and budgeting.
  • Report Viewer. Use this module to view existing reports.
  • License Manager. Use this module to enter or edit Sage Intelligence Reporting module licenses.
  • Security Manager. Use this module to define security for reports and users.
  • Connector. Use this module to connect to unlimited ODBC data sources or additional Sage 100 Contractor companies.

Important! The first time you run Sage Intelligence Reporting, you must log in as the Windows administrator. A user with Windows administrator privileges must register the ActiveX component, BICore.exe, that Sage Intelligence Reporting requires. To register this component, open any Sage Intelligence Reporting module. Once the component is registered, other users can use Sage Intelligence Reporting.

The following predefined reports come with Sage Intelligence Reporting:

  • 2-3 Income Statement: 21 – Income Statement
  • 2-3 Income Statement: 31 – Income Statement ~Period and YTD
  • 2-3 Income Statement: Dept. Income Statement ~Actual/Budget Comparison
  • 3-1-3 Receivables Aging: 26 – AR Invoice Aging ~Land
  • 4-1-3 Payable Aging: 26 – AP Invoice Aging ~Land
  • 6-1-1 Job Status Report: 31 – Job Status Report ~Land
  • 6-1-12 Committed Cost Report: 31 – Committed Costs ~Land
  • 6-1-12 Committed Cost Report: 61 – Committed Costs ~With Cost to Complete
  • 6-1-13 Home Builder Reports: 21 – Committed Budget/Cost Variance~by Cost Code
  • 6-1-13 Home Builder Reports: 51 – Gross Profit ~by Job
  • 6-1-4 Job Summary Report: 21 – Job Cost Summary
  • 6-1-4 Job Summary Report: 51 – Job Billing Summary
  • 6-1-4 Job Summary Report: 71 – Job Income Statement
  • 6-1-7 Over/Under Billing Report: 31 – Over/Under Billings ~Extended
  • 6-1-8 Bonding Report: 21 – Bonding Report
  • 6-6-3 Purchase Order Audit: 31 – Purchase Order Audit ~Land
  • 6-7-4 Subcontract Audit: 31 – Subcontract Audit ~Land
  • 10-1-5 Gantt Chart: 21 – Gantt Chart
  • 11-1-2 Service Invoice List: 91 – Estimated Work Order Profitability
  • 11-1-3 Service Aging: Service Invoice Aging ~Land

For information on using Sage Intelligence Reporting, see the Sage Intelligence Reporting help and supporting documentation.

You can also visit the following websites for more assistance: