RUKKENZH
Задать вопрос AI
SectionsОбъекты конфигурации 1С
Report "Reconciliation of Goods Data of Organizations and Accounting" in 1C:Accounting for Kazakhstan 3.0 - Complete Guide
Язык статьи:🇷🇺 RU🇰🇿 KK🇬🇧 EN🇨🇳 ZH
Версия статьи:📘 Для бухгалтера⚙️ Для тех-специалиста

Report "Reconciliation of Goods Data of Organizations and Accounting" in 1C:Accounting for Kazakhstan 3.0 - Complete Guide

Applies to: 1С:Бухгалтерия для Казахстана, release 3.0.74.2 · by 1C-Sapa Group, 1C partner
СТ
Сапа Т.И. — Эксперт по 1С и бухгалтерскому учёту, преподаватель-практик

Checked on release 3.0.74.2 "Accounting for Kazakhstan" (version 3.0).

You send a СНТ or electronic invoice (ESF), and the system says that the goods are not in the "virtual warehouse," even though they are recorded in account 1330. Or vice versa: according to the tax data, you have 500 packs of coffee, while in accounting — 480. You have nothing to sell, you can't issue a shipping invoice, and it's unclear where the numbers have diverged. This is where you open this report. It shows line by line, in just a minute, where the organization's inventory accounting and accounting records have diverged, and by how much.

1. Purpose

The report compares two independent accounts of the same goods: data from inventory accounting of organizations (the register from which СНТ and the "virtual warehouse" for electronic invoices (ESF) are formed) and data from accounting records (account 1330 "Goods" and related accounts). It identifies discrepancies in quantity and amount so that you can resolve them before sending electronic documents to the ESF and СНТ information system.

2. Where to find

The report is located in the section where all checks on goods and electronic documents are collected:

  • Section "Reports" (or "Sales" / "Purchases" depending on the interface settings) → group "Electronic invoices" / "Inventory accounting""Reconciliation of data on organizations' goods and accounting".
  • Or through the menu "All functions" → "Reports" → "Reconciliation of data on organizations' goods and accounting" (if the mode for displaying all functions is enabled).

The fastest way is to open it directly via the navigation link. Copy it, click in 1C "Service" → "Go to navigation link" (or Shift+F11) and paste:

e1cib/list/Report.ReconciliationOfDataOnOrganizationsGoodsAndAccounting

2a. How to find out your release

The instruction is tied to the configuration version. Check yours: "Help" → "About the program" (or the "i" icon / question menu in the upper right corner). In the opened window, there will be two lines — platform version (for example, 8.3.24.xxxx) and release of the configuration "Accounting for Kazakhstan" (you should have 3.0.74.2 or newer). If the release is older, some settings may look different.

3. How to fill out

This is a report, so you will not be "filling out" document fields, but selection parameters. If you make a mistake in them, you will either get an empty report or a bunch of "discrepancies" that do not actually exist.

Field Purpose What happens if incorrect
Period (MANDATORY) Sets the date for which the balances are reconciled. Usually — the end of the month or the current date. If you take the wrong date, you will see a "discrepancy" that does not exist: in one account the document is recorded, in the other it is not yet for that day.
Organization (MANDATORY) Which legal entity to reconcile. Critical in a database with multiple organizations. An empty or incorrect organization — the report will be empty or reconcile the wrong account.
Warehouse Narrow the reconciliation to one warehouse. If left empty — all warehouses are reconciled at once (this is normal for a general check).
Nomenclature Check one item or group when the СНТ is "stuck" on a specific position. If you specify the wrong position — you will not see the problematic item.
Filter "Only discrepancies" Hides matching rows, leaving only problematic ones. Enable almost always. If disabled — you will have to visually search for mismatches among hundreds of rows.
Grouping / detailing Expands data to nomenclature, characteristics, batch. Too coarse grouping will hide a specific position with an error.

After setting up, click "Generate". The columns show: quantity and amount according to inventory accounting, quantity and amount according to accounting, and the column "Discrepancy". A non-zero discrepancy is what needs to be corrected.

4. An example with numbers

Situation. LLP "Astana-Trade," September 2026. According to the СНТ, 500 packs of coffee "Arabica 250 g" were received at a price of 900 ₸ per pack. VAT at a rate of 16%.

