Language:


Individual Reports - Sales Ledger

The Sales Ledger report is included in the following Standard products:
  • Standard Accounts (Sales Ledger module)

  • Standard Contracts

  • Standard Invoicing
---

The Sales Ledger report is a summary of the position on each Customer's account. It lists the Invoices that you have issued to your Customers that have not yet been paid. For each Invoice, the Due Date, the outstanding amount and the number of days by which it is overdue are shown, so, together with the Receipts Forecast and Periodic Customer Statement report, it is a very useful tool for debt-chasing purposes.

When printed to screen, this report has the Drill-down feature common to many reports in Standard products. Click on any Customer Number in the report to open the Contact record for a Customer, or on an Invoice or Receipt Number to open an individual Invoice or Receipt record.

Customer
Paste Special    Customers in Contact register
Range Reporting    Alpha
If necessary, enter here the Customer Number of the Customer (or range of Customers) you wish to include in the report.

Category
Paste Special    Customer Categories setting
If you want to restrict the report to Customers belonging to a particular Customer Category, specify that Category here.

Date
Paste Special    Choose date
If necessary, you can print a report showing the debtor situation as it was on a particular date. To do this, enter that date here. If you don't need to use this feature, leave the field blank.

Function
Use these options to control the level of detail shown in the report. In all cases, if an Invoice is overdue for payment, the number of overdue days will be shown as a negative figure.
History
Where the Overview simply shows the outstanding balance of each Invoice, this option provides more detail, listing for each open Invoice any partial payments and Credit Notes.

Overview
The Overview shows each Customer's Number, Name and Telephone Number and, for each outstanding Invoice, the Invoice Number, the Invoice Date, the Payment Terms, the Due Date, the age or number of days overdue, and the outstanding balance.

Balance
This choice simply prints the total outstanding balance payable by each Customer.
Status
Use these options to determine the Invoices that will be included in the report.
Open
The report will list all unpaid Invoices.

Due
The report will only list those Invoices that are due for payment (i.e. Invoices whose Payment Terms have expired).
Sorting
The report can be sorted by Customer Number or Name.
The following additional Function options are available in Standard Contracts:
Aged
Select this option to show in a single line per Customer the outstanding totals of all unpaid Invoices sorted into ageing periods. The distribution of the age groups is defined using the Age Limits setting. The age of each Invoice will be calculated from its Due Date, not from its Invoice Date.

Detailed Aged
This option lists for each Customer all individual unpaid Invoices, showing the ageing period in which each falls. The telephone number of the Customer is also shown. The age of each Invoice will be calculated from its Due Date, not from its Invoice Date.
---

In this chapter:

Go back to home pages for: