Sage Accpac Intelligence

Key business information on a single page

Sage Accpac Intelligence empowers you to quickly and easily obtain the information you need for operations and strategic planning from your Sage Accpac solution. Effortlessly create reports and analyze data, utilizing the familiar Microsoft® Excel® application.

With Sage Accpac Intelligence you can spend more time focusing on information analysis and interpretation, and less time pulling the data together. Finally a Business Intelligence strategy that is fast and easy to deploy and cost-effective.

The benefits of Sage Accpac Intelligence include:

• Access to business-critical information when you need it
• Simplified reporting through seamless integration with Sage Accpac
• Customizable dashboards to transform your data into strategic decision-making intelligence
• Insight into your business through multi-dimensional analysis of your data
• Multi-currency and multi-company capabilities to give you the competitive edge to succeed in today’s fast-paced global marketplace
• Comprehensive security at variable levels, protecting your important business intelligence from unauthorized access or manipulation

Sage Accpac Intelligence is bundled with Sage Accpac ERP version 5.6. It ships with 12 pre-defined reports and 3 data cubes to get you up and running immediately. All standard reports and cubes can be copied and/or modified according to your unique business needs.
 

Dashboard Analysis
The Dashboard Analysis report contains a one-page summary of key business
information. The report features “Top N” Reporting on customers, items, and expenses,
and 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 from the start of the current financial year.

Financial Analysis Reports
Three powerful financial reports are available out of the box. Each of these reports
generates comparative balance sheets and/or income statements for any specified
financial year, period, quarter, and budget. The Income Statement and Balance Sheet layouts are
automatically generated, grouped, and subtotalled by mapped financial categories or by Accpac
account group. These reports are readily customizable within Microsoft Excel. It is possible to drill
down to the GL Transaction details for any of these accounts.

General Ledger Transaction Details
This fully customizable report displays the account transaction details and relevant date,
reference, description, and amount totals. It is possible to transform this report into a
monthly trial balance by simply manipulating the Pivot Table within Microsoft Excel. Additional
elements can be added to the pivot table for further analysis.
 
Inventory Master Report
Displays item cost and quantity information over any given date range, as well as
relevant item location details. The report can easily be filtered by item number and
location, or additional elements can be added to the pivot table for further analysis.

Purchase Master
This report lists relevant purchase information by vendor and item number for any given
date range. The report can be filtered by vendor, item number, or unit of measure. It is
possible to add additional elements to the pivot table for further manipulation and
analysis.
 
 
Sales Master
This report highlights pertinent sales information including item sales quantities, costs,
and gross profits by customer and product. Similar to the previous reports, additional
elements can be added to the pivot table for further manipulation and analysis.
 
 
Inventory Analysis Cube
This report allows you to analyze year-to-date stock-on-hand quantities, purchase and
sales order quantities, and actual stock values by inventory group. You also receive the
ability to perform multilevel drill-down into the required level of detail and a Top N Items
graph.
 
 
Sales Analysis Cube
This report allows you to analyze sales quantities, gross profits, and amounts by
customer, product, and salesperson over multiple fiscal/calendar years. It also provides
the ability to perform multilevel drill-down into the required level of detail and includes
Trend Analysis Graph.
 
 
Financial Analysis Cube
This report allows you to analyze G/L accounts by Account Group and segment over
multiple fiscal years. It also enables multilevel drill-downs into the required level of detail
and includes a Trend Analysis Graph.