Save content
Have you found this content useful? Use the button above to save it to your profile.
AIA

Sage releases Group Consolidation module

by
26th Mar 2010
Save content
Have you found this content useful? Use the button above to save it to your profile.

Sage’s Accountants Division has created a Group Consolidation module that takes advantage of technical advances that will feed through to the company’s family of accounts production products.

Currently available for Sage Accounts Production Advanced (SAPA), the Sage Group Consolidation tool is able to import trial balances from SAPA or Excel spreadsheets. When adjustments are made in the consolidation module, the information will flow through to SAPA. Then, if the single entity files are subsequently adjusted, the changes will synchronise with the Group Consolidation module. “Now you simply update the single entity file and the information goes back to the group consolidation and flows straight through to the extended trial balance and working papers,” explained Sage accounts production domain specialist and qualified accountant, Darren Ingles.

The group consolidation module comes with a Group Cashflow working papers utility for those who need to produce cashflow statements - as required by the IFRS for SMEs – and will store permanent data and working papers for use in subsequent years’ consolidations.

A built-in “Scratchpad” provides Excel-like functionality that allows users to import or cut any prior year consolidation schedules and workings into the program. Said Ingles: “If you make a mistake in an Excel file it can be like finding a needle in a haystack. We’re trying to avoid going outside the family so users can continue to do what they want, but not lose efficiency of SAPA.”

While the requirements for more companies to file group accounts and cashflow statements to comply with the IFRS for SMEs was a primary driver behind the project, the new module will also take advantage of inline XBRL (iXBRL) output provided a new Interactive Financial Statements reporting engine due in the next version 11 release of SAPA in November.

The module was developed in close consultation with some of the Accountants Divsion’s larger customers and has been put through its paces by a group of beta test users since last summer. So far, ten of them have gone on to purchase the module, said Inglis.

In previous conversations with AccountingWEB, Sage Accountants Division head of R&D Ben Bishop has explained how the company has been re-engineering the Sage Practice Solution. Under this refurbishment programme, Sage’s three accounts production packages (Sage Instant Accounts Production, Sage Accounts Production and SAPA) are slowly evolving towards a single code base. As part of the transition, a data translation layer codenamed “Kimono” handles the import and export of data between the three different applications as well as Sage Accounts 50 and the new consolidation module, which will eventually support all three accounts production products.

Simon Taylor, senior product development manager for Sage’s accounts production products exlplained that redesigning the products so they are eventually driven by the same program code means that users will be able to continue with their current products, but take advantage of the new reporting and efiling tools as they emerge. The differences between the products will then be defined by the accounting standards and final accounts formats they support.

The Kimono data later has also made the products “database agnostic”, he added, so it is now quite straightforward for Sage to adapt its accounts production for Microsoft SQL Server, MySQL and other relational database management systems.

Pricing for the new module has yet to be confirmed.

Replies (1)

Please login or register to join the discussion.

avatar
By User deleted
28th Mar 2010 11:33

Can they spell technical

What a joke coming from Sage '.. takes advantage of technical advances ..'

and as for '.. Sage’s three accounts production packages (Sage Instant Accounts Production, Sage Accounts Production and SAPA) are slowly evolving towards a single code base ..' - presumably this is an admission that their systems are so fragmented that they don't all work from the same code. Yet another little howler emerging after 20-30 years of flogging their wares to the public.

[removed by mod] - it just goes to reiterate what many have been saying for some time Sage is a marketing company and NOT an IT one

[removed by mod for being unnecessary]

Thanks (0)