--- title: "Report \"Analysis of Unpaid Customer Invoices\" in 1C:Accounting for Kazakhstan 3.0 — complete guide" country: KZ lang: en author: Сапа Т.И. (https://buhgpt.kz/authors/sapa-ti) date: 2026-09-08 canonical: https://buhgpt.kz/suraqtar/otchet-analiz-neoplachennyh-schetov-pokupatelyam-v-1s-buh-en source: BuhGPT --- # Report "Analysis of Unpaid Customer Invoices" in 1C:Accounting for Kazakhstan 3.0 — complete guide > **TL;DR:** Verified on release 3.0.74.2 "Accounting for Kazakhstan" (revision 3.0). A client calls and says: "I've already paid you everything, why are you sending a reminder?" You open the record — and there's a debt hanging there. Who's right? Manually reconciling dozens of invoices an --- Verified on release 3.0.74.2 "Accounting for Kazakhstan" (revision 3.0). A client calls and says: "I've already paid you everything, why are you sending a reminder?" You open the record — and there's a debt hanging there. Who's right? Manually reconciling dozens of invoices and payment orders takes an hour of work and carries the risk of error. Instead, in 10 seconds you open "Analysis of Unpaid Invoices to Customers", set a filter for this counterparty — and see: invoice No. 125 was paid 600,000 ₸, a balance of 560,000 ₸ has been outstanding since last month. The conversation ends with facts, not emotions. 1. Purpose The report shows the invoices for payment issued to customers and their status: for what amount the invoice was issued, how much has been paid against it, and how much remains unpaid. This is a management tool for controlling receivables by invoice, not an accounting register. It helps to spot overdue amounts in time and not "lose" unpaid invoices. 2. Where to Find It Menu path: - Section "Sales" → block "Reports" (or "Sales Reports") → "Analysis of Unpaid Invoices to Customers". - Or: section "Reports" → "Sales" → the same report. Quick way — navigation link. Menu "Tools" (or the link icon) → "Go to navigation link", paste: e1cib/list/Отчет.АнализНеоплаченныхСчетовПокупателям The report will open immediately, without searching through sections. 2a. How to Find Out Your Release Menu "Help" → "About". In the window that opens there are two lines needed for comparison with these instructions: - Platform version (for example, 8.3.24.x); - Configuration: "Accounting for Kazakhstan, revision 3.0" and release (ours is 3.0.74.2). If the release is older, some settings and columns may be named differently. 3. How to Fill In (Configure the Report) The report does not post anything — you set the parameters and click "Generate". Key fields in the header and settings: Field Required Why and what happens on error Period (from… to…) Yes The boundaries within which invoices are taken. Set a narrow period — invoices from last month will drop out, and the debt will "disappear." For a complete picture of receivables, set the start of the period earlier (for example, from the beginning of the year). Organization Yes (if there are several in the database) Which legal entity's invoices we are looking at. Select the wrong organization — you'll see someone else's or empty data. Counterparty No Filter by a specific customer. Leave it empty — the report covers everyone. To resolve a dispute with a client, set that exact client. Contract No Narrow down to a single contract. Useful if there are several contracts with the customer and settlements are kept separately for each. Currency No Filter by invoice currency. If you work in both ₸ and foreign currency, separate them — otherwise the amounts will visually "blend." Only unpaid (checkbox) No Hides fully paid invoices, leaves debts. Usually enabled — that's what the report is opened for. Grouping No How to collapse rows: Counterparty → Contract → Invoice. Changes readability, does not affect the figures. Report currency (tenge/settlement currency) No In what to show the totals. Set ₸ if you need a single total across all counterparties. Workflow: set the period and organization → if needed, add a filter by counterparty/contract → "Generate". The setup can be saved with the "Save variant" button so you don't have to set it up again. 4. Worked Example with Figures and Postings Situation. LLP "Bereke" (VAT payer, rate 16%) issued to the customer LLP "Altyn" Invoice for payment No. 125 dated 03.09.2026: - Goods: 100 units × 10,000 ₸ = 1,000,000 ₸ - VAT 16% = 160,000 ₸ - Total on the invoice: 1,160,000 ₸ On 10.09.2026 "Altyn" transferred 600,000 ₸. The goods were shipped in full. What the report will show (filter: organization "Bereke", counterparty "Altyn", checkbox "Only unpaid"): Invoice Invoice amount Paid Balance due No. 125 dated 03.09.2026 1,160,000 ₸ 600,000 ₸ 560,000 ₸ These 560,000 ₸ are the subject of the conversation with the client. The postings behind the report figures (the report itself does not make them — they were created by the sale and the payment receipt): Sale of goods (shipment): Dr Cr Amount Description 1210 6010 1,000,000 ₸ Revenue from sales 1210 3130 160,000 ₸ VAT payable 16% 7010 1330 (cost) Cost of goods written off Receipt of payment to the current account: Dr Cr Amount Description 1030 1210 600,000 ₸ Partial payment from the customer After these movements, the balance on account 1210 for "Altyn" = 560,000 ₸ — the same figure as in the report. The report merely ties this debt to the specific invoice No. 125, which the 1210 turnover sheet does not show. 5. Report Types / Output Variants This is a report, so it has no "operation types" — it has configuration variants, each solving its own task: - All invoices — a complete list of issued invoices with payment and balance. - Only unpaid — classic receivables control (checkbox enabled). - By counterparty — resolving a dispute/reconciliation with a single customer. - By contract — payment control within a specific contract. - Grouped by manager/organization — if you conduct sales through several legal entities or managers. 6. What Is Produced When Generating It's important to understand: this is a report, not a document. Therefore: - It creates no postings — the Dr/Cr from the example are produced by the sale and the bank document, not by the report. - It generates no electronic documents — ESF (IS ESF) and SNT are issued from the sales documents; the report only reflects them indirectly through the linked invoices. - It writes no register movements — it reads them: data on invoices and payments are taken from the settlement and invoice payment registers. The result of generation is only a table on the screen, which can be printed, saved, or sent. 7. Printed Forms The report has no separate form — its tabular result is printed: - Print (Ctrl+P) — send the generated table to the printer. - Save as… — to Excel (.xlsx), PDF, Spreadsheet document (.mxl). - Send by email — as an attachment directly from 1C to the client for reconciliation. 8. Common Mistakes "The value of the field 'Organization' is not filled in" Occurs if there are several legal entities in the database and no organization is selected. Select the required one in the header and generate again. The report is empty, although there are debts. Usually the cause is a narrow period: the invoice was issued before the start date. Move the start of the period (for example, to 01.01.2026) and generate again. Payment exists, but the invoice is still "unpaid." The payment is not linked to the invoice: the bank document does not specify a source document (invoice) or specifies a different contract. Open the receipt to the account, check the fields "Contract" and "Invoice for payment", repost. The debt is "doubled" between two contracts. There are several contracts with one customer, and the payment and invoice are under different ones. Compare the contract in the invoice and in the payment order, bring them to a single one. Amounts do not match the turnover balance sheet for 1210. This is normal: the report calculates by invoices for payment, while the TBS for 1210 covers all sales, including those made without an invoice. For a total reconciliation of receivables, also use the TBS/reconciliation statement. 9. FAQ Q: Does the report make postings? A: No. It is an analytical report: it only reads data and outputs a table. Postings are created by the sale and the bank. Q: Why doesn't the debt amount in the report equal the balance on account 1210? A: The report is tied to invoices for payment, while 1210 accumulates debt on all sales, including those without an invoice. The difference is shipments without an issued invoice. Q: How can I view the debt of just one client? A: In the filter, set Counterparty = the required customer, enable "Only unpaid" and generate. Q: What VAT rate is taken into account in the invoice amounts? A: The one specified in the invoice. In Kazakhstan in 2026 the standard VAT rate is 16%; in the example 160,000 ₸ on a base of 1,000,000 ₸. Q: Is it possible to see overdue amounts by payment deadline? A: Yes, if a payment deadline is set in the invoice/contract — group by deadline or add a filter by payment date; this shows which invoices are already overdue. Q: Does the report issue an ESF? A: No. The ESF and SNT are issued from sales documents in the IS ESF; the report only shows the payment status for the related invoices. Q: Why is a paid invoice still visible? A: Uncheck or check the "Only unpaid" checkbox — with the checkbox off, the report also shows fully paid invoices. Q: How to export the result to the client? A: The "Save as…" button → Excel or PDF, or "Send" as an attachment by email directly from the report. Q: Are foreign currency invoices shown in tenge? A: It depends on the "Report currency" parameter. Set tenge — the totals will be recalculated into ₸; leave the settlement currency — you'll see amounts in the original currency. Q: Does the report account for customer advances? A: It shows payment linked to an invoice. Unclosed advances without an invoice will not appear in this report — view them through the 1210 analysis/reconciliation statement. 10. Related Documents - What it is based on: "Invoice for payment to customer," "Sale of goods and services" (shipment), "Receipt to current account" / "Cash receipt order" (payment). - What is done based on the report results: issue a repeat invoice for payment, draw up a sale for unshipped items, generate a settlement reconciliation statement, issue an ESF for the shipment. - What to supplement it with: "Turnover balance sheet for account 1210," "Customer debt," "Settlement reconciliation statement" — for a complete picture of receivables. How to Find Out Your Release "Help" → "About" — there the platform version and configuration release are indicated. These instructions are current for release 3.0.74.2. The material was prepared for "Accounting for Kazakhstan," revision 3.0, release 3.0.74.2. --- _BuhGPT — ИИ-помощник для бухгалтеров Казахстана: https://buhgpt.kz_