Tag Archive: excel


Microsoft Excel is the universal language of business and accountants and most decision-makers in small to mid-sized businesses use ‘the king of spreadsheets’ in some way for reporting. In fact, research analyst Gartner has conceded that “Excel is still the number one reporting tool”[1]. Why then, would you want or need to use Sage Intelligence, a Business Intelligence (BI) tool, and not just Excel for your business reporting?

Let’s begin by answering this question with some more questions: Can you say with conviction that you have a clear view of your company’s performance? Do you have visibility of MTD and YTD sales year on year? Can you see, whenever you want to, how your profitability or cash flow is tracking? How about top 5 customers, expenses, or salespeople

To read more: Click here

by Michael Brennan

Sage has been carefully listening to its global market for Sage ERP X3 with regards to feedback and requests on the topic of Financial Reporting and is already making progress on integrating a powerful and flexible reporting technology based on cutting edge BI technology. The Sage ERP X3 core product team in France has embarked on a strategic partnership with our team with the intention of providing a modern Excel-based financial reporting designer and tools.

We have been in the business of offering robust Excel-based business intelligence tools for 11 years and have been working on Sage ERP products since 2005. Sage France’s move to collaborate closely with our team, mainly based in South Africa, is well aligned with Sage Group’s core strategy of consolidating group assets across regions and presents an exciting roadmap of consistent product and service offerings globally.

As global market BI market trends continue to evolve we have been investing heavily in new advanced technologies to power our next generation offerings and are pleased to announce Sage ERP X3 version 7 will include fully integrated financial reporting capabilities based on its next generation In-Memory Database BI Platform codenamed ‘LIME’. This new column based database platform has been engineered from the ground up to cater the needs of tomorrow’s businesses with a core focus on high performance, flexibility and great user experience. The new platform is able to accelerate performance by pre-calculating financial logic and place the results into its in-memory BI database to dramatically improve real-time query performance.

Expectations on this new offering include report design automation to cater for novice Excel users as well as flexible drag and drop formulas for capable Excel users. This approach allows both types of users to pull financial and analytical ledger data directly out of Sage ERP X3 v7 and arrange it within Excel using their existing Excel skills and save your Excel report securely back to the Sage ERP X3 server. In addition to utilizing cutting edge technology, we are also including major usability and modernization changes to our  report designer tools as we ramp up to deliver on ever increasing market demands for simpler BI and reporting software. This is great news for users who are already using Sage Intelligence Financial Reporting for Sage ERP X3 v6 and v6.5 who can look forward to substantial business value increases when moving to the integrated report designer within Sage ERP X3 which will be available as an option to all users using version 7.

Both French and South African teams are excited about the extent of new business value planned for Sage ERP X3 version 7 as a result of their collaboration and having a dedicated BI team focus on the Excel financial reporting capabilities of Sage ERP X3 allows the French team to ship more value to market each release.