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

Report "Counterparty Data Report" in 1C:Accounting for Kazakhstan 3.0 — Complete Guide

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

Verified on release 3.0.74.2 "Accounting for Kazakhstan" (edition 3.0).

A counterparty sent a reconciliation report, but your database shows a different amount. Or a manager asks: "How much does this customer owe us and under which contracts?" Opening five different reports and reconciling them manually takes time. The "Report on Counterparty Data" gathers everything about one counterparty in a single place: mutual settlement balance, contracts, documents, bank accounts, contact details. This is your "dossier card" of the counterparty for quick reconciliation and negotiation prep.

Right away, the key point: this is a report, not a document. It does not post anything, does not create an ESF, and does not change the data in the database. It only reads what already exists and shows it in a convenient form. That is why it does not generate postings — postings are made by documents, and the report merely reflects their result.

1. Purpose

The report shows a full summary for one selected counterparty over a period: the state of settlements (who owes whom and how much), the list of contracts and documents, bank details and contacts. It is used for reconciliation with the counterparty, preparation of a reconciliation report, and a quick answer to the question "what is the situation with this customer/supplier."

2. Where to find it

The path depends on where you start from:

  • From the counterparty card (the fastest way). Section "Reference Books" → "Counterparties" → open the one you need → in the navigation panel/via the "Reports" button select "Report on Counterparty Data". The counterparty will be filled in automatically.

  • Through the list of reports. Section "Purchases" or "Sales" → block "Reports""Report on Counterparty Data" (in some interfaces — via "All functions").

  • Direct 1C navigation link. Menu "Service" → "Go to navigation link" (or the link icon in the header) and paste:

    e1cib/list/Отчет.ОтчетПоДаннымКонтрагента
    

    This opens the object directly without wandering through the sections.

2a. How to find out your release

Click "Help" → "About the program" (or the "i" icon in the top right corner). There are two lines there: the platform version (for example, 8.3.24.xxxx) and the configuration release of "Accounting for Kazakhstan" (for example, 3.0.74.2). The instruction is written for release 3.0.74.2. If you have a different release, the location of the fields may differ slightly, but the logic is the same.

3. How to fill it in (report settings)

The report is filled in not like a document, but as a set of filters. Here are the key header parameters.

Field Why it is needed What happens if there is an error
Counterparty (REQUIRED) The main filter — for whom we build the summary Without it, the report will not be built or will collect "everything at once". Always select a specific counterparty
Organization (REQUIRED when accounting for several legal entities) For which of your organizations to view settlements If you have several LLPs/IEs and the organization is not specified, the amounts will "add up" across all of them, and the balance will not match the counterparty's report
Period (from … to …) For which interval to show turnovers and as of which date — the balance Too narrow a period will "cut off" the opening balance, and the customer will "suddenly" owe less. For reconciliation, take the period from the start of work or from the date of the last reconciliation
Contract Filter down to a specific contract If the counterparty has several contracts and you did not set the filter, you will see the total balance. For reconciliation by one contract, select it explicitly
Settlement currency For which settlements to view (₸ or currency) With currency contracts, without a filter you will mix tenge and currency amounts
Data output / composition With checkboxes you mark what to show: mutual settlements, contracts, documents, bank accounts, contacts If you uncheck the block you need, you will not see, for example, the details or the list of documents

After configuring, click "Generate" (F5). The "Settings" button opens advanced filters and groupings; "Show settings" — quick access to the period and filters right in the header.

4. Worked example with figures and postings

Situation. LLP "Caspiy Trade" is your customer. The counterparty sent a reconciliation report for Q3 2026 and claims it owes you 160,000 ₸. You open the report and check.

What happened during the period (the documents are already posted in the database):

  1. Sale of goods on 15.07.2026 for 1,160,000 ₸, including VAT 16%. The base is 1,000,000 ₸, VAT — 160,000 ₸. The cost of goods — 700,000 ₸.
  2. Receipt of payment from the customer on 20.08.2026 for 800,000 ₸.

