Supplier reports
Note: You can also track purchases, by using the Supplier Account Enquiry.
Account Analysis
Use these to keep track of your supplier accounts and their associated transactions.
Open: Purchase Ledger > Reports > Account Analysis.
This report provides details of transactions posted to the Purchase Ledger, for either a single posting date or a range of dates. The posting date is the physical posting date of the transaction; the system date on which the transaction was entered, not the date entered for the transaction itself. Therefore you can report on all entries that were made on a particular day.
If you enter transactions using other modules and they are held in the posting file for update to the ledger, the posting date is the date they were entered into the posting file and not the date they were updated to the Purchase Ledger.
You can use this report to identify a group of transactions entered by a particular user.
This report lists all or a selection of your supplier accounts stored on your Purchase Ledger, depending on the criteria you select when preparing the report. Use this report to identify all your suppliers currently stored on the Purchase Ledger.
You can produce the report in either a summarised version or a full detailed report. The summarised version lists the main account details which cover the supplier name, address and contact numbers. The detailed report provides additional information covering the terms of business, turnover and balance, payment terms and account type. Use the Account Details report to provide full details of your supplier records.
This report lists current transactions on the ledger and you can specify the range of transactions you are interested in when preparing the report.
The transactions are grouped with the relevant supplier and displayed in the order in which they were added to the ledger. The report displays values for net, VAT, discount, allocated and outstanding amounts for each transaction.
Provided you have set the ledger to use the archive history file, it is also possible to prepare this report using archived transactions.
This report is only relevant if you are using invoice authorisation. The report identifies all invoices requiring authorisation, using the query flag U for unauthorised to signify their status.
This report details a list of transactions added to the ledger during the current month that involve VAT.
Specify the number of VAT months over which transactions are included. As a result of this, only transactions up to 300 days old, calculated from the current system date, are included in the report. Use the information in the printed report to reconcile with your VAT Return transactions for the same VAT period.
Use the Trading Report to determine the level of trading activity between you and your suppliers. From this report you are able to identify the suppliers you spend most money with. By comparing this report to the List of Accounts report you can identify those suppliers you have not traded with for some time.
The Trading Report can be prepared in a detailed or a summarised format. The detailed report displays the turnover for the current year and last year for each supplier on the ledger. It also details the turnover figures for the current month and the last six months of trading for each supplier. Details of future transactions which may have been posted for a supplier are also included.
The summarised report displays the turnover for the current year for each supplier together with the supplier's account balance and the date the last transaction was applied to the account.
You can produce mailing labels to use when you issue statements and letters to your suppliers.
Use this to find supplier accounts that you have not traded with for a long time. This can be useful to find old accounts that you might be able to delete. See Managing your contact information (GDPR).
Payments control
These reports answer questions such as what discounts are available and to whom do I owe money? The reports include transactions marked as queried.
Open: Purchase Ledger > Reports > Payments Control.
Use the Aged Creditors report to determine all outstanding balances on each supplier account and the age of each debt relative to the ageing periods you specified when setting up the Purchase Ledger. You can also use this report to determine when your supplier invoices are due for payment.
You also have the option to generate the report in a detailed or summarised version. Both versions provide information relating to the supplier contact details and the basis on which they operate.
You can also prepare a Retrospective Aged Creditors report. This provides you with the additional flexibility of analysing your purchase debt across any ledger period that is earlier than the current period set on the Nominal Ledger. Invoices paid after the specific ageing date are shown as not paid and payments allocated after the specific ageing date are shown as not allocated in the report.
Note: Before preparing your Aged Creditors report you must run the Foreign Account Revaluation option if you are working with foreign currency suppliers.
Use the Due Date report to review outstanding balances on each account, aged using the due date held for each transaction.
The detailed version provides an outstanding balance on each account together with the transactions which make up the balance. The summarised version only provides the balance on each account.
This report helps you decide when to take advantage of settlement discounts. Based on the payment date you specify, the ledger identifies and reports on all qualifying entries.
Note: The suggested payments file also incorporates transactions which attract supplier discounts.
This report shows the time taken to pay the purchase invoice.
Overview
Reports and documents in Sage 200
Designing your own reports and documents
Other tasks
Send reports and documents by email
Reference