DBReport brings accounts data to Excel

Taunton-based Pendragon Systems has produced an Excel add-in designed to improve the management reporting capabilities of Sage and other accounting systems.

DBReport is the brainchild of Jason Raikes, a KPMG-trained chartered accountant with several years’ consulting experience designing and implementing management reporting systems. Having surveyed the available tools – from corporate-level report writers such as Crystal Reports to bespoke reporting packs produced by previous generations of consultants to free-for-all spreadsheet systems – Raikes decided there had to be a better way to get data out of accounting packages.

DBReport is the result: “an add-in with all the functionality of report writers, or more, but purely in the Excel environment”, as he describes it. Priced at £200+VAT per user, DBReport will sit on any database: Oracle, SQL Server, Microsoft Access and anything else with an ODBC driver, he said. An enhanced Consolidation Manger version is available for £500 that will pull in totals from several different accounting systems.

“DBReport is usually aimed at mid-tier organisations that probably have a database application, but aren’t happy with the reporting on it,” Raikes said. Users of the program include a structural engineering firm that uses it to extract montly project P&Ls from an old style ERP/project accounting system.