FI Report Custom development ALV report

Subledger vs Reconciliation Account Balance Check Report (S/4HANA Migration Check)

Short answer: A custom ALV report that totals customer and vendor subledger balances by reconciliation account and compares them with the G/L account balance for the same period. Differing reconciliation accounts, reconciliation accounts changed later and inconsistencies before period close are found before the S/4HANA migration and before month-end.

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

Why is the standard not enough?

FAGLB03 shows the G/L balance, FD10N and FK10N the balance of one customer or vendor; none puts the subledger total next to the reconciliation account. Standard reconciliation programs produce a technical inconsistency list and no business-readable summary per account. Because consistent subledgers and G/L are a prerequisite for the S/4HANA conversion, projects usually run this check early with a custom report.

Who uses it? General ledger and month-end close teams, FI consultants on S/4HANA conversion projects and internal audit.

Closest standard alternatives

  • FAGLB03 Display Balances (New General Ledger). Shows the G/L balance; does not compare it with the subledger total.
  • FD10N Customer Balance Display. Shows one customer's balance; does not total by reconciliation account.

Tables used

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

TableRoleJoinSystem
KNC1Customer Master (Transaction Figures)Customer period totals and balance carried forward (driving table)—ECC + S/4
LFC1Vendor Master (Transaction Figures)Vendor period totals and balance carried forwardLFC1-BUKRS = KNC1-BUKRS AND LFC1-GJAHR = KNC1-GJAHRECC + S/4
KNC3Customer Master (Special G/L Transaction Figures)Customer special G/L totals (subtracted)KNC3-KUNNR = KNC1-KUNNR AND KNC3-BUKRS = KNC1-BUKRS AND KNC3-GJAHR = KNC1-GJAHRECC + S/4
LFC3Vendor Master (Special G/L Transaction Figures)Vendor special G/L totals (subtracted)LFC3-LIFNR = LFC1-LIFNR AND LFC3-BUKRS = LFC1-BUKRS AND LFC3-GJAHR = LFC1-GJAHRECC + S/4
KNB1Customer Master (Company Code)Customer reconciliation accountKNB1-KUNNR = KNC1-KUNNR AND KNB1-BUKRS = KNC1-BUKRSECC + S/4
LFB1Vendor Master (Company Code)Vendor reconciliation accountLFB1-LIFNR = LFC1-LIFNR AND LFB1-BUKRS = LFC1-BUKRSECC + S/4
FAGLFLEXTNew General Ledger: TotalsG/L balance of the reconciliation account (selected ledger)FAGLFLEXT-RBUKRS = KNB1-BUKRS AND FAGLFLEXT-RACCT = KNB1-AKONT AND FAGLFLEXT-RYEAR = KNC1-GJAHRECC + S/4
SKB1G/L Account Master (Company Code)Reconciliation account type of the G/L account (customer/vendor)SKB1-BUKRS = KNB1-BUKRS AND SKB1-SAKNR = KNB1-AKONTECC + S/4
T001Company CodesCompany code currencyT001-BUKRS = KNC1-BUKRSECC + S/4

S/4HANA notes

  • KNC1 → ACDOCA: In S/4HANA KNC1 is a view of the same name; totals are calculated from line items in ACDOCA.
  • LFC1 → ACDOCA: In S/4HANA LFC1 is a view of the same name; totals are calculated from line items in ACDOCA.
  • KNC3 → ACDOCA: In S/4HANA KNC3 is a view of the same name; totals are calculated from line items in ACDOCA.
  • LFC3 → ACDOCA: In S/4HANA LFC3 is a view of the same name; totals are calculated from line items in ACDOCA.
  • FAGLFLEXT → ACDOCA: In S/4HANA totals tables are no longer updated separately; FAGLFLEXT is read as a compatibility view that aggregates ACDOCA line items.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleKNB1-BUKRSYes1000
P_GJAHRFiscal yearSingle valueKNC1-GJAHRYes2026
P_PERIOBalance up to period (inclusive)Single value—Yes10
S_AKONTReconciliation accountRange / multipleKNB1-AKONTNo120000
P_RLDNRLedgerSingle valueFAGLFLEXT-RLDNRNo0L
R_CUSTCustomersRadio button—NoX
R_VENDVendorsRadio button—No—
P_DIFFShow only accounts with a differenceCheckbox—No—

