Sage One Intelligence

With Sage One Intelligence, you get ready-to-use online and Microsoft® Excel® reports that give you immediate insight into and across your business. Take a look at the list of online reports available to you. You can also download any of the Excel reports listed below, sign in with your Sage One credentials and enjoy the flexible reporting capabilities of Excel!

Online Reports
Open Close
Financial reports
Management Pack

An easy way to merge multiple online reports into a single online “workbook”. Each report will be presented as a separate sheet in the report. It can also be downloaded as an Excel workbook for customisation.

Balance Sheet – Actual 1to12

This summary report includes a breakdown of all Assets and Liabilities for the finance year being reported on as well as the balance as at the end of each financial period.

Balance Sheet – Actual 1to12 – Prior 1to12

This report includes a detailed breakdown of all assets and liabilities and their accounts as well as the balance as at the end of each financial period for the finance year being reported on and for the prior finance year.

Balance Sheet – Actual vs Prior 1to12

This summary report includes a breakdown of all assets and liabilities as well as the balance as at the end of each financial period for the finance year being reported on and for the prior finance year.

Profit & Loss – Actual 1to12 – Actual YTD

This report includes a detailed breakdown of the revenue, costs and expenses and related accounts for each financial period within the specified financial year. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period and can be used to track changes over a set period of time.

Profit & Loss – Actual 1to12-Budget 1to12 – Actual YTD-Budget YTD

This summary report includes a breakdown of the revenue, costs and expenses incurred and budgeted for each financial period within the specified financial year. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period and can be used to track changes over a set period of time.

Profit & Loss – Actual 1to12-Budget 1to12-Prior 1to12 – Actual YTD-Budget YTD-Prior YTD

This summary report includes a breakdown of the revenue, costs and expenses incurred for each period in the finance year being reported on, the prior finance year and the corresponding budget for each period. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period in the financial year and can be used to compare the actual profit or loss of a period to what was budgeted.

Profit & Loss – Actual 1to12-Prior 1to12 – Actual YTD-Prior YTD

This detailed report includes a breakdown of the revenue costs and expenses incurred as well as their corresponding accounts for each period in the finance year being reported on and each corresponding period in the prior finance year. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period in the financial year and can be used to compare the profit and loss of a period to the prior year.

Profit & Loss – Actual-Budget-Prior 1to12 – Actual YTD-Prior YTD & BudgetYTD

This summary report includes a breakdown of the revenue, costs and expenses incurred for each period in the finance year being reported on, the prior finance year and the corresponding budget for each period. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period in the financial year and can be used to compare the actual profit and loss of a period to what was budgeted.

Profit & Loss – Actual-Budget-Variance 1to12 – Actual YTD-Budget YTD

This summary report includes a breakdown of the revenue, costs and expenses incurred for each period in the finance year being reported on, the corresponding budget and the difference between the actual profit or loss and the budget for each period. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period in the financial year and can be used to compare the actual profit and loss of a period to what was budgeted.

Profit & Loss – Actual-Prior 1to12 – Actual YTD-Prior YTD

This detailed report includes a breakdown of the revenue, costs and expenses incurred as well as their corresponding accounts for each period in the finance year being reported on and each corresponding period in the prior finance year. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period in the financial year and can be used to compare the profit and loss of a period to the prior year.

Asset & Liabilities—Actual 1 to 12

This summary report has a breakdown of all Assets and Liabilities for the finance year being reported on as well as the balance as at the end of each financial period.

Assets & Liabilities—Current Month

This summary report has a breakdown of Assets and Liabilities and contains the Opening Balance for the finance year being reported on and the balance as at the end of the current financial period.

Profit and Loss—12 Months Actual vs Prior

The Profit & Loss report summarises the revenue, costs and expenses incurred for each financial period within the specified financial year as well as the same information for the prior year. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period and can be used to compare changes between prior year and current year for each financial period.

Profit and Loss—12 Months Actuals

The Profit & Loss report summarises the revenue, costs and expenses incurred for each financial period within the specified financial year. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period and can be used to track changes over a set period of time.