The postings made by these documents (the report only reflects them, it does not generate them itself):

Date Dr Cr Amount, ₸ Meaning
15.07 1210 6010 1,000,000 Revenue from sale
15.07 1210 3130 160,000 VAT payable (16%)
15.07 7010 1330 700,000 Cost of goods written off
20.08 1030 1210 800,000 Payment received to the current account

What the report will show for account 1210 (settlements with the customer):

  • Charged (sale): 1,160,000 ₸
  • Paid: 800,000 ₸
  • Balance at the end of the period: 360,000 ₸ (debit) — the customer owes you.

Conclusion: the counterparty showed 160,000 ₸ in the report, but according to your data the debt is 360,000 ₸. The discrepancy is 200,000 ₸. Most likely, the counterparty did not record part of the shipment on its side or recorded it in a different period. The report immediately shows both the sale document and the payment — you tell the counterparty the number and date of the invoice on which the amount differs. Reconciliation is closed in 5 minutes instead of a week of correspondence.

5. Types of operation (report variants)

The report does not have "operation types" like a document. Instead, there are presentation variants that you enable with filters and settings:

  • Mutual settlements — balance and turnovers on accounts 1210/3310 (and advance accounts 1610/3510), who owes whom.
  • Counterparty documents — a list of invoices, acts, bills, payments for this counterparty.
  • Contracts — a list of contracts, their types ("With customer", "With supplier"), status.
  • Bank accounts — details for payments.
  • Contact information — addresses, phones, responsible persons.
  • Dossier / details — BIN/IIN, VAT status, residency indicator.

By combining the checkboxes, you get either a full dossier or a narrow settlement reconciliation.

6. What is generated upon generation

Since this is a report, when you click "Generate" not a single posting is created, no ESF, no SNT, no register movements — the database does not change. The report only reads the data:

  • the accounting register (balance and turnovers on accounts 1210, 3310, 1610, 3510) — for settlements;
  • the "Mutual settlements with counterparties" register — for detailing by contracts and settlement documents;
  • the reference books "Counterparties", "Contracts", "Bank accounts" — for details and contacts.

If you need exactly postings or electronic documents (ESF via the ESF IS, SNT), they are created by the documents "Sale", "Receipt", "Invoice (ESF)", not by this report.

7. Printed forms

The report is already a ready tabular form on the screen. With it, the following is available:

  • Print — the "Print" button sends the generated report to the printer.
  • Save as… — export to Excel (.xlsx), PDF, Word, HTML or an "mxl" table.
  • Send by email — attach the generated report in a letter to the counterparty.

For an official reconciliation, use not the report itself but the document "Mutual Settlement Reconciliation Report" — it has an approved bilateral printed form with fields for the signatures of both parties.

8. Common mistakes

  • "The required attribute Counterparty is not filled in." The report cannot be built without selecting a counterparty. Select it in the header and click "Generate".
  • The balance in the report does not match the counterparty's report. Most often the reason is the period. You set "from 01.07", but the debt carries over from the previous year. Widen the period or enable the output of the opening balance.
  • "The amount doubled." The counterparty has two contracts, and you are viewing without a filter by contract — the amounts added up. Set a filter by the needed contract.
  • An empty report with the counterparty filled in. Check the filter by organization: the settlements are recorded under another of your legal entities. Remove or change the "Organization" filter.
  • Currency and tenge amounts "got mixed up." Under a currency contract, settlements are kept in the currency. Set a filter by settlement currency so as not to add up ₸ and, for example, USD.
  • The latest documents are not visible. The document is posted but with a date later than the end of the period. Move the "to" date to the current one.

9. FAQ

Q: Does this report make postings? A: No. This is a report — it only shows the data. Postings are made by documents (sale, receipt, payments), and the report reflects their total.

Q: How is it different from a reconciliation report? A: The report is for your internal analysis: fast, flexible, with any filters. The reconciliation report is an official bilateral document with a printed form and signatures. First you reconcile with the report, then, if necessary, you issue the act.

