Document "Data Reconciliation of Goods in the SIBU" - Technical Description (Accounting for Kazakhstan 3.0.74.2)

1. Identification

Purpose. The object is intended for reconciling data on inventory (TMC) between accounting (inventory accounts, primarily 1330) and data from virtual warehouses — a register that supports inventory accounting in the context of the ESF / SNT system (traceability system of goods in the RK). It is used by accountants and controllers to identify discrepancies in inventory balances between two data sources: the accounting contour and the electronic document contour (ESF, SNT, virtual warehouses).

Reconciliation is usually performed during periodic checks (monthly, quarterly closing) or when discrepancies in balances are detected. The analysis is built by nomenclature in terms of accounting accounts, warehouses, and sources of goods.

Where to find in 1C: section "Nomenclature and Warehouse" → "Reconciliation of TMC according to accounting data and VS" (command "Reconciliation of data on inventory items in virtual warehouses with accounting data").

Important: despite being registered in the "Documents" branch, the object is not a posted primary document — it does not generate accounting entries and movements in registers, but reads data for comparison. More details in section 5.

2. Attributes and table parts

2.1 Header attributes (reconciliation parameters)

2.2 Table parts

Grouping — management of groupings and detailing (analogous to SCD dimensions):

AdditionalFields — additional analytical dimensions added to the report (set of columns beyond the standard ones). Each row describes a field, its representation, and placement according to the attribute AdditionalFieldsPlacement.

3. Forms

Forms are built according to the model of standard reports in the configuration: the user sets the selection and groupings, and the result is output in a layout with support for detailing (DetailingMode).

4. Key procedures of modules

From evidence, one key point is confirmed; the others are standard handlers for this type of object.

• BeforeLayoutCompilation — performs validation before building: checks the filling of StartPeriod (mandatory parameter of the analysis period), forms the time range StartPeriod … EndPeriod, applies selection by AccountList and organizations, sets groupings from the table part Grouping. Manages the placement of additional fields according to AdditionalFieldsPlacement.

Standard handlers (typical for the reconciliation/reporting tool):

• OnResultCompilation / layout generation — selection of balances from two sources (accounting and virtual warehouses), matching by key (Organization + Nomenclature + Warehouse + [Source of origin]) and calculating the discrepancy column.
• Detailing / DetailingProcessing — detailing the indicator down to the registering documents when DetailingMode is enabled.
• OnPeriodChange / flag handlers — restructuring the composition of groupings when switching ByAccounts and BySourcesOfOrigin.

5. Posting and movements

The object is not posted and does not generate movements in accounting or accumulation registers. It is an analytical reconciliation tool: it only reads and matches data from two contours.

Source 1 — accounting (accounting register "Cost Accounting"): inventory balances by account 1330 "Goods" (if necessary — other accounts from AccountList) in terms of sub-accounts "Nomenclature" / "Warehouses". These accounts participate in standard postings of the inventory contour:

The VAT rate for the RK in 2026 is 16 % (3130 "VAT payable", input VAT — 1420).

Source 2 — virtual warehouses (goods accounting register of the ESF/SNT system): balances formed by issued ESF and SNT (accompanying invoices for goods). This contour records the movement of goods from the perspective of electronic document flow and traceability.

Reconciliation result — a table of balances "Accounting vs Virtual Warehouse" with a discrepancy column for each nomenclature item (and, when BySourcesOfOrigin is enabled, by sources/batches). A non-zero discrepancy indicates an unposted/unissued ESF or SNT, an error in assigning to the warehouse, or a discrepancy in quantity between primary accounting and electronic documents.

6. Related objects and input based on

• Register of virtual warehouses of the ESF system — the main source of the electronic document contour.
• ESF (electronic invoice) and SNT (accompanying invoice for goods) — documents that generate movements in virtual warehouses.
• Documents of the inventory contour of accounting: "Receipt of goods and services", "Sale of goods and services", "Transfer of goods", adjustments — generate balances on account 1330 (data source of accounting).
• Chart of accounts "Standard" — source of values for the attribute AccountList.

Input based on for this object is not provided: reconciliation does not generate new documents. As a result, the user manually adjusts ESF/SNT or primary accounting documents until discrepancies are resolved.

7. Extension points

• Configuration extension (without removing from support): adding intercepting handlers to compilation procedures for additional filtering or new discrepancy columns.
• Additional fields / variants (ReportType) — standard mechanism for adding analytical dimensions without changing the code.
• New groupings — through the table part Grouping and StandardReportDetailingType.
• List of reconciliation accounts — parameterized through AccountList; in case of non-standard inventory accounting (for example, using additional sub-accounts to 1330), the composition is set without modification.
• Integration with the ESF system — connection points to services for obtaining data from virtual warehouses (updated along with integration releases; version-dependent).

Requires verification on a specific release: the exact composition of the source register of virtual warehouses and API integration with the ESF system — they are accompanied by separate subsystems and may change between versions of the exchange platform.