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.
| Table | Role | Access | System |
|---|---|---|---|
| T012House Banks | House bank that granted the loan | Read | ECC + S/4 |
| T012KHouse Bank Accounts | Bank account and G/L account used for drawdown and payments | Read | ECC + S/4 |
| BNKABank Master Data | Bank name and branch details | Read | ECC + S/4 |
| BSISG/L Account Open Items (Secondary Index) | Loan account items: comparison of plan and G/L balance | Read | ECC + S/4 |
| TCURRExchange Rates | Month-end revaluation rates for foreign currency loans | Read | ECC + S/4 |
| BKPFAccounting Document Header | Drawdown, interest, installment, exchange difference and reclassification documents | Write | 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).
- 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | T012-BUKRS | Yes | 1000 |
| S_HBKID | House bank | Range / multiple | T012-HBKID | No | AKB01 |
| P_BUDAT | Posting date (month end) | Single value | BKPF-BUDAT | Yes | 30.11.2026 |
| R_ACTN | Action: upload plan, monthly run, reclassification or report | Radio button | — | No | Aylık çalıştırma |
| P_FILE | Installment plan file (for upload) | Single value | — | No | C:\temp\kredi_plani.xlsx |
| P_TEST | Test mode | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Loan no. | By rule Key of the loan record; written to the document reference | Yes |
| 2 | Installment no. | By rule Sequence of the installment in the plan | Yes |
| 3 | Due date | By rule Date the installment is paid; becomes the posting date of the payment | Yes |
| 4 | Principal | By rule Principal repaid in this installment; deducted from the loan account | Yes |
| 5 | Interest | By rule Interest paid in this installment; cleared against accrued interest | Yes |
| 6 | Taxes and fees | By rule Taxes and fees paid with the installment; posted to the expense account in the settings table | No |
| 7 | Currency | By rule Loan currency; must match the currency on the loan record | Yes |
Sample upload file
| 1 | Loan no. * | Installment no. * | Due date * | Principal * | Interest * | Taxes and fees | Currency * |
|---|---|---|---|---|---|---|---|
| 2 | KR-2026-07 | 1 | 12/15/2026 | 1,250,000 | 412,500 | 20,625 | TRY |
| 3 | KR-2026-07 | 2 | 03/15/2027 | 1,250,000 | 371,250 | 18,562.50 | TRY |
| 4 | KR-2026-09 | 1 | 01/31/2027 | 0 | 18,750 | 0 | EUR |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Loan no. | Calculated Number in the loan record |
| 2 | Bank | BNKA-BANKA |
| 3 | Currency | T012K-WAERS |
| 4 | Remaining principal | Calculated Drawdown − principal repaid |
| 5 | Interest this month | Calculated Remaining principal × rate × days / day basis |
| 6 | Next installment date | Calculated First unpaid installment in the plan |
| 7 | Current portion | Calculated Principal payable in the next 12 months |
| 8 | G/L difference | Calculated Loan account balance − remaining principal |
| 9 | Status | Calculated Test, posted or error |
Sample result list
| Loan no. | Bank | Currency | Remaining principal | Interest this month | Next installment date | Current portion | G/L difference | Status |
|---|---|---|---|---|---|---|---|---|
| KR-2026-07 | Örnek Katılım Bankası | TRY | 10,000,000 | 337,500 | 12/15/2026 | 5,000,000 | 0 | Posted |
| KR-2026-09 | Demo Bank AG | EUR | 750,000 | 2,500 | 01/31/2027 | 0 | 0 | Posted |
| KR-2025-14 | Örnek Yatırım Bankası | TRY | 1,800,000 | 54,000 | 12/05/2026 | 1,800,000 | -15,000 | Test |
How does the program work?
- 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).
- 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.
- The drawdown is posted with BAPI_ACC_DOCUMENT_POST, debiting the bank and crediting the loan account.
- 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.
- For foreign currency loans, the remaining principal is revalued at the month-end rate (READ_EXCHANGE_RATE) and the exchange difference is posted.
- 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
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 …
Foreign Currency Open Items Exchange Difference Preview Report
A custom ALV report that reads customer and vendor open items by document currency, revalues them at the key-date rate and shows the unrealized …
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 …
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.