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…
|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:
“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:
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|