FI Program Custom development Background program

Lease Contracts and IFRS 16 Lease Accounting Program

Short answer: A custom program that keeps lease contracts (term, payment schedule, annual increase and discount rate) in one place, calculates and posts the lease liability and right-of-use asset at commencement, and posts interest accrual, lease payment and current/non-current split entries every month. When a contract changes, the liability is remeasured.

Estimated effort
L · 14–20 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 RE-FX (RECN) or separately licensed contract management solutions for IFRS 16; when these are not in place, lease contracts are tracked in spreadsheets, present value and interest tables are calculated by hand and entries are made every month with FB50. AS01 creates the right-of-use asset but does not calculate its amount; liability, interest and reclassification stay entirely outside SAP. The custom program brings contract, calculation and posting together in one flow.

Who uses it? General ledger teams reporting under IFRS, fixed asset teams, facilities teams tracking lease contracts and audit teams.

Closest standard alternatives

  • AS01 Create Asset Master Record. Creates the right-of-use asset by hand; no present value, interest or liability calculation.
  • FBD1 Enter Recurring Entry. A recurring entry with a fixed amount can be defined; it does not fit because the interest amount changes every month.

Tables used

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

TableRoleAccessSystem
ANLAAsset Master RecordRight-of-use asset master: asset class and capitalization dateWriteECC + S/4
ANLZTime-Dependent Asset AllocationsTime-dependent asset assignment: cost center and business areaWriteECC + S/4
ANLCAsset Value FieldsAccumulated depreciation and net book value of the assetReadECC + S/4
LFA1Vendor Master (General Section)Lessor vendorReadECC + S/4
TCURRExchange RatesPeriod-end rates for foreign currency leasesReadECC + S/4
BSIKVendor Open ItemsOpen or paid check of the vendor payables created for rentReadECC + S/4

S/4HANA notes

  • ANLC → ACDOCA: In S/4HANA new asset accounting the actual values are kept in ACDOCA; ANLC is only read through the compatibility view FAAV_ANLC.
  • BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.

BAPIs and functions used

  • BAPI_FIXEDASSET_CREATE1Create Fixed Asset. Creates the right-of-use asset
  • BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Posts commencement, interest, rent and reclassification entries
  • BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Commits each contract's postings
  • READ_EXCHANGE_RATEDetermine Exchange Rate from Table TCURR. Reads the rate for foreign currency contracts

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueANLA-BUKRSYes1000
P_BUDATPosting date (period end)Single valueBKPF-BUDATYes30.11.2026
R_ACTNAction: upload contracts, commencement, monthly run or remeasurementRadio button—NoAylık çalıştırma
P_FILEContract file (for upload)Single value—NoC:\temp\kira_sozlesmeleri.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
1Contract no.By rule Key of the contract record; written to the asset description and the document referenceYes
2LessorLFA1-LIFNRYes
3Start dateBy rule Lease commencement date; becomes the asset capitalization dateYes
4End dateBy rule End date; the contract term is used as useful lifeYes
5Monthly rentBy rule Rent amount for the first year of the payment scheduleYes
6CurrencyBy rule Contract currency; a foreign currency liability is revalued at the month-end rateYes
7Annual increase (%)By rule Increase applied to the rent at the start of each contract yearNo
8Discount rate (%)By rule Annual rate used for present value and effective interestYes
9Asset classANLA-ANLKLYes

Sample upload file

1Contract no. *Lessor *Start date *End date *Monthly rent *Currency *Annual increase (%)Discount rate (%) *Asset class *
2KS-001220071101/01/202612/31/203085,000TRY25386100
3KS-001320074503/01/202602/28/20294,200EUR37.506100
4KS-001420080306/01/202605/31/202712,000TRY0406200
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1Contract no.Calculated Number in the contract record
2LessorLFA1-NAME1
3Right-of-use assetANLA-ANLN1
4Opening liabilityCalculated Lease liability at the start of the period
5InterestCalculated Opening liability × monthly effective interest rate
6PaymentCalculated Rent falling due in the period
7Closing liabilityCalculated Opening + interest − payment
8Current portionCalculated Principal payable in the next 12 months
9StatusCalculated Test, posted or error

Sample result list

Contract no.LessorRight-of-use assetOpening liabilityInterestPaymentClosing liabilityCurrent portionStatus
KS-0012Demo Gayrimenkul Ltd.610000453,184,200100,83385,0003,200,033712,400Posted
KS-0013Örnek Yatırım A.Ş.61000046132,4508284,200129,07846,100Posted
KS-0014Mavi Depo Hizmetleri Ltd.6200001269,8002,32712,00060,12760,127Test
A view built with fictional sample data; not real system data.

How does the program work?

  1. Contracts are uploaded from an Excel template or entered on screen: lessor vendor (LFA1), start and end date, monthly rent, currency, annual increase rate or index, payment day, discount rate (incremental borrowing rate) and asset class.
  2. At commencement, the present value of all future payments is calculated with the discount rate; this amount is the initial lease liability and right-of-use asset. The asset is created with BAPI_FIXEDASSET_CREATE1 with the contract term as useful life and written to ANLA and ANLZ.
  3. The commencement entry is posted with BAPI_ACC_DOCUMENT_POST (debit right-of-use asset, credit lease liability).
  4. The monthly run accrues interest expense using the effective interest method; for rent that falls due, a payable to the vendor is posted and deducted from the liability. The right-of-use asset is depreciated by the standard depreciation run (AFAB).
  5. At period end, the principal payable in the next 12 months is reclassified to the current liability account.
  6. If a contract is extended, the rent changes or it ends early, the remaining payments are recalculated and the liability difference is posted as an adjustment to the asset. The full payment and interest schedule can be displayed per contract.

Performance notes

Contract counts are usually in the hundreds; the monthly run finishes in a few minutes. Remeasurement is only done for contracts that changed.

Features

  • Export to Excel Contracts are uploaded in bulk from an Excel template.
  • Test mode (check without posting)
  • Runs as a background job The monthly run is added to the period-end schedule.
  • Line-by-line result and error log
  • ALV list (sort, filter, subtotals)

Authorization objects

  • A_S_ANLKLAuthorization to create assets by asset class
  • F_BKPF_BUKPosting authorization for the company code

Frequently asked questions

What about short-term and low-value leases?

An exemption flag can be set on the contract. No asset or liability is created for these contracts; rent is expensed directly each month and shown separately in the report.

What happens when rent rises with an index?

The new rent and its effective date are entered on the contract and remeasurement is run. Remaining payments are discounted again with the new amount, and the difference is posted as an adjustment to the right-of-use asset.

Can rent stay as an expense in the statutory ledger?

Yes. With a parallel ledger, IFRS 16 entries are posted to the IFRS ledger group only; in the statutory ledger the rent stays an expense through the vendor invoice.

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: Lease Contracts and IFRS 16 Lease Accounting Program