Excel Reporting - list of reports

Watch a video

Get started with Excel Reporting (video)

Find this screen

Open: Excel Reporting > Excel Reports

Excel reports available

All of these reports are now available to Sage 200 customers.

Note: Before the Sage 200 Standard 2021 R2 release, some reports were only available with Sage 200 Services Extra.

Report	Description
Assets and Liability Reporting	Details of assets and liabilities. All periods within the current financial year are included.
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.
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. Note: This report is intended for Sage 200 Standard for Education.
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. Note: Transactions will only be displayed for the last 5 calendar years.
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.
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.
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.
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.
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.
Revenue and Cost Reporting	Details of revenues and costs. All periods within the current financial year are included.
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 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 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 Transactions (Profit Only)	Details of profit by stock item and product group.
Stock Transactions (Transactions Only)	Details of stock item profit by stock item and product group.
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. Note: Transactions will only be displayed for the last 5 calendar years.
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.
Suppliers	Detailed information about your supplier accounts, including their current balance.
VAT Transactions	Details of Vatable transactions with totals.

Can't see these reports?

Note: Some of these reports were made available free in the 2021 R2 release, and you may not see them in the list until you Restore Default Excel Reports.

You may not be able to see a report if:

It's a new Excel report that we've supplied in an update.
It has been deleted.

You will need to Restore the report before it is displayed in the Excel Reports list.

Open: Excel Reporting > Restore Default Excel Reports.

Select the box next to the individual reports, or select all reports, and click Restore.

If the reports already exist, you will be prompted to confirm that you want to overwrite the existing reports.
The report will now be displayed in the Excel Reports list.