We need the ability to generate a report that shows sales broken down by individual system user. Each sale should be attributed to the user who processed or completed the transaction, allowing us to select a date range and see the total sales value generated by each user during that period.
Ideally, the report would include:
-
User/staff member name
-
Number of sales/transactions processed
-
Total sales value per user
-
Date range selection
-
Ability to drill down and see the individual transactions making up each user's total
-
Export to Excel/CSV if possible
The key requirement is that every transaction must be linked to the logged-in user who processed the sale, so that we can accurately calculate individual sales incentives.