We use cookies on our website to provide you with the best experience. If you continue browsing, you are consenting to our use of these cookies, but if you would like to know more, including how you can change your settings, take a look at our Privacy Notice.

Sage 200 Report Designer Services - Report of the month

As part of Sage 200 Services, we will upload a report each month. These reports are not industry specific.

You can access previous reports from the table below which have been arranged by module.

Select the module on the left of the page to get there quicker.

Reports created on the back of wish list requests can be found here.

This article was last updated on 1st June 2020 with the June 2020 report of the month.

The report you're looking for isn't here?
If you need a report unique for your business then Sage 200 Services customers can request customised reports. Follow the process here to book an appointment with one of our Report Design Technicians.

Report of the month

Report of the month - June 2020

Report: Nominal Ledger Monthly Activity By Cost Centre & Dept
Software: Sage 200cloud / Standard / Sage for Education
Module: Nominal Ledger
Details:
  • This report shows 12 months values based on transaction dates grouped by cost centre then department.
Example:
File:

Sales Ledger

Month Report Example File
Nov 2019 Sales Ledger 12 Month Gross Turnover
Jun 2019 Invoice and Credits Summary
Nov 2018 Sales Ledger Customer Alert Report
Aug 2018 Average Days to Pay Invoices
Apr 2018 Customer Commission 10% Net by Analysis 1
Dec 2017 Top Customer Turnover 2 Financial Years
Aug 2017 Sales Ledger - Outstanding Invoices by Due Date
Apr 2017 Sales Ledger Net Turnover by Month
Jan 2017 Sales Ledger Daily Transactions
Sep 2016 Sales Ledger Accounts Due Credit Review.
Mar 2016 Sales Ledger Aged Debtors Report with Project Code (Detailed) Portrait
Jan 2016 Sales Ledger Accounts Credit Limit Exceeded
Dec 2015 Sales Ledger Accounts With Last Invoice Date
Dec 2015 Aged Debtors report (Summary) by Balance
Dec 2015 Aged Debtors Report (Detailed) by Balance
Jun 2015 Sales Ledger Aged Debtors (Summary) Portrait
May 2015 Sales Ledger Aged Debtors (Detailed) Portrait
May 2015 Department Sales Ledger Aged Debtors (Detailed). Based on the department attached to the customer record.
Jan 2015 Sales Ledger Agents Commission 10% Gross
Jan 2015 Cost Centre Sales Ledger Aged Debtors (Detailed). Based on the cost centre attached to the customer record.

Purchase Ledger

Month Report Example File
Oct 2019 Purchase Ledger 12 Month Gross Purchases
Dec 2018 Purchase Ledger Address List
Mar 2018 Top Supplier Turnover Last 2 Financial Years
Feb 2018 Purchase Ledger Transactions Summary (Portrait)
Jul 2017 Purchase Ledger on Hold Report
May 2017 Purchase Ledger Invoice and Credit Summary
Dec 2016 Purchase Ledger Bank Accounts (example will show what information is exported)
Aug 2016 Purchase Ledger Average Days to Pay
Jun 2016 Purchase Ledger Accounts Credit Limit Exceeded
Feb 2016 Purchase Ledger Aged Creditors Report with Project Code (Detailed) Portrait
Jan 2016 Purchase Ledger Departmental Analysis. Based on the department attached to the supplier record
Jan 2016 Purchase Ledger Invoices and Credits Summary
Dec 2015 Aged Creditors (Summary) by Balance
Dec 2015 Aged Creditors (Detailed) by Balance
Nov 2015 Purchase Ledger Aged Creditors (Summary) Portrait
Oct 2015 Purchase Ledger Net Turnover By Month
Aug 2015 Purchase Ledger Aged Creditors (Detailed) Portrait
May 2015 Department Purchase Ledger Aged Creditors (Detailed). Based on the department attached to the supplier record.
Jan 2015 Cost Centre Purchase Ledger Aged Creditors (Detailed). Based on the cost centre attached to the supplier record.

Nominal Ledger

Month Report Example File
Apr 2020 Nominal Ledger Monthly Posted Activity
Jan 2020 Nominal Ledger Budgets Only
Aug 2019 Nominal Ledger Budgets with Original Budget
Nov 2017 Nominal Ledger Trial Balance (Consolidated)
Feb 2017 Nominal Cost Centre Analysis
Jul 2016 Nominal Ledger Activity including BF
Feb 2016 Nominal Ledger Records to CSV
Jan 2015 Nominal Activity

