DRM: Monthly Summary Declaration

All winegrowers, as well as brewers, are required to submit a DRM: each month, this involves taking inventory of the cellar, which must be consistent with the movements recorded during the month.

This extension uses the stock movements recorded in Gestan and automatically calculates the theoretical results based on the recorded movements and previous stocks: all that remains is to compare them with the inventory.

It also calculates the taxes to be paid in the case of a brewery.

Via Tools → Administration → Configurable labels, configure the types of movements. For example:

Then configure the table of correspondences between units, via Tools → Administration → Repository → Coefficient between units, to record the ratio between your reference unit for calculating DRMs (usually the bottle or the neck) and other possible units: for example, a magnum = 2 bottles, a jeroboam = 8 bottles, 1 fillette = 0.5 or 0.75 bottles (depending on the region), 12 bottles = 1 cuite, 24 bottles = 1 coma, etc.

Continue configuring via Tools → Application settings → Extension settings → DRM.

The Synth in reference unit box allows you to total by appellation rather than by appellation/centilisation on the Summary tab, converting everything into the reference unit.

It is possible to specify a number of decimal, which is useful, for example, when you have a lot of bottles, but your reference unit for wine is the hectolitre.

Specify the product family or families that correspond to the wines (or beers) sold, then the reference unit for calculations, in this case the bottle (but it could be hectolitres).

Indicate which types of stock movements should be taken into account for the totals calculations: sales in France, sales in the EU, sales outside the EU. The small magnifying glasses allow you to select one or more types of movements.

In the other <configurable> fields, you can specify three additional categories for your own needs, for example ‘Personal consumption’ or ‘Cellar tasting’. Everything else will be classified as ‘Other’.

You can also specify, if necessary, the types of movements that should not be taken into account in the calculations (for example, transactions corresponding to a withdrawal for bottling).

The First inventory date will be filled in automatically when you first access the application, or when you delete the stock history by appellation. This is the start date for stock calculations, normally the last day of the month.

Calculations based on product names

If you need to perform calculations based on your product names:

Using the additional product fields (Tools > Application settings > Additional fields), select one of the available combos as the one managing product names, and enter the possible names on the same screen.

For each product, you can now declare which name it is on the product sheet.

In the extension settings, indicate the combo box number you used to encode the names.

The same applies to capsules if you manage a CRD stock: you can designate the Capsules product family and, in the capsule combo box, specify the combo box from the product sheet that will be used to differentiate them (CRD 0.5L, 0.75L, 1.5L, etc.).

If you wish to calculate duties and taxes payable based on the volume of alcohol sold:

Using the additional product fields, enter a number for managing the alcohol content by volume (ABV, or alcohol content, or alcohol percentage) and a combo box for managing taxes, as shown below:

Here, we have declared that the first additional numerical field available for the product sheet is used to declare the alcohol content, and that the third additional combo box available for the product sheet is used to declare the possible tax regime (e.g. reduced rate, full rate, custom brewing rate). These two fields are used as the basis for calculating the taxes levied on beer production.

The 1 button allows you to set the correspondence between the tax regime and the tax rate (this avoids having to update all product sheets in the event of a change in the tax rate), which must be recorded as follows:

[name of regime] | [tax rate]

for example ‘Custom brewing|7.40’

You will also need to indicate the correspondence between the reference unit (the bottle in our example) and the litre, as shown below.

You can use a wildcard button with the ‘Table_DRM’ command to display it as a button on the Gestan desktop.

This tab displays all movements for the month. You can exclude transfer movements if you manage several different locations, for example two separate warehouses.

The table's context menu includes an option to totalise the selected lines. There is also a Remove option, which allows you to exclude certain movements.

The context menu of the list of movements also allows you to request the editing of the DRM1 report: it is a good idea to archive it at the same time as your Monthly Summary Declaration, in order to keep a paper record of the basis for the calculation. You can also print the STK2 statement of stock movements here.

The Stocks/Designation button displays the stocks by name for the current month.

Movements whose units could not be converted into the reference unit are highlighted in red on the first tab (and are not taken into account on the following tabs). Otherwise, the correct conversion is highlighted in straw yellow.

The context menu in the year/month selection area allows you to choose a free date range.

This table shows the totals by product.

If a name management combo has been declared, the results are shown by name, as below:

This table shows the totals by type of movement.

This tab is only displayed if you have set up an alcohol content combo box and a tax regime combo box.

The table shows the movements for the period, grouped by tax regime. For each line, the alcohol equivalent is calculated and the tax rate applied. The total is what you will have to pay.

These are the figures to be reported on your DRM.

You can enter the previous month's stock values directly into the table (which you will find on your previous month's DRM, of course). They will be stored for the following month, unless the current month is earlier than the last inventory month (which would not be a normal situation).

The last row is a totalling row calculated in the reference unit.

In addition, a table shows the breakdown by market, according to the types of movements you have configured.

If you have specified a name management combo, the totals are calculated by name, as shown below.

The table's context menu (below)

allows you to delete the stock history for the previous month (it will be recalculated automatically), or to delete all stock histories since the beginning. The last day of the month preceding the current month will be considered as the date of the last inventory.

Other ‘Extensions’ articles

How to install an extension