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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| FEBKOElectronic Bank Statement Headers | Statement header: bank, account, statement number and date (driving table) | — | ECC + S/4 |
| FEBEPElectronic Bank Statement Line Items | Statement items: value date, amount, transaction code, posting document | FEBEP-KUKEY = FEBKO-KUKEY | ECC + S/4 |
| T012KHouse Bank Accounts | G/L account and currency of the bank account | T012K-BUKRS = FEBKO-BUKRS AND T012K-HBKID = FEBKO-HBKID AND T012K-HKTID = FEBKO-HKTID | ECC + S/4 |
| BSISG/L Account Open Items (Secondary Index) | Items still open on the clearing account | BSIS-BUKRS = FEBKO-BUKRS AND BSIS-BELNR = FEBEP-BELNR | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | FEBKO-BUKRS | Yes | 1000 |
| S_HBKID | House bank | Range / multiple | FEBKO-HBKID | No | BNK01 |
| S_HKTID | Account ID | Range / multiple | FEBKO-HKTID | No | TRY01 |
| S_AZDAT | Statement date | Range / multiple | FEBKO-AZDAT | No | 01.10.2026–17.11.2026 |
| S_HKONT | Clearing accounts | Range / multiple | BSIS-HKONT | No | 102199 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_NOTPST | Only items not posted | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | FEBKO-BUKRS |
| 2 | House bank | FEBKO-HBKID |
| 3 | Account ID | FEBKO-HKTID |
| 4 | Statement no. | FEBKO-AZNUM |
| 5 | Statement date | FEBKO-AZDAT |
| 6 | Item | FEBEP-ESNUM |
| 7 | Value date | FEBEP-VALUT |
| 8 | Amount | Calculated FEBEP-KWBTR, negative when EPVOZ indicates an outflow |
| 9 | Currency | T012K-WAERS |
| 10 | External transaction code | FEBEP-VGEXT |
| 11 | Posting document | FEBEP-BELNR |
| 12 | Clearing account | BSIS-HKONT |
| 13 | Days open | Calculated Key date − FEBEP-VALUT |
| 14 | Status | Calculated Not posted when BELNR is empty; open on clearing account when an open BSIS item exists |
Sample output
| Company code | House bank | Account ID | Statement no. | Statement date | Item | Value date | Amount | Currency | External transaction code | Posting document | Clearing account | Days open | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | BNK01 | TRY01 | 00218 | 11/03/2026 | 14 | 11/03/2026 | 18,750 | TRY | NTRF | 14 | Not posted | ||
| 1000 | BNK01 | TRY01 | 00221 | 11/06/2026 | 3 | 11/06/2026 | -2,450 | TRY | NCHG | 1000048812 | 102199 | 11 | Open on clearing account |
| 1000 | BNK02 | USD01 | 00097 | 10/21/2026 | 7 | 10/21/2026 | 5,200 | USD | NTRF | 1000047930 | 102299 | 27 | Open on clearing account |
How does the report work?
- Statement headers for the selected company code, house bank (HBKID), account ID (HKTID) and statement date range are read from FEBKO.
- Statement items are taken from FEBEP. Items without a document number (BELNR) are marked “Not posted”.
- 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”.
- The amount is FEBEP-KWBTR; outflows are shown negative by the direction indicator (EPVOZ). The currency comes from T012K.
- 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
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, …
Related reports
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. …
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 …
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.