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 and financial reports.

Sage 200 Services Extra is included for Sage 200cloud for Education customers, so you can use all of our Excel reports.

Find this screen

Open: Excel Reporting > Excel Reports.

Watch a video

Get started with Excel Reporting (video)

Sage 200 Services reports

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.

CFR Balances

Shows the current total balance for each CFR code and the total balance of your Opening Balances, Income, Expenditure, Capital Income and Capital Expenditure.

You can use this report as a base for the CFR report you need to send to your LEA.

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.

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.

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.

These reports are available to Sage 200cloud for Education customers, which includes Sage 200 Services Extra.

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

Report Description
Budget vs Actuals

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 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 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.

See Commitments.

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.

See Commitments.

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.

See Commitments.

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 Average Cost History Details of changes to a stock item's average cost.
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 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 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.