Output columns

#ColumnSource
1Company codeKNB1-BUKRS
2SubledgerCalculated Customer or Vendor by selection
3Reconciliation accountKNB1-AKONT
4Account typeSKB1-MITKZ
5Fiscal yearKNC1-GJAHR
6Number of accountsCalculated Number of customers or vendors assigned to this reconciliation account
7Subledger balanceCalculated KNC1/LFC1: UMSAV + period debits − period credits − KNC3/LFC3 special G/L totals
8G/L balanceCalculated FAGLFLEXT-HSLVT + HSL01…HSLnn up to the selected period
9DifferenceCalculated Subledger balance − G/L balance
10Accounts with changed reconciliation accountCalculated Number of accounts with a KNB1-AKONT/LFB1-AKONT change during the year (from change documents)
11CurrencyT001-WAERS
12StatusCalculated Consistent when the difference is zero, otherwise Difference

Sample output

Company codeSubledgerReconciliation accountAccount typeFiscal yearNumber of accountsSubledger balanceG/L balanceDifferenceAccounts with changed reconciliation accountCurrencyStatus
1000Customer120000D202641248,250,30048,250,30000TRYConsistent
1000Customer120100D2026379,120,0008,985,400134,6002TRYDifference
2000Customer120000D202615615,402,75015,402,75000TRYConsistent
1000Customer121000D202691,250,0001,310,000-60,0001TRYDifference
A view built with fictional sample data; not real system data.

How does the report work?

  1. For the selected company code and fiscal year, customer period totals are read from KNC1 and vendor period totals from LFC1; balance = balance carried forward (UMSAV) + debit totals − credit totals up to the selected period.
  2. Special G/L transactions are read from KNC3 and LFC3 and subtracted, because they are posted to the special G/L account rather than the reconciliation account.
  3. Each customer and vendor is grouped to its reconciliation account through KNB1-AKONT and LFB1-AKONT.
  4. The G/L balance for the same account and period is read from FAGLFLEXT (selected ledger, carry-forward HSLVT + period amounts); the reconciliation account type is confirmed through SKB1-MITKZ.
  5. Difference = subledger balance − G/L balance. Where there is a difference, accounts whose reconciliation account changed during the year are flagged from the change documents, which makes the cause easier to find.

Performance notes

Totals tables are far smaller than line-item tables, so the report runs in seconds. Line-item detail is read only on request for an account with a difference. On S/4HANA, G/L and subledger come from the same ACDOCA rows; the report can also be built on ACDOCA for post-migration validation.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a row with a difference lists the customer or vendor balances on that reconciliation account.
  • Export to Excel
  • Runs as a background job Can run automatically before every month-end close.

Authorization objects

  • F_BKPF_BUKAccounting data authorization by company code
  • F_KNA1_BUKCustomer balance authorization by company code
  • F_LFA1_BUKVendor balance authorization by company code

Frequently asked questions

How does a difference arise?

The most common cause is changing the reconciliation account of a customer or vendor that already has a balance: the old items stay on the old account, while the subledger is grouped to the new one. The report flags these accounts separately.

Does it work on systems with the classic general ledger?

Yes. If the new general ledger is not active, the G/L balance is read from GLT0 instead of FAGLFLEXT; this is set during installation.

When should it run during an S/4HANA migration?

Run it first at the start of the conversion project, then before every trial conversion and right before the final conversion, so differences are fixed well before the cut-over week.

Packages that include this solution

CA Package Custom

S/4HANA Conversion Readiness Pack

A five-component pack that finds the master data and finance inconsistencies to clean up before a system conversion from ECC to S/4HANA: business …

5 components · v1.0

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

FI Report Custom ALV report

Intercompany Open Items Reconciliation Report

A custom ALV report that matches receivable and payable open items between group companies by trading partner and reference number. Before the …

BSID · BSIK · KNA1 · LFA1

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: Subledger vs Reconciliation Account Balance Check Report (S/4HANA Migration Check)