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

Analysis of Unpaid Supplier Invoices 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 supplier sends you a reconciliation statement: "you owe 1,740,000 ₸ on three invoices." You look in 1C — and can't figure out exactly which invoices are "outstanding," what has already been paid, and what is overdue. Or the end of the month comes, there isn't enough money for everything, and you need to decide who to pay first. Opening each "Supplier Invoice" document one by one is slow and unreliable. This is where you open the "Analysis of Unpaid Supplier Invoices" report. In a couple of seconds it shows a list of the invoices issued to you, how much has been paid on each and how much is still owed, broken down by suppliers and contracts.


1. Purpose

The report shows which supplier invoices have not yet been fully paid, in what amount, and by which counterparties/contracts. It is a tool for payment discipline and payment planning — not a document; it doesn't post anything, it only reads the accounting data that has already been entered.

2. Where to find it

Path in the interface:

  • Section "Purchases" → block "Reports""Analysis of Unpaid Supplier Invoices".
  • Or: "Reports" (main menu of the section) → group "Settlements with counterparties".

If the item is not visible — click "Navigation settings" and add the report to the panel, or open it directly.

Direct 1C navigation link (menu "Tools" → "Go to navigation link", or the navigation field):

e1cib/list/Отчет.АнализНеоплаченныхСчетовПоставщиков

2a. How to find out your release

"Help" → "About" (or the "?" icon in the top right corner). In the window that opens you will see:

  • the platform version (for example, 8.3.24.xxxx);
  • the configuration release — "Accounting for Kazakhstan, edition 3.0 (3.0.74.2)".

It is the configuration release that matters: the layout and set of report fields depend on it. This guide is written for 3.0.74.2.

3. How to fill in (set up the selection)

The report is not "filled in" like a document — it is configured and then you click "Generate". Let's go through each header field and setting.

Field Why it matters and what happens if it's wrong
Period (REQUIRED) The date as of which the debt is calculated (usually the "as of date" field / end of period). Set yesterday's date — you won't see today's invoice. Set a future date — events that haven't yet occurred will be included. For reconciliation, use the date of the statement.
Organization (REQUIRED if there are several) The legal entity whose debts we are looking at. Choose the wrong one — you'll see someone else's invoices or an empty report. If there is only one organization, the field will fill in automatically.
Supplier (Counterparty) Selection by a single supplier. Leave it empty — the report covers all of them. For reconciliation with a specific counterparty, be sure to specify it, otherwise you'll drown in the list.
Contract Narrows the selection down to a specific contract. Useful when there are several contracts with a supplier (for example, "supply" and "services").
Currency If you work with foreign-currency contracts, selection by currency will separate tenge and foreign-currency invoices. By default amounts are converted to tenge at the exchange rate.
Overdue only (checkbox) Leaves in the report only invoices whose payment deadline has passed. Convenient for "who needs to be paid urgently."
Grouping ("Settings" button) Determines the view: by suppliers, and within them — by contracts and invoices. Remove the grouping by invoice — you won't see the breakdown by documents.
Filters ("Settings" button → "Filters") Fine-tuned conditions: debt amount greater than N, a specific manager, an item, etc.

Order of actions: set the Period and Organization → if necessary select the Supplier/Contract → enable the needed checkboxes → "Generate".

4. A worked example with figures

Scenario. The organization is LLP "Astana-Trade," a VAT payer. As of 06.09.2026 we check the debt to the supplier LLP "SnabKomplekt" under contract No. 12.

According to the accounting data:

  • Supplier invoice No. 101 dated 10.08.2026 for the amount of 580,000 ₸ (incl. VAT 16% = 80,000 ₸), payment due 20.08.2026. Paid 300,000 ₸.
  • Invoice No. 118 dated 28.08.2026 for the amount of 1,160,000 ₸ (incl. VAT 16% = 160,000 ₸), payment due 07.09.2026. Not paid.

What the report will show (grouping "Supplier → Contract → Invoice"):

Invoice Invoice amount Paid Debt Overdue
No. 101 dated 10.08 580,000 300,000 280,000 280,000
No. 118 dated 28.08 1,160,000 0 1,160,000 0
Total for SnabKomplekt 1,740,000 300,000 1,440,000 280,000

It is exactly 1,440,000 ₸ — the figure you reconcile against the supplier's statement.

Where these amounts come from (the postings of the primary documents that the report reads). The report itself doesn't make postings, but the debt was formed as follows:

Receipt of inventory under invoice No. 101 (document "Receipt of goods"):

  • Dt 1330 Cr 3310 — 500,000 ₸ (goods excluding VAT);
  • Dt 1420 Cr 3310 — 80,000 ₸ (VAT credited against liability).

Partial payment of 300,000 ₸ (payment order):

  • Dt 3310 Cr 1030 — 300,000 ₸.

Balance on invoice No. 101: 580,000 − 300,000 = 280,000 ₸ — this is the credit balance of 3310, which the report shows as debt.

5. Types ("operations") of the report

