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

Report "Aged Payables to Suppliers" 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).

The supplier calls and says: "You are two weeks overdue on payment, we are stopping the shipment." You are sure that everything has been paid. Opening a reconciliation act for each one is time-consuming. You need one screen that shows: who you owe, how much, and how many days you are overdue. This is exactly what the report "Overdue Payables to Suppliers" does. You open it before talking to the supplier, before planning payments for the week, and before closing the month — to ensure that overdue payables do not come as a surprise.

1. Purpose

The report shows your accounts payable to suppliers, for which the payment deadline has expired according to the contract or incoming document. The data is taken from account 3310 "Short-term Accounts Payable to Suppliers and Contractors" broken down by counterparties, contracts, and settlement documents. This report does not create or change anything in the accounting; it only displays what is already in the database.

2. Where to find

Menu path:

  • Section "Purchases" → block "Reports""Overdue Payables to Suppliers".

If you do not see it in the report interface, open it directly. In the "Go to navigation link" field (or via File → Open by link), paste:

e1cib/list/Report.OverduePayablesToSuppliers

and press Enter — 1C will open the report form.

2a. How to find out your release

Menu "Help" → "About the program" (or the ℹ icon in the upper right corner). In the opened window:

  • Platform version — for example, 8.3.24.x;
  • Configuration — "Accounting for Kazakhstan", version 3.0;
  • Release — for example, 3.0.74.2.

Compare the release with the header of this manual: in different releases, the set of fields and columns may differ.

3. How to fill in (report settings)

The report does not have "document fields" — there are parameters that determine what you will see. Let's break down each one.

Parameter Purpose What will happen if set incorrectly
Organization (mandatory) Which legal entity to consider for debts. You will see debts of the wrong legal entity or an empty report. If there is only one organization in the database, it is automatically substituted.
As of / Report Date (mandatory) At what point to consider the balance and overdue. Overdue = the difference between this date and the payment deadline. If you set yesterday's date — some recent overdue amounts will not be included. For an accurate picture, set today's date.
Counterparty (filter) Limit the report to one supplier — convenient before a call. If left empty — you will see everyone, which is normal for a general overview.
Contract (filter) Narrow down to a specific contract if there are several with the supplier. If you forget that the debt is "hanging" on another contract — you will think it has been paid, although it has not.
Currency Filter by currency of settlements. Debts in tenge and in foreign currency are shown separately. For a foreign currency contract, the amount in ₸ is converted at the exchange rate — do not confuse it with the contract amount in foreign currency.
Grouping How to collapse rows: Counterparty → Contract → Settlement Document. Too large grouping will hide specific accounts; too small will give a "sheet".
Overdue intervals (days) Breakdown of debt by "age": up to 7, 8–30, 31–60, over 60 days. If not set — you will see the total amount without understanding where the "fire" is.

The payment deadline from which overdue is calculated is taken from the contract (attribute "Payment deadline, days" / "Payment by") or from the incoming document. If the deadline is not filled in the contract — the document is considered overdue immediately from the date of receipt. This is the first thing to check if the report shows "strange" overdue.

4. An example with numbers and entries

Situation. LLP "Aktiv" purchased goods from LLP "Snabservice". The document "Receipt of Goods and Services" dated 10.08.2026 for the amount of 580,000 ₸, including VAT 16%. The payment deadline in the contract is 15 calendar days, meaning payment is due by 25.08.2026. As of 06.09.2026, payment has not been made.

Let's break down the amount of the document:

  • Cost of goods (excluding VAT): 500,000 ₸
  • VAT 16%: 500,000 × 16% = 80,000 ₸
  • Total amount due: 580,000 ₸

The entries generated by the receipt document (these created the debt on account 3310):

Dr Cr Amount, ₸ Description
1330 "Goods" 3310 500,000 Goods received
1420 "VAT to be refunded" 3310 80,000 Incoming VAT 16% on ESF

Thus, the balance on account 3310 for this supplier is 580,000 ₸ credit balance (your debt).

What the report will show on 06.09.2026:

Counterparty Document Payment Deadline Debt Amount, ₸ Days Overdue Interval
LLP "Snabservice" Receipt No… dated 10.08.2026 25.08.2026 580,000 12 8–30 days

12 days overdue — because from 25.08 (payment deadline) to 06.09 (report date) 12 calendar days have passed. Now, when you call the supplier, you see the exact amount and deadline and do not argue blindly.

When you process the payment with the document "Write-off from Current Account" for 580,000 ₸, the following entry will appear:

Dr Cr Amount, ₸ Description
3310 1030 "Cash in Current Accounts" 580,000 Payment to supplier

And in the next run of the report, this debt will disappear — the balance on 3310 is closed.

5. Report options and modes

The report is not a document, so it does not have "types of operations". But there are modes that determine what you will receive:

  • For all suppliers — a general overview of overdue payables (filter by counterparty is empty).
  • For one counterparty / contract — detailing before reconciliation or payment.
  • With breakdown by overdue intervals — "fresh" and "old" debts separately.
  • With detail down to the settlement document — shows each unpaid invoice/receipt.
  • Collapsed to counterparty — only total amounts for a managerial view.

6. What is generated when forming the report

The report does not create entries, does not generate ESF, does not create movements in registers — it only reads already accumulated data. Sources:

  • Account 3310 (credit balance) — debt amount;
  • Register of settlements with counterparties (settlements by documents) — linking debt to specific incoming and payment documents;
  • Payment deadline from the contract/document — for calculating overdue days.

Therefore, if the figures in the report seem incorrect — correct not the report, but the primary documents (receipt, payment, contract), and re-generate.

7. Print forms

