Menu
Close
Do you optimally use the invaluable business information your company collects on a daily basis? If you answer YES to one or more of the following questions, it may be about time you discover how business intelligence helps get rid of the daily grind. 1. Do you spend hours pulling together management and financial reports by manually […]
If you have used the Financial Report Designer to create reports, you may have taken advantage of Reporting Trees as a way of filtering them. If you then intend on sharing these reports with other counterparts and want them to be able to filter by the same tree structures, then, rather than having them re-create […]
One worksheet can be used to view specific aspects of several different worksheets. This can be done using the Linked Picture option. There are a few options when consolidating information from multiple worksheets, and in this tip, we’ll deal with the most popular. The option for this tip enables you to paste the copied cells […]
Over the past five years or so, the cloud has been an incredibly disruptive force within the global IT industry—owing to the various advantageous and value-adding qualities it holds. This is, of course, accompanied by the cloud’s greater cost saving element in providing its service, not only for commercial entities, but general households as well. […]
In the Sage Intelligence Financial Report Designer, account balances are returned in their “natural format” from your Sage accounting or business management solution. Therefore, credit accounts (with a credit balance) are shown as negative values and debit accounts (with a debit balance) are shown as positives values. However, in financial reporting, there are times when […]
A good Business Intelligence solution will give your company a competitive advantage, and there are many compelling reasons why all business owners should make it a priority to invest in one. Here are the top three: Reason 1: Automate reporting processes Most companies face constant pressure to increase profitability, improve cash flow, reduce costs, and […]
When using the SUMIF function between workbooks, you may get a VALUE error if the source workbook is not open. This behavior occurs when the formula that contains the SUMIF, COUNTIF, or COUNTBLANK function refers to cells in a closed workbook. To work around this, use a combination of the SUM and IF functions together […]
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”. Why then, would you want or need to use a Business […]
More and more companies are calling for the necessity of business intelligence (BI) and reporting. It’s fast becoming the ‘it’ word in business, and regularly features in the discussions of many business circles. However, there seems to be a gap in understanding why we need BI. What’s the point of having BI? What’s the big […]
Do you want to consolidate, bring together and analyze different kinds of data in one report? You may want to view your financial, payroll and payments information in a single dashboard. Currently, you may be spending a large amount of time reviewing these different reports to be able to draw a final conclusion. In Sage […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.