Türkiye VAT Refund List Preparation Cockpit
Short answer: A custom cockpit that prepares the sales invoice list, the input VAT list and the calculation of VAT incurred together for one period and refund type, for refund-generating transactions such as export exemption and reduced-rate sales. The lists are produced as files in the GİB upload template, the approved list version is frozen and the refundable VAT amount is transferred to the relevant account.
- Estimated effort
- L · 10–15 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
S_ALR_87012357 gives return amounts per tax code; it does not produce the sales invoice list per refund type, customs declaration details or the VAT-incurred calculation. FB41 posts the tax payable but does not prepare the transfer of refundable VAT. An input VAT list report only covers the purchase side. The cockpit prepares all lists of the refund file from the same data and version.
Who uses it? Tax and accounting teams, finance teams preparing VAT refunds, certified public accountants and sworn-in auditors.
Closest standard alternatives
- S_ALR_87012357 Advance Return for Tax on Sales/Purchases. Gives return amounts per tax code; there are no lists per refund type and no VAT-incurred calculation.
- FB41 Post Tax Payable. Posts the tax payable; does not prepare the refundable VAT transfer.
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: Articles 11, 29 and 32 of Value Added Tax Law No. 3065 and the refund provisions of the VAT General Application Communiqué.
List formats are checked against the current upload templates of the GİB Internet Tax Office during installation; the refund claim itself is filed through GİB.
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| VBRKBilling Document Header | Refund-generating sales invoices (driving table) | Read | ECC + S/4 |
| VBRPBilling Document: Item Data | Invoice items and delivery value | Read | ECC + S/4 |
| KNA1Customer Master (General Section) | Buyer name and country | Read | ECC + S/4 |
| BKPFAccounting Document Header | Purchase documents and the refundable VAT transfer posting | Read / write | ECC + S/4 |
| BSETTax Data Document Segment | Input VAT base and amount | Read | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name and tax number | Read | ECC + S/4 |
| STXHSAPscript Text Header | Customs declaration number and date on the invoice | Read | ECC + S/4 |
BAPIs and functions used
- READ_TEXTRead Long Text. Reads the customs declaration details from the invoice text
- BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Transfers the refundable VAT amount to the relevant account
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | BKPF-BUKRS | Yes | 1000 |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes | 2026 |
| P_MONAT | Period | Single value | BKPF-MONAT | Yes | 10 |
| P_RTYPE | Refund type (transaction code) | Single value | — | Yes | 301 |
| S_MWSKZ | Exemption and reduced-rate tax codes | Range / multiple | BSET-MWSKZ | No | A0, A1 |
| P_TEST | Test mode (without files or postings) | Checkbox | — | No | X |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | List | Calculated Sales invoices, input VAT or VAT incurred |
| 2 | Document | Calculated VBRK-VBELN for sales, BKPF-BELNR for purchases |
| 3 | Invoice date | BKPF-BLDAT |
| 4 | Invoice series and number | BKPF-XBLNR |
| 5 | Counterparty | Calculated KNA1-NAME1 for sales, LFA1-NAME1 for purchases |
| 6 | Base / delivery value | BSET-HWBAS |
| 7 | VAT | BSET-HWSTE |
| 8 | Customs declaration | Calculated Declaration number and date from the invoice text |
| 9 | Status | Calculated Listed, missing data, changed after approved version |
Sample result list
| List | Document | Invoice date | Invoice series and number | Counterparty | Base / delivery value | VAT | Customs declaration | Status |
|---|---|---|---|---|---|---|---|---|
| Sales invoices | 90031377 | 10/09/2026 | ABC2026000004812 | Demo Retail GmbH | 1,450,000 | 0 | 26341300EX001284 / 2026-10-10 | Listed |
| Input VAT | 5100004318 | 10/07/2026 | ANB2026000001207 | Anadolu Ambalaj San. Ltd. | 46,200 | 9,240 | Listed | |
| Sales invoices | 90031415 | 10/21/2026 | ABC2026000004890 | Nordic Home AB | 620,000 | 0 | Missing data |
How does the program work?
- Refund-generating sales invoices are read from VBRK and VBRP for the selected company code, period and refund type (e.g. 301 export of goods); tax code and billing type are limited by parameter. The customs declaration number and date come from the invoice text or foreign trade data.
- Sales invoice list: built with invoice date, series and number, buyer, delivery value and customs declaration details; buyer data comes from KNA1.
- Input VAT list: purchase documents of the period come from BKPF and BSET, vendor name and tax number from LFA1.
- VAT incurred: VAT attributable to refund-generating transactions is calculated directly and with an allocation key; refundable amount = min(VAT incurred, delivery value × standard rate).
- Lists are produced as files in the GİB upload template; when the user approves, the list version is frozen and later changes are shown as differences.
- The refundable VAT amount is transferred from the input VAT account to the refundable VAT account with BAPI_ACC_DOCUMENT_POST; nothing is posted in test mode.
Performance notes
Read VBRK by company code, billing date and billing type, and BSET by company code, fiscal year and tax code. Prepare yearly or multi-period refund files in the background.
Features
- Test mode (check without posting)
- ALV list (sort, filter, subtotals)
- Export to Excel Lists are produced in the GİB upload template and as Excel.
- Double-click drill-down to the document From a row you can jump to the invoice or the purchase document.
- Line-by-line result and error log
Authorization objects
- F_BKPF_BUKDisplay and posting authorization by company code
- V_VBRK_FKABilling display authorization by billing type
Frequently asked questions
How does it differ from the Input VAT List Report?
The Input VAT List Report gives only the purchase-side list. The cockpit also prepares the sales invoice list, the VAT-incurred calculation and the transfer posting for the same period and refund type, and freezes the approved version; the whole refund file is managed in one place.
What happens if a document changes after approval?
The approved version does not change. In the next run, changed, added or removed documents are shown as differences; if needed a new version is created and listed separately for the amended return.
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 …
Billing Documents Not Posted to Accounting Report
A custom ALV report that lists billing documents which exist in SD but have no accounting document yet, with the reason code, age and amount. At …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.