Hourly statistics (called Hourly sales statistics on the report itself) shows your sales distributed across the hours of the day. It gives a quick overview of when during the day the revenue comes in, how many sales are made in each hour, and what an average basket contains. The report is based solely on register sales (sales registered in POS/the Pos) and is limited to the organizational units (for example stores/departments) you have access to.
1. Go to Product -> Products in Financial.
The report can also be accessed elsewhere, among other places via the top print menu. It is also gathered under the sales reports, so you can find it among the sales reports.
2. Click the printer icon in the top right corner of the Products page.
3. Select the report Hourly statistics.
4. Fill in the parameters (described below).
5. Click the print format you want. The report can be produced as PDF and as Excel, so you can work further with the figures in a spreadsheet.
If you cannot see the menu item or the report, you probably lack permissions — contact support.
From date / To date specify the date range for the report. If you leave them empty, the from date is automatically set to today's date, and the to date is set to the same date as the from date. The range includes sales from and including the from date up to (but not including) the to date.
Split by determines how the figures are grouped beyond the fixed grouping per hour:
The figures are split per date (and then per hour within each date). Choose this if you want to compare the hourly distribution from day to day.
The figures are split per employee (and then per hour). Use this to see when the individual employee sells.
No further splitting. The sales are added together across the entire period and shown only distributed per hour. This is the pure hourly overview for the period.
Org. unit limits the report to one specific organizational unit (for example a single store or department). If you leave the field empty, all the units you have access to are included. The report never shows sales from units you do not have permissions for.
Date is shown only when you have chosen to split by date, and indicates the day the row belongs to.
Employee is shown only when you have chosen to split by employee, and indicates the name of the employee who completed the sale.
Hour is the time of day (the hour of the day) in which the sale was completed — for example 14 for sales between 14:00 and 14:59.
Number of sales is the number of completed sales (receipts) in the relevant hour.
Avg. basket (average basket size) is the average number of sale lines/units per sale in the hour — that is, how many items a typical customer buys.
Avg. amount (average amount) is the average price per unit sold in the hour.
Rev. is the revenue in the hour including VAT.
excl. VAT is the same revenue without VAT.
% of rev shows how large a share the hour's revenue makes up of the total revenue on the report.
DB (contribution margin) is the revenue minus the cost of goods (the cost price) — that is, the profit the sales in the hour have contributed, in kroner.
DG (margin rate) is the contribution margin expressed as a percentage of the revenue excl. VAT, and shows how good the earnings are on what was sold.
Hourly statistics draws on your register sales (POS). A sale is registered at the Pos and linked to the organizational unit and the employee who completes the sale. The report gathers these sales per hour and distributes them according to your choices of Split by and Org. unit.
Which units you can include is controlled by your access permissions to organizational units. If you only have access to one store, only that store's sales are shown — even if you leave Org. unit empty.
For administrators: the report includes only POS sales (source = 2) and is filtered per organizational unit via the permission OrganizationalUnit.Access.
Want to know more?
Read more in these related articles:
Invoice / receipt (print)
A4 invoice print for a sale in the Pos.
Day-end closing
Walkthrough of the day-end closing's list view and edit view in the Pos app: columns, actions, fields, states, error scenarios and permission requirements.
