Intellerator
Business Intelligence For Sage 200
Are you looking to improve your Sage 200 reporting? Meet Intellerator: Microsoft Power BI dashboards for Sage 200 providing powerful, interactive reports of your financial data. Identify trends, spot opportunities, and make informed decisions while incorporating up to date data from other systems. Ditch the PDFs, upgrade to Intellerator today and discover the perfect partnership between Microsoft Power BI and Sage 200.
The Power Of Vision
- Interactively report on Sage 200 - From financials through to commercials.
- Reports across all Sage 200 companies - See all the total over all companies and filter to specific companies.
- Cross system reporting - Report on all your Sage 200 data and also data from other third party systems.
- Dynamic filtering - Filter an entire report just by clicking a drop down or a bar in a chart.
- Drill down - We can see exactly what transactions make up any chart at any time using the transactions table.
- Output to excel - We can output the transactions to excel for further analysis and to amend data via Excelerator.
- Customisable refresh - Refresh manually or on a schedule
- Fully customisable - Contact us now to tailor any reports to your needs
Lenses
Two sides of the same coin
Sales manager can see sales figures and top customers across the company and for each sales rep.
Samuel can only see his sales figures and his top customers.
With Intellerator Lenses, different users access the same link and see only the Sage 200 data that you allow them to see, fully configurable from Sage 200. Imagine your:
- sales reps being able to view only their sales figures
- cost centre managers only seeing their cost centre’s profit and loss statements
- department managers only seeing their department’s nominal transactions
While the financial manager sees the big picture with all data. Say goodbye to different versions of spreadsheets everywhere, and discover a single source of truth with Intellerator.
Incredible Pricing
*Only £15 per user per month
£15 per month gives access to the full Intellerator suite of pre-built dashboards. Discover more about each dashboard below. Volume discounts may be available, enquire now.
See It In action
Our Customers
Feature rich pre-built dashboards
Jump to
Nominal Transactions
- View your Sage 200 nominal transactions across all companies, including current, deferred and waiting nominal transactions.
- At a glance KPIs including:
- Net income, this year vs prior
- Net income over time
- Net assets, this year vs prior
- Income and expenditure by cost centre
- Transaction balance by report categories
- Detailed analysis of:
- Balance by report category, nominal code, cost centre. Department and nominal account.
- A running balance over time. This can be filtered by any of the above.
- In detailed transaction table across all companies, filterable by any of the above.
- Lenses on Department Managers, Cost Centre Managers and Finance Managers.
Financial Statements
- See all profit and loss statements and balance sheets that you have set up in Sage 200.
- Ditch the PDFs and interactively filter on:
- Company
- Financial year and period
- Net assets, this year vs prior
- Department
- Fully configurable: Need to add or remove a report line? No problem, as this dashboard works straight from the financial statement layouts in Sage 200.
- Lenses on Cost Centre Managers, Department Managers and Finance Managers.
Sales
- Sales figures totalled across all companies.
- Sales reps can be set up in Sage 200.
- At a glance KPIs including:
- Total sales
- This period prior year
- Sales by period
- Top 5 sales representatives
- Top 5 customers
- Top 10 product group
- Sales by location
- Detailed analysis of:
- Sales by company
- Sales by product
- Sales by product group
- Sales by representatives
- Sales by customers
- Drill down to individual sales
- Filter any chart by any other. For example, click on a product and instantly see the top customers of that product.
- Lenses on Sales Reps and Sales Managers.
Purchases
- Purchase figures totalled across all companies.
- Buyers can be set up in Sage 200.
- At a glance KPIs including:
- Purchases by period
- Top 5 buyers
- Top 5 suppliers
- Top 10 product groups
- Purchases by location
- · Detailed analysis of:
- Purcahses by company
- Total purchases
- Purcahses by group
- Purchases by supplier
- Purcahses by buyer
- Drill down to individual purchases
- Filter any chart by any other. For example, click on a product and instantly see the top customers of that product.
- Lenses on Buyers and Purchase Managers.
Credit Control
- Your upgraded, fully interactive Sage 200 aged debtors report.
- Uses the ageing periods you set up in Sage 200.
- See the total you are owed over time for each ageing period.
- Works with sales in foreign currencies, including foreign currency revaluations.
- At a glance KPIs including:
- Total owed by period
- By ageing period
- Top 10 customers
- Total owed
- Detailed analysis of:
- Total owed by company
- Total owed by fiancial year
- Total owed by customer
- Total owed by nominal acount
- Drill down to individual sales invoices, receipts and foreign currency revaluations
- Filter any chart by any other. For example, click on a financial period and instantly see the customers that owed the most at that point, for ageing period.
- Lenses on sales reps (account managers) and sales managers.
Payments Control
- Your upgraded, fully interactive Sage 200 aged creditors report.
- Uses the ageing periods you set up in Sage 200.
- See the total you are owed over time for each ageing period.
- Works with sales in foreign currencies, including foreign currency revaluations.
- At a glance KPIs including:
- Total owed by period
- By ageing period
- Top 10 suppliers
- Total owed per ageing period over time
- Detailed analysis of:
- Total owed by company
- Total owed by financial year
- Total owed by supplier
- Total owed by nominal account
- Drill down to individual purchase invoices, payments and foreign currencies revaluations.
- Filter any chart by any other. For example, click on a financial period and instantly see the customer that owed the most at that point, for ageing period.
- Lenses on Buyers and Purchase Managers.
Stock Valuation
- Your upgraded, fully interactive Sage 200 Stock valuation report.
- See your stock valuation trend over time.
- Works with First in First Out (FIFO), Standard and Average costing methods.
- At a glance KPIs including:
- Stock value
- Stock value (current year vs prior year)
- Top 10 product groups by total value
- Top 5 products by total value
- Stock value over time
- Detailed analysis of:
- Stock value by period
- Stock value by product group
- Stock value by product
- Drill down to individual transactions, including changes in the standard cost of stock items where the standard costing method is used.
Contact us now
What is Power BI
Intellerator is built on Microsoft Power BI. Developed by Microsoft, it is the world’s most popular business intelligence and data visualization tool. With its intuitive interface and powerful features, Power BI has become a popular choice for businesses seeking to unlock insights and drive business growth through data.
Interactive Dashboard
With Power BI, you can create interactive dashboards that consolidate data from multiple sources into a single, unified view.
Easy Data Integration
Power BI seamlessly integrates with a wide range of data sources, including databases, spreadsheets, cloud services, and online applications.
Microsoft Fabric
Data analytics for the era of AI. Microsoft continue to make substantial investments into Power BI, releasing new features monthly.
Data Visualization
Power BI enables users to transform their raw data into interactive visualizations, such as charts, graphs, maps and much more.
Mobile Access
Power BI provides mobile applications for iOS and Android, enabling users to access dashboards and reports on the go.
Where to go from here
Discover more about Intellerator
Email us at sales@codis.co.uk or call us on 020 88 610 610 and claim your free Intellerator licence with every purchase of Excelerator.