What you'll do: see, for every customer and supplier, how much they bought or sold to you and what is still due, and compare your customer groups.
Before you start:
- Your role needs View supplier & customer report.
- Filters, print and export work as in How reports work.
Open Reports & Analytics → Reports → Contact Report.
Press Filter (Filter Contacts): All Groups, All Types (customers or suppliers), All Locations, All Contacts, and the date range.
1 Filter · 2 Total Sales · 3 Total Due Read the report:
- Total Purchases and Total Purchase Return: what you bought from the contact;
- Total Sales and Total Sales Return: what you sold to the contact;
- Opening Balance Due and Total Due: what is still open. Click a name to open the contact.
Use Export CSV, Export Excel (XLSX) or Print above the table (Current Page Only or All Records). See How reports work.
Customer group report
Section titled “Customer group report”Open Reports & Analytics → Reports → Customer Groups Report for the Total Sales of each Customer Group. Press Filter to choose All Locations, All Groups and the date range. It needs the same permission.