Verified on release 3.0.74.2 "Accounting for Kazakhstan" (edition 3.0).
A counterparty sent a reconciliation report, but you have a different amount on account 1210. The standard "Turnover balance sheet" shows only the total, while you need to see every posting: date, document, amount, VAT rate. You open the Universal Report, in a minute you compile a list of all movements for this buyer for the quarter — and find that very sale that the counterparty did not record on their side. Below is how to configure this tool for any task.
Important from the very first line. The Universal Report is a report, not a document. It does not post anything, does not create postings, does not issue ESF or SNT. It reads already prepared data from registers, reference books and documents and displays it the way you find convenient. Therefore, where the usual document guide says "postings upon posting," here we are talking about what data the report can extract.
1. Purpose
The Universal Report is a builder of custom reports. You choose yourself where to take data from (register, reference book, document), which indicators to calculate, how to group rows and columns, what to select. It is used when standard reports ("Turnover balance sheet," "Account card," "Subconto analysis") do not provide the required breakdown.
2. Where to find
Menu: the "Reports" section → the "Standard reports" group (or "Other") → "Universal Report".
Faster — via a navigation link. Copy the line below, in 1C click "Tools" → "Go to navigation link" (or Alt+F1 in the web client) and paste:
e1cib/list/Документ.УниверсальныйОтчет
You can also open the report form itself via "All functions" → "Reports" → "Universal Report" (if "All functions" is not visible, enable it: "Tools" → "Options" → Display the "All functions" command).
2a. How to find out your release
"Help" → "About the program" (the question mark icon in the top right corner). There are two lines there: the platform version (for example, 8.3.24) and the configuration release — "Accounting for Kazakhstan, edition 3.0 (3.0.74.2)." If your release is older, individual fields may be named differently, but the configuration logic is the same.
3. How to fill in (configure the report)
Configuration goes from top to bottom. Three fields in the header are mandatory, without them the report is empty.
| Field | Why | What happens if you make a mistake |
|---|---|---|
| Period (MANDATORY) | Selection boundaries: from which to which date to take data | Too narrow a period — a "shortage" of rows; too wide — the report pulls in unnecessary years and slows down |
| Data source type (MANDATORY) | Accumulation register / Information register / Accounting register / Reference book / Document / Document journal | Choose the wrong type — you won't find the required data table |
| Data source (MANDATORY) | A specific object: for example, "Postings journal (accounting and tax accounting)" | An empty list of indicators — nothing to compile from |
| Table | One source may have several tables: "Balances," "Turnovers," "Balances and turnovers," "Movements" | Take "Turnovers" instead of "Balances" — you will see movements for the period instead of the balance |
Next click "Settings" (the button at the top) and expand the required tabs:
- Indicators — what to sum: Amount, Quantity, DrAmount, CrAmount, AccAmount, etc. Check the boxes. If you check nothing, the table will contain only groupings without figures.
- Rows (groupings) — how to break down data vertically: by counterparty, by account, by item, by recorder (document). The order of groupings = the order of nesting.
- Columns — horizontal breakdown: by month, by organization, by VAT rate.
- Selection — a filter. Here you set "Counterparty = LLP 'Astana-Snab'," "Account = 1210," "VAT rate = 16%." Selection is the main tool of precision; without it the report will show everything indiscriminately.
- Sorting — by amount descending, by date, alphabetically.
- Appearance — conditional highlighting (for example, negative balances in red), grouping of totals.
Configure once — save via "Save variant" so as not to compile it again. Click "Generate" (or F5).
4. Worked example with figures
Task. Check which postings the sale of goods to buyer LLP "Astana-Snab" generated for August 2026, and reconcile the amount with its report.
The original sale in accounting:
- Goods sold for 1,160,000 ₸ including VAT.
- Amount excluding VAT — 1,000,000 ₸, VAT 16% — 160,000 ₸.
- Cost of goods — 650,000 ₸.
The postings made by the "Sale" document (which the report will show):
| Dr | Cr | Amount, ₸ | Description |
|---|---|---|---|
| 1210 | 6010 | 1,000,000 | Income from sales |
| 1210 | 3130 | 160,000 | VAT payable 16% |
| 7010 | 1330 | 650,000 | Cost of goods written off |
Report configuration:
- Period — 01.08.2026 – 31.08.2026.
- Source type — Accounting register.
- Source — Postings journal (accounting and tax accounting).
- Table — Movements.
- Indicators — Amount (AccountingAmount).
- Rows — Recorder → Dr Account → Cr Account.
- Selection — Subconto "Counterparties" = LLP "Astana-Snab".
- Generate.
Result. The report outputs three rows for a total debit amount on 1210 = 1,160,000 ₸. This is exactly the figure you reconcile with the counterparty's report. If they have 1,000,000, then they did not account for VAT; if 1,300,000 — they have an extra document "hanging." Thus, in a minute you find a discrepancy that is not visible in the "Turnover balance sheet."
5. Operation types (data source types)
The "operation type" for this report is the choice of source type. Each opens its own layer of data:
| Source type | What it shows | Example task |
|---|---|---|
| Accounting register | Dr/Cr postings, turnovers and balances by accounts | All movements on account 1210 broken down by documents |
| Accumulation register | Goods and cash movements (balances/turnovers) | Balances of goods in the warehouse by item |
| Information register | Periodic data: exchange rates, rates, prices | Item price history, ₸ rate by dates |
| Calculation register | Payroll accruals | Summary of IIT, MPC, SC for the month |
| Reference book | Element attributes | List of counterparties with BIN and without contracts |
| Document | Attributes and tabular sections of documents | All sales over 1,000,000 ₸ |
| Document journal | List of documents of one journal | All incoming ESF for the quarter |
6. What is generated during construction
Once again, clearly: the Universal Report does not create movements. When you click "Generate," it:
- does not make postings and does not change balances;
- does not issue ESF and does not generate SNT — these electronic documents are created by "Sale," "Invoice (issued)," "Transfer," and the report only shows them as rows if you select the corresponding journal/document as the source;
- does not write anything to registers — it only reads.
The only result is a table on the screen, which you then print or export. Therefore the Universal Report is safe: you cannot "spoil" data with it.
7. Printed forms
The report has no separate "printed form" — the generated table itself is printed:
- Print — the "Print" button (Ctrl+P), with preview and adjustment of margins/scale.
- Save as → Microsoft Excel (.xlsx), Spreadsheet (.mxl), PDF document, HTML, CSV.
- Send by email directly from the form (the envelope button), if an email account is configured.
- Save report variant — not printing, but saves the configuration itself for reuse.
8. Common mistakes
"The 'Period' field is not filled in" / the report is empty. The period is not set or is set incorrectly. Check the start and end dates; for a balance register, it is the exact date on which you are viewing the balance that matters.
The report is generated, but there are no rows, although the data definitely exists. Too strict a selection. A common reason is a selection by a subconto that is not in these postings (for example, a selection by "Item" on account 1210, where the subconto is "Counterparties" and "Contracts"). Remove the unnecessary selection and add them one by one.
"Data source not selected" / the list of indicators is empty. The source type is selected, but no specific object is selected in the "Data source" field. Expand the list and specify, for example, "Postings journal."
Amounts are twice as large as in the "Turnover balance sheet." The "Balances and turnovers" table is selected instead of "Turnovers," or the groupings are doubled. Change the table or remove the duplicating grouping by recorder.
The report takes a very long time to generate or "hangs." Too wide a period (several years) on a large register without a selection. Narrow the period and add a selection before generating.
"Error when calling context method" when exporting to Excel. A file with the same name is open in Excel. Close it and repeat the export under a different name.
9. FAQ
Does the Universal Report make postings? No. It is a report, not a document. It only shows already existing postings, movements and balances. You cannot change accounting data through it.
Can you issue an ESF or SNT from the Universal Report? No. ESF and SNT are generated by a sale, an invoice and a transfer. With the report you can only build a list of issued ESF by selecting the corresponding journal or document as the source.
How does it differ from the "Turnover balance sheet"? The "Turnover balance sheet" is a ready-made report with a fixed structure by accounts. You compile the Universal Report yourself: any source, any groupings and indicators, any selection. It is more flexible, but requires configuration.
How to view all postings for one counterparty? Source — "Accounting register" → "Postings journal," the "Movements" table, grouping by recorder, selection by subconto "Counterparties" = the required counterparty.
How to check accrued VAT at the 16% rate? Build a report on the accumulation register "VAT payable/creditable" or on postings on account 3130, add a "VAT rate" column. You will see the base and the tax amount at the 16% rate.
How to save the configuration so as not to compile it every time? The "Save variant" button. Give it a name (for example, "Postings by buyers"). Next time select it from the list of variants at the top.
Can data for several organizations be displayed at once? Yes. Do not set a selection by organization, but add "Organization" to the columns or groupings — you will get a breakdown by all legal entities of the database.
Why do the AA (accounting) and TA (tax) amounts not match in the report? In the accounting register for Kazakhstan, accounting and tax accounting amounts are stored separately. Add both indicators (AccountingAmount and TaxAmount) — the difference due to permanent/temporary differences is normal, not an error.
Can you build a report on payroll accruals — IIT, MPC, SC? Yes. Select the source type "Calculation register" (accruals) or accumulation registers for contributions. This way you will compile a summary of IIT 10%, MPC 10%, SC 5%, social tax 6% for the period.
How to export the result to Excel? After generating: "Save as" → "Microsoft Excel sheet (.xlsx)." The file will open separately, the data can be edited and recalculated.
10. Related objects
The Universal Report is not entered "based on" a document — it is built over the data created by other objects:
- Sources of postings: "Sale of inventory and services," "Receipt of inventory and services," "Payment order (outgoing/incoming)," "Debit from the current account," "Receipt to the current account" — you read their postings through the accounting register.
- Sources of movements: goods movement documents (transfer, capitalization) — through accumulation registers.
- Electronic documents ESF and SNT are created from a sale and an invoice; in the report they are visible as journal records.
- Alternatives: if the task is standard, it is faster to take a ready-made report — "Turnover balance sheet," "Account card," "Subconto analysis," "Turnovers between subconto." Use the Universal Report when standard breakdowns are not enough.
How to find out your release. "Help" → "About the program": the platform version and the configuration release are indicated there. Field settings may differ slightly between releases.
The instruction has been prepared for "Accounting for Kazakhstan," edition 3.0, release 3.0.74.2.