Menu
Close
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 […]
We all know that cash flow is such an essential ingredient to the survival and success of any business. If you ever encounter cash flow problems at some stage of your business’s life, it could be a serious obstacle to your progress. Which is why it always pays to keep a close eye on what […]
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. […]
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 […]
Having a meaningful title for a report can help make its intention clear. For example, being able to add a date to a report name allows you to tell at a glance what information the report is referring to, and having this work dynamically is an obvious convenience. Sage Intelligence has now made this possible […]
The 3 skills and knowledge domains a Business Analyst requires to effectively add value is well versed and well documented; they need a degree of Technical Knowledge, Business Knowledge and Interpersonal Skills. Although most industry reports and literature focus on the two former items in the list, the latter is certainly not emphasized enough, and […]
You may have reports that you don’t run out often, if at all. A common example is the sub-reports of a union report, and you only ever run out the union report. Having these additional reports in your Report Manager may be necessary but can clutter up your folders. Fortunately, the Report Manager gives you […]
Let’s say you have a workbook containing sales over a two year period. You would now like to know what the average is for your top 5 sales values, as well as the value for your largest sale. In our example, which you are welcome to download here, we are using Column A for the […]
Sometimes, large Microsoft Excel workbooks can be slow and inefficient—which could cause frustration. To reduce the size of a workbook, consider replacing several formulas with a single array formula. Array formulas can perform multiple calculations and they also ensure consistency, which can lead to greater accuracy. Furthermore, array formulas provide for more security, since a […]
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. […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.