Stock Control

Month Report Example File
Apr 2019 Preferred items by customer then product group
Jun 2018 Stock Warehouse with Address and Contact
Oct 2017 Simple Stock Details
Jul 2015 Product Movement In-Out
Mar 2015 Stock Quantity Sold with Value and Cost

Sales Order Processing

Month Report Example File
Mar 2020 Sales Order Products by Customer
Feb 2020 Invoiced Monthly Net Sales by Product Group and Stock Code
Feb 2019 Sales by Customer Analysis 3
Sep 2018 Sales By Nominal
May 2018 SOP by stock type (Detailed)
Sep 2017 Sales by Customer Analysis 2
Jun 2017 Product Sales by Nominal and Customer
Mar 2017 Sales by Customer Analysis 1
May 2016 SOP Invoice with Project Code (Single)
Jan 2016 Sales Orders Product Sales by Nominal and Customer
Aug 2015 Monthly Product Sales
Aug 2015 Monthly Product Sales By Customer
Aug 2015 Monthly Product Sales By Customer By Product Group
Aug 2015 Monthly Product Sales By Product Group By Customer
Aug 2015 Monthly Product Sales By Product Group
Aug 2015 Sales By Product (Detailed)
Aug 2015 Sales By Product (Summary)
Aug 2015 Sales By Product By Customer (Detailed)
Aug 2015 Sales By Product By Customer (Summary)
Aug 2015 Sales By Product By Customer By Product Group (Detailed)
Aug 2015 Sales By Product By Customer By Product Group (Summary)
Aug 2015 Sales By Product By Product Group (Detailed)
Aug 2015 Sales By Product By Product Group (Summary)
Aug 2015 Sales By Product By Product Group By Customer (Detailed)
Aug 2015 Sales By Product By Product Group By Customer (Summary)
May 2015 Sales Orders No. of Orders & Turnover (Detailed)
May 2015 Sales Orders No. of Orders & Turnover (Summary)
Feb 2015 Invoiced Product Sales by Customer (Detailed)
Feb 2015 Invoiced Product Sales by Customer (Summary)

Purchase Order Processing

Month Report Example File
May 2020 POP Potential Profit by Invoice Report
Jan 2019 POP Purchases by Nominal Code and Supplier
Jan 2018 POP Products on Order
Oct 2016 Purchase Orders Past Requested Date.
May 2016 POP Products On Order by Product Group
May 2016 POP Deliveries by supplier
Apr 2016 POP by Product Not Received
Feb 2015 Purchase Order by Product
Feb 2015 Invoiced Products by Supplier (Detailed)
Feb 2015 Invoiced Products by Supplier (Summary)
Jan 2015 Purchase Orders Fully Received Not Fully Invoiced

Cash Book

Month Report Example File
Nov 2016 Cash Book Transactions Report (Portrait) with Running Balance
Nov 2015 Cash Book Account Balances.
This report gives you a list of bank accounts with a date rangeable balance. You must run it from the 01/01/1980 up to the date you require to get an accurate balance.
Mar 2015 Cash Book Day Book Transaction Report
Jan 2015 Customer Receipt Report

Fixed Assets

Month Report Example File
December 2019 Fixed Asset Activity by Location
May 2019 Fixed Asset Activity
Oct 2018 Fixed Assets Monthly Depreciation by Manager

Price Book

Month Report Example File
Mar 2019 Price Book - List of Price Lists
Jul 2018 Price List (Base Prices) by Warehouse

Bill of Materials

Month Report Example File
Jul 2019 BOM Costing History
Sep 2015 Components by BOM
Sep 2015 Operations by BOM (Detailed)
Sep 2015 Operations by BOM (Summary)

Works Orders

Month Report Example File
Sep 2019 Works Order Summary

Download the Sage 200 report

  1. From the relevant tab, select the report you want to download and click the 'Download report' button.
  2. Enter your login details when prompted. When the download software and updates window appears, make a note of the filename, for example, sagereportdesigner.report then select Download.
  3. In the Save As window, browse to and select the required destination, for example, the Windows desktop > Save.

You have now successfully downloaded the Sage report file.

Add the report to Sage 200

For details regarding the full process of adding a new custom report to the menus within Sage 200, please refer to Ask Sage Article 25839. If you require support in this process please contact your Business Partner in the 1st instance.

If you are using Sage 200cloud Standard or Education please refer to your program help guide for help adding it to your menu.

$FOC_file_licence