By Grande Afrique Consulting Limited

Continuous auditing.
Control monitoring.
Built around you.

Automate recurring audit tests and monitor controls with GAC Analytics. Customise scripts, business rules and dashboards to your company’s unique needs—while analytics runs on your own local server.

Continuous auditing · Continuous control monitoring · Custom corporate analytics

GAC / ANALYTICS WORKSPACEIllustrative view

From transactions to visibility

Records reviewed12,480Sample dataset
Exceptions flagged24For follow-up
Tests scheduled08Example workflow
TRANSACTION ACTIVITYILLUSTRATIVE DATA
Connect → Analyse → MonitorInsights that prompt action
Read-only source connectionsSeparate analytics processingLocal data storageCompany-specific customisationDirect GAC support
Continuous auditing & control monitoring

Make control testing a routine.
Keep exceptions in view.

GAC Analytics supports continuous auditing and continuous monitoring of controls through scheduled, repeatable analysis of refreshed data. Identify exceptions between periodic reviews and give the right people timely results.

↻

Continuous auditing

Enable internal audit to repeat analytical tests at agreed intervals, examine emerging exceptions and use results to focus further audit work. Retain visibility of exception history and trends.

◎

Continuous control monitoring

Help management and process owners check transactions against defined control rules, approval limits and policy requirements. Surface deviations for investigation and corrective action.

⇢

Automated results delivery

Schedule scripts, present results through dashboards and email outputs to selected recipients. Reduce repetitive manual testing and direct attention to transactions requiring review.

01 / DEFINE

Agree the control

Identify the business rule, required data and exception criteria.

02 / SCHEDULE

Repeat the test

Run validated scripts on refreshed data at the agreed frequency.

03 / REVIEW

See the exceptions

Use dashboards, historical comparisons and emailed results to prioritise follow-up.

04 / IMPROVE

Refine the monitoring

Investigate results and update rules as policies and business risks change.

“Continuous” means recurring testing at the configured extraction and analysis frequency. Data-driven checks support control assessment; investigation and professional judgement remain essential.
Configured for your company

Your processes.
Your rules. Your insights.

GAC Analytics can be customised to meet the unique analytics, auditing and control-monitoring needs of any company, with the technical scope agreed around its systems, data and business requirements.

Start with your highest-priority questions, then expand the scripts and reporting as new needs arise. GAC works directly with your teams to translate policies and control requirements into practical analytics.

Discuss your unique requirements ↗
  • Data connections: configure supported databases, ERP connections and uploads around your environment.
  • Rules and thresholds: tailor scripts to approval limits, policy conditions and exception definitions.
  • Processes and teams: develop tests for audit, finance, risk, compliance, procurement and operations.
  • Dashboards and statistics: choose the measures, comparisons and exception-history views that matter to you.
  • Schedules and recipients: agree testing frequency and who receives the results.
  • Ongoing enhancement: adapt scripts and reporting when systems, policies and priorities change.
Meet the platform

One analytics foundation.
Value across your organisation.

GAC Analytics is a server-based data analytics solution developed and owned by Grande Afrique Consulting Limited. It brings data extraction, repeatable analysis and results delivery into a practical corporate tool.

01 ↗

Connect and consolidate

Bring together database, business-application and file-based data. Connect supported systems or upload Excel, CSV, JSON and Parquet files. Confirm compatibility during scoping.

02 ⌁

Analyse and investigate

Apply configurable scripts to review transactions, identify unusual patterns, reconcile records and test business rules. Extend analysis as your questions and business needs evolve.

03 ◷

Monitor and communicate

Schedule recurring tests for continuous auditing and monitoring. Explore dashboards showing transaction volumes, financial totals, trends, comparisons, exceptions and performance indicators, including the history of exceptions over time. Send results by email to selected users for review and follow-up.

From testing to follow-up

Practical tools for
the complete analytics journey.

Start with ready-made checks, build your own analysis and turn results into monitored exceptions, clear charts and shareable reports—all through a browser.

✓

Ready-made audit checks

Run duplicate detection, reconciliation, ageing, gap analysis, fuzzy matching, outlier tests and completeness checks. Apply Benford’s Law, sampling and segregation-of-duties checks where appropriate.

