G/L Line Items with Offsetting Account and Business Partner Report
Short answer: 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 account, the customer or vendor and the trading partner to every row. It produces one file for auditor and tax advisor requests.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
FBL3N and FAGLL03 list G/L line items, but the offsetting account and the customer/vendor name from the same document are not on the row; even with extra fields only the partner on that line is filled. A running balance and separate debit/credit columns are not part of the standard layout either. For the classic ledger format auditors ask for, the data is matched document by document in Excel.
Who uses it? General ledger teams, internal and external auditors, tax advisors.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| BKPFAccounting Document Header | Document header: posting date, document type, reference (driving table) | — | ECC + S/4 |
| BSEGAccounting Document Segment | Document lines: account, amount, partner, cost center, trading partner | BSEG-BUKRS = BKPF-BUKRS AND BSEG-BELNR = BKPF-BELNR AND BSEG-GJAHR = BKPF-GJAHR | ECC + S/4 |
| SKATG/L Account Descriptions | G/L and offsetting account names | SKAT-KTOPL = T001-KTOPL AND SKAT-SAKNR = BSEG-HKONT AND SKAT-SPRAS = SY-LANGU | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = BSEG-KUNNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = BSEG-LIFNR | ECC + S/4 |
| T001Company Codes | Chart of accounts and company code currency | T001-BUKRS = BKPF-BUKRS | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | All line items including the offsetting account (GKONT) on S/4HANA | RBUKRS = BKPF-BUKRS AND BELNR = BKPF-BELNR AND GJAHR = BKPF-GJAHR | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BKPF-BUKRS | Yes | 1000 |
| S_HKONT | G/L account | Range / multiple | BSEG-HKONT | Yes | 7700000000 |
| S_BUDAT | Posting date | Range / multiple | BKPF-BUDAT | Yes | 01.10.2026 – 31.10.2026 |
| S_BLART | Document type | Range / multiple | BKPF-BLART | No | KR |
| S_KOSTL | Cost center | Range / multiple | BSEG-KOSTL | No | 4110 |
| S_PRCTR | Profit center | Range / multiple | BSEG-PRCTR | No | PC100 |
| P_OPEN | Show opening and running balance | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | G/L account | BSEG-HKONT |
| 2 | Account name | SKAT-TXT50 |
| 3 | Posting date | BKPF-BUDAT |
| 4 | Document | BKPF-BELNR |
| 5 | Document type | BKPF-BLART |
| 6 | Reference | BKPF-XBLNR |
| 7 | Text | BSEG-SGTXT |
| 8 | Debit | Calculated BSEG-DMBTR when SHKZG = S |
| 9 | Credit | Calculated BSEG-DMBTR when SHKZG = H |
| 10 | Running balance | Calculated Opening balance + debit − credit (cumulative per account) |
| 11 | Offsetting account | Calculated BSEG-HKONT of the opposite-side line in the same document (largest amount when several) |
| 12 | Offsetting account name | Calculated SKAT-TXT50 text of the offsetting account |
| 13 | Partner | Calculated BSEG-KUNNR or BSEG-LIFNR from the line or from the document's D/K line |
| 14 | Partner name | Calculated KNA1-NAME1 or LFA1-NAME1 |
| 15 | Trading partner | BSEG-VBUND |
| 16 | Cost center | BSEG-KOSTL |
Sample output
| G/L account | Account name | Posting date | Document | Document type | Reference | Text | Debit | Credit | Running balance | Offsetting account | Offsetting account name | Partner | Partner name | Trading partner | Cost center |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7700000000 | General administrative expenses | 10/03/2026 | 5100004610 | KR | KS-2026-118 | October office rent | 85,000 | 0 | 85,000 | 3200000000 | Trade payables | 100901 | Kuzey Gayrimenkul | 9100 | |
| 7700000000 | General administrative expenses | 10/08/2026 | 5100004702 | KR | TL-88412 | Cleaning service | 12,400 | 0 | 97,400 | 3200000000 | Trade payables | 100915 | Pırıl Tesis Hizmetleri | 9100 | |
| 7700000000 | General administrative expenses | 10/15/2026 | 1000012233 | SA | Group company service fee | 40,000 | 0 | 137,400 | 3360000000 | Payables to group companies | 2000 | 9200 | |||
| 7700000000 | General administrative expenses | 10/31/2026 | 1000012410 | SA | Reversal of excess accrual | 0 | 6,500 | 130,900 | Multiple | 9100 |
How does the report work?
- Document headers are read from BKPF by company code, posting date range and document type; reversals and parked documents are excluded.
- The BSEG lines of the documents are read; lines within the S_HKONT range become report rows.
- Partner: when KUNNR/LIFNR is filled on the line it is used; otherwise it is taken from the customer (KOART = D) or vendor (KOART = K) line of the same document. The name is added from KNA1/LFA1.
- Offsetting account: in a two-line document, the account of the other line; in a multi-line document, the account of the largest line on the opposite side, flagged as “multiple” when there are several. The account name is read from SKAT (with T001-KTOPL).
- The amount goes to the debit or credit column by SHKZG; the opening balance comes from the totals before the period and a running balance is calculated per account.
Performance notes
In ECC, BSEG is a cluster table; read BKPF first by date and company code, then go to BSEG with the full document key. For open-item managed accounts the BSIS/BSAS index tables are a faster entry point. On S/4HANA ACDOCA already holds the offsetting account (GKONT) and its type, so the read collapses to one table.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the document number opens FB03.
- Export to Excel
- Runs as a background job Large volumes such as the annual audit file are run in the background.
Authorization objects
- F_BKPF_BUKAccounting document display authorization by company code
- F_SKA1_BUKG/L account authorization by company code
- F_BKPF_KOADocument authorization by account type (customer/vendor lines)
Frequently asked questions
How is the offsetting account determined in multi-line documents?
The account of the largest opposite-side line is used, and the row is flagged as "multiple" when there are several. Optionally, a view that produces one row per offsetting line can be added.
Where does the opening balance come from?
It is taken from the account totals before the period (FAGLFLEXT in the new G/L), so the running balance agrees with the G/L account balance.
Is it still needed on S/4HANA?
On S/4HANA the offsetting account is already in ACDOCA and the report is simpler to build; for the running balance, partner names and the audit layout a custom list is still preferred.
Related reports
Fixed Asset Register with Book and Tax Depreciation Report
A custom ALV report that shows every fixed asset on one row with acquisition cost, accumulated depreciation, depreciation of the year and net book …
Customer–Vendor Netting Open Items Report
A custom ALV report that puts open receivables and payables side by side for business partners that exist both as a customer and as a vendor, and …
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.