Menu
Close
Depending on your Sage business solution, you may or may not have the Missing Accounts feature in your Financial Report Designer report. Even if you have this functionality, you are still not automatically alerted that account level detail may be missing from your layout. In this tip, I’m going to share a way to identify […]
Do you have a workbook that could do with some neatening up? Being able to hide rows and columns in a report that contains data you don’t need to view is a great way to do this. An example of a report like this is a financial statement, which has account level detail and monthly […]
To complete an analytical review of the depreciation of your company’s assets, you can calculate the average useful life of these assets. The average useful life, which is a measure of conditional central tendency, can be calculated using the AVERAGEIF function. Central tendency is the middle value or a typical value within a data set. […]
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.
How would you like constant access to a library of additional reports? The Sage Intelligence Report Utility allows you to select the reports you like and automatically imports them into your Report Manager. All you need to do is download and install the Report Utility, select the reports you want, and click the Download button. […]
In the first part of this series, I compared becoming a new parent to nurturing relationships with new customers (and also managing their payments). The intent was for entrepreneurs to take 5 minutes every now and then to reflect on one element of their businesses to help them grow. In this article, I will focus on […]
If you’re a user of the Sage Intelligence Connector Module, you’ll know that the Connector maintains the links between your Sage Intelligence reports and your Sage Business Management Solution data sources. Different database systems store and recognise dates in different formats, and Sage Intelligence attempts to hide this detail from you by translating dates at […]
In order to correctly show the movement and management of cash within a business, accountants use a cash flow statement. This statement will display a business’s money coming in from ‘cash receipts’ and where it has paid money out, ‘cash paid’. The cash flow statement is a standard financial statement and is frequently used in […]
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 […]
I recently became a parent. For those who have gone through this experience, you’ll know it’s an emotional one, and the way you view the world changes. Even if that change is only because you are viewing it through half-closed eyes because of a lack of sleep. For those that don’t have children, the experience […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.