Get a dynamic view of your top customers with the Top Customers Analysis report

This report gives you a dynamic view of your top 5, 10, 15 and 20 customers—depending on your requirements. The first dashboard you’ll notice is a map chart, which opens up after you’ve entered your required from and to date. This map chart highlights the amount of Sales per Customer by Location. The size of the bubble indicates the […]

Continue reading


Get an overview of your purchasing behaviour with the Purchase Analysis report

This report gives you an overview of where, and from whom, you’re purchasing goods and services based on the date selection you have made. To run this report, you’ll first choose the from and to date by simply clicking on the date selector to expand it further: The Purchase Analysis by Region report will then open for the period […]

Continue reading


How to create a linked dashboard (or landing page) for your Excel workbook

Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently, especially if you are working with a large amount of data that needs to be analyzed periodically. This may be due to multiple tables, lookups, references, charts, graphs etc. This has […]

Continue reading


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 […]

Continue reading


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 […]

Continue reading