# Daily Bank Balances, Cash Movements and Net Financial Debt Report

> A report that shows the daily balance of every bank account in all company codes by bank, account and currency, from both the bank statement and the ledger; nets it against loan balances to calculate net financial debt in the reporting currency; and summarizes daily cash inflows and outflows by bank transaction type. Managers get an email when balances exceed set limits.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (7–10 working days)
- Last updated: 2026-11-18
- URL: https://nekuhub.com/en/reports/daily-bank-balances-cash-movements-and-net-financial-debt/


## Why is the standard not enough?

FS10N and FAGLB03 show G/L balances account by account; FF_5 and FEBAN import and process bank statements. But there is no standard report that totals the bank balances of all companies on one screen by bank and currency, puts the statement balance next to the ledger balance, nets them against loans, converts them to the reporting currency at one rate and groups movements by bank transaction code. Finance teams build this table in Excel every morning.

### Closest standard alternatives

- FS10N: Shows the balance of one G/L account; no cross-company total or netting against loans.
- FAGLB03: Shows the ledger balance; does not compare it with the statement balance.
- FF_5: Imports the bank statement; does not report balances.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| T012K | Bank accounts: house bank, account ID, G/L account, currency (driving table) | Read | - | ECC + S/4 |
| T012 | House bank and bank key | Read | T012-BUKRS = T012K-BUKRS AND T012-HBKID = T012K-HBKID | ECC + S/4 |
| BNKA | Bank name | Read | BNKA-BANKS = T012-BANKS AND BNKA-BANKL = T012-BANKL | ECC + S/4 |
| FEBKO | Statement header: closing balance | Read | FEBKO-BUKRS = T012K-BUKRS AND FEBKO-HBKID = T012K-HBKID AND FEBKO-HKTID = T012K-HKTID | ECC + S/4 |
| FEBEP | Statement items: amount, transaction code, value date | Read | FEBEP-KUKEY = FEBKO-KUKEY | ECC + S/4 |
| FAGLFLEXT | Ledger balance of bank and loan accounts (ECC new G/L) | Read | FAGLFLEXT-RACCT = T012K-HKONT | ECC only |
| GLT0 | Ledger balance (classic G/L) | Read | GLT0-RACCT = T012K-HKONT | ECC only |
| ACDOCA | Ledger balance (S/4HANA) | Read | ACDOCA-RACCT = T012K-HKONT | S/4HANA only |
| TCURR | Exchange rates for conversion to the reporting currency | Read | - | ECC + S/4 |

## BAPIs and functions used

- READ_EXCHANGE_RATE: Reads the rate on the key date
- CONVERT_TO_LOCAL_CURRENCY: Converts the amount to the reporting currency
- SO_NEW_DOCUMENT_ATT_SEND_API1: Sends the out-of-limit balance summary

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | T012K-BUKRS | Yes |
| P_KEYDT | Key date | Single value | - | Yes |
| S_HBKID | House bank | Range / multiple | T012K-HBKID | No |
| P_RWAER | Reporting currency | Single value | - | Yes |
| P_KURST | Exchange rate type | Single value | TCURR-KURST | Yes |
| P_MOVE | Show cash movements by transaction type | Checkbox | - | No |
| P_MAIL | Email balances outside limits | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Company code | T012K-BUKRS |
| Bank | BNKA-BANKA |
| Account ID | T012K-HKTID |
| Currency | T012K-WAERS |
| Statement balance | FEBKO-ESBTR |
| Ledger balance | Calculated: Balance of the bank G/L account up to the key date |
| Difference | Calculated: Statement balance − ledger balance |
| Daily inflow | Calculated: Sum of FEBEP-KWBTR > 0 (key date) |
| Daily outflow | Calculated: Sum of FEBEP-KWBTR < 0 (key date) |
| Amount in reporting currency | Calculated: Statement balance × rate |
| Net financial debt share | Calculated: Reporting currency amount, + for loan accounts and − for bank accounts |
| Limit status | Calculated: Within limits, below the lower limit or above the upper limit |

## How does the report work?

1. Bank accounts are read from T012K (house bank, account ID, G/L account, currency) and T012/BNKA (bank name). Accounts are grouped during installation into current, time deposit, credit card and so on.
2. The statement balance is taken from the closing balance (FEBKO-ESBTR) of the last statement on or before the key date. The ledger balance is summed up to the key date from FAGLFLEXT (new G/L) or GLT0 in ECC and from ACDOCA in S/4HANA; the difference column shows unprocessed items.
3. Loan balances are read from the ledger balance of the loan G/L accounts (short and long term) defined during installation; if the loan tracking program is used, the remaining principal is taken from there.
4. All amounts are converted to the reporting currency with the chosen rate type (TCURR, READ_EXCHANGE_RATE). Net financial debt = loans − (bank balances + time deposits), per company and for the group.
5. Cash movements are read from FEBEP for the date range and grouped as inflows and outflows by external transaction code (VGEXT): groups such as collections, supplier payments, taxes, salaries, loan repayments and interest are mapped during installation.
6. In the background run, a report summary is emailed to managers with SO_NEW_DOCUMENT_ATT_SEND_API1 for balances outside the lower and upper limits defined per account or company during installation.

## Authorization objects

- F_FEBB_BUK: Bank statement display authorization by company code
- F_BKPF_BUK: Ledger balance display authorization by company code

## Frequently asked questions

### What is shown for a bank whose statement has not arrived yet?

The balance and date of the last statement before the key date are shown; if the statement date is older than the key date, the line is highlighted as a warning.

### Can the definition of net financial debt be adapted to our company?

Yes. Which accounts count as cash equivalents and which as financial debt is defined by the account groups set during installation; lease liabilities or time deposits, for example, can be included or excluded.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=fi-bank-balances-net-financial-debt
