# Balance Sheet and Income Statement in Turkish Format

> 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.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (6–9 working days)
- Localization: TR
- Last updated: 2026-11-18
- URL: https://nekuhub.com/en/reports/turkey-balance-sheet-and-income-statement-local-format/


## Localization and legal basis: Türkiye

- 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.

## 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.

### Closest standard alternatives

- S_ALR_87012284: 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: Gives the classic list output by financial statement version; business area comparison and local line numbering are limited.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| FAGLFLEXT | G/L period balances with business area (driving table) | Read | - | ECC + S/4 |
| ACDOCA | Universal journal used for balances on S/4HANA | Read | - | ECC + S/4 |
| SKA1 | Balance sheet vs P&L account indicator (XBILK) | Read | SKA1-SAKNR = FAGLFLEXT-RACCT | ECC + S/4 |
| SKAT | Account names | Read | SKAT-SAKNR = SKA1-SAKNR AND SKAT-KTOPL = SKA1-KTOPL | ECC + S/4 |
| T001 | Company name, currency and chart of accounts | Read | T001-BUKRS = FAGLFLEXT-RBUKRS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_BUKRS | Company code | Single value | T001-BUKRS | Yes |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes |
| P_MONAT | To period | Single value | BKPF-MONAT | Yes |
| S_GSBER | Business area | Range / multiple | BSEG-GSBER | No |
| R_BAL | Balance sheet | Radio button | - | No |
| R_PL | Income statement | Radio button | - | No |
| P_PREV | Compare with prior year | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Line code | Calculated: Line from the mapping table (I, A, 1 …) |
| Line name | Calculated: Statutory line name, indented by level |
| Business area | FAGLFLEXT-RBUSA |
| Current period | Calculated: Balance total of the line's accounts or subtotal |
| Prior period | Calculated: Balance at the same period end of the prior year |
| Difference | Calculated: Current − prior |
| Difference % | Calculated: (Current − prior) / prior × 100 |

## How does the report work?

1. 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.
2. Balances for the selected company code, year and period are read from FAGLFLEXT (ACDOCA on S/4HANA) by account and optionally by business area.
3. 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).
4. Subtotals and the net profit for the period are calculated; equality of total assets and total liabilities is checked.
5. The same date of the prior year comes in a side column with the difference amount and percentage.
6. 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.

## Authorization objects

- F_BKPF_BUK: Accounting data display authorization by company code
- F_BKPF_GSB: Display 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=tr-financial-statements
