SECTION 184.108.40.206 - DEBTOR SALES ANALYSIS - TOP 50 CUSTOMERS
USAGE: To analyse the transaction files and print a list of your top 50 customers. The program also compares the ranking and sales with the same period in the previous year and the change since that time.
DISCUSSION: When you enter this program, the following questions will appear:
USE LONG FORMAT REPORT If you are using wide stationery, reply Y, otherwise reply N. This question will only be displayed if the relevant option is set to A, see SECTION 7.1.2.
CONSOLIDATE SUB-ACCOUNTS If you have sub-accounts in your Debtors you might wish to consolidate the report so that it gives one total per head-office. If you enter Y here, AAA/001 and AAA/002 would be totalled together under AAA. If you choose N, the individual stores would be shown separately. This is on top of the ability to sub-total by Group, etc. If you do not use the sub-account facility, your answer here is irrelevant except that an N will trigger the next question.
LIMIT TO DEBTOR GROUP If you have answered N to the previous question, you will be offered the choice to restrict the report to one Debtor Group. If you leave this field blank, all Debtor Groups will be included. The Debtor Group you enter here must be a valid Group. If you cannot remember the code, press <F9> to initiate a search.
EXCLUDE GST If you enter Y here, HiFinance will not include any GST value in the calculations.
EXCLUDE FREIGHT If you enter Y here, HiFinance will not include any Freight value in the totals. This is the Freight that you enter at the bottom of the Invoice. If you have entered Freight in the body of the invoice, HiFinance does not exclude it.
LIMIT REPORT TO [__50] CLIENTS By default the report will print only the top 50 clients. You may change this to any number from 1 to 9999. Entering a number greater than the maximum number of Debtors will cause the report to print all Debtors on file.
CUT OF AT Here you enter the year and the period number you wish to cut off the report at. This allows you to backdate the report to a completed period. Without this option, you would have to run the report immediately at end-of-period. You can choose a period in last-year, but this will not give you any comparisons or last-year rankings. If you choose a next-year period, the report will give the same results as if you have run an end-of-year and then chosen the same period in this-year. This means that you can run the report even if you have not yet run end-of-year.
To start the report, press <Enter> through each field or simply press <F10>.
The report itself will detail the current ranking. Debtor Code, the last year’s ranking, the total sales for each period in the chosen year up to and including the cut-off-period, the total of these balances, the cumulative percentage that this represents as a total of total sales, the period total of the same period in the previous year, the total last year (up to the cut-off-period) and the percentage change from last-year. At the end of the report each column is totalled for the top-50-customers, the total of all customers and what the top 50 customers represent as a percentage of the total of all customers.