You may be aware that Sage Intelligence allows you to connect to any ODBC compliance data source, meaning that you can access and report on information from just about anywhere in your organisation. Included is the ability to use Microsoft Excel as a data source, which is useful in cases where your business management or […]
- Solutions
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.- Learning
- Support
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.Get Support Assistance
Can’t find the solution to the challenge you’re facing in the resource library? No problem! Our highly-trained support team are here to help you out.Knowledgebase
Did you know that you also have access to the same knowledgebase articles our colleagues use here at Sage Intelligence? Available 24/7, the Sage Intelligence Knowledgebase gives you access to articles written and updated by Sage support analysts.Report Writers
Having some trouble creating or customizing the exact report you need to suit your business’s requirements? Contact one of the expert report writers recommended by Sage Intelligence.- Sage City
- University
- About Us
- Contact Us
Making use of Wildcards in your Reporting Trees
Reporting Trees is a feature of the Financial Report Designer, and allows you to model organisational hierarchies based on the structure of your business. You can then filter your layouts by the different units in your trees to view your data in ways that make sense to you. Sage Intelligence makes use of wildcards to […]
Learn how to reverse the sign of an account in the Sage Intelligence Online Report Designer
In Sage Intelligence, account balances are typically returned in their “natural format” from your Sage accounting or business management solution. In other words, 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 the […]
Learn how to save your rows and columns in the cloud for future use
When designing reports in Sage Intelligence, you may create custom rows and columns that you might want to make use of in future reports. Sage Intelligence provides a convenient way to save these sets, making future report creation a breeze. In this tip, I’m going to show you how to work with the Quick Add […]
How to avoid the VALUE error when using the SUMIF function between workbooks
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 […]
How to quickly convert negative values to positive values
Sometimes converting negative values to positive values can be time-consuming. This tip allows you to quickly convert a range of negative values into positive values, without having to edit each cell. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. 1. In a blank cell, enter the value -1. 2. Select the cell with […]
Create your own Operational Report in Sage Intelligence Reporting Cloud
Do you want to create your own operational report and analyze it according to your specific reporting needs from Accounting International? Sage Intelligence Reporting & Microsoft Excel make this easy and quick to do. Applies to: Accounting International, Microsoft Excel 2013 & 2016 How do I do this? 1. Download one of the standard Intelligence […]
Learn how to consolidate different kinds of data into one report
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 […]
Unlocking the door to complete business visibility
Keyhole visibility is a concept that is familiar to many Small & Medium Businesses (SMBs). This type of business visibility is equivalent to trying to see what’s happening in a room by looking through the keyhole of a door. Likewise, with a narrow view of your business, you are forced to make critical decisions with […]
Blast from the past: Age old pearls of wisdom that’ll boost your management potential
A friend and colleague approached me to ask that I write a blog entry on management, and how I manage my team; the techniques and tricks that I employ that help me get the job done. Initially, I was quite apprehensive as to how to go about analyzing what I do and then formulating catchy, […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.