# Unmatched Bank Statement Items on Clearing Accounts Report

> 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.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/unmatched-bank-statement-items-report/


## 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.

### Closest standard alternatives

- FEBAN: Processes statement items; gives no waiting time or cross-account list.
- FBL3N: Shows open items on the clearing account; does not bring bank and statement data.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| FEBKO | Statement header: bank, account, statement number and date (driving table) | Read | - | ECC + S/4 |
| FEBEP | Statement items: value date, amount, transaction code, posting document | Read | FEBEP-KUKEY = FEBKO-KUKEY | ECC + S/4 |
| T012K | G/L account and currency of the bank account | Read | T012K-BUKRS = FEBKO-BUKRS AND T012K-HBKID = FEBKO-HBKID AND T012K-HKTID = FEBKO-HKTID | ECC + S/4 |
| BSIS | Items still open on the clearing account | Read | BSIS-BUKRS = FEBKO-BUKRS AND BSIS-BELNR = FEBEP-BELNR | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | FEBKO-BUKRS | Yes |
| S_HBKID | House bank | Range / multiple | FEBKO-HBKID | No |
| S_HKTID | Account ID | Range / multiple | FEBKO-HKTID | No |
| S_AZDAT | Statement date | Range / multiple | FEBKO-AZDAT | No |
| S_HKONT | Clearing accounts | Range / multiple | BSIS-HKONT | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| P_NOTPST | Only items not posted | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Company code | FEBKO-BUKRS |
| House bank | FEBKO-HBKID |
| Account ID | FEBKO-HKTID |
| Statement no. | FEBKO-AZNUM |
| Statement date | FEBKO-AZDAT |
| Item | FEBEP-ESNUM |
| Value date | FEBEP-VALUT |
| Amount | Calculated: FEBEP-KWBTR, negative when EPVOZ indicates an outflow |
| Currency | T012K-WAERS |
| External transaction code | FEBEP-VGEXT |
| Posting document | FEBEP-BELNR |
| Clearing account | BSIS-HKONT |
| Days open | Calculated: Key date − FEBEP-VALUT |
| Status | Calculated: Not posted when BELNR is empty; open on clearing account when an open BSIS item exists |

## 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.

## Authorization objects

- F_FEBB_BUK: Bank statement authorization by company code
- F_BKPF_BUK: Accounting 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=fi-bank-statement-unmatched-items
