Sales Ledger
The Sales Ledger report is a summary of the position on each Customer's account. Together with the
Open Invoices Customer Statement and
Periodic Customer Statement reports, it is a very useful tool for debt-chasing purposes.
In its basic form, it shows Customer Name and Telephone Number and, for each Invoice, the amount outstanding, the Reminder Level, the Due Date and the age or number of days overdue. However, it can be reformatted in many different ways, and you can specify any selection you want.
When printed to screen, the History and Overview options of this report have FirstOffice's Drill-down feature. Click on any Invoice or Receipt Number to open an individual Invoice or Receipt record.
Please click
here for details about the Classification field added to the specification window by the CRM and Mail Value Pack.
- Customer
- Paste Special
Customers in Customer 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, Sales Ledger
- If you want to restrict the report to Customers of a particular Category, specify that Category here.
- Salesman
- Paste Special
Person register, System module
- Specify a salesman.
- Object
- Paste Special
Object register, Nominal Ledger
- To list Invoices with a single Object, enter that Object here. This refers to Objects entered at Invoice level, not those entered for Invoice rows. If you enter a number of Objects separated by commas, only those Invoices featuring all the Objects listed will be shown.
- 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.
- History
- With this option selected, the report lists for each Invoice any Receipts, partial payments and Credit Notes.
- Overview
- This option is a summary showing an outstanding balance, due date and age for each unpaid Invoice.
- 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 in this module. The age of each Invoice is calculated from its Due 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 is calculated from its Due Date.
- Balance
- This choice simply prints only the total outstanding balance for each Customer.
- Status
- Use these options to determine which Invoices are included in the report.
- Open
- Select this alternative to include all unpaid Invoices.
- Due
- Include only those Invoices that are due for payment (i.e. those whose Payment Terms have expired).
- Sorting
- The report can be sorted by Customer Number or Name.
Introduction to Reports in the Sales Ledger
