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.
| Table | Role | Join | System |
|---|---|---|---|
| BSETTax Data Document Segment | Document tax lines: tax code, base and tax amount (driving table) | — | ECC + S/4 |
| BKPFAccounting Document Header | Document header: period, document type, reversal data | BKPF-BUKRS = BSET-BUKRS AND BKPF-BELNR = BSET-BELNR AND BKPF-GJAHR = BSET-GJAHR | ECC + S/4 |
| T007ATax Codes | Tax code type (input / output) | T007A-MWSKZ = BSET-MWSKZ AND T007A-KALSM = vergi prosedürü (T005-KALSM) | ECC + S/4 |
| T005Countries | Tax calculation procedure of the company code country | T005-LAND1 = T001-LAND1 | ECC + S/4 |
| T001Company Codes | Company code country and chart of accounts | T001-BUKRS = BSET-BUKRS | ECC + S/4 |
| T030KTax Account Determination | Tax account defined for the tax code | T030K-KTOPL = T001-KTOPL AND T030K-MWSKZ = BSET-MWSKZ AND T030K-KTOSL = BSET-KTOSL | ECC + 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-GJAHR | ECC + S/4 |
| BSASG/L Account Cleared Items (Secondary Index) | Cleared postings on the tax accounts | BSAS-BUKRS = BSET-BUKRS AND BSAS-HKONT = BSET-HKONT AND BSAS-GJAHR = BSET-GJAHR | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BKPF-BUKRS | Yes | 1000 |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes | 2026 |
| S_MONAT | Period | Range / multiple | BKPF-MONAT | Yes | 10 |
| S_MWSKZ | Tax code | Range / multiple | BSET-MWSKZ | No | V2 |
| S_HKONT | Tax account | Range / multiple | BSET-HKONT | No | 191000 |
| S_BLART | Document type | Range / multiple | BKPF-BLART | No | KR |
| P_DIFF | Show only rows with a difference | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | BSET-BUKRS |
| 2 | Period | BKPF-MONAT |
| 3 | Tax code | BSET-MWSKZ |
| 4 | Tax type | T007A-MWART |
| 5 | Tax account | BSET-HKONT |
| 6 | Tax base | Calculated Sum of BSET-HWBAS, signed by SHKZG |
| 7 | Tax (BSET) | Calculated Sum of BSET-HWSTE, signed by SHKZG |
| 8 | Effective rate % | Calculated Tax / base × 100 |
| 9 | Amount posted to account | Calculated Sum of DMBTR on the tax account from BSIS and BSAS in the same period, signed by SHKZG |
| 10 | Difference | Calculated Amount posted to account − tax (BSET) |
| 11 | Documents without tax line | Calculated Number of documents posted to the tax account without a BSET line |
Sample output
| Company code | Period | Tax code | Tax type | Tax account | Tax base | Tax (BSET) | Effective rate % | Amount posted to account | Difference | Documents without tax line |
|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 10 | V2 | V | 191000 | 4,250,000 | 850,000 | 20 | 850,000 | 0 | 0 |
| 1000 | 10 | V1 | V | 191000 | 610,000 | 61,000 | 10 | 61,000 | 0 | 0 |
| 1000 | 10 | A2 | A | 391000 | -7,830,000 | -1,566,000 | 20 | -1,578,400 | -12,400 | 2 |
| 1000 | 10 | V2 | V | 191010 | 180,000 | 36,000 | 20 | 41,500 | 5,500 | 1 |
How does the report work?
- BKPF headers are read for the selected company code, fiscal year and periods; reversed documents are included or excluded by selection.
- 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).
- 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.
- All postings to the tax accounts in the same period are read from BSIS and BSAS; documents without a tax line are counted separately.
- 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
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 …
Related reports
G/L Line Items with Offsetting Account and Business Partner Report
A custom ALV general ledger report that lists the line items of selected G/L accounts with debit, credit and running balance, and adds the offsetting …
Subledger vs Reconciliation Account Balance Check Report (S/4HANA Migration Check)
A custom ALV report that totals customer and vendor subledger balances by reconciliation account and compares them with the G/L account balance for …
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.