HiFinance
5
SECTION
1.4.3.3 - 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>.
Specific modification, for some sites, excludes
credit-notes that contain general-ledger lines. This excludes discounts and
rebates and thus shows “gross sales”. If this modification is required for your
site, please advise your dealer or HiFinance P/L.
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.
