Having descriptive headings in a report can make it easier to comprehend. For example, having month names instead of period values for column titles can make it easier to determine the data a column refers to. Sage Intelligence now makes this possible in a dynamic way through Column Variables. This tip applies to: Sage Business […]
- 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
Using Wildcards to make finding or replacing data in Excel quicker and easier
This tip is useful when you want to replace or find text using Wildcards, e.g. if you have a column where you would like to replace everything after the space character with text. What are Wildcards? Wildcards are characters that are used to represent one or more characters. The following wildcard characters can be used […]
Learn how to check your Containers in the Sage Intelligence Connector module
Being able to check if the components of a report are functioning as expected while working with them can help provide a smooth workflow and save time dealing with problems later in the report creation process. Also, if you do come across errors in a report, being able to test its components easily allows for […]
Interactive dashboards now live in Sage Intelligence for Accounting!
Sage Intelligence has introduced five interactive dashboard reports to Sage Business Cloud Accounting that give you regular insights into your business’s key performance indicators. With these improved reports, you’ll be empowered with the ability to drill down into the detail of your information so that you can make faster decisions and act more decisively. Get […]
Track your creditors with the Analysis of Accounts Payable report
The Analysis of Accounts Payable report will help you to effectively manage who you owe money to. As a business owner, you’ll need to know how much money you’re expected to pay your suppliers within your credit terms, and which payments you can potentially push out to help manage your cash flow more appropriately. Looking […]
Know your numbers with the Business Snapshot Dashboard
The Business Snapshot Dashboard – Profit and Loss statement provides a visual summary of how your business is doing with regards to generating sales, managing expenses and creating profits. In other words, whether your business has made or lost money in the period under review. This can also help determine trends for future business decisions. […]
Collect your cash with the Analysis of Accounts Receivable report
It’s important for any business owner to know exactly who owes them cash, how much, and when they can expect to receive it from their customers. Looking at this Dashboard, the first thing you’ll see is that your Debtors Days are 134.54 and, in the red. This means that on average, your debtors are paying […]
Understand your customers with a Sales Trend Analysis report
Most successful businesses use sales analytics to report on and predict sales performance. As a small business, knowledge of this information is power! Being able to view and track Sales Trends year-on-year, as well as sales per sales representative, means that you’re kept up to date and empowered to use this information to track performance. […]
Enhance your reporting with Sage Intelligence and Microsoft Power BI
Are you familiar with Microsoft Power BI? Did you know that in addition to Excel, Power BI can be used with Sage Intelligence to provide attractive and interactive depictions of your data? A key benefit of this is being able to keep track of key performance indicators while on the go. If this appeals to […]
How to insert icons into a spreadsheet
This tip may seem basic, but with Microsoft continually adding value to its products—we just had to mention it. It’s lead by a repository of every icon imaginable (and maybe even a few that are unimaginable) that you may find useful, especially if you’re someone who likes your Excel workbooks to look a little more […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.