Balance Sheet and Income Statement in Turkish Format
Short answer: A custom ALV report that produces the balance sheet and income statement from SAP in the Turkish Uniform Chart of Accounts structure, with Roman-numeral main groups and lettered sub-groups, comparing current and prior periods. Company code and business area breakdowns can be selected; accounts with reverse balances are moved to the correct side, and the statement is exported to Excel in its statutory layout.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
S_ALR_87012284 and F.01 produce the balance sheet with a financial statement version, but the reverse balance rules of the local presentation (for example moving a credit-balance receivable account to liabilities), lettered line numbering and a clean Excel export need many nodes in the version and the output is still edited by hand. A comparative statement by business area needs separate runs.
Who uses it? Finance managers, general ledger teams, and management reporting and audit preparation teams.
Closest standard alternatives
- S_ALR_87012284 Financial Statements. Produces balance sheet and income statement with a financial statement version; local reverse balance rules and the statutory Excel layout need extra editing.
- F.01 Financial Statements. Gives the classic list output by financial statement version; business area comparison and local line numbering are limited.
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: The balance sheet and income statement layouts set by the General Communiqués on the Accounting System.
The line structure and account ranges are checked against the company's chart of accounts and the layout in current regulation during installation; if TFRS or BOBİ FRS presentation is needed, a separate line structure is defined.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| FAGLFLEXTNew General Ledger: Totals | G/L period balances with business area (driving table) | — | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | Universal journal used for balances on S/4HANA | — | ECC + S/4 |
| SKA1G/L Account Master (Chart of Accounts) | Balance sheet vs P&L account indicator (XBILK) | SKA1-SAKNR = FAGLFLEXT-RACCT | ECC + S/4 |
| SKATG/L Account Descriptions | Account names | SKAT-SAKNR = SKA1-SAKNR AND SKAT-KTOPL = SKA1-KTOPL | ECC + S/4 |
| T001Company Codes | Company name, currency and chart of accounts | T001-BUKRS = FAGLFLEXT-RBUKRS | ECC + S/4 |
S/4HANA notes
- FAGLFLEXT → ACDOCA: In S/4HANA totals tables are no longer updated separately; FAGLFLEXT is read as a compatibility view that aggregates ACDOCA line items.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | T001-BUKRS | Yes | 1000 |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes | 2026 |
| P_MONAT | To period | Single value | BKPF-MONAT | Yes | 09 |
| S_GSBER | Business area | Range / multiple | BSEG-GSBER | No | 0001 |
| R_BAL | Balance sheet | Radio button | — | No | X |
| R_PL | Income statement | Radio button | — | No | — |
| P_PREV | Compare with prior year | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Line code | Calculated Line from the mapping table (I, A, 1 …) |
| 2 | Line name | Calculated Statutory line name, indented by level |
| 3 | Business area | FAGLFLEXT-RBUSA |
| 4 | Current period | Calculated Balance total of the line's accounts or subtotal |
| 5 | Prior period | Calculated Balance at the same period end of the prior year |
| 6 | Difference | Calculated Current − prior |
| 7 | Difference % | Calculated (Current − prior) / prior × 100 |
Sample output
| Line code | Line name | Business area | Current period | Prior period | Difference | Difference % |
|---|---|---|---|---|---|---|
| I | CURRENT ASSETS | 48,620,000 | 41,270,000 | 7,350,000 | 17.80 | |
| I.A | Liquid Assets | 6,840,000 | 5,915,000 | 925,000 | 15.60 | |
| I.C | Trade Receivables | 21,430,000 | 18,260,000 | 3,170,000 | 17.40 |
How does the report work?
- The line structure is kept in a mapping table: I. Current Assets, A. Liquid Assets, B. Marketable Securities … and in the income statement A. Gross Sales, B. Sales Deductions … Each line has an account range and the line it moves to on a reverse balance.
- Balances for the selected company code, year and period are read from FAGLFLEXT (ACDOCA on S/4HANA) by account and optionally by business area.
- The balance direction of each account is checked; an account with a reverse balance moves to the counter line in the mapping (for example a credit-balance sub-account of 120 moves to 340 Advances Received).
- Subtotals and the net profit for the period are calculated; equality of total assets and total liabilities is checked.
- The same date of the prior year comes in a side column with the difference amount and percentage.
- You can drill down from a line to accounts and from an account to items; the Excel output follows the statutory layout with indented line names.
Performance notes
Read balances from FAGLFLEXT or ACDOCA aggregated by account and business area in the database; the reverse balance check runs per account in memory. The report runs within seconds for one company code.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Drill down from a line to accounts and from an account to items.
- Export to Excel The statement is exported to Excel in its statutory layout with indented line names.
Authorization objects
- F_BKPF_BUKAccounting data display authorization by company code
- F_BKPF_GSBDisplay authorization by business area
Frequently asked questions
Why a separate mapping table instead of the financial statement version?
In the local presentation the reverse balance rules differ by account and the lettered line structure needs many nodes in a financial statement version. The mapping table is one list the accounting team can maintain easily. An initial mapping can be generated from the existing financial statement version.
Does it produce consolidated statements?
No. The report works per company code; when several company codes are selected their total can be shown, but intercompany eliminations are not made.
Related reports
Cost of Goods Manufactured and Cost of Sales Statement (Turkey)
A custom ALV report that prepares the cost of sales statement of the Turkish financial statement schedules directly from SAP G/L balances. It starts …
Inventory Book (Envanter Defteri) Report and Print
A custom ALV report and print output that prepares the year-end inventory book from SAP account by account. The closing balance of every balance sheet …
Türkiye Legal Journal and General Ledger (Defter-i Kebir) Printout Report
A custom ALV report that prints the accounting entries of the selected period in legal format, either as a journal in date order with journal entry …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.