Menu
Close
Sage Intelligence have introduced five interactive dashboard reports to Sage Business Cloud Accounting that will 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. […]
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. […]
The Analysis of Aged Creditors 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 […]
Have you ever used the VLOOKUP formula with the approximate match in Excel? By using this formula, you’re able to extract the correct trade discount percentage based on the quantity of a specific item purchased. In this tip, we demonstrate how to set this up. If TRUE or 1 is specified in the Range_lookup argument text […]
This is a tip that you’re going to really enjoy if you love imagery and visualisations in your spreadsheet! It’s not the most useful tip in the world, but for most people, especially the creative types—it will put a smile on your face because it’s so much fun to play with. In this tip, I’m […]
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 have an Excel management pack with multiple worksheets and would like to save it as a PDF for convenient viewing and sharing? In this tip, I’m going to show you how easy this is to do. You have three options for this, but before continuing, there are a few things to take note […]
Would you like to separate your debit and credit balances while using the Excel Design Pane? If so, then the Balance Type function is for you. An example is if you want to create a Trial Balance with debit balances reflected in a debit column and credit balances reflected in a credit column.
With a disorganized reporting structure, finding anything specific can be like finding a needle in a haystack. Stop wasting time searching for reports by creating an organized folder structure with Sage Intelligence. The most effective folders structures are easy to use, so everyone can intuitively find the reports they’re looking for. Applicable Sage Business Cloud […]
As an accountant, my most valuable commodity is time. Being responsible for daily capturing, month end procedures and group reporting, I often don’t have time to breathe! Fortunately, a lot of my responsibilities are hastened because I use business intelligence (BI), which helps me extract key information from large volumes of data directly from our […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.