Business Intelligence Centre

A Flexible Excel-based financial reporting tool.

By going ‘Beyond the product’, Unisource is able to offer you an innovative and flexible Excel-based financial reporting software tool for small, medium and large enterprises (SME’s). The Pastel Business Intelligence Centre (BIC) dynamically links to Microsoft Excel – and as long as the information is stored in an accessible database, you can access sales, financials, inventory and purchasing reporting.

Basic Version

Users can help themselves, with just Excel aptitudes as a necessity. The module transports with a mixed bag of helpful administration reports, incorporating Monthly Management Pack (incorporating pay comment and monetary record), Sales, Inventory, Purchasing, and different wise reports. Making your particular reports in Excel has been made basic! 

Following your universal fare you frequently invest time arranging the article, but there’s no straightforward route to recovery this arrangement and connection it to the fare for destiny utilize. The outcome is that you consider yourself designing following every article. The Business Intelligence Centre recoveries the proposed strides for you – so every time, you actually run the article and its mechanically overhauled with your most recent information in the right arrange. 

Advance Version

Skilled IT faculty will be needed to transport the potential that the Advanced form offers. Pastel Business Intelligence Advanced Edition transports with a supplemental device called the Administrator. This gives the user the capacity to provide details regarding any ODBC consistent database. With the Advanced Edition you would be able to utilize more usefulness to accomplish combinations, parcel reporting, planned reporting and substantially more.

Benefits and Features 

Spare endless sums of time each month

One of the most obviously valuable profits of the Pastel Business Intelligence Centre is the speed at which you could probably access your arranged Excel reports. This not just recoveries you time, but in addition gives you “exist” informative content that is far additional valuable beyond “out of date” informative data. That final moment diary no longer effects your Excel reporting. Basically hit the run bind again!

Monthly Financials with drill down to record part

Your monthly financials more often than not elucidate an extensive rate of manual Excel labour. The Pastel Business Intelligence Centre offers a customisable pack which furnishes bore down practicality. Resulting from the fact that its all in one Excel workbook it would be able to be safeguarded and effectively dispersed.

Pastel Business Intelligence Centre On-Line Community for Pastel Cover Customers

As a Pastel Cover client you will consistently have access to a developing accumulation of standard report templates through the Online Business Intelligence Community which might be gained entrance to from within Pastel Business Intelligence Centre.

Close User Empowerment

The Business Intelligence Centre is planned to license closure users skilled in Excel, with an apparatus to hold the plan and arranging time they put resources into making Excel reports. This is unlike an Excel fare where the arranging is lost and should be rehashed inevitably the article is run.

Maximise your backing in Microsoft

Your ensemble as of now puts resources into Excel so verify monotonous Excel assignments are mechanized. Utilize the funds good to go through the Pastel Business Intelligence Centre to develop your base of articles needed for exceptional determination-making.

Comparison of BIC Products 

Unisource is able to offer you an innovative and flexible Excel-based financial reporting software tool for small, medium and large enterprises. The Pastel Business Intelligence Centre dynamically links to Microsoft Excel – and as long as the information is stored in an accessible database, you can access sales, financials, inventory and purchasing reporting.

Features Excel
Management
Reports for
Xpress Start Up
Excel
Management
Reports for
Xpress
Pastel BIC
Standard
Pastel BIC
Advanced
Reports Available
Management Pack Report:
Number of Income Statement Layouts
Number of Balance Sheets Layouts
2
1
10
5
10
5
10
5
Other Reports Available n/a n/a
Dashboard Analysis
Sales Master
Inventory Master
Purchase Master
Ledger Transaction Details
Financial Genie
Financial Ratio Calculator
Dashboard Analysis
Sales Master
Inventory Master
Purchase Master
Ledger Transaction Details
Financial Genie
Financial Ratio Calculator
Formatting & Customization
Distribute information to a Microsoft® Excel®environment
Fully customizable pre-built report templates
Add Pastel fields into reports easily 1
Link to data source and save report changes for future reuse
Unlimited ability to format reports
Customize reports from scratch
Sorting & Filtering
Filter report data
Group and ungroup data in one click
Sort report data
Easily add total and subtotal amounts
Easily convert between summary and detail reports
Ready-to-use filter parameters 2 2
View data in different ways via pre-built Microsoft® Excel® Pivot Tables
Report Automation
Share reports over the network
Ready-to-use reports that automatically link to Pastel Xpress data
Schedule report execution
Ready to use business dashboard for a summary of business KPIs’
Database Connectivity
Connect to the Pastel Xpress database automatically, and access real-time data from source
Automatically refresh report data in user created templates
Report on data from multiple databases simultaneously, including non-Pastel databases
Access all database fields in Pastel Xpress
Security
Report level security
User level security
Securely share reports over the network

1 Limited to a pre-defined set of fields available for each report

2 Limited and non-customizable

FREE 90 DAY TRIAL
The Pastel Business Intelligence Centre is available as an add-on module with Partner and Evolution.
Users have access to a free 90 day trial period from date of installation.

 

Our professional consultants will help you deploy Business Intelligence solutions that are simple.

Return to top of page thank you.