Sales Ledger

Sage 200 Reporting  –  Sage 200 Reports:

Sales Ledger

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
105
Customer Turnover – Top Customers 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 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.  
106
S/L Day Book linked to Allocations 149 >>>>> View Sample Print
Enhanced to include a criteria for the transaction date and also offer a choice to show allocation history against the selected reported transaction types.
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.
111 CONSOLIDATED Sales Ledger Statement (Single) – HO, Branch and Independent 99 >>>>> View Sample Print
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. 
117
Sales Ledger Aged Debtors Report (Detailed) – SELECTED (Aged by SELECTED method but retro by Transaction date. 99 >>>>> View Sample Print
The standard Sage Aged Debtors report modified to tabulate the ageing of the transaction by Due, Posted or Transaction Date.
128
Reports 102 and 105 (Turnover reports showing TOP Supplier and Customer account analysis) 300
>>>>>
 
Companion Pack
129
Reports 103 and 106 (Ledger Day Books with linked allocation details) 250
>>>>>
 
Companion Pack 
138
Purchase and Sales Ledger Contact Details Extract Into EXCEL F.O.C. View Sample Print
Companion Pack
144
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

>>>>>

View Sample Print
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.
162
Sales Ledger Net Sales by Calendar Month 250 >>>>>  View Sample Print
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. View Sample Print
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. View Sample Print
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).
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!
 173
 
Sales Ledger Transaction (Current) Listing – Foreign Currency
149 

>>>>>

View Sample Print
The standard Sage report has been modified to show The Document and Base currency values and the effective exchange rate of the transaction.
178
 
Aged Debtors (Detailed) with added columns to analyse the base values split into Net & VAT 149

>>>>>

View Sample Print
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.

>>>>>

View Sample Print
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

>>>>>

View Sample Print
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

>>>>>

View Sample Print
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 View Sample Print
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 Thus – when running a Sales Ledger Aged Debtors report retrospectively the outstanding amount is incorrectly adjusted. This will result in a report run to confirm the period end Sales Ledger balance from displaying the true period end balance and making reconciliation more difficult to prove.
197 Sales Ledger Transactions Not Matching DEBTOR CONTROL Transactions F.O.C View Sample Print
Created to help reconcile ledgers at Period End
198 Sales Ledger Transactions In Nominal Pending & Deferred Postings F.O.C View Sample Print
Created to help reconcile ledgers at Period End