Checked on release 3.0.74.2 "Accounting for Kazakhstan" (version 3.0).
The customer calls and says, "We don't owe you anything." But you have an amount hanging in the turnover on account 1210, and the payment deadline has already passed last quarter. Or vice versa — the manager asks for a list of debtors for the meeting in 10 minutes, and you don't want to manually sift through the turnover for each counterparty. This report is needed for such moments. It shows who owes you, how much, and how overdue — broken down by terms, without manual counting on a calculator.
It's important from the very beginning: this is a report, not a document. It does not post anything, does not create an electronic invoice (ESF), and does not change your data. It only reads what is already in the accounting and organizes it. Therefore, it does not have sections for "entries when processing" — and that's normal.
1. Purpose
The report collects accounts receivable from customers (account 1210 — short-term receivables) as of a selected date and breaks it down by overdue intervals: up to 7 days, 8–30, 31–60, over 90, etc. You can immediately see the "fresh" debt and the hopeless one, for which it's time to take action or create a reserve.
2. Where to find
Path in the menu:
Section "Sales" → group "Reports" → "Overdue Accounts Receivable".
If you have the "For the Manager" section set up, the report is duplicated there — in the analytics block on settlements.
The most reliable way to open the report directly is through the navigation link. Copy it, click in 1C "Service" → "Go to navigation link" (or Ctrl+F11 in the web client) and paste:
e1cib/list/Report.OverdueAccountsReceivable
2a. How to find out your release
"Help" → "About the program" (or the "i" icon in the upper right corner). In the opened window — the version of the platform (for example, 8.3.24) and configuration release ("Accounting for Kazakhstan, version 3.0 (3.0.74.2)"). The instructions below are tied specifically to release 3.0.74.2 — on similar releases, the interface matches, but minor field labels may differ.
3. How to set up and generate
The report is generated by clicking "Generate" (F5). Before that, set the parameters in the header.
| Field | Purpose and what will happen if set incorrectly |
|---|---|
| As of (mandatory) | The date for which the debt and overdue period is calculated. If you set yesterday's date — you won't see today's accruals. If you set a future date — the overdue will "increase" by extra days. Usually, set the current date or the last day of the month. |
| Organization (mandatory when accounting for multiple companies) | Which company to calculate for. In a database with one organization, the field is filled automatically. If you choose the wrong one — you will get someone else's debt. |
| Overdue intervals | Boundaries of "buckets" in days (0–7, 8–30, 31–60, 61–90, over 90). They are set in the report parameters. They determine which column the debt will fall into. Too large intervals — you will lose detail for the reserve. |
| Grouping (rows) | How rows are constructed: Counterparty → Contract → Settlement Document. If you remove "Contract" — you won't understand which transaction the debt is for. |
| Filter | Filter by a specific counterparty, manager, contract. Needed when reconciling with one customer. |
| Currency | If there are currency contracts — the amount is recalculated at the exchange rate as of the report date. Check that the rate for "As of" is loaded, otherwise, you will see empty amounts for currency transactions. |
A key point: overdue is calculated from the payment term, which is taken from the contract or the sales document. If the "Payment Term" field (number of days or specific date) is not filled in the contract, 1C will not know when the debt became overdue, and the entire amount may "fall" into the "0 days" interval or into the total balance. Therefore, 90% of errors in this report are due to the unfilled payment term in contracts.
4. An example with numbers
Initial data. LLP "Astana-Snab" (VAT payer, rate 16%) shipped goods to LLP "Stroy-Resurs" on July 15, 2026. The cost of the batch is 700,000 ₸. According to the contract, the payment term is 10 days (i.e., until July 25, 2026). Payment has not been received. The report is generated as of September 6, 2026.
Calculating the sales amount:
- Cost excluding VAT: 1,000,000 ₸
- VAT 16%: 1,000,000 × 16% = 160,000 ₸
- Total payable: 1,160,000 ₸
Entries of the "Sales of Goods and Services" document (generated by the sale, not the report):
| Dr | Cr | Amount, ₸ | Description |
|---|---|---|---|
| 1210 | 6010 | 1,000,000 | Revenue from sales |
| 1210 | 3130 | 160,000 | VAT payable 16% |
| 7010 | 1330 | 700,000 | Cost of goods written off |
After posting, there is a debit balance of 1,160,000 ₸ on account 1210 for "Stroy-Resurs".
What the report will show on 06.09.2026. The payment term expired on July 25, 2026. From July 25 to September 6 — 43 days overdue. Therefore, the amount will fall into the "31–60 days" column:
| Counterparty | Contract | Total debt | 0–7 | 8–30 | 31–60 | 61–90 | >90 |
|---|---|---|---|---|---|---|---|
| LLP "Stroy-Resurs" | Contract No. 14 | 1,160,000 | — | — | 1,160,000 | — | — |
| Total | 1,160,000 | 1,160,000 |
You can immediately see: the debt is of "medium severity", and it's time to write a claim. If "Stroy-Resurs" had paid 500,000 ₸ on September 5 (Dr 1030 Cr 1210), the report on September 6 would have shown 660,000 ₸ in the same interval.
5. Report options (analogous to "types of operations")
The report does not have "types of operations" like a document — instead, it has options for generation and grouping:
- By overdue intervals — the main type, breakdown by "buckets" of days.
- By counterparties — collapsed to one line per customer.
- By contracts / settlement documents — detailing down to a specific transaction.
- With filtering by manager — for monitoring the work of a specific seller.
You can save your configuration with the "Save option" button and call it later with one click.
6. What is generated when forming
Once again, honestly: the report does not make entries, does not create ESF and SCT, does not write movements to registers. It only reads data:
- accounting register — balances on account 1210;
- information on payment terms from contracts and sales documents;
- exchange rates — for currency contracts.
ESF and SCT are generated earlier — at the stage of the "Sales of Goods and Services" document, not in this report. The report only shows the consequence: the unpaid balance on 1210.
7. Print forms and output
There is no separate "print form" like in a document — the report's table area is printed:
- Print (Ctrl+P) — output of the generated table to the printer.
- Save as... — export to Excel (.xlsx), .pdf, .mxl.
- Send by email — directly from the report form as an attachment.
The finished table is convenient to attach to the reconciliation act or to a report for the manager.
8. Common errors and 1C messages
"The date for which the report is generated is not filled in." The "As of" field is empty. Set a date and click "Generate".
There is debt in the turnover, but the report is empty / the entire amount is in "0 days". The "Payment Term" is not filled in the contract. Open the customer's contract, set the number of days of deferral or a specific payment date, repost the settlement documents, and regenerate the report.
"Could not determine the exchange rate on the date...". There is no exchange rate for tenge on the date of the report for the currency contract. Load the rates: "Directories" → "Currencies" → "Load exchange rates".
The debt amount is duplicated. Double sale without mutual offset of advance or unaccounted advance account 1210/3510. Make a "Debt Adjustment" or perform an advance offset, then regenerate the report.
Negative amounts in the report. There is an overpayment for the counterparty (credit balance 1210 or advance on 3510). This is not overdue — check if the payment is duplicated.
9. FAQ
Is there an overpayment from the customer? Will the report show it? The report is focused on overdue receivables. An overpayment (advance) will appear as a negative amount or may not appear at all — for a complete picture, check the account statement for account 1210 or the "Settlements with Counterparties" report.
Where does the overdue term come from? From the payment term in the contract or in the sales document. Days overdue = (report date − payment term). No payment term — no correct overdue.
Can the intervals (0–7, 8–30, etc.) be changed? Yes, in the report settings (button "Settings" / "More" → "Change option"). Set your boundaries according to your credit policy.
Why is the amount in the report with VAT, while in revenues it is without? The customer's debt (1210) includes VAT, as they must pay the entire invoice amount. In the example, this is 1,160,000 ₸, while revenue 6010 is only 1,000,000 ₸.
Does the report create entries or ESF? No. This is just a report. Entries and ESF are generated by the sales document.
How to view the debt on a specific past date? Set the desired date in the "As of" field — the report will recalculate balances and overdue for that date.
Can only debtors over 90 days be displayed? Yes — through filtering in the settings or by referring to the "over 90 days" column. These amounts are candidates for reserves for doubtful debts.
Why is the customer in the turnover of 1210, but not in the report? Most likely, the debt is not yet overdue (the payment term has not arrived) or the payment term is not specified in the contract. Check the contract.
How does this report help with reserves for doubtful debts? The columns "61–90" and "over 90 days" are the basis for assessing doubtful and hopeless debts. They make it easy to decide on write-offs and reserve accruals.
Can the data be exported to Excel for the lawyer? Yes, "Save as..." → .xlsx. The finished list of debtors with amounts and terms will go into claim work.
10. Related documents
Data sources for the report (what generates the debt):
- Sales of Goods and Services — main entry Dr 1210 Cr 6010/3130.
- ESF (electronic invoice) and SCT — accompany the sale but do not affect the report figures.
- Contract with the customer — source of the payment term (key field for overdue).
What actions are taken based on what is seen in the report:
- Receipt to the bank account (Dr 1030 Cr 1210) — closes the debt.
- Reconciliation act — confirmation of the amount with the counterparty.
- Debt adjustment — offset of advances, transfer, write-off.
- Operation (manual entry) — accrual of reserves for doubtful debts and write-off of hopeless debts.
How to find out your release: "Help" → "About the program" — there you will find the version of the platform and the configuration release.
The instructions are prepared for "Accounting for Kazakhstan", version 3.0, release 3.0.74.2.