Q: Why does the balance not match what the counterparty sent? A: The most common reasons: a different period, a document not recorded by one of the parties, a document posted in a different quarter, or a discrepancy on advances (accounts 1610/3510). The report shows documents line by line — compare by numbers and dates.

Q: How do I view settlements across all of the counterparty's contracts at once? A: Remove the filter by contract — the report will show the total balance, and inside it will detail by each contract.

Q: Can the report be exported to Excel and sent to the client? A: Yes. "Save as…" → Excel or PDF, or the "Send by email" button. For an official reconciliation, it is better to send a reconciliation report.

Q: Does the VAT rate affect the report? A: The report shows amounts exactly as they were posted by the documents. In 2026 in the RK the VAT rate is 16%, so a sale of 1,000,000 ₸ will show with VAT of 160,000 ₸ and a total amount of 1,160,000 ₸.

Q: What to do if the report is empty, although the settlements definitely exist? A: Check three filters: organization, period and currency. Most often the settlements are "hidden" under a different organization or outside the period.

Q: How do I open the report directly from the counterparty card? A: Open the counterparty in the reference book and click "Reports" → "Report on Counterparty Data" — the counterparty will be filled in itself.

Q: Are the counterparty's VAT status and BIN visible in the report? A: Yes, if the details/dossier block is enabled. There you can see the BIN/IIN, the VAT payer indicator and bank accounts — convenient before issuing an ESF.

Q: Does the report show advances separately? A: Yes. Advances received/issued go through accounts 1610/3510 and are visible separately from the main debt on 1210/3310 — this helps understand the "net" balance.

10. Related documents

The report itself does not enter anything, but is directly connected with:

  • Source data documents: "Sale of Goods and Services", "Receipt of Goods and Services", "Receipt to Settlement Account", "Write-off from Settlement Account", "Invoice (ESF)".
  • What is done based on the reconciliation results: "Mutual Settlement Reconciliation Report" (official reconciliation), "Debt Adjustment" (offsets, transfers, mutual settlements) — if the report revealed a discrepancy or a stuck advance.
  • Similar reports for deeper analysis: "Account Turnover Balance Sheet" (1210/3310), "Account Card", "Customer Receivables"/"Supplier Payables", "Analysis of Subconto 'Counterparties'".

How to find out your release: "Help" → "About the program" — the platform version and configuration release are indicated there.

Prepared for "Accounting for Kazakhstan", release 3.0.74.2 (edition 3.0).

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

Does this report make postings?
No. This is a report — it only displays data. Postings are made by documents (sales, receipts, payments), and the report reflects their totals.
How does it differ from a reconciliation act?
The report is for your internal analysis: fast, flexible, with any filters. A reconciliation act is an official bilateral document with a printed form and signatures. First you reconcile with the report, then, if necessary, you issue an act.
Why doesn't the balance match what the counterparty sent?
The most common reasons: a different period, a document not reflected by one of the parties, a document posted in another quarter, or a discrepancy in advances (accounts 1610/3510). The report shows documents line by line — compare by numbers and dates.
How can I view settlements across all of a counterparty's contracts at once?
Remove the contract filter — the report will show the total balance and detail it internally by each contract.
Can I export the report to Excel and send it to a client?
Yes. "Save as…" → Excel or PDF, or the "Send by email" button. For an official reconciliation, it's better to send a reconciliation act.
Does the VAT rate affect the report?
The report shows amounts as they were posted by documents. In 2026, the VAT rate in Kazakhstan is 16%, so a sale of 1,000,000 ₸ will show with VAT of 160,000 ₸ and a total amount of 1,160,000 ₸.
What should I do if the report is empty, even though settlements definitely exist?
Check three filters: organization, period, and currency. Most often the settlements are "hidden" under another organization or outside the period.
How do I open the report directly from the counterparty's card?
Open the counterparty in the directory and click "Reports" → "Report on counterparty data" — the counterparty will be filled in automatically.

Read also

Источники

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