The Turnover by Item and Payment Type report answers how much of each item was sold and with which payment types the sales were paid. It sums the quantity, the purchase and the sale amount of each item, one row for each set of payment types its sales were paid with. Open it from Reports → Payments → Turnover by Item and Payment Type….
Filter
The Turnover by Item and Payment Type window opens first. Fill in only the filters you need: an empty filter does not limit the report. Click OK to run the report. Clear empties the filters and sets the check boxes back to their default. The window keeps the last filter you ran.

The check box in front of a filter puts its column in the result. A cleared check box also adds the rows up over that column. Item name: has no check box, so the item is always shown. A text filter finds the values that contain the text. Press F4 or click … to choose from a list.
| Filter | What it limits | Column by default |
|---|---|---|
| Date: | The period, by the date of the sale. Choose a period from the list, or Custom Dates and a start and an end date. Without dates the report covers all sales. | No column, no check box |
| Item code:, Item name: | The items. | Shown, no check box for Item name: |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Not shown |
| Item group: | The items of a group. | Not shown |
| Item tag: | Listed when item tags exist. It only filters. | No column |
| Lot:, Serial number:, Production date:, Expiration date:, Lot location: | Listed when you work with lots. A shown lot column splits the rows by lot. | Not shown |
| Sort by: | Sorts by Item or Code, ascending or descending. It sorts only by a column that is shown. | – |
The report has no location, user or partner filter: it always covers the sales of all locations, users and customers.
Results
The result opens in its own tab, with one row for each item and each set of payment types.

| Column | What it shows |
|---|---|
| Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Item Group | The item, as it is now in Items. |
| Total Qtty | The quantity sold, in the item’s Measure:. |
| Purchase Price | The average purchase price of the quantity sold: Total Purchase Amount divided by Total Qtty. |
| Sale Price | The average sale price after the discounts of the rows: Total Sale Amount divided by Total Qtty. |
| Total Purchase Amount | The sum of quantity × the purchase price saved with each sale row. |
| Total Sale Amount | The sum of quantity × price, after the discounts of the rows. |
| Payment Type | The names of the payment types the sales were paid with, separated by commas, in the order of their names, for example Card, Cash. Empty for sales without a payment. |
How the numbers are counted
- The report counts saved sales from every sale window, for example Sale and Touch Screen, and Consignment Sale. Drafts and sales still pending in another database are left out. An annulled sale no longer exists, so it is not counted.
- Returns and credit notes are not subtracted. See the Returns report for them.
- A sale counts on its Date, the date of the document, not on the day it was saved or paid.
- Payment Type belongs to the whole sale: it lists every payment type of the payments made for the document, at any date. All items of a sale paid partly in cash and partly by card go to the row of both types with their full quantity and amount. The amounts are not split by the paid amounts.
- Total Sale Amount and Sale Price include VAT when Use prices with included VAT is selected in Tools → Settings… → Special, and are without VAT when it is cleared.
- Amounts are in the main currency of the program. A sale made in another currency is counted at the rate saved with it.
Work with the results
Document opens the print preview of the result with its filters, and Export saves it to a file. Totals adds a row with the totals of Total Qtty and the amount columns. View shows the result as bars or a pie (see View Report Results). Filter → Report Filter shows the filters next to the result and runs it again as you change them, Report Filter as New… opens the result of another filter in a new tab, and Quick Filter searches the text of the rows. Refresh runs the report again. The report can also be a panel of the Dashboard.
Double-click a row or use Actions → Edit to open its item. Actions → Transform Selected Items puts the selected items, with their Total Qtty, in a new document (see Transform Document). Actions → Print Selected Items prints their labels when a quick print setup of Print Barcodes exists.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Payments → Turnover by Item and Payment Type… | The report. | Operators (the whole Reports menu) |
The report has no user filter, so it shows the sales of all users also to a user without Manage operators and view their operations. A user without Show items purchase price in the user’s settings gets the result without Purchase Price and Total Purchase Amount.
FAQ
Why is an item on several rows?
Its sales were paid with different payment types: each set of types, such as Cash, Card or Card, Cash, has its own row, and unpaid sales have a row with an empty Payment Type. A shown lot column also splits the rows.
How much money came in with each payment type?
This report does not split the amounts by payment. Use Business Date Turnover, which sums the payments by type, or Income for each payment.
Where do I see the profit?
In Profit by items. This report shows the purchase and the sale amounts, but not their difference.