The Sales by Tax Breakdown Report lists the sales document by document with their amount, VAT and total, and splits the VAT by VAT group, one column for each group. With the default columns each sale has one row for each of its items. Open it from Reports → Documents → Sales by Tax Breakdown….
Filter
The Sales by Tax Breakdown Report 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: with Item code:, Item name: and the other item filters cleared, each sale makes one row. Date: and Partner name: have no check box, so the date and the partner are 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. | Always shown, no check box |
| Item code:, Item name:, Item group: | The sales with these items. Only the rows of these items are counted. | Shown |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Shown when the item window shows barcodes and catalogue numbers |
| Location:, Location group: | Where the sale was made. | Shown |
| User:, User group: | The user in the User field of the sale. | Shown |
| Partner name:, Partner group: | The customer. | Always shown, no check box for Partner name: |
| Item tag:, Location tag:, User tag:, Partner tag: | Listed when such tags exist. They only filter. | 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 |
The report has no Sort by:. Click a column header in the result to sort by it.
Results
The result opens in its own tab. The example below has Item code:, Item name:, Barcode:, Catalogue:, Item group:, Location:, Location group:, Partner group:, User: and User group: cleared, so each sale has one row. The demo data has two VAT groups, so the last two columns are theirs.

| Column | What it shows |
|---|---|
| Operation No. | The number of the sale. It is always shown. |
| Date | The date of the sale. |
| Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Item Group | The item, as it is now in Items. |
| Location, Location Group, Partner Name, Partner Group, User, User Group | Where, to whom and by whom the sale was made. |
| Sale Amount | The sum of quantity × price, after the discounts of the rows. |
| VAT Amount Included or VAT Amount | The VAT of the rows: part of Sale Amount when prices include VAT, on top of it when they do not. |
| Total Sale Amount | The sum of quantity × price with VAT, after the discounts of the rows: the total of the sale. |
| One column for each VAT group | Named after the group in VAT Groups, in the order of their codes: the VAT of the rows in that group. Only the groups with a rate above 0% get a column. |
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 edited.
- Sale Amount includes VAT when Use prices with included VAT is selected in Tools → Settings… → Special, and then it equals Total Sale Amount. When the setting is cleared, Sale Amount is without VAT. The VAT Amount column is hidden when VAT registered is cleared there or all VAT groups are 0%.
- In the VAT group columns the VAT of each row is rounded to the decimals of the currency before it is added.
- A row of a combined VAT group (see Adding, editing and deleting VAT Group) adds all its VAT to the column of the combined group and its share to the column of each group it includes, by the rate of that group.
- Amounts are in the main currency of the program. A sale made in another currency is counted at the rate saved with it.
- Location, partner, user and item names come from the lists as they are now, not as they were on the day of the sale.
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 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 sale for editing, with the checks of Edit Sales. Actions also has Print (as in Reprint Sale), Transform Selected Documents (see Transform Document), Related Documents, Show Changes History and Split Document.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Documents → Sales by Tax Breakdown… | The report. | Operators (the whole Reports menu) |
| Manage operators and view their operations | The sales of all users. Without it User: is fixed to your name. | Operators |
A user with a Locked partner: or Locked location: in the user’s settings gets that partner or location fixed in the filter. Actions → Edit and Print follow the permissions of Edit Sales and Reprint Sale.
FAQ
How do I get the VAT of each group for a month?
Set Date: to the month, clear the item, location, user and partner group check boxes and click Totals. The totals row holds the VAT of each group for the period. The sales stay on their own rows, because the number and the date are always shown.
Why do the VAT group columns not add up to the VAT Amount?
The VAT group columns round the VAT of each row before adding it, so a few cents can differ. With a combined VAT group the VAT of a row is in the column of the combined group and in the columns of the groups it includes.
Why is a sale on several rows?
The item columns are shown by default, so each item of the sale has its own row. Clear Item code:, Item name:, Barcode:, Catalogue: and Item group: to get one row for each sale.