FI Report Custom development ALV report

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.

TableRoleJoinSystem
T012KHouse Bank AccountsBank accounts: house bank, account ID, G/L account, currency (driving table)—ECC + S/4
T012House BanksHouse bank and bank keyT012-BUKRS = T012K-BUKRS AND T012-HBKID = T012K-HBKIDECC + S/4
BNKABank Master DataBank nameBNKA-BANKS = T012-BANKS AND BNKA-BANKL = T012-BANKLECC + S/4
FEBKOElectronic Bank Statement HeadersStatement header: closing balanceFEBKO-BUKRS = T012K-BUKRS AND FEBKO-HBKID = T012K-HBKID AND FEBKO-HKTID = T012K-HKTIDECC + S/4
FEBEPElectronic Bank Statement Line ItemsStatement items: amount, transaction code, value dateFEBEP-KUKEY = FEBKO-KUKEYECC + S/4
FAGLFLEXTNew General Ledger: TotalsLedger balance of bank and loan accounts (ECC new G/L)FAGLFLEXT-RACCT = T012K-HKONTECC only
GLT0G/L Account Transaction FiguresLedger balance (classic G/L)GLT0-RACCT = T012K-HKONTECC only
ACDOCAUniversal Journal Entry Line ItemsLedger balance (S/4HANA)ACDOCA-RACCT = T012K-HKONTS/4HANA only
TCURRExchange RatesExchange 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

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleT012K-BUKRSYes1000–5000
P_KEYDTKey dateSingle value—Yes27.11.2026
S_HBKIDHouse bankRange / multipleT012K-HBKIDNo—
P_RWAERReporting currencySingle value—YesTRY
P_KURSTExchange rate typeSingle valueTCURR-KURSTYesM
P_MOVEShow cash movements by transaction typeCheckbox—NoX
P_MAILEmail balances outside limitsCheckbox—No—

Output columns

#ColumnSource
1Company codeT012K-BUKRS
2BankBNKA-BANKA
3Account IDT012K-HKTID
4CurrencyT012K-WAERS
5Statement balanceFEBKO-ESBTR
6Ledger balanceCalculated Balance of the bank G/L account up to the key date
7DifferenceCalculated Statement balance − ledger balance
8Daily inflowCalculated Sum of FEBEP-KWBTR > 0 (key date)
9Daily outflowCalculated Sum of FEBEP-KWBTR < 0 (key date)
10Amount in reporting currencyCalculated Statement balance × rate
11Net financial debt shareCalculated Reporting currency amount, + for loan accounts and − for bank accounts
12Limit statusCalculated Within limits, below the lower limit or above the upper limit

Sample output

Company codeBankAccount IDCurrencyStatement balanceLedger balanceDifferenceDaily inflowDaily outflowAmount in reporting currencyNet financial debt shareLimit status
1000Demo Bank A.Ş.TRY01TRY18,450,00018,312,500137,5004,250,000-3,110,00018,450,000-18,450,000Within limits
1000Örnek Katılım BankasıUSD01USD1,250,0001,250,0000300,000-85,00043,125,000-43,125,000Above the upper limit
2000Demo Bank A.Ş.KRD01TRY-60,000,000-60,000,00000-2,500,000-60,000,00060,000,000Loan account
A view built with fictional sample data; not real system data.

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.

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

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: Daily Bank Balances, Cash Movements and Net Financial Debt Report