Customer Ranking Report

Modified on Fri, 3 Mar, 2023 at 10:49 AM

mceclip0.png

Overview

The Customer Ranking Reports displays a list of customers/clients and their value to the business over a defined period. This report is useful to see which of your customers are bringing in the most value to your business.

The report can can be run to rank customers based on total invoiced amount or it can be set to take into account customer expenses, ranking customers based on profit margin. 

The report exports to a PDF for your records.

Accessing the Customer Ranking Report

The Customer Ranking Report is located at Reports > Accounting Reports in the Sales category.

Report Configuration Options

mceclip0.png

For PeriodDate range that determines which information displays on the report. Refers to AR date of invoices. 


Make selection with calendar picker range or options for predefined ranges:

  • All historic data
    • Sets range from January 1st, 2000 to the current date
  • Last calendar month
    • Displays data for the previous month
  • Last calendar quarter
    • Displays data for last calendar quarter. The years is divided into quarters by
  • Financial year to date
    • Displays data from the start of the financial year to the current date. Respects the financial year start date defined in Accounting Preferences.
Show Customers dropdown

Determines the number of customers ranked on the report.

mceclip0.png

Top 10

Displays top 10 most profitable customers.

Top 20

Displays top 20 most profitable customers.

Top 50

Displays top 50 most profitable customers.

All

Displays all customers in the system. 

Show customers selection box

If there is no selection in the Show Customers dropdown, specific participants can be searched and selected. Only the participants selected will display on the report.

show_customers.gif

Type

 Determines by which metric customers are ranked.

mceclip1.png

Based on total invoiced $

Ranks customer Value to business on total amount billed

Based on margin $

Ranks customer Value to business totals by total fees billed minus expenses

Total value

Toggles whether an additional column for customer total to date displays on the report.

mceclip2.png

ComparisonCreates additional column on report to display the customer value for the prior year in the same date range. The prior year is the year previous the report setting year. 
PDFDenotes the report is exported to PDF. *Currently this is the only export option.

 

Producing the Customer Ranking Report

mceclip1.png

A PDF of the report will be downloaded upon selecting the Submit button.

 

Understanding the Output of the Customer Ranking Report

mceclip0.png

 

Header Information

The Customer Ranking Report header displays basic information about your company and report configuration. 

mceclip3.png

Above line header

The top portion of the header displays:

  • The report title
  • The report description
  • Your organization name
  • Your organization street address
  • Your organization city
  • Your organization state/province
  • Your organization postal code
GeneratedTimestamp of the date and time the report was generated
For PeriodThe date range for which items with are displayed on the report
SelectionDisplays the number of customers selected to be displayed on the report. If specific customers are selected, their names are displayed.
TypeDenotes whether the customer ranking is based on total invoiced $ or total margin $
Comparison periodDisplays the comparison period date range
CurrencyDenotes for which currency the report has been run

 

Customer Ranking Table

The Customer ranking Table displays the primary report information. 

mceclip4.png

All figures on the Customer Ranking table exclude tax.

Customer nameName of the customer. All data in the row is attributed to that customer.
Value to businessDepending upon the Type selection, will display total invoiced amount or total fees minus expenses.
Comparison periodDisplays amounts based on the same behavior as the Value to business column for the year prior
Total to dateDepending upon type, displays the same behavior as Value to business column but for a date range from the first invoice in the system to today's date

 

Filter Summary

The Filter Summary displays the configuration options of the report. These provide context for the figures on the report.

mceclip5.png

GeneratedTimestamp of the date and time the report was generated
For PeriodThe date range for which items with are displayed on the report
SelectionDisplays the number of customers selected to be displayed on the report. If specific customers are selected, their names are displayed.
TypeDenotes whether the customer ranking is based on total invoiced $ or total margin $
Comparison periodDisplays the comparison period date range
CurrencyDenotes for which currency the report has been run

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article