Excise Tax Declaration — is a Torgsoft option that generates a monthly report for sold excisable goods (beer, alcoholic beverages, wine products) based on your sales in the program. It is needed when you sell excisable goods at retail and must report to the tax authority every month.
Retail sales of beer and alcoholic beverages require monthly submission of the excise tax declaration. A separate logic applies to tobacco products: the 5% retail excise has been transferred to manufacturers and importers, but such goods remain excisable and must be correctly reflected in fiscal receipts. The option collects sales for the selected month, groups them by product types, and generates data in a format that corresponds to the current reporting form. As a result, you receive ready XML files — the main part of the declaration and Appendix 6 — for submission through M.E.Doc, Art-Zvit, or another electronic reporting program. Before submission, you check the report data.
The option is suitable for alcohol and beer stores, grocery stores with excisable products, bars, and restaurants. Instead of manually consolidating sales, the program prepares the report in a few steps. License for 1 year.
Excise Tax Declaration without manual consolidation
The program collects sales of excisable goods for the month and generates declaration XML files directly in Torgsoft.
What an excise tax declaration is
The excise tax declaration is a mandatory reporting form submitted monthly by business entities that sell excisable goods at retail. It reflects sales volumes by product type and the amount of tax liability. The Torgsoft option handles the technical part: it collects sales for the period, groups them, and generates files in a format that corresponds to the current declaration form approved by the Ministry of Finance.
Basic concepts
Appendix 6
An appendix to the declaration filled in for retail trade in beer and alcoholic beverages by territorial codes of sales locations.
XML file
The format in which the declaration is submitted to the tax authority. The option generates two files — the main part and Appendix 6.
Reporting document
The main declaration for the current month. It must be submitted no later than the 20th day of the following month.
Corrective document
A corrective declaration for a past period. The program inserts the tags of the period being corrected into the XML.
Product category
An attribute in the product type card by which the item is included in the report: tobacco, spirits, beer, or wine products.
KOATUU code
The code of the sales location in the company details, required for correct declaration generation.
Who this option is for
Alcohol and beer stores
Retail sales of spirits, wine products, and beer with the obligation to submit a declaration every month.
Grocery stores
Retail outlets where excisable goods are part of the assortment alongside food products.
Bars and restaurants
Establishments that sell alcoholic beverages and beer at retail and report excise tax.
Retail chains
Businesses with several sales locations where the report is generated by territorial codes of each outlet.
Who does not need it. If you do not sell excisable goods at retail, you do not need to submit an excise tax declaration — the option will not be necessary. For retail tobacco sales, note that the 5% retail excise has been transferred to manufacturers, so such goods are taxed differently from beer and alcohol.
When to connect it immediately
- You are starting to sell alcohol, beer, or wine products.
- You consolidate the declaration manually and spend a lot of time on it every month.
- You have several sales locations and the report must be generated by different territorial codes.
- Files from another program fail gateway validation due to an outdated form.
What tasks the option solves
How it looks before and after
Before
The accountant manually selects sales of excisable goods for the month, consolidates amounts in a table, separately fills in the form and Appendix 6, checks rounding, and re-enters details each time. Any change in the form means searching for the current template.
After
You select the company, month, and year, set the document status and receipt type — the program generates two XML files according to the current form. Details are inserted automatically, and before submission you check the report data.
How it works: 5 steps
Step 1. Mark excisable goods. In the product type card, specify the “Category” field: tobacco, spirits, beer, or wine products. Only items with this category will be included in the report.
Step 2. Fill in company data. In “Settings — Company”, enter the KOATUU code, tax inspection, type of responsibility, manager identification code, EDRPOU (for legal entities), as well as contacts — postal code, phone, email. This is done once.
Step 3. Add the accountant. In “Settings — Employee”, on the “Personal data” tab, fill in the “Identification code” field (TIN or passport series and number). You select this employee in the report parameters as the accountant.
Step 4. Generate the report. Open “Report — Report on sales of excisable goods (Excise Tax Declaration)”, select the company, reporting year and month, and the required receipt fiscality filter. If there are sales in the database without a specified company, enable the “Include documents without company” switch — otherwise such sales will not be included in the report.
Step 5. Select the status and export XML. If necessary, in the “Edit document” window, set the status: reporting, new reporting, or corrective. The program will generate two files — the main part of the declaration and Appendix 6. Upload them to your electronic reporting program or send them to the accountant.
Important. For the option to work, the regional standard “Ukraine” must be set in “Settings — Parameters — Service”. The filter for non-fiscal receipts and receipts without a receipt is intended for control and correction of accounting, not for the usual reporting method — before submission, make sure that the report data matches RRO / PRRO and payments.
Try the option in your business
Activate “Excise Tax Declaration” free of charge for 30 days and generate the first report using your own sales. All data remains on your computer.
Option capabilities
Scenarios by niche
Alcohol store
The owner sells beer, wine, and strong alcoholic beverages. Every month, instead of consolidating sales in a spreadsheet, they select the month and generate two XML files, which are immediately uploaded to the reporting program.
Grocery store
There are beer and low-alcohol beverages on the shelves alongside food products. Product categories are set once, so only excisable items are included in the report, without manual selection.
Chain with several outlets
The business has several sales locations. Company details and territorial codes are entered, so Appendix 6 is generated according to the relevant codes of each outlet.
Example
The example is illustrative. Previously, an alcohol store prepared the declaration manually: the accountant selected sales for the month, consolidated amounts, separately filled in the form and Appendix 6, and reconciled rounding. It took almost a working day.
After connecting the option, the process changed: product categories and company details were entered once. Now the accountant selects the company and month, sets the document status and receipt type, generates two XML files, and checks the data before submission. Report preparation was reduced to a few steps.
Which options and equipment it works with
The Excise Tax Declaration relies on sales data in the program, so it works well with fiscalization and accounting options:
- Torgsoft-Ultra or Torgsoft-Terminal — licenses with which the option works.
- Software RRO and fiscal registrar integration — for correct receipt processing from which report data is collected.
- Accounting by UKT ZED — the product code is printed on the fiscal receipt for excisable items.
Comprehensive automation. The option covers excise reporting specifically. Product accounting, sales, and fiscalization are provided by the basic Torgsoft license and the relevant options — together, they provide the full cycle from selling excisable goods to submitting the declaration.
Price and connection terms
- Licenses. Torgsoft-Ultra or Torgsoft-Terminal. The option is not available in Torgsoft-Start.
- Connection. Purchased for each workplace for separate versions, or one per local network, or one per terminal license server. Available from Torgsoft® version 2018.2.0 (DB 481) and newer. Paid annually.
- Demo version. Free for 30 days. If you have already activated the free period before, it cannot be connected again for 30 days.
How to connect
- In the program, go to “Settings — List of additional options”.
- Select “Excise Tax Declaration” and click “Activate for 30 days” for a free trial.
- For permanent use, purchase an annual license on the option page in the online store.
Frequently asked questions
What does the “Excise Tax Declaration” option do?
It collects sales of excisable goods for the selected month, groups them by product type, and generates two XML files — the main part of the declaration and Appendix 6 — for submission through an electronic reporting program.
Which goods are included in the declaration?
Only those for which the corresponding category is specified in the product type card: tobacco, spirits, beer, or wine products.
Which details must be filled in before generation?
In the company card — KOATUU code, tax inspection, type of responsibility, manager identification code, EDRPOU (for legal entities), and contacts (postal code, phone, email). In the accountant card on the “Personal data” tab — the “Identification code” field.
Can I choose which sales will be included in the report?
Yes, the report form has a receipt fiscality filter: fiscal, non-fiscal, without receipt, or their combinations. The filter for non-fiscal receipts is intended for control and correction of accounting, not for the usual reporting method.
How do I generate a corrective declaration for a past period?
When generating the report, in the “Edit document” window, change the status to corrective document. The program will generate the XML file and automatically insert the tags of the period being corrected.
Why were some sales not included in the report?
The report is generated for the selected company — it includes goods whose sale was processed from this company. If there are sales in the database without a specified company, enable the “Include documents without company” switch.
Does the value of excisable goods include the excise tax amount itself?
No, the report shows the value of sold goods excluding the excise tax amount.
Why can rounding discrepancies occur when importing into Art-Zvit?
This is related to rounding rules. The option formats value to 2 decimal places, tax liability — to 3, and excise amount — to a whole number, which corresponds to tax authority schemas.
Does the option work in the Torgsoft-Start license?
No, the option is not available in Torgsoft-Start. It works with Torgsoft-Ultra and Torgsoft-Terminal licenses.
What is required for the option to work in the program?
The regional standard “Ukraine” must be set in “Settings — Parameters — Service”. The report is generated in “Report — Report on sales of excisable goods (Excise Tax Declaration)”. The option is available from Torgsoft® version 2018.2.0 (DB 481) and newer.
How should tobacco be sold after the retail excise was transferred to the manufacturer?
The “Excise” attribute is removed from the product in the product type card so that the tax is not charged again. At the same time, the UKT ZED code is still printed on the fiscal receipt for such goods.
Does the option guarantee that the report complies with DPS requirements?
The option helps generate XML according to the current declaration form, but the taxpayer performs the final data check before submission.
How much does the option cost and for what period?
The cost is indicated on the option page; the license is provided for 1 year and paid annually. You can try the function free of charge for 30 days.
Go back to the previous step