FI Report Custom development ALV report

Unmatched Bank Statement Items on Clearing Accounts Report

Short answer: A custom ALV report that lists electronic or manual bank statement items that were never posted, or were posted to a bank clearing account and are still open, with bank account, statement number and value date. Items are aged by how many days they have been waiting.

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

Why is the standard not enough?

FEBAN shows statement items in a processing screen but does not age them and gives no consolidated list of pending items across bank accounts. FBL3N shows open items on the clearing account but without bank, statement number and external transaction code. For the bank reconciliation statement, the two lists are usually combined in Excel.

Who uses it? Treasury and cash management teams, accounting teams that do bank reconciliation and period-close owners.

Closest standard alternatives

  • FEBAN Bank Statement Postprocessing. Processes statement items; gives no waiting time or cross-account list.
  • FBL3N G/L Account Line Items. Shows open items on the clearing account; does not bring bank and statement data.

Tables used

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

TableRoleJoinSystem
FEBKOElectronic Bank Statement HeadersStatement header: bank, account, statement number and date (driving table)—ECC + S/4
FEBEPElectronic Bank Statement Line ItemsStatement items: value date, amount, transaction code, posting documentFEBEP-KUKEY = FEBKO-KUKEYECC + S/4
T012KHouse Bank AccountsG/L account and currency of the bank accountT012K-BUKRS = FEBKO-BUKRS AND T012K-HBKID = FEBKO-HBKID AND T012K-HKTID = FEBKO-HKTIDECC + S/4
BSISG/L Account Open Items (Secondary Index)Items still open on the clearing accountBSIS-BUKRS = FEBKO-BUKRS AND BSIS-BELNR = FEBEP-BELNRECC + S/4

S/4HANA notes

  • T012K: In S/4HANA reads of T012K go through the compatibility view V_T012K_BAM; bank accounts are maintained in Bank Account Management (BAM).
  • 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.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleFEBKO-BUKRSYes1000
S_HBKIDHouse bankRange / multipleFEBKO-HBKIDNoBNK01
S_HKTIDAccount IDRange / multipleFEBKO-HKTIDNoTRY01
S_AZDATStatement dateRange / multipleFEBKO-AZDATNo01.10.2026–17.11.2026
S_HKONTClearing accountsRange / multipleBSIS-HKONTNo102199
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026
P_NOTPSTOnly items not postedCheckbox—No—

Output columns

#ColumnSource
1Company codeFEBKO-BUKRS
2House bankFEBKO-HBKID
3Account IDFEBKO-HKTID
4Statement no.FEBKO-AZNUM
5Statement dateFEBKO-AZDAT
6ItemFEBEP-ESNUM
7Value dateFEBEP-VALUT
8AmountCalculated FEBEP-KWBTR, negative when EPVOZ indicates an outflow
9CurrencyT012K-WAERS
10External transaction codeFEBEP-VGEXT
11Posting documentFEBEP-BELNR
12Clearing accountBSIS-HKONT
13Days openCalculated Key date − FEBEP-VALUT
14StatusCalculated Not posted when BELNR is empty; open on clearing account when an open BSIS item exists

Sample output

Company codeHouse bankAccount IDStatement no.Statement dateItemValue dateAmountCurrencyExternal transaction codePosting documentClearing accountDays openStatus
1000BNK01TRY010021811/03/20261411/03/202618,750TRYNTRF14Not posted
1000BNK01TRY010022111/06/2026311/06/2026-2,450TRYNCHG100004881210219911Open on clearing account
1000BNK02USD010009710/21/2026710/21/20265,200USDNTRF100004793010229927Open on clearing account
A view built with fictional sample data; not real system data.

How does the report work?

  1. Statement headers for the selected company code, house bank (HBKID), account ID (HKTID) and statement date range are read from FEBKO.
  2. Statement items are taken from FEBEP. Items without a document number (BELNR) are marked “Not posted”.
  3. For posted items whose document went to a clearing account (S_HKONT or clearing accounts derived from T012K-HKONT), BSIS is searched for an open item with the same company code, account and document; if found the status is “Open on clearing account”.
  4. The amount is FEBEP-KWBTR; outflows are shown negative by the direction indicator (EPVOZ). The currency comes from T012K.
  5. Waiting time = key date − value date (VALUT); subtotals are built by bank account and status.

Performance notes

Restrict FEBKO by company code and statement date; the FEBEP read uses the full KUKEY key. The BSIS check runs only for the clearing accounts.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a statement item opens FEBAN; double-clicking the document opens FB03.
  • Export to Excel
  • Runs as a background job Can run every morning after the statement import.
  • Send the result by email

Authorization objects

  • F_FEBB_BUKBank statement authorization by company code
  • F_BKPF_BUKAccounting document authorization by company code

Frequently asked questions

Which accounts count as clearing accounts?

Clearing accounts follow the bank account symbol configuration and differ by company. The report takes them from the selection screen; during installation a default list derived from the bank G/L accounts is prepared.

Does the report post or clear the items?

No, the report only reads. Items are processed in FEBAN or with standard clearing transactions; the report jumps directly to FEBAN.

Does it work on S/4HANA?

Yes. FEBKO and FEBEP are used the same way on S/4HANA; BSIS is read as a compatibility view. If the Fiori bank statement apps are used, the data still comes from the same tables.

Packages that include this solution

FI Package Custom

Month-End Close Control Pack

A pack that lists the five topics to clean up before the close with one company code and period selection: parked documents, unmatched bank items, …

5 components · v1.0

Related reports

FI Report Custom ALV report

Customer Receivables Aging Report

A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …

BSID · BSAD · KNA1 · KNB1

FI Report Custom ALV report

Parked Documents Aging Report

A custom ALV report that lists parked accounting documents that are not yet posted by user, document type and waiting time. Before the period close it …

VBKPF · BKPF · VBSEGS · T001

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: Unmatched Bank Statement Items on Clearing Accounts Report