# 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 period. Postings made directly to a VAT account without a tax code, and differences between the return and the ledger, are visible before filing.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/vat-tax-code-gl-account-reconciliation-report/


## Why is the standard not enough?

S_ALR_87012357 lists tax lines by tax code but does not compare them with the G/L balance. FS10N shows the tax account balance but does not split it by tax code. Manual postings to a VAT account without a tax code do not appear on the return; this difference is found only by comparing both lists in Excel.

### Closest standard alternatives

- S_ALR_87012357: Lists tax lines by tax code; does not compare them with the G/L balance.
- FS10N: Shows the tax account's period balance; does not split it by tax code.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| BSET | Document tax lines: tax code, base and tax amount (driving table) | Read | - | ECC + S/4 |
| BKPF | Document header: period, document type, reversal data | Read | BKPF-BUKRS = BSET-BUKRS AND BKPF-BELNR = BSET-BELNR AND BKPF-GJAHR = BSET-GJAHR | ECC + S/4 |
| T007A | Tax code type (input / output) | Read | T007A-MWSKZ = BSET-MWSKZ AND T007A-KALSM = vergi prosedürü (T005-KALSM) | ECC + S/4 |
| T005 | Tax calculation procedure of the company code country | Read | T005-LAND1 = T001-LAND1 | ECC + S/4 |
| T001 | Company code country and chart of accounts | Read | T001-BUKRS = BSET-BUKRS | ECC + S/4 |
| T030K | Tax account defined for the tax code | Read | T030K-KTOPL = T001-KTOPL AND T030K-MWSKZ = BSET-MWSKZ AND T030K-KTOSL = BSET-KTOSL | ECC + S/4 |
| BSIS | Postings on the tax accounts (open items index) | Read | BSIS-BUKRS = BSET-BUKRS AND BSIS-HKONT = BSET-HKONT AND BSIS-GJAHR = BSET-GJAHR | ECC + S/4 |
| BSAS | Cleared postings on the tax accounts | Read | BSAS-BUKRS = BSET-BUKRS AND BSAS-HKONT = BSET-HKONT AND BSAS-GJAHR = BSET-GJAHR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BKPF-BUKRS | Yes |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes |
| S_MONAT | Period | Range / multiple | BKPF-MONAT | Yes |
| S_MWSKZ | Tax code | Range / multiple | BSET-MWSKZ | No |
| S_HKONT | Tax account | Range / multiple | BSET-HKONT | No |
| S_BLART | Document type | Range / multiple | BKPF-BLART | No |
| P_DIFF | Show only rows with a difference | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Company code | BSET-BUKRS |
| Period | BKPF-MONAT |
| Tax code | BSET-MWSKZ |
| Tax type | T007A-MWART |
| Tax account | BSET-HKONT |
| Tax base | Calculated: Sum of BSET-HWBAS, signed by SHKZG |
| Tax (BSET) | Calculated: Sum of BSET-HWSTE, signed by SHKZG |
| Effective rate % | Calculated: Tax / base × 100 |
| Amount posted to account | Calculated: Sum of DMBTR on the tax account from BSIS and BSAS in the same period, signed by SHKZG |
| Difference | Calculated: Amount posted to account − tax (BSET) |
| Documents without tax line | Calculated: Number of documents posted to the tax account without a BSET line |

## How does the report work?

1. BKPF headers are read for the selected company code, fiscal year and periods; reversed documents are included or excluded by selection.
2. The documents' tax lines are read from BSET; base (HWBAS) and tax (HWSTE) amounts are signed by SHKZG and totalled by tax code (MWSKZ) and tax account (HKONT).
3. Whether the tax code is input (V) or output (A) tax comes from T007A-MWART, and the expected tax account of the tax code from T030K.
4. All postings to the tax accounts in the same period are read from BSIS and BSAS; documents without a tax line are counted separately.
5. Difference = tax account postings − BSET tax total. Effective rate = tax / base is shown, and tax codes that deviate from the expected rate are flagged.

## Authorization objects

- F_BKPF_BUK: Accounting document authorization by company code
- F_SKA1_BUK: G/L account authorization by company code

## Frequently asked questions

### Does the report replace the VAT return?

No. The report is a pre-filing check. The layout and scope of the return are prepared separately under current regulation; the report only shows whether the ledger and tax lines agree.

### How are partially withheld VAT codes shown?

Withholding VAT codes are also stored as separate BSET lines, so they are compared with their own tax accounts in the same way. Which codes feed which return line is defined in a mapping table during installation.

### How are documents with differences corrected?

They are usually manual postings to a VAT account without a tax code, or documents posted with the wrong tax code. The document is reversed and posted again with the right tax code; running the report again confirms the difference is closed.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=fi-vat-tax-code-gl-reconciliation
