The obligation to record the volume of turnover of alcoholic beverages in a special accounting journal is enshrined in clause 11 of Decree of the Government of the Russian Federation dated June 19, 2006 No. 380. The form of this journal, as well as the procedure for filling it out, were approved by Order of the Federal Alcohol Regulatory Agency No. 164 dated June 19, 2015 (hereinafter referred to as Order No. 164) . The need to maintain such a log by retailers of alcoholic and alcohol-containing products was introduced on 01/01/2016. Read more about this in the comments. Both organizations selling alcoholic beverages at retail and individual entrepreneurs selling retail beer, beer-based drinks, cider, poire and mead must keep a log. Subsequently, the information recorded in the journal is used by them when filling out declarations on the volume of production, turnover and (or) use of alcohol and alcohol-containing products (clause 3 of the Procedure, approved by Order No. 164). This means that the journal, in fact, is one of the documents on the basis of which control over the circulation of alcohol will be carried out. You must fill out the log when selling both food and non-food alcohol-containing products.
As for the electronic form of the journal, as reported on the Rosalkogolregulirovanie website, the EGAIS personal account has the ability to automatically generate an accounting journal based on data received from the technical means used to work with the system. This means that alcohol retailers connected to EGAIS do not need to keep a log manually - information about the alcoholic products sold will be entered into it automatically.
Please note: there is no legal requirement for alcohol retailers to regularly provide the log to regulatory authorities. But taking into account the fact that Order No. 164 provides for the mandatory presence of such a journal, regulatory authorities have the right to demand familiarization with its contents during control activities (for example, during an inspection).
The absence of a log book for the retail sale of alcohol and alcohol-containing products, as well as violation of the procedure for filling it out, may become the basis for bringing the seller to administrative liability on the basis of Art. 14.19 of the Code of Administrative Offenses of the Russian Federation (clause 7 of the letter of the Rosalkogolregulirovanie dated September 1, 2014 No. 17141/03). The fine for such a violation may be:
- for officials - from 10,000 to 15,000 rubles;
- for legal entities - from 150,000 to 200,000 rubles.
Simultaneously with the imposition of a fine, it is possible to apply such a measure of liability as confiscation of products that were the subject of an administrative offense.
We notify you that June 19, 2015 Rosalkogolregulirovanie FSRAR was canceled and introduced published, which approved a new form for recording the volume of consumption (retail sales) of alcohol and beer, this form is correctly called "Logbook for recording the volume of retail sales of alcoholic and alcohol-containing products".
The order was to come into force on January 1, 2016, respectively, a logbook for recording the volume of retail sales of alcoholic and alcohol-containing products will have to be carried out from 01/01/2016.
Also, in addition to the Retail Sales Logbook, a system is being introduced.
This register of retail sales of alcohol and beer will be are required to operate both organizations selling alcohol (licensed) and beer.
Retail logbook must be maintained, either in in paper form, or in electronic form using software (Unified State Automated Information System for recording the volume of production and turnover of ethyl alcohol, alcoholic and alcohol-containing products).
A log must be kept daily separately for each outlet.
Journal of accounting for the volume of retail sales of alcoholic and alcohol-containing products (form/blank) –
A ready-made magazine template with a title page for printing and maintaining at the point of sale (download ready template) –
Let's take a closer look at what a journal is for recording the volume of retail sales of alcohol and alcohol-containing products.
Explanations. How to fill out a journal for recording the volume of retail sales of alcoholic and alcohol-containing products.
The journal for recording the volume of retail sales of alcoholic and alcohol-containing products is a table that represents daily detailed report on alcohol and beer sales.
The first thing to be filled in is the basic details of the organization or individual entrepreneur (IP):
- Name of organization details or FULL NAME. individual entrepreneur (IP):
- TIN/KPP of the organization or TIN of an individual entrepreneur (IP)
- Point of sale address where the sale takes place (sale of alcohol and beer)
The alcohol and beer logbook itself includes the following columns:
1. №
- serial number of the record
2. Retail date- here you need to indicate the date of sale of consumer containers (packaging) of alcohol and beer, if the organization or individual entrepreneur is a catering establishment, then the date of opening of the container is indicated.
3. Barcode- here are the symbols that are contained in the two-dimensional bar code, which is printed on a federal special excise stamp or excise stamp. I advise you to purchase a special scanner that will read all this.
*
If the journal is kept in in paper form, column 3 is not filled in, if alcohol or beer is not subject to labeling in accordance with Article 12 No. 171 of the Federal Law.
4. Product name- the name of the alcohol and beer is written exactly as written in your accompanying documents, for example Vodka “Belenkaya”.
5. Product type code- the product code is written here in accordance with the Classifier of Product Types.
6. Container capacity (packaging) (l)- the capacity in liters of packaging/containers of alcohol or beer sold is indicated here.
7. Quantity of containers (packaging)- here you need to indicate the number of packages/containers of alcohol or beer sold.
*
If the journal is kept electronically using , columns 4,5,6,7 are not filled in.
Results according to the register of retail sales of alcoholic and alcohol-containing products filled every day at the end of the day must be brought totals by product type codes (column 5) for each item (column 4) and number of pieces (7).
An example of filling out a journal for recording the volume of retail sales of alcohol and alcohol-containing products (in paper form), as we understand it ourselves
Rosalkogolregulirovanie FSRAR also reports that in case of violation established procedure for accounting for alcohol and beer, organizations will be punished with an administrative fine in accordance with Article 14.19 of the Code of Administrative Offenses of the Russian Federation.
Punishment for violating the procedure for accounting for alcohol and beer, failing to keep a journal for recording the volume of retail sales of alcohol and alcohol-containing products
Article 14.19, Code of Administrative Offenses of the Russian Federation
Violation of the procedure for recording alcohol and beer and failure to keep a log of the volume of retail sales of alcohol and alcohol-containing products entails the following fines:
- For organizations (legal entities) – 150,000 - 200,000 rubles.
- For individual entrepreneurs (individuals) – 10,000 - 15,000 rubles.
P.S. Due to increasing attempts to copy the content of this article.
We remind you that this text is the object of intellectual property of the site administration.
Copying, rewriting, rewriting and posting in other sources of this article is PROHIBITED!
We allow you to place a link on your websites to the article, but NOT copy this text.
Read more about our measures to combat content theft.
Today, the sale of alcoholic beverages requires keeping a logbook. Since the document was introduced recently, many people have different questions. It’s worth asking how to fill out the documentation, where to get a sample, and how to keep such a log in retail.
How to keep a log of retail sales of alcoholic beverages in 2018
June 2015 was remembered for the adoption of Order No. 164, which was issued by Rosalkogol regulation. This provision regulates the recording of the volume of alcoholic beverages on sale through journaling. Each point of sale is obliged to register products in this document every day. Keeping a journal of the volume of retail trade of alcoholic beverages is mandatory for each enterprise engaged in the relevant type of activity.
The use of standard documentation can be checked by the FSRAR service, which regulates the alcohol market. The filling can also be checked to ensure compliance with established standards. Therefore, it is recommended to anticipate possible situations, carefully fill out documentation and monitor changes in legislation. It was previously reported that the adopted federal law would come into force in December 2015, but in reality its effect only began in January 2016. Therefore, inspections in the month of May or July for the entire next year are carried out according to the new regulations.
How to fill out a journal - rules for individual entrepreneurs
Counting of alcohol-containing products must be carried out on paper or on a computer. The electronic sample is connected to the EGAIS system, which serves for automatic accounting. EGAIS controls the production and volume of turnover of alcoholic beverages in Russia.
A paper version of recording the volume of retail sales of alcoholic beverages also ensures record keeping. An individual entrepreneur, as a seller of alcohol, must also maintain this document.
The accounting document form contains the following columns:
- Record number;
- Sales time;
- Bar code;
- Code for the type of product;
- Name;
- What was the container in terms of capacity;
- How much of the drink was sold?
The individual entrepreneur must also fill in the details, tax identification number and address where the point of sale is located. A simple example of how to fill out the form can be seen in various videos on the Internet. The form for filling out the journal in accordance with the law is available on the Internet. You can print a universal journal form for individual entrepreneurs using Excel or Word. The proper filling procedure is the same for a large organization or a single entrepreneur. However, a separate document for the turnover of goods must be filled out for each place of sale.
Is it necessary to approve a journal for recording the volume of retail sales of alcoholic beverages?
Many entrepreneurs also ask whether there is a legal requirement to approve such documentation. The order of Rosalkogolregulirovaniya contains information on the regulation of production and sales. A new sample of accounting documentation must be completed and can be signed by the director of the organization. If the enterprise has accounting activities through the Unified State Automated Information System, then the introduction of additional documentation will not be necessary. The EGAIS application, as an information carrier in an electronic accounting system, independently systematizes and registers information.
As a rule, products containing ethyl alcohol undergo production control. Registration with EGAIS using a bar code will also allow you to check whether the product is being sold for real and whether its expiration date has expired. The enterprise must use at least one form. If an organization has two points of sale, you will need to keep separate journals, where the first and second are filled out according to the same principle.
From January 1, 2016, stores must keep a log of sales of alcohol, alcohol-containing products and beer (Order No. 164 of June 19, 2015). The Federal Tax Service fines for the absence of a journal - officials pay up to 15,000 rubles, and legal entities up to 150,000. We will show you how to fill out a journal and how to make keeping it simpler.
Rules for keeping a log of alcohol sales
Who is required to keep a journal:
- Retailers of alcoholic and alcohol-containing products
- Stores of draft beer and beer drinks (cider, poiret, mead)
- Catering enterprises
You need to keep an alcohol log even after connecting to EGAIS. If you have a chain of stores, then each branch should have its own magazine.
When to make a journal entry
No later than the next day after the sale of alcohol.
If a store sells draft alcoholic drinks, then the log must reflect the fact that the transport container has been opened.
Magazine form
A journal is a table with a set of fields. You can fill it out in a notebook or notepad.
The log can also be kept in an Excel spreadsheet. If they come to you to check, print out the magazine and show it. The main thing is to fill out the required fields and follow the form.
Journaling using EGAIS
You can keep a log using EGAIS if the store is connected to the system and sends data on alcohol sales to FSRAR. The store owner will be able to print the magazine in his personal account on the FSRAR website.
Mandatory information
Entrepreneur and store details:
- Name of organization
- Full name of individual entrepreneur
- TIN (personal)
- TIN of an individual entrepreneur
- Store Address
Information about sold items:
- Serial number (column 1)
- Date of retail sale (column 2)
- Bar code (grade PDF-417) (column 3)
- Product name (column 4)
- Product type code (column 5)
- Capacity, l (column 6)
- Quantity, pcs (column 7)
Difference between paper version and electronic version
In a paper journal, you do not need to fill out column 3 “Barcode”.
When maintaining a journal using EGAIS, all fields are filled in automatically.
Every day you need to record sales results in the journal:
- Total for each code type of alcoholic beverages
- Total by name of each type of alcoholic product
- Total by quantity (pcs)
Advice: If you keep a journal in electronic form, print out pages with sales for the shift every day and put them in a separate folder. In this case, the check will not take you by surprise.
Maintaining an alcohol journal with Viki cash registers
The cash register program automatically records all data on alcohol sold. You do not need to fill out any fields. To print a magazine, you just need to select a time period. For example: from 01/01/16 to 04/1/16.
We recorded on video the entire process of selling alcohol - from scanning the barcode to recording the sale in the log.
Specialization: Trade automation, Online cash registers, EGAIS, compliance with 54-FZ, Trade equipment, Antiviruses, application software.
Categories:EGAIS and Alcohol Sales Logbook
In this article we will talk about all stages of the implementation of EGAIS in retail. What fines are imposed and how to connect to the Unified State Automated Information System in Astrakhan. The material is constantly updated.
Update from 10/11/2016
From 10/01/2016, the balances of alcoholic products must be synchronized with data in the Unified State Automated Information System.
Update from 07/11/2016
EGAIS: First blood
Well, we waited. The sudden arrival of the first of July marked the beginning of alcohol sales through EGAIS. Typically, this event did not cause a storm of delight among the participants in the process. Moreover, there are already the first sad results for business.
So quite recently there was one instructive story from which conclusions should be drawn. Representatives of the Rosalkogolregulirovaniye service paid a visit to one of the grocery stores (I will not specify the name for ethical reasons). During the inspection, they seized several bottles of her darling, prepared for sale. The motivation for the seizure was something like “there are signs of falsification.” And this despite the seller having all the necessary documents.
After an examination, it was determined that the seized alcohol was of dubious origin, and a fine of 200 thousand rubles was imposed on the organization. The amount, to put it mildly, is not small. Be that as it may, it is difficult to oppose anything to the letter of the law. More precisely, the liability is subject to “Turbage of alcoholic products without labeling (Part 4 of Article 15.12 of the Code of Administrative Offenses of the Russian Federation).” In legal terms, the one from whom the counterfeit was confiscated is the one to blame. This does not eliminate the responsibility of the supply chain, but the first blows fall on retail entrepreneurs.
Checking stamps in egais
To avoid such a fate, now each labeled bottle of alcohol should be checked on the FSRAR resource “Verification of brands”, available at https://service.fsrar.ru/auth/login. Login to it is carried out using a hardware cryptokey (that same Jakarta). Access also requires Internet Explorer version 9 or later and a plugin installed upon first login.
In the barcode entry window, you are asked to scan excise stamps (up to 10 pieces per request), after which the codes will be checked against the database, and the answer for each will appear on the screen. It is better to put those bottles whose brands cannot be scanned right away out of harm’s way.
Some time ago, the opinion was actively discussed that the system “won’t take off”, and EGAIS would one way or another be curtailed, or at least put away in a long box. However, as one famous character from Bulgakov’s imperishable story used to say, a fact is the most stubborn thing in the world. And here are a few stubborn figures cited by Gazeta.ru:
The amount of accrued taxes on ethyl alcohol and alcoholic products increased over 5 months of this year by 49% (about 30 billion rubles in absolute terms)
Of the 648.8 thousand deciliters of alcohol tested over 5 months, 269.8 thousand deciliters (about 42 percent) turned out to be illegal. According to the PAP service, 95% of retail organizations with licenses have already connected to the system (which, however, does not mean stable and well-functioning operation).
Based on this, the state will definitely not give up the idea of whitewashing the alcohol market, thus replenishing the budget. So, if EGAIS has not taken off, it is very close to it.
Update from June 15, 2016
The second stage of implementation of EGAIS
Before the echoes of cries of indignation at the first stage of the EGAIS implementation had died down, the second stage loomed on the horizon, playfully waving new problems. Time will tell how difficult it will be, but something tells me that I shouldn’t expect an easy walk.
What exactly are we talking about? For those who have not yet had time to sip grief, I will explain. Starting from January of this year, the state wants to know what kind of alcohol and in what volume trade organizations purchase. For this purpose, the Unified State Automated Information System (USAIS) was developed, which is a database into which information about the circulation of alcoholic beverages is collected via the Internet. Its implementation has already caused a lot of trouble, but the attempts of business to shout to those in power were akin to a quixotic fight against windmills.
EGAIS in retail
In the summer of the same year (more specifically, from July 1), the second act of the Marlezon ballet starts. This time, data on retail sales of alcohol will begin to be transmitted to EGAIS. It will look like this: on the designated day, the program at the checkout will slightly change its behavior. When you try to sell a product that contains a sign of labeled alcoholic beverages in the product group, a window will be displayed on the screen with a hint that in addition to the barcode, you must also consider the excise stamp. The cashier, armed with a 2D scanner, performs the required action. After the receipt is generated, the system will automatically send a request to EGAIS, and upon receiving confirmation, print a receipt with a QR code reflecting the fact of sale and information about a specific product.
How to avoid printing a QR code on a receipt
Some time ago, the topic of the need to print this very QR code was actively discussed on the relevant Internet resources. And as it turned out, there is no such need. The receipt must contain information about the alcohol sold, and the code can be replaced with a link to the FSRAR resource containing such information. That is, from the point of view of the law, there is no need to update the firmware of fiscal devices to print QR codes. However (as practice shows) this does not mean that changes will not be promptly made to the law to state the opposite.
Checking excise stamps for counterfeit goods
The issue of checking excise stamps deserves special attention. At the moment, through the efforts of FSRAR, an appropriate service has been created that allows you to scan an excise tax to determine whether a product is counterfeit. The trouble is that the web interface on this resource is quite slow. Login is carried out through your personal account (how to access it is described in the FSRAR information message).
Moreover, excise stamps are verified one by one. An alternative option is with “CheckMark2” software installed. The cost of such a gadget varies widely, and starts from 80,000 rubles. Taking into account the fact that many organizations have several points of sale, the solution to this issue becomes truly “golden”. However, not everything is so sad. Craftsmen write external processing for 1C day and night, allowing you to enter your personal account, bypassing browser brakes, and upload up to 10 excise stamps per request for verification.
You can only work for three days without the Internet
The question immediately arises - what if the connection with the EGAIS server is lost at the time of sale? After all, the quality of communication channels is not always ideal. In this case, a time buffer of 3 days is provided. During this time, the transport module gives the go-ahead for printing receipts, obediently issues QR codes, and carefully stores sales information. At the moment the connection is restored, it reaches out with all its virtual tentacles to its native server, where it transmits the data. The question to the specialists of the Federal State Unitary Enterprise “CenterInform” about what will happen if the Internet cannot be repaired during this time remains unanswered.
Update from 1.03.2016
Fines in EGAIS
From January 1, 2016Without connecting to EGAIS, alcohol retailers will not be able to legally accept alcohol from the supplier. Violation of the established accounting procedure (Article 14.19 of the Code of Administrative Offenses of the Russian Federation) threatens with an administrative fine:
- for officials it will be from 10,000 to 15,000 rubles,
Selling alcohol without connecting to EGAIS will be illegal. If the store is not able to read the barcode from the bottle and send it to the FS RAR for “approval,” you cannot print and sell a bottle of alcohol.
In accordance with Article 14.19 of the Code of Administrative Offenses of the Russian Federation, the following fines are imposed for violation of the procedure for recording information in the Unified State Automated Information System for reporting on the volume of production and turnover of alcoholic products:
- for individuals (company manager) – up to 15,000 rubles,
- for legal entities - from 150,000 to 200,000 rubles.
Fine for not registering alcohol sales
If a company (LLC or individual entrepreneur) does not keep a log of sales of alcoholic products, it can be fined under Article 14.19 of the Code of Administrative Offenses of the Russian Federation for violating the established procedure for recording ethyl alcohol, alcoholic and alcohol-containing products during their production or circulation (sale).
The fine is:
- from guilty officials - from 10 thousand to 15 thousand rubles,
- from legal entities - from 150 thousand to 200 thousand rubles.
Answers to frequently asked questions
Answers to frequently asked questions about EGAIS from the FSRAR website
Retail trade organizations must, no later than April 20, register in the Unified State Automated Information System the products purchased in the first quarter of 2016.
The movement of alcoholic products from one separate division of an organization to another separate division of an organization carrying out a licensed type of activity and specified in the licenses is carried out only if the documents established by Article 10.2 of the Law are available.
In this connection, information about the circulation of alcoholic products, in this case about internal movement, between separate divisions must be recorded in the EGAIS system.
Information in question-answer format from the forum http://www.carbis.ru/forum
Question: Should organizations keep a sales log in public catering, from what date? What are the features of journaling for catering?
Answer: Organizations must maintain a retail sales journal from 01/01/2016. According to the procedure for filling out the retail sales log: The log is filled out no later than the next day after the fact of retail sale of each unit of consumer packaging (packaging) of alcoholic and alcohol-containing products, or upon opening of the transport container (including reusable containers) used for the delivery and subsequent bottling of products to the consumer (hereinafter referred to as transport packaging).
Question: Does the logbook not take into account the write-off of alcohol?
Answer: Absolutely right, there is no need to write off alcohol in the “Logbook of Sales of Alcoholic Products”. The log records each whole (unopened) container of alcohol sold. When selling alcohol by portion (on tap or as part of cocktails), the container is considered sold at the moment it is opened. This also applies to transport containers, such as beer kegs or large containers of wine.
Question: Where should the magazine be submitted? What if the magazine is lost? (the base flew off, the PC broke, etc.)?
Answer: There is no need to submit the “Alcoholic Products Sales Log.” In case of verification, you must provide it in printed form to the authorized bodies. The magazine must be stored for 5 years. To ensure that the log is not lost, we recommend making archival copies of the database of your accounting system (in which the “Alcohol Products Sales Log” is kept).
Question: Can an organization move alcoholic beverages between separate divisions (from one to another)? What documents are required to document this movement? Need confirmation in EGAIS?
Answer: According to paragraph 16 of Article 2 of the Federal Law of November 22, 1995 No. 171-FZ “On state regulation of the production and turnover of ethyl alcohol, alcoholic and alcohol-containing products and on limiting the consumption (drinking) of alcoholic products” (hereinafter referred to as the Law) under the turnover of alcoholic products means procurement (including import), supply (including export), storage, transportation and retail sale, which are subject to the Law.
The movement of alcoholic beverages from one separate division of an organization to another separate division of an organization carrying out a licensed type of activity and specified in the licenses is carried out only if the documents established by Article 10.2 are available.
An active discussion of innovations in the field of alcohol trade is taking place on the forum http://olegon.ruThe movement of products from one separate division of the organization to another division must also be registered in EGAIS from 01/01/2016. At the same time, all separate divisions between which the movement is carried out must be connected to the Unified State Automated Information System, since the movement must be documented with invoices and certificates “B” and recorded in the Unified State Automated Information System.
Here are some interesting user quotes:
PAP is linked everywhere to the address and checkpoint of the retail outlet. It generates certificates using them. At the same time, RAR says that if he came to a store selling alcohol, then there should be a computer on the store premises with a key installed for exchanging data with the Unified State Automated Information System. Not in the next building, not in the central office, but in the store. (This is in that big video I gave a link to on Monday). No computer or key is already a violation and a possible fine.
Each brand of incoming alcohol must be checked through the services of FSRAR, otherwise the retailer is responsible for the leftness and unreadability of the brand;
From 01/01/2016, the fact of purchase (and internal movement between “stores” 1.28) must be reflected by retail trade organizations;
EGAIS inspections have begun
The prosecutor's office has begun checking compliance with legislation in the area of alcohol sales.
On February 19, 2016, information appeared on the website of the Lipetsk Region Prosecutor's Office about its inspection of compliance with federal legislation regulating the production and circulation of ethyl alcohol, alcoholic and alcohol-containing products.
During the inspection, violations were identified that served as the basis for the adoption of prosecutorial response measures - the volume of retail sales of alcohol and alcohol-containing products was not taken into account, i.e. The same “Accounting Journal...” was not filled out.
Update from 02/15/2016
First results of implementation - comments from market participants
On January 1, the Unified State Automated System for Control over the Production and Turnover of Alcoholic Products (USAIS) began operating. From this moment on, all alcohol suppliers and retailers had to connect to the system and enter data about their goods. The system was tested in a number of large chains, including Magnit, Dixy, and X5 Retail Group. And although none of the market players expected the launch to be painless, the collapse in sales of alcoholic beverages, which market participants feared, was avoided. The editors of Retail.ru asked market players to comment on the first results of working with EGAIS. Dmitry Potapenko, CEO Management Development Group, Inc.
EGAIS is not a problem, it’s complete bullshit. I won’t tell you for the whole of Odessa, but we live on old leftovers, and our assortment has already dropped by 30%. I don’t know, maybe we don’t know how to work. But the fact remains that holes in the assortment have to be replaced with other items, because working with suppliers is now simply terrible. The main problem is that the system works with very severe glitches, so it hasn’t given us anything good yet. I don't expect anything good from the system.
Boris Rodionov, founder of the private distillery Rodionov and Sons
I hate this EGAIS, because I understand that no one needs it, there is no EGAIS anywhere in the world. I produce alcohol in Poland, and sell it all over the world, in England, France, America, and China - there is no EGAIS anywhere. As a result, we have a lot of people involved in EGAIS, they have tortured all the manufacturers and sellers, and this system is constantly not working for them. If social vodka appears, then normal laws will appear, instead of a hysterical fight against counterfeit goods, and then EGAIS will not be needed.
X5 Retail Group, press service representative
Since January 1, all X5 distribution centers have been recording alcoholic beverages in the Unified State Automated Information System. There were minor difficulties, mainly in the first days of the New Year, during the New Year holidays. Subsequently, interaction with suppliers was streamlined and the volume of supplies was brought into line with the schedule. Products that were not previously taken into account by suppliers in the Unified State Automated Information System can be put on the balance sheet during 2016 and thus put into legal circulation. Due to the fact that X5 participated in EGAIS even at the stage of pilot implementation of the system, today there are practically no such products left in the X5 company’s warehouses.
Oksana Tokareva, Head of Corporate and External Communications, METRO Cash & Carry Russia
There are no failures in the operation of the EGAIS system. Since the system began operating, the acceptance of alcoholic beverages has been proceeding as usual. Shopping center employees responsible for working with the EGAIS system have completed all the necessary training in advance. There are no interruptions in the volume of assortment of alcoholic products and delivery times.
"DIXY", press service
Dixie prepared in advance for work in EGAIS and by January 1 completed additional system settings. Today the system is operating in working mode, there are no failures that would affect the presentation of products on the shelves, technical issues are resolved with CenterInform online. The assortment representation on the shelves in all formats of Dixy Group is maximum, there are no missing items or shortages.
We are confident that soon after the system is closed, the share of counterfeit alcohol on the market will begin to rapidly decrease.
Kirill Bolmatov, Director of Corporate Relations, Heineken Russia
Heineken began testing the EGAIS system in advance in order to be fully prepared by the time of its official launch and avoid the risk of failures. We also tried to inform our retail partners about the need for early implementation and testing of this system. However, due to the complexity and technological imperfection of the system, an uninterrupted transition could not be achieved. The system still experiences frequent and long-lasting (up to several hours) crashes and freezes. As a result, in January 2015, in some stores, cases of refusal of shipments, missed delivery deadlines, transport downtime, and even freezing of beer due to untimely shipment were recorded.
In general, this system seems to us to be working, but its practical implementation is still imperfect. We hope that all the problems and bugs that prevent EGAIS from working like clockwork will be eliminated in the near future. And of course, constant close contact between manufacturers, retailers and PAR is extremely important in order to respond as quickly as possible to any failures or identified problematic issues.
Oraz Durdyev, Director for Legal Affairs and Corporate Relations of SUN InBev JSC
We can say with confidence that at the moment the EGAIS system is not stable. Recently, on January 22, the system did not work for more than 12 hours, and users were unable to register documents. Beer trucks froze during shipment near warehouses, waiting for confirmation from the system for several hours. Product returns are also regularly observed when the partner does not see the shipment in the system: in three weeks of January, the percentage of returns reached 10% of the total volume of shipments. Company losses from such problems in EGAIS consist of several factors: damaged goods, transport downtime, overtime payments to employees. In an annual perspective, these are very significant amounts. It is important to note that even without taking into account losses from failures, working with the system requires significant investments: for example, last year all beer producers spent up to 1 million rubles per plant to implement EGAIS in production. EGAIS was initially introduced for strong alcoholic drinks, and now they are trying to adapt it to the realities of beer circulation. Problems in the system and the resulting financial losses may force some wholesalers, small and medium-sized enterprises, and retail outlets to eliminate beer from their portfolio altogether. According to our estimates, about 20% of our retail partners are now at risk.
Evgeny Pavlov, member of the board of directors of RUSALKA Group
EGAIS is an example of how the state is exercising its influence on the industry. First, the wholesaler fights for the shelf, and when he gets there, it turns out that in the neighboring hut, vodka costs 100 rubles, and ours costs 180... While half of the alcohol is sold past the cash registers, will you last long? We can reduce costs to zero and still not make money. In Yekaterinburg at 2 am I know where to buy vodka in any area of the city. And not only in Yekaterinburg. It is impossible for a legal manufacturer to compete with the black sector!
Update from 01/19/2016
The government indirectly admitted that the system was technically unready for full operation
According to the old Russian tradition, 2 days before the law on working with EGAIS for the retail and wholesale segment came into force, changes were made to it - on December 29, 2015, Government Decree No. 1459 “On the functioning of a unified state automated information system for recording the volume of production and turnover of ethyl alcohol” was issued. alcohol, alcoholic and alcohol-containing products."
The document specifies the rules for working with the system and the composition of the data that should be displayed in it.
The most surprising thing is the fact that the Government indirectly recognized the technical unreadiness of the system for full operation and granted a deferment to the retail segment for entering part of the data into the Unified State Automated Information System: paragraph 2 of the resolution states that “the information specified in subparagraphs 1 - 3, 18, 20, 25 , 26 and 30 of paragraph 6 of the Rules approved by this resolution are recorded by organizations engaged in the retail sale of alcoholic beverages, and individual entrepreneurs engaged in the retail sale of beer and beer drinks, cider, poire, mead from January 1, 2016 to March 31, 2016. (inclusive), in EGAIS no later than April 20, 2016.”
It turns out that all restaurants and bars, along with shops and hypermarkets, will be able to enter some data into the Unified State Automated Information System “retroactively,” but the main thing is that they have time to do this before April 20, 2016. And in order for them to do this, the FS RAR, according to paragraph 3 of the resolution, is obliged to approve all the necessary application forms “for recording data in the Unified State Automated Information System” by March 31, 2016, i.e. the same document that will allow you to enter information into the system regardless of the time of the business transaction associated with it.
- name, location, taxpayer identification number - for an organization or agricultural producer registered as a legal entity, as well as the reason code for registration, location of separate divisions (if any);
- name and type of product specified in Article 2 of the Federal Law “On state regulation of the production and turnover of ethyl alcohol, alcoholic and alcohol-containing products and on limiting the consumption (drinking) of alcoholic products”;
- product type code according to the classifier of product types, used when filling out declarations on the volume of production, turnover and (or) use of ethyl alcohol, alcoholic and alcohol-containing products;
- information contained in the consignment note and (or) international consignment note, a certificate attached to the consignment note (for products manufactured in the Russian Federation, as well as for imported products that are goods of the Eurasian Economic Union), certificate, attached to the customs declaration (for imported products, with the exception of products that are goods of the Eurasian Economic Union);
- numbers, dates and times of submission of applications for recording information about the organization (agricultural producer, individual entrepreneur), about products of each type and name, about the volume of production and turnover of products of each type and name, about documents permitting and accompanying the production and turnover of products, in unified information system;
- information about the counterparty(s) for the supply and purchase of products (name, taxpayer identification number, address);
- information on the volume of alcoholic products established based on the results of the inventory of alcoholic products, including indicating the numbers of federal special stamps and excise stamps applied to labeled alcoholic products;
- information about write-off of products in case of defects or other reasons;
In addition, the Government Decree determines the procedure for carrying out measures “to control the recording of information in the system.” This will be done by the territorial bodies of the Federal Service for Regulation of the Alcohol Market and customs authorities and will do this using software from a unified information system.
It turns out that for the period from January 1, 2016 to March 31, 2016, a transition period is being introduced during which enterprises in the retail segment are allowed not to enter part of the data on alcohol turnover not related to retail sales, which will need to be recorded for stores from 07/01/2016. But they still need to confirm the facts of purchasing alcohol from suppliers. Such a transition period means that the territorial bodies of the FS RAR simply will not be able to verify the physical presence of alcohol in a restaurant, bar or store with the data in the Unified State Automated Information System, because they are allowed to differ. However, they may well check the very fact of the enterprise’s work in the Unified State Automated Information System and the absence of such work (connection to the Unified State Automated Information System, confirmation of procurement facts) will constitute a violation, with all the consequences...
The Government is allocating the next three months (until March 31, 2016) to put things in order in working with the system and to prepare for the next big stage - registering the sale of alcohol in EGAIS from 01.07.2016. Whether FS RAR will have time to set everything up or a new government decree will be issued at the end of June 2016 - time will tell.
Update from July 3, 2015
The bill on EGAIS has been adopted
July 3, 2015 – official publication of the law in Rossiyskaya Gazeta.
At the moment, the system is operating in test mode, but from November 1, 2015, all alcohol wholesalers will have to install the software for EGAIS, and from July 1, 2016 - all retail stores, including sellers of low-alcohol drinks.
And by this moment you will need to have:
- POS system/ monoblock/ personal computer (),
- Internet connection from 256 kbit/sec and above,
- PDF417 two-dimensional barcode scanner,
- cash register program compatible with EGAIS software,
- installed EGAIS software (free),
- flash drive or smart card with a personal crypto key (electronic signature),
- personal account on the FSRAR website.
Over the coming year, the rules for the sale of alcohol will change dramatically. The state is introducing new strict standards. We have tried to collect the most up-to-date information about changes in legislation.
Alcohol Sales Log
Rosalkogolregulirovanie issued an order (N153) according to which all stores with a license for the retail sale of alcohol must keep a special journal - “Recording the volume of retail sales of alcohol and alcohol-containing products.”
The essence of the order is that from January 1, 2015 (the entry into force of the order has been postponed), stores must keep a log where they record all sales of alcohol (and beer too). Records can be kept both on paper and electronically.
Initial form of the magazine
According to the initial idea, if accounting is not automated, you start another notebook, each entry in it contains 15 fields. Moreover, the journal was to be filled out “as business transactions were completed,” that is, immediately after the alcohol was sold. The log is kept separately for each outlet and must be kept for 5 years. On any day, an employee of Rosalkogol can come in and ask to see the magazine. Failure to fill out the journal is punishable by a fine of 150,000 rubles. for legal entities persons
It is possible to keep a journal in electronic form using a special program - EGAIS (Unified State Automated Information System), it is provided free of charge, but not all accounting programs are able to work with it.
The order caused a storm of indignation among stores, so its implementation was postponed until July 1, 2015 (2 weeks remained, but we did not notice any noticeable movement in stores in this regard).
New draft order
A draft order has been adopted, according to which the keeping of a log of alcohol sales is postponed until January 1, 2016. The same draft proposes to reduce the number of fields to be filled out and to postpone the deadline for filling out the magazine until the next day: “the magazine is filled out no later than the next day after the fact of retail sale.” Draft order
The following changes are also required ():
- When maintaining a paper log, filling out the 68-character code from the alcohol brand becomes optional.
- The columns with the name and TIN of the manufacturer have been removed.
- Added quantity column.
- Added daily summary.
Minimum set of equipment for logging
Computer - 27 tr.A standard office computer will do. It is highly not recommended to use a laptop or netbook. As practice shows, the laptop does not work well with peripheral equipment; one by one the scanner and then the cash register stop working. Therefore, we strongly recommend using a full-fledged computer. And if you need a more compact and neat solution, purchase a POS system.
Barcode Scanner
Simple. Reliable. Barcode scanner tested by hundreds of stores in Astrakhan.
Program
It’s hard to find a cheaper retail automation software:
- It has all the necessary functionality for running a store.
- An interface that every cashier can understand.
- It takes less time to learn and get started with the program.
Installing the program and connecting the scanner is not enough. In the first months of working with 1C, the store gets used to the new accounting system: something happens to the computer and equipment, new questions arise about working in the program. These three months we will solve all problems that arise and help establish stable operation of the store.
All alcohol will be recorded in your 1C database. When selling, the seller scans the barcode from the bottle and the name of the product enters 1C. At any time, you can generate a report in the program for the Alcohol Sales Log and print it on a printer. The entire operation takes less than a minute. Errors due to human carelessness, when the sold product was forgotten to be entered into the journal, are excluded.
The use of an automated accounting system gives many opportunities to the manager.
The logical continuation of the magazine is the widespread implementation of the EGAIS system - “The main fiscal meaning of the retail accounting journal is to stimulate early connection to the EGAIS.” In 1C programs, connection to EGAIS will be implemented in the near future.
When you need to connect to EGAIS, all you have to do is purchase the necessary equipment and install a free program for EGAIS.
EGAIS
EGAIS is a program for state control over the production and sale of alcoholic beverages. By law, retail stores selling alcohol will need to install this program at their cash registers, and it will automatically transfer data on the sale of alcohol to a unified system.
According to Federal Law No. 171-FZ, in order to sell alcohol, retail stores must install a software module at the point of sale, with the help of which data on the sale of alcohol is automatically transferred to a unified system.
How will it work
Each bottle of alcohol - currently only strong and wine, but soon also weak - has a special stamp. It is marked with a PDF417 two-dimensional barcode with detailed information about the manufacturer, license, bottling date and other characteristics of the drink.
The fact of sale of each unit of alcohol must be recorded in the EGAIS system. This is done through the use of a 2D scanner at the checkout. It reads information from the stamp, the EGAIS cash register module processes it and transmits it to the Rosalkogolregulirovaniye server. And thus, accounting is carried out online. To date, the system has been installed and is already operating in some large retail chains, such as Magnit, Dixy and X5 RetailGroup - Perekrestok store.
Connection deadlines
At the moment the system is working in test mode, but:
- from November 1, 2015, all alcohol wholesalers will have to install software for EGAIS,
- from July 1, 2016, all retail stores (for rural areas from July 1, 2017),
- for beer and other fermented drinks, in accordance with the new version of the law, the deadline for mandatory accounting of their turnover in the Unified State Automated Information System has been moved to July 1, 2016.
Who can't connect?
Only retail outlets located in populated areas of less than three thousand people, where it is impossible to ensure uninterrupted data transfer, and public catering establishments are exempt from the need to connect to EGAIS. However, these reliefs are temporary. Equipping remote areas with EGAIS is planned for mid-2017. At the same time, it is planned to connect catering enterprises.
In accordance with 182-FZ, signed by the President on June 29, 2015, the following may not be connected to EGAIS:
- producers of beer and beer drinks, cider, poiret and mead with a volume of no more than 300 thousand deciliters per year;
- producers of wine and sparkling wine (champagne) from their own grapes;
- organizations engaged in the retail sale of beer, beer drinks, cider, poiret, mead, alcohol-containing products (in terms of recording sales);
- organizations engaged in the retail sale of alcoholic beverages while providing catering services.
It turns out that without a 2D scanner and a computer it will be impossible to sell alcohol?
Yes. To sell any alcohol in EGAIS, you need to install a scanner for reading PDF417 two-dimensional barcodes, a computer and a special program.
How real is this?
According to opponents of the law, the required number of scanners to automate all the country's stores simply does not exist in nature. And the very implementation of this system will cost store owners a pretty penny.
It is quite possible that officials from the Federal Alcohol Regulatory Authority will not be able to push through these innovations. But at the moment, all that can be said is that they are making significant efforts to do this.
Will the requirements for receipts for alcoholic beverages change?
Yes. Along with the receipt, the buyer must be given a slip with a QR code. The buyer can scan the code, follow the link on the Internet and read information about the drink on the EGAIS website. "EGAIS Retail" independently displays the necessary information on the slip. There is no need to install additional programs to print receipts.
Will any special maintenance be required?
No. Rosalkogolregulirovanie will launch a system for remote automatic updating of EGAIS software. There will be no mandatory tariffs for maintaining the system (as in 2006). For stable operation, the efforts of the store's full-time engineers are sufficient.
What equipment will make working in EGAIS easier?
“If one of the suppliers sends a batch of alcohol with counterfeit or incorrect barcodes, then if the “wrong” product is sold, EGAIS will send a signal to Rosalkogolregulirovanie. The store will have to pay a fine for the violation.
To avoid such situations, you should buy a data collection terminal with a built-in 2D scanner. Employees will be able to check alcohol while receiving goods at the warehouse and prevent violations.”
We need a reinforced EPC
Any reports that the company submits via telecommunication channels, from January 1, 2014, are signed only with an enhanced CES (qualified electronic signature). A strengthened qualified electronic signature is created using cryptographic means confirmed by the FSB and has a certificate from an accredited certification center, which acts as a guarantor of the authenticity of the signature.
In the event of a malfunction...
In the event of a system failure, the EGAIS program goes into offline mode, accumulating data to be sent to the server after operation is restored. The transfer delay period is no more than three days. However, this deadline is not final. It is installed for the period of test work of EGAIS. Further, it can be revised both up and down in accordance with the quality of communication at the location of the outlet.
Moratorium until January 1, 2019
Dmitry Medvedev proposed introducing a moratorium on the implementation of the Unified State Automated Information System (USAIS) in retail trade.
Industry participants do not have a clear opinion on this issue, says RBC’s source in the management of AKORT (the association unites the largest Russian networks). According to him, the decision to postpone EGAIS for retail looks correct, but a number of companies, participating in the pilot project, have already invested in the program and by the end of the year their points will be fully equipped. On the other hand, most companies are not yet ready to implement EGAIS, said a representative of the association.
The moratorium was not accepted.
There is less and less time until the system is fully launched, but the work of EGAIS still raises many questions. Rosalkogolregulirovanie is in no hurry to publish clear and precise instructions for connection. We will continue to collect data and keep you updated on changes.
You can express your opinion or ask a question in the comments.
Loading...