FI Report Custom development ALV report

VAT by Tax Code vs Tax G/L Account Reconciliation Report

Short answer: 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.

Estimated effort
M · 4–6 working days
System
ECC and S/4HANA
Tables
8
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

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.

Who uses it? Tax and general ledger teams, specialists who prepare the VAT return and finance managers working with external tax advisers.

Closest standard alternatives

  • S_ALR_87012357 Advance Return for Tax on Sales/Purchases. Lists tax lines by tax code; does not compare them with the G/L balance.
  • FS10N Balance Display. Shows the tax account's period balance; does not split it by tax code.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
BSETTax Data Document SegmentDocument tax lines: tax code, base and tax amount (driving table)—ECC + S/4
BKPFAccounting Document HeaderDocument header: period, document type, reversal dataBKPF-BUKRS = BSET-BUKRS AND BKPF-BELNR = BSET-BELNR AND BKPF-GJAHR = BSET-GJAHRECC + S/4
T007ATax CodesTax code type (input / output)T007A-MWSKZ = BSET-MWSKZ AND T007A-KALSM = vergi prosedürü (T005-KALSM)ECC + S/4
T005CountriesTax calculation procedure of the company code countryT005-LAND1 = T001-LAND1ECC + S/4
T001Company CodesCompany code country and chart of accountsT001-BUKRS = BSET-BUKRSECC + S/4
T030KTax Account DeterminationTax account defined for the tax codeT030K-KTOPL = T001-KTOPL AND T030K-MWSKZ = BSET-MWSKZ AND T030K-KTOSL = BSET-KTOSLECC + S/4
BSISG/L Account Open Items (Secondary Index)Postings on the tax accounts (open items index)BSIS-BUKRS = BSET-BUKRS AND BSIS-HKONT = BSET-HKONT AND BSIS-GJAHR = BSET-GJAHRECC + S/4
BSASG/L Account Cleared Items (Secondary Index)Cleared postings on the tax accountsBSAS-BUKRS = BSET-BUKRS AND BSAS-HKONT = BSET-HKONT AND BSAS-GJAHR = BSET-GJAHRECC + S/4

S/4HANA notes

  • BSIS → ACDOCA: In S/4HANA BSIS is no longer filled as a separate index table; it is read through a compatibility view of the same name. New developments should use ACDOCA or the related CDS views.
  • BSAS → ACDOCA: In S/4HANA BSAS is not filled as a separate table; it is read through a compatibility view of the same name. New developments should prefer ACDOCA or the related CDS views.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleBKPF-BUKRSYes1000
P_GJAHRFiscal yearSingle valueBKPF-GJAHRYes2026
S_MONATPeriodRange / multipleBKPF-MONATYes10
S_MWSKZTax codeRange / multipleBSET-MWSKZNoV2
S_HKONTTax accountRange / multipleBSET-HKONTNo191000
S_BLARTDocument typeRange / multipleBKPF-BLARTNoKR
P_DIFFShow only rows with a differenceCheckbox—No—

Output columns

#ColumnSource
1Company codeBSET-BUKRS
2PeriodBKPF-MONAT
3Tax codeBSET-MWSKZ
4Tax typeT007A-MWART
5Tax accountBSET-HKONT
6Tax baseCalculated Sum of BSET-HWBAS, signed by SHKZG
7Tax (BSET)Calculated Sum of BSET-HWSTE, signed by SHKZG
8Effective rate %Calculated Tax / base × 100
9Amount posted to accountCalculated Sum of DMBTR on the tax account from BSIS and BSAS in the same period, signed by SHKZG
10DifferenceCalculated Amount posted to account − tax (BSET)
11Documents without tax lineCalculated Number of documents posted to the tax account without a BSET line

Sample output

Company codePeriodTax codeTax typeTax accountTax baseTax (BSET)Effective rate %Amount posted to accountDifferenceDocuments without tax line
100010V2V1910004,250,000850,00020850,00000
100010V1V191000610,00061,0001061,00000
100010A2A391000-7,830,000-1,566,00020-1,578,400-12,4002
100010V2V191010180,00036,0002041,5005,5001
A view built with fictional sample data; not real system data.

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.

Performance notes

Read BSET by the BKPF keys and BSIS/BSAS only for the tax accounts; running per period keeps the volume small. On S/4HANA the tax lines remain in BSET and the G/L side can be read from ACDOCA.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a difference row lists the documents without a tax line; each document opens FB03.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • F_BKPF_BUKAccounting document authorization by company code
  • F_SKA1_BUKG/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.

Packages that include this solution

FI Package Custom

Currency Valuation and VAT Reconciliation Pack

A four-component pack that brings period-end valuation and tax checks together: daily automatic import of central bank exchange rates, an exchange …

4 components · v1.0

Related reports

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.

Related report: VAT by Tax Code vs Tax G/L Account Reconciliation Report