Verified on release 3.0.74.2 "Accounting for Kazakhstan" (edition 3.0).
The buyer calls and says: "We don't owe you anything, we paid everything." You open the card of account 1210 — and there's 660,000 ₸ hanging there. Who's right? The amount in the reconciliation report is static, it only shows "how much right now." But you need to understand how this debt accumulated: when the shipment happened, when the partial payment came in, in which month the debt grew, and in which it dropped. This is exactly why you open the "Dynamics of Customer Debt" — the report shows not a point, but a line: the opening balance, turnovers, and closing balance for each period and each counterparty.
1. Purpose
The report shows the change in customer accounts receivable over time — by periods (day/week/month/quarter), counterparties, contracts, and settlement documents. It does not change data in the database and does not make postings: it reads the already generated movements on account 1210 and lays them out on a timeline. It is a management tool — to see the debt trend and find where a discrepancy with a counterparty came from.
2. Where to find
Menu path:
Section "Sales" (or "For Manager") → block "Reports" → "Dynamics of Customer Debt".
The most reliable way to open the report regardless of interface settings is a navigation link. Menu "Tools" → "Go to navigation link" (or the link icon in the header), paste:
e1cib/list/Отчет.ДинамикаЗадолженностиПокупателей
If the item is not in the section panel — click "Navigation settings" and add the report to the visible ones, or use the link.
2a. How to find out your release
"Help" → "About" (or the i icon in the upper right corner). In the window that opens, you will see two lines: the platform version (for example, 8.3.24.x) and the configuration release — "Accounting for Kazakhstan, edition 3.0 (3.0.74.2)". The second line is your release. If it differs from the one indicated in the header of this guide, individual fields and wordings may be named differently.
3. How to fill in (configure)
The report is generated with the "Generate" button. Before that, set the parameters in the header and in the settings.
| Field | Why it matters and what happens if wrong |
|---|---|
| Period from … to … (MANDATORY) | Analysis boundaries. The start date sets the "opening" balance, the end date — the "closing" one. Set a narrow period — you won't see the old shipment that the debt is hanging on, and you'll decide the data is "broken." |
| Organization (MANDATORY if there are several in the database) | Which legal entity to calculate for. An empty field with several organizations will mix debts of different firms — the figure will be meaningless. |
| Periodicity | Timeline step: day, week, month, quarter, year. For a yearly reconciliation, a month is more convenient; to "catch" a specific payment — a day. |
| Counterparty (filter) | Limits the selection to one customer. Left blank — all customers at once. To resolve a dispute with a specific client, be sure to set the filter, otherwise you'll drown in rows. |
| Contract (filter) | Needed when one customer has several contracts and settlements are kept separately. |
| Currency | For which settlements to show. If the contract is in a foreign currency and you forgot to switch the display — you'll see the tenge equivalent at the exchange rate and won't understand the discrepancy. |
| Groupings (structure) | How to break down the rows: Counterparty → Contract → Settlement document. Remove the detail down to the document — you won't find which specific invoice is not closed. |
Practical minimum: period (for example, the whole of 2026), organization, periodicity "Month", filter by the required counterparty, grouping "Counterparty → Contract → Settlement document". Clicked "Generate" — got the picture.
4. Worked example with figures and postings
Given. LLP "Astana-Trade" (VAT payer, rate 16%). Customer — Sole Proprietor "Bayterek". For 2026:
- January 15 — sale of goods for 1,160,000 ₸ (incl. VAT 16% = 160,000 ₸, income excl. VAT = 1,000,000 ₸).
- February 10 — 500,000 ₸ received from the customer.
- March 20 — another sale for 348,000 ₸ (incl. VAT = 48,000 ₸, income = 300,000 ₸).
The report itself makes no postings. It shows the result of these movements, which were generated by the "Sale" and "Receipt to account" documents:
| Date | Document | Dr | Cr | Amount, ₸ |
|---|---|---|---|---|
| 15.01 | Sale | 1210 | 6010 | 1,000,000 |
| 15.01 | Sale | 1210 | 3130 | 160,000 |
| 15.01 | Write-off of cost | 7010 | 1330 | (per accounting) |
| 10.02 | Receipt to account | 1030 | 1210 | 500,000 |
| 20.03 | Sale | 1210 | 6010 | 300,000 |
| 20.03 | Sale | 1210 | 3130 | 48,000 |
How this will appear in the report (periodicity "Month", customer "Bayterek"):
| Period | Opening balance | Increase in debt (shipment) | Repayment (payment) | Closing balance |
|---|---|---|---|---|
| January | 0 | 1,160,000 | 0 | 1,160,000 |
| February | 1,160,000 | 0 | 500,000 | 660,000 |
| March | 660,000 | 348,000 | 0 | 1,008,000 |
| Total 2026 | 0 | 1,508,000 | 500,000 | 1,008,000 |
Now everything is visible: the customer paid 500,000 in February, but the January shipment is not fully closed, and in March a new one was added. The final debt of 1,008,000 ₸ — and you can show the client not "1,008,000 is hanging," but by month, where it came from. The dispute is closed with figures.
5. Variants (operation types) of the report
This is a report, not a document, so it has no "operation types" with postings. But there are presentation variants and breakdowns it provides:
- By periods — classic dynamics (opening balance → turnovers → closing balance) on a day/week/month/quarter scale.
- By counterparties — ranking of customers by size and growth of debt.
- By contracts and settlement documents — detail down to a specific invoice.
- Chart — the same dynamics as a graph/histogram for a visual trend.
- By currencies — separately tenge and foreign currency settlements.
You can save your combination of filters and groupings via "More" → "Save settings" (report variants).
6. What is generated when building
Key point: the report makes no postings, creates no ESF or SNT, and writes no movements to registers. It only reads already existing data:
- the accounting register for account 1210 (balance and turnovers);
- with analytics by settlement documents — the register of mutual settlements with customers.
ESF (via the ESF IS) and SNT are generated at the stage of the sale document, not the report. Here you see only the monetary trace of these operations. Therefore, if the report shows a "wrong" amount, you need to fix the source document (the sale or the payment receipt), not the report.
7. Printed forms
The report has no separate form — the generated tabular document itself is printed:
- Print (printer icon) — output of the current report on paper.
- Save as — export to Excel (
.xlsx),.pdf,.mxlfor sending to the manager or attaching to a reconciliation report. - Chart — you can output/print a graphical representation of the dynamics.
For an official reconciliation with the customer, use not this report, but the document "Act of reconciliation of mutual settlements" — it has a regulated printed form with signatures of the parties.
8. Common mistakes
"The 'Organization' field is not filled in" — when there are several legal entities in the database. Select the organization in the header; an empty field will add up debts of different firms.
The report is empty, although there is a debt. The reason is almost always the period. The report's start date is later than the shipment date, and the "opening" balance was cut off along with the turnover. Extend the period from the start of settlements.
The amount in the report does not match the reconciliation report from the customer. The report is correct — the primary documents diverge. Detail down to the "Settlement document" and look for: an unposted sale, a payment attributed to another contract, or an advance offset that you have not made.
The debt is "stuck" on a closed contract / the payment did not close the shipment. The payment document does not specify, or specifies the wrong contract / settlement document. The payment went into an advance (1210 "by advances"), and the shipment remained hanging. Check the "Settlements" tab in the money receipt and, if necessary, do an "Offset of advances."
A currency contract shows a "strange" amount. Switch the currency display or remember that the tenge equivalent is recalculated at the rate on the date; at the end of the period it is revalued.
9. FAQ
1. Does the report make postings? No. This is an analytical report: it only reads the movements on account 1210 and lays them out over time. It makes no entries in the database.
2. How is it different from the "Turnover balance sheet for account 1210"? The TBS gives a snapshot on a date (opening/turnovers/closing for one interval). "Dynamics" breaks the same debt into several consecutive periods and builds a trend — you can see in which month the debt grew and in which it was repaid.
3. Can it replace a reconciliation report? For internal analysis — yes. For signing with a counterparty — no: the official form with signatures of the parties exists only for the document "Act of reconciliation of mutual settlements."
4. Why is the customer listed as in debt, although they paid? Most likely the payment is tied to the wrong contract or settlement document and went into advances. Detail the report down to the settlement document and check the "Settlements" tab in the money receipt.
5. How to see only overdue debt? In this report over time — detail by documents and look at shipment dates. For a strict distribution by terms (0–30, 30–60 days), use the report "Accounts receivable by debt terms."
6. Is VAT taken into account here? Yes. The debt on 1210 is formed for the entire sale amount including VAT. In the example, the shipment of 1,160,000 ₸ is income of 1,000,000 ₸ plus VAT 16% = 160,000 ₸, and the whole one million one hundred and sixty is hanging on the customer.
7. Can it be built for all customers at once? Yes — don't fill in the counterparty filter. Then group by "Counterparty" to get a ranking of debtors. To resolve a single dispute, still set the filter.
8. How to output a chart? In the settings, select chart output or switch the presentation to "Chart" — the debt dynamics will appear as a line/histogram by periods.
9. Does the report show the debt in the contract currency or in tenge? It depends on the currency setting in the report. By default — in the currency of management/accounting (tenge ₸); currency settlements can be shown separately.
10. Why does the figure change if you change the periodicity? The final closing balance does not change — only the breakdown of turnovers by rows changes. A day gives more rows, a quarter — a larger step. Always check the "Total" row.
10. Related documents
The report itself is not entered on the basis of anything and generates nothing — it reads the data of these documents:
- "Sale (of goods, services)" — increases the debt (Dr 1210 Cr 6010, Cr 3130); here ESF and SNT are also generated.
- "Receipt to current account" / "Cash receipt order" — repays the debt (Dr 1030 Cr 1210).
- "Debt adjustment" and "Offset of advances" — transfer amounts between contracts and close advances.
- "Act of reconciliation of mutual settlements" — the official reconciliation document; the data for it is prepared by the same analytics on 1210.
It makes sense to work in a bundle: saw a stuck debt in the dynamics → opened the settlement document → corrected the payment binding or made an offset → signed the reconciliation report.
How to find out your release: "Help" → "About" — the line with the configuration version.
The guide is prepared for "Accounting for Kazakhstan", edition 3.0, release 3.0.74.2. Values for 2026: VAT 16%, MCI 4,325 ₸, minimum wage 85,000 ₸.