The receipt in accounting was reflected by the document "Receipt of goods," but the operator made a mistake and entered 480 packs instead of 500. In the inventory accounting module (according to the СНТ data), there are still 500 packs, while in accounting — 480.

Entries that were actually formed upon receipt of 480 packs:

Dr Cr Amount, ₸ Description
1330 3310 432,000 Received 480 pcs × 900 ₸
1420 3310 69,120 VAT to be credited 16% of 432,000

Total for account 1330 "Goods" — 480 pcs for 432,000 ₸.

What the report "Reconciliation of data on organizations' goods and accounting" shows:

Nomenclature Quantity (inventory accounting) Quantity (accounting) Discrepancy, pcs Amount of discrepancy, ₸
Coffee "Arabica 250 g" 500 480 20 18,000

A discrepancy of 20 pcs (18,000 ₸ excluding VAT) is a direct indication of an input error. The СНТ for sale will not allow closing the balance because the virtual warehouse thinks you have 500, and selling "at a loss" according to accounting is not allowed.

Correction. Open the document "Receipt of goods," change 480 to 500, and re-post. The system will accrue the missing 20 packs:

Dr Cr Amount, ₸ Description
1330 3310 18,000 Additional receipt of 20 pcs × 900 ₸
1420 3310 2,880 VAT to be credited 16% of 18,000

Generate the report again — the discrepancy line disappears, "Discrepancy" = 0. Now the СНТ and ESF will pass without errors.

5. Types of operations (report options)

The report is a check, so "types of operations" here refer to reconciliation modes:

  • Reconciliation by quantity — comparison of physical balances (pieces, kg, liters). The main mode for СНТ and the virtual warehouse.
  • Reconciliation by amount — comparison of costs. Catches errors in price and cost with matching quantities.
  • Reconciliation with the filter "Only discrepancies" — working mode before submitting reports: shows only problematic positions.
  • Full reconciliation (all rows) — a control run when you need to ensure that everything matches.

6. What is generated during formation

It is important to understand honestly: this is a report, not a document. It does not create entries, does not make movements in registers, does not send ESF or СНТ, and does not change anything in the database. It only reads already existing data from the two accounts and shows the difference.

What it reads and compares:

  • Registers of inventory accounting of organizations (data source for СНТ and the virtual warehouse of the ESF information system).
  • Data from accounting records for account 1330 "Goods" (balances and turnovers).

All corrections are made not in the report, but in the primary documents (receipt, sale, inventory, adjustment), after which the report is generated again for control.

7. Printed forms

The report does not have a separate form — the printed form is the table generated itself. Standard actions of the 1C table document are available:

  • Print the generated report (print button / Ctrl+P).
  • Save to file: Excel (.xlsx / .xls), PDF, .mxl (1C table document).
  • Send by email the generated report directly from 1C.

8. Common errors

"Discrepancy in quantity. Not enough goods in the organization's warehouse" (when trying to issue СНТ/sale). The virtual warehouse "sees" less than accounting, or vice versa. Generate the report, find the position with a non-zero discrepancy, and re-post/correct the primary document.

The report shows discrepancies, although all documents are posted. Most often, the issue is with the period: balances are taken on a date when one of the documents has not yet been reflected. Set the period with a margin (for example, until the end of the month) and re-generate.

"Discrepancy only in amount, quantity matches". The price or cost has diverged. Check the price in the receipt and the cost write-off settings (FIFO / average). The quantity is correct — adjust the monetary assessment.

The report is empty. The organization is not filled in or the nomenclature/warehouse specified has no movements. Remove unnecessary filters and leave only the organization with the period.

The discrepancy "stuck" after correction. You corrected the document but did not re-post the chain of subsequent documents. Perform bulk re-posting for the period and generate the report again.

9. FAQ

Does this report create entries or movements? No. This is an analytical report: it only compares the inventory accounting of the organization and accounting records. All changes are made in primary documents.

Why do the virtual warehouse and account 1330 diverge? Typical reasons: receipt posted in one account and not posted in the other, error in quantity during input, unposted adjustment or inventory, different document posting dates.

