Sage 200 Reporting – Sage 200 Reports:
If Pay-As-You-Go is not for you why not contact your business partner to see if they would commission a report on your behalf. We will be cheaper than the ‘free’ reports offered by Sage under their Sage Services contract!
|Ref:||Title||Fee £||Details||View PDF|
||Customer Turnover – Top Customers||199|
|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|
||S/L Day Book linked to Allocations||149||>>>>>|
|Enhanced to include a criteria for the transaction date and also offer a choice to show allocation history against the selected reported transaction types.
||S/L Aged Debtors Report – All in One and with MEMO details available (if required)||199|
|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.
|111||CONSOLIDATED Sales Ledger Statement (Single) – HO, Branch and Independent||99||>>>>>|
|Although the Sales Ledger account has settings to send statements as an independent, branch or head office it is not possible with the standard layout to consolidate all the branch accounts onto the single head office statement. This new layout can.|
||Sales Ledger Aged Debtors Report (Detailed) – SELECTED (Aged by SELECTED method but retro by Transaction date.||99||>>>>>|
|The standard Sage Aged Debtors report modified to tabulate the ageing of the transaction by Due, Posted or Transaction Date.
||Reports 102 and 105 (Turnover reports showing TOP Supplier and Customer account analysis)||300
||Reports 103 and 106 (Ledger Day Books with linked allocation details)||250
||Purchase and Sales Ledger Contact Details Extract Into EXCEL||F.O.C.|
||Sales Ledger Module Settings – Printout||10|
|The module settings set against each tab are printed out per tab section to offer a record of how the Sage module has been set up.|
|155||Time Taken to Pay Sales Invoices – Enhanced||25|
|This new report can be set to show the invoice details as per the original Sage report but can also report the days taken to pay calculated on the Due Date rather than the standard Transaction Date.
||Sales Ledger Net Sales by Calendar Month||250||>>>>>|
|The trading periods are only stamped with a beginning and end date – the reported year and month is pulled from the period end date. This report can span multiple years.
|163||Customers and their Document Layouts||F.O.C.|
|This report displays the Statement, Credit Note and Invoice document mapping used for each selected sales ledger account.|
|165||Sales Accounts linked to Head Office||F.O.C.|
|This report has been created to select sales ledger accounts which have been set as Head Office accounts and report back their linked Branch account(s).
||Sales Ledger Alerts – Enhanced||199|
|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.
||S/L Credit Control – All in a SINGLE Report||199|
|Report 107 plus the ageing by TRANSACTION, POSTED or DUE dates. A Due Date report is now possible RETROSPECTIVELY!|
||Sales Ledger Transaction (Current) Listing – Foreign Currency
|The standard Sage report has been modified to show The Document and Base currency values and the effective exchange rate of the transaction.
||Aged Debtors (Detailed) with added columns to analyse the base values split into Net & VAT||149|
|The standard Sage Aged Debtors report with two additional columns for the outstanding Net and VAT. The Grand total Summary at the footer of the report also analyses the Net and VAT values under the aged columns.|
|181||Sales Ledger Receipt showing linked allocations to the customer’s payment||P.O.A.|
|A mini statement to confirm the posted receipt to a customer’s account and the related transactions to which has been allocated.|
|189||Sales Ledger Receipt Transactions Linked to Allocations.||49|
|This report has been designed to help report back allocations preventing a retrospective Aged Debtors agreeing with the Sales Ledger Nominal Control account.|
|191||Sales Ledger Invoicing Transactions reported together with ALL customers without transactions..||49|
|The standard Invoicing report amended to enable all Customer Accounts to be listed in the report regardless of no transactions for those customers within the selected BETWEEN date range.|
|195||Sales Ledger Transactions with Back Dated Allocations||F.O.C|
|This report has been created to select sales ledger transactions that have a Transaction Date in one month and associated Allocation Date in a previous month. Show More|
|197||Sales Ledger Transactions Not Matching DEBTOR CONTROL Transactions||F.O.C|
|Created to help reconcile ledgers at Period End|
|198||Sales Ledger Transactions In Nominal Pending & Deferred Postings||F.O.C|
|Created to help reconcile ledgers at Period End|