⌘

Visual tools or custom code

Build queries by selecting tables and columns, reshape results with visual steps, or use SQL and Python for specialist analysis. Save routines for repeat use.

⇄

Repeatable data pipelines

Combine sources, transform data and schedule pipelines. Sequence extraction and analysis jobs, with options to stop or continue when a step fails.

◎

Exception follow-up

Track each finding as open, investigating, resolved, false positive or accepted risk. Record review notes and retain follow-up status across collections using the finding’s defined key.

◷

Alerts that focus attention

Notify selected recipients when findings increase, exceed a threshold or rise by a chosen percentage. Flag checks that have stopped running and notify teams about failed jobs.

↗

Reports ready to share

Export findings to Excel, CSV or PDF and email result files. Share exception summaries, run history and trend reports, with result context recorded in Excel exports.

Dashboards & statistics

See the numbers.
Understand the whole picture.

GAC Analytics dashboards bring a wide range of statistics together: totals, counts, averages, percentages, trends, comparisons and exceptions. Choose bar, line, area, pie, donut, radar or radial-bar charts. Pin selected charts to your overview and let them follow the latest script run, or retain a fixed-run view.

↗

Financial statistics

Track income, expenditure, balances, payment values, budget variances and financial trends across reporting periods.

▥

Transaction statistics

See transaction counts, total and average values, distributions, activity patterns and comparisons by department, branch or category.

◷

Audit, risk & compliance

Summarise test results, exception counts and exception rates. Exception-history dashboards show past results, recurring issues and patterns across reporting periods for management review.

⇄

Procurement & suppliers

Review spend by supplier, purchase category and business unit, together with payment patterns and flagged transactions.

⌁

Operational performance

Present stock movements, service volumes, activity levels, turnaround times and other operational measures available in your data.

◎

Management overview

Bring key performance indicators, period comparisons and emerging patterns into a clear overview for executives and decision-makers.

Explore process dashboard panels ↓
Exception-history dashboards let users look back at exceptions over time, compare periods and identify recurring patterns. Dashboard examples describe configurable reporting possibilities. Actual statistics depend on the source data, agreed calculations and dashboard scope.
Analytics in focus

Every process.
A clearer view of performance.

Explore how dashboards turn detailed records into visible trends, comparisons and exceptions. These illustrative panels show the types of insight GAC can configure around your business data.

ILLUSTRATIVE DATA · NOT LIVE RESULTS
01 / Finance

Income & expenditure

Compare financial movement across periods.

KES 8.4m sample six-month income
JanFebMarAprMayJun
IncomeExpenditure

Main strength: see direction and compare financial performance over time.

02 / Exception history

See recurring patterns

Review the history of exceptions by reporting period.

24 exceptions in sample June run
483944312824JanFebMarAprMayJun

Main strength: reveal whether exceptions are increasing, reducing or recurring.

03 / Procurement

Understand where money goes

Compare spending across procurement categories.

KES 12m sample spend analysed
IT services4.8m
Supplies3.6m
Logistics2.4m
Other1.2m

Main strength: identify spend concentration and focus procurement review.

04 / Control monitoring

Locate exception hotspots

Compare exceptions by process and business unit.

Colour bands: 1–3 low · 4–8 medium · 9+ high exception counts.

Main strength: focus follow-up where flagged activity is concentrated.

05 / Inventory

Make stock patterns visible

Summarise items by movement pattern.

100sample items
65 Active
25 Slow-moving
10 Inactive

Main strength: highlight stock categories requiring operational attention.

06 / Service performance

Compare turnaround times

Review average processing time by business unit.

3.5 days sample overall average
Unit A2 days
Unit B3 days
Unit C5 days
Unit D4 days

Main strength: reveal differences that warrant a closer process review.

All figures are fictional illustrations of configurable analytics. Actual dashboards depend on available data and the agreed implementation. Exceptions require investigation.

The data journey

Analysis happens on a separate server.

Your source systems remain the source. GAC Analytics extracts data and runs analysis on the stored copy.

01 / CONNECT

Business systems

