Stock - Purchases Percent Sales
Updated Wed 28 Oct 2026
Running the report
Report options
Select a start date
The first day to include. It starts on today's date. The whole of that trading day is counted, from the store's start of trade.
Select an end date
The last day to include. It starts on today's date. The whole of that trading day is counted, up to each store's close of trade, so the end date is included in full.
Search for a stock item
The stock item to check. Each entry shows the category, the item name and, if it has one, the item code in brackets, and the list is in alphabetical order. You must pick an item before the report can run. Only stock items set up for the whole brand are listed. Archived items, and items that belong to one store only, are not in the list.
The report at a glance
These are the first and last days you chose. The times always show as the start and end of those days. Each store's own close of trade time decides exactly where its trading day starts and ends, so a store that closes at 03:00 counts sales up to 03:00 the next morning as part of the previous day.
- Selected parameters: the stock item you chose.
- The store list: purchases, sales, ratio and percentage for each store.
- Brand total: the totals for all the stores listed.
Selected parameters
A panel under the title repeats the stock item you picked, so a printed copy always says what it was run for.
| STOCK ITEM |
|---|
| Meat - Beef patty 150g (BP150) |
The store list
One line for each store in the brand that is switched on. A heading above the columns repeats the stock item with its unit of measure in brackets. Stores are listed from the highest percentage to the lowest. Stores with no percentage are listed last.
| Meat - Beef patty 150g (BP150) (each) | |||||
| Store Id 1 | Store name | Purchases value (excl) 2 | Turnover (excl) 3 | Ratio 4 | Percent 5 |
|---|---|---|---|---|---|
| 1002 | Bob's Burgers Wharf | 18 450.00 | 52 700.00 | 1:3 | 35.0% |
| 1001 | Bob's Burgers Times Square | 24 600.00 | 82 000.00 | 1:3 | 30.0% |
| 1003 | Bob's Burgers Boardwalk | 9 900.00 | 49 500.00 | 1:5 | 20.0% |
| 1004 | Bob's Burgers Harbour | - | 38 400.00 | - | - |
1 Store Id and Store name
The store's number and name.
2 Purchases value (excl)
What the store paid for the chosen stock item in the period, excluding VAT. Only finalised goods received are counted, by the date the stock was received into the store. Credit notes and returns to the supplier are taken off, so the figure is the net amount bought. A grey dash means the store bought none of this item in the period, or the purchases and credits cancelled out exactly.
3 Turnover (excl)
Everything the store sold in the period, excluding VAT. This is the store's total sales, not only sales of the chosen item. Voided invoices are not counted.
4 Ratio
How much the store sold for every R1.00 it spent on the item. 1:3 means roughly R3 of sales for every R1.00 of purchases. A bigger second number means the item costs the store less compared with what it sells. Hover over the small icon in the heading to see this explained on screen. A grey dash means there are no purchases to compare with.
5 Percent
Purchases value divided by turnover, shown to one decimal place. In the example, Bob's Burgers Wharf spent 35.0% of its sales on this item. A grey dash means the store has no purchases of the item, or no sales, in the period.
Brand total
A last line adds up the stores listed.
| Brand total: | 52 950.00 | 222 600.00 | 1:4 | 23.8% |
The total purchases and the total turnover are the sums of the lines above. The brand's ratio and percentage are worked out from those two totals, so they are not an average of the store percentages. A store with sales but no purchases of the item still adds its sales to the total, which pulls the brand percentage down, as the Harbour store does in the example.
Frequently asked questions
Why does a store show a dash for purchases?
The store has no finalised purchases of this item in the period. Goods received that are still being captured, or that were received before or after your dates, are not counted. A dash also shows when purchases and credit notes for the item cancel out exactly.
Are credit notes and returns taken into account?
Yes. Credit notes for short deliveries and returns to the supplier are subtracted from the purchases, so the figure is the net amount bought. If a store returns more than it bought in the period, its purchases can be negative.
Why doesn't the purchases figure match another purchases report?
Make sure both reports use the same dates and the same stock item. This report counts finalised goods received by the date the stock was received, and archived goods received vouchers are left out. It shows the value excluding VAT, so compare it with the excluding VAT figures in the other report. Credit notes and returns are subtracted here, so look at those in the other report as well.
What do the dates and close of trade do?
Each store counts from its own start of trade on the first day to its own close of trade on the last day. If a store trades past midnight, a late-night sale counts for the trading day it belongs to. The same window is used for purchases and for sales.
Why is a store missing from the list?
Only stores that are switched on are listed. A store that has been switched off does not appear, even if it bought stock or made sales in the period.
Why can't I find my stock item in the list?
Only active stock items set up for the whole brand are listed. An item that has been archived, or that was created for one store only, does not appear. Ask head office to check the item's setup if you expect it to be there.
Does the turnover only include the chosen item?
No. Turnover is the store's total sales excluding VAT. The percentage therefore tells you how much of every R1.00 of sales went on buying this item.
Why is the brand percentage different from the average of the store percentages?
The brand line divides the total purchases by the total turnover. A large store has more influence on it than a small one, and a store with no purchases still adds its sales to the total.
Glossary
- Brand total
- The total purchases and total turnover of all the stores listed, with the ratio and percentage worked out from those totals.
- Close of trade
- The time a store's trading day ends. Sales and purchases after midnight but before this time belong to the previous trading day.
- Credit note
- A document from a supplier that reduces what you owe, for example for goods delivered short or goods returned. It is taken off the purchases.
- Percent
- Purchases value divided by turnover, shown to one decimal place.
- Purchases value (excl)
- The net amount a store paid for the chosen stock item in the period, excluding VAT, after credit notes and returns.
- Ratio
- Turnover divided by purchases, rounded to a whole number and shown as 1:n. It is the sales made for every R1.00 spent on the item.
- Stock item
- One product you buy and keep in stock, for example a beef patty.
- Turnover (excl)
- All sales a store made in the period, excluding VAT, not counting voided invoices.
- VAT
- Value-added tax, or your country's equivalent sales tax.