Which sales are losing me money and what can I do about it
What products have I sold recently that had an unreasonably high or low GP%?
Low GP report on existing sales
- Select "Reports" then "List Reports" on the Navigation panel
- From the list reports tab that opens on your screen
- Click on the drop down filter above list reports and select "Custom Reports"
- Click on the "Readysell Store" button. Then click on "Browse Store"
- Download the report "Sale Invoice Line Low GP Report" from the Readysell store
When you run the report, there is a column called "price code" displayed, the meaning of this code is Price Codes
Use Changing the formatting on lists using appearance rules to highlight, in red for example, the figures that should be fixed. Then press the save button to keep those changes for next time
Use Group and report totals to help you focus you efforts in particular areas. For example by category, value sold or value on hand
Then assign the report to a team member to run regularly on a fixed day of the week or month and give them a target, like fixing at least specified number of items every time they run the report and follow up to check what they did in a way that can be measured and reward or thank them in some way if they have done well
Adjust your target over time ad the data gets more tidy
Adjust your filter to show a manageable report by increasing or decreasing the high and low GP percentages on the report filter. As you get your data under control, tighten up the criteria in your filter to be more sensitive to smaller errors
The report includes a number of examples of how conditional formatting can be used to get more information out of reports. Right click on the column heading row and open the conditional formatting manager to review the colour and shading rules used on the example report:
The GP% for high and low GP is shown on the filter query near the bottom of the report screen. Increase or decrease the GP% to suit your business. You want only a page of information on each report. Something you can action quickly. So if the report is too long or too short, adjust the filter criteria:
