FI Program Custom development Background program

Bank Loan Tracking, Interest Accrual and Repayment Schedule Program

Short answer: A custom program that keeps bank loans (amount, currency, interest, maturity and installment plan) in one place and automatically posts the monthly interest accrual, principal and interest payments of installments falling due, the revaluation of foreign currency loans and the current/non-current reclassification. Remaining principal and future payments per loan are visible in one list.

Estimated effort
L · 10–14 working days
System
ECC and S/4HANA
Tables
6
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

The standard offers Treasury and Risk Management or Consumer and Mortgage Loans (CML) for loans; these need separate licensing and setup. Without them, the installment plan sent by the bank is tracked in a spreadsheet, interest accrual is entered by hand with an FBD1 recurring entry or FB50, and the remaining principal is derived from the G/L balance. The custom program brings loan record, plan and posting together inside FI.

Who uses it? Treasury and financing teams, general ledger and finance managers who plan cash flow.

Closest standard alternatives

  • FBD1 Enter Recurring Entry. A recurring entry with a fixed amount can be defined for interest; changing interest, the installment plan and remaining principal are not tracked.
  • FB50 G/L Account Posting (Single Screen). Interest and installment entries are made by hand; amounts are calculated outside SAP.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
T012House BanksHouse bank that granted the loanReadECC + S/4
T012KHouse Bank AccountsBank account and G/L account used for drawdown and paymentsReadECC + S/4
BNKABank Master DataBank name and branch detailsReadECC + S/4
BSISG/L Account Open Items (Secondary Index)Loan account items: comparison of plan and G/L balanceReadECC + S/4
TCURRExchange RatesMonth-end revaluation rates for foreign currency loansReadECC + S/4
BKPFAccounting Document HeaderDrawdown, interest, installment, exchange difference and reclassification documentsWriteECC + 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.

BAPIs and functions used

  • BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Posts the loan entries
  • BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Commits after each document
  • READ_EXCHANGE_RATEDetermine Exchange Rate from Table TCURR. Reads the rate for foreign currency loan revaluation

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueT012-BUKRSYes1000
S_HBKIDHouse bankRange / multipleT012-HBKIDNoAKB01
P_BUDATPosting date (month end)Single valueBKPF-BUDATYes30.11.2026
R_ACTNAction: upload plan, monthly run, reclassification or reportRadio button—NoAylık çalıştırma
P_FILEInstallment plan file (for upload)Single value—NoC:\temp\kredi_plani.xlsx
P_TESTTest modeCheckbox—NoX

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1Loan no.By rule Key of the loan record; written to the document referenceYes
2Installment no.By rule Sequence of the installment in the planYes
3Due dateBy rule Date the installment is paid; becomes the posting date of the paymentYes
4PrincipalBy rule Principal repaid in this installment; deducted from the loan accountYes
5InterestBy rule Interest paid in this installment; cleared against accrued interestYes
6Taxes and feesBy rule Taxes and fees paid with the installment; posted to the expense account in the settings tableNo
7CurrencyBy rule Loan currency; must match the currency on the loan recordYes

Sample upload file

1Loan no. *Installment no. *Due date *Principal *Interest *Taxes and feesCurrency *
2KR-2026-07112/15/20261,250,000412,50020,625TRY
3KR-2026-07203/15/20271,250,000371,25018,562.50TRY
4KR-2026-09101/31/2027018,7500EUR
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1Loan no.Calculated Number in the loan record
2BankBNKA-BANKA
3CurrencyT012K-WAERS
4Remaining principalCalculated Drawdown − principal repaid
5Interest this monthCalculated Remaining principal × rate × days / day basis
6Next installment dateCalculated First unpaid installment in the plan
7Current portionCalculated Principal payable in the next 12 months
8G/L differenceCalculated Loan account balance − remaining principal
9StatusCalculated Test, posted or error

Sample result list

Loan no.BankCurrencyRemaining principalInterest this monthNext installment dateCurrent portionG/L differenceStatus
KR-2026-07Örnek Katılım BankasıTRY10,000,000337,50012/15/20265,000,0000Posted
KR-2026-09Demo Bank AGEUR750,0002,50001/31/202700Posted
KR-2025-14Örnek Yatırım BankasıTRY1,800,00054,00012/05/20261,800,000-15,000Test
A view built with fictional sample data; not real system data.

How does the program work?

  1. A loan is entered on screen: bank (T012 and BNKA), drawdown date, amount, currency, interest rate (fixed or variable), day count basis, maturity, principal account and linked house bank account (T012K).
  2. The installment plan is either calculated by the program as equal installments or a single bullet payment, or uploaded from the bank’s schedule in Excel; plan lines are kept per loan.
  3. The drawdown is posted with BAPI_ACC_DOCUMENT_POST, debiting the bank and crediting the loan account.
  4. The monthly run accrues interest from the last payment date to month end (debit interest expense, credit accrued interest). For an installment that falls due, principal and accrued interest are cleared and a payment is posted to the bank account.
  5. For foreign currency loans, the remaining principal is revalued at the month-end rate (READ_EXCHANGE_RATE) and the exchange difference is posted.
  6. At period end, principal payable in the next 12 months is reclassified to the short-term loan account. The G/L balance of the loan account (BSIS) is compared with the remaining principal in the plan.

Performance notes

Loan counts are usually in the tens; the monthly run finishes in seconds. For variable-rate loans, only that loan's plan is recalculated when a new rate is entered.

Features

  • Export to Excel The bank's installment table is uploaded from Excel.
  • Test mode (check without posting)
  • Runs as a background job Runs automatically in the month-end close schedule.
  • Line-by-line result and error log
  • ALV list (sort, filter, subtotals)

Authorization objects

  • F_BKPF_BUKPosting authorization for the company code
  • F_BKPF_KOAAuthorization to post G/L account items

Frequently asked questions

How are variable-rate loans handled?

The new interest rate is entered on the loan with its effective date. The program calculates interest after that date at the new rate; if the bank sends a new plan, it can be uploaded again from Excel.

Where are taxes and fees charged on a loan posted?

The taxes and fees column in the plan is posted to expense accounts defined in the settings table. Which items are expenses and which are financing costs is set at installation according to accounting policy.

Is it linked to cash flow planning?

Yes. Future installments can be passed to cash flow planning as expected payments, so loan repayments show up in the cash position on their due dates.

Related reports

FI Program Custom Mass upload

Mass G/L Journal Entry Upload from Excel

A custom program that posts multi-line G/L documents (accruals, reclassifications, allocation entries) in bulk from Excel or CSV rows. It checks every …

BKPF · BSEG · SKB1 · CSKS

Let us build this program 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: Bank Loan Tracking, Interest Accrual and Repayment Schedule Program