The report doesn't have "operation types" like a document does, but it does have variants/modes that you switch with settings:

  • By suppliers — a collapsed total of debt for each counterparty.
  • By contracts — detailing within a supplier.
  • By invoices (detailed) — each unpaid invoice line by line.
  • Overdue only — filter by breached payment deadline.
  • Broken down by terms (aging analysis of the debt) — if the variant is available: before due date / 1–30 days / over 30 days.

Save a convenient set via "Settings" → "Save report variant".

6. What is generated when it is built

This is a report, therefore:

  • It does not create postings and does not issue electronic documents (ESF, SNT) — those are generated by sales/receipt documents and in the ESF IS, not by the report.
  • It does not make register movements — it only reads registers. The report takes debt data from the accounting totals for account 3310 "Short-term accounts payable to suppliers and contractors" and from the registers of settlements with counterparties, matching supplier invoices against payments.
  • The result is a spreadsheet document on screen, which can be saved, printed, and sent.

7. Printed forms

The report has no separate form — the generated table itself is printed:

  • Print (Ctrl+P) — output the current result to a printer.
  • Save as… — to Excel (.xlsx / .mxl), PDF, a spreadsheet document.
  • Send by email — right from the report form as an attachment.

For an official reconciliation, use the "Statement of mutual settlements reconciliation" document (see section 10) — it has a regulated printed form, while this report provides a working breakdown.

8. Common mistakes

"The 'Organization' field is not filled in" — with several legal entities the selection is empty. Choose the organization in the header and generate again.

The report is empty, even though there are debts. Reasons: an incorrect Period (a date earlier than the receipt of the invoices); the "Overdue only" checkbox is enabled while the deadline hasn't arrived yet; the wrong contract is selected. Remove the extra filters, set the date to "today."

The debt amount doesn't match the supplier's statement. Most often: the payment was posted without specifying an invoice/contract, and the program didn't "link" it to the invoice. Open the payment and in the "Contract"/"Debt repayment" field specify the correct document. Also check whether an advance was posted separately to account 1610 — it is not included in this debt report.

"Debt" shows the amount with VAT, while the supplier counts without VAT. The report shows the full amount payable (with VAT 16%). That's normal — reconcile the total payable, not the value excluding tax.

Doubled debt on a single invoice. A sign that the receipt was entered twice or the receipt is not linked to the invoice. Check the receipt documents for the period.

9. FAQ

See the block of questions below — it is moved to a structured list.

10. Related documents

Data sources of the report (on the basis of which it is built):

  • "Supplier invoice" / "Invoice for payment (received)" — the invoices themselves.
  • "Receipt of goods and services" — forms the credit of 3310 (the debt amount).
  • "Write-off from the current account" / "Cash disbursement order" — payments that reduce the debt.

What is done based on the report's data:

  • "Outgoing payment order" — you plan payment of the identified debts.
  • "Statement of mutual settlements reconciliation" — you officially reconcile the total with the supplier.
  • "Debt adjustment" — if you need to offset an advance, transfer or write off the debt.

How to find out your release

"Help" → "About": it shows the platform version (8.3.x) and the configuration release. This guide is current for "Accounting for Kazakhstan," edition 3.0, release 3.0.74.2. In other releases the layout of the fields and the set of report variants may differ.

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

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

How does the "Analysis of Unpaid Supplier Invoices" report differ from the "Account 3310 Turnover-Balance Sheet"?
The Account 3310 turnover-balance sheet shows the balance for the counterparty and contract as a whole, but does not tie it to specific invoices with their payment due dates. This report breaks down the debt precisely by supplier invoices and can highlight overdue ones — that is, it answers the question "which invoice to pay first," and not only "how much is owed in total."
Why does the debt amount in the report not match the supplier's reconciliation statement?
Three common reasons: a payment was made without specifying an invoice/contract and was not tied to it; an advance is sitting on account 1610 and is not included in the debt; a receipt was entered twice or is not linked to an invoice. Open the payments for the period, check the "Contract/Debt repayment" field and the receipt documents.
Does the report show debt with or without VAT?
With VAT. It displays the full amount payable to the supplier, including 16% VAT. Reconcile against the invoice's total amount payable, not against the value of goods excluding tax.
How can I keep only overdue invoices in the report?
Enable the "Overdue only" checkbox in the header (or add a filter by payment due date in the settings). Then only invoices whose payment date has already passed relative to the report date will remain.
Does the report create postings or issue ESF/CNT?
No. This is a report: it only reads data and outputs a table. Postings are generated by receipt and payment documents, and ESF and CNT are issued by sales/receipt documents and in the ESF IS — not by this report.
The report is empty, though debts definitely exist. What should I check?
Check the Period (the date must not be earlier than the invoice dates), the correctness of the selected Organization and Contract, and also uncheck the "Overdue only" checkbox if the payment due date has not yet arrived.
How can I view the debt as of a specific date in the past?
Set the required date in the "Period" field ("as of date") and generate the report. It will recalculate the debt taking into account all payments made up to and including that date.
Can the report be generated for all suppliers at once?
Yes. Leave the "Supplier" field empty — the report will show all counterparties with outstanding invoices, grouped by suppliers and contracts. To reconcile with a single counterparty, specify it in the filter.

Read also

Источники

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