Excel Reporting workbooks and subscription

Some Excel Reporting reports are provided free with Sage 200 Services to get you started.

If you subscribe to Sage 200 Services Extra, you can access additional reports, such as stock reports. For information on the Sage 200 Services Extra subscription package, please contact your business partner.

Free reports with Sage 200 Services

These reports are free for all Sage 200cloud customers.

Report Description
Assets and Liability Reporting

Details of assets and liabilities. All periods within the current financial year are included. See Financial data reports.

Customers

Detailed information about your customer accounts, including their current balance.

This report could potentially be used as a source for a mail merge, data validation and cross-referencing, or graphical analysis by analysis code.

Customer Transactions Preview

Details of current transactions for customer accounts.

Note: This is a preview of the subscription Customer Current Transactions report, and is restricted to show the 250 most recent transactions.

Nominal Accounts

Summary of your nominal accounts with month and year-to-date balances.

This report contains credit, debit and balance for the year and for periods, so it could potentially be used to create a custom Trial Balance, working Profit and Loss, or Balance Sheet.

Nominal Account Balances

Details of nominal account balances, including data for budget comparisons. See Financial data reports.

Nominal Transactions

Details of transactions on Nominal Ledger accounts.

This report could potentially be used for reconciliation, reporting and graphical analysis by analysis code, or analysing out of period posting.

Revenue and Cost Reporting

Details of revenues and costs. All periods within the current financial year are included. See Financial data reports.

Stock Items

Details of your stock items, including quantities and location.

This report could potentially be used to help discover where there are shortages of stock items, to display graphs of stock balances, or to find items which have not been sold for a long time.

Stock Transactions Preview

Details of stock item transactions (movements).

Note: This is a preview of the subscription Stock Transaction History report, and is restricted to show the 250 most recent Movement In/Out transactions by date.

Supplier Transactions Preview

Details of current transactions for supplier accounts.

Note: This is a preview of the subscription Supplier Transactions report, and is restricted to show the 250 most recent transactions.

Suppliers Detailed information about your supplier accounts, including their current balance.

Subscription reports with Sage 200 Services Extra

These reports are available if you subscribe to Sage 200 Services Extra.

Additional reports can be downloaded from the Sage 200 Services Extra website as an add-on package.

Report Description
Budgets vs Actual

Use this report to see how much you've spent from your budgets and how much remains, so you can check if you're under or over budget.

You can compare your nominal account budget figures against your actual and committed expenditure, and view figures for selected periods or an annual budget. Use the slicers to view details by cost centre, department, report category, individual nominal accounts or a combined nominal budget. See How to report on your budgets.

Cash Book Transactions Details Cash Book transactions, with totals by code.
Customer Archived Transactions This is similar to the Customer Transactions report but shows archived transactions.
Customer Batched Transactions Details of customer batch transactions and totals.
Customer Reverse Charge VAT Transactions This details transactions subject to Reverse Charge VAT.
Customer Transactions

Details of current transactions for supplier accounts.

This report could potentially be used for reconciliation, graphical analysis based on query code, reporting based on days to pay, analysis of settlement discounts taken, reporting commission, marketing analysis using analysis codes, or reporting on finance charges.

Customer Turnover by Period Details trading turnover with breakdown of the invoice and credit totals, using the base currency and the currency of the customer.
Nominal Archived Transactions This is similar to the Nominal Transactions report but shows archived transactions.
Nominal Budget Overview The Nominal Budget Overview Excel workbook includes budget, actual and committed values for all your nominal accounts. Information is shown across several worksheets, such as Report Category, Cost Centre (fund), Department and Combined Budget. See How to report on your budgets.
Nominal Budgets

This report shows you the position of your nominal account budgets for each accounting period, taking into account actual and committed expenditure.

For each nominal account in each period, you can see your account budget, actual expenditure, committed expenditure, and the budget variance.

Note: The values in this report are affected by your Commitment Reporting settings.

Nominal Commitments This shows all the purchase order lines entered against each nominal account. You can also use this to see how whether any part of an order has been received or invoiced.
Nominal Held Journals Details of journals which are on hold and have not yet been posted.
Nominal Outturn

This report shows your budget position for each nominal account taking into consideration any commitments.

For each nominal account, you can see the annual budget, budget to date, actual expenditure, committed expenditure, budget variance, and budget remaining.

Note: The values in this report are affected by your Commitment Reporting settings.

Nominal Outturn by Report Category

This report shows your budget position for each report category taking into consideration any commitments.

For each report category, you can see the annual budget, budget to date, actual expenditure, committed expenditure, budget variance, and budget remaining.

The budget values are calculated from total of the budgets set on each nominal account within the report category. Budgets set at report category level are not included.

Note: The values in this report are affected by your Commitment Reporting settings.

Nominal Waiting Postings Details of pending and deferred Nominal transactions.
POP Requisitions

Details of all purchase requisitions, showing details of the requested items, their authorisation status, and how they've been fulfilled.

Stock Additional Product Group and Stock Details Details about product groups and stock items, providing more information than the Stock Items report.
Stock Allocations This report is used to identify stock that has been allocated but not yet issued.
Stock Alternatives This report shows alternatives for a particular stock item.
Stock Archived Transactions This is similar to the Stock Transactions report but shows archived transactions.
Stock Average Cost History Details of changes to a stock item's average cost.
Stock Batch Serial Tracked Allocations Provides details of traceable stock items with batch or serial numbers.
Stock Levels Details of stock item quantities, and their maximum, minimum and reorder levels.
Stock Movements Details of stock quantities and valuation.
Stock Period Values Shows details of stock profitability by individual stock item or product group per period.
Stock Standard Cost History Details of changes to a stock item's standard cost.
Stock Suppliers Provides details of stock items with suppliers, including order value and quantity on order.
Stock Traceable Transactions Details of stock item transactions that are traceable by batch or serial numbers.
Stock Traceable Transactions Archive Shows details of archived stock item transactions that are traceable by batch or serial numbers.
Stock Transactions Details of stock item transactions (movements), with ability to analyse transactions by search category.
Stock Warehouses and Bins Details of stocktakes at warehouse and bin locations, for example to check bins where a stock take is due.
Stocktakes Provides details of the last stocktake for each warehouse and results for each stock item.
Supplier Archived Transactions This is similar to the Supplier Transactions report but shows archived transactions.
Supplier Batched Transactions Details of supplier batch transactions and totals.
Supplier Suggested Payments Details of suggested payments to suppliers.
Supplier Transactions Details of current transactions for supplier accounts.
Supplier Turnover by Period Detailed breakdown of supplier turnover in terms of the invoice and credit totals, plus the data is provided in the base currency and the currency of the customer.
VAT Transactions Details of Vatable transactions with totals.

Financial data reports

Financial data reports are free for all Sage 200cloud customers, and include:

  • Assets and Liability Reporting.
  • Revenue and Cost Reporting.
  • Nominal and Account Balances.

Design your financial reports

If you want to use the Revenue and Cost Reporting or Revenue and Cost Reporting reports you'll need to:

  • Make sure you've set up report categories correctly. Use the Report categories option to add report category types, such as Asset or Liability. If any report categories have a type of Undefined, Sage 200cloud won't be able to process the data for the Excel report.
  • Configure the layout of your reports. Use the Financial Statement Designer to set which accounts are included in each section, and how they are grouped and totalled.

Make your reports available

Make the reports are available to users by adding the reports to the appropriate roles.

  1. Open System Administration.
  2. Select Roles, then right-click the appropriate role and select Features.
  3. Select the reports in Features > Excel Reporting > Reports > Financial Data Pack.