Agree the databases, ERP data or uploaded files required for each analysis.

02 / EXTRACT

Read-only access

Retrieve authorised data without writing changes back to the source.

03 / ANALYSE

Local analytics server

Store extracted data locally and perform tests away from the production environment.

04 / ACT

Results and insights

Review dashboards and emailed results, investigate exceptions and decide the next action.

Analytics processing is separated from production. Extraction timing, data volumes and access permissions are agreed with your IT team to manage source-system workload.
Explore the possibilities

Different teams. Better questions.

Choose a business area to explore an example test and the decision it can support.

Illustrative tests and fictional records. Actual scripts, fields and outputs are configured for each organisation. An exception is a prompt for investigation, not proof of fraud.

Control & confidence

Your environment.
A controlled data journey.

Designed for organisations that want analytics close to their data, with direct ownership of the implementation relationship.

  • Local storage: extracted data is stored on the server where the solution is installed.
  • Read-only connections: source data is accessed for extraction, without source-system alteration.
  • Separate processing: analytical scripts run on the extracted data rather than within production systems.
  • Selected recipients: results are emailed to the users identified for the relevant tests.
Implementation assurance

Build controls into delivery.

GAC works with your business and IT teams to define the controls, responsibilities and acceptance criteria for your deployment.

  • Team-based access and administrator/member roles
  • Encrypted connection credentials and read-only source accounts
  • Data completeness, integrity and reconciliation
  • Script validation and analytical accuracy
  • Activity audit logs and controlled script changes
  • Scheduled backups, recovery planning and support continuity
  • Documentation, user training and handover

The agreed technical design and service scope define how each control is implemented.

Migration & ongoing support

Keep the knowledge.
Move the analytics forward.

Considering a move from Arbutus, ACL, IDEA or another analytics tool? GAC converts your existing client-owned analytics scripts at no additional charge. We assess the scripts, connections and reporting requirements, then plan conversion and validation.

01 / ASSESS

Map your requirements

Inventory data sources, scripts, outputs, users, infrastructure and the controls you rely on.

02 / CONFIGURE

Install and convert

Set up the server, configure connections and adapt scripts to the agreed analytics requirements.

03 / VALIDATE

Reconcile the results

Compare outputs, test completeness and accuracy, and resolve differences before acceptance.

04 / ENABLE

Train and support

Equip users, document routines and agree maintenance, enhancements and response arrangements.

Script conversion is not billed: GAC converts client-owned scripts from Arbutus, ACL, IDEA and other analytics tools at no additional charge. Conversion scope and timing are agreed after assessment, with compatibility reviewed and outputs validated.
Why GAC Analytics

Built around practical analytical work.

A locally developed product with a direct route to the team responsible for delivery, support and enhancements.

↔

Direct product ownership

GAC owns and controls the solution, providing a direct relationship for licensing, renewals, support and product improvements.

⌘

Customised to your business

Tailor scripts, control rules, thresholds, schedules and dashboards to your company’s unique needs. Extend analytical testing across departments as requirements evolve.

↻

More time for investigation

Automate recurring analytical routines to reduce repeated manual work. Use exception-focused outputs and historical trends to prioritise review and follow-up.

Licence-based pricing

Highly competitive licence pricing.
Multiple data sources.

Every GAC Analytics licence includes the full analytics capability: data connections, analysis, dashboards, continuous auditing and continuous control monitoring. You do not need to purchase separate desktop and server analytics licences. Pricing is based on licence quantity, and each licence can connect to multiple data sources.

01

Full capability in every licence

Get the complete analytics capability in each licence, including scheduled testing, dashboards and exception-history reporting. Separate desktop and server analytics licences are not required.

⇄

Connect multiple sources

Each licence can connect to multiple data sources through supported connections.

↗

Request your quotation

Your licence quotation is based on the number of licences, rather than the number of connected data sources. Conversion of client-owned analytics scripts is included at no additional charge.

Request a licence quotation ↗
Questions, answered

Understand the essentials.

Does GAC Analytics support continuous auditing and control monitoring?

