Business Analysis Software

In accountsIQ the GL Code structure has been very carefully designed to allow for (amongst other things) efficient database management, group company consolidation functionality, multi jurisdiction reporting and unique GL coding for multiple entity businesses. For reporting on the GL codes there are over 250 pre-defined reports built into the system, and you can also customise and create your own reports. However, the SQL language that hosts the database also allows for further functionality on reporting.

Most accountancy and Business Intelligence systems run reports based solely on GL codes. This has the disadvantage of requiring extensive numbers of GL Codes when the corporate structure becomes more complex with varying Locations and Product lines. For example, a Company that operated in several locations with varying Product Lines will be required to have a separate GL Code for each office and each Product Line should they wish to have the ability to report by Sales Office or by Product. This can quickly create a vast amount of GL Codes, which makes the data entry more complex (and subject to human error) and puts strains on the database and thus can affect system performance. It also makes the GL structure complex hindering the Group Consolidation functionality.

AccountsIQ separates the Business Analysis coding structure away from the GL coding structure by allowing you to create up to 6 Analysis Groups. Each Analysis Group can then have any number of members within them (known as Analysis Codes). For example, if one Analysis Group is defined as Location, you can then have any number of Locations (individual Analysis Group Codes) within this Group. An example of this is set out below where Branch, Department, Customer Type and Product Category are the Analysis Groups and the Analysis Group Codes are under each Group Heading:


You can then use the Analysis Groups and subsequent Analysis Group Codes to create an individual Analysis Code for each and every transaction. For example:


In this example when the Central Branch makes a Sale to a Retail customer the Analysis Code for that transaction becomes “CE-SA-RE”. Obviously this Analysis Code can have up to 6 elements, each of which is a unique reference key when stored within the database. Therefore, every transaction within the database will have the GL Code, Analysis code and 6 unique elements of the of each Analysis Group and subsequent Group Code, giving a total of 8 separate access keys, each of which can be used to build queries for reporting purposes. As the transactions are entered all that is required is the GL Code and the Analysis Code and many of the Analysis Codes can be presented as inherited default codes from master data records (which can be over-written if required).

Analysis Groups and Analysis Codes allow you to define what you want to analyse. They are the tool that essentially allows you to make any type of reporting of Business Analytics possible (Key Performance Indicators etc). You don’t necessarily need to understand the methodology (as it is quite complicated) – all you need to understand is the functionality and reporting possibilities are infinite – a truly unique functionality of AccountsIQ made possible by the underlying database design of the system. This can then be presented in a custom built dashboard that easily presents the data in an intuitive manner.

Once you have your analysis groups and codes in place you can then report, in real-time, on these statistics – in addition to the standard reports available within accountsIQ – of which there are already 200 pre-defined reports available. You can then customise your dashboard and view the results as you wish…

 3  AP-Dashboard

Additional Features:

Multi-Company with Group Consolidation (inclusive of Multiple Currencies) Inter-Company Transactions & Postings
Multi-Jurisdiction Tax Multi-Currency with Revaluations
Multi-Location Accounting Full Integration with many and increasing No. of  POS Solutions
Multiple Profit Centre/Cost Centre Analysis and Reporting Project & Job Accounting
Automated Bank Reconciliation eBanking Integration & On-Line Payments
Many Standard Dashboards and also User Designed Dashboard Development Tools Fully “White Label” & “Own Brand” the System as your own
Incoming Supplier Emailed & Scanned Invoices Automated Input & Data Capture Comprehensive Purchase Order, Purchase Invoice and Purchase Invoice Approval Workflow procedures
Customisable Chart of Accounts Customisable P & L and Balance Sheet Reporting
General Ledger Drill Down Explorer Transaction Browser with Powerful Navigation features
Client Company and User Administration & Control Layer User Definable Menus, Nomenclature and Permissions
Company Setup Wizard and Company Templates for US, UK, Aus & Irl, etc. Extensive On-Boarding of Current and Historical Data
Document Management/Paperless Office Bulk Emailing of Documents (Statements, Invoices, etc.)
Comprehensive Reporting Facilities Business Intelligence Software Integration Facilities
Extensive Data Export/Import Tools & Facilities Excel Add-in for Data Extraction, Reporting and Charting
Worldwide coverage with Tier 4 Datacentre Server Infrastructures located in USA, UK and Australia Individual Separate Databases for each Client Company(ies)
Comprehensive Sales Ordering, Sales Ledger, Purchase Ordering and Purchase Ledger Modules, As well as Inventory Management, General Ledgers, Departmental Ledgers, Banking Modules
Budgets and Revised Budgets Cash Flow Management & Reporting
Time Tracking facilities Excel Integration
Full set of “How To” Articles complements On-Line Help & Documentation On-Line Audit Trail Enquiry and Reporting (inc. “System Changes” tracking)

AccountsIQ uses the Software as a Service (SaaS) commercial model whereby all operational Client services are provided for a single low monthly usage Fee. This includes provision of all the required Server Processing and Storage infrastructure hosted in the highest security Tier IV Datacenters, all Databases, Application Software and Upgrades, Application Support, Infrastructure Management, Backups, Security patches, 24/7 operation with access from anywhere in the world and with 99.98% uptime. The infrastructure and service is completely scalable and can be expanded as your Group of Companies expand, continue to grow and prosper.

Our Group Company Clients:

Group Consolidation Clients

“We are impressed with the reporting capabilities of accountsIQ, and with the support we got from the accountsIQ team in implementing the new system.

A cloud solution makes so much sense for a multi-location business like ours. We now have a strong foundation on which to manage and grow our operations and develop our franchise model, while maintaining tight control .”

Barry Kehoe, Chief Financial Officer of Insomnia  

“As part of our strategy as outsourced accounting providers,  we realised that moving to the cloud to service our client base was essential.  AccountsIQ is now an integral part of our offering.  Both staff and clients really enjoy using the software and it serves a very diverse range of clients both in terms of industry and scale across multiple jurisdictions.” 

Gerry McNally – Owner of MBSL

Case Studies: Read our Case studies here.

Read some of our articles about Cloud Accounting:

An Introduction to the Cloud

A look at Cloud Security

Analysing the cost savings of Cloud Computing

Cloud Accounting: Radically changing the way we work

Download our Group Company Accounting Brochure:

Cloud Accounting for Group Companies

For more information, or to book a demonstration of the system, please contact us here.

Request A Demo View Video