How do I see what share of the year’s sales falls in a period?
Sales → Sales reports has two analysis reports: Analysis by product and Analysis by customer. They don’t tell you how much has been sold, because the ordinary summaries already do that. They tell you what weight the sales between some dates carry against the whole financial year, and at what average price they went out.
How is it different from the usual sales summary?
The Sales summary by product answers ‘how much of this have I sold between these dates’. The Sales analysis answers something different: ‘of everything I have sold so far this financial year, what share falls between these dates’.
That is why the analysis asks for two date ranges instead of one, and why each figure for the period comes with the one for the financial year and the percentage it represents. It shows at a glance whether an item is selling more or less than usual, or whether a customer has concentrated their year into one quarter.
What do I put in the four dates it asks for?
They are two ranges and they do different things:
- Financial year from and Financial year to are the whole you compare against. Normally it is the full year: from 1 January to 31 December. It is also the only thing that limits the search: no invoice outside this range is looked at.
- Period from and Period to are the part being analysed: the month, the quarter or the week you want to look at. They go inside the previous range.
All four are required. If you put the same range in both, all the percentages come out at 100 %: the part and the whole would be the same.
What does each column mean?
From left to right, one line per item (or per customer):
| Column | What it says |
|---|---|
| Avg. price | Average sales price for the period: the amount divided by the units. It isn’t the average of the line prices. |
| Quantity | Units sold in the period. |
| Qty % | What share of the financial year’s units was sold in the period. |
| FY qty | Units sold in the whole financial year range. |
| Amount | Tax base sold in the period. |
| Sales % | What share of the financial year’s amount falls in the period. |
| FY sales | Tax base for the whole financial year range. |
The amounts are tax base, without VAT. And only sales invoices are included: credit notes and corrective invoices aren’t subtracted here.
Why doesn’t the average price match the one on the item record?
Because it is the real average price of what was invoiced in the period, not the price list price. It comes from dividing the amount by the units of the whole set, so a sale of 1.000 units weighs a thousand times more than a sale of just one.
It is the figure that shows the effect of discounts and special prices: if the average price goes down and the units don’t go up, you are selling the same for less.
Why does an item appear with 0 in the period and with figures in the financial year?
Because it was sold during the financial year, but not on the dates of the period. It is information, not a fault: the report shows everything that moved in the financial year and marks with a zero what hasn’t been touched in the period you are looking at.
If you only want what has been sold between some specific dates, the report you are looking for is the Sales summary by product or by customer, not this one.
Which of the two analyses do I use?
Analysis by product groups by item, and uses the item on the record, not the text that was typed on the invoice line. That way the same product isn’t split into several lines because someone touched up the description when invoicing.
Analysis by customer groups by customer and answers the same questions along the other axis: who has concentrated their year in the period, and at what average price they are sold to.
Both are run like any other report, with View, Report or Data: run a report.
More about Reports
- How do I group and total a report?
- How do I change the design of an invoice?
- How do I create a custom report?
- Where is each report?
- How do I choose which layout a document is printed with?
- How do I export a report to Excel?
- How do I print labels?
- Running reports and formatting documents
- The standard reports in each area
- How do I run a report?