The report does not have a separate regulated print form — it prints and exports the generated tabular document:

  • Print (Ctrl+P) — output of the report to the printer;
  • Save as… — export to Excel (.xlsx), PDF, .mxl;
  • Send by email — attach the report in an email to the counterparty.

For official reconciliation with the supplier, use a separate document "Reconciliation Act of Mutual Settlements" — it has a print form with signatures of the parties.

8. Common mistakes

"The field 'Organization' is not filled" — when there are several legal entities in the database, the organization was not substituted. Select the organization manually in the report header.

The report is empty, although there are debts. Reasons: (1) incorrect report date — the date is set earlier than when the debts arose; (2) the wrong counterparty/contract is selected in the filter; (3) all debts are still within the payment deadline — there is formally no overdue. Remove filters and set the current date.

Shows overdue for a recent receipt. The contract does not have the attribute "Payment Deadline" filled in, so the document is considered overdue from the date of receipt. Open the contract and specify the number of days for payment.

The debt amount does not match the supplier's act. Usually, the reason is an unaccounted advance or a payment made without specifying the incoming document (settlements "did not reconcile"). Check the payment documents: they should specify the correct contract and method of debt settlement, then reprocess and regenerate the report.

The debt "hangs" after payment. The payment was made under another contract with the same counterparty. Correct the contract in the payment document — the debt will close.

9. FAQ

1. What is the difference between "overdue payables" and regular payables? Regular payables are your total debt to suppliers (the entire credit of 3310). Overdue payables are only that part for which the payment deadline from the contract or document has already passed. This report shows exactly the second, "burning" part.

2. Where does the payment deadline come from? From the contract with the supplier (attribute "Payment deadline, days") or from the incoming document itself. If the deadline is not specified anywhere — the debt is considered overdue from the date of receipt.

3. On which account is this debt recorded? On account 3310 "Short-term Accounts Payable to Suppliers and Contractors". The report reads its credit balance.

4. Why does the amount in the report include VAT? Because the debt to the supplier is the total amount due, including VAT 16%. In the example, the goods are 500,000 ₸ + VAT 80,000 ₸ = debt 580,000 ₸. Incoming VAT is reflected on account 1420.

5. How to view the debt for only one supplier? Fill in the filter "Counterparty" in the report header and, if necessary, "Contract". The report will show overdue only for that supplier.

6. Does the report create entries or ESF? No. This is an analytical report: it does not create entries, does not issue ESF or SN, does not change balances. All entries are created by primary documents (receipt, payment).

7. Why is the debt still visible after payment? Most likely, the payment was made under another contract or without linking to the incoming document. Check the contract and method of settlement in the payment document, reprocess, then regenerate the report for the current date.

8. Can the report be exported to Excel and sent to the supplier? Yes: Save as… → Excel or PDF, or the email sending button. But for official reconciliation, it is better to use the document "Reconciliation Act of Mutual Settlements" with a print form and signatures.

9. How to see which debt is the oldest? Enable breakdown by overdue intervals (up to 7, 8–30, 31–60, over 60 days). Debts over 60 days are the first candidates for urgent payment or negotiations.

10. Does the report date affect the number of overdue days? Yes, directly. Overdue = "report date" minus "payment deadline". Set yesterday's date — you will get one day less overdue. For an accurate picture, always set the current date.

10. Related documents

  • Receipt of Goods and Services — generates debt on account 3310 (data source for the report).
  • Write-off from Current Account / Cash Withdrawal — extinguishes debt (Dr 3310 Cr 1030), removes the line from the report.
  • Reconciliation Act of Mutual Settlements — official reconciliation with the supplier; entered based on data from the same account 3310.
  • Adjustment of Debt — accounting for advances, transferring debts between contracts, writing off uncollectible payables.
  • Contract with Counterparty — here the "Payment Deadline" is set, from which the report calculates overdue.

How to find out your release

"Help" → "About the program" — there you will find the platform version (8.3.x) and the configuration release. This instruction has been prepared and verified on release 3.0.74.2 of the configuration "Accounting for Kazakhstan" (version 3.0). If your release differs, individual columns and filter parameters may look different.

Prepared for "Accounting for Kazakhstan", version 3.0, release 3.0.74.2.

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

What is the difference between "overdue debt" and regular accounts payable?
Regular accounts payable is your total debt to suppliers (the entire credit of account 3310). Overdue debt is only that part for which the payment term from the contract or document has already passed. This report shows specifically the second, "burning" part.
Where does the payment term come from?
From the contract with the supplier (the attribute "Payment term, days") or from the receipt document itself. If the term is not specified anywhere, the debt is considered overdue from the date of receipt.
On which account is this debt recorded?
On account 3310 "Short-term accounts payable to suppliers and contractors." The report reads its credit balance.
Why does the amount in the report include VAT?
Because the debt to the supplier is the total amount payable, including VAT of 16%. For example, goods worth 500,000 ₸ + VAT 80,000 ₸ = debt 580,000 ₸. The incoming VAT is reflected on account 1420.
How can I view the debt for just one supplier?
Fill in the "Counterparty" filter in the report header and, if necessary, "Contract." The report will show the overdue amount only for that supplier.
Does the report create entries or electronic invoices (ESF)?
No. This is an analytical report: it does not create any entries, does not issue electronic invoices (ESF) or tax returns, and does not change balances. All entries are created by primary documents (receipt, payment).
Why is the debt still visible after payment?
Most likely, the payment was made under a different contract or without linking to the receipt document. Check the contract and the method of offset in the payment document, reprocess it, then regenerate the report for the current date.
Can the report be exported to Excel and sent to the supplier?
Yes: "Save as... → Excel" or "PDF," or use the email sending button. However, for official reconciliation, it is better to use the document "Reconciliation Act" with printed form and signatures.

Read also

Источники

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