Türkiye Stamp Tax Calculation and List Report
Short answer: A custom ALV report that calculates stamp tax on the value of sales and purchasing contracts with the rate and the maximum amount cap, compares it with the stamp tax posted in accounting and shows missing or excess postings. The list grouped by declaration period is used when preparing the withholding and social security declaration.
- Estimated effort
- S · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VA45 lists sales contracts and ME3L lists purchasing contracts; neither calculates stamp tax, applies the maximum amount cap or compares with the accounting posting. Teams export the contract list to Excel and calculate the tax by hand. The report calculates both contract types in one list and reconciles them with the postings.
Who uses it? Tax and accounting teams, purchasing and sales contract management teams.
Closest standard alternatives
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: Stamp Tax Law No. 488 and table (1) attached to the law.
The tax rate and the maximum amount per document are updated every year; the values are entered as parameters.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| VBAKSales Document Header | Sales contracts: date, customer and net value | — | ECC + S/4 |
| EKKOPurchasing Document Header | Purchasing outline agreements: date, vendor | — | ECC + S/4 |
| EKPOPurchasing Document Item | Target values of the purchasing contract | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| BSEGAccounting Document Segment | Postings to the stamp tax account | BSEG-HKONT = damga vergisi hesabı AND BSEG-ZUONR = sözleşme no | ECC + S/4 |
| TCURRExchange Rates | Rate on the contract date for foreign currency contracts | TCURR-FCURR = VBAK-WAERK | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BKPF-BUKRS | Yes | 1000 |
| S_DATE | Contract date | Range / multiple | VBAK-AUDAT | Yes | 01.10.2026 – 31.10.2026 |
| S_AUART | Sales contract types | Range / multiple | VBAK-AUART | No | WK1, WK2 |
| S_BSART | Purchasing contract types | Range / multiple | EKKO-BSART | No | MK, WK |
| P_RATE | Stamp tax rate (per mille) | Single value | — | Yes | 9,48 |
| P_CAP | Maximum amount per document | Single value | — | No | 23000000 |
| S_HKONT | Stamp tax account | Range / multiple | BSEG-HKONT | No | 360000020 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Contract type | Calculated Sales (VBAK) or purchasing (EKKO) |
| 2 | Contract no. | Calculated VBAK-VBELN or EKKO-EBELN |
| 3 | Contract date | Calculated VBAK-AUDAT or EKKO-BEDAT |
| 4 | Counterparty | Calculated KNA1-NAME1 or LFA1-NAME1 |
| 5 | Contract value | VBAK-NETWR |
| 6 | Currency | VBAK-WAERK |
| 7 | Value (TRY) | Calculated Contract value × rate on the contract date |
| 8 | Calculated stamp tax | Calculated min(Value (TRY) × P_RATE / 1000, P_CAP) × company share |
| 9 | Posted stamp tax | Calculated Σ BSEG-DMBTR on the stamp tax account matched by contract number |
| 10 | Difference | Calculated Calculated − posted |
| 11 | Declaration period | Calculated Year and month of the contract date |
Sample output
| Contract type | Contract no. | Contract date | Counterparty | Contract value | Currency | Value (TRY) | Calculated stamp tax | Posted stamp tax | Difference | Declaration period |
|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 40000815 | 10/03/2026 | Örnek Tekstil A.Ş. | 2,500,000 | TRY | 2,500,000 | 23,700 | 23,700 | 0 | 2026-10 |
| Purchasing | 4600000391 | 10/14/2026 | Anadolu Ambalaj San. Ltd. | 120,000 | EUR | 4,920,000 | 46,641.60 | 0 | 46,641.60 | 2026-10 |
| Sales | 40000822 | 10/28/2026 | Demo Retail Ltd. | 750,000 | TRY | 750,000 | 7,110 | 7,900 | -790 | 2026-10 |
How does the report work?
- Sales contracts are read from VBAK (contract document types by parameter) and purchasing contracts from EKKO (outline agreement types) by document date.
- The contract value comes from the header net value; foreign currency contracts are converted to local currency at the rate on the contract date.
- Stamp tax = value × rate (per mille); if the result exceeds the maximum amount per document, the maximum is used. The company’s share (all or split between the parties) is set by parameter.
- Postings to the stamp tax account are read from BSEG and matched by the contract number in the item text or assignment field.
- Calculated and posted amounts are compared; the difference is shown as a contract without posting or a posting without contract.
- Rows are grouped by declaration period (month of the contract date).
Performance notes
Limit VBAK and EKKO by document type and date range; read the stamp tax account's items once by account and period.
Features
- ALV list (sort, filter, subtotals)
- Export to Excel
- Double-click drill-down to the document From a row you can jump to the contract or the stamp tax posting.
- User-specific layout variants
Authorization objects
- V_VBAK_VKOContract display authorization by sales organization
- M_BEST_EKOContract display authorization by purchasing organization
- F_BKPF_BUKAccounting document display authorization by company code
Frequently asked questions
What about contracts signed outside SAP?
The report covers sales and purchasing contracts in SAP. For contracts that do not exist as documents in SAP, such as lease, service or loan agreements, the same calculation can be done as an extra option with a list uploaded from Excel.
Does the program need a change when the rate or the maximum amount changes?
No. The rate and the maximum amount are entered as parameters on the selection screen; for the yearly update only the variant values are changed.
Related reports
Türkiye Input VAT List Report
A custom ALV report that produces the input VAT list required for Turkish VAT refund files from purchase documents in SAP, one line per invoice. …
VAT by Tax Code vs Tax G/L Account Reconciliation Report
A custom ALV report that totals the period's tax lines by tax code and compares them with the amounts posted to the tax G/L accounts in the same …
Purchasing Contract Utilization and Remaining Balance Report
A custom ALV report that lists, for quantity and value contracts, how much of the target quantity and value has been used by release orders, the …
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.