What VAT rate to consider when reconciling amounts in 2026? The standard VAT rate in Kazakhstan in 2026 is 16%. This is the rate laid down in new receipt and sale documents; the old 12% is found only in documents from previous periods.

On what date to reconcile balances? On the date for which you are submitting reports or issuing СНТ. Usually, this is the end of the month or the current day. The main thing is that all primary documents for the period have been posted.

The report showed a discrepancy — where to correct it? In the primary document: "Receipt of goods," "Sale of goods," "Inventory," "Adjustment." Corrected, re-posted — re-generate the report.

Can all warehouses be reconciled at once? Yes. Leave the "Warehouse" field empty — the report will reconcile balances across all warehouses of the organization. For pinpoint searching, specify a specific warehouse.

Why is the СНТ not posted, even though the goods are in accounting? Because the СНТ relies on the inventory accounting of the organization (virtual warehouse), not directly on account 1330. If the balance there is less — reconcile with the report and re-post the receipt.

What to do if the discrepancy is only in amount? The quantity is correct, the difference is in cost. Check the price in the receipt and the cost assessment method. The monetary difference is eliminated by adjusting the cost, not the quantity.

Is there anything to save after reconciliation? There is no obligation, but before submitting reports, it is useful to save the report in Excel/PDF as confirmation that the inventory accounting and accounting records matched.

10. Related documents

Based on what the reconcilable data appears:

  • Receipt of goods — forms the balance in both inventory accounting and accounting (Dr 1330 Cr 3310).
  • Sale of goods — writes off the balance (Dr 7010 Cr 1330, income Dr 1210 Cr 6010, VAT 16% Dr 1210 Cr 3130).
  • Shipping invoice (СНТ) — movements of the virtual warehouse.
  • Inventory of goods and Receipt / Write-off of goods — adjust physical balances.

What actions are taken after reconciliation:

  • Correct and re-post primary documents of receipt/sale.
  • Generate ESF (ESF information system) and СНТ only after the discrepancy has been reduced to zero.
  • In case of identified surpluses/shortages — "Receipt of goods" or "Write-off of goods."

How to find out your release: "Help" → "About the program" — there you will find the version of the 1C:Enterprise platform and the release of the configuration.

Material prepared for "Accounting for Kazakhstan," version 3.0, release 3.0.74.2.

Частые вопросы

Does this report create entries or movements?
No. This is an analytical report: it only compares the organization's inventory accounting and financial accounting. All changes are made in the primary documents.
Why do the virtual warehouse and account 1330 differ?
Typical reasons: the receipt was recorded in one accounting system and not in the other, an error in quantity during entry, an unrecorded adjustment or inventory, different document processing dates.
What VAT rate should be considered when reconciling amounts in 2026?
The standard VAT rate in Kazakhstan in 2026 is 16%. This is the rate included in the new receipt and sales documents; the old 12% is only found in documents from previous periods.
What date should be used for reconciling balances?
On the date for which you are submitting the reporting or issuing the electronic invoice (ESF). Usually, this is the end of the month or the current day. The main thing is that all primary documents for the period have been processed.
The report showed a discrepancy — where to correct it?
In the primary document: "Goods Receipt," "Goods Sale," "Inventory," "Adjustment." Correct it, reprocess — regenerate the report.
Can all warehouses be reconciled at once?
Yes. Leave the "Warehouse" field empty — the report will reconcile balances across all warehouses of the organization. For targeted searching, specify a specific warehouse.
Why is the electronic invoice (ESF) not processed, even though the goods are in the accounting records?
Because the electronic invoice (ESF) relies on the organization's inventory accounting (virtual warehouse), not directly on account 1330. If the balance there is lower — reconcile with the report and reprocess the receipt.
What to do if the discrepancy is only in the amount?
The quantity is correct, the difference is in value. Check the price in the receipt and the method of cost valuation. The monetary difference is eliminated by adjusting the value, not the quantity.

Read also

Источники

Была ли статья полезна?
💼 Нужна помощь с 1С или учётом? Слава КВЦ — многолетняя практика в 1С в Казахстане. Изучите разложенный НК РК 2026 или спросите в чате BuhGPT — ответит за секунды.