Customer reports

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.

This report lists all or a selection of your customer accounts stored on your Sales Ledger, depending on the criteria you select when preparing the report. Use this report to identify all your customers currently stored on the Sales 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 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 EC, you need to submit an EC Sales List to the HMRC or the Irish Revenue.

For more information on producing this and how it links to the VAT Return, see Produce EC Sales List.

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 the EC Sales List requires.

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.

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 Sales Ledger 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.

How transactions are shown on the aged debt reports

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 uses the Due Date of your transactions to review outstanding balances on each account.

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.