Premium Reports

Sage 200 Reporting  –  Sage 200 Reports:

Premium Reports

Below is a list of our Premium Reports that offer exceptional value for money!

Ref: Title Fee £ Details PDF
NOMINAL LEDGER
123 Profit and Loss Report (MTD-YTD) split across Cost Centres 199   View Sample Print
The standard Sage report has been modified to print in portrait and adapted so each reported Cost Centre has the same full FSL format as when a P & L report is created when all cost centres and departments are not split out.
PURCHASE LEDGER
102 Supplier Turnover – TOP Suppliers 199 View Sample Print
Selected column is sorted in DESCENDING sequence so the highest value is at the TOP.  However, this report has some additional criteria to select the number of suppliers to be reported back.Show More The number of suppliers is then set as a COUNT or as a PERCENTAGE.   After the selected suppliers have been listed  the report will show the grand totals of the reported suppliers and then a grand total for the non-reported suppliers.  A grand total for all supplier accounts is also shown. 
103 Purchase Ledger Day Book with Allocations 149 View Sample Print
Ideal to show what purchase invoice(s) were paid against a cash book payment. 
137 Time Taken To Pay Suppliers – Enhanced for Duty To Report  199 View Sample Print

This report will highlight if you are being fair to your suppliers and if any suppliers are being paid outside your ‘normal’ terms.  The  ‘Due Date’ is calculated as the Invoice date plus TERM days. 

SALES LEDGER 
105 Sales Ledger Day Book linked to Allocations 149 View Sample Print
** Selected column is sorted in DESCENDING sequence, so the highest value is at the TOP.  However, this report has some additional criteria to select the number of customers to be reported back.  Show More The number of customers is then set as a COUNT or as a PERCENTAGE.   After the selected customers have been listed. The report will show the grand totals of the reported customers and then a grand total for the non-reported customers.  A grand total for all customer accounts is also shown. ** 
107 S/L Aged Debtors Report – All in One and with MEMO details available (if required) 199 View Sample Print
A report that can be run in either Detailed or Summary and by either Account Number or Short Name sequence.   All the four options available can also be set to display the linked ACTIVE Memo data. 
168 Sales Ledger Alerts – Enhanced 199 View Sample Print
The Sage ROTM of November 2018 offers a free report to list the ALERTS set against the Sales Ledger Customer Accounts.  This report addresses the lack of reporting which FORMS are assigned to each ALERT and adds additional run time criteria to select which of the FORMS should be used to filter the displayed alerts. 
170 S/L Credit Control – All in a SINGLE Report 199 View Sample Print
Report 107 plus the ageing by TRANSACTION, POSTED or DUE dates.  A Due Date report is now possible RETROSPECTIVELY! **
SALES ORDER PROCESSING / BOM
122 13 period analysis (month or week) 199 View Sample Print
SOP analysis tabulated across 13 periods. If the periods are months then the DAY of the last period date is used for the end day for both column 1 and column 13. Show More This will then allow for a better comparison between column 1 and 13. With eight sort sequences and the ability to report in months or weeks you get 16 value reports. You also get 16 quantity reports if you select to switch to report quantities **This report therefore offers 32 reports in one.  **  
184 Picking List Amended to Display as report 183 but with an additional BOM explosion summary page(s) grouped by the items Product Group code. 500 View Sample Print 
The new BOM Summary page(s) also includes the SOP Order Line items withing the Product Group  sort sequence enabling the  whole document to be picked from the summary pages via Product Group  location.
STOCK CONTROL
116 Aged Stock Balances – 7 columns – Custom 199 View Sample Print
This ‘must have’ report allows you to monitor your stock levels and valuation by aged columns to quickly identify the slower moving items and if your money is tied up in stock that has not moved off the shelf for many months or years. Show More Each user will have different break points for the reported columns so the first five columns can be fixed by pre-set criteria and the sixth column can be set at run time so as to mark the start point (in days) for the final seventh column. With this ‘moveable’ break point for column 7 the items captured in this column can be easily noted to have been in stock for at least the number of days entered. Note: this report has the criteria for the warehouse fully functional – The standard Sage 200 Stock Valuation report only allows for the warehouse to be set as ALL or IS This report has been formatted to ensure that when exported to Excel it is immediately available to be analysed further without the need to manipulate the output.    
119 Stock Profit – Customer and Product reports combined into a SINGLE report – NEW sort sequence options deliver 11 sort sequences. 199 View Sample Print
The FOUR Stock Status Proffit reports; Profit By Customer, Profit By Customer (Summary), Profit By Stock Item and Profit By Stock Item (Summary) have been combined into this SINGLE report. Show More Eleven permutations are now possible with an added third sort level. A tick-box criteria can switch the report from summary to detailed, giving 22 possible layout formats.  

137-PUR-NEW