Daily Bank Balances, Cash Movements and Net Financial Debt Report
Short answer: 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.
- Estimated effort
- M · 7–10 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Finance and treasury managers, the CFO office, cash management and bank reconciliation teams.
Closest standard alternatives
- FS10N Balance Display. Shows the balance of one G/L account; no cross-company total or netting against loans.
- FAGLB03 Display Balances (New General Ledger). Shows the ledger balance; does not compare it with the statement balance.
- FF_5 Import Electronic Bank Statement. Imports the bank statement; does not report balances.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| T012KHouse Bank Accounts | Bank accounts: house bank, account ID, G/L account, currency (driving table) | — | ECC + S/4 |
| T012House Banks | House bank and bank key | T012-BUKRS = T012K-BUKRS AND T012-HBKID = T012K-HBKID | ECC + S/4 |
| BNKABank Master Data | Bank name | BNKA-BANKS = T012-BANKS AND BNKA-BANKL = T012-BANKL | ECC + S/4 |
| FEBKOElectronic Bank Statement Headers | Statement header: closing balance | FEBKO-BUKRS = T012K-BUKRS AND FEBKO-HBKID = T012K-HBKID AND FEBKO-HKTID = T012K-HKTID | ECC + S/4 |
| FEBEPElectronic Bank Statement Line Items | Statement items: amount, transaction code, value date | FEBEP-KUKEY = FEBKO-KUKEY | ECC + S/4 |
| FAGLFLEXTNew General Ledger: Totals | Ledger balance of bank and loan accounts (ECC new G/L) | FAGLFLEXT-RACCT = T012K-HKONT | ECC only |
| GLT0G/L Account Transaction Figures | Ledger balance (classic G/L) | GLT0-RACCT = T012K-HKONT | ECC only |
| ACDOCAUniversal Journal Entry Line Items | Ledger balance (S/4HANA) | ACDOCA-RACCT = T012K-HKONT | S/4HANA only |
| TCURRExchange Rates | Exchange rates for conversion to the reporting currency | — | 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).
- FAGLFLEXT → ACDOCA: In S/4HANA totals tables are no longer updated separately; FAGLFLEXT is read as a compatibility view that aggregates ACDOCA line items.
- GLT0 → ACDOCA: In S/4HANA GLT0 is not updated; reads go through a compatibility view that aggregates ACDOCA line items.
BAPIs and functions used
- READ_EXCHANGE_RATEDetermine Exchange Rate from Table TCURR. Reads the rate on the key date
- CONVERT_TO_LOCAL_CURRENCYTranslate Foreign Currency Amount to Local Currency. Converts the amount to the reporting currency
- SO_NEW_DOCUMENT_ATT_SEND_API1SAPoffice: Send New Document with Attachments. Sends the out-of-limit balance summary
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | T012K-BUKRS | Yes | 1000–5000 |
| P_KEYDT | Key date | Single value | — | Yes | 27.11.2026 |
| S_HBKID | House bank | Range / multiple | T012K-HBKID | No | — |
| P_RWAER | Reporting currency | Single value | — | Yes | TRY |
| P_KURST | Exchange rate type | Single value | TCURR-KURST | Yes | M |
| P_MOVE | Show cash movements by transaction type | Checkbox | — | No | X |
| P_MAIL | Email balances outside limits | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | T012K-BUKRS |
| 2 | Bank | BNKA-BANKA |
| 3 | Account ID | T012K-HKTID |
| 4 | Currency | T012K-WAERS |
| 5 | Statement balance | FEBKO-ESBTR |
| 6 | Ledger balance | Calculated Balance of the bank G/L account up to the key date |
| 7 | Difference | Calculated Statement balance − ledger balance |
| 8 | Daily inflow | Calculated Sum of FEBEP-KWBTR > 0 (key date) |
| 9 | Daily outflow | Calculated Sum of FEBEP-KWBTR < 0 (key date) |
| 10 | Amount in reporting currency | Calculated Statement balance × rate |
| 11 | Net financial debt share | Calculated Reporting currency amount, + for loan accounts and − for bank accounts |
| 12 | Limit status | Calculated Within limits, below the lower limit or above the upper limit |
Sample output
| Company code | Bank | Account ID | Currency | Statement balance | Ledger balance | Difference | Daily inflow | Daily outflow | Amount in reporting currency | Net financial debt share | Limit status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | Demo Bank A.Ş. | TRY01 | TRY | 18,450,000 | 18,312,500 | 137,500 | 4,250,000 | -3,110,000 | 18,450,000 | -18,450,000 | Within limits |
| 1000 | Örnek Katılım Bankası | USD01 | USD | 1,250,000 | 1,250,000 | 0 | 300,000 | -85,000 | 43,125,000 | -43,125,000 | Above the upper limit |
| 2000 | Demo Bank A.Ş. | KRD01 | TRY | -60,000,000 | -60,000,000 | 0 | 0 | -2,500,000 | -60,000,000 | 60,000,000 | Loan account |
How does the report work?
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Performance notes
Read ledger balances from the totals tables (FAGLFLEXT, GLT0) or, in S/4HANA, with one aggregating SELECT on ACDOCA, not from line item tables. Take only the last statement per account from FEBKO; limit FEBEP to the date range.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Drill down from a balance to statement items and ledger items.
- Export to Excel
- Send the result by email Out-of-limit balances and the net financial debt summary are sent to managers.
- Runs as a background job Runs automatically every morning after bank statements are imported.
Authorization objects
- F_FEBB_BUKBank statement display authorization by company code
- F_BKPF_BUKLedger 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.
Related reports
Bank Loan Tracking, Interest Accrual and Repayment Schedule Program
A custom program that keeps bank loans (amount, currency, interest, maturity and installment plan) in one place and automatically posts the monthly …
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 …
Cash Flow Planning Entry and Weekly Cash Flow Table Program
A custom program that enters expected receipts and payments with no accounting document yet (taxes, salaries, loan installments, capital expenditure, …
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.