Yes. It runs scheduled analytical tests against refreshed data, checks defined control rules, and presents exceptions through dashboards and emailed results. Internal audit can use it for recurring assurance work, while management can use it to monitor controls. Testing frequency is configured to the deployment.

Can GAC Analytics be customised for our company?

Yes. GAC can customise scripts, business rules, thresholds, dashboards, schedules and results distribution around your company’s unique processes and requirements. Data compatibility, implementation scope and acceptance criteria are agreed with your teams.

Is GAC Analytics only for auditors?

No. It supports corporate analytics across audit, risk, compliance, finance, procurement and operations. The analysis is configured to the questions each team needs to answer.

Does it change data in our live systems?

The source connection is read-only. Data is extracted to the local analytics server, where the analytical work is performed on the stored copy.

Which systems and files can it connect to?

Supported connections include SQL Server, Oracle, PostgreSQL and MySQL; Microsoft Dynamics 365 Business Central, NetSuite, Salesforce, HubSpot, Stripe and Zendesk; and files from shared folders, SFTP, Amazon S3, Azure Blob Storage and Google Cloud Storage. Upload formats include Excel, CSV, TSV, text, JSON and Parquet. GAC confirms compatibility and access requirements for your deployment.

Can we see the history of exceptions?

Yes. GAC Analytics includes dashboards showing the history of exceptions, helping users review past results, compare exception volumes across periods, identify recurring issues and understand trends over time.

What statistics can the dashboards show?

Dashboards can show a broad range of statistics, including counts, totals, averages, percentages, trends, comparisons, exceptions and performance indicators across finance, audit, risk, procurement and operations. GAC configures the measures to match your source data and reporting requirements.

Can tests run automatically?

Yes. Tests can be scheduled for continuous auditing and monitoring, with results emailed to selected users. Frequency and delivery arrangements are configured for the deployment.

Can GAC convert our existing analytics scripts?

Yes. GAC converts client-owned scripts from tools such as Arbutus, ACL and IDEA at no additional charge. We assess the scripts, map the required logic and validate the converted outputs. Conversion scope and timing are agreed after review; script conversion is not billed.

Can GAC Analytics add analytics to our existing audit management system?

Yes. If your audit management system does not currently include analytics, GAC Analytics can complement it with data analysis, continuous auditing, control monitoring and exception dashboards. You can retain your existing audit management system and use GAC Analytics alongside it. Any direct integration is assessed and agreed separately.

Do we need separate desktop and server analytics licences?

No. Each GAC Analytics licence includes the full analytics capability, including data analysis, dashboards, continuous auditing, continuous control monitoring and scheduled results delivery. You do not need separate desktop and server analytics licences to access these capabilities. Each licence can connect to multiple data sources; pricing is based on the number of licences purchased.

How is pricing determined?

GAC Analytics is priced per licence, based on the number of licences your organisation purchases. Each licence includes the full analytics capability, without separate desktop and server analytics licences. One licence can connect to multiple data sources, so the number of connected data sources does not determine the licence price. Contact GAC for a quotation for the number of licences you require.

Can users work through a browser?

Yes. GAC Analytics is a web application hosted in your server environment. Users access it through a supported browser. Local accounts, Active Directory and OpenID Connect single sign-on options are documented; the sign-in approach is configured with your IT team.

Can we track what happens to exceptions after detection?

Yes. Exception tables retain findings between runs, show recent trends and changes, and allow each finding to carry a status and review note. Teams can distinguish open investigations from resolved findings, false positives and accepted risks.

Who develops and supports GAC Analytics?

GAC Analytics is developed and owned by Grande Afrique Consulting Limited. GAC provides implementation, script development, training, maintenance and support under the agreed engagement.

Start with your business question

See what your data
could tell you.

Arrange a demonstration or discuss your analytics and migration requirements with Grande Afrique Consulting Limited.

marketing@grandeafrique.co.ke ↗+254 796 024 663+254 729 940 695Enquire on WhatsApp ↗

Please share your business requirements only. Discuss a secure transfer method with GAC before sending operational or confidential data.

Request a demonstration

What would you like to discuss?

Select all that apply.

Opens your email application with your enquiry. Nothing is submitted or stored by this website.