Customer reports
Note: You can also track sales by using the customer accounts enquiry.
Account Analysis
Use these to keep track of your customer accounts and their associated transactions.
Open: Sales Ledger > Reports > Account Analysis.
Use the Day Book report to provide details of transactions posted to the Sales 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 Sales Ledger.
You can use this report to identify a group of transactions entered by a particular user.
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 customer name, address and contact numbers. The detailed report provides additional information covering the payment terms, turnover and balance, payment terms and account type. Use the Account Details report to provide full details of your customer records.
This report lists current transactions on the ledger in the range you specify for the report. Transactions are grouped with the relevant customer and displayed in the order in which they were added to the ledger. The report also provides totals showing values for each goods, VAT, discount, allocated and outstanding amounts.
Use this report to view customer transactions in a date range.
If you are using online payment processing, you can prepare this report using online payments.
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 details a list of transactions added to the ledger during the current period that involve VAT.
Specify the number of VAT months over which transactions are to be included. As a result of this only transactions up to 300 days old calculated from the current system date will be included. 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 customers. From this report you can identify the customers who spend most money. By comparing this report to the List of Accounts report you can identify those customers who have not traded with you 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 customer on the ledger. It also details the turnover figures for the current month and the last six months of trading for each customer. Details of future transactions which may have been posted for a customer are also included.
The summarised report displays the turnover for the current year for each customer together with the customer's account balance and the date the last transaction was applied to the account.
If you are registered for VAT and supply goods to customers in the EU you need to submit:
- An EC Sales List (ESL) to HMRC.
- A VAT Information Exchange System (VIES) return to the Irish Revenue.
This report lets you output the EC Sales List or VIES return as an XML file which you can upload directly to the HMRC or Irish Revenue website.
For more information on producing this and how it links to the VAT Return, see Produce your EC Sales List (ESL) or VIES return.
Note: You must produce your EC Sales List report before you produce your final VAT Return, as producing a VAT Return will clear out the figures that the EC Sales List requires.
From July 2022, you are no longer to submit your Reverse Charge Sales List to HMRC. For more information, see HMRC: Revenue and Customs Brief 9 (2022): VAT domestic reverse charge for mobile phones and computer chips (opens in a new tab).
However, you can still produce the Reverse Charge Sales List reports or CSV file for your own use.
You would record reverse charge sales if you're accounting for VAT as a domestic reverse charge to prevent fraud in trade between businesses within the UK centres. This is known as carousel fraud or missing trader intra community (MTIC) fraud.
-
Use the RCSL Report (Detailed) / (Summary) reports to view transactions that will appear on the RCSL.
-
Use Produce RCSL Declaration to generate a CSV file with totals of the reverse charge sales in each period.
For more detailed information about the RCSL, see Reverse charge VAT to prevent carousel fraud (UK).
You can produce mailing labels to use when you issue statements and letters to your customers.
This prints an address label for each customer account in Sage 200.
Use this to find customer 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).
Use these reports to show a list of payments or refunds from Invoice Payments. Transactions are grouped by currency and the customer account. The reports also show outstanding transactions that have not been allocated to an invoice.
Credit control
Use these reports to identify your outstanding customer debt.
Open: Sales Ledger > Reports > Credit Control.
You can produce statements to send to customers as part of your company's credit control procedures. Statements are usually issued regularly in the normal process of reclaiming debt. You can print statements at any time.
For more information, see Statements.
You can use the Aged Debtors reports to:
- Analyse the trends in your customer payments.
-
Identify which customers payments are overdue.
You can use the reports to identify which customers have not been paying you during the agreed payment terms and therefore which customers you need to target to reclaim outstanding monies.
- Reconcile the sales ledger with the nominal ledger.
This reports show you:
- All the outstanding balances on each account.
-
The age of the transactions.
These are aged using the transaction date, the due date or the accounting period, depending on your Ageing setting in the Sales Ledger Settings Processing tab. See Processing (SL settings).
The aged debtors reports show the outstanding balances for your customers, based on the data in the sales ledger on the day that the reports are run.
You can also produce the aged debtors reports for selected date in the past. To do this, select Restropective on the report criteria. The aged debt report that is produced is for the Base data for ageing date entered. Invoices paid after this date are shown as not paid. Receipts allocated after this date are shown in the report as if they have not been allocated.
The following table shows when invoices entered and paid on different dates are shown on the aged debtors reports:
Invoice details | Amount outstanding | |||||
---|---|---|---|---|---|---|
Amount | Date Entered | Invoice Date | Amount and date allocated |
Report Run 30/01 Ageing date 30/01 |
Report run 10/02 Ageing date 30/01 |
Report run 10/02 Retrospective ageing date 30/01 |
60 |
04/01 |
04/01 |
All 29/01 |
0 (fully paid) |
0 (fully paid) |
0 (fully paid) |
04/01 |
04/01 |
All 04/02 |
60 (not yet allocated |
0 (fully paid) |
60 (allocation date after retrospective date) |
|
04/01 |
04/01 |
£30 04/02 |
60 |
30 |
60 (allocation date after retrospective date) |
|
80 |
05/02 |
29/01 |
0 |
0 (did not exist) |
80 |
80 |
05/02 |
29/01 |
All 29/01 |
0 (did not exist) |
0 (fully paid) |
0 (fully paid) |
|
05/02 |
29/01 |
All 04/02 |
0 (did not exist) |
0 (fully paid) |
80 (allocation date after retrospective date) |
|
20 |
29/01 |
04/02 |
0 |
20 |
20 |
0 (transaction after retrospective date) |
29/01 |
04/02 |
All 29/01 |
0 (fully paid) |
0 (fully paid) |
0 (transaction after retrospective date) |
|
29/01 |
04/02 |
All 04/02 |
20 |
0 (fully paid) |
0 (transaction after retrospective date) |
|
30 |
29/01 |
29/01 |
All Allocated: 04/02 Allocation date: 29/01 |
30 (not yet allocated) |
0 (fully paid) |
0 (fully paid) |
29/01 |
29/01 |
All Allocated: 04/02 Allocation date: 03/02 |
30 (not yet allocated) |
0 (fully paid) |
30 (allocation date after retrospective date) |
This report shows the time taken to pay the sales invoice.
You can produce letters to send to customers with outstanding debts.
For more information, see Debtor letters.
Overview
Reports and documents in Sage 200
Designing your own reports and documents
Other tasks
Send reports and documents by email
Manage invoice and credit note layouts
Reference