Menu
Close
Most successful businesses use a Sales Trend Analysis 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 […]
Do you need to future-proof your business? The Excel Forecast sheet may be the right tool for you! The Forecast sheet allows you to take your historical business data (sales, cash flow, etc.) and create more accurate forecasts for the future. You are welcome to download the workbook to practice! 1. To create a Forecast […]
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 […]
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 […]
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.
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 […]
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.