1. Identification of the Object
| Parameter | Value |
|---|---|
| Object Type | Report |
| Name | TurnoversBetweenSubaccountsStandard |
| Full Path | Report.TurnoversBetweenSubaccountsStandard |
| Synonym | Turnovers between subaccounts (accounting) |
| Configuration | Accounting for Kazakhstan, edition 3.0, version 3.0.74.2 |
| Country/Localization | Republic of Kazakhstan (₸, chart of accounts of the RK, VAT rate 16%) |
Purpose. The report is designed for analyzing turnovers and correspondences between various types of analytical accounting (subaccounts) on accounting accounts. It allows accountants and financial analysts to study the interrelationships between accounting objects (counterparties, contracts, projects, divisions, nomenclature, etc.) across one or more accounts. It generates a multidimensional table: subaccounts specified in rows, corresponding subaccounts (with whom the turnover occurred) in columns. It supports a breakdown mode for transitioning to primary documents. It is used weekly to monthly — during period closing and reconciliations.
Where to find in 1C: section "Reports" → "Turnovers between subaccounts (accounting)."
Navigation link: e1cib/list/Report.TurnoversBetweenSubaccountsStandard
2. Attributes and Table Parts
2.1 Attributes (form/settings parameters)
| Name | Type | Mandatory | Purpose |
|---|---|---|---|
| StartPeriod | Date (dateTime) | Not checked | Start date of the analysis period. Sets the lower limit for selecting entries from accounting registers. |
| EndPeriod | Date (dateTime) | Not checked | End date of the analysis period. Sets the upper limit for selecting entries. |
| OrganizationListRepresentation | String | Not checked | Text representation of selected organizations for display in the form without opening selection settings. |
| DepartmentListRepresentation | String | Not checked | Text representation of selected departments to inform the user about applied filters. |
| AdditionalFieldsPlacement | Number (decimal) | Not checked | Method of placing additional fields in the layout (vertically/horizontally). Affects the structure of the final table. |
| BreakdownMode | Boolean | Not checked | Flag for interactive breakdown mode: transition from summary indicators to primary documents. |
| BUIndicator | Boolean | Not checked | BU indicator — total turnovers in the main accounting currency (₸). The main indicator for most scenarios. |
| CurrencyAmountIndicator | Boolean | Not checked | Currency amount indicator for multi-currency accounts (relevant for accounts accounting for currency transactions). |
| QuantityIndicator | Boolean | Not checked | Quantitative indicator for accounts with quantitative accounting (goods, materials, products). |
| SubaccountTypesList | ValueList | Mandatory | List of subaccount types for analysis by rows. The report cannot be generated without filling this in. Defines the main analytics. |
| CorrespondingSubaccountTypesList | ValueList | Mandatory | List of corresponding subaccount types for analysis by columns. Defines the analytics of correspondence (with whom the turnover occurred). |
2.2 Table Parts
Grouping — setting up groupings and data detailing: selection of grouping fields for rows, type of totals, and order of nesting levels. The user forms a hierarchy of analytical cuts by which the result is summarized.
Additionally, reports of this class include auxiliary table parts/settings sets: selection (conditions based on subaccount values, accounts, organizations), sorting, and composition of additional fields. Their composition is determined by the report's data composition scheme.
3. Forms
The report uses the standard set of forms for objects of the type "Report" in BK 3.0:
| Form | Purpose |
|---|---|
| Main Report Form | Input of the period, selection of organizations/departments, specification of subaccount types and corresponding subaccounts, inclusion of indicators (BU, currency amount, quantity), initiation of generation and output of the result in the table document field. |
| Settings Form (layout settings) | Extended structure settings: groupings, selections, sorting, composition of indicators and additional fields, formatting. |
| Variant Selection Form | Selection of a saved report variant from predefined and user-defined variants. |
Forms interact through data composition settings parameters; the result is output in the table document field with support for breakdowns.
4. Key Module Procedures
The attached evidence does not provide the source texts of the modules (BSL). Below is a typical set of handlers for the BK 3.0 report based on the data composition scheme. Exact names and lines are specified in the configurator.
- OnResultComposition (report form module) — main handler: before outputting the data composition scheme, it substitutes user parameters (period, list of subaccount/corresponding subaccount types, indicators), checks the mandatory parameters
SubaccountTypesListandCorrespondingSubaccountTypesListfor completion. - OnCreationOnServer — initialization of default settings, setting the period, restoring the last used variant.
- SetPeriod / ProcessPeriodSelection — working with the attributes
StartPeriodandEndPeriod, synchronization with the data composition scheme parameters. - GenerateReport (client → server) — assembling layout settings, calling the data composition processor, outputting to the table document.
- ResultBreakdownProcessing — when
BreakdownModeis enabled, opens the primary document or detailed report for the selected cell. - Handlers for displaying selections — filling
OrganizationListRepresentationandDepartmentListRepresentationfor informative display of applied filters.
The main logic of calculations is implemented in the data composition scheme (layout MainDataCompositionScheme): the data set is built by querying the turnover tables of the accounting register CostAccounting (virtual table CostAccounting.TurnoversDebitCredit with breakdown by types of subaccounts and corresponding subaccounts).
5. Data Sources and Movements
The report does not generate entries and movements in registers — it is a read-only object. It selects already formed records from the accounting register.
- Main source: accounting register
CostAccounting, virtual turnover table Debit-Credit (CostAccountingBalancesAndTurnovers/CostAccountingTurnovers) with dimensions by subaccounts. - Dimensions: debit account, credit account, up to three types of debit and credit subaccounts, organization, department.
- Indicators: BU amount (₸), currency amount, quantity.
Example of analyzed correspondences (chart of accounts of the RK, VAT rate 16%):
| Business Operation | Debit | Credit | Comment |
|---|---|---|---|
| Sale of goods to the customer | 1210 | 6010 | Accounts receivable from customers ↔ revenue from sales |
| VAT accrued on sales | 1210 | 3130 | VAT 16% on taxable turnover |
| Cost of goods sold written off | 7010 | 1330 | Cost of goods sold ↔ goods in stock |
| Receipt of goods from the supplier | 1330 | 3310 | Goods ↔ accounts payable to suppliers |
| Payment to the supplier from the current account | 3310 | 1030 | Accounts payable ↔ cash in the account |
| Receipt of payment from the customer | 1030 | 1210 | Cash ↔ accounts receivable from customers |
For example, setting the subaccount "Counterparties" in rows and "Nomenclature" in columns for account 1210↔6010, the report will show which customers and for which nomenclature revenue from sales was generated during the period.
When selling for 116,000 ₸ (including VAT 16% = 16,000 ₸), the turnovers will be distributed: Debit 1210 Credit 6010 — 100,000 ₸, Debit 1210 Credit 3130 — 16,000 ₸.
6. Related Objects and Input on the Basis
- Accounting register
CostAccounting— the only data source. - Plans of characteristic types
CostAccountingSubaccountTypes— define the allowable values forSubaccountTypesListandCorrespondingSubaccountTypesList. - Chart of accounts
CostAccounting— accounts of the RK (1210, 1030, 1330, 3310, 3130, 6010, 7010, etc.). - Directories
Organizations,Departments,Counterparties,Nomenclature,Contracts— sources of subaccount values and selections. - Breakdowns lead to primary documents (sales, receipts, payment documents, including those related to electronic invoices (ESF)/SNT).
Input on the basis for reports is not provided. The report itself serves as a transition point (through breakdown) to primary documents.
7. Extension Points
- User report variants — saving configured combinations of subaccount types, selections, and groupings.
- Extension of the data composition scheme through configuration extension: adding calculated fields, resources, additional data sets.
- Additional handlers for the object/form module in the extension — for example, filling in indicators or custom processing of breakdowns.
- External printed forms and layouts for data composition — connectable output options.
- Roles and functional options — managing the availability and composition of indicators.
Requires verification (version-specific): the exact list of predefined variants and composition of additional fields in the layout may differ between releases of the 3.0.74.x line.