IN THIS SECTION
Overview
The Sales by Customer Report shows Sales (from invoices and credit notes) grouped by customer. Only approved Invoices and Credit Notes are included.
NOTE This report currently only includes Invoices and Credit Notes. It does not include other items such as Payments, Spend Money or Journal Entries so may not reconcile exactly with other financial reports.
Report Filters
The Sales by Customer report includes the same report filters and actions as the other financial reports - such as selecting companies, dates and currencies, downloading to Excel and adding to Report Packs - more information on these filters can be found in the Running Reports article.
NOTE The Invoice or Credit Note Date will be used to filter based on the dates selected.
Other Report Options
The report includes other options as follows:
| Option | Description |
| Show Tax | Display the tax amount for each invoice/credit note and in the customer total. |
| Show Net | Display the Net Value of invoices and credit notes - the customer total will show the total of the Net Values. |
| Show Gross | Display the Gross Value of invoices and credit notes - the customer total will show the total of the Gross Values. |
| Show Balance | Display the customer account balance after the Invoice or Credit Note has been applied - the customer total will show the total customer account balance for the selected period. |
| Compact View | Switch to compact view - this view reduces the number of columns being displayed by displaying the values in a single column. |
Sorting
You can sort the results by clicking on the column headings. Clicking once will sort ascending, clicking again will sort descending. The arrow icon next to the column heading shows the current sort order. Combining this with the Top 10 toggle gives you the ability to hone in on the most important results.
Drilldown - Viewing Invoices and Credit Notes
To view the details of each Invoice and Credit Note that makes up the total, click on the customer name. The details will be shown below the customer total line. Invoices are marked with an (i) and credit notes with a (cn). To hide the details simply click on the Customer name again.
FX
For more information on how FX is applied on the Sales by Customer report see this article.