# Türkiye VAT Refund List Preparation Cockpit

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

- Type: Program, Custom development, Interface
- Module: FI
- Estimated effort: L (10–15 working days)
- Localization: TR
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/programs/turkey-vat-refund-list-preparation-cockpit/


## Localization and legal basis: Türkiye

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

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

### Closest standard alternatives

- S_ALR_87012357: Gives return amounts per tax code; there are no lists per refund type and no VAT-incurred calculation.
- FB41: Posts the tax payable; does not prepare the refundable VAT transfer.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBRK | Refund-generating sales invoices (driving table) | Read | - | ECC + S/4 |
| VBRP | Invoice items and delivery value | Read | VBRP-VBELN = VBRK-VBELN | ECC + S/4 |
| KNA1 | Buyer name and country | Read | KNA1-KUNNR = VBRK-KUNAG | ECC + S/4 |
| BKPF | Purchase documents and the refundable VAT transfer posting | Read / write | - | ECC + S/4 |
| BSET | Input VAT base and amount | Read | BSET-BUKRS = BKPF-BUKRS AND BSET-BELNR = BKPF-BELNR AND BSET-GJAHR = BKPF-GJAHR | ECC + S/4 |
| LFA1 | Vendor name and tax number | Read | LFA1-LIFNR = BSEG-LIFNR | ECC + S/4 |
| STXH | Customs declaration number and date on the invoice | Read | STXH-TDOBJECT = 'VBBK' AND STXH-TDNAME = VBRK-VBELN | ECC + S/4 |

## BAPIs and functions used

- READ_TEXT: Reads the customs declaration details from the invoice text
- BAPI_ACC_DOCUMENT_POST: Transfers the refundable VAT amount to the relevant account

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_BUKRS | Company code | Single value | BKPF-BUKRS | Yes |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes |
| P_MONAT | Period | Single value | BKPF-MONAT | Yes |
| P_RTYPE | Refund type (transaction code) | Single value | - | Yes |
| S_MWSKZ | Exemption and reduced-rate tax codes | Range / multiple | BSET-MWSKZ | No |
| P_TEST | Test mode (without files or postings) | Checkbox | - | No |

## Result list columns

| Column | Source |
|---|---|
| List | Calculated: Sales invoices, input VAT or VAT incurred |
| Document | Calculated: VBRK-VBELN for sales, BKPF-BELNR for purchases |
| Invoice date | BKPF-BLDAT |
| Invoice series and number | BKPF-XBLNR |
| Counterparty | Calculated: KNA1-NAME1 for sales, LFA1-NAME1 for purchases |
| Base / delivery value | BSET-HWBAS |
| VAT | BSET-HWSTE |
| Customs declaration | Calculated: Declaration number and date from the invoice text |
| Status | Calculated: Listed, missing data, changed after approved version |

## How does the program work?

1. 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.
2. Sales invoice list: built with invoice date, series and number, buyer, delivery value and customs declaration details; buyer data comes from KNA1.
3. Input VAT list: purchase documents of the period come from BKPF and BSET, vendor name and tax number from LFA1.
4. 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).
5. 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.
6. 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.

## Authorization objects

- F_BKPF_BUK: Display and posting authorization by company code
- V_VBRK_FKA: Billing 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.

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