Profit and Loss—Current Period vs YTD

The Profit & Loss report summarises the revenue, costs and expenses incurred for the current financial period for a specified financial year. The Year To Date balance for the current financial period as well as the Year To Date balance taking into account all entries posted is also displayed. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period.

Open Close
Dashboards
Financial dashboard

This dashboard will help you understand how your business is doing, and in some instances, compares it to the previous financial year. Includes Trend analysis, how far you are with your sales target, gross profit and cost of sales for every Rand of Sales made, top five expenses and cash movement.

View Report
Accounting dashboard

Revenue Analysis, cumulative revenue, trend analysis, ratios, gross and net profit compared to the same period last year.

View Report
Excel Reports
Open Close
Financial reports
Profit & Loss Current Month
  • Displays calculations for Gross profit, Total Income, Net Profit before Tax, Net Profit after Tax
  • Reflects totals per period as well as actual YTD Profit & Loss Annual – YTD
  • Handy for long-term financial monitoring and planning
View Report    Download Report
Statement of Assets and Liabilities

Gives you an up-to-date view by period as well as YTD of:

  • Current and non-current assets
  • Current and non-current liabilities

View Report    Download Report
Assets & Liabilities—Current Month & YTD

This summary report has a breakdown of assets and liabilities and contains the opening balance for the finance year being reported on and the balance as at the end of the current financial period. Future period entries have been included in the Year-To-Date column. And, we’ve included a chart which visually displays total assets and total liabilities for each of the above balances.

View Report    Download Report
Assets & Liabilities—Opening Balance & Actual 1 – 12

This summary report has a breakdown of all assets and liabilities and contains the opening balance for the finance year being reported on as well as the balance as at the end of each financial period. We’ve also provided a separate layout containing the financial year opening balance and the balance as at the end of the current financial period. And, we’ve included a chart which visually displays total assets and total liabilities for the opening balance and the current period.

View Report    Download Report
Financial Ratio report

The ratio report can be used to analyse your company’s financial standing. You can use it to compare companies across industries to identity strengths and weaknesses. These reports are usually divided into categories, e.g. liquidity, solvency, profitability, so we’ve given you the ability to select a ratio using a slicer which will then display the relevant chart, calculation and description.

View Report    Download Report
Profit & Loss—Actual 1 – 12 & YTD

This report summarises the revenue, costs and expenses incurred for each financial period within the specified financial year. The report calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period and can be used to track changes over a set period of time. The report contains charts to graphically display each financial category of the Profit & Loss statement.

View Report    Download Report
Profit & Loss—Current Period & YTD

This report summarises the revenue, costs and expenses incurred for the current financial period for a specified financial year. It displays the Year To Date balance to the current financial period as well as the Year To Date balance taking into account all entries posted. This report also calculates the Gross Profit (or Loss) as well as the Net Profit (or Loss) for each period.

View Report    Download Report
Trial Balance

This report displays all the debit and credit balances of the ledger per financial group. It has been split into Balance Sheet groups and Income Statement groups, and when added together they should balance. An imbalance would indicate that there is an error. Balances displayed are the opening balance as at the beginning of the specified financial year, the balance for the current financial period, the closing balance as at the end of the current period as well as the balance for all entries posted up to the end of the financial year.

View Report    Download Report
Open Close
Sales reports
Sales Year vs Year Dashboard

Highlights your monthly and yearly sales trends. This report can be sliced by the following:

  • Customer
  • Company category
  • Sales Rep
  • Item type
  • Calendar month
  • Calendar year

View Report    Download Report
Sales Dashboard

Sales patterns:

  • Top five customers by sales
  • Top five items by sales
  • Top five item types by sales
  • Top customer categories by customer count

View Report    Download Report
Sales by Customer

Gives you an overview of sales to individual customers including:

  • Customer category
  • Items types
  • Date ranges

View Report    Download Report
Sage © Sage South Africa Pty Ltd 2016 . All Rights Reserved.