General Debtors Report

The General Debtors Report allows you to see a list of your customers and how much they owe for any date since upgrading to Retailer 3. Effectively, the report can be backdated to see what customer accounts would have owed on a past date, and whether they were overdue then.

Generating the Report

On the top menu bar of Retailer, click on Reports -> Customer -> General Debtors Report.
Select the Aging Types of customers to report on. For all customers, tick all options.
Choose the Customer Categories to report on, or all Categories.
Choose the Customer Account Categories to report on, or all Categories.
You can show or hide some of the columns on the report. Tick boxes to show and untick to hide.
Select End date - If unticked, report will run for today. If you need the report for a previous day, tick this and choose the date on the right.
NOTE: This will only be accurate for dates after you upgraded to Retailer 3.
Balance - This enables the report to select customers to display based on their balance.
Sort by - will order the customers on the report based on the selection.

Reading the Report

The Customer Listing Report has several columns which give you information about the customers orders.

Name - Full name of the customer
Num - The customer number in Retailer
Company Name
Address
Mobile
Phone
Email
Cred Lim- Credit Limit
Older - Balance older than 3 months
Feb, Mar, Apr - The report will list charges to the customer from this month and then the 2 previous months (for default Aging Type - End of month). It will show different headings for different Aging Types.
Balance - Total outstanding balance on the Account

Exporting the Report

You can export the report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:

PDF - Click on the red PDF button at the top of the report and choose your save destination.
Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button [...] to choose your save destination. Click OK to save the file.

Related Articles
Orders for Title Report
This is for Newsagencies Only Generating the Report From the main screen of Retailer, click on Reports -> Customer -> Orders for Title. There are a few options that can be set here: Start Date - This is the date that the report will use to check if ...
Customer Credit Limit Report
The Customer Credit Limit Report can be used to identify all customers who have exceeded the credit limit placed on their account. Generating the Report 1. On the home screen of Retailer, click on Reports -> Customer -> Credit Limit Report. 2. In the ...
Layby Report
The Layby Report lets you find all Laybys which are still outstanding, have been collected between a particular date range or for a specific customer. Generating the Report From the main screen of Retailer, click on Reports -> Sales Reports -> Layby ...
Changing Customer Menu or Pay Menu Buttons
Customer Screen Menu In the Customers screen, when looking at a Customer account, a menu can be used to perform actions on the account such as paying the account, running a report, or starting/stopping newspaper runs. You can change what options ...
Ranked Sales By Customer Report
The Ranked Sales By Customer report can provide a list of customers who have made purchases during the selected date range. These purchases can be separated by the transaction type, supplier or department. It also has the option to display the items ...

General Debtors Report

General Debtors Report

Generating the Report

Reading the Report

Exporting the Report

Related Articles

Orders for Title Report

Customer Credit Limit Report

Layby Report

Changing Customer Menu or Pay Menu Buttons

Ranked Sales By Customer Report