After saving the active collation statement, you can view and print the results of the inventory, i.e. inventory list, which reflects the calculated surpluses and shortages.

The list of goods on the Surplus/shortage tab is sorted alphabetically by default, regardless of the order in which goods are added to the Goods tab.
If you need to display the order of adding goods, set the appropriate flag in the Service > Environment settings... .

All quantities on the Surplus/shortage tab are displayed in basic units of goods measurement
In the Calculated balance column of the Surplus/shortage tab, the estimated balance is indicated in quantitative and sum terms. The estimated balance means the amount of goods according to the documents.
In the Actual balance column of the Surplus/shortage tab, the actual balance is indicated in quantitative and total terms. The actual balance is the amount that you specified in the collation statement.
The actual balance is formed as the sum of the quantity specified in the document for the goods and the quantity determined from the sets of goods with the Break into components flag, if this item is used in the set.
Example: The document indicates "Flour" in the amount of 1 kg and "Pizza dough p/f" in the amount of 2 kg.

In the set "Pizza dough p / f" for 2 kg of finished semi-finished product, 1.1 kg of the product "Flour" is spent.

Accordingly, as a result of the inventory, in the actual balances for the product "Flour" the sum of two lines is indicated (from the document and from the calculation for the semi-finished product) - 2.1 kg.
The difference between the actual and estimated balance in quantitative terms is indicated in the Surplus/shortage column.
If the actual balance exceeds the calculated one, this means that there are surpluses for the product and such product is highlighted in green.
If the actual balance is less than the calculated one, this means that a shortage has been detected for the product and such product is highlighted in blue.
The amount of the shortfall is calculated using the FIFO method as if the shortfall had been written off an outgoing invoice.
The amount of surplus can be determined in two ways:

Automatically. The surplus is valued at the price of the latest write-off of receipts on the date of the reconciliation statement. If all receipts are written off, then the surplus is valued at the price of the last receipt on the inventory date.
Manually The Surplus Price can be entered manually in the Surplus Price field (see Fig. - Jameson Whiskey).

The actual balance in sum terms is calculated as the estimated balance in sum terms plus (minus) the amount of surplus/shortage.

When receiving surpluses for goods with the “Alcoholic products” flag, in order to correctly generate the “Alcohol Declaration” report, on the “Surplus / Shortage” tab of the “Collating List” document, you must define the “Type of alc. products” and “Producer/importer”.

Both parameters are filled in manually.

In the field "Type of alc. products” it is necessary to indicate the code of alcoholic products from the dictionary “Types of alcoholic products” for goods, on the cards of which the “Alcoholic products” flag is displayed.

In the "Producer/Importer" field, select from the drop-down list the correspondent who is the producer or importer of alcoholic products, for which a surplus has formed. The list of correspondents is determined on the product card.

After saving the active reconciliation statement, the surpluses are automatically credited (at the price of the last of the unwritten receipts), and the shortage is written off at cost. That is, after saving the active collation statement, the calculated balance will be brought into line with the actual one automatically. No additional documents (incoming or outgoing invoices) are created in this case.

If it is necessary to correct the inventory data, you can copy the surplus to the receipt invoice, and the shortages to the expense invoice. To do this, use the “Document” main menu item and select the “Copy to invoice…” command or use the “Copy to invoice…” item of the context menu.

If you do not need to copy all the goods from the "Surplus / Shortage", then you can select the goods for copying using [Ctrl] or [Shift], and use the "Copy to invoice ..." item of the context menu.

A window will open on the screen:

To copy surplus: select the type of invoice - p / n and set the flag "Copy positive balances (surplus)".

If changes are made to the documents preceding the collation sheet, then the surplus and shortage are recalculated, and the actual balances of goods entered by the user remain unchanged.